Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.categorie AS categorie_1,
  r0_.titre AS titre_2,
  r0_.auteur AS auteur_3,
  r0_.description AS description_4,
  r0_.is_public AS is_public_5,
  r0_.date_debut AS date_debut_6,
  r0_.date_expiration AS date_expiration_7,
  r0_.image AS image_8,
  r0_.ressource AS ressource_9,
  r0_.status AS status_10,
  r0_.user_id AS user_id_11
FROM
  ressources r0_
WHERE
  r0_.is_public = 1
  AND (
    r0_.date_expiration > ?
    OR r0_.date_expiration IS NULL
  )
ORDER BY
  r0_.id DESC

SELECT r0_.id AS id_0, r0_.categorie AS categorie_1, r0_.titre AS titre_2, r0_.auteur AS auteur_3, r0_.description AS description_4, r0_.is_public AS is_public_5, r0_.date_debut AS date_debut_6, r0_.date_expiration AS date_expiration_7, r0_.image AS image_8, r0_.ressource AS ressource_9, r0_.status AS status_10, r0_.user_id AS user_id_11 FROM ressources r0_ WHERE r0_.is_public = 1 AND (r0_.date_expiration > '2026-03-12 12:12:06' OR r0_.date_expiration IS NULL) ORDER BY r0_.id DESC;

SELECT
  t0.id AS id_8,
  t0.email AS email_9,
  t0.username AS username_10,
  t0.password AS password_11,
  t0.roles AS roles_12,
  t0.is_verified AS is_verified_13,
  t0.token_reset AS token_reset_14,
  t0.is_deleted AS is_deleted_15,
  t0.type,
  t1.nom AS nom_16,
  t1.prenom AS prenom_17,
  t1.tel AS tel_18,
  t1.fonction AS fonction_19,
  t1.autre AS autre_20,
  t1.fonctions AS fonctions_21,
  t1.gouvernorat_id AS gouvernorat_id_22,
  t2.type_partenaire AS type_partenaire_23,
  t2.nombre_entreprise AS nombre_entreprise_24,
  t2.cnsscnrps AS cnsscnrps_25,
  t2.code_cnss AS code_cnss_26,
  t2.secteur AS secteur_27,
  t2.branche AS branche_28,
  t2.fax AS fax_29,
  t2.tel AS tel_30,
  t2.nom_prenom_president AS nom_prenom_president_31,
  t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32,
  t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33,
  t2.nom AS nom_34,
  t2.file_name AS file_name_35,
  t2.original_file_name AS original_file_name_36,
  t2.gouvernorat_id AS gouvernorat_id_37,
  t2.delegation_id AS delegation_id_38,
  t3.matricule_fiscal AS matricule_fiscal_39,
  t3.nom_commercial AS nom_commercial_40,
  t3.fax AS fax_41,
  t3.code_cnss AS code_cnss_42,
  t3.cnsscnrps AS cnsscnrps_43,
  t3.secteur AS secteur_44,
  t3.branche AS branche_45,
  t3.produits_services_rendus AS produits_services_rendus_46,
  t3.statut AS statut_47,
  t3.exportatrice AS exportatrice_48,
  t3.off_shore AS off_shore_49,
  t3.taux_tfp AS taux_tfp_50,
  t3.regime_travail AS regime_travail_51,
  t3.tel AS tel_52,
  t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53,
  t3.raison_sociale AS raison_sociale_54,
  t3.montant AS montant_55,
  t3.adresse_siege_social AS adresse_siege_social_56,
  t3.adresse_site_production AS adresse_site_production_57,
  t3.gouvernorat_id AS gouvernorat_id_58,
  t3.delegation_id AS delegation_id_59,
  t4.tel AS tel_60,
  t4.nom AS nom_61,
  t4.prenom AS prenom_62,
  t4.ministere AS ministere_63,
  t4.direction AS direction_64,
  t4.gouvernorat_id AS gouvernorat_id_65,
  t5.nom AS nom_66,
  t5.prenom AS prenom_67,
  t5.tel AS tel_68,
  t5.unite_regional_id AS unite_regional_id_69,
  t6.nom AS nom_70,
  t6.prenom AS prenom_71,
  t6.tel AS tel_72,
  t6.nom_administration AS nom_administration_73,
  t6.regional AS regional_74,
  t6.unite AS unite_75,
  t6.fonction AS fonction_76,
  t7.nom AS nom_77,
  t7.prenom AS prenom_78,
  t7.tel AS tel_79,
  t7.gouvernorat_id AS gouvernorat_id_80
