Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.photo AS photo_7,
  t0.phone AS phone_8,
  t0.bio AS bio_9,
  t0.enabled AS enabled_10,
  t0.reference AS reference_11,
  t0.theme AS theme_12,
  t0.kanban_notification AS kanban_notification_13,
  t0.last_activity_at AS last_activity_at_14,
  t0.last_activity_source AS last_activity_source_15,
  t0.access_app AS access_app_16,
  t0.is_active AS is_active_17,
  t0.google_id AS google_id_18,
  t0.google_access_token AS google_access_token_19,
  t0.google_refresh_token AS google_refresh_token_20,
  t0.google_token_expires_at AS google_token_expires_at_21,
  t0.google_token_expires AS google_token_expires_22,
  t0.role_id AS role_id_23,
  t0.client_id AS client_id_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.photo AS photo_7, t0.phone AS phone_8, t0.bio AS bio_9, t0.enabled AS enabled_10, t0.reference AS reference_11, t0.theme AS theme_12, t0.kanban_notification AS kanban_notification_13, t0.last_activity_at AS last_activity_at_14, t0.last_activity_source AS last_activity_source_15, t0.access_app AS access_app_16, t0.is_active AS is_active_17, t0.google_id AS google_id_18, t0.google_access_token AS google_access_token_19, t0.google_refresh_token AS google_refresh_token_20, t0.google_token_expires_at AS google_token_expires_at_21, t0.google_token_expires AS google_token_expires_22, t0.role_id AS role_id_23, t0.client_id AS client_id_24 FROM user t0 WHERE t0.id = 67;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM role t0 WHERE t0.id = 2;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  last_activity_at = ?
WHERE
  id = ?

UPDATE user SET last_activity_at = '2026-09-07 11:21:58' WHERE id = 67;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.entreprise AS entreprise_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.adresse AS adresse_6,
  t0.pays AS pays_7,
  t0.logo AS logo_8,
  t0.email AS email_9,
  t0.email2 AS email2_10,
  t0.tel AS tel_11,
  t0.tel2 AS tel2_12,
  t0.fax AS fax_13,
  t0.remarques AS remarques_14,
  t0.created_at AS created_at_15,
  t0.formule AS formule_16,
  t0.entreprise_type AS entreprise_type_17,
  t0.cp AS cp_18,
  t0.ville AS ville_19,
  t0.slug AS slug_20,
  t0.avec_dossier AS avec_dossier_21,
  t0.created_by_id AS created_by_id_22
FROM
  contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.entreprise AS entreprise_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.pays AS pays_7, t0.logo AS logo_8, t0.email AS email_9, t0.email2 AS email2_10, t0.tel AS tel_11, t0.tel2 AS tel2_12, t0.fax AS fax_13, t0.remarques AS remarques_14, t0.created_at AS created_at_15, t0.formule AS formule_16, t0.entreprise_type AS entreprise_type_17, t0.cp AS cp_18, t0.ville AS ville_19, t0.slug AS slug_20, t0.avec_dossier AS avec_dossier_21, t0.created_by_id AS created_by_id_22 FROM contact t0 WHERE t0.id = 49;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.parent AS parent_4,
  t0.icon AS icon_5
FROM
  permission t0
  INNER JOIN role_permission ON t0.id = role_permission.permission_id
WHERE
  role_permission.role_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.parent AS parent_4, t0.icon AS icon_5 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = 2;

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  d0_.bg AS bg_2,
  d0_.visible AS visible_3,
  d0_.seo AS seo_4,
  d0_.api_update AS api_update_5
FROM
  dossier_status d0_

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.bg AS bg_2, d0_.visible AS visible_3, d0_.seo AS seo_4, d0_.api_update AS api_update_5 FROM dossier_status d0_;

SELECT
  u0_.id AS id_0,
  u0_.full_name AS full_name_1,
  COUNT(d1_.id) AS sclr_2
FROM
  user u0_
  LEFT JOIN dossier d1_ ON (
    d1_.manager_id = u0_.id
    AND d1_.contact_id = ?
  )
WHERE
  u0_.client_id = ?
GROUP BY
  u0_.id
ORDER BY
  u0_.full_name ASC

