Symfony Profiler

SELECT
  n0_.title AS title_0,
  n0_.body AS body_1,
  n0_.short AS short_2,
  n0_.status AS status_3,
  n0_.slug AS slug_4,
  n0_.created_at AS created_at_5,
  n0_.updated_at AS updated_at_6,
  n0_.id AS id_7,
  n0_.user_id AS user_id_8
FROM
  news n0_
ORDER BY
  n0_.updated_at DESC
LIMIT
  25

SELECT n0_.title AS title_0, n0_.body AS body_1, n0_.short AS short_2, n0_.status AS status_3, n0_.slug AS slug_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.id AS id_7, n0_.user_id AS user_id_8 FROM news n0_ ORDER BY n0_.updated_at DESC LIMIT 25;

SELECT
  count(1) AS sclr_0
FROM
  news n0_

SELECT count(1) AS sclr_0 FROM news n0_;

SELECT
  p.id,
  p.slug,
  p.name,
  p.description_short,
  p.price_sell,
  p.price_offer,
  p.tax_type,
  p.on_offer,
  b.id AS brand_id,
  b.name AS brand_name,
  b.slug AS brand_slug
FROM
  products p
  LEFT JOIN products_brands b ON b.id = p.brand_id
WHERE
  p.status = ?
  AND p.showcase = ?
ORDER BY
  p.updated_at DESC
LIMIT
  ?

SELECT p.id, p.slug, p.name, p.description_short, p.price_sell, p.price_offer, p.tax_type, p.on_offer,
                    b.id AS brand_id, b.name AS brand_name, b.slug AS brand_slug
             FROM products p
             LEFT JOIN products_brands b ON b.id = p.brand_id
             WHERE p.status = 1 AND p.showcase = 1
             ORDER BY p.updated_at DESC
             LIMIT 25;

SELECT
  p.id,
  p.slug,
  p.name,
  p.description_short,
  p.price_sell,
  p.price_offer,
  p.tax_type,
  p.on_offer,
  b.id AS brand_id,
  b.name AS brand_name,
  b.slug AS brand_slug
FROM
  products p
  LEFT JOIN products_brands b ON b.id = p.brand_id
WHERE
  p.status = ?
  AND p.on_offer = ?
  AND p.show_on_home_deals = ?
ORDER BY
  p.updated_at DESC
LIMIT
  ?

SELECT p.id, p.slug, p.name, p.description_short, p.price_sell, p.price_offer, p.tax_type, p.on_offer,
                    b.id AS brand_id, b.name AS brand_name, b.slug AS brand_slug
             FROM products p
             LEFT JOIN products_brands b ON b.id = p.brand_id
             WHERE p.status = 1 AND p.on_offer = 1 AND p.show_on_home_deals = 1
             ORDER BY p.updated_at DESC
             LIMIT 25;

SELECT
  p.id,
  p.slug,
  p.name,
  p.description_short,
  p.price_sell,
  p.price_offer,
  p.tax_type,
  p.on_offer,
  b.id AS brand_id,
  b.name AS brand_name,
  b.slug AS brand_slug
FROM
  products p
  LEFT JOIN products_brands b ON b.id = p.brand_id
WHERE
  p.status = ?
  AND p.new = ?
  AND p.show_on_home_new_products = ?
ORDER BY
  p.updated_at DESC
LIMIT
  ?

SELECT p.id, p.slug, p.name, p.description_short, p.price_sell, p.price_offer, p.tax_type, p.on_offer,
                    b.id AS brand_id, b.name AS brand_name, b.slug AS brand_slug
             FROM products p
             LEFT JOIN products_brands b ON b.id = p.brand_id
             WHERE p.status = 1 AND p.new = 1 AND p.show_on_home_new_products = 1
             ORDER BY p.updated_at DESC
             LIMIT 25;

SELECT
  pc.product_id,
  c.id,
  c.name
FROM
  products_rel_categories pc
  INNER JOIN products_categories c ON c.id = pc.category_id
WHERE
  pc.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT pc.product_id, c.id, c.name
             FROM products_rel_categories pc
             INNER JOIN products_categories c ON c.id = pc.category_id
             WHERE pc.product_id IN (86273, 71170, 85511, 71967, 69924, 2115, 2170, 68731, 74665, 71141, 70894, 86254, 71678, 81412, 84996, 87826, 87827, 87829, 82966, 87830, 88089, 82972, 86049, 82978, 83496, 83497, 83498, 69679, 81455, 82224, 87857, 88114, 82227, 87860, 86582, 85816, 88065, 83714, 83715, 83716, 87556, 85509, 87045, 85510, 83207, 88839, 85512, 85768, 88072, 88840, 82185, 85513, 85514, 88075, 82446, 87566, 80911, 84239, 81936);

