| 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` = '46c5404893f7d8e229da7750c47993437n1mo6i9u6f9bbamgk6ajjem42' LIMIT 1 | 1 | 1 | 411 | maybe slow |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969197 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `dpg_ecommerce`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`id` = 1969197 | 1 | 1 | 0 | |
| UPDATE `dpg_ecommerce`.`user_activities` SET `id` = 1969197, `useragent` = '46c5404893f7d8e229da7750c47993437n1mo6i9u6f9bbamgk6ajjem42', `user_id` = NULL, `last_action` = 1765006854, `last_url` = '/products/shop/Roland-DGA-ESM-MCVP-PSA-Print-Media', `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:40:41', `modified` = '2025-12-05 21:40:56' WHERE `dpg_ecommerce`.`user_activities`.`id` = '1969197' | 1 | 1 | 0 | |
| COMMIT | | | | |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`slug` = 'Roland-DGA-ESM-MCVP-PSA-Print-Media' 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`, `Group`.`id`, `Group`.`name`, `Group`.`a10n`, `SubGroup`.`id`, `SubGroup`.`name`, `SubGroup`.`group_id`, `SubGroup`.`a10n`, `Template`.`id`, `Template`.`name`, `Template`.`notes`, `Template`.`template`, `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color`, `PrimaryBrand`.`id`, `PrimaryBrand`.`parent_id`, `PrimaryBrand`.`lft`, `PrimaryBrand`.`rght`, `PrimaryBrand`.`name`, `PrimaryBrand`.`template_id`, `PrimaryBrand`.`slug`, `PrimaryBrand`.`meta_tag_title`, `PrimaryBrand`.`meta_tag_description`, `PrimaryBrand`.`url`, `PrimaryBrand`.`publish_flag` FROM `dpg_ecommerce`.`products` AS `Product` LEFT JOIN `dpg_ecommerce`.`groups` AS `Group` ON (`Product`.`group_id` = `Group`.`id`) LEFT JOIN `dpg_ecommerce`.`sub_groups` AS `SubGroup` ON (`Product`.`sub_group_id` = `SubGroup`.`id`) LEFT JOIN `dpg_ecommerce`.`templates` AS `Template` ON (`Product`.`template_id` = `Template`.`id`) LEFT JOIN `dpg_ecommerce`.`specification_details` AS `StockStatus` ON (`Product`.`stock_status_id` = `StockStatus`.`id`) LEFT JOIN `dpg_ecommerce`.`brands` AS `PrimaryBrand` ON (`Product`.`primary_brand_id` = `PrimaryBrand`.`id`) WHERE ((`Product`.`publish_flag` != 'N') AND (`Product`.`id` = 834)) ORDER BY `Product`.`id` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Item`.`id`, `Item`.`cp1_item`, `Item`.`product_parent`, `Item`.`sell`, `Item`.`org_sell`, `Item`.`sell_override`, `Item`.`cost`, `Item`.`org_cost`, `Item`.`std_cost`, `Item`.`org_std_cost`, `Item`.`last_cost`, `Item`.`org_last_cost`, `Item`.`fixed_cost`, `Item`.`org_fixed_cost`, `Item`.`dim1`, `Item`.`dim1_unit_id`, `Item`.`dim2`, `Item`.`dim2_unit_id`, `Item`.`item_unit_id`, `Item`.`vitem`, `Item`.`cp_vend_no`, `Item`.`publish_flag`, `Item`.`group_id`, `Item`.`price_group_id`, `Item`.`finish_id`, `Item`.`ships_by_itself`, `Item`.`shipping_width`, `Item`.`shipping_height`, `Item`.`shipping_length`, `Item`.`shipping_weight`, `Item`.`acutal_weight`, `Item`.`shipping_header_id`, `Item`.`free_shipping_item`, `Item`.`stock_status_id`, `Item`.`description_override`, `Item`.`clear_override`, `Item`.`cp1_description`, `Item`.`auto_desc`, `Item`.`keyword`, `Item`.`keyword_2`, `Item`.`color_id`, `Item`.`item_id`, `Item`.`csi`, `Item`.`color_selector_id`, `Item`.`color_number`, `Item`.`cp1_status`, `Item`.`taxable`, `Item`.`min`, `Item`.`max`, `Item`.`qty_avail`, `Item`.`qty_on_hand`, `Item`.`qty_on_po`, `Item`.`qty_on_bo`, `Item`.`qty_commit`, `Item`.`last_po_date`, `Item`.`instock_override`, `Item`.`created`, `Item`.`modified`, `Item`.`cost_update`, `Item`.`cost_update_method`, `Item`.`last_cost_update`, `Item`.`last_cost_update_method`, `Item`.`fixed_cost_update`, `Item`.`fixed_cost_update_method`, `Item`.`sell_update`, `Item`.`sell_update_method`, `Item`.`sell_strategy`, `Item`.`cp1_write_off`, `Item`.`cp1_categ_cod`, `Item`.`cp1_subcat_cod`, `Item`.`cp1_categ_subcat`, `Item`.`photo_square`, `Item`.`hide`, `Item`.`sale_end`, `Item`.`sale_price`, `Item`.`sale_start`, `Item`.`legacy_id`, `Item`.`legacy_source`, `Item`.`kit_part`, `Item`.`kit_flag`, `Item`.`kitable`, `Item`.`fedx_flag`, `Item`.`ups_flag`, `Item`.`cp1_export`, `Item`.`cp1_sync`, `Item`.`cp1_update`, `Item`.`cp1_export_flag`, `Item`.`unit_id`, `ItemsProduct`.`id`, `ItemsProduct`.`item_id`, `ItemsProduct`.`product_id` FROM `dpg_ecommerce`.`items` AS `Item` JOIN `dpg_ecommerce`.`items_products` AS `ItemsProduct` ON (`ItemsProduct`.`product_id` = 834 AND `ItemsProduct`.`item_id` = `Item`.`id`) WHERE `Item`.`publish_flag` != 'N' | 3 | 3 | 1 | maybe slow |
| SELECT `Item_Unit`.`id`, `Item_Unit`.`name`, `Item_Unit`.`conversion`, `Item_Unit`.`a10n`, `Item_Unit`.`purpose`, `Item_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Item_Unit` WHERE `Item_Unit`.`id` = 18 | 1 | 1 | 0 | |
| SELECT `Item_Unit`.`id`, `Item_Unit`.`name`, `Item_Unit`.`conversion`, `Item_Unit`.`a10n`, `Item_Unit`.`purpose`, `Item_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Item_Unit` WHERE `Item_Unit`.`id` = 18 | 1 | 1 | 0 | |
| SELECT `Item_Unit`.`id`, `Item_Unit`.`name`, `Item_Unit`.`conversion`, `Item_Unit`.`a10n`, `Item_Unit`.`purpose`, `Item_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Item_Unit` WHERE `Item_Unit`.`id` = 18 | 1 | 1 | 0 | |
| SELECT `Dim1_Unit`.`id`, `Dim1_Unit`.`name`, `Dim1_Unit`.`conversion`, `Dim1_Unit`.`a10n`, `Dim1_Unit`.`purpose`, `Dim1_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim1_Unit` WHERE `Dim1_Unit`.`id` = 13 | 1 | 1 | 0 | |
| SELECT `Dim1_Unit`.`id`, `Dim1_Unit`.`name`, `Dim1_Unit`.`conversion`, `Dim1_Unit`.`a10n`, `Dim1_Unit`.`purpose`, `Dim1_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim1_Unit` WHERE `Dim1_Unit`.`id` = 13 | 1 | 1 | 0 | |
| SELECT `Dim1_Unit`.`id`, `Dim1_Unit`.`name`, `Dim1_Unit`.`conversion`, `Dim1_Unit`.`a10n`, `Dim1_Unit`.`purpose`, `Dim1_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim1_Unit` WHERE `Dim1_Unit`.`id` = 13 | 1 | 1 | 0 | |
| SELECT `Dim2_Unit`.`id`, `Dim2_Unit`.`name`, `Dim2_Unit`.`conversion`, `Dim2_Unit`.`a10n`, `Dim2_Unit`.`purpose`, `Dim2_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim2_Unit` WHERE `Dim2_Unit`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `Dim2_Unit`.`id`, `Dim2_Unit`.`name`, `Dim2_Unit`.`conversion`, `Dim2_Unit`.`a10n`, `Dim2_Unit`.`purpose`, `Dim2_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim2_Unit` WHERE `Dim2_Unit`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `Dim2_Unit`.`id`, `Dim2_Unit`.`name`, `Dim2_Unit`.`conversion`, `Dim2_Unit`.`a10n`, `Dim2_Unit`.`purpose`, `Dim2_Unit`.`sort` FROM `dpg_ecommerce`.`units` AS `Dim2_Unit` WHERE `Dim2_Unit`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 5 | 1 | 1 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 5 | 1 | 1 | 0 | |
| SELECT `Group`.`id`, `Group`.`name`, `Group`.`a10n` FROM `dpg_ecommerce`.`groups` AS `Group` WHERE `Group`.`id` = 5 | 1 | 1 | 0 | |
| SELECT `PriceGroup`.`id`, `PriceGroup`.`description`, `PriceGroup`.`a10n`, `PriceGroup`.`sort`, `PriceGroup`.`groups`, `PriceGroup`.`specification_id`, `PriceGroup`.`icon`, `PriceGroup`.`text_color`, `PriceGroup`.`index_flag`, `PriceGroup`.`active` FROM `dpg_ecommerce`.`specification_details` AS `PriceGroup` WHERE `PriceGroup`.`id` = 247 | 1 | 1 | 0 | |
| SELECT `PriceGroup`.`id`, `PriceGroup`.`description`, `PriceGroup`.`a10n`, `PriceGroup`.`sort`, `PriceGroup`.`groups`, `PriceGroup`.`specification_id`, `PriceGroup`.`icon`, `PriceGroup`.`text_color`, `PriceGroup`.`index_flag`, `PriceGroup`.`active` FROM `dpg_ecommerce`.`specification_details` AS `PriceGroup` WHERE `PriceGroup`.`id` = 247 | 1 | 1 | 0 | |
| SELECT `PriceGroup`.`id`, `PriceGroup`.`description`, `PriceGroup`.`a10n`, `PriceGroup`.`sort`, `PriceGroup`.`groups`, `PriceGroup`.`specification_id`, `PriceGroup`.`icon`, `PriceGroup`.`text_color`, `PriceGroup`.`index_flag`, `PriceGroup`.`active` FROM `dpg_ecommerce`.`specification_details` AS `PriceGroup` WHERE `PriceGroup`.`id` = 247 | 1 | 1 | 0 | |
| SELECT `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color` FROM `dpg_ecommerce`.`specification_details` AS `StockStatus` WHERE `StockStatus`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color` FROM `dpg_ecommerce`.`specification_details` AS `StockStatus` WHERE `StockStatus`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `StockStatus`.`id`, `StockStatus`.`description`, `StockStatus`.`text_color` FROM `dpg_ecommerce`.`specification_details` AS `StockStatus` WHERE `StockStatus`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `Color`.`id`, `Color`.`description`, `Color`.`a10n`, `Color`.`sort`, `Color`.`groups`, `Color`.`specification_id`, `Color`.`icon`, `Color`.`text_color`, `Color`.`index_flag`, `Color`.`active` FROM `dpg_ecommerce`.`specification_details` AS `Color` WHERE `Color`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `Color`.`id`, `Color`.`description`, `Color`.`a10n`, `Color`.`sort`, `Color`.`groups`, `Color`.`specification_id`, `Color`.`icon`, `Color`.`text_color`, `Color`.`index_flag`, `Color`.`active` FROM `dpg_ecommerce`.`specification_details` AS `Color` WHERE `Color`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `Color`.`id`, `Color`.`description`, `Color`.`a10n`, `Color`.`sort`, `Color`.`groups`, `Color`.`specification_id`, `Color`.`icon`, `Color`.`text_color`, `Color`.`index_flag`, `Color`.`active` FROM `dpg_ecommerce`.`specification_details` AS `Color` WHERE `Color`.`id` = 0 | 0 | 0 | 0 | |
| SELECT `ShippingHeader`.`id`, `ShippingHeader`.`name`, `ShippingHeader`.`a10n`, `ShippingHeader`.`zones`, `ShippingHeader`.`extra_fee` FROM `dpg_ecommerce`.`shipping_headers` AS `ShippingHeader` WHERE `ShippingHeader`.`id` = 0 | 1 | 1 | 0 | |
| SELECT `ShippingHeader`.`id`, `ShippingHeader`.`name`, `ShippingHeader`.`a10n`, `ShippingHeader`.`zones`, `ShippingHeader`.`extra_fee` FROM `dpg_ecommerce`.`shipping_headers` AS `ShippingHeader` WHERE `ShippingHeader`.`id` = 0 | 1 | 1 | 0 | |
| SELECT `ShippingHeader`.`id`, `ShippingHeader`.`name`, `ShippingHeader`.`a10n`, `ShippingHeader`.`zones`, `ShippingHeader`.`extra_fee` FROM `dpg_ecommerce`.`shipping_headers` AS `ShippingHeader` WHERE `ShippingHeader`.`id` = 0 | 1 | 1 | 0 | |
| SELECT `ShippingRates`.`id`, `ShippingRates`.`weight`, `ShippingRates`.`value`, `ShippingRates`.`shipping_header_id` FROM `dpg_ecommerce`.`shipping_rates` AS `ShippingRates` WHERE `ShippingRates`.`shipping_header_id` = 0 AND `ShippingRates`.`weight` = '7' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ShippingRates`.`id`, `ShippingRates`.`weight`, `ShippingRates`.`value`, `ShippingRates`.`shipping_header_id` FROM `dpg_ecommerce`.`shipping_rates` AS `ShippingRates` WHERE `ShippingRates`.`shipping_header_id` = 0 AND `ShippingRates`.`weight` = '0' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ShippingRates`.`id`, `ShippingRates`.`weight`, `ShippingRates`.`value`, `ShippingRates`.`shipping_header_id` FROM `dpg_ecommerce`.`shipping_rates` AS `ShippingRates` WHERE `ShippingRates`.`shipping_header_id` = 0 AND `ShippingRates`.`weight` = '0' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Specification`.`id`, `Specification`.`name` FROM `dpg_ecommerce`.`specifications` AS `Specification` WHERE `Specification`.`id` = 21 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`id`, `SpecificationDetail`.`description`, `SpecificationDetail`.`a10n`, `SpecificationDetail`.`sort`, `SpecificationDetail`.`groups`, `SpecificationDetail`.`specification_id`, `SpecificationDetail`.`icon`, `SpecificationDetail`.`text_color`, `SpecificationDetail`.`index_flag`, `SpecificationDetail`.`active` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`specification_id` = (21) | 11 | 11 | 0 | |
| SELECT `Specification`.`id`, `Specification`.`name` FROM `dpg_ecommerce`.`specifications` AS `Specification` WHERE `Specification`.`id` = 21 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`id`, `SpecificationDetail`.`description`, `SpecificationDetail`.`a10n`, `SpecificationDetail`.`sort`, `SpecificationDetail`.`groups`, `SpecificationDetail`.`specification_id`, `SpecificationDetail`.`icon`, `SpecificationDetail`.`text_color`, `SpecificationDetail`.`index_flag`, `SpecificationDetail`.`active` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`specification_id` = (21) | 11 | 11 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 16 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 171 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 191 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 84 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 604 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 16 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 171 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 191 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 84 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 604 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SpecificationDetail`.`description` FROM `dpg_ecommerce`.`specification_details` AS `SpecificationDetail` WHERE `SpecificationDetail`.`id` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductSideBar`.`id`, `ProductSideBar`.`heading_text`, `ProductSideBar`.`heading_text_id`, `ProductSideBar`.`product_id`, `ProductSideBar`.`heading_color`, `ProductSideBar`.`heading_text_color`, `ProductSideBar`.`heading_icon`, `ProductSideBar`.`new_heading_icon`, `ProductSideBar`.`body_text`, `ProductSideBar`.`download_file_path`, `ProductSideBar`.`download_icon_path`, `ProductSideBar`.`download_icon_alt_text`, `ProductSideBar`.`footer_text_id`, `ProductSideBar`.`footer_color`, `ProductSideBar`.`footer_text_color`, `ProductSideBar`.`footer_text`, `ProductSideBar`.`footer_body_text`, `ProductSideBar`.`footer_link`, `ProductSideBar`.`footer_icon`, `ProductSideBar`.`new_footer_icon`, `ProductSideBar`.`sort_flag`, `ProductSideBar`.`sort`, `ProductSideBar`.`publish_flag`, `ProductSideBar`.`type`, `ProductSideBar`.`new_type`, `ProductSideBar`.`product_link_id`, `ProductSideBar`.`product_link_path`, `ProductSideBar`.`file_flag`, `ProductSideBar`.`position` FROM `dpg_ecommerce`.`product_side_bars` AS `ProductSideBar` WHERE `ProductSideBar`.`product_id` = 834 AND `ProductSideBar`.`publish_flag` = 'Y' ORDER BY `ProductSideBar`.`sort` ASC | 0 | 0 | 0 | |
| SELECT `Cp1SpecialPrice`.`id`, `Cp1SpecialPrice`.`GRP_TYP`, `Cp1SpecialPrice`.`CUST_NO`, `Cp1SpecialPrice`.`GRP_COD`, `Cp1SpecialPrice`.`RUL_SEQ_NO`, `Cp1SpecialPrice`.`DESCR`, `Cp1SpecialPrice`.`ITEM_FILT`, `Cp1SpecialPrice`.`MIN_QTY`, `Cp1SpecialPrice`.`PRC_METH`, `Cp1SpecialPrice`.`PRC_BASIS`, `Cp1SpecialPrice`.`AMT_OR_PCT`, `Cp1SpecialPrice`.`MIX_MATCH_COD`, `UserBillTo`.`id`, `UserBillTo`.`m1_id`, `UserBillTo`.`name`, `UserBillTo`.`address1`, `UserBillTo`.`address2`, `UserBillTo`.`city`, `UserBillTo`.`state`, `UserBillTo`.`zip`, `UserBillTo`.`phone`, `UserBillTo`.`fax`, `UserBillTo`.`web_page`, `UserBillTo`.`web`, `UserBillTo`.`cp1_account`, `UserBillTo`.`payment_term_id`, `UserBillTo`.`freight_code_id`, `UserBillTo`.`tax_cod`, `UserBillTo`.`tax_number`, `UserBillTo`.`created`, `UserBillTo`.`modified`, `UserBillTo`.`last_login`, `UserBillTo`.`last_order`, `UserBillTo`.`last_sale`, `UserBillTo`.`saleperson_id`, `UserBillTo`.`salesperson`, `UserBillTo`.`assigned_to_id`, `UserBillTo`.`sync`, `UserBillTo`.`m1_import`, `UserBillTo`.`active`, `UserBillTo`.`keywords`, `UserBillTo`.`key_code` FROM `dpg_ecommerce`.`cp1_special_prices` AS `Cp1SpecialPrice` LEFT JOIN `dpg_ecommerce`.`user_bill_tos` AS `UserBillTo` ON (`UserBillTo`.`cp1_account` = `Cp1SpecialPrice`.`CUST_NO`) WHERE ((((`Cp1SpecialPrice`.`CUST_NO` IS NULL) AND (`UserBillTo`.`name` IS NULL))) OR (`Cp1SpecialPrice`.`CUST_NO` IS NULL)) ORDER BY `Cp1SpecialPrice`.`RUL_SEQ_NO` DESC | 2 | 2 | 1 | maybe slow |
| SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1008780 AND (((Item.cp1_item >= '1002051') and (Item.cp1_item <= '1002053'))) | 0 | 0 | 2 | maybe slow |
| SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1008780 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487'))) | 0 | 0 | 2 | maybe slow |
| SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1114631 AND (((Item.cp1_item >= '1002051') and (Item.cp1_item <= '1002053'))) | 0 | 0 | 2 | maybe slow |
| SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1114631 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487'))) | 0 | 0 | 2 | maybe slow |
| SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1114630 AND (((Item.cp1_item >= '1002051') and (Item.cp1_item <= '1002053'))) | 0 | 0 | 2 | maybe slow |
| SELECT `Item`.`id` FROM `dpg_ecommerce`.`items` AS `Item` WHERE `Item`.`cp1_item` = 1114630 AND (((Item.cp1_item >= '1002487') and (Item.cp1_item <= '1002487'))) | 0 | 0 | 2 | maybe slow |
| SELECT `Product`.`id`, `Product`.`name` FROM `dpg_ecommerce`.`products` AS `Product` WHERE `Product`.`id` = 834 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SeeAlso`.`id`, `SeeAlso`.`name`, `SeeAlso`.`product_id`, `SeeAlso`.`override`, `SeeAlso`.`sort`, `SeeAlso`.`publish_flag` FROM `dpg_ecommerce`.`see_alsos` AS `SeeAlso` WHERE `SeeAlso`.`product_id` = (834) | 0 | 0 | 0 | |
| SELECT `InkType`.`id`, `InkType`.`name` FROM `dpg_ecommerce`.`ink_types` AS `InkType` WHERE 1 = 1 | 20 | 20 | 0 | |
38 duplicate queries run.