SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000387s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000178s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000205s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000107s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000218s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000083s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000205s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000124s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000077s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000159s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000088s ]
SHOW FULL COLUMNS FROM `sys_article` [ RunTime:0.000198s ]
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.000107s ]
SHOW FULL COLUMNS FROM `sys_case` [ RunTime:0.000172s ]
SELECT `id`,`title`,`content`,`addtime`,`tags`,`subtitle`,`cover` FROM `sys_case` WHERE ( `is_recommend` = 1 ) ORDER BY `updatetime` DESC LIMIT 3 [ RunTime:0.000089s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000178s ]
SELECT * FROM `sys_ad` WHERE ( `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC [ RunTime:0.000132s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000274s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` WHERE ( `status` = 1 ) [ RunTime:0.000279s ]
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.001380s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000319s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1111 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000174s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1111 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000081s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000164s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000054s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000135s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 8 ) LIMIT 1 [ RunTime:0.000074s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1111 ) LIMIT 1 [ RunTime:0.000075s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000209s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000171s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000180s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1111 ) LIMIT 1 [ RunTime:0.000072s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1111 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000082s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000156s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1111 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000131s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 297 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000096s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 297 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000081s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000141s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 8 ) LIMIT 1 [ RunTime:0.000107s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 297 ) LIMIT 1 [ RunTime:0.000114s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000191s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 297 ) LIMIT 1 [ RunTime:0.000083s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 297 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000082s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 297 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000124s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1600 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000110s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000054s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 288 ) LIMIT 1 [ RunTime:0.000058s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1600 ) LIMIT 1 [ RunTime:0.000080s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000164s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1600 ) LIMIT 1 [ RunTime:0.000098s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1600 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000081s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1600 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000105s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1525 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000099s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000049s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 9 ) LIMIT 1 [ RunTime:0.000056s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1525 ) LIMIT 1 [ RunTime:0.000072s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000176s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1525 ) LIMIT 1 [ RunTime:0.000084s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1525 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000081s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1525 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000098s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1103 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000097s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1103 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000099s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000054s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 8 ) LIMIT 1 [ RunTime:0.000058s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1103 ) LIMIT 1 [ RunTime:0.000082s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000163s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1103 ) LIMIT 1 [ RunTime:0.000074s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1103 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000091s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1103 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000113s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 400 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000126s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 400 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000084s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000049s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 52 ) LIMIT 1 [ RunTime:0.000059s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 400 ) LIMIT 1 [ RunTime:0.000070s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000180s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 400 ) LIMIT 1 [ RunTime:0.000097s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 400 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000081s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 400 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000100s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 706 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000112s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 706 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000107s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000054s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 72 ) LIMIT 1 [ RunTime:0.000059s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 706 ) LIMIT 1 [ RunTime:0.000084s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000161s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 706 ) LIMIT 1 [ RunTime:0.000073s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 706 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000076s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 706 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000111s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1650 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000113s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1650 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000080s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000049s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 1 ) LIMIT 1 [ RunTime:0.000056s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1650 ) LIMIT 1 [ RunTime:0.000069s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000184s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1650 ) LIMIT 1 [ RunTime:0.000092s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1650 AND `addtime` BETWEEN '1777564800' AND '1780243199' ) LIMIT 1 [ RunTime:0.000087s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1650 AND `status` = 1 AND `starttime` <= 1779820848 AND `endtime` >= 1779820848 ) LIMIT 1 [ RunTime:0.000099s ]
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` <= '1779820848' AND `gl`.`endtime` >= '1779820848' ) LIMIT 8 [ RunTime:0.000180s ]
