SHOW FULL COLUMNS FROM `software_list` [ RunTime:0.000755s ]
SELECT `this`.`slug`,`native_name`,software_category.cate_name as category,`cate_id`,`downloads`,`rating` FROM `software_list` `this` LEFT JOIN `software_detail` ON `this`.`id`=`software_detail`.`software_id` LEFT JOIN `software_category` ON `software_category`.`id`=`software_detail`.`cate_id` LEFT JOIN `software_votes` ON `this`.`id`=`software_votes`.`software_id` LEFT JOIN `software_weight` ON `software_weight`.`software_id`=this.id and software_weight.domain_id = 32 LEFT JOIN `software_dmca` ON `this`.`id`=software_dmca.software_id and software_dmca.domain_id = 32 WHERE ( `software_detail`.`lang_id` = '3' ) AND `software_dmca`.`is_dmca` IS NULL ORDER BY `weight` DESC LIMIT 0,5 [ RunTime:0.007768s ]
SELECT `this`.`slug`,`native_name`,software_category.cate_name as category,`cate_id`,`downloads`,`rating` FROM `software_list` `this` LEFT JOIN `software_detail` ON `this`.`id`=`software_detail`.`software_id` LEFT JOIN `software_category` ON `software_category`.`id`=`software_detail`.`cate_id` LEFT JOIN `software_votes` ON `this`.`id`=`software_votes`.`software_id` LEFT JOIN `software_weight` ON `software_weight`.`software_id`=this.id and software_weight.domain_id = 32 LEFT JOIN `software_dmca` ON `this`.`id`=software_dmca.software_id and software_dmca.domain_id = 32 WHERE ( `software_detail`.`lang_id` = '3' ) AND `software_dmca`.`is_dmca` IS NULL ORDER BY `weight` DESC LIMIT 5,60 [ RunTime:0.007164s ]