Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.active AS active_5,
  t0.breeding_description AS breeding_description_6,
  t0.title AS title_7,
  t0.meta_title AS meta_title_8,
  t0.meta_keywords AS meta_keywords_9,
  t0.meta_description AS meta_description_10,
  t0.image_id AS image_id_11
FROM
  type t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.active AS active_5, t0.breeding_description AS breeding_description_6, t0.title AS title_7, t0.meta_title AS meta_title_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.image_id AS image_id_11 FROM type t0 WHERE t0.slug = 'zwierzeta-na-sprzedaz' AND t0.active = 1 LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.slug AS slug_2,
  f0_.type AS type_3,
  f0_.required AS required_4,
  f0_.all_categories AS all_categories_5,
  f0_.search AS search_6,
  f0_.choices AS choices_7,
  f0_.position AS position_8
FROM
  filter f0_
  LEFT JOIN filter_category f2_ ON f0_.id = f2_.filter_id
  LEFT JOIN category c1_ ON c1_.id = f2_.category_id
WHERE
  f0_.all_categories = 1
ORDER BY
  f0_.position ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.type AS type_3, f0_.required AS required_4, f0_.all_categories AS all_categories_5, f0_.search AS search_6, f0_.choices AS choices_7, f0_.position AS position_8 FROM filter f0_ LEFT JOIN filter_category f2_ ON f0_.id = f2_.filter_id LEFT JOIN category c1_ ON c1_.id = f2_.category_id WHERE f0_.all_categories = 1 ORDER BY f0_.position ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.regon AS regon_2,
  f0_.description AS description_3,
  f0_.show_badge AS show_badge_4,
  f0_.full_name AS full_name_5,
  f0_.show_table AS show_table_6
FROM
  federation f0_
  LEFT JOIN association a1_ ON f0_.id = a1_.federation_id
  LEFT JOIN breeding b2_ ON a1_.id = b2_.association_id
GROUP BY
  f0_.id,
  f0_.name,
  f0_.regon,
  f0_.description,
  f0_.show_badge,
  f0_.full_name,
  f0_.show_table
HAVING
  COUNT(a1_.id) > 0
  AND COUNT(b2_.id) > 0
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.regon AS regon_2, f0_.description AS description_3, f0_.show_badge AS show_badge_4, f0_.full_name AS full_name_5, f0_.show_table AS show_table_6 FROM federation f0_ LEFT JOIN association a1_ ON f0_.id = a1_.federation_id LEFT JOIN breeding b2_ ON a1_.id = b2_.association_id GROUP BY f0_.id, f0_.name, f0_.regon, f0_.description, f0_.show_badge, f0_.full_name, f0_.show_table HAVING COUNT(a1_.id) > 0 AND COUNT(b2_.id) > 0 ORDER BY f0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4
FROM
  province t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM province t0 ORDER BY t0.name ASC;

SELECT
  s0_.name AS name_0,
  s0_.value AS value_1
FROM
  setting s0_

SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_;

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date_created_at AS date_created_at_1
FROM
  offer o0_
  LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON o0_.category_id = c2_.id
  LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id
  LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id
  LEFT JOIN province p5_ ON u1_.province_id = p5_.id
  LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id
  LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id
  LEFT JOIN association a8_ ON b6_.association_id = a8_.id
  LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id
  LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id
  LEFT JOIN image i10_ ON i10_.id = o11_.image_id
  LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id
  LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id
  LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id
WHERE
  o0_.status = ?
  AND o0_.started_at < ?
  AND u1_.is_blocked <> 1
  AND u1_.is_verified = 1
  AND u1_.active = 1
  AND u1_.deleted_at IS NULL
  AND (
    o14_.distinction_start_at < ?
    OR o14_.distinction_start_at IS NULL
  )
  AND o14_.distinction_end_at >= ?
ORDER BY
  o0_.date_created_at DESC