FROM
  user t0
  LEFT JOIN particulier t1 ON t0.id = t1.id
  LEFT JOIN partenaire t2 ON t0.id = t2.id
  LEFT JOIN entreprise t3 ON t0.id = t3.id
  LEFT JOIN dae t4 ON t0.id = t4.id
  LEFT JOIN charge_assistance t5 ON t0.id = t5.id
  LEFT JOIN agent_interne t6 ON t0.id = t6.id
  LEFT JOIN autres t7 ON t0.id = t7.id
WHERE
  t0.id = ?

SELECT t0.id AS id_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.token_reset AS token_reset_14, t0.is_deleted AS is_deleted_15, t0.type, t1.nom AS nom_16, t1.prenom AS prenom_17, t1.tel AS tel_18, t1.fonction AS fonction_19, t1.autre AS autre_20, t1.fonctions AS fonctions_21, t1.gouvernorat_id AS gouvernorat_id_22, t2.type_partenaire AS type_partenaire_23, t2.nombre_entreprise AS nombre_entreprise_24, t2.cnsscnrps AS cnsscnrps_25, t2.code_cnss AS code_cnss_26, t2.secteur AS secteur_27, t2.branche AS branche_28, t2.fax AS fax_29, t2.tel AS tel_30, t2.nom_prenom_president AS nom_prenom_president_31, t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32, t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33, t2.nom AS nom_34, t2.file_name AS file_name_35, t2.original_file_name AS original_file_name_36, t2.gouvernorat_id AS gouvernorat_id_37, t2.delegation_id AS delegation_id_38, t3.matricule_fiscal AS matricule_fiscal_39, t3.nom_commercial AS nom_commercial_40, t3.fax AS fax_41, t3.code_cnss AS code_cnss_42, t3.cnsscnrps AS cnsscnrps_43, t3.secteur AS secteur_44, t3.branche AS branche_45, t3.produits_services_rendus AS produits_services_rendus_46, t3.statut AS statut_47, t3.exportatrice AS exportatrice_48, t3.off_shore AS off_shore_49, t3.taux_tfp AS taux_tfp_50, t3.regime_travail AS regime_travail_51, t3.tel AS tel_52, t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53, t3.raison_sociale AS raison_sociale_54, t3.montant AS montant_55, t3.adresse_siege_social AS adresse_siege_social_56, t3.adresse_site_production AS adresse_site_production_57, t3.gouvernorat_id AS gouvernorat_id_58, t3.delegation_id AS delegation_id_59, t4.tel AS tel_60, t4.nom AS nom_61, t4.prenom AS prenom_62, t4.ministere AS ministere_63, t4.direction AS direction_64, t4.gouvernorat_id AS gouvernorat_id_65, t5.nom AS nom_66, t5.prenom AS prenom_67, t5.tel AS tel_68, t5.unite_regional_id AS unite_regional_id_69, t6.nom AS nom_70, t6.prenom AS prenom_71, t6.tel AS tel_72, t6.nom_administration AS nom_administration_73, t6.regional AS regional_74, t6.unite AS unite_75, t6.fonction AS fonction_76, t7.nom AS nom_77, t7.prenom AS prenom_78, t7.tel AS tel_79, t7.gouvernorat_id AS gouvernorat_id_80 FROM user t0 LEFT JOIN particulier t1 ON t0.id = t1.id LEFT JOIN partenaire t2 ON t0.id = t2.id LEFT JOIN entreprise t3 ON t0.id = t3.id LEFT JOIN dae t4 ON t0.id = t4.id LEFT JOIN charge_assistance t5 ON t0.id = t5.id LEFT JOIN agent_interne t6 ON t0.id = t6.id LEFT JOIN autres t7 ON t0.id = t7.id WHERE t0.id = 18;

