SHOW FULL COLUMNS FROM `mx_cms_category` [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `mx_cms_category` WHERE `status` = 1 AND `pid` = 36 ORDER BY `weight` DESC,`id` DESC [ RunTime:0.000532s ]
SHOW FULL COLUMNS FROM `mx_demand` [ RunTime:0.001589s ]
SELECT COUNT(*) AS think_count FROM `mx_demand` `d` LEFT JOIN `mx_cms_category` `cc` ON `d`.`cat_id`=`cc`.`id` WHERE `d`.`cat_id` = '37' AND `d`.`status` = '1' AND `d`.`sj_status` = '1' LIMIT 1 [ RunTime:0.000669s ]
SELECT `d`.`id`,`d`.`user_id`,`d`.`cat_id`,`d`.`name`,`d`.`phone`,`d`.`price`,`d`.`create_time`,`d`.`photos`,`d`.`photos_thumb`,`d`.`concat_name`,`d`.`status`,`cc`.`topid` FROM `mx_demand` `d` LEFT JOIN `mx_cms_category` `cc` ON `d`.`cat_id`=`cc`.`id` WHERE `d`.`cat_id` = '37' AND `d`.`status` = '1' AND `d`.`sj_status` = '1' ORDER BY `d`.`weight` DESC,`d`.`id` DESC LIMIT 0,6 [ RunTime:0.000539s ]
