Symfony Profiler

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  decision d0_
  LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id
  LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id
  LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id
  LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id
  LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id
  LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id
WHERE
  d0_.is_published = ?
  AND (
    d0_.numero LIKE ?
    OR d0_.numero_dossier LIKE ?
    OR d0_.object LIKE ?
    OR d0_.keywords LIKE ?
  )
  AND (
    n3_.id = ?
    OR n3_.code = ?
  )

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = 1 AND (d0_.numero LIKE '%Immunité %' OR d0_.numero_dossier LIKE '%Immunité %' OR d0_.object LIKE '%Immunité %' OR d0_.keywords LIKE '%Immunité %') AND (n3_.id = 'SOCIALE' OR n3_.code = 'SOCIALE');

SELECT
  d0_.id AS id_0,
  d0_.code AS code_1,
  d0_.numero AS numero_2,
  d0_.arret_at AS arret_at_3,
  d0_.numero_dossier AS numero_dossier_4,
  d0_.created_at AS created_at_5,
  d0_.updated_at AS updated_at_6,
  d0_.validated_at AS validated_at_7,
  d0_.is_published AS is_published_8,
  d0_.is_validated AS is_validated_9,
  d0_.demandeur AS demandeur_10,
  d0_.defendeur AS defendeur_11,
  d0_.filename AS filename_12,
  d0_.object AS object_13,
  d0_.object_other AS object_other_14,
  d0_.content AS content_15,
  d0_.president AS president_16,
  d0_.conseiller_rapporteur AS conseiller_rapporteur_17,
  d0_.conseiller AS conseiller_18,
  d0_.greffier AS greffier_19,
  d0_.avocat_general AS avocat_general_20,
  d0_.autre_personnes AS autre_personnes_21,
  d0_.validation_note AS validation_note_22,
  d0_.sommaire AS sommaire_23,
  d0_.keywords AS keywords_24,
  d0_.content_brut AS content_brut_25,
  d0_.validate_by_id AS validate_by_id_26,
  d0_.nature_id AS nature_id_27,
  d0_.solution_id AS solution_id_28,
  d0_.cassation_id AS cassation_id_29,
  d0_.statut_id AS statut_id_30,
  d0_.created_by_id AS created_by_id_31
FROM
  decision d0_
  LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id
  LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id
  LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id
  LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id
  LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id
  LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id
WHERE
  d0_.is_published = ?
  AND (
    d0_.numero LIKE ?
    OR d0_.numero_dossier LIKE ?
    OR d0_.object LIKE ?
    OR d0_.keywords LIKE ?
  )
  AND (
    n3_.id = ?
    OR n3_.code = ?
  )
  AND d0_.id IN (?)
ORDER BY
  d0_.arret_at DESC

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.numero AS numero_2, d0_.arret_at AS arret_at_3, d0_.numero_dossier AS numero_dossier_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.validated_at AS validated_at_7, d0_.is_published AS is_published_8, d0_.is_validated AS is_validated_9, d0_.demandeur AS demandeur_10, d0_.defendeur AS defendeur_11, d0_.filename AS filename_12, d0_.object AS object_13, d0_.object_other AS object_other_14, d0_.content AS content_15, d0_.president AS president_16, d0_.conseiller_rapporteur AS conseiller_rapporteur_17, d0_.conseiller AS conseiller_18, d0_.greffier AS greffier_19, d0_.avocat_general AS avocat_general_20, d0_.autre_personnes AS autre_personnes_21, d0_.validation_note AS validation_note_22, d0_.sommaire AS sommaire_23, d0_.keywords AS keywords_24, d0_.content_brut AS content_brut_25, d0_.validate_by_id AS validate_by_id_26, d0_.nature_id AS nature_id_27, d0_.solution_id AS solution_id_28, d0_.cassation_id AS cassation_id_29, d0_.statut_id AS statut_id_30, d0_.created_by_id AS created_by_id_31 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = 1 AND (d0_.numero LIKE '%Immunité %' OR d0_.numero_dossier LIKE '%Immunité %' OR d0_.object LIKE '%Immunité %' OR d0_.keywords LIKE '%Immunité %') AND (n3_.id = 'SOCIALE' OR n3_.code = 'SOCIALE') AND d0_.id IN (524) ORDER BY d0_.arret_at DESC;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.arret_at AS arret_at_1
FROM
  decision d0_
  LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id
  LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id
  LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id
  LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id
  LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id
  LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id
WHERE
  d0_.is_published = ?
  AND (
    d0_.numero LIKE ?
    OR d0_.numero_dossier LIKE ?
    OR d0_.object LIKE ?
    OR d0_.keywords LIKE ?
  )
  AND (
    n3_.id = ?
    OR n3_.code = ?
  )
ORDER BY
  d0_.arret_at DESC
LIMIT
  20

SELECT DISTINCT d0_.id AS id_0, d0_.arret_at AS arret_at_1 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = 1 AND (d0_.numero LIKE '%Immunité %' OR d0_.numero_dossier LIKE '%Immunité %' OR d0_.object LIKE '%Immunité %' OR d0_.keywords LIKE '%Immunité %') AND (n3_.id = 'SOCIALE' OR n3_.code = 'SOCIALE') ORDER BY d0_.arret_at DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.created_at AS created_at_3,
  t0.filename AS filename_4,
  t0.completed_at AS completed_at_5,
  t0.is_classified AS is_classified_6,
  t0.numero AS numero_7,
  t0.arret_at AS arret_at_8,
  t0.year_at AS year_at_9,
  t0.content AS content_10,
  t0.updated_at AS updated_at_11,
  t0.created_by_id AS created_by_id_12,
  t0.decision_id AS decision_id_13,
  t0.completed_by_id AS completed_by_id_14,
  t0.nature_id AS nature_id_15
FROM
  draft t0
WHERE
  t0.decision_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.filename AS filename_4, t0.completed_at AS completed_at_5, t0.is_classified AS is_classified_6, t0.numero AS numero_7, t0.arret_at AS arret_at_8, t0.year_at AS year_at_9, t0.content AS content_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.decision_id AS decision_id_13, t0.completed_by_id AS completed_by_id_14, t0.nature_id AS nature_id_15 FROM draft t0 WHERE t0.decision_id = 524;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3
FROM
  matiere t0
  INNER JOIN decision_matiere ON t0.id = decision_matiere.matiere_id
WHERE
  decision_matiere.decision_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM matiere t0 INNER JOIN decision_matiere ON t0.id = decision_matiere.matiere_id WHERE decision_matiere.decision_id = 524;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3
FROM
  nature t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM nature t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.color AS color_4
FROM
  solution t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.color AS color_4 FROM solution t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3
FROM
  cassation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM cassation t0 WHERE t0.id = 1;