Symfony Profiler

SELECT
  t0_.id AS id_0,
  r1_.label AS label_1,
  r1_.type AS type_2,
  r1_.slug AS slug_3,
  t0_.date AS date_4
FROM
  tasks_status_history t0_
  LEFT JOIN task t2_ ON t0_.task_id = t2_.id
  LEFT JOIN ref_status r1_ ON t0_.status_id = r1_.id
WHERE
  t2_.id LIKE ?
ORDER BY
  t0_.date DESC,
  t0_.id DESC
LIMIT
  1

SELECT t0_.id AS id_0, r1_.label AS label_1, r1_.type AS type_2, r1_.slug AS slug_3, t0_.date AS date_4 FROM tasks_status_history t0_ LEFT JOIN task t2_ ON t0_.task_id = t2_.id LEFT JOIN ref_status r1_ ON t0_.status_id = r1_.id WHERE t2_.id LIKE 434 ORDER BY t0_.date DESC, t0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.successive_carriers AS successive_carriers_2,
  t0.custom_formalities AS custom_formalities_3,
  t0.instructions AS instructions_4,
  t0.seal_number AS seal_number_5,
  t0.cmr AS cmr_6,
  t0.mission AS mission_7,
  t0.presta_ann_sender_planned AS presta_ann_sender_planned_8,
  t0.presta_ann_consignee_planned AS presta_ann_consignee_planned_9,
  t0.attached_docs AS attached_docs_10,
  t0.planned_at AS planned_at_11,
  t0.pallet_europe AS pallet_europe_12,
  t0.pallet_other AS pallet_other_13,
  t0.pallet_80_120 AS pallet_80_120_14,
  t0.pallet_100_120 AS pallet_100_120_15,
  t0.created_at AS created_at_16,
  t0.is_tournee_associated AS is_tournee_associated_17,
  t0.contractor_id AS contractor_id_18,
  t0.consignee_id AS consignee_id_19,
  t0.sender_id AS sender_id_20,
  t0.carrier_id AS carrier_id_21,
  t0.created_by_id AS created_by_id_22
FROM
  task t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.successive_carriers AS successive_carriers_2, t0.custom_formalities AS custom_formalities_3, t0.instructions AS instructions_4, t0.seal_number AS seal_number_5, t0.cmr AS cmr_6, t0.mission AS mission_7, t0.presta_ann_sender_planned AS presta_ann_sender_planned_8, t0.presta_ann_consignee_planned AS presta_ann_consignee_planned_9, t0.attached_docs AS attached_docs_10, t0.planned_at AS planned_at_11, t0.pallet_europe AS pallet_europe_12, t0.pallet_other AS pallet_other_13, t0.pallet_80_120 AS pallet_80_120_14, t0.pallet_100_120 AS pallet_100_120_15, t0.created_at AS created_at_16, t0.is_tournee_associated AS is_tournee_associated_17, t0.contractor_id AS contractor_id_18, t0.consignee_id AS consignee_id_19, t0.sender_id AS sender_id_20, t0.carrier_id AS carrier_id_21, t0.created_by_id AS created_by_id_22 FROM task t0 WHERE t0.id = 434 LIMIT 1;

SELECT
  DISTINCT(t.id),
  c.company_name AS expediteur,
  c.adr1 AS adresse_exp,
  c.cp_zip AS cp_exp,
  c.city AS city_exp,
  d.company_name AS destinataire,
  d.adr1 AS adresse_dest,
  dr.id AS driver_id,
  td.display_order,
  d.cp_zip AS cp_dest,
  d.city AS city_dest,
  c.tel1 AS tel1Exp,
  c.tel2 AS tel2Exp,
  d.tel1 AS tel1Dest,
  d.tel2 AS tel2Dest,
  t.mission,
  t.planned_at,
  t.is_tournee_associated
FROM
  task t
  LEFT JOIN task_vehicule tv ON tv.task_id = t.id
  LEFT JOIN vehicules v ON v.id = tv.vehicule_id
  LEFT JOIN companys c ON c.id = t.sender_id
  LEFT JOIN companys d ON d.id = t.consignee_id
  LEFT JOIN carriers crr ON crr.id = t.carrier_id
  LEFT JOIN task_driver td ON td.task_id = t.id
  LEFT JOIN drivers dr ON dr.id = td.driver_id
  LEFT JOIN user u ON u.driver_id = dr.id
WHERE
  crr.id = 82
  AND u.id = 142

