GET https://dev.petso.halisz.pl/hodowle?page=1

Response
200 OK
IP
216.73.216.123
Profiled on
Token
415e05

Query Metrics

40 Database Queries
17 Different statements
1073.06 ms Query time
2 Invalid entities
819 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
771.02 ms
(71.85%) 		1 
SELECT DISTINCT b0_.id AS id_0, (CASE WHEN (SELECT COUNT(i1_.id) AS sclr_2 FROM breeding b2_ LEFT JOIN breeding_images b3_ ON b2_.id = b3_.breeding_id LEFT JOIN image i1_ ON i1_.id = b3_.image_id WHERE b2_.id = b0_.id) > 3 THEN 1 ELSE 0 END) + (CASE WHEN (SELECT COUNT(o4_.id) AS sclr_3 FROM breeding b5_ LEFT JOIN `user` u6_ ON b5_.owner_id = u6_.id LEFT JOIN offer o4_ ON u6_.id = o4_.owner_id WHERE b5_.id = b0_.id AND o4_.status = ?) > 0 THEN 2 ELSE 0 END) AS sclr_1, u7_.last_offer_added_at AS last_offer_added_at_4, b0_.id AS id_5 FROM breeding b0_ LEFT JOIN breeding_breed b9_ ON b0_.id = b9_.breeding_id LEFT JOIN breed b8_ ON b8_.id = b9_.breed_id LEFT JOIN breed_information b10_ ON b8_.id = b10_.breed_id LEFT JOIN category c11_ ON b8_.category_id = c11_.id LEFT JOIN `user` u7_ ON b0_.owner_id = u7_.id LEFT JOIN foundation f12_ ON u7_.id = f12_.owner_id LEFT JOIN breeding_images b14_ ON b0_.id = b14_.breeding_id LEFT JOIN image i13_ ON i13_.id = b14_.image_id LEFT JOIN association a15_ ON b0_.association_id = a15_.id LEFT JOIN federation f16_ ON a15_.federation_id = f16_.id LEFT JOIN image i17_ ON u7_.avatar_id = i17_.id LEFT JOIN province p18_ ON u7_.province_id = p18_.id LEFT JOIN offer o19_ ON u7_.id = o19_.owner_id WHERE u7_.is_blocked <> 1 AND u7_.is_verified = 1 AND u7_.active = 1 AND u7_.deleted_at IS NULL ORDER BY sclr_1 DESC, u7_.last_offer_added_at DESC, b0_.id DESC LIMIT 16
Parameters: 
[
  "approved"
]
View formatted query    View runnable query    Explain query    View query backtrace
134.17 ms
(12.50%) 		1 
SELECT (CASE WHEN (SELECT COUNT(i0_.id) AS sclr_1 FROM breeding b1_ LEFT JOIN breeding_images b2_ ON b1_.id = b2_.breeding_id LEFT JOIN image i0_ ON i0_.id = b2_.image_id WHERE b1_.id = b3_.id) > 3 THEN 1 ELSE 0 END) + (CASE WHEN (SELECT COUNT(o4_.id) AS sclr_2 FROM breeding b5_ LEFT JOIN `user` u6_ ON b5_.owner_id = u6_.id LEFT JOIN offer o4_ ON u6_.id = o4_.owner_id WHERE b5_.id = b3_.id AND o4_.status = ?) > 0 THEN 2 ELSE 0 END) AS sclr_0, b3_.id AS id_3, b3_.name AS name_4, b3_.regon AS regon_5, b3_.description AS description_6, b3_.verified AS verified_7, b3_.association_custom AS association_custom_8, b3_.nickname AS nickname_9, b3_.facebook_url AS facebook_url_10, b3_.instagram_url AS instagram_url_11, b3_.web_url AS web_url_12, b3_.certificate_file AS certificate_file_13, b3_.certificate_file_status AS certificate_file_status_14, b3_.certificate_file_uploaded_at AS certificate_file_uploaded_at_15, b3_.certificate_file_rejected_reason AS certificate_file_rejected_reason_16, b3_.certificate_file_public AS certificate_file_public_17, b3_.deleted_at AS deleted_at_18, b7_.id AS id_19, b7_.name AS name_20, b7_.slug AS slug_21, b7_.description AS description_22, b7_.active AS active_23, b7_.breeding_description AS breeding_description_24, b7_.title AS title_25, b7_.meta_title AS meta_title_26, b7_.meta_keywords AS meta_keywords_27, b7_.meta_description AS meta_description_28, b8_.id AS id_29, b8_.name AS name_30, b8_.content AS content_31, b8_.stat_size AS stat_size_32, b8_.stat_exercises AS stat_exercises_33, b8_.stat_training AS stat_training_34, b8_.stat_hair_amount AS stat_hair_amount_35, b8_.stat_haircut_frequency AS stat_haircut_frequency_36, b8_.stat_kids AS stat_kids_37, b8_.stat_health AS stat_health_38, b8_.stat_costs AS stat_costs_39, b8_.stat_intelligence AS stat_intelligence_40, b8_.param_life AS param_life_41, b8_.param_weight_male AS param_weight_male_42, b8_.param_weight_female AS param_weight_female_43, b8_.param_growth AS param_growth_44, b8_.param_recognized_by_fci AS param_recognized_by_fci_45, b8_.blocks AS blocks_46, b8_.title AS title_47, b8_.meta_title AS meta_title_48, b8_.meta_keywords AS meta_keywords_49, b8_.meta_description AS meta_description_50, c9_.id AS id_51, c9_.name AS name_52, c9_.slug AS slug_53, c9_.description AS description_54, c9_.active AS active_55, c9_.position AS position_56, c9_.breeding_description AS breeding_description_57, c9_.title AS title_58, c9_.meta_title AS meta_title_59, c9_.meta_keywords AS meta_keywords_60, c9_.meta_description AS meta_description_61, u10_.id AS id_62, u10_.email AS email_63, u10_.roles AS roles_64, u10_.password AS password_65, u10_.firstname AS firstname_66, u10_.lastname AS lastname_67, u10_.phone AS phone_68, u10_.city AS city_69, u10_.postcode AS postcode_70, u10_.address AS address_71, u10_.active AS active_72, u10_.is_verified AS is_verified_73, u10_.uuid AS uuid_74, u10_.newsletter AS newsletter_75, u10_.is_blocked AS is_blocked_76, u10_.blocked_message AS blocked_message_77, u10_.blocked_date AS blocked_date_78, u10_.allow_auto_approval AS allow_auto_approval_79, u10_.type AS type_80, u10_.last_offer_added_at AS last_offer_added_at_81, u10_.delete_request_at AS delete_request_at_82, u10_.created_at AS created_at_83, u10_.updated_at AS updated_at_84, u10_.deleted_at AS deleted_at_85, f11_.id AS id_86, f11_.name AS name_87, f11_.phone AS phone_88, f11_.regon AS regon_89, f11_.address AS address_90, f11_.city AS city_91, f11_.postcode AS postcode_92, f11_.description AS description_93, f11_.facebook_url AS facebook_url_94, f11_.instagram_url AS instagram_url_95, f11_.web_url AS web_url_96, f11_.deleted_at AS deleted_at_97, i12_.id AS id_98, i12_.name AS name_99, i12_.alt AS alt_100, i12_.file AS file_101, i12_.uuid AS uuid_102, i12_.type AS type_103, i12_.temp AS temp_104, i12_.path AS path_105, i12_.width AS width_106, i12_.height AS height_107, i12_.extension AS extension_108, i12_.position AS position_109, i12_.created_at AS created_at_110, i12_.updated_at AS updated_at_111, a13_.id AS id_112, a13_.name AS name_113, a13_.regon AS regon_114, f14_.id AS id_115, f14_.name AS name_116, f14_.regon AS regon_117, f14_.description AS description_118, f14_.show_badge AS show_badge_119, f14_.full_name AS full_name_120, f14_.show_table AS show_table_121, i15_.id AS id_122, i15_.name AS name_123, i15_.alt AS alt_124, i15_.file AS file_125, i15_.uuid AS uuid_126, i15_.type AS type_127, i15_.temp AS temp_128, i15_.path AS path_129, i15_.width AS width_130, i15_.height AS height_131, i15_.extension AS extension_132, i15_.position AS position_133, i15_.created_at AS created_at_134, i15_.updated_at AS updated_at_135, p16_.id AS id_136, p16_.name AS name_137, p16_.slug AS slug_138, p16_.active AS active_139, b3_.owner_id AS owner_id_140, b3_.association_id AS association_id_141, b7_.image_id AS image_id_142, b7_.category_id AS category_id_143, b8_.breed_id AS breed_id_144, c9_.category_id AS category_id_145, c9_.image_id AS image_id_146, u10_.province_id AS province_id_147, u10_.avatar_id AS avatar_id_148, u10_.last_payment_address_id AS last_payment_address_id_149, f11_.province_id AS province_id_150, f11_.owner_id AS owner_id_151, i12_.owner_id AS owner_id_152, a13_.federation_id AS federation_id_153, i15_.owner_id AS owner_id_154 FROM breeding b3_ LEFT JOIN breeding_breed b17_ ON b3_.id = b17_.breeding_id LEFT JOIN breed b7_ ON b7_.id = b17_.breed_id LEFT JOIN breed_information b8_ ON b7_.id = b8_.breed_id LEFT JOIN category c9_ ON b7_.category_id = c9_.id LEFT JOIN `user` u10_ ON b3_.owner_id = u10_.id LEFT JOIN foundation f11_ ON u10_.id = f11_.owner_id LEFT JOIN breeding_images b18_ ON b3_.id = b18_.breeding_id LEFT JOIN image i12_ ON i12_.id = b18_.image_id LEFT JOIN association a13_ ON b3_.association_id = a13_.id LEFT JOIN federation f14_ ON a13_.federation_id = f14_.id LEFT JOIN image i15_ ON u10_.avatar_id = i15_.id LEFT JOIN province p16_ ON u10_.province_id = p16_.id LEFT JOIN offer o19_ ON u10_.id = o19_.owner_id WHERE u10_.is_blocked <> 1 AND u10_.is_verified = 1 AND u10_.active = 1 AND u10_.deleted_at IS NULL AND b3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_0 DESC, u10_.last_offer_added_at DESC, b3_.id DESC, b7_.name ASC, i12_.position ASC
Parameters: 
[
  "approved"
  1479
  152
  3259
  992
  1237
  3250
  3239
  3248
  3247
  1148
  1946
  3062
  2976
  1850
  2887
  3087
]
View formatted query    View runnable query    Explain query    View query backtrace
129.47 ms
(12.07%) 		1 
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM breeding b0_ LEFT JOIN breeding_breed b2_ ON b0_.id = b2_.breeding_id LEFT JOIN breed b1_ ON b1_.id = b2_.breed_id LEFT JOIN breed_information b3_ ON b1_.id = b3_.breed_id LEFT JOIN category c4_ ON b1_.category_id = c4_.id LEFT JOIN `user` u5_ ON b0_.owner_id = u5_.id LEFT JOIN foundation f6_ ON u5_.id = f6_.owner_id LEFT JOIN breeding_images b8_ ON b0_.id = b8_.breeding_id LEFT JOIN image i7_ ON i7_.id = b8_.image_id LEFT JOIN association a9_ ON b0_.association_id = a9_.id LEFT JOIN federation f10_ ON a9_.federation_id = f10_.id LEFT JOIN image i11_ ON u5_.avatar_id = i11_.id LEFT JOIN province p12_ ON u5_.province_id = p12_.id LEFT JOIN offer o13_ ON u5_.id = o13_.owner_id WHERE u5_.is_blocked <> 1 AND u5_.is_verified = 1 AND u5_.active = 1 AND u5_.deleted_at IS NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
15.15 ms
(1.41%) 		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
11.49 ms
(1.07%) 		16 
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.owner_id = ?
Parameters: 
[
  1479
]
View formatted query    View runnable query    Explain query    View query backtrace
2.48 ms
(0.23%) 		5 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?)
Parameters: 
[
  4520
]
View formatted query    View runnable query    Explain query    View query backtrace
2.05 ms
(0.19%) 		3 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  1418
  1940
  3431
  3432
  3620
  4512
]
View formatted query    View runnable query    Explain query    View query backtrace
1.80 ms
(0.17%) 		3 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?, ?, ?, ?)
Parameters: 
[
  1867
  2107
  2752
  4528
]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  2631
  3103
  3535
  3724
  3725
  3726
  3851
  3868
  3998
  4195
  4475
]
View formatted query    View runnable query    Explain query    View query backtrace
0.86 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  108
  652
  675
  952
  1458
  1702
  1943
  3298
  3890
  4523
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(0.06%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?, ?, ?, ?, ?)
Parameters: 
[
  4033
  4164
  4309
  4409
  4469
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(0.05%) 		1 
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
0.57 ms
(0.05%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?, ?, ?)
Parameters: 
[
  4313
  4335
  4465
]
View formatted query    View runnable query    Explain query    View query backtrace
0.50 ms
(0.05%) 		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.50 ms
(0.05%) 		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.50 ms
(0.05%) 		1 
SELECT t0.id AS id_1, t0.value AS value_2, t0.filter_id AS filter_id_3, t0.offer_id AS offer_id_4 FROM offer_filter t0 WHERE t0.offer_id IN (?, ?)
Parameters: 
[
  4255
  4257
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.03%) 		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

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\OfferFilter 442
App\Entity\Image 159
App\Entity\Offer 66
App\Entity\OfferPromotion 53
App\Entity\Province 16
App\Entity\Breeding 16
App\Entity\Breed 16
App\Entity\User 16
App\Entity\BreedInformation 11
App\Entity\Association 7
App\Entity\Filter 7
App\Entity\Federation 6
App\Entity\Category 2
App\Entity\Type 1
App\Entity\AdvertGroup 1

Entities Mapping

Class Mapping errors
App\Entity\Type No errors.
App\Entity\Image No errors.
App\Entity\Federation No errors.
App\Entity\Association No errors.
App\Entity\Breeding No errors.
App\Entity\Province No errors.
App\Entity\City No errors.
App\Entity\Setting No errors.
App\Entity\User
  • The mappings App\Entity\User#plans and App\Entity\UserPlan#owner are inconsistent with each other.
App\Entity\Offer No errors.
App\Entity\Breed No errors.
App\Entity\BreedInformation No errors.
App\Entity\Category No errors.
App\Entity\Foundation No errors.
App\Entity\Address No errors.
App\Entity\Filter 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\AdvertGroup No errors.
App\Entity\Advert No errors.
App\Entity\OfferPromotion No errors.
App\Entity\OfferFilter No errors.
App\Entity\Abuse No errors.