SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000684s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000497s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000600s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000557s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000548s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000396s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000445s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000544s ]
SELECT *,`name` FROM `sys_category` WHERE ( `seller_id` = 1 AND `status` = 1 AND `pid` = 0 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000655s ]
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` = '1' ) AND `b`.`status` = '1' [ RunTime:0.001171s ]
SELECT `g`.`goods_sn`,`g`.`id`,`g`.`title`,`g`.`class_id`,`g`.`attr_id`,`g`.`brand_id`,`g`.`category_id`,`g`.`thumb`,`g`.`seller_id`,`g`.`total_sales`,`g`.`moon_sales` FROM `sys_goods` `g` LEFT JOIN `sys_brand` `b` ON `b`.`id`=`g`.`brand_id` WHERE ( `g`.`status` = '1' AND `g`.`seller_id` = '1' ) AND `b`.`status` = '1' ORDER BY `g`.`seller_id` ASC,g.total_sales desc,`g`.`id` ASC LIMIT 0,12 [ RunTime:0.001171s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000589s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` IN (1,2,3,4,5,6,7,8,9,10,11,12) AND `price` > '0' [ RunTime:0.008492s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000708s ]
SELECT `name`,`id` FROM `sys_goods_attr` WHERE `id` IN (1,2,3,4) [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000632s ]
SELECT goods_id, SUM(quantity) AS qty, SUM(CASE WHEN addtime BETWEEN 1793462400 AND 1796054399 THEN quantity ELSE 0 END) AS month_qty FROM `sys_order_item` WHERE `goods_id` IN (1,2,3,4,5,6,7,8,9,10,11,12) GROUP BY `goods_id` [ RunTime:0.000533s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000566s ]
SELECT * FROM `sys_goods_low` WHERE `goods_id` IN (1,2,3,4,5,6,7,8,9,10,11,12) AND ( `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000662s ]
SELECT * FROM `sys_coupon` WHERE `seller_id` = '1' AND ( `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `sys_user_coupon` [ RunTime:0.000565s ]
SELECT coupon_id, COUNT(*) AS cnt FROM `sys_user_coupon` WHERE `coupon_id` = 2 GROUP BY `coupon_id` [ RunTime:0.000425s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` WHERE ( `status` = 1 AND `seller_id` = 1 ) [ RunTime:0.000753s ]
SELECT `id`,`title`,`class_id`,`attr_id`,`thumb`,`seller_id`,`total_sales`,`moon_sales` FROM `sys_goods` WHERE ( `status` = 1 AND `seller_id` = 1 ) ORDER BY RAND() LIMIT 0,8 [ RunTime:0.001776s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 956 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000497s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 956 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000535s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000363s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 50 ) LIMIT 1 [ RunTime:0.000357s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 956 ) LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 956 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000552s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000372s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 956 ) LIMIT 1 [ RunTime:0.000404s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 956 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000412s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 956 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000426s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1300 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000463s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1300 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000402s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000369s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 173 ) LIMIT 1 [ RunTime:0.000380s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1300 ) LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1300 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000395s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000460s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000380s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1300 ) LIMIT 1 [ RunTime:0.000343s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1300 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000374s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1300 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000381s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 724 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000377s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 724 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000342s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000355s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 1 ) LIMIT 1 [ RunTime:0.000346s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 724 ) LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 724 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000413s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000442s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000403s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 724 ) LIMIT 1 [ RunTime:0.000345s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 724 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000372s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 724 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000372s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1464 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000363s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000376s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 13 ) LIMIT 1 [ RunTime:0.000338s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1464 ) LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1464 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000396s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000448s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000352s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1464 ) LIMIT 1 [ RunTime:0.000369s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1464 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1464 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000393s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 606 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000481s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 606 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000445s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000375s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 28 ) LIMIT 1 [ RunTime:0.000377s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 606 ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 606 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000516s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000557s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000409s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 606 ) LIMIT 1 [ RunTime:0.000402s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 606 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000435s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 606 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000432s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 1344 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000448s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000392s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 14 ) LIMIT 1 [ RunTime:0.000382s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 1344 ) LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 1344 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000493s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000527s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000425s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1344 ) LIMIT 1 [ RunTime:0.000396s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 1344 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 1344 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000435s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 397 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000455s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 397 AND `price` > '0' ) LIMIT 1 [ RunTime:0.000451s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000366s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 17 ) LIMIT 1 [ RunTime:0.000373s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 397 ) LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 397 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000526s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000552s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000430s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 397 ) LIMIT 1 [ RunTime:0.000396s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 397 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000442s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 397 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000446s ]
SELECT min(price) FROM `sys_goods_item` WHERE ( `goods_id` = 780 AND `price` > '0' AND `local_stock` > 0 ) LIMIT 1 [ RunTime:0.000445s ]
SELECT `name` FROM `sys_goods_class` WHERE ( `id` IS NULL ) LIMIT 1 [ RunTime:0.000362s ]
SELECT `name` FROM `sys_goods_attr` WHERE ( `id` = 8 ) LIMIT 1 [ RunTime:0.000374s ]
SELECT sum(local_stock) FROM `sys_goods_item` WHERE ( `goods_id` = 780 ) LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` = 780 AND `price` > '0' ORDER BY `local_stock` DESC,`price` ASC LIMIT 1 [ RunTime:0.000497s ]
SELECT * FROM `sys_coupon` WHERE ( `seller_id` = '1' AND `status` = 1 AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000517s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000407s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 780 ) LIMIT 1 [ RunTime:0.000404s ]
SELECT sum(quantity) FROM `sys_order_item` WHERE ( `goods_id` = 780 AND `addtime` BETWEEN '1793462400' AND '1796054399' ) LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `sys_goods_low` WHERE ( `goods_id` = 780 AND `status` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) LIMIT 1 [ RunTime:0.000440s ]
SHOW FULL COLUMNS FROM `sys_seller` [ RunTime:0.000698s ]
SELECT `seller_id`,`seller_name`,`seller_logo`,`seller_desc`,`service_phone`,`service_time`,`is_self` FROM `sys_seller` WHERE ( `seller_id` = '1' ) LIMIT 1 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `sys_seller_comment` [ RunTime:0.000581s ]
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` = 1 LIMIT 1 [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `sys_user_collect` [ RunTime:0.000561s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 1 ) [ RunTime:0.000430s ]
SELECT COUNT(*) AS think_count FROM `sys_user_collect` WHERE ( `type` = '3' AND `point_id` = 1 AND `uid` = 0 ) [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `sys_announcement` [ RunTime:0.000565s ]
SELECT `id`,`title`,`content`,`addtime` FROM `sys_announcement` WHERE ( `seller_id` = 1 AND `status` = 1 ) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000446s ]
SELECT `id`,`title`,`content`,`addtime` FROM `sys_announcement` WHERE ( `seller_id` = 0 AND `status` = 1 ) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000404s ]
SELECT * FROM `sys_coupon` WHERE ( `status` = 1 AND `seller_id` = '1' AND `type` = 1 AND `starttime` <= 1794307044 AND `endtime` >= 1794307044 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000502s ]
SELECT COUNT(*) AS think_count FROM `sys_user_coupon` WHERE ( `coupon_id` = 2 ) [ RunTime:0.000416s ]