Skip to content
Menu
  • Home
  • About
  • Producers
  • Wine
  • Bar
  • News & Events
  • Contact
  • Search
  • Login
  • Wine List
  • Bar List
  • Value Range

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies.

More information
Close
Menu

5 Version01_RGB.png

  • Search
  • Login
  • Wine List
  • Bar List
  • Value Range
  • Email
  • Facebook
  • Twitter
  • Pinterest
  • LinkedIn
  • Google+
x
  • Home
  • About
  • Producers
  • Wine
  • Bar
  • News & Events
  • Contact
Terra di Limoni Limoncello di AmalfiLimoncello di Amalfi
Sambuca Fina, Colazingari - Lazio, ItalySambuca Fina
Rhum Rhum Blanc Agricole (Green), Capovilla - Veneto, ItalyRhum Rhum Blanc Agricole (Green)
Villa Zarri NocinoLiquore Nocino - Organic
Villa Zarri Brandy 10YrsBrandy 10Yrs
Capovilla Grappa di BassanoGrappa di Bassano
Grappa di AmaroneGrappa di Amarone
Capovilla Grappa Moscato giallo con astuccioGrappa di Moscato Giallo
Grappa di BrunelloGrappa di Brunello di Montalcino
Grappa di BaroloGrappa di Nebbiolo
Capovilla Distillato di vino (Brandy)Distillato di Vino (Brandy)
Capovilla Distillato di Uva IsabellaDistillato di Uva Isabella
  • Previous
  • 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
  • Next
