| 1 |
0.72 ms |
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = ? LIMIT 1
Parameters: [
"2963574603"
]
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = '2963574603' LIMIT 1;
|
| 2 |
0.60 ms |
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = ? LIMIT 1
Parameters: [
"2963574603"
]
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = '2963574603' LIMIT 1;
|
| 3 |
0.66 ms |
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = ? LIMIT 1
Parameters: [
"2963574603"
]
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = '2963574603' LIMIT 1;
|
| 4 |
0.22 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 5 |
0.55 ms |
UPDATE pointage SET updated_at = ? WHERE id = ?
Parameters: [
"2026-06-03 12:54:30"
93
]
UPDATE pointage SET updated_at = '2026-06-03 12:54:30' WHERE id = 93;
|
| 6 |
1.05 ms |
"COMMIT"
|
| 7 |
0.43 ms |
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = ? LIMIT 1
Parameters: [
"2963574603"
]
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.monday_item_name AS monday_item_name_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.work_date AS work_date_6, t0.personnel_item_id AS personnel_item_id_7, t0.monday_user_id AS monday_user_id_8, t0.affaire_item_id AS affaire_item_id_9, t0.activite_item_id AS activite_item_id_10, t0.task_planning_item_id AS task_planning_item_id_11, t0.absence_code AS absence_code_12, t0.absence_unit AS absence_unit_13, t0.worked_hours AS worked_hours_14, t0.travel_hours AS travel_hours_15, t0.prime_chantier AS prime_chantier_16, t0.deplacement_code AS deplacement_code_17, t0.is_injected AS is_injected_18, t0.injected_at AS injected_at_19, t0.last_snapshot AS last_snapshot_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.personnel_matricule AS personnel_matricule_23, t0.employee_status AS employee_status_24 FROM pointage t0 WHERE t0.monday_item_id = '2963574603' LIMIT 1;
|
| 8 |
0.46 ms |
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.snapshot_type AS snapshot_type_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.payload AS payload_6, t0.source AS source_7, t0.created_at AS created_at_8, t0.personnel_matricule AS personnel_matricule_9, t0.employee_status AS employee_status_10, t0.pointage_id AS pointage_id_11 FROM pointage_snapshot t0 WHERE t0.pointage_id = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.monday_item_id AS monday_item_id_2, t0.snapshot_type AS snapshot_type_3, t0.workflow AS workflow_4, t0.injection_planning_status AS injection_planning_status_5, t0.payload AS payload_6, t0.source AS source_7, t0.created_at AS created_at_8, t0.personnel_matricule AS personnel_matricule_9, t0.employee_status AS employee_status_10, t0.pointage_id AS pointage_id_11 FROM pointage_snapshot t0 WHERE t0.pointage_id = 93 ORDER BY t0.created_at DESC;
|
| 9 |
0.13 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 10 |
0.40 ms |
INSERT INTO pointage_snapshot (monday_item_id, snapshot_type, workflow, injection_planning_status, payload, source, created_at, personnel_matricule, employee_status, pointage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"2963574603"
"dirty"
"À valider"
null
"{"mondayItemId":"2963574603","_dirty":true,"_dirty_reason":"monday_business_column_changed","_dirty_at":"2026-06-03T12:54:30+02:00"}"
"monday_business_column_changed"
"2026-06-03 12:54:30"
null
null
93
]
INSERT INTO pointage_snapshot (monday_item_id, snapshot_type, workflow, injection_planning_status, payload, source, created_at, personnel_matricule, employee_status, pointage_id) VALUES ('2963574603', 'dirty', 'À valider', NULL, '{\"mondayItemId\":\"2963574603\",\"_dirty\":true,\"_dirty_reason\":\"monday_business_column_changed\",\"_dirty_at\":\"2026-06-03T12:54:30+02:00\"}', 'monday_business_column_changed', '2026-06-03 12:54:30', NULL, NULL, 93);
|
| 11 |
0.48 ms |
UPDATE pointage SET last_snapshot = ?, updated_at = ? WHERE id = ?
Parameters: [
"{"mondayItemId":"2963574603","_dirty":true,"_dirty_reason":"monday_business_column_changed","_dirty_at":"2026-06-03T12:54:30+02:00"}"
"2026-06-03 12:54:30"
93
]
UPDATE pointage SET last_snapshot = '{\"mondayItemId\":\"2963574603\",\"_dirty\":true,\"_dirty_reason\":\"monday_business_column_changed\",\"_dirty_at\":\"2026-06-03T12:54:30+02:00\"}', updated_at = '2026-06-03 12:54:30' WHERE id = 93;
|
| 12 |
0.90 ms |
"COMMIT"
|