SELECT
  t0.id AS id_8,
  t0.email AS email_9,
  t0.username AS username_10,
  t0.password AS password_11,
  t0.roles AS roles_12,
  t0.is_verified AS is_verified_13,
  t0.token_reset AS token_reset_14,
  t0.is_deleted AS is_deleted_15,
  t0.type,
  t1.nom AS nom_16,
  t1.prenom AS prenom_17,
  t1.tel AS tel_18,
  t1.fonction AS fonction_19,
  t1.autre AS autre_20,
  t1.fonctions AS fonctions_21,
  t1.gouvernorat_id AS gouvernorat_id_22,
  t2.type_partenaire AS type_partenaire_23,
  t2.nombre_entreprise AS nombre_entreprise_24,
  t2.cnsscnrps AS cnsscnrps_25,
  t2.code_cnss AS code_cnss_26,
  t2.secteur AS secteur_27,
  t2.branche AS branche_28,
  t2.fax AS fax_29,
  t2.tel AS tel_30,
  t2.nom_prenom_president AS nom_prenom_president_31,
  t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32,
  t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33,
  t2.nom AS nom_34,
  t2.file_name AS file_name_35,
  t2.original_file_name AS original_file_name_36,
  t2.gouvernorat_id AS gouvernorat_id_37,
  t2.delegation_id AS delegation_id_38,
  t3.matricule_fiscal AS matricule_fiscal_39,
  t3.nom_commercial AS nom_commercial_40,
  t3.fax AS fax_41,
  t3.code_cnss AS code_cnss_42,
  t3.cnsscnrps AS cnsscnrps_43,
  t3.secteur AS secteur_44,
  t3.branche AS branche_45,
  t3.produits_services_rendus AS produits_services_rendus_46,
  t3.statut AS statut_47,
  t3.exportatrice AS exportatrice_48,
  t3.off_shore AS off_shore_49,
  t3.taux_tfp AS taux_tfp_50,
  t3.regime_travail AS regime_travail_51,
  t3.tel AS tel_52,
  t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53,
  t3.raison_sociale AS raison_sociale_54,
  t3.montant AS montant_55,
  t3.adresse_siege_social AS adresse_siege_social_56,
  t3.adresse_site_production AS adresse_site_production_57,
  t3.gouvernorat_id AS gouvernorat_id_58,
  t3.delegation_id AS delegation_id_59,
  t4.tel AS tel_60,
  t4.nom AS nom_61,
  t4.prenom AS prenom_62,
  t4.ministere AS ministere_63,
  t4.direction AS direction_64,
  t4.gouvernorat_id AS gouvernorat_id_65,
  t5.nom AS nom_66,
  t5.prenom AS prenom_67,
  t5.tel AS tel_68,
  t5.unite_regional_id AS unite_regional_id_69,
  t6.nom AS nom_70,
  t6.prenom AS prenom_71,
  t6.tel AS tel_72,
  t6.nom_administration AS nom_administration_73,
  t6.regional AS regional_74,
  t6.unite AS unite_75,
  t6.fonction AS fonction_76,
  t7.nom AS nom_77,
  t7.prenom AS prenom_78,
  t7.tel AS tel_79,
  t7.gouvernorat_id AS gouvernorat_id_80
FROM
  user t0
  LEFT JOIN particulier t1 ON t0.id = t1.id
  LEFT JOIN partenaire t2 ON t0.id = t2.id
  LEFT JOIN entreprise t3 ON t0.id = t3.id
  LEFT JOIN dae t4 ON t0.id = t4.id
  LEFT JOIN charge_assistance t5 ON t0.id = t5.id
  LEFT JOIN agent_interne t6 ON t0.id = t6.id
  LEFT JOIN autres t7 ON t0.id = t7.id
WHERE
  t0.id = ?