SELECT
  pm.product_id,
  COALESCE(mw.path, m.path) AS image_path
FROM
  products_medias pm
  INNER JOIN media m ON m.id = pm.media_id
  LEFT JOIN media_watermark mw ON mw.id = m.media_watermark_id
WHERE
  pm.product_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  pm.product_id ASC,
  pm.is_main DESC,
  pm.position ASC

SELECT pm.product_id, COALESCE(mw.path, m.path) AS image_path
             FROM products_medias pm
             INNER JOIN media m ON m.id = pm.media_id
             LEFT JOIN media_watermark mw ON mw.id = m.media_watermark_id
             WHERE pm.product_id IN (86273, 71170, 85511, 71967, 69924, 2115, 2170, 68731, 74665, 71141, 70894, 86254, 71678, 81412, 84996, 87826, 87827, 87829, 82966, 87830, 88089, 82972, 86049, 82978, 83496, 83497, 83498, 69679, 81455, 82224, 87857, 88114, 82227, 87860, 86582, 85816, 88065, 83714, 83715, 83716, 87556, 85509, 87045, 85510, 83207, 88839, 85512, 85768, 88072, 88840, 82185, 85513, 85514, 88075, 82446, 87566, 80911, 84239, 81936)
             ORDER BY pm.product_id ASC, pm.is_main DESC, pm.position ASC;

SELECT
  b0_.name AS name_0,
  b0_.link_to AS link_to_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.updated_at AS updated_at_4,
  b0_.id AS id_5
FROM
  banners b0_
  INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id
WHERE
  b0_.status = ?
  AND b1_.location = ?
ORDER BY
  b1_.position ASC
LIMIT
  25

SELECT b0_.name AS name_0, b0_.link_to AS link_to_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.id AS id_5 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = 2 AND b1_.location = 1 ORDER BY b1_.position ASC LIMIT 25;

SELECT
  count(1) AS sclr_0
FROM
  banners b0_
  INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id
WHERE
  b0_.status = ?
  AND b1_.location = ?

SELECT count(1) AS sclr_0 FROM banners b0_ INNER JOIN banner_location_position b1_ ON b0_.id = b1_.banner_id WHERE b0_.status = 2 AND b1_.location = 1;

SELECT
  t0.position AS position_1,
  t0.is_main AS is_main_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5,
  t0.news_id AS news_id_6,
  t0.media_id AS media_id_7
FROM
  news_medias t0
WHERE
  t0.news_id = ?

SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.news_id AS news_id_6, t0.media_id AS media_id_7 FROM news_medias t0 WHERE t0.news_id = '955bfa3e-03ec-4634-8de4-d483c7d62c95';

SELECT
  t0.content_type AS content_type_1,
  t0.filename AS filename_2,
  t0.file_extension AS file_extension_3,
  t0.path AS path_4,
  t0.md5 AS md5_5,
  t0.file_size AS file_size_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.id AS id_11,
  t0.media_watermark_id AS media_watermark_id_12
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = '92dfcf6f-7df6-4cb5-8259-83b5f8376c5c';

SELECT
  t0.position AS position_1,
  t0.is_main AS is_main_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5,
  t0.news_id AS news_id_6,
  t0.media_id AS media_id_7
FROM
  news_medias t0
WHERE
  t0.news_id = ?

SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.news_id AS news_id_6, t0.media_id AS media_id_7 FROM news_medias t0 WHERE t0.news_id = 'c1d775db-2e70-4e23-957e-b95819111e10';

SELECT
  t0.content_type AS content_type_1,
  t0.filename AS filename_2,
  t0.file_extension AS file_extension_3,
  t0.path AS path_4,
  t0.md5 AS md5_5,
  t0.file_size AS file_size_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.id AS id_11,
  t0.media_watermark_id AS media_watermark_id_12
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = 'e8b4b6bb-1c74-4529-a738-cc445fbef22c';

SELECT
  t0.location AS location_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.banner_id AS banner_id_4,
  t0.brand_id AS brand_id_5,
  t0.category_id AS category_id_6
FROM
  banner_location_position t0
WHERE
  t0.banner_id = ?

SELECT t0.location AS location_1, t0.position AS position_2, t0.id AS id_3, t0.banner_id AS banner_id_4, t0.brand_id AS brand_id_5, t0.category_id AS category_id_6 FROM banner_location_position t0 WHERE t0.banner_id = 'cf443ada-c557-4361-98dc-3dc5949a9f40';

