| 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/contact/', '/s/contact/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 06:37:45') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:45') 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` = 9 AND `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:45') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:45') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 2 |
| 8 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 22 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` <= 23 AND `Content`.`rght` >= 24 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` = 22 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` <= 23 AND `Content`.`rght` >= 24 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 12 | SELECT `MailContent`.`id`, `MailContent`.`description`, `MailContent`.`sender_1`, `MailContent`.`sender_2`, `MailContent`.`sender_name`, `MailContent`.`subject_user`, `MailContent`.`subject_admin`, `MailContent`.`form_template`, `MailContent`.`mail_template`, `MailContent`.`redirect_url`, `MailContent`.`auth_captcha`, `MailContent`.`widget_area`, `MailContent`.`ssl_on`, `MailContent`.`save_info`, `MailContent`.`publish_begin`, `MailContent`.`publish_end`, `MailContent`.`created`, `MailContent`.`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_mail_contents` AS `MailContent` LEFT JOIN `coe`.`mysite_contents` AS `Content` ON (`Content`.`entity_id` = `MailContent`.`id` AND `Content`.`type` = 'MailContent' AND `Content`.`alias_id` IS NULL) inner JOIN `coe`.`mysite_mail_fields` AS `MailField` ON (`MailContent`.`id` = `MailField`.`mail_content_id`) WHERE `MailContent`.`id` = 1 AND `MailField`.`use_field` = '1' ORDER BY `MailField`.`sort` ASC LIMIT 1 | | 1 | 1 | 0 |
| 13 | SELECT `MailField`.`id`, `MailField`.`mail_content_id`, `MailField`.`no`, `MailField`.`name`, `MailField`.`field_name`, `MailField`.`type`, `MailField`.`head`, `MailField`.`attention`, `MailField`.`before_attachment`, `MailField`.`after_attachment`, `MailField`.`source`, `MailField`.`size`, `MailField`.`rows`, `MailField`.`maxlength`, `MailField`.`options`, `MailField`.`class`, `MailField`.`separator`, `MailField`.`default_value`, `MailField`.`description`, `MailField`.`group_field`, `MailField`.`group_valid`, `MailField`.`valid`, `MailField`.`valid_ex`, `MailField`.`auto_convert`, `MailField`.`not_empty`, `MailField`.`use_field`, `MailField`.`no_send`, `MailField`.`sort`, `MailField`.`created`, `MailField`.`modified` FROM `coe`.`mysite_mail_fields` AS `MailField` WHERE `MailField`.`mail_content_id` = (1) ORDER BY `sort` ASC | | 18 | 18 | 0 |
| 14 | SELECT `MailConfig`.`id`, `MailConfig`.`site_name`, `MailConfig`.`site_url`, `MailConfig`.`site_email`, `MailConfig`.`site_tel`, `MailConfig`.`site_fax`, `MailConfig`.`created`, `MailConfig`.`modified` FROM `coe`.`mysite_mail_configs` AS `MailConfig` WHERE 1 = 1 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` FROM `coe`.`mysite_contents` AS `Content` LEFT JOIN `coe`.`mysite_sites` AS `Site` ON (`Content`.`site_id` = `Site`.`id`) WHERE ((`Content`.`id` = 9) OR (`Content`.`main_site_content_id` = 9)) AND ((`Site`.`status` = '1') OR (`Site`.`status` IS NULL)) AND `Content`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:46') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:46') 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 | 2 |
| 16 | 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 |
| 17 | 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`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:46') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:46') 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 |
| 18 | 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`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:46') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:46') 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 |
| 19 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 22 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 20 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 23 AND `Content`.`rght` >= 24 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 21 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 22 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 22 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 23 AND `Content`.`rght` >= 24 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 23 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 22 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 23 AND `Content`.`rght` >= 24 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 25 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 22 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 26 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 23 AND `Content`.`rght` >= 24 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 27 | SELECT `Content`.`lft`, `Content`.`rght` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 22 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 28 | SELECT `Content`.`id` FROM `coe`.`mysite_contents` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 23 AND `Content`.`rght` >= 24 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` asc | | 3 | 3 | 0 |
| 29 | 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`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:46') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:46') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`type` <> 'ContentFolder' AND `Content`.`site_id` = 2 AND `Content`.`parent_id` = 3 AND `Content`.`lft` < 23 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` DESC LIMIT 1 | | 1 | 1 | 1 |
| 30 | 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`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:46') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:46') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`type` <> 'ContentFolder' AND `Content`.`site_id` = 2 AND `Content`.`parent_id` = 3 AND `Content`.`deleted` = '0' AND `Content`.`lft` >= 21 AND `Content`.`lft` != 23 ORDER BY `Content`.`lft` ASC LIMIT 2 | | 1 | 1 | 1 |
| 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`, `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`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:46') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:46') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`type` <> 'ContentFolder' AND `Content`.`site_id` = 2 AND `Content`.`parent_id` = 3 AND `Content`.`lft` < 23 AND `Content`.`deleted` = '0' ORDER BY `Content`.`lft` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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`, `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`.`status` = '1' AND ((`Content`.`publish_begin` <= '2026-06-07 06:37:46') OR (`Content`.`publish_begin` IS NULL) OR (`Content`.`publish_begin` = '0000-00-00 00:00:00')) AND ((`Content`.`publish_end` >= '2026-06-07 06:37:46') OR (`Content`.`publish_end` IS NULL) OR (`Content`.`publish_end` = '0000-00-00 00:00:00')) AND `Content`.`type` <> 'ContentFolder' AND `Content`.`site_id` = 2 AND `Content`.`parent_id` = 3 AND `Content`.`deleted` = '0' AND `Content`.`lft` >= 21 AND `Content`.`lft` != 23 ORDER BY `Content`.`lft` ASC LIMIT 2 | | 1 | 1 | 0 |
| 33 | 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 |
| 34 | SELECT `Content`.`site_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `Content`.`id` = 22 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 35 | SELECT `Content`.`parent_id` FROM `coe`.`mysite_contents` AS `Content` WHERE `id` = 22 AND `Content`.`deleted` = '0' LIMIT 1 | | 1 | 1 | 0 |
| 36 | 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 |
| 37 | 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 |
| 38 | 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 |