SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000414s ]
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.000323s ]
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.000262s ]
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.000186s ]
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.000174s ]
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.000222s ]
SHOW FULL COLUMNS FROM `sys_links` [ RunTime:0.000269s ]
SELECT `icon`,`url` FROM `sys_links` WHERE ( `status` = 1 ) ORDER BY `sort` ASC,`id` ASC LIMIT 5 [ RunTime:0.000181s ]
SHOW FULL COLUMNS FROM `sys_goods_cate` [ RunTime:0.000271s ]
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.000424s ]
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.000339s ]
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.000329s ]
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.000345s ]
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.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` = '142' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000315s ]
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.000300s ]
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.000298s ]
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.000303s ]
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.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` = '8' 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` = '10' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000300s ]
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.000303s ]
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.000312s ]
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.000351s ]
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.000296s ]
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.000274s ]
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.000344s ]
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.000309s ]
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.000303s ]
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.000317s ]
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.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` = '281' 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` = '280' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000327s ]
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.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` = '283' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000328s ]
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.000296s ]
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.000287s ]
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.000302s ]
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.000278s ]
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.000269s ]
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.000345s ]
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.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` = '290' 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` = '291' AND `gct`.`lang` = 'zh-cn' ) ORDER BY `gc`.`sort` ASC,`gc`.`id` ASC [ RunTime:0.000320s ]
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.000324s ]
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.000269s ]
SHOW FULL COLUMNS FROM `sys_service_cate` [ RunTime:0.000290s ]
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.000246s ]
SHOW FULL COLUMNS FROM `sys_hot_search` [ RunTime:0.000234s ]
SELECT `keyword` FROM `sys_hot_search` WHERE ( `status` = 1 AND `lang` = 'zh-cn' ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000171s ]
SHOW FULL COLUMNS FROM `sys_service` [ RunTime:0.000277s ]
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` = '1' ) AND ( `s`.`status` = '1' ) [ RunTime:0.000212s ]
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` = '1' ) AND ( `s`.`status` = '1' ) ORDER BY `s`.`sort` ASC,`s`.`id` DESC LIMIT 0,12 [ RunTime:0.000196s ]
电子产品
体育与娱乐
美妆
父母、儿童及玩具
个人护理和家庭护理
农产品，食品与饮料
建筑与房地产
商用设备和机械
原材料
电子元器件
工业机械
服务
服务
