Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.percentage_rating AS percentage_rating_1,
  c0_.enabled AS enabled_2,
  c0_.date AS date_3,
  o1_.id AS id_4,
  o1_.phone AS phone_5,
  o1_.user_id AS user_id_6,
  o1_.car AS car_7,
  o1_.date AS date_8,
  o1_.receipt AS receipt_9,
  o1_.status AS status_10,
  o1_.sms AS sms_11,
  o1_.sms_order_end AS sms_order_end_12,
  o1_.sms_order_end_permission AS sms_order_end_permission_13,
  o1_.photo AS photo_14,
  o1_.mileage AS mileage_15,
  o1_.order_type AS order_type_16,
  o1_.client_id AS client_id_17,
  o1_.car_id AS car_id_18,
  o1_.photos AS photos_19,
  o1_.invoice_number AS invoice_number_20,
  o1_.fiscal_receipt_status AS fiscal_receipt_status_21,
  o1_.declaration AS declaration_22,
  o1_.detailing AS detailing_23,
  o1_.complaint AS complaint_24,
  o1_.consultant AS consultant_25,
  o1_.tools AS tools_26,
  o1_.explains AS explains_27,
  o1_.special_verification AS special_verification_28,
  o1_.finished AS finished_29,
  o1_.is_waiting AS is_waiting_30,
  o1_.stop_order AS stop_order_31,
  o1_.dateset AS dateset_32,
  o1_.dateend AS dateend_33,
  o1_.datein AS datein_34,
  o1_.suggested_repair_date AS suggested_repair_date_35,
  o1_.repair_start AS repair_start_36,
  o1_.suggested_repair_date_approval AS suggested_repair_date_approval_37,
  o1_.reservation AS reservation_38,
  c0_.order_number_id AS order_number_id_39,
  o1_.user_id AS user_id_40,
  o1_.consultant AS consultant_41
FROM
  crm_repair_time_accuracy c0_
  INNER JOIN orders o1_ ON c0_.order_number_id = o1_.id
WHERE
  c0_.enabled = 1
  AND (
    c0_.date BETWEEN ?
    AND ?
  )
  AND o1_.consultant = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.percentage_rating AS percentage_rating_1, c0_.enabled AS enabled_2, c0_.date AS date_3, o1_.id AS id_4, o1_.phone AS phone_5, o1_.user_id AS user_id_6, o1_.car AS car_7, o1_.date AS date_8, o1_.receipt AS receipt_9, o1_.status AS status_10, o1_.sms AS sms_11, o1_.sms_order_end AS sms_order_end_12, o1_.sms_order_end_permission AS sms_order_end_permission_13, o1_.photo AS photo_14, o1_.mileage AS mileage_15, o1_.order_type AS order_type_16, o1_.client_id AS client_id_17, o1_.car_id AS car_id_18, o1_.photos AS photos_19, o1_.invoice_number AS invoice_number_20, o1_.fiscal_receipt_status AS fiscal_receipt_status_21, o1_.declaration AS declaration_22, o1_.detailing AS detailing_23, o1_.complaint AS complaint_24, o1_.consultant AS consultant_25, o1_.tools AS tools_26, o1_.explains AS explains_27, o1_.special_verification AS special_verification_28, o1_.finished AS finished_29, o1_.is_waiting AS is_waiting_30, o1_.stop_order AS stop_order_31, o1_.dateset AS dateset_32, o1_.dateend AS dateend_33, o1_.datein AS datein_34, o1_.suggested_repair_date AS suggested_repair_date_35, o1_.repair_start AS repair_start_36, o1_.suggested_repair_date_approval AS suggested_repair_date_approval_37, o1_.reservation AS reservation_38, c0_.order_number_id AS order_number_id_39, o1_.user_id AS user_id_40, o1_.consultant AS consultant_41 FROM crm_repair_time_accuracy c0_ INNER JOIN orders o1_ ON c0_.order_number_id = o1_.id WHERE c0_.enabled = 1 AND (c0_.date BETWEEN '2025-12-01 00:00:00' AND '2025-12-31 23:59:59') AND o1_.consultant = 301 ORDER BY c0_.id ASC;

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_.suggested_repair_date < ?
  AND (
    o0_.status = 2
    OR o0_.status = 9
  )
  AND o0_.consultant = ?

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_.suggested_repair_date < '2025-12-17 11:01:35' AND (o0_.status = 2 OR o0_.status = 9) AND o0_.consultant = 301;

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

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

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  crm_chat_thread c0_
WHERE
  c0_.consultant_id = ?
  AND c0_.status <> ?
  AND (
    (
      c0_.last_read_at_consultant IS NULL
      AND c0_.created_at <> c0_.updated_at
    )
    OR (
      c0_.last_read_at_consultant IS NOT NULL
      AND c0_.updated_at > c0_.last_read_at_consultant
    )
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM crm_chat_thread c0_ WHERE c0_.consultant_id = 301 AND c0_.status <> 'closed' AND ((c0_.last_read_at_consultant IS NULL AND c0_.created_at <> c0_.updated_at) OR (c0_.last_read_at_consultant IS NOT NULL AND c0_.updated_at > c0_.last_read_at_consultant));

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 = 301;