Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.focus AS focus_4,
  t0.keywords AS keywords_5,
  t0.position AS position_6,
  t0.last_imported_at AS last_imported_at_7,
  t0.project_id AS project_id_8
FROM
  category t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.position ASC,
  t0.label ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.project_id = 1 ORDER BY t0.position ASC, t0.label ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.slug AS slug_2,
          a0_.resume AS resume_3,
          a0_.conclusion AS conclusion_4,
          a0_.pmid AS pmid_5,
          a0_.url AS url_6,
          a0_.doi AS doi_7,
          a0_.publication_date AS publication_date_8,
          a0_.authors AS authors_9,
          a0_.journal AS journal_10,
          a0_.volume AS volume_11,
          a0_.issue AS issue_12,
          a0_.pages AS pages_13,
          a0_.hypotheses AS hypotheses_14,
          a0_.population AS population_15,
          a0_.variables AS variables_16,
          a0_.protocol AS protocol_17,
          a0_.measurement_tools AS measurement_tools_18,
          a0_.statistical_analyses AS statistical_analyses_19,
          a0_.statistical_results AS statistical_results_20,
          a0_.conclusions AS conclusions_21,
          a0_.limitations AS limitations_22,
          a0_.personal_interest AS personal_interest_23,
          a0_.other_comments AS other_comments_24,
          a0_.created_at AS created_at_25,
          a0_.updated_at AS updated_at_26,
          a1_.id AS id_27,
          a1_.is_read AS is_read_28,
          a1_.is_favorite AS is_favorite_29,
          a1_.in_progress AS in_progress_30,
          a1_.linked_at AS linked_at_31,
          a1_.unlinked_at AS unlinked_at_32
        FROM
          article a0_
          INNER JOIN article_project a1_ ON a0_.id = a1_.article_id
          AND (a1_.project_id = ?)
          INNER JOIN article_category a3_ ON a0_.id = a3_.article_id
          INNER JOIN category c2_ ON c2_.id = a3_.category_id
        WHERE
          a1_.unlinked_at IS NULL
          AND c2_.id = ?
        ORDER BY
          a0_.publication_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.conclusion AS conclusion_4, a0_.pmid AS pmid_5, a0_.url AS url_6, a0_.doi AS doi_7, a0_.publication_date AS publication_date_8, a0_.authors AS authors_9, a0_.journal AS journal_10, a0_.volume AS volume_11, a0_.issue AS issue_12, a0_.pages AS pages_13, a0_.hypotheses AS hypotheses_14, a0_.population AS population_15, a0_.variables AS variables_16, a0_.protocol AS protocol_17, a0_.measurement_tools AS measurement_tools_18, a0_.statistical_analyses AS statistical_analyses_19, a0_.statistical_results AS statistical_results_20, a0_.conclusions AS conclusions_21, a0_.limitations AS limitations_22, a0_.personal_interest AS personal_interest_23, a0_.other_comments AS other_comments_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, a1_.id AS id_27, a1_.is_read AS is_read_28, a1_.is_favorite AS is_favorite_29, a1_.in_progress AS in_progress_30, a1_.linked_at AS linked_at_31, a1_.unlinked_at AS unlinked_at_32 FROM article a0_ INNER JOIN article_project a1_ ON a0_.id = a1_.article_id AND (a1_.project_id = 1) INNER JOIN article_category a3_ ON a0_.id = a3_.article_id INNER JOIN category c2_ ON c2_.id = a3_.category_id WHERE a1_.unlinked_at IS NULL AND c2_.id = 31 ORDER BY a0_.publication_date DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      publication_date_8
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.title AS title_1,
          a0_.slug AS slug_2,
          a0_.resume AS resume_3,
          a0_.conclusion AS conclusion_4,
          a0_.pmid AS pmid_5,
          a0_.url AS url_6,
          a0_.doi AS doi_7,
          a0_.publication_date AS publication_date_8,
          a0_.authors AS authors_9,
          a0_.journal AS journal_10,
          a0_.volume AS volume_11,
          a0_.issue AS issue_12,
          a0_.pages AS pages_13,
          a0_.hypotheses AS hypotheses_14,
          a0_.population AS population_15,
          a0_.variables AS variables_16,
          a0_.protocol AS protocol_17,
          a0_.measurement_tools AS measurement_tools_18,
          a0_.statistical_analyses AS statistical_analyses_19,
          a0_.statistical_results AS statistical_results_20,
          a0_.conclusions AS conclusions_21,
          a0_.limitations AS limitations_22,
          a0_.personal_interest AS personal_interest_23,
          a0_.other_comments AS other_comments_24,
          a0_.created_at AS created_at_25,
          a0_.updated_at AS updated_at_26,
          a1_.id AS id_27,
          a1_.is_read AS is_read_28,
          a1_.is_favorite AS is_favorite_29,
          a1_.in_progress AS in_progress_30,
          a1_.linked_at AS linked_at_31,
          a1_.unlinked_at AS unlinked_at_32,
          c2_.id AS id_33,
          c2_.slug AS slug_34,
          c2_.label AS label_35,
          c2_.focus AS focus_36,
          c2_.keywords AS keywords_37,
          c2_.position AS position_38,
          c2_.last_imported_at AS last_imported_at_39
        FROM
          article a0_
          INNER JOIN article_project a1_ ON a0_.id = a1_.article_id
          AND (a1_.project_id = ?)
          INNER JOIN article_category a3_ ON a0_.id = a3_.article_id
          INNER JOIN category c2_ ON c2_.id = a3_.category_id
        WHERE
          a1_.unlinked_at IS NULL
          AND c2_.id = ?
      ) dctrn_result_inner
    ORDER BY
      publication_date_8 DESC
  ) dctrn_result
