SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000806s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000681s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000451s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000668s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000482s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000682s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000452s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000546s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000434s ]
SHOW FULL COLUMNS FROM `sys_article` [ RunTime:0.000673s ]
SELECT `id`,`title`,`content`,`addtime`,`tags`,`subtitle`,`cover`,`read_count` FROM `sys_article` WHERE ( `is_recommend` = 1 ) ORDER BY `updatetime` DESC,`id` DESC LIMIT 3 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `sys_case` [ RunTime:0.000626s ]
SELECT `id`,`title`,`content`,`addtime`,`tags`,`subtitle`,`cover` FROM `sys_case` WHERE ( `is_recommend` = 1 ) ORDER BY `updatetime` DESC,`id` DESC LIMIT 6 [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000595s ]
SELECT `a`.* FROM `sys_ad` `a` LEFT JOIN `sys_ad_pos` `p` ON `p`.`id`=`a`.`pos_id` WHERE `a`.`status` = '1' AND `a`.`starttime` <= '1794306311' AND `a`.`endtime` >= '1794306311' AND ( ( `p`.`name` IN ('首页轮播','首页') AND `p`.`status` = '1' ) OR `a`.`pos_id` IS NULL OR `a`.`pos_id` = '0' ) ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.000618s ]
SELECT `a`.* FROM `sys_ad` `a` LEFT JOIN `sys_ad_pos` `p` ON `p`.`id`=`a`.`pos_id` WHERE `a`.`status` = '1' AND `a`.`starttime` <= '1794306311' AND `a`.`endtime` >= '1794306311' AND `p`.`name` = '新品速递左下轮播' AND `p`.`status` = '1' ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.000581s ]
SELECT `a`.* FROM `sys_ad` `a` LEFT JOIN `sys_ad_pos` `p` ON `p`.`id`=`a`.`pos_id` WHERE `a`.`status` = '1' AND `a`.`starttime` <= '1794306311' AND `a`.`endtime` >= '1794306311' AND `p`.`name` = '新品速递右侧轮播' AND `p`.`status` = '1' ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000790s ]
SELECT `id`,`title`,`class_id`,`attr_id`,`thumb`,`seller_id`,`total_sales`,`moon_sales` FROM `sys_goods` WHERE `status` = 1 ORDER BY `addtime` DESC,`id` DESC LIMIT 5 [ RunTime:0.000474s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000520s ]
SELECT `g`.* FROM `sys_goods_low` `gl` LEFT JOIN `sys_goods` `g` ON `gl`.`goods_id`=`g`.`id` WHERE ( `gl`.`status` = '1' AND `gl`.`starttime` <= '1794306311' AND `gl`.`endtime` >= '1794306311' ) ORDER BY `gl`.`sort` DESC,`gl`.`id` DESC LIMIT 8 [ RunTime:0.000605s ]
SELECT `id`,`title`,`class_id`,`attr_id`,`thumb`,`seller_id`,`total_sales`,`moon_sales` FROM `sys_goods` `g` WHERE `status` = 1 AND `is_recommend` = 1 ORDER BY (SELECT COALESCE(MAX(CASE WHEN gi.price > 0 THEN gi.local_stock END), SUM(gi.local_stock), 0) FROM sys_goods_item gi WHERE gi.goods_id = g.id) > 0 DESC, RAND() LIMIT 8 [ RunTime:0.003848s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000642s ]
SELECT `id`,`goods_id`,`price`,`v2_price`,`local_stock`,`specs_ids`,`attr_id`,`thumb` FROM `sys_goods_item` WHERE `goods_id` IN (1697,1696,1695,1693,1692,2,3,84,13,4,65,46,41,5,6) AND `price` > '0' [ RunTime:0.010677s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000813s ]
SELECT `name`,`id` FROM `sys_goods_attr` WHERE `id` IN (28,14,8,2,11,4,1,5,3) [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000627s ]
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 (1697,1696,1695,1693,1692,2,3,84,13,4,65,46,41,5,6) GROUP BY `goods_id` [ RunTime:0.000520s ]
SELECT * FROM `sys_goods_low` WHERE `goods_id` IN (1697,1696,1695,1693,1692,2,3,84,13,4,65,46,41,5,6) AND ( `status` = 1 AND `starttime` <= 1794306311 AND `endtime` >= 1794306311 ) [ RunTime:0.000539s ]
SELECT goods_id,SUM(local_stock) AS stock FROM `sys_goods_item` WHERE `goods_id` IN (1697,1696,1695,1693,1692,2,3,84,13,4,65,46,41,5,6) GROUP BY `goods_id` [ RunTime:0.005943s ]
2026-06-05
42
