Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

29.38 ms Query time

0 Invalid entities

2 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

10.63 ms
(36.18%)

SELECT DISTINCT id_1, MIN(sclr_120) AS dctrn_minrownum FROM (SELECT (CASE WHEN ((c0_.morning_start IS NOT NULL AND c0_.morning_end IS NOT NULL AND ? BETWEEN c0_.morning_start AND c0_.morning_end) OR (c0_.morning_start IS NULL AND c0_.morning_end IS NOT NULL AND ? <= c0_.morning_end) OR (c0_.morning_start IS NOT NULL AND c0_.morning_end IS NULL AND ? >= c0_.morning_start)) OR ((c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NOT NULL AND ? BETWEEN c0_.afternoon_start AND c0_.afternoon_end) OR (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NOT NULL AND ? <= c0_.afternoon_end) OR (c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NULL AND ? >= c0_.afternoon_start)) OR ((c0_.morning_start IS NULL AND c0_.morning_end IS NULL) AND (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NULL)) THEN true ELSE false END) AS sclr_0, t1_.id AS id_1, t1_.created_at AS created_at_2, t1_.title AS title_3, t1_.description AS description_4, t1_.priority AS priority_5, t1_.status AS status_6, t1_.type AS type_7, t1_.updated_at AS updated_at_8, t1_.alert AS alert_9, t1_.joint_file AS joint_file_10, t1_.category AS category_11, t1_.is_automatic AS is_automatic_12, t1_.anomaly_status_responsable AS anomaly_status_responsable_13, t1_.result AS result_14, t1_.summer AS summer_15, t1_.quiz AS quiz_16, t1_.date_attribution AS date_attribution_17, t1_.estimation_huissier AS estimation_huissier_18, t1_.estimation_assignation AS estimation_assignation_19, t1_.estimation_avocat AS estimation_avocat_20, t1_.comment AS comment_21, f2_.id AS id_22, f2_.registration AS registration_23, f2_.registration_normalized AS registration_normalized_24, f2_.vehicle_model AS vehicle_model_25, f2_.insurance_name AS insurance_name_26, f2_.appointment AS appointment_27, f2_.appointment_end AS appointment_end_28, f2_.status AS status_29, f2_.windscreen AS windscreen_30, f2_.insurance_card AS insurance_card_31, f2_.vehicle_card AS vehicle_card_32, f2_.created_at AS created_at_33, f2_.professional AS professional_34, f2_.tva_subject AS tva_subject_35, f2_.sensor AS sensor_36, f2_.athermal AS athermal_37, f2_.camera AS camera_38, f2_.glass AS glass_39, f2_.sinister_date AS sinister_date_40, f2_.declare_date AS declare_date_41, f2_.sinister_reason AS sinister_reason_42, f2_.sinister_circ AS sinister_circ_43, f2_.sinister_location AS sinister_location_44, f2_.travel_reason AS travel_reason_45, f2_.invoice_due AS invoice_due_46, f2_.deductible_amount AS deductible_amount_47, f2_.verified_deductible AS verified_deductible_48, f2_.insurance_number AS insurance_number_49, f2_.cca AS cca_50, f2_.procedure AS procedure_51, f2_.signed AS signed_52, f2_.signed_date AS signed_date_53, f2_.file AS file_54, f2_.known_by AS known_by_55, f2_.gift AS gift_56, f2_.adresse_pose AS adresse_pose_57, f2_.task AS task_58, f2_.updated_at AS updated_at_59, f2_.relance_at AS relance_at_60, f2_.is_paid AS is_paid_61, f2_.sinister_number AS sinister_number_62, f2_.is_assured AS is_assured_63, f2_.is_send_folder AS is_send_folder_64, f2_.is_send_invoice AS is_send_invoice_65, f2_.cancellation_reason AS cancellation_reason_66, f2_.cover AS cover_67, f2_.status_command AS status_command_68, f2_.ref AS ref_69, f2_.ref_client AS ref_client_70, f2_.km AS km_71, f2_.member_client AS member_client_72, f2_.member_garage AS member_garage_73, f2_.is_gift_send AS is_gift_send_74, f2_.status_updated AS status_updated_75, f2_.pattern_cover AS pattern_cover_76, f2_.judicial AS judicial_77, f2_.relance_updated_at AS relance_updated_at_78, f2_.relance_created_at AS relance_created_at_79, f2_.relance_after_at AS relance_after_at_80, f2_.sms_balance AS sms_balance_81, f2_.brand AS brand_82, f2_.mine_type AS mine_type_83, f2_.serial_number AS serial_number_84, f2_.wan_code AS wan_code_85, f2_.audatex_code AS audatex_code_86, f2_.euro_code AS euro_code_87, f2_.vin_identified AS vin_identified_88, f2_.sidexa_state AS sidexa_state_89, f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90, f2_.data_updated AS data_updated_91, f2_.category AS category_92, f2_.department AS department_93, f2_.complexity AS complexity_94, f2_.repar AS repar_95, f2_.marge AS marge_96, f2_.appointment_update_reason AS appointment_update_reason_97, f2_.closing_date AS closing_date_98, f2_.planif_date AS planif_date_99, f2_.gap AS gap_100, f2_.offset_pose AS offset_pose_101, f2_.duplicate AS duplicate_102, f2_.couriers_parent_number AS couriers_parent_number_103, f2_.state AS state_104, f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105, f2_.prime_date AS prime_date_106, f2_.insurance_card_added_at AS insurance_card_added_at_107, f2_.vehicle_card_added_at AS vehicle_card_added_at_108, f2_.windscreen_added_at AS windscreen_added_at_109, f2_.last_agent_update_at AS last_agent_update_at_110, f2_.openai_thread_id AS openai_thread_id_111, f2_.vehicle_description AS vehicle_description_112, f2_.has_partial_payment AS has_partial_payment_113, f2_.paid_gap_amount AS paid_gap_amount_114, f2_.gap_declarate_date AS gap_declarate_date_115, f2_.hubspot_id AS hubspot_id_116, f2_.ht_repair_order AS ht_repair_order_117, f2_.task_verif_closed_date AS task_verif_closed_date_118, f2_.first_signature_date AS first_signature_date_119, ROW_NUMBER() OVER(ORDER BY f2_.appointment ASC) AS sclr_120 FROM task t1_ INNER JOIN folder f2_ ON t1_.folder_id = f2_.id INNER JOIN companie c3_ ON f2_.companie_id = c3_.id INNER JOIN customer c4_ ON f2_.customer_id = c4_.id LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id INNER JOIN franchise f8_ ON c3_.franchise_id = f8_.id WHERE t1_.status = 'cancel' AND a7_.id = ? AND f8_.is_gold = true AND t1_.category = 0) dctrn_result GROUP BY id_1 ORDER BY dctrn_minrownum ASC LIMIT 25

Parameters:

