SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000612s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000539s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000496s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000459s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000270s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000202s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000415s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `sys_article` [ RunTime:0.000430s ]
SELECT `id`,`title`,`content`,`addtime`,`tags`,`subtitle`,`cover`,`read_count` FROM `sys_article` WHERE ( `is_recommend` = 1 ) ORDER BY `updatetime` DESC LIMIT 4 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `sys_case` [ RunTime:0.000431s ]
SELECT `id`,`title`,`content`,`addtime`,`tags`,`subtitle`,`cover` FROM `sys_case` WHERE ( `is_recommend` = 1 ) ORDER BY `updatetime` DESC LIMIT 3 [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000567s ]
SELECT * FROM `sys_ad` WHERE ( `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000616s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` WHERE ( `status` = 1 ) [ RunTime:0.000599s ]
SELECT `id`,`title`,`class_id`,`attr_id`,`thumb`,`seller_id`,`total_sales`,`moon_sales` FROM `sys_goods` WHERE ( `status` = 1 ) ORDER BY RAND() LIMIT 0,8 [ RunTime:0.002341s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000555s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 597 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000273s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 597 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000515s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000143s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000421s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 15 ) LIMIT 1 [ RunTime:0.000232s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 597 ) LIMIT 1 [ RunTime:0.000226s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 597 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000591s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000458s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 597 ) LIMIT 1 [ RunTime:0.000179s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 597 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000373s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 597 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000278s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1382 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000229s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000130s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 28 ) LIMIT 1 [ RunTime:0.000156s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1382 ) LIMIT 1 [ RunTime:0.000292s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1382 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000282s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000352s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1382 ) LIMIT 1 [ RunTime:0.000187s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1382 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000195s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1382 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000231s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 138 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000267s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 138 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000299s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000180s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 5 ) LIMIT 1 [ RunTime:0.000178s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 138 ) LIMIT 1 [ RunTime:0.000210s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 138 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000296s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000343s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 138 ) LIMIT 1 [ RunTime:0.000196s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 138 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000220s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 138 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000224s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 896 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000285s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 896 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000216s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000141s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 14 ) LIMIT 1 [ RunTime:0.000160s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 896 ) LIMIT 1 [ RunTime:0.000193s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 896 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000321s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000317s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 896 ) LIMIT 1 [ RunTime:0.000176s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 896 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 896 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000236s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 222 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000220s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 222 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000188s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000124s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 37 ) LIMIT 1 [ RunTime:0.000142s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 222 ) LIMIT 1 [ RunTime:0.000166s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 222 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000295s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000323s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 222 ) LIMIT 1 [ RunTime:0.000178s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 222 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000170s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 222 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000231s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 794 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000289s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 794 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000205s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000140s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 1 ) LIMIT 1 [ RunTime:0.000149s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 794 ) LIMIT 1 [ RunTime:0.000181s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 794 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000249s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000414s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 794 ) LIMIT 1 [ RunTime:0.000239s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 794 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000214s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 794 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000231s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 111 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000320s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000145s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 15 ) LIMIT 1 [ RunTime:0.000232s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 111 ) LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 111 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000355s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 111 ) LIMIT 1 [ RunTime:0.000276s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 111 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000249s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 111 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000238s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 5 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.001187s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000151s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 3 ) LIMIT 1 [ RunTime:0.000207s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 5 ) LIMIT 1 [ RunTime:0.001071s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 5 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.001489s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000340s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 5 ) LIMIT 1 [ RunTime:0.000249s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 5 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000224s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 5 AND `status` = 1 AND `starttime` <= 1791351824 AND `endtime` >= 1791351824 ) LIMIT 1 [ RunTime:0.000272s ]
SELECT `g`.* FROM `sys_goods_low` `gl` LEFT JOIN `sys_goods` `g` ON `gl`.`goods_id`=`g`.`id` WHERE ( `gl`.`status` = '1' AND `gl`.`starttime` <= '1791351824' AND `gl`.`endtime` >= '1791351824' ) LIMIT 8 [ RunTime:0.000456s ]
