GET https://dev.petso.halisz.pl/zwierzeta-na-sprzedaz/psy/ratler-praski

Response
200 OK
IP
216.73.216.123
Profiled on
Token
2e9ac2

Query Metrics

23 Database Queries
20 Different statements
80.63 ms Query time
2 Invalid entities
403 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
30.47 ms
(37.79%) 		1 
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.active AS active_4, b0_.breeding_description AS breeding_description_5, b0_.title AS title_6, b0_.meta_title AS meta_title_7, b0_.meta_keywords AS meta_keywords_8, b0_.meta_description AS meta_description_9, c1_.id AS id_10, c1_.name AS name_11, c1_.slug AS slug_12, c1_.description AS description_13, c1_.active AS active_14, c1_.position AS position_15, c1_.breeding_description AS breeding_description_16, c1_.title AS title_17, c1_.meta_title AS meta_title_18, c1_.meta_keywords AS meta_keywords_19, c1_.meta_description AS meta_description_20, i2_.id AS id_21, i2_.name AS name_22, i2_.alt AS alt_23, i2_.file AS file_24, i2_.uuid AS uuid_25, i2_.type AS type_26, i2_.temp AS temp_27, i2_.path AS path_28, i2_.width AS width_29, i2_.height AS height_30, i2_.extension AS extension_31, i2_.position AS position_32, i2_.created_at AS created_at_33, i2_.updated_at AS updated_at_34, b3_.id AS id_35, b3_.name AS name_36, b3_.content AS content_37, b3_.stat_size AS stat_size_38, b3_.stat_exercises AS stat_exercises_39, b3_.stat_training AS stat_training_40, b3_.stat_hair_amount AS stat_hair_amount_41, b3_.stat_haircut_frequency AS stat_haircut_frequency_42, b3_.stat_kids AS stat_kids_43, b3_.stat_health AS stat_health_44, b3_.stat_costs AS stat_costs_45, b3_.stat_intelligence AS stat_intelligence_46, b3_.param_life AS param_life_47, b3_.param_weight_male AS param_weight_male_48, b3_.param_weight_female AS param_weight_female_49, b3_.param_growth AS param_growth_50, b3_.param_recognized_by_fci AS param_recognized_by_fci_51, b3_.blocks AS blocks_52, b3_.title AS title_53, b3_.meta_title AS meta_title_54, b3_.meta_keywords AS meta_keywords_55, b3_.meta_description AS meta_description_56, b0_.image_id AS image_id_57, b0_.category_id AS category_id_58, c1_.category_id AS category_id_59, c1_.image_id AS image_id_60, i2_.owner_id AS owner_id_61, b3_.breed_id AS breed_id_62 FROM breed b0_ LEFT JOIN category c1_ ON b0_.category_id = c1_.id LEFT JOIN image i2_ ON b0_.image_id = i2_.id LEFT JOIN breed_information b3_ ON b0_.id = b3_.breed_id WHERE c1_.active = ? AND b0_.active = ? AND c1_.slug = ?
Parameters: 
[
  1
  1
  "psy"
]
View formatted query    View runnable query    Explain query    View query backtrace
25.41 ms
(31.51%) 		1 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4.62 ms
(5.73%) 		1 
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 c2_.slug = ? AND b3_.slug = ? 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
Parameters: 
[
  "approved"
  "2025-12-06 06:00:56"
  "psy"
  "ratler-praski"
  "2025-12-06 06:00:56"
  "2025-12-06 06:00:56"
  2017
]
View formatted query    View runnable query    Explain query    View query backtrace
2.95 ms
(3.66%) 		2 
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.content AS content_4, b0_.date_created_at AS date_created_at_5, b0_.date_updated_at AS date_updated_at_6, b0_.active AS active_7, b0_.is_featured AS is_featured_8, b0_.position AS position_9, b0_.title AS title_10, b0_.meta_title AS meta_title_11, b0_.meta_keywords AS meta_keywords_12, b0_.meta_description AS meta_description_13, i1_.id AS id_14, i1_.name AS name_15, i1_.alt AS alt_16, i1_.file AS file_17, i1_.uuid AS uuid_18, i1_.type AS type_19, i1_.temp AS temp_20, i1_.path AS path_21, i1_.width AS width_22, i1_.height AS height_23, i1_.extension AS extension_24, i1_.position AS position_25, i1_.created_at AS created_at_26, i1_.updated_at AS updated_at_27, b0_.image_id AS image_id_28, b0_.big_image_id AS big_image_id_29, b0_.author_id AS author_id_30, i1_.owner_id AS owner_id_31 FROM blog b0_ LEFT JOIN image i1_ ON b0_.image_id = i1_.id LEFT JOIN tagging t2_ ON (t2_.resource_type = ? AND t2_.resource_id = b0_.id) LEFT JOIN tag t3_ ON t2_.tag_id = t3_.id WHERE b0_.active = 1 AND t3_.slug IN (?) ORDER BY b0_.date_created_at DESC LIMIT 3
Parameters: 
[
  "App\Entity\Blog"
  Symfony\Component\String\UnicodeString {#5136
    __toString(): "pies"
  }
]
View formatted query    View runnable query    View query backtrace
1.88 ms
(2.34%) 		3 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.location AS location_2, a0_.advert_height AS advert_height_3, a0_.advert_width AS advert_width_4, a0_.active AS active_5, a0_.max_quantity AS max_quantity_6 FROM advert_group a0_ WHERE a0_.location = ? AND a0_.active = ?
Parameters: 
[
  "listing_left_1"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.73 ms
(2.15%) 		1 
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 c2_.slug = ? AND b3_.slug = ? AND ((o14_.distinction_start_at IS NULL AND o14_.distinction_end_at IS NULL) OR (o14_.distinction_start_at > ? OR o14_.distinction_end_at < ?))
Parameters: 
[
  "approved"
  "2025-12-06 06:00:56"
  "psy"
  "ratler-praski"
  "2025-12-06 06:00:56"
  "2025-12-06 06:00:56"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.67 ms
(2.07%) 		1 
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 c2_.slug = ? AND b3_.slug = ? AND (o14_.distinction_start_at < ? OR o14_.distinction_start_at IS NULL) AND o14_.distinction_end_at >= ? ORDER BY o0_.date_created_at DESC
Parameters: 
[
  "approved"
  "2025-12-06 06:00:56"
  "psy"
  "ratler-praski"
  "2025-12-06 06:00:56"
  "2025-12-06 06:00:56"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.66 ms
(2.06%) 		1 
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 c2_.slug = ? AND b3_.slug = ? 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
Parameters: 
[
  "approved"
  "2025-12-06 06:00:56"
  "psy"
  "ratler-praski"
  "2025-12-06 06:00:56"
  "2025-12-06 06:00:56"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.44 ms
(1.79%) 		1 
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 c2_.slug = ? AND b3_.slug = ? 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
Parameters: 
[
  "approved"
  "2025-12-06 06:00:56"
  "psy"
  "ratler-praski"
  "2025-12-06 06:00:56"
  "2025-12-06 06:00:56"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.29 ms
(1.60%) 		1 
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 c2_.slug = ? AND b3_.slug = ? AND (o14_.distinction_start_at < ? OR o14_.distinction_start_at IS NULL) AND o14_.distinction_end_at >= ? ORDER BY RAND() ASC LIMIT 4
Parameters: 
[
  "approved"
  "2025-12-06 06:00:56"
  "psy"
  "ratler-praski"
  "2025-12-06 06:00:56"
  "2025-12-06 06:00:56"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(1.53%) 		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, t0.category_id AS category_id_12, t13.id AS id_14, t13.name AS name_15, t13.content AS content_16, t13.stat_size AS stat_size_17, t13.stat_exercises AS stat_exercises_18, t13.stat_training AS stat_training_19, t13.stat_hair_amount AS stat_hair_amount_20, t13.stat_haircut_frequency AS stat_haircut_frequency_21, t13.stat_kids AS stat_kids_22, t13.stat_health AS stat_health_23, t13.stat_costs AS stat_costs_24, t13.stat_intelligence AS stat_intelligence_25, t13.param_life AS param_life_26, t13.param_weight_male AS param_weight_male_27, t13.param_weight_female AS param_weight_female_28, t13.param_growth AS param_growth_29, t13.param_recognized_by_fci AS param_recognized_by_fci_30, t13.blocks AS blocks_31, t13.title AS title_32, t13.meta_title AS meta_title_33, t13.meta_keywords AS meta_keywords_34, t13.meta_description AS meta_description_35, t13.breed_id AS breed_id_36 FROM breed t0 LEFT JOIN breed_information t13 ON t13.breed_id = t0.id WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters: 
[
  "ratler-praski"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(1.09%) 		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 c1_.id = ? OR f0_.all_categories = 1 ORDER BY f0_.position ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(0.94%) 		1 
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(0.94%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.alt AS alt_3, t0.file AS file_4, t0.uuid AS uuid_5, t0.type AS type_6, t0.temp AS temp_7, t0.path AS path_8, t0.width AS width_9, t0.height AS height_10, t0.extension AS extension_11, t0.position AS position_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_15 FROM image t0 WHERE t0.id = ?
Parameters: 
[
  2962
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(0.89%) 		1 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.url AS url_2, a0_.image AS image_3, a0_.code AS code_4, a0_.start_at AS start_at_5, a0_.end_at AS end_at_6, a0_.views AS views_7, a0_.clicks AS clicks_8, a0_.unique_views AS unique_views_9, a0_.uuid AS uuid_10, a0_.extension AS extension_11, a0_.alt AS alt_12, a0_.title AS title_13, a0_.weight AS weight_14, a0_.active AS active_15, a0_.advert_group_id AS advert_group_id_16 FROM advert a0_ WHERE a0_.advert_group_id = ? AND a0_.active = ? AND a0_.start_at < ? AND a0_.end_at > ? ORDER BY a0_.weight ASC
Parameters: 
[
  2
  1
  "2025-12-06 06:00:56"
  "2025-12-06 06:00:56"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(0.88%) 		1 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.84%) 		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 = ? AND t0.active = ? LIMIT 1
Parameters: 
[
  "zwierzeta-na-sprzedaz"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.78%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.regon AS regon_4, t0.address AS address_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.description AS description_8, t0.facebook_url AS facebook_url_9, t0.instagram_url AS instagram_url_10, t0.web_url AS web_url_11, t0.deleted_at AS deleted_at_12, t0.province_id AS province_id_13, t0.owner_id AS owner_id_14 FROM foundation t0 WHERE t0.owner_id = ?
Parameters: 
[
  355
]
View formatted query    View runnable query    Explain query    View query backtrace
0.61 ms
(0.76%) 		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.position AS position_6, t0.breeding_description AS breeding_description_7, t0.title AS title_8, t0.meta_title AS meta_title_9, t0.meta_keywords AS meta_keywords_10, t0.meta_description AS meta_description_11, t0.category_id AS category_id_12, t0.image_id AS image_id_13 FROM category t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters: 
[
  "psy"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(0.63%) 		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.display_name AS display_name_7 FROM employee t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Image 137
App\Entity\Breed 127
App\Entity\BreedInformation 92
App\Entity\Province 16
App\Entity\Filter 7
App\Entity\OfferFilter 7
App\Entity\Federation 6
App\Entity\Blog 3
App\Entity\AdvertGroup 2
App\Entity\Type 1
App\Entity\Category 1
App\Entity\Offer 1
App\Entity\User 1
App\Entity\Breeding 1
App\Entity\Employee 1

Entities Mapping

Class Mapping errors
App\Entity\Type No errors.
App\Entity\Image No errors.
App\Entity\Category No errors.
App\Entity\Breed No errors.
App\Entity\Offer No errors.
App\Entity\Filter No errors.
App\Entity\BreedInformation No errors.
App\Entity\OfferFilter No errors.
App\Entity\Federation No errors.
App\Entity\Association No errors.
App\Entity\Breeding No errors.
App\Entity\User
  • The mappings App\Entity\User#plans and App\Entity\UserPlan#owner are inconsistent with each other.
App\Entity\Province No errors.
App\Entity\City No errors.
App\Entity\Setting No errors.
App\Entity\Foundation No errors.
App\Entity\OfferPromotion No errors.
App\Entity\UserPlan
  • The association App\Entity\UserPlan#owner refers to the inverse side field App\Entity\User#userPackages which does not exist.
App\Entity\Address No errors.
App\Entity\Favorite No errors.
App\Entity\Abuse No errors.
App\Entity\Message No errors.
App\Entity\Order No errors.
App\Entity\Notification No errors.
App\Entity\ConversationParticipant No errors.
App\Entity\AdvertGroup No errors.
App\Entity\Advert No errors.
App\Entity\Blog No errors.
App\Entity\Tagging No errors.
App\Entity\Tag No errors.
App\Entity\Employee No errors.