[
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  640
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_1,
  MIN(sclr_120) AS dctrn_minrownum
FROM
  (
    SELECT
      (
        CASE WHEN (
          (
            c0_.morning_start IS NOT NULL
            AND c0_.morning_end IS NOT NULL
            AND ? BETWEEN c0_.morning_start
            AND c0_.morning_end
          )
          OR (
            c0_.morning_start IS NULL
            AND c0_.morning_end IS NOT NULL
            AND ? <= c0_.morning_end
          )
          OR (
            c0_.morning_start IS NOT NULL
            AND c0_.morning_end IS NULL
            AND ? >= c0_.morning_start
          )
        )
        OR (
          (
            c0_.afternoon_start IS NOT NULL
            AND c0_.afternoon_end IS NOT NULL
            AND ? BETWEEN c0_.afternoon_start
            AND c0_.afternoon_end
          )
          OR (
            c0_.afternoon_start IS NULL
            AND c0_.afternoon_end IS NOT NULL
            AND ? <= c0_.afternoon_end
          )
          OR (
            c0_.afternoon_start IS NOT NULL
            AND c0_.afternoon_end IS NULL
            AND ? >= c0_.afternoon_start
          )
        )
        OR (
          (
            c0_.morning_start IS NULL
            AND c0_.morning_end IS NULL
          )
          AND (
            c0_.afternoon_start IS NULL
            AND c0_.afternoon_end IS NULL
          )
        ) THEN
          true
        ELSE
          false
        END
      ) AS sclr_0,
      t1_.id AS id_1,
      t1_.created_at AS created_at_2,
      t1_.title AS title_3,
      t1_.description AS description_4,
      t1_.priority AS priority_5,
      t1_.status AS status_6,
      t1_.type AS type_7,
      t1_.updated_at AS updated_at_8,
      t1_.alert AS alert_9,
      t1_.joint_file AS joint_file_10,
      t1_.category AS category_11,
      t1_.is_automatic AS is_automatic_12,
      t1_.anomaly_status_responsable AS anomaly_status_responsable_13,
      t1_.result AS result_14,
      t1_.summer AS summer_15,
      t1_.quiz AS quiz_16,
      t1_.date_attribution AS date_attribution_17,
      t1_.estimation_huissier AS estimation_huissier_18,
      t1_.estimation_assignation AS estimation_assignation_19,
      t1_.estimation_avocat AS estimation_avocat_20,
      t1_.comment AS comment_21,
      f2_.id AS id_22,
      f2_.registration AS registration_23,
      f2_.registration_normalized AS registration_normalized_24,
      f2_.vehicle_model AS vehicle_model_25,
      f2_.insurance_name AS insurance_name_26,
      f2_.appointment AS appointment_27,
      f2_.appointment_end AS appointment_end_28,
      f2_.status AS status_29,
      f2_.windscreen AS windscreen_30,
      f2_.insurance_card AS insurance_card_31,
      f2_.vehicle_card AS vehicle_card_32,
      f2_.created_at AS created_at_33,
      f2_.professional AS professional_34,
      f2_.tva_subject AS tva_subject_35,
      f2_.sensor AS sensor_36,
      f2_.athermal AS athermal_37,
      f2_.camera AS camera_38,
      f2_.glass AS glass_39,
      f2_.sinister_date AS sinister_date_40,
      f2_.declare_date AS declare_date_41,
      f2_.sinister_reason AS sinister_reason_42,
      f2_.sinister_circ AS sinister_circ_43,
      f2_.sinister_location AS sinister_location_44,
      f2_.travel_reason AS travel_reason_45,
      f2_.invoice_due AS invoice_due_46,
      f2_.deductible_amount AS deductible_amount_47,
      f2_.verified_deductible AS verified_deductible_48,
      f2_.insurance_number AS insurance_number_49,
      f2_.cca AS cca_50,
      f2_.procedure AS procedure_51,
      f2_.signed AS signed_52,
      f2_.signed_date AS signed_date_53,
      f2_.file AS file_54,
      f2_.known_by AS known_by_55,
      f2_.gift AS gift_56,
      f2_.adresse_pose AS adresse_pose_57,
      f2_.task AS task_58,
      f2_.updated_at AS updated_at_59,
      f2_.relance_at AS relance_at_60,
      f2_.is_paid AS is_paid_61,
      f2_.sinister_number AS sinister_number_62,
      f2_.is_assured AS is_assured_63,
      f2_.is_send_folder AS is_send_folder_64,
      f2_.is_send_invoice AS is_send_invoice_65,
      f2_.cancellation_reason AS cancellation_reason_66,
      f2_.cover AS cover_67,
      f2_.status_command AS status_command_68,
      f2_.ref AS ref_69,
      f2_.ref_client AS ref_client_70,
      f2_.km AS km_71,
      f2_.member_client AS member_client_72,
      f2_.member_garage AS member_garage_73,
      f2_.is_gift_send AS is_gift_send_74,
      f2_.status_updated AS status_updated_75,
      f2_.pattern_cover AS pattern_cover_76,
      f2_.judicial AS judicial_77,
      f2_.relance_updated_at AS relance_updated_at_78,
      f2_.relance_created_at AS relance_created_at_79,
      f2_.relance_after_at AS relance_after_at_80,
      f2_.sms_balance AS sms_balance_81,
      f2_.brand AS brand_82,
      f2_.mine_type AS mine_type_83,
      f2_.serial_number AS serial_number_84,
      f2_.wan_code AS wan_code_85,
      f2_.audatex_code AS audatex_code_86,
      f2_.euro_code AS euro_code_87,
      f2_.vin_identified AS vin_identified_88,
      f2_.sidexa_state AS sidexa_state_89,
      f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90,
      f2_.data_updated AS data_updated_91,
      f2_.category AS category_92,
      f2_.department AS department_93,
      f2_.complexity AS complexity_94,
      f2_.repar AS repar_95,
      f2_.marge AS marge_96,
      f2_.appointment_update_reason AS appointment_update_reason_97,
      f2_.closing_date AS closing_date_98,
      f2_.planif_date AS planif_date_99,
      f2_.gap AS gap_100,
      f2_.offset_pose AS offset_pose_101,
      f2_.duplicate AS duplicate_102,
      f2_.couriers_parent_number AS couriers_parent_number_103,
      f2_.state AS state_104,
      f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105,
      f2_.prime_date AS prime_date_106,
      f2_.insurance_card_added_at AS insurance_card_added_at_107,
      f2_.vehicle_card_added_at AS vehicle_card_added_at_108,
      f2_.windscreen_added_at AS windscreen_added_at_109,
      f2_.last_agent_update_at AS last_agent_update_at_110,
      f2_.openai_thread_id AS openai_thread_id_111,
      f2_.vehicle_description AS vehicle_description_112,
      f2_.has_partial_payment AS has_partial_payment_113,
      f2_.paid_gap_amount AS paid_gap_amount_114,
      f2_.gap_declarate_date AS gap_declarate_date_115,
      f2_.hubspot_id AS hubspot_id_116,
      f2_.ht_repair_order AS ht_repair_order_117,
      f2_.task_verif_closed_date AS task_verif_closed_date_118,
      f2_.first_signature_date AS first_signature_date_119,
      ROW_NUMBER() OVER(
        ORDER BY
          f2_.appointment ASC
      ) AS sclr_120
    FROM
      task t1_
      INNER JOIN folder f2_ ON t1_.folder_id = f2_.id
      INNER JOIN companie c3_ ON f2_.companie_id = c3_.id
      INNER JOIN customer c4_ ON f2_.customer_id = c4_.id
      LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id
      LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id
      LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id
      INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id
      INNER JOIN franchise f8_ ON c3_.franchise_id = f8_.id
    WHERE
      t1_.status = 'cancel'
      AND a7_.id = ?
      AND f8_.is_gold = true
      AND t1_.category = 0
  ) dctrn_result
GROUP BY
  id_1
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_1, MIN(sclr_120) AS dctrn_minrownum FROM (SELECT (CASE WHEN ((c0_.morning_start IS NOT NULL AND c0_.morning_end IS NOT NULL AND '11:25:52' BETWEEN c0_.morning_start AND c0_.morning_end) OR (c0_.morning_start IS NULL AND c0_.morning_end IS NOT NULL AND '11:25:52' <= c0_.morning_end) OR (c0_.morning_start IS NOT NULL AND c0_.morning_end IS NULL AND '11:25:52' >= c0_.morning_start)) OR ((c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NOT NULL AND '11:25:52' BETWEEN c0_.afternoon_start AND c0_.afternoon_end) OR (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NOT NULL AND '11:25:52' <= c0_.afternoon_end) OR (c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NULL AND '11:25:52' >= c0_.afternoon_start)) OR ((c0_.morning_start IS NULL AND c0_.morning_end IS NULL) AND (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NULL)) THEN true ELSE false END) AS sclr_0, t1_.id AS id_1, t1_.created_at AS created_at_2, t1_.title AS title_3, t1_.description AS description_4, t1_.priority AS priority_5, t1_.status AS status_6, t1_.type AS type_7, t1_.updated_at AS updated_at_8, t1_.alert AS alert_9, t1_.joint_file AS joint_file_10, t1_.category AS category_11, t1_.is_automatic AS is_automatic_12, t1_.anomaly_status_responsable AS anomaly_status_responsable_13, t1_.result AS result_14, t1_.summer AS summer_15, t1_.quiz AS quiz_16, t1_.date_attribution AS date_attribution_17, t1_.estimation_huissier AS estimation_huissier_18, t1_.estimation_assignation AS estimation_assignation_19, t1_.estimation_avocat AS estimation_avocat_20, t1_.comment AS comment_21, f2_.id AS id_22, f2_.registration AS registration_23, f2_.registration_normalized AS registration_normalized_24, f2_.vehicle_model AS vehicle_model_25, f2_.insurance_name AS insurance_name_26, f2_.appointment AS appointment_27, f2_.appointment_end AS appointment_end_28, f2_.status AS status_29, f2_.windscreen AS windscreen_30, f2_.insurance_card AS insurance_card_31, f2_.vehicle_card AS vehicle_card_32, f2_.created_at AS created_at_33, f2_.professional AS professional_34, f2_.tva_subject AS tva_subject_35, f2_.sensor AS sensor_36, f2_.athermal AS athermal_37, f2_.camera AS camera_38, f2_.glass AS glass_39, f2_.sinister_date AS sinister_date_40, f2_.declare_date AS declare_date_41, f2_.sinister_reason AS sinister_reason_42, f2_.sinister_circ AS sinister_circ_43, f2_.sinister_location AS sinister_location_44, f2_.travel_reason AS travel_reason_45, f2_.invoice_due AS invoice_due_46, f2_.deductible_amount AS deductible_amount_47, f2_.verified_deductible AS verified_deductible_48, f2_.insurance_number AS insurance_number_49, f2_.cca AS cca_50, f2_.procedure AS procedure_51, f2_.signed AS signed_52, f2_.signed_date AS signed_date_53, f2_.file AS file_54, f2_.known_by AS known_by_55, f2_.gift AS gift_56, f2_.adresse_pose AS adresse_pose_57, f2_.task AS task_58, f2_.updated_at AS updated_at_59, f2_.relance_at AS relance_at_60, f2_.is_paid AS is_paid_61, f2_.sinister_number AS sinister_number_62, f2_.is_assured AS is_assured_63, f2_.is_send_folder AS is_send_folder_64, f2_.is_send_invoice AS is_send_invoice_65, f2_.cancellation_reason AS cancellation_reason_66, f2_.cover AS cover_67, f2_.status_command AS status_command_68, f2_.ref AS ref_69, f2_.ref_client AS ref_client_70, f2_.km AS km_71, f2_.member_client AS member_client_72, f2_.member_garage AS member_garage_73, f2_.is_gift_send AS is_gift_send_74, f2_.status_updated AS status_updated_75, f2_.pattern_cover AS pattern_cover_76, f2_.judicial AS judicial_77, f2_.relance_updated_at AS relance_updated_at_78, f2_.relance_created_at AS relance_created_at_79, f2_.relance_after_at AS relance_after_at_80, f2_.sms_balance AS sms_balance_81, f2_.brand AS brand_82, f2_.mine_type AS mine_type_83, f2_.serial_number AS serial_number_84, f2_.wan_code AS wan_code_85, f2_.audatex_code AS audatex_code_86, f2_.euro_code AS euro_code_87, f2_.vin_identified AS vin_identified_88, f2_.sidexa_state AS sidexa_state_89, f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90, f2_.data_updated AS data_updated_91, f2_.category AS category_92, f2_.department AS department_93, f2_.complexity AS complexity_94, f2_.repar AS repar_95, f2_.marge AS marge_96, f2_.appointment_update_reason AS appointment_update_reason_97, f2_.closing_date AS closing_date_98, f2_.planif_date AS planif_date_99, f2_.gap AS gap_100, f2_.offset_pose AS offset_pose_101, f2_.duplicate AS duplicate_102, f2_.couriers_parent_number AS couriers_parent_number_103, f2_.state AS state_104, f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105, f2_.prime_date AS prime_date_106, f2_.insurance_card_added_at AS insurance_card_added_at_107, f2_.vehicle_card_added_at AS vehicle_card_added_at_108, f2_.windscreen_added_at AS windscreen_added_at_109, f2_.last_agent_update_at AS last_agent_update_at_110, f2_.openai_thread_id AS openai_thread_id_111, f2_.vehicle_description AS vehicle_description_112, f2_.has_partial_payment AS has_partial_payment_113, f2_.paid_gap_amount AS paid_gap_amount_114, f2_.gap_declarate_date AS gap_declarate_date_115, f2_.hubspot_id AS hubspot_id_116, f2_.ht_repair_order AS ht_repair_order_117, f2_.task_verif_closed_date AS task_verif_closed_date_118, f2_.first_signature_date AS first_signature_date_119, ROW_NUMBER() OVER(ORDER BY f2_.appointment ASC) AS sclr_120 FROM task t1_ INNER JOIN folder f2_ ON t1_.folder_id = f2_.id INNER JOIN companie c3_ ON f2_.companie_id = c3_.id INNER JOIN customer c4_ ON f2_.customer_id = c4_.id LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id INNER JOIN franchise f8_ ON c3_.franchise_id = f8_.id WHERE t1_.status = 'cancel' AND a7_.id = 640 AND f8_.is_gold = true AND t1_.category = 0) dctrn_result GROUP BY id_1 ORDER BY dctrn_minrownum ASC LIMIT 25;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 1257)
8	App\Controller\Admin\GestionController::taskTable (line 1257)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

