SHOW FULL COLUMNS FROM `xm_area` [ RunTime:0.000475s ]
SELECT `id`,`name` FROM `xm_area` WHERE `parent_id` = 0 [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `xm_scate` [ RunTime:0.000399s ]
SELECT * FROM `xm_scate` WHERE ( `syst` = 1 AND `status` = 1 AND `pid` = 0 ) AND `xm_scate`.`delete_time` IS NULL ORDER BY `sort` [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `xm_brand` [ RunTime:0.000411s ]
SELECT `id`,`brand`,`logo` FROM `xm_brand` WHERE ( `status` = 1 AND `pstype` = 2 ) AND `xm_brand`.`delete_time` IS NULL [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `xm_service` [ RunTime:0.000377s ]
SELECT COUNT(*) AS think_count FROM `xm_service` WHERE `status` = 1 AND `org_id` <> 0 AND `delete_time` IS NULL [ RunTime:0.000246s ]
SELECT `id`,`s_name`,`s_guige`,`s_xinghao`,`s_price`,`s_image`,`unit` FROM `xm_service` WHERE `status` = 1 AND `org_id` <> 0 AND `delete_time` IS NULL ORDER BY `evaluates`,`hot` LIMIT 0,30 [ RunTime:0.000241s ]
