Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.cover_file_name AS cover_file_name_3,
  t0.cover_mime_type AS cover_mime_type_4,
  t0.cover_path AS cover_path_5,
  t0.cover_size AS cover_size_6,
  t0.slug AS slug_7
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.cover_file_name AS cover_file_name_3, t0.cover_mime_type AS cover_mime_type_4, t0.cover_path AS cover_path_5, t0.cover_size AS cover_size_6, t0.slug AS slug_7 FROM category t0 WHERE t0.slug = 'gestione-piscina' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.visible AS visible_1,
  a0_.featured AS featured_2,
  a0_.date AS date_3,
  a0_.title AS title_4,
  a0_.content AS content_5,
  a0_.meta_title AS meta_title_6,
  a0_.meta_description AS meta_description_7,
  a0_.cover_file_name AS cover_file_name_8,
  a0_.cover_mime_type AS cover_mime_type_9,
  a0_.cover_path AS cover_path_10,
  a0_.cover_size AS cover_size_11,
  a0_.document_file_name AS document_file_name_12,
  a0_.document_mime_type AS document_mime_type_13,
  a0_.document_path AS document_path_14,
  a0_.document_size AS document_size_15,
  a0_.slug AS slug_16,
  a0_.created_at AS created_at_17,
  a0_.updated_at AS updated_at_18
FROM
  article a0_
WHERE
  a0_.visible = 1
  AND a0_.featured = 1
ORDER BY
  a0_.date DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.visible = 1 AND a0_.featured = 1 ORDER BY a0_.date DESC LIMIT 1;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.visible = 1
  AND a0_.featured = 0
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.visible = 1 AND a0_.featured = 0 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (41));

SELECT
  DISTINCT a0_.id AS id_0
FROM
  article a0_
WHERE
  a0_.visible = 1
  AND a0_.featured = 0
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )
LIMIT
  9

SELECT DISTINCT a0_.id AS id_0 FROM article a0_ WHERE a0_.visible = 1 AND a0_.featured = 0 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (41)) LIMIT 9;

SELECT
  a0_.id AS id_0,
  a0_.visible AS visible_1,
  a0_.featured AS featured_2,
  a0_.date AS date_3,
  a0_.title AS title_4,
  a0_.content AS content_5,
  a0_.meta_title AS meta_title_6,
  a0_.meta_description AS meta_description_7,
  a0_.cover_file_name AS cover_file_name_8,
  a0_.cover_mime_type AS cover_mime_type_9,
  a0_.cover_path AS cover_path_10,
  a0_.cover_size AS cover_size_11,
  a0_.document_file_name AS document_file_name_12,
  a0_.document_mime_type AS document_mime_type_13,
  a0_.document_path AS document_path_14,
  a0_.document_size AS document_size_15,
  a0_.slug AS slug_16,
  a0_.created_at AS created_at_17,
  a0_.updated_at AS updated_at_18
FROM
  article a0_
WHERE
  a0_.visible = 1
  AND a0_.featured = 0
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )
  AND a0_.id IN (?)

SELECT a0_.id AS id_0, a0_.visible AS visible_1, a0_.featured AS featured_2, a0_.date AS date_3, a0_.title AS title_4, a0_.content AS content_5, a0_.meta_title AS meta_title_6, a0_.meta_description AS meta_description_7, a0_.cover_file_name AS cover_file_name_8, a0_.cover_mime_type AS cover_mime_type_9, a0_.cover_path AS cover_path_10, a0_.cover_size AS cover_size_11, a0_.document_file_name AS document_file_name_12, a0_.document_mime_type AS document_mime_type_13, a0_.document_path AS document_path_14, a0_.document_size AS document_size_15, a0_.slug AS slug_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18 FROM article a0_ WHERE a0_.visible = 1 AND a0_.featured = 0 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (41)) AND a0_.id IN (146);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.cover_file_name AS cover_file_name_3,
  t0.cover_mime_type AS cover_mime_type_4,
  t0.cover_path AS cover_path_5,
  t0.cover_size AS cover_size_6,
  t0.slug AS slug_7
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.cover_file_name AS cover_file_name_3, t0.cover_mime_type AS cover_mime_type_4, t0.cover_path AS cover_path_5, t0.cover_size AS cover_size_6, t0.slug AS slug_7 FROM category t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.page AS page_4
FROM
  page_introduction t0
WHERE
  t0.page = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.page AS page_4 FROM page_introduction t0 WHERE t0.page = 'blog' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.page AS page_4
FROM
  page_introduction t0
WHERE
  t0.page = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.page AS page_4 FROM page_introduction t0 WHERE t0.page = 'blog' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.cover_file_name AS cover_file_name_3,
  t0.cover_mime_type AS cover_mime_type_4,
  t0.cover_path AS cover_path_5,
  t0.cover_size AS cover_size_6,
  t0.slug AS slug_7
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.cover_file_name AS cover_file_name_3, t0.cover_mime_type AS cover_mime_type_4, t0.cover_path AS cover_path_5, t0.cover_size AS cover_size_6, t0.slug AS slug_7 FROM category t0;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.call_to_action AS call_to_action_3,
  t0.link AS link_4,
  t0.type AS type_5,
  t0.sorting AS sorting_6,
  t0.headquarter_type AS headquarter_type_7,
  t0.blank AS blank_8
FROM
  footer_entry t0
WHERE
  t0.position = ?
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = 'row_1' ORDER BY t0.sorting ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.call_to_action AS call_to_action_3,
  t0.link AS link_4,
  t0.type AS type_5,
  t0.sorting AS sorting_6,
  t0.headquarter_type AS headquarter_type_7,
  t0.blank AS blank_8