1 to 12 of 101
  • © 2024 Astrum Wine Cellars
  • Terms & Conditions
  • Sitemap
  • Enjoy responsibly - drinkaware.co.uk
  • website by on-IDLE
  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    • Restore to current request
    • products/search/page:6/limit:12
    • producers/details/samaroli/country:the-united-kingdom/limit:4
    • products/details/GU0119/producer:gulfi/limit:12
    • products/search/page:5/limit:12
    ====
  • Session
    +

    Session

    • Config(array)
      • userAgent2de8fd4a5318d832203fd0e1fe809a1e
      • time1728157012
      • countdown10
    ====
  • Request
    +

    Request

    Cake Params

    • pluginproduct
    • controllerspirits
    • actionsearch
    • named(array)
      • category(null)
      • country(null)
      • region(null)
      • grape_variety(null)
      • producer(null)
      • limit12
    • pass(empty)
    • isAjax(false)
    • paging(array)
      • Product(array)
        • page1
        • current12
        • count101
        • prevPage(false)
        • nextPage(true)
        • pageCount9
        • order(array)
          • Product.sortingasc
        • limit12
        • options(array)
          • limit12
        • paramTypenamed

    Post data

    No post data.

    Query string

    No querystring data.

    Cookie

    To view Cookies, add CookieComponent to Controller

    Current Route

    • keys(empty)
    • options(array)
      • __page/bar/search
    • defaults(array)
      • pluginproduct
      • controllerspirits
      • actionsearch
    • template/bar/search
    ====
  • Sql Log
    +

    Sql Logs

    default

    Total Time: 188 ms
    Total Queries: 64 queries
    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` = '/bar/search' AND `FrontpageRewrite`.`status` = 1 LIMIT 1 0 0 3 maybe slow
    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 2 maybe slow
    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` = '/bar/search' LIMIT 1 1 1 8 maybe slow
    SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 52 LIMIT 1 1 1 4 maybe slow
    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` <= 67 AND `FrontpagePage`.`nright` >= 68 ORDER BY `FrontpagePage`.`nleft` asc 3 3 0
    SELECT `ProductCategory`.`id` FROM `astrum`.`oc_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`group` = 'spirit' 2 2 0
    SELECT `ProductCategoriesProduct`.`product_id` FROM `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` WHERE `product_category_id` IN (6, 14) 200 200 1
    SELECT `Product`.`title`, `Product`.`code`, `Product`.`vintage`, `Product`.`id` FROM `astrum`.`oc_products` AS `Product` WHERE `Product`.`status` = '1' AND `Product`.`id` IN (303, 304, 305, 306, 308, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 857, 858, 468, 475, 496, 511, 512, 513, 514, 515, 516, 517, 518, 538, 551, 552, 553, 557, 558, 601, 602, 604, 610, 611, 612, 613, 614, 615, 616, 618, 619, 621, 620, 622, 644, 645, 647, 662, 663, 666, 689, 690, 691, 692, 694, 695, 698, 699, 700, 701, 704, 856, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 722, 723, 735, 738, 739, 740, 748, 755, 756, 763, 777, 778, 781, 784, 785, 786, 800, 811, 812, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 853, 859, 860, 861, 862, 863, 864, 878, 879, 887, 888, 889, 890, 891, 892, 917, 918, 919, 963, 852, 988, 989, 1008, 1173, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1018, 1036, 1095, 1127, 1147, 1148, 1151, 1150, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1174, 1263, 1096, 307, 309, 536, 537, 1109, 1110, 1111, 1184, 1192, 1212, 1213, 1235, 1264, 1265, 1291, 1292, 1293) ORDER BY `Product`.`sorting` asc LIMIT 12 12 12 4 maybe slow
    SELECT `ProductImage`.`title`, `ProductImage`.`image_id`, `ProductImage`.`product_id` FROM `astrum`.`oc_product_images` AS `ProductImage` WHERE `ProductImage`.`status` = '1' AND `ProductImage`.`product_id` IN (303, 304, 306, 307, 309, 310, 312, 313, 314, 315, 316, 317) ORDER BY `ProductImage`.`sorting` asc 12 12 2 maybe slow
    SELECT COUNT(*) AS `count` FROM `astrum`.`oc_products` AS `Product` WHERE `Product`.`status` = '1' AND `Product`.`id` IN (303, 304, 305, 306, 308, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 857, 858, 468, 475, 496, 511, 512, 513, 514, 515, 516, 517, 518, 538, 551, 552, 553, 557, 558, 601, 602, 604, 610, 611, 612, 613, 614, 615, 616, 618, 619, 621, 620, 622, 644, 645, 647, 662, 663, 666, 689, 690, 691, 692, 694, 695, 698, 699, 700, 701, 704, 856, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 722, 723, 735, 738, 739, 740, 748, 755, 756, 763, 777, 778, 781, 784, 785, 786, 800, 811, 812, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 853, 859, 860, 861, 862, 863, 864, 878, 879, 887, 888, 889, 890, 891, 892, 917, 918, 919, 963, 852, 988, 989, 1008, 1173, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1018, 1036, 1095, 1127, 1147, 1148, 1151, 1150, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1174, 1263, 1096, 307, 309, 536, 537, 1109, 1110, 1111, 1184, 1192, 1212, 1213, 1235, 1264, 1265, 1291, 1292, 1293) 1 1 18 maybe slow
    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` = 1940 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` = 1940 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` = 1940 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` = 3948 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` = 3948 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) 0 0 9 maybe slow
    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` = 3948 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` = 3753 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` = 3753 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) 0 0 9 maybe slow
    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` = 3753 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` = 1896 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` = 1896 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` = 1896 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` = 1899 LIMIT 1 1 1 9 maybe slow
    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` = 1899 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` = 1899 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` = 3234 LIMIT 1 1 1 9 maybe slow
    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` = 3234 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` = 3234 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` = 3236 LIMIT 1 1 1 9 maybe slow
    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` = 3236 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` = 3236 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` = 3232 LIMIT 1 1 1 12 maybe slow
    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` = 3232 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) 0 0 8 maybe slow
    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` = 3232 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` = 3233 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` = 3233 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) 0 0 2 maybe slow
    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` = 3233 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` = 3235 LIMIT 1 1 1 17 maybe slow
    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` = 3235 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` = 3235 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` = 3237 LIMIT 1 1 1 9 maybe slow
    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` = 3237 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` = 3237 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` = 3238 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` = 3238 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` = 3238 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC 0 0 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 12 maybe slow
    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 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` = 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` = 52 LIMIT 1 1 1 9 maybe slow
    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` <= 67 AND `FrontpagePage`.`nright` >= 68 ORDER BY `FrontpagePage`.`nleft` asc 3 3 6 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, 51, 52) ORDER BY `FrontpageContent`.`sorting` asc 2 2 7 maybe slow
    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, 51, 52) 3 3 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, 51, 52) 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` = 51 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 2 2 2
    SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'footer' AND `FrontpagePage`.`type` = 'folder' LIMIT 1 1 1 10 maybe slow
    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

    Query Explain:

    Click an "Explain" link above, to see the query explanation.

    ====
  • Timer
    +

    Memory

    Peak Memory Use 13.48 MB

    Message Memory use
    Component initialization 2.40 MB
    Controller action start 4.17 MB
    Controller render start 4.86 MB
    View render complete 7.38 MB

    Timers

    Total Request Time: 1146 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 115.69
    Event: Controller.initialize 120.27
    Event: Controller.startup 1.01
    Controller action 56.54
    Event: Controller.beforeRender 26.25
    » Processing toolbar data 25.91
    Rendering View 597.79
    » Event: View.beforeRender 0.08
    » Rendering APP/Plugin/Product/View/Spirits/search.ctp 280.30
    » Event: View.afterRender 0.19
    » Event: View.beforeLayout 0.05
    » Rendering APP/Plugin/Frontpage/View/Layouts/default.ctp 315.00
    » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp 3.38
    » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2 16.45
    » » Rendering APP/Plugin/Frontpage/View/Elements/document/header.ctp 2.09
    » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/navigation.ctp #3 1.23
    » » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp 0.46
    » » Rendering APP/Plugin/Frontpage/View/Elements/page/header.ctp #2 9.30
    » » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp #2 0.49
    » » » Rendering APP/Plugin/Frontpage/View/Elements/social_sharing.ctp 3.25
    » » » » Rendering APP/Plugin/Frontpage/View/Elements/share.ctp 2.31
    » » Rendering APP/Plugin/Frontpage/View/Elements/sidebar.ctp 185.89
    » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav.ctp 185.22
    » » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav_item.ctp 2.90
    » » Rendering APP/Plugin/Frontpage/View/Elements/page/footer.ctp 14.12
    » » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #4 13.18
    » » Rendering APP/Plugin/Frontpage/View/Elements/document/footer.ctp #2 1.36
    Event: View.afterLayout 0.00
    ====
  • Log
    +

    Logs

    There were no log entries made this request

    ====
  • Variables
    +

    View Variables

    • title_for_layoutAstrum Wine Cellars | Search < Bar
    • crumbs(array)
      • 0(array)
        • titleHome
        • url/
        • options(null)
      • 1(array)
        • titleBar
        • url/bar
        • options(null)
      • 2(array)
        • titleSearch
        • url/bar/search
        • options(null)
    • data(array)
      • 0(array)
        • Product(array)
          • titleLimoncello di Amalfi
          • codeIP0115
          • vintage(null)
          • id303
        • ProductImage(array)
          • 0(array)
            • titleTerra di Limoni Limoncello di Amalfi
            • image_id1940
            • product_id303
      • 1(array)
        • Product(array)
          • titleSambuca Fina
          • codeCZ001
          • vintage(null)
          • id304
        • ProductImage(array)
          • 0(array)
            • titleSambuca Fina, Colazingari - Lazio, Italy
            • image_id3948
            • product_id304
      • 2(array)
        • Product(array)
          • titleRhum Rhum Blanc Agricole (Green)
          • codeCV090
          • vintage(null)
          • id306
        • ProductImage(array)
          • 0(array)
            • titleRhum Rhum Blanc Agricole (Green), Capovilla - Veneto, Italy
            • image_id3753
            • product_id306
      • 3(array)
        • Product(array)
          • titleLiquore Nocino - Organic
          • codeVZ210
          • vintage(null)
          • id307
        • ProductImage(array)
          • 0(array)
            • titleVilla Zarri Nocino
            • image_id1896
            • product_id307
      • 4(array)
        • Product(array)
          • titleBrandy 10Yrs
          • codeVZ110
          • vintage(null)
          • id309
        • ProductImage(array)
          • 0(array)
            • titleVilla Zarri Brandy 10Yrs
            • image_id1899
            • product_id309
      • 5(array)
        • Product(array)
          • titleGrappa di Bassano
          • codeCV001
          • vintage(null)
          • id310
        • ProductImage(array)
          • 0(array)
            • titleCapovilla Grappa di Bassano
            • image_id3234
            • product_id310
      • 6(array)
        • Product(array)
          • titleGrappa di Amarone
          • codeCV003
          • vintage(null)
          • id312
        • ProductImage(array)
          • 0(array)
            • titleGrappa di Amarone
            • image_id3236
            • product_id312
      • 7(array)
        • Product(array)
          • titleGrappa di Moscato Giallo
          • codeCV004
          • vintage(null)
          • id313
        • ProductImage(array)
          • 0(array)
            • titleCapovilla Grappa Moscato giallo con astuccio
            • image_id3232
            • product_id313
      • 8(array)
        • Product(array)
          • titleGrappa di Brunello di Montalcino
          • codeCV015
          • vintage(null)
          • id314
        • ProductImage(array)
          • 0(array)
            • titleGrappa di Brunello
            • image_id3233
            • product_id314
      • 9(array)
        • Product(array)
          • titleGrappa di Nebbiolo
          • codeCV031
          • vintage(null)
          • id315
        • ProductImage(array)
          • 0(array)
            • titleGrappa di Barolo
            • image_id3235
            • product_id315
      • 10(array)
        • Product(array)
          • titleDistillato di Vino (Brandy)
          • codeCV016
          • vintage(null)
          • id316
        • ProductImage(array)
          • 0(array)
            • titleCapovilla Distillato di vino (Brandy)
            • image_id3237
            • product_id316
      • 11(array)
        • Product(array)
          • titleDistillato di Uva Isabella
          • codeCV005
          • vintage(null)
          • id317
        • ProductImage(array)
          • 0(array)
            • titleCapovilla Distillato di Uva Isabella
            • image_id3238
            • product_id317
    • ProductLib(object)
      • groupspirit
      • activePages(array)
        • 01
        • 151
        • 252
      • page(array)
        • FrontpagePage(array)
          • id52
          • parent_id51
          • nleft67
          • nright68
          • level0
          • sorting0
          • nameSearch
          • titleSearch
          • slugsearch
          • typepage
          • url/bar/search
          • external_url
          • folder_key(null)
          • alias_id(null)
          • meta_title
          • meta_keywords
          • meta_description
          • in_sitemap(true)
          • sitemap_modified2018-09-17 09:17:09
          • sitemap_changesmonthly
          • sitemap_priority0.8
          • is_homepage(false)
          • in_routes(true)
          • in_navigation(false)
          • logged_in_only(false)
          • logged_out_only(false)
          • user_landing_page(false)
          • overlay(false)
          • is_404page(false)
          • layout_filedefault
          • layout_file_recursive0
          • view_filedefault
          • view_file_recursive0
          • use_url_as_view0
          • meta_title_template(null)
          • options(null)
          • options_local(null)
          • tags
          • notes(null)
          • created2018-09-17 09:17:09
          • created_by(null)
          • modified2024-10-02 12:34:53
          • modified_by9
          • status1
        • Alias(array)
          • id(null)
          • parent_id(null)
          • nleft(null)
          • nright(null)
          • level(null)
          • sorting(null)
          • name(null)
          • title(null)
          • slug(null)
          • type(null)
          • url(null)
          • external_url(null)
          • folder_key(null)
          • alias_id(null)
          • meta_title(null)
          • meta_keywords(null)
          • meta_description(null)
          • in_sitemap(null)
          • sitemap_modified(null)
          • sitemap_changes(null)
          • sitemap_priority(null)
          • is_homepage(null)
          • in_routes(null)
          • in_navigation(null)
          • logged_in_only(null)
          • logged_out_only(null)
          • user_landing_page(null)
          • overlay(null)
          • is_404page(null)
          • layout_file(null)
          • layout_file_recursive(null)
          • view_file(null)
          • view_file_recursive(null)
          • use_url_as_view(null)
          • meta_title_template(null)
          • options(null)
          • options_local(null)
          • tags(null)
          • notes(null)
          • created(null)
          • created_by(null)
          • modified(null)
          • modified_by(null)
          • status(null)
      • $request->data(empty)
      • $this->validationErrors(array)
        • AppPreference(empty)
        • AppPreferenceExpanded(empty)
        • FrontpageRewrite(empty)
        • FrontpagePage(empty)
        • Tag(empty)
        • Aco(empty)
        • Aro(empty)
        • CreatedBy(empty)
        • ModifiedBy(empty)
        • Alias(empty)
        • ProductCategory(empty)
        • Product(empty)
        • ProductCategoriesProduct(empty)
        • ProductImage(empty)
      • Loaded Helpers(array)
        • 0Frontpage
        • 1Cache
        • 2AppTable
        • 3Form
        • 4Asset
        • 5AssetCompress
        • 6CookieCompliance
        • 7FrontpageSitemap
        • 8Html
        • 9Js
        • 10Pager
        • 11Text
        • 12Time
        • 13Number
        • 14GoogleMapV3
        • 15Avatar
        • 16SimpleGraph
        • 17Paginator
        • 18DebugTimer
        • 19Toolbar
        • 20AppJqueryEngine
        • 21Session
        • 22HtmlToolbar
      ====
    • Environment
      +

      App Constants

      Constant Value
      GWINE wine
      GSPIRIT spirit

      CakePHP Constants

      Constant Value
      APP /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/
      APP_DIR app
      APPLIBS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/Lib/
      CACHE /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/cache/
      CAKE /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/Cake/
      CAKE_CORE_INCLUDE_PATH /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib
      CORE_PATH /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/
      CAKE_VERSION 2.4.6
      CSS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/css/
      CSS_URL css/
      DS /
      FULL_BASE_URL https://www.astrumwinecellars.com
      IMAGES /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/img/
      IMAGES_URL img/
      JS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/js/
      JS_URL js/
      LOGS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/logs/
      ROOT /var/www/vhosts/astrumwinecellars.com/httpdocs/live
      TESTS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/Test/
      TMP /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/
      VENDORS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/vendors/
      WEBROOT_DIR webroot
      WWW_ROOT /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/

      PHP Environment

      Environment Variable Value
      Php Version 5.6.40
      User astrum
      Home /var/www/vhosts/astrumwinecellars.com
      Fcgi Role RESPONDER
      Redirect Redirect Unique Id ZwFdFPX0aX46DVrOc2HZ6wAAAUw
      Redirect Redirect Script Url /bar/search
      Redirect Redirect Script Uri https://www.astrumwinecellars.com/bar/search
      Redirect Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
      Redirect Redirect Passenger Compile Native Support Binary 0
      Redirect Redirect Passenger Download Native Support Binary 0
      Redirect Redirect Https on
      Redirect Redirect Status 200
      Redirect Unique Id ZwFdFPX0aX46DVrOc2HZ6wAAAUw
      Redirect Script Url /bar/search
      Redirect Script Uri https://www.astrumwinecellars.com/bar/search
      Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
      Redirect Passenger Compile Native Support Binary 0
      Redirect Passenger Download Native Support Binary 0
      Redirect Https on
      Redirect Status 200
      Unique Id ZwFdFPX0aX46DVrOc2HZ6wAAAUw
      Script Url /bar/search
      Script Uri https://www.astrumwinecellars.com/bar/search
      Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
      Passenger Compile Native Support Binary 0
      Passenger Download Native Support Binary 0
      Https on
      Proxy-nokeepalive 1
      Http Host www.astrumwinecellars.com
      Http X Real Ip 3.236.112.101
      Http X Accel Internal /internal-nginx-static-location
      Http Connection close
      Http User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
      Http Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      Http Accept Language en-US,en;q=0.5
      Http Accept Encoding br,gzip
      Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
      Server Signature
      Server Software Apache
      Server Name www.astrumwinecellars.com
      Server Addr 10.2.132.5
      Server Port 443
      Remote Addr 3.236.112.101
      Document Root /var/www/vhosts/astrumwinecellars.com/httpdocs/live
      Request Scheme https
      Context Prefix
      Context Document Root /var/www/vhosts/astrumwinecellars.com/httpdocs/live
      Server Admin root@localhost
      Script Filename /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/index.php
      Remote Port 45690
      Redirect Query String /bar/search
      Redirect Url /app/webroot/bar/search
      Gateway Interface CGI/1.1
      Server Protocol HTTP/1.0
      Request Method GET
      Query String /bar/search
      Request Uri /bar/search
      Script Name /app/webroot/index.php
      Php Self /app/webroot/index.php
      Request Time Float 1728142612.0209
      Request Time 1728142612
      ====
    • Include
      +

      Included Files

      Include Paths

      • 0/var/www/vhosts/astrumwinecellars.com/httpdocs/live/lib
      • 2/opt/plesk/php/5.6/share/pear
      • 3-> /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/Cake/

      Included Files

      • core(array)
        • Behavior(array)
          • 0CORE/Model/Behavior/ContainableBehavior.php
          • 1CORE/Model/Behavior/TreeBehavior.php
          • 2CORE/Model/Behavior/AclBehavior.php
        • Cache(array)
          • 0CORE/Cache/Cache.php
          • 1CORE/Cache/Engine/FileEngine.php
          • 2CORE/Cache/CacheEngine.php
        • Component(array)
          • 0CORE/Controller/Component/SessionComponent.php
          • 1CORE/Controller/Component/RequestHandlerComponent.php
          • 2CORE/Controller/Component/CookieComponent.php
          • 3CORE/Controller/Component/AuthComponent.php
          • 4CORE/Controller/Component/PaginatorComponent.php
        • Config(array)
          • 0CORE/Config/config.php
        • Configure(array)
          • 0CORE/Configure/PhpReader.php
          • 1CORE/Configure/ConfigReaderInterface.php
        • Controller(array)
          • 0CORE/Controller/Controller.php
          • 1CORE/Controller/ComponentCollection.php
          • 2CORE/Controller/Component.php
        • Datasource(array)
          • 0CORE/Model/Datasource/CakeSession.php
          • 1CORE/Model/Datasource/Database/Mysql.php
          • 2CORE/Model/Datasource/DboSource.php
          • 3CORE/Model/Datasource/DataSource.php
        • Error(array)
          • 0CORE/Error/exceptions.php
          • 1CORE/Error/ErrorHandler.php
        • I18n(array)
          • 0CORE/I18n/I18n.php
          • 1CORE/I18n/L10n.php
        • Log(array)
          • 0CORE/Log/CakeLog.php
          • 1CORE/Log/LogEngineCollection.php
          • 2CORE/Log/Engine/FileLog.php
          • 3CORE/Log/Engine/BaseLog.php
          • 4CORE/Log/CakeLogInterface.php
        • Model(array)
          • 0CORE/Model/Model.php
          • 1CORE/Model/BehaviorCollection.php
          • 2CORE/Model/ModelBehavior.php
          • 3CORE/Model/ConnectionManager.php
          • 4CORE/Model/Aco.php
          • 5CORE/Model/AclNode.php
          • 6CORE/Model/Aro.php
        • Network(array)
          • 0CORE/Network/CakeRequest.php
          • 1CORE/Network/CakeResponse.php
        • Other(array)
          • 0CORE/bootstrap.php
          • 1CORE/basics.php
          • 2CORE/Core/App.php
          • 3CORE/Core/Configure.php
          • 4CORE/Core/CakePlugin.php
          • 5CORE/Event/CakeEventListener.php
          • 6CORE/Event/CakeEvent.php
          • 7CORE/Event/CakeEventManager.php
          • 8CORE/Core/Object.php
        • Routing(array)
          • 0CORE/Routing/Dispatcher.php
          • 1CORE/Routing/Filter/AssetDispatcher.php
          • 2CORE/Routing/DispatcherFilter.php
          • 3CORE/Routing/Filter/CacheDispatcher.php
          • 4CORE/Routing/Router.php
          • 5CORE/Routing/Route/CakeRoute.php
        • Utility(array)
          • 0CORE/Utility/Hash.php
          • 1CORE/Utility/Inflector.php
          • 2CORE/Utility/ObjectCollection.php
          • 3CORE/Utility/CakeNumber.php
          • 4CORE/Utility/Debugger.php
          • 5CORE/Utility/String.php
          • 6CORE/Utility/ClassRegistry.php
          • 7CORE/Utility/Set.php
        • View(array)
          • 0CORE/View/HelperCollection.php
      • app(array)
        • Config(array)
          • 0APP/Config/core.php
          • 1APP/Config/bootstrap.php
          • 2APP/Config/config.php
          • 3APP/Config/routes.php
          • 4APP/Config/database.php
        • Other(array)
          • 0APP/webroot/index.php
      • plugins(array)
        • AclBase(array)
          • Behavior(array)
            • 0AclBase/Model/Behavior/AclBaseBehavior.php
        • Admin(array)
          • Config(array)
            • 0Admin/Config/bootstrap.php
            • 1Admin/Config/routes.php
        • App(array)
          • Controller(array)
            • 0App/Controller/AppController.php
          • Model(array)
            • 0App/Model/AppPreference.php
            • 1App/Model/AppModel.php
            • 2App/Model/AppPreferenceExpanded.php
          • Component(array)
            • 0App/Controller/Component/AppComponent.php
        • AppAdmin(array)
          • Config(array)
            • 0AppAdmin/Config/bootstrap.php
            • 1AppAdmin/Config/routes.php
        • Asset(array)
          • Config(array)
            • 0Asset/Config/bootstrap.php
            • 1Asset/Config/routes.php
        • AssetAdmin(array)
          • Config(array)
            • 0AssetAdmin/Config/bootstrap.php
            • 1AssetAdmin/Config/routes.php
        • AssetCompress(array)
          • Config(array)
            • 0AssetCompress/Config/routes.php
        • Attachment(array)
          • Config(array)
            • 0Attachment/Config/routes.php
        • CakePdf(array)
          • Config(array)
            • 0CakePdf/Config/bootstrap.php
        • Config(array)
          • Config(array)
            • 0Config/Controller/Component/IniComponent.php
        • ContactAdmin(array)
          • Config(array)
            • 0ContactAdmin/Config/bootstrap.php
            • 1ContactAdmin/Config/routes.php
        • CookieComplianceAdmin(array)
          • Config(array)
            • 0CookieComplianceAdmin/Config/bootstrap.php
            • 1CookieComplianceAdmin/Config/routes.php
        • DebugKit(array)
          • Component(array)
            • 0DebugKit/Controller/Component/ToolbarComponent.php
          • Plugin(array)
            • 0DebugKit/Lib/DebugMemory.php
            • 1DebugKit/Lib/Panel/HistoryPanel.php
            • 2DebugKit/Lib/DebugPanel.php
            • 3DebugKit/Lib/Panel/SessionPanel.php
            • 4DebugKit/Lib/Panel/RequestPanel.php
            • 5DebugKit/Lib/Panel/SqlLogPanel.php
            • 6DebugKit/Lib/Panel/TimerPanel.php
            • 7DebugKit/Lib/Panel/LogPanel.php
            • 8DebugKit/Lib/Log/Engine/DebugKitLog.php
            • 9DebugKit/Lib/Panel/VariablesPanel.php
            • 10DebugKit/Lib/Panel/EnvironmentPanel.php
            • 11DebugKit/Lib/Panel/IncludePanel.php
            • 12DebugKit/Lib/DebugTimer.php
        • Enews(array)
          • Config(array)
            • 0Enews/Config/bootstrap.php
            • 1Enews/Config/routes.php
        • EnewsAdmin(array)
          • Config(array)
            • 0EnewsAdmin/Config/bootstrap.php
            • 1EnewsAdmin/Config/routes.php
        • Expandable(array)
          • Behavior(array)
            • 0Expandable/Model/Behavior/ExpandableBehavior.php
        • Frontpage(array)
          • Config(array)
            • 0Frontpage/Config/bootstrap.php
            • 1Frontpage/Config/routes.php
          • Plugin(array)
            • 0Frontpage/Lib/Routing/Route/FrontpagePageRoute.php
          • Component(array)
            • 0Frontpage/Controller/Component/FrontpageComponent.php
          • Model(array)
            • 0Frontpage/Model/FrontpagePage.php
            • 1Frontpage/Model/FrontpageAppModel.php
            • 2Frontpage/Model/FrontpageRewrite.php
          • Behavior(array)
            • 0Frontpage/Model/Behavior/FrontpagePageBehavior.php
        • FrontpageAdmin(array)
          • Config(array)
            • 0FrontpageAdmin/Config/bootstrap.php
            • 1FrontpageAdmin/Config/routes.php
        • FrontpageUser(array)
          • Model(array)
            • 0FrontpageUser/Model/FrontpageUser.php
            • 1FrontpageUser/Model/FrontpageUserAppModel.php
        • FrontpageUserAdmin(array)
          • Config(array)
            • 0FrontpageUserAdmin/Config/bootstrap.php
            • 1FrontpageUserAdmin/Config/routes.php
        • Gapi(array)
          • Config(array)
            • 0Gapi/Config/routes.php
        • GeographyAdmin(array)
          • Config(array)
            • 0GeographyAdmin/Config/bootstrap.php
            • 1GeographyAdmin/Config/routes.php
        • HabtmCounterCache(array)
          • Behavior(array)
            • 0HabtmCounterCache/Model/Behavior/HabtmCounterCacheBehavior.php
        • News(array)
          • Config(array)
            • 0News/Config/bootstrap.php
        • NewsAdmin(array)
          • Config(array)
            • 0NewsAdmin/Config/bootstrap.php
            • 1NewsAdmin/Config/routes.php
        • Product(array)
          • Config(array)
            • 0Product/Config/bootstrap.php
          • Controller(array)
            • 0Product/Controller/SpiritsController.php
            • 1Product/Controller/ProductsController.php
            • 2Product/Controller/ProductAppController.php
          • Plugin(array)
            • 0Product/Lib/ProductLib.php
          • Model(array)
            • 0Product/Model/ProductCategory.php
            • 1Product/Model/ProductAppModel.php
            • 2Product/Model/Product.php
            • 3Product/Model/ProductImage.php
        • ProductAdmin(array)
          • Config(array)
            • 0ProductAdmin/Config/bootstrap.php
            • 1ProductAdmin/Config/routes.php
        • Quote(array)
          • Config(array)
            • 0Quote/Config/bootstrap.php
        • QuoteAdmin(array)
          • Config(array)
            • 0QuoteAdmin/Config/bootstrap.php
            • 1QuoteAdmin/Config/routes.php
        • Slug(array)
          • Behavior(array)
            • 0Slug/Model/Behavior/SluggableBehavior.php
        • Sorting(array)
          • Behavior(array)
            • 0Sorting/Model/Behavior/IncrementalBehavior.php
        • Tag(array)
          • Behavior(array)
            • 0Tag/Model/Behavior/TaggableBehavior.php
          • Model(array)
            • 0Tag/Model/Tag.php
            • 1Tag/Model/TagAppModel.php
        • UniqueKey(array)
          • Behavior(array)
            • 0UniqueKey/Model/Behavior/UniqueKeyBehavior.php
        • User(array)
          • Behavior(array)
            • 0User/Model/Behavior/LoggingBehavior.php
          • Model(array)
            • 0User/Model/User.php
        • UserAdmin(array)
          • Config(array)
            • 0UserAdmin/Config/bootstrap.php
            • 1UserAdmin/Config/routes.php
      ====