SHOW FULL COLUMNS FROM `xm_area` [ RunTime:0.000639s ]
SELECT `id`,`name` FROM `xm_area` WHERE `parent_id` = 0 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `xm_scate` [ RunTime:0.000573s ]
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.000384s ]
SHOW FULL COLUMNS FROM `xm_brand` [ RunTime:0.000519s ]
SELECT `id`,`brand`,`logo` FROM `xm_brand` WHERE ( `status` = 1 AND `pstype` = 2 ) AND `xm_brand`.`delete_time` IS NULL [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `xm_service` [ RunTime:0.000611s ]
SELECT COUNT(*) AS think_count FROM `xm_service` WHERE `status` = 1 AND `org_id` <> 0 AND `delete_time` IS NULL [ RunTime:0.000293s ]
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.000296s ]