FROM
  footer_entry t0
WHERE
  t0.position = ?
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = 'row_2' ORDER BY t0.sorting ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.call_to_action AS call_to_action_3,
  t0.link AS link_4,
  t0.type AS type_5,
  t0.sorting AS sorting_6,
  t0.headquarter_type AS headquarter_type_7,
  t0.blank AS blank_8
FROM
  footer_entry t0
WHERE
  t0.position = ?
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = 'row_3' ORDER BY t0.sorting ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.call_to_action AS call_to_action_3,
  t0.link AS link_4,
  t0.type AS type_5,
  t0.sorting AS sorting_6,
  t0.headquarter_type AS headquarter_type_7,
  t0.blank AS blank_8
FROM
  footer_entry t0
WHERE
  t0.position = ?
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = 'row_4' ORDER BY t0.sorting ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.call_to_action AS call_to_action_3,
  t0.link AS link_4,
  t0.type AS type_5,
  t0.sorting AS sorting_6,
  t0.headquarter_type AS headquarter_type_7,
  t0.blank AS blank_8
FROM
  footer_entry t0
WHERE
  t0.position = ?
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = 'row_5' ORDER BY t0.sorting ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.call_to_action AS call_to_action_3,
  t0.link AS link_4,
  t0.type AS type_5,
  t0.sorting AS sorting_6,
  t0.headquarter_type AS headquarter_type_7,
  t0.blank AS blank_8
FROM
  footer_entry t0
WHERE
  t0.position = ?
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.call_to_action AS call_to_action_3, t0.link AS link_4, t0.type AS type_5, t0.sorting AS sorting_6, t0.headquarter_type AS headquarter_type_7, t0.blank AS blank_8 FROM footer_entry t0 WHERE t0.position = 'footer' ORDER BY t0.sorting ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.visible AS visible_4,
  t0.introduction AS introduction_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.cover_file_name AS cover_file_name_8,
  t0.cover_mime_type AS cover_mime_type_9,
  t0.cover_path AS cover_path_10,
  t0.cover_size AS cover_size_11,
  t0.menu_cover_file_name AS menu_cover_file_name_12,
  t0.menu_cover_mime_type AS menu_cover_mime_type_13,
  t0.menu_cover_path AS menu_cover_path_14,
  t0.menu_cover_size AS menu_cover_size_15,
  t0.slug AS slug_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  product t0
WHERE
  t0.visible = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.visible AS visible_4, t0.introduction AS introduction_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.menu_cover_file_name AS menu_cover_file_name_12, t0.menu_cover_mime_type AS menu_cover_mime_type_13, t0.menu_cover_path AS menu_cover_path_14, t0.menu_cover_size AS menu_cover_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM product t0 WHERE t0.visible = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.introduction AS introduction_4,
  t0.visible AS visible_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.cover_file_name AS cover_file_name_8,
  t0.cover_mime_type AS cover_mime_type_9,
  t0.cover_path AS cover_path_10,
  t0.cover_size AS cover_size_11,
  t0.background_file_name AS background_file_name_12,
  t0.background_mime_type AS background_mime_type_13,
  t0.background_path AS background_path_14,
  t0.background_size AS background_size_15,
  t0.slug AS slug_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  component t0
WHERE
  t0.visible = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.introduction AS introduction_4, t0.visible AS visible_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.background_file_name AS background_file_name_12, t0.background_mime_type AS background_mime_type_13, t0.background_path AS background_path_14, t0.background_size AS background_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM component t0 WHERE t0.visible = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.visible AS visible_4,
  t0.introduction AS introduction_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.cover_file_name AS cover_file_name_8,
  t0.cover_mime_type AS cover_mime_type_9,
  t0.cover_path AS cover_path_10,
  t0.cover_size AS cover_size_11,
  t0.menu_cover_file_name AS menu_cover_file_name_12,
  t0.menu_cover_mime_type AS menu_cover_mime_type_13,
  t0.menu_cover_path AS menu_cover_path_14,
  t0.menu_cover_size AS menu_cover_size_15,
  t0.slug AS slug_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  product t0
WHERE
  t0.visible = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.visible AS visible_4, t0.introduction AS introduction_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.menu_cover_file_name AS menu_cover_file_name_12, t0.menu_cover_mime_type AS menu_cover_mime_type_13, t0.menu_cover_path AS menu_cover_path_14, t0.menu_cover_size AS menu_cover_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM product t0 WHERE t0.visible = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.introduction AS introduction_4,
  t0.visible AS visible_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.cover_file_name AS cover_file_name_8,
  t0.cover_mime_type AS cover_mime_type_9,
  t0.cover_path AS cover_path_10,
  t0.cover_size AS cover_size_11,
  t0.background_file_name AS background_file_name_12,
  t0.background_mime_type AS background_mime_type_13,
  t0.background_path AS background_path_14,
  t0.background_size AS background_size_15,
  t0.slug AS slug_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  component t0
WHERE
  t0.visible = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.introduction AS introduction_4, t0.visible AS visible_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.cover_file_name AS cover_file_name_8, t0.cover_mime_type AS cover_mime_type_9, t0.cover_path AS cover_path_10, t0.cover_size AS cover_size_11, t0.background_file_name AS background_file_name_12, t0.background_mime_type AS background_mime_type_13, t0.background_path AS background_path_14, t0.background_size AS background_size_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM component t0 WHERE t0.visible = 1;