Symfony Profiler

[
  "route" => "task_table"
  "route_parameters" => [
    "_route" => "task_table"
    "_controller" => "App\Controller\Admin\GestionController::taskTable"
    "model" => "folder"
    "type" => "mycancel"
  ]
  "request_uri" => "https://preprod.reseauglass.fr/admin/gestion/taskTable/folder/mycancel"
  "method" => "POST"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 54320
    "user" => "reso"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "13"
    "defaultTableOptions" => []
    "dbname" => "resoglass_preprod_2"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 640
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "rolesignature@reseauglass.fr"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "ip" => "196.206.89.0"
  "user_agent" => "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.7204.15 Safari/537.36"
  "path" => "/admin/gestion/taskTable/folder/mycancel"
  "live_action" => null
  "query_params" => []
  "post_params" => [
    "draw" => "2"
    "columns" => [
      [
        "data" => "0"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "1"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "2"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "3"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "4"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "5"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "6"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "7"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "8"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
      [
        "data" => "9"
        "name" => ""
        "searchable" => "true"
        "orderable" => "true"
        "search" => [
          "value" => ""
          "regex" => "false"
        ]
      ]
    ]
    "order" => [
      [
        "column" => "7"
        "dir" => "asc"
        "name" => ""
      ]
    ]
    "start" => "0"
    "length" => "25"
    "search" => [
      "value" => ""
      "regex" => "false"
    ]
    "searchByAlert" => [
      "value" => ""
    ]
    "searchByInvoice" => [
      "value" => ""
    ]
    "searchBySigned" => [
      "value" => ""
    ]
    "searchByGroup" => [
      "value" => ""
    ]
    "searchByInsurAvailability" => [
      "value" => ""
    ]
  ]
  "user" => [
    "id" => 640
    "email" => "rolesignature@reseauglass.fr"
    "roles" => [
      "ROLE_SIGNATURE"
    ]
  ]
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\AccessLoggerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\ImageFixWidthSubscriber::onImageUpload"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\CompanyIdSubscriber::onKernelRequest"
]

[
  "sql" => "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)"
]

[
  "sql" => "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"
  "params" => [
    1 => "Assurance"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1 FROM companie c0_ WHERE c0_.is_active = true AND c0_.category_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 640
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "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"
  "params" => [
    1 => "11:25:52"
    2 => "11:25:52"
    3 => "11:25:52"
    4 => "11:25:52"
    5 => "11:25:52"
    6 => "11:25:52"
    7 => 640
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "11:25:52"
    2 => "11:25:52"
    3 => "11:25:52"
    4 => "11:25:52"
    5 => "11:25:52"
    6 => "11:25:52"
    7 => 640
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "11:25:52"
    2 => "11:25:52"
    3 => "11:25:52"
    4 => "11:25:52"
    5 => "11:25:52"
    6 => "11:25:52"
    7 => 640
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentTypeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Mercure\EventSubscriber\SetCookieSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\UX\LiveComponent\EventListener\LiveUrlSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]