SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.005837s ]
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.001044s ]
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.007137s ]
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.000661s ]
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.001358s ]
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.001937s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.003981s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.001362s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.004491s ]
SELECT * FROM `sys_ad` WHERE ( `pos_id` = 1 AND `status` = 1 AND `starttime` <= 1794188766 AND `endtime` > 1794188766 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.001751s ]
SHOW FULL COLUMNS FROM `sys_goods_cate` [ RunTime:0.002576s ]
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.001258s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.011474s ]
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` <= '1794188766' AND `g`.`endtime` > '1794188766' ) [ RunTime:0.010455s ]
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` <= '1794188766' AND `g`.`endtime` > '1794188766' ) ORDER BY `g`.`is_rec` DESC,`g`.`sort` ASC,`g`.`id` DESC LIMIT 1380,20 [ RunTime:0.008187s ]
SHOW FULL COLUMNS FROM `sys_goods_tag` [ RunTime:0.037774s ]
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.001869s ]
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.000779s ]
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.026659s ]
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.000623s ]
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.000607s ]
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.000514s ]
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.000283s ]
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.000681s ]
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.000345s ]
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.000470s ]
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.011104s ]
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.000243s ]
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.000269s ]
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.000212s ]
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.000323s ]
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.000230s ]
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.000210s ]
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','1') ) [ RunTime:0.000226s ]
SHOW FULL COLUMNS FROM `sys_hot_search` [ RunTime:0.000373s ]
SELECT `keyword` FROM `sys_hot_search` WHERE ( `status` = 1 AND `lang` = 'zh-cn' ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000246s ]
精选商品
日用
日化
服被箱包
美容
建材
食品
车辆汽配
