Query Metrics
64
Database Queries
13
Different statements
52.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
30.76 ms (58.19%) |
2 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.cart AS cart_3 FROM cart_unsaved t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
"guest_693f520f6df0a"
]
|
|
8.48 ms (16.04%) |
26 |
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:
[
725
]
|
|
5.81 ms (10.98%) |
22 |
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 block_translation t0 WHERE t0.object_id = ?
Parameters:
[
1
]
|
|
2.29 ms (4.33%) |
3 |
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.short AS short_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.spec AS spec_10, t0.newlabel AS newlabel_11, t0.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18, t0.pic AS pic_19 FROM cat t0 WHERE t0.cat = ? AND t0.visible = ? ORDER BY t0.prior DESC
Parameters:
[ 0 1 ] |
|
1.65 ms (3.12%) |
1 |
SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC
Parameters:
[
0
]
|
|
0.95 ms (1.80%) |
3 |
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.short AS short_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.spec AS spec_10, t0.newlabel AS newlabel_11, t0.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18, t0.pic AS pic_19 FROM cat t0 WHERE t0.id = ?
Parameters:
[
725
]
|
|
0.63 ms (1.20%) |
1 |
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.value AS value_4 FROM block t0
Parameters:
[] |
|
0.60 ms (1.13%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.page AS page_3, t0.intname AS intname_4, t0.mainpage AS mainpage_5, t0.name AS name_6, t0.href AS href_7, t0.short AS short_8, t0.cont AS cont_9, t0.prior AS prior_10, t0.visible AS visible_11, t0.title AS title_12, t0.h1 AS h1_13, t0.kw AS kw_14, t0.descr AS descr_15, t0.tstamp AS tstamp_16, t0.icon AS icon_17 FROM page t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
"catalog"
]
|
|
0.46 ms (0.88%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 725 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.46 ms (0.87%) |
1 |
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:
[
30
]
|
|
0.34 ms (0.64%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 531 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.24 ms (0.46%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 917 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.20 ms (0.37%) |
1 |
SELECT c0_.id AS id_0, c0_.intname AS intname_1, c0_.cat AS cat_2 FROM cat c0_ WHERE c0_.id = 0 ORDER BY c0_.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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Discount | No errors. |
| App\Entity\Prod | No errors. |
| App\Entity\CartUnsaved | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Cat | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Catpage | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\Char | No errors. |
| App\Entity\Block | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| App\Entity\Translation\BlockTranslation | No errors. |
| App\Entity\Wishlist | No errors. |
| App\Entity\Catchar | No errors. |
| App\Entity\Charval | No errors. |
| App\Entity\PagePhoto | No errors. |
| App\Entity\PageBlock | No errors. |
| App\Entity\Translation\PageTranslation | No errors. |
| App\Entity\Translation\CatTranslation | No errors. |