Symfony Profiler

SELECT
  o0_.id AS id_0,
  o0_.phone AS phone_1,
  o0_.user_id AS user_id_2,
  o0_.car AS car_3,
  o0_.date AS date_4,
  o0_.receipt AS receipt_5,
  o0_.status AS status_6,
  o0_.sms AS sms_7,
  o0_.sms_order_end AS sms_order_end_8,
  o0_.sms_order_end_permission AS sms_order_end_permission_9,
  o0_.photo AS photo_10,
  o0_.mileage AS mileage_11,
  o0_.order_type AS order_type_12,
  o0_.client_id AS client_id_13,
  o0_.car_id AS car_id_14,
  o0_.photos AS photos_15,
  o0_.invoice_number AS invoice_number_16,
  o0_.fiscal_receipt_status AS fiscal_receipt_status_17,
  o0_.declaration AS declaration_18,
  o0_.detailing AS detailing_19,
  o0_.complaint AS complaint_20,
  o0_.consultant AS consultant_21,
  o0_.tools AS tools_22,
  o0_.explains AS explains_23,
  o0_.special_verification AS special_verification_24,
  o0_.finished AS finished_25,
  o0_.is_waiting AS is_waiting_26,
  o0_.stop_order AS stop_order_27,
  o0_.dateset AS dateset_28,
  o0_.dateend AS dateend_29,
  o0_.datein AS datein_30,
  o0_.suggested_repair_date AS suggested_repair_date_31,
  o0_.repair_start AS repair_start_32,
  o0_.suggested_repair_date_approval AS suggested_repair_date_approval_33,
  o0_.reservation AS reservation_34,
  o0_.user_id AS user_id_35,
  o0_.consultant AS consultant_36
FROM
  orders o0_
WHERE
  o0_.user_id <> 67
  AND (
    o0_.status IN (1, 2, 4, 5, 8, 9)
  )
  AND (
    (
      (
        (
          o0_.status IN (4)
        )
        AND o0_.repair_start <= ?
        AND COALESCE(o0_.dateend, ?) >= ?
      )
      OR (
        (
          o0_.status IN (1, 2, 9)
        )
        AND o0_.repair_start <= ?
      )
      OR (
        (
          o0_.status IN (5, 8)
        )
        AND (o0_.date <= ?)
        AND (
          o0_.suggested_repair_date BETWEEN ?
          AND ?
          OR o0_.suggested_repair_date > ?
        )
      )
    )
  )

SELECT o0_.id AS id_0, o0_.phone AS phone_1, o0_.user_id AS user_id_2, o0_.car AS car_3, o0_.date AS date_4, o0_.receipt AS receipt_5, o0_.status AS status_6, o0_.sms AS sms_7, o0_.sms_order_end AS sms_order_end_8, o0_.sms_order_end_permission AS sms_order_end_permission_9, o0_.photo AS photo_10, o0_.mileage AS mileage_11, o0_.order_type AS order_type_12, o0_.client_id AS client_id_13, o0_.car_id AS car_id_14, o0_.photos AS photos_15, o0_.invoice_number AS invoice_number_16, o0_.fiscal_receipt_status AS fiscal_receipt_status_17, o0_.declaration AS declaration_18, o0_.detailing AS detailing_19, o0_.complaint AS complaint_20, o0_.consultant AS consultant_21, o0_.tools AS tools_22, o0_.explains AS explains_23, o0_.special_verification AS special_verification_24, o0_.finished AS finished_25, o0_.is_waiting AS is_waiting_26, o0_.stop_order AS stop_order_27, o0_.dateset AS dateset_28, o0_.dateend AS dateend_29, o0_.datein AS datein_30, o0_.suggested_repair_date AS suggested_repair_date_31, o0_.repair_start AS repair_start_32, o0_.suggested_repair_date_approval AS suggested_repair_date_approval_33, o0_.reservation AS reservation_34, o0_.user_id AS user_id_35, o0_.consultant AS consultant_36 FROM orders o0_ WHERE o0_.user_id <> 67 AND (o0_.status IN (1, 2, 4, 5, 8, 9)) AND ((((o0_.status IN (4)) AND o0_.repair_start <= '2025-12-20 23:59:59' AND COALESCE(o0_.dateend, '2099-12-31 23:59:59') >= '2025-12-20 00:00:00') OR ((o0_.status IN (1, 2, 9)) AND o0_.repair_start <= '2025-12-20 23:59:59') OR ((o0_.status IN (5, 8)) AND (o0_.date <= '2025-12-20 23:59:59') AND (o0_.suggested_repair_date BETWEEN '2025-12-20 00:00:00' AND '2025-12-20 23:59:59' OR o0_.suggested_repair_date > '2025-12-20 23:59:59'))));

SELECT
  c0_.id AS id_0
FROM
  crm_users c0_
WHERE
  CONCAT(c0_.firstname, ' ', c0_.lastname) = ?