LIMIT
  12
OFFSET
  72

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_8 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.conclusion AS conclusion_4, a0_.pmid AS pmid_5, a0_.url AS url_6, a0_.doi AS doi_7, a0_.publication_date AS publication_date_8, a0_.authors AS authors_9, a0_.journal AS journal_10, a0_.volume AS volume_11, a0_.issue AS issue_12, a0_.pages AS pages_13, a0_.hypotheses AS hypotheses_14, a0_.population AS population_15, a0_.variables AS variables_16, a0_.protocol AS protocol_17, a0_.measurement_tools AS measurement_tools_18, a0_.statistical_analyses AS statistical_analyses_19, a0_.statistical_results AS statistical_results_20, a0_.conclusions AS conclusions_21, a0_.limitations AS limitations_22, a0_.personal_interest AS personal_interest_23, a0_.other_comments AS other_comments_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, a1_.id AS id_27, a1_.is_read AS is_read_28, a1_.is_favorite AS is_favorite_29, a1_.in_progress AS in_progress_30, a1_.linked_at AS linked_at_31, a1_.unlinked_at AS unlinked_at_32, c2_.id AS id_33, c2_.slug AS slug_34, c2_.label AS label_35, c2_.focus AS focus_36, c2_.keywords AS keywords_37, c2_.position AS position_38, c2_.last_imported_at AS last_imported_at_39 FROM article a0_ INNER JOIN article_project a1_ ON a0_.id = a1_.article_id AND (a1_.project_id = 1) INNER JOIN article_category a3_ ON a0_.id = a3_.article_id INNER JOIN category c2_ ON c2_.id = a3_.category_id WHERE a1_.unlinked_at IS NULL AND c2_.id = 31) dctrn_result_inner ORDER BY publication_date_8 DESC) dctrn_result LIMIT 12 OFFSET 72;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.tagline AS tagline_4,
  t0.description AS description_5,
  t0.color_primary AS color_primary_6,
  t0.color_header_start AS color_header_start_7,
  t0.color_header_end AS color_header_end_8,
  t0.logo AS logo_9,
  t0.position AS position_10,
  t0.is_active AS is_active_11
FROM
  project t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.tagline AS tagline_4, t0.description AS description_5, t0.color_primary AS color_primary_6, t0.color_header_start AS color_header_start_7, t0.color_header_end AS color_header_end_8, t0.logo AS logo_9, t0.position AS position_10, t0.is_active AS is_active_11 FROM project t0 WHERE t0.slug = 'scientia' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.focus AS focus_4,
  t0.keywords AS keywords_5,
  t0.position AS position_6,
  t0.last_imported_at AS last_imported_at_7,
  t0.project_id AS project_id_8
FROM
  category t0
WHERE
  t0.slug = ?
  AND t0.project_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.slug = 'novlangue_controle_cognitif' AND t0.project_id = 1 LIMIT 1;