SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000503s ]
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.000384s ]
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.000283s ]
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.000188s ]
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.000159s ]
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.000209s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000304s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000214s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000371s ]
SELECT * FROM `sys_ad` WHERE ( `pos_id` = 1 AND `status` = 1 AND `starttime` <= 1776627382 AND `endtime` > 1776627382 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `sys_goods_cate` [ RunTime:0.000334s ]
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.000299s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000344s ]
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` <= '1776627382' AND `g`.`endtime` > '1776627382' ) [ RunTime:0.004193s ]
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` <= '1776627382' AND `g`.`endtime` > '1776627382' ) ORDER BY `g`.`is_rec` DESC,`g`.`sort` ASC,`g`.`id` DESC LIMIT 1860,20 [ RunTime:0.025985s ]
SHOW FULL COLUMNS FROM `sys_goods_tag` [ RunTime:0.000374s ]
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') ) [ RunTime:0.000179s ]
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.000130s ]
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.000141s ]
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.000121s ]
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.000127s ]
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.000112s ]
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.000130s ]
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.000108s ]
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.000138s ]
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.000193s ]
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.000132s ]
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.000128s ]
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.000108s ]
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.000137s ]
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.000109s ]
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.000104s ]
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.000103s ]
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.000123s ]
SHOW FULL COLUMNS FROM `sys_hot_search` [ RunTime:0.000282s ]
SELECT `keyword` FROM `sys_hot_search` WHERE ( `status` = 1 AND `lang` = 'zh-cn' ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000147s ]
精选商品
日用
日化
服被箱包
美容
建材
食品
车辆汽配
