Symfony Profiler

SELECT
  count(a0_.id) AS sclr_0
FROM
  advert_attribute_search_2 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
  a1_.active = 1

SELECT count(a0_.id) AS sclr_0 FROM advert_attribute_search_2 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 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 19:24:23';

SELECT
  a0_.id AS id_0,
  CASE WHEN a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  ) THEN
    1
  ELSE
    0
  END AS sclr_1
FROM
  advert_attribute_search_2 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
  a0_.active = 1
ORDER BY
  sclr_1 DESC,
  a0_.updated_at DESC
LIMIT
  20

SELECT a0_.id AS id_0, CASE WHEN a0_.id IN (2114970, 2122833, 2122969, 2132319, 2132402, 2133301, 2136444, 2136947, 2137375, 2137677, 2140055, 2140527, 2140529, 2140551, 2140689, 2141037, 2141053, 2142092, 2142162, 2142726, 2142748, 2142751, 2142768, 2142789, 2142845, 2142917, 2143307, 2143314, 2143316, 2143733, 2144187, 2144191, 2144418, 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_2 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 a0_.active = 1 ORDER BY sclr_1 DESC, a0_.updated_at DESC LIMIT 20;

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_.pay AS pay_29,
  a1_.only_logged AS only_logged_30,
  a1_.id AS id_31,
  a1_.name AS name_32,
  a1_.description AS description_33,
  a1_.slug AS slug_34,
  a1_.price_from_to AS price_from_to_35,
  a1_.hide_default_fields AS hide_default_fields_36,
  a1_.fields AS fields_37,
  f2_.id AS id_38,
  f2_.company_name AS company_name_39,
  f2_.phone AS phone_40,
  f2_.phone_mobile AS phone_mobile_41,
  f2_.postal_code AS postal_code_42,
  f2_.city AS city_43,
  f2_.street AS street_44,
  f2_.geocode AS geocode_45,
  f2_.www AS www_46,
  f2_.comment AS comment_47,
  f2_.pdo AS pdo_48,
  f2_.invoice_nip AS invoice_nip_49,
  f2_.invoice_company_name AS invoice_company_name_50,
  f2_.invoice_name AS invoice_name_51,
  f2_.invoice_postal_code AS invoice_postal_code_52,
  f2_.invoice_city AS invoice_city_53,
  f2_.invoice_street AS invoice_street_54,
  f2_.invoice_phone AS invoice_phone_55,
  f2_.invoice_delivery AS invoice_delivery_56,
  f2_.invoice_delivery_name AS invoice_delivery_name_57,
  f2_.invoice_delivery_postal_code AS invoice_delivery_postal_code_58,
  f2_.invoice_delivery_city AS invoice_delivery_city_59,
  f2_.invoice_delivery_street AS invoice_delivery_street_60,
  f2_.profile_title_top AS profile_title_top_61,
  f2_.profile_title_bottom AS profile_title_bottom_62,
  f2_.deleted_at AS deleted_at_63,
  f2_.userpage_home AS userpage_home_64,
  f2_.lang AS lang_65,
  f2_.last_activity AS last_activity_66,
  f2_.profile_url AS profile_url_67,
  f2_.expire_notify_at AS expire_notify_at_68,
  f2_.expired_at AS expired_at_69,
  f2_.test AS test_70,
  f2_.powiat AS powiat_71,
  f2_.about AS about_72,
  f2_.views AS views_73,
  f2_.name AS name_74,
  f2_.username AS username_75,
  f2_.username_canonical AS username_canonical_76,
  f2_.email AS email_77,
  f2_.email_canonical AS email_canonical_78,
  f2_.enabled AS enabled_79,
  f2_.salt AS salt_80,
  f2_.password AS password_81,
  f2_.last_login AS last_login_82,
  f2_.confirmation_token AS confirmation_token_83,
  f2_.password_requested_at AS password_requested_at_84,
  f2_.roles AS roles_85
FROM
  advert a0_
  LEFT JOIN advert_category a1_ ON a0_.category_id = a1_.id
  LEFT JOIN fos_user f2_ ON a0_.user_id = f2_.id
  AND (f2_.deleted_at IS NULL)
WHERE
  (
    a0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )
  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_.pay AS pay_29, a1_.only_logged AS only_logged_30, a1_.id AS id_31, a1_.name AS name_32, a1_.description AS description_33, a1_.slug AS slug_34, a1_.price_from_to AS price_from_to_35, a1_.hide_default_fields AS hide_default_fields_36, a1_.fields AS fields_37, f2_.id AS id_38, f2_.company_name AS company_name_39, f2_.phone AS phone_40, f2_.phone_mobile AS phone_mobile_41, f2_.postal_code AS postal_code_42, f2_.city AS city_43, f2_.street AS street_44, f2_.geocode AS geocode_45, f2_.www AS www_46, f2_.comment AS comment_47, f2_.pdo AS pdo_48, f2_.invoice_nip AS invoice_nip_49, f2_.invoice_company_name AS invoice_company_name_50, f2_.invoice_name AS invoice_name_51, f2_.invoice_postal_code AS invoice_postal_code_52, f2_.invoice_city AS invoice_city_53, f2_.invoice_street AS invoice_street_54, f2_.invoice_phone AS invoice_phone_55, f2_.invoice_delivery AS invoice_delivery_56, f2_.invoice_delivery_name AS invoice_delivery_name_57, f2_.invoice_delivery_postal_code AS invoice_delivery_postal_code_58, f2_.invoice_delivery_city AS invoice_delivery_city_59, f2_.invoice_delivery_street AS invoice_delivery_street_60, f2_.profile_title_top AS profile_title_top_61, f2_.profile_title_bottom AS profile_title_bottom_62, f2_.deleted_at AS deleted_at_63, f2_.userpage_home AS userpage_home_64, f2_.lang AS lang_65, f2_.last_activity AS last_activity_66, f2_.profile_url AS profile_url_67, f2_.expire_notify_at AS expire_notify_at_68, f2_.expired_at AS expired_at_69, f2_.test AS test_70, f2_.powiat AS powiat_71, f2_.about AS about_72, f2_.views AS views_73, f2_.name AS name_74, f2_.username AS username_75, f2_.username_canonical AS username_canonical_76, f2_.email AS email_77, f2_.email_canonical AS email_canonical_78, f2_.enabled AS enabled_79, f2_.salt AS salt_80, f2_.password AS password_81, f2_.last_login AS last_login_82, f2_.confirmation_token AS confirmation_token_83, f2_.password_requested_at AS password_requested_at_84, f2_.roles AS roles_85 FROM advert a0_ LEFT JOIN advert_category a1_ ON a0_.category_id = a1_.id LEFT JOIN fos_user f2_ ON a0_.user_id = f2_.id AND (f2_.deleted_at IS NULL) WHERE (a0_.id IN (2146635, 2145908, 2145531, 2146509, 2146505, 2146497, 2145748, 2146024, 2146149, 2142092, 2146152, 2146374, 2146017, 2143314, 2140055, 2143316, 2146081, 2145281, 2145185, 2143307)) AND (a0_.deleted_at IS NULL);

SELECT
  p0_.advert_id AS sclr_0,
  p0_.expired_at AS expired_at_1
FROM
  promo_adverts p0_
WHERE
  p0_.advert_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND p0_.promo_id = 2
ORDER BY
  p0_.id ASC

SELECT p0_.advert_id AS sclr_0, p0_.expired_at AS expired_at_1 FROM promo_adverts p0_ WHERE p0_.advert_id IN (2146635, 2145908, 2145531, 2146509, 2146505, 2146497, 2145748, 2146024, 2146149, 2142092, 2146152, 2146374, 2146017, 2143314, 2140055, 2143316, 2146081, 2145281, 2145185, 2143307) AND p0_.promo_id = 2 ORDER BY p0_.id 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 = ?
    AND a1_.active = 1
    AND f0_.powiat <> ''
  )
  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 = 10 AND a1_.active = 1 AND f0_.powiat <> '') AND (a1_.deleted_at IS NULL) GROUP BY f0_.powiat ORDER BY sclr_1 ASC;

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
  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 19:24:23';