SHOW FULL COLUMNS FROM `mx_cms_category` [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `mx_cms_category` WHERE `status` = 1 AND `pid` = 39 ORDER BY `weight` DESC,`id` DESC [ RunTime:0.000483s ]
SHOW FULL COLUMNS FROM `mx_supply` [ RunTime:0.001455s ]
SELECT COUNT(*) AS think_count FROM `mx_supply` `d` LEFT JOIN `mx_cms_category` `cc` ON `d`.`cat_id`=`cc`.`id` WHERE `d`.`cat_id` = '40' AND `d`.`status` = '1' AND `d`.`sj_status` = '1' LIMIT 1 [ RunTime:0.000436s ]
SELECT `d`.`id`,`d`.`user_id`,`d`.`cat_id`,`d`.`num`,`d`.`name`,`d`.`phone`,`d`.`price`,`d`.`create_time`,`d`.`photos`,`d`.`photos_thumb`,`d`.`concat_name`,`d`.`status`,`cc`.`topid` FROM `mx_supply` `d` LEFT JOIN `mx_cms_category` `cc` ON `d`.`cat_id`=`cc`.`id` WHERE `d`.`cat_id` = '40' AND `d`.`status` = '1' AND `d`.`sj_status` = '1' ORDER BY `d`.`weight` DESC,`d`.`id` DESC LIMIT 0,6 [ RunTime:0.000442s ]
