| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Company`.`inactive_logout_minutes` FROM `hive-beta`.`companies` AS `Company` WHERE `url_prefix` = 'acme' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `SiteSetting`.`id`, `SiteSetting`.`name`, `SiteSetting`.`array_slug`, `SiteSetting`.`type`, `SiteSetting`.`options`, `SiteSetting`.`value`, `SiteSetting`.`sequence`, `SiteSetting`.`site_setting_category_id`, `SiteSetting`.`prevent_edit`, `SiteSetting`.`created`, `SiteSetting`.`modified`, `SiteSettingCategory`.`id`, `SiteSettingCategory`.`name`, `SiteSettingCategory`.`array_slug`, `SiteSettingCategory`.`sequence`, `SiteSettingCategory`.`prevent_edit`, `SiteSettingCategory`.`created`, `SiteSettingCategory`.`modified` FROM `hive-beta`.`ev_site_settings_site_settings` AS `SiteSetting` LEFT JOIN `hive-beta`.`ev_site_settings_site_setting_categories` AS `SiteSettingCategory` ON (`SiteSetting`.`site_setting_category_id` = `SiteSettingCategory`.`id`) WHERE 1 = 1 ORDER BY `SiteSetting`.`array_slug` ASC | 22 | 22 | 1 | |
| SELECT `Currency`.`id`, `Currency`.`name` FROM `hive-beta`.`ev_currency_currencies` AS `Currency` WHERE `Currency`.`is_active` = '1' ORDER BY `Currency`.`name` ASC, `Currency`.`sequence` ASC | 1 | 1 | 0 | |
| SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`currency_prefix`, `Currency`.`currency_suffix`, `Currency`.`thousand_separator`, `Currency`.`decimal_point_char`, `Currency`.`decimal_places`, `Currency`.`exchange_rate`, `Currency`.`exchange_rate_date`, `Currency`.`conversion_padding`, `Currency`.`free_delivery_threshold`, `Currency`.`is_active`, `Currency`.`is_default`, `Currency`.`sequence`, `Currency`.`created`, `Currency`.`modified` FROM `hive-beta`.`ev_currency_currencies` AS `Currency` WHERE `is_default` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Currency`.`id`, `Currency`.`name`, `Currency`.`currency_prefix`, `Currency`.`currency_suffix`, `Currency`.`thousand_separator`, `Currency`.`decimal_point_char`, `Currency`.`decimal_places`, `Currency`.`exchange_rate`, `Currency`.`exchange_rate_date`, `Currency`.`conversion_padding`, `Currency`.`free_delivery_threshold`, `Currency`.`is_active`, `Currency`.`is_default`, `Currency`.`sequence`, `Currency`.`created`, `Currency`.`modified` FROM `hive-beta`.`ev_currency_currencies` AS `Currency` WHERE `id` = 1 AND `is_active` = '1' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `hive-beta`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '88551e4546fab01a1b4434ad3eefb272' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`url_prefix`, `Company`.`hex_welcome_background`, `Company`.`hex_welcome_text`, `Company`.`hex_primary_background`, `Company`.`hex_primary_text`, `Company`.`hex_secondary_background`, `Company`.`hex_secondary_text`, `Company`.`hex_secondary_text2`, `Company`.`password_expiry_days`, `Company`.`inactive_logout_minutes`, `Company`.`whitelist_ips`, `Company`.`delivery_schedule`, `Company`.`contact_details`, `Company`.`allows_registration`, `Company`.`show_popular_products`, `Company`.`delivery_cost`, `Company`.`delivery_offer`, `Company`.`free_monthly_deliveries_per_branch`, `Company`.`free_delivery_fixed_amount`, `Company`.`minimum_spend`, `Company`.`budget_timeframe`, `Company`.`budget_start_date`, `Company`.`allows_hq_edit`, `Company`.`allows_area_manager_edit`, `Company`.`allows_area_manager_order_address_edit`, `Company`.`allows_area_manager_order_quantity_edit`, `Company`.`branch_registration_fields`, `Company`.`has_custom_briefing_form`, `Company`.`has_password_reveal`, `Company`.`has_mandatory_order_reference`, `Company`.`admin_contact_id`, `Company`.`branch_terminology_id`, `Company`.`created`, `Company`.`modified`, `Company`.`is_active`, `BranchTerminology`.`id`, `BranchTerminology`.`name`, `BranchTerminology`.`singular`, `BranchTerminology`.`plural`, `BranchTerminology`.`created`, `BranchTerminology`.`modified`, `BranchTerminology`.`is_active`, (CONCAT(`BranchTerminology`.`name`, ' (', `BranchTerminology`.`singular`, ' / ', `BranchTerminology`.`plural`, ')')) AS `BranchTerminology__long_name` FROM `hive-beta`.`companies` AS `Company` LEFT JOIN `hive-beta`.`branch_terminologies` AS `BranchTerminology` ON (`Company`.`branch_terminology_id` = `BranchTerminology`.`id`) WHERE `Company`.`url_prefix` = 'acme' AND `Company`.`is_active` = '1' AND ((`Company`.`whitelist_ips` IS NULL) OR (`Company`.`whitelist_ips` = '') OR (`Company`.`whitelist_ips` LIKE '%216.73.216.166%')) LIMIT 1 | 1 | 1 | 1 | |
| SELECT `LogoImage`.`id`, `LogoImage`.`model`, `LogoImage`.`model_id`, `LogoImage`.`filename`, `LogoImage`.`attachment_type`, `LogoImage`.`template_id`, `LogoImage`.`alt`, `LogoImage`.`caption`, `LogoImage`.`link_text`, `LogoImage`.`link_url`, `LogoImage`.`type`, `LogoImage`.`size`, `LogoImage`.`dir`, `LogoImage`.`sequence`, `LogoImage`.`is_active`, `LogoImage`.`created`, `LogoImage`.`modified`, (CONCAT("files/image/", dir, "/", filename)) AS `LogoImage__filepath` FROM `hive-beta`.`images` AS `LogoImage` WHERE `model` = 'Company' AND `attachment_type` = 'LogoImage' AND `LogoImage`.`model_id` = (7) | 1 | 1 | 2 | maybe slow |
| SELECT `UserManualDocument`.`id`, `UserManualDocument`.`uuid`, `UserManualDocument`.`model`, `UserManualDocument`.`model_id`, `UserManualDocument`.`filename`, `UserManualDocument`.`attachment_type`, `UserManualDocument`.`template_id`, `UserManualDocument`.`caption`, `UserManualDocument`.`type`, `UserManualDocument`.`ext`, `UserManualDocument`.`size`, `UserManualDocument`.`dir`, `UserManualDocument`.`sequence`, `UserManualDocument`.`is_active`, `UserManualDocument`.`created`, `UserManualDocument`.`modified`, (CONCAT("files/document/", dir, "/", filename)) AS `UserManualDocument__filepath`, (CONCAT("/files/document/", dir, "/", filename)) AS `UserManualDocument__url` FROM `hive-beta`.`documents` AS `UserManualDocument` WHERE `model` = 'Company' AND `attachment_type` = 'UserManualDocument' AND `UserManualDocument`.`model_id` = (7) ORDER BY `sequence` asc | 1 | 1 | 1 | |
| SELECT `Page`.`template_id` FROM `hive-beta`.`pages` AS `Page` WHERE `Page`.`id` = 40 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`title`, `Page`.`internal_title`, `Page`.`body`, `Page`.`is_active`, `Page`.`is_protected`, `Page`.`template_id`, `Page`.`redirect_url`, `Page`.`created`, `Page`.`modified` FROM `hive-beta`.`pages` AS `Page` WHERE `Page`.`is_active` = '1' AND `Page`.`id` = 40 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`filename`, `Image`.`attachment_type`, `Image`.`template_id`, `Image`.`alt`, `Image`.`caption`, `Image`.`link_text`, `Image`.`link_url`, `Image`.`type`, `Image`.`size`, `Image`.`dir`, `Image`.`sequence`, `Image`.`is_active`, `Image`.`created`, `Image`.`modified`, (CONCAT("files/image/", dir, "/", filename)) AS `Image__filepath` FROM `hive-beta`.`images` AS `Image` WHERE `model` = 'Page' AND `attachment_type` = 'Image' AND `Image`.`model_id` = (40) ORDER BY `sequence` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `MetaData`.`id`, `MetaData`.`model`, `MetaData`.`model_id`, `MetaData`.`title`, `MetaData`.`description`, `MetaData`.`keywords`, `MetaData`.`created`, `MetaData`.`modified` FROM `hive-beta`.`meta_data` AS `MetaData` WHERE ((`MetaData`.`model` = 'Page') AND (`MetaData`.`model_id` = 40)) | 1 | 1 | 1 | |
| SELECT `FieldData`.`id`, `FieldData`.`field_id`, `FieldData`.`value`, `FieldData`.`model`, `FieldData`.`model_id`, `FieldData`.`created`, `FieldData`.`modified`, `Field`.`id`, `Field`.`name`, `Field`.`tab_name`, `Field`.`label`, `Field`.`type`, `Field`.`display_info`, `Field`.`options`, `Field`.`validation`, `Field`.`model`, `Field`.`model_id`, `Field`.`sequence`, `Field`.`is_active`, `Field`.`created`, `Field`.`modified` FROM `hive-beta`.`ev_custom_fields_field_data` AS `FieldData` LEFT JOIN `hive-beta`.`ev_custom_fields_fields` AS `Field` ON (`FieldData`.`field_id` = `Field`.`id`) WHERE `FieldData`.`model` = 'EvCore.Page' AND `FieldData`.`model_id` = (40) ORDER BY `Field`.`sequence` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`parent_id`, `CompaniesProductCategory`.`total_products`, `ProductCategory`.`slug` FROM `hive-beta`.`product_categories` AS `ProductCategory` INNER JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`slug` IS NOT NULL ORDER BY `ProductCategory`.`name` ASC | 23 | 23 | 1 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`parent_id`, `CompaniesProductCategory`.`total_products`, `ProductCategory`.`slug` FROM `hive-beta`.`product_categories` AS `ProductCategory` INNER JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`slug` IS NOT NULL AND `ProductCategory`.`parent_id` IN (64, 21, 68, 83, 36, 15, 38, 22, 14, 2, 67, 3, 4, 65, 62, 1, 12, 5, 26, 10, 16, 13, 18) ORDER BY `ProductCategory`.`name` ASC | 14 | 14 | 1 | maybe slow |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 36 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 204 AND `ProductCategory`.`rght` >= 215 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 92 AND `ProductCategory`.`rght` >= 105 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 2 | maybe slow |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 10 AND `ProductCategory`.`rght` >= 29 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 1 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 30 AND `ProductCategory`.`rght` >= 37 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 38 AND `ProductCategory`.`rght` >= 53 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 62 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 116 AND `ProductCategory`.`rght` >= 131 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 2 AND `ProductCategory`.`rght` >= 9 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 54 AND `ProductCategory`.`rght` >= 77 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 1 | |
| SELECT `ProductCategory`.`lft`, `ProductCategory`.`rght` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE `ProductCategory`.`id` = 18 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `ProductCategory`.`content`, `ProductCategory`.`parent_id`, `ProductCategory`.`lft`, `ProductCategory`.`rght`, `ProductCategory`.`created`, `ProductCategory`.`modified`, `ProductCategory`.`is_active` FROM `hive-beta`.`product_categories` AS `ProductCategory` WHERE 1 = 1 AND `ProductCategory`.`lft` <= 194 AND `ProductCategory`.`rght` >= 203 ORDER BY `ProductCategory`.`lft` asc | 1 | 1 | 0 | |
| SELECT `ProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`is_active` = '1' AND `ProductCategory`.`parent_id` IS NULL GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 19 | 19 | 6 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 170 AND `ProductCategory`.`rght` < 171 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 78 AND `ProductCategory`.`rght` < 91 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 6 | 6 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 172 AND `ProductCategory`.`rght` < 191 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 9 | 9 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 204 AND `ProductCategory`.`rght` < 215 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 5 | 5 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 152 AND `ProductCategory`.`rght` < 169 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 8 | 8 | 4 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 92 AND `ProductCategory`.`rght` < 105 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 6 | 6 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 216 AND `ProductCategory`.`rght` < 223 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 10 AND `ProductCategory`.`rght` < 29 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 9 | 9 | 4 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 232 AND `ProductCategory`.`rght` < 241 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 4 | 4 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 30 AND `ProductCategory`.`rght` < 37 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 3 | 3 | 3 | |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 38 AND `ProductCategory`.`rght` < 53 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 7 | 7 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 116 AND `ProductCategory`.`rght` < 131 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 7 | 7 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 2 AND `ProductCategory`.`rght` < 9 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 54 AND `ProductCategory`.`rght` < 77 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 11 | 11 | 4 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 106 AND `ProductCategory`.`rght` < 107 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 132 AND `ProductCategory`.`rght` < 151 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 9 | 9 | 3 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 224 AND `ProductCategory`.`rght` < 231 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 108 AND `ProductCategory`.`rght` < 115 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 3 | 3 | 2 | maybe slow |
| SELECT `ProductCategory`.`id`, `ProductCategory`.`parent_id`, `ProductCategory`.`name`, `ProductCategory`.`slug`, `CompaniesProductCategory`.*, (`CompaniesProductCategory`.`total_products`) AS `ProductCategory__total_products` FROM `hive-beta`.`product_categories` AS `ProductCategory` LEFT JOIN `hive-beta`.`companies_product_categories` AS `CompaniesProductCategory` ON (`ProductCategory`.`id` = `CompaniesProductCategory`.`product_category_id` AND `CompaniesProductCategory`.`company_id` = 7) LEFT JOIN `hive-beta`.`products` AS `Product` ON (`ProductCategory`.`id` = `Product`.`product_category_id` AND `Product`.`is_active` = '1' AND `Product`.`is_removed` = '0') WHERE `ProductCategory`.`lft` > 194 AND `ProductCategory`.`rght` < 203 AND `ProductCategory`.`is_active` = '1' GROUP BY `ProductCategory`.`id` ORDER BY `ProductCategory`.`name` ASC | 4 | 4 | 2 | maybe slow |
| SELECT `ProductBrand`.`id`, `ProductBrand`.`name`, `CompaniesProductBrand`.`total_products`, `ProductBrand`.`slug` FROM `hive-beta`.`product_brands` AS `ProductBrand` INNER JOIN `hive-beta`.`companies_product_brands` AS `CompaniesProductBrand` ON (`ProductBrand`.`id` = `CompaniesProductBrand`.`product_brand_id` AND `CompaniesProductBrand`.`company_id` = 7) WHERE `ProductBrand`.`is_active` = '1' AND `ProductBrand`.`slug` IS NOT NULL AND `ProductBrand`.`company_id` = 7 ORDER BY `ProductBrand`.`name` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ProductRange`.`id`, `ProductRange`.`name`, `CompaniesProductRange`.`total_products`, `ProductRange`.`slug` FROM `hive-beta`.`product_ranges` AS `ProductRange` INNER JOIN `hive-beta`.`companies_product_ranges` AS `CompaniesProductRange` ON (`ProductRange`.`id` = `CompaniesProductRange`.`product_range_id` AND `CompaniesProductRange`.`company_id` = 7) WHERE `ProductRange`.`is_active` = '1' AND `ProductRange`.`slug` IS NOT NULL AND `ProductRange`.`company_id` = 7 ORDER BY `ProductRange`.`name` ASC | 0 | 0 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '1a9e1434-7667-41ef-ae30-4aa4c0b861e6' AND `Basket`.`currency_id` = 1 | 1 | 1 | 0 | |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '1a9e1434-7667-41ef-ae30-4aa4c0b861e6' | 1 | 1 | 0 | |
| INSERT INTO `hive-beta`.`ev_basket_baskets` (`hash`, `currency_id`, `modified`, `created`) VALUES ('1a9e1434-7667-41ef-ae30-4aa4c0b861e6', 1, '2025-12-10 04:58:42', '2025-12-10 04:58:42') | 1 | 1 | 0 | |
| COMMIT | | | | |
| SELECT COUNT(*) AS `count` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '1a9e1434-7667-41ef-ae30-4aa4c0b861e6' AND `Basket`.`currency_id` = 1 | 1 | 1 | 2 | maybe slow |
| SELECT `Basket`.`id`, `Basket`.`user_id`, `Basket`.`hash`, `Basket`.`currency_id`, `Basket`.`created`, `Basket`.`modified`, `Basket`.`last_activity` FROM `hive-beta`.`ev_basket_baskets` AS `Basket` WHERE `Basket`.`hash` = '1a9e1434-7667-41ef-ae30-4aa4c0b861e6' AND `Basket`.`currency_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `BasketItem`.`id`, `BasketItem`.`basket_id`, `BasketItem`.`name`, `BasketItem`.`model`, `BasketItem`.`model_id`, `BasketItem`.`artwork_type`, `BasketItem`.`company_artwork_id`, `BasketItem`.`company_artwork_caption`, `BasketItem`.`unit_price`, `BasketItem`.`unit_tax`, `BasketItem`.`tax_rate`, `BasketItem`.`quantity`, `BasketItem`.`row_total`, `BasketItem`.`created`, `BasketItem`.`modified` FROM `hive-beta`.`ev_basket_basket_items` AS `BasketItem` WHERE `BasketItem`.`basket_id` = (114347) | 0 | 0 | 0 | |
| SELECT `BasketTotal`.`id`, `BasketTotal`.`basket_id`, `BasketTotal`.`name`, `BasketTotal`.`amount`, `BasketTotal`.`tax`, `BasketTotal`.`display_inc_tax`, `BasketTotal`.`display_ex_tax`, `BasketTotal`.`sequence`, `BasketTotal`.`is_grand_total`, `BasketTotal`.`display_only`, `BasketTotal`.`created`, `BasketTotal`.`modified` FROM `hive-beta`.`ev_basket_basket_totals` AS `BasketTotal` WHERE `BasketTotal`.`basket_id` = (114347) ORDER BY `BasketTotal`.`is_grand_total` ASC, `BasketTotal`.`sequence` ASC | 0 | 0 | 0 | |
| SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`level`, `Menu`.`name`, `Menu`.`system_name`, `Menu`.`url`, `Menu`.`pattern`, `Menu`.`plugin`, `Menu`.`controller`, `Menu`.`model`, `Menu`.`model_id`, `Menu`.`action`, `Menu`.`class`, `Menu`.`content_element`, `Menu`.`permission_level`, `Menu`.`requires_login`, `Menu`.`new_window`, `Menu`.`is_menu_hidden`, `Menu`.`is_active`, `Menu`.`created`, `Menu`.`modified` FROM `hive-beta`.`ev_navigation_menus` AS `Menu` WHERE `Menu`.`id` = 8 ORDER BY `lft` ASC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Menu`.*, `Page`.`redirect_url` FROM `hive-beta`.`ev_navigation_menus` AS `Menu` LEFT JOIN `hive-beta`.`pages` AS `Page` ON (`Menu`.`model` = 'EvCorePage' AND `Page`.`id` = `Menu`.`model_id`) WHERE `Menu`.`lft` > 78 AND `Menu`.`rght` < 79 AND `Menu`.`is_active` = '1' ORDER BY `Menu`.`lft` ASC | 0 | 0 | 0 | |
1 duplicate queries run.