Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.color AS color_4,
  c0_.icon AS icon_5,
  c0_.position AS position_6,
  c0_.is_active AS is_active_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9
FROM
  category c0_
WHERE
  c0_.is_active = ?
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.color AS color_4, c0_.icon AS icon_5, c0_.position AS position_6, c0_.is_active AS is_active_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9 FROM category c0_ WHERE c0_.is_active = 1 ORDER BY c0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.color AS color_5,
  t0.icon AS icon_6,
  t0.position AS position_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.position AS position_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM category t0 WHERE t0.slug = 'politique' LIMIT 1;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.category_id = ?
  AND a0_.status = ?

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.category_id = 1 AND a0_.status = 'published';

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.published_at AS published_at_1
FROM
  article a0_
WHERE
  a0_.category_id = ?
  AND a0_.status = ?
ORDER BY
  a0_.published_at DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1 FROM article a0_ WHERE a0_.category_id = 1 AND a0_.status = 'published' ORDER BY a0_.published_at DESC LIMIT 12;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.subtitle AS subtitle_3,
  a0_.excerpt AS excerpt_4,
  a0_.body AS body_5,
  a0_.status AS status_6,
  a0_.source_topic AS source_topic_7,
  a0_.satire_score AS satire_score_8,
  a0_.risk_score AS risk_score_9,
  a0_.is_ai_generated AS is_ai_generated_10,
  a0_.is_featured AS is_featured_11,
  a0_.view_count AS view_count_12,
  a0_.author AS author_13,
  a0_.published_at AS published_at_14,
  a0_.created_at AS created_at_15,
  a0_.updated_at AS updated_at_16,
  a0_.metadata AS metadata_17,
  a0_.ai_prompt AS ai_prompt_18,
  a0_.ai_response AS ai_response_19,
  a0_.category_id AS category_id_20,
  a0_.featured_image_id AS featured_image_id_21
FROM
  article a0_
WHERE
  a0_.category_id = ?
  AND a0_.status = ?
  AND a0_.id IN (?)
ORDER BY
  a0_.published_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.subtitle AS subtitle_3, a0_.excerpt AS excerpt_4, a0_.body AS body_5, a0_.status AS status_6, a0_.source_topic AS source_topic_7, a0_.satire_score AS satire_score_8, a0_.risk_score AS risk_score_9, a0_.is_ai_generated AS is_ai_generated_10, a0_.is_featured AS is_featured_11, a0_.view_count AS view_count_12, a0_.author AS author_13, a0_.published_at AS published_at_14, a0_.created_at AS created_at_15, a0_.updated_at AS updated_at_16, a0_.metadata AS metadata_17, a0_.ai_prompt AS ai_prompt_18, a0_.ai_response AS ai_response_19, a0_.category_id AS category_id_20, a0_.featured_image_id AS featured_image_id_21 FROM article a0_ WHERE a0_.category_id = 1 AND a0_.status = 'published' AND a0_.id IN (1, 2, 6, 7, 14) ORDER BY a0_.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.title AS title_5,
  t0.metadata AS metadata_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.is_ai_generated AS is_ai_generated_9,
  t0.generation_prompt AS generation_prompt_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  media_asset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.alt AS alt_4, t0.title AS title_5, t0.metadata AS metadata_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.is_ai_generated AS is_ai_generated_9, t0.generation_prompt AS generation_prompt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM media_asset t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.title AS title_5,
  t0.metadata AS metadata_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.is_ai_generated AS is_ai_generated_9,
  t0.generation_prompt AS generation_prompt_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  media_asset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.alt AS alt_4, t0.title AS title_5, t0.metadata AS metadata_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.is_ai_generated AS is_ai_generated_9, t0.generation_prompt AS generation_prompt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM media_asset t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.title AS title_5,
  t0.metadata AS metadata_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.is_ai_generated AS is_ai_generated_9,
  t0.generation_prompt AS generation_prompt_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  media_asset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.alt AS alt_4, t0.title AS title_5, t0.metadata AS metadata_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.is_ai_generated AS is_ai_generated_9, t0.generation_prompt AS generation_prompt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM media_asset t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.title AS title_5,
  t0.metadata AS metadata_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.is_ai_generated AS is_ai_generated_9,
  t0.generation_prompt AS generation_prompt_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  media_asset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.alt AS alt_4, t0.title AS title_5, t0.metadata AS metadata_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.is_ai_generated AS is_ai_generated_9, t0.generation_prompt AS generation_prompt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM media_asset t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.alt AS alt_4,
  t0.title AS title_5,
  t0.metadata AS metadata_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.is_ai_generated AS is_ai_generated_9,
  t0.generation_prompt AS generation_prompt_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  media_asset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.alt AS alt_4, t0.title AS title_5, t0.metadata AS metadata_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.is_ai_generated AS is_ai_generated_9, t0.generation_prompt AS generation_prompt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM media_asset t0 WHERE t0.id = 9;