Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Brand`.`code` FROM `brands` AS `Brand` WHERE `Brand`.`delete_flg` = '0' | 0 | 0 | 1 | maybe slow |
SELECT `Post`.`post_url`, `Post`.`code` FROM `posts` AS `Post` WHERE `post_url` != '' AND `post_div` = 1 AND `Post`.`delete_flg` = '0' | 0 | 0 | 0 | |
SELECT `OperationSetting`.`id`, `OperationSetting`.`code`, `OperationSetting`.`controller`, `OperationSetting`.`value`, `OperationSetting`.`created_user`, `OperationSetting`.`created`, `OperationSetting`.`modified_user`, `OperationSetting`.`modified`, `OperationSetting`.`delete_flg` FROM `kalmor_stg`.`operation_settings` AS `OperationSetting` WHERE `OperationSetting`.`delete_flg` = '0' | 585 | 585 | 2 | |
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`item_options` AS `ItemOption` WHERE `ItemOption`.`delete_flg` = '0' | 1 | 1 | 1 | |
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` IS NULL AND `Basket`.`delete_flg` = '0' LIMIT 1 | 0 | 0 | 1 | maybe slow |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '13875e02-c6e1-41da-8416-f89bb59ea033' | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '13875e02-c6e1-41da-8416-f89bb59ea033' | 1 | 1 | 1 | |
INSERT INTO `kalmor_stg`.`baskets` (`id`, `data`, `modified`, `created`, `modified_user`) VALUES ('13875e02-c6e1-41da-8416-f89bb59ea033', '{\"cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]},\"subscription_cart\":{\"version\":\"1.00\",\"shipping_count\":1,\"total_quantity\":0,\"items\":[]}}', '2025-06-17 16:56:43', '2025-06-17 16:56:43', '-') | 1 | 1 | 4 | maybe slow |
COMMIT | | | | |
SELECT COUNT(*) AS `count` FROM `kalmor_stg`.`item_options` AS `ItemOption` WHERE `ItemOption`.`delete_flg` = '0' | 1 | 1 | 0 | |
SELECT `Basket`.`id`, `Basket`.`data`, `Basket`.`created`, `Basket`.`modified_user`, `Basket`.`modified`, `Basket`.`delete_flg` FROM `kalmor_stg`.`baskets` AS `Basket` WHERE `Basket`.`id` = '13875e02-c6e1-41da-8416-f89bb59ea033' AND `Basket`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `kalmor_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2025-06-17' AND `TaxRate`.`tax_div` = 1 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `TaxRate`.`id`, `TaxRate`.`tax_div`, `TaxRate`.`tax`, `TaxRate`.`from`, `TaxRate`.`label_div`, `TaxRate`.`memo`, `TaxRate`.`created_user`, `TaxRate`.`created`, `TaxRate`.`modified_user`, `TaxRate`.`modified`, `TaxRate`.`delete_flg` FROM `kalmor_stg`.`tax_rates` AS `TaxRate` WHERE `TaxRate`.`from` <= '2025-06-17' AND `TaxRate`.`tax_div` = 2 AND `TaxRate`.`delete_flg` = '0' ORDER BY `TaxRate`.`from` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg` FROM `kalmor_stg`.`pages` AS `Page` WHERE `code` = 'signup' AND `Page`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `PagePart`.`id`, `PagePart`.`page_id`, `PagePart`.`part_id`, `PagePart`.`display_section_div`, `PagePart`.`display_order`, `PagePart`.`content`, `PagePart`.`created_user`, `PagePart`.`created`, `PagePart`.`modified_user`, `PagePart`.`modified`, `PagePart`.`delete_flg`, `Page`.`id`, `Page`.`code`, `Page`.`name`, `Page`.`title`, `Page`.`keywords`, `Page`.`description`, `Page`.`content`, `Page`.`label_div`, `Page`.`memo`, `Page`.`created_user`, `Page`.`created`, `Page`.`modified_user`, `Page`.`modified`, `Page`.`delete_flg`, `Part`.`id`, `Part`.`code`, `Part`.`name`, `Part`.`title`, `Part`.`ajax_div`, `Part`.`content`, `Part`.`system_parts_flg`, `Part`.`label_div`, `Part`.`memo`, `Part`.`created_user`, `Part`.`created`, `Part`.`modified_user`, `Part`.`modified`, `Part`.`delete_flg` FROM `kalmor_stg`.`page_parts` AS `PagePart` LEFT JOIN `kalmor_stg`.`pages` AS `Page` ON (`PagePart`.`page_id` = `Page`.`id` AND `Page`.`delete_flg` = '0') LEFT JOIN `kalmor_stg`.`parts` AS `Part` ON (`PagePart`.`part_id` = `Part`.`id` AND `Part`.`delete_flg` = '0') WHERE `page_id` = '51b46cb0-fd34-46cf-b5e5-a799fd5ad003' AND `PagePart`.`delete_flg` = '0' ORDER BY `PagePart`.`display_section_div` ASC, `PagePart`.`display_order` ASC | 2 | 2 | 1 | maybe slow |
2 duplicate queries run.