SELECT DISTINCT o0_.id AS id_0, o0_.date_created_at AS date_created_at_1 FROM offer o0_ LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id LEFT JOIN category c2_ ON o0_.category_id = c2_.id LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id LEFT JOIN province p5_ ON u1_.province_id = p5_.id LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id LEFT JOIN association a8_ ON b6_.association_id = a8_.id LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id LEFT JOIN image i10_ ON i10_.id = o11_.image_id LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id WHERE o0_.status = 'approved' AND o0_.started_at < '2026-01-27 11:25:36' AND u1_.is_blocked <> 1 AND u1_.is_verified = 1 AND u1_.active = 1 AND u1_.deleted_at IS NULL AND (o14_.distinction_start_at < '2026-01-27 11:25:36' OR o14_.distinction_start_at IS NULL) AND o14_.distinction_end_at >= '2026-01-27 11:25:36' ORDER BY o0_.date_created_at DESC;

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date_created_at AS date_created_at_1
FROM
  offer o0_
  LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON o0_.category_id = c2_.id
  LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id
  LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id
  LEFT JOIN province p5_ ON u1_.province_id = p5_.id
  LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id
  LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id
  LEFT JOIN association a8_ ON b6_.association_id = a8_.id
  LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id
  LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id
  LEFT JOIN image i10_ ON i10_.id = o11_.image_id
  LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id
  LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id
  LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id
WHERE
  o0_.status = ?
  AND o0_.started_at < ?
  AND u1_.is_blocked <> 1
  AND u1_.is_verified = 1
  AND u1_.active = 1
  AND u1_.deleted_at IS NULL
  AND (
    o14_.distinction_start_at < ?
    OR o14_.distinction_start_at IS NULL
  )
  AND o14_.distinction_end_at >= ?
ORDER BY
  o0_.date_created_at DESC
LIMIT
  2

SELECT DISTINCT o0_.id AS id_0, o0_.date_created_at AS date_created_at_1 FROM offer o0_ LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id LEFT JOIN category c2_ ON o0_.category_id = c2_.id LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id LEFT JOIN province p5_ ON u1_.province_id = p5_.id LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id LEFT JOIN association a8_ ON b6_.association_id = a8_.id LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id LEFT JOIN image i10_ ON i10_.id = o11_.image_id LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id WHERE o0_.status = 'approved' AND o0_.started_at < '2026-01-27 11:25:36' AND u1_.is_blocked <> 1 AND u1_.is_verified = 1 AND u1_.active = 1 AND u1_.deleted_at IS NULL AND (o14_.distinction_start_at < '2026-01-27 11:25:36' OR o14_.distinction_start_at IS NULL) AND o14_.distinction_end_at >= '2026-01-27 11:25:36' ORDER BY o0_.date_created_at DESC LIMIT 2;

SELECT
  DISTINCT o0_.id AS id_0
FROM
  offer o0_
  LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON o0_.category_id = c2_.id
  LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id
  LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id
  LEFT JOIN province p5_ ON u1_.province_id = p5_.id
  LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id
  LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id
  LEFT JOIN association a8_ ON b6_.association_id = a8_.id
  LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id
  LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id
  LEFT JOIN image i10_ ON i10_.id = o11_.image_id
  LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id
  LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id
  LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id
WHERE
  o0_.status = ?
  AND o0_.started_at < ?
  AND u1_.is_blocked <> 1
  AND u1_.is_verified = 1
  AND u1_.active = 1
  AND u1_.deleted_at IS NULL
  AND (
    o14_.distinction_start_at < ?
    OR o14_.distinction_start_at IS NULL
  )
  AND o14_.distinction_end_at >= ?
ORDER BY
  RAND() ASC
LIMIT
  4

SELECT DISTINCT o0_.id AS id_0 FROM offer o0_ LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id LEFT JOIN category c2_ ON o0_.category_id = c2_.id LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id LEFT JOIN province p5_ ON u1_.province_id = p5_.id LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id LEFT JOIN association a8_ ON b6_.association_id = a8_.id LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id LEFT JOIN image i10_ ON i10_.id = o11_.image_id LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id WHERE o0_.status = 'approved' AND o0_.started_at < '2026-01-27 11:25:36' AND u1_.is_blocked <> 1 AND u1_.is_verified = 1 AND u1_.active = 1 AND u1_.deleted_at IS NULL AND (o14_.distinction_start_at < '2026-01-27 11:25:36' OR o14_.distinction_start_at IS NULL) AND o14_.distinction_end_at >= '2026-01-27 11:25:36' ORDER BY RAND() ASC LIMIT 4;

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  offer o0_
  LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON o0_.category_id = c2_.id
  LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id
  LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id
  LEFT JOIN province p5_ ON u1_.province_id = p5_.id
  LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id
  LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id
  LEFT JOIN association a8_ ON b6_.association_id = a8_.id
  LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id
  LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id
  LEFT JOIN image i10_ ON i10_.id = o11_.image_id
  LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id
  LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id
  LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id
