SHOW FULL COLUMNS FROM `mx_demand` [ RunTime:0.006623s ]
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.001110s ]
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,8 [ RunTime:0.000797s ]
SHOW FULL COLUMNS FROM `mx_supply` [ RunTime:0.002195s ]
SELECT COUNT(*) AS think_count FROM `mx_supply` `s` LEFT JOIN `mx_cms_category` `cc` ON `s`.`cat_id`=`cc`.`id` WHERE `s`.`status` = '1' AND `s`.`sj_status` = '1' LIMIT 1 [ RunTime:0.002355s ]
SELECT `s`.`id`,`s`.`num`,`s`.`user_id`,`s`.`cat_id`,`s`.`name`,`s`.`phone`,`s`.`price`,`s`.`create_time`,`s`.`photos`,`s`.`photos_thumb`,`s`.`concat_name`,`s`.`status`,`cc`.`topid` FROM `mx_supply` `s` LEFT JOIN `mx_cms_category` `cc` ON `s`.`cat_id`=`cc`.`id` WHERE `s`.`status` = '1' AND `s`.`sj_status` = '1' ORDER BY `s`.`weight` DESC,`s`.`id` DESC LIMIT 0,8 [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `mx_cms_article` [ RunTime:0.001957s ]
SELECT COUNT(*) AS think_count FROM `mx_cms_article` WHERE `status` = 1 LIMIT 1 [ RunTime:0.000883s ]
SELECT id,title,left(content,100) constr FROM `mx_cms_article` WHERE `status` = 1 ORDER BY `weight` DESC,`id` DESC LIMIT 0,4 [ RunTime:0.000435s ]
