[ DB ] CONNECT:[ UseTime:0.000755s ] mysql:host=localhost;dbname=psilla_db1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `app_language` [ RunTime:0.000843s ]
[ SQL ] SELECT `id`,`lang_name`,`code_android` FROM `app_language` WHERE `www` = 1 ORDER BY `id` ASC [ RunTime:0.000433s ]
[ SQL ] SELECT `code_android` FROM `app_language` WHERE `www` = 1 ORDER BY `id` ASC [ RunTime:0.000525s ]
[ SQL ] SHOW COLUMNS FROM `app_phrase_www` [ RunTime:0.000394s ]
[ SQL ] SELECT `phrase_name`,`position` FROM `app_phrase_www` WHERE `lang_id` = 10 [ RunTime:0.000893s ]
[ SQL ] SHOW COLUMNS FROM `app_category` [ RunTime:0.000403s ]
[ 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` = 10 LIMIT 10 [ RunTime:0.000388s ]
[ 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` = 10 LIMIT 10 [ RunTime:0.000314s ]
[ SQL ] SELECT `this`.`cate_slug`,`app_cate_lang`.`cate_name`,`this`.`pid` FROM `app_category` `this` INNER JOIN `app_cate_lang` ON `this`.`id`=`app_cate_lang`.`cate_id` WHERE ( this.cate_slug = 'education' and app_cate_lang.lang_id = 10 ) LIMIT 1 [ RunTime:0.000372s ]
[ SQL ] SHOW COLUMNS FROM `app_meta` [ RunTime:0.000416s ]
[ SQL ] SELECT `title`,`keywords`,`description` FROM `app_meta` WHERE ( position = 'category-sub' and lang_id = '10' and site = 2 ) LIMIT 1 [ RunTime:0.000320s ]
[ SQL ] SHOW COLUMNS FROM `app_list` [ RunTime:0.000420s ]
[ SQL ] SELECT IFNULL(app_weight.weight, 0) as weight, app_category.pid, app_votes.rating, this.slug_www as play_link, app_detail.native_name as app_name, this.slug FROM `app_list` `this` LEFT JOIN `app_category` ON `this`.`cate_id`=`app_category`.`id` LEFT JOIN `app_weight` ON `app_weight`.`app_id`=this.id and app_weight.lang_id = 10 LEFT JOIN `app_detail` ON `this`.`id`=`app_detail`.`app_id` LEFT JOIN `app_votes` ON `app_votes`.`app_id`=`this`.`id` WHERE ( app_detail.anp_is_dmca != 1 and app_category.cate_slug = 'education' and app_detail.lang_id = 10 and (app_detail.is_show = 1 or app_detail.is_show = 0) ) ORDER BY `weight` DESC LIMIT 0,48 [ RunTime:0.031528s ]
[ SQL ] SELECT IFNULL(app_weight.weight, 0) as weight, app_developer.dev_name, app_cate_lang.cate_name, app_category.cate_slug, app_votes.rating, this.slug_www as play_link, app_detail.native_name as app_name, this.slug FROM `app_list` `this` INNER JOIN `app_detail` ON `this`.`id`=`app_detail`.`app_id` INNER JOIN `app_votes` ON `app_votes`.`app_id`=`this`.`id` LEFT JOIN `app_weight` ON `app_weight`.`app_id`=this.id and app_weight.lang_id = 10 INNER JOIN `app_category` ON `this`.`cate_id`=`app_category`.`id` INNER JOIN `app_cate_lang` ON `app_category`.`id`=`app_cate_lang`.`cate_id` INNER JOIN `app_developer` ON `app_developer`.`id`=`this`.`dev_id` WHERE ( app_cate_lang.lang_id = 10 and app_category.pid = 2 and app_category.cate_slug = 'education' and app_detail.anp_is_dmca != 1 and this.price = 0 and (app_detail.lang_id = 10 ) and (app_detail.is_show = 1 or app_detail.is_show = 0) ) ORDER BY `weight` DESC LIMIT 0,12 [ RunTime:0.032065s ]
[ SQL ] SELECT IFNULL(app_weight.weight, 0) as weight, app_developer.dev_name, app_cate_lang.cate_name, app_category.cate_slug, app_votes.rating, this.slug_www as play_link, app_detail.native_name as app_name, this.slug FROM `app_list` `this` INNER JOIN `app_detail` ON `this`.`id`=`app_detail`.`app_id` INNER JOIN `app_votes` ON `app_votes`.`app_id`=`this`.`id` LEFT JOIN `app_weight` ON `app_weight`.`app_id`=this.id and app_weight.lang_id = 10 INNER JOIN `app_category` ON `this`.`cate_id`=`app_category`.`id` INNER JOIN `app_cate_lang` ON `app_category`.`id`=`app_cate_lang`.`cate_id` INNER JOIN `app_developer` ON `app_developer`.`id`=`this`.`dev_id` WHERE ( app_cate_lang.lang_id = 10 and app_category.pid = 2 and app_category.cate_slug = 'education' and app_detail.anp_is_dmca != 1 and this.price = 0 and (app_detail.lang_id = 10 ) and (app_detail.is_show = 1 or app_detail.is_show = 0) ) ORDER BY `weight` DESC LIMIT 12,9223372036854775807 [ RunTime:0.030343s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_list` `this` LEFT JOIN `app_category` ON `this`.`cate_id`=`app_category`.`id` LEFT JOIN `app_weight` ON `app_weight`.`app_id`=this.id and app_weight.lang_id = 10 LEFT JOIN `app_detail` ON `this`.`id`=`app_detail`.`app_id` LEFT JOIN `app_votes` ON `app_votes`.`app_id`=`this`.`id` WHERE ( app_category.cate_slug = 'education' and app_detail.lang_id = 10 and app_detail.anp_is_dmca != 1 and (app_detail.is_show = 1 or app_detail.is_show = 0) ) LIMIT 1 [ RunTime:0.016833s ]