SELECT t0.id AS id_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.token_reset AS token_reset_14, t0.is_deleted AS is_deleted_15, t0.type, t1.nom AS nom_16, t1.prenom AS prenom_17, t1.tel AS tel_18, t1.fonction AS fonction_19, t1.autre AS autre_20, t1.fonctions AS fonctions_21, t1.gouvernorat_id AS gouvernorat_id_22, t2.type_partenaire AS type_partenaire_23, t2.nombre_entreprise AS nombre_entreprise_24, t2.cnsscnrps AS cnsscnrps_25, t2.code_cnss AS code_cnss_26, t2.secteur AS secteur_27, t2.branche AS branche_28, t2.fax AS fax_29, t2.tel AS tel_30, t2.nom_prenom_president AS nom_prenom_president_31, t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32, t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33, t2.nom AS nom_34, t2.file_name AS file_name_35, t2.original_file_name AS original_file_name_36, t2.gouvernorat_id AS gouvernorat_id_37, t2.delegation_id AS delegation_id_38, t3.matricule_fiscal AS matricule_fiscal_39, t3.nom_commercial AS nom_commercial_40, t3.fax AS fax_41, t3.code_cnss AS code_cnss_42, t3.cnsscnrps AS cnsscnrps_43, t3.secteur AS secteur_44, t3.branche AS branche_45, t3.produits_services_rendus AS produits_services_rendus_46, t3.statut AS statut_47, t3.exportatrice AS exportatrice_48, t3.off_shore AS off_shore_49, t3.taux_tfp AS taux_tfp_50, t3.regime_travail AS regime_travail_51, t3.tel AS tel_52, t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53, t3.raison_sociale AS raison_sociale_54, t3.montant AS montant_55, t3.adresse_siege_social AS adresse_siege_social_56, t3.adresse_site_production AS adresse_site_production_57, t3.gouvernorat_id AS gouvernorat_id_58, t3.delegation_id AS delegation_id_59, t4.tel AS tel_60, t4.nom AS nom_61, t4.prenom AS prenom_62, t4.ministere AS ministere_63, t4.direction AS direction_64, t4.gouvernorat_id AS gouvernorat_id_65, t5.nom AS nom_66, t5.prenom AS prenom_67, t5.tel AS tel_68, t5.unite_regional_id AS unite_regional_id_69, t6.nom AS nom_70, t6.prenom AS prenom_71, t6.tel AS tel_72, t6.nom_administration AS nom_administration_73, t6.regional AS regional_74, t6.unite AS unite_75, t6.fonction AS fonction_76, t7.nom AS nom_77, t7.prenom AS prenom_78, t7.tel AS tel_79, t7.gouvernorat_id AS gouvernorat_id_80 FROM user t0 LEFT JOIN particulier t1 ON t0.id = t1.id LEFT JOIN partenaire t2 ON t0.id = t2.id LEFT JOIN entreprise t3 ON t0.id = t3.id LEFT JOIN dae t4 ON t0.id = t4.id LEFT JOIN charge_assistance t5 ON t0.id = t5.id LEFT JOIN agent_interne t6 ON t0.id = t6.id LEFT JOIN autres t7 ON t0.id = t7.id WHERE t0.id = 99;

SELECT
  t0.id AS id_8,
  t0.email AS email_9,
  t0.username AS username_10,
  t0.password AS password_11,
  t0.roles AS roles_12,
  t0.is_verified AS is_verified_13,
  t0.token_reset AS token_reset_14,
  t0.is_deleted AS is_deleted_15,
  t0.type,
  t1.nom AS nom_16,
  t1.prenom AS prenom_17,
  t1.tel AS tel_18,
  t1.fonction AS fonction_19,
  t1.autre AS autre_20,
  t1.fonctions AS fonctions_21,
  t1.gouvernorat_id AS gouvernorat_id_22,
  t2.type_partenaire AS type_partenaire_23,
  t2.nombre_entreprise AS nombre_entreprise_24,
  t2.cnsscnrps AS cnsscnrps_25,
  t2.code_cnss AS code_cnss_26,
  t2.secteur AS secteur_27,
  t2.branche AS branche_28,
  t2.fax AS fax_29,
  t2.tel AS tel_30,
  t2.nom_prenom_president AS nom_prenom_president_31,
  t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32,
  t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33,
  t2.nom AS nom_34,
  t2.file_name AS file_name_35,
  t2.original_file_name AS original_file_name_36,
  t2.gouvernorat_id AS gouvernorat_id_37,
  t2.delegation_id AS delegation_id_38,
  t3.matricule_fiscal AS matricule_fiscal_39,
  t3.nom_commercial AS nom_commercial_40,
  t3.fax AS fax_41,
  t3.code_cnss AS code_cnss_42,
  t3.cnsscnrps AS cnsscnrps_43,
  t3.secteur AS secteur_44,
  t3.branche AS branche_45,
  t3.produits_services_rendus AS produits_services_rendus_46,
  t3.statut AS statut_47,
  t3.exportatrice AS exportatrice_48,
  t3.off_shore AS off_shore_49,
  t3.taux_tfp AS taux_tfp_50,
  t3.regime_travail AS regime_travail_51,
  t3.tel AS tel_52,
  t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53,
  t3.raison_sociale AS raison_sociale_54,
  t3.montant AS montant_55,
  t3.adresse_siege_social AS adresse_siege_social_56,
  t3.adresse_site_production AS adresse_site_production_57,
  t3.gouvernorat_id AS gouvernorat_id_58,
  t3.delegation_id AS delegation_id_59,
  t4.tel AS tel_60,
  t4.nom AS nom_61,
  t4.prenom AS prenom_62,
  t4.ministere AS ministere_63,
  t4.direction AS direction_64,
  t4.gouvernorat_id AS gouvernorat_id_65,
  t5.nom AS nom_66,
  t5.prenom AS prenom_67,
  t5.tel AS tel_68,
  t5.unite_regional_id AS unite_regional_id_69,
  t6.nom AS nom_70,
  t6.prenom AS prenom_71,
  t6.tel AS tel_72,
  t6.nom_administration AS nom_administration_73,
  t6.regional AS regional_74,
  t6.unite AS unite_75,
  t6.fonction AS fonction_76,
  t7.nom AS nom_77,
  t7.prenom AS prenom_78,
  t7.tel AS tel_79,
  t7.gouvernorat_id AS gouvernorat_id_80
