SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000665s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000507s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000485s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000499s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000386s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000433s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000341s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000514s ]
SELECT *,`name` FROM `sys_category` WHERE ( `seller_id` = 4 AND `status` = 1 AND `pid` = 0 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000644s ]
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` = '4' ) AND `b`.`status` = '1' [ RunTime:0.000584s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` WHERE ( `status` = 1 AND `seller_id` = 4 ) [ RunTime:0.000482s ]
SELECT `id`,`title`,`class_id`,`attr_id`,`thumb`,`seller_id`,`total_sales`,`moon_sales` FROM `sys_goods` WHERE ( `status` = 1 AND `seller_id` = 4 ) ORDER BY RAND() LIMIT 0,8 [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000634s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1697 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000515s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` = 0 ) LIMIT 1 [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000523s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000363s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1697 ) LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1697 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000629s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '4' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307042 AND `endtime` >= 1794307042 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000593s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1697 ) LIMIT 1 [ RunTime:0.000414s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1697 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000528s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1697 AND `status` = 1 AND `starttime` <= 1794307042 AND `endtime` >= 1794307042 ) LIMIT 1 [ RunTime:0.000429s ]
SHOW FULL COLUMNS FROM `sys_seller` [ RunTime:0.000597s ]
SELECT `seller_id`,`seller_name`,`seller_logo`,`seller_desc`,`service_phone`,`service_time`,`is_self` FROM `sys_seller` WHERE ( `seller_id` = '4' ) LIMIT 1 [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `sys_seller_comment` [ RunTime:0.000552s ]
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` = 4 LIMIT 1 [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `sys_user_collect` [ RunTime:0.000493s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 4 ) [ RunTime:0.000398s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 4 AND `uid` = 0 ) [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `sys_announcement` [ RunTime:0.000597s ]
SELECT `id`,`title`,`content`,`addtime` FROM `sys_announcement` WHERE ( `seller_id` = 4 AND `status` = 1 ) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000413s ]
SELECT `id`,`title`,`content`,`addtime` FROM `sys_announcement` WHERE ( `seller_id` = 0 AND `status` = 1 ) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000372s ]
SELECT * FROM `sys_coupon` WHERE ( `status` = 1 AND `seller_id` = '4' AND `type` = 1 AND `starttime` <= 1794307042 AND `endtime` >= 1794307042 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000479s ]