WHERE
  o0_.status = ?
  AND o0_.started_at < ?
  AND u1_.is_blocked <> 1
  AND u1_.is_verified = 1
  AND u1_.active = 1
  AND u1_.deleted_at IS NULL
  AND (
    (
      o14_.distinction_start_at IS NULL
      AND o14_.distinction_end_at IS NULL
    )
    OR (
      o14_.distinction_start_at > ?
      OR o14_.distinction_end_at < ?
    )
  )

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM offer o0_ LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id LEFT JOIN category c2_ ON o0_.category_id = c2_.id LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id LEFT JOIN province p5_ ON u1_.province_id = p5_.id LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id LEFT JOIN association a8_ ON b6_.association_id = a8_.id LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id LEFT JOIN image i10_ ON i10_.id = o11_.image_id LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id WHERE o0_.status = 'approved' AND o0_.started_at < '2026-01-27 11:25:37' AND u1_.is_blocked <> 1 AND u1_.is_verified = 1 AND u1_.active = 1 AND u1_.deleted_at IS NULL AND ((o14_.distinction_start_at IS NULL AND o14_.distinction_end_at IS NULL) OR (o14_.distinction_start_at > '2026-01-27 11:25:37' OR o14_.distinction_end_at < '2026-01-27 11:25:37'));

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date_created_at AS date_created_at_1
FROM
  offer o0_
  LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON o0_.category_id = c2_.id
  LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id
  LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id
  LEFT JOIN province p5_ ON u1_.province_id = p5_.id
  LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id
  LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id
  LEFT JOIN association a8_ ON b6_.association_id = a8_.id
  LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id
  LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id
  LEFT JOIN image i10_ ON i10_.id = o11_.image_id
  LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id
  LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id
  LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id
WHERE
  o0_.status = ?
  AND o0_.started_at < ?
  AND u1_.is_blocked <> 1
  AND u1_.is_verified = 1
  AND u1_.active = 1
  AND u1_.deleted_at IS NULL
  AND (
    (
      o14_.distinction_start_at IS NULL
      AND o14_.distinction_end_at IS NULL
    )
    OR (
      o14_.distinction_start_at > ?
      OR o14_.distinction_end_at < ?
    )
  )
ORDER BY
  o0_.date_created_at DESC
LIMIT
  16

SELECT DISTINCT o0_.id AS id_0, o0_.date_created_at AS date_created_at_1 FROM offer o0_ LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id LEFT JOIN category c2_ ON o0_.category_id = c2_.id LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id LEFT JOIN province p5_ ON u1_.province_id = p5_.id LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id LEFT JOIN foundation f7_ ON u1_.id = f7_.owner_id LEFT JOIN association a8_ ON b6_.association_id = a8_.id LEFT JOIN federation f9_ ON a8_.federation_id = f9_.id LEFT JOIN offer_images o11_ ON o0_.id = o11_.offer_id LEFT JOIN image i10_ ON i10_.id = o11_.image_id LEFT JOIN offer_filter o12_ ON o0_.id = o12_.offer_id LEFT JOIN filter f13_ ON o12_.filter_id = f13_.id LEFT JOIN offer_promotion o14_ ON o0_.id = o14_.offer_id WHERE o0_.status = 'approved' AND o0_.started_at < '2026-01-27 11:25:37' AND u1_.is_blocked <> 1 AND u1_.is_verified = 1 AND u1_.active = 1 AND u1_.deleted_at IS NULL AND ((o14_.distinction_start_at IS NULL AND o14_.distinction_end_at IS NULL) OR (o14_.distinction_start_at > '2026-01-27 11:25:37' OR o14_.distinction_end_at < '2026-01-27 11:25:37')) ORDER BY o0_.date_created_at DESC LIMIT 16;

