Symfony Profiler

SELECT
  a0_.pay AS pay_0,
  a0_.only_logged AS only_logged_1,
  a0_.id AS id_2,
  a0_.name AS name_3,
  a0_.description AS description_4,
  a0_.slug AS slug_5,
  a0_.price_from_to AS price_from_to_6,
  a0_.hide_default_fields AS hide_default_fields_7,
  a0_.fields AS fields_8,
  a0_.package_group_id AS package_group_id_9
FROM
  advert_category a0_

SELECT a0_.pay AS pay_0, a0_.only_logged AS only_logged_1, a0_.id AS id_2, a0_.name AS name_3, a0_.description AS description_4, a0_.slug AS slug_5, a0_.price_from_to AS price_from_to_6, a0_.hide_default_fields AS hide_default_fields_7, a0_.fields AS fields_8, a0_.package_group_id AS package_group_id_9 FROM advert_category a0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.advert_category AS advert_category_3
FROM
  advert_type t0
WHERE
  t0.advert_category IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_category AS advert_category_3 FROM advert_type t0 WHERE t0.advert_category IN (2, 3, 4, 6, 7, 8, 9, 10);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.advert_type AS advert_type_3
FROM
  advert_subtype t0
WHERE
  t0.advert_type IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_type AS advert_type_3 FROM advert_subtype t0 WHERE t0.advert_type IN (1, 2, 3, 4, 5, 6, 7, 8);

SELECT
  a0_.id AS id_0,
  a0_.number AS number_1,
  a0_.if_promo AS if_promo_2,
  a0_.active AS active_3,
  a0_.sold AS sold_4,
  a0_.expired_active AS expired_active_5,
  a0_.views AS views_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.email AS email_8,
  a0_.title AS title_9,
  a0_.slug AS slug_10,
  a0_.currency AS currency_11,
  a0_.grossnet AS grossnet_12,
  a0_.price_negotiation AS price_negotiation_13,
  a0_.price AS price_14,
  a0_.price_pln AS price_pln_15,
  a0_.price_eur AS price_eur_16,
  a0_.price_usd AS price_usd_17,
  a0_.price_to AS price_to_18,
  a0_.price_to_pln AS price_to_pln_19,
  a0_.price_to_eur AS price_to_eur_20,
  a0_.price_to_usd AS price_to_usd_21,
  a0_.created_at AS created_at_22,
  a0_.updated_at AS updated_at_23,
  a0_.refreshed_at AS refreshed_at_24,
  a0_.expired_at AS expired_at_25,
  a0_.expire AS expire_26,
  a0_.expire_notify_at AS expire_notify_at_27,
  a0_.prices_updated_at AS prices_updated_at_28,
  a0_.category_id AS category_id_29,
  a0_.type_id AS type_id_30,
  a0_.subtype_id AS subtype_id_31,
  a0_.user_id AS user_id_32
FROM
  advert a0_
WHERE
  (a0_.deleted_at IS NULL)
ORDER BY
  a0_.views DESC
LIMIT
  2

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.if_promo AS if_promo_2, a0_.active AS active_3, a0_.sold AS sold_4, a0_.expired_active AS expired_active_5, a0_.views AS views_6, a0_.deleted_at AS deleted_at_7, a0_.email AS email_8, a0_.title AS title_9, a0_.slug AS slug_10, a0_.currency AS currency_11, a0_.grossnet AS grossnet_12, a0_.price_negotiation AS price_negotiation_13, a0_.price AS price_14, a0_.price_pln AS price_pln_15, a0_.price_eur AS price_eur_16, a0_.price_usd AS price_usd_17, a0_.price_to AS price_to_18, a0_.price_to_pln AS price_to_pln_19, a0_.price_to_eur AS price_to_eur_20, a0_.price_to_usd AS price_to_usd_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.refreshed_at AS refreshed_at_24, a0_.expired_at AS expired_at_25, a0_.expire AS expire_26, a0_.expire_notify_at AS expire_notify_at_27, a0_.prices_updated_at AS prices_updated_at_28, a0_.category_id AS category_id_29, a0_.type_id AS type_id_30, a0_.subtype_id AS subtype_id_31, a0_.user_id AS user_id_32 FROM advert a0_ WHERE (a0_.deleted_at IS NULL) ORDER BY a0_.views DESC LIMIT 2;

SELECT
  count(a0_.id) AS sclr_0
FROM
  advert a0_
WHERE
  (
    a0_.category_id IN (?)
    AND a0_.active = 1
  )
  AND (a0_.deleted_at IS NULL)

