Symfony Profiler

SELECT
  w0_.id AS id_0,
  w0_.date_public AS date_public_1,
  w0_.date_from AS date_from_2,
  w0_.date_to AS date_to_3,
  w0_.is_active AS is_active_4,
  w0_.is_popup AS is_popup_5,
  w0_.createts AS createts_6,
  w0_.editts AS editts_7,
  w1_.locale AS locale_8,
  w1_.title AS title_9,
  w1_.slug AS slug_10,
  w1_.description AS description_11,
  w1_.image AS image_12,
  w1_.createts AS createts_13,
  w1_.editts AS editts_14,
  w1_.id AS id_15,
  w0_.create_user_id AS create_user_id_16,
  w0_.edit_user_id AS edit_user_id_17,
  w1_.create_user_id AS create_user_id_18,
  w1_.edit_user_id AS edit_user_id_19,
  w1_.translatable_id AS translatable_id_20
FROM
  web_news w0_
  INNER JOIN web_news_translation w1_ ON w0_.id = w1_.translatable_id
  AND (w1_.locale = ?)
WHERE
  w0_.is_active = 1
  AND (
    w0_.date_from IS NULL
    OR (
      ? BETWEEN w0_.date_from
      AND w0_.date_to
    )
  )
ORDER BY
  w0_.date_public DESC
LIMIT
  3

SELECT w0_.id AS id_0, w0_.date_public AS date_public_1, w0_.date_from AS date_from_2, w0_.date_to AS date_to_3, w0_.is_active AS is_active_4, w0_.is_popup AS is_popup_5, w0_.createts AS createts_6, w0_.editts AS editts_7, w1_.locale AS locale_8, w1_.title AS title_9, w1_.slug AS slug_10, w1_.description AS description_11, w1_.image AS image_12, w1_.createts AS createts_13, w1_.editts AS editts_14, w1_.id AS id_15, w0_.create_user_id AS create_user_id_16, w0_.edit_user_id AS edit_user_id_17, w1_.create_user_id AS create_user_id_18, w1_.edit_user_id AS edit_user_id_19, w1_.translatable_id AS translatable_id_20 FROM web_news w0_ INNER JOIN web_news_translation w1_ ON w0_.id = w1_.translatable_id AND (w1_.locale = 'cs') WHERE w0_.is_active = 1 AND (w0_.date_from IS NULL OR ('2026-10-26 15:39:43' BETWEEN w0_.date_from AND w0_.date_to)) ORDER BY w0_.date_public DESC LIMIT 3;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.date_from AS date_from_2,
  w0_.date_to AS date_to_3,
  w0_.is_active AS is_active_4,
  w0_.position AS position_5,
  w0_.createts AS createts_6,
  w0_.editts AS editts_7,
  w1_.locale AS locale_8,
  w1_.label AS label_9,
  w1_.title AS title_10,
  w1_.subtitle AS subtitle_11,
  w1_.url AS url_12,
  w1_.image AS image_13,
  w1_.image_mobile AS image_mobile_14,
  w1_.createts AS createts_15,
  w1_.editts AS editts_16,
  w1_.id AS id_17,
  w0_.create_user_id AS create_user_id_18,
  w0_.edit_user_id AS edit_user_id_19,
  w1_.create_user_id AS create_user_id_20,
  w1_.edit_user_id AS edit_user_id_21,
  w1_.translatable_id AS translatable_id_22
FROM
  web_slide_show w0_
  LEFT JOIN web_slide_show_translation w1_ ON w0_.id = w1_.translatable_id
  AND (w1_.locale = ?)
WHERE
  w0_.is_active = 1
  AND (
    DATE(
      NOW()
    ) BETWEEN w0_.date_from
    AND w0_.date_to
  )
  AND w1_.image IS NOT NULL
ORDER BY
  w0_.position ASC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.date_from AS date_from_2, w0_.date_to AS date_to_3, w0_.is_active AS is_active_4, w0_.position AS position_5, w0_.createts AS createts_6, w0_.editts AS editts_7, w1_.locale AS locale_8, w1_.label AS label_9, w1_.title AS title_10, w1_.subtitle AS subtitle_11, w1_.url AS url_12, w1_.image AS image_13, w1_.image_mobile AS image_mobile_14, w1_.createts AS createts_15, w1_.editts AS editts_16, w1_.id AS id_17, w0_.create_user_id AS create_user_id_18, w0_.edit_user_id AS edit_user_id_19, w1_.create_user_id AS create_user_id_20, w1_.edit_user_id AS edit_user_id_21, w1_.translatable_id AS translatable_id_22 FROM web_slide_show w0_ LEFT JOIN web_slide_show_translation w1_ ON w0_.id = w1_.translatable_id AND (w1_.locale = 'cs') WHERE w0_.is_active = 1 AND (DATE(NOW()) BETWEEN w0_.date_from AND w0_.date_to) AND w1_.image IS NOT NULL ORDER BY w0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.host AS host_4,
  t0.createts AS createts_5,
  t0.locale AS locale_6,
  t0.currencies AS currencies_7,
  t0.editts AS editts_8,
  t0.create_user_id AS create_user_id_9,
  t0.edit_user_id AS edit_user_id_10
FROM
  domain t0
WHERE
  t0.host = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.host AS host_4, t0.createts AS createts_5, t0.locale AS locale_6, t0.currencies AS currencies_7, t0.editts AS editts_8, t0.create_user_id AS create_user_id_9, t0.edit_user_id AS edit_user_id_10 FROM domain t0 WHERE t0.host = 'freeport.docker.internal.ablevyvoj.cz' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.image AS image_1,
  p0_.code AS code_2,
  p0_.hash AS hash_3,
  p0_.is_active AS is_active_4,
  p0_.only_for_adults AS only_for_adults_5,
  p0_.createts AS createts_6,
  p0_.editts AS editts_7,
  p0_.translated AS translated_8,
  p1_.discount_percent AS discount_percent_9