SELECT
  o0_.id AS id_0,
  o0_.uuid AS uuid_1,
  o0_.slug AS slug_2,
  o0_.status AS status_3,
  o0_.payment_type AS payment_type_4,
  o0_.rejection_reason AS rejection_reason_5,
  o0_.date_created_at AS date_created_at_6,
  o0_.started_at AS started_at_7,
  o0_.ended_at AS ended_at_8,
  o0_.name AS name_9,
  o0_.description AS description_10,
  o0_.price AS price_11,
  o0_.gender_male AS gender_male_12,
  o0_.gender_female AS gender_female_13,
  o0_.date_availability AS date_availability_14,
  o0_.stat_view AS stat_view_15,
  o0_.stat_phone AS stat_phone_16,
  o0_.stat_message AS stat_message_17,
  o0_.approval_type AS approval_type_18,
  o0_.deleted_at AS deleted_at_19,
  o0_.created_at AS created_at_20,
  o0_.updated_at AS updated_at_21,
  u1_.id AS id_22,
  u1_.email AS email_23,
  u1_.roles AS roles_24,
  u1_.password AS password_25,
  u1_.firstname AS firstname_26,
  u1_.lastname AS lastname_27,
  u1_.phone AS phone_28,
  u1_.city AS city_29,
  u1_.postcode AS postcode_30,
  u1_.address AS address_31,
  u1_.active AS active_32,
  u1_.is_verified AS is_verified_33,
  u1_.uuid AS uuid_34,
  u1_.newsletter AS newsletter_35,
  u1_.is_blocked AS is_blocked_36,
  u1_.blocked_message AS blocked_message_37,
  u1_.blocked_date AS blocked_date_38,
  u1_.allow_auto_approval AS allow_auto_approval_39,
  u1_.type AS type_40,
  u1_.last_offer_added_at AS last_offer_added_at_41,
  u1_.delete_request_at AS delete_request_at_42,
  u1_.created_at AS created_at_43,
  u1_.updated_at AS updated_at_44,
  u1_.deleted_at AS deleted_at_45,
  c2_.id AS id_46,
  c2_.name AS name_47,
  c2_.slug AS slug_48,
  c2_.description AS description_49,
  c2_.active AS active_50,
  c2_.position AS position_51,
  c2_.breeding_description AS breeding_description_52,
  c2_.title AS title_53,
  c2_.meta_title AS meta_title_54,
  c2_.meta_keywords AS meta_keywords_55,
  c2_.meta_description AS meta_description_56,
  b3_.id AS id_57,
  b3_.name AS name_58,
  b3_.slug AS slug_59,
  b3_.description AS description_60,
  b3_.active AS active_61,
  b3_.breeding_description AS breeding_description_62,
  b3_.title AS title_63,
  b3_.meta_title AS meta_title_64,
  b3_.meta_keywords AS meta_keywords_65,
  b3_.meta_description AS meta_description_66,
  i4_.id AS id_67,
  i4_.name AS name_68,
  i4_.alt AS alt_69,
  i4_.file AS file_70,
  i4_.uuid AS uuid_71,
  i4_.type AS type_72,
  i4_.temp AS temp_73,
  i4_.path AS path_74,
  i4_.width AS width_75,
  i4_.height AS height_76,
  i4_.extension AS extension_77,
  i4_.position AS position_78,
  i4_.created_at AS created_at_79,
  i4_.updated_at AS updated_at_80,
  p5_.id AS id_81,
  p5_.name AS name_82,
  p5_.slug AS slug_83,
  p5_.active AS active_84,
  b6_.id AS id_85,
  b6_.name AS name_86,
  b6_.regon AS regon_87,
  b6_.description AS description_88,
  b6_.verified AS verified_89,
  b6_.association_custom AS association_custom_90,
  b6_.nickname AS nickname_91,
  b6_.facebook_url AS facebook_url_92,
  b6_.instagram_url AS instagram_url_93,
  b6_.web_url AS web_url_94,
  b6_.certificate_file AS certificate_file_95,
  b6_.certificate_file_status AS certificate_file_status_96,
  b6_.certificate_file_uploaded_at AS certificate_file_uploaded_at_97,
  b6_.certificate_file_rejected_reason AS certificate_file_rejected_reason_98,
  b6_.certificate_file_public AS certificate_file_public_99,
  b6_.deleted_at AS deleted_at_100,
  a7_.id AS id_101,
  a7_.name AS name_102,
  a7_.regon AS regon_103,
  f8_.id AS id_104,
  f8_.name AS name_105,
  f8_.regon AS regon_106,
  f8_.description AS description_107,
  f8_.show_badge AS show_badge_108,
  f8_.full_name AS full_name_109,
  f8_.show_table AS show_table_110,
  i9_.id AS id_111,
  i9_.name AS name_112,
  i9_.alt AS alt_113,
  i9_.file AS file_114,
  i9_.uuid AS uuid_115,
  i9_.type AS type_116,
  i9_.temp AS temp_117,
  i9_.path AS path_118,
  i9_.width AS width_119,
  i9_.height AS height_120,
  i9_.extension AS extension_121,
  i9_.position AS position_122,
  i9_.created_at AS created_at_123,
  i9_.updated_at AS updated_at_124,
  o10_.id AS id_125,
  o10_.value AS value_126,
  f11_.id AS id_127,
  f11_.name AS name_128,
  f11_.slug AS slug_129,
  f11_.type AS type_130,
  f11_.required AS required_131,
  f11_.all_categories AS all_categories_132,
  f11_.search AS search_133,
  f11_.choices AS choices_134,
  f11_.position AS position_135,
  o12_.id AS id_136,
  o12_.package AS package_137,
  o12_.distinction_bay AS distinction_bay_138,
  o12_.distinction_current AS distinction_current_139,
  o12_.distinction_start_at AS distinction_start_at_140,
  o12_.distinction_end_at AS distinction_end_at_141,
  o12_.refreshment_bay AS refreshment_bay_142,
  o12_.refreshment_current AS refreshment_current_143,
  o12_.refreshment_last_at AS refreshment_last_at_144,
  o12_.post_bay AS post_bay_145,
  o12_.homepage_bay AS homepage_bay_146,
  o12_.homepage_start_at AS homepage_start_at_147,
  o12_.homepage_end_at AS homepage_end_at_148,
  o12_.bay_at AS bay_at_149,
  o0_.owner_id AS owner_id_150,
  o0_.breed_id AS breed_id_151,
  o0_.category_id AS category_id_152,
  o0_.user_plan_id AS user_plan_id_153,
  u1_.province_id AS province_id_154,
  u1_.avatar_id AS avatar_id_155,
  u1_.last_payment_address_id AS last_payment_address_id_156,
  c2_.category_id AS category_id_157,
  c2_.image_id AS image_id_158,
  b3_.image_id AS image_id_159,
  b3_.category_id AS category_id_160,
  i4_.owner_id AS owner_id_161,
  b6_.owner_id AS owner_id_162,
  b6_.association_id AS association_id_163,
  a7_.federation_id AS federation_id_164,
  i9_.owner_id AS owner_id_165,
  o10_.filter_id AS filter_id_166,
  o10_.offer_id AS offer_id_167,
  o12_.offer_id AS offer_id_168
