Query Metrics
75
Database Queries
6
Different statements
3.60 ms
Query time
0
Invalid entities
67
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.33 ms (64.60%) |
61 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM cat_translation t0 WHERE t0.object_id = ?
Parameters:
[
739730
]
|
|
0.47 ms (13.05%) |
5 |
SELECT c0_.id AS id_0, c0_.cat AS cat_1, c0_.intname AS intname_2, c0_.name AS name_3, c0_.short AS short_4, c0_.cont AS cont_5, c0_.cont2 AS cont2_6, c0_.prior AS prior_7, c0_.visible AS visible_8, c0_.spec AS spec_9, c0_.newlabel AS newlabel_10, c0_.supercat AS supercat_11, c0_.inprice AS inprice_12, c0_.incatalog AS incatalog_13, c0_.notinxml AS notinxml_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.kw AS kw_17, c0_.descr AS descr_18, c0_.pic AS pic_19, c0_.bc AS bc_20, c0_.noindex AS noindex_21 FROM cat c0_ WHERE c0_.visible = 1 AND c0_.cat = ? ORDER BY c0_.prior DESC
Parameters:
[
739730
]
|
|
0.32 ms (8.97%) |
1 |
SELECT c0_.id AS id_0, c0_.cat AS cat_1, c0_.intname AS intname_2, c0_.name AS name_3, c0_.short AS short_4, c0_.cont AS cont_5, c0_.cont2 AS cont2_6, c0_.prior AS prior_7, c0_.visible AS visible_8, c0_.spec AS spec_9, c0_.newlabel AS newlabel_10, c0_.supercat AS supercat_11, c0_.inprice AS inprice_12, c0_.incatalog AS incatalog_13, c0_.notinxml AS notinxml_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.kw AS kw_17, c0_.descr AS descr_18, c0_.pic AS pic_19, c0_.bc AS bc_20, c0_.noindex AS noindex_21 FROM cat c0_ WHERE c0_.supercat = 1 AND c0_.visible = 1 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.29 ms (8.10%) |
6 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM page_translation t0 WHERE t0.object_id = ?
Parameters:
[
236
]
|
|
0.10 ms (2.83%) |
1 |
SELECT p0_.id AS id_0, p0_.page AS page_1, p0_.type AS type_2, p0_.intname AS intname_3, p0_.mainpage AS mainpage_4, p0_.name AS name_5, p0_.href AS href_6, p0_.short AS short_7, p0_.cont AS cont_8, p0_.autosub AS autosub_9, p0_.prior AS prior_10, p0_.visible AS visible_11, p0_.main AS main_12, p0_.foot AS foot_13, p0_.title AS title_14, p0_.h1 AS h1_15, p0_.kw AS kw_16, p0_.descr AS descr_17, p0_.tstamp AS tstamp_18, p0_.icon AS icon_19, p0_.topmenu AS topmenu_20, p0_.footmenu AS footmenu_21, p0_.noindex AS noindex_22, p0_.rating AS rating_23 FROM page p0_ WHERE p0_.visible = 1 AND p0_.topmenu = 1 ORDER BY p0_.prior DESC
Parameters:
[] |
|
0.09 ms (2.44%) |
1 |
SELECT p0_.id AS id_0, p0_.page AS page_1, p0_.type AS type_2, p0_.intname AS intname_3, p0_.mainpage AS mainpage_4, p0_.name AS name_5, p0_.href AS href_6, p0_.short AS short_7, p0_.cont AS cont_8, p0_.autosub AS autosub_9, p0_.prior AS prior_10, p0_.visible AS visible_11, p0_.main AS main_12, p0_.foot AS foot_13, p0_.title AS title_14, p0_.h1 AS h1_15, p0_.kw AS kw_16, p0_.descr AS descr_17, p0_.tstamp AS tstamp_18, p0_.icon AS icon_19, p0_.topmenu AS topmenu_20, p0_.footmenu AS footmenu_21, p0_.noindex AS noindex_22, p0_.rating AS rating_23 FROM page p0_ WHERE p0_.visible = 1 AND p0_.footmenu = 1 ORDER BY p0_.prior DESC
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\Cat | 61 |
| App\Entity\Page | 6 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Cat | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| App\Entity\Translation\CatTranslation | No errors. |
| App\Entity\Catpage | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PagePhoto | No errors. |
| App\Entity\PageBlock | No errors. |
| App\Entity\Translation\PageTranslation | No errors. |
| App\Entity\Translation\CatpageTranslation | No errors. |
| App\Entity\Translation\PagePhotoTranslation | No errors. |
| App\Entity\Translation\PageBlockTranslation | No errors. |