Query Metrics
154
Database Queries
16
Different statements
20.38 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.25 ms |
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.external_link AS external_link_2, m0_.name AS name_3, m0_.alias AS alias_4, m0_.route AS route_5, m0_.description AS description_6, m0_.priority AS priority_7, m0_.is_active AS is_active_8, m0_.image AS image_9, m0_.lft AS lft_10, m0_.lvl AS lvl_11, m0_.rgt AS rgt_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.parent_id AS parent_id_15, m0_.template_id AS template_id_16, m0_.layout_template_id AS layout_template_id_17, m0_.root_id AS root_id_18 FROM MLDev_Page m0_ WHERE m0_.parent_id IS NULL ORDER BY m0_.lft ASC
Parameters:
[] |
2 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.robots AS robots_5, t0.isActive AS isActive_6, t0.isDefault AS isDefault_7 FROM MLDev_SeoSite t0 WHERE t0.isActive = ? AND t0.isDefault = ? LIMIT 1
Parameters:
[ 1 1 ] |
3 | 0.18 ms |
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.external_link AS external_link_2, m0_.name AS name_3, m0_.alias AS alias_4, m0_.route AS route_5, m0_.description AS description_6, m0_.priority AS priority_7, m0_.is_active AS is_active_8, m0_.image AS image_9, m0_.lft AS lft_10, m0_.lvl AS lvl_11, m0_.rgt AS rgt_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.parent_id AS parent_id_15, m0_.template_id AS template_id_16, m0_.layout_template_id AS layout_template_id_17, m0_.root_id AS root_id_18 FROM MLDev_Page m0_ WHERE (m0_.route = ? OR m0_.route = ?) AND m0_.is_active = 1 ORDER BY m0_.lft ASC, m0_.priority ASC
Parameters:
[ "/ru/katalog/taif/industrial-masla" "/katalog/taif/industrial-masla" ] |
4 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.is_layout AS is_layout_4 FROM MLDev_Page_Template t0 WHERE t0.id = ?
Parameters:
[
2
]
|
5 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.is_layout AS is_layout_4 FROM MLDev_Page_Template t0 WHERE t0.id = ?
Parameters:
[
1
]
|
6 | 0.17 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.priority AS priority_3, t0.is_active AS is_active_4, t0.widget AS widget_5, t0.options AS options_6, t0.page_id AS page_id_7 FROM MLDev_Page_Content t0 WHERE (t0.is_active = ? AND t0.page_id = ?) ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[ 1 67 ] |
7 | 0.20 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.id = ?
Parameters:
[
20
]
|
8 | 0.16 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.id = ?
Parameters:
[
3
]
|
9 | 0.18 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
67
]
|
10 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
68
]
|
11 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
69
]
|
12 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
70
]
|
13 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
71
]
|
14 | 0.10 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
72
]
|
15 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
73
]
|
16 | 0.09 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
74
]
|
17 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
75
]
|
18 | 0.10 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
76
]
|
19 | 0.09 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
77
]
|
20 | 0.66 ms |
SELECT m0_.id AS id_0, m0_.external_id AS external_id_1, m0_.name AS name_2, m0_.alterName AS alterName_3, m0_.sku AS sku_4, m0_.amount AS amount_5, m0_.is_active AS is_active_6, m0_.is_new AS is_new_7, m0_.is_sale AS is_sale_8, m0_.use_on_yandex_market AS use_on_yandex_market_9, m0_.available_image_list AS available_image_list_10, m1_.id AS id_11, m1_.external_id AS external_id_12, m1_.name AS name_13, m1_.alter_name AS alter_name_14, m1_.alias AS alias_15, m1_.unit AS unit_16, m1_.annotation AS annotation_17, m1_.description AS description_18, m1_.priority AS priority_19, m1_.is_active AS is_active_20, m1_.extra_fields AS extra_fields_21, m1_.created_at AS created_at_22, m1_.updated_at AS updated_at_23, m0_.product_id AS product_id_24, m0_.product_image_id AS product_image_id_25, m0_.color_id AS color_id_26, m1_.brand_id AS brand_id_27 FROM MLDev_Product_Item m0_ INNER JOIN MLDev_Product m1_ ON m0_.product_id = m1_.id INNER JOIN MLDev_Product_Page m3_ ON m1_.id = m3_.product_id INNER JOIN MLDev_Page m2_ ON m2_.id = m3_.page_id LEFT JOIN MLDev_Product_Item_Price m4_ ON m0_.id = m4_.product_item_id WHERE m2_.id IN (68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 67) AND m1_.is_active = 1 AND m0_.is_active = 1 ORDER BY m0_.amount DESC, m1_.priority DESC, m1_.id ASC
Parameters:
[] |
21 | 0.17 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
68
]
|
22 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
69
]
|
23 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
70
]
|
24 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
71
]
|
25 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
72
]
|
26 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
73
]
|
27 | 0.10 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
74
]
|
28 | 0.09 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
75
]
|
29 | 0.09 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
76
]
|
30 | 0.09 ms |
SELECT COUNT(*) FROM MLDev_Page t0 WHERE t0.parent_id = ?
Parameters:
[
77
]
|
31 | 0.14 ms |
SELECT MIN(m0_.value) AS sclr_0, MAX(m0_.value) AS sclr_1 FROM MLDev_Product_Item m1_ INNER JOIN MLDev_Product m2_ ON m1_.product_id = m2_.id INNER JOIN MLDev_Product_Page m4_ ON m2_.id = m4_.product_id INNER JOIN MLDev_Page m3_ ON m3_.id = m4_.page_id LEFT JOIN MLDev_Product_Item_Price m0_ ON m1_.id = m0_.product_item_id WHERE m3_.id IN (68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 67) AND m2_.is_active = 1 AND m1_.is_active = 1 ORDER BY m1_.amount DESC, m2_.priority DESC, m2_.id ASC
Parameters:
[] |
32 | 0.15 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
262
]
|
33 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
262
]
|
34 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
263
]
|
35 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
263
]
|
36 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
264
]
|
37 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
264
]
|
38 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
265
]
|
39 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
265
]
|
40 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
266
]
|
41 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
266
]
|
42 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
267
]
|
43 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
267
]
|
44 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
268
]
|
45 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
268
]
|
46 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
269
]
|
47 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
269
]
|
48 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
270
]
|
49 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
270
]
|
50 | 0.15 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
271
]
|
51 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
271
]
|
52 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
272
]
|
53 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
272
]
|
54 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
273
]
|
55 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
273
]
|
56 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
274
]
|
57 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
274
]
|
58 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
275
]
|
59 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
275
]
|
60 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
276
]
|
61 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
276
]
|
62 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
277
]
|
63 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
277
]
|
64 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
278
]
|
65 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
278
]
|
66 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
279
]
|
67 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
279
]
|
68 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
280
]
|
69 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
280
]
|
70 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
281
]
|
71 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
281
]
|
72 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
282
]
|
73 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
282
]
|
74 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
283
]
|
75 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
283
]
|
76 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
284
]
|
77 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
284
]
|
78 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
285
]
|
79 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
285
]
|
80 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
286
]
|
81 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
286
]
|
82 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
287
]
|
83 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
287
]
|
84 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
288
]
|
85 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
288
]
|
86 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
289
]
|
87 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
289
]
|
88 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
290
]
|
89 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
290
]
|
90 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
291
]
|
91 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
291
]
|
92 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
292
]
|
93 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
292
]
|
94 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
293
]
|
95 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
293
]
|
96 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
294
]
|
97 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
294
]
|
98 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
295
]
|
99 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
295
]
|
100 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
296
]
|
101 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
296
]
|
102 | 0.11 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
297
]
|
103 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
297
]
|
104 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
298
]
|
105 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
298
]
|
106 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
299
]
|
107 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
299
]
|
108 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
300
]
|
109 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
300
]
|
110 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
301
]
|
111 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
301
]
|
112 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
302
]
|
113 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
302
]
|
114 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
303
]
|
115 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
303
]
|
116 | 0.16 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
304
]
|
117 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
304
]
|
118 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
305
]
|
119 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
305
]
|
120 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
306
]
|
121 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
306
]
|
122 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
307
]
|
123 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
307
]
|
124 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
308
]
|
125 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
308
]
|
126 | 0.13 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
309
]
|
127 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
309
]
|
128 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
310
]
|
129 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
310
]
|
130 | 0.14 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
311
]
|
131 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
311
]
|
132 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
312
]
|
133 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
312
]
|
134 | 0.12 ms |
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
313
]
|
135 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
313
]
|
136 | 0.13 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.is_default AS is_default_5, t0.seo_site_id AS seo_site_id_6 FROM MLDev_SeoInfo t0 INNER JOIN MLDev_Page_SeoInfo ON t0.id = MLDev_Page_SeoInfo.seo_info_id WHERE MLDev_Page_SeoInfo.page_id = ?
Parameters:
[
67
]
|
137 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "header-contacts" 1 ] |
138 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"default"
]
|
139 | 0.17 ms |
SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = ? AND te.is_active = ? ORDER BY priority ASC
Parameters:
[ 1 1 ] |
140 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"footer-1"
]
|
141 | 0.14 ms |
SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = ? AND te.is_active = ? ORDER BY priority ASC
Parameters:
[ 2 1 ] |
142 | 0.14 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
3
]
|
143 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"footer-2"
]
|
144 | 0.14 ms |
SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = ? AND te.is_active = ? ORDER BY priority ASC
Parameters:
[ 3 1 ] |
145 | 0.14 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
23
]
|
146 | 0.17 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
6
]
|
147 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"footer-3"
]
|
148 | 0.15 ms |
SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = ? AND te.is_active = ? ORDER BY priority ASC
Parameters:
[ 4 1 ] |
149 | 0.15 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
2
]
|
150 | 0.14 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
7
]
|
151 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "footer-contacts-1" 1 ] |
152 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "footer-contacts-2" 1 ] |
153 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "footer-policy-link" 1 ] |
154 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "counters" 1 ] |
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 |
---|---|
MLDev\BaseBundle\Entity\Page | No errors. |
MLDev\BaseBundle\Entity\PageTemplate | No errors. |
MLDev\BaseBundle\Entity\Menu | No errors. |
MLDev\BaseBundle\Entity\PageContent | No errors. |
MLDev\BaseBundle\Entity\SeoInfo | No errors. |
MLDev\SeoSiteBundle\Entity\SeoSiteInfo | No errors. |
MLDev\BaseBundle\Entity\SeoSite | No errors. |
MLDev\SeoSiteBundle\Entity\SeoSite | No errors. |
MLDev\CatalogBundle\Entity\ProductItem | No errors. |
MLDev\CatalogBundle\Entity\Product | No errors. |
MLDev\CatalogBundle\Entity\ProductItemPrice | No errors. |
MLDev\CatalogBundle\Entity\ProductImage | No errors. |
MLDev\CatalogBundle\Entity\Color | No errors. |
MLDev\CatalogBundle\Entity\Brand | No errors. |
MLDev\CatalogBundle\Entity\ProductItemStock | No errors. |
MLDev\CatalogBundle\Entity\ProductDocument | No errors. |
MLDev\BaseBundle\Entity\Block | No errors. |