SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000505s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000402s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000209s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000405s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000176s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000465s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000272s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000209s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000401s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000216s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.001167s ]
SELECT `id`,`name` FROM `sys_goods_class` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001545s ]
SHOW FULL COLUMNS FROM `sys_brand` [ RunTime:0.000525s ]
SELECT `id`,`name`,`logo`,`seller_id` FROM `sys_brand` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002670s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000594s ]
SELECT `id`,`pid`,`name`,`seller_id` FROM `sys_category` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002162s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000521s ]
SELECT `id`,`name`,`seller_id` FROM `sys_goods_attr` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002845s ]
SHOW FULL COLUMNS FROM `sys_goods_specs` [ RunTime:0.000603s ]
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.015567s ]
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.004975s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.001645s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` `g` WHERE ( `g`.`status` = '1' ) [ RunTime:0.004656s ]
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.006270s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.002329s ]
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.020362s ]
SELECT `name`,`id` FROM `sys_goods_attr` WHERE `id` IN (46,15,73,6,8,191,1,63) [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000645s ]
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.002560s ]
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 '1780243200' AND '1782835199' GROUP BY `goods_id` [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000581s ]
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` <= 1780987830 AND `endtime` >= 1780987830 ) [ RunTime:0.005916s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000624s ]
SELECT * FROM `sys_coupon` WHERE `seller_id` = '1' AND ( `status` = 1 AND `type` = 1 AND `starttime` <= 1780987830 AND `endtime` >= 1780987830 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.005337s ]