SELECT count(a0_.id) AS sclr_0 FROM advert a0_ WHERE (a0_.category_id IN (2) AND a0_.active = 1) AND (a0_.deleted_at IS NULL);

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.country_id AS country_id_2
FROM
  region r0_
  LEFT JOIN country c1_ ON r0_.country_id = c1_.id
WHERE
  c1_.name = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.country_id AS country_id_2 FROM region r0_ LEFT JOIN country c1_ ON r0_.country_id = c1_.id WHERE c1_.name = 'Polska';

SELECT
  count(a0_.id) AS sclr_0
FROM
  advert_attribute_search_8 a0_
  LEFT JOIN advert a1_ ON a0_.advert_id = a1_.id
  AND (a1_.deleted_at IS NULL)
  LEFT JOIN fos_user f2_ ON a1_.user_id = f2_.id
  AND (f2_.deleted_at IS NULL)
WHERE
  a0_.zapytania_data_wyjazdu >= ?
  AND a1_.active = 1

SELECT count(a0_.id) AS sclr_0 FROM advert_attribute_search_8 a0_ LEFT JOIN advert a1_ ON a0_.advert_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN fos_user f2_ ON a1_.user_id = f2_.id AND (f2_.deleted_at IS NULL) WHERE a0_.zapytania_data_wyjazdu >= '2026-10-28' AND a1_.active = 1;

SELECT
  DISTINCT p0_.advert_id AS sclr_0
FROM
  promo_adverts p0_
WHERE
  p0_.promo_id = 2
  AND p0_.expired_at > ?

SELECT DISTINCT p0_.advert_id AS sclr_0 FROM promo_adverts p0_ WHERE p0_.promo_id = 2 AND p0_.expired_at > '2026-10-28 17:21:47';

SELECT
  a0_.id AS id_0,
  CASE WHEN a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  ) THEN
    1
  ELSE
    0
  END AS sclr_1
FROM
  advert_attribute_search_8 a1_
  LEFT JOIN advert a0_ ON a1_.advert_id = a0_.id
  AND (a0_.deleted_at IS NULL)
  LEFT JOIN fos_user f2_ ON a0_.user_id = f2_.id
  AND (f2_.deleted_at IS NULL)
WHERE
  a1_.zapytania_data_wyjazdu >= ?
  AND a0_.active = 1
ORDER BY
  sclr_1 DESC,
  a0_.updated_at DESC

SELECT a0_.id AS id_0, CASE WHEN a0_.id IN (2114970, 2122833, 2122969, 2132319, 2132402, 2133301, 2135576, 2136444, 2136947, 2137375, 2137677, 2140055, 2140527, 2140529, 2140551, 2140689, 2141037, 2141053, 2141449, 2142092, 2142162, 2142726, 2142748, 2142751, 2142768, 2142789, 2142845, 2142917, 2143307, 2143314, 2143316, 2143733, 2144187, 2144191, 2144418, 2144451, 2144729, 2145072, 2145167, 2145185, 2145281, 2145465, 2145488, 2145515, 2145531, 2145748, 2145908, 2146017, 2146024, 2146058, 2146081, 2146149, 2146152, 2146268, 2146301, 2146366, 2146374, 2146380, 2146403, 2146440, 2146459, 2146471, 2146497, 2146505, 2146509, 2146635) THEN 1 ELSE 0 END AS sclr_1 FROM advert_attribute_search_8 a1_ LEFT JOIN advert a0_ ON a1_.advert_id = a0_.id AND (a0_.deleted_at IS NULL) LEFT JOIN fos_user f2_ ON a0_.user_id = f2_.id AND (f2_.deleted_at IS NULL) WHERE a1_.zapytania_data_wyjazdu >= '2026-10-28' AND a0_.active = 1 ORDER BY sclr_1 DESC, a0_.updated_at DESC;

SELECT
  count(a0_.id) AS sclr_0
FROM
  advert a0_
WHERE
  (
    a0_.category_id IN (?)
    AND a0_.active = 1
  )
  AND (a0_.deleted_at IS NULL)

SELECT count(a0_.id) AS sclr_0 FROM advert a0_ WHERE (a0_.category_id IN (10) AND a0_.active = 1) AND (a0_.deleted_at IS NULL);

