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 = ?
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 = 9 ;
Copy
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
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 ;
Copy
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
]
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 (3213 , 3212 , 3211 , 3210 , 3209 , 3208 , 3207 , 3206 , 3205 , 3204 ) ORDER BY b0_ . created_at DESC ;
Copy
4
1.13 ms
SELECT count (b0_ . id ) AS sclr_0 FROM business b0_
SELECT count (b0_ . id ) AS sclr_0 FROM business b0_ ;
Copy
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 = ?
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 = 24 ;
Copy
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 = ?
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 = 5 ;
Copy
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 = ?
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 = 1 ;
Copy
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 = ?
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 = 4313 ;
Copy
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 = ?
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 = 3213 ;
Copy
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 = ?
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 = 3213 ;
Copy
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 = ?
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 = 7 ;
Copy
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 = ?
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 = 20 ;
Copy
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 = ?
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 = 2 ;
Copy
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 = ?
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 = 4648 ;
Copy
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 = ?
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 = 3212 ;
Copy
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 = ?
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 = 3212 ;
Copy
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 = ?
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 = 13 ;
Copy
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 = ?
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 = 1 ;
Copy
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 = ?
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 = 2869 ;
Copy
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 = ?
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 = 3211 ;
Copy
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 = ?
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 = 3211 ;
Copy
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 = ?
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 = 857 ;
Copy
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 = ?
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 = 3210 ;
Copy
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 = ?
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 = 3210 ;
Copy
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 = ?
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 = 2680 ;
Copy
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 = ?
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 = 3209 ;
Copy
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 = ?
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 = 3209 ;
Copy
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 = ?
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 = 2796 ;
Copy
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 = ?
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 = 3208 ;
Copy
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 = ?
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 = 3208 ;
Copy
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 = ?
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 = 2235 ;
Copy
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 = ?
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 = 3207 ;
Copy
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 = ?
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 = 3207 ;
Copy
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 = ?
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 = 3523 ;
Copy
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 = ?
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 = 3206 ;
Copy
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 = ?
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 = 3206 ;
Copy
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 = ?
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 = 803 ;
Copy
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 = ?
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 = 3205 ;
Copy
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 = ?
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 = 3205 ;
Copy
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 = ?
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 = 397 ;
Copy
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 = ?
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 = 3204 ;
Copy
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 = ?
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 = 3204 ;
Copy
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"] "
]
SELECT count (a0_ . id ) AS sclr_0 FROM absence_request a0_ INNER JOIN "user" u1_ ON a0_ . owner_id = u1_ . id WHERE (u1_ . id < > 9 AND a0_ . accepted IS NULL AND (to_jsonb (u1_ . roles ) @ > '[\"ROLE_SUPER_ADMIN\"]' ) = false ) AND a0_ . request_type IN ('vacation' );
Copy
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"] "
]
SELECT count (a0_ . id ) AS sclr_0 FROM absence_request a0_ INNER JOIN "user" u1_ ON a0_ . owner_id = u1_ . id WHERE (u1_ . id < > 9 AND a0_ . accepted IS NULL AND (to_jsonb (u1_ . roles ) @ > '[\"ROLE_SUPER_ADMIN\"]' ) = false ) AND a0_ . request_type IN ('rtt' );
Copy
45
0.86 ms
SELECT COUNT (o0_ . id ) AS sclr_0 FROM overtime o0_ WHERE o0_ . owner_id = ? AND o0_ . type IS NULL
SELECT COUNT (o0_ . id ) AS sclr_0 FROM overtime o0_ WHERE o0_ . owner_id = 9 AND o0_ . type IS NULL ;
Copy
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
SELECT count (r0_ . id ) AS sclr_0 FROM reception r0_ INNER JOIN "user" u1_ ON r0_ . receptionist_id = u1_ . id WHERE u1_ . id = 9 AND r0_ . business_id IS NULL ;
Copy