掲示板

特別研修房総地域君津市にて研修

記事がありません。

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent359d31d6737416e23d489d7c778cb8fe
  time1555909005
  countdown10
  languageja
- _Token(array)
  key62f0aab2d1d81271b268a8581700747ee1887504e14686026312975ed97f811866e3c2c9b9a4969ad2ad52e0f2ee4bc37ad5c315758565114121716ff4917078
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  62f0aab2d1d81271b268a8581700747ee1887504e14686026312975ed97f811866e3c2c9b9a4969ad2ad52e0f2ee4bc37ad5c315758565114121716ff49170781555896405
====
Request
+
Request

Cake Params
- pluginbbses
- controllerbbs_articles
- actionindex
- named(array)
  sortBbsArticle.created
  directionasc
- pass(empty)
- block_id33
- setting(false)
- isAjax(false)
- _Token(array)
  key62f0aab2d1d81271b268a8581700747ee1887504e14686026312975ed97f811866e3c2c9b9a4969ad2ad52e0f2ee4bc37ad5c315758565114121716ff4917078
  unlockedFields(empty)
- paging(array)
  BbsArticle(array)
  page1
  current0
  count0
  prevPage(false)
  nextPage(false)
  pageCount0
  order(array)
  BbsArticle.createdasc
  limit10
  options(array)
  sortBbsArticle.created
  directionasc
  paramTypenamed
  queryScope(null)
Post data

No post data.

Query string
- frame_id49
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0plugin
  1controller
  2block_id
  3action
- options(array)
  pluginaccess_counters|announcements|auth|auth_general|authorization_keys|bbses|blocks|blogs|boxes|cabinets|calendars|categories|circular_notices|community_space|containers|content_comments|data_types|debug_kit|faqs|files|frames|groups|iframes|install|likes|links|m17n|mails|menus|migrations|mobile_detect|multidatabases|nc2_to_nc3|net_commons|notifications|pages|photo_albums|private_space|public_space|questionnaires|quizzes|registrations|reservations|roles|rss_readers|searches|tags|tasks|theme_settings|topics|upload|users|videos|visual_captcha|workflow|wysiwyg
  block_id[0-9]+
  key[a-zA-Z0-9_]+
- defaults(array)
  setting(false)
