Query Metrics
8
Database Queries
8
Different statements
6303.43 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6182.92 ms (98.09%) |
1 |
SELECT p0_.id AS id_0 FROM prod p0_ WHERE p0_.visible = 1 AND (p0_.num > 0 OR p0_.num2 > 0 OR p0_.num3 > 0)
Parameters:
[] |
89.57 ms (1.42%) |
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 article t0 WHERE t0.visible = ?
Parameters:
[
1
]
|
22.36 ms (0.35%) |
1 |
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
Parameters:
[] |
3.85 ms (0.06%) |
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
]
|
2.01 ms (0.03%) |
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.type = ? AND t0.visible = ?
Parameters:
[ "page" 1 ] |
1.48 ms (0.02%) |
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.83 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[] |
0.40 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.brand AS brand_3, t0.intname AS intname_4, t0.name AS name_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.visible AS visible_8, t0.prior AS prior_9, t0.title AS title_10, t0.h1 AS h1_11, t0.kw AS kw_12, t0.descr AS descr_13 FROM catpage t0
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\Redirect | 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\Page | No errors. |
App\Entity\PagePhoto | No errors. |
App\Entity\PageBlock | No errors. |
App\Entity\Translation\PageTranslation | No errors. |
App\Entity\Article | No errors. |
App\Entity\Translation\ArticleTranslation | No errors. |
App\Entity\Cat | No errors. |
App\Entity\Translation\CatTranslation | No errors. |
App\Entity\Catpage | No errors. |
App\Entity\Translation\CatpageTranslation | No errors. |
App\Entity\Prod | No errors. |