SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000386s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000179s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000200s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000100s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000195s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000089s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000175s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000110s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000073s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000157s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000088s ]
SHOW FULL COLUMNS FROM `sys_article` [ RunTime:0.000195s ]
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.000108s ]
SHOW FULL COLUMNS FROM `sys_case` [ RunTime:0.000168s ]
SELECT `id`,`title`,`content`,`addtime`,`tags`,`subtitle`,`cover` FROM `sys_case` WHERE ( `is_recommend` = 1 ) ORDER BY `updatetime` DESC LIMIT 3 [ RunTime:0.000093s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000178s ]
SELECT * FROM `sys_ad` WHERE ( `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC [ RunTime:0.000143s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000261s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` WHERE ( `status` = 1 ) [ RunTime:0.000297s ]
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.001306s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000299s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1313 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000202s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000155s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000056s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000133s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 288 ) LIMIT 1 [ RunTime:0.000068s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1313 ) LIMIT 1 [ RunTime:0.000097s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000225s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000175s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000183s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1313 ) LIMIT 1 [ RunTime:0.000078s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1313 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000077s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000172s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1313 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000106s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1254 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000089s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1254 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000068s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000050s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 93 ) LIMIT 1 [ RunTime:0.000055s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1254 ) LIMIT 1 [ RunTime:0.000084s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000152s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1254 ) LIMIT 1 [ RunTime:0.000064s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1254 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000066s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1254 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000087s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1657 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000077s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1657 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000064s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000051s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 14 ) LIMIT 1 [ RunTime:0.000056s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1657 ) LIMIT 1 [ RunTime:0.000078s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000125s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1657 ) LIMIT 1 [ RunTime:0.000061s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1657 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000064s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1657 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000084s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1693 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000077s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000048s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 14 ) LIMIT 1 [ RunTime:0.000062s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1693 ) LIMIT 1 [ RunTime:0.000066s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000144s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1693 ) LIMIT 1 [ RunTime:0.000063s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1693 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000064s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1693 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000101s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 413 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000457s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000053s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 10 ) LIMIT 1 [ RunTime:0.000056s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 413 ) LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000131s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 413 ) LIMIT 1 [ RunTime:0.000061s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 413 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000064s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 413 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000083s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 305 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000074s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 305 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000083s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000048s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 8 ) LIMIT 1 [ RunTime:0.000064s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 305 ) LIMIT 1 [ RunTime:0.000065s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000120s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 305 ) LIMIT 1 [ RunTime:0.000059s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 305 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000063s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 305 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000079s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 104 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000122s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000059s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 14 ) LIMIT 1 [ RunTime:0.000059s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 104 ) LIMIT 1 [ RunTime:0.000096s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000115s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 104 ) LIMIT 1 [ RunTime:0.000061s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 104 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000062s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 104 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000084s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 504 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000102s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000052s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 15 ) LIMIT 1 [ RunTime:0.000054s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 504 ) LIMIT 1 [ RunTime:0.000077s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000113s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 504 ) LIMIT 1 [ RunTime:0.000059s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 504 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000079s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 504 AND `status` = 1 AND `starttime` <= 1779816991 AND `endtime` >= 1779816991 ) LIMIT 1 [ RunTime:0.000085s ]
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` <= '1779816991' AND `gl`.`endtime` >= '1779816991' ) LIMIT 8 [ RunTime:0.000178s ]