FROM
  offer o0_
  LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id
  LEFT JOIN category c2_ ON o0_.category_id = c2_.id
  LEFT JOIN breed b3_ ON o0_.breed_id = b3_.id
  LEFT JOIN image i4_ ON u1_.avatar_id = i4_.id
  LEFT JOIN province p5_ ON u1_.province_id = p5_.id
  LEFT JOIN breeding b6_ ON u1_.id = b6_.owner_id
  LEFT JOIN foundation f13_ ON u1_.id = f13_.owner_id
  LEFT JOIN association a7_ ON b6_.association_id = a7_.id
  LEFT JOIN federation f8_ ON a7_.federation_id = f8_.id
  LEFT JOIN offer_images o14_ ON o0_.id = o14_.offer_id
  LEFT JOIN image i9_ ON i9_.id = o14_.image_id
  LEFT JOIN offer_filter o10_ ON o0_.id = o10_.offer_id
  LEFT JOIN filter f11_ ON o10_.filter_id = f11_.id
  LEFT JOIN offer_promotion o12_ ON o0_.id = o12_.offer_id
WHERE
  o0_.status = ?
  AND o0_.started_at < ?
  AND u1_.is_blocked <> 1
  AND u1_.is_verified = 1
  AND u1_.active = 1
  AND u1_.deleted_at IS NULL
  AND (
    (
      o12_.distinction_start_at IS NULL
      AND o12_.distinction_end_at IS NULL
    )
    OR (
      o12_.distinction_start_at > ?
      OR o12_.distinction_end_at < ?
    )
  )
  AND o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  o0_.date_created_at DESC,
  i9_.position ASC