Symfony Profiler

Query Metrics

245 Database Queries
26 Different statements
73.02 ms Query time
7 Invalid entities
142 Managed entities
Queries


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.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM role t0 WHERE t0.id = ?
"START TRANSACTION"
UPDATE user SET last_activity_at = ? WHERE id = ?
"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.slug = ? LIMIT 1
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 = ?
SHOW TABLE STATUS WHERE `Name` = 'dossier'
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.avec_dossier = ?
SELECT count(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.destination_id = ? AND n0_.vue = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.meta AS meta_4, t0.date AS date_5, t0.text AS text_6, t0.entity AS entity_7, t0.entity_id AS entity_id_8, t0.link AS link_9, t0.vue AS vue_10, t0.send AS send_11, t0.owner_id AS owner_id_12, t0.destination_id AS destination_id_13 FROM notification t0 WHERE t0.destination_id = ? ORDER BY t0.date DESC LIMIT 10
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 = ?
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 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 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 COUNT(DISTINCT d0_.id) AS sclr_0 FROM dossier d0_ WHERE d0_.contact_id = ?
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
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 COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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 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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.entity_name = ? AND d0_.entity_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 = ?
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
                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 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 = ? AND t0_.box = 2 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 = ? AND t0_.box = 3 ORDER BY t0_.rank ASC, t0_.created_at DESC
SELECT COUNT(t0_.id) AS sclr_0 FROM kanban k1_ LEFT JOIN task t0_ ON k1_.id = t0_.kanban_id WHERE k1_.id = ?
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.dossier_id AS dossier_id_7 FROM dossier_meta t0 WHERE t0.dossier_id = ? AND t0.meta_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.bg AS bg_3, t0.visible AS visible_4, t0.seo AS seo_5, t0.api_update AS api_update_6 FROM dossier_status t0
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_.projet_id AS projet_id_21, d0_.contact_id AS contact_id_22, d0_.status_id AS status_id_23, d0_.created_by_id AS created_by_id_24, d0_.kanban_id AS kanban_id_25, d0_.manager_id AS manager_id_26, d0_.affected_to_id AS affected_to_id_27 FROM dossier d0_ WHERE d0_.contact_id = ? ORDER BY d0_.created_at DESC
SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dossier d0_ WHERE d0_.contact_id = ?
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
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\DossierMeta	68
App\Entity\Dossier	17
App\Entity\Kanban	17
App\Entity\DossierStatus	12
App\Entity\Notification	10
App\Entity\User	6
App\Entity\Permission	5
App\Entity\Contact	4
App\Entity\Role	3
Entities Mapping

Class	Mapping errors
App\Entity\User	The association App\Entity\User#role refers to the inverse side field App\Entity\Role#user which does not exist.
App\Entity\Role	No errors.
App\Entity\Contact	The mappings App\Entity\Contact#dossiers and App\Entity\Dossier#contact are inconsistent with each other.
App\Entity\UserMeta	No errors.
App\Entity\Permission	No errors.
App\Entity\Dossier	The association App\Entity\Dossier#projet refers to the inverse side field App\Entity\Projet#dossiers which does not exist. The association App\Entity\Dossier#contact refers to the inverse side field App\Entity\Contact#contact which does not exist. The field App\Entity\Dossier#kanban is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Kanban#dossier does not contain the required 'mappedBy: "kanban"' attribute. The field App\Entity\Dossier#statusHistories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DossierStatusHistory#dossier does not contain the required 'inversedBy: "statusHistories"' attribute.
App\Entity\Notification	No errors.
App\Entity\DossierStatus	The field App\Entity\DossierStatus#dossiers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Dossier#status does not contain the required 'inversedBy: "dossiers"' attribute.
App\Entity\Projet	The association App\Entity\Projet#client refers to the inverse side field App\Entity\Contact#projet which does not exist.
App\Entity\Kanban	The association App\Entity\Kanban#contrat refers to the inverse side field App\Entity\Contrat#kanbans which does not exist. The field App\Entity\Kanban#dossier is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Dossier#kanban does not contain the required 'mappedBy: "dossier"' attribute.
App\Entity\Quote	No errors.
App\Entity\DossierMeta	No errors.
App\Entity\DossierStatusHistory	No errors.
App\Entity\Document	No errors.
App\Entity\Task	No errors.
App\Entity\Contrat	The association App\Entity\Contrat#contact refers to the inverse side field App\Entity\Contact#contrat which does not exist.
App\Entity\TaskActivity	No errors.
Symfony Profiler

GET https://crm.blue-web-agency.fr/dossier/oscp

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
