Symfony Profiler

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) = 'Grzegorz Dorynek';

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 <= '2026-01-10 23:59:59' AND COALESCE(o0_.dateend, '2099-12-31 23:59:59') >= '2026-01-10 00:00:00') OR ((o0_.status IN (1, 2, 9)) AND o0_.repair_start <= '2026-01-10 23:59:59') OR ((o0_.status IN (5, 8)) AND (o0_.date <= '2026-01-10 23:59:59') AND (o0_.suggested_repair_date BETWEEN '2026-01-10 00:00:00' AND '2026-01-10 23:59:59' OR o0_.suggested_repair_date > '2026-01-10 23:59:59'))));

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

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;

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 = '2026-01-10 00:00:00' AND c0_.user_id IN (32, 42, 54, 65, 70, 96, 99, 120, 134, 149, 152, 156, 157, 166, 167, 172, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 195, 196, 198, 199, 200, 201, 202, 203, 205, 208, 209, 212, 213, 214, 216, 217, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 238, 239, 242, 243, 245, 246, 247, 248, 251, 253, 254, 255, 256, 259, 260, 261, 263, 264, 265, 268, 269, 271, 272, 273, 274, 275, 276, 277, 278, 279, 281, 283, 286, 287, 288, 289, 295, 296, 297, 298, 299, 303);

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 = '2026-01-10 00:00:00' AND c0_.user_id IN (32, 42, 54, 65, 70, 96, 99, 120, 134, 149, 152, 156, 157, 166, 167, 172, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 195, 196, 198, 199, 200, 201, 202, 203, 205, 208, 209, 212, 213, 214, 216, 217, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 238, 239, 242, 243, 245, 246, 247, 248, 251, 253, 254, 255, 256, 259, 260, 261, 263, 264, 265, 268, 269, 271, 272, 273, 274, 275, 276, 277, 278, 279, 281, 283, 286, 287, 288, 289, 295, 296, 297, 298, 299, 303);

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
  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 >= '2026-01-10 00:00:00' AND o0_.date <= '2026-01-10 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 = '2026-01-10' AND t0.enabled = 1 LIMIT 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;