[ DB ] CONNECT:[ UseTime:0.001652s ] mysql:host=127.0.0.1;port=3306;dbname=www_gbpxfww_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `archives__schools` [ RunTime:0.016604s ]
[ SQL ] SELECT `archives__schools`.`id` FROM `archives__schools` WHERE ( `archives__schools`.`pinyin` = 'zycjdx' ) AND `archives__schools`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000828s ]
[ SQL ] SELECT `archives__schools`.*,f1.path icon_path,f2.path logo_path FROM `archives__schools` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` LEFT JOIN `system__files` `f2` ON `f2`.`id`=`archives__schools`.`logo_id` WHERE ( `archives__schools`.`id` = 97 AND `archives__schools`.`is_show` = 0 ) AND `archives__schools`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001054s ]
[ SQL ] SHOW COLUMNS FROM `system__code_values` [ RunTime:0.018864s ]
[ SQL ] SELECT `value`,`name` FROM `system__code_values` WHERE ( `code` = 'BB' ) AND `system__code_values`.`delete_time` = 0 [ RunTime:0.000987s ]
[ SQL ] SHOW COLUMNS FROM `archives__school_images` [ RunTime:0.019922s ]
[ SQL ] SELECT `archives__school_images`.*,f1.path icon_path FROM `archives__school_images` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_images`.`image_id` WHERE ( `archives__school_images`.`type` = 1 AND `archives__school_images`.`school_id` = 97 AND `archives__school_images`.`verify` = 1 ) AND `archives__school_images`.`delete_time` = 0 LIMIT 4 [ RunTime:0.001796s ]
[ SQL ] SELECT `archives__school_images`.*,f1.path icon_path FROM `archives__school_images` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_images`.`image_id` WHERE ( `archives__school_images`.`type` = 2 AND `archives__school_images`.`school_id` = 97 AND `archives__school_images`.`verify` = 1 ) AND `archives__school_images`.`delete_time` = 0 LIMIT 4 [ RunTime:0.001168s ]
[ SQL ] SELECT `archives__school_images`.*,f1.path icon_path FROM `archives__school_images` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_images`.`image_id` WHERE ( `archives__school_images`.`type` = 3 AND `archives__school_images`.`school_id` = 97 AND `archives__school_images`.`verify` = 1 ) AND `archives__school_images`.`delete_time` = 0 LIMIT 5 [ RunTime:0.001427s ]
[ SQL ] SHOW COLUMNS FROM `archives__links` [ RunTime:0.017311s ]
[ SQL ] SELECT * FROM `archives__links` WHERE ( `aid` = 97 AND `type` = 1 ) AND `archives__links`.`delete_time` = 0 ORDER BY `weight` DESC [ RunTime:0.001264s ]
[ SQL ] SHOW COLUMNS FROM `archives__school_articles` [ RunTime:0.017352s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( ( (archives__school_articles.flag&(1<<3))>0 ) AND `archives__school_articles`.`type` = 3 AND `archives__school_articles`.`school_id` = 97 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`show_time` LIMIT 1 [ RunTime:0.001876s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( ( (archives__school_articles.flag&(1<<3))>0 ) AND `archives__school_articles`.`type` = 3 AND `archives__school_articles`.`school_id` = 97 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`show_time` LIMIT 6 [ RunTime:0.001911s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 3 AND `archives__school_articles`.`classify` = 2 AND `archives__school_articles`.`school_id` = 97 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`show_time` LIMIT 1 [ RunTime:0.003252s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 3 AND `archives__school_articles`.`classify` = 2 AND `archives__school_articles`.`school_id` = 97 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`show_time` LIMIT 6 [ RunTime:0.001892s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 1 AND `archives__school_articles`.`school_id` = 97 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`show_time` LIMIT 5 [ RunTime:0.003225s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 2 AND `archives__school_articles`.`school_id` = 97 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`show_time` LIMIT 5 [ RunTime:0.001960s ]
中央财经大学干部培训掠影
更多>
