ふんわりとした広い座面と、どっしりとしたロースタイルが魅力のパーソナルソファです。2台、3台と並べたり、オットマンを併用してゆったりくつろぐ事も可能です。フェザーをふんだんに使用した柔らかで弾力のある座り心地です。
MOREテーブルを囲み、ダイニングシーンにくつろぎを取り入れてくれるダイニングソファです。お部屋や人数に合わせてレイアウトが可能なソファダイニングシリーズで、ソフィアダイニングテーブルと合わせて使うのに適しています。
MOREワイドとロングのソファを自由に組み合わせる事で、コーナーソファのように顔を合わせて座ったり、カウチで脚を伸ばして座ったりと、寛ぎとコミニケーションをコンセプトにデザインしたソファシリーズです。
MORE全体的に高さを抑え、ごろんと横になるのに適したゆったりとした印象のカバーリングソファです。
MORE時間をかけて曲げた背合板とオーク天然木の肘、スリムなアイアンを組合せ、やわらかさとぬくもりとヴィンテージ感を融合させたチェアです。
MORE伝統的な意匠と新しい感覚を融合させたリビングソファです。コンパクトなサイズ感と厚みを抑えた座が軽やかな印象です。
MORESIEVEの家具とも合わせやすいデザイン。ホットカーペットカバー対応やご家庭でお洗濯いただけたりと実用性も高いラグをご用意しております。
MORE足掛けの高さに貫部材を装着し、強度と物を置けるスペースを兼ねそえたチェアです。
MOREアイアンと天然木との異素材を組み合わせたKarla unit sofa / カーラユニットソファシリーズ。3タイプを組み合わせることで、レイアウトの自由度が高いシリーズです。
MORE全体的に丸みを帯びたフォルムと、細めの鉄脚を組み合わせたデザインが特徴のモンスソファ。前後に丸みを帯びた山のような形状の肘掛は、腕を置いた時に、手が自然に馴染むような ゆるやかな曲線をイメージしました。
MORE1人の空間で快適に過ごすことを重視したパーソナルチェアです。リクライニングさせたり、サイドテーブルやオットマンを組み合わせて、お部屋を私だけのリラックス空間にすることができます。
MORE軽快でスタイリッシュなデザイン。ダイニングに限らず、デスクスペースやワーキングスペースなど様々なシチュエーションに対応できます。
MOREスリムなアイアン脚と天然木を組合わせ、古びたジムにあるラックをイメージしたマルチラックです。
MOREジェシカソファ 2.5人掛け
MOREKKEITO ダイニングチェア
MORE見る方向によって変化するデザイン。ゆったりとした座面に座ったり寝転んだり、思いきりくつろげるソファーです。
MORE<コラム>
ソファの選び方|サイズ・レイアウト【最新版2020年4月更新】ソファを選ぶ時、何を基準に考えれば良いでしょうか?サイズ・座り心地・デザインなど、ソファを選ぶときに役立つポイントをご紹介いたします!
<キャンペーン>
カーラソファ予約10%OFFキャンペーンご好評いただいており『カーラソファ』の欠品につきまして、皆様にはご迷惑をおかけし誠に申し訳ございません。次回入荷は4月末〜5月上旬を予定しておりますが、欠品のお詫びとしまして『10%OFF』でご予約承ります!!
<アイテム>
シンプルで使い勝手の良いダイニングシリーズ|saucer diningダイニングとはどんな場所でしょうか?家事の合間に一息ついたり、友人との会話を楽しむ団らんの場所であったり。 食事以外にも重要な時間を過ごす場所である事に気がつきます。
<アイテム>
クッションプレゼント対象のお客様へ『特別クーポン』のご案内ご注文数の増加により、オリジナルフェザークッションの生産が間に合わず欠品しており、ご迷惑をおかけし申し訳ございません。クッションの代わりといたしまして特別クーポンをご用意いたしました。
No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Brand`.`code` FROM `brands` AS `Brand` WHERE `Brand`.`delete_flg` = '0' | 4 | 4 | 1 | maybe slow |
SELECT `OperationSetting`.`id`, `OperationSetting`.`code`, `OperationSetting`.`controller`, `OperationSetting`.`value`, `OperationSetting`.`created_user`, `OperationSetting`.`created`, `OperationSetting`.`modified_user`, `OperationSetting`.`modified`, `OperationSetting`.`delete_flg` FROM `sieve_stg`.`operation_settings` AS `OperationSetting` WHERE `OperationSetting`.`delete_flg` = '0' | 509 | 509 | 2 | |
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` IS NULL AND `Basket`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 0 | |
BEGIN | ||||
SELECT COUNT(*) AS `count` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '6041d5bf-9f60-44d5-8c6a-13240a00013d' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '6041d5bf-9f60-44d5-8c6a-13240a00013d' | 1 | 1 | 0 | |
INSERT INTO `sieve_stg`.`baskets` (`id`, `data`, `modified`, `created`, `modified_user`) VALUES ('6041d5bf-9f60-44d5-8c6a-13240a00013d', '{\"cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]},\"subscription_cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]}}', '2021-03-05 15:54:55', '2021-03-05 15:54:55', '-') | 1 | 1 | 3 | maybe slow |
COMMIT | ||||
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `sieve_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '6041d5bf-9f60-44d5-8c6a-13240a00013d' AND `Basket`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `sieve_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2021-03-05' AND `TaxRate`.`tax_div` = 1 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `sieve_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2021-03-05' AND `TaxRate`.`tax_div` = 2 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg` FROM `sieve_stg`.`pages` AS `Page` WHERE `code` = 'top' AND `Page`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PagePart`.`id`, `PagePart`.`page_id`, `PagePart`.`part_id`, `PagePart`.`display_section_div`, `PagePart`.`display_order`, `PagePart`.`content`, `PagePart`.`created_user`, `PagePart`.`created`, `PagePart`.`modified_user`, `PagePart`.`modified`, `PagePart`.`delete_flg`, `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg`, `Part`.`id`, `Part`.`code`, `Part`.`name`, `Part`.`title`, `Part`.`ajax_div`, `Part`.`content`, `Part`.`system_parts_flg`, `Part`.`label_div`, `Part`.`memo`, `Part`.`created_user`, `Part`.`created`, `Part`.`modified_user`, `Part`.`modified`, `Part`.`delete_flg` FROM `sieve_stg`.`page_parts` AS `PagePart` LEFT JOIN `sieve_stg`.`pages` AS `Page` ON (`PagePart`.`page_id` = `Page`.`id` AND `Page`.`delete_flg` = '0') LEFT JOIN `sieve_stg`.`parts` AS `Part` ON (`PagePart`.`part_id` = `Part`.`id` AND `Part`.`delete_flg` = '0') WHERE `page_id` = '519f7900-9914-47cb-ab61-85c8fd5ad003' AND `PagePart`.`delete_flg` = '0' ORDER BY `PagePart`.`display_section_div` ASC, `PagePart`.`display_order` ASC | 17 | 17 | 2 | maybe slow |
SELECT `Post`.`id`, `Post`.`post_div`, `Post`.`post_category_id`, `Post`.`code`, `Post`.`brand_id`, `Post`.`release_div`, `Post`.`important_flg`, `Post`.`title`, `Post`.`description`, `Post`.`keywords`, `Post`.`post_date`, `Post`.`content`, `Post`.`wysiwyg_flg`, `Post`.`link`, `Post`.`link_target_div`, `Post`.`image`, `Post`.`thumb_image`, `Post`.`image_sp`, `Post`.`attachment_file`, `Post`.`disp_date_from`, `Post`.`disp_date_to`, `Post`.`tags`, `Post`.`left_column_display_div`, `Post`.`right_column_display_div`, `Post`.`label_div`, `Post`.`sns_div`, `Post`.`sns_post_id`, `Post`.`memo`, `Post`.`created_user`, `Post`.`created`, `Post`.`modified_user`, `Post`.`modified`, `Post`.`delete_flg`, `PostCategory`.`id`, `PostCategory`.`post_div`, `PostCategory`.`code`, `PostCategory`.`title`, `PostCategory`.`image`, `PostCategory`.`content`, `PostCategory`.`display_order`, `PostCategory`.`created_user`, `PostCategory`.`created`, `PostCategory`.`modified_user`, `PostCategory`.`modified`, `PostCategory`.`delete_flg` FROM `sieve_stg`.`posts` AS `Post` LEFT JOIN `sieve_stg`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id` AND `PostCategory`.`delete_flg` = '0') WHERE `Post`.`release_div` = 1 AND `Post`.`disp_date_from` <= '2021-03-05 15:55:54' AND ((`Post`.`disp_date_to` IS NULL) OR (`Post`.`disp_date_to` >= '2021-03-05 15:55:54')) AND `Post`.`post_div` = 3 AND `Post`.`delete_flg` = '0' ORDER BY `disp_date_from` desc | 4 | 4 | 1 | maybe slow |
SELECT `Item`.`id`, `Item`.`code`, `Item`.`brand_id`, `Item`.`name`, `Item`.`title`, `Item`.`name_kana`, `Item`.`jan_code`, `Item`.`smaregi_original_code`, `Item`.`description`, `Item`.`keywords`, `Item`.`subscription_div`, `Item`.`reservation_div`, `Item`.`scheduled_arrival_date`, `Item`.`release_div`, `Item`.`only_member_flg`, `Item`.`only_bussiness_flg`, `Item`.`outlet_flg`, `Item`.`not_purchase_flg`, `Item`.`price_hidden_flg`, `Item`.`set_item_flg`, `Item`.`set_item_contents`, `Item`.`disp_date_from`, `Item`.`disp_date_to`, `Item`.`selling_date_from`, `Item`.`selling_date_to`, `Item`.`sale_date_from`, `Item`.`sale_date_to`, `Item`.`price`, `Item`.`sale_price`, `Item`.`member_price`, `Item`.`business_price`, `Item`.`cost_price`, `Item`.`shipping_weight`, `Item`.`point_div`, `Item`.`free_shipping_div`, `Item`.`cool_div`, `Item`.`specific_point`, `Item`.`specific_point_date_from`, `Item`.`specific_point_date_to`, `Item`.`item_tags`, `Item`.`item_list_tags`, `Item`.`explain`, `Item`.`explain2`, `Item`.`wysiwyg_flg`, `Item`.`wysiwyg_flg2`, `Item`.`item_variation_group_id`, `Item`.`stock_div`, `Item`.`stock_quantity`, `Item`.`warning_stock_quantity`, `Item`.`lot_quantity`, `Item`.`core_item_flg`, `Item`.`item_variation_attribute1`, `Item`.`item_variation_attribute2`, `Item`.`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`.`item_option1`, `Item`.`item_option2`, `Item`.`item_option3`, `Item`.`item_option4`, `Item`.`item_option5`, `Item`.`images`, `Item`.`image_captions`, `Item`.`representative_image`, `Item`.`point`, `Item`.`google_product_category`, `Item`.`pla_image`, `Item`.`shipping_category_id`, `Item`.`parts_id1`, `Item`.`parts_id2`, `Item`.`parts_id3`, `Item`.`parts_id4`, `Item`.`parts_id5`, `Item`.`disp_inform_restock_flg`, `Item`.`delivery_sources_id`, `Item`.`external_cooperation_1`, `Item`.`external_cooperation_2`, `Item`.`external_cooperation_3`, `Item`.`external_cooperation_4`, `Item`.`external_cooperation_5`, `Item`.`ga_page_view`, `Item`.`avg_review`, `Item`.`notice_text`, `Item`.`recommend`, `Item`.`label_div`, `Item`.`memo`, `Item`.`created_user`, `Item`.`created`, `Item`.`modified_user`, `Item`.`modified`, `Item`.`delete_flg`, `Item`.`parent_item_id`, (COALESCE(IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price`, NULL), `Item`.`price`)) AS `Item__current_price`, (TRUNCATE (COALESCE(IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08)), NULL), `Item`.`price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08))), 0 ) ) AS `Item__current_price_withtax`, (IF(`Item`.`sale_price` IS NULL, 1, IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), 2, 1))) AS `Item__price_div`, (IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`selling_date_from`, '1000-01-01') AND COALESCE(`Item`.`selling_date_to`, '9999-12-31'), 1, 2)) AS `Item__selling_div`, (IF(SYSDATE() BETWEEN `Item`.`sale_date_from` AND `Item`.`sale_date_to` ,true, false)) AS `Item__sales_term_flg`, (IF(`Item`.`item_variation_group_id` IS NULL OR `Item`.`item_variation_group_id` = "", "", (SELECT SUM(stock_quantity) AS sum_stock_quantity FROM items WHERE item_variation_group_id = `Item`.`item_variation_group_id` ) )) AS `Item__variation_sum_stock_quantity` FROM `sieve_stg`.`items` AS `Item` WHERE `Item`.`delete_flg` = 0 AND '2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND `Item`.`release_div` = 1 AND ((((`Item`.`item_variation_group_id` is not null) AND (`Item`.`item_variation_group_id` <> '') AND (`Item`.`core_item_flg` = '1'))) OR (((`Item`.`item_variation_group_id` is null) OR (`Item`.`item_variation_group_id` = '')))) AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) ORDER BY `Item`.`disp_date_from` DESC, `Item`.`code` ASC LIMIT 4 | 4 | 4 | 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`.`item_variation_attribute1`, `Item`.`item_variation_attribute2`, `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`.`item_option1`, `Item`.`item_option2`, `Item`.`item_option3`, `Item`.`item_option4`, `Item`.`item_option5`, `Item`.`images`, `Item`.`image_captions`, `Item`.`representative_image`, `Item`.`point`, `Item`.`google_product_category`, `Item`.`pla_image`, `Item`.`shipping_category_id`, `Item`.`parts_id1`, `Item`.`parts_id2`, `Item`.`parts_id3`, `Item`.`parts_id4`, `Item`.`parts_id5`, `Item`.`disp_inform_restock_flg`, `Item`.`delivery_sources_id`, `Item`.`external_cooperation_1`, `Item`.`external_cooperation_2`, `Item`.`external_cooperation_3`, `Item`.`external_cooperation_4`, `Item`.`external_cooperation_5`, `Item`.`ga_page_view`, `Item`.`avg_review`, `Item`.`notice_text`, `Item`.`recommend`, `Item`.`label_div`, `Item`.`memo`, `Item`.`created_user`, `Item`.`created`, `Item`.`modified_user`, `Item`.`modified`, `Item`.`delete_flg`, `Item`.`parent_item_id`, (COALESCE(IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price`, NULL), `Item`.`price`)) AS `Item__current_price`, (TRUNCATE (COALESCE(IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08)), NULL), `Item`.`price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08))), 0 ) ) AS `Item__current_price_withtax`, (IF(`Item`.`sale_price` IS NULL, 1, IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), 2, 1))) AS `Item__price_div`, (IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`selling_date_from`, '1000-01-01') AND COALESCE(`Item`.`selling_date_to`, '9999-12-31'), 1, 2)) AS `Item__selling_div`, (IF(SYSDATE() BETWEEN `Item`.`sale_date_from` AND `Item`.`sale_date_to` ,true, false)) AS `Item__sales_term_flg`, (IF(`Item`.`item_variation_group_id` IS NULL OR `Item`.`item_variation_group_id` = "", "", (SELECT SUM(stock_quantity) AS sum_stock_quantity FROM items WHERE item_variation_group_id = `Item`.`item_variation_group_id` ) )) AS `Item__variation_sum_stock_quantity` FROM `sieve_stg`.`items` AS `Item` WHERE `Item`.`delete_flg` = 0 AND '2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`disp_date_from`, '1000-01-01') AND COALESCE(`Item`.`disp_date_to`, '9999-12-31') AND `Item`.`release_div` = 1 AND EXISTS (SELECT * FROM item_category_relations AS ItemCategoryReration WHERE `ItemCategoryReration`.`delete_flg` <> 1 AND `Item`.`id` = `ItemCategoryReration`.`item_id` AND `ItemCategoryReration`.`item_category_div` = 8 ) AND `Item`.`delete_flg` = '0' AND ((`Item`.`only_bussiness_flg` = '0') OR (`Item`.`only_bussiness_flg` IS NULL) OR (`Item`.`only_bussiness_flg` = '0')) ORDER BY `Item`.`disp_date_from` DESC, `Item`.`code` ASC | 8 | 8 | 22 | maybe slow |
SELECT `SetItemRelation`.`id`, `SetItemRelation`.`parent_item_id`, `SetItemRelation`.`child_item_id`, `SetItemRelation`.`quantity`, `SetItemRelation`.`created_user`, `SetItemRelation`.`created`, `SetItemRelation`.`modified_user`, `SetItemRelation`.`modified`, `SetItemRelation`.`delete_flg` FROM `sieve_stg`.`set_item_relations` AS `SetItemRelation` WHERE `SetItemRelation`.`delete_flg` = '0' AND `SetItemRelation`.`parent_item_id` IN ('57c4f584-bbd0-4ce7-8a25-0c53a0104cac', '5668ebd2-9f64-43f5-a668-070fa0104cac', '56121a61-7064-466b-97a1-2456fd5ad003', '567cf33e-dbc4-446b-a1c4-1535a0104cac', '560a4b2d-ffe8-4002-bdee-651afd5ad003', '567cf539-e1bc-4ca8-89f2-2507a0104cac', '5617b2b3-0760-449b-b621-244e31d4bbf8', '560a4b33-8ac0-4ba3-9bf6-651afd5ad003') | 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 `sieve_stg`.`item_category_relations` AS `ItemCategoryRelation` WHERE `ItemCategoryRelation`.`delete_flg` = '0' AND `ItemCategoryRelation`.`item_id` IN ('57c4f584-bbd0-4ce7-8a25-0c53a0104cac', '5668ebd2-9f64-43f5-a668-070fa0104cac', '56121a61-7064-466b-97a1-2456fd5ad003', '567cf33e-dbc4-446b-a1c4-1535a0104cac', '560a4b2d-ffe8-4002-bdee-651afd5ad003', '567cf539-e1bc-4ca8-89f2-2507a0104cac', '5617b2b3-0760-449b-b621-244e31d4bbf8', '560a4b33-8ac0-4ba3-9bf6-651afd5ad003') | 76 | 76 | 1 | |
SELECT `ItemKeyword`.`id`, `ItemKeyword`.`item_id`, `ItemKeyword`.`keyword`, `ItemKeyword`.`priority`, `ItemKeyword`.`label_div`, `ItemKeyword`.`memo`, `ItemKeyword`.`created_user`, `ItemKeyword`.`created`, `ItemKeyword`.`modified_user`, `ItemKeyword`.`modified`, `ItemKeyword`.`delete_flg` FROM `sieve_stg`.`item_keywords` AS `ItemKeyword` WHERE `ItemKeyword`.`delete_flg` = '0' AND `ItemKeyword`.`item_id` IN ('57c4f584-bbd0-4ce7-8a25-0c53a0104cac', '5668ebd2-9f64-43f5-a668-070fa0104cac', '56121a61-7064-466b-97a1-2456fd5ad003', '567cf33e-dbc4-446b-a1c4-1535a0104cac', '560a4b2d-ffe8-4002-bdee-651afd5ad003', '567cf539-e1bc-4ca8-89f2-2507a0104cac', '5617b2b3-0760-449b-b621-244e31d4bbf8', '560a4b33-8ac0-4ba3-9bf6-651afd5ad003') | 40 | 40 | 2 | maybe slow |
SELECT `Post`.`id`, `Post`.`post_div`, `Post`.`post_category_id`, `Post`.`code`, `Post`.`brand_id`, `Post`.`release_div`, `Post`.`important_flg`, `Post`.`title`, `Post`.`description`, `Post`.`keywords`, `Post`.`post_date`, `Post`.`content`, `Post`.`wysiwyg_flg`, `Post`.`link`, `Post`.`link_target_div`, `Post`.`image`, `Post`.`thumb_image`, `Post`.`image_sp`, `Post`.`attachment_file`, `Post`.`disp_date_from`, `Post`.`disp_date_to`, `Post`.`tags`, `Post`.`left_column_display_div`, `Post`.`right_column_display_div`, `Post`.`label_div`, `Post`.`sns_div`, `Post`.`sns_post_id`, `Post`.`memo`, `Post`.`created_user`, `Post`.`created`, `Post`.`modified_user`, `Post`.`modified`, `Post`.`delete_flg`, `PostCategory`.`id`, `PostCategory`.`post_div`, `PostCategory`.`code`, `PostCategory`.`title`, `PostCategory`.`image`, `PostCategory`.`content`, `PostCategory`.`display_order`, `PostCategory`.`created_user`, `PostCategory`.`created`, `PostCategory`.`modified_user`, `PostCategory`.`modified`, `PostCategory`.`delete_flg` FROM `sieve_stg`.`posts` AS `Post` LEFT JOIN `sieve_stg`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id` AND `PostCategory`.`delete_flg` = '0') WHERE `Post`.`delete_flg` = 0 AND `Post`.`release_div` = 1 AND '2021-03-05 15:54:55' BETWEEN COALESCE(`Post`.`disp_date_from`, '1000-01-01') AND COALESCE(`Post`.`disp_date_to`, '9999-12-31') AND `Post`.`post_div` = 2 AND `Post`.`delete_flg` = '0' ORDER BY `disp_date_from` desc LIMIT 1 | 1 | 1 | 1 | |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 3 AND `ItemCategory`.`release_div` = 1 AND `ItemCategory`.`display_order` > 0 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, `ItemCategory`.`disp_date_from` desc | 23 | 23 | 6 | maybe slow |
SELECT `ItemCategoryRelation`.`id`, `ItemCategoryRelation`.`item_category_div`, `ItemCategoryRelation`.`item_id`, `ItemCategoryRelation`.`item_category_id`, `ItemCategoryRelation`.`label_div`, `ItemCategoryRelation`.`memo`, `ItemCategoryRelation`.`created_user`, `ItemCategoryRelation`.`created`, `ItemCategoryRelation`.`modified_user`, `ItemCategoryRelation`.`modified`, `ItemCategoryRelation`.`delete_flg` FROM `sieve_stg`.`item_category_relations` AS `ItemCategoryRelation` WHERE `ItemCategoryRelation`.`delete_flg` = '0' AND `ItemCategoryRelation`.`item_category_id` IN ('5ed0c4f1-6870-4468-a0ca-16650a00013d', '5e96dac8-293c-449d-ac2d-7a6b0a00013d', '5e4e223a-7ee4-4d0b-920e-6cce0a00013d', '5e410aed-b338-40a2-bc45-3a680a00013d', '58ca421b-22cc-4b7f-9685-0a47a0104cac', '58d4bd51-ef90-40c2-ab83-3f2aa0104cac', '5f99e79d-9628-4ead-8124-6bbd0a00013d', '58ca43c5-0834-46b8-af57-0c05a0104cac', '5d3829a4-afc8-4f82-beaa-31670a00015c', '5d392932-e4c4-4a78-930a-47390a00015c', '58cb972f-d37c-4be1-8779-3a28a0104cac', '58c7ab1c-40ec-4254-a219-1b42a0104cac', '5da6e594-47b0-4c2b-96e9-72a70a00015c', '560e01a6-7518-4d20-99cd-07e531d4bbf8', '58b4bf0f-b244-4493-bc37-5312a0104cac', '5d36c4d3-c160-42e3-b7b9-130c0a00015c', '5d37d74e-66a0-4adf-8ad9-2a240a00015c', '5885ce52-43f8-4e75-9d7e-644fa0104cac', '5898399e-160c-4065-b14f-0f9da0104cac', '589c11b0-b508-4c7a-942a-5f43a0104cac', '58c0e895-25b0-46ad-bd32-643aa0104cac', '58535321-2ec0-4ee3-bbdb-34a3a0104cac', '57ea376d-62a4-402d-9db8-760ca0104cac') | 210 | 210 | 12 | maybe slow |
SELECT `Post`.`id`, `Post`.`post_div`, `Post`.`post_category_id`, `Post`.`code`, `Post`.`brand_id`, `Post`.`release_div`, `Post`.`important_flg`, `Post`.`title`, `Post`.`description`, `Post`.`keywords`, `Post`.`post_date`, `Post`.`content`, `Post`.`wysiwyg_flg`, `Post`.`link`, `Post`.`link_target_div`, `Post`.`image`, `Post`.`thumb_image`, `Post`.`image_sp`, `Post`.`attachment_file`, `Post`.`disp_date_from`, `Post`.`disp_date_to`, `Post`.`tags`, `Post`.`left_column_display_div`, `Post`.`right_column_display_div`, `Post`.`label_div`, `Post`.`sns_div`, `Post`.`sns_post_id`, `Post`.`memo`, `Post`.`created_user`, `Post`.`created`, `Post`.`modified_user`, `Post`.`modified`, `Post`.`delete_flg`, `PostCategory`.`id`, `PostCategory`.`post_div`, `PostCategory`.`code`, `PostCategory`.`title`, `PostCategory`.`image`, `PostCategory`.`content`, `PostCategory`.`display_order`, `PostCategory`.`created_user`, `PostCategory`.`created`, `PostCategory`.`modified_user`, `PostCategory`.`modified`, `PostCategory`.`delete_flg` FROM `sieve_stg`.`posts` AS `Post` LEFT JOIN `sieve_stg`.`post_categories` AS `PostCategory` ON (`Post`.`post_category_id` = `PostCategory`.`id` AND `PostCategory`.`delete_flg` = '0') WHERE `Post`.`delete_flg` = 0 AND `Post`.`release_div` = 1 AND '2021-03-05 15:54:55' BETWEEN COALESCE(`Post`.`disp_date_from`, '1000-01-01') AND COALESCE(`Post`.`disp_date_to`, '9999-12-31') AND `Post`.`post_div` = 2 AND `Post`.`important_flg` = 1 AND `Post`.`delete_flg` = '0' ORDER BY `disp_date_from` desc | 7 | 7 | 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`.`item_variation_attribute1`, `Item`.`item_variation_attribute2`, `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`.`item_option1`, `Item`.`item_option2`, `Item`.`item_option3`, `Item`.`item_option4`, `Item`.`item_option5`, `Item`.`images`, `Item`.`image_captions`, `Item`.`representative_image`, `Item`.`point`, `Item`.`google_product_category`, `Item`.`pla_image`, `Item`.`shipping_category_id`, `Item`.`parts_id1`, `Item`.`parts_id2`, `Item`.`parts_id3`, `Item`.`parts_id4`, `Item`.`parts_id5`, `Item`.`disp_inform_restock_flg`, `Item`.`delivery_sources_id`, `Item`.`external_cooperation_1`, `Item`.`external_cooperation_2`, `Item`.`external_cooperation_3`, `Item`.`external_cooperation_4`, `Item`.`external_cooperation_5`, `Item`.`ga_page_view`, `Item`.`avg_review`, `Item`.`notice_text`, `Item`.`recommend`, `Item`.`label_div`, `Item`.`memo`, `Item`.`created_user`, `Item`.`created`, `Item`.`modified_user`, `Item`.`modified`, `Item`.`delete_flg`, `Item`.`parent_item_id`, (COALESCE(IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price`, NULL), `Item`.`price`)) AS `Item__current_price`, (TRUNCATE (COALESCE(IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), `Item`.`sale_price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08)), NULL), `Item`.`price` * (IF(`Item`.`tax_div` = 1, 1.1, 1.08))), 0 ) ) AS `Item__current_price_withtax`, (IF(`Item`.`sale_price` IS NULL, 1, IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`sale_date_from`, '1000-01-01') AND COALESCE(`Item`.`sale_date_to`, '9999-12-31'), 2, 1))) AS `Item__price_div`, (IF('2021-03-05 15:54:55' BETWEEN COALESCE(`Item`.`selling_date_from`, '1000-01-01') AND COALESCE(`Item`.`selling_date_to`, '9999-12-31'), 1, 2)) AS `Item__selling_div`, (IF(SYSDATE() BETWEEN `Item`.`sale_date_from` AND `Item`.`sale_date_to` ,true, false)) AS `Item__sales_term_flg`, (IF(`Item`.`item_variation_group_id` IS NULL OR `Item`.`item_variation_group_id` = "", "", (SELECT SUM(stock_quantity) AS sum_stock_quantity FROM items WHERE item_variation_group_id = `Item`.`item_variation_group_id` ) )) AS `Item__variation_sum_stock_quantity` FROM `sieve_stg`.`sales_rankings` AS `SalesRanking` LEFT JOIN `sieve_stg`.`items` AS `Item` ON (`SalesRanking`.`item_id` = `Item`.`id` AND `Item`.`delete_flg` = '0') WHERE '2021-03-05 15:54:55' 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_category_id` = 'TOP' AND `item_category_id` = 'TOP' AND `SalesRanking`.`delete_flg` = '0' ORDER BY `rank` 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' BETWEEN COALESCE(`ItemCategory`.`disp_date_from`, '1000-01-01') AND COALESCE(`ItemCategory`.`disp_date_to`, '9999-12-31') AND `ItemCategory`.`item_category_div` = 2 AND `ItemCategory`.`delete_flg` = '0' AND ((`ItemCategory`.`only_bussiness_flg` = '0') OR (`ItemCategory`.`only_bussiness_flg` IS NULL) OR (`ItemCategory`.`only_bussiness_flg` = '0')) ORDER BY `display_order` asc | 10 | 10 | 1 | maybe slow |
SELECT `Part`.`id`, `Part`.`code`, `Part`.`name`, `Part`.`title`, `Part`.`ajax_div`, `Part`.`content`, `Part`.`system_parts_flg`, `Part`.`label_div`, `Part`.`memo`, `Part`.`created_user`, `Part`.`created`, `Part`.`modified_user`, `Part`.`modified`, `Part`.`delete_flg` FROM `sieve_stg`.`parts` AS `Part` WHERE `Part`.`code` = 'parts_sidebar_recent' AND `Part`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 | 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc117-a798-49d2-8fdf-661d31d4bbf8' 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 | 10 | 10 | 1 | maybe slow |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc191-44e8-422b-80d6-663a31d4bbf8' 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 | 22 | 22 | 1 | |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc19a-40a4-4f47-a96c-664331d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:56d3fed8-9888-4c49-9c2d-0618a0104cac' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 | 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc117-a798-49d2-8fdf-661d31d4bbf8' 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 | 10 | 10 | 1 | maybe slow |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc273-6cb8-478a-b36c-662f31d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc2eb-0f7c-4ddd-a9d8-656031d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560cf354-8b2c-4e46-b9bf-664331d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560cf478-9734-45bb-9f2e-661f31d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d12bc-dd20-44b2-ac26-07e131d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fc774-4114-4331-9011-07c80a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fc697-7acc-40dc-a0e4-07100a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:5ce3a0df-a274-4b78-b31b-5a2a0a00015c' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fc65c-6f38-46b9-8142-07410a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fc6ce-638c-4cd0-adb1-07c70a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc191-44e8-422b-80d6-663a31d4bbf8' 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 | 22 | 22 | 1 | |
SELECT `ItemCategory`.`id`, `ItemCategory`.`item_category_div`, `ItemCategory`.`code`, `ItemCategory`.`brand_id`, `ItemCategory`.`title`, `ItemCategory`.`subtitle`, `ItemCategory`.`link_url`, `ItemCategory`.`read`, `ItemCategory`.`title_kana`, `ItemCategory`.`prefecture_div`, `ItemCategory`.`description`, `ItemCategory`.`keywords`, `ItemCategory`.`head_tag`, `ItemCategory`.`image`, `ItemCategory`.`icon_image`, `ItemCategory`.`parent_category_tree`, `ItemCategory`.`main_content`, `ItemCategory`.`side_content`, `ItemCategory`.`wysiwyg_flg`, `ItemCategory`.`display_order`, `ItemCategory`.`release_div`, `ItemCategory`.`only_bussiness_flg`, `ItemCategory`.`disp_date_from`, `ItemCategory`.`disp_date_to`, `ItemCategory`.`core_item_div`, `ItemCategory`.`allow_pre_published_flg`, `ItemCategory`.`label_div`, `ItemCategory`.`memo`, `ItemCategory`.`created_user`, `ItemCategory`.`created`, `ItemCategory`.`modified_user`, `ItemCategory`.`modified`, `ItemCategory`.`delete_flg`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d00be-34bc-4c17-a0e7-664331d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d1381-0324-49d7-b28c-080031d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d13cb-8aa8-4ae9-9b4c-07ea31d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d13af-1c54-4304-93b9-07e331d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d12e7-1900-4db8-aa8b-07e031d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd4ab-4d90-4ee8-a245-09cb0a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd487-494c-4ba2-8d37-0a4e0a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd417-408c-42cd-b8a3-093b0a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd3aa-8fe8-433c-b683-0a690a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd36b-bce8-4169-9ff0-08920a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d141e-9808-4e05-bf11-07e331d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d131c-7ec8-4e74-a55d-07e631d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d14c1-97ec-4c3a-a1be-07f731d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d144f-6324-40b4-8029-07e531d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560d134e-401c-4ab3-a16b-07e431d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:5f1e976c-48a0-49ff-bfce-23090a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd1a4-6588-4349-9b4b-09710a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd2b3-15d4-4df0-836d-093b0a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd33d-a828-4bab-b131-08e40a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd3cc-4018-4d2b-a058-08060a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd3fd-6338-43d4-8792-09710a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:600fd807-d8d4-44ef-a624-0adc0a00013d' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:560bc19a-40a4-4f47-a96c-664331d4bbf8' 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`, `ItemCategory`.`tmp`, (CONCAT(`ItemCategory`.`parent_category_tree`,":", `ItemCategory`.`id`)) AS `ItemCategory__category_tree` FROM `sieve_stg`.`item_categories` AS `ItemCategory` WHERE `ItemCategory`.`delete_flg` = 0 AND '2021-03-05 15:54:55' 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 '%:56d3fed8-9888-4c49-9c2d-0618a0104cac' 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 |
6 duplicate queries run.
Peak Memory Use 20.62 MB
Message | Memory use |
---|---|
Component initialization | 6.25 MB |
Controller action start | 10.23 MB |
Controller render start | 13.41 MB |
View render complete | 15.15 MB |
Total Request Time: 419 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 62.73 | |
Event: Controller.initialize | 40.97 | |
Event: Controller.startup | 136.50 | |
Controller action | 136.36 | |
Event: Controller.beforeRender | 6.11 | |
» Processing toolbar data | 5.97 | |
Rendering View | 92.02 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/View/Front/Top/index.ctp | 0.10 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Front/Layouts/default_sieve.ctp | 90.67 | |
» » Rendering APP/View/Front/Elements/gaTrackingCode.ctp | 1.18 | |
» » Rendering APP/View/Front/Elements/parts_header_sieve.ctp | 1.11 | |
» » Rendering APP/View/Front/Elements/parts_top_carousel_sieve.ctp | 1.05 | |
» » Rendering APP/View/Front/Elements/parts_top_news.ctp | 2.17 | |
» » Rendering APP/View/Front/Elements/parts_sidebar_genre.ctp | 2.14 | |
» » Rendering APP/View/Front/Elements/parts_top_newarrival.ctp | 15.44 | |
» » » Rendering APP/View/Front/Elements/item_info_sieve.ctp | 2.14 | |
» » » Rendering APP/View/Front/Elements/item_info_sieve.ctp #2 | 2.14 | |
» » » Rendering APP/View/Front/Elements/item_info_sieve.ctp #3 | 2.11 | |
» » » Rendering APP/View/Front/Elements/item_info_sieve.ctp #4 | 2.10 | |
» » Rendering APP/View/Front/Elements/parts_top_special_sieve.ctp | 2.03 | |
» » Rendering APP/View/Front/Elements/parts_sidebar_recent_sieve.ctp | 0.16 | |
» » Rendering APP/View/Front/Elements/parts_sidebar_basic_category.ctp | 0.29 | |
» » Rendering APP/View/Front/Elements/parts_footer_sieve.ctp | 0.53 | |
Event: View.afterLayout | 0.00 |