| 1 | SELECT `SiteConfig`.`name`, `SiteConfig`.`value` FROM `coe`.`mysite_site_configs` AS `SiteConfig` WHERE 1 = 1 | | 30 | 30 | 0 |
| 2 | SELECT `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified` FROM `coe`.`mysite_sites` AS `Site` WHERE 1 = 1 | | 2 | 2 | 0 |
| 3 | SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`title`, `Plugin`.`version`, `Plugin`.`status`, `Plugin`.`db_inited`, `Plugin`.`priority`, `Plugin`.`created`, `Plugin`.`modified` FROM `coe`.`mysite_plugins` AS `Plugin` WHERE `Plugin`.`status` = '1' ORDER BY `Plugin`.`priority` ASC | | 6 | 6 | 0 |
| 4 | SELECT `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified` FROM `coe`.`mysite_sites` AS `Site` WHERE `name` = 'smartphone' LIMIT 1 | | 1 | 1 | 0 |
| 5 | SELECT `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified` FROM `coe`.`mysite_sites` AS `Site` WHERE ((`Site`.`name` = 's') OR (`Site`.`alias` = 's')) LIMIT 1 | | 1 | 1 | 0 |
| 6 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified`, `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`real_name_1`, `User`.`real_name_2`, `User`.`email`, `User`.`user_group_id`, `User`.`nickname`, `User`.`created`, `User`.`modified` FROM `coe`.`mysite_contents` AS `Content` LEFT JOIN `coe`.`mysite_sites` AS `Site` ON (`Content`.`site_id` = `Site`.`id`) LEFT JOIN `coe`.`mysite_users` AS `User` ON (`Content`.`author_id` = `User`.`id`) WHERE `Content`.`url` IN ('/s/', '/s/index') AND ((`Site`.`status` = '1') OR (`Site`.`status` IS NULL)) AND ((`Site`.`same_main_url` = '0') OR (`Site`.`same_main_url` IS NULL)) AND ((`Site`.`use_subdomain` = '0') OR (`Site`.`use_subdomain` IS NULL)) AND `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 07:55:05') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 07:55:05') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`deleted` = '0' ORDER BY `Content`.`url` DESC LIMIT 1 | | 1 | 1 | 1 |
| 7 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 4 AND `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 07:55:05') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 07:55:05') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 1 |
| 8 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 9 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 10 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 11 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 12 | SELECT `Content`.`url` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 4 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 13 | SELECT `Page`.`id`, `Page`.`contents`, `Page`.`draft`, `Page`.`page_template`, `Page`.`code`, `Page`.`modified`, `Page`.`created` FROM `coe`.`mysite_pages` AS `Page` WHERE `Page`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 14 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` LEFT JOIN `coe`.`mysite_sites` AS `Site` ON (`Content`.`site_id` = `Site`.`id`) LEFT JOIN `coe`.`mysite_users` AS `User` ON (`Content`.`author_id` = `User`.`id`) LEFT JOIN `coe`.`mysite_content_folders` AS `ContentFolder` ON (`Content`.`entity_id` = `ContentFolder`.`id`) WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 15 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified`, `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`real_name_1`, `User`.`real_name_2`, `User`.`email`, `User`.`user_group_id`, `User`.`nickname`, `User`.`created`, `User`.`modified`, `ContentFolder`.`id`, `ContentFolder`.`folder_template`, `ContentFolder`.`page_template`, `ContentFolder`.`created`, `ContentFolder`.`modified` FROM `coe`.`mysite_contents` AS `Content` LEFT JOIN `coe`.`mysite_sites` AS `Site` ON (`Content`.`site_id` = `Site`.`id`) LEFT JOIN `coe`.`mysite_users` AS `User` ON (`Content`.`author_id` = `User`.`id`) LEFT JOIN `coe`.`mysite_content_folders` AS `ContentFolder` ON (`Content`.`entity_id` = `ContentFolder`.`id`) WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 16 | SELECT `BlogPost`.`id`, `BlogPost`.`blog_content_id`, `BlogPost`.`no`, `BlogPost`.`name`, `BlogPost`.`content`, `BlogPost`.`detail`, `BlogPost`.`blog_category_id`, `BlogPost`.`user_id`, `BlogPost`.`status`, `BlogPost`.`posts_date`, `BlogPost`.`content_draft`, `BlogPost`.`detail_draft`, `BlogPost`.`publish_begin`, `BlogPost`.`publish_end`, `BlogPost`.`exclude_search`, `BlogPost`.`eye_catch`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`blog_content_id`, `BlogCategory`.`no`, `BlogCategory`.`name`, `BlogCategory`.`title`, `BlogCategory`.`status`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`owner_id`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`real_name_1`, `User`.`real_name_2`, `User`.`email`, `User`.`user_group_id`, `User`.`nickname`, `User`.`created`, `User`.`modified`, `BlogContent`.`id`, `BlogContent`.`description`, `BlogContent`.`template`, `BlogContent`.`list_count`, `BlogContent`.`list_direction`, `BlogContent`.`feed_count`, `BlogContent`.`tag_use`, `BlogContent`.`comment_use`, `BlogContent`.`comment_approve`, `BlogContent`.`auth_captcha`, `BlogContent`.`widget_area`, `BlogContent`.`eye_catch_size`, `BlogContent`.`use_content`, `BlogContent`.`created`, `BlogContent`.`modified` FROM `coe`.`mysite_blog_posts` AS `BlogPost` LEFT JOIN `coe`.`mysite_blog_categories` AS `BlogCategory` ON (`BlogPost`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `coe`.`mysite_users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) LEFT JOIN `coe`.`mysite_blog_contents` AS `BlogContent` ON (`BlogPost`.`blog_content_id` = `BlogContent`.`id`) LEFT JOIN `coe`.`mysite_contents` AS `Content` ON (`Content`.`entity_id`=`BlogContent`.`id` AND `Content`.`type`='BlogContent') WHERE `Content`.`url` = ('/news/') AND `BlogPost`.`status` = '1' AND ((`BlogPost`.`publish_begin` <= '2026-06-07 07:55:05') OR (`BlogPost`.`publish_begin` IS NULL) OR (`BlogPost`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`BlogPost`.`publish_end` >= '2026-06-07 07:55:05') OR (`BlogPost`.`publish_end` IS NULL) OR (`BlogPost`.`publish_end` = '0000-00-00 00:00:00')) ORDER BY `BlogPost`.`posts_date` DESC, `BlogPost`.`id` DESC LIMIT 5 | | 2 | 2 | 4 |
| 17 | SELECT `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`title`, `UserGroup`.`auth_prefix`, `UserGroup`.`use_admin_globalmenu`, `UserGroup`.`default_favorites`, `UserGroup`.`use_move_contents`, `UserGroup`.`modified`, `UserGroup`.`created` FROM `coe`.`mysite_user_groups` AS `UserGroup` WHERE `UserGroup`.`id` = 1 | | 1 | 1 | 0 |
| 18 | SELECT `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`title`, `UserGroup`.`auth_prefix`, `UserGroup`.`use_admin_globalmenu`, `UserGroup`.`default_favorites`, `UserGroup`.`use_move_contents`, `UserGroup`.`modified`, `UserGroup`.`created` FROM `coe`.`mysite_user_groups` AS `UserGroup` WHERE `UserGroup`.`id` = 1 | | 1 | 1 | 0 |
| 19 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`entity_id` = 1 AND `Content`.`type` = 'BlogContent' AND `Content`.`alias_id` IS NULL | | 1 | 1 | 0 |
| 20 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`entity_id` = 1 AND `Content`.`type` = 'BlogContent' AND `Content`.`alias_id` IS NULL | | 1 | 1 | 0 |
| 21 | SELECT `BlogTag`.`id`, `BlogTag`.`name`, `BlogTag`.`created`, `BlogTag`.`modified`, `BlogPostsBlogTag`.`id`, `BlogPostsBlogTag`.`blog_post_id`, `BlogPostsBlogTag`.`blog_tag_id`, `BlogPostsBlogTag`.`created`, `BlogPostsBlogTag`.`modified` FROM `coe`.`mysite_blog_tags` AS `BlogTag` JOIN `coe`.`mysite_blog_posts_blog_tags` AS `BlogPostsBlogTag` ON (`BlogPostsBlogTag`.`blog_post_id` IN (2, 1) AND `BlogPostsBlogTag`.`blog_tag_id` = `BlogTag`.`id`) | | 1 | 1 | 0 |
| 22 | SELECT `BlogContent`.`template`, `BlogContent`.`id` FROM `coe`.`mysite_blog_contents` AS `BlogContent` LEFT JOIN `coe`.`mysite_contents` AS `Content` ON (`Content`.`entity_id` = `BlogContent`.`id` AND `Content`.`type` = 'BlogContent' AND `Content`.`alias_id` IS NULL) WHERE `Content`.`url` = ('/news/') AND `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 07:55:05') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 07:55:05') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) LIMIT 1 | | 1 | 1 | 1 |
| 23 | SELECT `BlogContent`.`id`, `BlogContent`.`description`, `BlogContent`.`template`, `BlogContent`.`list_count`, `BlogContent`.`list_direction`, `BlogContent`.`feed_count`, `BlogContent`.`tag_use`, `BlogContent`.`comment_use`, `BlogContent`.`comment_approve`, `BlogContent`.`auth_captcha`, `BlogContent`.`widget_area`, `BlogContent`.`eye_catch_size`, `BlogContent`.`use_content`, `BlogContent`.`created`, `BlogContent`.`modified` FROM `coe`.`mysite_blog_contents` AS `BlogContent` WHERE `BlogContent`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`entity_id` = 1 AND `Content`.`type` = 'BlogContent' AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 25 | SELECT `BlogContent`.`id`, `BlogContent`.`description`, `BlogContent`.`template`, `BlogContent`.`list_count`, `BlogContent`.`list_direction`, `BlogContent`.`feed_count`, `BlogContent`.`tag_use`, `BlogContent`.`comment_use`, `BlogContent`.`comment_approve`, `BlogContent`.`auth_captcha`, `BlogContent`.`widget_area`, `BlogContent`.`eye_catch_size`, `BlogContent`.`use_content`, `BlogContent`.`created`, `BlogContent`.`modified`, `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_blog_contents` AS `BlogContent` LEFT JOIN `coe`.`mysite_contents` AS `Content` ON (`Content`.`entity_id` = `BlogContent`.`id` AND `Content`.`type` = 'BlogContent' AND `Content`.`alias_id` IS NULL) WHERE `BlogContent`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 26 | SELECT `Content`.`site_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`entity_id` = 1 AND `Content`.`type` = 'BlogContent' AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT `Content`.`site_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 4 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 28 | SELECT `BlogContent`.`id`, `BlogContent`.`description`, `BlogContent`.`template`, `BlogContent`.`list_count`, `BlogContent`.`list_direction`, `BlogContent`.`feed_count`, `BlogContent`.`tag_use`, `BlogContent`.`comment_use`, `BlogContent`.`comment_approve`, `BlogContent`.`auth_captcha`, `BlogContent`.`widget_area`, `BlogContent`.`eye_catch_size`, `BlogContent`.`use_content`, `BlogContent`.`created`, `BlogContent`.`modified`, `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_blog_contents` AS `BlogContent` LEFT JOIN `coe`.`mysite_contents` AS `Content` ON (`Content`.`entity_id` = `BlogContent`.`id` AND `Content`.`type` = 'BlogContent' AND `Content`.`alias_id` IS NULL) WHERE `BlogContent`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 29 | SELECT `Content`.`site_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`entity_id` = 1 AND `Content`.`type` = 'BlogContent' AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 30 | SELECT `Content`.`site_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 4 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 31 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified`, `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified`, `ContentFolder`.`id`, `ContentFolder`.`folder_template`, `ContentFolder`.`page_template`, `ContentFolder`.`created`, `ContentFolder`.`modified` FROM `coe`.`mysite_contents` AS `Content` LEFT JOIN `coe`.`mysite_sites` AS `Site` ON (`Content`.`site_id` = `Site`.`id`) LEFT JOIN `coe`.`mysite_content_folders` AS `ContentFolder` ON (`Content`.`entity_id` = `ContentFolder`.`id`) WHERE ((`Content`.`id` = 4) OR (`Content`.`main_site_content_id` = 4)) AND ((`Site`.`status` = '1') OR (`Site`.`status` IS NULL)) AND `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 07:55:05') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 07:55:05') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`deleted` = '0' ORDER BY `Content`.`id` ASC | | 2 | 2 | 1 |
| 32 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`site_id` = 2 AND `Content`.`site_root` = '1' AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 33 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified`, `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`real_name_1`, `User`.`real_name_2`, `User`.`email`, `User`.`user_group_id`, `User`.`nickname`, `User`.`created`, `User`.`modified`, `ContentFolder`.`id`, `ContentFolder`.`folder_template`, `ContentFolder`.`page_template`, `ContentFolder`.`created`, `ContentFolder`.`modified` FROM `coe`.`mysite_contents` AS `Content` LEFT JOIN `coe`.`mysite_sites` AS `Site` ON (`Content`.`site_id` = `Site`.`id`) LEFT JOIN `coe`.`mysite_users` AS `User` ON (`Content`.`author_id` = `User`.`id`) LEFT JOIN `coe`.`mysite_content_folders` AS `ContentFolder` ON (`Content`.`entity_id` = `ContentFolder`.`id`) WHERE `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 07:55:05') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 07:55:05') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`id` = 3 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 1 |
| 34 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified`, `Site`.`id`, `Site`.`main_site_id`, `Site`.`name`, `Site`.`display_name`, `Site`.`title`, `Site`.`alias`, `Site`.`theme`, `Site`.`status`, `Site`.`keyword`, `Site`.`description`, `Site`.`use_subdomain`, `Site`.`relate_main_site`, `Site`.`device`, `Site`.`lang`, `Site`.`same_main_url`, `Site`.`auto_redirect`, `Site`.`auto_link`, `Site`.`domain_type`, `Site`.`created`, `Site`.`modified`, `User`.`id`, `User`.`name`, `User`.`password`, `User`.`real_name_1`, `User`.`real_name_2`, `User`.`email`, `User`.`user_group_id`, `User`.`nickname`, `User`.`created`, `User`.`modified`, `ContentFolder`.`id`, `ContentFolder`.`folder_template`, `ContentFolder`.`page_template`, `ContentFolder`.`created`, `ContentFolder`.`modified` FROM `coe`.`mysite_contents` AS `Content` LEFT JOIN `coe`.`mysite_sites` AS `Site` ON (`Content`.`site_id` = `Site`.`id`) LEFT JOIN `coe`.`mysite_users` AS `User` ON (`Content`.`author_id` = `User`.`id`) LEFT JOIN `coe`.`mysite_content_folders` AS `ContentFolder` ON (`Content`.`entity_id` = `ContentFolder`.`id`) WHERE `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 07:55:05') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 07:55:05') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`site_root` = '0' AND `rght` < 25 AND `lft` > 6 AND `Content`.`level` < 5 AND `Content`.`deleted` = '0' ORDER BY `Content`.`site_id` ASC, `Content`.`lft` ASC | | 9 | 9 | 1 |
| 35 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 36 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 37 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 38 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 39 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 40 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 41 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 42 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 43 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 44 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 7 AND `Content`.`rght` >= 8 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 45 | SELECT `WidgetArea`.`id`, `WidgetArea`.`name`, `WidgetArea`.`widgets`, `WidgetArea`.`modified`, `WidgetArea`.`created` FROM `coe`.`mysite_widget_areas` AS `WidgetArea` WHERE `WidgetArea`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 46 | SELECT `Content`.`site_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 47 | SELECT `Content`.`parent_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `id` = 14 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 48 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 3 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 49 | SELECT `Content`.`id`, `Content`.`name`, `Content`.`plugin`, `Content`.`type`, `Content`.`entity_id`, `Content`.`url`, `Content`.`site_id`, `Content`.`alias_id`, `Content`.`main_site_content_id`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`level`, `Content`.`title`, `Content`.`description`, `Content`.`eyecatch`, `Content`.`author_id`, `Content`.`layout_template`, `Content`.`status`, `Content`.`publish_begin`, `Content`.`publish_end`, `Content`.`self_status`, `Content`.`self_publish_begin`, `Content`.`self_publish_end`, `Content`.`exclude_search`, `Content`.`created_date`, `Content`.`modified_date`, `Content`.`site_root`, `Content`.`deleted_date`, `Content`.`deleted`, `Content`.`exclude_menu`, `Content`.`blank_link`, `Content`.`created`, `Content`.`modified` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`site_id` = 2 AND `Content`.`site_root` = '1' AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 50 | SELECT `Content`.`id`, `Content`.`title`, `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `type` = 'ContentFolder' AND `alias_id` IS NULL AND `site_id` = 2 AND `id` <> 3 AND 1 = 1 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 1 | 1 | 0 |