Query Metrics
3
Database Queries
3
Different statements
2.17 ms
Query time
1
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.32 ms (60.68%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM pages p0_ LEFT JOIN pages p1_ ON p0_.parent_id = p1_.id LEFT JOIN languages l2_ ON p0_.language_id = l2_.id LEFT JOIN pages p3_ ON p0_.id = p3_.translation_id WHERE p0_.synonym = ? ORDER BY p0_.id DESC LIMIT 30
Parameters:
[
"user-like-list"
]
|
|
0.51 ms (23.28%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.synonym AS synonym_2, p0_.place AS place_3, p0_.type AS type_4, p0_.content AS content_5, p0_.orders AS orders_6, p0_.active AS active_7, p0_.clickability AS clickability_8, p0_.menu_class AS menu_class_9, p0_.images AS images_10, p0_.seo_title AS seo_title_11, p0_.seo_description AS seo_description_12, p1_.id AS id_13, p1_.name AS name_14, p1_.synonym AS synonym_15, p1_.place AS place_16, p1_.type AS type_17, p1_.content AS content_18, p1_.orders AS orders_19, p1_.active AS active_20, p1_.clickability AS clickability_21, p1_.menu_class AS menu_class_22, p1_.images AS images_23, p1_.seo_title AS seo_title_24, p1_.seo_description AS seo_description_25, l2_.id AS id_26, l2_.name AS name_27, l2_.key AS key_28, p3_.id AS id_29, p3_.name AS name_30, p3_.synonym AS synonym_31, p3_.place AS place_32, p3_.type AS type_33, p3_.content AS content_34, p3_.orders AS orders_35, p3_.active AS active_36, p3_.clickability AS clickability_37, p3_.menu_class AS menu_class_38, p3_.images AS images_39, p3_.seo_title AS seo_title_40, p3_.seo_description AS seo_description_41, p0_.parent_id AS parent_id_42, p0_.slider_id AS slider_id_43, p0_.language_id AS language_id_44, p0_.translation_id AS translation_id_45, p1_.parent_id AS parent_id_46, p1_.slider_id AS slider_id_47, p1_.language_id AS language_id_48, p1_.translation_id AS translation_id_49, p3_.parent_id AS parent_id_50, p3_.slider_id AS slider_id_51, p3_.language_id AS language_id_52, p3_.translation_id AS translation_id_53 FROM pages p0_ LEFT JOIN pages p1_ ON p0_.parent_id = p1_.id LEFT JOIN languages l2_ ON p0_.language_id = l2_.id LEFT JOIN pages p3_ ON p0_.id = p3_.translation_id WHERE p0_.synonym = ? AND p0_.id IN (?) ORDER BY p0_.id DESC
Parameters:
[ "user-like-list" 27 ] |
|
0.35 ms (16.05%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pages p0_ LEFT JOIN pages p1_ ON p0_.parent_id = p1_.id LEFT JOIN languages l2_ ON p0_.language_id = l2_.id LEFT JOIN pages p3_ ON p0_.id = p3_.translation_id WHERE p0_.synonym = ?
Parameters:
[
"user-like-list"
]
|
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\Pages | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Pages | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Languages |
|
| App\Entity\Slider | No errors. |
| App\Entity\PageInfos | No errors. |
| App\Entity\Gallery | No errors. |