SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000394s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000182s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000288s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000129s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000266s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000119s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000290s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000141s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000089s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000209s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000123s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000207s ]
SELECT `id`,`name` FROM `sys_goods_class` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000116s ]
SHOW FULL COLUMNS FROM `sys_brand` [ RunTime:0.000228s ]
SELECT `id`,`name`,`logo`,`seller_id` FROM `sys_brand` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000145s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000323s ]
SELECT `id`,`pid`,`name`,`seller_id` FROM `sys_category` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000180s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000202s ]
SELECT `id`,`name`,`seller_id` FROM `sys_goods_attr` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000384s ]
SHOW FULL COLUMNS FROM `sys_goods_specs` [ RunTime:0.000244s ]
SELECT `c`.`id`,`c`.`pid`,`c`.`name`,`c`.`name_en`,`c`.`code`,`c`.`color`,`c`.`seller_id` FROM `sys_goods_specs` `c` INNER JOIN `sys_goods_specs` `p` ON `c`.`pid`=p.id AND p.status = 1 AND p.pid = 0 AND p.code = 'color' WHERE `c`.`status` = '1' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.003320s ]
SELECT `c`.`id`,`c`.`pid`,`c`.`name`,`c`.`name_en`,`c`.`code`,`c`.`seller_id` FROM `sys_goods_specs` `c` INNER JOIN `sys_goods_specs` `p` ON `c`.`pid`=p.id AND p.status = 1 AND p.pid = 0 AND p.code = 'size' WHERE `c`.`status` = '1' ORDER BY `c`.`sort` ASC,`c`.`id` ASC [ RunTime:0.002163s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000478s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` `g` WHERE ( `g`.`status` = '1' ) [ RunTime:0.000361s ]
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` WHERE ( `g`.`status` = '1' ) ORDER BY `g`.`seller_id` ASC,g.total_sales desc LIMIT 0,12 [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000307s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id` FROM `sys_goods_item` WHERE `goods_id` IN (256,512,768,1024,1280,1536,1,257,513,769,1025,1281) AND `price` > '0' [ RunTime:0.000546s ]
SELECT `name`,`id` FROM `sys_goods_attr` WHERE `id` IN (46,15,73,6,8,191,1,63) [ RunTime:0.000137s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000267s ]
SELECT goods_id, SUM(quantity) AS qty FROM `sys_order_item` WHERE `goods_id` IN (256,512,768,1024,1280,1536,1,257,513,769,1025,1281) GROUP BY `goods_id` [ RunTime:0.000175s ]
SELECT goods_id, SUM(quantity) AS qty FROM `sys_order_item` WHERE `goods_id` IN (256,512,768,1024,1280,1536,1,257,513,769,1025,1281) AND `addtime` BETWEEN '1777564800' AND '1780243199' GROUP BY `goods_id` [ RunTime:0.000153s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000230s ]
SELECT * FROM `sys_goods_low` WHERE `goods_id` IN (256,512,768,1024,1280,1536,1,257,513,769,1025,1281) AND ( `status` = 1 AND `starttime` <= 1779820540 AND `endtime` >= 1779820540 ) [ RunTime:0.000190s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000243s ]
SELECT * FROM `sys_coupon` WHERE `seller_id` = '1' AND ( `status` = 1 AND `type` = 1 AND `starttime` <= 1779820540 AND `endtime` >= 1779820540 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000211s ]