Database Queries

Всего 31 запись.

Time	Duration	Type	Query

22:30:22.842	26.9 ms	SELECT	SELECT `ark_product`.* FROM `ark_product` LEFT JOIN `ark_product_price` ON `ark_product`.`id` = `ark_product_price`.`pid` LEFT JOIN `ark_seller` ON `ark_product`.`mid` = `ark_seller`.`mid` LEFT JOIN `ark_product_attr` ON `ark_product`.`id` = `ark_product_attr`.`pid` LEFT JOIN `ark_unit` ON `ark_product`.`unitid` = `ark_unit`.`id` WHERE (`ark_product`.`stationid`=5) AND (`ark_product`.`id`=11724) AND (`ark_product`.`language`='ru-RU') ORDER BY `moq`, `is_system` DESC, `id` [+] Explain
22:30:22.869	0.4 ms	SHOW	SHOW FULL COLUMNS FROM `ark_product`
22:30:22.869	0.2 ms	SELECT	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ark_product' AND kcu.table_name = 'ark_product' [+] Explain
22:30:22.870	0.9 ms	SELECT	SELECT * FROM `ark_product_price` WHERE `pid`=11724 ORDER BY `moq` [+] Explain
22:30:22.871	0.2 ms	SHOW	SHOW FULL COLUMNS FROM `ark_product_price`
22:30:22.871	0.2 ms	SELECT	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ark_product_price' AND kcu.table_name = 'ark_product_price' [+] Explain
22:30:22.871	2.5 ms	SELECT	SELECT * FROM `ark_seller` WHERE `mid`=488 [+] Explain
22:30:22.874	0.3 ms	SHOW	SHOW FULL COLUMNS FROM `ark_seller`
22:30:22.874	0.2 ms	SELECT	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ark_seller' AND kcu.table_name = 'ark_seller' [+] Explain
22:30:22.874	11.1 ms	SELECT	SELECT * FROM `ark_product_attr` WHERE `pid`=11724 ORDER BY `is_system` DESC, `id` [+] Explain
22:30:22.885	0.2 ms	SHOW	SHOW FULL COLUMNS FROM `ark_product_attr`
22:30:22.886	0.1 ms	SELECT	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ark_product_attr' AND kcu.table_name = 'ark_product_attr' [+] Explain
22:30:22.886	0.1 ms	SELECT	SELECT * FROM `ark_unit` WHERE `id`=25 [+] Explain
22:30:22.886	0.1 ms	SHOW	SHOW FULL COLUMNS FROM `ark_unit`
22:30:22.886	0.2 ms	SELECT	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ark_unit' AND kcu.table_name = 'ark_unit' [+] Explain
22:30:22.887	2.0 ms	UPDATE	UPDATE `ark_product` SET `hits`=`hits`+1 WHERE `id`=11724 [+] Explain
22:30:22.889	0.1 ms	SELECT	SELECT `id`, `class_name_zh_CN`, `class_name_en_US`, `class_name_ru_RU`, `parent_id` FROM `ark_category` WHERE `id`=746 [+] Explain
22:30:22.889	0.1 ms	SELECT	SELECT `id`, `class_name_zh_CN`, `class_name_en_US`, `class_name_ru_RU`, `parent_id` FROM `ark_category` WHERE `id`='700' [+] Explain
22:30:22.889	10.7 ms	SELECT	SELECT `id`, `title`, `titlepic` FROM `ark_product` WHERE (`stationid`=5) AND (`cateid`=746) AND (`language`='ru-RU') AND (`status`=1) LIMIT 5 [+] Explain
22:30:22.900	20.4 ms	SELECT	SELECT `id`, `title`, `titlepic` FROM `ark_product` WHERE (`stationid`=5) AND (`mid`=488) AND (`language`='ru-RU') AND (`status`=1) LIMIT 6 [+] Explain
22:30:22.921	0.2 ms	SELECT	SELECT * FROM `ark_category` WHERE `id`=746 [+] Explain
22:30:22.921	1.3 ms	SELECT	SELECT `class_name_ru_RU`, `id` FROM `ark_category` WHERE (`parent_id`='700') AND (`id` != 746) ORDER BY `id` LIMIT 8 [+] Explain
22:30:22.922	0.1 ms	SELECT	SELECT `class_name_ru_RU` FROM `ark_category` WHERE `id`='700' [+] Explain
22:30:22.924	0.1 ms	SELECT	SELECT * FROM `ark_location` WHERE `id`=7 [+] Explain
22:30:22.924	0.2 ms	SHOW	SHOW FULL COLUMNS FROM `ark_location`
22:30:22.925	0.2 ms	SELECT	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'ark_location' AND kcu.table_name = 'ark_location' [+] Explain
22:30:22.925	0.1 ms	SELECT	SELECT * FROM `ark_location` WHERE `id`=261 [+] Explain
22:30:22.925	0.1 ms	SELECT	SELECT * FROM `ark_location` WHERE `id`=3203 [+] Explain
22:30:22.930	0.3 ms	SELECT	SELECT `class_name_ru_RU`, `id` FROM `ark_category` WHERE (`parent_id`=0) AND (`stationid`=5) ORDER BY `id` [+] Explain
22:30:22.931	0.1 ms	SELECT	SELECT `id`, `specialname` FROM `ark_special` WHERE (`stationid`=5) AND (`language`='ru-RU') ORDER BY `id` [+] Explain
22:30:22.931	0.2 ms	SELECT	SELECT `id`, `title_ru` FROM `ark_chain` WHERE `stationid`=5 ORDER BY `displayorder`, `createtime` [+] Explain

[+] Explain all