SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000518s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000260s ]
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.000243s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000431s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000464s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000193s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000436s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000196s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000488s ]
SELECT `id`,`name` FROM `sys_goods_class` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000217s ]
SHOW FULL COLUMNS FROM `sys_brand` [ RunTime:0.000543s ]
SELECT `id`,`name`,`logo`,`seller_id` FROM `sys_brand` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000558s ]
SELECT `id`,`pid`,`name`,`seller_id` FROM `sys_category` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000613s ]
SELECT `id`,`name`,`seller_id` FROM `sys_goods_attr` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000939s ]
SHOW FULL COLUMNS FROM `sys_goods_specs` [ RunTime:0.000602s ]
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` DESC,`c`.`id` ASC [ RunTime:0.004582s ]
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` DESC,`c`.`id` ASC [ RunTime:0.003642s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000955s ]
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 `b`.`status` = '1' [ RunTime:0.001368s ]
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 `b`.`status` = '1' ORDER BY `g`.`seller_id` ASC,g.total_sales desc LIMIT 0,12 [ RunTime:0.001329s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000724s ]
SELECT `id`,`goods_id`,`price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` 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.000939s ]
SELECT `name`,`id` FROM `sys_goods_attr` WHERE `id` IN (46,15,73,6,8,191,1,63) [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000558s ]
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.000317s ]
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 '1790784000' AND '1793462399' GROUP BY `goods_id` [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000476s ]
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` <= 1791351698 AND `endtime` >= 1791351698 ) [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000550s ]
SELECT * FROM `sys_coupon` WHERE `seller_id` = '1' AND ( `status` = 1 AND `type` = 1 AND `starttime` <= 1791351698 AND `endtime` >= 1791351698 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000377s ]