[ BEHAVIOR ] Run \addons\betterform\Betterform @view_filter [ RunTime:0.000033s ]
[ BEHAVIOR ] Run \addons\loginbgindex\Loginbgindex @response_send [ RunTime:0.000026s ]
[ DB ] CONNECT:[ UseTime:0.000236s ] mysql:host=127.0.0.1;port=3306;dbname=zhaoshangzaixian;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `zs_menu` [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `zs_menu` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000197s ]
[ SQL ] SHOW COLUMNS FROM `zs_area` [ RunTime:0.000459s ]
[ SQL ] SELECT `id` FROM `zs_area` WHERE `short_name` = '' AND `level` = 1 LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT `id` FROM `zs_area` WHERE `short_name` = '' AND `level` = 2 LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SELECT `id` FROM `zs_area` WHERE `short_name` = '官渡区' AND `level` = 3 LIMIT 1 [ RunTime:0.001819s ]
[ SQL ] SELECT `id` FROM `zs_area` WHERE `short_name` = '' AND `level` = 4 LIMIT 1 [ RunTime:0.000209s ]
[ SQL ] SELECT `id` FROM `zs_area` WHERE `short_name` = '' AND `level` = 5 LIMIT 1 [ RunTime:0.000140s ]
[ SQL ] SELECT `id`,`short_name` FROM `zs_area` [ RunTime:0.001295s ]
[ SQL ] SHOW COLUMNS FROM `zs_city` [ RunTime:0.000636s ]
[ SQL ] SELECT * FROM `zs_city` WHERE `uni_id` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT `id`,`name` FROM `zs_city` WHERE `parentid` = 0 [ RunTime:0.000192s ]
[ SQL ] SHOW COLUMNS FROM `zs_case_sidebar` [ RunTime:0.000310s ]
[ SQL ] SELECT * FROM `zs_case_sidebar` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `zs_area` WHERE `pid` = 0 ORDER BY `sort` ASC [ RunTime:0.000238s ]
[ SQL ] SHOW COLUMNS FROM `zs_park` [ RunTime:0.000537s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zs_park` `p` LEFT JOIN `zs_area` `a` ON `p`.`province`=`a`.`id` LEFT JOIN `zs_area` `city_a` ON `p`.`city`=`city_a`.`id` LEFT JOIN `zs_area` `district_a` ON `p`.`district`=`district_a`.`id` WHERE `p`.`park_rank` = '区县级' AND `p`.`name` LIKE '%%' AND `p`.`status` = 1 AND `p`.`industry` LIKE '%环保节能%' LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SELECT `p`.*,a.name as province_name,city_a.short_name as city_name,district_a.short_name as district_name FROM `zs_park` `p` LEFT JOIN `zs_area` `a` ON `p`.`province`=`a`.`id` LEFT JOIN `zs_area` `city_a` ON `p`.`city`=`city_a`.`id` LEFT JOIN `zs_area` `district_a` ON `p`.`district`=`district_a`.`id` WHERE `p`.`park_rank` = '区县级' AND `p`.`name` LIKE '%%' AND `p`.`status` = 1 AND `p`.`industry` LIKE '%环保节能%' ORDER BY `p`.`is_recommend` DESC,`p`.`id` DESC LIMIT 0,15 [ RunTime:0.000357s ]
[ SQL ] SELECT a.name as province_name, a.id as province_id, COUNT(p.id) as park_count FROM `zs_area` `a` LEFT JOIN `zs_park` `p` ON `a`.`id`=p.province AND p.status = 1 WHERE `a`.`level` = 1 AND `a`.`status` = 1 GROUP BY `a`.`id` ORDER BY `park_count` DESC LIMIT 40 [ RunTime:0.000482s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zs_park` WHERE `status` = 1 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `zs_area` WHERE `pid` = 0 ORDER BY `sort` ASC [ RunTime:0.000290s ]
[ SQL ] SELECT `p`.*,province_a.short_name as province_name,city_a.short_name as city_name,district_a.short_name as district_name FROM `zs_park` `p` LEFT JOIN `zs_area` `province_a` ON `p`.`province`=`province_a`.`id` LEFT JOIN `zs_area` `city_a` ON `p`.`city`=`city_a`.`id` LEFT JOIN `zs_area` `district_a` ON `p`.`district`=`district_a`.`id` WHERE `p`.`status` = 1 ORDER BY `p`.`refresh_time` DESC LIMIT 3 [ RunTime:0.000408s ]
[ SQL ] SHOW COLUMNS FROM `zs_user` [ RunTime:0.000617s ]
[ SQL ] SELECT `id`,`nickname`,`username`,`company_job` FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000258s ]
[ SQL ] SELECT `id`,`nickname`,`username`,`company_job` FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000196s ]
[ SQL ] SELECT `id`,`nickname`,`username`,`company_job` FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000169s ]
[ SQL ] SHOW COLUMNS FROM `zs_parkgov` [ RunTime:0.000511s ]
[ SQL ] SELECT `p`.*,province_a.short_name as province_name,city_a.short_name as city_name,district_a.short_name as district_name FROM `zs_parkgov` `p` LEFT JOIN `zs_area` `province_a` ON `p`.`province`=`province_a`.`id` LEFT JOIN `zs_area` `city_a` ON `p`.`city`=`city_a`.`id` LEFT JOIN `zs_area` `district_a` ON `p`.`district`=`district_a`.`id` WHERE `p`.`status` = 1 ORDER BY `p`.`refresh_time` DESC LIMIT 3 [ RunTime:0.000464s ]
[ SQL ] SELECT `id`,`nickname`,`username`,`company_job` FROM `zs_user` WHERE `id` IN (1,2,3) [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`nickname`,`username`,`company_job` FROM `zs_user` WHERE `id` IN (1) [ RunTime:0.000112s ]
[ SQL ] SELECT `id`,`nickname`,`username`,`company_job` FROM `zs_user` WHERE `id` IN (2) [ RunTime:0.000102s ]
[ SQL ] SELECT * FROM `zs_park` WHERE `status` = 1 AND `is_recommend` = 1 LIMIT 6 [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000305s ]
[ SQL ] SELECT * FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000276s ]
[ SQL ] SELECT * FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `zs_user` WHERE `id` IN (1,2) [ RunTime:0.000337s ]
[ SQL ] SELECT `p`.`id`,`p`.`name`,`p`.`views`,a.short_name as province_name FROM `zs_park` `p` LEFT JOIN `zs_area` `a` ON `p`.`province`=`a`.`id` WHERE `p`.`status` = 1 ORDER BY `p`.`views` DESC LIMIT 10 [ RunTime:0.000303s ]
[ SQL ] SHOW COLUMNS FROM `zs_news` [ RunTime:0.000426s ]
[ SQL ] SELECT * FROM `zs_news` WHERE `status` = 1 AND `type` = 5 AND `is_hot` = 1 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.000312s ]
[ SQL ] SHOW COLUMNS FROM `zs_landsdeals` [ RunTime:0.000491s ]
[ SQL ] SELECT l.*,
CONCAT(province_a.short_name, "-", city_a.short_name) as region_name,
l.deal_unit_price FROM `zs_landsdeals` `l` LEFT JOIN `zs_area` `province_a` ON `l`.`province`=`province_a`.`id` LEFT JOIN `zs_area` `city_a` ON `l`.`city`=`city_a`.`id` LEFT JOIN `zs_area` `district_a` ON `l`.`district`=`district_a`.`id` WHERE `l`.`status` = 1 ORDER BY `l`.`create_time` DESC LIMIT 6 [ RunTime:0.000483s ]
[ SQL ] SHOW COLUMNS FROM `zs_customer_service_qr` [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `zs_customer_service_qr` WHERE `name` = '招商在线招商端' LIMIT 1 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `zs_customer_service_qr` WHERE `name` = '招商在线选哪儿' LIMIT 1 [ RunTime:0.000191s ]