SELECT
  t0.position AS position_1,
  t0.is_main AS is_main_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5,
  t0.banner_id AS banner_id_6,
  t0.media_id AS media_id_7
FROM
  banners_medias t0
WHERE
  t0.banner_id = ?

SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.banner_id AS banner_id_6, t0.media_id AS media_id_7 FROM banners_medias t0 WHERE t0.banner_id = 'cf443ada-c557-4361-98dc-3dc5949a9f40';

SELECT
  t0.content_type AS content_type_1,
  t0.filename AS filename_2,
  t0.file_extension AS file_extension_3,
  t0.path AS path_4,
  t0.md5 AS md5_5,
  t0.file_size AS file_size_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.id AS id_11,
  t0.media_watermark_id AS media_watermark_id_12
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = '0d019414-469b-43e8-a079-a3aca1a4aa75';

SELECT
  t0.location AS location_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.banner_id AS banner_id_4,
  t0.brand_id AS brand_id_5,
  t0.category_id AS category_id_6
FROM
  banner_location_position t0
WHERE
  t0.banner_id = ?

SELECT t0.location AS location_1, t0.position AS position_2, t0.id AS id_3, t0.banner_id AS banner_id_4, t0.brand_id AS brand_id_5, t0.category_id AS category_id_6 FROM banner_location_position t0 WHERE t0.banner_id = '34daaef3-cecd-4cf4-927a-3114608d0bf6';

SELECT
  t0.position AS position_1,
  t0.is_main AS is_main_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5,
  t0.banner_id AS banner_id_6,
  t0.media_id AS media_id_7
FROM
  banners_medias t0
WHERE
  t0.banner_id = ?

SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.banner_id AS banner_id_6, t0.media_id AS media_id_7 FROM banners_medias t0 WHERE t0.banner_id = '34daaef3-cecd-4cf4-927a-3114608d0bf6';

SELECT
  t0.content_type AS content_type_1,
  t0.filename AS filename_2,
  t0.file_extension AS file_extension_3,
  t0.path AS path_4,
  t0.md5 AS md5_5,
  t0.file_size AS file_size_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.id AS id_11,
  t0.media_watermark_id AS media_watermark_id_12
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.content_type AS content_type_1, t0.filename AS filename_2, t0.file_extension AS file_extension_3, t0.path AS path_4, t0.md5 AS md5_5, t0.file_size AS file_size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.id AS id_11, t0.media_watermark_id AS media_watermark_id_12 FROM media t0 WHERE t0.id = 'f8941def-8654-4488-a8a2-93fb47f9a124';

SELECT
  t0.keyname AS keyname_1,
  t0.value AS value_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.id AS id_5
FROM
  configuration t0
WHERE
  t0.keyname = ?
LIMIT
  1

SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = 'info_header_contact_1' LIMIT 1;

SELECT
  t0.keyname AS keyname_1,
  t0.value AS value_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.id AS id_5
FROM
  configuration t0
WHERE
  t0.keyname = ?
LIMIT
  1

SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = 'info_header_contact_2' LIMIT 1;

SELECT
  t0.keyname AS keyname_1,
  t0.value AS value_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.id AS id_5
FROM
  configuration t0
WHERE
  t0.keyname = ?
LIMIT
  1

SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = 'info_opening_hours_1' LIMIT 1;

SELECT
  t0.keyname AS keyname_1,
  t0.value AS value_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.id AS id_5
FROM
  configuration t0
WHERE
  t0.keyname = ?
LIMIT
  1

SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = 'info_opening_hours_2' LIMIT 1;

SELECT
  p0_.name AS name_0,
  p0_.url AS url_1,
  p0_.status AS status_2,
  p0_.date_start AS date_start_3,
  p0_.date_end AS date_end_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  p0_.id AS id_7
FROM
  promotions p0_
WHERE
  p0_.status = ?
ORDER BY
  p0_.date_start ASC
LIMIT
  30

SELECT p0_.name AS name_0, p0_.url AS url_1, p0_.status AS status_2, p0_.date_start AS date_start_3, p0_.date_end AS date_end_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.id AS id_7 FROM promotions p0_ WHERE p0_.status = 1 ORDER BY p0_.date_start ASC LIMIT 30;

SELECT
  count(1) AS sclr_0
FROM
  promotions p0_
WHERE
  p0_.status = ?

SELECT count(1) AS sclr_0 FROM promotions p0_ WHERE p0_.status = 1;