SELECT c0_.id AS id_0 FROM crm_users c0_ WHERE CONCAT(c0_.firstname, ' ', c0_.lastname) = 'Rafał Kiedrzyn';

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.type AS type_2,
  c0_.start_at AS start_at_3,
  c0_.end_at AS end_at_4,
  c0_.minutes AS minutes_5,
  c0_.note AS note_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8,
  c0_.plan_id AS plan_id_9,
  c0_.user_id AS user_id_10,
  c0_.created_by_id AS created_by_id_11,
  c0_.updated_by_id AS updated_by_id_12
FROM
  crm_shift_assignment c0_
WHERE
  c0_.date = ?
  AND c0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.type AS type_2, c0_.start_at AS start_at_3, c0_.end_at AS end_at_4, c0_.minutes AS minutes_5, c0_.note AS note_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c0_.plan_id AS plan_id_9, c0_.user_id AS user_id_10, c0_.created_by_id AS created_by_id_11, c0_.updated_by_id AS updated_by_id_12 FROM crm_shift_assignment c0_ WHERE c0_.date = '2025-12-20 00:00:00' AND c0_.user_id IN (65, 96, 191, 226, 234, 271, 281, 288, 295, 297, 299);

SELECT
  c0_.id AS id_0,
  c0_.phone AS phone_1,
  c0_.roles AS roles_2,
  c0_.password AS password_3,
  c0_.firstname AS firstname_4,
  c0_.lastname AS lastname_5,
  c0_.email AS email_6,
  c0_.enabled AS enabled_7,
  c0_.company_phone AS company_phone_8,
  c0_.last_login AS last_login_9,
  c0_.last_password_change AS last_password_change_10,
  c0_.daily_access_code AS daily_access_code_11,
  c0_.department_id AS department_id_12,
  c0_.payment_rule_id AS payment_rule_id_13
FROM
  crm_users c0_
  LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id
WHERE
  c1_.id IN (3, 10, 11)
  AND c0_.id <> 67
  AND c0_.enabled = 1

SELECT c0_.id AS id_0, c0_.phone AS phone_1, c0_.roles AS roles_2, c0_.password AS password_3, c0_.firstname AS firstname_4, c0_.lastname AS lastname_5, c0_.email AS email_6, c0_.enabled AS enabled_7, c0_.company_phone AS company_phone_8, c0_.last_login AS last_login_9, c0_.last_password_change AS last_password_change_10, c0_.daily_access_code AS daily_access_code_11, c0_.department_id AS department_id_12, c0_.payment_rule_id AS payment_rule_id_13 FROM crm_users c0_ LEFT JOIN crm_departments c1_ ON c0_.department_id = c1_.id WHERE c1_.id IN (3, 10, 11) AND c0_.id <> 67 AND c0_.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.enabled AS enabled_8,
  t0.company_phone AS company_phone_9,
  t0.last_login AS last_login_10,
  t0.last_password_change AS last_password_change_11,
  t0.daily_access_code AS daily_access_code_12,
  t0.department_id AS department_id_13,
  t0.payment_rule_id AS payment_rule_id_14
FROM
  crm_users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.enabled AS enabled_8, t0.company_phone AS company_phone_9, t0.last_login AS last_login_10, t0.last_password_change AS last_password_change_11, t0.daily_access_code AS daily_access_code_12, t0.department_id AS department_id_13, t0.payment_rule_id AS payment_rule_id_14 FROM crm_users t0 WHERE t0.id = 2;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  orders o0_
WHERE
  (
    o0_.status = 1
    OR o0_.status = 2
    OR o0_.status = 9
  )
  AND o0_.consultant IS NULL

SELECT COUNT(o0_.id) AS sclr_0 FROM orders o0_ WHERE (o0_.status = 1 OR o0_.status = 2 OR o0_.status = 9) AND o0_.consultant IS NULL;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_at AS start_at_2,
  c0_.end_at AS end_at_3,
  c0_.reason AS reason_4,
  c0_.created_at AS created_at_5,
  c0_.plan_id AS plan_id_6,
  c0_.user_id AS user_id_7,
  c0_.created_by_id AS created_by_id_8
FROM
  crm_mechanic_block c0_
WHERE
  c0_.date = ?
  AND c0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_at AS start_at_2, c0_.end_at AS end_at_3, c0_.reason AS reason_4, c0_.created_at AS created_at_5, c0_.plan_id AS plan_id_6, c0_.user_id AS user_id_7, c0_.created_by_id AS created_by_id_8 FROM crm_mechanic_block c0_ WHERE c0_.date = '2025-12-20 00:00:00' AND c0_.user_id IN (65, 96, 191, 226, 234, 271, 281, 288, 295, 297, 299);

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  orders o0_
WHERE
  o0_.date >= ?
  AND o0_.date <= ?
  AND o0_.status = 8

SELECT COUNT(o0_.id) AS sclr_0 FROM orders o0_ WHERE o0_.date >= '2025-12-20 00:00:00' AND o0_.date <= '2025-12-20 23:59:59' AND o0_.status = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date AS date_3,
  t0.enabled AS enabled_4
FROM
  crm_non_working_days t0
WHERE
  t0.date = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.enabled AS enabled_4 FROM crm_non_working_days t0 WHERE t0.date = '2025-12-20' AND t0.enabled = 1 LIMIT 1;