35.78 ms (55.50%)
2
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 o0_ . id IN (? , ? , ? ) ORDER BY o0_ . date_created_at DESC , i9_ . position ASC
Parameters :
[
"approved "
"2025-12-06 07:10:25 "
4479
4523
4504
]
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 o0_ . id IN (? , ? , ? )
ORDER BY
o0_ . date_created_at DESC ,
i9_ . position ASC
Copy
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 = 'approved' AND o0_ . started_at < '2025-12-06 07:10:25' AND u1_ . is_blocked < > 1 AND u1_ . is_verified = 1 AND u1_ . active = 1 AND u1_ . deleted_at IS NULL AND o0_ . id IN (4479 , 4523 , 4504 ) ORDER BY o0_ . date_created_at DESC , i9_ . position ASC ;
Copy
1.15 ms (1.78%)
1
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . firstname AS firstname_5 , t0 . lastname AS lastname_6 , t0 . phone AS phone_7 , t0 . city AS city_8 , t0 . postcode AS postcode_9 , t0 . address AS address_10 , t0 . active AS active_11 , t0 . is_verified AS is_verified_12 , t0 . uuid AS uuid_13 , t0 . newsletter AS newsletter_14 , t0 . is_blocked AS is_blocked_15 , t0 . blocked_message AS blocked_message_16 , t0 . blocked_date AS blocked_date_17 , t0 . allow_auto_approval AS allow_auto_approval_18 , t0 . type AS type_19 , t0 . last_offer_added_at AS last_offer_added_at_20 , t0 . delete_request_at AS delete_request_at_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . deleted_at AS deleted_at_24 , t0 . province_id AS province_id_25 , t26 . id AS id_27 , t26 . name AS name_28 , t26 . regon AS regon_29 , t26 . description AS description_30 , t26 . verified AS verified_31 , t26 . association_custom AS association_custom_32 , t26 . nickname AS nickname_33 , t26 . facebook_url AS facebook_url_34 , t26 . instagram_url AS instagram_url_35 , t26 . web_url AS web_url_36 , t26 . certificate_file AS certificate_file_37 , t26 . certificate_file_status AS certificate_file_status_38 , t26 . certificate_file_uploaded_at AS certificate_file_uploaded_at_39 , t26 . certificate_file_rejected_reason AS certificate_file_rejected_reason_40 , t26 . certificate_file_public AS certificate_file_public_41 , t26 . deleted_at AS deleted_at_42 , t26 . owner_id AS owner_id_43 , t26 . association_id AS association_id_44 , t0 . avatar_id AS avatar_id_45 , t0 . last_payment_address_id AS last_payment_address_id_46 , t47 . id AS id_48 , t47 . name AS name_49 , t47 . phone AS phone_50 , t47 . regon AS regon_51 , t47 . address AS address_52 , t47 . city AS city_53 , t47 . postcode AS postcode_54 , t47 . description AS description_55 , t47 . facebook_url AS facebook_url_56 , t47 . instagram_url AS instagram_url_57 , t47 . web_url AS web_url_58 , t47 . deleted_at AS deleted_at_59 , t47 . province_id AS province_id_60 , t47 . owner_id AS owner_id_61 FROM `user` t0 LEFT JOIN breeding t26 ON t26 . owner_id = t0 . id LEFT JOIN foundation t47 ON t47 . owner_id = t0 . id WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . email AS email_2 ,
t0 . roles AS roles_3 ,
t0 . password AS password_4 ,
t0 . firstname AS firstname_5 ,
t0 . lastname AS lastname_6 ,
t0 . phone AS phone_7 ,
t0 . city AS city_8 ,
t0 . postcode AS postcode_9 ,
t0 . address AS address_10 ,
t0 . active AS active_11 ,
t0 . is_verified AS is_verified_12 ,
t0 . uuid AS uuid_13 ,
t0 . newsletter AS newsletter_14 ,
t0 . is_blocked AS is_blocked_15 ,
t0 . blocked_message AS blocked_message_16 ,
t0 . blocked_date AS blocked_date_17 ,
t0 . allow_auto_approval AS allow_auto_approval_18 ,
t0 . type AS type_19 ,
t0 . last_offer_added_at AS last_offer_added_at_20 ,
t0 . delete_request_at AS delete_request_at_21 ,
t0 . created_at AS created_at_22 ,
t0 . updated_at AS updated_at_23 ,
t0 . deleted_at AS deleted_at_24 ,
t0 . province_id AS province_id_25 ,
t26 . id AS id_27 ,
t26 . name AS name_28 ,
t26 . regon AS regon_29 ,
t26 . description AS description_30 ,
t26 . verified AS verified_31 ,
t26 . association_custom AS association_custom_32 ,
t26 . nickname AS nickname_33 ,
t26 . facebook_url AS facebook_url_34 ,
t26 . instagram_url AS instagram_url_35 ,
t26 . web_url AS web_url_36 ,
t26 . certificate_file AS certificate_file_37 ,
t26 . certificate_file_status AS certificate_file_status_38 ,
t26 . certificate_file_uploaded_at AS certificate_file_uploaded_at_39 ,
t26 . certificate_file_rejected_reason AS certificate_file_rejected_reason_40 ,
t26 . certificate_file_public AS certificate_file_public_41 ,
t26 . deleted_at AS deleted_at_42 ,
t26 . owner_id AS owner_id_43 ,
t26 . association_id AS association_id_44 ,
t0 . avatar_id AS avatar_id_45 ,
t0 . last_payment_address_id AS last_payment_address_id_46 ,
t47 . id AS id_48 ,
t47 . name AS name_49 ,
t47 . phone AS phone_50 ,
t47 . regon AS regon_51 ,
t47 . address AS address_52 ,
t47 . city AS city_53 ,
t47 . postcode AS postcode_54 ,
t47 . description AS description_55 ,
t47 . facebook_url AS facebook_url_56 ,
t47 . instagram_url AS instagram_url_57 ,
t47 . web_url AS web_url_58 ,
t47 . deleted_at AS deleted_at_59 ,
t47 . province_id AS province_id_60 ,
t47 . owner_id AS owner_id_61
FROM
`user` t0
LEFT JOIN breeding t26 ON t26 . owner_id = t0 . id
LEFT JOIN foundation t47 ON t47 . owner_id = t0 . id
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . firstname AS firstname_5 , t0 . lastname AS lastname_6 , t0 . phone AS phone_7 , t0 . city AS city_8 , t0 . postcode AS postcode_9 , t0 . address AS address_10 , t0 . active AS active_11 , t0 . is_verified AS is_verified_12 , t0 . uuid AS uuid_13 , t0 . newsletter AS newsletter_14 , t0 . is_blocked AS is_blocked_15 , t0 . blocked_message AS blocked_message_16 , t0 . blocked_date AS blocked_date_17 , t0 . allow_auto_approval AS allow_auto_approval_18 , t0 . type AS type_19 , t0 . last_offer_added_at AS last_offer_added_at_20 , t0 . delete_request_at AS delete_request_at_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . deleted_at AS deleted_at_24 , t0 . province_id AS province_id_25 , t26 . id AS id_27 , t26 . name AS name_28 , t26 . regon AS regon_29 , t26 . description AS description_30 , t26 . verified AS verified_31 , t26 . association_custom AS association_custom_32 , t26 . nickname AS nickname_33 , t26 . facebook_url AS facebook_url_34 , t26 . instagram_url AS instagram_url_35 , t26 . web_url AS web_url_36 , t26 . certificate_file AS certificate_file_37 , t26 . certificate_file_status AS certificate_file_status_38 , t26 . certificate_file_uploaded_at AS certificate_file_uploaded_at_39 , t26 . certificate_file_rejected_reason AS certificate_file_rejected_reason_40 , t26 . certificate_file_public AS certificate_file_public_41 , t26 . deleted_at AS deleted_at_42 , t26 . owner_id AS owner_id_43 , t26 . association_id AS association_id_44 , t0 . avatar_id AS avatar_id_45 , t0 . last_payment_address_id AS last_payment_address_id_46 , t47 . id AS id_48 , t47 . name AS name_49 , t47 . phone AS phone_50 , t47 . regon AS regon_51 , t47 . address AS address_52 , t47 . city AS city_53 , t47 . postcode AS postcode_54 , t47 . description AS description_55 , t47 . facebook_url AS facebook_url_56 , t47 . instagram_url AS instagram_url_57 , t47 . web_url AS web_url_58 , t47 . deleted_at AS deleted_at_59 , t47 . province_id AS province_id_60 , t47 . owner_id AS owner_id_61 FROM `user` t0 LEFT JOIN breeding t26 ON t26 . owner_id = t0 . id LEFT JOIN foundation t47 ON t47 . owner_id = t0 . id WHERE t0 . id = 1237 ;
Copy
0.95 ms (1.48%)
1
SELECT t0 . id AS id_1 , t0 . uuid AS uuid_2 , t0 . slug AS slug_3 , t0 . status AS status_4 , t0 . payment_type AS payment_type_5 , t0 . rejection_reason AS rejection_reason_6 , t0 . date_created_at AS date_created_at_7 , t0 . started_at AS started_at_8 , t0 . ended_at AS ended_at_9 , t0 . name AS name_10 , t0 . description AS description_11 , t0 . price AS price_12 , t0 . gender_male AS gender_male_13 , t0 . gender_female AS gender_female_14 , t0 . date_availability AS date_availability_15 , t0 . stat_view AS stat_view_16 , t0 . stat_phone AS stat_phone_17 , t0 . stat_message AS stat_message_18 , t0 . approval_type AS approval_type_19 , t0 . deleted_at AS deleted_at_20 , t0 . created_at AS created_at_21 , t0 . updated_at AS updated_at_22 , t0 . owner_id AS owner_id_23 , t0 . breed_id AS breed_id_24 , t0 . category_id AS category_id_25 , t26 . id AS id_27 , t26 . package AS package_28 , t26 . distinction_bay AS distinction_bay_29 , t26 . distinction_current AS distinction_current_30 , t26 . distinction_start_at AS distinction_start_at_31 , t26 . distinction_end_at AS distinction_end_at_32 , t26 . refreshment_bay AS refreshment_bay_33 , t26 . refreshment_current AS refreshment_current_34 , t26 . refreshment_last_at AS refreshment_last_at_35 , t26 . post_bay AS post_bay_36 , t26 . homepage_bay AS homepage_bay_37 , t26 . homepage_start_at AS homepage_start_at_38 , t26 . homepage_end_at AS homepage_end_at_39 , t26 . bay_at AS bay_at_40 , t26 . offer_id AS offer_id_41 , t0 . user_plan_id AS user_plan_id_42 FROM offer t0 LEFT JOIN offer_promotion t26 ON t26 . offer_id = t0 . id WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . uuid AS uuid_2 ,
t0 . slug AS slug_3 ,
t0 . status AS status_4 ,
t0 . payment_type AS payment_type_5 ,
t0 . rejection_reason AS rejection_reason_6 ,
t0 . date_created_at AS date_created_at_7 ,
t0 . started_at AS started_at_8 ,
t0 . ended_at AS ended_at_9 ,
t0 . name AS name_10 ,
t0 . description AS description_11 ,
t0 . price AS price_12 ,
t0 . gender_male AS gender_male_13 ,
t0 . gender_female AS gender_female_14 ,
t0 . date_availability AS date_availability_15 ,
t0 . stat_view AS stat_view_16 ,
t0 . stat_phone AS stat_phone_17 ,
t0 . stat_message AS stat_message_18 ,
t0 . approval_type AS approval_type_19 ,
t0 . deleted_at AS deleted_at_20 ,
t0 . created_at AS created_at_21 ,
t0 . updated_at AS updated_at_22 ,
t0 . owner_id AS owner_id_23 ,
t0 . breed_id AS breed_id_24 ,
t0 . category_id AS category_id_25 ,
t26 . id AS id_27 ,
t26 . package AS package_28 ,
t26 . distinction_bay AS distinction_bay_29 ,
t26 . distinction_current AS distinction_current_30 ,
t26 . distinction_start_at AS distinction_start_at_31 ,
t26 . distinction_end_at AS distinction_end_at_32 ,
t26 . refreshment_bay AS refreshment_bay_33 ,
t26 . refreshment_current AS refreshment_current_34 ,
t26 . refreshment_last_at AS refreshment_last_at_35 ,
t26 . post_bay AS post_bay_36 ,
t26 . homepage_bay AS homepage_bay_37 ,
t26 . homepage_start_at AS homepage_start_at_38 ,
t26 . homepage_end_at AS homepage_end_at_39 ,
t26 . bay_at AS bay_at_40 ,
t26 . offer_id AS offer_id_41 ,
t0 . user_plan_id AS user_plan_id_42
FROM
offer t0
LEFT JOIN offer_promotion t26 ON t26 . offer_id = t0 . id
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . uuid AS uuid_2 , t0 . slug AS slug_3 , t0 . status AS status_4 , t0 . payment_type AS payment_type_5 , t0 . rejection_reason AS rejection_reason_6 , t0 . date_created_at AS date_created_at_7 , t0 . started_at AS started_at_8 , t0 . ended_at AS ended_at_9 , t0 . name AS name_10 , t0 . description AS description_11 , t0 . price AS price_12 , t0 . gender_male AS gender_male_13 , t0 . gender_female AS gender_female_14 , t0 . date_availability AS date_availability_15 , t0 . stat_view AS stat_view_16 , t0 . stat_phone AS stat_phone_17 , t0 . stat_message AS stat_message_18 , t0 . approval_type AS approval_type_19 , t0 . deleted_at AS deleted_at_20 , t0 . created_at AS created_at_21 , t0 . updated_at AS updated_at_22 , t0 . owner_id AS owner_id_23 , t0 . breed_id AS breed_id_24 , t0 . category_id AS category_id_25 , t26 . id AS id_27 , t26 . package AS package_28 , t26 . distinction_bay AS distinction_bay_29 , t26 . distinction_current AS distinction_current_30 , t26 . distinction_start_at AS distinction_start_at_31 , t26 . distinction_end_at AS distinction_end_at_32 , t26 . refreshment_bay AS refreshment_bay_33 , t26 . refreshment_current AS refreshment_current_34 , t26 . refreshment_last_at AS refreshment_last_at_35 , t26 . post_bay AS post_bay_36 , t26 . homepage_bay AS homepage_bay_37 , t26 . homepage_start_at AS homepage_start_at_38 , t26 . homepage_end_at AS homepage_end_at_39 , t26 . bay_at AS bay_at_40 , t26 . offer_id AS offer_id_41 , t0 . user_plan_id AS user_plan_id_42 FROM offer t0 LEFT JOIN offer_promotion t26 ON t26 . offer_id = t0 . id WHERE t0 . id = 4512 ;
Copy