Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`logo_id`, `AppPreference`.`intro_top`, `AppPreference`.`intro_detail`, `AppPreference`.`intro_link_id`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`smtp_host`, `AppPreference`.`smtp_port`, `AppPreference`.`smtp_username`, `AppPreference`.`smtp_password`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`pdf_cover_details`, `AppPreference`.`pdf_inside_cover_file`, `AppPreference`.`pdf_introduction`, `AppPreference`.`pdf_details`, `AppPreference`.`pdf_terms_and_conditions`, `AppPreference`.`google_analytics`, `AppPreference`.`ga_username`, `AppPreference`.`ga_password`, `AppPreference`.`ga_report_id`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `astrum`.`oc_app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `astrum`.`oc_app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1) | 10 | 10 | 0 | |
SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` = '/products/details/RH0222' AND `FrontpageRewrite`.`status` = 1 LIMIT 1 | 0 | 0 | 0 | |
SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` LIKE '%*' AND `FrontpageRewrite`.`status` = 1 | 0 | 0 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`url` = '/products/details' LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 33 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE 1 = 1 AND `FrontpagePage`.`nleft` <= 63 AND `FrontpagePage`.`nright` >= 64 ORDER BY `FrontpagePage`.`nleft` asc | 3 | 3 | 0 | |
SELECT `Product`.`id`, `Product`.`uid`, `Product`.`title`, `Product`.`slug`, `Product`.`code`, `Product`.`business_price`, `Product`.`product_category_id`, `Product`.`product_grape_variety_id`, `Product`.`geography_region_id`, `Product`.`vintage`, `Product`.`vineage`, `Product`.`product_producer_id`, `Product`.`product_distributor_id`, `Product`.`product_range_id`, `Product`.`soil`, `Product`.`training`, `Product`.`yield`, `Product`.`ageing`, `Product`.`vinification`, `Product`.`alcohol`, `Product`.`product_bottle_closure_type_id`, `Product`.`product_bottle_size_id`, `Product`.`product_case_size_id`, `Product`.`ph_level`, `Product`.`acidity`, `Product`.`residual_sugar_content`, `Product`.`method_and_production`, `Product`.`tasting_notes`, `Product`.`food_match`, `Product`.`status`, `Product`.`sorting`, `Product`.`created`, `Product`.`created_by`, `Product`.`modified`, `Product`.`modified_by`, `ProductProducer`.`name`, `ProductProducer`.`slug`, `ProductDistributor`.`title`, `ProductDistributor`.`slug`, `ProductCaseSize`.`title`, `ProductBottleSize`.`title`, `ProductBottleClosureType`.`title`, `GeographyRegion`.`title`, `GeographyRegion`.`slug`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_products` AS `Product` LEFT JOIN `astrum`.`oc_product_producers` AS `ProductProducer` ON (`Product`.`product_producer_id` = `ProductProducer`.`id`) LEFT JOIN `astrum`.`oc_product_distributors` AS `ProductDistributor` ON (`Product`.`product_distributor_id` = `ProductDistributor`.`id`) LEFT JOIN `astrum`.`oc_product_case_sizes` AS `ProductCaseSize` ON (`Product`.`product_case_size_id` = `ProductCaseSize`.`id`) LEFT JOIN `astrum`.`oc_product_bottle_sizes` AS `ProductBottleSize` ON (`Product`.`product_bottle_size_id` = `ProductBottleSize`.`id`) LEFT JOIN `astrum`.`oc_product_bottle_closure_types` AS `ProductBottleClosureType` ON (`Product`.`product_bottle_closure_type_id` = `ProductBottleClosureType`.`id`) LEFT JOIN `astrum`.`oc_geography_regions` AS `GeographyRegion` ON (`Product`.`geography_region_id` = `GeographyRegion`.`id`) WHERE `Product`.`code` = 'RH0222' AND `Product`.`status` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT `GeographyCountry`.`title`, `GeographyCountry`.`slug` FROM `astrum`.`oc_geography_countries` AS `GeographyCountry` WHERE `GeographyCountry`.`id` = 2 | 1 | 1 | 0 | |
SELECT `ProductImage`.`title`, `ProductImage`.`image_id`, `ProductImage`.`product_id` FROM `astrum`.`oc_product_images` AS `ProductImage` WHERE `ProductImage`.`status` = '1' AND `ProductImage`.`product_id` = (1287) ORDER BY `ProductImage`.`sorting` asc | 1 | 1 | 0 | |
SELECT `ProductBox`.`id`, `ProductBox`.`product_id`, `ProductBox`.`title`, `ProductBox`.`text`, `ProductBox`.`image_id`, `ProductBox`.`document_id`, `ProductBox`.`document_title`, `ProductBox`.`status`, `ProductBox`.`sorting`, `ProductBox`.`created`, `ProductBox`.`created_by`, `ProductBox`.`modified`, `ProductBox`.`modified_by` FROM `astrum`.`oc_product_boxes` AS `ProductBox` WHERE `ProductBox`.`product_id` = (1287) | 0 | 0 | 0 | |
SELECT `ProductGrapeVarietyProduct`.`percentage`, `ProductGrapeVarietyProduct`.`product_grape_variety_id`, `ProductGrapeVarietyProduct`.`product_id` FROM `astrum`.`oc_product_grape_variety_products` AS `ProductGrapeVarietyProduct` WHERE `ProductGrapeVarietyProduct`.`product_id` = (1287) ORDER BY `ProductGrapeVarietyProduct`.`percentage` desc | 1 | 1 | 0 | |
SELECT `ProductGrapeVariety`.`title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`id` = 223 | 1 | 1 | 0 | |
SELECT `ProductCategory`.`title`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `astrum`.`oc_product_categories` AS `ProductCategory` JOIN `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` = 1287 AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) | 2 | 2 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 4117 LIMIT 1 | 1 | 1 | 1 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 4117 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `AssetTag`.`id`, `AssetTag`.`name`, `AssetTag`.`slug`, `AssetTag`.`used`, `AssetTag`.`created`, `AssetTag`.`created_by`, `AssetTag`.`modified`, `AssetTag`.`modified_by`, `AssetTagsAsset`.`id`, `AssetTagsAsset`.`asset_id`, `AssetTagsAsset`.`asset_tag_id`, `AssetTagsAsset`.`created`, `AssetTagsAsset`.`modified`, `AssetTagsAsset`.`sorting`, `AssetTagsAsset`.`created_by`, `AssetTagsAsset`.`modified_by` FROM `astrum`.`oc_asset_tags` AS `AssetTag` JOIN `astrum`.`oc_asset_tags_assets` AS `AssetTagsAsset` ON (`AssetTagsAsset`.`asset_id` = 4117 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC | 0 | 0 | 0 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 4117 LIMIT 1 | 1 | 1 | 0 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 4117 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `AssetTag`.`id`, `AssetTag`.`name`, `AssetTag`.`slug`, `AssetTag`.`used`, `AssetTag`.`created`, `AssetTag`.`created_by`, `AssetTag`.`modified`, `AssetTag`.`modified_by`, `AssetTagsAsset`.`id`, `AssetTagsAsset`.`asset_id`, `AssetTagsAsset`.`asset_tag_id`, `AssetTagsAsset`.`created`, `AssetTagsAsset`.`modified`, `AssetTagsAsset`.`sorting`, `AssetTagsAsset`.`created_by`, `AssetTagsAsset`.`modified_by` FROM `astrum`.`oc_asset_tags` AS `AssetTag` JOIN `astrum`.`oc_asset_tags_assets` AS `AssetTagsAsset` ON (`AssetTagsAsset`.`asset_id` = 4117 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC | 0 | 0 | 0 | |
SELECT `FrontpagePage`.`title`, `FrontpagePage`.`url`, `FrontpageContent`.`id` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` inner JOIN `astrum`.`oc_frontpage_contents_frontpage_elements` AS `FrontpageContentsFrontpageElement` ON (`FrontpageContentsFrontpageElement`.`frontpage_content_id` = `FrontpageContent`.`id`) inner JOIN `astrum`.`oc_frontpage_elements` AS `FrontpageElement` ON (`FrontpageElement`.`id` = `FrontpageContentsFrontpageElement`.`frontpage_element_id` AND `FrontpageElement`.`id` = 3) LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageContent`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `astrum`.`oc_quotes` AS `Quote` ON (`FrontpageContent`.`quote_id` = `Quote`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageContent`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageContent`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageContent`.`status` = '1' AND `FrontpagePage`.`status` = '1' AND `FrontpageElement`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpageContentDocument`.`id`, `FrontpageContentDocument`.`frontpage_content_id`, `FrontpageContentDocument`.`document_id`, `FrontpageContentDocument`.`created`, `FrontpageContentDocument`.`created_by`, `FrontpageContentDocument`.`modified`, `FrontpageContentDocument`.`modified_by`, `FrontpageContentDocument`.`status` FROM `astrum`.`oc_frontpage_content_documents` AS `FrontpageContentDocument` WHERE `FrontpageContentDocument`.`frontpage_content_id` = (16) ORDER BY `FrontpageContentDocument`.`created` desc | 0 | 0 | 0 | |
SELECT `FrontpageElement`.`id`, `FrontpageElement`.`name`, `FrontpageElement`.`path`, `FrontpageElement`.`created`, `FrontpageElement`.`modified`, `FrontpageContentsFrontpageElement`.`id`, `FrontpageContentsFrontpageElement`.`frontpage_element_id`, `FrontpageContentsFrontpageElement`.`frontpage_content_id` FROM `astrum`.`oc_frontpage_elements` AS `FrontpageElement` JOIN `astrum`.`oc_frontpage_contents_frontpage_elements` AS `FrontpageContentsFrontpageElement` ON (`FrontpageContentsFrontpageElement`.`frontpage_content_id` = 16 AND `FrontpageContentsFrontpageElement`.`frontpage_element_id` = `FrontpageElement`.`id`) | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'header' AND `FrontpagePage`.`type` = 'folder' LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 26 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc | 5 | 5 | 1 | maybe slow |
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'main' AND `FrontpagePage`.`type` = 'folder' LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 1 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc | 7 | 7 | 1 | maybe slow |
SELECT `CookieCompliance`.`id`, `CookieCompliance`.`content`, `CookieCompliance`.`page_id`, `CookieCompliance`.`created`, `CookieCompliance`.`created_by`, `CookieCompliance`.`modified`, `CookieCompliance`.`modified_by`, `CookieCompliance`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_cookie_compliances` AS `CookieCompliance` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`CookieCompliance`.`page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`CookieCompliance`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`CookieCompliance`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 3503 LIMIT 1 | 1 | 1 | 1 | |
SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 3503 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) | 0 | 0 | 0 | |
SELECT `AssetTag`.`id`, `AssetTag`.`name`, `AssetTag`.`slug`, `AssetTag`.`used`, `AssetTag`.`created`, `AssetTag`.`created_by`, `AssetTag`.`modified`, `AssetTag`.`modified_by`, `AssetTagsAsset`.`id`, `AssetTagsAsset`.`asset_id`, `AssetTagsAsset`.`asset_tag_id`, `AssetTagsAsset`.`created`, `AssetTagsAsset`.`modified`, `AssetTagsAsset`.`sorting`, `AssetTagsAsset`.`created_by`, `AssetTagsAsset`.`modified_by` FROM `astrum`.`oc_asset_tags` AS `AssetTag` JOIN `astrum`.`oc_asset_tags_assets` AS `AssetTagsAsset` ON (`AssetTagsAsset`.`asset_id` = 3503 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC | 0 | 0 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 33 LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpagePage`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpagePage`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpagePage`.`nleft` <= 63 AND `FrontpagePage`.`nright` >= 64 ORDER BY `FrontpagePage`.`nleft` asc | 3 | 3 | 1 | maybe slow |
SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_content_category_id`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_link`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`title`, `FrontpageContent`.`subtitle`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`quote_id`, `FrontpageContent`.`embed`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` WHERE `FrontpageContent`.`frontpage_page_id` IN (1, 12, 33) ORDER BY `FrontpageContent`.`sorting` asc | 2 | 2 | 0 | |
SELECT `FrontpageRoute`.`id`, `FrontpageRoute`.`route`, `FrontpageRoute`.`plugin`, `FrontpageRoute`.`controller`, `FrontpageRoute`.`action`, `FrontpageRoute`.`named`, `FrontpageRoute`.`pass`, `FrontpageRoute`.`frontpage_page_id`, `FrontpageRoute`.`route_class`, `FrontpageRoute`.`status`, `FrontpageRoute`.`sorting`, `FrontpageRoute`.`created`, `FrontpageRoute`.`created_by`, `FrontpageRoute`.`modified`, `FrontpageRoute`.`modified_by` FROM `astrum`.`oc_frontpage_routes` AS `FrontpageRoute` WHERE `FrontpageRoute`.`frontpage_page_id` IN (1, 12, 33) | 2 | 2 | 0 | |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`slug`, `Tag`.`used`, `Tag`.`tag_object_count`, `Tag`.`created`, `Tag`.`modified`, `Tag`.`created_by`, `Tag`.`modified_by`, `TagObject`.`id`, `TagObject`.`tag_id`, `TagObject`.`object`, `TagObject`.`object_id`, `TagObject`.`sorting`, `TagObject`.`created`, `TagObject`.`modified` FROM `astrum`.`oc_tags` AS `Tag` JOIN `astrum`.`oc_tags_objects` AS `TagObject` ON (`TagObject`.`object_id` IN (1, 12, 33) AND `TagObject`.`tag_id` = `Tag`.`id`) WHERE `TagObject`.`object` = 'FrontpagePage' ORDER BY `TagObject`.`sorting` asc | 0 | 0 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 12 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc | 2 | 2 | 0 | |
SELECT `ProductCategory`.`id`, `ProductCategory`.`slug`, (CONCAT(`ProductCategory`.`title`, " (", `ProductCategory`.`product_count`, ")")) AS `ProductCategory__combo_title` FROM `astrum`.`oc_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`status` = '1' AND `ProductCategory`.`group` = 'wine' ORDER BY `ProductCategory`.`sorting` asc | 10 | 10 | 0 | |
SELECT `ProductCategoriesProduct`.`product_id` FROM `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` WHERE `product_category_id` IN (4, 2, 3, 1, 5, 9, 10, 11, 12, 13) | 1485 | 1485 | 1 | |
SELECT `Product`.`geography_region_id`, `Product`.`code`, `Product`.`title`, `ProductProducer`.`name`, `ProductDistributor`.`title`, `ProductProducer`.`id`, `ProductDistributor`.`id` FROM `astrum`.`oc_products` AS `Product` LEFT JOIN `astrum`.`oc_product_producers` AS `ProductProducer` ON (`Product`.`product_producer_id` = `ProductProducer`.`id`) LEFT JOIN `astrum`.`oc_product_distributors` AS `ProductDistributor` ON (`Product`.`product_distributor_id` = `ProductDistributor`.`id`) WHERE `Product`.`status` = '1' AND `Product`.`id` IN (31, 32, 33, 34, 35, 36, 37, 38, 39, 41, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 157, 158, 159, 160, 163, 164, 165, 166, 167, 168, 169, 171, 172, 173, 174, 176, 177, 178, 179, 180, 181, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 232, 233, 234, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 300, 301, 302, 307, 309, 327, 328, 329, 330, 332, 333, 334, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 354, 355, 356, 357, 358, 359, 360, 361, 363, 366, 367, 369, 370, 371, 372, 373, 374, 375, 376, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 393, 394, 396, 397, 398, 399, 400, 402, 403, 404, 405, 407, 408, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 426, 427, 428, 429, 430, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 469, 470, 471, 472, 476, 477, 478, 479, 480, 481, 482, 483, 484, 487, 488, 489, 490, 491, 492, 493, 494, 495, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 519, 520, 521, 522, 523, 524, 525, 526, 527, 529, 532, 533, 534, 535, 536, 537, 539, 540, 541, 543, 544, 545, 546, 547, 548, 549, 550, 554, 555, 556, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 578, 579, 580, 581, 582, 583, 584, 586, 587, 588, 589, 590, 591, 593, 594, 595, 596, 597, 598, 599, 600, 605, 606, 607, 608, 609, 617, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 638, 639, 640, 641, 642, 643, 646, 648, 649, 650, 651, 653, 654, 655, 656, 657, 658, 659, 660, 661, 664, 665, 667, 668, 669, 670, 671, 672, 673, 674, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 693, 696, 697, 702, 703, 704, 705, 706, 707, 708, 709, 710, 721, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 736, 737, 742, 743, 744, 745, 746, 747, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 779, 780, 782, 783, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 813, 814, 815, 816, 834, 835, 836, 837, 838, 839, 840, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 854, 855, 865, 866, 867, 868, 869, 870, 871, 873, 874, 876, 877, 880, 882, 884, 885, 886, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1047, 1048, 1049, 1050, 1051, 1052, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1077, 1078, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1149, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1294, 1295, 1296, 1297, 1298, 1299, 1300) ORDER BY `Product`.`title` asc | 397 | 397 | 7 | |
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` WHERE `id` IN (56, 25, 19, 32, 13, 21, 18, 67, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 68, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 55, 1, 11, 31, 48, 33, 49, 28, 40, 20, 43, 5) | 43 | 43 | 0 | |
SELECT `GeographyRegion`.`id`, `GeographyRegion`.`slug`, `GeographyRegion`.`title`, `GeographyCountry`.`id`, `GeographyCountry`.`slug`, `GeographyCountry`.`title`, `GeographyCountry`.`image_area_coordinates`, `GeographyCountry`.`image_area_coordinates_spirit` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` LEFT JOIN `astrum`.`oc_geography_countries` AS `GeographyCountry` ON (`GeographyRegion`.`geography_country_id` = `GeographyCountry`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`GeographyRegion`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`GeographyRegion`.`modified_by` = `ModifiedBy`.`id`) WHERE `GeographyRegion`.`id` IN (56, 25, 19, 32, 13, 21, 18, 67, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 68, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 55, 1, 11, 31, 48, 33, 49, 28, 40, 20, 43, 5) AND `GeographyRegion`.`status` = '1' AND `GeographyCountry`.`status` = '1' ORDER BY `GeographyCountry`.`title` asc, `GeographyRegion`.`sorting` asc | 43 | 43 | 1 | |
SELECT `ProductGrapeVariety`.`slug`, (CONCAT(`ProductGrapeVariety`.`title`, " (", `ProductGrapeVariety`.`product_count`, ")")) AS `ProductGrapeVariety__combo_title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`status` = '1' ORDER BY `ProductGrapeVariety`.`title` asc | 214 | 214 | 1 | |
SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'footer' AND `FrontpagePage`.`type` = 'folder' LIMIT 1 | 1 | 1 | 0 | |
SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 2 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc | 3 | 3 | 1 | maybe slow |