SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000877s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000606s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000806s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000445s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000515s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000458s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000634s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000445s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000465s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000398s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000551s ]
SELECT *,`name` FROM `sys_category` WHERE ( `seller_id` = 5 AND `status` = 1 AND `pid` = 0 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000620s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` `g` LEFT JOIN `sys_brand` `b` ON `b`.`id`=`g`.`brand_id` WHERE ( `g`.`status` = '1' AND `g`.`seller_id` = '5' ) AND `b`.`status` = '1' [ RunTime:0.000485s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` WHERE ( `status` = 1 AND `seller_id` = 5 ) [ RunTime:0.000374s ]
SELECT `id`,`title`,`class_id`,`attr_id`,`thumb`,`seller_id`,`total_sales`,`moon_sales` FROM `sys_goods` WHERE ( `status` = 1 AND `seller_id` = 5 ) ORDER BY RAND() LIMIT 0,8 [ RunTime:0.000422s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000562s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1696 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000400s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000458s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` = 0 ) LIMIT 1 [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000485s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000336s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1696 ) LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1696 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000540s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000638s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '5' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307043 AND `endtime` >= 1794307043 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000603s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1696 ) LIMIT 1 [ RunTime:0.000413s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1696 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000453s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000570s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1696 AND `status` = 1 AND `starttime` <= 1794307043 AND `endtime` >= 1794307043 ) LIMIT 1 [ RunTime:0.000423s ]
SHOW FULL COLUMNS FROM `sys_seller` [ RunTime:0.000558s ]
SELECT `seller_id`,`seller_name`,`seller_logo`,`seller_desc`,`service_phone`,`service_time`,`is_self` FROM `sys_seller` WHERE ( `seller_id` = '5' ) LIMIT 1 [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `sys_seller_comment` [ RunTime:0.000445s ]
SELECT ROUND(AVG(service_score), 1) AS `service_score`,ROUND(AVG(logistics_score), 1) AS `logistics_score`,COUNT(*) AS `total` FROM `sys_seller_comment` WHERE `seller_id` = 5 LIMIT 1 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `sys_user_collect` [ RunTime:0.000416s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 5 ) [ RunTime:0.000363s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 5 AND `uid` = 0 ) [ RunTime:0.000339s ]
SHOW FULL COLUMNS FROM `sys_announcement` [ RunTime:0.000467s ]
SELECT `id`,`title`,`content`,`addtime` FROM `sys_announcement` WHERE ( `seller_id` = 5 AND `status` = 1 ) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000390s ]
SELECT * FROM `sys_coupon` WHERE ( `status` = 1 AND `seller_id` = '5' AND `type` = 1 AND `starttime` <= 1794307043 AND `endtime` >= 1794307043 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000451s ]