5.86 ms
(19.96%)

SELECT DISTINCT id_1, MIN(sclr_120) AS dctrn_minrownum FROM (SELECT (CASE WHEN ((c0_.morning_start IS NOT NULL AND c0_.morning_end IS NOT NULL AND ? BETWEEN c0_.morning_start AND c0_.morning_end) OR (c0_.morning_start IS NULL AND c0_.morning_end IS NOT NULL AND ? <= c0_.morning_end) OR (c0_.morning_start IS NOT NULL AND c0_.morning_end IS NULL AND ? >= c0_.morning_start)) OR ((c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NOT NULL AND ? BETWEEN c0_.afternoon_start AND c0_.afternoon_end) OR (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NOT NULL AND ? <= c0_.afternoon_end) OR (c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NULL AND ? >= c0_.afternoon_start)) OR ((c0_.morning_start IS NULL AND c0_.morning_end IS NULL) AND (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NULL)) THEN true ELSE false END) AS sclr_0, t1_.id AS id_1, t1_.created_at AS created_at_2, t1_.title AS title_3, t1_.description AS description_4, t1_.priority AS priority_5, t1_.status AS status_6, t1_.type AS type_7, t1_.updated_at AS updated_at_8, t1_.alert AS alert_9, t1_.joint_file AS joint_file_10, t1_.category AS category_11, t1_.is_automatic AS is_automatic_12, t1_.anomaly_status_responsable AS anomaly_status_responsable_13, t1_.result AS result_14, t1_.summer AS summer_15, t1_.quiz AS quiz_16, t1_.date_attribution AS date_attribution_17, t1_.estimation_huissier AS estimation_huissier_18, t1_.estimation_assignation AS estimation_assignation_19, t1_.estimation_avocat AS estimation_avocat_20, t1_.comment AS comment_21, f2_.id AS id_22, f2_.registration AS registration_23, f2_.registration_normalized AS registration_normalized_24, f2_.vehicle_model AS vehicle_model_25, f2_.insurance_name AS insurance_name_26, f2_.appointment AS appointment_27, f2_.appointment_end AS appointment_end_28, f2_.status AS status_29, f2_.windscreen AS windscreen_30, f2_.insurance_card AS insurance_card_31, f2_.vehicle_card AS vehicle_card_32, f2_.created_at AS created_at_33, f2_.professional AS professional_34, f2_.tva_subject AS tva_subject_35, f2_.sensor AS sensor_36, f2_.athermal AS athermal_37, f2_.camera AS camera_38, f2_.glass AS glass_39, f2_.sinister_date AS sinister_date_40, f2_.declare_date AS declare_date_41, f2_.sinister_reason AS sinister_reason_42, f2_.sinister_circ AS sinister_circ_43, f2_.sinister_location AS sinister_location_44, f2_.travel_reason AS travel_reason_45, f2_.invoice_due AS invoice_due_46, f2_.deductible_amount AS deductible_amount_47, f2_.verified_deductible AS verified_deductible_48, f2_.insurance_number AS insurance_number_49, f2_.cca AS cca_50, f2_.procedure AS procedure_51, f2_.signed AS signed_52, f2_.signed_date AS signed_date_53, f2_.file AS file_54, f2_.known_by AS known_by_55, f2_.gift AS gift_56, f2_.adresse_pose AS adresse_pose_57, f2_.task AS task_58, f2_.updated_at AS updated_at_59, f2_.relance_at AS relance_at_60, f2_.is_paid AS is_paid_61, f2_.sinister_number AS sinister_number_62, f2_.is_assured AS is_assured_63, f2_.is_send_folder AS is_send_folder_64, f2_.is_send_invoice AS is_send_invoice_65, f2_.cancellation_reason AS cancellation_reason_66, f2_.cover AS cover_67, f2_.status_command AS status_command_68, f2_.ref AS ref_69, f2_.ref_client AS ref_client_70, f2_.km AS km_71, f2_.member_client AS member_client_72, f2_.member_garage AS member_garage_73, f2_.is_gift_send AS is_gift_send_74, f2_.status_updated AS status_updated_75, f2_.pattern_cover AS pattern_cover_76, f2_.judicial AS judicial_77, f2_.relance_updated_at AS relance_updated_at_78, f2_.relance_created_at AS relance_created_at_79, f2_.relance_after_at AS relance_after_at_80, f2_.sms_balance AS sms_balance_81, f2_.brand AS brand_82, f2_.mine_type AS mine_type_83, f2_.serial_number AS serial_number_84, f2_.wan_code AS wan_code_85, f2_.audatex_code AS audatex_code_86, f2_.euro_code AS euro_code_87, f2_.vin_identified AS vin_identified_88, f2_.sidexa_state AS sidexa_state_89, f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90, f2_.data_updated AS data_updated_91, f2_.category AS category_92, f2_.department AS department_93, f2_.complexity AS complexity_94, f2_.repar AS repar_95, f2_.marge AS marge_96, f2_.appointment_update_reason AS appointment_update_reason_97, f2_.closing_date AS closing_date_98, f2_.planif_date AS planif_date_99, f2_.gap AS gap_100, f2_.offset_pose AS offset_pose_101, f2_.duplicate AS duplicate_102, f2_.couriers_parent_number AS couriers_parent_number_103, f2_.state AS state_104, f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105, f2_.prime_date AS prime_date_106, f2_.insurance_card_added_at AS insurance_card_added_at_107, f2_.vehicle_card_added_at AS vehicle_card_added_at_108, f2_.windscreen_added_at AS windscreen_added_at_109, f2_.last_agent_update_at AS last_agent_update_at_110, f2_.openai_thread_id AS openai_thread_id_111, f2_.vehicle_description AS vehicle_description_112, f2_.has_partial_payment AS has_partial_payment_113, f2_.paid_gap_amount AS paid_gap_amount_114, f2_.gap_declarate_date AS gap_declarate_date_115, f2_.hubspot_id AS hubspot_id_116, f2_.ht_repair_order AS ht_repair_order_117, f2_.task_verif_closed_date AS task_verif_closed_date_118, f2_.first_signature_date AS first_signature_date_119, ROW_NUMBER() OVER(ORDER BY f2_.appointment ASC) AS sclr_120 FROM task t1_ INNER JOIN folder f2_ ON t1_.folder_id = f2_.id INNER JOIN companie c3_ ON f2_.companie_id = c3_.id INNER JOIN customer c4_ ON f2_.customer_id = c4_.id LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id LEFT JOIN franchise f8_ ON c3_.franchise_id = f8_.id WHERE t1_.status = 'cancel' AND a7_.id = ? AND (f8_.is_gold = false OR f8_.is_gold IS NULL) AND t1_.category = 0) dctrn_result GROUP BY id_1 ORDER BY dctrn_minrownum ASC LIMIT 25

