Query Metrics
2
Database Queries
2
Different statements
3.17 ms
Query time
0
Invalid entities
72
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.07 ms (65.31%) |
1 |
SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.name_de AS name_de_2, c0_.name_en AS name_en_3, c0_.name_tr AS name_tr_4, c0_.name_ru AS name_ru_5, c0_.name_uk AS name_uk_6, c0_.slug AS slug_7, c0_.enabled AS enabled_8, c0_.order_id AS order_id_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c1_.id AS id_12, c1_.icon AS icon_13, c1_.name_de AS name_de_14, c1_.name_en AS name_en_15, c1_.name_tr AS name_tr_16, c1_.name_ru AS name_ru_17, c1_.name_uk AS name_uk_18, c1_.slug AS slug_19, c1_.enabled AS enabled_20, c1_.order_id AS order_id_21, c1_.created_at AS created_at_22, c1_.updated_at AS updated_at_23, c0_.parent_id AS parent_id_24, c0_.user_id AS user_id_25, c1_.parent_id AS parent_id_26, c1_.user_id AS user_id_27 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.enabled = 1 AND (c1_.enabled = 1 OR c1_.id IS NULL) ORDER BY c0_.order_id ASC, c1_.order_id ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
1.10 ms (34.69%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.type AS type_4, a0_.latitude AS latitude_5, a0_.longitude AS longitude_6, a0_.street AS street_7, a0_.city AS city_8, a0_.postcode AS postcode_9, a0_.country AS country_10, a0_.google_place_id AS google_place_id_11, a0_.url AS url_12, a0_.phone_number AS phone_number_13, a0_.rating AS rating_14, a0_.reviews_count AS reviews_count_15, a0_.image AS image_16, a0_.order_id AS order_id_17, a0_.created_at AS created_at_18, a0_.updated_at AS updated_at_19, a0_.category_id AS category_id_20, a0_.user_id AS user_id_21 FROM activity a0_ ORDER BY a0_.order_id ASC LIMIT 20
Parameters:
[]
|
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\Category | 59 |
| App\Entity\Activity | 12 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Activity | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\User | No errors. |