Query Metrics
12
Database Queries
10
Different statements
8.38 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.01 ms |
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:
[
3
]
|
2 | 0.56 ms |
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:
[
2
]
|
3 | 0.62 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.service_type AS service_type_5, t0.image AS image_6, t0.icone AS icone_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM service t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"autocar"
]
|
4 | 0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM devis_travel_reason t0 WHERE t0.id = ?
Parameters:
[
5
]
|
5 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM devis_luggage t0 WHERE t0.id = ?
Parameters:
[
6
]
|
6 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM devis_budget t0 WHERE t0.id = ?
Parameters:
[
5
]
|
7 | 0.66 ms |
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:
[] |
8 | 0.58 ms |
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:
[] |
9 | 0.65 ms |
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
]
|
10 | 0.56 ms |
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
]
|
11 | 0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
12 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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.