Query Metrics
398
Database Queries
4
Different statements
223.46 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
158.24 ms (70.81%) |
367 |
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 WHERE t0.visible = ? AND t0.cat = ? ORDER BY t0.prior DESC
Parameters:
[ 1 16 ] |
52.05 ms (23.29%) |
1 |
SELECT id, cat, intname, name, art, price, price2, price3, priceopt, priceopt2, priceopt3, skidka, skidka2, skidka3, skidkaopt, skidkaopt2, skidkaopt3, numdiscount, numdiscount2, numdiscount3, chars, numdiscountopt, numdiscountopt2, numdiscountopt3, num, num2, num3, weight, weight2, weight3, inpack, inpack2, inpack3, pop, new, mix, ACTION, onsale, prior, ordered, CHANGED, colors FROM prod WHERE visible = 1 AND (num > 0 OR num2 > 0 OR num3 > 0) AND (cat = 641 OR cat = 645 OR cat = 646 OR cat = 647 OR cat = 648 OR cat = 649 OR cat = 652 OR cat = 653 OR cat = 733 OR cat = 734 OR cat = 735 OR cat = 736 OR cat = 737 OR cat = 738 OR cat = 739 OR cat = 740 OR cat = 741 OR cat = 742 OR cat = 743 OR cat = 744 OR cat = 745 OR cat = 766 OR cat = 797 OR cat = 805 OR cat = 855 OR cat = 856 OR cat = 895 OR cat = 896 OR cat = 897 OR cat = 898 OR cat = 899 OR cat = 900 OR cat = 901 OR cat = 902 OR cat = 903 OR cat = 904 OR cat = 905 OR cat = 906 OR cat = 949 OR cat = 204)
Parameters:
[] |
12.37 ms (5.54%) |
29 |
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 catpage_translation t0 WHERE t0.object_id = ?
Parameters:
[
27
]
|
0.79 ms (0.36%) |
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
]
|
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\Wishlist | No errors. |
App\Entity\Catchar | No errors. |
App\Entity\PagePhoto | No errors. |
App\Entity\PageBlock | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\PageTranslation | No errors. |
App\Entity\Translation\CatTranslation | No errors. |
App\Entity\Translation\ProdTranslation | No errors. |
App\Entity\Translation\DiscountTranslation | No errors. |
App\Entity\Translation\CatpageTranslation | No errors. |
App\Entity\Timer | No errors. |
App\Entity\Char | No errors. |
App\Entity\Charval | No errors. |