SELECT u0_.id AS id_0, u0_.full_name AS full_name_1, COUNT(d1_.id) AS sclr_2 FROM user u0_ LEFT JOIN dossier d1_ ON (d1_.manager_id = u0_.id AND d1_.contact_id = 49) WHERE u0_.client_id = 49 GROUP BY u0_.id ORDER BY u0_.full_name ASC;

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  COUNT(d1_.id) AS sclr_2
FROM
  dossier_status d0_
  LEFT JOIN dossier d1_ ON d0_.id = d1_.status_id
WHERE
  d1_.contact_id = ?
GROUP BY
  d0_.id

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, COUNT(d1_.id) AS sclr_2 FROM dossier_status d0_ LEFT JOIN dossier d1_ ON d0_.id = d1_.status_id WHERE d1_.contact_id = 49 GROUP BY d0_.id;

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  dossier d0_
WHERE
  d0_.contact_id = ?

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dossier d0_ WHERE d0_.contact_id = 49;

SELECT
  d0_.id AS id_0,
  d0_.libelle AS libelle_1,
  d0_.created_at AS created_at_2,
  d0_.date_reception AS date_reception_3,
  d0_.date_livraison_maquette AS date_livraison_maquette_4,
  d0_.date_production AS date_production_5,
  d0_.date_livraison AS date_livraison_6,
  d0_.description AS description_7,
  d0_.link AS link_8,
  d0_.priority AS priority_9,
  d0_.type AS type_10,
  d0_.docs AS docs_11,
  d0_.deadline AS deadline_12,
  d0_.devis AS devis_13,
  d0_.slug AS slug_14,
  d0_.link_preview AS link_preview_15,
  d0_.link_template AS link_template_16,
  d0_.facture AS facture_17,
  d0_.seo_stats AS seo_stats_18,
  d0_.bloque AS bloque_19,
  d0_.reference AS reference_20,
  d0_.id AS id_21,
  d0_.libelle AS libelle_22,
  d0_.created_at AS created_at_23,
  d0_.date_reception AS date_reception_24,
  d0_.date_livraison_maquette AS date_livraison_maquette_25,
  d0_.date_production AS date_production_26,
  d0_.date_livraison AS date_livraison_27,
  d0_.description AS description_28,
  d0_.link AS link_29,
  d0_.priority AS priority_30,
  d0_.type AS type_31,
  d0_.docs AS docs_32,
  d0_.deadline AS deadline_33,
  d0_.devis AS devis_34,
  d0_.slug AS slug_35,
  d0_.link_preview AS link_preview_36,
  d0_.link_template AS link_template_37,
  d0_.facture AS facture_38,
  d0_.seo_stats AS seo_stats_39,
  d0_.bloque AS bloque_40,
  d0_.reference AS reference_41,
  d0_.projet_id AS projet_id_42,
  d0_.contact_id AS contact_id_43,
  d0_.status_id AS status_id_44,
  d0_.created_by_id AS created_by_id_45,
  d0_.kanban_id AS kanban_id_46,
  d0_.manager_id AS manager_id_47,
  d0_.affected_to_id AS affected_to_id_48
FROM
  dossier d0_
WHERE
  d0_.contact_id = ?
ORDER BY
  d0_.id DESC
LIMIT
  25
OFFSET
  25

SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.created_at AS created_at_2, d0_.date_reception AS date_reception_3, d0_.date_livraison_maquette AS date_livraison_maquette_4, d0_.date_production AS date_production_5, d0_.date_livraison AS date_livraison_6, d0_.description AS description_7, d0_.link AS link_8, d0_.priority AS priority_9, d0_.type AS type_10, d0_.docs AS docs_11, d0_.deadline AS deadline_12, d0_.devis AS devis_13, d0_.slug AS slug_14, d0_.link_preview AS link_preview_15, d0_.link_template AS link_template_16, d0_.facture AS facture_17, d0_.seo_stats AS seo_stats_18, d0_.bloque AS bloque_19, d0_.reference AS reference_20, d0_.id AS id_21, d0_.libelle AS libelle_22, d0_.created_at AS created_at_23, d0_.date_reception AS date_reception_24, d0_.date_livraison_maquette AS date_livraison_maquette_25, d0_.date_production AS date_production_26, d0_.date_livraison AS date_livraison_27, d0_.description AS description_28, d0_.link AS link_29, d0_.priority AS priority_30, d0_.type AS type_31, d0_.docs AS docs_32, d0_.deadline AS deadline_33, d0_.devis AS devis_34, d0_.slug AS slug_35, d0_.link_preview AS link_preview_36, d0_.link_template AS link_template_37, d0_.facture AS facture_38, d0_.seo_stats AS seo_stats_39, d0_.bloque AS bloque_40, d0_.reference AS reference_41, d0_.projet_id AS projet_id_42, d0_.contact_id AS contact_id_43, d0_.status_id AS status_id_44, d0_.created_by_id AS created_by_id_45, d0_.kanban_id AS kanban_id_46, d0_.manager_id AS manager_id_47, d0_.affected_to_id AS affected_to_id_48 FROM dossier d0_ WHERE d0_.contact_id = 49 ORDER BY d0_.id DESC LIMIT 25 OFFSET 25;

SELECT
  n0_.entity_id AS entity_id_0,
  COUNT(n0_.id) AS sclr_1
FROM
  notification n0_
WHERE
  n0_.destination_id = ?
  AND n0_.vue = 0
  AND n0_.type = ?
  AND n0_.entity = ?
  AND n0_.entity_id IS NOT NULL
GROUP BY
  n0_.entity_id

SELECT n0_.entity_id AS entity_id_0, COUNT(n0_.id) AS sclr_1 FROM notification n0_ WHERE n0_.destination_id = 67 AND n0_.vue = 0 AND n0_.type = 'dossier.message' AND n0_.entity = 'Dossier' AND n0_.entity_id IS NOT NULL GROUP BY n0_.entity_id;

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  document d0_
WHERE
  d0_.entity_name = ?
  AND d0_.entity_id = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = 'dossier' AND d0_.entity_id = 56;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.photo AS photo_7,
  t0.phone AS phone_8,
  t0.bio AS bio_9,
  t0.enabled AS enabled_10,
  t0.reference AS reference_11,
  t0.theme AS theme_12,
  t0.kanban_notification AS kanban_notification_13,
  t0.last_activity_at AS last_activity_at_14,
  t0.last_activity_source AS last_activity_source_15,
  t0.access_app AS access_app_16,
  t0.is_active AS is_active_17,
  t0.google_id AS google_id_18,
  t0.google_access_token AS google_access_token_19,
  t0.google_refresh_token AS google_refresh_token_20,
  t0.google_token_expires_at AS google_token_expires_at_21,
  t0.google_token_expires AS google_token_expires_22,
  t0.role_id AS role_id_23,
  t0.client_id AS client_id_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.photo AS photo_7, t0.phone AS phone_8, t0.bio AS bio_9, t0.enabled AS enabled_10, t0.reference AS reference_11, t0.theme AS theme_12, t0.kanban_notification AS kanban_notification_13, t0.last_activity_at AS last_activity_at_14, t0.last_activity_source AS last_activity_source_15, t0.access_app AS access_app_16, t0.is_active AS is_active_17, t0.google_id AS google_id_18, t0.google_access_token AS google_access_token_19, t0.google_refresh_token AS google_refresh_token_20, t0.google_token_expires_at AS google_token_expires_at_21, t0.google_token_expires AS google_token_expires_22, t0.role_id AS role_id_23, t0.client_id AS client_id_24 FROM user t0 WHERE t0.id = 80;

SELECT
  COUNT(CASE WHEN t.box = 1 THEN
    1
  END) as todo,
  COUNT(CASE WHEN t.box = 2 THEN
    1
  END) as progress,
  COUNT(CASE WHEN t.box = 3 THEN
    1
  END) as completed,
  COUNT(t.id) as total
FROM
  kanban k
  LEFT JOIN task t ON t.kanban_id = k.id
WHERE
  k.id = ?

