Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`configure_label`, `Setting`.`value` FROM `cast_iron_whole`.`settings` AS `Setting` WHERE 1 = 1 | 5 | 5 | 0 | |
SELECT `NeoShopProduct`.`id`, `NeoShopProduct`.`neo_shop_category_id`, `NeoShopProduct`.`neo_shop_manufacturer_id`, `NeoShopProduct`.`new`, `NeoShopProduct`.`private`, `NeoShopProduct`.`name`, `NeoShopProduct`.`short_description`, `NeoShopProduct`.`long_description`, `NeoShopProduct`.`unit`, `NeoShopProduct`.`price`, `NeoShopProduct`.`base_cost`, `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`.`modified`, `NeoShopProduct`.`modified_by`, `NeoShopProduct`.`created`, `NeoShopProduct`.`created_by`, `NeoShopProduct`.`weight`, `NeoShopProduct`.`minimum_order`, `NeoShopProduct`.`box_amount`, `NeoShopProduct`.`size`, `NeoShopProduct`.`title`, `NeoShopProduct`.`h1`, `NeoShopProduct`.`meta_keywords`, `NeoShopProduct`.`meta_description`, `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`meta_title`, `NeoShopCategory`.`meta_h1`, `NeoShopCategory`.`content`, `NeoShopCategory`.`content_bottom`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`new`, `NeoShopCategory`.`type`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `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 `cast_iron_whole`.`neo_shop_products` AS `NeoShopProduct` LEFT JOIN `cast_iron_whole`.`neo_shop_categories` AS `NeoShopCategory` ON (`NeoShopProduct`.`neo_shop_category_id` = `NeoShopCategory`.`id`) LEFT JOIN `cast_iron_whole`.`neo_shop_manufacturers` AS `NeoShopManufacturer` ON (`NeoShopProduct`.`neo_shop_manufacturer_id` = `NeoShopManufacturer`.`id`) LEFT JOIN `cast_iron_whole`.`neo_shop_taxes` AS `NeoShopTax` ON (`NeoShopProduct`.`neo_shop_tax_id` = `NeoShopTax`.`id`) LEFT JOIN `cast_iron_whole`.`users` AS `CreatedBy` ON (`NeoShopProduct`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `cast_iron_whole`.`users` AS `ModifiedBy` ON (`NeoShopProduct`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoShopProduct`.`active` = '1' AND `NeoShopProduct`.`private` = '0' ORDER BY `NeoShopProduct`.`name` asc LIMIT 228, 12 | 12 | 12 | 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 `cast_iron_whole`.`neo_shop_product_variants` AS `NeoShopProductVariant` WHERE `NeoShopProductVariant`.`neo_shop_product_id` IN (51, 710, 52, 732, 412, 638, 473, 480, 468, 140, 707, 621) | 0 | 0 | 0 | |
SELECT `NeoUploadFile`.`id`, `NeoUploadFile`.`filename`, `NeoUploadFile`.`plugin`, `NeoUploadFile`.`model`, `NeoUploadFile`.`foreign_key`, `NeoUploadFile`.`description`, `NeoUploadFile`.`order` FROM `cast_iron_whole`.`neo_upload_files` AS `NeoUploadFile` WHERE `NeoUploadFile`.`model` = 'NeoShopProduct' AND `NeoUploadFile`.`foreign_key` IN (51, 710, 52, 732, 412, 638, 473, 480, 468, 140, 707, 621) ORDER BY `NeoUploadFile`.`order` ASC | 21 | 21 | 1 | |
SELECT `SimilarProducts1`.`id`, `SimilarProducts1`.`neo_shop_category_id`, `SimilarProducts1`.`neo_shop_manufacturer_id`, `SimilarProducts1`.`new`, `SimilarProducts1`.`private`, `SimilarProducts1`.`name`, `SimilarProducts1`.`short_description`, `SimilarProducts1`.`long_description`, `SimilarProducts1`.`unit`, `SimilarProducts1`.`price`, `SimilarProducts1`.`base_cost`, `SimilarProducts1`.`reduction_amount`, `SimilarProducts1`.`reduction_percent`, `SimilarProducts1`.`code`, `SimilarProducts1`.`ean13`, `SimilarProducts1`.`stock`, `SimilarProducts1`.`stock_amount`, `SimilarProducts1`.`image`, `SimilarProducts1`.`neo_shop_tax_id`, `SimilarProducts1`.`active`, `SimilarProducts1`.`modified`, `SimilarProducts1`.`modified_by`, `SimilarProducts1`.`created`, `SimilarProducts1`.`created_by`, `SimilarProducts1`.`weight`, `SimilarProducts1`.`minimum_order`, `SimilarProducts1`.`box_amount`, `SimilarProducts1`.`size`, `SimilarProducts1`.`title`, `SimilarProducts1`.`h1`, `SimilarProducts1`.`meta_keywords`, `SimilarProducts1`.`meta_description`, `NeoShopSimilarProduct`.`neo_shop_product_id1`, `NeoShopSimilarProduct`.`neo_shop_product_id2` FROM `cast_iron_whole`.`neo_shop_products` AS `SimilarProducts1` JOIN `cast_iron_whole`.`neo_shop_similar_products` AS `NeoShopSimilarProduct` ON (`NeoShopSimilarProduct`.`neo_shop_product_id1` IN (51, 710, 52, 732, 412, 638, 473, 480, 468, 140, 707, 621) AND `NeoShopSimilarProduct`.`neo_shop_product_id2` = `SimilarProducts1`.`id`) | 0 | 0 | 0 | |
SELECT `SimilarProducts2`.`id`, `SimilarProducts2`.`neo_shop_category_id`, `SimilarProducts2`.`neo_shop_manufacturer_id`, `SimilarProducts2`.`new`, `SimilarProducts2`.`private`, `SimilarProducts2`.`name`, `SimilarProducts2`.`short_description`, `SimilarProducts2`.`long_description`, `SimilarProducts2`.`unit`, `SimilarProducts2`.`price`, `SimilarProducts2`.`base_cost`, `SimilarProducts2`.`reduction_amount`, `SimilarProducts2`.`reduction_percent`, `SimilarProducts2`.`code`, `SimilarProducts2`.`ean13`, `SimilarProducts2`.`stock`, `SimilarProducts2`.`stock_amount`, `SimilarProducts2`.`image`, `SimilarProducts2`.`neo_shop_tax_id`, `SimilarProducts2`.`active`, `SimilarProducts2`.`modified`, `SimilarProducts2`.`modified_by`, `SimilarProducts2`.`created`, `SimilarProducts2`.`created_by`, `SimilarProducts2`.`weight`, `SimilarProducts2`.`minimum_order`, `SimilarProducts2`.`box_amount`, `SimilarProducts2`.`size`, `SimilarProducts2`.`title`, `SimilarProducts2`.`h1`, `SimilarProducts2`.`meta_keywords`, `SimilarProducts2`.`meta_description`, `NeoShopSimilarProduct`.`neo_shop_product_id1`, `NeoShopSimilarProduct`.`neo_shop_product_id2` FROM `cast_iron_whole`.`neo_shop_products` AS `SimilarProducts2` JOIN `cast_iron_whole`.`neo_shop_similar_products` AS `NeoShopSimilarProduct` ON (`NeoShopSimilarProduct`.`neo_shop_product_id2` IN (51, 710, 52, 732, 412, 638, 473, 480, 468, 140, 707, 621) AND `NeoShopSimilarProduct`.`neo_shop_product_id1` = `SimilarProducts2`.`id`) | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `cast_iron_whole`.`neo_shop_products` AS `NeoShopProduct` LEFT JOIN `cast_iron_whole`.`neo_shop_categories` AS `NeoShopCategory` ON (`NeoShopProduct`.`neo_shop_category_id` = `NeoShopCategory`.`id`) LEFT JOIN `cast_iron_whole`.`neo_shop_manufacturers` AS `NeoShopManufacturer` ON (`NeoShopProduct`.`neo_shop_manufacturer_id` = `NeoShopManufacturer`.`id`) LEFT JOIN `cast_iron_whole`.`neo_shop_taxes` AS `NeoShopTax` ON (`NeoShopProduct`.`neo_shop_tax_id` = `NeoShopTax`.`id`) LEFT JOIN `cast_iron_whole`.`users` AS `CreatedBy` ON (`NeoShopProduct`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `cast_iron_whole`.`users` AS `ModifiedBy` ON (`NeoShopProduct`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoShopProduct`.`active` = '1' AND `NeoShopProduct`.`private` = '0' | 1 | 1 | 1 | |
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 `cast_iron_whole`.`neo_cms_content_blocks` AS `NeoCmsContentBlock` LEFT JOIN `cast_iron_whole`.`users` AS `CreatedBy` ON (`NeoCmsContentBlock`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `cast_iron_whole`.`users` AS `ModifiedBy` ON (`NeoCmsContentBlock`.`modified_by` = `ModifiedBy`.`id`) INNER JOIN `cast_iron_whole`.`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` = 'eng') WHERE 1 = 1 | 14 | 14 | 1 | maybe slow |
SELECT `NeoShopCategory`.`id`, `NeoShopCategory`.`name`, `NeoShopCategory`.`title`, `NeoShopCategory`.`meta_description`, `NeoShopCategory`.`meta_keywords`, `NeoShopCategory`.`meta_title`, `NeoShopCategory`.`meta_h1`, `NeoShopCategory`.`content`, `NeoShopCategory`.`content_bottom`, `NeoShopCategory`.`parent_id`, `NeoShopCategory`.`lft`, `NeoShopCategory`.`rght`, `NeoShopCategory`.`level`, `NeoShopCategory`.`visible`, `NeoShopCategory`.`new`, `NeoShopCategory`.`type`, `NeoShopCategory`.`image`, `NeoShopCategory`.`modified`, `NeoShopCategory`.`modified_by`, `NeoShopCategory`.`created`, `NeoShopCategory`.`created_by`, `ParentNeoShopCategory`.`id`, `ParentNeoShopCategory`.`name`, `ParentNeoShopCategory`.`title`, `ParentNeoShopCategory`.`meta_description`, `ParentNeoShopCategory`.`meta_keywords`, `ParentNeoShopCategory`.`meta_title`, `ParentNeoShopCategory`.`meta_h1`, `ParentNeoShopCategory`.`content`, `ParentNeoShopCategory`.`content_bottom`, `ParentNeoShopCategory`.`parent_id`, `ParentNeoShopCategory`.`lft`, `ParentNeoShopCategory`.`rght`, `ParentNeoShopCategory`.`level`, `ParentNeoShopCategory`.`visible`, `ParentNeoShopCategory`.`new`, `ParentNeoShopCategory`.`type`, `ParentNeoShopCategory`.`image`, `ParentNeoShopCategory`.`modified`, `ParentNeoShopCategory`.`modified_by`, `ParentNeoShopCategory`.`created`, `ParentNeoShopCategory`.`created_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 `cast_iron_whole`.`neo_shop_categories` AS `NeoShopCategory` LEFT JOIN `cast_iron_whole`.`neo_shop_categories` AS `ParentNeoShopCategory` ON (`NeoShopCategory`.`parent_id` = `ParentNeoShopCategory`.`id`) LEFT JOIN `cast_iron_whole`.`users` AS `CreatedBy` ON (`NeoShopCategory`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `cast_iron_whole`.`users` AS `ModifiedBy` ON (`NeoShopCategory`.`modified_by` = `ModifiedBy`.`id`) WHERE `NeoShopCategory`.`parent_id` = 0 ORDER BY `NeoShopCategory`.`name` ASC | 14 | 14 | 1 | maybe slow |
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`.`meta_title`, `NeoCmsPage`.`meta_h1`, `NeoCmsPage`.`google_index`, `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 `cast_iron_whole`.`neo_cms_pages` AS `NeoCmsPage` INNER JOIN `cast_iron_whole`.`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` = 'eng') INNER JOIN `cast_iron_whole`.`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` = 'eng') INNER JOIN `cast_iron_whole`.`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` = 'eng') WHERE `NeoCmsPage`.`parent_id` IS NULL AND `visible` = '1' ORDER BY `NeoCmsPage`.`lft` ASC | 5 | 5 | 2 | maybe slow |
SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `cast_iron_whole`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 7 AND `lang` = 'eng' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `cast_iron_whole`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 6 AND `lang` = 'eng' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `cast_iron_whole`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 11 AND `lang` = 'eng' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `cast_iron_whole`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 9 AND `lang` = 'eng' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slug`.`id`, `Slug`.`lang`, `Slug`.`slug`, `Slug`.`url`, `Slug`.`model`, `Slug`.`foreign_key` FROM `cast_iron_whole`.`slugs` AS `Slug` WHERE `model` = 'NeoCmsPage' AND `foreign_key` = 12 AND `lang` = 'eng' LIMIT 1 | 1 | 1 | 0 | |