Parameters:

[
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  640
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_1,
  MIN(sclr_120) AS dctrn_minrownum
FROM
  (
    SELECT
      (
        CASE WHEN (
          (
            c0_.morning_start IS NOT NULL
            AND c0_.morning_end IS NOT NULL
            AND ? BETWEEN c0_.morning_start
            AND c0_.morning_end
          )
          OR (
            c0_.morning_start IS NULL
            AND c0_.morning_end IS NOT NULL
            AND ? <= c0_.morning_end
          )
          OR (
            c0_.morning_start IS NOT NULL
            AND c0_.morning_end IS NULL
            AND ? >= c0_.morning_start
          )
        )
        OR (
          (
            c0_.afternoon_start IS NOT NULL
            AND c0_.afternoon_end IS NOT NULL
            AND ? BETWEEN c0_.afternoon_start
            AND c0_.afternoon_end
          )
          OR (
            c0_.afternoon_start IS NULL
            AND c0_.afternoon_end IS NOT NULL
            AND ? <= c0_.afternoon_end
          )
          OR (
            c0_.afternoon_start IS NOT NULL
            AND c0_.afternoon_end IS NULL
            AND ? >= c0_.afternoon_start
          )
        )
        OR (
          (
            c0_.morning_start IS NULL
            AND c0_.morning_end IS NULL
          )
          AND (
            c0_.afternoon_start IS NULL
            AND c0_.afternoon_end IS NULL
          )
        ) THEN
          true
        ELSE
          false
        END
      ) AS sclr_0,
      t1_.id AS id_1,
      t1_.created_at AS created_at_2,
      t1_.title AS title_3,
      t1_.description AS description_4,
      t1_.priority AS priority_5,
      t1_.status AS status_6,
      t1_.type AS type_7,
      t1_.updated_at AS updated_at_8,
      t1_.alert AS alert_9,
      t1_.joint_file AS joint_file_10,
      t1_.category AS category_11,
      t1_.is_automatic AS is_automatic_12,
      t1_.anomaly_status_responsable AS anomaly_status_responsable_13,
      t1_.result AS result_14,
      t1_.summer AS summer_15,
      t1_.quiz AS quiz_16,
      t1_.date_attribution AS date_attribution_17,
      t1_.estimation_huissier AS estimation_huissier_18,
      t1_.estimation_assignation AS estimation_assignation_19,
      t1_.estimation_avocat AS estimation_avocat_20,
      t1_.comment AS comment_21,
      f2_.id AS id_22,
      f2_.registration AS registration_23,
      f2_.registration_normalized AS registration_normalized_24,
      f2_.vehicle_model AS vehicle_model_25,
      f2_.insurance_name AS insurance_name_26,
      f2_.appointment AS appointment_27,
      f2_.appointment_end AS appointment_end_28,
      f2_.status AS status_29,
      f2_.windscreen AS windscreen_30,
      f2_.insurance_card AS insurance_card_31,
      f2_.vehicle_card AS vehicle_card_32,
      f2_.created_at AS created_at_33,
      f2_.professional AS professional_34,
      f2_.tva_subject AS tva_subject_35,
      f2_.sensor AS sensor_36,
      f2_.athermal AS athermal_37,
      f2_.camera AS camera_38,
      f2_.glass AS glass_39,
      f2_.sinister_date AS sinister_date_40,
      f2_.declare_date AS declare_date_41,
      f2_.sinister_reason AS sinister_reason_42,
      f2_.sinister_circ AS sinister_circ_43,
      f2_.sinister_location AS sinister_location_44,
      f2_.travel_reason AS travel_reason_45,
      f2_.invoice_due AS invoice_due_46,
      f2_.deductible_amount AS deductible_amount_47,
      f2_.verified_deductible AS verified_deductible_48,
      f2_.insurance_number AS insurance_number_49,
      f2_.cca AS cca_50,
      f2_.procedure AS procedure_51,
      f2_.signed AS signed_52,
      f2_.signed_date AS signed_date_53,
      f2_.file AS file_54,
      f2_.known_by AS known_by_55,
      f2_.gift AS gift_56,
      f2_.adresse_pose AS adresse_pose_57,
      f2_.task AS task_58,
      f2_.updated_at AS updated_at_59,
      f2_.relance_at AS relance_at_60,
      f2_.is_paid AS is_paid_61,
      f2_.sinister_number AS sinister_number_62,
      f2_.is_assured AS is_assured_63,
      f2_.is_send_folder AS is_send_folder_64,
      f2_.is_send_invoice AS is_send_invoice_65,
      f2_.cancellation_reason AS cancellation_reason_66,
      f2_.cover AS cover_67,
      f2_.status_command AS status_command_68,
      f2_.ref AS ref_69,
      f2_.ref_client AS ref_client_70,
      f2_.km AS km_71,
      f2_.member_client AS member_client_72,
      f2_.member_garage AS member_garage_73,
      f2_.is_gift_send AS is_gift_send_74,
      f2_.status_updated AS status_updated_75,
      f2_.pattern_cover AS pattern_cover_76,
      f2_.judicial AS judicial_77,
      f2_.relance_updated_at AS relance_updated_at_78,
      f2_.relance_created_at AS relance_created_at_79,
      f2_.relance_after_at AS relance_after_at_80,
      f2_.sms_balance AS sms_balance_81,
      f2_.brand AS brand_82,
      f2_.mine_type AS mine_type_83,
      f2_.serial_number AS serial_number_84,
      f2_.wan_code AS wan_code_85,
      f2_.audatex_code AS audatex_code_86,
      f2_.euro_code AS euro_code_87,
      f2_.vin_identified AS vin_identified_88,
      f2_.sidexa_state AS sidexa_state_89,
      f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90,
      f2_.data_updated AS data_updated_91,
      f2_.category AS category_92,
      f2_.department AS department_93,
      f2_.complexity AS complexity_94,
      f2_.repar AS repar_95,
      f2_.marge AS marge_96,
      f2_.appointment_update_reason AS appointment_update_reason_97,
      f2_.closing_date AS closing_date_98,
      f2_.planif_date AS planif_date_99,
      f2_.gap AS gap_100,
      f2_.offset_pose AS offset_pose_101,
      f2_.duplicate AS duplicate_102,
      f2_.couriers_parent_number AS couriers_parent_number_103,
      f2_.state AS state_104,
      f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105,
      f2_.prime_date AS prime_date_106,
      f2_.insurance_card_added_at AS insurance_card_added_at_107,
      f2_.vehicle_card_added_at AS vehicle_card_added_at_108,
      f2_.windscreen_added_at AS windscreen_added_at_109,
      f2_.last_agent_update_at AS last_agent_update_at_110,
      f2_.openai_thread_id AS openai_thread_id_111,
      f2_.vehicle_description AS vehicle_description_112,
      f2_.has_partial_payment AS has_partial_payment_113,
      f2_.paid_gap_amount AS paid_gap_amount_114,
      f2_.gap_declarate_date AS gap_declarate_date_115,
      f2_.hubspot_id AS hubspot_id_116,
      f2_.ht_repair_order AS ht_repair_order_117,
      f2_.task_verif_closed_date AS task_verif_closed_date_118,
      f2_.first_signature_date AS first_signature_date_119,
      ROW_NUMBER() OVER(
        ORDER BY
          f2_.appointment ASC
      ) AS sclr_120
    FROM
      task t1_
      INNER JOIN folder f2_ ON t1_.folder_id = f2_.id
      INNER JOIN companie c3_ ON f2_.companie_id = c3_.id
      INNER JOIN customer c4_ ON f2_.customer_id = c4_.id
      LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id
      LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id
      LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id
      INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id
      LEFT JOIN franchise f8_ ON c3_.franchise_id = f8_.id
    WHERE
      t1_.status = 'cancel'
      AND a7_.id = ?
      AND (
        f8_.is_gold = false
        OR f8_.is_gold IS NULL
      )
      AND t1_.category = 0
  ) dctrn_result
GROUP BY
  id_1
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_1, MIN(sclr_120) AS dctrn_minrownum FROM (SELECT (CASE WHEN ((c0_.morning_start IS NOT NULL AND c0_.morning_end IS NOT NULL AND '11:25:52' BETWEEN c0_.morning_start AND c0_.morning_end) OR (c0_.morning_start IS NULL AND c0_.morning_end IS NOT NULL AND '11:25:52' <= c0_.morning_end) OR (c0_.morning_start IS NOT NULL AND c0_.morning_end IS NULL AND '11:25:52' >= c0_.morning_start)) OR ((c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NOT NULL AND '11:25:52' BETWEEN c0_.afternoon_start AND c0_.afternoon_end) OR (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NOT NULL AND '11:25:52' <= c0_.afternoon_end) OR (c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NULL AND '11:25:52' >= c0_.afternoon_start)) OR ((c0_.morning_start IS NULL AND c0_.morning_end IS NULL) AND (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NULL)) THEN true ELSE false END) AS sclr_0, t1_.id AS id_1, t1_.created_at AS created_at_2, t1_.title AS title_3, t1_.description AS description_4, t1_.priority AS priority_5, t1_.status AS status_6, t1_.type AS type_7, t1_.updated_at AS updated_at_8, t1_.alert AS alert_9, t1_.joint_file AS joint_file_10, t1_.category AS category_11, t1_.is_automatic AS is_automatic_12, t1_.anomaly_status_responsable AS anomaly_status_responsable_13, t1_.result AS result_14, t1_.summer AS summer_15, t1_.quiz AS quiz_16, t1_.date_attribution AS date_attribution_17, t1_.estimation_huissier AS estimation_huissier_18, t1_.estimation_assignation AS estimation_assignation_19, t1_.estimation_avocat AS estimation_avocat_20, t1_.comment AS comment_21, f2_.id AS id_22, f2_.registration AS registration_23, f2_.registration_normalized AS registration_normalized_24, f2_.vehicle_model AS vehicle_model_25, f2_.insurance_name AS insurance_name_26, f2_.appointment AS appointment_27, f2_.appointment_end AS appointment_end_28, f2_.status AS status_29, f2_.windscreen AS windscreen_30, f2_.insurance_card AS insurance_card_31, f2_.vehicle_card AS vehicle_card_32, f2_.created_at AS created_at_33, f2_.professional AS professional_34, f2_.tva_subject AS tva_subject_35, f2_.sensor AS sensor_36, f2_.athermal AS athermal_37, f2_.camera AS camera_38, f2_.glass AS glass_39, f2_.sinister_date AS sinister_date_40, f2_.declare_date AS declare_date_41, f2_.sinister_reason AS sinister_reason_42, f2_.sinister_circ AS sinister_circ_43, f2_.sinister_location AS sinister_location_44, f2_.travel_reason AS travel_reason_45, f2_.invoice_due AS invoice_due_46, f2_.deductible_amount AS deductible_amount_47, f2_.verified_deductible AS verified_deductible_48, f2_.insurance_number AS insurance_number_49, f2_.cca AS cca_50, f2_.procedure AS procedure_51, f2_.signed AS signed_52, f2_.signed_date AS signed_date_53, f2_.file AS file_54, f2_.known_by AS known_by_55, f2_.gift AS gift_56, f2_.adresse_pose AS adresse_pose_57, f2_.task AS task_58, f2_.updated_at AS updated_at_59, f2_.relance_at AS relance_at_60, f2_.is_paid AS is_paid_61, f2_.sinister_number AS sinister_number_62, f2_.is_assured AS is_assured_63, f2_.is_send_folder AS is_send_folder_64, f2_.is_send_invoice AS is_send_invoice_65, f2_.cancellation_reason AS cancellation_reason_66, f2_.cover AS cover_67, f2_.status_command AS status_command_68, f2_.ref AS ref_69, f2_.ref_client AS ref_client_70, f2_.km AS km_71, f2_.member_client AS member_client_72, f2_.member_garage AS member_garage_73, f2_.is_gift_send AS is_gift_send_74, f2_.status_updated AS status_updated_75, f2_.pattern_cover AS pattern_cover_76, f2_.judicial AS judicial_77, f2_.relance_updated_at AS relance_updated_at_78, f2_.relance_created_at AS relance_created_at_79, f2_.relance_after_at AS relance_after_at_80, f2_.sms_balance AS sms_balance_81, f2_.brand AS brand_82, f2_.mine_type AS mine_type_83, f2_.serial_number AS serial_number_84, f2_.wan_code AS wan_code_85, f2_.audatex_code AS audatex_code_86, f2_.euro_code AS euro_code_87, f2_.vin_identified AS vin_identified_88, f2_.sidexa_state AS sidexa_state_89, f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90, f2_.data_updated AS data_updated_91, f2_.category AS category_92, f2_.department AS department_93, f2_.complexity AS complexity_94, f2_.repar AS repar_95, f2_.marge AS marge_96, f2_.appointment_update_reason AS appointment_update_reason_97, f2_.closing_date AS closing_date_98, f2_.planif_date AS planif_date_99, f2_.gap AS gap_100, f2_.offset_pose AS offset_pose_101, f2_.duplicate AS duplicate_102, f2_.couriers_parent_number AS couriers_parent_number_103, f2_.state AS state_104, f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105, f2_.prime_date AS prime_date_106, f2_.insurance_card_added_at AS insurance_card_added_at_107, f2_.vehicle_card_added_at AS vehicle_card_added_at_108, f2_.windscreen_added_at AS windscreen_added_at_109, f2_.last_agent_update_at AS last_agent_update_at_110, f2_.openai_thread_id AS openai_thread_id_111, f2_.vehicle_description AS vehicle_description_112, f2_.has_partial_payment AS has_partial_payment_113, f2_.paid_gap_amount AS paid_gap_amount_114, f2_.gap_declarate_date AS gap_declarate_date_115, f2_.hubspot_id AS hubspot_id_116, f2_.ht_repair_order AS ht_repair_order_117, f2_.task_verif_closed_date AS task_verif_closed_date_118, f2_.first_signature_date AS first_signature_date_119, ROW_NUMBER() OVER(ORDER BY f2_.appointment ASC) AS sclr_120 FROM task t1_ INNER JOIN folder f2_ ON t1_.folder_id = f2_.id INNER JOIN companie c3_ ON f2_.companie_id = c3_.id INNER JOIN customer c4_ ON f2_.customer_id = c4_.id LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id LEFT JOIN franchise f8_ ON c3_.franchise_id = f8_.id WHERE t1_.status = 'cancel' AND a7_.id = 640 AND (f8_.is_gold = false OR f8_.is_gold IS NULL) AND t1_.category = 0) dctrn_result GROUP BY id_1 ORDER BY dctrn_minrownum ASC LIMIT 25;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 1257)
8	App\Controller\Admin\GestionController::taskTable (line 1257)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

