SHOW FULL COLUMNS FROM `t_products` [ RunTime:0.000361s ]
SELECT `t1`.`cate_id` FROM `t_products` `t1` LEFT JOIN `t_products_lang` `t2` ON `t1`.`id`=`t2`.`pid` WHERE `t1`.`delete_time` = '0' AND `t2`.`delete_time` = '0' AND `t2`.`status` = '1' AND `t2`.`state` = '1' AND ( t2.id > 0 ) AND `t2`.`lang` = 'ja-jp' GROUP BY `t1`.`cate_id` [ RunTime:0.000310s ]
SHOW FULL COLUMNS FROM `t_articles_cates` [ RunTime:0.000227s ]
SELECT `name`,`langs`,`id` FROM `t_articles_cates` WHERE `delete_time` = 0 ORDER BY `weight` ASC [ RunTime:0.000131s ]
SHOW FULL COLUMNS FROM `t_products_cates` [ RunTime:0.000258s ]
SELECT `seo_param`,`name`,`langs`,`id` FROM `t_products_cates` WHERE `delete_time` = 0 AND `pid` = 0 AND `id` IN (16,22) ORDER BY `weight` ASC [ RunTime:0.000149s ]
SHOW FULL COLUMNS FROM `t_make_abilitys` [ RunTime:0.000180s ]
SELECT `t1`.`name`,`langs`,`t1`.`id` FROM `t_make_abilitys` `t1` LEFT JOIN `t_make_ability_contents` `t2` ON `t1`.`id`=`t2`.`pid` WHERE `delete_time` = 0 AND ( t2.id > 0 ) AND `t2`.`lang` = 'ja-jp' GROUP BY `t1`.`id` ORDER BY `weight` ASC [ RunTime:0.000225s ]
SHOW FULL COLUMNS FROM `t_articles_lang` [ RunTime:0.000221s ]
SELECT COUNT(*) AS think_count FROM `t_articles_lang` WHERE `delete_time` = 0 AND `state` = 1 AND `lang` = 'ja-jp' LIMIT 1 [ RunTime:0.000132s ]
SELECT pid as id,`title`,`create_time`,`covers` FROM `t_articles_lang` WHERE `delete_time` = 0 AND `state` = 1 AND `lang` = 'ja-jp' ORDER BY `pid` DESC LIMIT 0,10 [ RunTime:0.000154s ]
SHOW FULL COLUMNS FROM `t_seos_lang` [ RunTime:0.000202s ]
SHOW FULL COLUMNS FROM `t_seos` [ RunTime:0.000184s ]
SELECT `seos_lang`.`id`,`seos_lang`.`pid`,`seos_lang`.`lang`,`seos_lang`.`seo_title`,`seos_lang`.`seo_keyword`,`seos_lang`.`seo_description`,`seos_lang`.`create_time`,`seos_lang`.`update_time`,`seo`.`id` AS `seo__id`,`seo`.`name` AS `seo__name`,`seo`.`key` AS `seo__key`,`seo`.`create_time` AS `seo__create_time`,`seo`.`update_time` AS `seo__update_time`,`seo`.`delete_time` AS `seo__delete_time` FROM `t_seos_lang` `seos_lang` LEFT JOIN `t_seos` `seo` ON `seos_lang`.`pid`=`seo`.`id` WHERE `pid` > 0 [ RunTime:0.000132s ]
SHOW FULL COLUMNS FROM `t_web_config` [ RunTime:0.000209s ]
SELECT * FROM `t_web_config` [ RunTime:0.000104s ]
SHOW FULL COLUMNS FROM `t_products_lang` [ RunTime:0.000205s ]
SELECT t3.langs as cate,t3.name,t2.cate_id,count(t1.id) as total FROM `t_products_lang` `t1` LEFT JOIN `t_products` `t2` ON `t1`.`pid`=`t2`.`id` LEFT JOIN `t_products_cates` `t3` ON `t2`.`cate_id`=`t3`.`id` WHERE `t1`.`delete_time` = '0' AND `t1`.`state` = '1' AND `t1`.`status` = '1' AND `t1`.`lang` = 'ja-jp' GROUP BY `t2`.`cate_id` [ RunTime:0.000230s ]
SELECT pid as id,`covers`,`title`,`create_time` FROM `t_articles_lang` WHERE `lang` = 'ja-jp' AND `delete_time` = 0 AND `state` = 1 AND `lang` = 'ja-jp' ORDER BY `visits` DESC LIMIT 0,5 [ RunTime:0.000179s ]
+86 18688681618
Gavin@v-1.com
