SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000295s ]
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.000279s ]
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.000250s ]
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.000204s ]
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.000183s ]
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.000200s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000301s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000159s ]
SHOW FULL COLUMNS FROM `sys_ad` [ RunTime:0.000266s ]
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.000180s ]
SHOW FULL COLUMNS FROM `sys_goods_cate` [ RunTime:0.000271s ]
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.000423s ]
SHOW FULL COLUMNS FROM `sys_goods` [ RunTime:0.000336s ]
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.002036s ]
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 780,20 [ RunTime:0.002954s ]
SHOW FULL COLUMNS FROM `sys_goods_tag` [ RunTime:0.000319s ]
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` = '' ) [ RunTime:0.000147s ]
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.000147s ]
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.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','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.000116s ]
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.000120s ]
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.000161s ]
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.000098s ]
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.000099s ]
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.000084s ]
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','1') ) [ RunTime:0.000165s ]
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','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.000116s ]
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.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') ) [ RunTime:0.000160s ]
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.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','1') ) [ RunTime:0.000143s ]
SHOW FULL COLUMNS FROM `sys_hot_search` [ RunTime:0.000264s ]
SELECT `keyword` FROM `sys_hot_search` WHERE ( `status` = 1 AND `lang` = 'zh-cn' ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000191s ]