4.43 ms
(15.07%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT (CASE WHEN ((c0_.morning_start IS NOT NULL AND c0_.morning_end IS NOT NULL AND ? BETWEEN c0_.morning_start AND c0_.morning_end) OR (c0_.morning_start IS NULL AND c0_.morning_end IS NOT NULL AND ? <= c0_.morning_end) OR (c0_.morning_start IS NOT NULL AND c0_.morning_end IS NULL AND ? >= c0_.morning_start)) OR ((c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NOT NULL AND ? BETWEEN c0_.afternoon_start AND c0_.afternoon_end) OR (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NOT NULL AND ? <= c0_.afternoon_end) OR (c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NULL AND ? >= c0_.afternoon_start)) OR ((c0_.morning_start IS NULL AND c0_.morning_end IS NULL) AND (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NULL)) THEN true ELSE false END) AS sclr_0, t1_.id AS id_1, t1_.created_at AS created_at_2, t1_.title AS title_3, t1_.description AS description_4, t1_.priority AS priority_5, t1_.status AS status_6, t1_.type AS type_7, t1_.updated_at AS updated_at_8, t1_.alert AS alert_9, t1_.joint_file AS joint_file_10, t1_.category AS category_11, t1_.is_automatic AS is_automatic_12, t1_.anomaly_status_responsable AS anomaly_status_responsable_13, t1_.result AS result_14, t1_.summer AS summer_15, t1_.quiz AS quiz_16, t1_.date_attribution AS date_attribution_17, t1_.estimation_huissier AS estimation_huissier_18, t1_.estimation_assignation AS estimation_assignation_19, t1_.estimation_avocat AS estimation_avocat_20, t1_.comment AS comment_21, f2_.id AS id_22, f2_.registration AS registration_23, f2_.registration_normalized AS registration_normalized_24, f2_.vehicle_model AS vehicle_model_25, f2_.insurance_name AS insurance_name_26, f2_.appointment AS appointment_27, f2_.appointment_end AS appointment_end_28, f2_.status AS status_29, f2_.windscreen AS windscreen_30, f2_.insurance_card AS insurance_card_31, f2_.vehicle_card AS vehicle_card_32, f2_.created_at AS created_at_33, f2_.professional AS professional_34, f2_.tva_subject AS tva_subject_35, f2_.sensor AS sensor_36, f2_.athermal AS athermal_37, f2_.camera AS camera_38, f2_.glass AS glass_39, f2_.sinister_date AS sinister_date_40, f2_.declare_date AS declare_date_41, f2_.sinister_reason AS sinister_reason_42, f2_.sinister_circ AS sinister_circ_43, f2_.sinister_location AS sinister_location_44, f2_.travel_reason AS travel_reason_45, f2_.invoice_due AS invoice_due_46, f2_.deductible_amount AS deductible_amount_47, f2_.verified_deductible AS verified_deductible_48, f2_.insurance_number AS insurance_number_49, f2_.cca AS cca_50, f2_.procedure AS procedure_51, f2_.signed AS signed_52, f2_.signed_date AS signed_date_53, f2_.file AS file_54, f2_.known_by AS known_by_55, f2_.gift AS gift_56, f2_.adresse_pose AS adresse_pose_57, f2_.task AS task_58, f2_.updated_at AS updated_at_59, f2_.relance_at AS relance_at_60, f2_.is_paid AS is_paid_61, f2_.sinister_number AS sinister_number_62, f2_.is_assured AS is_assured_63, f2_.is_send_folder AS is_send_folder_64, f2_.is_send_invoice AS is_send_invoice_65, f2_.cancellation_reason AS cancellation_reason_66, f2_.cover AS cover_67, f2_.status_command AS status_command_68, f2_.ref AS ref_69, f2_.ref_client AS ref_client_70, f2_.km AS km_71, f2_.member_client AS member_client_72, f2_.member_garage AS member_garage_73, f2_.is_gift_send AS is_gift_send_74, f2_.status_updated AS status_updated_75, f2_.pattern_cover AS pattern_cover_76, f2_.judicial AS judicial_77, f2_.relance_updated_at AS relance_updated_at_78, f2_.relance_created_at AS relance_created_at_79, f2_.relance_after_at AS relance_after_at_80, f2_.sms_balance AS sms_balance_81, f2_.brand AS brand_82, f2_.mine_type AS mine_type_83, f2_.serial_number AS serial_number_84, f2_.wan_code AS wan_code_85, f2_.audatex_code AS audatex_code_86, f2_.euro_code AS euro_code_87, f2_.vin_identified AS vin_identified_88, f2_.sidexa_state AS sidexa_state_89, f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90, f2_.data_updated AS data_updated_91, f2_.category AS category_92, f2_.department AS department_93, f2_.complexity AS complexity_94, f2_.repar AS repar_95, f2_.marge AS marge_96, f2_.appointment_update_reason AS appointment_update_reason_97, f2_.closing_date AS closing_date_98, f2_.planif_date AS planif_date_99, f2_.gap AS gap_100, f2_.offset_pose AS offset_pose_101, f2_.duplicate AS duplicate_102, f2_.couriers_parent_number AS couriers_parent_number_103, f2_.state AS state_104, f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105, f2_.prime_date AS prime_date_106, f2_.insurance_card_added_at AS insurance_card_added_at_107, f2_.vehicle_card_added_at AS vehicle_card_added_at_108, f2_.windscreen_added_at AS windscreen_added_at_109, f2_.last_agent_update_at AS last_agent_update_at_110, f2_.openai_thread_id AS openai_thread_id_111, f2_.vehicle_description AS vehicle_description_112, f2_.has_partial_payment AS has_partial_payment_113, f2_.paid_gap_amount AS paid_gap_amount_114, f2_.gap_declarate_date AS gap_declarate_date_115, f2_.hubspot_id AS hubspot_id_116, f2_.ht_repair_order AS ht_repair_order_117, f2_.task_verif_closed_date AS task_verif_closed_date_118, f2_.first_signature_date AS first_signature_date_119 FROM task t1_ INNER JOIN folder f2_ ON t1_.folder_id = f2_.id INNER JOIN companie c3_ ON f2_.companie_id = c3_.id INNER JOIN customer c4_ ON f2_.customer_id = c4_.id LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id LEFT JOIN franchise f8_ ON c3_.franchise_id = f8_.id WHERE t1_.status = 'cancel' AND a7_.id = ? AND (f8_.is_gold = false OR f8_.is_gold IS NULL) AND t1_.category = 0 ORDER BY f2_.appointment ASC) dctrn_result) dctrn_table