- template/:plugin/:controller/:action/:block_id/*
====

Sql Logs

slave1

Total Time: 24 ms
Total Queries: 76 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` WHERE `permalink` = 'bbses' LIMIT 1	0	0	1	maybe slow
SELECT `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` WHERE `permalink` = '' AND `id` != 1 LIMIT 1	1	1	1
SELECT COUNT(*) AS `count` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`permalink` = 'bbses/bbs_articles/index/33' AND `Room`.`space_id` = 2	1	1	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE ((`SiteSetting`.`key` LIKE 'App.site_name%') OR (`SiteSetting`.`key` LIKE 'Config.language%') OR (`SiteSetting`.`key` LIKE 'App.default_start_room%') OR (`SiteSetting`.`key` LIKE 'App.default_timezone%') OR (`SiteSetting`.`key` LIKE 'debug%') OR (`SiteSetting`.`key` LIKE 'App.close_site%') OR (`SiteSetting`.`key` LIKE 'ForgotPass.use_password_reissue%') OR (`SiteSetting`.`key` LIKE 'AutoRegist.use_automatic_register%') OR (`SiteSetting`.`key` LIKE 'Session%'))	12	12	0
SELECT `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` WHERE `is_active` = '1' ORDER BY `weight` asc	1	1	0
SELECT `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` WHERE `is_active` = '1' AND `code` = 'ja' ORDER BY `weight` asc LIMIT 1	1	1	0
SELECT `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` WHERE `key` = 'bbses' AND `language_id` = 2 LIMIT 1	1	1	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Security.enable_allow_system_plugin_ips%'	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`id` = 49 LIMIT 1	1	1	1
SELECT `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Box`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Box`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Box`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Box`.`id` = 186 LIMIT 1	1	1	0
SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured`, `PageContainer`.`created_user`, `PageContainer`.`created`, `PageContainer`.`modified_user`, `PageContainer`.`modified`, `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_page_containers` AS `PageContainer` ON (`BoxesPageContainer`.`page_container_id` = `PageContainer`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` ON (`BoxesPageContainer`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) WHERE `BoxesPageContainer`.`box_id` = 186 AND `BoxesPageContainer`.`page_id` = 19 AND `BoxesPageContainer`.`container_type` = 3 LIMIT 1	1	1	0
SELECT `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Block`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Block`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Block`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Block`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Block`.`id` = 33 LIMIT 1	1	1	1
SELECT `Space`.`id`, `Space`.`room_id_root` FROM `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` WHERE 1 = 1	4	4	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`room_id` = 1 AND NOT (`Page`.`parent_id` IS NULL) ORDER BY `Page`.`lft` asc LIMIT 1	1	1	0
SELECT `DefaultRolePermission`.`id`, `DefaultRolePermission`.`role_key`, `DefaultRolePermission`.`type`, `DefaultRolePermission`.`permission`, `DefaultRolePermission`.`value`, `DefaultRolePermission`.`fixed`, `DefaultRolePermission`.`created_user`, `DefaultRolePermission`.`created`, `DefaultRolePermission`.`modified_user`, `DefaultRolePermission`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_default_role_permissions` AS `DefaultRolePermission` WHERE `role_key` = 'visitor'	16	16	0
SELECT `PluginsRoom`.`id`, `PluginsRoom`.`room_id`, `PluginsRoom`.`plugin_key`, `PluginsRoom`.`created_user`, `PluginsRoom`.`created`, `PluginsRoom`.`modified_user`, `PluginsRoom`.`modified`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_plugins_rooms` AS `PluginsRoom` inner JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`PluginsRoom`.`plugin_key` = `Plugin`.`key` AND `Plugin`.`language_id` = 2) inner JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`PluginsRoom`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`PluginsRoom`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`PluginsRoom`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Plugin`.`type` = 1 AND `Room`.`id` = 15 ORDER BY `PluginsRoom`.`id` ASC	22	22	2	maybe slow
SELECT `BlockSetting`.`field_name`, `BlockSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_block_settings` AS `BlockSetting` WHERE `block_key` = '7aeadc829848fb87719612b943ee17ee' AND `field_name` IN ('use_workflow', 'use_comment_approval')	2	2	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Security.enable_bad_ips%'	1	1	1
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Security.deny_ip_move%'	1	1	0
SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 19 LIMIT 1	1	1	1
SELECT `Page`.`id` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 14 AND `Page`.`rght` >= 15 ORDER BY `Page`.`lft` asc	2	2	1	maybe slow
SELECT `Page`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `id` IN (1, 19) AND `theme` IS NOT NULL ORDER BY `lft` desc LIMIT 1	0	0	1	maybe slow
SELECT `Room`.`lft`, `Room`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `Room`.`id` = 15 LIMIT 1	1	1	1
SELECT `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE 1 = 1 AND `Room`.`lft` <= 11 AND `Room`.`rght` >= 12 ORDER BY `Room`.`lft` asc	3	3	1	maybe slow
SELECT `Room`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `id` IN (4, 1, 15) AND `theme` IS NOT NULL ORDER BY `lft` desc LIMIT 1	1	1	1
SELECT `Bbs`.`id`, `Bbs`.`key`, `Bbs`.`block_id`, `Bbs`.`language_id`, `Bbs`.`is_origin`, `Bbs`.`is_translation`, `Bbs`.`is_original_copy`, `Bbs`.`name`, `Bbs`.`bbs_article_modified`, `Bbs`.`created_user`, `Bbs`.`created`, `Bbs`.`modified_user`, `Bbs`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_bbses` AS `Bbs` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Bbs`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Bbs`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Bbs`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Block`.`id` = 33 AND `Block`.`room_id` = 15 AND ((`Bbs`.`is_translation` = '0') OR (`Bbs`.`language_id` = 2)) LIMIT 1	1	1	0
SELECT `BlockSetting`.`id`, `BlockSetting`.`plugin_key`, `BlockSetting`.`room_id`, `BlockSetting`.`block_key`, `BlockSetting`.`field_name`, `BlockSetting`.`value`, `BlockSetting`.`type`, `BlockSetting`.`created_user`, `BlockSetting`.`created`, `BlockSetting`.`modified_user`, `BlockSetting`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_block_settings` AS `BlockSetting` WHERE `plugin_key` = 'bbses' AND `room_id` = 15 AND `block_key` = '7aeadc829848fb87719612b943ee17ee' AND `field_name` IN ('use_like', 'use_unlike', 'use_comment', 'use_workflow', 'use_comment_approval')	5	5	1	maybe slow
SELECT `BbsFrameSetting`.`id`, `BbsFrameSetting`.`frame_key`, `BbsFrameSetting`.`display_type`, `BbsFrameSetting`.`articles_per_page`, `BbsFrameSetting`.`created_user`, `BbsFrameSetting`.`created`, `BbsFrameSetting`.`modified_user`, `BbsFrameSetting`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_bbs_frame_settings` AS `BbsFrameSetting` WHERE `frame_key` = '0ac44c1de9288410c29c140ac0bae21c' LIMIT 1	1	1	0
SELECT `Room`.`space_id`, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `space_id` = 1	1	1	0
SELECT `Room`.`space_id`, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` WHERE `parent_id` = 4	3	3	0
SELECT `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Room`.`parent_id` = 4 ORDER BY `Room`.`lft` ASC	3	3	1	maybe slow
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 2, 3)	6	6	0
SELECT * FROM `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` INNER JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoomsUser`.`user_id` IS NULL) WHERE `RolesRoom`.`room_id` IN (1, 2)	0	0	0
SELECT `BbsArticle`.`id`, `BbsArticle`.`bbs_key`, `BbsArticle`.`block_id`, `BbsArticle`.`language_id`, `BbsArticle`.`status`, `BbsArticle`.`is_active`, `BbsArticle`.`is_latest`, `BbsArticle`.`is_origin`, `BbsArticle`.`is_translation`, `BbsArticle`.`is_original_copy`, `BbsArticle`.`key`, `BbsArticle`.`title`, `BbsArticle`.`title_icon`, `BbsArticle`.`content`, `BbsArticle`.`created_user`, `BbsArticle`.`created`, `BbsArticle`.`modified_user`, `BbsArticle`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Like`.`id`, `Like`.`plugin_key`, `Like`.`block_key`, `Like`.`content_key`, `Like`.`like_count`, `Like`.`unlike_count`, `Like`.`weight`, `Like`.`created_user`, `Like`.`created`, `Like`.`modified_user`, `Like`.`modified`, `LikesUser`.`id`, `LikesUser`.`like_id`, `LikesUser`.`user_id`, `LikesUser`.`session_key`, `LikesUser`.`is_liked`, `LikesUser`.`created_user`, `LikesUser`.`created`, `LikesUser`.`modified_user`, `LikesUser`.`modified`, `BbsArticleTree`.`id`, `BbsArticleTree`.`bbs_key`, `BbsArticleTree`.`bbs_article_key`, `BbsArticleTree`.`root_id`, `BbsArticleTree`.`parent_id`, `BbsArticleTree`.`lft`, `BbsArticleTree`.`rght`, `BbsArticleTree`.`article_no`, `BbsArticleTree`.`bbs_article_child_count`, `BbsArticleTree`.`created_user`, `BbsArticleTree`.`created`, `BbsArticleTree`.`modified_user`, `BbsArticleTree`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_bbs_articles` AS `BbsArticle` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`BbsArticle`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BbsArticle`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BbsArticle`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_likes` AS `Like` ON (`Like`.`plugin_key` = 'bbses' AND `BbsArticle`.`key` = `Like`.`content_key`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_likes_users` AS `LikesUser` ON (`Like`.`id` = `LikesUser`.`like_id` AND `LikesUser`.`session_key` = '08prvd35b8v64297vdj1q8k4r2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_bbs_article_trees` AS `BbsArticleTree` ON (`BbsArticle`.`key` = `BbsArticleTree`.`bbs_article_key` AND ((`BbsArticle`.`language_id` = 2) OR (`BbsArticle`.`is_translation` = '0'))) WHERE `BbsArticle`.`is_origin` = '1' AND `BbsArticle`.`is_active` = '1' AND `BbsArticleTree`.`parent_id` IS NULL AND `BbsArticle`.`bbs_key` = 'd71459b33aecd3984078360a58fa048e' ORDER BY `BbsArticle`.`created` asc LIMIT 10	0	0	1	maybe slow
SELECT `BbsArticleTree`.`root_id`, COUNT(*) AS bbs_article_child_count FROM `LAA0857082-chibagakudo`.`nc3_bbs_articles` AS `BbsArticle` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`BbsArticle`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BbsArticle`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BbsArticle`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_likes` AS `Like` ON (`Like`.`plugin_key` = 'bbses' AND `BbsArticle`.`key` = `Like`.`content_key`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_likes_users` AS `LikesUser` ON (`Like`.`id` = `LikesUser`.`like_id` AND `LikesUser`.`session_key` = '08prvd35b8v64297vdj1q8k4r2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_bbs_article_trees` AS `BbsArticleTree` ON (`BbsArticle`.`key` = `BbsArticleTree`.`bbs_article_key` AND ((`BbsArticle`.`language_id` = 2) OR (`BbsArticle`.`is_translation` = '0'))) WHERE `BbsArticle`.`is_origin` = '1' AND `BbsArticle`.`is_active` = '1' AND `BbsArticleTree`.`root_id` IS NULL AND `BbsArticleTree`.`bbs_key` = 'd71459b33aecd3984078360a58fa048e' GROUP BY `BbsArticleTree`.`root_id`	0	0	1	maybe slow
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `ParentPage`.`id`, `ParentPage`.`room_id`, `ParentPage`.`root_id`, `ParentPage`.`parent_id`, `ParentPage`.`lft`, `ParentPage`.`rght`, `ParentPage`.`permalink`, `ParentPage`.`slug`, `ParentPage`.`is_container_fluid`, `ParentPage`.`theme`, `ParentPage`.`created_user`, `ParentPage`.`created`, `ParentPage`.`modified_user`, `ParentPage`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`permalink` = 'event' AND `Room`.`space_id` = 2 LIMIT 1	1	1	1
SELECT `PagesLanguage`.`id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`is_origin`, `PagesLanguage`.`is_translation`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `PagesLanguage`.`meta_title`, `PagesLanguage`.`meta_description`, `PagesLanguage`.`meta_keywords`, `PagesLanguage`.`meta_robots`, `PagesLanguage`.`created_user`, `PagesLanguage`.`created`, `PagesLanguage`.`modified_user`, `PagesLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` WHERE `PagesLanguage`.`page_id` = 19 AND `PagesLanguage`.`language_id` = 2 LIMIT 1	1	1	0
SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured`, `PageContainer`.`created_user`, `PageContainer`.`created`, `PageContainer`.`modified_user`, `PageContainer`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` = 19 ORDER BY `container_type` asc	5	5	0
SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 91 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 17 ORDER BY `Frame`.`weight` ASC	0	0	1	maybe slow
SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 92 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 18 ORDER BY `Frame`.`weight` ASC	1	1	1
SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 93 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 186 ORDER BY `Frame`.`weight` ASC	5	5	1	maybe slow
SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 94 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 19 ORDER BY `Frame`.`weight` ASC	0	0	1	maybe slow
SELECT `BoxesPageContainer`.`id`, `BoxesPageContainer`.`page_container_id`, `BoxesPageContainer`.`page_id`, `BoxesPageContainer`.`container_type`, `BoxesPageContainer`.`box_id`, `BoxesPageContainer`.`is_published`, `BoxesPageContainer`.`weight`, `BoxesPageContainer`.`created_user`, `BoxesPageContainer`.`created`, `BoxesPageContainer`.`modified_user`, `BoxesPageContainer`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `RoomsLanguage`.`id`, `RoomsLanguage`.`name` FROM `LAA0857082-chibagakudo`.`nc3_boxes_page_containers` AS `BoxesPageContainer` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`BoxesPageContainer`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`BoxesPageContainer`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`BoxesPageContainer`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Room`.`id` = `Box`.`room_id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`RoomsLanguage`.`room_id` = `Box`.`room_id` AND `RoomsLanguage`.`language_id` = 2) WHERE `BoxesPageContainer`.`page_container_id` = 95 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`is_deleted` = '0' AND `Frame`.`box_id` = 20 ORDER BY `Frame`.`weight` ASC	0	0	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.description%'	2	2	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.keywords%'	2	2	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.robots%'	1	1	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.copyright%'	2	2	0
SELECT `SiteSetting`.`language_id`, `SiteSetting`.`key`, `SiteSetting`.`value` FROM `LAA0857082-chibagakudo`.`nc3_site_settings` AS `SiteSetting` WHERE `SiteSetting`.`key` LIKE 'Meta.author%'	2	2	0
SELECT `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` WHERE `key` = 'menus' AND `language_id` = 2 LIMIT 1	1	1	0
SELECT `Frame`.`id`, `Frame`.`room_id`, `Frame`.`box_id`, `Frame`.`plugin_key`, `Frame`.`block_id`, `Frame`.`key`, `Frame`.`header_type`, `Frame`.`weight`, `Frame`.`is_deleted`, `Frame`.`default_action`, `Frame`.`default_setting_action`, `Frame`.`created_user`, `Frame`.`created`, `Frame`.`modified_user`, `Frame`.`modified`, `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Block`.`id`, `Block`.`room_id`, `Block`.`plugin_key`, `Block`.`key`, `Block`.`public_type`, `Block`.`publish_start`, `Block`.`publish_end`, `Block`.`content_count`, `Block`.`created_user`, `Block`.`created`, `Block`.`modified_user`, `Block`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Plugin`.`id`, `Plugin`.`language_id`, `Plugin`.`is_origin`, `Plugin`.`is_translation`, `Plugin`.`is_original_copy`, `Plugin`.`key`, `Plugin`.`is_m17n`, `Plugin`.`name`, `Plugin`.`namespace`, `Plugin`.`weight`, `Plugin`.`type`, `Plugin`.`version`, `Plugin`.`commit_version`, `Plugin`.`commited`, `Plugin`.`default_action`, `Plugin`.`default_setting_action`, `Plugin`.`frame_add_action`, `Plugin`.`display_topics`, `Plugin`.`display_search`, `Plugin`.`serialize_data`, `Plugin`.`created_user`, `Plugin`.`created`, `Plugin`.`modified_user`, `Plugin`.`modified`, `FramePublicLanguage`.`id`, `FramePublicLanguage`.`language_id`, `FramePublicLanguage`.`frame_id`, `FramePublicLanguage`.`is_public`, `FramesLanguage`.`id`, `FramesLanguage`.`language_id`, `FramesLanguage`.`frame_id`, `FramesLanguage`.`name`, `FramesLanguage`.`is_origin`, `FramesLanguage`.`is_translation`, `FramesLanguage`.`is_original_copy`, `BlocksLanguage`.`language_id`, `BlocksLanguage`.`block_id`, `BlocksLanguage`.`name`, `BlocksLanguage`.`is_origin`, `BlocksLanguage`.`is_translation`, `BlocksLanguage`.`is_original_copy` FROM `LAA0857082-chibagakudo`.`nc3_frames` AS `Frame` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` ON (`Frame`.`box_id` = `Box`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks` AS `Block` ON (`Frame`.`block_id` = `Block`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Frame`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Frame`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Frame`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_plugins` AS `Plugin` ON (`Plugin`.`key` = `Frame`.`plugin_key` AND `Plugin`.`language_id` = 2) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frame_public_languages` AS `FramePublicLanguage` ON (`FramePublicLanguage`.`frame_id` = `Frame`.`id` AND `FramePublicLanguage`.`language_id` IN (0, 2) AND `FramePublicLanguage`.`is_public` = '1') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_frames_languages` AS `FramesLanguage` ON (`FramesLanguage`.`frame_id` = `Frame`.`id` AND ((`FramesLanguage`.`is_translation` = '0') OR (`FramesLanguage`.`language_id` = 2))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_blocks_languages` AS `BlocksLanguage` ON (`BlocksLanguage`.`block_id` = `Block`.`id` AND ((`BlocksLanguage`.`is_translation` = '0') OR (`BlocksLanguage`.`language_id` = 2))) WHERE `Frame`.`id` = 2 LIMIT 1	1	1	1
SELECT `Box`.`id`, `Box`.`container_id`, `Box`.`type`, `Box`.`space_id`, `Box`.`room_id`, `Box`.`page_id`, `Box`.`container_type`, `Box`.`weight`, `Box`.`created_user`, `Box`.`created`, `Box`.`modified_user`, `Box`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename` FROM `LAA0857082-chibagakudo`.`nc3_boxes` AS `Box` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Box`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Box`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Box`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Box`.`modified_user` = `TrackableUpdater`.`id`) WHERE `Box`.`id` = 18 LIMIT 1	1	1	0
SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 19 LIMIT 1	1	1	0
SELECT `Page`.`id` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 14 AND `Page`.`rght` >= 15 ORDER BY `Page`.`lft` asc	2	2	0
SELECT `Page`.`theme` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `id` IN (1, 19) AND `theme` IS NOT NULL ORDER BY `lft` desc LIMIT 1	0	0	0
SELECT `Room`., `RolesRoom`., `RolesRoomsUser`.*, `Room`.`id` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Room`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Room`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `ParentRoom` ON (`Room`.`parent_id` = `ParentRoom`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms_users` AS `RolesRoomsUser` ON (`RolesRoomsUser`.`room_id` = Room .id AND `RolesRoomsUser`.`user_id` IS NULL) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_roles_rooms` AS `RolesRoom` ON (`RolesRoomsUser`.`roles_room_id` = RolesRoom .id AND `RolesRoom`.`room_id` = Room .id) WHERE `Room`.`space_id` = (2) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`active` = '1' AND `Room`.`in_draft` = '0' ORDER BY `Room`.`lft` ASC	6	6	0
SELECT `RoomsLanguage`.`id`, `RoomsLanguage`.`language_id`, `RoomsLanguage`.`is_origin`, `RoomsLanguage`.`is_translation`, `RoomsLanguage`.`is_original_copy`, `RoomsLanguage`.`room_id`, `RoomsLanguage`.`name`, `RoomsLanguage`.`created_user`, `RoomsLanguage`.`created`, `RoomsLanguage`.`modified_user`, `RoomsLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` WHERE `RoomsLanguage`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	0
SELECT `ChildRoom`.`id`, `ChildRoom`.`space_id`, `ChildRoom`.`page_id_top`, `ChildRoom`.`parent_id`, `ChildRoom`.`lft`, `ChildRoom`.`rght`, `ChildRoom`.`active`, `ChildRoom`.`in_draft`, `ChildRoom`.`default_role_key`, `ChildRoom`.`need_approval`, `ChildRoom`.`default_participation`, `ChildRoom`.`page_layout_permitted`, `ChildRoom`.`theme`, `ChildRoom`.`created_user`, `ChildRoom`.`created`, `ChildRoom`.`modified_user`, `ChildRoom`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `ChildRoom` WHERE `ChildRoom`.`parent_id` IN (1, 7, 9, 10, 11, 15)	5	5	0
SELECT `Page`., `PagesLanguage`., `MenuFramesPage`.* FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` ON (`Page`.`id` = PagesLanguage .page_id) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_menu_frames_pages` AS `MenuFramesPage` ON (`Page`.`id` = MenuFramesPage .page_id AND `MenuFramesPage`.`frame_key` = 'frame_2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = '2') WHERE `Page`.`room_id` IN (1, 7, 9, 10, 11, 15) AND ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`id` = PagesLanguage .page_id ORDER BY `Page`.`lft` asc	7	7	0
SELECT `MenuFrameSetting`.`id`, `MenuFrameSetting`.`frame_key`, `MenuFrameSetting`.`display_type`, `MenuFrameSetting`.`is_private_room_hidden`, `MenuFrameSetting`.`created_user`, `MenuFrameSetting`.`created`, `MenuFrameSetting`.`modified_user`, `MenuFrameSetting`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_menu_frame_settings` AS `MenuFrameSetting` WHERE `frame_key` = 'frame_2' LIMIT 1	1	1	0
SELECT `Room`., `RoomsLanguage`., `MenuFramesRoom`.* FROM `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` INNER JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) INNER JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `RoomsLanguage` ON (`Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = '2') OR (`Space`.`is_m17n` = '0'))) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_menu_frames_rooms` AS `MenuFramesRoom` ON (`Room`.`id` = MenuFramesRoom .room_id AND `MenuFramesRoom`.`frame_key` = 'frame_2') LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms_languages` AS `OriginRoomsLanguage` ON (`RoomsLanguage`.`room_id` = `OriginRoomsLanguage`.`room_id` AND `OriginRoomsLanguage`.`language_id` = '2') WHERE `Room`.`id` IN (1, 7, 9, 10, 11, 15) AND NOT (`Room`.`page_id_top` IS NULL) AND `Room`.`id` = RoomsLanguage .room_id AND ((`RoomsLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`RoomsLanguage`.`id` = `OriginRoomsLanguage`.`id`) OR (`OriginRoomsLanguage`.`id` IS NULL)))))) ORDER BY `Room`.`lft` asc	6	6	0
SELECT `PagesLanguage`.`id`, `PagesLanguage`.`language_id`, `PagesLanguage`.`is_origin`, `PagesLanguage`.`is_translation`, `PagesLanguage`.`page_id`, `PagesLanguage`.`name`, `PagesLanguage`.`meta_title`, `PagesLanguage`.`meta_description`, `PagesLanguage`.`meta_keywords`, `PagesLanguage`.`meta_robots`, `PagesLanguage`.`created_user`, `PagesLanguage`.`created`, `PagesLanguage`.`modified_user`, `PagesLanguage`.`modified`, `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Language`.`id`, `Language`.`code`, `Language`.`weight`, `Language`.`is_active`, `Language`.`created_user`, `Language`.`created`, `Language`.`modified_user`, `Language`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified`, `OriginPagesLanguage`.`id`, `OriginPagesLanguage`.`language_id`, `OriginPagesLanguage`.`is_origin`, `OriginPagesLanguage`.`is_translation`, `OriginPagesLanguage`.`page_id`, `OriginPagesLanguage`.`name`, `OriginPagesLanguage`.`meta_title`, `OriginPagesLanguage`.`meta_description`, `OriginPagesLanguage`.`meta_keywords`, `OriginPagesLanguage`.`meta_robots`, `OriginPagesLanguage`.`created_user`, `OriginPagesLanguage`.`created`, `OriginPagesLanguage`.`modified_user`, `OriginPagesLanguage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_languages` AS `Language` ON (`PagesLanguage`.`language_id` = `Language`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`PagesLanguage`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`PagesLanguage`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `Page`.`room_id` IN (1, 7, 9, 10, 11, 15)	7	7	1	maybe slow
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Room`.`id`, `Room`.`space_id`, `Room`.`page_id_top`, `Room`.`parent_id`, `Room`.`lft`, `Room`.`rght`, `Room`.`active`, `Room`.`in_draft`, `Room`.`default_role_key`, `Room`.`need_approval`, `Room`.`default_participation`, `Room`.`page_layout_permitted`, `Room`.`theme`, `Room`.`created_user`, `Room`.`created`, `Room`.`modified_user`, `Room`.`modified`, `ParentPage`.`id`, `ParentPage`.`room_id`, `ParentPage`.`root_id`, `ParentPage`.`parent_id`, `ParentPage`.`lft`, `ParentPage`.`rght`, `ParentPage`.`permalink`, `ParentPage`.`slug`, `ParentPage`.`is_container_fluid`, `ParentPage`.`theme`, `ParentPage`.`created_user`, `ParentPage`.`created`, `ParentPage`.`modified_user`, `ParentPage`.`modified`, `TrackableCreator`.`id`, `TrackableCreator`.`handlename`, `TrackableUpdater`.`id`, `TrackableUpdater`.`handlename`, `Space`.`id`, `Space`.`parent_id`, `Space`.`lft`, `Space`.`rght`, `Space`.`type`, `Space`.`plugin_key`, `Space`.`default_setting_action`, `Space`.`room_disk_size`, `Space`.`room_id_root`, `Space`.`page_id_top`, `Space`.`permalink`, `Space`.`is_m17n`, `Space`.`after_user_save_model`, `Space`.`created_user`, `Space`.`created`, `Space`.`modified_user`, `Space`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) WHERE `Page`.`id` IN (1, 4, 7, 13, 14, 15, 19)	7	7	0
SELECT `ChildPage`.`id`, `ChildPage`.`room_id`, `ChildPage`.`root_id`, `ChildPage`.`parent_id`, `ChildPage`.`lft`, `ChildPage`.`rght`, `ChildPage`.`permalink`, `ChildPage`.`slug`, `ChildPage`.`is_container_fluid`, `ChildPage`.`theme`, `ChildPage`.`created_user`, `ChildPage`.`created`, `ChildPage`.`modified_user`, `ChildPage`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (7, 19, 13, 14, 15, 1, 4)	6	6	0
SELECT `PageContainer`.`id`, `PageContainer`.`page_id`, `PageContainer`.`container_type`, `PageContainer`.`is_published`, `PageContainer`.`is_configured`, `PageContainer`.`created_user`, `PageContainer`.`created`, `PageContainer`.`modified_user`, `PageContainer`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_page_containers` AS `PageContainer` WHERE `PageContainer`.`page_id` IN (7, 19, 13, 14, 15, 1, 4)	35	35	0
SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 19 LIMIT 1	1	1	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 14 AND `Page`.`rght` >= 15 ORDER BY `Page`.`lft` asc	2	2	0
SELECT COUNT(*) AS `count` FROM `LAA0857082-chibagakudo`.`nc3_menu_frames_rooms` AS `MenuFramesRoom` WHERE `MenuFramesRoom`.`frame_key` = 'frame_2'	1	1	0
SELECT COUNT(*) AS `count` FROM `LAA0857082-chibagakudo`.`nc3_menu_frames_pages` AS `MenuFramesPage` WHERE `MenuFramesPage`.`frame_key` = 'frame_2'	1	1	0
SELECT `Page`.`id`, `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` LEFT JOIN `LAA0857082-chibagakudo`.`nc3_rooms` AS `Room` ON (`Page`.`room_id` = `Room`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableCreator` ON (`Page`.`created_user` = `TrackableCreator`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_users` AS `TrackableUpdater` ON (`Page`.`modified_user` = `TrackableUpdater`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_spaces` AS `Space` ON (`Room`.`space_id` = `Space`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `PagesLanguage` ON (`PagesLanguage`.`page_id` = `Page`.`id`) LEFT JOIN `LAA0857082-chibagakudo`.`nc3_pages_languages` AS `OriginPagesLanguage` ON (`PagesLanguage`.`page_id` = `OriginPagesLanguage`.`page_id` AND `OriginPagesLanguage`.`language_id` = 2) WHERE ((`PagesLanguage`.`language_id` = 2) OR (((`Space`.`is_m17n` = '0') AND (((`PagesLanguage`.`id` = `OriginPagesLanguage`.`id`) OR (`OriginPagesLanguage`.`id` IS NULL)))))) AND `PagesLanguage`.`page_id` = `Page`.`id` AND `Page`.`room_id` IN (1, 7, 9, 10, 11, 15) AND 1 = 1 ORDER BY `Page`.`lft` asc	7	7	0
SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 19 LIMIT 1	1	1	0
SELECT `Page`.`id`, `Page`.`room_id`, `Page`.`root_id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`permalink`, `Page`.`slug`, `Page`.`is_container_fluid`, `Page`.`theme`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE 1 = 1 AND `Page`.`lft` <= 14 AND `Page`.`rght` >= 15 ORDER BY `Page`.`lft` asc	2	2	0

6 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 19.85 MB

Message	Memory use
Component initialization	7.03 MB
Controller action start	10.27 MB
Controller render start	10.57 MB
Component initialization #2	12.96 MB
Controller action start #2	13.21 MB
Controller render start #2	13.65 MB
View render complete	13.78 MB

Timers

Total Request Time: 759 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	267.24
Event: Controller.initialize	149.36
Event: Controller.startup	6.96
Controller action	26.09
Event: Controller.beforeRender	80.05
» Processing toolbar data	52.24
Rendering View	101.23
» Event: View.beforeRender	0.63
» Rendering APP/Plugin/Bbses/View/BbsArticles/index.ctp	5.76
» » Rendering APP/Plugin/NetCommons/View/Elements/limit_dropdown_toggle.ctp	1.32
» Event: View.afterRender	1.45
» » Rendering APP/Plugin/Frames/View/Elements/frame.ctp	0.83
» » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp	0.33
» Event: View.beforeLayout	84.91
» » Rendering APP/Plugin/Pages/View/Elements/page_major.ctp	84.63
» » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp	84.31
» » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp	84.06
» » » » » Event: Controller.initialize #2	14.19
» » » » » Event: Controller.startup #2	0.57
» » » » » Controller action #2	33.94
» » » » » Event: Controller.beforeRender #2	24.12
» » » » » » Processing toolbar data #2	23.76
Rendering View #2	0.00
» » » » » » Event: View.beforeRender #2	0.53
» » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp #2	3.85
» » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/index.ctp #3	3.55
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp	0.47
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #2	0.22
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #3	0.21
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #4	0.21
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #5	0.22
» » » » » » Event: View.afterRender #2	1.29
» » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2	0.52
» » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2	0.34
» » » » » » Event: Controller.shutdown	0.09
» » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3	0.32
» » Rendering APP/Plugin/Pages/View/Layouts/default.ctp	5.41
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp	0.76
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp	0.31
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp	0.64
» » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp	0.38
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp	1.41
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp	0.16
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- bbsArticles(empty)
- treeLists(empty)
- curretDirectionasc
- curretSortBbsArticle.created
- options(array)
  BbsArticle.created.desc(array)
  label最新の投稿順
  sortBbsArticle.created
  directiondesc
  BbsArticle.created.asc(array)
  label古い投稿順
  sortBbsArticle.created
  directionasc
  BbsArticleTree.bbs_article_child_count.desc(array)
  labelコメントの多い順
  sortBbsArticleTree.bbs_article_child_count
  directiondesc
- bbsFrameSetting(array)
  id3
  frame_key0ac44c1de9288410c29c140ac0bae21c
  display_typeflat
  articles_per_page10
  created_user5
  created2018-07-01 04:55:05
  modified_user5
  modified2018-07-01 04:55:05
- bbsSetting(array)
  use_comment0
  use_comment_approval0
  use_like1
  use_unlike0
  use_workflow0
- bbs(array)
  id3
  keyd71459b33aecd3984078360a58fa048e
  block_id33
  language_id2
  is_origin(true)
  is_translation(false)
  is_original_copy(false)
  name特別研修房総地域君津市にて研修
  bbs_article_modified(null)
  created_user5
  created2018-07-01 04:55:05
  modified_user5
  modified2018-07-01 04:55:05
- hasSwitchLang(false)
- switchLanguages(array)
  0(array)
  Language(array)
  id2
  codeja
  weight1
  is_active(true)
  created_user(null)
  created2017-05-07 08:12:29
  modified_user(null)
  modified2017-05-07 08:12:29
- $request->data(empty)
- $this->validationErrors(array)
  Page(empty)
  Space(empty)
  Room(empty)
  RolesRoomsUser(empty)
  RolesRoom(empty)
  RoomsLanguage(empty)
  ParentPage(empty)
  TrackableCreator(empty)
  UploadFile(empty)
  UploadFilesContent(empty)
  TrackableUpdater(empty)
  SiteSetting(empty)
  Language(empty)
  Plugin(empty)
  PluginsRole(empty)
  Frame(empty)
  Block(empty)
  BlocksLanguage(empty)
  Box(empty)
  FramePublicLanguage(empty)
  FramesLanguage(empty)
  BoxesPageContainer(empty)
  PageContainer(empty)
  DefaultRolePermission(empty)
  RoomRolePermission(empty)
  PluginsRoom(empty)
  BlockRolePermission(empty)
  BlockSetting(empty)
  Bbs(empty)
  BbsArticle(empty)
  MailSetting(empty)
  MailQueue(empty)
  MailQueueUser(empty)
  BbsArticleTree(empty)
  BbsFrameSetting(empty)
  BbsSetting(empty)
  Like(empty)
  LikesUser(empty)
  PagesLanguage(empty)
- Loaded Helpers(array)
  0Html
  1M17n
  2BackTo
  3Button
  4LinkButton
  5Date
  6MessageFlash
  7NetCommonsForm
  8NetCommonsHtml
  9BbsesForm
  10Like
  11DisplayNumber
  12Workflow
  13Number
  14SimpleGraph
  15DisplayUser
  16Paginator
  17DebugTimer
  18Toolbar
  19PageLayout
  20Composer
  21Blocks
  22Boxes
  23Frames
  24html
  25Flash
  26Session
  27HtmlToolbar
  28Form
====

Environment

App Constants

Constant	Value
CONFIG	/home/users/2/hiho.jp-chibagakudo/web/app/Config/
HTMLPURIFIER_PREFIX	/home/users/2/hiho.jp-chibagakudo/web/vendors/ezyang/htmlpurifier/library

CakePHP Constants

Constant	Value
APP	/home/users/2/hiho.jp-chibagakudo/web/app/
APP_DIR	app
APPLIBS	/home/users/2/hiho.jp-chibagakudo/web/app/Lib/
CACHE	/home/users/2/hiho.jp-chibagakudo/web/app/tmp/cache/
CAKE	/home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib
CORE_PATH	/home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/
CAKE_VERSION	2.10.5
CSS	/home/users/2/hiho.jp-chibagakudo/web/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://chibagakudo.hiho.jp
IMAGES	/home/users/2/hiho.jp-chibagakudo/web/app/webroot/img/
IMAGES_URL	img/
JS	/home/users/2/hiho.jp-chibagakudo/web/app/webroot/js/
JS_URL	js/
LOGS	/home/users/2/hiho.jp-chibagakudo/web/app/tmp/logs/
ROOT	/home/users/2/hiho.jp-chibagakudo/web
TESTS	/home/users/2/hiho.jp-chibagakudo/web/app/Test/
TMP	/home/users/2/hiho.jp-chibagakudo/web/app/tmp/
VENDORS	/home/users/2/hiho.jp-chibagakudo/web/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/users/2/hiho.jp-chibagakudo/web/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.1.5
Redirect Redirect Unique Id	XL0RTZ0HalUAAAQcqVYAAAD4
Redirect Redirect Mef Proxy Addr	172.19.45.84
Redirect Redirect Nss Sdb Use Cache	YES
Redirect Redirect Status	200
Redirect Unique Id	XL0RTZ0HalUAAAQcqVYAAAD4
Redirect Mef Proxy Addr	172.19.45.84
Redirect Nss Sdb Use Cache	YES
Redirect Status	200
Unique Id	XL0RTZ0HalUAAAQcqVYAAAD4
Mef Proxy Addr	172.19.45.84
Nss Sdb Use Cache	YES
Http Host	chibagakudo.hiho.jp
Http X Forwarded Host	chibagakudo.hiho.jp
Http X Forwarded For	18.234.111.56
Http X Forwarded Proto	http
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http If Modified Since	Tue, 19 Feb 2019 01:27:50 GMT
Http Accept Encoding	gzip
Path	/sbin:/usr/sbin:/bin:/usr/bin
Server Signature
Server Software	Apache
Server Name	chibagakudo.hiho.jp
Server Addr	172.19.46.85
Server Port	80
Remote Addr	18.234.111.56
Document Root	/home/users/2/hiho.jp-chibagakudo/web
Request Scheme	http
Context Prefix
Context Document Root	/home/users/2/hiho.jp-chibagakudo/web
Server Admin	https://lolipop.jp/support/
Script Filename	/home/users/2/hiho.jp-chibagakudo/web/app/webroot/index.php
Remote Port	33034
Redirect Query String	frame_id=49
Redirect Url	/app/webroot/bbses/bbs_articles/index/33/sort:BbsArticle.created/direction:asc
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String	frame_id=49
Request Uri	/bbses/bbs_articles/index/33/sort:BbsArticle.created/direction:asc?frame_id=49
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1555894605.343
Request Time	1555894605

====

Include
+
Included Files

Include Paths
- 1/usr/local/php/7.1/lib/php
- 2-> /home/users/2/hiho.jp-chibagakudo/web/vendors/cakephp/cakephp/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/TreeBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/FlashComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/SecurityComponent.php
  5CORE/Controller/Component/PaginatorComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/ConnectionManager.php
  2CORE/Model/BehaviorCollection.php
  3CORE/Model/ModelBehavior.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Router.php
  1CORE/Routing/Dispatcher.php
  2CORE/Routing/Filter/AssetDispatcher.php
  3CORE/Routing/DispatcherFilter.php
  4CORE/Routing/Filter/CacheDispatcher.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  6CORE/Utility/Set.php
  7CORE/Utility/Folder.php
  8CORE/Utility/Security.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/Controller/AppControllerNC.php
  Model(array)
  0APP/Model/AppModel.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  Auth(array)
  Config(array)
  0Auth/Config/routes.php
  Model(array)
  0Auth/Model/AutoUserRegist.php
  Bbses(array)
  Controller(array)
  0Bbses/Controller/BbsArticlesController.php
  1Bbses/Controller/BbsesAppController.php
  Model(array)
  0Bbses/Model/Bbs.php
  1Bbses/Model/BbsesAppModel.php
  2Bbses/Model/BbsArticle.php
  3Bbses/Model/BbsArticleTree.php
  4Bbses/Model/BbsFrameSetting.php
  5Bbses/Model/BbsSetting.php
  Behavior(array)
  0Bbses/Model/Behavior/BbsArticleBehavior.php
  Blocks(array)
  Model(array)
  0Blocks/Model/Block.php
  1Blocks/Model/BlocksAppModel.php
  2Blocks/Model/BlocksLanguage.php
  3Blocks/Model/BlockRolePermission.php
  4Blocks/Model/BlockSetting.php
  5Blocks/Model/BlockBaseModel.php
  Behavior(array)
  0Blocks/Model/Behavior/BlockSettingBehavior.php
  1Blocks/Model/Behavior/BlockBehavior.php
  2Blocks/Model/Behavior/BlockRolePermissionBehavior.php
  Boxes(array)
  Model(array)
  0Boxes/Model/Box.php
  1Boxes/Model/BoxesAppModel.php
  2Boxes/Model/BoxesPageContainer.php
  Calendars(array)
  Config(array)
  0Calendars/Config/routes.php
  DataTypes(array)
  Behavior(array)
  0DataTypes/Model/Behavior/TimezoneBehavior.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Files(array)
  Behavior(array)
  0Files/Model/Behavior/AttachmentBehavior.php
  1Files/Model/Behavior/UploadFileValidateBehavior.php
  2Files/Model/Behavior/UploadValidatorWrapBehavior.php
  Model(array)
  0Files/Model/UploadFile.php
  1Files/Model/FilesAppModel.php
  2Files/Model/UploadFilesContent.php
  Frames(array)
  Config(array)
  0Frames/Config/routes.php
  Model(array)
  0Frames/Model/Frame.php
  1Frames/Model/FramesAppModel.php
  2Frames/Model/FramePublicLanguage.php
  3Frames/Model/FramesLanguage.php
  Groups(array)
  Config(array)
  0Groups/Config/routes.php
  Holidays(array)
  Config(array)
  0Holidays/Config/routes.php
  Install(array)
  Config(array)
  0Install/Config/routes.php
  Likes(array)
  Behavior(array)
  0Likes/Model/Behavior/LikeBehavior.php
  Model(array)
  0Likes/Model/Like.php
  1Likes/Model/LikesAppModel.php
  2Likes/Model/LikesUser.php
  M17n(array)
  Behavior(array)
  0M17n/Model/Behavior/M17nBehavior.php
  1M17n/Model/Behavior/SaveM17nBehavior.php
  Model(array)
  0M17n/Model/Language.php
  1M17n/Model/M17nAppModel.php
  Mails(array)
  Behavior(array)
  0Mails/Model/Behavior/MailQueueBehavior.php
  Model(array)
  0Mails/Model/MailSettingFixedPhrase.php
  1Mails/Model/MailsAppModel.php
  2Mails/Model/MailSetting.php
  3Mails/Model/MailQueue.php
  4Mails/Model/MailQueueUser.php
  Menus(array)
  Config(array)
  0Menus/Config/routes.php
  MobileDetect(array)
  Component(array)
  0MobileDetect/Controller/Component/MobileDetectComponent.php
  NetCommons(array)
  Config(array)
  0NetCommons/Config/bootstrap.php
  1NetCommons/Config/routes.php
  Plugin(array)
  0NetCommons/Utility/Current.php
  1NetCommons/Utility/CurrentBase.php
  2NetCommons/Utility/NetCommonsTime.php
  3NetCommons/Utility/CurrentSystem.php
  4NetCommons/Utility/CurrentFrame.php
  5NetCommons/Utility/CurrentPage.php
  6NetCommons/Utility/NetCommonsSecurity.php
  Model(array)
  0NetCommons/Model/NetCommonsAppModel.php
  Behavior(array)
  0NetCommons/Model/Behavior/TrackableBehavior.php
  1NetCommons/Model/Behavior/NetCommonsValidationRuleBehavior.php
  2NetCommons/Model/Behavior/OriginalKeyBehavior.php
  Controller(array)
  0NetCommons/Controller/NetCommonsAppController.php
  Component(array)
  0NetCommons/Controller/Component/AccessCtrlComponent.php
  1NetCommons/Controller/Component/AssetComponent.php
  2NetCommons/Controller/Component/PermissionComponent.php
  3NetCommons/Controller/Component/NetCommonsComponent.php
  4NetCommons/Controller/Component/NetCommonsTimeComponent.php
  Pages(array)
  Config(array)
  0Pages/Config/routes.php
  Plugin(array)
  0Pages/Routing/Route/SlugRoute.php
  Model(array)
  0Pages/Model/Page.php
  1Pages/Model/PagesAppModel.php
  2Pages/Model/PageContainer.php
  Behavior(array)
  0Pages/Model/Behavior/PagesTreeBehavior.php
  1Pages/Model/Behavior/SavePageBehavior.php
  2Pages/Model/Behavior/GetPageBehavior.php
  3Pages/Model/Behavior/PageAssociationsBehavior.php
  Component(array)
  0Pages/Controller/Component/PageLayoutComponent.php
  PluginManager(array)
  Model(array)
  0PluginManager/Model/Plugin.php
  1PluginManager/Model/PluginsRole.php
  2PluginManager/Model/PluginsRoom.php
  Behavior(array)
  0PluginManager/Model/Behavior/PluginBehavior.php
  1PluginManager/Model/Behavior/PluginBowerBehavior.php
  2PluginManager/Model/Behavior/PluginComposerBehavior.php
  3PluginManager/Model/Behavior/PluginThemeBehavior.php
  4PluginManager/Model/Behavior/PluginsRoomBehavior.php
  PrivateSpace(array)
  Behavior(array)
  0PrivateSpace/Model/Behavior/PrivateSpaceBehavior.php
  PublicSpace(array)
  Component(array)
  0PublicSpace/Controller/Component/PublicSpaceComponent.php
  Questionnaires(array)
  Config(array)
  0Questionnaires/Config/routes.php
  Quizzes(array)
  Config(array)
  0Quizzes/Config/routes.php
  Registrations(array)
  Config(array)
  0Registrations/Config/routes.php
  Reservations(array)
  Config(array)
  0Reservations/Config/routes.php
  Roles(array)
  Model(array)
  0Roles/Model/Role.php
  1Roles/Model/RolesAppModel.php
  2Roles/Model/DefaultRolePermission.php
  Rooms(array)
  Config(array)
  0Rooms/Config/routes.php
  Model(array)
  0Rooms/Model/Space.php
  1Rooms/Model/RoomsAppModel.php
  2Rooms/Model/Room.php
  3Rooms/Model/RolesRoomsUser.php
  4Rooms/Model/RolesRoom.php
  5Rooms/Model/RoomsLanguage.php
  6Rooms/Model/RoomRolePermission.php
  Behavior(array)
  0Rooms/Model/Behavior/DeleteRoomAssociationsBehavior.php
  1Rooms/Model/Behavior/RoomBehavior.php
  2Rooms/Model/Behavior/SaveRoomAssociationsBehavior.php
  SiteManager(array)
  Config(array)
  0SiteManager/Config/routes.php
  Plugin(array)
  0SiteManager/Utility/SiteSettingUtil.php
  1SiteManager/Utility/SiteSettingUtilFunc.php
  Model(array)
  0SiteManager/Model/SiteSetting.php
  1SiteManager/Model/SiteManagerAppModel.php
  Behavior(array)
  0SiteManager/Model/Behavior/IpAddressManagerBehavior.php
  1SiteManager/Model/Behavior/SiteSettingValidateBehavior.php
  2SiteManager/Model/Behavior/SiteManagerValidateBehavior.php
  3SiteManager/Model/Behavior/SiteManagerSaveBehavior.php
  4SiteManager/Model/Behavior/SystemManagerValidateBehavior.php
  5SiteManager/Model/Behavior/SystemManagerSaveBehavior.php
  SystemManager(array)
  Config(array)
  0SystemManager/Config/routes.php
  ThemeSettings(array)
  Behavior(array)
  0ThemeSettings/Model/Behavior/ThemeBehavior.php
  Topics(array)
  Behavior(array)
  0Topics/Model/Behavior/TopicsBehavior.php
  1Topics/Model/Behavior/TopicsBaseBehavior.php
  Upload(array)
  Behavior(array)
  0Upload/Model/Behavior/UploadBehavior.php
  UserAttributes(array)
  Config(array)
  0UserAttributes/Config/routes.php
  UserManager(array)
  Config(array)
  0UserManager/Config/routes.php
  UserRoles(array)
  Config(array)
  0UserRoles/Config/routes.php
  Users(array)
  Config(array)
  0Users/Config/routes.php
  Model(array)
  0Users/Model/User.php
  1Users/Model/UsersAppModel.php
  Behavior(array)
  0Users/Model/Behavior/AvatarBehavior.php
  1Users/Model/Behavior/DeleteUserBehavior.php
  2Users/Model/Behavior/ImportExportBehavior.php
  3Users/Model/Behavior/UserPermissionBehavior.php
  4Users/Model/Behavior/UsersValidationRuleBehavior.php
  5Users/Model/Behavior/SaveUserBehavior.php
  VisualCaptcha(array)
  Config(array)
  0VisualCaptcha/Config/routes.php
  Workflow(array)
  Component(array)
  0Workflow/Controller/Component/WorkflowComponent.php
  Behavior(array)
  0Workflow/Model/Behavior/WorkflowCommentBehavior.php
  1Workflow/Model/Behavior/WorkflowBehavior.php
  Wysiwyg(array)
  Config(array)
  0Wysiwyg/Config/routes.php
  Behavior(array)
  0Wysiwyg/Model/Behavior/WysiwygBehavior.php
  1Wysiwyg/Model/Behavior/PurifiableBehavior.php
====

特別研修 房総地域 君津市にて研修

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

slave1

Total Time: 24 ms Total Queries: 76 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

特別研修房総地域君津市にて研修

Total Time: 24 ms
Total Queries: 76 queries