SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000298s ]
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.000265s ]
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.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` = '2' AND `nt`.`lang` = 'zh-cn' ) ORDER BY `n`.`sort` ASC,`n`.`id` ASC [ RunTime:0.000203s ]
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.000160s ]
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.000188s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000306s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000168s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000315s ]
SELECT * FROM `sys_ad` WHERE ( `pos_id` = 1 AND `status` = 1 AND `starttime` <= 1772169876 AND `endtime` > 1772169876 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000175s ]
SHOW FULL COLUMNS FROM `sys_goods_cate` [ RunTime:0.000252s ]
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.000407s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000326s ]
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` <= '1772169876' AND `g`.`endtime` > '1772169876' ) [ RunTime:0.001983s ]
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` <= '1772169876' AND `g`.`endtime` > '1772169876' ) ORDER BY `g`.`is_rec` DESC,`g`.`sort` ASC,`g`.`id` DESC LIMIT 160,20 [ RunTime:0.001532s ]
SHOW FULL COLUMNS FROM `sys_goods_tag` [ RunTime:0.000290s ]
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.000183s ]
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.000145s ]
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` = '' ) [ RunTime:0.000118s ]
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.000146s ]
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.000151s ]
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.000119s ]
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.000123s ]
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.000134s ]
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.000113s ]
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.000110s ]
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.000124s ]
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.000136s ]
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.000148s ]
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.000117s ]
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.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','1') ) [ RunTime:0.000140s ]
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.000170s ]
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.000166s ]
SHOW FULL COLUMNS FROM `sys_hot_search` [ RunTime:0.000242s ]
SELECT `keyword` FROM `sys_hot_search` WHERE ( `status` = 1 AND `lang` = 'zh-cn' ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000148s ]