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 (
    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 (n3_.id = 'COMMERCIALE' OR n3_.code = 'COMMERCIALE');

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 (
    n3_.id = ?
    OR n3_.code = ?
  )
ORDER BY
  d0_.arret_at DESC
LIMIT
  20
OFFSET
  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 (n3_.id = 'COMMERCIALE' OR n3_.code = 'COMMERCIALE') ORDER BY d0_.arret_at DESC LIMIT 20 OFFSET 20;

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 (
    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 (n3_.id = 'COMMERCIALE' OR n3_.code = 'COMMERCIALE') AND d0_.id IN (430, 311, 307, 308, 302, 285, 251, 228, 231, 218, 219, 211, 208, 204, 191, 187, 175, 169, 160, 124) ORDER BY d0_.arret_at DESC;

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 = 430;

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 = 311;

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 = 307;

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 = 308;

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 = 302;

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 = 285;

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 = 251;

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 = 228;

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 = 231;

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 = 218;

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 = 219;

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 = ?