Лаки - страница 2 - страница 2

Messages Request Timeline Exceptions Database45

7.4.33513ms2MB

$_GET: []
$_POST: []
$_SESSION: array:17 [ "key_lang" => "ru" "key_lang_name" => "Рус" "key_lang_admin" => "ua" "currency" =...
$_COOKIE: []

45 statements were executed, 15 of which were duplicates, 30 unique. Show only duplicated435ms34.33KB

SELECT name,value FROM config4.11ms128B9300000000120c5035000000006daa887fdefault
SELECT tb.key,tb2.value FROM translate tb LEFT JOIN ru_translate tb2 ON tb.id=tb2.translate_id4.11ms128B41700000000120c5035000000006daa887fdefault
SELECT `to`, `type` FROM `redirects` WHERE `from`=? AND `from`!='' AND `to`!='' AND active='1'6.13ms1.04KB000000000120c5002000000006daa887fdefault
Params
0: eskaroshop.com.ua/catalog/laki-12/page/2
SELECT * FROM `currency` ORDER BY `id` ASC1.96ms648B200000000120c5002000000006daa887fdefault
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?3.1ms1000B100000000120c5004000000006daa887fdefault
Params
0: product
1:
SELECT * FROM `currency` WHERE `base`='1' 6.21ms648B100000000120c5004000000006daa887fdefault
SELECT id FROM `price_type` WHERE `default`='1'6.07ms64B100000000120c500e000000006daa887fdefault
SELECT MIN(price) AS price FROM `price`5.01ms840B100000000120c5004000000006daa887fdefault
Params
0: 1
SELECT MAX(price) AS price FROM `price`3.63ms840B100000000120c5004000000006daa887fdefault
Params
0: 1
SHOW TABLES LIKE 'ru_catalog'5.36ms96B100000000120c5038000000006daa887fdefault
SELECT * FROM `catalog` `tb` LEFT JOIN `ru_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active=? AND tb.url=? 8.07ms2.52KB100000000120c5038000000006daa887fdefault
Params
0: 1
1: laki-12
SELECT COLUMN_NAME as name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? 5.41ms1.02KB1500000000120c5038000000006daa887fdefault
Params
0: wgzfgqwt_main
1: catalog
SHOW TABLES LIKE 'ru_catalog'3.2ms96B100000000120c5038000000006daa887fdefault
SELECT * FROM `catalog` `tb` LEFT JOIN `ru_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active='1' GROUP BY tb.id ORDER BY tb.sort ASC, tb.id ASC, tb.id DESC 2.5ms1.52KB2100000000120c5038000000006daa887fdefault
SELECT `id`, `url` FROM `product_status`4.23ms128B200000000120c5038000000006daa887fdefault
SHOW TABLES LIKE 'ru_catalog'7.07ms96B100000000120c5038000000006daa887fdefault
SELECT * FROM `catalog` `tb` LEFT JOIN `ru_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active='1' AND tb.sub IS NULL GROUP BY tb.id ORDER BY tb.sort ASC, tb.id ASC, tb.id DESC 4.27ms1.52KB1200000000120c5038000000006daa887fdefault
SELECT GROUP_CONCAT(tb.id) FROM `catalog` tb WHERE tb.active = '1'3.49ms80B100000000120c5038000000006daa887fdefault
SELECT GROUP_CONCAT(tb.id) FROM `product` tb WHERE tb.active = '1'3.75ms80B100000000120c5038000000006daa887fdefault
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?3.04ms1000B100000000120c5038000000006daa887fdefault
Params
0: params
1:
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='12'4.81ms88B100000000120c5038000000006daa887fdefault
SELECT GROUP_CONCAT(DISTINCT product_id) FROM product_catalog WHERE catalog_id IN(12) 5.62ms96B100000000120c5038000000006daa887fdefault
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='12'4.55ms88B100000000120c5038000000006daa887fdefault
SELECT * FROM catalog LEFT JOIN ru_catalog ON ru_catalog.catalog_id = catalog.id WHERE catalog_id=?4.4ms2.41KB100000000120c501c000000006daa887fdefault
Params
0: 12
SELECT * FROM catalog LEFT JOIN ru_catalog ON ru_catalog.catalog_id = catalog.id WHERE catalog_id=?1.98ms2.41KB100000000120c501c000000006daa887fdefault
Params
0: 1
SELECT params.id FROM params LEFT JOIN params_catalog pc ON params.id = pc.params_id WHERE params.active = '1' AND pc.catalog_id IN (12) AND params.sub IS NULL7.94ms64B600000000120c501c000000006daa887fdefault
SELECT params.id FROM params LEFT JOIN params_product pp ON params.id = pp.params_id LEFT JOIN product ON product.id = pp.product_id LEFT JOIN product_catalog pc ON pc.product_id = product.id WHERE product.active='1' AND params.active='1' AND params.sub IN(1,8,12,15,19,28) AND pc.catalog_id IN (12) GROUP BY params.id27.45ms64B3000000000120c501c000000006daa887fdefault
SHOW TABLES LIKE 'ru_params'2.74ms96B100000000120c501c000000006daa887fdefault
SELECT tb.*, tb_lang.*, (SELECT GROUP_CONCAT(DISTINCT tb2.url) from params tb2 WHERE tb2.id IN (tb.id,0) ORDER BY tb.sort ASC) as filter_url FROM `params` `tb` LEFT JOIN `ru_params` tb_lang ON tb.id=tb_lang.params_id WHERE tb.active = '1' AND tb.id IN('3','5','6','7','9','10','11','13','14','16','17','18','20','21','24','25','26','27','29','30','32','33','35','52','54','233','235','487','488','637') 14.62ms1.19KB3000000000120c501c000000006daa887fdefault
SHOW TABLES LIKE 'ru_params'4.91ms96B100000000120c501c000000006daa887fdefault
SELECT tb.*, tb_lang.* FROM `params` `tb` LEFT JOIN `ru_params` tb_lang ON tb.id=tb_lang.params_id LEFT JOIN (SELECT * FROM params WHERE sub IS NOT NULL) tb2 ON tb2.sub = tb.id WHERE tb.sub IS NULL AND tb.active = '1' AND tb2.id IN ('3','5','6','7','9','10','11','13','14','16','17','18','20','21','24','25','26','27','29','30','32','33','35','52','54','233','235','487','488','637') GROUP BY tb.id ORDER BY tb.sort ASC 6.14ms1.02KB600000000120c501c000000006daa887fdefault
SHOW TABLES LIKE 'ru_params'3.78ms96B100000000120c501c000000006daa887fdefault
SELECT tb.*, tb_lang.*, (SELECT GROUP_CONCAT(DISTINCT tb2.url) from params tb2 WHERE tb2.id IN (tb.id,'') ORDER BY tb.sort ASC) as filter_url FROM `params` `tb` LEFT JOIN `ru_params` tb_lang ON tb.id=tb_lang.params_id WHERE tb.active = '1' AND tb.id IN(0) 2.56ms1.19KB000000000120c501c000000006daa887fdefault
SHOW TABLES LIKE 'ru_params'2.79ms96B100000000120c501c000000006daa887fdefault
SELECT tb.*, tb_lang.* FROM `params` `tb` LEFT JOIN `ru_params` tb_lang ON tb.id=tb_lang.params_id LEFT JOIN (SELECT * FROM params WHERE sub IS NOT NULL) tb2 ON tb2.sub = tb.id WHERE tb.sub IS NULL AND tb.active = '1' AND tb2.id IN (0) GROUP BY tb.id ORDER BY tb.sort ASC 2.23ms1.02KB000000000120c501c000000006daa887fdefault
SHOW TABLES LIKE 'ru_product'4.78ms96B100000000120c501c000000006daa887fdefault
SELECT count(*) as count, min(pr.price * c.rate) as min, max(pr.price * c.rate) as max FROM `product` `tb` LEFT JOIN `ru_product` tb_lang ON tb.id=tb_lang.product_id LEFT JOIN price pr ON tb.id = pr.product_id LEFT JOIN currency c ON pr.currency_id = c.id WHERE tb.id IN('462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100'7.09ms192B100000000120c501c000000006daa887fdefault
SHOW TABLES LIKE 'ru_product'5.64ms96B100000000120c501c000000006daa887fdefault
SELECT tb.*, tb_lang.*, tb5.name as status, pr.id as price_id, pr.price, pr.code, pr.basePrice, pr.discount, pr.stock, pr.discount_end, pc.catalog_id as catalog_id, fv.user_id AS favorite, c.rate as currency_rate, pr.price * c.rate as price_sort FROM `product` `tb` LEFT JOIN `ru_product` tb_lang ON tb.id=tb_lang.product_id LEFT JOIN price pr ON tb.id = pr.product_id LEFT JOIN currency c ON pr.currency_id = c.id LEFT JOIN product_catalog pc ON pc.product_id = tb.id LEFT JOIN favorites fv ON fv.product_id = tb.id AND fv.user_id = 0 LEFT JOIN params_product pp ON pp.product_id = tb.id LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id LEFT JOIN product_status tb6 ON tb.id=tb4.status_id LEFT JOIN ru_product_status tb5 ON tb4.status_id=tb5.product_status_id WHERE tb.id IN('462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC77.49ms3.52KB6500000000120c506c000000006daa887fdefault
SELECT tb.*, tb_lang.*, tb5.name as status, pr.id as price_id, pr.price, pr.code, pr.basePrice, pr.discount, pr.stock, pr.discount_end, pc.catalog_id as catalog_id, fv.user_id AS favorite, c.rate as currency_rate, pr.price * c.rate as price_sort FROM `product` `tb` LEFT JOIN `ru_product` tb_lang ON tb.id=tb_lang.product_id LEFT JOIN price pr ON tb.id = pr.product_id LEFT JOIN currency c ON pr.currency_id = c.id LEFT JOIN product_catalog pc ON pc.product_id = tb.id LEFT JOIN favorites fv ON fv.product_id = tb.id AND fv.user_id = 0 LEFT JOIN params_product pp ON pp.product_id = tb.id LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id LEFT JOIN product_status tb6 ON tb.id=tb4.status_id LEFT JOIN ru_product_status tb5 ON tb4.status_id=tb5.product_status_id WHERE tb.id IN('462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC77.61ms2.27KB0default
SHOW TABLES LIKE 'ru_product'5.47ms96B100000000120c504a000000006daa887fdefault
SELECT tb.*, tb_lang.*, tb5.name as status, pr.id as price_id, pr.price, pr.code, pr.basePrice, pr.discount, pr.stock, pr.discount_end, pc.catalog_id as catalog_id, fv.user_id AS favorite, c.rate as currency_rate, pr.price * c.rate as price_sort FROM `product` `tb` LEFT JOIN `ru_product` tb_lang ON tb.id=tb_lang.product_id LEFT JOIN price pr ON tb.id = pr.product_id LEFT JOIN currency c ON pr.currency_id = c.id LEFT JOIN product_catalog pc ON pc.product_id = tb.id LEFT JOIN favorites fv ON fv.product_id = tb.id AND fv.user_id = 0 LEFT JOIN params_product pp ON pp.product_id = tb.id LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id LEFT JOIN product_status tb6 ON tb.id=tb4.status_id LEFT JOIN ru_product_status tb5 ON tb4.status_id=tb5.product_status_id WHERE tb.id IN('462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC LIMIT 30,3049.99ms3.52KB3000000000120c504a000000006daa887fdefault
SHOW TABLES LIKE 'ru_params'6.67ms96B100000000120c506c000000006daa887fdefault
SELECT GROUP_CONCAT(tb3.price_id) as concat_prices,tb_lang.name, tb.id as id, tb2_lang.name as parent_name, tb3.product_id, tb3.price_id as price_id, tb3.params_sub as sub FROM `params` `tb` LEFT JOIN `ru_params` tb_lang ON tb.id=tb_lang.params_id LEFT JOIN params_price tb3 ON tb3.params_id = tb.id LEFT JOIN ru_params tb2_lang ON tb3.params_sub = tb2_lang.params_id WHERE tb.id IN ( SELECT params_id FROM params_price ) AND tb3.product_id IN('499','498','497','496','495','494','493','491','490','489','488','487','486','483','482','481','480','479','478','477','476','475','474','473','472','471','470','469','468','467') GROUP BY tb.id, tb3.product_id7.82ms480B000000000120c506c000000006daa887fdefault
SELECT * FROM currency ORDER BY id ASC5.22ms648B200000000120c506c000000006daa887fdefault

↑