Symfony Profiler

SELECT
  CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0
FROM
  tbulletin t2_
  INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id
  INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id
  INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id
  INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id
WHERE
  (
    p3_.id = 5
    OR p3_.id = 68
  )
  AND t2_.id = ?
  AND t1_.active = 1

SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = 107095 AND t1_.active = 1;

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.code AS code_3,
  t0.observation AS observation_4,
  t0.active AS active_5,
  t0.motif_annulation AS motif_annulation_6,
  t0.taux_cotis_cimr AS taux_cotis_cimr_7,
  t0.categorie_cimr AS categorie_cimr_8,
  t0.periode_id AS periode_id_9,
  t0.contract_id AS contract_id_10,
  t0.dossier_id AS dossier_id_11,
  t0.devise_id AS devise_id_12,
  t0.paiement_id AS paiement_id_13,
  t0.bordereau_id AS bordereau_id_14,
  t0.piece_id AS piece_id_15,
  t0.user_annulation_id AS user_annulation_id_16
FROM
  tbulletin t0
WHERE
  t0.bordereau_id = ?

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = 7293;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.type AS type_3,
  t0.code AS code_4,
  t0.nature AS nature_5,
  t0.observation AS observation_6,
  t0.active AS active_7,
  t0.date_integration AS date_integration_8,
  t0.unique_id AS unique_id_9,
  t0.motif_annulation AS motif_annulation_10,
  t0.periode_id AS periode_id_11,
  t0.user_created_id AS user_created_id_12,
  t0.dossier_id AS dossier_id_13,
  t0.paiement_id AS paiement_id_14,
  t0.piece_id AS piece_id_15,
  t0.nature_contract_id AS nature_contract_id_16,
  t0.statut_id AS statut_id_17,
  t0.devise_id AS devise_id_18,
  t0.user_integration_id AS user_integration_id_19,
  t0.user_annulation_id AS user_annulation_id_20,
  t0.rubrique_indiminite_id AS rubrique_indiminite_id_21
FROM
  pbordereau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = 7293;

SELECT
  p0_.id AS id_0,
  p1_.designation AS designation_1,
  p2_.designation AS designation_2,
  p3_.designation AS designation_3,
  p4_.abreviation AS abreviation_4,
  p0_.code AS code_5,
  p0_.created AS created_6,
  p0_.type AS type_7,
  p5_.designation AS designation_8,
  p6_.designation AS designation_9,
  p6_.icon AS icon_10
FROM
  pbordereau p0_
  INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id
  INNER JOIN periode p4_ ON p0_.periode_id = p4_.id
  INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id
  INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id
  INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id
  LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id
WHERE
  p0_.active = 1
  AND p0_.periode_id = ?
  AND p1_.id = ?
ORDER BY
  p3_.designation DESC

SELECT p0_.id AS id_0, p1_.designation AS designation_1, p2_.designation AS designation_2, p3_.designation AS designation_3, p4_.abreviation AS abreviation_4, p0_.code AS code_5, p0_.created AS created_6, p0_.type AS type_7, p5_.designation AS designation_8, p6_.designation AS designation_9, p6_.icon AS icon_10 FROM pbordereau p0_ INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id INNER JOIN periode p4_ ON p0_.periode_id = p4_.id INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id WHERE p0_.active = 1 AND p0_.periode_id = 46 AND p1_.id = 3 ORDER BY p3_.designation DESC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.abreviation AS abreviation_3,
  t0.date AS date_4,
  t0.is_valider AS is_valider_5,
  t0.is_integrer AS is_integrer_6
FROM
  periode t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.abreviation AS abreviation_3, t0.date AS date_4, t0.is_valider AS is_valider_5, t0.is_integrer AS is_integrer_6 FROM periode t0 WHERE t0.code = '032025' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p1_.designation AS designation_1,
  p2_.designation AS designation_2,
  p3_.designation AS designation_3,
  p4_.abreviation AS abreviation_4,
  p0_.code AS code_5,
  p0_.created AS created_6,
  p0_.type AS type_7,
  p5_.designation AS designation_8,
  p6_.designation AS designation_9,
  p6_.icon AS icon_10
FROM
  pbordereau p0_
  INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id
  INNER JOIN periode p4_ ON p0_.periode_id = p4_.id
  INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id
  INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id
  INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id
  LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id
WHERE
  p0_.active = 1
  AND p0_.periode_id = ?
  AND p1_.id = ?
ORDER BY
  p0_.id DESC
LIMIT
  10

SELECT p0_.id AS id_0, p1_.designation AS designation_1, p2_.designation AS designation_2, p3_.designation AS designation_3, p4_.abreviation AS abreviation_4, p0_.code AS code_5, p0_.created AS created_6, p0_.type AS type_7, p5_.designation AS designation_8, p6_.designation AS designation_9, p6_.icon AS icon_10 FROM pbordereau p0_ INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id INNER JOIN periode p4_ ON p0_.periode_id = p4_.id INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id WHERE p0_.active = 1 AND p0_.periode_id = 46 AND p1_.id = 3 ORDER BY p0_.id DESC LIMIT 10;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  pbordereau p0_
  INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id
WHERE
  p0_.active = 1
  AND p0_.periode_id = ?
  AND p1_.id = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM pbordereau p0_ INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id WHERE p0_.active = 1 AND p0_.periode_id = 46 AND p1_.id = 3;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.enable AS enable_7,
  t0.created AS created_8,
  t0.email AS email_9,
  t0.updated AS updated_10,
  t0.user_updated_id AS user_updated_id_11,
  t0.dossier_responsable_id AS dossier_responsable_id_12
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = 3;