[ DB ] CONNECT:[ UseTime:0.000552s ] mysql:host=localhost;dbname=silvern_appdata;charset=utf8
[ SQL ] SHOW COLUMNS FROM `app_category` [ RunTime:0.000488s ]
[ 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.000351s ]
[ 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.000252s ]
[ SQL ] SELECT `this`.`cate_slug`,`app_cate_lang`.`cate_name`,app_cate_lang.lang_id as app_cate_lang_id,`this`.`pid` FROM `app_category` `this` INNER JOIN `app_cate_lang` ON `this`.`id`=`app_cate_lang`.`cate_id` WHERE ( this.cate_slug = 'art-and-design' and app_cate_lang.lang_id = 3 ) LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SHOW COLUMNS FROM `app_list` [ RunTime:0.000274s ]
[ SQL ] SELECT IFNULL(app_weight.weight, 0) as weight, app_category.pid, app_votes.rating, app_detail.native_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.domain_id = 28 LEFT JOIN `app_detail` ON `this`.`id`=`app_detail`.`app_id` LEFT JOIN `app_votes` ON `app_votes`.`app_id`=`this`.`id` LEFT JOIN `app_dmca` ON `this`.`id`=app_dmca.app_id and app_dmca.domain_id = 28 WHERE `app_category`.`cate_slug` = 'art-and-design' AND `app_detail`.`lang_id` = 3 AND `app_dmca`.`is_dmca` IS NULL ORDER BY `weight` DESC LIMIT 0,48 [ RunTime:0.002999s ]
[ SQL ] SELECT IFNULL(app_weight.weight, 0) as weight, app_developer.dev_name, app_category.cate_slug, cate_id, app_votes.rating, app_detail.native_name, this.slug, this.id as app_id 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.domain_id = 28 INNER JOIN `app_category` ON `this`.`cate_id`=`app_category`.`id` INNER JOIN `app_developer` ON `app_developer`.`id`=`this`.`dev_id` LEFT JOIN `app_dmca` ON `this`.`id`=app_dmca.app_id and app_dmca.domain_id = 28 WHERE `this`.`price` = 0 AND `app_detail`.`lang_id` = 3 AND `app_category`.`pid` = 2 AND `app_category`.`cate_slug` = 'art-and-design' AND `app_dmca`.`is_dmca` IS NULL ORDER BY `weight` DESC,`app_id` DESC LIMIT 0,24 [ RunTime:0.002195s ]
[ SQL ] SHOW COLUMNS FROM `app_cate_lang` [ RunTime:0.000304s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000206s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000163s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000162s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000173s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT `cate_name` FROM `app_cate_lang` WHERE `cate_id` = 45 AND `lang_id` = 3 LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SELECT COUNT(*) AS tp_count 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.domain_id = 28 INNER JOIN `app_category` ON `this`.`cate_id`=`app_category`.`id` INNER JOIN `app_developer` ON `app_developer`.`id`=`this`.`dev_id` LEFT JOIN `app_dmca` ON `this`.`id`=app_dmca.app_id and app_dmca.domain_id = 28 WHERE `this`.`price` = 0 AND `app_detail`.`lang_id` = 3 AND `app_category`.`pid` = 2 AND `app_category`.`cate_slug` = 'art-and-design' AND `app_dmca`.`is_dmca` IS NULL [ RunTime:0.001792s ]
[ 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.domain_id = 28 LEFT JOIN `app_detail` ON `this`.`id`=`app_detail`.`app_id` LEFT JOIN `app_votes` ON `app_votes`.`app_id`=`this`.`id` LEFT JOIN `app_dmca` ON `this`.`id`=app_dmca.app_id and app_dmca.domain_id = 28 WHERE `app_category`.`cate_slug` = 'art-and-design' AND `app_detail`.`lang_id` = 3 AND `app_dmca`.`is_dmca` IS NULL [ RunTime:0.001684s ]