Query Metrics

46 Database Queries
13 Different statements
43.08 ms Query time
0 Invalid entities
39 Managed entities

Queries

Group similar statements

# Time Info
1 3.03 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  9
]
2 4.34 ms
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM business b0_ ORDER BY b0_.created_at DESC LIMIT 10
Parameters:
[]
3 0.97 ms
SELECT b0_.id AS id_0, b0_.number AS number_1, b0_.status AS status_2, b0_.description AS description_3, b0_.period_export AS period_export_4, b0_.only_affiliated_tasks AS only_affiliated_tasks_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.business_manager_id AS business_manager_id_8, b0_.sector_id AS sector_id_9, b0_.client_id AS client_id_10 FROM business b0_ WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC
Parameters:
[
  3213
  3212
  3211
  3210
  3209
  3208
  3207
  3206
  3205
  3204
]
4 1.13 ms
SELECT count(b0_.id) AS sclr_0 FROM business b0_
Parameters:
[]
5 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  24
]
6 1.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.activity_input_method AS activity_input_method_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.agency_id AS agency_id_6 FROM sector t0 WHERE t0.id = ?
Parameters:
[
  5
]
7 1.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone_number AS phone_number_4, t0.siret AS siret_5, t0.ip_address AS ip_address_6, t0.end_of_input AS end_of_input_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.administrator_id AS administrator_id_10, t0.hr_id AS hr_id_11 FROM agency t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 1.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  4313
]
9 1.57 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3213
]
10 2.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3213
]
11 0.57 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  7
]
12 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.activity_input_method AS activity_input_method_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.agency_id AS agency_id_6 FROM sector t0 WHERE t0.id = ?
Parameters:
[
  20
]
13 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone_number AS phone_number_4, t0.siret AS siret_5, t0.ip_address AS ip_address_6, t0.end_of_input AS end_of_input_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.administrator_id AS administrator_id_10, t0.hr_id AS hr_id_11 FROM agency t0 WHERE t0.id = ?
Parameters:
[
  2
]
14 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  4648
]
15 0.77 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3212
]
16 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3212
]
17 0.50 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  13
]
18 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.activity_input_method AS activity_input_method_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.agency_id AS agency_id_6 FROM sector t0 WHERE t0.id = ?
Parameters:
[
  1
]
19 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  2869
]
20 0.79 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3211
]
21 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3211
]
22 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  857
]
23 0.78 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3210
]
24 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3210
]
25 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  2680
]
26 0.69 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3209
]
27 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3209
]
28 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  2796
]
29 0.85 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3208
]
30 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3208
]
31 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  2235
]
32 0.77 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3207
]
33 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3207
]
34 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  3523
]
35 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3206
]
36 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3206
]
37 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  803
]
38 0.87 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3205
]
39 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3205
]
40 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.number AS number_4, t0.city AS city_5, t0.post_code AS post_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9 FROM client t0 WHERE t0.id = ?
Parameters:
[
  397
]
41 0.75 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 INNER JOIN business_user ON t0.id = business_user.user_id WHERE business_user.business_id = ?
Parameters:
[
  3204
]
42 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type_id AS type_id_5, t0.client_id AS client_id_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.name AS name_10, t8.inspection_date AS inspection_date_11, t8.frequency AS frequency_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.machine_id AS machine_id_15, t8.type_id AS type_id_16 FROM machine t0 LEFT JOIN machine_equipment t8 ON t8.machine_id = t0.id INNER JOIN business_machine ON t0.id = business_machine.machine_id WHERE business_machine.business_id = ?
Parameters:
[
  3204
]
43 3.58 ms
SELECT count(a0_.id) AS sclr_0 FROM absence_request a0_ INNER JOIN "user" u1_ ON a0_.owner_id = u1_.id WHERE (u1_.id <> ? AND a0_.accepted IS NULL AND (to_jsonb(u1_.roles) @> ?) = false) AND a0_.request_type IN ('vacation')
Parameters:
[
  9
  "["ROLE_SUPER_ADMIN"]"
]
44 0.68 ms
SELECT count(a0_.id) AS sclr_0 FROM absence_request a0_ INNER JOIN "user" u1_ ON a0_.owner_id = u1_.id WHERE (u1_.id <> ? AND a0_.accepted IS NULL AND (to_jsonb(u1_.roles) @> ?) = false) AND a0_.request_type IN ('rtt')
Parameters:
[
  9
  "["ROLE_SUPER_ADMIN"]"
]
45 0.86 ms
SELECT COUNT(o0_.id) AS sclr_0 FROM overtime o0_ WHERE o0_.owner_id = ? AND o0_.type IS NULL
Parameters:
[
  9
]
46 1.72 ms
SELECT count(r0_.id) AS sclr_0 FROM reception r0_ INNER JOIN "user" u1_ ON r0_.receptionist_id = u1_.id WHERE u1_.id = ? AND r0_.business_id IS NULL
Parameters:
[
  9
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Business 10
App\Entity\Client 10
App\Entity\User 8
App\Entity\Agency 4
App\Entity\Sector 4
App\Entity\Badge 3