Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image_name AS image_name_4,
  t0.author AS author_5,
  t0.summary AS summary_6,
  t0.content AS content_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.state AS state_10,
  t0.seo_title AS seo_title_11,
  t0.seo_description AS seo_description_12,
  t0.seo_canonical AS seo_canonical_13,
  t0.seo_indexed AS seo_indexed_14,
  t0.category_id AS category_id_15
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.author AS author_5, t0.summary AS summary_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.state AS state_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_canonical AS seo_canonical_13, t0.seo_indexed AS seo_indexed_14, t0.category_id AS category_id_15 FROM article t0 WHERE t0.slug = 'comment-ameliorer-la-performance-dune-requete-sql-lente' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.pdf_name AS pdf_name_4,
  t0.pdf_mime_type AS pdf_mime_type_5,
  t0.updated_at AS updated_at_6,
  t0.show_on_home_page AS show_on_home_page_7,
  t0.featured_on_search AS featured_on_search_8,
  t0.price AS price_9,
  t0.cpf AS cpf_10,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_11,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_12,
  t0.individual_videoconference_hours AS individual_videoconference_hours_13,
  t0.collective_videoconference_hours AS collective_videoconference_hours_14,
  t0.elearning_hours AS elearning_hours_15,
  t0.format AS format_16,
  t0.description AS description_17,
  t0.min_period AS min_period_18,
  t0.max_period AS max_period_19,
  t0.public AS public_20,
  t0.prerequisites AS prerequisites_21,
  t0.code AS code_22,
  t0.face_to_face_hours_text AS face_to_face_hours_text_23,
  t0.satisfaction_rate AS satisfaction_rate_24,
  t0.cpf_link AS cpf_link_25,
  t0.completion_rate AS completion_rate_26,
  t0.slug_history AS slug_history_27,
  t0.sub_title AS sub_title_28,
  t0.pixels AS pixels_29,
  t0.status AS status_30,
  t0.seo_title AS seo_title_31,
  t0.seo_description AS seo_description_32,
  t0.seo_canonical AS seo_canonical_33,
  t0.seo_indexed AS seo_indexed_34,
  t0.certification_id AS certification_id_35,
  t0.category_id AS category_id_36,
  t0.created_by_id AS created_by_id_37
FROM
  training t0
  INNER JOIN article_training ON t0.id = article_training.training_id
WHERE
  article_training.article_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.pdf_name AS pdf_name_4, t0.pdf_mime_type AS pdf_mime_type_5, t0.updated_at AS updated_at_6, t0.show_on_home_page AS show_on_home_page_7, t0.featured_on_search AS featured_on_search_8, t0.price AS price_9, t0.cpf AS cpf_10, t0.collective_face_to_face_hours AS collective_face_to_face_hours_11, t0.individual_face_to_face_hours AS individual_face_to_face_hours_12, t0.individual_videoconference_hours AS individual_videoconference_hours_13, t0.collective_videoconference_hours AS collective_videoconference_hours_14, t0.elearning_hours AS elearning_hours_15, t0.format AS format_16, t0.description AS description_17, t0.min_period AS min_period_18, t0.max_period AS max_period_19, t0.public AS public_20, t0.prerequisites AS prerequisites_21, t0.code AS code_22, t0.face_to_face_hours_text AS face_to_face_hours_text_23, t0.satisfaction_rate AS satisfaction_rate_24, t0.cpf_link AS cpf_link_25, t0.completion_rate AS completion_rate_26, t0.slug_history AS slug_history_27, t0.sub_title AS sub_title_28, t0.pixels AS pixels_29, t0.status AS status_30, t0.seo_title AS seo_title_31, t0.seo_description AS seo_description_32, t0.seo_canonical AS seo_canonical_33, t0.seo_indexed AS seo_indexed_34, t0.certification_id AS certification_id_35, t0.category_id AS category_id_36, t0.created_by_id AS created_by_id_37 FROM training t0 INNER JOIN article_training ON t0.id = article_training.training_id WHERE article_training.article_id = 174;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
  INNER JOIN article_training_category ON t0.id = article_training_category.training_category_id
