Query Metrics
6
Database Queries
6
Different statements
18.16 ms
Query time
1
Invalid entities
62
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.78 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 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[ "psy" 1 ]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.73 ms |
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 3 | 2.65 ms |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM breed_information b0_ LEFT JOIN breed b1_ ON b0_.breed_id = b1_.id LEFT JOIN category c2_ ON b1_.category_id = c2_.id LEFT JOIN image i3_ ON b1_.image_id = i3_.id WHERE c2_.active = ? AND b1_.active = ? AND b1_.id NOT IN (?, ?) AND c2_.slug = ?
Parameters:
[ 1 1 52 53 "psy" ] |
||||||||||||||||||||||||||||||||||
| 4 | 2.85 ms |
SELECT DISTINCT b0_.id AS id_0, b1_.name AS name_1 FROM breed_information b0_ LEFT JOIN breed b1_ ON b0_.breed_id = b1_.id LEFT JOIN category c2_ ON b1_.category_id = c2_.id LEFT JOIN image i3_ ON b1_.image_id = i3_.id WHERE c2_.active = ? AND b1_.active = ? AND b1_.id NOT IN (?, ?) AND c2_.slug = ? ORDER BY b1_.name ASC LIMIT 20
Parameters:
[ 1 1 52 53 "psy" ] |
||||||||||||||||||||||||||||||||||
| 5 | 10.44 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.content AS content_2, b0_.stat_size AS stat_size_3, b0_.stat_exercises AS stat_exercises_4, b0_.stat_training AS stat_training_5, b0_.stat_hair_amount AS stat_hair_amount_6, b0_.stat_haircut_frequency AS stat_haircut_frequency_7, b0_.stat_kids AS stat_kids_8, b0_.stat_health AS stat_health_9, b0_.stat_costs AS stat_costs_10, b0_.stat_intelligence AS stat_intelligence_11, b0_.param_life AS param_life_12, b0_.param_weight_male AS param_weight_male_13, b0_.param_weight_female AS param_weight_female_14, b0_.param_growth AS param_growth_15, b0_.param_recognized_by_fci AS param_recognized_by_fci_16, b0_.blocks AS blocks_17, b0_.title AS title_18, b0_.meta_title AS meta_title_19, b0_.meta_keywords AS meta_keywords_20, b0_.meta_description AS meta_description_21, b1_.id AS id_22, b1_.name AS name_23, b1_.slug AS slug_24, b1_.description AS description_25, b1_.active AS active_26, b1_.breeding_description AS breeding_description_27, b1_.title AS title_28, b1_.meta_title AS meta_title_29, b1_.meta_keywords AS meta_keywords_30, b1_.meta_description AS meta_description_31, c2_.id AS id_32, c2_.name AS name_33, c2_.slug AS slug_34, c2_.description AS description_35, c2_.active AS active_36, c2_.position AS position_37, c2_.breeding_description AS breeding_description_38, c2_.title AS title_39, c2_.meta_title AS meta_title_40, c2_.meta_keywords AS meta_keywords_41, c2_.meta_description AS meta_description_42, i3_.id AS id_43, i3_.name AS name_44, i3_.alt AS alt_45, i3_.file AS file_46, i3_.uuid AS uuid_47, i3_.type AS type_48, i3_.temp AS temp_49, i3_.path AS path_50, i3_.width AS width_51, i3_.height AS height_52, i3_.extension AS extension_53, i3_.position AS position_54, i3_.created_at AS created_at_55, i3_.updated_at AS updated_at_56, b0_.breed_id AS breed_id_57, b1_.image_id AS image_id_58, b1_.category_id AS category_id_59, c2_.category_id AS category_id_60, c2_.image_id AS image_id_61, i3_.owner_id AS owner_id_62 FROM breed_information b0_ LEFT JOIN breed b1_ ON b0_.breed_id = b1_.id LEFT JOIN category c2_ ON b1_.category_id = c2_.id LEFT JOIN image i3_ ON b1_.image_id = i3_.id WHERE c2_.active = ? AND b1_.active = ? AND b1_.id NOT IN (?, ?) AND c2_.slug = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b1_.name ASC
Parameters:
[ 1 1 52 53 "psy" 83 62 69 14 2 67 28 18 20 81 15 64 17 21 65 9 60 22 24 75 ] |
||||||||||||||||||||||||||||||||||
| 6 | 0.69 ms |
SELECT s0_.value AS value_0 FROM setting s0_ WHERE s0_.name = ? LIMIT 1
Parameters:
[
"breed_content_bottom_2"
]
|
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 | 21 |
| App\Entity\BreedInformation | 20 |
| App\Entity\Breed | 20 |
| App\Entity\Category | 1 |
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\Setting | No errors. |
| App\Entity\BreedInformation | No errors. |
| App\Entity\User |
|