SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000745s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000538s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000730s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000608s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000624s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000404s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000477s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `sys_goods_class` [ RunTime:0.000478s ]
SELECT `id`,`name` FROM `sys_goods_class` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `sys_brand` [ RunTime:0.000504s ]
SELECT `id`,`name`,`logo`,`seller_id` FROM `sys_brand` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `sys_category` [ RunTime:0.000533s ]
SELECT `id`,`pid`,`name`,`seller_id` FROM `sys_category` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000423s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000505s ]
SELECT `id`,`name`,`seller_id`,`icon` FROM `sys_goods_attr` WHERE ( `status` = 1 ) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000665s ]
SHOW FULL COLUMNS FROM `sys_goods_specs` [ RunTime:0.000483s ]
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.005076s ]
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.002855s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000781s ]
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.001130s ]
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 EXISTS (SELECT 1 FROM sys_goods_item gi WHERE gi.goods_id = g.id AND gi.price > 0 AND gi.local_stock > 0) DESC,LOWER(LEFT(TRIM(b.name), 1)) ASC, b.id ASC, CASE WHEN TRIM(g.title) REGEXP '^[0-9]' THEN 0 ELSE 1 END ASC, CASE WHEN TRIM(g.title) REGEXP '^[0-9]' THEN CAST(TRIM(g.title) AS UNSIGNED) ELSE NULL END ASC, LOWER(TRIM(g.title)) ASC,`g`.`id` ASC LIMIT 0,12 [ RunTime:0.019812s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000747s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` IN (1600,1606,1688,1597,1598,1662,1516,1515,1655,1629,1599,1313) AND `price` > '0' [ RunTime:0.000771s ]
SELECT `name`,`id` FROM `sys_goods_attr` WHERE `id` IN (288,14,289,286,8,298) [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000578s ]
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 (1600,1606,1688,1597,1598,1662,1516,1515,1655,1629,1599,1313) GROUP BY `goods_id` [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000544s ]
SELECT * FROM `sys_goods_low` WHERE `goods_id` IN (1600,1606,1688,1597,1598,1662,1516,1515,1655,1629,1599,1313) AND ( `status` = 1 AND `starttime` <= 1794306308 AND `endtime` >= 1794306308 ) [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `sys_coupon` [ RunTime:0.000612s ]
SELECT * FROM `sys_coupon` WHERE `seller_id` = '1' AND ( `status` = 1 AND `type` = 1 AND `starttime` <= 1794306308 AND `endtime` >= 1794306308 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `sys_user_coupon` [ RunTime:0.000541s ]
SELECT coupon_id, COUNT(*) AS cnt FROM `sys_user_coupon` WHERE `coupon_id` = 2 GROUP BY `coupon_id` [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `sys_goods_attr_industry_item` [ RunTime:0.000569s ]
SELECT i.id AS industry_id,i.name AS industry_name,i.name_en AS industry_name_en,`a`.`id`,`a`.`name`,`a`.`name_en`,`a`.`icon` FROM `sys_goods_attr_industry_item` `r` INNER JOIN `sys_goods_attr_industry` `i` ON `i`.`id`=`r`.`industry_id` INNER JOIN `sys_goods_attr` `a` ON `a`.`id`=`r`.`attr_id` WHERE `i`.`status` = '1' AND `a`.`status` = '1' ORDER BY `i`.`sort` ASC,`i`.`id` ASC,`r`.`sort` ASC,`a`.`id` ASC [ RunTime:0.000917s ]