WHERE
  article_training_category.article_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 INNER JOIN article_training_category ON t0.id = article_training_category.training_category_id WHERE article_training_category.article_id = 174;

SELECT
  t0_.id AS id_0,
  t0_.label AS label_1,
  t0_.slug AS slug_2,
  t0_.pdf_name AS pdf_name_3,
  t0_.pdf_mime_type AS pdf_mime_type_4,
  t0_.updated_at AS updated_at_5,
  t0_.show_on_home_page AS show_on_home_page_6,
  t0_.featured_on_search AS featured_on_search_7,
  t0_.price AS price_8,
  t0_.cpf AS cpf_9,
  t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10,
  t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11,
  t0_.individual_videoconference_hours AS individual_videoconference_hours_12,
  t0_.collective_videoconference_hours AS collective_videoconference_hours_13,
  t0_.elearning_hours AS elearning_hours_14,
  t0_.format AS format_15,
  t0_.description AS description_16,
  t0_.min_period AS min_period_17,
  t0_.max_period AS max_period_18,
  t0_.public AS public_19,
  t0_.prerequisites AS prerequisites_20,
  t0_.code AS code_21,
  t0_.face_to_face_hours_text AS face_to_face_hours_text_22,
  t0_.satisfaction_rate AS satisfaction_rate_23,
  t0_.cpf_link AS cpf_link_24,
  t0_.completion_rate AS completion_rate_25,
  t0_.slug_history AS slug_history_26,
  t0_.sub_title AS sub_title_27,
  t0_.pixels AS pixels_28,
  t0_.status AS status_29,
  t0_.seo_title AS seo_title_30,
  t0_.seo_description AS seo_description_31,
  t0_.seo_canonical AS seo_canonical_32,
  t0_.seo_indexed AS seo_indexed_33,
  t0_.certification_id AS certification_id_34,
  t0_.category_id AS category_id_35,
  t0_.created_by_id AS created_by_id_36
FROM
  training t0_
WHERE
  t0_.category_id IN (?)
ORDER BY
  RANDOM() ASC
LIMIT
  4

SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33, t0_.certification_id AS certification_id_34, t0_.category_id AS category_id_35, t0_.created_by_id AS created_by_id_36 FROM training t0_ WHERE t0_.category_id IN (10) ORDER BY RANDOM() ASC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.image_name AS image_name_3,
  a0_.author AS author_4,
  a0_.summary AS summary_5,
  a0_.content AS content_6,
  a0_.created_at AS created_at_7,
  a0_.updated_at AS updated_at_8,
  a0_.state AS state_9,
  a0_.seo_title AS seo_title_10,
  a0_.seo_description AS seo_description_11,
  a0_.seo_canonical AS seo_canonical_12,
  a0_.seo_indexed AS seo_indexed_13,
  a0_.category_id AS category_id_14
FROM
  article a0_
  INNER JOIN article_category a1_ ON a0_.category_id = a1_.id
  AND (a1_.id = ?)
WHERE
  a0_.id <> ?
  AND a0_.state = ?
ORDER BY
  RANDOM() ASC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.image_name AS image_name_3, a0_.author AS author_4, a0_.summary AS summary_5, a0_.content AS content_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.state AS state_9, a0_.seo_title AS seo_title_10, a0_.seo_description AS seo_description_11, a0_.seo_canonical AS seo_canonical_12, a0_.seo_indexed AS seo_indexed_13, a0_.category_id AS category_id_14 FROM article a0_ INNER JOIN article_category a1_ ON a0_.category_id = a1_.id AND (a1_.id = 24) WHERE a0_.id <> 174 AND a0_.state = 'ONLINE' ORDER BY RANDOM() ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.ebook_title AS ebook_title_5,
  t0.ebook_sub_title AS ebook_sub_title_6,
  t0.pdf_name AS pdf_name_7,
  t0.pdf_mime_type AS pdf_mime_type_8
FROM
  article_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.ebook_title AS ebook_title_5, t0.ebook_sub_title AS ebook_sub_title_6, t0.pdf_name AS pdf_name_7, t0.pdf_mime_type AS pdf_mime_type_8 FROM article_category t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 25;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 24;