Профессиональные Инструменты: Надежность и Эффективность для Ваших Проектов

Messages Request Timeline Exceptions Database44

7.4.33112ms1MB

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

44 statements were executed, 15 of which were duplicates, 29 unique. Show only duplicated74.61ms31.67KB

SELECT name,value FROM config1.2ms128B930000000055a172f7000000001c5242d2default
SELECT tb.key,tb2.value FROM translate tb LEFT JOIN ru_translate tb2 ON tb.id=tb2.translate_id2.75ms128B4170000000055a172f7000000001c5242d2default
SELECT `to`, `type` FROM `redirects` WHERE `from`=? AND `from`!='' AND `to`!='' AND active='1'1.51ms1.04KB00000000055a172c0000000001c5242d2default
Params
0: eskaroshop.com.ua/catalog/instrumenti
SELECT * FROM `currency` ORDER BY `id` ASC1.33ms648B20000000055a172c0000000001c5242d2default
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?1.31ms1000B10000000055a172c6000000001c5242d2default
Params
0: product
1:
SELECT * FROM `currency` WHERE `base`='1' 1.25ms648B10000000055a172c6000000001c5242d2default
SELECT id FROM `price_type` WHERE `default`='1'1.29ms64B10000000055a172cc000000001c5242d2default
SELECT MIN(price) AS price FROM `price`1.39ms840B10000000055a172c6000000001c5242d2default
Params
0: 1
SELECT MAX(price) AS price FROM `price`1.22ms840B10000000055a172c6000000001c5242d2default
Params
0: 1
SHOW TABLES LIKE 'ru_catalog'1.32ms96B10000000055a172fa000000001c5242d2default
SELECT * FROM `catalog` `tb` LEFT JOIN `ru_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active=? AND tb.url=? 1.48ms2.52KB10000000055a172fa000000001c5242d2default
Params
0: 1
1: instrumenti
SELECT COLUMN_NAME as name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? 1.66ms1.02KB150000000055a172fa000000001c5242d2default
Params
0: wgzfgqwt_main
1: catalog
SHOW TABLES LIKE 'ru_catalog'1.2ms96B10000000055a172fa000000001c5242d2default
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 1.58ms1.52KB210000000055a172fa000000001c5242d2default
SELECT `id`, `url` FROM `product_status`1.06ms128B20000000055a172fa000000001c5242d2default
SHOW TABLES LIKE 'ru_catalog'1.41ms96B10000000055a172fa000000001c5242d2default
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 1.64ms1.52KB120000000055a172fa000000001c5242d2default
SELECT GROUP_CONCAT(tb.id) FROM `catalog` tb WHERE tb.active = '1'1.01ms80B10000000055a172fa000000001c5242d2default
SELECT GROUP_CONCAT(tb.id) FROM `product` tb WHERE tb.active = '1'1.32ms80B10000000055a172fa000000001c5242d2default
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?1.21ms1000B10000000055a172fa000000001c5242d2default
Params
0: params
1:
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='30'1.25ms88B10000000055a172fa000000001c5242d2default
SELECT GROUP_CONCAT(DISTINCT product_id) FROM product_catalog WHERE catalog_id IN(30) 1.14ms96B10000000055a172fa000000001c5242d2default
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='30'1.08ms88B10000000055a172fa000000001c5242d2default
SELECT * FROM catalog LEFT JOIN ru_catalog ON ru_catalog.catalog_id = catalog.id WHERE catalog_id=?1.09ms2.41KB10000000055a172de000000001c5242d2default
Params
0: 30
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 (30) AND params.sub IS NULL1.43ms64B80000000055a172de000000001c5242d2default
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,44,508) AND pc.catalog_id IN (30) GROUP BY params.id1.57ms64B250000000055a172de000000001c5242d2default
SHOW TABLES LIKE 'ru_params'1.21ms96B10000000055a172de000000001c5242d2default
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','4','13','14','16','17','18','24','25','26','32','33','40','43','229','230','695','703','704','705','706','708','709','710','711') 5.39ms1.19KB250000000055a172de000000001c5242d2default
SHOW TABLES LIKE 'ru_params'1.35ms96B10000000055a172de000000001c5242d2default
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','4','13','14','16','17','18','24','25','26','32','33','40','43','229','230','695','703','704','705','706','708','709','710','711') GROUP BY tb.id ORDER BY tb.sort ASC 1.8ms1.02KB50000000055a172de000000001c5242d2default
SHOW TABLES LIKE 'ru_params'1.23ms96B10000000055a172de000000001c5242d2default
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) 1.12ms1.19KB00000000055a172de000000001c5242d2default
SHOW TABLES LIKE 'ru_params'1.21ms96B10000000055a172de000000001c5242d2default
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 1.18ms1.02KB00000000055a172de000000001c5242d2default
SHOW TABLES LIKE 'ru_product'1.23ms96B10000000055a172de000000001c5242d2default
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('860','861','862','863','886','887','888','889','890','891','892','893','894','914','915','916','917') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100'1.42ms192B10000000055a172de000000001c5242d2default
SHOW TABLES LIKE 'ru_product'1.21ms96B10000000055a172de000000001c5242d2default
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('860','861','862','863','886','887','888','889','890','891','892','893','894','914','915','916','917') 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 DESC4.62ms3.52KB160000000055a172af000000001c5242d2default
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('860','861','862','863','886','887','888','889','890','891','892','893','894','914','915','916','917') 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 DESC4.64ms2.02KB0default
SHOW TABLES LIKE 'ru_product'1.22ms96B10000000055a172af000000001c5242d2default
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('860','861','862','863','886','887','888','889','890','891','892','893','894','914','915','916','917') 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 0,304.48ms3.52KB160000000055a172af000000001c5242d2default
SHOW TABLES LIKE 'ru_params'1.2ms96B10000000055a172af000000001c5242d2default
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('917','916','915','914','894','893','892','891','890','889','887','886','863','862','861','860') GROUP BY tb.id, tb3.product_id1.31ms480B00000000055a172af000000001c5242d2default
SELECT * FROM currency ORDER BY id ASC3.07ms648B20000000055a172af000000001c5242d2default

↑