Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.department AS department_3,
  t0.enabled AS enabled_4,
  t0.schedule_panel AS schedule_panel_5,
  t0.color AS color_6
FROM
  crm_departments t0
WHERE
  t0.schedule_panel = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.enabled AS enabled_4, t0.schedule_panel AS schedule_panel_5, t0.color AS color_6 FROM crm_departments t0 WHERE t0.schedule_panel = '1';

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?, ?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 2 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (1, 2) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 2 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (3) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_users c0_
  LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id
WHERE
  c1_.id = ?
  AND c0_.enabled = 1
  AND c0_.id <> 67

SELECT count(c0_.id) AS sclr_0 FROM crm_users c0_ LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id WHERE c1_.id = 2 AND c0_.enabled = 1 AND c0_.id <> 67;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?, ?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 3 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (1, 2) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 3 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (3) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_users c0_
  LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id
WHERE
  c1_.id = ?
  AND c0_.enabled = 1
  AND c0_.id <> 67

SELECT count(c0_.id) AS sclr_0 FROM crm_users c0_ LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id WHERE c1_.id = 3 AND c0_.enabled = 1 AND c0_.id <> 67;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?, ?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 6 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (1, 2) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 6 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (3) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_users c0_
  LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id
WHERE
  c1_.id = ?
  AND c0_.enabled = 1
  AND c0_.id <> 67

SELECT count(c0_.id) AS sclr_0 FROM crm_users c0_ LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id WHERE c1_.id = 6 AND c0_.enabled = 1 AND c0_.id <> 67;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?, ?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 7 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (1, 2) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 7 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (3) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_users c0_
  LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id
WHERE
  c1_.id = ?
  AND c0_.enabled = 1
  AND c0_.id <> 67

SELECT count(c0_.id) AS sclr_0 FROM crm_users c0_ LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id WHERE c1_.id = 7 AND c0_.enabled = 1 AND c0_.id <> 67;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?, ?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 8 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (1, 2) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 8 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (3) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_users c0_
  LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id
WHERE
  c1_.id = ?
  AND c0_.enabled = 1
  AND c0_.id <> 67

SELECT count(c0_.id) AS sclr_0 FROM crm_users c0_ LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id WHERE c1_.id = 8 AND c0_.enabled = 1 AND c0_.id <> 67;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?, ?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 9 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (1, 2) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_schedule_history c0_
  LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id
WHERE
  c1_.department_id = ?
  AND c0_.type = 1
  AND c0_.session = 1
  AND c0_.status IN (?)
  AND c0_.date > ?
  AND c0_.date < ?
ORDER BY
  c0_.id DESC

SELECT count(c0_.id) AS sclr_0 FROM crm_schedule_history c0_ LEFT JOIN crm_users c1_ ON c0_.user_id = c1_.id WHERE c1_.department_id = 9 AND c0_.type = 1 AND c0_.session = 1 AND c0_.status IN (3) AND c0_.date > '2025-12-14 00:00:00' AND c0_.date < '2025-12-14 23:59:59' ORDER BY c0_.id DESC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  crm_users c0_
  LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id
WHERE
  c1_.id = ?
  AND c0_.enabled = 1
  AND c0_.id <> 67

SELECT count(c0_.id) AS sclr_0 FROM crm_users c0_ LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id WHERE c1_.id = 9 AND c0_.enabled = 1 AND c0_.id <> 67;