SELECT
  a0_.id AS id_0,
  a0_.number AS number_1,
  a0_.if_promo AS if_promo_2,
  a0_.active AS active_3,
  a0_.sold AS sold_4,
  a0_.expired_active AS expired_active_5,
  a0_.views AS views_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.email AS email_8,
  a0_.title AS title_9,
  a0_.slug AS slug_10,
  a0_.currency AS currency_11,
  a0_.grossnet AS grossnet_12,
  a0_.price_negotiation AS price_negotiation_13,
  a0_.price AS price_14,
  a0_.price_pln AS price_pln_15,
  a0_.price_eur AS price_eur_16,
  a0_.price_usd AS price_usd_17,
  a0_.price_to AS price_to_18,
  a0_.price_to_pln AS price_to_pln_19,
  a0_.price_to_eur AS price_to_eur_20,
  a0_.price_to_usd AS price_to_usd_21,
  a0_.created_at AS created_at_22,
  a0_.updated_at AS updated_at_23,
  a0_.refreshed_at AS refreshed_at_24,
  a0_.expired_at AS expired_at_25,
  a0_.expire AS expire_26,
  a0_.expire_notify_at AS expire_notify_at_27,
  a0_.prices_updated_at AS prices_updated_at_28,
  a1_.id AS id_29,
  a1_.field_id AS field_id_30,
  a1_.value AS value_31,
  a1_.unit AS unit_32,
  a0_.category_id AS category_id_33,
  a0_.type_id AS type_id_34,
  a0_.subtype_id AS subtype_id_35,
  a0_.user_id AS user_id_36,
  a1_.advert_id AS advert_id_37
FROM
  advert a0_
  LEFT JOIN advert_attribute a1_ ON a0_.id = a1_.advert_id
WHERE
  (a0_.category_id = 7)
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.id ASC,
  a1_.id ASC

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.if_promo AS if_promo_2, a0_.active AS active_3, a0_.sold AS sold_4, a0_.expired_active AS expired_active_5, a0_.views AS views_6, a0_.deleted_at AS deleted_at_7, a0_.email AS email_8, a0_.title AS title_9, a0_.slug AS slug_10, a0_.currency AS currency_11, a0_.grossnet AS grossnet_12, a0_.price_negotiation AS price_negotiation_13, a0_.price AS price_14, a0_.price_pln AS price_pln_15, a0_.price_eur AS price_eur_16, a0_.price_usd AS price_usd_17, a0_.price_to AS price_to_18, a0_.price_to_pln AS price_to_pln_19, a0_.price_to_eur AS price_to_eur_20, a0_.price_to_usd AS price_to_usd_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.refreshed_at AS refreshed_at_24, a0_.expired_at AS expired_at_25, a0_.expire AS expire_26, a0_.expire_notify_at AS expire_notify_at_27, a0_.prices_updated_at AS prices_updated_at_28, a1_.id AS id_29, a1_.field_id AS field_id_30, a1_.value AS value_31, a1_.unit AS unit_32, a0_.category_id AS category_id_33, a0_.type_id AS type_id_34, a0_.subtype_id AS subtype_id_35, a0_.user_id AS user_id_36, a1_.advert_id AS advert_id_37 FROM advert a0_ LEFT JOIN advert_attribute a1_ ON a0_.id = a1_.advert_id WHERE (a0_.category_id = 7) AND (a0_.deleted_at IS NULL) ORDER BY a0_.id ASC, a1_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  part_category t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM part_category t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.part_category_id AS part_category_id_3
FROM
  part_subcategory t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.part_category_id AS part_category_id_3 FROM part_subcategory t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.advert_category AS advert_category_3
FROM
  advert_type t0
WHERE
  t0.advert_category = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_category AS advert_category_3 FROM advert_type t0 WHERE t0.advert_category = 10;

SELECT
  f0_.powiat AS powiat_0,
  MIN(a1_.id) AS sclr_1
FROM
  advert a1_
  INNER JOIN fos_user f0_ ON a1_.user_id = f0_.id
  AND (f0_.deleted_at IS NULL)
WHERE
  (
    a1_.category_id = ?
    AND a1_.active = 1
  )
  AND (a1_.deleted_at IS NULL)
GROUP BY
  f0_.powiat
ORDER BY
  sclr_1 ASC

SELECT f0_.powiat AS powiat_0, MIN(a1_.id) AS sclr_1 FROM advert a1_ INNER JOIN fos_user f0_ ON a1_.user_id = f0_.id AND (f0_.deleted_at IS NULL) WHERE (a1_.category_id = 6 AND a1_.active = 1) AND (a1_.deleted_at IS NULL) GROUP BY f0_.powiat ORDER BY sclr_1 ASC;