| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `UserSetting`.`id`, `UserSetting`.`name`, `UserSetting`.`name_public`, `UserSetting`.`value`, `UserSetting`.`type`, `UserSetting`.`category`, `UserSetting`.`setting_key`, `UserSetting`.`setting_value`, `UserSetting`.`setting_type` FROM `dpg_ecommerce`.`user_settings` AS `UserSetting` WHERE 1 = 1 | 55 | 55 | 0 | |
| SELECT `UserActivity`.`id`, `UserActivity`.`useragent`, `UserActivity`.`user_id`, `UserActivity`.`last_action`, `UserActivity`.`last_url`, `UserActivity`.`logout_time`, `UserActivity`.`user_browser`, `UserActivity`.`ip_address`, `UserActivity`.`logout`, `UserActivity`.`deleted`, `UserActivity`.`status`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`useragent` = '46c5404893f7d8e229da7750c4799343oe85m3gfcvqovhdrp92nkmja94' LIMIT 1 | 1 | 1 | 410 | maybe slow |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969158 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969158 | 1 | 1 | 0 | |
| UPDATE `dpg_ecommerce`.`user_activities` SET `id` = 1969158, `useragent` = '46c5404893f7d8e229da7750c4799343oe85m3gfcvqovhdrp92nkmja94', `user_id` = NULL, `last_action` = 1765004557, `last_url` = '/categories/shop/Inks-SPL-Brand-Epson', `logout_time` = NULL, `user_browser` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', `ip_address` = '216.73.216.151', `logout` = 0, `deleted` = 0, `status` = 0, `created` = '2025-12-05 21:02:29', `modified` = '2025-12-05 21:02:38' WHERE `dpg_ecommerce`.`user_activities`.`id` = '1969158' | 1 | 1 | 0 | |
| COMMIT | | | | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE `Category`.`slug` = 'Inks-SPL-Brand-Epson' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`categories` AS `Category` LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Category`.`template_id` = `Template`.`id`) WHERE `Category`.`slug` = 'Inks-SPL-Brand-Epson' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`cat_name`, `Product`.`cart_name`, `Product`.`cart_short_name`, `Product`.`child_name`, `Product`.`short_name`, `Product`.`keyword`, `Product`.`keyword_2`, `Product`.`publish_flag`, `Product`.`slug_lock`, `Product`.`slug`, `Product`.`group_id`, `Product`.`sub_group_id`, `Product`.`primary_brand_id`, `Product`.`template_id`, `Product`.`sub_template_id`, `Product`.`description`, `Product`.`description_1`, `Product`.`description_2`, `Product`.`description_3`, `Product`.`description_4`, `Product`.`description_heading`, `Product`.`description_1_heading`, `Product`.`description_2_heading`, `Product`.`description_3_heading`, `Product`.`description_4_heading`, `Product`.`footer`, `Product`.`footer_heading`, `Product`.`description_short`, `Product`.`photo_rectangular`, `Product`.`photo_rectangular_2`, `Product`.`photo_square`, `Product`.`flag_url`, `Product`.`adhesive_id`, `Product`.`adhesive_thickness_dimension`, `Product`.`adhesive_thickness_id`, `Product`.`application_temperature_range_id`, `Product`.`back_side_id`, `Product`.`base_stock_id`, `Product`.`block_out`, `Product`.`block_out_id`, `Product`.`carrier_id`, `Product`.`carrier_thickness_dimension`, `Product`.`carrier_thickness_id`, `Product`.`color_id`, `Product`.`exclusion_id`, `Product`.`film_thickness_dimension`, `Product`.`film_thickness_id`, `Product`.`finish_id`, `Product`.`flag_id`, `Product`.`free_shipping_item`, `Product`.`ht_cut_direction_id`, `Product`.`ht_peel_id`, `Product`.`ht_preheat`, `Product`.`ht_pressure_id`, `Product`.`ht_temp_id`, `Product`.`ht_time_id`, `Product`.`inside_durability_id`, `Product`.`outside_durability_id`, `Product`.`layerable`, `Product`.`liner_id`, `Product`.`liner_thickness_dimension`, `Product`.`liner_thickness_id`, `Product`.`min_application_temperature_id`, `Product`.`removability_id`, `Product`.`removal_temperature_range_id`, `Product`.`service_temperature_range_id`, `Product`.`shelf_life_id`, `Product`.`sort_id`, `Product`.`stock_status_flag`, `Product`.`stock_status_rating`, `Product`.`stock_status_id`, `Product`.`storage_requirement_id`, `Product`.`thickness_dimension`, `Product`.`thickness_id`, `Product`.`total_thickness_dimension`, `Product`.`total_thickness_id`, `Product`.`meta_tag_title`, `Product`.`meta_tag_description`, `Product`.`meta_brand`, `Product`.`meta_categories`, `Product`.`meta_certifications`, `Product`.`meta_cp1_items`, `Product`.`meta_vitems`, `Product`.`meta_ink_types`, `Product`.`meta_specifications`, `Product`.`meta_substrates`, `Product`.`manual_key_words`, `Product`.`key_words`, `Product`.`washability_id`, `Product`.`m1_sync`, `Product`.`dpg_sync`, `Product`.`std_price_update`, `Product`.`sell_update`, `Product`.`sell_strategy`, `Product`.`ink_type_id`, `Product`.`profile_id`, `Product`.`cs_count`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `dpg_ecommerce`.`products` AS `Product` JOIN `dpg_ecommerce`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 112 AND `CategoriesProduct`.`product_id` = `Product`.`id`) ORDER BY `Product`.`name` ASC | 3 | 3 | 1 | maybe slow |
| SELECT `SubGroup`.`id`, `SubGroup`.`name`, `SubGroup`.`group_id`, `SubGroup`.`a10n` FROM `dpg_ecommerce`.`sub_groups` AS `SubGroup` WHERE `SubGroup`.`id` = 34 | 1 | 1 | 0 | |
| SELECT `SubGroup`.`id`, `SubGroup`.`name`, `SubGroup`.`group_id`, `SubGroup`.`a10n` FROM `dpg_ecommerce`.`sub_groups` AS `SubGroup` WHERE `SubGroup`.`id` = 80 | 1 | 1 | 0 | |
| SELECT `SubGroup`.`id`, `SubGroup`.`name`, `SubGroup`.`group_id`, `SubGroup`.`a10n` FROM `dpg_ecommerce`.`sub_groups` AS `SubGroup` WHERE `SubGroup`.`id` = 37 | 1 | 1 | 0 | |
| SELECT `OutSideDurability`.`id`, `OutSideDurability`.`description`, `OutSideDurability`.`a10n`, `OutSideDurability`.`sort`, `OutSideDurability`.`groups`, `OutSideDurability`.`specification_id`, `OutSideDurability`.`icon`, `OutSideDurability`.`text_color`, `OutSideDurability`.`index_flag`, `OutSideDurability`.`active` FROM `dpg_ecommerce`.`specification_details` AS `OutSideDurability` WHERE `OutSideDurability`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `OutSideDurability`.`id`, `OutSideDurability`.`description`, `OutSideDurability`.`a10n`, `OutSideDurability`.`sort`, `OutSideDurability`.`groups`, `OutSideDurability`.`specification_id`, `OutSideDurability`.`icon`, `OutSideDurability`.`text_color`, `OutSideDurability`.`index_flag`, `OutSideDurability`.`active` FROM `dpg_ecommerce`.`specification_details` AS `OutSideDurability` WHERE `OutSideDurability`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `OutSideDurability`.`id`, `OutSideDurability`.`description`, `OutSideDurability`.`a10n`, `OutSideDurability`.`sort`, `OutSideDurability`.`groups`, `OutSideDurability`.`specification_id`, `OutSideDurability`.`icon`, `OutSideDurability`.`text_color`, `OutSideDurability`.`index_flag`, `OutSideDurability`.`active` FROM `dpg_ecommerce`.`specification_details` AS `OutSideDurability` WHERE `OutSideDurability`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `InSideDurability`.`id`, `InSideDurability`.`description`, `InSideDurability`.`a10n`, `InSideDurability`.`sort`, `InSideDurability`.`groups`, `InSideDurability`.`specification_id`, `InSideDurability`.`icon`, `InSideDurability`.`text_color`, `InSideDurability`.`index_flag`, `InSideDurability`.`active` FROM `dpg_ecommerce`.`specification_details` AS `InSideDurability` WHERE `InSideDurability`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `InSideDurability`.`id`, `InSideDurability`.`description`, `InSideDurability`.`a10n`, `InSideDurability`.`sort`, `InSideDurability`.`groups`, `InSideDurability`.`specification_id`, `InSideDurability`.`icon`, `InSideDurability`.`text_color`, `InSideDurability`.`index_flag`, `InSideDurability`.`active` FROM `dpg_ecommerce`.`specification_details` AS `InSideDurability` WHERE `InSideDurability`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `InSideDurability`.`id`, `InSideDurability`.`description`, `InSideDurability`.`a10n`, `InSideDurability`.`sort`, `InSideDurability`.`groups`, `InSideDurability`.`specification_id`, `InSideDurability`.`icon`, `InSideDurability`.`text_color`, `InSideDurability`.`index_flag`, `InSideDurability`.`active` FROM `dpg_ecommerce`.`specification_details` AS `InSideDurability` WHERE `InSideDurability`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `InkType`.`id`, `InkType`.`name`, `InkType`.`a10n`, `InkType`.`sort`, `InkProduct`.`id`, `InkProduct`.`ink_type_id`, `InkProduct`.`product_id` FROM `dpg_ecommerce`.`ink_types` AS `InkType` JOIN `dpg_ecommerce`.`ink_products` AS `InkProduct` ON (`InkProduct`.`product_id` IN (794, 1238, 1385) AND `InkProduct`.`ink_type_id` = `InkType`.`id`) | 0 | 0 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE `Category`.`id` = 112 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 223 AND `Category`.`rght` >= 224 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE `Category`.`id` = 112 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 223 AND `Category`.`rght` >= 224 ORDER BY `Category`.`lft` asc | 3 | 3 | 0 | |
| SELECT `Category`.`lft`, `Category`.`rght` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`id` = 112 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`template_id`, `Category`.`slug`, `Category`.`slug_lock`, `Category`.`publish_flag`, `Category`.`heading`, `Category`.`meta_tag_title`, `Category`.`meta_tag_description`, `Category`.`product_id`, `Category`.`seq`, `Category`.`modified` FROM `dpg_ecommerce`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`rght` < 224 AND `Category`.`lft` > 223 ORDER BY `Category`.`lft` asc | 0 | 0 | 0 | |
| SELECT `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template` FROM `dpg_ecommerce`.`templates` AS `Template` WHERE `Template`.`id` = 22 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1 | 20 | 20 | 0 | |
7 duplicate queries run.
