GET https://dev.petso.halisz.pl/hodowca/122-Flortix-of-Collie

Response
200 OK
IP
216.73.216.123
Profiled on
Token
359dfa

Query Metrics

15 Database Queries
8 Different statements
12.09 ms Query time
2 Invalid entities
6 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.01 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.regon AS regon_3, t0.description AS description_4, t0.verified AS verified_5, t0.association_custom AS association_custom_6, t0.nickname AS nickname_7, t0.facebook_url AS facebook_url_8, t0.instagram_url AS instagram_url_9, t0.web_url AS web_url_10, t0.certificate_file AS certificate_file_11, t0.certificate_file_status AS certificate_file_status_12, t0.certificate_file_uploaded_at AS certificate_file_uploaded_at_13, t0.certificate_file_rejected_reason AS certificate_file_rejected_reason_14, t0.certificate_file_public AS certificate_file_public_15, t0.deleted_at AS deleted_at_16, t0.owner_id AS owner_id_17, t0.association_id AS association_id_18 FROM breeding t0 WHERE t0.id = ?
Parameters: 
[
  "122"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.47 ms 
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 = ?
Parameters: 
[
  123
]
View formatted query    View runnable query    Explain query    View query backtrace
3 3.74 ms 
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 u1_.id = ? ORDER BY o0_.date_created_at DESC, i9_.position ASC
Parameters: 
[
  "approved"
  "2025-12-06 15:47:47"
  123
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.78 ms 
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
5 0.73 ms 
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 INNER JOIN breeding_images ON t0.id = breeding_images.image_id WHERE breeding_images.breeding_id = ? ORDER BY t0.position ASC
Parameters: 
[
  122
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.43 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4 FROM province t0 WHERE t0.id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.43 ms 
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: 
[
  "breeding_content"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.33 ms 
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: 
[
  "breeding_content"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.44 ms 
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: 
[
  12
  1
  "2025-12-06 15:47:47"
  "2025-12-06 15:47:47"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.60 ms 
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: 
[
  "breeding_right_1"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.38 ms 
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: 
[
  "breeding_right_1"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.51 ms 
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: 
[
  13
  1
  "2025-12-06 15:47:47"
  "2025-12-06 15:47:47"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.38 ms 
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: 
[
  "breeding_right_2"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.39 ms 
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: 
[
  "breeding_right_2"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.46 ms 
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: 
[
  14
  1
  "2025-12-06 15:47:47"
  "2025-12-06 15:47:47"
]
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\AdvertGroup 3
App\Entity\Breeding 1
App\Entity\User 1
App\Entity\Province 1

Entities Mapping

Class Mapping 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\Association No errors.
App\Entity\Image No errors.
App\Entity\Breed No errors.
App\Entity\Province No errors.
App\Entity\Address No errors.
App\Entity\Foundation No errors.
App\Entity\Offer No errors.
App\Entity\Message No errors.
App\Entity\Order No errors.
App\Entity\Favorite No errors.
App\Entity\Notification No errors.
App\Entity\ConversationParticipant 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\Category No errors.
App\Entity\Federation No errors.
App\Entity\OfferFilter No errors.
App\Entity\Filter No errors.
App\Entity\OfferPromotion No errors.
App\Entity\Setting No errors.
App\Entity\City No errors.
App\Entity\AdvertGroup No errors.
App\Entity\Advert No errors.