Query Metrics
6
Database Queries
5
Different statements
228.70 ms
Query time
0
Invalid entities
6427
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.80 ms |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 15.37 ms |
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.category_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 3 | 53.72 ms |
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.category_id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
| 4 | 3.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.date_created_at AS date_created_at_6, t0.date_updated_at AS date_updated_at_7, t0.active AS active_8, t0.is_featured AS is_featured_9, t0.position AS position_10, t0.title AS title_11, t0.meta_title AS meta_title_12, t0.meta_keywords AS meta_keywords_13, t0.meta_description AS meta_description_14, t0.image_id AS image_id_15, t0.big_image_id AS big_image_id_16, t0.author_id AS author_id_17 FROM blog t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 5 | 86.72 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.regon AS regon_2, b0_.description AS description_3, b0_.verified AS verified_4, b0_.association_custom AS association_custom_5, b0_.nickname AS nickname_6, b0_.facebook_url AS facebook_url_7, b0_.instagram_url AS instagram_url_8, b0_.web_url AS web_url_9, b0_.certificate_file AS certificate_file_10, b0_.certificate_file_status AS certificate_file_status_11, b0_.certificate_file_uploaded_at AS certificate_file_uploaded_at_12, b0_.certificate_file_rejected_reason AS certificate_file_rejected_reason_13, b0_.certificate_file_public AS certificate_file_public_14, b0_.deleted_at AS deleted_at_15, b0_.owner_id AS owner_id_16, b0_.association_id AS association_id_17 FROM breeding b0_ LEFT JOIN `user` u1_ ON b0_.owner_id = u1_.id WHERE u1_.active = 1 AND u1_.deleted_at IS NULL AND u1_.is_blocked <> 1 AND u1_.is_verified = 1
Parameters:
[]
|
||||||||||||||||||||||||||||
| 6 | 68.51 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_.auto_renew AS auto_renew_20, o0_.created_at AS created_at_21, o0_.updated_at AS updated_at_22, o0_.owner_id AS owner_id_23, o0_.breed_id AS breed_id_24, o0_.category_id AS category_id_25, o0_.user_plan_id AS user_plan_id_26 FROM offer o0_ LEFT JOIN `user` u1_ ON o0_.owner_id = u1_.id WHERE u1_.active = 1 AND u1_.deleted_at IS NULL AND u1_.is_blocked <> 1 AND u1_.is_verified = 1 AND o0_.status = ? AND (o0_.ended_at > ? OR o0_.ended_at IS NULL) AND o0_.deleted_at IS NULL
Parameters:
[ "approved" "2026-03-29 02:40:19" ]
|
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\Breeding | 2939 |
| App\Entity\User | 2939 |
| App\Entity\Image | 177 |
| App\Entity\Breed | 156 |
| App\Entity\BreedInformation | 120 |
| App\Entity\Association | 72 |
| App\Entity\Blog | 20 |
| App\Entity\Category | 2 |
| App\Entity\Employee | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Breed | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\Filter | No errors. |
| App\Entity\BreedInformation | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\Employee | No errors. |
| App\Entity\Breeding | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Association | No errors. |
| App\Entity\UserPlan | No errors. |