| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`configure_label`, `Setting`.`value` FROM `d4yscq02`.`settings` AS `Setting` WHERE 1 = 1 | 0 | 0 | 0 | |
| SELECT `NeoShopFilterGroup`.`id`, `NeoShopFilterGroup`.`name`, `NeoShopFilterGroup`.`created_by`, `NeoShopFilterGroup`.`modified_by`, `NeoShopFilterGroup`.`created`, `NeoShopFilterGroup`.`modified` FROM `d4yscq02`.`neo_shop_filter_groups` AS `NeoShopFilterGroup` WHERE 1 = 1 | 1 | 1 | 1 | |
| SELECT `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`content`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `NeoShopCategory`.`neo_shop_filter_group_id` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` WHERE `NeoShopCategory`.`neo_shop_filter_group_id` = (4) | 7 | 7 | 1 | maybe slow |
| SELECT `NeoShopManufacturer`.`id`, `NeoShopManufacturer`.`name`, `NeoShopManufacturer`.`content`, `NeoShopManufacturer`.`image`, `NeoShopManufacturer`.`modified`, `NeoShopManufacturer`.`modified_by`, `NeoShopManufacturer`.`created`, `NeoShopManufacturer`.`created_by` FROM `d4yscq02`.`neo_shop_manufacturers` AS `NeoShopManufacturer` WHERE 1 = 1 ORDER BY `NeoShopManufacturer`.`name` ASC | 16 | 16 | 1 | maybe slow |
| SELECT `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` WHERE `NeoShopCategory`.`id` = 275 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`content`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `NeoShopCategory`.`neo_shop_filter_group_id` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` WHERE 1 = 1 AND `NeoShopCategory`.`lft` <= 443 AND `NeoShopCategory`.`rght` >= 444 ORDER BY `NeoShopCategory`.`lft` asc | 3 | 3 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` WHERE `NeoShopCategory`.`id` = 275 | 1 | 1 | 0 | |
| SELECT `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`content`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `NeoShopCategory`.`neo_shop_filter_group_id`, `ParentNeoShopCategory`.`id`, `ParentNeoShopCategory`.`name`, `ParentNeoShopCategory`.`title`, `ParentNeoShopCategory`.`meta_description`, `ParentNeoShopCategory`.`meta_keywords`, `ParentNeoShopCategory`.`content`, `ParentNeoShopCategory`.`parent_id`, `ParentNeoShopCategory`.`lft`, `ParentNeoShopCategory`.`rght`, `ParentNeoShopCategory`.`level`, `ParentNeoShopCategory`.`visible`, `ParentNeoShopCategory`.`image`, `ParentNeoShopCategory`.`modified`, `ParentNeoShopCategory`.`modified_by`, `ParentNeoShopCategory`.`created`, `ParentNeoShopCategory`.`created_by`, `ParentNeoShopCategory`.`neo_shop_filter_group_id`, `NeoShopFilterGroup`.`id`, `NeoShopFilterGroup`.`name`, `NeoShopFilterGroup`.`created_by`, `NeoShopFilterGroup`.`modified_by`, `NeoShopFilterGroup`.`created`, `NeoShopFilterGroup`.`modified`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`user_group_id`, `CreatedBy`.`active`, `CreatedBy`.`blocked`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`active`, `ModifiedBy`.`blocked`, `ModifiedBy`.`created`, `ModifiedBy`.`modified` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` LEFT JOIN `d4yscq02`.`neo_shop_categories` AS `ParentNeoShopCategory` ON (`NeoShopCategory`.`parent_id` = `ParentNeoShopCategory`.`id`) LEFT JOIN `d4yscq02`.`neo_shop_filter_groups` AS `NeoShopFilterGroup` ON (`NeoShopCategory`.`neo_shop_filter_group_id` = `NeoShopFilterGroup`.`id`) LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoShopCategory`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoShopCategory`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoShopCategory`.`id` = 275 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ChildNeoShopCategory`.`id`, `ChildNeoShopCategory`.`name`, `ChildNeoShopCategory`.`title`, `ChildNeoShopCategory`.`meta_description`, `ChildNeoShopCategory`.`meta_keywords`, `ChildNeoShopCategory`.`content`, `ChildNeoShopCategory`.`parent_id`, `ChildNeoShopCategory`.`lft`, `ChildNeoShopCategory`.`rght`, `ChildNeoShopCategory`.`level`, `ChildNeoShopCategory`.`visible`, `ChildNeoShopCategory`.`image`, `ChildNeoShopCategory`.`modified`, `ChildNeoShopCategory`.`modified_by`, `ChildNeoShopCategory`.`created`, `ChildNeoShopCategory`.`created_by`, `ChildNeoShopCategory`.`neo_shop_filter_group_id` FROM `d4yscq02`.`neo_shop_categories` AS `ChildNeoShopCategory` WHERE `ChildNeoShopCategory`.`parent_id` = (275) | 0 | 0 | 1 | maybe slow |
| SELECT `NeoShopProduct`.`id`, `NeoShopProduct`.`neo_shop_category_id`, `NeoShopProduct`.`neo_shop_manufacturer_id`, `NeoShopProduct`.`name`, `NeoShopProduct`.`short_description`, `NeoShopProduct`.`long_description`, `NeoShopProduct`.`unit`, `NeoShopProduct`.`price`, `NeoShopProduct`.`wholesale_price`, `NeoShopProduct`.`reduction_amount`, `NeoShopProduct`.`reduction_percent`, `NeoShopProduct`.`code`, `NeoShopProduct`.`ean13`, `NeoShopProduct`.`stock`, `NeoShopProduct`.`stock_amount`, `NeoShopProduct`.`image`, `NeoShopProduct`.`neo_shop_tax_id`, `NeoShopProduct`.`active`, `NeoShopProduct`.`only_wholesale`, `NeoShopProduct`.`modified`, `NeoShopProduct`.`modified_by`, `NeoShopProduct`.`created`, `NeoShopProduct`.`created_by`, `NeoShopProduct`.`weight`, `NeoShopProduct`.`minimum_order`, `NeoShopProduct`.`box_amount`, `NeoShopProduct`.`size`, `NeoShopProduct`.`title`, `NeoShopProduct`.`meta_keywords`, `NeoShopProduct`.`meta_description`, `NeoShopProduct`.`material`, `NeoShopProduct`.`certication`, `NeoShopProduct`.`property_1`, `NeoShopProduct`.`property_2`, `NeoShopProduct`.`rating`, `NeoShopProduct`.`rated_times`, `NeoShopProduct`.`top`, `NeoShopProduct`.`dostupnost` FROM `d4yscq02`.`neo_shop_products` AS `NeoShopProduct` WHERE `NeoShopProduct`.`neo_shop_category_id` = (275) | 2 | 2 | 7 | maybe slow |
| SELECT `NeoUploadFile`.`id`, `NeoUploadFile`.`filename`, `NeoUploadFile`.`plugin`, `NeoUploadFile`.`model`, `NeoUploadFile`.`foreign_key`, `NeoUploadFile`.`description`, `NeoUploadFile`.`order` FROM `d4yscq02`.`neo_upload_files` AS `NeoUploadFile` WHERE `NeoUploadFile`.`model` = 'NeoShopCategory' AND `NeoUploadFile`.`foreign_key` = (275) ORDER BY `NeoUploadFile`.`order` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` WHERE 1 = 1 AND `NeoShopCategory`.`id` = 275 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`content`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `NeoShopCategory`.`neo_shop_filter_group_id` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` WHERE 1 = 1 AND `NeoShopCategory`.`rght` < 444 AND `NeoShopCategory`.`lft` > 443 ORDER BY `NeoShopCategory`.`lft` asc | 0 | 0 | 1 | maybe slow |
| SELECT `NeoShopProduct`.`id`, `NeoShopProduct`.`neo_shop_category_id`, `NeoShopProduct`.`neo_shop_manufacturer_id`, `NeoShopProduct`.`name`, `NeoShopProduct`.`short_description`, `NeoShopProduct`.`long_description`, `NeoShopProduct`.`unit`, `NeoShopProduct`.`price`, `NeoShopProduct`.`wholesale_price`, `NeoShopProduct`.`reduction_amount`, `NeoShopProduct`.`reduction_percent`, `NeoShopProduct`.`code`, `NeoShopProduct`.`ean13`, `NeoShopProduct`.`stock`, `NeoShopProduct`.`stock_amount`, `NeoShopProduct`.`image`, `NeoShopProduct`.`neo_shop_tax_id`, `NeoShopProduct`.`active`, `NeoShopProduct`.`only_wholesale`, `NeoShopProduct`.`modified`, `NeoShopProduct`.`modified_by`, `NeoShopProduct`.`created`, `NeoShopProduct`.`created_by`, `NeoShopProduct`.`weight`, `NeoShopProduct`.`minimum_order`, `NeoShopProduct`.`box_amount`, `NeoShopProduct`.`size`, `NeoShopProduct`.`title`, `NeoShopProduct`.`meta_keywords`, `NeoShopProduct`.`meta_description`, `NeoShopProduct`.`material`, `NeoShopProduct`.`certication`, `NeoShopProduct`.`property_1`, `NeoShopProduct`.`property_2`, `NeoShopProduct`.`rating`, `NeoShopProduct`.`rated_times`, `NeoShopProduct`.`top`, `NeoShopProduct`.`dostupnost`, `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`content`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `NeoShopCategory`.`neo_shop_filter_group_id`, `NeoShopManufacturer`.`id`, `NeoShopManufacturer`.`name`, `NeoShopManufacturer`.`content`, `NeoShopManufacturer`.`image`, `NeoShopManufacturer`.`modified`, `NeoShopManufacturer`.`modified_by`, `NeoShopManufacturer`.`created`, `NeoShopManufacturer`.`created_by`, `NeoShopTax`.`id`, `NeoShopTax`.`name`, `NeoShopTax`.`value`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`user_group_id`, `CreatedBy`.`active`, `CreatedBy`.`blocked`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`active`, `ModifiedBy`.`blocked`, `ModifiedBy`.`created`, `ModifiedBy`.`modified` FROM `d4yscq02`.`neo_shop_products` AS `NeoShopProduct` LEFT JOIN `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` ON (`NeoShopProduct`.`neo_shop_category_id` = `NeoShopCategory`.`id`) LEFT JOIN `d4yscq02`.`neo_shop_manufacturers` AS `NeoShopManufacturer` ON (`NeoShopProduct`.`neo_shop_manufacturer_id` = `NeoShopManufacturer`.`id`) LEFT JOIN `d4yscq02`.`neo_shop_taxes` AS `NeoShopTax` ON (`NeoShopProduct`.`neo_shop_tax_id` = `NeoShopTax`.`id`) LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoShopProduct`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoShopProduct`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoShopProduct`.`active` = '1' AND `NeoShopProduct`.`neo_shop_category_id` = (275) AND `NeoShopProduct`.`only_wholesale` = '0' ORDER BY `NeoShopProduct`.`name` asc LIMIT 12 | 2 | 2 | 3 | maybe slow |
| SELECT `NeoShopProductVariant`.`id`, `NeoShopProductVariant`.`neo_shop_product_id`, `NeoShopProductVariant`.`name`, `NeoShopProductVariant`.`description`, `NeoShopProductVariant`.`price`, `NeoShopProductVariant`.`reduction_amount`, `NeoShopProductVariant`.`reduction_percent`, `NeoShopProductVariant`.`code`, `NeoShopProductVariant`.`ean13`, `NeoShopProductVariant`.`stock`, `NeoShopProductVariant`.`image`, `NeoShopProductVariant`.`active`, `NeoShopProductVariant`.`modified`, `NeoShopProductVariant`.`modified_by`, `NeoShopProductVariant`.`created`, `NeoShopProductVariant`.`created_by`, `NeoShopProductVariant`.`nazov2`, `NeoShopProductVariant`.`plu`, `NeoShopProductVariant`.`stav`, `NeoShopProductVariant`.`mj`, `NeoShopProductVariant`.`mj2`, `NeoShopProductVariant`.`koefmj2`, `NeoShopProductVariant`.`hmotnost`, `NeoShopProductVariant`.`sortiment`, `NeoShopProductVariant`.`priznaks01`, `NeoShopProductVariant`.`priznaks02`, `NeoShopProductVariant`.`priznaks03`, `NeoShopProductVariant`.`dlzka` FROM `d4yscq02`.`neo_shop_product_variants` AS `NeoShopProductVariant` WHERE `NeoShopProductVariant`.`neo_shop_product_id` IN (44, 45) | 0 | 0 | 1 | maybe slow |
| SELECT `NeoShopProductProperty`.`id`, `NeoShopProductProperty`.`neo_shop_product_id`, `NeoShopProductProperty`.`name`, `NeoShopProductProperty`.`type` FROM `d4yscq02`.`neo_shop_product_properties` AS `NeoShopProductProperty` WHERE `NeoShopProductProperty`.`neo_shop_product_id` IN (44, 45) | 2 | 2 | 2 | |
| SELECT `NeoShopPropertiesInfo`.`id`, `NeoShopPropertiesInfo`.`neo_shop_product_property_values`, `NeoShopPropertiesInfo`.`stock_amount`, `NeoShopPropertiesInfo`.`image`, `NeoShopPropertiesInfo`.`neo_shop_product_id`, `NeoShopPropertiesInfo`.`price`, `NeoShopPropertiesInfo`.`wholesale_price` FROM `d4yscq02`.`neo_shop_properties_infos` AS `NeoShopPropertiesInfo` WHERE `NeoShopPropertiesInfo`.`neo_shop_product_id` IN (44, 45) | 2 | 2 | 7 | maybe slow |
| SELECT `NeoUploadFile`.`id`, `NeoUploadFile`.`filename`, `NeoUploadFile`.`plugin`, `NeoUploadFile`.`model`, `NeoUploadFile`.`foreign_key`, `NeoUploadFile`.`description`, `NeoUploadFile`.`order` FROM `d4yscq02`.`neo_upload_files` AS `NeoUploadFile` WHERE `NeoUploadFile`.`model` = 'NeoShopProduct' AND `NeoUploadFile`.`foreign_key` IN (44, 45) ORDER BY `NeoUploadFile`.`order` ASC | 2 | 2 | 2 | |
| SELECT `NeoShopProductProperty`.`id`, `NeoShopProductProperty`.`neo_shop_product_id`, `NeoShopProductProperty`.`name`, `NeoShopProductProperty`.`type`, `NeoShopProduct`.`id`, `NeoShopProduct`.`neo_shop_category_id`, `NeoShopProduct`.`neo_shop_manufacturer_id`, `NeoShopProduct`.`name`, `NeoShopProduct`.`short_description`, `NeoShopProduct`.`long_description`, `NeoShopProduct`.`unit`, `NeoShopProduct`.`price`, `NeoShopProduct`.`wholesale_price`, `NeoShopProduct`.`reduction_amount`, `NeoShopProduct`.`reduction_percent`, `NeoShopProduct`.`code`, `NeoShopProduct`.`ean13`, `NeoShopProduct`.`stock`, `NeoShopProduct`.`stock_amount`, `NeoShopProduct`.`image`, `NeoShopProduct`.`neo_shop_tax_id`, `NeoShopProduct`.`active`, `NeoShopProduct`.`only_wholesale`, `NeoShopProduct`.`modified`, `NeoShopProduct`.`modified_by`, `NeoShopProduct`.`created`, `NeoShopProduct`.`created_by`, `NeoShopProduct`.`weight`, `NeoShopProduct`.`minimum_order`, `NeoShopProduct`.`box_amount`, `NeoShopProduct`.`size`, `NeoShopProduct`.`title`, `NeoShopProduct`.`meta_keywords`, `NeoShopProduct`.`meta_description`, `NeoShopProduct`.`material`, `NeoShopProduct`.`certication`, `NeoShopProduct`.`property_1`, `NeoShopProduct`.`property_2`, `NeoShopProduct`.`rating`, `NeoShopProduct`.`rated_times`, `NeoShopProduct`.`top`, `NeoShopProduct`.`dostupnost` FROM `d4yscq02`.`neo_shop_product_properties` AS `NeoShopProductProperty` LEFT JOIN `d4yscq02`.`neo_shop_products` AS `NeoShopProduct` ON (`NeoShopProductProperty`.`neo_shop_product_id` = `NeoShopProduct`.`id`) WHERE `NeoShopProductProperty`.`id` = 37 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `NeoShopProductPropertyValue`.`id`, `NeoShopProductPropertyValue`.`value`, `NeoShopProductPropertyValue`.`price_delta`, `NeoShopProductPropertyValue`.`neo_shop_product_property_id` FROM `d4yscq02`.`neo_shop_product_property_values` AS `NeoShopProductPropertyValue` WHERE `NeoShopProductPropertyValue`.`neo_shop_product_property_id` = (37) | 1 | 1 | 4 | maybe slow |
| SELECT `NeoShopProductProperty`.`id`, `NeoShopProductProperty`.`neo_shop_product_id`, `NeoShopProductProperty`.`name`, `NeoShopProductProperty`.`type`, `NeoShopProduct`.`id`, `NeoShopProduct`.`neo_shop_category_id`, `NeoShopProduct`.`neo_shop_manufacturer_id`, `NeoShopProduct`.`name`, `NeoShopProduct`.`short_description`, `NeoShopProduct`.`long_description`, `NeoShopProduct`.`unit`, `NeoShopProduct`.`price`, `NeoShopProduct`.`wholesale_price`, `NeoShopProduct`.`reduction_amount`, `NeoShopProduct`.`reduction_percent`, `NeoShopProduct`.`code`, `NeoShopProduct`.`ean13`, `NeoShopProduct`.`stock`, `NeoShopProduct`.`stock_amount`, `NeoShopProduct`.`image`, `NeoShopProduct`.`neo_shop_tax_id`, `NeoShopProduct`.`active`, `NeoShopProduct`.`only_wholesale`, `NeoShopProduct`.`modified`, `NeoShopProduct`.`modified_by`, `NeoShopProduct`.`created`, `NeoShopProduct`.`created_by`, `NeoShopProduct`.`weight`, `NeoShopProduct`.`minimum_order`, `NeoShopProduct`.`box_amount`, `NeoShopProduct`.`size`, `NeoShopProduct`.`title`, `NeoShopProduct`.`meta_keywords`, `NeoShopProduct`.`meta_description`, `NeoShopProduct`.`material`, `NeoShopProduct`.`certication`, `NeoShopProduct`.`property_1`, `NeoShopProduct`.`property_2`, `NeoShopProduct`.`rating`, `NeoShopProduct`.`rated_times`, `NeoShopProduct`.`top`, `NeoShopProduct`.`dostupnost` FROM `d4yscq02`.`neo_shop_product_properties` AS `NeoShopProductProperty` LEFT JOIN `d4yscq02`.`neo_shop_products` AS `NeoShopProduct` ON (`NeoShopProductProperty`.`neo_shop_product_id` = `NeoShopProduct`.`id`) WHERE `NeoShopProductProperty`.`id` = 38 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `NeoShopProductPropertyValue`.`id`, `NeoShopProductPropertyValue`.`value`, `NeoShopProductPropertyValue`.`price_delta`, `NeoShopProductPropertyValue`.`neo_shop_product_property_id` FROM `d4yscq02`.`neo_shop_product_property_values` AS `NeoShopProductPropertyValue` WHERE `NeoShopProductPropertyValue`.`neo_shop_product_property_id` = (38) | 1 | 1 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `d4yscq02`.`neo_shop_products` AS `NeoShopProduct` LEFT JOIN `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` ON (`NeoShopProduct`.`neo_shop_category_id` = `NeoShopCategory`.`id`) LEFT JOIN `d4yscq02`.`neo_shop_manufacturers` AS `NeoShopManufacturer` ON (`NeoShopProduct`.`neo_shop_manufacturer_id` = `NeoShopManufacturer`.`id`) LEFT JOIN `d4yscq02`.`neo_shop_taxes` AS `NeoShopTax` ON (`NeoShopProduct`.`neo_shop_tax_id` = `NeoShopTax`.`id`) LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoShopProduct`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoShopProduct`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoShopProduct`.`active` = '1' AND `NeoShopProduct`.`neo_shop_category_id` = (275) AND `NeoShopProduct`.`only_wholesale` = '0' | 1 | 1 | 2 | maybe slow |
| SELECT `NeoBlogArticle`.`id`, `NeoBlogArticle`.`neo_blog_category_id`, `NeoBlogArticle`.`slug`, `NeoBlogArticle`.`title`, `NeoBlogArticle`.`thumbnail_path`, `NeoBlogArticle`.`perex`, `NeoBlogArticle`.`type`, `NeoBlogArticle`.`content`, `NeoBlogArticle`.`date`, `NeoBlogArticle`.`author`, `NeoBlogArticle`.`visits`, `NeoBlogArticle`.`created_by`, `NeoBlogArticle`.`created`, `NeoBlogArticle`.`modified_by`, `NeoBlogArticle`.`modified`, (`I18n__title`.`content`) AS `NeoBlogArticle__i18n_title`, (`I18n__slug`.`content`) AS `NeoBlogArticle__i18n_slug`, (`I18n__content`.`content`) AS `NeoBlogArticle__i18n_content`, (`I18n__type`.`content`) AS `NeoBlogArticle__i18n_type`, (`I18n__perex`.`content`) AS `NeoBlogArticle__i18n_perex`, `NeoBlogCategory`.`id`, `NeoBlogCategory`.`parent_id`, `NeoBlogCategory`.`name`, `NeoBlogCategory`.`neo_blog_article_count`, `NeoBlogCategory`.`created`, `NeoBlogCategory`.`modified`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`user_group_id`, `CreatedBy`.`active`, `CreatedBy`.`blocked`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`active`, `ModifiedBy`.`blocked`, `ModifiedBy`.`created`, `ModifiedBy`.`modified` FROM `d4yscq02`.`neo_blog_articles` AS `NeoBlogArticle` INNER JOIN `d4yscq02`.`i18n` AS `I18n__title` ON (`NeoBlogArticle`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'NeoBlogArticle' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `d4yscq02`.`i18n` AS `I18n__slug` ON (`NeoBlogArticle`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'NeoBlogArticle' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'slk') INNER JOIN `d4yscq02`.`i18n` AS `I18n__content` ON (`NeoBlogArticle`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'NeoBlogArticle' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') INNER JOIN `d4yscq02`.`i18n` AS `I18n__type` ON (`NeoBlogArticle`.`id` = `I18n__type`.`foreign_key` AND `I18n__type`.`model` = 'NeoBlogArticle' AND `I18n__type`.`field` = 'type' AND `I18n__type`.`locale` = 'slk') INNER JOIN `d4yscq02`.`i18n` AS `I18n__perex` ON (`NeoBlogArticle`.`id` = `I18n__perex`.`foreign_key` AND `I18n__perex`.`model` = 'NeoBlogArticle' AND `I18n__perex`.`field` = 'perex' AND `I18n__perex`.`locale` = 'slk') LEFT JOIN `d4yscq02`.`neo_blog_categories` AS `NeoBlogCategory` ON (`NeoBlogArticle`.`neo_blog_category_id` = `NeoBlogCategory`.`id`) LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoBlogArticle`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoBlogArticle`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 ORDER BY `NeoBlogArticle`.`date` desc, `NeoBlogArticle`.`id` desc LIMIT 3 | 0 | 0 | 5 | maybe slow |
| SELECT `NeoCmsContentBlock`.`id`, `NeoCmsContentBlock`.`name`, `NeoCmsContentBlock`.`slug`, `NeoCmsContentBlock`.`content`, `NeoCmsContentBlock`.`created`, `NeoCmsContentBlock`.`created_by`, `NeoCmsContentBlock`.`modified`, `NeoCmsContentBlock`.`modified_by`, `NeoCmsContentBlock`.`content_type`, (`I18n__content`.`content`) AS `NeoCmsContentBlock__i18n_content`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`user_group_id`, `CreatedBy`.`active`, `CreatedBy`.`blocked`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`active`, `ModifiedBy`.`blocked`, `ModifiedBy`.`created`, `ModifiedBy`.`modified` FROM `d4yscq02`.`neo_cms_content_blocks` AS `NeoCmsContentBlock` INNER JOIN `d4yscq02`.`i18n` AS `I18n__content` ON (`NeoCmsContentBlock`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'NeoCmsContentBlock' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'slk') LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoCmsContentBlock`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoCmsContentBlock`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 | 5 | 5 | 1 | maybe slow |
| SELECT `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`content`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `NeoShopCategory`.`neo_shop_filter_group_id`, `ParentNeoShopCategory`.`id`, `ParentNeoShopCategory`.`name`, `ParentNeoShopCategory`.`title`, `ParentNeoShopCategory`.`meta_description`, `ParentNeoShopCategory`.`meta_keywords`, `ParentNeoShopCategory`.`content`, `ParentNeoShopCategory`.`parent_id`, `ParentNeoShopCategory`.`lft`, `ParentNeoShopCategory`.`rght`, `ParentNeoShopCategory`.`level`, `ParentNeoShopCategory`.`visible`, `ParentNeoShopCategory`.`image`, `ParentNeoShopCategory`.`modified`, `ParentNeoShopCategory`.`modified_by`, `ParentNeoShopCategory`.`created`, `ParentNeoShopCategory`.`created_by`, `ParentNeoShopCategory`.`neo_shop_filter_group_id`, `NeoShopFilterGroup`.`id`, `NeoShopFilterGroup`.`name`, `NeoShopFilterGroup`.`created_by`, `NeoShopFilterGroup`.`modified_by`, `NeoShopFilterGroup`.`created`, `NeoShopFilterGroup`.`modified`, `CreatedBy`.`id`, `CreatedBy`.`username`, `CreatedBy`.`password`, `CreatedBy`.`user_group_id`, `CreatedBy`.`active`, `CreatedBy`.`blocked`, `CreatedBy`.`created`, `CreatedBy`.`modified`, `ModifiedBy`.`id`, `ModifiedBy`.`username`, `ModifiedBy`.`password`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`active`, `ModifiedBy`.`blocked`, `ModifiedBy`.`created`, `ModifiedBy`.`modified` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` LEFT JOIN `d4yscq02`.`neo_shop_categories` AS `ParentNeoShopCategory` ON (`NeoShopCategory`.`parent_id` = `ParentNeoShopCategory`.`id`) LEFT JOIN `d4yscq02`.`neo_shop_filter_groups` AS `NeoShopFilterGroup` ON (`NeoShopCategory`.`neo_shop_filter_group_id` = `NeoShopFilterGroup`.`id`) LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoShopCategory`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoShopCategory`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 | 263 | 263 | 3 | |
| SELECT `NeoCmsPage`.`id`, `NeoCmsPage`.`parent_id`, `NeoCmsPage`.`lft`, `NeoCmsPage`.`rght`, `NeoCmsPage`.`level`, `NeoCmsPage`.`order`, `NeoCmsPage`.`name`, `NeoCmsPage`.`title`, `NeoCmsPage`.`meta_description`, `NeoCmsPage`.`meta_keywords`, `NeoCmsPage`.`visible`, `NeoCmsPage`.`cache_content`, `NeoCmsPage`.`created`, `NeoCmsPage`.`created_by`, `NeoCmsPage`.`modified`, `NeoCmsPage`.`modified_by`, (`I18n__name`.`content`) AS `NeoCmsPage__i18n_name`, (`I18n__title`.`content`) AS `NeoCmsPage__i18n_title`, (`I18n__cache_content`.`content`) AS `NeoCmsPage__i18n_cache_content` FROM `d4yscq02`.`neo_cms_pages` AS `NeoCmsPage` INNER JOIN `d4yscq02`.`i18n` AS `I18n__name` ON (`NeoCmsPage`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'NeoCmsPage' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'slk') INNER JOIN `d4yscq02`.`i18n` AS `I18n__title` ON (`NeoCmsPage`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'NeoCmsPage' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'slk') INNER JOIN `d4yscq02`.`i18n` AS `I18n__cache_content` ON (`NeoCmsPage`.`id` = `I18n__cache_content`.`foreign_key` AND `I18n__cache_content`.`model` = 'NeoCmsPage' AND `I18n__cache_content`.`field` = 'cache_content' AND `I18n__cache_content`.`locale` = 'slk') WHERE `NeoCmsPage`.`parent_id` IS NULL AND `visible` = '1' ORDER BY `NeoCmsPage`.`lft` ASC | 10 | 10 | 3 | maybe slow |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 5 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 9 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 10 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 11 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 12 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 13 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 15 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 16 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 17 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `d4yscq02`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 18 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
