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

Messages Request Timeline Exceptions Database45

7.4.33265ms2MB

$_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 duplicated222ms34.33KB

SELECT name,value FROM config131μs128B93000000001b2012b800000000286f16addefault
SELECT tb.key,tb2.value FROM translate tb LEFT JOIN ru_translate tb2 ON tb.id=tb2.translate_id138μs128B405000000001b2012b800000000286f16addefault
SELECT `to`, `type` FROM `redirects` WHERE `from`=? AND `from`!='' AND `to`!='' AND active='1'480μs1.04KB0000000001b20128f00000000286f16addefault
Params
0: eskaroshop.com.ua/catalog/laki-12/page/2
SELECT * FROM `currency` ORDER BY `id` ASC3.33ms648B2000000001b20128f00000000286f16addefault
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?95μs1000B1000000001b20128900000000286f16addefault
Params
0: product
1:
SELECT * FROM `currency` WHERE `base`='1' 86μs648B1000000001b20128900000000286f16addefault
SELECT id FROM `price_type` WHERE `default`='1'13.78ms64B1000000001b20128300000000286f16addefault
SELECT MIN(price) AS price FROM `price`1.52ms840B1000000001b20128900000000286f16addefault
Params
0: 1
SELECT MAX(price) AS price FROM `price`85μs840B1000000001b20128900000000286f16addefault
Params
0: 1
SHOW TABLES LIKE 'ru_catalog'479μs96B1000000001b2012b500000000286f16addefault
SELECT * FROM `catalog` `tb` LEFT JOIN `ru_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active=? AND tb.url=? 1.09ms2.52KB1000000001b2012b500000000286f16addefault
Params
0: 1
1: laki-12
SELECT COLUMN_NAME as name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? 2.77ms1.02KB15000000001b2012b500000000286f16addefault
Params
0: wgzfgqwt_main
1: catalog
SHOW TABLES LIKE 'ru_catalog'332μs96B1000000001b2012b500000000286f16addefault
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.37ms1.52KB21000000001b2012b500000000286f16addefault
SELECT `id`, `url` FROM `product_status`72μs128B2000000001b2012b500000000286f16addefault
SHOW TABLES LIKE 'ru_catalog'312μs96B1000000001b2012b500000000286f16addefault
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 793μs1.52KB12000000001b2012b500000000286f16addefault
SELECT GROUP_CONCAT(tb.id) FROM `catalog` tb WHERE tb.active = '1'73μs80B1000000001b2012b500000000286f16addefault
SELECT GROUP_CONCAT(tb.id) FROM `product` tb WHERE tb.active = '1'58μs80B1000000001b2012b500000000286f16addefault
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?70μs1000B1000000001b2012b500000000286f16addefault
Params
0: params
1:
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='12'92μs88B1000000001b2012b500000000286f16addefault
SELECT GROUP_CONCAT(DISTINCT product_id) FROM product_catalog WHERE catalog_id IN(12) 71μs96B1000000001b2012b500000000286f16addefault
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='12'80μs88B1000000001b2012b500000000286f16addefault
SELECT * FROM catalog LEFT JOIN ru_catalog ON ru_catalog.catalog_id = catalog.id WHERE catalog_id=?299μs2.41KB1000000001b20129100000000286f16addefault
Params
0: 12
SELECT * FROM catalog LEFT JOIN ru_catalog ON ru_catalog.catalog_id = catalog.id WHERE catalog_id=?544μs2.41KB1000000001b20129100000000286f16addefault
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 NULL78μs64B6000000001b20129100000000286f16addefault
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.id91μs64B30000000001b20129100000000286f16addefault
SHOW TABLES LIKE 'ru_params'362μs96B1000000001b20129100000000286f16addefault
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') 11.72ms1.19KB30000000001b20129100000000286f16addefault
SHOW TABLES LIKE 'ru_params'1.45ms96B1000000001b20129100000000286f16addefault
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 1.31ms1.02KB6000000001b20129100000000286f16addefault
SHOW TABLES LIKE 'ru_params'1.76ms96B1000000001b20129100000000286f16addefault
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) 85μs1.19KB0000000001b20129100000000286f16addefault
SHOW TABLES LIKE 'ru_params'379μs96B1000000001b20129100000000286f16addefault
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 70μs1.02KB0000000001b20129100000000286f16addefault
SHOW TABLES LIKE 'ru_product'385μs96B1000000001b20129100000000286f16addefault
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'1.35ms192B1000000001b20129100000000286f16addefault
SHOW TABLES LIKE 'ru_product'447μs96B1000000001b20129100000000286f16addefault
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 DESC63.85ms3.52KB65000000001b2012e100000000286f16addefault
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 DESC63.95ms2.27KB0default
SHOW TABLES LIKE 'ru_product'597μs96B1000000001b2012c700000000286f16addefault
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,3038.19ms3.52KB30000000001b2012c700000000286f16addefault
SHOW TABLES LIKE 'ru_params'370μs96B1000000001b2012e100000000286f16addefault
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_id5.7ms480B0000000001b2012e100000000286f16addefault
SELECT * FROM currency ORDER BY id ASC599μs648B2000000001b2012e100000000286f16addefault

↑