SELECT
                COUNT(CASE WHEN t.box = 1 THEN 1 END) as todo,
                COUNT(CASE WHEN t.box = 2 THEN 1 END) as progress,
                COUNT(CASE WHEN t.box = 3 THEN 1 END) as completed,
                COUNT(t.id) as total
            FROM kanban k
            LEFT JOIN task t ON t.kanban_id = k.id
            WHERE k.id = 0x019F3D49FDF07876B90380CDF8174E7D
        ;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t0_.title AS title_2,
  t0_.date_debut AS date_debut_3,
  t0_.date_fin AS date_fin_4,
  t0_.temps_estime AS temps_estime_5,
  t0_.description AS description_6,
  t0_.statut AS statut_7,
  t0_.created_at AS created_at_8,
  t0_.box AS box_9,
  t0_.rank AS rank_10,
  t0_.file AS file_11,
  t0_.priority AS priority_12,
  t0_.kanban_id_old AS kanban_id_old_13,
  t0_.created_by_id AS created_by_id_14,
  t0_.contrat_id AS contrat_id_15,
  t0_.projet_id AS projet_id_16,
  t0_.owner_id AS owner_id_17,
  t0_.employe_id AS employe_id_18,
  t0_.activity_id AS activity_id_19,
  t0_.kanban_id AS kanban_id_20
FROM
  task t0_
WHERE
  t0_.kanban_id = ?
  AND t0_.box = 1
ORDER BY
  t0_.rank ASC,
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = 0x019F3D49FDF07876B90380CDF8174E7D AND t0_.box = 1 ORDER BY t0_.rank ASC, t0_.created_at DESC;

SELECT
  COUNT(CASE WHEN t.box = 1 THEN
    1
  END) as todo,
  COUNT(CASE WHEN t.box = 2 THEN
    1
  END) as progress,
  COUNT(CASE WHEN t.box = 3 THEN
    1
  END) as completed,
  COUNT(t.id) as total
FROM
  kanban k
  LEFT JOIN task t ON t.kanban_id = k.id
WHERE
  k.id = ?

SELECT
                COUNT(CASE WHEN t.box = 1 THEN 1 END) as todo,
                COUNT(CASE WHEN t.box = 2 THEN 1 END) as progress,
                COUNT(CASE WHEN t.box = 3 THEN 1 END) as completed,
                COUNT(t.id) as total
            FROM kanban k
            LEFT JOIN task t ON t.kanban_id = k.id
            WHERE k.id = 0x019F3D49FDF07876B90380CDF8174E7D
        ;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t0_.title AS title_2,
  t0_.date_debut AS date_debut_3,
  t0_.date_fin AS date_fin_4,
  t0_.temps_estime AS temps_estime_5,
  t0_.description AS description_6,
  t0_.statut AS statut_7,
  t0_.created_at AS created_at_8,
  t0_.box AS box_9,
  t0_.rank AS rank_10,
  t0_.file AS file_11,
  t0_.priority AS priority_12,
  t0_.kanban_id_old AS kanban_id_old_13,
  t0_.created_by_id AS created_by_id_14,
  t0_.contrat_id AS contrat_id_15,
  t0_.projet_id AS projet_id_16,
  t0_.owner_id AS owner_id_17,
  t0_.employe_id AS employe_id_18,
  t0_.activity_id AS activity_id_19,
  t0_.kanban_id AS kanban_id_20
FROM
  task t0_
WHERE
  t0_.kanban_id = ?
  AND t0_.box = 1
ORDER BY
  t0_.rank ASC,
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.title AS title_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.temps_estime AS temps_estime_5, t0_.description AS description_6, t0_.statut AS statut_7, t0_.created_at AS created_at_8, t0_.box AS box_9, t0_.rank AS rank_10, t0_.file AS file_11, t0_.priority AS priority_12, t0_.kanban_id_old AS kanban_id_old_13, t0_.created_by_id AS created_by_id_14, t0_.contrat_id AS contrat_id_15, t0_.projet_id AS projet_id_16, t0_.owner_id AS owner_id_17, t0_.employe_id AS employe_id_18, t0_.activity_id AS activity_id_19, t0_.kanban_id AS kanban_id_20 FROM task t0_ WHERE t0_.kanban_id = 0x019F3D49FDF07876B90380CDF8174E7D AND t0_.box = 1 ORDER BY t0_.rank ASC, t0_.created_at DESC;