https://app.dev.my-flow.fr/user/my-flow/directory/page/1

Query Metrics

24 Database Queries
4 Different statements
5.53 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.11 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.domaine_name AS domaine_name_2, c0_.email_project AS email_project_3, c0_.mdp_email_project AS mdp_email_project_4, c0_.marge_my_flow AS marge_my_flow_5, c0_.logo_name AS logo_name_6, c0_.favicon_name AS favicon_name_7, c0_.enabled AS enabled_8, c0_.type_company AS type_company_9, c0_.cb_payment AS cb_payment_10, c0_.contract AS contract_11, c0_.customer_discount AS customer_discount_12, c0_.default_credit_cost AS default_credit_cost_13, c0_.cost_of_discounted_credit AS cost_of_discounted_credit_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.siren AS siren_17, c0_.front_id AS front_id_18, c0_.current_credit AS current_credit_19, c0_.current_balance AS current_balance_20, c0_.deleted AS deleted_21, c0_.link_my_flow_confidentiality_commitment AS link_my_flow_confidentiality_commitment_22, c0_.extension_domain AS extension_domain_23, c0_.parent_id AS parent_id_24, c0_.company_data_id AS company_data_id_25, c0_.representative_id AS representative_id_26 FROM companies c0_ WHERE c0_.domaine_name LIKE ?
Parameters:
[
  "%app.dev.my-flow.fr%"
]
2 0.98 ms
SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.new_add AS new_add_2, u0_.all_company AS all_company_3, u0_.salary AS salary_4, u0_.manager AS manager_5, u0_.partner AS partner_6, u0_.share_my_email AS share_my_email_7, u0_.share_my_phone AS share_my_phone_8, u0_.lastname AS lastname_9, u0_.cell_phone AS cell_phone_10, u0_.enabled AS enabled_11, u0_.external AS external_12, u0_.daily_rate AS daily_rate_13, u0_.resale_rate AS resale_rate_14, u0_.billing_method AS billing_method_15, u0_.picture_name AS picture_name_16, u0_.updated_at AS updated_at_17, u0_.email AS email_18, u0_.original_email AS original_email_19, u0_.roles AS roles_20, u0_.password AS password_21, u0_.created_at AS created_at_22, u0_.last_connection_at AS last_connection_at_23, u0_.account_type AS account_type_24, u0_.notification_type AS notification_type_25, u0_.notification AS notification_26, u0_.freq_notification AS freq_notification_27, u0_.freq_notification_everytime AS freq_notification_everytime_28, u0_.freq_notification_per_day AS freq_notification_per_day_29, u0_.freq_notification_per_week AS freq_notification_per_week_30, u0_.freq_notification_per_month AS freq_notification_per_month_31, u0_.is_active_notification AS is_active_notification_32, u0_.deleted AS deleted_33, u0_.referencing_confirmation_notification AS referencing_confirmation_notification_34, u0_.gender AS gender_35, u0_.device_connected_list AS device_connected_list_36, u0_.invisible AS invisible_37, u0_.last_activity_at AS last_activity_at_38, u0_.is_logged AS is_logged_39, u0_.is_new_client AS is_new_client_40, u0_.autorization_date_at AS autorization_date_at_41, u0_.accept_presentation AS accept_presentation_42, u0_.description AS description_43, u0_.title AS title_44, u0_.one_time_login_token AS one_time_login_token_45, u0_.state AS state_46, u0_.company_id AS company_id_47, u0_.user_data_id AS user_data_id_48, u0_.parent_id AS parent_id_49 FROM users u0_ WHERE u0_.deleted = 0 AND u0_.accept_presentation = 1
Parameters:
[]
3 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "2M6x6zgcZnghxofMHDbJQL"
]
4 0.20 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "2M6x6zgcZnghxofMHDbJQL"
]
5 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "2Z4WB41BSdbGfi7ov35qzk"
]
6 0.28 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "2Z4WB41BSdbGfi7ov35qzk"
]
7 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "3VFwicQU8Wy3b6HubEmHUW"
]
8 0.14 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "3VFwicQU8Wy3b6HubEmHUW"
]
9 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "7XYr3f1phL3p2BDSATX9dz"
]
10 0.17 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "7XYr3f1phL3p2BDSATX9dz"
]
11 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "9DxMygjtYxYHrrP1JHyfm6"
]
12 0.15 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "9DxMygjtYxYHrrP1JHyfm6"
]
13 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "DoZevioyaTc9KVhz4ja4qF"
]
14 0.14 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "DoZevioyaTc9KVhz4ja4qF"
]
15 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "JYdF3GEZPr9LDF6DaksAjY"
]
16 0.10 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "JYdF3GEZPr9LDF6DaksAjY"
]
17 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "KikS3jauVoaoizwt9Ysk4W"
]
18 0.09 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "KikS3jauVoaoizwt9Ysk4W"
]
19 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "QExvAQcUyXXdQ2SU5TrNeC"
]
20 0.08 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "QExvAQcUyXXdQ2SU5TrNeC"
]
21 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "TKhMbdidGdsZb18rPj8xkF"
]
22 0.10 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "TKhMbdidGdsZb18rPj8xkF"
]
23 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.agency_id AS agency_id_5 FROM jobs t0 INNER JOIN job_user ON t0.id = job_user.job_id WHERE job_user.user_id = ?
Parameters:
[
  "V3Q353BM9e4eDg3wazcxhT"
]
24 0.09 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.client AS client_3, t0.file_type AS file_type_4, t0.file_url AS file_url_5, t0.thumbnail AS thumbnail_6, t0.title AS title_7, t0.keywords AS keywords_8, t0.file_category AS file_category_9, t0.user_id AS user_id_10 FROM portfolio t0 WHERE t0.user_id = ?
Parameters:
[
  "V3Q353BM9e4eDg3wazcxhT"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Message No errors.
App\Entity\Company No errors.
App\Entity\Campaign No errors.
App\Entity\User No errors.
App\Entity\Mission No errors.
App\Entity\MissionParticipant No errors.
App\Entity\WorkflowStep No errors.
App\Entity\CreditHistory No errors.
App\Entity\CommandeLogging No errors.
App\Entity\NotificationToSend No errors.
App\Entity\ConfidentialityContract No errors.
App\Entity\CampaignPendingToSend No errors.
App\Entity\SystemEmail No errors.
App\Entity\BalanceTransactions No errors.
App\Entity\Service No errors.
App\Entity\Historique No errors.
App\Entity\SubContractorCompany No errors.
App\Entity\Job No errors.
App\Entity\CompanyData No errors.
App\Entity\Portfolio No errors.
App\Entity\UserData No errors.
App\Entity\FileMission No errors.
App\Entity\WorkflowAction No errors.
App\Entity\InfoMission No errors.
App\Entity\Device No errors.
App\Entity\MessageReaction No errors.
App\Entity\Emoji No errors.
App\Entity\Support No errors.
App\Entity\SignedContract No errors.
App\Entity\Product No errors.