SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000740s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000655s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000550s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000707s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000326s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000539s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000223s ]
SHOW FULL COLUMNS FROM `sys_article` [ RunTime:0.000553s ]
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.000283s ]
SHOW FULL COLUMNS FROM `sys_case` [ RunTime:0.000717s ]
SELECT `id`,`title`,`content`,`addtime`,`tags`,`subtitle`,`cover` FROM `sys_case` WHERE ( `is_recommend` = 1 ) ORDER BY `updatetime` DESC LIMIT 3 [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000501s ]
SELECT * FROM `sys_ad` WHERE ( `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000693s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` WHERE ( `status` = 1 ) [ RunTime:0.000588s ]
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.002260s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000551s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1085 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000503s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000142s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000406s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 102 ) LIMIT 1 [ RunTime:0.000178s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1085 ) LIMIT 1 [ RunTime:0.000184s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1085 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000527s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000433s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1085 ) LIMIT 1 [ RunTime:0.000200s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1085 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000213s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000404s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1085 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000241s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 484 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000249s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000127s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 14 ) LIMIT 1 [ RunTime:0.000145s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 484 ) LIMIT 1 [ RunTime:0.000183s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 484 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000310s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000313s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 484 ) LIMIT 1 [ RunTime:0.000183s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 484 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000195s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 484 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000224s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1212 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000233s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1212 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000187s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000157s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 93 ) LIMIT 1 [ RunTime:0.000239s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1212 ) LIMIT 1 [ RunTime:0.000195s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1212 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000284s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000348s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1212 ) LIMIT 1 [ RunTime:0.000192s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1212 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000216s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1212 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000218s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1477 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000231s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1477 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000199s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000138s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 13 ) LIMIT 1 [ RunTime:0.000234s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1477 ) LIMIT 1 [ RunTime:0.000194s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1477 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000326s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1477 ) LIMIT 1 [ RunTime:0.000178s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1477 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000189s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1477 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000240s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 401 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000340s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000153s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 10 ) LIMIT 1 [ RunTime:0.000208s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 401 ) LIMIT 1 [ RunTime:0.000271s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 401 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000398s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000370s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 401 ) LIMIT 1 [ RunTime:0.000188s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 401 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000212s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 401 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000221s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 447 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000798s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000147s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 13 ) LIMIT 1 [ RunTime:0.000147s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 447 ) LIMIT 1 [ RunTime:0.000751s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 447 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000972s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000322s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 447 ) LIMIT 1 [ RunTime:0.000189s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 447 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000185s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 447 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000215s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 91 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000233s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000134s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 13 ) LIMIT 1 [ RunTime:0.000141s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 91 ) LIMIT 1 [ RunTime:0.000282s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 91 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` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000311s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 91 ) LIMIT 1 [ RunTime:0.000196s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 91 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000181s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 91 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000226s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1496 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000244s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1496 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000218s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000175s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 191 ) LIMIT 1 [ RunTime:0.000156s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1496 ) LIMIT 1 [ RunTime:0.000207s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1496 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000298s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000348s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1496 ) LIMIT 1 [ RunTime:0.000181s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1496 AND `addtime` BETWEEN '1790784000' AND '1793462399' ) LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1496 AND `status` = 1 AND `starttime` <= 1791348304 AND `endtime` >= 1791348304 ) LIMIT 1 [ RunTime:0.000218s ]
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` <= '1791348304' AND `gl`.`endtime` >= '1791348304' ) LIMIT 8 [ RunTime:0.000361s ]