Parameters:

[
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  "11:25:52"
  640
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          (
            CASE WHEN (
              (
                c0_.morning_start IS NOT NULL
                AND c0_.morning_end IS NOT NULL
                AND ? BETWEEN c0_.morning_start
                AND c0_.morning_end
              )
              OR (
                c0_.morning_start IS NULL
                AND c0_.morning_end IS NOT NULL
                AND ? <= c0_.morning_end
              )
              OR (
                c0_.morning_start IS NOT NULL
                AND c0_.morning_end IS NULL
                AND ? >= c0_.morning_start
              )
            )
            OR (
              (
                c0_.afternoon_start IS NOT NULL
                AND c0_.afternoon_end IS NOT NULL
                AND ? BETWEEN c0_.afternoon_start
                AND c0_.afternoon_end
              )
              OR (
                c0_.afternoon_start IS NULL
                AND c0_.afternoon_end IS NOT NULL
                AND ? <= c0_.afternoon_end
              )
              OR (
                c0_.afternoon_start IS NOT NULL
                AND c0_.afternoon_end IS NULL
                AND ? >= c0_.afternoon_start
              )
            )
            OR (
              (
                c0_.morning_start IS NULL
                AND c0_.morning_end IS NULL
              )
              AND (
                c0_.afternoon_start IS NULL
                AND c0_.afternoon_end IS NULL
              )
            ) THEN
              true
            ELSE
              false
            END
          ) AS sclr_0,
          t1_.id AS id_1,
          t1_.created_at AS created_at_2,
          t1_.title AS title_3,
          t1_.description AS description_4,
          t1_.priority AS priority_5,
          t1_.status AS status_6,
          t1_.type AS type_7,
          t1_.updated_at AS updated_at_8,
          t1_.alert AS alert_9,
          t1_.joint_file AS joint_file_10,
          t1_.category AS category_11,
          t1_.is_automatic AS is_automatic_12,
          t1_.anomaly_status_responsable AS anomaly_status_responsable_13,
          t1_.result AS result_14,
          t1_.summer AS summer_15,
          t1_.quiz AS quiz_16,
          t1_.date_attribution AS date_attribution_17,
          t1_.estimation_huissier AS estimation_huissier_18,
          t1_.estimation_assignation AS estimation_assignation_19,
          t1_.estimation_avocat AS estimation_avocat_20,
          t1_.comment AS comment_21,
          f2_.id AS id_22,
          f2_.registration AS registration_23,
          f2_.registration_normalized AS registration_normalized_24,
          f2_.vehicle_model AS vehicle_model_25,
          f2_.insurance_name AS insurance_name_26,
          f2_.appointment AS appointment_27,
          f2_.appointment_end AS appointment_end_28,
          f2_.status AS status_29,
          f2_.windscreen AS windscreen_30,
          f2_.insurance_card AS insurance_card_31,
          f2_.vehicle_card AS vehicle_card_32,
          f2_.created_at AS created_at_33,
          f2_.professional AS professional_34,
          f2_.tva_subject AS tva_subject_35,
          f2_.sensor AS sensor_36,
          f2_.athermal AS athermal_37,
          f2_.camera AS camera_38,
          f2_.glass AS glass_39,
          f2_.sinister_date AS sinister_date_40,
          f2_.declare_date AS declare_date_41,
          f2_.sinister_reason AS sinister_reason_42,
          f2_.sinister_circ AS sinister_circ_43,
          f2_.sinister_location AS sinister_location_44,
          f2_.travel_reason AS travel_reason_45,
          f2_.invoice_due AS invoice_due_46,
          f2_.deductible_amount AS deductible_amount_47,
          f2_.verified_deductible AS verified_deductible_48,
          f2_.insurance_number AS insurance_number_49,
          f2_.cca AS cca_50,
          f2_.procedure AS procedure_51,
          f2_.signed AS signed_52,
          f2_.signed_date AS signed_date_53,
          f2_.file AS file_54,
          f2_.known_by AS known_by_55,
          f2_.gift AS gift_56,
          f2_.adresse_pose AS adresse_pose_57,
          f2_.task AS task_58,
          f2_.updated_at AS updated_at_59,
          f2_.relance_at AS relance_at_60,
          f2_.is_paid AS is_paid_61,
          f2_.sinister_number AS sinister_number_62,
          f2_.is_assured AS is_assured_63,
          f2_.is_send_folder AS is_send_folder_64,
          f2_.is_send_invoice AS is_send_invoice_65,
          f2_.cancellation_reason AS cancellation_reason_66,
          f2_.cover AS cover_67,
          f2_.status_command AS status_command_68,
          f2_.ref AS ref_69,
          f2_.ref_client AS ref_client_70,
          f2_.km AS km_71,
          f2_.member_client AS member_client_72,
          f2_.member_garage AS member_garage_73,
          f2_.is_gift_send AS is_gift_send_74,
          f2_.status_updated AS status_updated_75,
          f2_.pattern_cover AS pattern_cover_76,
          f2_.judicial AS judicial_77,
          f2_.relance_updated_at AS relance_updated_at_78,
          f2_.relance_created_at AS relance_created_at_79,
          f2_.relance_after_at AS relance_after_at_80,
          f2_.sms_balance AS sms_balance_81,
          f2_.brand AS brand_82,
          f2_.mine_type AS mine_type_83,
          f2_.serial_number AS serial_number_84,
          f2_.wan_code AS wan_code_85,
          f2_.audatex_code AS audatex_code_86,
          f2_.euro_code AS euro_code_87,
          f2_.vin_identified AS vin_identified_88,
          f2_.sidexa_state AS sidexa_state_89,
          f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90,
          f2_.data_updated AS data_updated_91,
          f2_.category AS category_92,
          f2_.department AS department_93,
          f2_.complexity AS complexity_94,
          f2_.repar AS repar_95,
          f2_.marge AS marge_96,
          f2_.appointment_update_reason AS appointment_update_reason_97,
          f2_.closing_date AS closing_date_98,
          f2_.planif_date AS planif_date_99,
          f2_.gap AS gap_100,
          f2_.offset_pose AS offset_pose_101,
          f2_.duplicate AS duplicate_102,
          f2_.couriers_parent_number AS couriers_parent_number_103,
          f2_.state AS state_104,
          f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105,
          f2_.prime_date AS prime_date_106,
          f2_.insurance_card_added_at AS insurance_card_added_at_107,
          f2_.vehicle_card_added_at AS vehicle_card_added_at_108,
          f2_.windscreen_added_at AS windscreen_added_at_109,
          f2_.last_agent_update_at AS last_agent_update_at_110,
          f2_.openai_thread_id AS openai_thread_id_111,
          f2_.vehicle_description AS vehicle_description_112,
          f2_.has_partial_payment AS has_partial_payment_113,
          f2_.paid_gap_amount AS paid_gap_amount_114,
          f2_.gap_declarate_date AS gap_declarate_date_115,
          f2_.hubspot_id AS hubspot_id_116,
          f2_.ht_repair_order AS ht_repair_order_117,
          f2_.task_verif_closed_date AS task_verif_closed_date_118,
          f2_.first_signature_date AS first_signature_date_119
        FROM
          task t1_
          INNER JOIN folder f2_ ON t1_.folder_id = f2_.id
          INNER JOIN companie c3_ ON f2_.companie_id = c3_.id
          INNER JOIN customer c4_ ON f2_.customer_id = c4_.id
          LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id
          LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id
          LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id
          INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id
          LEFT JOIN franchise f8_ ON c3_.franchise_id = f8_.id
        WHERE
          t1_.status = 'cancel'
          AND a7_.id = ?
          AND (
            f8_.is_gold = false
            OR f8_.is_gold IS NULL
          )
          AND t1_.category = 0
        ORDER BY
          f2_.appointment ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT (CASE WHEN ((c0_.morning_start IS NOT NULL AND c0_.morning_end IS NOT NULL AND '11:25:52' BETWEEN c0_.morning_start AND c0_.morning_end) OR (c0_.morning_start IS NULL AND c0_.morning_end IS NOT NULL AND '11:25:52' <= c0_.morning_end) OR (c0_.morning_start IS NOT NULL AND c0_.morning_end IS NULL AND '11:25:52' >= c0_.morning_start)) OR ((c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NOT NULL AND '11:25:52' BETWEEN c0_.afternoon_start AND c0_.afternoon_end) OR (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NOT NULL AND '11:25:52' <= c0_.afternoon_end) OR (c0_.afternoon_start IS NOT NULL AND c0_.afternoon_end IS NULL AND '11:25:52' >= c0_.afternoon_start)) OR ((c0_.morning_start IS NULL AND c0_.morning_end IS NULL) AND (c0_.afternoon_start IS NULL AND c0_.afternoon_end IS NULL)) THEN true ELSE false END) AS sclr_0, t1_.id AS id_1, t1_.created_at AS created_at_2, t1_.title AS title_3, t1_.description AS description_4, t1_.priority AS priority_5, t1_.status AS status_6, t1_.type AS type_7, t1_.updated_at AS updated_at_8, t1_.alert AS alert_9, t1_.joint_file AS joint_file_10, t1_.category AS category_11, t1_.is_automatic AS is_automatic_12, t1_.anomaly_status_responsable AS anomaly_status_responsable_13, t1_.result AS result_14, t1_.summer AS summer_15, t1_.quiz AS quiz_16, t1_.date_attribution AS date_attribution_17, t1_.estimation_huissier AS estimation_huissier_18, t1_.estimation_assignation AS estimation_assignation_19, t1_.estimation_avocat AS estimation_avocat_20, t1_.comment AS comment_21, f2_.id AS id_22, f2_.registration AS registration_23, f2_.registration_normalized AS registration_normalized_24, f2_.vehicle_model AS vehicle_model_25, f2_.insurance_name AS insurance_name_26, f2_.appointment AS appointment_27, f2_.appointment_end AS appointment_end_28, f2_.status AS status_29, f2_.windscreen AS windscreen_30, f2_.insurance_card AS insurance_card_31, f2_.vehicle_card AS vehicle_card_32, f2_.created_at AS created_at_33, f2_.professional AS professional_34, f2_.tva_subject AS tva_subject_35, f2_.sensor AS sensor_36, f2_.athermal AS athermal_37, f2_.camera AS camera_38, f2_.glass AS glass_39, f2_.sinister_date AS sinister_date_40, f2_.declare_date AS declare_date_41, f2_.sinister_reason AS sinister_reason_42, f2_.sinister_circ AS sinister_circ_43, f2_.sinister_location AS sinister_location_44, f2_.travel_reason AS travel_reason_45, f2_.invoice_due AS invoice_due_46, f2_.deductible_amount AS deductible_amount_47, f2_.verified_deductible AS verified_deductible_48, f2_.insurance_number AS insurance_number_49, f2_.cca AS cca_50, f2_.procedure AS procedure_51, f2_.signed AS signed_52, f2_.signed_date AS signed_date_53, f2_.file AS file_54, f2_.known_by AS known_by_55, f2_.gift AS gift_56, f2_.adresse_pose AS adresse_pose_57, f2_.task AS task_58, f2_.updated_at AS updated_at_59, f2_.relance_at AS relance_at_60, f2_.is_paid AS is_paid_61, f2_.sinister_number AS sinister_number_62, f2_.is_assured AS is_assured_63, f2_.is_send_folder AS is_send_folder_64, f2_.is_send_invoice AS is_send_invoice_65, f2_.cancellation_reason AS cancellation_reason_66, f2_.cover AS cover_67, f2_.status_command AS status_command_68, f2_.ref AS ref_69, f2_.ref_client AS ref_client_70, f2_.km AS km_71, f2_.member_client AS member_client_72, f2_.member_garage AS member_garage_73, f2_.is_gift_send AS is_gift_send_74, f2_.status_updated AS status_updated_75, f2_.pattern_cover AS pattern_cover_76, f2_.judicial AS judicial_77, f2_.relance_updated_at AS relance_updated_at_78, f2_.relance_created_at AS relance_created_at_79, f2_.relance_after_at AS relance_after_at_80, f2_.sms_balance AS sms_balance_81, f2_.brand AS brand_82, f2_.mine_type AS mine_type_83, f2_.serial_number AS serial_number_84, f2_.wan_code AS wan_code_85, f2_.audatex_code AS audatex_code_86, f2_.euro_code AS euro_code_87, f2_.vin_identified AS vin_identified_88, f2_.sidexa_state AS sidexa_state_89, f2_.sidexa_vehicle_model AS sidexa_vehicle_model_90, f2_.data_updated AS data_updated_91, f2_.category AS category_92, f2_.department AS department_93, f2_.complexity AS complexity_94, f2_.repar AS repar_95, f2_.marge AS marge_96, f2_.appointment_update_reason AS appointment_update_reason_97, f2_.closing_date AS closing_date_98, f2_.planif_date AS planif_date_99, f2_.gap AS gap_100, f2_.offset_pose AS offset_pose_101, f2_.duplicate AS duplicate_102, f2_.couriers_parent_number AS couriers_parent_number_103, f2_.state AS state_104, f2_.quiz_sent_folder_submited AS quiz_sent_folder_submited_105, f2_.prime_date AS prime_date_106, f2_.insurance_card_added_at AS insurance_card_added_at_107, f2_.vehicle_card_added_at AS vehicle_card_added_at_108, f2_.windscreen_added_at AS windscreen_added_at_109, f2_.last_agent_update_at AS last_agent_update_at_110, f2_.openai_thread_id AS openai_thread_id_111, f2_.vehicle_description AS vehicle_description_112, f2_.has_partial_payment AS has_partial_payment_113, f2_.paid_gap_amount AS paid_gap_amount_114, f2_.gap_declarate_date AS gap_declarate_date_115, f2_.hubspot_id AS hubspot_id_116, f2_.ht_repair_order AS ht_repair_order_117, f2_.task_verif_closed_date AS task_verif_closed_date_118, f2_.first_signature_date AS first_signature_date_119 FROM task t1_ INNER JOIN folder f2_ ON t1_.folder_id = f2_.id INNER JOIN companie c3_ ON f2_.companie_id = c3_.id INNER JOIN customer c4_ ON f2_.customer_id = c4_.id LEFT JOIN companie c0_ ON f2_.insurance_name_new_id = c0_.id LEFT JOIN task t5_ ON t1_.anomaly_task_id = t5_.id LEFT JOIN admin a6_ ON t1_.created_by_id = a6_.id INNER JOIN admin a7_ ON f2_.gestionnaire_id = a7_.id LEFT JOIN franchise f8_ ON c3_.franchise_id = f8_.id WHERE t1_.status = 'cancel' AND a7_.id = 640 AND (f8_.is_gold = false OR f8_.is_gold IS NULL) AND t1_.category = 0 ORDER BY f2_.appointment ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Controller\Admin\GestionController->taskTable (line 1389)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

2.84 ms
(9.68%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.id = ?

Parameters:

[
  640
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.firstname AS firstname_6,
  t0.name AS name_7,
  t0.is_active AS is_active_8,
  t0.partenaire AS partenaire_9,
  t0.last_login AS last_login_10,
  t0.is_ready AS is_ready_11,
  t0.referent AS referent_12,
  t0.difficulty AS difficulty_13,
  t0.is_premium AS is_premium_14,
  t0.is_gold AS is_gold_15,
  t0.tokens_invalidated_at AS tokens_invalidated_at_16,
  t0.hubspot_id AS hubspot_id_17,
  t0.service_id AS service_id_18,
  t0.notif_configuration_id AS notif_configuration_id_19,
  t0.mail_configuration_id AS mail_configuration_id_20
FROM
  admin 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.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.id = 640;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

2.33 ms
(7.94%)

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM companie c0_ WHERE c0_.is_active = true AND (c0_.is_supplier = false OR c0_.is_supplier IS NULL) AND (c0_.is_prospect = false OR c0_.is_prospect IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  companie c0_
WHERE
  c0_.is_active = true
  AND (
    c0_.is_supplier = false
    OR c0_.is_supplier IS NULL
  )
  AND (
    c0_.is_prospect = false
    OR c0_.is_prospect IS NULL
  )

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM companie c0_ WHERE c0_.is_active = true AND (c0_.is_supplier = false OR c0_.is_supplier IS NULL) AND (c0_.is_prospect = false OR c0_.is_prospect IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Admin\GestionController->__construct (line 76)
7	ContainerXPpIOdj\getGestionControllerService->do (line 24)
8	ContainerXPpIOdj\App_KernelDevDebugContainer::load (line 871)
9	Symfony\Component\DependencyInjection\Container->make (line 221)
10	Symfony\Component\DependencyInjection\Container::get (line 203)
11	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
12	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
15	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

1.71 ms
(5.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.code_name AS code_name_4 FROM category t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "Assurance"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.code_name AS code_name_4
FROM
  category t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.code_name AS code_name_4 FROM category t0 WHERE t0.name = 'Assurance' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\Admin\GestionController->__construct (line 77)
5	ContainerXPpIOdj\getGestionControllerService->do (line 24)
6	ContainerXPpIOdj\App_KernelDevDebugContainer::load (line 871)
7	Symfony\Component\DependencyInjection\Container->make (line 221)
8	Symfony\Component\DependencyInjection\Container::get (line 203)
9	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
10	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
13	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

1.00 ms
(3.40%)

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.referent AS referent_3, t0.hubspot_id AS hubspot_id_4, t0.company_id AS company_id_5, t0.user_id AS user_id_6, t0.known_id AS known_id_7 FROM user_company t0 WHERE t0.user_id = ?

Parameters:

[
  640
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.referent AS referent_3,
  t0.hubspot_id AS hubspot_id_4,
  t0.company_id AS company_id_5,
  t0.user_id AS user_id_6,
  t0.known_id AS known_id_7
FROM
  user_company t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.referent AS referent_3, t0.hubspot_id AS hubspot_id_4, t0.company_id AS company_id_5, t0.user_id AS user_id_6, t0.known_id AS known_id_7 FROM user_company t0 WHERE t0.user_id = 640;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Security\Voter\CompanyRoleVoter->voteOnAttribute (line 61)
8	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
9	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
11	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
13	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
14	App\Services\SecurizerService->isGranted (line 20)
15	App\Repository\TaskRepository->joinSearchAdmin (line 266)
16	App\Repository\TaskRepository->findAllTask (line 376)
17	App\Controller\Admin\GestionController->taskTable (line 1248)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.57 ms
(1.95%)

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM companie c0_ WHERE c0_.is_active = true AND c0_.category_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  companie c0_
WHERE
  c0_.is_active = true
  AND c0_.category_id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM companie c0_ WHERE c0_.is_active = true AND c0_.category_id = 4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\Admin\GestionController->__construct (line 84)
7	ContainerXPpIOdj\getGestionControllerService->do (line 24)
8	ContainerXPpIOdj\App_KernelDevDebugContainer::load (line 871)
9	Symfony\Component\DependencyInjection\Container->make (line 221)
10	Symfony\Component\DependencyInjection\Container::get (line 203)
11	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
12	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
15	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Admin	1
App\Entity\Category	1

Entities Mapping

Class	Mapping errors
App\Entity\Admin	No errors.
App\Entity\AgentService	No errors.
App\Entity\Configuration	No errors.
App\Entity\Folder	No errors.
App\Entity\Jeton	No errors.
App\Entity\Task	No errors.
App\Entity\Stock	No errors.
App\Entity\Recovery	No errors.
App\Entity\Company	No errors.
App\Entity\HistoryActionAgent	No errors.
App\Entity\Message	No errors.
App\Entity\ContactAccessLog	No errors.
App\Entity\Technician	No errors.
App\Entity\UserCompany	No errors.
App\Entity\InfoGlobalRead	No errors.
App\Entity\InfoGLobalHistory	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.
App\Entity\Known	No errors.
App\Entity\Customer	No errors.
App\Entity\Franchise	No errors.

Symfony Profiler

POST https://preprod.reseauglass.fr/admin/gestion/taskTable/folder/mycancel

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping