[ DB ] CONNECT:[ UseTime:0.000365s ] mysql:host=localhost;dbname=silvern_appdata;charset=utf8
[ SQL ] SHOW COLUMNS FROM `app_category` [ RunTime:0.000493s ]
[ SQL ] SELECT `this`.`cate_slug`,`app_cate_lang`.`cate_name` FROM `app_category` `this` INNER JOIN `app_cate_lang` ON `app_cate_lang`.`cate_id`=`this`.`id` WHERE `this`.`pid` = 1 AND `app_cate_lang`.`lang_id` = 3 LIMIT 10 [ RunTime:0.000408s ]
[ SQL ] SELECT `this`.`cate_slug`,`app_cate_lang`.`cate_name` FROM `app_category` `this` INNER JOIN `app_cate_lang` ON `app_cate_lang`.`cate_id`=`this`.`id` WHERE `this`.`pid` = 2 AND `app_cate_lang`.`lang_id` = 3 LIMIT 10 [ RunTime:0.000285s ]
[ SQL ] SHOW COLUMNS FROM `app_list` [ RunTime:0.000345s ]
[ SQL ] SELECT IFNULL(app_weight.weight, 0) as weight, app_category.cate_slug, cate_id, app_detail.native_name, app_votes.rating, this.slug FROM `app_list` `this` LEFT JOIN `app_weight` ON `app_weight`.`app_id`=this.id and app_weight.domain_id = 28 INNER JOIN `app_detail` ON `this`.`id`=`app_detail`.`app_id` INNER JOIN `app_votes` ON `app_votes`.`app_id`=`this`.`id` INNER JOIN `app_category` ON `this`.`cate_id`=`app_category`.`id` LEFT JOIN `app_dmca` ON `this`.`id`=app_dmca.app_id and app_dmca.domain_id = 28 WHERE `app_detail`.`lang_id` = 3 AND `app_dmca`.`is_dmca` IS NULL ORDER BY `weight` DESC LIMIT 51,12 [ RunTime:0.200840s ]
[ SQL ] SHOW COLUMNS FROM `app_cate_lang` [ RunTime:0.000573s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 22 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 15 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 35 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 10 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 13 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 18 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 10 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000335s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 5 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000166s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 35 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 23 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000156s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 49 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 18 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000170s ]
[ SQL ] SELECT `this`.`cate_slug`,`app_cate_lang`.`cate_name` FROM `app_category` `this` INNER JOIN `app_cate_lang` ON `this`.`id`=`app_cate_lang`.`cate_id` WHERE ( this.pid = 1 and app_cate_lang.lang_id = 3 ) [ RunTime:0.000260s ]
[ SQL ] SELECT `this`.`cate_slug`,`app_cate_lang`.`cate_name` FROM `app_category` `this` INNER JOIN `app_cate_lang` ON `this`.`id`=`app_cate_lang`.`cate_id` WHERE ( this.pid = 2 and app_cate_lang.lang_id = 3 ) [ RunTime:0.000221s ]