SELECT 
                            DISTINCT(t.id), c.company_name AS expediteur, c.adr1 AS adresse_exp, c.cp_zip AS cp_exp, 
                            c.city AS city_exp, d.company_name AS destinataire, d.adr1 AS adresse_dest, dr.id AS driver_id, td.display_order,
                            d.cp_zip AS cp_dest, d.city AS city_dest, c.tel1 AS tel1Exp, c.tel2 AS tel2Exp, d.tel1 AS tel1Dest, d.tel2 AS tel2Dest,
                        t.mission, t.planned_at, t.is_tournee_associated
                        FROM task t 
                        LEFT JOIN task_vehicule tv ON tv.task_id = t.id
                        LEFT JOIN vehicules v ON v.id = tv.vehicule_id
                        LEFT JOIN companys c ON c.id = t.sender_id 
                        LEFT JOIN companys d ON d.id = t.consignee_id
                        LEFT JOIN carriers crr ON crr.id = t.carrier_id
                        LEFT JOIN task_driver td ON td.task_id = t.id
                        LEFT JOIN drivers dr ON dr.id = td.driver_id                      
                        LEFT JOIN user u ON u.driver_id = dr.id                      
                        WHERE crr.id = 82
                        AND u.id = 142
                        ;

SELECT
  t0.id AS id_1,
  t0.possible_reservations AS possible_reservations_2,
  t0.type AS type_3,
  t0.task_id AS task_id_4,
  t0.sender_id AS sender_id_5,
  t0.consignee_id AS consignee_id_6,
  t0.driver_id AS driver_id_7,
  t0.carrier_id AS carrier_id_8
FROM
  `litiges` t0
WHERE
  t0.task_id = ?

SELECT t0.id AS id_1, t0.possible_reservations AS possible_reservations_2, t0.type AS type_3, t0.task_id AS task_id_4, t0.sender_id AS sender_id_5, t0.consignee_id AS consignee_id_6, t0.driver_id AS driver_id_7, t0.carrier_id AS carrier_id_8 FROM `litiges` t0 WHERE t0.task_id = 434;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_name AS last_name_5,
  t0.first_name AS first_name_6,
  t0.tel AS tel_7,
  t0.mobile AS mobile_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.last_cnx_at AS last_cnx_at_12,
  t0.is_verified AS is_verified_13,
  t0.is_main_user AS is_main_user_14,
  t0.reset_token AS reset_token_15,
  t0.last_activity_at AS last_activity_at_16,
  t0.contact_mailjet AS contact_mailjet_17,
  t0.first_login AS first_login_18,
  t0.consentement_transmission_geographique AS consentement_transmission_geographique_19,
  t0.id_jira_account AS id_jira_account_20,
  t0.is_demo_user AS is_demo_user_21,
  t0.carriers_id AS carriers_id_22,
  t0.driver_id AS driver_id_23,
  t0.ref_country_id AS ref_country_id_24
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.tel AS tel_7, t0.mobile AS mobile_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.last_cnx_at AS last_cnx_at_12, t0.is_verified AS is_verified_13, t0.is_main_user AS is_main_user_14, t0.reset_token AS reset_token_15, t0.last_activity_at AS last_activity_at_16, t0.contact_mailjet AS contact_mailjet_17, t0.first_login AS first_login_18, t0.consentement_transmission_geographique AS consentement_transmission_geographique_19, t0.id_jira_account AS id_jira_account_20, t0.is_demo_user AS is_demo_user_21, t0.carriers_id AS carriers_id_22, t0.driver_id AS driver_id_23, t0.ref_country_id AS ref_country_id_24 FROM user t0 WHERE t0.email = 'chauffeur1@docutrans.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_name AS last_name_5,
  t0.first_name AS first_name_6,
  t0.tel AS tel_7,
  t0.mobile AS mobile_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.last_cnx_at AS last_cnx_at_12,
  t0.is_verified AS is_verified_13,
  t0.is_main_user AS is_main_user_14,
  t0.reset_token AS reset_token_15,
  t0.last_activity_at AS last_activity_at_16,
  t0.contact_mailjet AS contact_mailjet_17,
  t0.first_login AS first_login_18,
  t0.consentement_transmission_geographique AS consentement_transmission_geographique_19,
  t0.id_jira_account AS id_jira_account_20,
  t0.is_demo_user AS is_demo_user_21,
  t0.carriers_id AS carriers_id_22,
  t0.driver_id AS driver_id_23,
  t0.ref_country_id AS ref_country_id_24
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.tel AS tel_7, t0.mobile AS mobile_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.last_cnx_at AS last_cnx_at_12, t0.is_verified AS is_verified_13, t0.is_main_user AS is_main_user_14, t0.reset_token AS reset_token_15, t0.last_activity_at AS last_activity_at_16, t0.contact_mailjet AS contact_mailjet_17, t0.first_login AS first_login_18, t0.consentement_transmission_geographique AS consentement_transmission_geographique_19, t0.id_jira_account AS id_jira_account_20, t0.is_demo_user AS is_demo_user_21, t0.carriers_id AS carriers_id_22, t0.driver_id AS driver_id_23, t0.ref_country_id AS ref_country_id_24 FROM user t0 WHERE t0.id = 142 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  last_activity_at = ?
WHERE
  id = ?

UPDATE user SET last_activity_at = '2026-11-12 15:25:35' WHERE id = 142;

"COMMIT"

"COMMIT";