SHOW FULL COLUMNS FROM `mx_demand` [ RunTime:0.003199s ]
SELECT * FROM `mx_demand` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000533s ]
SELECT COUNT(*) AS think_count FROM `mx_demand` `d` LEFT JOIN `mx_cms_category` `cc` ON `d`.`cat_id`=`cc`.`id` WHERE `d`.`status` = '1' AND `d`.`sj_status` = '1' LIMIT 1 [ RunTime:0.000593s ]
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`.`status` = '1' AND `d`.`sj_status` = '1' ORDER BY `d`.`weight` DESC,`d`.`id` DESC LIMIT 0,4 [ RunTime:0.000517s ]
