| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Brand`.`code` FROM `brands` AS `Brand` WHERE `Brand`.`delete_flg` = '0' | 4 | 4 | 1 | maybe slow |
| 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' | 546 | 546 | 3 | |
| 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 | 1 | maybe slow |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '508cb45f-0958-4c46-a1ef-ec077e2f1ed1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '508cb45f-0958-4c46-a1ef-ec077e2f1ed1' | 1 | 1 | 0 | |
| INSERT INTO `sieve_stg`.`baskets` (`id`, `data`, `modified`, `created`, `modified_user`) VALUES ('508cb45f-0958-4c46-a1ef-ec077e2f1ed1', '{\"cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]},\"subscription_cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]}}', '2021-10-25 22:21:03', '2021-10-25 22:21:03', '-') | 1 | 1 | 3 | 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` = '508cb45f-0958-4c46-a1ef-ec077e2f1ed1' AND `Basket`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
| 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-10-25' AND `TaxRate`.`tax_div` = 1 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 1 | |
| 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-10-25' AND `TaxRate`.`tax_div` = 2 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 1 | |
| 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` = 'item_list' AND `Page`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
| 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` = '527b103b-d354-431c-8f8a-d644fd5ad003' AND `PagePart`.`delete_flg` = '0' ORDER BY `PagePart`.`display_section_div` ASC, `PagePart`.`display_order` ASC | 11 | 11 | 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 | 1 | |
| SELECT `PagePartRelation`.`id`, `PagePartRelation`.`page_id`, `PagePartRelation`.`part_id`, `PagePartRelation`.`created_user`, `PagePartRelation`.`created`, `PagePartRelation`.`modified_user`, `PagePartRelation`.`modified`, `PagePartRelation`.`delete_flg` FROM `sieve_stg`.`page_part_relations` AS `PagePartRelation` WHERE `PagePartRelation`.`delete_flg` = '0' AND `PagePartRelation`.`part_id` = ('51b2824b-878c-4420-82df-867cfd5ad003') | 0 | 0 | 1 | maybe slow |
| 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-10-25 22:21:03' 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 | 11 | 11 | 1 | maybe slow |
| 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-10-25 22:21:03' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 3 AND `ItemCategory`.`release_div` = 1 AND ((`ItemCategory`.`description` LIKE '%サイドテーブル%') OR (`ItemCategory`.`title` LIKE '%サイドテーブル%') OR (`ItemCategory`.`title_kana` LIKE '%サイドテーブル%')) 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 `ItemCategory`.`disp_date_from` desc | 0 | 0 | 1 | maybe slow |
| SELECT `Item`.`id`, `Item`.`code`, `Item`.`brand_id`, `Item`.`name`, `Item`.`title`, `Item`.`name_kana`, `Item`.`jan_code`, `Item`.`smaregi_original_code`, `Item`.`description`, `Item`.`keywords`, `Item`.`subscription_div`, `Item`.`reservation_div`, `Item`.`scheduled_arrival_date`, `Item`.`release_div`, `Item`.`only_member_flg`, `Item`.`only_bussiness_flg`, `Item`.`outlet_flg`, `Item`.`not_purchase_flg`, `Item`.`price_hidden_flg`, `Item`.`set_item_flg`, `Item`.`set_item_contents`, `Item`.`disp_date_from`, `Item`.`disp_date_to`, `Item`.`selling_date_from`, `Item`.`selling_date_to`, `Item`.`sale_date_from`, `Item`.`sale_date_to`, `Item`.`price`, `Item`.`sale_price`, `Item`.`member_price`, `Item`.`business_price`, `Item`.`cost_price`, `Item`.`shipping_weight`, `Item`.`point_div`, `Item`.`free_shipping_div`, `Item`.`cool_div`, `Item`.`specific_point`, `Item`.`specific_point_date_from`, `Item`.`specific_point_date_to`, `Item`.`item_tags`, `Item`.`item_list_tags`, `Item`.`explain`, `Item`.`explain2`, `Item`.`wysiwyg_flg`, `Item`.`wysiwyg_flg2`, `Item`.`item_variation_group_id`, `Item`.`stock_div`, `Item`.`stock_quantity`, `Item`.`warning_stock_quantity`, `Item`.`lot_quantity`, `Item`.`core_item_flg`, `Item`.`item_variation_attribute1`, `Item`.`item_variation_attribute2`, `Item`.`item_variation_colorcode`, `Item`.`tax_div`, `Item`.`preview_image_index`, `Item`.`brand`, `Item`.`attribute1`, `Item`.`attribute2`, `Item`.`attribute3`, `Item`.`attribute4`, `Item`.`attribute5`, `Item`.`attribute6`, `Item`.`attribute7`, `Item`.`attribute8`, `Item`.`attribute9`, `Item`.`attribute10`, `Item`.`attribute11`, `Item`.`attribute12`, `Item`.`attribute13`, `Item`.`attribute14`, `Item`.`attribute15`, `Item`.`item_option1`, `Item`.`item_option2`, `Item`.`item_option3`, `Item`.`item_option4`, `Item`.`item_option5`, `Item`.`images`, `Item`.`image_captions`, `Item`.`representative_image`, `Item`.`point`, `Item`.`google_product_category`, `Item`.`pla_image`, `Item`.`shipping_category_id`, `Item`.`parts_id1`, `Item`.`parts_id2`, `Item`.`parts_id3`, `Item`.`parts_id4`, `Item`.`parts_id5`, `Item`.`disp_inform_restock_flg`, `Item`.`delivery_sources_id`, `Item`.`external_cooperation_1`, `Item`.`external_cooperation_2`, `Item`.`external_cooperation_3`, `Item`.`external_cooperation_4`, `Item`.`external_cooperation_5`, `Item`.`ga_page_view`, `Item`.`avg_review`, `Item`.`notice_text`, `Item`.`recommend`, `Item`.`label_div`, `Item`.`memo`, `Item`.`created_user`, `Item`.`created`, `Item`.`modified_user`, `Item`.`modified`, `Item`.`delete_flg`, `Item`.`parent_item_id`, (COALESCE(IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price`, NULL), `Item`.`price`)) AS `Item__current_price`, (TRUNCATE (COALESCE(IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08)), NULL), `Item`.`price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08))), 0 ) ) AS `Item__current_price_withtax`, (IF(`Item`.`sale_price` IS NULL, 1, IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), 2, 1))) AS `Item__price_div`, (IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`selling_date_from`, '1000-01-01') AND COALESCE(`Item`.`selling_date_to`, '9999-12-31'), 1, 2)) AS `Item__selling_div`, (IF(SYSDATE() BETWEEN `Item`.`sale_date_from` AND `Item`.`sale_date_to` ,true, false)) AS `Item__sales_term_flg`, (IF(`Item`.`item_variation_group_id` IS NULL OR `Item`.`item_variation_group_id` = "", "", (SELECT SUM(stock_quantity) AS sum_stock_quantity FROM items WHERE item_variation_group_id = `Item`.`item_variation_group_id` ) )) AS `Item__variation_sum_stock_quantity` FROM `sieve_stg`.`items` AS `Item` WHERE `Item`.`delete_flg` = 0 AND '2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND `Item`.`release_div` = 1 AND ((((`Item`.`item_variation_group_id` is not null) AND (`Item`.`item_variation_group_id` <> '') AND (`Item`.`core_item_flg` = '1'))) OR (((`Item`.`item_variation_group_id` is null) OR (`Item`.`item_variation_group_id` = '')))) AND ((`Item`.`name` LIKE '%サイドテーブル%') OR (`Item`.`name_kana` LIKE '%サイドテーブル%') OR (`Item`.`title` LIKE '%サイドテーブル%') OR (`Item`.`code` LIKE '%サイドテーブル%') OR (`Item`.`keywords` LIKE '%サイドテーブル%') OR (`Item`.`explain` LIKE '%サイドテーブル%') OR (`Item`.`item_tags` LIKE '%サイドテーブル%')) AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) ORDER BY `Item`.`disp_date_from` desc, `code` asc LIMIT 24 | 11 | 11 | 17 | maybe slow |
| SELECT `SetItemRelation`.`id`, `SetItemRelation`.`parent_item_id`, `SetItemRelation`.`child_item_id`, `SetItemRelation`.`quantity`, `SetItemRelation`.`created_user`, `SetItemRelation`.`created`, `SetItemRelation`.`modified_user`, `SetItemRelation`.`modified`, `SetItemRelation`.`delete_flg` FROM `sieve_stg`.`set_item_relations` AS `SetItemRelation` WHERE `SetItemRelation`.`delete_flg` = '0' AND `SetItemRelation`.`parent_item_id` IN ('5f2288a2-60c0-47ad-beee-0d8a0a00013d', '5df19783-af58-49de-a34c-70c60a00013d', '5df19784-8244-433a-a54d-70c60a00013d', '5df19784-9048-42ad-b3a7-70c60a00013d', '587ed60f-14a0-4d13-962c-5be0a0104cac', '5fb258d1-cf3c-4d3e-9757-3f930a00013d', '5fb258d1-66f8-442d-abcb-3f930a00013d', '5fb258d1-4d8c-435c-bb75-3f930a00013d', '57c3e2e5-03a4-4df7-b896-6b1fa0104cac', '586341c7-9474-4db7-bc65-11f8a0104cac', '571dc352-1dcc-422d-9b78-4d4ba0104cac') | 13 | 13 | 1 | maybe slow |
| SELECT `ItemCategoryRelation`.`id`, `ItemCategoryRelation`.`item_category_div`, `ItemCategoryRelation`.`item_id`, `ItemCategoryRelation`.`item_category_id`, `ItemCategoryRelation`.`label_div`, `ItemCategoryRelation`.`memo`, `ItemCategoryRelation`.`created_user`, `ItemCategoryRelation`.`created`, `ItemCategoryRelation`.`modified_user`, `ItemCategoryRelation`.`modified`, `ItemCategoryRelation`.`delete_flg` FROM `sieve_stg`.`item_category_relations` AS `ItemCategoryRelation` WHERE `ItemCategoryRelation`.`delete_flg` = '0' AND `ItemCategoryRelation`.`item_id` IN ('5f2288a2-60c0-47ad-beee-0d8a0a00013d', '5df19783-af58-49de-a34c-70c60a00013d', '5df19784-8244-433a-a54d-70c60a00013d', '5df19784-9048-42ad-b3a7-70c60a00013d', '587ed60f-14a0-4d13-962c-5be0a0104cac', '5fb258d1-cf3c-4d3e-9757-3f930a00013d', '5fb258d1-66f8-442d-abcb-3f930a00013d', '5fb258d1-4d8c-435c-bb75-3f930a00013d', '57c3e2e5-03a4-4df7-b896-6b1fa0104cac', '586341c7-9474-4db7-bc65-11f8a0104cac', '571dc352-1dcc-422d-9b78-4d4ba0104cac') | 29 | 29 | 1 | |
| SELECT `ItemKeyword`.`id`, `ItemKeyword`.`item_id`, `ItemKeyword`.`keyword`, `ItemKeyword`.`priority`, `ItemKeyword`.`label_div`, `ItemKeyword`.`memo`, `ItemKeyword`.`created_user`, `ItemKeyword`.`created`, `ItemKeyword`.`modified_user`, `ItemKeyword`.`modified`, `ItemKeyword`.`delete_flg` FROM `sieve_stg`.`item_keywords` AS `ItemKeyword` WHERE `ItemKeyword`.`delete_flg` = '0' AND `ItemKeyword`.`item_id` IN ('5f2288a2-60c0-47ad-beee-0d8a0a00013d', '5df19783-af58-49de-a34c-70c60a00013d', '5df19784-8244-433a-a54d-70c60a00013d', '5df19784-9048-42ad-b3a7-70c60a00013d', '587ed60f-14a0-4d13-962c-5be0a0104cac', '5fb258d1-cf3c-4d3e-9757-3f930a00013d', '5fb258d1-66f8-442d-abcb-3f930a00013d', '5fb258d1-4d8c-435c-bb75-3f930a00013d', '57c3e2e5-03a4-4df7-b896-6b1fa0104cac', '586341c7-9474-4db7-bc65-11f8a0104cac', '571dc352-1dcc-422d-9b78-4d4ba0104cac') | 20 | 20 | 3 | maybe slow |
| SELECT `Item`.`id`, `Item`.`stock_quantity` FROM `sieve_stg`.`items` AS `Item` WHERE `id` IN ('567cf33e-9f38-4853-9c8b-1535a0104cac', '560a4b2d-3278-4dd4-89b7-651afd5ad003', '560a4b2c-decc-4986-b663-651afd5ad003', '587ed60e-8554-4a58-b7cc-5be0a0104cac') AND `stock_div` = 1 AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) | 4 | 4 | 1 | maybe slow |
| SELECT `Item`.`id`, `Item`.`stock_quantity` FROM `sieve_stg`.`items` AS `Item` WHERE `id` IN ('567cf33e-9f38-4853-9c8b-1535a0104cac', '587ed60f-14a0-4d13-962c-5be0a0104cac', '587ed60e-8554-4a58-b7cc-5be0a0104cac', '560a4b2d-ffe8-4002-bdee-651afd5ad003') AND `stock_div` = 1 AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) | 4 | 4 | 1 | maybe slow |
| SELECT `Item`.`id`, `Item`.`stock_quantity` FROM `sieve_stg`.`items` AS `Item` WHERE `id` IN ('587ed60e-8554-4a58-b7cc-5be0a0104cac', '560a4b2d-3278-4dd4-89b7-651afd5ad003', '587ed60f-14a0-4d13-962c-5be0a0104cac', '567cf33e-9f38-4853-9c8b-1535a0104cac', '560a4b2c-decc-4986-b663-651afd5ad003') AND `stock_div` = 1 AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) | 5 | 5 | 1 | maybe slow |
| SELECT `Item`.`id`, `Item`.`code`, `Item`.`brand_id`, `Item`.`name`, `Item`.`title`, `Item`.`name_kana`, `Item`.`jan_code`, `Item`.`smaregi_original_code`, `Item`.`description`, `Item`.`keywords`, `Item`.`subscription_div`, `Item`.`reservation_div`, `Item`.`scheduled_arrival_date`, `Item`.`release_div`, `Item`.`only_member_flg`, `Item`.`only_bussiness_flg`, `Item`.`outlet_flg`, `Item`.`not_purchase_flg`, `Item`.`price_hidden_flg`, `Item`.`set_item_flg`, `Item`.`set_item_contents`, `Item`.`disp_date_from`, `Item`.`disp_date_to`, `Item`.`selling_date_from`, `Item`.`selling_date_to`, `Item`.`sale_date_from`, `Item`.`sale_date_to`, `Item`.`price`, `Item`.`sale_price`, `Item`.`member_price`, `Item`.`business_price`, `Item`.`cost_price`, `Item`.`shipping_weight`, `Item`.`point_div`, `Item`.`free_shipping_div`, `Item`.`cool_div`, `Item`.`specific_point`, `Item`.`specific_point_date_from`, `Item`.`specific_point_date_to`, `Item`.`item_tags`, `Item`.`item_list_tags`, `Item`.`explain`, `Item`.`explain2`, `Item`.`wysiwyg_flg`, `Item`.`wysiwyg_flg2`, `Item`.`item_variation_group_id`, `Item`.`stock_div`, `Item`.`stock_quantity`, `Item`.`warning_stock_quantity`, `Item`.`lot_quantity`, `Item`.`core_item_flg`, `Item`.`item_variation_attribute1`, `Item`.`item_variation_attribute2`, `Item`.`item_variation_colorcode`, `Item`.`tax_div`, `Item`.`preview_image_index`, `Item`.`brand`, `Item`.`attribute1`, `Item`.`attribute2`, `Item`.`attribute3`, `Item`.`attribute4`, `Item`.`attribute5`, `Item`.`attribute6`, `Item`.`attribute7`, `Item`.`attribute8`, `Item`.`attribute9`, `Item`.`attribute10`, `Item`.`attribute11`, `Item`.`attribute12`, `Item`.`attribute13`, `Item`.`attribute14`, `Item`.`attribute15`, `Item`.`item_option1`, `Item`.`item_option2`, `Item`.`item_option3`, `Item`.`item_option4`, `Item`.`item_option5`, `Item`.`images`, `Item`.`image_captions`, `Item`.`representative_image`, `Item`.`point`, `Item`.`google_product_category`, `Item`.`pla_image`, `Item`.`shipping_category_id`, `Item`.`parts_id1`, `Item`.`parts_id2`, `Item`.`parts_id3`, `Item`.`parts_id4`, `Item`.`parts_id5`, `Item`.`disp_inform_restock_flg`, `Item`.`delivery_sources_id`, `Item`.`external_cooperation_1`, `Item`.`external_cooperation_2`, `Item`.`external_cooperation_3`, `Item`.`external_cooperation_4`, `Item`.`external_cooperation_5`, `Item`.`ga_page_view`, `Item`.`avg_review`, `Item`.`notice_text`, `Item`.`recommend`, `Item`.`label_div`, `Item`.`memo`, `Item`.`created_user`, `Item`.`created`, `Item`.`modified_user`, `Item`.`modified`, `Item`.`delete_flg`, `Item`.`parent_item_id`, (COALESCE(IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price`, NULL), `Item`.`price`)) AS `Item__current_price`, (TRUNCATE (COALESCE(IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08)), NULL), `Item`.`price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08))), 0 ) ) AS `Item__current_price_withtax`, (IF(`Item`.`sale_price` IS NULL, 1, IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), 2, 1))) AS `Item__price_div`, (IF('2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`selling_date_from`, '1000-01-01') AND COALESCE(`Item`.`selling_date_to`, '9999-12-31'), 1, 2)) AS `Item__selling_div`, (IF(SYSDATE() BETWEEN `Item`.`sale_date_from` AND `Item`.`sale_date_to` ,true, false)) AS `Item__sales_term_flg`, (IF(`Item`.`item_variation_group_id` IS NULL OR `Item`.`item_variation_group_id` = "", "", (SELECT SUM(stock_quantity) AS sum_stock_quantity FROM items WHERE item_variation_group_id = `Item`.`item_variation_group_id` ) )) AS `Item__variation_sum_stock_quantity` FROM `sieve_stg`.`items` AS `Item` WHERE `Item`.`delete_flg` = 0 AND '2021-10-25 22:21:03' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND `Item`.`release_div` = 1 AND `Item`.`item_variation_group_id` IN ('5df19b21-8058-4ac1-b9b1-70490a00013d', '587ed60f-b34c-4804-8fd1-5be0a0104cac', '5fb258d0-a7bc-438e-8a61-3f930a00013d', '5fb258d1-ebb4-415d-a503-3f930a00013d', '5fb258d1-2aa8-43cb-bc0b-3f930a00013d', '5617b344-6a8c-47a9-b0e6-119231d4bbf8') AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) ORDER BY `core_item_flg` desc, `code` ASC | 17 | 17 | 13 | maybe slow |
| 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` = 'item_list' AND `Page`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
| 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` = '527b103b-d354-431c-8f8a-d644fd5ad003' AND `PagePart`.`delete_flg` = '0' ORDER BY `PagePart`.`display_section_div` ASC, `PagePart`.`display_order` ASC | 11 | 11 | 1 | maybe slow |
3 duplicate queries run.
sofa / ソファ 
chair / チェア 
table / テーブル 
storage / ストレージ 
rug / ラグ 
cushion / クッション 
clock / 時計 
goods / 雑貨・小物 
umbrella goods / 傘立て 
mentainance・cover / メンテナンス・カバー 
リビング / living
ダイニング / dining