FROM
  product p0_
  LEFT JOIN variant v2_ ON p0_.id = v2_.product_id
  AND (v2_.is_active = 1)
  LEFT JOIN pricelist p1_ ON p0_.id = p1_.product_id
  AND (p1_.currency = ?)
WHERE
  p0_.dealer_id <> 4
  AND p0_.is_active = 1
  AND p0_.only_for_adults = 0
  AND v2_.is_active = 1
  AND p0_.category_id IS NOT NULL
  AND p0_.image IS NOT NULL
GROUP BY
  p0_.id
ORDER BY
  p1_.discount_percent DESC
LIMIT
  16

SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.code AS code_2, p0_.hash AS hash_3, p0_.is_active AS is_active_4, p0_.only_for_adults AS only_for_adults_5, p0_.createts AS createts_6, p0_.editts AS editts_7, p0_.translated AS translated_8, p1_.discount_percent AS discount_percent_9 FROM product p0_ LEFT JOIN variant v2_ ON p0_.id = v2_.product_id AND (v2_.is_active = 1) LEFT JOIN pricelist p1_ ON p0_.id = p1_.product_id AND (p1_.currency = 'CZK') WHERE p0_.dealer_id <> 4 AND p0_.is_active = 1 AND p0_.only_for_adults = 0 AND v2_.is_active = 1 AND p0_.category_id IS NOT NULL AND p0_.image IS NOT NULL GROUP BY p0_.id ORDER BY p1_.discount_percent DESC LIMIT 16;

SELECT
  a0_.id AS id_0,
  a0_.is_active AS is_active_1,
  a0_.from_outlet_price AS from_outlet_price_2,
  a0_.from_normal_price AS from_normal_price_3,
  a0_.is_public AS is_public_4,
  a0_.date_from AS date_from_5,
  a0_.date_to AS date_to_6,
  a0_.public_date AS public_date_7,
  a0_.createts AS createts_8,
  a0_.editts AS editts_9,
  a0_.image AS image_10,
  a1_.locale AS locale_11,
  a1_.name AS name_12,
  a1_.title AS title_13,
  a1_.sub_title AS sub_title_14,
  a1_.description AS description_15,
  a1_.id AS id_16,
  a0_.store_id AS store_id_17,
  a0_.category_id AS category_id_18,
  a0_.top_category_id AS top_category_id_19,
  a0_.create_user_id AS create_user_id_20,
  a0_.edit_user_id AS edit_user_id_21,
  a1_.translatable_id AS translatable_id_22
FROM
  app_offer a0_
  LEFT JOIN app_offer_translation a1_ ON a0_.id = a1_.translatable_id
WHERE
  a0_.is_active = 1
  AND a0_.is_public = 1
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.from_outlet_price AS from_outlet_price_2, a0_.from_normal_price AS from_normal_price_3, a0_.is_public AS is_public_4, a0_.date_from AS date_from_5, a0_.date_to AS date_to_6, a0_.public_date AS public_date_7, a0_.createts AS createts_8, a0_.editts AS editts_9, a0_.image AS image_10, a1_.locale AS locale_11, a1_.name AS name_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.description AS description_15, a1_.id AS id_16, a0_.store_id AS store_id_17, a0_.category_id AS category_id_18, a0_.top_category_id AS top_category_id_19, a0_.create_user_id AS create_user_id_20, a0_.edit_user_id AS edit_user_id_21, a1_.translatable_id AS translatable_id_22 FROM app_offer a0_ LEFT JOIN app_offer_translation a1_ ON a0_.id = a1_.translatable_id WHERE a0_.is_active = 1 AND a0_.is_public = 1 ORDER BY a0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.image AS image_1,
  p0_.code AS code_2,
  p0_.hash AS hash_3,
  p0_.is_active AS is_active_4,
  p0_.only_for_adults AS only_for_adults_5,
  p0_.createts AS createts_6,
  p0_.editts AS editts_7,
  p0_.translated AS translated_8
FROM
  product p0_
  LEFT JOIN variant v1_ ON p0_.id = v1_.product_id
  AND (v1_.is_active = 1)
  LEFT JOIN pricelist p2_ ON p0_.id = p2_.product_id
  AND (p2_.currency = ?)
WHERE
  (
    p0_.dealer_id <> 4
    AND p0_.is_active = 1
    AND p0_.only_for_adults = 0
    AND v1_.is_active = 1
    AND p0_.category_id IS NOT NULL
    AND p0_.image IS NOT NULL
  )
  AND p2_.price > 0
GROUP BY
  p0_.id
ORDER BY
  p0_.id DESC
LIMIT
  16

SELECT p0_.id AS id_0, p0_.image AS image_1, p0_.code AS code_2, p0_.hash AS hash_3, p0_.is_active AS is_active_4, p0_.only_for_adults AS only_for_adults_5, p0_.createts AS createts_6, p0_.editts AS editts_7, p0_.translated AS translated_8 FROM product p0_ LEFT JOIN variant v1_ ON p0_.id = v1_.product_id AND (v1_.is_active = 1) LEFT JOIN pricelist p2_ ON p0_.id = p2_.product_id AND (p2_.currency = 'CZK') WHERE (p0_.dealer_id <> 4 AND p0_.is_active = 1 AND p0_.only_for_adults = 0 AND v1_.is_active = 1 AND p0_.category_id IS NOT NULL AND p0_.image IS NOT NULL) AND p2_.price > 0 GROUP BY p0_.id ORDER BY p0_.id DESC LIMIT 16;