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 `NeoSlideshowSlide`.`id`, `NeoSlideshowSlide`.`neo_slideshow_slideshow_id`, `NeoSlideshowSlide`.`url`, `NeoSlideshowSlide`.`content`, `NeoSlideshowSlide`.`order`, `NeoSlideshowSlide`.`active`, `NeoSlideshowSlide`.`created`, `NeoSlideshowSlide`.`created_by`, `NeoSlideshowSlide`.`modified`, `NeoSlideshowSlide`.`modified_by`, `NeoSlideshowSlideshow`.`id`, `NeoSlideshowSlideshow`.`name`, `NeoSlideshowSlideshow`.`width`, `NeoSlideshowSlideshow`.`height`, `NeoSlideshowSlideshow`.`created`, `NeoSlideshowSlideshow`.`created_by`, `NeoSlideshowSlideshow`.`modified`, `NeoSlideshowSlideshow`.`modified_by`, `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_slideshow_slides` AS `NeoSlideshowSlide` LEFT JOIN `d4yscq02`.`neo_slideshow_slideshows` AS `NeoSlideshowSlideshow` ON (`NeoSlideshowSlide`.`neo_slideshow_slideshow_id` = `NeoSlideshowSlideshow`.`id`) LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoSlideshowSlide`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoSlideshowSlide`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoSlideshowSlideshow`.`name` = 'home' | 8 | 8 | 1 | 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` = 'NeoSlideshowSlide' AND `NeoUploadFile`.`foreign_key` IN (19, 18, 15, 20, 8, 16, 17, 21) ORDER BY `NeoUploadFile`.`order` ASC | 8 | 8 | 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` FROM `d4yscq02`.`neo_shop_categories` AS `NeoShopCategory` WHERE `NeoShopCategory`.`parent_id` = 0 ORDER BY `NeoShopCategory`.`name` ASC | 1 | 1 | 0 | |
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` = (262) ORDER BY `NeoUploadFile`.`order` ASC | 0 | 0 | 0 | |
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`, `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_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') LEFT JOIN `d4yscq02`.`users` AS `CreatedBy` ON (`NeoCmsPage`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `d4yscq02`.`users` AS `ModifiedBy` ON (`NeoCmsPage`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoCmsPage`.`id` = 5 LIMIT 1 | 1 | 1 | 1 | |
SELECT `NeoCmsPageModuleItem`.`id`, `NeoCmsPageModuleItem`.`neo_cms_page_id`, `NeoCmsPageModuleItem`.`order`, `NeoCmsPageModuleItem`.`neo_cms_component_id`, `NeoCmsPageModuleItem`.`neo_cms_component_item_id` FROM `d4yscq02`.`neo_cms_page_module_items` AS `NeoCmsPageModuleItem` WHERE `NeoCmsPageModuleItem`.`neo_cms_page_id` = (5) ORDER BY `NeoCmsPageModuleItem`.`order` ASC | 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` = 5 AND `lang` = 'slk' LIMIT 1 | 1 | 1 | 0 | |
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`.`only_wholesale` = '0' ORDER BY `NeoShopProduct`.`id` DESC LIMIT 8 | 8 | 8 | 1 | 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 (984, 983, 982, 981, 980, 979, 978, 977) | 0 | 0 | 0 | |
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 (984, 983, 982, 981, 980, 979, 978, 977) | 16 | 16 | 1 | maybe slow |
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 (984, 983, 982, 981, 980, 979, 978, 977) | 103 | 103 | 3 | |
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 (984, 983, 982, 981, 980, 979, 978, 977) ORDER BY `NeoUploadFile`.`order` ASC | 20 | 20 | 1 | 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` = 1847 LIMIT 1 | 1 | 1 | 0 | |
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` = (1847) | 3 | 3 | 1 | 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` = 1848 LIMIT 1 | 1 | 1 | 0 | |
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` = (1848) | 5 | 5 | 1 | 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` = 1845 LIMIT 1 | 1 | 1 | 0 | |
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` = (1845) | 3 | 3 | 1 | 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` = 1846 LIMIT 1 | 1 | 1 | 0 | |
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` = (1846) | 4 | 4 | 1 | 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` = 1843 LIMIT 1 | 1 | 1 | 0 | |
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` = (1843) | 3 | 3 | 1 | 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` = 1844 LIMIT 1 | 1 | 1 | 0 | |
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` = (1844) | 4 | 4 | 1 | 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` = 1841 LIMIT 1 | 1 | 1 | 0 | |
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` = (1841) | 1 | 1 | 1 | |
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` = 1842 LIMIT 1 | 1 | 1 | 0 | |
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` = (1842) | 5 | 5 | 1 | 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` = 1839 LIMIT 1 | 1 | 1 | 0 | |
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` = (1839) | 3 | 3 | 1 | 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` = 1840 LIMIT 1 | 1 | 1 | 0 | |
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` = (1840) | 5 | 5 | 1 | 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` = 1837 LIMIT 1 | 1 | 1 | 0 | |
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` = (1837) | 3 | 3 | 1 | 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` = 1838 LIMIT 1 | 1 | 1 | 0 | |
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` = (1838) | 5 | 5 | 1 | 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` = 1835 LIMIT 1 | 1 | 1 | 0 | |
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` = (1835) | 2 | 2 | 1 | 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` = 1836 LIMIT 1 | 1 | 1 | 0 | |
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` = (1836) | 4 | 4 | 1 | 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` = 1833 LIMIT 1 | 1 | 1 | 0 | |
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` = (1833) | 2 | 2 | 1 | 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` = 1834 LIMIT 1 | 1 | 1 | 0 | |
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` = (1834) | 4 | 4 | 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`.`top` = '1' AND `NeoShopProduct`.`only_wholesale` = '0' ORDER BY `NeoShopProduct`.`id` DESC LIMIT 8 | 1 | 1 | 15 | 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` = (19) | 0 | 0 | 0 | |
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` = (19) | 1 | 1 | 0 | |
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` = (19) | 2 | 2 | 2 | |
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` = (19) ORDER BY `NeoUploadFile`.`order` ASC | 2 | 2 | 0 | |
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` = 18 LIMIT 1 | 1 | 1 | 0 | |
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` = (18) | 2 | 2 | 1 | maybe slow |
SELECT Count(`NeoShopOrderDetail`.`id`) as count, `NeoShopOrderDetail`.`neo_shop_product_id` FROM `d4yscq02`.`neo_shop_order_details` AS `NeoShopOrderDetail` WHERE 1 = 1 GROUP BY `NeoShopOrderDetail`.`neo_shop_product_id` ORDER BY `count` desc | 1 | 1 | 1 | |
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`.`id` = 858 AND `NeoShopProduct`.`only_wholesale` = '0' LIMIT 1 | 1 | 1 | 0 | |
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` = (858) | 0 | 0 | 0 | |
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` = (858) | 2 | 2 | 0 | |
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` = (858) | 4 | 4 | 2 | 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` = (858) ORDER BY `NeoUploadFile`.`order` ASC | 1 | 1 | 0 | |
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` = 1567 LIMIT 1 | 1 | 1 | 0 | |
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` = (1567) | 1 | 1 | 1 | |
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` = 1568 LIMIT 1 | 1 | 1 | 0 | |
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` = (1568) | 4 | 4 | 1 | 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 6 | 0 | 0 | 3 | 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 | 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` = 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 | |