Query Metrics
12
Database Queries
10
Different statements
6.63 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.65 ms (24.81%) |
1 |
SELECT t0.id AS id_1, t0.civility AS civility_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.status AS status_8, t0.latest_login AS latest_login_9, t0.avatar AS avatar_10, t0.credit_balance AS credit_balance_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t14.id AS id_15, t14.siret AS siret_16, t14.entreprise_name AS entreprise_name_17, t14.about_me AS about_me_18, t14.birthday AS birthday_19, t14.birthplace AS birthplace_20, t14.mobile_phone AS mobile_phone_21, t14.landline_phone AS landline_phone_22, t14.address AS address_23, t14.address1 AS address1_24, t14.postal_code AS postal_code_25, t14.city AS city_26, t14.longitude AS longitude_27, t14.latitude AS latitude_28, t14.facebook AS facebook_29, t14.twitter AS twitter_30, t14.instagram AS instagram_31, t14.linkedin AS linkedin_32, t14.agree_terms AS agree_terms_33, t14.user_id AS user_id_34, t35.id AS id_36, t35.about_us AS about_us_37, t35.siret AS siret_38, t35.social_denomination AS social_denomination_39, t35.tva AS tva_40, t35.type_personne AS type_personne_41, t35.other_function AS other_function_42, t35.birthday AS birthday_43, t35.birthplace AS birthplace_44, t35.mobile_phone AS mobile_phone_45, t35.landline_phone AS landline_phone_46, t35.address AS address_47, t35.address1 AS address1_48, t35.postal_code AS postal_code_49, t35.city AS city_50, t35.longitude AS longitude_51, t35.latitude AS latitude_52, t35.cover AS cover_53, t35.confirmation_token AS confirmation_token_54, t35.confirmation_token_created_at AS confirmation_token_created_at_55, t35.expiration_token AS expiration_token_56, t35.agree_terms AS agree_terms_57, t35.user_id AS user_id_58, t35.country_id AS country_id_59, t35.piece_justificative_id AS piece_justificative_id_60, t35.department_id AS department_id_61, t62.id AS id_63, t62.carte_id AS carte_id_64, t62.registration_number AS registration_number_65, t62.carte_vitale AS carte_vitale_66, t62.nationality AS nationality_67, t62.family_situation AS family_situation_68, t62.function_type AS function_type_69, t62.service AS service_70, t62.salaire_brute AS salaire_brute_71, t62.horaires AS horaires_72, t62.hourly_rate AS hourly_rate_73, t62.contract_type AS contract_type_74, t62.employement_start AS employement_start_75, t62.language AS language_76, t62.cover AS cover_77, t62.token AS token_78, t62.confirmation_token AS confirmation_token_79, t62.expiration_token AS expiration_token_80, t62.agree_terms AS agree_terms_81, t62.code AS code_82, t62.user_id AS user_id_83, t62.client_id AS client_id_84, t62.park_id AS park_id_85, t62.fonction_id AS fonction_id_86 FROM user t0 LEFT JOIN client t14 ON t14.user_id = t0.id LEFT JOIN transporteur t35 ON t35.user_id = t0.id LEFT JOIN collaborateur t62 ON t62.user_id = t0.id WHERE t0.id = ?
Parameters:
[
4
]
|
0.93 ms (14.03%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
13
]
|
0.58 ms (8.81%) |
1 |
SELECT t0.id AS id_1, t0.address AS address_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.phone AS phone_5, t0.mail AS mail_6, t0.website AS website_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.linkedin AS linkedin_10, t0.youtube AS youtube_11, t0.instagram AS instagram_12, t0.office AS office_13, t0.description AS description_14, t0.working_hours AS working_hours_15, t0.days_open AS days_open_16, t0.hours_open AS hours_open_17, t0.days_close AS days_close_18, t0.hours_close AS hours_close_19, t0.building AS building_20 FROM contact_page t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
0.56 ms (8.43%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.title1 AS title1_4, t0.content1 AS content1_5, t0.icon1 AS icon1_6, t0.title2 AS title2_7, t0.content2 AS content2_8, t0.icon2 AS icon2_9, t0.title3 AS title3_10, t0.content3 AS content3_11, t0.icon3 AS icon3_12, t0.title4 AS title4_13, t0.content4 AS content4_14, t0.icon4 AS icon4_15, t0.title5 AS title5_16, t0.content5 AS content5_17, t0.icon5 AS icon5_18, t0.title6 AS title6_19, t0.content6 AS content6_20, t0.icon6 AS icon6_21, t0.title7 AS title7_22, t0.content7 AS content7_23, t0.icon7 AS icon7_24 FROM why_choose_us t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
0.54 ms (8.15%) |
1 |
SELECT t0.id AS id_1, t0.carte_id AS carte_id_2, t0.registration_number AS registration_number_3, t0.carte_vitale AS carte_vitale_4, t0.nationality AS nationality_5, t0.family_situation AS family_situation_6, t0.function_type AS function_type_7, t0.service AS service_8, t0.salaire_brute AS salaire_brute_9, t0.horaires AS horaires_10, t0.hourly_rate AS hourly_rate_11, t0.contract_type AS contract_type_12, t0.employement_start AS employement_start_13, t0.language AS language_14, t0.cover AS cover_15, t0.token AS token_16, t0.confirmation_token AS confirmation_token_17, t0.expiration_token AS expiration_token_18, t0.agree_terms AS agree_terms_19, t0.code AS code_20, t0.user_id AS user_id_21, t0.client_id AS client_id_22, t0.park_id AS park_id_23, t0.fonction_id AS fonction_id_24 FROM collaborateur t0 WHERE t0.client_id = ?
Parameters:
[
3
]
|
0.48 ms (7.26%) |
1 |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.service_type AS service_type_4, s0_.image AS image_5, s0_.icone AS icone_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8 FROM service s0_ ORDER BY s0_.id ASC
Parameters:
[] |
0.48 ms (7.23%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.src AS src_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM partner t0 ORDER BY t0.id ASC
Parameters:
[] |
0.48 ms (7.16%) |
1 |
SELECT t0.id AS id_1, t0.background AS background_2, t0.title1 AS title1_3, t0.sub_title1 AS sub_title1_4, t0.title3 AS title3_5, t0.sub_title3 AS sub_title3_6, t0.title4 AS title4_7, t0.sub_title4 AS sub_title4_8, t0.title5 AS title5_9, t0.sub_title5 AS sub_title5_10, t0.title6 AS title6_11, t0.sub_title6 AS sub_title6_12, t0.title7 AS title7_13, t0.sub_title7 AS sub_title7_14, t0.title8 AS title8_15, t0.sub_title8 AS sub_title8_16, t0.title9 AS title9_17, t0.sub_title9 AS sub_title9_18, t0.title10 AS title10_19, t0.sub_title10 AS sub_title10_20, t0.keywords AS keywords_21, t0.description AS description_22 FROM homepage t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.47 ms (7.07%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.status AS status_5, t0.image AS image_6, t0.keywords AS keywords_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM article t0 WHERE t0.status = ? ORDER BY t0.id DESC LIMIT 3
Parameters:
[
1
]
|
0.47 ms (7.04%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.sub_title AS sub_title_4, t0.background AS background_5, t0.title1 AS title1_6, t0.description1 AS description1_7, t0.image1 AS image1_8, t0.video_link1 AS video_link1_9, t0.title2 AS title2_10, t0.sub_title2 AS sub_title2_11, t0.image2 AS image2_12 FROM about_us t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"notre-histoire"
]
|
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.