| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Brand`.`code` FROM `brands` AS `Brand` WHERE `Brand`.`delete_flg` = '0' | 0 | 0 | 11 | maybe slow |
| SELECT `Post`.`post_url`, `Post`.`code` FROM `posts` AS `Post` WHERE `post_url` != '' AND `post_div` = 1 AND `Post`.`delete_flg` = '0' | 0 | 0 | 12 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`item_options` AS `ItemOption` WHERE `ItemOption`.`delete_flg` = '0' | 1 | 1 | 8 | maybe slow |
| SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` IS NULL AND `Basket`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 10 | maybe slow |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '0601d5fb-7e39-48ab-bd00-00635450a89a' | 1 | 1 | 4 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '0601d5fb-7e39-48ab-bd00-00635450a89a' | 1 | 1 | 11 | maybe slow |
| INSERT INTO `kalmor_stg`.`baskets` (`id`, `data`, `modified`, `created`, `modified_user`) VALUES ('0601d5fb-7e39-48ab-bd00-00635450a89a', '{\"cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]},\"subscription_cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]}}', '2025-06-18 01:45:44', '2025-06-18 01:45:44', '-') | 1 | 1 | 5 | maybe slow |
| COMMIT | | | | |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`item_options` AS `ItemOption` WHERE `ItemOption`.`delete_flg` = '0' | 1 | 1 | 1 | |
| SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '0601d5fb-7e39-48ab-bd00-00635450a89a' 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 `kalmor_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2025-06-18' 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 `kalmor_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2025-06-18' 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 `kalmor_stg`.`pages` AS `Page` WHERE `code` = 'item' 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 `kalmor_stg`.`page_parts` AS `PagePart` LEFT JOIN `kalmor_stg`.`pages` AS `Page` ON (`PagePart`.`page_id` = `Page`.`id` AND `Page`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`parts` AS `Part` ON (`PagePart`.`part_id` = `Part`.`id` AND `Part`.`delete_flg` = '0') WHERE `page_id` = '527b8fa8-940c-47ae-96ba-e021fd5ad003' AND `PagePart`.`delete_flg` = '0' ORDER BY `PagePart`.`display_section_div` ASC, `PagePart`.`display_order` ASC | 15 | 15 | 1 | maybe slow |
| SELECT `RelatedItem`.`id`, `RelatedItem`.`parent_item_id`, `RelatedItem`.`child_item_id`, `RelatedItem`.`created_user`, `RelatedItem`.`created`, `RelatedItem`.`modified_user`, `RelatedItem`.`modified`, `RelatedItem`.`delete_flg`, `ParentItem`.`id`, `ParentItem`.`code`, `ParentItem`.`brand_id`, `ParentItem`.`name`, `ParentItem`.`title`, `ParentItem`.`name_kana`, `ParentItem`.`jan_code`, `ParentItem`.`smaregi_original_code`, `ParentItem`.`description`, `ParentItem`.`keywords`, `ParentItem`.`subscription_div`, `ParentItem`.`reservation_div`, `ParentItem`.`scheduled_arrival_date`, `ParentItem`.`release_div`, `ParentItem`.`only_member_flg`, `ParentItem`.`only_bussiness_flg`, `ParentItem`.`outlet_flg`, `ParentItem`.`not_purchase_flg`, `ParentItem`.`price_hidden_flg`, `ParentItem`.`set_item_flg`, `ParentItem`.`set_item_contents`, `ParentItem`.`disp_date_from`, `ParentItem`.`disp_date_to`, `ParentItem`.`selling_date_from`, `ParentItem`.`selling_date_to`, `ParentItem`.`sale_date_from`, `ParentItem`.`sale_date_to`, `ParentItem`.`price`, `ParentItem`.`sale_price`, `ParentItem`.`member_price`, `ParentItem`.`business_price`, `ParentItem`.`cost_price`, `ParentItem`.`shipping_weight`, `ParentItem`.`point_div`, `ParentItem`.`free_shipping_div`, `ParentItem`.`cool_div`, `ParentItem`.`specific_point`, `ParentItem`.`specific_point_date_from`, `ParentItem`.`specific_point_date_to`, `ParentItem`.`item_tags`, `ParentItem`.`item_list_tags`, `ParentItem`.`explain`, `ParentItem`.`explain2`, `ParentItem`.`wysiwyg_flg`, `ParentItem`.`wysiwyg_flg2`, `ParentItem`.`item_variation_group_id`, `ParentItem`.`stock_div`, `ParentItem`.`stock_quantity`, `ParentItem`.`warning_stock_quantity`, `ParentItem`.`lot_quantity`, `ParentItem`.`core_item_flg`, `ParentItem`.`disp_item_flg`, `ParentItem`.`item_variation_attribute1`, `ParentItem`.`item_variation_attribute2`, `ParentItem`.`item_variation_colorcode`, `ParentItem`.`tax_div`, `ParentItem`.`preview_image_index`, `ParentItem`.`brand`, `ParentItem`.`attribute1`, `ParentItem`.`attribute2`, `ParentItem`.`attribute3`, `ParentItem`.`attribute4`, `ParentItem`.`attribute5`, `ParentItem`.`attribute6`, `ParentItem`.`attribute7`, `ParentItem`.`attribute8`, `ParentItem`.`attribute9`, `ParentItem`.`attribute10`, `ParentItem`.`attribute11`, `ParentItem`.`attribute12`, `ParentItem`.`attribute13`, `ParentItem`.`attribute14`, `ParentItem`.`attribute15`, `ParentItem`.`item_option1`, `ParentItem`.`item_option2`, `ParentItem`.`item_option3`, `ParentItem`.`item_option4`, `ParentItem`.`item_option5`, `ParentItem`.`images`, `ParentItem`.`image_captions`, `ParentItem`.`representative_image`, `ParentItem`.`explain_image_display`, `ParentItem`.`point`, `ParentItem`.`google_product_category`, `ParentItem`.`pla_image`, `ParentItem`.`shipping_category_id`, `ParentItem`.`parts_id1`, `ParentItem`.`parts_id2`, `ParentItem`.`parts_id3`, `ParentItem`.`parts_id4`, `ParentItem`.`parts_id5`, `ParentItem`.`disp_inform_restock_flg`, `ParentItem`.`delivery_sources_id`, `ParentItem`.`external_cooperation_1`, `ParentItem`.`external_cooperation_2`, `ParentItem`.`external_cooperation_3`, `ParentItem`.`external_cooperation_4`, `ParentItem`.`external_cooperation_5`, `ParentItem`.`ga_page_view`, `ParentItem`.`avg_review`, `ParentItem`.`notice_text`, `ParentItem`.`recommend`, `ParentItem`.`label_div`, `ParentItem`.`memo`, `ParentItem`.`created_user`, `ParentItem`.`created`, `ParentItem`.`modified_user`, `ParentItem`.`modified`, `ParentItem`.`delete_flg`, (COALESCE(IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`sale_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`sale_date_to`, '9999-12-31'), `ParentItem`.`sale_price`, NULL), `ParentItem`.`price`)) AS `ParentItem__current_price`, (TRUNCATE (COALESCE(IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`sale_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`sale_date_to`, '9999-12-31'), `ParentItem`.`sale_price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08)), NULL), `ParentItem`.`price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08))), 0 ) ) AS `ParentItem__current_price_withtax`, (IF(`ParentItem`.`sale_price` IS NULL, 1, IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`sale_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`sale_date_to`, '9999-12-31'), 2, 1))) AS `ParentItem__price_div`, (IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`selling_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`selling_date_to`, '9999-12-31'), 1, 2)) AS `ParentItem__selling_div`, (IF(SYSDATE() BETWEEN `ParentItem`.`sale_date_from` AND `ParentItem`.`sale_date_to` ,true, false)) AS `ParentItem__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 `ParentItem__variation_sum_stock_quantity`, `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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`related_items` AS `RelatedItem` LEFT JOIN `kalmor_stg`.`items` AS `ParentItem` ON (`RelatedItem`.`parent_item_id` = `ParentItem`.`id` AND `ParentItem`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`items` AS `Item` ON (`RelatedItem`.`child_item_id` = `Item`.`id` AND `Item`.`delete_flg` = '0') WHERE `Item`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND `Item`.`release_div` = 1 AND `ParentItem`.`code` = 'NOL-0102-229' AND `RelatedItem`.`delete_flg` = '0' ORDER BY `Item`.`disp_date_from` desc | 0 | 0 | 3 | 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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`items` AS `Item` WHERE `Item`.`delete_flg` = 0 AND '2025-06-18 01:45:44' 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`.`code` = 'NOL-0102-229' AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) LIMIT 1 | 1 | 1 | 2 | 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 `kalmor_stg`.`set_item_relations` AS `SetItemRelation` WHERE `SetItemRelation`.`delete_flg` = '0' AND `SetItemRelation`.`parent_item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 0 | 0 | 0 | |
| 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 `kalmor_stg`.`item_category_relations` AS `ItemCategoryRelation` WHERE `ItemCategoryRelation`.`delete_flg` = '0' AND `ItemCategoryRelation`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 2 | 2 | 1 | maybe slow |
| 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 `kalmor_stg`.`item_keywords` AS `ItemKeyword` WHERE `ItemKeyword`.`delete_flg` = '0' AND `ItemKeyword`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 0 | 0 | 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`, `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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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`, `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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_category_relations` AS `ItemCategoryRelation` LEFT JOIN `kalmor_stg`.`items` AS `Item` ON (`ItemCategoryRelation`.`item_id` = `Item`.`id` AND `Item`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`item_categories` AS `ItemCategory` ON (`ItemCategoryRelation`.`item_category_id` = `ItemCategory`.`id` AND `ItemCategory`.`delete_flg` = '0') WHERE `ItemCategoryRelation`.`item_id` <> '9be3a5e3-2454-4934-a6e8-2917557f9a2e' AND `ItemCategoryRelation`.`item_category_id` IN ('da1d3750-ef3b-4407-addd-34d1a6f67c1f', '98c9cf36-2eb6-4909-bbf4-2d0c733bb800') AND ((`Item`.`stock_div` = 0) OR (((`Item`.`stock_div` = 1) AND (`Item`.`stock_quantity` > 0)))) AND `ItemCategoryRelation`.`delete_flg` = '0' GROUP BY `Item`.`id` | 20 | 20 | 5 | 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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`items` AS `Item` WHERE `Item`.`code` = 'NOL-0102-229' AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) LIMIT 1 | 1 | 1 | 2 | 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 `kalmor_stg`.`set_item_relations` AS `SetItemRelation` WHERE `SetItemRelation`.`delete_flg` = '0' AND `SetItemRelation`.`parent_item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 0 | 0 | 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 `kalmor_stg`.`item_category_relations` AS `ItemCategoryRelation` WHERE `ItemCategoryRelation`.`delete_flg` = '0' AND `ItemCategoryRelation`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 2 | 2 | 1 | maybe slow |
| 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 `kalmor_stg`.`item_keywords` AS `ItemKeyword` WHERE `ItemKeyword`.`delete_flg` = '0' AND `ItemKeyword`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 0 | 0 | 0 | |
| 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 `kalmor_stg`.`parts` AS `Part` WHERE `Part`.`id` IS NULL AND `Part`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 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 `kalmor_stg`.`parts` AS `Part` WHERE `Part`.`id` IS NULL AND `Part`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 0 | |
| 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 `kalmor_stg`.`parts` AS `Part` WHERE `Part`.`id` IS NULL AND `Part`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 0 | |
| 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 `kalmor_stg`.`parts` AS `Part` WHERE `Part`.`id` IS NULL AND `Part`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 0 | |
| 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 `kalmor_stg`.`parts` AS `Part` WHERE `Part`.`id` IS NULL AND `Part`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 0 | |
| 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND ((`ItemCategory`.`parent_category_tree` IS NULL) OR (`ItemCategory`.`parent_category_tree` = '')) 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`.`display_order` ASC | 14 | 14 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND ((`ItemCategory`.`parent_category_tree` IS NULL) OR (`ItemCategory`.`parent_category_tree` = '')) 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`.`display_order` ASC | 14 | 14 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:b4db7370-0e3e-4c19-9b34-e1a87db543ee' 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`.`display_order` ASC | 9 | 9 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:690186aa-07ab-4a50-aefb-e3569241dcad' 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`.`display_order` ASC | 14 | 14 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:f809a95b-cdbb-413f-8b83-2a53f3916c9a' 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`.`display_order` ASC | 9 | 9 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:1f5017ba-1d20-4590-9874-9ce75e6db86a' 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`.`display_order` ASC | 4 | 4 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:da1d3750-ef3b-4407-addd-34d1a6f67c1f' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:35559e87-22d2-4288-bb31-e74e7d9d6435' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:123c595b-efd3-41d5-bc71-fe924a41cbf7' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:0d07eeaf-4c7a-49e3-aecd-f01c028b1740' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:b2ff351d-60cb-4c8f-9f0b-dec9b96ef734' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:960048a9-3597-423a-b100-f6abba553f4d' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:d5f12a2a-3257-4da2-9204-b1f9bd7f656e' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:cd895858-43e5-4655-88a1-144a3a8aed46' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:f72f8ba3-cc25-4ce0-afce-4dc24821c375' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:49dda0e6-66b4-4387-aaed-eb344968cc28' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND ((`ItemCategory`.`parent_category_tree` IS NULL) OR (`ItemCategory`.`parent_category_tree` = '')) 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`.`display_order` ASC | 14 | 14 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:b4db7370-0e3e-4c19-9b34-e1a87db543ee' 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`.`display_order` ASC | 9 | 9 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:98c9cf36-2eb6-4909-bbf4-2d0c733bb800' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:288b7c73-44bb-4104-99b9-bc1029cf8a78' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:e5b361a2-df42-42b7-a168-4e40dcb917c2' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:bba7216d-986d-4fc3-8f7a-36fae6395c6e' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:3ea073aa-17de-47d4-a69c-5f2ae0580be0' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:7448cdd7-4ed4-49d8-aad5-f826e683afa6' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:15b10234-965c-45d1-8047-20adffa1ba71' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:a87d7a3e-cf84-4b27-b1bb-c85d7cef6808' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:1a460079-daf3-44bd-b5ca-f2627ced5293' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:690186aa-07ab-4a50-aefb-e3569241dcad' 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`.`display_order` ASC | 14 | 14 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:6d5abac8-18ab-4291-b4c2-685869639041' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:12f63f72-6fa1-47a1-88fa-41116fb48f1f' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:93e70d41-1d5b-4705-b0d7-0a3bba1a8153' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:4f88c3cc-f6f5-40b7-b172-f827bab753cb' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:79abfe18-ffbb-4f83-9332-c0e47d1381a5' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:1bdd365a-7967-4862-abe2-30e82ed541ca' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:5da7b573-6a8d-4ca3-a656-6d4f98c73b5f' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:9b725cbd-7547-4510-b3a2-b3604ff73340' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:483edbd6-9a15-496e-ba32-63d50b1f1e00' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:701816fd-d43a-4049-905f-f9df717905a2' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:127e038c-1ac9-4dfc-9ac5-e162fef4b1a1' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:06c41f66-cda7-47dc-ae1e-a481c5afc1c3' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:ebbb1c3c-df39-4a49-994e-5f4340cea7cc' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:55621a46-c2c6-4487-977e-f6cac39fa621' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:f809a95b-cdbb-413f-8b83-2a53f3916c9a' 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`.`display_order` ASC | 9 | 9 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:b9f8693f-7627-412d-a013-62f6dd298e47' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:7ae1d3be-040e-475a-9dd3-ce66b6d4dfa2' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:ce118c5d-7b6b-4014-81b9-e0971159bf81' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:311551be-76de-49d6-b152-cb58174bb3c4' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:e118ffae-60f3-4e08-8ae9-71c019c36439' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:0de22cb4-6f39-4b57-a7ed-4e55d53b2018' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:9ee161df-b3d8-43d3-a91c-8edb16ea5335' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:4afb5f1c-84f7-4251-a2c2-a90ebf2fbb32' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:2c53fd12-b9ea-46ce-93e4-a52eae9576c7' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:1f5017ba-1d20-4590-9874-9ce75e6db86a' 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`.`display_order` ASC | 4 | 4 | 3 | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:941d3318-da89-4a46-8e3e-3b98a9468c34' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:21d72fb2-f06e-4ddf-bff8-7da578f5cfd9' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:55f06458-7a63-48f8-8adb-78fc918f95e6' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:964583ae-8095-454c-b374-a00a24abd674' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:da1d3750-ef3b-4407-addd-34d1a6f67c1f' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:35559e87-22d2-4288-bb31-e74e7d9d6435' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:123c595b-efd3-41d5-bc71-fe924a41cbf7' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:0d07eeaf-4c7a-49e3-aecd-f01c028b1740' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:b2ff351d-60cb-4c8f-9f0b-dec9b96ef734' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:960048a9-3597-423a-b100-f6abba553f4d' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:d5f12a2a-3257-4da2-9204-b1f9bd7f656e' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:cd895858-43e5-4655-88a1-144a3a8aed46' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:f72f8ba3-cc25-4ce0-afce-4dc24821c375' 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`.`display_order` ASC | 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 10 AND `ItemCategory`.`parent_category_tree` LIKE '%:49dda0e6-66b4-4387-aaed-eb344968cc28' 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`.`display_order` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `Calendar`.`id`, `Calendar`.`target_date`, `Calendar`.`calendar_status_div`, `Calendar`.`description`, `Calendar`.`link_url`, `Calendar`.`calendar_icon_div`, `Calendar`.`label_div`, `Calendar`.`memo`, `Calendar`.`created_user`, `Calendar`.`created`, `Calendar`.`modified_user`, `Calendar`.`modified`, `Calendar`.`delete_flg` FROM `kalmor_stg`.`calendars` AS `Calendar` WHERE `Calendar`.`target_date` >= '2025-06-01 00:00:00' AND `Calendar`.`target_date` <= '2025-06-30 23:59:59' AND `Calendar`.`delete_flg` = '0' ORDER BY `Calendar`.`target_date` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `Calendar`.`id`, `Calendar`.`target_date`, `Calendar`.`calendar_status_div`, `Calendar`.`description`, `Calendar`.`link_url`, `Calendar`.`calendar_icon_div`, `Calendar`.`label_div`, `Calendar`.`memo`, `Calendar`.`created_user`, `Calendar`.`created`, `Calendar`.`modified_user`, `Calendar`.`modified`, `Calendar`.`delete_flg` FROM `kalmor_stg`.`calendars` AS `Calendar` WHERE `Calendar`.`target_date` >= '2025-07-01 00:00:00' AND `Calendar`.`target_date` <= '2025-07-31 23:59:59' AND `Calendar`.`delete_flg` = '0' ORDER BY `Calendar`.`target_date` ASC | 0 | 0 | 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 `kalmor_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 `kalmor_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 `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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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`, `ItemOption1`.`id`, `ItemOption1`.`code`, `ItemOption1`.`item_option_div`, `ItemOption1`.`required_div`, `ItemOption1`.`title`, `ItemOption1`.`option_detail`, `ItemOption1`.`explain`, `ItemOption1`.`label_div`, `ItemOption1`.`image`, `ItemOption1`.`image_sp`, `ItemOption1`.`memo`, `ItemOption1`.`created_user`, `ItemOption1`.`created`, `ItemOption1`.`modified_user`, `ItemOption1`.`modified`, `ItemOption1`.`delete_flg`, `ItemOption2`.`id`, `ItemOption2`.`code`, `ItemOption2`.`item_option_div`, `ItemOption2`.`required_div`, `ItemOption2`.`title`, `ItemOption2`.`option_detail`, `ItemOption2`.`explain`, `ItemOption2`.`label_div`, `ItemOption2`.`image`, `ItemOption2`.`image_sp`, `ItemOption2`.`memo`, `ItemOption2`.`created_user`, `ItemOption2`.`created`, `ItemOption2`.`modified_user`, `ItemOption2`.`modified`, `ItemOption2`.`delete_flg`, `ItemOption3`.`id`, `ItemOption3`.`code`, `ItemOption3`.`item_option_div`, `ItemOption3`.`required_div`, `ItemOption3`.`title`, `ItemOption3`.`option_detail`, `ItemOption3`.`explain`, `ItemOption3`.`label_div`, `ItemOption3`.`image`, `ItemOption3`.`image_sp`, `ItemOption3`.`memo`, `ItemOption3`.`created_user`, `ItemOption3`.`created`, `ItemOption3`.`modified_user`, `ItemOption3`.`modified`, `ItemOption3`.`delete_flg`, `ItemOption4`.`id`, `ItemOption4`.`code`, `ItemOption4`.`item_option_div`, `ItemOption4`.`required_div`, `ItemOption4`.`title`, `ItemOption4`.`option_detail`, `ItemOption4`.`explain`, `ItemOption4`.`label_div`, `ItemOption4`.`image`, `ItemOption4`.`image_sp`, `ItemOption4`.`memo`, `ItemOption4`.`created_user`, `ItemOption4`.`created`, `ItemOption4`.`modified_user`, `ItemOption4`.`modified`, `ItemOption4`.`delete_flg`, `ItemOption5`.`id`, `ItemOption5`.`code`, `ItemOption5`.`item_option_div`, `ItemOption5`.`required_div`, `ItemOption5`.`title`, `ItemOption5`.`option_detail`, `ItemOption5`.`explain`, `ItemOption5`.`label_div`, `ItemOption5`.`image`, `ItemOption5`.`image_sp`, `ItemOption5`.`memo`, `ItemOption5`.`created_user`, `ItemOption5`.`created`, `ItemOption5`.`modified_user`, `ItemOption5`.`modified`, `ItemOption5`.`delete_flg` FROM `kalmor_stg`.`items` AS `Item` LEFT JOIN `kalmor_stg`.`item_options` AS `ItemOption1` ON (`Item`.`item_option1` = `ItemOption1`.`id` AND `ItemOption1`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`item_options` AS `ItemOption2` ON (`Item`.`item_option2` = `ItemOption2`.`id` AND `ItemOption1`.`delete_flg` = '0' AND `ItemOption2`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`item_options` AS `ItemOption3` ON (`Item`.`item_option3` = `ItemOption3`.`id` AND `ItemOption1`.`delete_flg` = '0' AND `ItemOption3`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`item_options` AS `ItemOption4` ON (`Item`.`item_option4` = `ItemOption4`.`id` AND `ItemOption1`.`delete_flg` = '0' AND `ItemOption4`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`item_options` AS `ItemOption5` ON (`Item`.`item_option5` = `ItemOption5`.`id` AND `ItemOption1`.`delete_flg` = '0' AND `ItemOption5`.`delete_flg` = '0') WHERE `Item`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND `Item`.`release_div` != 0 AND `Item`.`code` = 'NOL-0102-229' AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) LIMIT 1 | 1 | 1 | 2 | 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 `kalmor_stg`.`set_item_relations` AS `SetItemRelation` WHERE `SetItemRelation`.`delete_flg` = '0' AND `SetItemRelation`.`parent_item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 0 | 0 | 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 `kalmor_stg`.`item_category_relations` AS `ItemCategoryRelation` WHERE `ItemCategoryRelation`.`delete_flg` = '0' AND `ItemCategoryRelation`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 2 | 2 | 1 | maybe slow |
| 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 `kalmor_stg`.`item_keywords` AS `ItemKeyword` WHERE `ItemKeyword`.`delete_flg` = '0' AND `ItemKeyword`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') | 0 | 0 | 0 | |
| 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`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `kalmor_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`code` = 'home' AND `ItemCategory`.`delete_flg` = '0' AND ((`ItemCategory`.`only_bussiness_flg` = '0') OR (`ItemCategory`.`only_bussiness_flg` IS NULL) OR (`ItemCategory`.`only_bussiness_flg` = '0')) LIMIT 1 | 1 | 1 | 1 | |
| 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 `kalmor_stg`.`item_category_relations` AS `ItemCategoryRelation` WHERE `ItemCategoryRelation`.`delete_flg` = '0' AND `ItemCategoryRelation`.`item_category_id` = ('b4db7370-0e3e-4c19-9b34-e1a87db543ee') | 0 | 0 | 1 | maybe slow |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '0601d5fb-7e39-48ab-bd00-00635450a89a' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '0601d5fb-7e39-48ab-bd00-00635450a89a' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '0601d5fb-7e39-48ab-bd00-00635450a89a' | 1 | 1 | 0 | |
| UPDATE `kalmor_stg`.`baskets` SET `id` = '0601d5fb-7e39-48ab-bd00-00635450a89a', `data` = '{\"cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[],\"history\":[\"9be3a5e3-2454-4934-a6e8-2917557f9a2e\"]},\"subscription_cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]}}', `modified` = '2025-06-18 01:45:44', `modified_user` = '-' WHERE `kalmor_stg`.`baskets`.`id` = '0601d5fb-7e39-48ab-bd00-00635450a89a' | 1 | 1 | 4 | maybe slow |
| COMMIT | | | | |
| SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`member_favorite_items` AS `MemberFavoriteItem` LEFT JOIN `kalmor_stg`.`items` AS `Item` ON (`MemberFavoriteItem`.`item_id` = `Item`.`id` AND `Item`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`members` AS `Member` ON (`MemberFavoriteItem`.`member_id` = `Member`.`id` AND `Member`.`delete_flg` = '0') WHERE `item_id` = '9be3a5e3-2454-4934-a6e8-2917557f9a2e' AND `MemberFavoriteItem`.`delete_flg` = '0' | 1 | 1 | 1 | |
| SELECT DISTINCT(`BuyRelatedItem`.`child_item_id`) FROM `kalmor_stg`.`buy_related_items` AS `BuyRelatedItem` LEFT JOIN `kalmor_stg`.`items` AS `ChildItem` ON (`BuyRelatedItem`.`child_item_id` = `ChildItem`.`id` AND `ChildItem`.`delete_flg` = '0') WHERE `BuyRelatedItem`.`parent_item_id` = '9be3a5e3-2454-4934-a6e8-2917557f9a2e' AND `BuyRelatedItem`.`delete_flg` = '0' ORDER BY `BuyRelatedItem`.`buy_count` DESC, `ChildItem`.`code` ASC LIMIT 4 | 0 | 0 | 1 | maybe slow |
| SELECT `SalesRanking`.`id`, `SalesRanking`.`rank`, `SalesRanking`.`item_category_id`, `SalesRanking`.`item_id`, `SalesRanking`.`sales_amount`, `SalesRanking`.`sales_count`, `SalesRanking`.`created_user`, `SalesRanking`.`created`, `SalesRanking`.`modified_user`, `SalesRanking`.`modified`, `SalesRanking`.`delete_flg`, `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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`sales_rankings` AS `SalesRanking` LEFT JOIN `kalmor_stg`.`items` AS `Item` ON (`SalesRanking`.`item_id` = `Item`.`id` AND `Item`.`delete_flg` = '0') WHERE '2025-06-18 01:45:44' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND '2025-06-18 01:45:44' BETWEEN COALESCE(`Item`.`selling_date_from`, '1000-01-01') AND COALESCE(`Item`.`selling_date_to`, '9999-12-31') AND `Item`.`release_div` = 1 AND ((`Item`.`stock_div` = 0) OR (((`Item`.`stock_div` = 1) AND (`Item`.`stock_quantity` > 0)))) AND NOT (`SalesRanking`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e')) AND `SalesRanking`.`delete_flg` = '0' ORDER BY rand() ASC LIMIT 4 | 0 | 0 | 2 | maybe slow |
| SELECT `RelatedItem`.`id`, `RelatedItem`.`parent_item_id`, `RelatedItem`.`child_item_id`, `RelatedItem`.`created_user`, `RelatedItem`.`created`, `RelatedItem`.`modified_user`, `RelatedItem`.`modified`, `RelatedItem`.`delete_flg`, `ParentItem`.`id`, `ParentItem`.`code`, `ParentItem`.`brand_id`, `ParentItem`.`name`, `ParentItem`.`title`, `ParentItem`.`name_kana`, `ParentItem`.`jan_code`, `ParentItem`.`smaregi_original_code`, `ParentItem`.`description`, `ParentItem`.`keywords`, `ParentItem`.`subscription_div`, `ParentItem`.`reservation_div`, `ParentItem`.`scheduled_arrival_date`, `ParentItem`.`release_div`, `ParentItem`.`only_member_flg`, `ParentItem`.`only_bussiness_flg`, `ParentItem`.`outlet_flg`, `ParentItem`.`not_purchase_flg`, `ParentItem`.`price_hidden_flg`, `ParentItem`.`set_item_flg`, `ParentItem`.`set_item_contents`, `ParentItem`.`disp_date_from`, `ParentItem`.`disp_date_to`, `ParentItem`.`selling_date_from`, `ParentItem`.`selling_date_to`, `ParentItem`.`sale_date_from`, `ParentItem`.`sale_date_to`, `ParentItem`.`price`, `ParentItem`.`sale_price`, `ParentItem`.`member_price`, `ParentItem`.`business_price`, `ParentItem`.`cost_price`, `ParentItem`.`shipping_weight`, `ParentItem`.`point_div`, `ParentItem`.`free_shipping_div`, `ParentItem`.`cool_div`, `ParentItem`.`specific_point`, `ParentItem`.`specific_point_date_from`, `ParentItem`.`specific_point_date_to`, `ParentItem`.`item_tags`, `ParentItem`.`item_list_tags`, `ParentItem`.`explain`, `ParentItem`.`explain2`, `ParentItem`.`wysiwyg_flg`, `ParentItem`.`wysiwyg_flg2`, `ParentItem`.`item_variation_group_id`, `ParentItem`.`stock_div`, `ParentItem`.`stock_quantity`, `ParentItem`.`warning_stock_quantity`, `ParentItem`.`lot_quantity`, `ParentItem`.`core_item_flg`, `ParentItem`.`disp_item_flg`, `ParentItem`.`item_variation_attribute1`, `ParentItem`.`item_variation_attribute2`, `ParentItem`.`item_variation_colorcode`, `ParentItem`.`tax_div`, `ParentItem`.`preview_image_index`, `ParentItem`.`brand`, `ParentItem`.`attribute1`, `ParentItem`.`attribute2`, `ParentItem`.`attribute3`, `ParentItem`.`attribute4`, `ParentItem`.`attribute5`, `ParentItem`.`attribute6`, `ParentItem`.`attribute7`, `ParentItem`.`attribute8`, `ParentItem`.`attribute9`, `ParentItem`.`attribute10`, `ParentItem`.`attribute11`, `ParentItem`.`attribute12`, `ParentItem`.`attribute13`, `ParentItem`.`attribute14`, `ParentItem`.`attribute15`, `ParentItem`.`item_option1`, `ParentItem`.`item_option2`, `ParentItem`.`item_option3`, `ParentItem`.`item_option4`, `ParentItem`.`item_option5`, `ParentItem`.`images`, `ParentItem`.`image_captions`, `ParentItem`.`representative_image`, `ParentItem`.`explain_image_display`, `ParentItem`.`point`, `ParentItem`.`google_product_category`, `ParentItem`.`pla_image`, `ParentItem`.`shipping_category_id`, `ParentItem`.`parts_id1`, `ParentItem`.`parts_id2`, `ParentItem`.`parts_id3`, `ParentItem`.`parts_id4`, `ParentItem`.`parts_id5`, `ParentItem`.`disp_inform_restock_flg`, `ParentItem`.`delivery_sources_id`, `ParentItem`.`external_cooperation_1`, `ParentItem`.`external_cooperation_2`, `ParentItem`.`external_cooperation_3`, `ParentItem`.`external_cooperation_4`, `ParentItem`.`external_cooperation_5`, `ParentItem`.`ga_page_view`, `ParentItem`.`avg_review`, `ParentItem`.`notice_text`, `ParentItem`.`recommend`, `ParentItem`.`label_div`, `ParentItem`.`memo`, `ParentItem`.`created_user`, `ParentItem`.`created`, `ParentItem`.`modified_user`, `ParentItem`.`modified`, `ParentItem`.`delete_flg`, (COALESCE(IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`sale_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`sale_date_to`, '9999-12-31'), `ParentItem`.`sale_price`, NULL), `ParentItem`.`price`)) AS `ParentItem__current_price`, (TRUNCATE (COALESCE(IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`sale_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`sale_date_to`, '9999-12-31'), `ParentItem`.`sale_price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08)), NULL), `ParentItem`.`price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08))), 0 ) ) AS `ParentItem__current_price_withtax`, (IF(`ParentItem`.`sale_price` IS NULL, 1, IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`sale_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`sale_date_to`, '9999-12-31'), 2, 1))) AS `ParentItem__price_div`, (IF('2025-06-18 01:45:44' BETWEEN COALESCE(`ParentItem`.`selling_date_from`, '1000-01-01') AND COALESCE(`ParentItem`.`selling_date_to`, '9999-12-31'), 1, 2)) AS `ParentItem__selling_div`, (IF(SYSDATE() BETWEEN `ParentItem`.`sale_date_from` AND `ParentItem`.`sale_date_to` ,true, false)) AS `ParentItem__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 `ParentItem__variation_sum_stock_quantity`, `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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`related_items` AS `RelatedItem` LEFT JOIN `kalmor_stg`.`items` AS `ParentItem` ON (`RelatedItem`.`parent_item_id` = `ParentItem`.`id` AND `ParentItem`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`items` AS `Item` ON (`RelatedItem`.`child_item_id` = `Item`.`id` AND `Item`.`delete_flg` = '0') WHERE `Item`.`delete_flg` = 0 AND '2025-06-18 01:45:44' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND `Item`.`release_div` = 1 AND `ParentItem`.`code` = 'NOL-0102-229' AND `RelatedItem`.`delete_flg` = '0' ORDER BY `Item`.`disp_date_from` desc | 0 | 0 | 2 | 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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`items` AS `Item` WHERE `Item`.`id` = '9be3a5e3-2454-4934-a6e8-2917557f9a2e' AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Review`.`id`, `Review`.`order_detail_id`, `Review`.`item_id`, `Review`.`member_id`, `Review`.`rank_div`, `Review`.`title`, `Review`.`image`, `Review`.`prefecture_div`, `Review`.`age`, `Review`.`sex_div`, `Review`.`comment`, `Review`.`post_date`, `Review`.`review_status_div`, `Review`.`reply_comment`, `Review`.`reply_post_date`, `Review`.`reply_review_status_div`, `Review`.`mail_sender_div`, `Review`.`label_div`, `Review`.`memo`, `Review`.`created_user`, `Review`.`created`, `Review`.`modified_user`, `Review`.`modified`, `Review`.`delete_flg`, `OrderDetail`.`id`, `OrderDetail`.`order_id`, `OrderDetail`.`order_shipping_id`, `OrderDetail`.`order_detail_status_div`, `OrderDetail`.`item_id`, `OrderDetail`.`item_code`, `OrderDetail`.`jan_code`, `OrderDetail`.`item_title`, `OrderDetail`.`reservation_div`, `OrderDetail`.`scheduled_arrival_date`, `OrderDetail`.`set_item_contents`, `OrderDetail`.`variation_attribute1`, `OrderDetail`.`variation_attribute2`, `OrderDetail`.`variation_attribute1_selected`, `OrderDetail`.`variation_attribute2_selected`, `OrderDetail`.`item_option_id`, `OrderDetail`.`item_option_code`, `OrderDetail`.`item_option_title`, `OrderDetail`.`item_option_key_selected`, `OrderDetail`.`item_option_name_selected`, `OrderDetail`.`price_div`, `OrderDetail`.`price`, `OrderDetail`.`cost_price`, `OrderDetail`.`price_with_tax`, `OrderDetail`.`quantity`, `OrderDetail`.`sub_total`, `OrderDetail`.`sub_total_with_tax`, `OrderDetail`.`base_price`, `OrderDetail`.`base_price_with_tax`, `OrderDetail`.`base_sub_total`, `OrderDetail`.`base_sub_total_with_tax`, `OrderDetail`.`shipping_category_id`, `OrderDetail`.`shipping_category_code`, `OrderDetail`.`shipping_category_name`, `OrderDetail`.`shipping_category_fee`, `OrderDetail`.`shipping_category_fee_with_tax`, `OrderDetail`.`tax_div`, `OrderDetail`.`tax_ratio`, `OrderDetail`.`parent_order_detail_id`, `OrderDetail`.`option_id`, `OrderDetail`.`option_code`, `OrderDetail`.`option_title`, `OrderDetail`.`selected_option_code`, `OrderDetail`.`selected_option_title`, `OrderDetail`.`label_div`, `OrderDetail`.`memo`, `OrderDetail`.`created_user`, `OrderDetail`.`created`, `OrderDetail`.`modified_user`, `OrderDetail`.`modified`, `OrderDetail`.`delete_flg` FROM `kalmor_stg`.`reviews` AS `Review` left JOIN `kalmor_stg`.`order_details` AS `OrderDetail` ON (`Review`.`order_detail_id` = `OrderDetail`.`id` AND `OrderDetail`.`delete_flg` = '0') WHERE `Review`.`item_id` = ('9be3a5e3-2454-4934-a6e8-2917557f9a2e') AND `Review`.`review_status_div` = 1 AND `Review`.`delete_flg` = '0' ORDER BY `Review`.`post_date` desc | 2 | 2 | 1 | maybe slow |
| SELECT `Order`.`id`, `Order`.`order_no`, `Order`.`order_div`, `Order`.`reservation_order_div`, `Order`.`subscription_id`, `Order`.`subscription_no`, `Order`.`last_scheduled_arrival_date`, `Order`.`member_id`, `Order`.`member_no`, `Order`.`email`, `Order`.`order_date`, `Order`.`coupon_id`, `Order`.`coupon_group_id`, `Order`.`coupon_code`, `Order`.`coupon_name`, `Order`.`coupon_discount_ratio`, `Order`.`coupon_discount_amount`, `Order`.`get_point`, `Order`.`use_point`, `Order`.`purchase_amount`, `Order`.`purchase_amount_origin`, `Order`.`tax_div_1_amount`, `Order`.`tax_div_2_amount`, `Order`.`total_price`, `Order`.`tax_amount`, `Order`.`tax_ratio`, `Order`.`discount_amount`, `Order`.`last_name`, `Order`.`first_name`, `Order`.`last_name_kana`, `Order`.`first_name_kana`, `Order`.`zip`, `Order`.`prefecture_div`, `Order`.`address1`, `Order`.`address2`, `Order`.`member_div`, `Order`.`company`, `Order`.`division`, `Order`.`tel`, `Order`.`birth_date`, `Order`.`age`, `Order`.`sex_div`, `Order`.`payment_method_id`, `Order`.`credit_card_payment_div`, `Order`.`credit_card_payment_count`, `Order`.`credit_deadline`, `Order`.`cvs_div`, `Order`.`cvs_receipt_no`, `Order`.`cvs_company_code`, `Order`.`cvs_payment_url`, `Order`.`cvs_payment_limit_date`, `Order`.`fba_shipping_status`, `Order`.`payment_confirm_div`, `Order`.`payment_date`, `Order`.`payment_fee`, `Order`.`payment_fee_with_tax`, `Order`.`device_div`, `Order`.`transaction_code`, `Order`.`rakuten_basket_id`, `Order`.`rakuten_request_id`, `Order`.`option1_title`, `Order`.`option1_value`, `Order`.`option2_title`, `Order`.`option2_value`, `Order`.`option3_title`, `Order`.`option3_value`, `Order`.`option4_title`, `Order`.`option4_value`, `Order`.`option5_title`, `Order`.`option5_value`, `Order`.`user_agent`, `Order`.`host_ip`, `Order`.`user_note`, `Order`.`review_request_mail_send_div`, `Order`.`ordering_flg`, `Order`.`receipt_issued_flg`, `Order`.`filtering_flg`, `Order`.`label_div`, `Order`.`memo`, `Order`.`created_user`, `Order`.`created`, `Order`.`modified_user`, `Order`.`modified`, `Order`.`delete_flg` FROM `kalmor_stg`.`orders` AS `Order` WHERE `Order`.`id` = '9189680b-53c9-4fb7-84c2-5c0b6605a83a' | 1 | 1 | 1 | |
| 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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`items` AS `Item` WHERE `Item`.`id` = '9be3a5e3-2454-4934-a6e8-2917557f9a2e' | 1 | 1 | 1 | |
| SELECT `OrderDetailItemOption`.`id`, `OrderDetailItemOption`.`order_detail_id`, `OrderDetailItemOption`.`item_option_id`, `OrderDetailItemOption`.`item_option_code`, `OrderDetailItemOption`.`item_option_title`, `OrderDetailItemOption`.`item_option_key_selected`, `OrderDetailItemOption`.`item_option_name_selected`, `OrderDetailItemOption`.`item_option_text_inputted`, `OrderDetailItemOption`.`price`, `OrderDetailItemOption`.`price_with_tax`, `OrderDetailItemOption`.`label_div`, `OrderDetailItemOption`.`memo`, `OrderDetailItemOption`.`created_user`, `OrderDetailItemOption`.`created`, `OrderDetailItemOption`.`modified_user`, `OrderDetailItemOption`.`modified`, `OrderDetailItemOption`.`delete_flg` FROM `kalmor_stg`.`order_detail_item_options` AS `OrderDetailItemOption` WHERE `OrderDetailItemOption`.`order_detail_id` = ('63b432e2-12e3-456c-9c00-a693e628cc49') | 0 | 0 | 1 | maybe slow |
| SELECT `Order`.`id`, `Order`.`order_no`, `Order`.`order_div`, `Order`.`reservation_order_div`, `Order`.`subscription_id`, `Order`.`subscription_no`, `Order`.`last_scheduled_arrival_date`, `Order`.`member_id`, `Order`.`member_no`, `Order`.`email`, `Order`.`order_date`, `Order`.`coupon_id`, `Order`.`coupon_group_id`, `Order`.`coupon_code`, `Order`.`coupon_name`, `Order`.`coupon_discount_ratio`, `Order`.`coupon_discount_amount`, `Order`.`get_point`, `Order`.`use_point`, `Order`.`purchase_amount`, `Order`.`purchase_amount_origin`, `Order`.`tax_div_1_amount`, `Order`.`tax_div_2_amount`, `Order`.`total_price`, `Order`.`tax_amount`, `Order`.`tax_ratio`, `Order`.`discount_amount`, `Order`.`last_name`, `Order`.`first_name`, `Order`.`last_name_kana`, `Order`.`first_name_kana`, `Order`.`zip`, `Order`.`prefecture_div`, `Order`.`address1`, `Order`.`address2`, `Order`.`member_div`, `Order`.`company`, `Order`.`division`, `Order`.`tel`, `Order`.`birth_date`, `Order`.`age`, `Order`.`sex_div`, `Order`.`payment_method_id`, `Order`.`credit_card_payment_div`, `Order`.`credit_card_payment_count`, `Order`.`credit_deadline`, `Order`.`cvs_div`, `Order`.`cvs_receipt_no`, `Order`.`cvs_company_code`, `Order`.`cvs_payment_url`, `Order`.`cvs_payment_limit_date`, `Order`.`fba_shipping_status`, `Order`.`payment_confirm_div`, `Order`.`payment_date`, `Order`.`payment_fee`, `Order`.`payment_fee_with_tax`, `Order`.`device_div`, `Order`.`transaction_code`, `Order`.`rakuten_basket_id`, `Order`.`rakuten_request_id`, `Order`.`option1_title`, `Order`.`option1_value`, `Order`.`option2_title`, `Order`.`option2_value`, `Order`.`option3_title`, `Order`.`option3_value`, `Order`.`option4_title`, `Order`.`option4_value`, `Order`.`option5_title`, `Order`.`option5_value`, `Order`.`user_agent`, `Order`.`host_ip`, `Order`.`user_note`, `Order`.`review_request_mail_send_div`, `Order`.`ordering_flg`, `Order`.`receipt_issued_flg`, `Order`.`filtering_flg`, `Order`.`label_div`, `Order`.`memo`, `Order`.`created_user`, `Order`.`created`, `Order`.`modified_user`, `Order`.`modified`, `Order`.`delete_flg` FROM `kalmor_stg`.`orders` AS `Order` WHERE `Order`.`id` = 'ad564d4f-c7f2-43d0-a937-b8e9eb0e44a9' | 1 | 1 | 1 | |
| 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`.`disp_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`.`explain_image_display`, `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`, (COALESCE(IF('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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('2025-06-18 01:45:44' 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 `kalmor_stg`.`items` AS `Item` WHERE `Item`.`id` = '9be3a5e3-2454-4934-a6e8-2917557f9a2e' | 1 | 1 | 1 | |
| SELECT `OrderDetailItemOption`.`id`, `OrderDetailItemOption`.`order_detail_id`, `OrderDetailItemOption`.`item_option_id`, `OrderDetailItemOption`.`item_option_code`, `OrderDetailItemOption`.`item_option_title`, `OrderDetailItemOption`.`item_option_key_selected`, `OrderDetailItemOption`.`item_option_name_selected`, `OrderDetailItemOption`.`item_option_text_inputted`, `OrderDetailItemOption`.`price`, `OrderDetailItemOption`.`price_with_tax`, `OrderDetailItemOption`.`label_div`, `OrderDetailItemOption`.`memo`, `OrderDetailItemOption`.`created_user`, `OrderDetailItemOption`.`created`, `OrderDetailItemOption`.`modified_user`, `OrderDetailItemOption`.`modified`, `OrderDetailItemOption`.`delete_flg` FROM `kalmor_stg`.`order_detail_item_options` AS `OrderDetailItemOption` WHERE `OrderDetailItemOption`.`order_detail_id` = ('9d2ff4ad-a650-4ffe-998d-b8d17ecad81f') | 0 | 0 | 1 | maybe slow |
| SELECT `ItemVariationGroup`.`id`, `ItemVariationGroup`.`code`, `ItemVariationGroup`.`explain`, `ItemVariationGroup`.`attribute1`, `ItemVariationGroup`.`attribute2`, `ItemVariationGroup`.`label_div`, `ItemVariationGroup`.`memo`, `ItemVariationGroup`.`created_user`, `ItemVariationGroup`.`created`, `ItemVariationGroup`.`modified_user`, `ItemVariationGroup`.`modified`, `ItemVariationGroup`.`delete_flg` FROM `kalmor_stg`.`item_variation_groups` AS `ItemVariationGroup` WHERE `ItemVariationGroup`.`id` IS NULL AND `ItemVariationGroup`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 1 | maybe slow |
35 duplicate queries run.