FROM
  user t0
  LEFT JOIN particulier t1 ON t0.id = t1.id
  LEFT JOIN partenaire t2 ON t0.id = t2.id
  LEFT JOIN entreprise t3 ON t0.id = t3.id
  LEFT JOIN dae t4 ON t0.id = t4.id
  LEFT JOIN charge_assistance t5 ON t0.id = t5.id
  LEFT JOIN agent_interne t6 ON t0.id = t6.id
  LEFT JOIN autres t7 ON t0.id = t7.id
WHERE
  t0.id = ?

SELECT t0.id AS id_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.token_reset AS token_reset_14, t0.is_deleted AS is_deleted_15, t0.type, t1.nom AS nom_16, t1.prenom AS prenom_17, t1.tel AS tel_18, t1.fonction AS fonction_19, t1.autre AS autre_20, t1.fonctions AS fonctions_21, t1.gouvernorat_id AS gouvernorat_id_22, t2.type_partenaire AS type_partenaire_23, t2.nombre_entreprise AS nombre_entreprise_24, t2.cnsscnrps AS cnsscnrps_25, t2.code_cnss AS code_cnss_26, t2.secteur AS secteur_27, t2.branche AS branche_28, t2.fax AS fax_29, t2.tel AS tel_30, t2.nom_prenom_president AS nom_prenom_president_31, t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32, t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33, t2.nom AS nom_34, t2.file_name AS file_name_35, t2.original_file_name AS original_file_name_36, t2.gouvernorat_id AS gouvernorat_id_37, t2.delegation_id AS delegation_id_38, t3.matricule_fiscal AS matricule_fiscal_39, t3.nom_commercial AS nom_commercial_40, t3.fax AS fax_41, t3.code_cnss AS code_cnss_42, t3.cnsscnrps AS cnsscnrps_43, t3.secteur AS secteur_44, t3.branche AS branche_45, t3.produits_services_rendus AS produits_services_rendus_46, t3.statut AS statut_47, t3.exportatrice AS exportatrice_48, t3.off_shore AS off_shore_49, t3.taux_tfp AS taux_tfp_50, t3.regime_travail AS regime_travail_51, t3.tel AS tel_52, t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53, t3.raison_sociale AS raison_sociale_54, t3.montant AS montant_55, t3.adresse_siege_social AS adresse_siege_social_56, t3.adresse_site_production AS adresse_site_production_57, t3.gouvernorat_id AS gouvernorat_id_58, t3.delegation_id AS delegation_id_59, t4.tel AS tel_60, t4.nom AS nom_61, t4.prenom AS prenom_62, t4.ministere AS ministere_63, t4.direction AS direction_64, t4.gouvernorat_id AS gouvernorat_id_65, t5.nom AS nom_66, t5.prenom AS prenom_67, t5.tel AS tel_68, t5.unite_regional_id AS unite_regional_id_69, t6.nom AS nom_70, t6.prenom AS prenom_71, t6.tel AS tel_72, t6.nom_administration AS nom_administration_73, t6.regional AS regional_74, t6.unite AS unite_75, t6.fonction AS fonction_76, t7.nom AS nom_77, t7.prenom AS prenom_78, t7.tel AS tel_79, t7.gouvernorat_id AS gouvernorat_id_80 FROM user t0 LEFT JOIN particulier t1 ON t0.id = t1.id LEFT JOIN partenaire t2 ON t0.id = t2.id LEFT JOIN entreprise t3 ON t0.id = t3.id LEFT JOIN dae t4 ON t0.id = t4.id LEFT JOIN charge_assistance t5 ON t0.id = t5.id LEFT JOIN agent_interne t6 ON t0.id = t6.id LEFT JOIN autres t7 ON t0.id = t7.id WHERE t0.id = 3;