[ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=www_gbpxfww_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `system__areas` [ RunTime:0.049703s ]
[ SQL ] SELECT * FROM `system__areas` WHERE `id` = 440000 LIMIT 1 [ RunTime:0.001254s ]
[ SQL ] SHOW COLUMNS FROM `archives__schools` [ RunTime:0.047549s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `archives__schools` INNER JOIN `system__areas` ON `system__areas`.`id`=`archives__schools`.`area_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` WHERE ( `archives__schools`.`type` = 2 AND `archives__schools`.`is_show` = '0' AND `archives__schools`.`area_id` = 440000 ) AND `archives__schools`.`delete_time` = 0 [ RunTime:0.001233s ]
[ SQL ] SELECT `archives__schools`.`id`,system__areas.name as area_name,`archives__schools`.`name`,`archives__schools`.`icon_id`,`archives__schools`.`panoramic_image_id`,`archives__schools`.`address`,`archives__schools`.`weight`,`archives__schools`.`logo_id`,`archives__schools`.`status`,f1.path icon_path,`archives__schools`.`flag`,`archives__schools`.`abstract`,`archives__schools`.`pinyin` FROM `archives__schools` INNER JOIN `system__areas` ON `system__areas`.`id`=`archives__schools`.`area_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` WHERE ( `archives__schools`.`type` = 2 AND `archives__schools`.`is_show` = '0' AND `archives__schools`.`area_id` = 440000 ) AND `archives__schools`.`delete_time` = 0 ORDER BY `archives__schools`.`weight` DESC LIMIT 0,4 [ RunTime:0.001456s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `archives__schools` INNER JOIN `system__areas` ON `system__areas`.`id`=`archives__schools`.`area_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` WHERE ( `archives__schools`.`type` = 3 AND `archives__schools`.`is_show` = '0' AND `archives__schools`.`area_id` = 440000 ) AND `archives__schools`.`delete_time` = 0 [ RunTime:0.001037s ]
[ SQL ] SELECT `archives__schools`.`id`,system__areas.name as area_name,`system__areas`.`pinyin`,`archives__schools`.`name`,`archives__schools`.`icon_id`,`archives__schools`.`panoramic_image_id`,`archives__schools`.`address`,`archives__schools`.`abstract`,`archives__schools`.`weight`,`archives__schools`.`logo_id`,`archives__schools`.`status`,`archives__schools`.`flag`,f1.path icon_path FROM `archives__schools` INNER JOIN `system__areas` ON `system__areas`.`id`=`archives__schools`.`area_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` WHERE ( `archives__schools`.`type` = 3 AND `archives__schools`.`is_show` = '0' AND `archives__schools`.`area_id` = 440000 ) AND `archives__schools`.`delete_time` = 0 ORDER BY `archives__schools`.`weight` DESC LIMIT 0,6 [ RunTime:0.000948s ]