Query Metrics
16
Database Queries
16
Different statements
85.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.14 ms |
SELECT (c0_.id) AS sclr_0, (c0_.name) AS sclr_1, (c0_.parent_id) AS sclr_2, (c0_.products_number) AS sclr_3, (c0_.slug) AS sclr_4, (c0_.sort) AS sclr_5, (c0_.icon) AS sclr_6, (c0_.image) AS sclr_7 FROM category c0_ WHERE c0_.visible = 1 ORDER BY c0_.sort ASC
Parameters:
[] |
| 2 | 0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.kladr AS kladr_4, t0.fias AS fias_5, t0.oktmo AS oktmo_6, t0.time_zone AS time_zone_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.population AS population_10, t0.full_address AS full_address_11, t0.okato AS okato_12, t0.country AS country_13, t0.region_id AS region_id_14, t0.delivery_zone_id AS delivery_zone_id_15 FROM city t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 3 | 0.09 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.date_from AS date_from_2, p0_.date_to AS date_to_3, p0_.name AS name_4, p0_.config AS config_5, p0_.type AS type_6, p0_.product_label_id AS product_label_id_7 FROM promotion p0_ WHERE (p0_.is_active = 1 AND p0_.date_to >= ? AND p0_.date_from <= ?) AND p0_.type IN ('profit_set', 'registered_customer', 'even_less_price', 'discount_on_products')
Parameters:
[ "2026-02-04 06:45:36" "2026-02-04 06:45:36" ] |
| 4 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"khalaty"
]
|
| 5 | 0.51 ms |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.h1 AS h1_4, t0.top_banner_img AS top_banner_img_5, t0.seo_text_top AS seo_text_top_6, t0.seo_text_bottom AS seo_text_bottom_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.top_banner_img_mobile AS top_banner_img_mobile_10, t0.top_banner_url AS top_banner_url_11 FROM products_list_content t0 WHERE t0.id = ?
Parameters:
[
252
]
|
| 6 | 0.11 ms |
SELECT t0.id AS id_1, t0.object AS object_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5, t0.keywords AS keywords_6, t0.title_pagination AS title_pagination_7, t0.description_pagination AS description_pagination_8, t0.h1_pagination AS h1_pagination_9, t0.keywords_pagination AS keywords_pagination_10 FROM seo_template t0 WHERE t0.object = ? LIMIT 1
Parameters:
[ App\Component\Seo\SeoObjectType {#3166 : "category" } ] |
| 7 | 0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.slug AS slug_4, t0.sort AS sort_5, t0.products_number AS products_number_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image AS image_9, t0.icon AS icon_10, t0.level AS level_11, t0.filter_properties AS filter_properties_12, t0.product_properties AS product_properties_13, t0.parent_id AS parent_id_14, t0.content_id AS content_id_15 FROM category t0 WHERE t0.id = ?
Parameters:
[
559
]
|
| 8 | 0.47 ms |
SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.title AS title_2, p0_.values_sort AS values_sort_3 FROM property p0_ WHERE p0_.id IN ('9', '44', '46', '4', '29', '32', '7', '10', '8', '12', '54')
Parameters:
[] |
| 9 | 2.37 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (855, 410, 413, 550, 8, 19, 544, 580, 3840444, 335, 1528, 7, 154, 3839580, 1182, 519, 411, 553, 554, 412, 1525, 130, 617, 185, 556, 557, 5996, 147, 1623, 318, 491, 1434, 307, 1512, 347, 558, 559, 1614, 262, 499, 89, 208, 1653, 121, 131, 290, 1651, 54, 1414, 604, 542, 543, 3839594, 40, 1563, 1602, 1603, 4, 1625, 169, 257, 422, 423, 33, 146, 269, 60, 3845105, 426, 427, 587, 588, 3839557, 32, 3465303, 3230, 3498, 249, 174, 6487, 1516, 2847591, 3116, 3839550, 1569, 807, 232, 7233, 541, 163, 3840640, 4337, 160, 302, 709, 432, 433, 104, 1084, 229, 108, 429, 430, 1397, 27, 3844887, 1971, 164, 3840294, 1395, 2117, 3840081, 354, 3839637, 785, 5622, 140, 5648, 137, 82, 2282, 1967, 2048740, 3840303, 3841092, 4438, 2076, 577, 5872, 157, 39, 116423, 695, 3720, 152, 231, 7276, 3109, 4340, 573, 3839693, 416, 3838951, 582, 639, 868, 3841496, 2051, 3841495, 419, 1013, 1604, 216, 3845633, 3841394, 5689, 551, 1357, 549, 1593, 1181, 132, 272, 3840569, 547659, 1535, 297, 717, 330, 263, 3843464, 473, 42, 565, 465, 576, 495, 3840305, 3840483, 3844531, 3845369, 145, 1385, 6194, 3839561, 3678, 3828423, 3837663, 3837909, 3844527, 3845371, 6819, 504, 291, 3842046, 1610, 2070, 24, 3072, 3845422, 3845431, 162, 1994501, 3838232, 308, 3845124, 4487, 686, 1682, 5545, 1940, 3839598, 30, 355, 522, 70, 875, 3841493, 1101, 114, 2740, 2915, 3114, 994, 1089, 1415050, 3839694, 3841500, 3843542, 3843757, 3844121, 3844699, 3844877, 3845381, 3845430, 3845445, 3846236, 3847564, 1431, 1503, 1514, 3838756, 3845158, 3845370, 4156, 5014, 5375, 6742, 6751, 8048, 997, 261, 1109, 3840859, 3843462, 3847634, 539108, 1017, 1582, 1617, 1737, 204, 2301, 2503, 3471, 5184, 594, 624, 634682, 872, 2774, 3844917, 511, 7348, 3839658, 3840976, 3155803, 3837840, 3840300, 3840302, 3840304, 3840307, 3841492, 3841494, 3841501, 3841502, 3841911, 3841914, 3843627, 3843629, 3843632, 3844132, 3844526, 3844528, 3844529, 3844530, 3844533, 3844868, 3844870, 3844879, 3844885, 3845382, 3845413, 3845429, 3845446, 3845631, 3845636, 3845637, 3845638, 3845639, 3845640, 3845642, 3845647, 3845649, 3845652, 3845653, 3845654, 3845693, 3845700, 3845719, 3845732, 3847344, 3847352, 3847354, 3847561, 3847562, 3847563, 3847565, 3847566, 3847567, 3847568, 3847569, 3847639, 3847719, 4664, 488103, 488104, 1277441, 1446, 1488, 1590, 1591, 1646, 1994491, 3080, 3090, 346, 3838028, 3838971, 3840871, 3841837, 3844373, 3844925, 3845643, 3845712, 3845943, 3847353, 3847633, 3847636, 462732, 4698, 521, 595, 6247, 685, 173, 256, 271, 17, 3422, 3839318, 3839472, 3839866, 3839940, 3840642, 3840792, 3841010, 3843936, 3844071, 3844230, 3844988, 3845632, 3845641, 3845648, 3845650, 3845711, 3847351, 4508, 24851, 2048, 2174, 2377, 2874, 4442, 7491, 135, 2713, 24848, 2500, 7229, 1943, 2902040, 1396, 922, 334, 1624, 3839760, 3841444, 3843552, 3843624, 3843764, 3844034, 3844081, 3844133, 3844701, 3844702, 3844706, 3844711, 3844821, 3844841, 3844845, 3844860, 3844869, 3844892, 3845035, 3845118, 3845132, 3845260, 3845261, 3845355, 3845359, 3845384, 3845385, 3845399, 3845563, 3845566, 3845634, 3845645, 3845651, 3845655, 3845855, 3845857, 3846229, 3847155, 3847158, 3847343, 1055591, 1125, 1136, 1444, 1496, 1607, 1877, 1899, 1960, 2418, 3608, 3650, 3837643, 3837876, 3838419, 3840827, 3842019, 3845125, 3845333, 3845335, 3845801, 547, 6229, 777, 817507, 1157, 1776, 2674, 3839457, 3840382, 3840856, 3842036, 3844134, 3844921, 3845635, 3847350, 2513, 1001, 1044, 1079, 1621, 2058, 210, 2289, 2548, 2595, 2928, 3145, 3576, 3596, 3943, 3977, 4845, 526, 730, 403, 1616, 2443, 406, 1937, 407, 1401, 3841953, 3844792, 3844873, 1286425, 1730800, 3155804, 3837841, 3838994, 3839000, 3839083, 3839084, 3840218, 3840634, 3841498, 3841503, 3841505, 3841915, 3841952, 3843283, 3843461, 3843463, 3843466, 3843543, 3843551, 3843554, 3843556, 3843623, 3843631, 3843771, 3843772, 3843773, 3844061, 3844082, 3844083, 3844087, 3844119, 3844344, 3844346, 3844347, 3844536, 3844832, 3844836, 3844843, 3844883, 3844893, 3845047, 3845120, 3845128, 3845143, 3845144, 3845348, 3845352, 3845383, 3845428, 3845567, 3845568, 3845619, 3845644, 3845696, 3845710, 3845713, 3845736, 3845858, 3845860, 3847153, 3847156, 3847157, 3847159, 3847345, 3847346, 3847570, 3847573, 4666, 1026, 116, 1353, 1396523, 1723, 1749424, 1886, 2285, 2332, 2371192, 351, 361, 3647, 3822, 3839119, 3840105, 3841499, 3842274, 3842286, 3844537, 3847355, 3847357, 3847635, 6221, 6234, 747, 808776, 866, 6673, 2493, 3840465, 3840846, 3840866, 3841397, 3841954, 3842047, 3844919, 3847356, 4678, 5736, 768, 3692, 3844445, 1075, 1295442, 158, 178, 188, 2499, 2577, 2812, 3591, 488102, 5400, 6589, 6833, 960, 885, 2444, 2488, 1056, 3844953, 1730795, 3837908, 3838926, 3839008, 3839018, 3839079, 3840628, 3841399, 3841416, 3841446, 3841464, 3841912, 3841913, 3841948, 3842078, 3842519, 3843460, 3843555, 3843622, 3843625, 3843626, 3843634, 3843639, 3843770, 3844033, 3844090, 3844120, 3844345, 3844348, 3844511, 3844532, 3844704, 3844709, 3844710, 3844764, 3844829, 3844834, 3844844, 3844852, 3844859, 3844871, 3844872, 3844875, 3844876, 3844878, 3844880, 3844881, 3844882, 3844888, 3844891, 3845107, 3845119, 3845145, 3845360, 3845418, 3845426, 3845720, 3845721, 3845722, 3845723, 3845731, 3845856, 3845859, 3846150, 3847154, 3847160, 4667, 488106, 1304550, 1391, 1427, 1505, 1584, 1778, 1798, 1861, 1962, 1994478, 2296, 2752, 329, 3839124, 3840455, 3844523, 3844923, 3844937, 3845387, 3846152, 3893, 4000, 4147, 4385, 4824, 5476, 6791, 116422, 1749422, 24777, 331, 3839551, 3840191, 3840381, 3840629, 3841928, 3842119, 3842163, 3844522, 3844922, 3844924, 3846151, 13, 1099888, 1104, 1585, 1613, 1669, 1850, 3902, 5142, 606, 719, 72, 77, 870087, 1191, 1403, 3837964, 3844069, 1404, 1939, 3838221, 336, 377, 5449, 0)
Parameters:
[] |
| 10 | 79.18 ms |
SELECT p0_.property_id AS sclr_0, p0_.value_id AS sclr_1, p0_.product_id AS sclr_2 FROM product_property p0_ WHERE p0_.product_id IN ('9179', '9180', '9181', '14482', '14483', '15594', '15595', '18934', '18935', '20385', '20386', '20388', '20389', '20390', '20392', '20398', '22048', '22273', '22522', '22710', '22712', '22724', '22727', '22767', '23472', '23473', '23474', '23475', '23476', '23477', '24463', '24464', '24466', '24467', '24480', '24485', '24821', '26030', '26032', '26033', '26046', '26142', '26143', '26144', '26154', '26155', '26156', '26656', '26675', '26880', '26881', '26882', '26951', '27379', '27380', '27382', '27390', '27444', '27447', '27629', '27634', '27635', '27638', '27639', '27664', '27682', '27856', '27871', '27872', '29128', '29129', '29130', '29202', '29212', '29213', '29214', '30314', '31053', '31111', '31150', '31151', '31152', '31156', '31158', '31159', '31160', '31161', '31162', '31166', '31167', '31168', '31169', '32106', '32115', '32116', '32130', '32131', '32132', '32133', '32134', '32135', '32540', '32542', '33746', '33748', '33749', '33757', '33817', '33859', '33870', '33871', '33872', '33873', '33874', '33875', '33883', '33884', '33887', '33888', '33889', '33890', '33891', '33892', '33893', '33898', '33901', '33902', '33903', '33904', '33905', '33906', '33907', '33908', '33909', '33911', '33912', '33913', '33915', '33919', '33926', '33929', '33937', '33938', '34328', '34330', '34341', '34342', '34376', '34377', '34378', '34379', '34381', '34384', '34387', '34388', '34389', '34392', '34459', '34462', '34466', '34467', '34468', '34469', '34501', '34509', '34510', '36200', '36210', '36213', '36215', '36216', '36217', '36218', '36220', '36224', '36225', '36393', '36394', '36396', '36398', '36399', '36400', '36403', '36404', '36405', '36406', '36409', '36411', '36412', '36534', '36535', '36536', '36538', '36539', '36540', '36543', '36544', '36546', '36548', '36550', '36551', '36553', '36554', '36555', '36557', '36559', '36566', '36567', '36568', '36569', '36570', '36571', '36573', '36574', '36575', '36577', '36580', '36582', '36583', '36585', '36586', '36591', '36592', '36593', '36603', '36795', '36796', '36797', '36798', '36799', '36800', '36801', '36802', '36806', '36807', '36808', '36810', '36811', '36812', '36813', '36815', '36816', '36853', '37387', '37388', '37389', '37390', '37391', '37392', '37393', '37410', '37413', '37425', '37489', '37490', '37492', '37493', '37494', '37495', '37496', '37497', '37513', '37514', '37515', '37516', '37518', '37519', '37520', '37794', '37808', '38228', '38233', '38234', '38235', '38236', '38237', '38238', '38239', '38240', '38241', '38242', '38243', '38244', '38245', '38246', '38247', '38248', '38249', '38250', '38252', '38253', '38254', '38255', '38260', '38760', '38769', '38770', '38771', '38772', '38773', '38774', '38775', '38776', '38777', '38778', '38779', '38780', '38781', '38804', '38805', '38806', '38815', '38819', '38820', '38822', '38823', '38824', '38825', '38927', '38965', '38966', '38969', '38974', '38999', '39000', '39001', '39003', '39004', '39005', '39006', '39007', '39008', '39009', '39010', '39011', '39013', '39014', '39016', '39017', '39018', '39019', '39020', '39021', '39022', '39023', '39024', '39025', '39026', '39028', '39029', '39031', '39032', '39033', '39034', '39036', '39041', '39044', '39046', '39049', '39075', '39077', '39084', '39085', '39086', '39094', '39096', '39097', '39100', '39108', '39111', '39113', '39114', '39115', '39116', '39117', '39119', '39203', '39204', '39205', '39206', '39207', '39208', '39265', '39269', '39270', '39327', '39328', '39329', '39330', '39337', '39338', '39481', '39482', '39483', '39484', '39486', '39487', '39503', '39506', '39507', '39509', '39510', '39513', '39556', '39557', '39558', '39587', '39588', '39589', '39590', '39591', '39595', '39596', '39597', '39598', '39599', '39656', '39997', '40031', '40032', '40033', '40034', '40035', '40036', '40037', '40038', '40039', '40040', '40042', '40043', '40044', '40224', '40225', '40226', '40227', '40229', '40230', '40231', '40232', '40233', '40234', '40236', '40237', '40238', '40361', '40362', '40369', '40371', '40372', '40373', '40374', '40375', '40376', '40377', '40378', '40379', '40380', '40381', '40382', '40383', '40384', '40385', '40386', '40387', '40388', '40394', '40395', '40533', '40534', '40535', '40566', '40567', '40568', '40569', '40570', '40571', '40572', '40573', '40574', '40575', '40576', '40577', '40578', '40579', '40580', '40581', '40582', '40583', '40584', '40585', '40586', '40587', '40588', '40590', '40591', '40592', '40593', '40594', '40595', '40597', '40599', '40601', '40602', '40603', '40607', '40608', '40609', '40610', '40611', '40612', '40613', '40614', '40615', '40616', '40617', '40618', '40619', '40620', '40621', '40622', '40623', '40624', '40625', '40626', '40627', '40628', '40629', '40630', '40631', '40632', '40673', '40674', '40675', '40676', '40702', '40703', '40704', '40705', '40709', '40710', '40711', '40712', '40713', '40714', '40715', '40716', '40717', '40719', '40720', '40721', '40722', '40723', '40724', '40725', '40727', '40728', '40758', '40759', '40760', '40765', '40768', '40990', '40991', '40992', '40995', '41004', '41005', '41007', '41109', '41110', '41111', '41112', '41113', '41891', '41892', '41893', '41894', '41895', '41896', '41897', '41898', '41899', '41900', '41901', '41902', '41903', '41904', '41905', '41906', '41907', '41908', '41910', '41911', '42285', '42286', '42287', '42288', '42289', '42290', '42291', '42292', '42293', '42294', '42296', '42297', '42298', '42299', '42300', '42301', '42302', '42303', '42304', '42305', '42306', '42307', '42308', '42309', '42310', '42311', '42312', '42313', '42314', '42315', '42316', '42317', '42318', '42319', '42320', '42321', '42322', '42323', '42325', '42326', '42327', '42328', '42329', '42330', '42331', '42334', '42335', '42336', '42337', '42338', '42339')
Parameters:
[] |
| 11 | 0.57 ms |
SELECT p0_.id AS id_0, b1_.image AS image_1 FROM property_value p0_ INNER JOIN brand b1_ ON (b1_.uid = p0_.uid) WHERE p0_.id IN (3840444, 3839580, 3839594, 3839637, 3839693, 3839561, 3839598, 3839694, 3839658, 3840976)
Parameters:
[] |
| 12 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.color AS color_2, p0_.visible AS visible_3, p0_.priority AS priority_4, p0_.type AS type_5 FROM product_label p0_ WHERE p0_.type <> ? AND p0_.visible = 1
Parameters:
[
"custom"
]
|
| 13 | 0.46 ms |
SELECT plp.product_id,pl.text,pl.color,pl.priority,pl.type FROM product_label_product plp join product_label pl on pl.id = plp.product_label_id WHERE plp.product_id IN (23473,27635,36583,36796,38760,39044,40535,40765,41004,41007,42296,9179,9180,18934,22048,22522,22710,22712,22724,22727,22767,23472,23474,23475,23476,23477,24463,24464,24466,24480,24485,24821,26881,26882) AND pl.visible=1 ORDER BY plp.product_id,pl.priority DESC
Parameters:
[] |
| 14 | 0.34 ms |
SELECT te.id AS id, te.name AS name, te.slug AS slug, te.created_at AS created_at, te.updated_at AS updated_at, te.conditions AS conditions, te.visible AS visible, te.short_name AS short_name, te.image AS image, te.filter_properties AS filter_properties, te.products_count AS products_count, te.content_id AS content_id FROM virtual_category te JOIN virtual_category_category t ON t.virtual_category_id = te.id WHERE t.category_id = ? AND te.visible = ? AND te.products_count > ?
Parameters:
[ 562 1 0 ] |
| 15 | 0.29 ms |
SELECT te.id AS id, te.name AS name, te.visible AS visible, te.slug AS slug, te.sort AS sort, te.products_number AS products_number, te.created_at AS created_at, te.updated_at AS updated_at, te.image AS image, te.icon AS icon, te.level AS level, te.filter_properties AS filter_properties, te.product_properties AS product_properties, te.parent_id AS parent_id, te.content_id AS content_id FROM category te JOIN category_category_to_tag t ON t.category_source = te.id WHERE t.category_target = ? AND te.visible = ? AND te.products_number > ?
Parameters:
[ 562 1 0 ] |
| 16 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.content_head AS content_head_6 FROM ext_script 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\Category | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Sms | No errors. |
| App\Entity\PromoCode | No errors. |
| App\Entity\Settings | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\DeliveryZone | No errors. |
| App\Entity\TransporterCode | No errors. |
| App\Entity\PickPoint | No errors. |
| App\Entity\Transporter | No errors. |
| App\Entity\Promotions\AbstractPromotion | No errors. |
| App\Entity\Promotions\ProfitSetPromotion | No errors. |
| App\Entity\Promotions\DiscountRegisteredCustomerPromotion | No errors. |
| App\Entity\Promotions\EvenLessPricePromotion | No errors. |
| App\Entity\Promotions\DiscountOnProductsPromotion | No errors. |
| App\Entity\ProductLabel | No errors. |
| App\Entity\ProductsListContent | No errors. |
| App\Entity\Category1C | No errors. |
| App\Entity\VirtualCategory | No errors. |
| App\Entity\SeoTemplate | No errors. |
| App\Entity\Property | No errors. |
| App\Entity\PropertyValue | No errors. |
| App\Entity\ProductProperty | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Content | No errors. |
| App\Entity\InfoBlockLink | No errors. |
| App\Entity\ExtScript | No errors. |