Symfony Profiler

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;

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;

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;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.created_at AS created_at_1
FROM
  business b0_
WHERE
  LOWER(b0_.number || '') LIKE ?
  OR LOWER(b0_.status || '') LIKE ?
  OR LOWER(b0_.description || '') LIKE ?
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_ WHERE LOWER(b0_.number || '') LIKE '%absences%' OR LOWER(b0_.status || '') LIKE '%absences%' OR LOWER(b0_.description || '') LIKE '%absences%' ORDER BY b0_.created_at DESC LIMIT 10;

SELECT
  count(b0_.id) AS sclr_0
FROM
  business b0_
WHERE
  LOWER(b0_.number || '') LIKE ?
  OR LOWER(b0_.status || '') LIKE ?
  OR LOWER(b0_.description || '') LIKE ?

SELECT count(b0_.id) AS sclr_0 FROM business b0_ WHERE LOWER(b0_.number || '') LIKE '%absences%' OR LOWER(b0_.status || '') LIKE '%absences%' OR LOWER(b0_.description || '') LIKE '%absences%';

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;

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')

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');

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;

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;

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;

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
  (
    LOWER(b0_.number || '') LIKE ?
    OR LOWER(b0_.status || '') LIKE ?
    OR LOWER(b0_.description || '') LIKE ?
  )
  AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.created_at DESC

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 (LOWER(b0_.number || '') LIKE '%absences%' OR LOWER(b0_.status || '') LIKE '%absences%' OR LOWER(b0_.description || '') LIKE '%absences%') AND b0_.id IN (3212, 940, 939, 938, 937, 936, 935, 934, 933, 932) ORDER BY b0_.created_at DESC;

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;

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')

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');