SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000608s ]
SELECT `n`.`id`,`n`.`pos`,`n`.`url`,`nt`.`name`,`nt`.`seo_title`,`nt`.`seo_keywords`,`nt`.`seo_description` FROM `sys_navigation` `n` LEFT JOIN `sys_navigation_translate` `nt` ON `n`.`id`=`nt`.`navigation_id` WHERE ( `n`.`status` = '1' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC LIMIT 4 [ RunTime:0.000476s ]
SELECT `n`.`pos`,`n`.`url`,`nt`.`name`,`nt`.`seo_title`,`nt`.`seo_keywords`,`nt`.`seo_description` FROM `sys_navigation` `n` LEFT JOIN `sys_navigation_translate` `nt` ON `n`.`id`=`nt`.`navigation_id` WHERE ( `n`.`status` = '1' AND `n`.`pid` = '1' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000449s ]
SELECT `n`.`pos`,`n`.`url`,`nt`.`name`,`nt`.`seo_title`,`nt`.`seo_keywords`,`nt`.`seo_description` FROM `sys_navigation` `n` LEFT JOIN `sys_navigation_translate` `nt` ON `n`.`id`=`nt`.`navigation_id` WHERE ( `n`.`status` = '1' AND `n`.`pid` = '2' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000252s ]
SELECT `n`.`pos`,`n`.`url`,`nt`.`name`,`nt`.`seo_title`,`nt`.`seo_keywords`,`nt`.`seo_description` FROM `sys_navigation` `n` LEFT JOIN `sys_navigation_translate` `nt` ON `n`.`id`=`nt`.`navigation_id` WHERE ( `n`.`status` = '1' AND `n`.`pid` = '3' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000247s ]
SELECT `n`.`pos`,`n`.`url`,`nt`.`name`,`nt`.`seo_title`,`nt`.`seo_keywords`,`nt`.`seo_description` FROM `sys_navigation` `n` LEFT JOIN `sys_navigation_translate` `nt` ON `n`.`id`=`nt`.`navigation_id` WHERE ( `n`.`status` = '1' AND `n`.`pid` = '4' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000543s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000148s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000427s ]
SELECT * FROM `sys_ad` WHERE ( `pos_id` = 1 AND `status` = 1 AND `starttime` <= 1781926273 AND `endtime` > 1781926273 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000253s ]
SHOW FULL COLUMNS FROM `sys_goods_cate` [ RunTime:0.000338s ]
SELECT `gc`.`child_ids`,`gc`.`icon`,`gct`.`name` FROM `sys_goods_cate` `gc` LEFT JOIN `sys_goods_cate_translate` `gct` ON `gc`.`id`=`gct`.`goods_cate_id` WHERE ( `gc`.`status` = '1' AND `gc`.`pid` = '0' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000457s ]
SELECT COUNT(*) AS think_count FROM `sys_goods` `g` LEFT JOIN `sys_goods_translate` `gt` ON `g`.`id`=gt.goods_id AND gt.lang="zh-cn" LEFT JOIN `sys_supplier` `s` ON `g`.`supplier_id`=`s`.`id` WHERE ( `g`.`status` = '1' AND `g`.`starttime` <= '1781926273' AND `g`.`endtime` > '1781926273' ) [ RunTime:0.005915s ]
SELECT `g`.`id`,`g`.`thumb`,`g`.`price`,`g`.`market_price`,`g`.`tag_ids`,`gt`.`name`,IF(s.mark_up_rate > 0, ROUND(g.price + (g.price * s.mark_up_rate / 100), 2), g.price) as price,IF(s.mark_up_rate > 0, ROUND(g.market_price + (g.market_price * s.mark_up_rate / 100), 2), g.market_price) as market_price FROM `sys_goods` `g` LEFT JOIN `sys_goods_translate` `gt` ON `g`.`id`=gt.goods_id AND gt.lang="zh-cn" LEFT JOIN `sys_supplier` `s` ON `g`.`supplier_id`=`s`.`id` WHERE ( `g`.`status` = '1' AND `g`.`starttime` <= '1781926273' AND `g`.`endtime` > '1781926273' ) ORDER BY `g`.`is_rec` DESC,`g`.`sort` ASC,`g`.`id` DESC LIMIT 1660,20 [ RunTime:0.008595s ]
SHOW FULL COLUMNS FROM `sys_goods_tag` [ RunTime:0.000480s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000304s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000227s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000225s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000202s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000213s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000204s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000205s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000203s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000185s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000214s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000236s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000412s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000200s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000172s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000158s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000197s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000214s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000197s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000198s ]
SELECT `gtt`.`name` FROM `sys_goods_tag` `gt` LEFT JOIN `sys_goods_tag_translate` `gtt` ON `gt`.`id`=gtt.goods_tag_id AND gtt.lang="zh-cn" WHERE ( `gt`.`id` IN ('4','3','2') ) [ RunTime:0.000221s ]
SHOW FULL COLUMNS FROM `sys_hot_search` [ RunTime:0.000358s ]
SELECT `keyword` FROM `sys_hot_search` WHERE ( `status` = 1 AND `lang` = 'zh-cn' ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000171s ]
精选商品
日用
日化
服被箱包
美容
建材
食品
车辆汽配
