[ DB ] CONNECT:[ UseTime:0.000372s ] mysql:host=127.0.0.1;port=3306;dbname=puwowo;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `info_shops` [ RunTime:0.000663s ]
[ SQL ] SELECT `a`.*,`c`.`catname` FROM `info_shops` `a` LEFT JOIN `info_cate` `c` ON `c`.`code`=`a`.`catid` WHERE `a`.`id` = '4' LIMIT 1 [ RunTime:0.000571s ]
[ SQL ] SHOW COLUMNS FROM `info_files` [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `info_files` WHERE `tid` = 4 AND `type` = 1 [ RunTime:0.000210s ]
[ SQL ] SHOW COLUMNS FROM `system_area_region` [ RunTime:0.000284s ]
[ SQL ] SELECT `qyname` FROM `system_area_region` WHERE `code` = '001' LIMIT 1 [ RunTime:0.000154s ]
[ SQL ] SELECT `id`,`title`,`picurl`,`rent`,`unit`,`area` FROM `info_shops` WHERE `qy_area` = '001036' AND `status` = 1 AND `id` <> 4 ORDER BY `sort` DESC,`views` DESC,`id` DESC LIMIT 4 [ RunTime:0.000440s ]