SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000782s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000654s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000474s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000685s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000440s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000620s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000460s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000534s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `sys_article` [ RunTime:0.000664s ]
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.000495s ]
SHOW FULL COLUMNS FROM `sys_case` [ RunTime:0.000589s ]
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.000448s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000612s ]
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` <= '1794305463' AND `a`.`endtime` >= '1794305463' 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.000621s ]
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` <= '1794305463' AND `a`.`endtime` >= '1794305463' AND `p`.`name` = '新品速递左下轮播' AND `p`.`status` = '1' ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.000534s ]
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` <= '1794305463' AND `a`.`endtime` >= '1794305463' AND `p`.`name` = '新品速递右侧轮播' AND `p`.`status` = '1' ORDER BY `a`.`sort` DESC,`a`.`id` DESC [ RunTime:0.000636s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000722s ]
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.000494s ]
SHOW FULL COLUMNS FROM `sys_goods_low` [ RunTime:0.000535s ]
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` <= '1794305463' AND `gl`.`endtime` >= '1794305463' ) ORDER BY `gl`.`sort` DESC,`gl`.`id` DESC LIMIT 8 [ RunTime:0.000613s ]
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.003784s ]
SHOW FULL COLUMNS FROM `sys_goods_item` [ RunTime:0.000647s ]
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,6,5) AND `price` > '0' [ RunTime:0.010038s ]
SHOW FULL COLUMNS FROM `sys_goods_attr` [ RunTime:0.000750s ]
SELECT `name`,`id` FROM `sys_goods_attr` WHERE `id` IN (28,14,8,2,11,4,1,5,3) [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `sys_order_item` [ RunTime:0.000573s ]
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,6,5) GROUP BY `goods_id` [ RunTime:0.000518s ]
SELECT * FROM `sys_goods_low` WHERE `goods_id` IN (1697,1696,1695,1693,1692,2,3,84,13,4,65,46,41,6,5) AND ( `status` = 1 AND `starttime` <= 1794305463 AND `endtime` >= 1794305463 ) [ RunTime:0.000486s ]
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,6,5) GROUP BY `goods_id` [ RunTime:0.005838s ]
2026-06-05
42
