掲示板

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

記事がありません。

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent359d31d6737416e23d489d7c778cb8fe
  time1540057581
  countdown10
  languageja
- _Token(array)
  key8972567494c3346f16183c8d0d6cf045b18df7a7a5ce32902638b876a2af74d63fdcaf4642fc148cd8a92965f9f56cb62366b05aad319e0d57b4502efbbcccf0
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  8972567494c3346f16183c8d0d6cf045b18df7a7a5ce32902638b876a2af74d63fdcaf4642fc148cd8a92965f9f56cb62366b05aad319e0d57b4502efbbcccf01540044982
====
Request
+
Request

Cake Params
- pluginbbses
- controllerbbs_articles
- actionindex
- named(array)
  sortBbsArticle.created
  directionasc
- pass(empty)
- block_id33
- setting(false)
- isAjax(false)
- _Token(array)
  key8972567494c3346f16183c8d0d6cf045b18df7a7a5ce32902638b876a2af74d63fdcaf4642fc148cd8a92965f9f56cb62366b05aad319e0d57b4502efbbcccf0
  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: 79 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	0
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	2	maybe slow
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	1	maybe slow
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	1
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	2	maybe slow
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	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`, `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	1
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	1	maybe slow
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	0
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	5	maybe slow
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	0
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	0
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	4	maybe slow
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	6	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	1
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	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, 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` = 'g40j4nle0i8uufktn76473e4q7') 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` = 'g40j4nle0i8uufktn76473e4q7') 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	4	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	5	maybe slow
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	1
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	1
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	1
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	1
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	2	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	1
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	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` = 95 AND `BoxesPageContainer`.`is_published` = '1' ORDER BY `BoxesPageContainer`.`weight` ASC	1	1	1
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	1	maybe slow
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	1	maybe slow
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	1	maybe slow
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	6	maybe slow
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	1	maybe slow
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	1	maybe slow
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	1	maybe slow
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	2	maybe slow
SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 19 LIMIT 1	1	1	2	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` 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 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	3	maybe slow
SELECT `Page`.`lft`, `Page`.`rght` FROM `LAA0857082-chibagakudo`.`nc3_pages` AS `Page` WHERE `Page`.`id` = 19 LIMIT 1	1	1	3	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` 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	2

6 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 20.43 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: 710 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	174.40
Event: Controller.initialize	166.95
Event: Controller.startup	7.77
Controller action	26.11
Event: Controller.beforeRender	81.97
» Processing toolbar data	37.18
Rendering View	131.18
» Event: View.beforeRender	0.51
» Rendering APP/Plugin/Bbses/View/BbsArticles/index.ctp	7.46
» » Rendering APP/Plugin/NetCommons/View/Elements/limit_dropdown_toggle.ctp	2.13
» Event: View.afterRender	1.93
» » Rendering APP/Plugin/Frames/View/Elements/frame.ctp	1.03
» » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp	0.48
» Event: View.beforeLayout	112.53
» » Rendering APP/Plugin/Pages/View/Elements/page_major.ctp	112.21
» » » Rendering APP/Plugin/Boxes/View/Elements/render_boxes.ctp	111.77
» » » » Rendering APP/Plugin/Frames/View/Elements/render_frames.ctp	111.46
» » » » » Event: Controller.initialize #2	18.93
» » » » » Event: Controller.startup #2	0.60
» » » » » Controller action #2	51.97
» » » » » Event: Controller.beforeRender #2	29.86
» » » » » » Processing toolbar data #2	29.52
Rendering View #2	0.00
» » » » » » Event: View.beforeRender #2	0.33
» » » » » » Rendering APP/Plugin/Menus/View/Menus/index.ctp #2	3.27
» » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/index.ctp #3	3.04
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp	0.23
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #2	0.20
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #3	0.20
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #4	0.20
» » » » » » » » Rendering APP/Plugin/Menus/View/Elements/Menus/major/list.ctp #5	0.20
» » » » » » Event: View.afterRender #2	1.07
» » » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #2	0.36
» » » » » » » Rendering APP/Plugin/Pages/View/Elements/page_main.ctp #2	0.32
» » » » » » Event: Controller.shutdown	0.07
» » » » » » Rendering APP/Plugin/Frames/View/Elements/frame.ctp #3	0.27
» » Rendering APP/Plugin/Pages/View/Layouts/default.ctp	4.82
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_css.ctp	0.66
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_theme_css.ctp	0.30
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_js.ctp	0.60
» » » Rendering APP/Plugin/Wysiwyg/View/Elements/mathjax_js.ctp	0.33
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_header.ctp	1.25
» » » Rendering APP/Plugin/NetCommons/View/Elements/common_footer.ctp	0.15
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	W8sxrZ0HalUAAAzNSswAAABJ
Redirect Redirect Mef Proxy Addr	172.19.45.84
Redirect Redirect Nss Sdb Use Cache	YES
Redirect Redirect Status	200
Redirect Unique Id	W8sxrZ0HalUAAAzNSswAAABJ
Redirect Mef Proxy Addr	172.19.45.84
Redirect Nss Sdb Use Cache	YES
Redirect Status	200
Unique Id	W8sxrZ0HalUAAAzNSswAAABJ
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	54.196.26.1
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 If Modified Since	Sat, 18 Aug 2018 18:20:38 UTC
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	54.196.26.1
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	38110
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	1540043181.682
Request Time	1540043181

====

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: 79 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: 79 ms
Total Queries: 76 queries