Site Map

(default) 60 queries took 92 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`774
2DESCRIBE `acos`770
3DESCRIBE `aros_acos`770
4DESCRIBE `search_index`660
5DESCRIBE `pages`23230
6DESCRIBE `articles`17170
7DESCRIBE `article_categories`11110
8DESCRIBE `documents`19194
9DESCRIBE `document_categories`16160
10DESCRIBE `articles_documents`334
11DESCRIBE `documents_pages`330
12DESCRIBE `mixtures`34340
13DESCRIBE `mixture_categories`17170
14DESCRIBE `banner_images_mixture_categories`330
15DESCRIBE `mixture_categories_mixtures`440
16DESCRIBE `mixture_categories_thumbnails`334
17DESCRIBE `documents_mixture_categories`330
18DESCRIBE `species`37370
19DESCRIBE `species_categories`14140
20DESCRIBE `banner_images_species_categories`334
21DESCRIBE `species_categories_thumbnails`330
22DESCRIBE `documents_species_categories`334
23DESCRIBE `species_types`14140
24DESCRIBE `regions`11110
25DESCRIBE `regions_species`334
26DESCRIBE `articles_species`330
27DESCRIBE `banner_images_species`334
28DESCRIBE `mixtures_species`440
29DESCRIBE `pages_species`334
30DESCRIBE `species_thumbnails`330
31DESCRIBE `documents_species`330
32DESCRIBE `articles_mixtures`330
33DESCRIBE `banner_images_mixtures`330
34DESCRIBE `mixtures_mixtures`440
35DESCRIBE `mixtures_thumbnails`330
36DESCRIBE `documents_mixtures`330
37DESCRIBE `mixtures_pages`334
38DESCRIBE `articles_banner_images`330
39DESCRIBE `articles_thumbnails`330
40DESCRIBE `articles_pages`330
41DESCRIBE `banner_images_pages`330
42DESCRIBE `pages_pages`330
43DESCRIBE `pages_thumbnails`334
44SELECT `Page`.`id`, `Page`.`lft`, `Page`.`rght`, `Page`.`parent_id`, `Page`.`name`, `Page`.`link_name`, `Page`.`slug`, `Page`.`location`, `Page`.`synopsis`, `Page`.`content`, `Page`.`html_content`, `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_description`, `Page`.`allow_delete`, `Page`.`include_in_main_menu`, `Page`.`is_section`, `Page`.`is_home_page`, `Page`.`level`, `Page`.`sequence`, `Page`.`status`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE `Page`.`level` = 1 AND `Page`.`status` = 1 AND `Page`.`include_in_main_menu` = 1 AND `Page`.`is_home_page` = 0 ORDER BY `Page`.`lft` ASC 660
45SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`name`, `Page`.`slug`, `Page`.`synopsis`, `Page`.`created` FROM `pages` AS `Page` LEFT JOIN `pages` AS `ParentPage` ON (`Page`.`parent_id` = `ParentPage`.`id`) WHERE `Page`.`status` = 1 AND `Page`.`is_home_page` = 0 ORDER BY `Page`.`lft` asc 81810
46SELECT `ChildPage`.`id`, `ChildPage`.`lft`, `ChildPage`.`rght`, `ChildPage`.`parent_id`, `ChildPage`.`name`, `ChildPage`.`link_name`, `ChildPage`.`slug`, `ChildPage`.`location`, `ChildPage`.`synopsis`, `ChildPage`.`content`, `ChildPage`.`html_content`, `ChildPage`.`meta_title`, `ChildPage`.`meta_keywords`, `ChildPage`.`meta_description`, `ChildPage`.`allow_delete`, `ChildPage`.`include_in_main_menu`, `ChildPage`.`is_section`, `ChildPage`.`is_home_page`, `ChildPage`.`level`, `ChildPage`.`sequence`, `ChildPage`.`status`, `ChildPage`.`created`, `ChildPage`.`modified` FROM `pages` AS `ChildPage` WHERE `ChildPage`.`parent_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) ORDER BY lft asc 84848
47SELECT `Article`.`id`, `Article`.`article_category_id`, `Article`.`name`, `Article`.`link_name`, `Article`.`slug`, `Article`.`published`, `Article`.`synopsis`, `Article`.`content`, `Article`.`html_content`, `Article`.`meta_title`, `Article`.`meta_keywords`, `Article`.`meta_description`, `Article`.`featured`, `Article`.`allow_delete`, `Article`.`status`, `Article`.`created`, `Article`.`modified`, `ArticlesPage`.`id`, `ArticlesPage`.`article_id`, `ArticlesPage`.`page_id` FROM `articles` AS `Article` JOIN `articles_pages` AS `ArticlesPage` ON (`ArticlesPage`.`page_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) AND `ArticlesPage`.`article_id` = `Article`.`id`) ORDER BY `Article`.`published` DESC 24240
48SELECT `BannerImage`.`id`, `BannerImage`.`document_category_id`, `BannerImage`.`model`, `BannerImage`.`foreign_key`, `BannerImage`.`name`, `BannerImage`.`link_name`, `BannerImage`.`link_title`, `BannerImage`.`description`, `BannerImage`.`meta_title`, `BannerImage`.`meta_keywords`, `BannerImage`.`meta_description`, `BannerImage`.`extension`, `BannerImage`.`mime_type`, `BannerImage`.`filesize`, `BannerImage`.`md5`, `BannerImage`.`allow_delete`, `BannerImage`.`status`, `BannerImage`.`created`, `BannerImage`.`modified`, `BannerImagesPage`.`id`, `BannerImagesPage`.`page_id`, `BannerImagesPage`.`document_id` FROM `documents` AS `BannerImage` JOIN `banner_images_pages` AS `BannerImagesPage` ON (`BannerImagesPage`.`page_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) AND `BannerImagesPage`.`document_id` = `BannerImage`.`id`) 000
49SELECT `RelatedPage`.`id`, `RelatedPage`.`lft`, `RelatedPage`.`rght`, `RelatedPage`.`parent_id`, `RelatedPage`.`name`, `RelatedPage`.`link_name`, `RelatedPage`.`slug`, `RelatedPage`.`location`, `RelatedPage`.`synopsis`, `RelatedPage`.`content`, `RelatedPage`.`html_content`, `RelatedPage`.`meta_title`, `RelatedPage`.`meta_keywords`, `RelatedPage`.`meta_description`, `RelatedPage`.`allow_delete`, `RelatedPage`.`include_in_main_menu`, `RelatedPage`.`is_section`, `RelatedPage`.`is_home_page`, `RelatedPage`.`level`, `RelatedPage`.`sequence`, `RelatedPage`.`status`, `RelatedPage`.`created`, `RelatedPage`.`modified`, `PagesPage`.`id`, `PagesPage`.`page_id`, `PagesPage`.`related_page_id` FROM `pages` AS `RelatedPage` JOIN `pages_pages` AS `PagesPage` ON (`PagesPage`.`page_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) AND `PagesPage`.`related_page_id` = `RelatedPage`.`id`) 29294
50SELECT `Thumbnail`.`id`, `Thumbnail`.`document_category_id`, `Thumbnail`.`model`, `Thumbnail`.`foreign_key`, `Thumbnail`.`name`, `Thumbnail`.`link_name`, `Thumbnail`.`link_title`, `Thumbnail`.`description`, `Thumbnail`.`meta_title`, `Thumbnail`.`meta_keywords`, `Thumbnail`.`meta_description`, `Thumbnail`.`extension`, `Thumbnail`.`mime_type`, `Thumbnail`.`filesize`, `Thumbnail`.`md5`, `Thumbnail`.`allow_delete`, `Thumbnail`.`status`, `Thumbnail`.`created`, `Thumbnail`.`modified`, `PagesThumbnail`.`id`, `PagesThumbnail`.`document_id`, `PagesThumbnail`.`page_id` FROM `documents` AS `Thumbnail` JOIN `pages_thumbnails` AS `PagesThumbnail` ON (`PagesThumbnail`.`page_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) AND `PagesThumbnail`.`document_id` = `Thumbnail`.`id`) 220
51SELECT `Document`.`id`, `Document`.`document_category_id`, `Document`.`model`, `Document`.`foreign_key`, `Document`.`name`, `Document`.`link_name`, `Document`.`link_title`, `Document`.`description`, `Document`.`meta_title`, `Document`.`meta_keywords`, `Document`.`meta_description`, `Document`.`extension`, `Document`.`mime_type`, `Document`.`filesize`, `Document`.`md5`, `Document`.`allow_delete`, `Document`.`status`, `Document`.`created`, `Document`.`modified`, `DocumentsPage`.`id`, `DocumentsPage`.`document_id`, `DocumentsPage`.`page_id` FROM `documents` AS `Document` JOIN `documents_pages` AS `DocumentsPage` ON (`DocumentsPage`.`page_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) AND `DocumentsPage`.`document_id` = `Document`.`id`) 55550
52SELECT `Mixture`.`id`, `Mixture`.`mixture_category_id`, `Mixture`.`name`, `Mixture`.`link_name`, `Mixture`.`slug`, `Mixture`.`sku`, `Mixture`.`description`, `Mixture`.`html_content`, `Mixture`.`details`, `Mixture`.`html_details`, `Mixture`.`cultural_info`, `Mixture`.`composition_description`, `Mixture`.`html_cultural_info`, `Mixture`.`price_100_grams`, `Mixture`.`price_1000_grams`, `Mixture`.`price_10000_grams`, `Mixture`.`price_100000_grams`, `Mixture`.`sowing_rate`, `Mixture`.`units`, `Mixture`.`min_units_per_order`, `Mixture`.`max_units_per_order`, `Mixture`.`sowing_rate_kg_ha`, `Mixture`.`sowing_rate_kg_acre`, `Mixture`.`sowing_rate_g_m2`, `Mixture`.`quantity`, `Mixture`.`meta_title`, `Mixture`.`meta_keywords`, `Mixture`.`meta_description`, `Mixture`.`allow_delete`, `Mixture`.`level`, `Mixture`.`sequence`, `Mixture`.`status`, `Mixture`.`created`, `Mixture`.`modified`, `MixturesPage`.`id`, `MixturesPage`.`mixture_id`, `MixturesPage`.`page_id` FROM `mixtures` AS `Mixture` JOIN `mixtures_pages` AS `MixturesPage` ON (`MixturesPage`.`page_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) AND `MixturesPage`.`mixture_id` = `Mixture`.`id`) 17170
53SELECT `Species`.`id`, `Species`.`species_category_id`, `Species`.`species_type_id`, `Species`.`name`, `Species`.`link_name`, `Species`.`latin_name`, `Species`.`slug`, `Species`.`sku`, `Species`.`description`, `Species`.`html_content`, `Species`.`details`, `Species`.`html_details`, `Species`.`technical_info`, `Species`.`html_technical_info`, `Species`.`cultural_info`, `Species`.`html_cultural_info`, `Species`.`seeds_per_gram`, `Species`.`height`, `Species`.`price_1_grams`, `Species`.`price_10_grams`, `Species`.`price_100_grams`, `Species`.`price_1000_grams`, `Species`.`price_10000_grams`, `Species`.`sowing_rate_g_m2`, `Species`.`units`, `Species`.`min_units_per_order`, `Species`.`max_units_per_order`, `Species`.`quantity`, `Species`.`meta_title`, `Species`.`meta_keywords`, `Species`.`meta_description`, `Species`.`allow_delete`, `Species`.`level`, `Species`.`sequence`, `Species`.`status`, `Species`.`created`, `Species`.`modified`, `PagesSpecy`.`id`, `PagesSpecy`.`page_id`, `PagesSpecy`.`species_id` FROM `species` AS `Species` JOIN `pages_species` AS `PagesSpecy` ON (`PagesSpecy`.`page_id` IN (2, 56, 58, 59, 57, 1, 4, 105, 106, 5, 91, 93, 6, 94, 95, 96, 97, 3, 60, 61, 62, 64, 69, 70, 71, 72, 7, 8, 119, 16, 19, 9, 21, 27, 107, 108, 28, 109, 110, 30, 115, 116, 36, 34, 35, 38, 47, 113, 114, 48, 52, 53, 54, 55, 26, 111, 112, 24, 98, 99, 100, 101, 118, 78, 83, 117, 121, 120, 40, 41, 42, 43, 44, 45, 46, 89, 75, 76, 77, 102, 103) AND `PagesSpecy`.`species_id` = `Species`.`id`) 17170
54SELECT `ArticleCategory`.`id`, `ArticleCategory`.`name`, `ArticleCategory`.`slug`, `ArticleCategory`.`description`, `ArticleCategory`.`meta_title`, `ArticleCategory`.`meta_keywords`, `ArticleCategory`.`meta_description`, `ArticleCategory`.`allow_delete`, `ArticleCategory`.`status`, `ArticleCategory`.`created`, `ArticleCategory`.`modified` FROM `article_categories` AS `ArticleCategory` WHERE `ArticleCategory`.`status` = 1 ORDER BY `ArticleCategory`.`name` asc 330
55SELECT `Article`.`id`, `Article`.`article_category_id`, `Article`.`name`, `Article`.`link_name`, `Article`.`slug`, `Article`.`published`, `Article`.`synopsis`, `Article`.`content`, `Article`.`html_content`, `Article`.`meta_title`, `Article`.`meta_keywords`, `Article`.`meta_description`, `Article`.`featured`, `Article`.`allow_delete`, `Article`.`status`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE `Article`.`status` = 1 AND `Article`.`article_category_id` IN (4, 3, 2) ORDER BY `Article`.`published` DESC 363612
56SELECT `SpeciesCategory`.`id`, `SpeciesCategory`.`name`, `SpeciesCategory`.`link_name`, `SpeciesCategory`.`slug`, `SpeciesCategory`.`description`, `SpeciesCategory`.`content`, `SpeciesCategory`.`html_content`, `SpeciesCategory`.`meta_title`, `SpeciesCategory`.`meta_keywords`, `SpeciesCategory`.`meta_description`, `SpeciesCategory`.`allow_delete`, `SpeciesCategory`.`status`, `SpeciesCategory`.`created`, `SpeciesCategory`.`modified` FROM `species_categories` AS `SpeciesCategory` WHERE `SpeciesCategory`.`status` = 1 ORDER BY `SpeciesCategory`.`id` asc 440
57SELECT `Species`.`id`, `Species`.`species_category_id`, `Species`.`species_type_id`, `Species`.`name`, `Species`.`link_name`, `Species`.`latin_name`, `Species`.`slug`, `Species`.`sku`, `Species`.`description`, `Species`.`html_content`, `Species`.`details`, `Species`.`html_details`, `Species`.`technical_info`, `Species`.`html_technical_info`, `Species`.`cultural_info`, `Species`.`html_cultural_info`, `Species`.`seeds_per_gram`, `Species`.`height`, `Species`.`price_1_grams`, `Species`.`price_10_grams`, `Species`.`price_100_grams`, `Species`.`price_1000_grams`, `Species`.`price_10000_grams`, `Species`.`sowing_rate_g_m2`, `Species`.`units`, `Species`.`min_units_per_order`, `Species`.`max_units_per_order`, `Species`.`quantity`, `Species`.`meta_title`, `Species`.`meta_keywords`, `Species`.`meta_description`, `Species`.`allow_delete`, `Species`.`level`, `Species`.`sequence`, `Species`.`status`, `Species`.`created`, `Species`.`modified` FROM `species` AS `Species` WHERE `Species`.`status` = 1 AND `Species`.`species_category_id` IN (1, 2, 3, 4) ORDER BY `Species`.`latin_name` ASC 19719712
58SELECT `MixtureCategory`.`id`, `MixtureCategory`.`parent_id`, `MixtureCategory`.`name`, `MixtureCategory`.`link_name`, `MixtureCategory`.`sub_name`, `MixtureCategory`.`slug`, `MixtureCategory`.`description`, `MixtureCategory`.`content`, `MixtureCategory`.`html_content`, `MixtureCategory`.`meta_title`, `MixtureCategory`.`meta_keywords`, `MixtureCategory`.`meta_description`, `MixtureCategory`.`level`, `MixtureCategory`.`allow_delete`, `MixtureCategory`.`status`, `MixtureCategory`.`created`, `MixtureCategory`.`modified` FROM `mixture_categories` AS `MixtureCategory` WHERE `MixtureCategory`.`status` = 1 AND `MixtureCategory`.`level` = 1 ORDER BY `MixtureCategory`.`id` asc 554
59SELECT `ChildMixtureCategory`.`id`, `ChildMixtureCategory`.`parent_id`, `ChildMixtureCategory`.`name`, `ChildMixtureCategory`.`link_name`, `ChildMixtureCategory`.`sub_name`, `ChildMixtureCategory`.`slug`, `ChildMixtureCategory`.`description`, `ChildMixtureCategory`.`content`, `ChildMixtureCategory`.`html_content`, `ChildMixtureCategory`.`meta_title`, `ChildMixtureCategory`.`meta_keywords`, `ChildMixtureCategory`.`meta_description`, `ChildMixtureCategory`.`level`, `ChildMixtureCategory`.`allow_delete`, `ChildMixtureCategory`.`status`, `ChildMixtureCategory`.`created`, `ChildMixtureCategory`.`modified` FROM `mixture_categories` AS `ChildMixtureCategory` WHERE `ChildMixtureCategory`.`status` = 1 AND `ChildMixtureCategory`.`parent_id` IN (1, 5, 8, 11, 14) 16160
60SELECT `Mixture`.`id`, `Mixture`.`mixture_category_id`, `Mixture`.`name`, `Mixture`.`link_name`, `Mixture`.`slug`, `Mixture`.`sku`, `Mixture`.`description`, `Mixture`.`html_content`, `Mixture`.`details`, `Mixture`.`html_details`, `Mixture`.`cultural_info`, `Mixture`.`composition_description`, `Mixture`.`html_cultural_info`, `Mixture`.`price_100_grams`, `Mixture`.`price_1000_grams`, `Mixture`.`price_10000_grams`, `Mixture`.`price_100000_grams`, `Mixture`.`sowing_rate`, `Mixture`.`units`, `Mixture`.`min_units_per_order`, `Mixture`.`max_units_per_order`, `Mixture`.`sowing_rate_kg_ha`, `Mixture`.`sowing_rate_kg_acre`, `Mixture`.`sowing_rate_g_m2`, `Mixture`.`quantity`, `Mixture`.`meta_title`, `Mixture`.`meta_keywords`, `Mixture`.`meta_description`, `Mixture`.`allow_delete`, `Mixture`.`level`, `Mixture`.`sequence`, `Mixture`.`status`, `Mixture`.`created`, `Mixture`.`modified`, `MixtureCategoriesMixture`.`id`, `MixtureCategoriesMixture`.`mixture_category_id`, `MixtureCategoriesMixture`.`mixture_id`, `MixtureCategoriesMixture`.`default` FROM `mixtures` AS `Mixture` JOIN `mixture_categories_mixtures` AS `MixtureCategoriesMixture` ON (`MixtureCategoriesMixture`.`mixture_category_id` IN (2, 3, 4, 6, 7, 9, 10, 12, 13, 16, 17, 18, 19, 20, 21, 22) AND `MixtureCategoriesMixture`.`mixture_id` = `Mixture`.`id`) WHERE `Mixture`.`status` = 1 ORDER BY `Mixture`.`sku` ASC 61618