ТЕЛЕФОН
ежедневно c 9:00 до 19:00
+38 (67) 177 37 77

Обратный звонок

  • В корзине пусто!

Размеры

Изменить стоимость для заказчика

базовая сумма

9500 грн.

Уже уплачено

грн.

Фотоподтверждение заказа:

Queries: 184, Total time: 101.997 ms [By time] [By id] [By file]
1 (0.079)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://onebyone.com.ua/'
/var/www/onebyone/onebyone.com.ua/index.php:39
2 (4.451)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/onebyone/onebyone.com.ua/index.php:51
3 (0.134)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/onebyone/onebyone.com.ua/index.php:150
4 (0.071)
SELECT *
FROM oc_currency
/var/www/onebyone/onebyone.com.ua/system/library/currency.php:13
5 (0.096)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/onebyone/onebyone.com.ua/system/library/tax.php:26
6 (0.062)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/onebyone/onebyone.com.ua/system/library/tax.php:54
7 (0.060)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/var/www/onebyone/onebyone.com.ua/system/library/weight.php:9
8 (0.050)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/var/www/onebyone/onebyone.com.ua/system/library/length.php:9
9 (17.040)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 14 DAY)
/var/www/onebyone/onebyone.com.ua/system/library/cart.php:14
10 (0.139)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/onebyone/onebyone.com.ua/system/library/openbay.php:117
11 (0.090)
SELECT *
FROM oc_event
/var/www/onebyone/onebyone.com.ua/index.php:259
12 (0.166)
SELECT oo.option_id
FROM oc_ocfilter_option oo
LEFT JOIN oc_ocfilter_option_to_category oo2c ON(oo.option_id = oo2c.option_id)
WHERE oo2c.category_id = '50' AND oo.`keyword` = 'razmer' LIMIT 1
/var/www/onebyone/onebyone.com.ua/catalog/controller/module/ocfilter.php:640
13 (0.053)
SELECT value_id
FROM oc_ocfilter_option_value
WHERE option_id = '5' AND `keyword` = 's' LIMIT 1
/var/www/onebyone/onebyone.com.ua/catalog/controller/module/ocfilter.php:648
14 (0.046)
SELECT value_id
FROM oc_ocfilter_option_value
WHERE option_id = '5' AND `keyword` = 'xs-s' LIMIT 1
/var/www/onebyone/onebyone.com.ua/catalog/controller/module/ocfilter.php:648
15 (0.110)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '50' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:4
16 (0.093)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '50' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
17 (9.107)
SELECT p.product_id, oov2p.value_id, oov2p.option_id, oov2p.slide_value_min, oov2p.slide_value_max, p.manufacturer_id, p.quantity, p.stock_status_id
FROM oc_product p
LEFT JOIN oc_ocfilter_option_value_to_product oov2p ON (oov2p.product_id = p.product_id)
LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p.date_available <= '2021-07-29' AND p2c.category_id = '50'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:388
18 (0.207)
SELECT oov.keyword
FROM oc_ocfilter_option_value oov
WHERE ( oov.option_id = 5 AND oov.value_id IN (169,175))
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:291
19 (12.388)
SELECT DISTINCT pov.product_id
FROM oc_product_option_value pov
WHERE pov.option_value_id IN (SELECT ovd.option_value_id
FROM oc_option_value_description ovd
WHERE ovd.name LIKE 's' OR ovd.name LIKE 'xs-s' ) AND pov.product_id IN (4849,8607,7924,8493,7870,8037,4204,7865,2702,8021,7883,7925,2756,8610,3043,3039,2697,8277,8094,2010,8452,1875,4373,7666,7939,4058,1972,3120,4414,5111,4857,3036,7965,2357,8503,7902,8044,1295,7459,2034,4529,7974,8373,8039,4497,4905,8014,4544,8279,7620,5417,8291,8327,8117,4066,2882,2684,2594,2970,2149,8207,1070,8298,7619,2982,8437,2974,8438,5070,3058,4542,5112,3105,1308,8335,4427,5617,8341,4436,4443,3608,8002,7923,4195,2868,8266,7922,7550,5108,2796,8349,1615,1622,8331,3088,4861,7532,8267,7537,5092,8501,2086,6412,8578,2923,8604,2275,2084,4348,8440,8297,4294,4346,4449,3055,8573,6583,8571,5067,8443,7860,8512,8079,8432,4937,4302,8601,4253,4455,8244,7942,4914,4303,4061,8288,8112,8595,8013,2108,8606,4329,7735,2867,4386,6413,915,3509,8308,3040,8184,7976,8453,7932,8346,8603,8140,7827,4370,8318,8068,8325,8146,5003,2927,8344,4273,2191,8281,4434,4650,8589,2375,3078,3511,1215,5017,2407,8119,2359,2412,4521,8339,7911,7525,5140,4620,2311,4859,2800,5647,7637,2765,7864,8342,8334,7825,6604,8579,4298,8042,4010,7995,2766,8599,5069,3143,8254,8322,6714,8324,8284,3943,1209,3158,1971,8323,7473,8147,4238,4622,4491,5415,8317,6404,8511,4317,8057,2083,8059,1664,4431,1379,2155,8340,3532,5637,8049,8583,8287,3118,4537,4451,6378,4533,4089,4804,8216,4064,4075,8139,3138,8591,5610,8097,7994,2213,8600,4448,8336,4223,6603,8411,8332,4445,4384,7445,4389,4543,4380,1227,7510,8326,8405,4474,7645,8319,2845,8506,4278,4447,3642,7627,5127,2663,4621,2181,8285,4330,7910,8596,5002,4328,2387,7962,4513,3398,8302,8242,4252,3649,6410,2698,6713,3456,1693,4710,4388,8058,8022,4707,7879,7527,2427,5096,1253,4869,1417,4809,7376,4088,2794,5623,4535,4366,4855,5603,8289,5413,7968,2534,4893,2797,8051,8602,8121,5104,4807,4538,4539,4545,4819,2114,1090,8587,8123,4920,3027,8394,7867,3077,8137,8345,5611,929,3417,3530,2570,7921,4646,8300,2488,2799,5075,8153,4800,4801,4802,8519,4858,8400,4205,3373,4619,8311,4838,4608,8290,3376,6382,4227,3038,3616,5628,8301,7623,8073,6712,7857,4798,2762,8372,8572,7815,1191,4315,4341,1325,6403,4435,4258,6507,8108,4712,7514,2491,7891,5115,4949,8175,7664,8431,2733,8436,8581,4385,7919,7903,6691,6409,4285,2485,6421,4347,8142,7999,4725,4295,8473,2866,2224,4374,5645,4655,8434,3071,7935,4392,8356,4897,8035,8133,6637,7978,3568,4502,4074,6611,2458,4581,5422,7853,4423,6411,7861,4287,8009,8408,7852,8078,5638,2411,5062,5107,2981,4416,4260,4742,5414,3031,8024,5106,4077,8032,7822,5655,4299,6408,3507,5644,7540,4479,6716,7667,946,8252,7953,6372,6746,5121,5064,4331,8605,8132,8282,8131,2654,8018,8253,4439,5619,5420,5036,1362,8063,8513,8337,8609,4393,8315,8265,2964,2746,6598,8124,8086,7446,8092,8471,2577,4704,2836,8593,7614,8085,4425,2544,4843,8067,8209,7739,1998,8352,3037,8296,5058,2123,5412,1198,7959,8509,7526,8307,4359,6392,8439,8194,3420,4301,8080,6353,8313,4417,4322,6627,7955,7947,2454,8351,7975,8359,8362,8364,5072,8367,8361,8368,7901,8357,8360,8370,8371,8374,7998,8380,8381,8382,8384,8388,8390,8391,6397,8397,8392,8399,8401,8075,8416,8413,8412,8414,8417,8415,8422,8423,8424,8425,8428,8429,8430,8435,6614,8447,1067,8446,8444,8442,7437,3095,6526,7957,8389,8608,8611,4073,2030,8150,6498,8149,8076,8445,8107) AND pov.quantity > '0'
ORDER BY pov.product_id ASC
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:260
20 (4.080)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '50' AND p.product_id IN (7870,7865,3043,3039,2697,7939,4058,1972,4414,3036,4529,8039,4905,8014,4544,8327,2594,8207,7619,2982,5070,3058,4542,3105,8341,8002,2868,5108,6412,8440,7860,8432,4937,8112,8013,6413,7976,7932,7827,8325,4521,5647,7864,7825,6604,7995,5069,1971,7473,6404,8057,1379,8049,4804,5610,7994,8411,8332,7445,4543,4380,7510,8319,3642,7627,8285,5002,7962,3398,4710,8058,8022,7879,5096,4869,1417,4809,7376,5623,5603,5413,7968,2797,8121,4807,5611,4205,7623,8073,4798,8372,7815,4315,8108,7891,8431,2733,6691,6409,2224,5645,4074,2458,6411,4287,8009,7852,5107,4416,5414,3031,8032,7822,5644,4479,7667,6746,5121,8282,4439,5619,5420,8337,6598,8086,7446,2836,2544,4843,1998,5412,8439,3420,6627,7947,2454,7901,8415,8428,7437,7957,6498,8107) AND p.product_id IN (7870,7865,3043,3039,2697,7939,4058,1972,4414,3036,4529,8039,4905,8014,4544,8327,2594,8207,7619,2982,5070,3058,4542,3105,8341,8002,2868,5108,6412,8440,7860,8432,4937,8112,8013,6413,7976,7932,7827,8325,4521,5647,7864,7825,6604,7995,5069,1971,7473,6404,8057,1379,8049,4804,5610,7994,8411,8332,7445,4543,4380,7510,8319,3642,7627,8285,5002,7962,3398,4710,8058,8022,7879,5096,4869,1417,4809,7376,5623,5603,5413,7968,2797,8121,4807,5611,4205,7623,8073,4798,8372,7815,4315,8108,7891,8431,2733,6691,6409,2224,5645,4074,2458,6411,4287,8009,7852,5107,4416,5414,3031,8032,7822,5644,4479,7667,6746,5121,8282,4439,5619,5420,8337,6598,8086,7446,2836,2544,4843,1998,5412,8439,3420,6627,7947,2454,7901,8415,8428,7437,7957,6498,8107) AND p.product_id IN (7870,7865,3043,3039,2697,7939,4058,1972,4414,3036,4529,8039,4905,8014,4544,8327,2594,8207,7619,2982,5070,3058,4542,3105,8341,8002,2868,5108,6412,8440,7860,8432,4937,8112,8013,6413,7976,7932,7827,8325,4521,5647,7864,7825,6604,7995,5069,1971,7473,6404,8057,1379,8049,4804,5610,7994,8411,8332,7445,4543,4380,7510,8319,3642,7627,8285,5002,7962,3398,4710,8058,8022,7879,5096,4869,1417,4809,7376,5623,5603,5413,7968,2797,8121,4807,5611,4205,7623,8073,4798,8372,7815,4315,8108,7891,8431,2733,6691,6409,2224,5645,4074,2458,6411,4287,8009,7852,5107,4416,5414,3031,8032,7822,5644,4479,7667,6746,5121,8282,4439,5619,5420,8337,6598,8086,7446,2836,2544,4843,1998,5412,8439,3420,6627,7947,2454,7901,8415,8428,7437,7957,6498,8107)
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:704
21 (14.803)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY IF(p.quantity > 0, 0, 1), pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY IF(p.quantity > 0, 0, 1), ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '50' AND p.product_id IN (7870,7865,3043,3039,2697,7939,4058,1972,4414,3036,4529,8039,4905,8014,4544,8327,2594,8207,7619,2982,5070,3058,4542,3105,8341,8002,2868,5108,6412,8440,7860,8432,4937,8112,8013,6413,7976,7932,7827,8325,4521,5647,7864,7825,6604,7995,5069,1971,7473,6404,8057,1379,8049,4804,5610,7994,8411,8332,7445,4543,4380,7510,8319,3642,7627,8285,5002,7962,3398,4710,8058,8022,7879,5096,4869,1417,4809,7376,5623,5603,5413,7968,2797,8121,4807,5611,4205,7623,8073,4798,8372,7815,4315,8108,7891,8431,2733,6691,6409,2224,5645,4074,2458,6411,4287,8009,7852,5107,4416,5414,3031,8032,7822,5644,4479,7667,6746,5121,8282,4439,5619,5420,8337,6598,8086,7446,2836,2544,4843,1998,5412,8439,3420,6627,7947,2454,7901,8415,8428,7437,7957,6498,8107) AND p.product_id IN (7870,7865,3043,3039,2697,7939,4058,1972,4414,3036,4529,8039,4905,8014,4544,8327,2594,8207,7619,2982,5070,3058,4542,3105,8341,8002,2868,5108,6412,8440,7860,8432,4937,8112,8013,6413,7976,7932,7827,8325,4521,5647,7864,7825,6604,7995,5069,1971,7473,6404,8057,1379,8049,4804,5610,7994,8411,8332,7445,4543,4380,7510,8319,3642,7627,8285,5002,7962,3398,4710,8058,8022,7879,5096,4869,1417,4809,7376,5623,5603,5413,7968,2797,8121,4807,5611,4205,7623,8073,4798,8372,7815,4315,8108,7891,8431,2733,6691,6409,2224,5645,4074,2458,6411,4287,8009,7852,5107,4416,5414,3031,8032,7822,5644,4479,7667,6746,5121,8282,4439,5619,5420,8337,6598,8086,7446,2836,2544,4843,1998,5412,8439,3420,6627,7947,2454,7901,8415,8428,7437,7957,6498,8107) AND p.product_id IN (7870,7865,3043,3039,2697,7939,4058,1972,4414,3036,4529,8039,4905,8014,4544,8327,2594,8207,7619,2982,5070,3058,4542,3105,8341,8002,2868,5108,6412,8440,7860,8432,4937,8112,8013,6413,7976,7932,7827,8325,4521,5647,7864,7825,6604,7995,5069,1971,7473,6404,8057,1379,8049,4804,5610,7994,8411,8332,7445,4543,4380,7510,8319,3642,7627,8285,5002,7962,3398,4710,8058,8022,7879,5096,4869,1417,4809,7376,5623,5603,5413,7968,2797,8121,4807,5611,4205,7623,8073,4798,8372,7815,4315,8108,7891,8431,2733,6691,6409,2224,5645,4074,2458,6411,4287,8009,7852,5107,4416,5414,3031,8032,7822,5644,4479,7667,6746,5121,8282,4439,5619,5420,8337,6598,8086,7446,2836,2544,4843,1998,5412,8439,3420,6627,7947,2454,7901,8415,8428,7437,7957,6498,8107) AND p.product_id <> '71' GROUP BY p.product_id
ORDER BY IF(p.quantity > 0, 0, 1), p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,12
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:340
22 (1.413)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8121' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
23 (0.941)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8337' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
24 (0.944)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8372' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
25 (0.959)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3420' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
26 (0.935)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8411' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
27 (0.975)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8428' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
28 (0.899)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8285' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
29 (1.000)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8439' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
30 (0.971)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8440' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
31 (0.808)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8431' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
32 (0.699)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8432' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
33 (0.705)
SELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name
FROM oc_manufacturer_description md
WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7437' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:34
34 (0.076)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8121'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
35 (0.087)
SELECT *
FROM oc_product_image
WHERE product_id = '8121'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
36 (0.076)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8121'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
37 (0.089)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8121' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
38 (0.089)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8337'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
39 (0.143)
SELECT *
FROM oc_product_image
WHERE product_id = '8337'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
40 (0.096)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8337'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
41 (0.071)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8337' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
42 (0.085)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8372'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
43 (0.103)
SELECT *
FROM oc_product_image
WHERE product_id = '8372'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
44 (0.084)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8372'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
45 (0.077)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8372' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
46 (0.088)
SELECT *
FROM oc_product_to_category
WHERE product_id = '3420'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
47 (0.088)
SELECT *
FROM oc_product_image
WHERE product_id = '3420'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
48 (0.080)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '3420'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
49 (0.142)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '3420' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
50 (0.068)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8411'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
51 (0.083)
SELECT *
FROM oc_product_image
WHERE product_id = '8411'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
52 (0.063)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8411'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
53 (0.080)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8411' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
54 (0.082)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8428'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
55 (0.090)
SELECT *
FROM oc_product_image
WHERE product_id = '8428'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
56 (0.080)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8428'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
57 (0.073)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8428' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
58 (0.097)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8285'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
59 (0.087)
SELECT *
FROM oc_product_image
WHERE product_id = '8285'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
60 (0.082)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8285'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
61 (0.086)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8285' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
62 (0.101)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8439'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
63 (0.093)
SELECT *
FROM oc_product_image
WHERE product_id = '8439'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
64 (0.076)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8439'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
65 (0.079)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8439' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
66 (0.073)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8440'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
67 (0.094)
SELECT *
FROM oc_product_image
WHERE product_id = '8440'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
68 (0.062)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8440'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
69 (0.080)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8440' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
70 (0.088)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8431'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
71 (0.102)
SELECT *
FROM oc_product_image
WHERE product_id = '8431'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
72 (2.474)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8431'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
73 (0.086)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8431' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
74 (0.103)
SELECT *
FROM oc_product_to_category
WHERE product_id = '8432'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
75 (0.107)
SELECT *
FROM oc_product_image
WHERE product_id = '8432'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
76 (0.086)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '8432'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
77 (0.079)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '8432' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
78 (0.082)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7437'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:548
79 (0.096)
SELECT *
FROM oc_product_image
WHERE product_id = '7437'
ORDER BY sort_order ASC
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:520
80 (0.071)
SELECT *
FROM oc_gp_bundle
WHERE product_id = '7437'
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:5
81 (0.072)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '7437' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/onebyone/onebyone.com.ua/system/storage/modification/catalog/model/catalog/product.php:449
82 (0.086)
SELECT *
FROM oc_ocfilter_option oo
LEFT JOIN oc_ocfilter_option_description ood ON (oo.option_id = ood.option_id)
WHERE oo.option_id = '5' AND ood.language_id = '1'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:79
83 (0.091)
SELECT *
FROM oc_ocfilter_option_value oov
LEFT JOIN oc_ocfilter_option_value_description oovd ON (oov.value_id = oovd.value_id)
WHERE oov.value_id = '169' AND oovd.language_id = '1'
ORDER BY oov.sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:85
84 (0.074)
SELECT *
FROM oc_ocfilter_option_value oov
LEFT JOIN oc_ocfilter_option_value_description oovd ON (oov.value_id = oovd.value_id)
WHERE oov.value_id = '175' AND oovd.language_id = '1'
ORDER BY oov.sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:85
85 (0.109)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND category_id = '50' AND ocfilter_params = 'razmer:s,xs-s'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:599
86 (0.087)
SELECT *
FROM oc_ocfilter_option oo
LEFT JOIN oc_ocfilter_option_description ood ON (oo.option_id = ood.option_id)
WHERE oo.option_id = '5' AND ood.language_id = '1'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:79
87 (0.080)
SELECT *
FROM oc_ocfilter_option_value oov
LEFT JOIN oc_ocfilter_option_value_description oovd ON (oov.value_id = oovd.value_id)
WHERE oov.value_id = '169' AND oovd.language_id = '1'
ORDER BY oov.sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:85
88 (0.084)
SELECT *
FROM oc_ocfilter_option_value oov
LEFT JOIN oc_ocfilter_option_value_description oovd ON (oov.value_id = oovd.value_id)
WHERE oov.value_id = '175' AND oovd.language_id = '1'
ORDER BY oov.sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:85
89 (0.073)
SELECT *
FROM oc_ocfilter_page
WHERE status = '1' AND category_id = '50' AND ocfilter_params = 'razmer:s,xs-s'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:599
90 (0.068)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '50' AND store_id = '0'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:55
91 (0.077)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:4
92 (0.083)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:14
93 (0.428)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
94 (0.998)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'category'
/var/www/onebyone/onebyone.com.ua/catalog/model/setting/setting.php:6
95 (0.084)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '522' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
96 (0.098)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '47' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
97 (0.085)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '486' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
98 (0.238)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '40' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
99 (0.082)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '390' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
100 (0.075)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '391' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
101 (0.068)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '392' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
102 (0.090)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '393' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
103 (0.122)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '394' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
104 (0.167)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '397' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
105 (0.152)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '328' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
106 (0.089)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '490' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
107 (0.090)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '372' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
108 (0.077)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '121' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
109 (0.079)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
110 (0.087)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '41' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
111 (0.179)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '382' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
112 (0.061)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '495' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
113 (0.080)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '383' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
114 (0.054)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '384' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
115 (0.070)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '385' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
116 (0.060)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '386' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
117 (0.118)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '387' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
118 (0.071)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '388' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
119 (0.104)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '373' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
120 (0.058)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '38' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
121 (0.064)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '326' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
122 (0.096)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '389' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
123 (0.105)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '63' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
124 (0.060)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '376' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
125 (0.072)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '377' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
126 (0.105)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '494' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
127 (0.067)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '375' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
128 (0.104)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '374' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
129 (0.117)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '44' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
130 (0.089)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '371' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
131 (0.064)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '369' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
132 (0.127)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '364' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
133 (0.065)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '365' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
134 (0.069)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '366' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
135 (0.060)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '367' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
136 (0.066)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '120' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
137 (0.092)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '119' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
138 (0.185)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '46' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
139 (0.086)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '359' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
140 (0.074)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '362' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
141 (0.066)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '355' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
142 (0.115)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '352' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
143 (0.084)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '357' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
144 (0.069)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '356' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
145 (0.059)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '358' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
146 (0.054)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '351' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
147 (0.080)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '361' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
148 (0.060)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '363' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
149 (0.095)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '169' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
150 (0.068)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '427' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
151 (0.080)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '50' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
152 (7.733)
SELECT p.product_id, oov2p.value_id, oov2p.option_id, oov2p.slide_value_min, oov2p.slide_value_max, p.manufacturer_id, p.quantity, p.stock_status_id
FROM oc_product p
LEFT JOIN oc_ocfilter_option_value_to_product oov2p ON (oov2p.product_id = p.product_id)
LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p.date_available <= '2021-07-29' AND p2c.category_id = '50'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:388
153 (0.178)
SELECT oov.keyword
FROM oc_ocfilter_option_value oov
WHERE ( oov.option_id = 5 AND oov.value_id IN (169,175))
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:291
154 (0.259)
SELECT DISTINCT pov.product_id
FROM oc_product_option_value pov
WHERE pov.option_value_id IN (SELECT ovd.option_value_id
FROM oc_option_value_description ovd
WHERE ovd.name LIKE 's' OR ovd.name LIKE 'xs-s' ) AND pov.product_id IN (4849,8607,7924,8493,7870,8037,4204,7865,2702,8021,7883,7925,2756,8610,3043,3039,2697,8277,8094,2010,8452,1875,4373,7666,7939,4058,1972,3120,4414,5111,4857,3036,7965,2357,8503,7902,8044,1295,7459,2034,4529,7974,8373,8039,4497,4905,8014,4544,8279,7620,5417,8291,8327,8117,4066,2882,2684,2594,2970,2149,8207,1070,8298,7619,2982,8437,2974,8438,5070,3058,4542,5112,3105,1308,8335,4427,5617,8341,4436,4443,3608,8002,7923,4195,2868,8266,7922,7550,5108,2796,8349,1615,1622,8331,3088,4861,7532,8267,7537,5092,8501,2086,6412,8578,2923,8604,2275,2084,4348,8440,8297,4294,4346,4449,3055,8573,6583,8571,5067,8443,7860,8512,8079,8432,4937,4302,8601,4253,4455,8244,7942,4914,4303,4061,8288,8112,8595,8013,2108,8606,4329,7735,2867,4386,6413,915,3509,8308,3040,8184,7976,8453,7932,8346,8603,8140,7827,4370,8318,8068,8325,8146,5003,2927,8344,4273,2191,8281,4434,4650,8589,2375,3078,3511,1215,5017,2407,8119,2359,2412,4521,8339,7911,7525,5140,4620,2311,4859,2800,5647,7637,2765,7864,8342,8334,7825,6604,8579,4298,8042,4010,7995,2766,8599,5069,3143,8254,8322,6714,8324,8284,3943,1209,3158,1971,8323,7473,8147,4238,4622,4491,5415,8317,6404,8511,4317,8057,2083,8059,1664,4431,1379,2155,8340,3532,5637,8049,8583,8287,3118,4537,4451,6378,4533,4089,4804,8216,4064,4075,8139,3138,8591,5610,8097,7994,2213,8600,4448,8336,4223,6603,8411,8332,4445,4384,7445,4389,4543,4380,1227,7510,8326,8405,4474,7645,8319,2845,8506,4278,4447,3642,7627,5127,2663,4621,2181,8285,4330,7910,8596,5002,4328,2387,7962,4513,3398,8302,8242,4252,3649,6410,2698,6713,3456,1693,4710,4388,8058,8022,4707,7879,7527,2427,5096,1253,4869,1417,4809,7376,4088,2794,5623,4535,4366,4855,5603,8289,5413,7968,2534,4893,2797,8051,8602,8121,5104,4807,4538,4539,4545,4819,2114,1090,8587,8123,4920,3027,8394,7867,3077,8137,8345,5611,929,3417,3530,2570,7921,4646,8300,2488,2799,5075,8153,4800,4801,4802,8519,4858,8400,4205,3373,4619,8311,4838,4608,8290,3376,6382,4227,3038,3616,5628,8301,7623,8073,6712,7857,4798,2762,8372,8572,7815,1191,4315,4341,1325,6403,4435,4258,6507,8108,4712,7514,2491,7891,5115,4949,8175,7664,8431,2733,8436,8581,4385,7919,7903,6691,6409,4285,2485,6421,4347,8142,7999,4725,4295,8473,2866,2224,4374,5645,4655,8434,3071,7935,4392,8356,4897,8035,8133,6637,7978,3568,4502,4074,6611,2458,4581,5422,7853,4423,6411,7861,4287,8009,8408,7852,8078,5638,2411,5062,5107,2981,4416,4260,4742,5414,3031,8024,5106,4077,8032,7822,5655,4299,6408,3507,5644,7540,4479,6716,7667,946,8252,7953,6372,6746,5121,5064,4331,8605,8132,8282,8131,2654,8018,8253,4439,5619,5420,5036,1362,8063,8513,8337,8609,4393,8315,8265,2964,2746,6598,8124,8086,7446,8092,8471,2577,4704,2836,8593,7614,8085,4425,2544,4843,8067,8209,7739,1998,8352,3037,8296,5058,2123,5412,1198,7959,8509,7526,8307,4359,6392,8439,8194,3420,4301,8080,6353,8313,4417,4322,6627,7955,7947,2454,8351,7975,8359,8362,8364,5072,8367,8361,8368,7901,8357,8360,8370,8371,8374,7998,8380,8381,8382,8384,8388,8390,8391,6397,8397,8392,8399,8401,8075,8416,8413,8412,8414,8417,8415,8422,8423,8424,8425,8428,8429,8430,8435,6614,8447,1067,8446,8444,8442,7437,3095,6526,7957,8389,8608,8611,4073,2030,8150,6498,8149,8076,8445,8107) AND pov.quantity > '0'
ORDER BY pov.product_id ASC
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/ocfilter.php:260
155 (0.152)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '50' AND store_id = '0'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:55
156 (0.060)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:4
157 (0.051)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:14
158 (0.060)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '50' AND store_id = '0'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:55
159 (0.057)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:4
160 (0.056)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:14
161 (0.058)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '50' AND store_id = '0'
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:55
162 (0.060)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:4
163 (0.057)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/onebyone/onebyone.com.ua/catalog/model/design/layout.php:14
164 (0.263)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/information.php:10
165 (0.076)
SELECT setting
FROM oc_module
WHERE module_id = 39
/var/www/onebyone/onebyone.com.ua/catalog/model/blockrender/blockrender.php:7
166 (0.059)
SELECT setting
FROM oc_module
WHERE module_id = 34
/var/www/onebyone/onebyone.com.ua/catalog/model/blockrender/blockrender.php:7
167 (0.064)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/onebyone/onebyone.com.ua/catalog/model/extension/extension.php:4
168 (0.387)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
169 (0.079)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '47' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
170 (0.065)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '486' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
171 (0.113)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '328' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
172 (0.067)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '41' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
173 (0.096)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '44' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
174 (0.188)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '46' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
175 (0.251)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '50' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/onebyone/onebyone.com.ua/catalog/model/catalog/category.php:10
176 (1.734)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3f230b2f3e51d784df4e6690a89702ad'
/var/www/onebyone/onebyone.com.ua/system/library/cart.php:35
177 (0.369)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/onebyone/onebyone.com.ua/catalog/model/extension/extension.php:4
178 (0.140)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3f230b2f3e51d784df4e6690a89702ad'
/var/www/onebyone/onebyone.com.ua/system/library/cart.php:35
179 (0.102)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3f230b2f3e51d784df4e6690a89702ad'
/var/www/onebyone/onebyone.com.ua/system/library/cart.php:35
180 (0.103)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3f230b2f3e51d784df4e6690a89702ad'
/var/www/onebyone/onebyone.com.ua/system/library/cart.php:35
181 (0.115)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '3f230b2f3e51d784df4e6690a89702ad'
/var/www/onebyone/onebyone.com.ua/system/library/cart.php:35
182 (0.115)
SELECT setting
FROM oc_module
WHERE module_id = 32
/var/www/onebyone/onebyone.com.ua/catalog/model/blockrender/blockrender.php:7
183 (0.111)
SELECT setting
FROM oc_module
WHERE module_id = 33
/var/www/onebyone/onebyone.com.ua/catalog/model/blockrender/blockrender.php:7
184 (0.122)
SELECT setting
FROM oc_module
WHERE module_id = 34
/var/www/onebyone/onebyone.com.ua/catalog/model/blockrender/blockrender.php:7