SHOW FULL COLUMNS FROM `mx_supply` [ RunTime:0.002215s ]
SELECT * FROM `mx_supply` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000522s ]
SELECT COUNT(*) AS think_count FROM `mx_supply` `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.000483s ]
SELECT `d`.`id`,`d`.`num`,`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_supply` `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.000473s ]
