Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Brand`.`code` FROM `brands` AS `Brand` WHERE `Brand`.`delete_flg` = '0' | 4 | 4 | 0 | |
SELECT `OperationSetting`.`id`, `OperationSetting`.`code`, `OperationSetting`.`controller`, `OperationSetting`.`value`, `OperationSetting`.`created_user`, `OperationSetting`.`created`, `OperationSetting`.`modified_user`, `OperationSetting`.`modified`, `OperationSetting`.`delete_flg` FROM `sieve_stg`.`operation_settings` AS `OperationSetting` WHERE `OperationSetting`.`delete_flg` = '0' | 504 | 504 | 2 | |
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` IS NULL AND `Basket`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 0 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '603ef76a-5878-4047-82f9-3a460a00013d' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '603ef76a-5878-4047-82f9-3a460a00013d' | 1 | 1 | 0 | |
INSERT INTO `sieve_stg`.`baskets` (`id`, `data`, `modified`, `created`, `modified_user`) VALUES ('603ef76a-5878-4047-82f9-3a460a00013d', '{\"cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]},\"subscription_cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]}}', '2021-03-03 11:41:46', '2021-03-03 11:41:46', '-') | 1 | 1 | 2 | maybe slow |
COMMIT | | | | |
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '603ef76a-5878-4047-82f9-3a460a00013d' AND `Basket`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `sieve_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2021-03-03' AND `TaxRate`.`tax_div` = 1 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `sieve_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2021-03-03' AND `TaxRate`.`tax_div` = 2 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg` FROM `sieve_stg`.`pages` AS `Page` WHERE `code` = 'content' AND `Page`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PagePart`.`id`, `PagePart`.`page_id`, `PagePart`.`part_id`, `PagePart`.`display_section_div`, `PagePart`.`display_order`, `PagePart`.`content`, `PagePart`.`created_user`, `PagePart`.`created`, `PagePart`.`modified_user`, `PagePart`.`modified`, `PagePart`.`delete_flg`, `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg`, `Part`.`id`, `Part`.`code`, `Part`.`name`, `Part`.`title`, `Part`.`ajax_div`, `Part`.`content`, `Part`.`system_parts_flg`, `Part`.`label_div`, `Part`.`memo`, `Part`.`created_user`, `Part`.`created`, `Part`.`modified_user`, `Part`.`modified`, `Part`.`delete_flg` FROM `sieve_stg`.`page_parts` AS `PagePart` LEFT JOIN `sieve_stg`.`pages` AS `Page` ON (`PagePart`.`page_id` = `Page`.`id` AND `Page`.`delete_flg` = '0') LEFT JOIN `sieve_stg`.`parts` AS `Part` ON (`PagePart`.`part_id` = `Part`.`id` AND `Part`.`delete_flg` = '0') WHERE `page_id` = '526a8d65-a348-4a52-8d6e-4bb3fd5ad003' AND `PagePart`.`delete_flg` = '0' ORDER BY `PagePart`.`display_section_div` ASC, `PagePart`.`display_order` ASC | 7 | 7 | 1 | maybe slow |
SELECT `Post`.`id`, `Post`.`post_div`, `Post`.`post_category_id`, `Post`.`code`, `Post`.`brand_id`, `Post`.`release_div`, `Post`.`important_flg`, `Post`.`title`, `Post`.`description`, `Post`.`keywords`, `Post`.`post_date`, `Post`.`content`, `Post`.`wysiwyg_flg`, `Post`.`link`, `Post`.`link_target_div`, `Post`.`image`, `Post`.`thumb_image`, `Post`.`image_sp`, `Post`.`attachment_file`, `Post`.`disp_date_from`, `Post`.`disp_date_to`, `Post`.`tags`, `Post`.`left_column_display_div`, `Post`.`right_column_display_div`, `Post`.`label_div`, `Post`.`sns_div`, `Post`.`sns_post_id`, `Post`.`memo`, `Post`.`created_user`, `Post`.`created`, `Post`.`modified_user`, `Post`.`modified`, `Post`.`delete_flg`, `PostCategory`.`id`, `PostCategory`.`post_div`, `PostCategory`.`code`, `PostCategory`.`title`, `PostCategory`.`image`, `PostCategory`.`content`, `PostCategory`.`display_order`, `PostCategory`.`created_user`, `PostCategory`.`created`, `PostCategory`.`modified_user`, `PostCategory`.`modified`, `PostCategory`.`delete_flg` FROM `sieve_stg`.`posts` AS `Post` LEFT JOIN `sieve_stg`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id`) WHERE ((`Post`.`id` = 'privacy') OR (`Post`.`code` = 'privacy')) AND `Post`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-03 11:41:46' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 2 AND `ItemCategory`.`delete_flg` = '0' AND ((`ItemCategory`.`only_bussiness_flg` = '0') OR (`ItemCategory`.`only_bussiness_flg` IS NULL) OR (`ItemCategory`.`only_bussiness_flg` = '0')) ORDER BY `display_order` asc | 10 | 10 | 1 | maybe slow |
SELECT `Part`.`id`, `Part`.`code`, `Part`.`name`, `Part`.`title`, `Part`.`ajax_div`, `Part`.`content`, `Part`.`system_parts_flg`, `Part`.`label_div`, `Part`.`memo`, `Part`.`created_user`, `Part`.`created`, `Part`.`modified_user`, `Part`.`modified`, `Part`.`delete_flg` FROM `sieve_stg`.`parts` AS `Part` WHERE `Part`.`code` = 'parts_sidebar_recent' AND `Part`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`post_div`, `Post`.`post_category_id`, `Post`.`code`, `Post`.`brand_id`, `Post`.`release_div`, `Post`.`important_flg`, `Post`.`title`, `Post`.`description`, `Post`.`keywords`, `Post`.`post_date`, `Post`.`content`, `Post`.`wysiwyg_flg`, `Post`.`link`, `Post`.`link_target_div`, `Post`.`image`, `Post`.`thumb_image`, `Post`.`image_sp`, `Post`.`attachment_file`, `Post`.`disp_date_from`, `Post`.`disp_date_to`, `Post`.`tags`, `Post`.`left_column_display_div`, `Post`.`right_column_display_div`, `Post`.`label_div`, `Post`.`sns_div`, `Post`.`sns_post_id`, `Post`.`memo`, `Post`.`created_user`, `Post`.`created`, `Post`.`modified_user`, `Post`.`modified`, `Post`.`delete_flg`, `PostCategory`.`id`, `PostCategory`.`post_div`, `PostCategory`.`code`, `PostCategory`.`title`, `PostCategory`.`image`, `PostCategory`.`content`, `PostCategory`.`display_order`, `PostCategory`.`created_user`, `PostCategory`.`created`, `PostCategory`.`modified_user`, `PostCategory`.`modified`, `PostCategory`.`delete_flg` FROM `sieve_stg`.`posts` AS `Post` LEFT JOIN `sieve_stg`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id` AND `PostCategory`.`delete_flg` = '0') WHERE `Post`.`release_div` = 1 AND `Post`.`disp_date_from` <= '2021-03-03 11:46:41' AND ((`Post`.`disp_date_to` IS NULL) OR (`Post`.`disp_date_to` >= '2021-03-03 11:46:41')) AND `Post`.`post_div` = 1 AND `Post`.`code` = 'privacy' AND `Post`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
1 duplicate queries run.