Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Post`.`id`, `Post`.`created`, `Post`.`modified`, `Post`.`user_id`, `Post`.`post_start_date`, `Post`.`post_end_date`, `Post`.`title`, `Post`.`content`, `Post`.`parenturl`, `Post`.`pagename`, `Post`.`status`, `Post`.`temp_status`, `Post`.`approved`, `Post`.`preview_block`, `Post`.`status_modified_date`, `Post`.`template_id`, `Post`.`design_layout`, `Post`.`parentid`, `Post`.`short_url`, `Post`.`debug`, `User`.`id`, `User`.`username`, `User`.`created`, `User`.`modified`, `User`.`email`, `User`.`password`, `User`.`permission_tree`, `User`.`user_type`, `User`.`mail_maga`, `User`.`notification_status`, `User`.`position`, `User`.`name`, `User`.`language`, `User`.`home_grid_order`, `User`.`home_grid_display`, `User`.`display_table_settings`, `User`.`pagelist_limit`, `User`.`dataentrylist_limit`, `Template`.`id`, `Template`.`created`, `Template`.`modified`, `Template`.`user_id`, `Template`.`title`, `Template`.`slug`, `Template`.`desc`, `Template`.`status`, `Template`.`postgroup_id`, `Template`.`body_required`, `Template`.`filename`, `Template`.`multiple`, `Template`.`picture`, `Template`.`category`, `Template`.`count`, `Template`.`repeat_fields`, `Approval`.`id`, `Approval`.`post_id`, `Approval`.`title`, `Approval`.`approval_url`, `Approval`.`approval_comment`, `Approval`.`post_user_email`, `Approval`.`approval_date`, `Approval`.`approvalscol`, `Approval`.`product_id`, `Approval`.`store_id`, `Approval`.`campaign_id` FROM `manaable-test-cms`.`posts` AS `Post` LEFT JOIN `manaable-test-cms`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `manaable-test-cms`.`templates` AS `Template` ON (`Post`.`template_id` = `Template`.`id`) LEFT JOIN `manaable-test-cms`.`approvals` AS `Approval` ON (`Approval`.`post_id` = `Post`.`id`) WHERE ((`Post`.`parenturl` = 'www-test.manaable.com') AND (`Post`.`pagename` = 'index.html')) AND `Post`.`status` = '公開' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Postfield`.`id`, `Postfield`.`post_id`, `Postfield`.`field_key`, `Postfield`.`field_value` FROM `manaable-test-cms`.`postfields` AS `Postfield` WHERE `Postfield`.`post_id` = (3) | 0 | 0 | 0 | |
SELECT `Postfield`.`id`, `Postfield`.`post_id`, `Postfield`.`field_key`, `Postfield`.`field_value`, `Post`.`id`, `Post`.`created`, `Post`.`modified`, `Post`.`user_id`, `Post`.`post_start_date`, `Post`.`post_end_date`, `Post`.`title`, `Post`.`content`, `Post`.`parenturl`, `Post`.`pagename`, `Post`.`status`, `Post`.`temp_status`, `Post`.`approved`, `Post`.`preview_block`, `Post`.`status_modified_date`, `Post`.`template_id`, `Post`.`design_layout`, `Post`.`parentid`, `Post`.`short_url`, `Post`.`debug` FROM `manaable-test-cms`.`postfields` AS `Postfield` LEFT JOIN `manaable-test-cms`.`posts` AS `Post` ON (`Postfield`.`post_id` = `Post`.`id`) WHERE 1 = 1 | 75 | 75 | 1 | |
SELECT `Setting`.`id`, `Setting`.`setting_name`, `Setting`.`setting_value`, `Setting`.`site_id` FROM `manaable-test-cms`.`settings` AS `Setting` WHERE `Setting`.`setting_name` = 'site_name' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`created`, `Post`.`modified`, `Post`.`user_id`, `Post`.`post_start_date`, `Post`.`post_end_date`, `Post`.`title`, `Post`.`content`, `Post`.`parenturl`, `Post`.`pagename`, `Post`.`status`, `Post`.`temp_status`, `Post`.`approved`, `Post`.`preview_block`, `Post`.`status_modified_date`, `Post`.`template_id`, `Post`.`design_layout`, `Post`.`parentid`, `Post`.`short_url`, `Post`.`debug` FROM `manaable-test-cms`.`posts` AS `Post` WHERE `parenturl` = 'www-test.manaable.com' AND `pagename` = 'index.html' | 2 | 2 | 0 | |
SELECT `Post`.`title`, `Post`.`pagename`, `Post`.`parenturl`, `Post`.`post_start_date`, `Post`.`template_id`, `Post`.`id` FROM `manaable-test-cms`.`posts` AS `Post` LEFT JOIN `manaable-test-cms`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `manaable-test-cms`.`templates` AS `Template` ON (`Post`.`template_id` = `Template`.`id`) LEFT JOIN `manaable-test-cms`.`approvals` AS `Approval` ON (`Approval`.`post_id` = `Post`.`id`) WHERE `Post`.`parenturl` = 'www-test.manaable.com/menu_customize' AND `Post`.`status` = '公開' ORDER BY `Post`.`post_start_date` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Post`.`title`, `Post`.`pagename`, `Post`.`parenturl`, `Post`.`post_start_date`, `Post`.`template_id`, `Post`.`id` FROM `manaable-test-cms`.`posts` AS `Post` LEFT JOIN `manaable-test-cms`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `manaable-test-cms`.`templates` AS `Template` ON (`Post`.`template_id` = `Template`.`id`) LEFT JOIN `manaable-test-cms`.`approvals` AS `Approval` ON (`Approval`.`post_id` = `Post`.`id`) WHERE `Post`.`parenturl` = 'www-test.manaable.com/menu_customize' AND `Post`.`status` = '公開' ORDER BY `Post`.`post_start_date` ASC | 0 | 0 | 0 | |
1 duplicate queries run.