SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000309s ]
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.000350s ]
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.000244s ]
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.000170s ]
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.000174s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000299s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000150s ]
SHOW FULL COLUMNS FROM `sys_goods_cate` [ RunTime:0.000311s ]
SELECT `gc`.`id`,`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.000451s ]
SELECT `gc`.`id`,`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` = '9' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000308s ]
SELECT `gc`.`id`,`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` = '97' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000313s ]
SELECT `gc`.`id`,`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` = '112' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000316s ]
SELECT `gc`.`id`,`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` = '63' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000330s ]
SELECT `gc`.`id`,`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` = '142' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000289s ]
SELECT `gc`.`id`,`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` = '4' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000293s ]
SELECT `gc`.`id`,`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` = '7' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000277s ]
SELECT `gc`.`id`,`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` = '1' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000254s ]
SELECT `gc`.`id`,`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` = '6' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000352s ]
SELECT `gc`.`id`,`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` = '8' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000294s ]
SELECT `gc`.`id`,`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` = '10' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000280s ]
SELECT `gc`.`id`,`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` = '11' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000305s ]
SELECT `gc`.`id`,`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` = '51' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000270s ]
SELECT `gc`.`id`,`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` = '54' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000305s ]
SELECT `gc`.`id`,`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` = '69' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000323s ]
SELECT `gc`.`id`,`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` = '62' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000265s ]
SELECT `gc`.`id`,`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` = '233' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000360s ]
SELECT `gc`.`id`,`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` = '270' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000266s ]
SELECT `gc`.`id`,`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` = '296' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000250s ]
SELECT `gc`.`id`,`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` = '293' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000311s ]
SELECT `gc`.`id`,`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` = '294' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000240s ]
SELECT `gc`.`id`,`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` = '281' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000250s ]
SELECT `gc`.`id`,`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` = '280' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000297s ]
SELECT `gc`.`id`,`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` = '282' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000252s ]
SELECT `gc`.`id`,`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` = '283' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000319s ]
SELECT `gc`.`id`,`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` = '284' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000291s ]
SELECT `gc`.`id`,`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` = '285' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000252s ]
SELECT `gc`.`id`,`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` = '286' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000295s ]
SELECT `gc`.`id`,`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` = '287' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000243s ]
SELECT `gc`.`id`,`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` = '289' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000245s ]
SELECT `gc`.`id`,`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` = '278' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000381s ]
SELECT `gc`.`id`,`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` = '288' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000268s ]
SELECT `gc`.`id`,`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` = '290' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000292s ]
SELECT `gc`.`id`,`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` = '291' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000283s ]
SELECT `gc`.`id`,`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` = '292' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000277s ]
SELECT `gc`.`id`,`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` = '158' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `sys_service_cate` [ RunTime:0.000256s ]
SELECT `sc`.`id`,`sc`.`icon`,`sct`.`name` FROM `sys_service_cate` `sc` LEFT JOIN `sys_service_cate_translate` `sct` ON `sc`.`id`=`sct`.`service_cate_id` WHERE ( `sc`.`status` = '1' AND `sct`.`lang` = 'zh-cn' ) ORDER BY `sc`.`sort` ASC,`sc`.`id` ASC [ RunTime:0.000205s ]
SHOW FULL COLUMNS FROM `sys_hot_search` [ RunTime:0.000246s ]
SELECT `keyword` FROM `sys_hot_search` WHERE ( `status` = 1 AND `lang` = 'zh-cn' ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000167s ]
SHOW FULL COLUMNS FROM `sys_service` [ RunTime:0.001614s ]
SELECT COUNT(*) AS think_count FROM `sys_service` `s` LEFT JOIN `sys_service_translate` `st` ON `s`.`id`=st.service_id AND st.lang="zh-cn" WHERE ( `s`.`cate_id` = '2' ) AND ( `s`.`status` = '1' ) [ RunTime:0.001559s ]
SELECT `s`.`id`,`s`.`thumb`,`st`.`name` FROM `sys_service` `s` LEFT JOIN `sys_service_translate` `st` ON `s`.`id`=st.service_id AND st.lang="zh-cn" WHERE ( `s`.`cate_id` = '2' ) AND ( `s`.`status` = '1' ) ORDER BY `s`.`sort` ASC,`s`.`id` DESC LIMIT 0,12 [ RunTime:0.000227s ]
电子产品
体育与娱乐
美妆
父母、儿童及玩具
个人护理和家庭护理
农产品，食品与饮料
建筑与房地产
商用设备和机械
原材料
电子元器件
工业机械
服务
服务
