1 to 5 of 5
-
- History
- Session
-
Request +
Request
Cake Params
- pluginproduct
- controllerproducts
- actionsearch
- named(array)
- produceradami
- category(null)
- country(null)
- region(null)
- grape_variety(null)
- limit12
- pass(empty)
- isAjax(false)
- paging(array)
- Product(array)
- page1
- current5
- count5
- prevPage(false)
- nextPage(false)
- pageCount1
- order(array)
- Product.sortingasc
- limit12
- options(array)
- limit12
- paramTypenamed
- Product(array)
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/products/search
- defaults(array)
- pluginproduct
- controllerproducts
- actionsearch
- template/products/search/*
==== -
Sql Log +
Sql Logs
default
Total Time: 22 ms
Total Queries: 50 queriesQuery Affected Num. rows Took (ms) Actions SELECT `AppPreference`.`id`, `AppPreference`.`application_name`, `AppPreference`.`email`, `AppPreference`.`mail_recipients`, `AppPreference`.`logo_id`, `AppPreference`.`intro_top`, `AppPreference`.`intro_detail`, `AppPreference`.`intro_link_id`, `AppPreference`.`404_not_found_page_id`, `AppPreference`.`smtp_host`, `AppPreference`.`smtp_port`, `AppPreference`.`smtp_username`, `AppPreference`.`smtp_password`, `AppPreference`.`meta_title`, `AppPreference`.`meta_show_title`, `AppPreference`.`meta_reverse_title`, `AppPreference`.`pdf_cover_details`, `AppPreference`.`pdf_inside_cover_file`, `AppPreference`.`pdf_introduction`, `AppPreference`.`pdf_details`, `AppPreference`.`pdf_terms_and_conditions`, `AppPreference`.`google_analytics`, `AppPreference`.`ga_username`, `AppPreference`.`ga_password`, `AppPreference`.`ga_report_id`, `AppPreference`.`userlog_record_limit`, `AppPreference`.`userlog_time_limit`, `AppPreference`.`created`, `AppPreference`.`modified` FROM `astrum`.`oc_app_preferences` AS `AppPreference` WHERE 1 = 1 LIMIT 1 1 1 0 SELECT `AppPreferenceExpanded`.`id`, `AppPreferenceExpanded`.`app_preference_id`, `AppPreferenceExpanded`.`key`, `AppPreferenceExpanded`.`value`, `AppPreferenceExpanded`.`created`, `AppPreferenceExpanded`.`modified` FROM `astrum`.`oc_app_preferences_extended` AS `AppPreferenceExpanded` WHERE `AppPreferenceExpanded`.`app_preference_id` = (1) 10 10 0 SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` = '/products/search/producer:adami' AND `FrontpageRewrite`.`status` = 1 LIMIT 1 0 0 0 SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` LIKE '%*' AND `FrontpageRewrite`.`status` = 1 0 0 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`url` = '/products/search' LIMIT 1 1 1 0 SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 32 LIMIT 1 1 1 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE 1 = 1 AND `FrontpagePage`.`nleft` <= 61 AND `FrontpagePage`.`nright` >= 62 ORDER BY `FrontpagePage`.`nleft` asc 3 3 0 SELECT `ProductCategory`.`id` FROM `astrum`.`oc_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`group` = 'wine' 12 12 0 SELECT `ProductCategoriesProduct`.`product_id` FROM `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` WHERE `product_category_id` IN (1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13) 1501 1501 1 SELECT `ProductProducer`.`id` FROM `astrum`.`oc_product_producers` AS `ProductProducer` WHERE `ProductProducer`.`slug` = 'adami' AND `ProductProducer`.`status` = '1' LIMIT 1 1 1 0 SELECT `Product`.`title`, `Product`.`code`, `Product`.`vintage`, `Product`.`id` FROM `astrum`.`oc_products` AS `Product` WHERE `Product`.`status` = '1' AND `Product`.`id` IN (31, 32, 33, 34, 35, 36, 37, 38, 39, 41, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 157, 158, 159, 160, 163, 164, 165, 166, 167, 168, 169, 171, 172, 173, 174, 176, 177, 178, 179, 180, 181, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 232, 233, 234, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 300, 301, 302, 307, 309, 327, 328, 329, 330, 332, 333, 334, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 354, 355, 356, 357, 358, 359, 360, 361, 363, 366, 367, 369, 370, 371, 372, 373, 374, 375, 376, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 393, 394, 396, 397, 398, 399, 400, 402, 403, 404, 405, 407, 408, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 426, 427, 428, 429, 430, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 469, 470, 471, 472, 473, 474, 476, 477, 478, 479, 480, 481, 482, 483, 484, 487, 488, 489, 490, 491, 492, 493, 494, 495, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 519, 520, 521, 522, 523, 524, 525, 526, 527, 529, 530, 531, 532, 533, 534, 535, 536, 537, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 554, 555, 556, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 586, 587, 588, 589, 590, 591, 593, 594, 595, 596, 597, 598, 599, 600, 605, 606, 607, 608, 609, 617, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 638, 639, 640, 641, 642, 643, 646, 648, 649, 650, 651, 653, 654, 655, 656, 657, 658, 659, 660, 661, 664, 665, 667, 668, 669, 670, 671, 672, 673, 674, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 693, 696, 697, 702, 703, 704, 705, 706, 707, 708, 709, 710, 721, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 736, 737, 742, 743, 744, 745, 746, 747, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 779, 780, 782, 783, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 813, 814, 815, 816, 834, 835, 836, 837, 838, 839, 840, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 854, 855, 865, 866, 867, 868, 869, 870, 871, 873, 874, 876, 877, 880, 882, 884, 885, 886, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1047, 1048, 1049, 1050, 1051, 1052, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1077, 1078, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1149, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1294, 1295, 1296, 1297, 1298, 1299, 1300) AND `Product`.`product_producer_id` = 12 ORDER BY `Product`.`sorting` asc LIMIT 12 5 5 1 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 (189, 190, 191, 192, 949) ORDER BY `ProductImage`.`sorting` asc 5 5 0 SELECT COUNT(*) AS `count` FROM `astrum`.`oc_products` AS `Product` WHERE `Product`.`status` = '1' AND `Product`.`id` IN (31, 32, 33, 34, 35, 36, 37, 38, 39, 41, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 157, 158, 159, 160, 163, 164, 165, 166, 167, 168, 169, 171, 172, 173, 174, 176, 177, 178, 179, 180, 181, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 232, 233, 234, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 300, 301, 302, 307, 309, 327, 328, 329, 330, 332, 333, 334, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 354, 355, 356, 357, 358, 359, 360, 361, 363, 366, 367, 369, 370, 371, 372, 373, 374, 375, 376, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 393, 394, 396, 397, 398, 399, 400, 402, 403, 404, 405, 407, 408, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 426, 427, 428, 429, 430, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 469, 470, 471, 472, 473, 474, 476, 477, 478, 479, 480, 481, 482, 483, 484, 487, 488, 489, 490, 491, 492, 493, 494, 495, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 519, 520, 521, 522, 523, 524, 525, 526, 527, 529, 530, 531, 532, 533, 534, 535, 536, 537, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 554, 555, 556, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 586, 587, 588, 589, 590, 591, 593, 594, 595, 596, 597, 598, 599, 600, 605, 606, 607, 608, 609, 617, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 638, 639, 640, 641, 642, 643, 646, 648, 649, 650, 651, 653, 654, 655, 656, 657, 658, 659, 660, 661, 664, 665, 667, 668, 669, 670, 671, 672, 673, 674, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 693, 696, 697, 702, 703, 704, 705, 706, 707, 708, 709, 710, 721, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 736, 737, 742, 743, 744, 745, 746, 747, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 779, 780, 782, 783, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 813, 814, 815, 816, 834, 835, 836, 837, 838, 839, 840, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 854, 855, 865, 866, 867, 868, 869, 870, 871, 873, 874, 876, 877, 880, 882, 884, 885, 886, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1047, 1048, 1049, 1050, 1051, 1052, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1077, 1078, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1149, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1294, 1295, 1296, 1297, 1298, 1299, 1300) AND `Product`.`product_producer_id` = 12 1 1 1 SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 1813 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` = 1813 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` = 1813 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` = 1812 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` = 1812 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` = 1812 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` = 1805 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` = 1805 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` = 1805 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` = 1808 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` = 1808 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` = 1808 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` = 2902 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` = 2902 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` = 2902 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 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 1 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 7 7 1 maybe slow SELECT `CookieCompliance`.`id`, `CookieCompliance`.`content`, `CookieCompliance`.`page_id`, `CookieCompliance`.`created`, `CookieCompliance`.`created_by`, `CookieCompliance`.`modified`, `CookieCompliance`.`modified_by`, `CookieCompliance`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_cookie_compliances` AS `CookieCompliance` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`CookieCompliance`.`page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`CookieCompliance`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`CookieCompliance`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 LIMIT 1 1 1 1 SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 3503 LIMIT 1 1 1 1 SELECT `AssetCategory`.`id`, `AssetCategory`.`name`, `AssetCategory`.`created`, `AssetCategory`.`created_by`, `AssetCategory`.`modified`, `AssetCategory`.`modified_by`, `AssetCategoriesAsset`.`id`, `AssetCategoriesAsset`.`asset_id`, `AssetCategoriesAsset`.`asset_category_id` FROM `astrum`.`oc_asset_categories` AS `AssetCategory` JOIN `astrum`.`oc_asset_categories_assets` AS `AssetCategoriesAsset` ON (`AssetCategoriesAsset`.`asset_id` = 3503 AND `AssetCategoriesAsset`.`asset_category_id` = `AssetCategory`.`id`) 0 0 0 SELECT `AssetTag`.`id`, `AssetTag`.`name`, `AssetTag`.`slug`, `AssetTag`.`used`, `AssetTag`.`created`, `AssetTag`.`created_by`, `AssetTag`.`modified`, `AssetTag`.`modified_by`, `AssetTagsAsset`.`id`, `AssetTagsAsset`.`asset_id`, `AssetTagsAsset`.`asset_tag_id`, `AssetTagsAsset`.`created`, `AssetTagsAsset`.`modified`, `AssetTagsAsset`.`sorting`, `AssetTagsAsset`.`created_by`, `AssetTagsAsset`.`modified_by` FROM `astrum`.`oc_asset_tags` AS `AssetTag` JOIN `astrum`.`oc_asset_tags_assets` AS `AssetTagsAsset` ON (`AssetTagsAsset`.`asset_id` = 3503 AND `AssetTagsAsset`.`asset_tag_id` = `AssetTag`.`id`) ORDER BY `AssetTagsAsset`.`sorting` ASC 0 0 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 32 LIMIT 1 1 1 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpagePage`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpagePage`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpagePage`.`nleft` <= 61 AND `FrontpagePage`.`nright` >= 62 ORDER BY `FrontpagePage`.`nleft` asc 3 3 1 maybe slow SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_content_category_id`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_link`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`title`, `FrontpageContent`.`subtitle`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`quote_id`, `FrontpageContent`.`embed`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` WHERE `FrontpageContent`.`frontpage_page_id` IN (1, 12, 32) ORDER BY `FrontpageContent`.`sorting` asc 2 2 0 SELECT `FrontpageRoute`.`id`, `FrontpageRoute`.`route`, `FrontpageRoute`.`plugin`, `FrontpageRoute`.`controller`, `FrontpageRoute`.`action`, `FrontpageRoute`.`named`, `FrontpageRoute`.`pass`, `FrontpageRoute`.`frontpage_page_id`, `FrontpageRoute`.`route_class`, `FrontpageRoute`.`status`, `FrontpageRoute`.`sorting`, `FrontpageRoute`.`created`, `FrontpageRoute`.`created_by`, `FrontpageRoute`.`modified`, `FrontpageRoute`.`modified_by` FROM `astrum`.`oc_frontpage_routes` AS `FrontpageRoute` WHERE `FrontpageRoute`.`frontpage_page_id` IN (1, 12, 32) 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, 12, 32) AND `TagObject`.`tag_id` = `Tag`.`id`) WHERE `TagObject`.`object` = 'FrontpagePage' ORDER BY `TagObject`.`sorting` asc 0 0 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 12 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 2 2 0 SELECT `ProductCategory`.`id`, `ProductCategory`.`slug`, (CONCAT(`ProductCategory`.`title`, " (", `ProductCategory`.`product_count`, ")")) AS `ProductCategory__combo_title` FROM `astrum`.`oc_product_categories` AS `ProductCategory` WHERE `ProductCategory`.`status` = '1' AND `ProductCategory`.`group` = 'wine' ORDER BY `ProductCategory`.`sorting` asc 10 10 0 SELECT `ProductCategoriesProduct`.`product_id` FROM `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` WHERE `product_category_id` IN (4, 2, 3, 1, 5, 9, 10, 11, 12, 13) 1485 1485 1 SELECT `Product`.`geography_region_id`, `Product`.`code`, `Product`.`title`, `ProductProducer`.`name`, `ProductDistributor`.`title`, `ProductProducer`.`id`, `ProductDistributor`.`id` FROM `astrum`.`oc_products` AS `Product` LEFT JOIN `astrum`.`oc_product_producers` AS `ProductProducer` ON (`Product`.`product_producer_id` = `ProductProducer`.`id`) LEFT JOIN `astrum`.`oc_product_distributors` AS `ProductDistributor` ON (`Product`.`product_distributor_id` = `ProductDistributor`.`id`) WHERE `Product`.`status` = '1' AND `Product`.`id` IN (31, 32, 33, 34, 35, 36, 37, 38, 39, 41, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 157, 158, 159, 160, 163, 164, 165, 166, 167, 168, 169, 171, 172, 173, 174, 176, 177, 178, 179, 180, 181, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 201, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 232, 233, 234, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 300, 301, 302, 307, 309, 327, 328, 329, 330, 332, 333, 334, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 354, 355, 356, 357, 358, 359, 360, 361, 363, 366, 367, 369, 370, 371, 372, 373, 374, 375, 376, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 393, 394, 396, 397, 398, 399, 400, 402, 403, 404, 405, 407, 408, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 426, 427, 428, 429, 430, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 469, 470, 471, 472, 476, 477, 478, 479, 480, 481, 482, 483, 484, 487, 488, 489, 490, 491, 492, 493, 494, 495, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 519, 520, 521, 522, 523, 524, 525, 526, 527, 529, 532, 533, 534, 535, 536, 537, 539, 540, 541, 543, 544, 545, 546, 547, 548, 549, 550, 554, 555, 556, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576, 578, 579, 580, 581, 582, 583, 584, 586, 587, 588, 589, 590, 591, 593, 594, 595, 596, 597, 598, 599, 600, 605, 606, 607, 608, 609, 617, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 638, 639, 640, 641, 642, 643, 646, 648, 649, 650, 651, 653, 654, 655, 656, 657, 658, 659, 660, 661, 664, 665, 667, 668, 669, 670, 671, 672, 673, 674, 676, 677, 678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 693, 696, 697, 702, 703, 704, 705, 706, 707, 708, 709, 710, 721, 724, 725, 726, 727, 728, 729, 730, 731, 732, 733, 734, 736, 737, 742, 743, 744, 745, 746, 747, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 762, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 779, 780, 782, 783, 788, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 813, 814, 815, 816, 834, 835, 836, 837, 838, 839, 840, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 854, 855, 865, 866, 867, 868, 869, 870, 871, 873, 874, 876, 877, 880, 882, 884, 885, 886, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1047, 1048, 1049, 1050, 1051, 1052, 1054, 1055, 1056, 1057, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1077, 1078, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1149, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289, 1294, 1295, 1296, 1297, 1298, 1299, 1300) ORDER BY `Product`.`title` asc 397 397 6 SELECT `GeographyRegion`.`id`, `GeographyRegion`.`geography_country_id` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` WHERE `id` IN (56, 25, 19, 32, 13, 21, 18, 67, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 68, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 55, 1, 11, 31, 48, 33, 49, 28, 40, 20, 43, 5) 43 43 0 SELECT `GeographyRegion`.`id`, `GeographyRegion`.`slug`, `GeographyRegion`.`title`, `GeographyCountry`.`id`, `GeographyCountry`.`slug`, `GeographyCountry`.`title`, `GeographyCountry`.`image_area_coordinates`, `GeographyCountry`.`image_area_coordinates_spirit` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` LEFT JOIN `astrum`.`oc_geography_countries` AS `GeographyCountry` ON (`GeographyRegion`.`geography_country_id` = `GeographyCountry`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`GeographyRegion`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`GeographyRegion`.`modified_by` = `ModifiedBy`.`id`) WHERE `GeographyRegion`.`id` IN (56, 25, 19, 32, 13, 21, 18, 67, 17, 7, 65, 59, 60, 27, 26, 8, 57, 16, 68, 15, 51, 62, 52, 4, 23, 29, 2, 39, 24, 61, 64, 55, 1, 11, 31, 48, 33, 49, 28, 40, 20, 43, 5) AND `GeographyRegion`.`status` = '1' AND `GeographyCountry`.`status` = '1' ORDER BY `GeographyCountry`.`title` asc, `GeographyRegion`.`sorting` asc 43 43 1 SELECT `ProductGrapeVariety`.`slug`, (CONCAT(`ProductGrapeVariety`.`title`, " (", `ProductGrapeVariety`.`product_count`, ")")) AS `ProductGrapeVariety__combo_title` FROM `astrum`.`oc_product_grape_varieties` AS `ProductGrapeVariety` WHERE `ProductGrapeVariety`.`status` = '1' ORDER BY `ProductGrapeVariety`.`title` asc 214 214 1 SELECT `FrontpagePage`.`id` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'footer' AND `FrontpagePage`.`type` = 'folder' LIMIT 1 1 1 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`external_url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`logged_in_only`, `Alias`.`logged_out_only`, `Alias`.`user_landing_page`, `Alias`.`overlay`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 2 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 3 3 1 maybe slow Query Explain:
==== -
Timer +
Memory
Peak Memory Use 19.98 MB
Message Memory use Component initialization 4.93 MB Controller action start 8.55 MB Controller render start 9.67 MB View render complete 15.05 MB Timers
Total Request Time: 315 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 32.81 Event: Controller.initialize 28.04 Event: Controller.startup 0.81 Controller action 28.09 Event: Controller.beforeRender 21.29 » Processing toolbar data 20.97 Rendering View 107.35 » Event: View.beforeRender 0.08 » Rendering APP/Plugin/Product/View/Products/search.ctp 22.37 » Event: View.afterRender 0.07 » Event: View.beforeLayout 0.04 » Rendering APP/Plugin/Frontpage/View/Layouts/product-filters.ctp 83.35 » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp 2.76 » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2 2.75 » » Rendering APP/Plugin/Frontpage/View/Elements/document/header.ctp 1.33 » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/navigation.ctp #3 0.46 » » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp 0.18 » » Rendering APP/Plugin/Frontpage/View/Elements/page/header.ctp #2 5.87 » » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp #2 0.18 » » » Rendering APP/Plugin/Frontpage/View/Elements/social_sharing.ctp 1.92 » » » » Rendering APP/Plugin/Frontpage/View/Elements/share.ctp 1.45 » » Rendering APP/Plugin/Frontpage/View/Elements/sidebar.ctp 11.20 » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav.ctp 10.93 » » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav_item.ctp 1.12 » » Rendering APP/Plugin/Product/View/Elements/product/filters.ctp 48.40 » » Rendering APP/Plugin/Frontpage/View/Elements/page/footer.ctp 4.12 » » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #4 3.40 » » Rendering APP/Plugin/Frontpage/View/Elements/document/footer.ctp #2 1.41 Event: View.afterLayout 0.00 ==== - Log
-
Variables +
View Variables
- title_for_layoutAstrum Wine Cellars | Search < Wine
- crumbs(array)
- 0(array)
- titleHome
- url/
- options(null)
- 1(array)
- titleWine
- url/products
- options(null)
- 2(array)
- titleSearch
- url/products/search
- options(null)
- 0(array)
- data(array)
- 0(array)
- Product(array)
- titleValdobbiadene DOCG Prosecco Superiore 'Bosco di Gica'
- codeAD7024
- vintage(null)
- id189
- ProductImage(array)
- 0(array)
- titleBosca di Gica
- image_id1813
- product_id189
- 0(array)
- Product(array)
- 1(array)
- Product(array)
- titleValdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Half Bottle
- codeAD7124
- vintage(null)
- id190
- ProductImage(array)
- 0(array)
- titleBosca di Gica
- image_id1812
- product_id190
- 0(array)
- Product(array)
- 2(array)
- Product(array)
- titleValdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Magnum
- codeAD7524
- vintage(null)
- id191
- ProductImage(array)
- 0(array)
- titleProsecco Bosca de Gica Magnum
- image_id1805
- product_id191
- 0(array)
- Product(array)
- 3(array)
- Product(array)
- titleValdobbiadene DOCG Prosecco Superiore Rive di Farra di Soligo 'Col Credas'
- codeAD8923
- vintage2023
- id192
- ProductImage(array)
- 0(array)
- titleCol Credas
- image_id1808
- product_id192
- 0(array)
- Product(array)
- 4(array)
- Product(array)
- titleValdobbiadene DOCG Prosecco Superiore Sui Lieviti Brut Nature 'Col Fondo'
- codeAD6022
- vintage2022
- id949
- ProductImage(array)
- 0(array)
- titleAdami Prosecco Col Fondo
- image_id2902
- product_id949
- 0(array)
- Product(array)
- 0(array)
- ProductLib(object)
- data(array)
- categories(array)
- 0(array)
- ProductCategory(array)
- id4
- slugsparkling-wine
- combo_titleSparkling Wine (21)
- ProductCategory(array)
- 1(array)
- ProductCategory(array)
- id2
- slugwhite-wine
- combo_titleWhite Wine (141)
- ProductCategory(array)
- 2(array)
- ProductCategory(array)
- id3
- slugrose-wine
- combo_titleRosé Wine (7)
- ProductCategory(array)
- 3(array)
- ProductCategory(array)
- id1
- slugred-wine
- combo_titleRed Wine (202)
- ProductCategory(array)
- 4(array)
- ProductCategory(array)
- id5
- slugdessert-wine
- combo_titleDessert Wine (17)
- ProductCategory(array)
- 5(array)
- ProductCategory(array)
- id9
- slugorganic
- combo_titleOrganic (55)
- ProductCategory(array)
- 6(array)
- ProductCategory(array)
- id10
- slugbiodynamic
- combo_titleBiodynamic (2)
- ProductCategory(array)
- 7(array)
- ProductCategory(array)
- id11
- slugorange-wine
- combo_titleOrange Wine (1)
- ProductCategory(array)
- 8(array)
- ProductCategory(array)
- id12
- slugvegan
- combo_titleVegan (272)
- ProductCategory(array)
- 9(array)
- ProductCategory(array)
- id13
- slugnatural
- combo_titleNatural (4)
- ProductCategory(array)
- 0(array)
- categoryOptions(array)
- sparkling-wineSparkling Wine (21)
- white-wineWhite Wine (141)
- rose-wineRosé Wine (7)
- red-wineRed Wine (202)
- dessert-wineDessert Wine (17)
- organicOrganic (55)
- biodynamicBiodynamic (2)
- orange-wineOrange Wine (1)
- veganVegan (272)
- naturalNatural (4)
- productsOptions(array)
- TF0319 Cornas 'Les Versantes', Thomas Farge
- TF0121 Saint-Joseph Rouge 'Grand Angle', Thomas Farge
- LL0523Aglianico Beneventano, Lapilli
- PI0719Aglianico Quirico, Pietracupa
- BZ0122Albana di Romagna 'Isola', Balìa di Zola
- LA0123Albariño, Lagar de Costa
- LA0823Albariño Natural, Lagar de Costa
- LA0221Albariño Tradición, Lagar de Costa
- ET4520Alta Langa DOCG Extra Brut, Ettore Germano
- PG0320Alta Valle della Greve 'Capogatto', Poggio Scalette
- PG0220Alta Valle della Greve 'Il Carbonaione', Poggio Scalette
- PG0420Alta Valle della Greve 'Piantonaia', Poggio Scalette
- LR0719Amarone della Valpolicella Classico, L'Arco
- SP0419Amarone della Valpolicella Classico Sant'Urbano, Speri
- SP0407Amarone della Valpolicella Classico Sant'Urbano, Speri
- SP0404Amarone della Valpolicella Classico Sant'Urbano, Speri
- SP0411Amarone della Valpolicella Classico Sant'Urbano, Speri
- MN0717Amarone della Valpolicella Riserva, Monte Tondo
- LR0220Arcum, L'Arco
- VI0819Asolo Prosecco Superiore DOCG Extra Dry , Vinvita
- PB0220Barbaresco, Produttori del Barbaresco
- PB1520Barbaresco - Magnum, Produttori del Barbaresco
- PB1620Barbaresco Double - Magnum, Produttori del Barbaresco
- PB0519Barbaresco Riserva 'Asili', Produttori del Barbaresco
- PB3316Barbaresco Riserva 'Don Fiorino', Produttori del Barbaresco
- PB0319Barbaresco Riserva 'Montefico' , Produttori del Barbaresco
- PB0719Barbaresco Riserva 'Montestefano' , Produttori del Barbaresco
- PB1219Barbaresco Riserva 'Muncagota' , Produttori del Barbaresco
- PB0419Barbaresco Riserva 'Ovello' , Produttori del Barbaresco
- PB0819Barbaresco Riserva 'Pajé' , Produttori del Barbaresco
- PB0619Barbaresco Riserva 'Pora', Produttori del Barbaresco
- PB0919Barbaresco Riserva 'Rabajà', Produttori del Barbaresco
- PB1119Barbaresco Riserva 'Rio Sordo' , Produttori del Barbaresco
- FR1021Barbera D'Alba, Francesco Rinaldi
- FB1022Barbera d'Asti, Folli & Benato
- OD0322Barbera d'Asti Superiore Nizza , Oddero
- FR0119Barolo , Francesco Rinaldi
- AR0218Barolo 'Undicicomuni', ArnaldoRivera
- FR0217Barolo Brunate, Francesco Rinaldi
- OD1018Barolo Brunate, Oddero
- OD4518Barolo Brunate - Magnum , Oddero
- AR0916Barolo Bussia, ArnaldoRivera
- FR0317Barolo Cannubi, Francesco Rinaldi
- AR0716Barolo Castello , ArnaldoRivera
- ET0519Barolo Cerretta, Ettore Germano
- OD0820Barolo Classico, Oddero
- OD4719Barolo Classico - Magnum , Oddero
- ET2719Barolo Prapò, Ettore Germano
- AR0816Barolo Ravera, ArnaldoRivera
- OD0717Barolo Riserva Bussia Vigna Mondoca, Oddero
- OD0917ABarolo Riserva Vignarionda, Oddero
- OD4115Barolo Riserva Vignarionda - Magnum , Oddero
- OD4117Barolo Riserva Vignarionda - Magnum , Oddero
- ET0720Barolo Serralunga, Ettore Germano
- ET1720Barolo Serralunga - Half Bottle, Ettore Germano
- ET3217Barolo Serralunga - Magnum, Ettore Germano
- AR0517Barolo Vignarionda , ArnaldoRivera
- OD0619Barolo Villero, Oddero
- AZ0123Beaujolais Villages 'Stellogonie', Domaine Azzara
- MI7022Bianco Friuli Colli Orientali, Miani
- TG0220Boca - Organic, Tenute Guardasole
- VD0124Bollicine Rosé, Serafini & Vidotto
- VW0222Bourgogne Chardonnay, Vincent Wengier
- PD0123Bourgogne Chardonnay, Domaine de la Pierre des Dames
- PD0423Bourgogne Pinot Noir, Domaine de la Pierre des Dames
- VW0822Bourgogne Pinot Noir 'Les Ardillers', Vincent Wengier
- TL0515Bramaterra, Tenute Sella
- NO0719Bramaterra Rocce di Luce, Noah
- NO0619Bramaterra Salero, Noah
- PM0123Branco, Passagem
- VZ110Brandy 10Yrs, Villa Zarri
- VZ124Brandy 23Yrs, Villa Zarri
- CR0119Brunello di Montalcino, Castello Romitorio
- CA9719Brunello di Montalcino, Caparzo
- CA9817Brunello di Montalcino 'La Casa', Caparzo
- CA9812Brunello di Montalcino 'La Casa', Caparzo
- CA9519Brunello di Montalcino - Half Bottle, Caparzo
- CA9418Brunello di Montalcino - Magnum, Caparzo
- CR0319Brunello di Montalcino Filo di Seta, Castello Romitorio
- CA9319Brunello di Montalcino Rio Cassero, Caparzo
- CA9916Brunello di Montalcino Riserva, Caparzo
- HI0124Brut Reserve, Highweald Wine Estate
- IC0623Cabernet Franc, I Clivi
- TC0313Calabria Bianco 'Manere', Tenuta del Conte
- AS0121Canaiolo, Ascione-Alongi
- GB0521Cannonau di Sardegna 'Lillové', Gabbas
- GB0616Cannonau di Sardegna Riserva Dule, Gabbas
- PC0120Carema Classico , Produttori del Carema
- FE0319Carema Etichetta Bianca, Ferrando
- FE0718Carema Etichetta Bianca - Magnum, Ferrando
- FE0419Carema Etichetta Nera , Ferrando
- FE0818Carema Etichetta Nera - Magnum, Ferrando
- PC0519Carema Riserva, Produttori del Carema
- PC0716Carema Selezione, Produttori del Carema
- GU0521Carjcanti - Organic, Gulfi
- GU0723Cerasuolo di Vittoria, Gulfi
- VW0322Chablis, Vincent Wengier
- VW0522Chablis - Half Bottle, Vincent Wengier
- EM0121Chablis Archives, Domaine des Pérégrins
- EM0720Chablis Archives Vieilles Vignes, Domaine des Pérégrins
- EM0620Chablis Pérégrinations Chronique, Domaine des Pérégrins
- EM0521Chablis Premier Cru Côte de Jouan, Domaine des Pérégrins
- BM0122Chablis Premier Cru Vaillons, Domaine Begue-Mathiot
- LH0514Champagne Grand Cru Blanc de Blancs 'Les Sillons', Legras & Haas
- LH0423Champagne Grand Cru Blanc de Blancs Extra Brut 'L’Évidence', Legras & Haas
- LH0621Champagne Grand Cru Blanc de Blancs Extra Brut 'L’Évidence' - Magnum, Legras & Haas
- LH0914Champagne Grand Cru Blanc de Blancs Millésime, Legras & Haas
- LH0223Champagne Intuition Brut , Legras & Haas
- LH0321Champagne Intuition Rosé Brut, Legras & Haas
- BA0124Champagne L’Éloquente Brut , Jean de la Fontaine
- WS0721Chardonnay, Winzerhof Stahl
- HI0422Chardonnay, Highweald Wine Estate
- FD0122Chardonnay 'Monopolia Sannicola', Fondo Indizeno
- MI7222Chardonnay Friuli Colli Orientali, Miani
- TE6622Chardonnay Kreuth, Cantina Terlano
- TE7822Chardonnay Kreuth - Magnum, Cantina Terlano
- CD1023Chardonnay Somereto, Cantina Andriano
- TE0223Chardonnay Tradition, Cantina Terlano
- MO0616Château-Chalon, Domaine Jean-Luc Mouillard
- OF0622Châteauneuf du Pape Blanc, Olivier & Lafont
- OF0820Châteauneuf du Pape Rouge, Olivier & Lafont
- VZ310Cherry Brandy, Villa Zarri
- SA0123Chianti 'Biskero' - Organic, Salcheto
- SA2123Chianti 'Biskero' - Organic - Magnum, Salcheto
- PG0122Chianti Classico, Poggio Scalette
- LC4822Chianti Classico - Half Bottle - Organic, Villa Le Corti - Principe Corsini
- LC4522Chianti Classico - Organic, Villa Le Corti - Principe Corsini
- LC4620Chianti Classico Riserva 'Cortevecchia' - Organic, Villa Le Corti - Principe Corsini
- SE0122Chiaretto Riviera del Garda Classico 'San Donino', Selva Capuzza
- RC0221Cialla Bianco , Ronchi di Cialla
- RC2521Cialla Bianco - Magnum, Ronchi di Cialla
- TC0122Cirò Bianco - Organic, Tenuta del Conte
- TC0522Cirò Rosato - Organic, Tenuta del Conte
- TC0218Cirò Rosso Classico Superiore - Organic, Tenuta del Conte
- VZ410Coffee Brandy, Villa Zarri
- BP0122Colección Malbec, Bodega Privada
- CU0119Colline Novaresi DOC Agamium, Antichi Vigneti di Cantalupo
- TF0723Collines Rhodaniennes Syrah 'Les Jardins de Chavagnac', Thomas Farge
- MN0422Corvina, Monte Tondo
- TM0120Costa Toscana Birillo - Organic, Tenuta Marsiliana - Principe Corsini
- NO0323Coste della Sesia 'Rossonoah', Noah
- TL0222Coste della Sesia Nebbiolo 'Orbello', Tenute Sella
- TL0723Coste della Sesia Rosato 'Majoli', Tenute Sella
- DL0123Côtes de Gascogne Blanc, Domaine de Papolle
- ME0123Côtes de Provence Rosé, Maison Étoilée
- MO0122Côtes du Jura Chardonnay 'Bas de la Chaux' , Domaine Jean-Luc Mouillard
- MO0518Côtes du Jura Savagnin, Domaine Jean-Luc Mouillard
- MO0220Côtes du Jura Savagnin 'Le Curieux' , Domaine Jean-Luc Mouillard
- OF0123Côtes du Rhône Blanc, Olivier & Lafont
- OF0221Côtes du Rhône Rouge, Olivier & Lafont
- MA0917Croatina Colli Tortonesi 'Montemirano', Claudio Mariotto
- OF0519Crozes-Hermitage, Olivier & Lafont
- HT0522Cuvée Auslese, Weingut Tschida Angerhof
- RU0622Doi Raps, Russolo
- FR2023Dolcetto D'Alba Roussot, Francesco Rinaldi
- AR1122Dolcetto Diano d'Alba 'Sorì del Cascinotto', ArnaldoRivera
- VZ846Dusk Manhatten Cherry Brandy, Villa Zarri
- VZ845Dusk Negroni Brandy, Villa Zarri
- FE0122Erbaluce di Caluso Etichetta Verde, Ferrando
- ML0123Etna Bianco, Monteleone
- FZ0121Etna Bianco Gamma, Federico Curtaz
- ML0322Etna Rosso, Monteleone
- FZ0220Etna Rosso Il Purgatorio, Federico Curtaz
- ET4024Extra Brut Rosé Metodo Classico 'Rosanna' , Ettore Germano
- LP0122Falanghina Beneventano, Lapilli
- PI0222Fiano, Pietracupa
- PI0420Fiano 'Il Cupo', Pietracupa
- CF0423Fiano - Organic, Caiaffa
- MZ0223Fiano Puglia, Mezzogiorno
- MA0421Freisa Colli Tortonesi Braghé, Claudio Mariotto
- RG2522Friulano Buri Bellaria, Ronco del Gnemiz
- IC0221Friulano Collio 'San Lorenzo', I Clivi
- MI7122Friulano Friuli Colli Orientali, Miani
- VS0323Furmint, Verus
- TR0318Gattinara Riserva , Travaglini
- TR1218Gattinara Riserva - Double Magnum, Travaglini
- TR1018Gattinara Riserva - Magnum, Travaglini
- TR0221Gattinara Selezione , Travaglini
- TR1320Gattinara Selezione - Double Magnum, Travaglini
- TR0919Gattinara Selezione - Magnum, Travaglini
- TR0519Gattinara Tre Vigne, Travaglini
- FB0123Gavi, Folli & Benato
- FR3023Gavi, Francesco Rinaldi
- FB0223Gavi del Comune di Gavi, Folli & Benato
- TE3223Gewürztraminer Tradition, Cantina Terlano
- CU0715Ghemme Anno Primo, Antichi Vigneti di Cantalupo
- CU0307Ghemme Collis Breclemae , Antichi Vigneti di Cantalupo
- CU0313Ghemme Collis Breclemae , Antichi Vigneti di Cantalupo
- CU0315Ghemme Collis Breclemae , Antichi Vigneti di Cantalupo
- CU0208Ghemme Collis Carellae, Antichi Vigneti di Cantalupo
- CU0215Ghemme Collis Carellae, Antichi Vigneti di Cantalupo
- HI0524Ghyll Valley White, Highweald Wine Estate
- PI0122Greco, Pietracupa
- LL0222Greco di Tufo , Lapilli
- CE0123Grillo 'Lumà', Cantine Cellaro
- CP0222Grillo 'Rocce di Pietra Longa' - Organic, Centopassi
- CP0122Grillo-Catarratto Giato Bianco - Organic, Centopassi
- BS0123Grüner Veltliner - Organic, Besas
- HT0918Grüner Veltliner Beerenauslese - Half Bottle, Weingut Tschida Angerhof
- IS0223Kerner, Cantina Valle Isarco
- IS0720Kerner 'Aristos', Cantina Valle Isarco
- MO0318L'Etoile Sélection , Domaine Jean-Luc Mouillard
- CD0723Lagrein 'Rubeno', Cantina Andriano
- TE1021Lagrein Riserva 'Gries', Cantina Terlano
- TE1720Lagrein Riserva 'Porphyr' , Cantina Terlano
- TE0923Lagrein Rosé Tradition, Cantina Terlano
- FR2322Langhe Freisa, Francesco Rinaldi
- AR0122Langhe Nascetta del Comune di Novello, ArnaldoRivera
- OD0121Langhe Nebbiolo, Oddero
- PB0122Langhe Nebbiolo , Produttori del Barbaresco
- ET1221Langhe Riesling Hérzu , Ettore Germano
- NO0419Lessona, Noah
- TL0619Lessona, Tenute Sella
- TL1513Lessona San Sebastiano allo Zoppo , Tenute Sella
- VZ210Liquore Nocino - Organic, Villa Zarri
- SE0222Lugana 'Selva', Selva Capuzza
- VG0119Lussac-Saint-Émilion 'Château Chéreau', Vignobles Silvestrini
- VG0211Lussac-Saint-Émilion 'L'Egérie du Château Chéreau', Vignobles Silvestrini
- PD0223Macon Prissé, Domaine de la Pierre des Dames
- IC0122Malvasia Collio 'Vigna 80 Anni', I Clivi
- OR0123Malvasia-Chardonnay, Ortonese
- VD0921Manzoni Bianco, Serafini & Vidotto
- AL0621McLaren Vale Shiraz, Adelina
- VL0122Mencía La Premisa, Vinos Valtuille
- MI1620Merlot Friuli Colli Orientali Buri, Miani
- MI0709Merlot Friuli Colli Orientali Filip, Miani
- RU0922Merlot Massarac , Russolo
- TR4018Metodo Classico Pas Dosé 'Nebolè', Travaglini
- CM0622Montepulciano d'Abruzzo 'Malandrino' - Organic, Cataldi Madonna
- AT0323Montepulciano d'Abruzzo - Organic, Amoterra
- RH0122Morgon Charmes, Domaine Raphaël Chopin
- SC0123Moscato d'Asti , Paolo Saracco
- SC0223Moscato d'Asti - Half Bottle , Paolo Saracco
- TK0523Mtsvane, Tiko Estate
- CD0523Müller-Thurgau, Cantina Andriano
- WS0123Nachschlag 'Bright Side of Life', Winzerhof Stahl
- TR0123Nebbiolo Coste della Sesia, Travaglini
- CF0222Negroamaro - Organic , Caiaffa
- CP2121Nerello Mascalese 'Pietre a Purtedda da Ginestra' - Organic, Centopassi
- MZ0423Nero d'Avola Terre Siciliane, Mezzogiorno
- CP0522Nero d'Avola-Perricone Giato Rosso - Organic, Centopassi
- CF0919Nero di Troia 'Lampryris' - Organic, Caiaffa
- CF0322Nero di Troia - Organic, Caiaffa
- CF0823Nero di Troia Rosato Pét-Nat Ancestrale - Organic, Caiaffa
- GU0319NeroBaronj - Organic, Gulfi
- GU0119NeroBufaleffj - Organic, Gulfi
- GU0219NeroSanloré - Organic, Gulfi
- GU0216NeroSanloré - Organic, Gulfi
- VZ847New Orange Brandy , Villa Zarri
- SA9022Obvius Bianco - Organic, Salcheto
- TK0222Orange Kisi, Tiko Estate
- LR0320Pario, L'Arco
- SO0321Passito di Pantelleria, Solidea
- CM0223Pecorino 'Giulia', Cataldi Madonna
- LC5221Per Filo - Organic, Villa Le Corti - Principe Corsini
- VD0421Phigaia 'After The Red', Serafini & Vidotto
- TL0121Piemonte Bianco 'Piandoro', Tenute Sella
- CD0123Pinot Bianco 'Finado' , Cantina Andriano
- TE4011Pinot Bianco Rarity , Cantina Terlano
- TE1221Pinot Bianco Riserva 'Vorberg' , Cantina Terlano
- TE3121Pinot Bianco Riserva 'Vorberg' - Magnum , Cantina Terlano
- TE1623Pinot Bianco Tradition, Cantina Terlano
- CD0223Pinot Grigio, Cantina Andriano
- RU0323Pinot Grigio Ronco Calaj, Russolo
- TE0423Pinot Grigio Tradition , Cantina Terlano
- VI0223Pinot Grigio Veneto, Vinvita
- VS0223Pinot Gris , Verus
- JR1920Pinot Noir Gumpoldskirchen Grillenhügel - Organic, Familie Reinisch
- JR1717Pinot Noir Holzspur - Organic, Familie Reinisch
- TE2521Pinot Noir Riserva 'Monticol', Cantina Terlano
- JR0722Pinot Noir Tattendorf - Organic, Familie Reinisch
- JR0622Pinot Noir Tattendorf - Organic, Familie Reinisch
- TE3023Pinot Noir Tradition, Cantina Terlano
- VG0318Pomerol 'Domaine de la Pointe', Vignobles Silvestrini
- PM0924Port 10 Year Old Tawny, Passagem
- PM0818Port Late Bottle Vintage, Passagem
- TO0622Premium Furmint Nagy Somlói, Tornai Pincészet
- CF0122Primitivo - Organic, Caiaffa
- GP0821Primitivo di Manduria 'Magnifico Rosso Fuoco', Magnifico
- MZ0522Primitivo Puglia , Mezzogiorno
- TS0122Priorat DOQ '90 Minuts', Trossos del Priorat
- VI0122Prosecco Spumante DOC Extra Dry, Vinvita
- VD0321Recantina , Serafini & Vidotto
- LR0517Recioto della Valpolicella Classico, L'Arco
- SP0520Recioto della Valpolicella Classico La Roggia, Speri
- RU0820Refosco dal Peduncolo Rosso, Russolo
- MI1820Refosco Friuli Colli Orientali Cossut, Miani
- RH0222Régnié Archambault, Domaine Raphaël Chopin
- RC0123Ribolla Gialla , Ronchi di Cialla
- MI8321Ribolla Gialla Friuli Colli Orientali Pettarin, Miani
- VS0422Riesling , Verus
- BU0123Rioja Alavesa, Bodegas Estraunza
- CX0120Rioja Alavesa 'letras minúsculas', Bodegas Tierra - Creaciones Exeo
- CX0320Rioja Alavesa Garnacha Blanca 'Cifras', Bodegas Tierra - Creaciones Exeo
- CX0221Rioja Alavesa Garnacha Tinta 'Cifras', Bodegas Tierra - Creaciones Exeo
- CX0420Rioja Alavesa Malvasia 'La Greña', Bodegas Tierra - Creaciones Exeo
- TK0422Rkatsiteli, Tiko Estate
- MZ0623Rosato Puglia, Mezzogiorno
- HI0324Rosé, Highweald Wine Estate
- RG5121Rosso Buri Bellaria, Ronco del Gnemiz
- LR0120Rosso del Veronese, L'Arco
- VD0518Rosso dell'Abazia, Serafini & Vidotto
- CA9221Rosso di Montalcino, Caparzo
- AA0119Rosso di Montefalco , Adanti
- RG5021Rosso Dottor Palazzolo, Ronco del Gnemiz
- MI1520Rosso Friuli Colli Orientali, Miani
- GU0622Rossojbleo - Organic, Gulfi
- JR1022Roter Eiswein - Half Bottle - Organic, Familie Reinisch
- JR1821Rotgipfler 'Satzing' - Organic, Familie Reinisch
- JR0222Rotgipfler - Organic, Familie Reinisch
- LR0618Rùbeo, L'Arco
- AA0810Sagrantino di Montefalco Riserva 'Il Domenico', Adanti
- PD0323Saint Véran, Domaine de la Pierre des Dames
- TF0219Saint-Joseph Blanc 'Grand Angle', Thomas Farge
- HT0304Sämling Trockenbeerenauslese - Half Bottle, Weingut Tschida Angerhof
- HT0312Sämling Trockenbeerenauslese - Half Bottle, Weingut Tschida Angerhof
- SE0322San Martino della Battaglia 'Campo del Soglio', Selva Capuzza
- FN0122Sancerre 'Silex' - Organic, François Le Saint
- BZ0321Sangiovese di Romagna Superiore 'Balitore', Balìa di Zola
- CA9022Sangiovese di Toscana, Caparzo
- VI0622Sangiovese Rubicone, Vinvita
- OR0423Sangiovese-Merlot, Ortonese
- TK0321Saperavi, Tiko Estate
- TE0522Sauvignon 'Quarz', Cantina Terlano
- TE2722Sauvignon 'Quarz' - Magnum, Cantina Terlano
- TE0323Sauvignon 'Winkl' , Cantina Terlano
- VS0123Sauvignon Blanc , Verus
- FD0323Sauvignon Blanc, Fondo Indizeno
- CD2522Sauvignon Blanc Andrius, Cantina Andriano
- BC0122Sauvignon Blanc Earth Series, Black Cottage
- MI7322Sauvignon Friuli Colli Orientali, Miani
- MI8021Sauvignon Friuli Colli Orientali Casa Rossa , Miani
- MI8221Sauvignon Friuli Colli Orientali Saurint, Miani
- MI8121Sauvignon Friuli Colli Orientali Zitelle , Miani
- RG2920Sauvignon Iris , Ronco del Gnemiz
- RG2722Sauvignon Lozeta , Ronco del Gnemiz
- RG2022Sauvignon Peri, Ronco del Gnemiz
- RG3922Sauvignon Serena , Ronco del Gnemiz
- RG3822Sauvignon Sol, Ronco del Gnemiz
- WS0520Scheurebe 'Cyriakusberg', Winzerhof Stahl
- RG4021Schioppettino, Ronco del Gnemiz
- RC0617Schioppettino di Cialla, Ronchi di Cialla
- RC0521Schioppettino RiNera, Ronchi di Cialla
- WS0322Silvaner , Winzerhof Stahl
- SI0122Sirkel Chenin Blanc, Scali
- SI0220Sirkel Shiraz Viognier , Scali
- MN0223Soave Classico, Monte Tondo
- MN0323Soave Classico - Half Bottle, Monte Tondo
- MN0922Soave Classico Casette Foscarino, Monte Tondo
- MN0123Soave Mito, Monte Tondo
- HT1522Spätlese Merlot, Weingut Tschida Angerhof
- JR0820St. Laurent - Organic, Familie Reinisch
- IS1019Sylvaner 'Sabiona', Cantina Valle Isarco
- CE0422Syrah 'Lumà' , Cantine Cellaro
- PI0517Taurasi, Pietracupa
- TE0123Terlaner Cuvée, Cantina Terlano
- TE3523Terlaner Cuvée - Half Bottle, Cantina Terlano
- TE5523Terlaner Cuvée - Magnum, Cantina Terlano
- TE0821Terlaner Cuvée Riserva 'Nova Domus', Cantina Terlano
- TE5221Terlaner Cuvée Riserva 'Nova Domus' - Magnum, Cantina Terlano
- TE5021Terlaner I Grande Cuvée Primo, Cantina Terlano
- TE51121Terlaner I Grande Cuvée Primo - Magnum
- MA0122Timorasso Colli Tortonesi Bricco San Michele, Claudio Mariotto
- MA0320Timorasso Colli Tortonesi Cavallina, Claudio Mariotto
- PM0221Tinto, Passagem
- CR0322Toscana Rosso Brio , Castello Romitorio
- CR0421Toscana Rosso Romitorio, Castello Romitorio
- AT0123Trebbiano d'Abruzzo - Organic, Amoterra
- VI0523Trebbiano Rubicone, Vinvita
- AD7024Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' , Adami
- AD7124Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Half Bottle, Adami
- AD7524Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Magnum, Adami
- AD8923Valdobbiadene DOCG Prosecco Superiore Rive di Farra di Soligo 'Col Credas', Adami
- AD6022Valdobbiadene DOCG Prosecco Superiore Sui Lieviti Brut Nature 'Col Fondo', Adami
- SP0123Valpolicella Classico, Speri
- SP0221Valpolicella Classico Superiore Ripasso , Speri
- SP0320Valpolicella Classico Superiore Sant'Urbano, Speri
- GP0122Veneto Rosso IGT, Gran Passione
- AT0523Verdicchio di Matelica - Organic, Amoterra
- AR1222Verduno Pelaverga, ArnaldoRivera
- RC1583Verduzzo di Cialla, Ronchi di Cialla
- RC1018Verduzzo di Cialla - Half Bottle, Ronchi di Cialla
- GB0123Vermentino di Sardegna Manzanile , Gabbas
- PA0123Vernaccia di San Gimignano - Organic, Panizzi
- PA0320Vernaccia di San Gimignano Riserva - Organic, Panizzi
- PA0222Vernaccia di San Gimignano Vigna Santa Margherita - Organic, Panizzi
- MO0717Vin de Paille, Domaine Jean-Luc Mouillard
- LC6006Vin Santo 'Sant'Andrea Corsini', Villa Le Corti - Principe Corsini
- SA1018Vino Nobile di Montepulciano 'Salco' - Organic, Salcheto
- SA0320Vino Nobile di Montepulciano - Half Bottle - Organic , Salcheto
- SA0619Vino Nobile di Montepulciano - Magnum - Organic, Salcheto
- SA0520Vino Nobile di Montepulciano - Organic, Salcheto
- AL0122Watervale Riesling, Adelina
- WS0222Weissburgunder, Winzerhof Stahl
- PF1523Wien.1 , Pfaffl
- PF1623Wien.2 , Pfaffl
- JR0522Zweigelt - Organic, Familie Reinisch
- regionOptions(array)
- Argentina(array)
- mendozaMendoza (1)
- Australia(array)
- clare-valleyClare Valley (1)
- mclaren-valeMcLaren Vale (1)
- Austria(array)
- thermenregionThermenregion (9)
- traisentalTraisental (1)
- neusiedlerseeNeusiedlersee (5)
- weinviertelWeinviertel (2)
- France(array)
- burgundyBurgundy (13)
- champagneChampagne (7)
- bordeauxBordeaux (3)
- loire-valleyLoire Valley (1)
- provenceProvence (1)
- rhone-valleyRhône Valley (9)
- gasconyGascony (1)
- beaujolais-1Beaujolais (3)
- juraJura (6)
- Georgia(array)
- kakhetiKakheti (4)
- Germany(array)
- frankenFranken (5)
- Hungary(array)
- somloSomlo (1)
- Italy(array)
- piemontePiemonte (92)
- lombardiaLombardia (3)
- trentino-alto-adigeTrentino-Alto Adige (33)
- friuli-venezia-giuliaFriuli Venezia-Giulia (37)
- venetoVeneto (34)
- emilia-romagnaEmilia Romagna (12)
- marcheMarche (1)
- toscanaToscana (34)
- pugliaPuglia (11)
- abruzzoAbruzzo (5)
- campaniaCampania (8)
- siciliaSicilia (19)
- sardegnaSardegna (3)
- umbriaUmbria (2)
- calabriaCalabria (4)
- New Zealand(array)
- marlboroughMarlborough (1)
- Portugal(array)
- douroDouro (4)
- Slovenia(array)
- ormozOrmoz (4)
- South Africa(array)
- northern-paarlNorthern Paarl (2)
- Spain(array)
- prioratPriorat (1)
- rias-baixasRias Baixas (3)
- riojaRioja (5)
- bierzo-1Bierzo (1)
- The United Kingdom(array)
- sussexSussex (4)
- Argentina(array)
- regions(array)
- 0(array)
- GeographyRegion(array)
- id51
- slugmendoza
- titleMendoza
- GeographyCountry(array)
- id14
- slugargentina
- titleArgentina
- image_area_coordinates
- image_area_coordinates_spirit
- GeographyRegion(array)
- 1(array)
- GeographyRegion(array)
- id43
- slugclare-valley
- titleClare Valley
- GeographyCountry(array)
- id13
- slugaustralia
- titleAustralia
- image_area_coordinates602,31,610,39,610,46,630,67,630,87,626,91,621,95,662,99,614,108,610,103,606,107,593,95,589,95,586,91,581,91,577,86,554,87,554,91,541,91,542,95,537,95,534,91,534,76,530,75,534,71,533,63,530,63,529,60,538,59,537,55,546,55,563,38,566,42,570,43,570,39,578,39,
- image_area_coordinates_spirit
- GeographyRegion(array)
- 2(array)
- GeographyRegion(array)
- id61
- slugmclaren-vale
- titleMcLaren Vale
- GeographyCountry(array)
- id13
- slugaustralia
- titleAustralia
- image_area_coordinates602,31,610,39,610,46,630,67,630,87,626,91,621,95,662,99,614,108,610,103,606,107,593,95,589,95,586,91,581,91,577,86,554,87,554,91,541,91,542,95,537,95,534,91,534,76,530,75,534,71,533,63,530,63,529,60,538,59,537,55,546,55,563,38,566,42,570,43,570,39,578,39,
- image_area_coordinates_spirit
- GeographyRegion(array)
- 3(array)
- GeographyRegion(array)
- id1
- slugthermenregion
- titleThermenregion
- GeographyCountry(array)
- id1
- slugaustria
- titleAustria
- image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
- image_area_coordinates_spirit
- GeographyRegion(array)
- 4(array)
- GeographyRegion(array)
- id2
- slugtraisental
- titleTraisental
- GeographyCountry(array)
- id1
- slugaustria
- titleAustria
- image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
- image_area_coordinates_spirit
- GeographyRegion(array)
- 5(array)
- GeographyRegion(array)
- id4
- slugneusiedlersee
- titleNeusiedlersee
- GeographyCountry(array)
- id1
- slugaustria
- titleAustria
- image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
- image_area_coordinates_spirit
- GeographyRegion(array)
- 6(array)
- GeographyRegion(array)
- id5
- slugweinviertel
- titleWeinviertel
- GeographyCountry(array)
- id1
- slugaustria
- titleAustria
- image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
- image_area_coordinates_spirit
- GeographyRegion(array)
- 7(array)
- GeographyRegion(array)
- id7
- slugburgundy
- titleBurgundy
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 8(array)
- GeographyRegion(array)
- id8
- slugchampagne
- titleChampagne
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 9(array)
- GeographyRegion(array)
- id39
- slugbordeaux
- titleBordeaux
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 10(array)
- GeographyRegion(array)
- id49
- slugloire-valley
- titleLoire Valley
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 11(array)
- GeographyRegion(array)
- id52
- slugprovence
- titleProvence
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 12(array)
- GeographyRegion(array)
- id56
- slugrhone-valley
- titleRhône Valley
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 13(array)
- GeographyRegion(array)
- id62
- sluggascony
- titleGascony
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 14(array)
- GeographyRegion(array)
- id67
- slugbeaujolais-1
- titleBeaujolais
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 15(array)
- GeographyRegion(array)
- id68
- slugjura
- titleJura
- GeographyCountry(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- GeographyRegion(array)
- 16(array)
- GeographyRegion(array)
- id55
- slugkakheti
- titleKakheti
- GeographyCountry(array)
- id15
- sluggeorgia
- titleGeorgia
- image_area_coordinates396,167,425,181,435,176,455,195,476,190,492,210,495,223,483,224,477,215,470,224,446,222,434,213,419,215,426,202,396,181
- image_area_coordinates_spirit
- GeographyRegion(array)
- 17(array)
- GeographyRegion(array)
- id57
- slugfranken
- titleFranken
- GeographyCountry(array)
- id3
- sluggermany
- titleGermany
- image_area_coordinates209,111,224,112,231,119,271,122,270,142,273,164,243,179,263,205,256,211,216,210,213,189,196,187,193,175,197,164,208,163,211,134,194,127,216,126
- image_area_coordinates_spirit
- GeographyRegion(array)
- 18(array)
- GeographyRegion(array)
- id11
- slugsomlo
- titleSomlo
- GeographyCountry(array)
- id4
- slughungary
- titleHungary
- image_area_coordinates309,214,333,217,338,209,350,204,360,205,359,225,348,236,331,243,315,243,303,229
- image_area_coordinates_spirit
- GeographyRegion(array)
- 19(array)
- GeographyRegion(array)
- id13
- slugpiemonte
- titlePiemonte
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 20(array)
- GeographyRegion(array)
- id15
- sluglombardia
- titleLombardia
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 21(array)
- GeographyRegion(array)
- id16
- slugtrentino-alto-adige
- titleTrentino-Alto Adige
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 22(array)
- GeographyRegion(array)
- id17
- slugfriuli-venezia-giulia
- titleFriuli Venezia-Giulia
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 23(array)
- GeographyRegion(array)
- id18
- slugveneto
- titleVeneto
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 24(array)
- GeographyRegion(array)
- id19
- slugemilia-romagna
- titleEmilia Romagna
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 25(array)
- GeographyRegion(array)
- id20
- slugmarche
- titleMarche
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 26(array)
- GeographyRegion(array)
- id21
- slugtoscana
- titleToscana
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 27(array)
- GeographyRegion(array)
- id23
- slugpuglia
- titlePuglia
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 28(array)
- GeographyRegion(array)
- id24
- slugabruzzo
- titleAbruzzo
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 29(array)
- GeographyRegion(array)
- id25
- slugcampania
- titleCampania
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 30(array)
- GeographyRegion(array)
- id26
- slugsicilia
- titleSicilia
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 31(array)
- GeographyRegion(array)
- id27
- slugsardegna
- titleSardegna
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 32(array)
- GeographyRegion(array)
- id33
- slugumbria
- titleUmbria
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 33(array)
- GeographyRegion(array)
- id60
- slugcalabria
- titleCalabria
- GeographyCountry(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- GeographyRegion(array)
- 34(array)
- GeographyRegion(array)
- id28
- slugmarlborough
- titleMarlborough
- GeographyCountry(array)
- id6
- slugnew-zealand
- titleNew Zealand
- image_area_coordinates594,274,611,304,624,305,625,321,605,342,572,385,563,385,545,382,551,361,575,337,594,332,589,322,597,308,581,283
- image_area_coordinates_spirit(null)
- GeographyRegion(array)
- 35(array)
- GeographyRegion(array)
- id65
- slugdouro
- titleDouro
- GeographyCountry(array)
- id16
- slugportugal
- titlePortugal
- image_area_coordinates33,304,55,304,52,317,45,336,43,354,44,373,23,359,23,339,35,332
- image_area_coordinates_spirit
- GeographyRegion(array)
- 36(array)
- GeographyRegion(array)
- id29
- slugormoz
- titleOrmoz
- GeographyCountry(array)
- id7
- slugslovenia
- titleSlovenia
- image_area_coordinates298,236,303,245,284,258,271,256,273,248,277,239
- image_area_coordinates_spirit
- GeographyRegion(array)
- 37(array)
- GeographyRegion(array)
- id40
- slugnorthern-paarl
- titleNorthern Paarl
- GeographyCountry(array)
- id11
- slugsouth-africa
- titleSouth Africa
- image_area_coordinates592,173,605,162,613,158,618,160,623,168,623,176,626,181,631,184,631,195,623,207,618,218,602,233,586,239,568,242,557,246,548,239,545,233,548,222,541,214,534,202,542,198,556,205,559,175,564,181,564,190,573,191,573,177,581,183,593,182
- image_area_coordinates_spirit(null)
- GeographyRegion(array)
- 38(array)
- GeographyRegion(array)
- id31
- slugpriorat
- titlePriorat
- GeographyCountry(array)
- id8
- slugspain
- titleSpain
- image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
- image_area_coordinates_spirit
- GeographyRegion(array)
- 39(array)
- GeographyRegion(array)
- id32
- slugrias-baixas
- titleRias Baixas
- GeographyCountry(array)
- id8
- slugspain
- titleSpain
- image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
- image_area_coordinates_spirit
- GeographyRegion(array)
- 40(array)
- GeographyRegion(array)
- id48
- slugrioja
- titleRioja
- GeographyCountry(array)
- id8
- slugspain
- titleSpain
- image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
- image_area_coordinates_spirit
- GeographyRegion(array)
- 41(array)
- GeographyRegion(array)
- id64
- slugbierzo-1
- titleBierzo
- GeographyCountry(array)
- id8
- slugspain
- titleSpain
- image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
- image_area_coordinates_spirit
- GeographyRegion(array)
- 42(array)
- GeographyRegion(array)
- id59
- slugsussex
- titleSussex
- GeographyCountry(array)
- id10
- slugthe-united-kingdom
- titleThe United Kingdom
- image_area_coordinates71,49,95,48,92,60,108,62,106,72,97,85,114,110,127,136,140,139,142,146,139,157,141,164,125,179,107,181,90,184,69,187,67,178,81,165,72,153,87,149,87,139,78,138,91,131,78,111,63,122,52,115,36,113,60,88,57,69
- image_area_coordinates_spirit246,214,451,213,450,395,245,394
- GeographyRegion(array)
- 0(array)
- countryOptions(array)
- argentinaArgentina (1)
- australiaAustralia (2)
- austriaAustria (17)
- franceFrance (44)
- georgiaGeorgia (4)
- germanyGermany (5)
- hungaryHungary (1)
- italyItaly (298)
- new-zealandNew Zealand (1)
- portugalPortugal (4)
- sloveniaSlovenia (4)
- south-africaSouth Africa (2)
- spainSpain (10)
- the-united-kingdomThe United Kingdom (4)
- countries(array)
- argentina(array)
- id14
- slugargentina
- titleArgentina
- image_area_coordinates
- image_area_coordinates_spirit
- count1
- australia(array)
- id13
- slugaustralia
- titleAustralia
- image_area_coordinates602,31,610,39,610,46,630,67,630,87,626,91,621,95,662,99,614,108,610,103,606,107,593,95,589,95,586,91,581,91,577,86,554,87,554,91,541,91,542,95,537,95,534,91,534,76,530,75,534,71,533,63,530,63,529,60,538,59,537,55,546,55,563,38,566,42,570,43,570,39,578,39,
- image_area_coordinates_spirit
- count2
- austria(array)
- id1
- slugaustria
- titleAustria
- image_area_coordinates269,209,290,208,298,215,295,229,272,230,263,223,229,225,226,217,270,217
- image_area_coordinates_spirit
- count17
- france(array)
- id2
- slugfrance
- titleFrance
- image_area_coordinates145,170,163,186,189,195,203,196,209,205,186,235,192,259,199,275,222,287,223,308,214,298,215,283,195,282,178,281,165,280,162,290,147,285,122,280,108,269,103,246,82,222,80,207,109,204,112,191,139,182
- image_area_coordinates_spirit
- count44
- georgia(array)
- id15
- sluggeorgia
- titleGeorgia
- image_area_coordinates396,167,425,181,435,176,455,195,476,190,492,210,495,223,483,224,477,215,470,224,446,222,434,213,419,215,426,202,396,181
- image_area_coordinates_spirit
- count4
- germany(array)
- id3
- sluggermany
- titleGermany
- image_area_coordinates209,111,224,112,231,119,271,122,270,142,273,164,243,179,263,205,256,211,216,210,213,189,196,187,193,175,197,164,208,163,211,134,194,127,216,126
- image_area_coordinates_spirit
- count5
- hungary(array)
- id4
- slughungary
- titleHungary
- image_area_coordinates309,214,333,217,338,209,350,204,360,205,359,225,348,236,331,243,315,243,303,229
- image_area_coordinates_spirit
- count1
- italy(array)
- id5
- slugitaly
- titleItaly
- image_area_coordinates325,316,325,329,309,331,312,346,304,361,291,364,293,381,259,367,260,356,228,345,213,349,214,314,228,315,231,336,273,356,293,354,292,342,279,326,261,309,228,275,207,272,201,255,241,233,258,233,264,244,257,266,289,300,300,298,301,308
- image_area_coordinates_spirit247,20,449,20,449,198,248,197
- count298
- new-zealand(array)
- id6
- slugnew-zealand
- titleNew Zealand
- image_area_coordinates594,274,611,304,624,305,625,321,605,342,572,385,563,385,545,382,551,361,575,337,594,332,589,322,597,308,581,283
- image_area_coordinates_spirit(null)
- count1
- portugal(array)
- id16
- slugportugal
- titlePortugal
- image_area_coordinates33,304,55,304,52,317,45,336,43,354,44,373,23,359,23,339,35,332
- image_area_coordinates_spirit
- count4
- slovenia(array)
- id7
- slugslovenia
- titleSlovenia
- image_area_coordinates298,236,303,245,284,258,271,256,273,248,277,239
- image_area_coordinates_spirit
- count4
- south-africa(array)
- id11
- slugsouth-africa
- titleSouth Africa
- image_area_coordinates592,173,605,162,613,158,618,160,623,168,623,176,626,181,631,184,631,195,623,207,618,218,602,233,586,239,568,242,557,246,548,239,545,233,548,222,541,214,534,202,542,198,556,205,559,175,564,181,564,190,573,191,573,177,581,183,593,182
- image_area_coordinates_spirit(null)
- count2
- spain(array)
- id8
- slugspain
- titleSpain
- image_area_coordinates31,277,110,280,117,289,136,290,146,296,159,298,159,311,125,338,129,348,124,363,104,377,64,380,53,369,51,347,56,315,60,300,32,297,22,288
- image_area_coordinates_spirit
- count10
- the-united-kingdom(array)
- id10
- slugthe-united-kingdom
- titleThe United Kingdom
- image_area_coordinates71,49,95,48,92,60,108,62,106,72,97,85,114,110,127,136,140,139,142,146,139,157,141,164,125,179,107,181,90,184,69,187,67,178,81,165,72,153,87,149,87,139,78,138,91,131,78,111,63,122,52,115,36,113,60,88,57,69
- image_area_coordinates_spirit246,214,451,213,450,395,245,394
- count4
- argentina(array)
- categories(array)
- data(array)
- groupwine
- activePages(array)
- 01
- 112
- 232
- page(array)
- FrontpagePage(array)
- id32
- parent_id12
- nleft61
- nright62
- level0
- sorting0
- nameSearch
- titleSearch
- slugsearch
- typepage
- url/products/search
- external_url(null)
- folder_key(null)
- alias_id(null)
- meta_title
- meta_keywords
- meta_description
- in_sitemap(false)
- sitemap_modified2012-10-12 14:04:49
- sitemap_changesnever
- 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_fileproduct-filters
- layout_file_recursive0
- view_filedefault
- view_file_recursive0
- use_url_as_view0
- meta_title_template(null)
- options(null)
- options_local(null)
- tags
- notes(null)
- created2012-10-12 14:05:12
- created_by4
- modified2018-04-23 11:43:53
- modified_by5
- 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)
- FrontpagePage(array)
- $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)
- ProductProducer(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/app/ APP_DIR app APPLIBS /var/www/app/Lib/ CACHE /var/www/app/tmp/cache/ CAKE /var/www/cake/lib/Cake/ CAKE_CORE_INCLUDE_PATH /var/www/cake/lib CORE_PATH /var/www/cake/lib/ CAKE_VERSION 2.4.6 CSS /var/www/app/webroot/css/ CSS_URL css/ DS / FULL_BASE_URL http://127.0.0.1:8020 IMAGES /var/www/app/webroot/img/ IMAGES_URL img/ JS /var/www/app/webroot/js/ JS_URL js/ LOGS /var/www/app/tmp/logs/ ROOT /var/www TESTS /var/www/app/Test/ TMP /var/www/app/tmp/ VENDORS /var/www/vendors/ WEBROOT_DIR webroot WWW_ROOT /var/www/app/webroot/ PHP Environment
Environment Variable Value Php Version 5.6.40 Php Extra Configure Args --enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data --disable-cgi Hostname 42fae3577f7a Php Ini Dir /usr/local/etc/php Shlvl 1 Home /home/www-data Php Ldflags -Wl,-O1 -Wl,--hash-style=both -pie Php Cflags -fstack-protector-strong -fpic -fpie -O2 Php Md5 Gpg Keys 0BD78B5F97500D450838F95DFE857D9A90D90EC1 6E4F6AB321FDC07F2C332E3AC2BF0BC433CFC8B3 Php Cppflags -fstack-protector-strong -fpic -fpie -O2 Php Asc Url https://secure.php.net/get/php-5.6.40.tar.xz.asc/from/this/mirror Php Url https://secure.php.net/get/php-5.6.40.tar.xz/from/this/mirror Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin Phpize Deps autoconf dpkg-dev dpkg file g++ gcc libc-dev make pkgconf re2c Pwd /var/www/app Php Sha256 1369a51eee3995d7fbd1c5342e5cc917760e276d561595b6052b21ace2656d1c User www-data Fcgi Role RESPONDER Query String Request Method GET Content Type Content Length Script Name /index.php Request Uri /products/search/producer:adami Document Uri /index.php Document Root /var/www/app/webroot Server Protocol HTTP/1.0 Request Scheme http Gateway Interface CGI/1.1 Server Software nginx/1.27.2 Remote Addr 172.18.0.1 Remote Port 58664 Server Addr 172.18.0.3 Server Port 80 Server Name Redirect Status 200 Script Filename /var/www/app/webroot/index.php Http Host 127.0.0.1:8020 Http Connection close Http Accept */* Http User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) Http Accept Encoding gzip, br, zstd, deflate Http Referer https://astrumwinecellars.com/products/search/producer:adami Php Self /index.php Request Time Float 1730299115.5489 Request Time 1730299115 Argc 0 ==== -
Include +
Included Files
Include Paths
- 0/var/www/lib
- 2/usr/local/lib/php
- 3-> /var/www/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
- Behavior(array)
- 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
- Config(array)
- plugins(array)
- AclBase(array)
- Behavior(array)
- 0AclBase/Model/Behavior/AclBaseBehavior.php
- Behavior(array)
- Admin(array)
- Config(array)
- 0Admin/Config/bootstrap.php
- 1Admin/Config/routes.php
- Config(array)
- 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
- Controller(array)
- AppAdmin(array)
- Config(array)
- 0AppAdmin/Config/bootstrap.php
- 1AppAdmin/Config/routes.php
- Config(array)
- Asset(array)
- Config(array)
- 0Asset/Config/bootstrap.php
- 1Asset/Config/routes.php
- Config(array)
- AssetAdmin(array)
- Config(array)
- 0AssetAdmin/Config/bootstrap.php
- 1AssetAdmin/Config/routes.php
- Config(array)
- AssetCompress(array)
- Config(array)
- 0AssetCompress/Config/routes.php
- Config(array)
- Attachment(array)
- Config(array)
- 0Attachment/Config/routes.php
- Config(array)
- CakePdf(array)
- Config(array)
- 0CakePdf/Config/bootstrap.php
- Config(array)
- Config(array)
- Config(array)
- 0Config/Controller/Component/IniComponent.php
- Config(array)
- ContactAdmin(array)
- Config(array)
- 0ContactAdmin/Config/bootstrap.php
- 1ContactAdmin/Config/routes.php
- Config(array)
- CookieComplianceAdmin(array)
- Config(array)
- 0CookieComplianceAdmin/Config/bootstrap.php
- 1CookieComplianceAdmin/Config/routes.php
- Config(array)
- 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
- Component(array)
- Enews(array)
- Config(array)
- 0Enews/Config/bootstrap.php
- 1Enews/Config/routes.php
- Config(array)
- EnewsAdmin(array)
- Config(array)
- 0EnewsAdmin/Config/bootstrap.php
- 1EnewsAdmin/Config/routes.php
- Config(array)
- Expandable(array)
- Behavior(array)
- 0Expandable/Model/Behavior/ExpandableBehavior.php
- Behavior(array)
- 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
- Config(array)
- FrontpageAdmin(array)
- Config(array)
- 0FrontpageAdmin/Config/bootstrap.php
- 1FrontpageAdmin/Config/routes.php
- Config(array)
- FrontpageUser(array)
- Model(array)
- 0FrontpageUser/Model/FrontpageUser.php
- 1FrontpageUser/Model/FrontpageUserAppModel.php
- Model(array)
- FrontpageUserAdmin(array)
- Config(array)
- 0FrontpageUserAdmin/Config/bootstrap.php
- 1FrontpageUserAdmin/Config/routes.php
- Config(array)
- Gapi(array)
- Config(array)
- 0Gapi/Config/routes.php
- Config(array)
- GeographyAdmin(array)
- Config(array)
- 0GeographyAdmin/Config/bootstrap.php
- 1GeographyAdmin/Config/routes.php
- Config(array)
- Google(array)
- Behavior(array)
- 0Google/Model/Behavior/GoogleMapCoordinateBehavior.php
- Behavior(array)
- HabtmCounterCache(array)
- Behavior(array)
- 0HabtmCounterCache/Model/Behavior/HabtmCounterCacheBehavior.php
- Behavior(array)
- News(array)
- Config(array)
- 0News/Config/bootstrap.php
- Config(array)
- NewsAdmin(array)
- Config(array)
- 0NewsAdmin/Config/bootstrap.php
- 1NewsAdmin/Config/routes.php
- Config(array)
- Product(array)
- Config(array)
- 0Product/Config/bootstrap.php
- Controller(array)
- 0Product/Controller/ProductsController.php
- 1Product/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/ProductProducer.php
- 4Product/Model/ProductImage.php
- Config(array)
- ProductAdmin(array)
- Config(array)
- 0ProductAdmin/Config/bootstrap.php
- 1ProductAdmin/Config/routes.php
- Config(array)
- Quote(array)
- Config(array)
- 0Quote/Config/bootstrap.php
- Config(array)
- QuoteAdmin(array)
- Config(array)
- 0QuoteAdmin/Config/bootstrap.php
- 1QuoteAdmin/Config/routes.php
- Config(array)
- Slug(array)
- Behavior(array)
- 0Slug/Model/Behavior/SluggableBehavior.php
- Behavior(array)
- Sorting(array)
- Behavior(array)
- 0Sorting/Model/Behavior/IncrementalBehavior.php
- Behavior(array)
- Tag(array)
- Behavior(array)
- 0Tag/Model/Behavior/TaggableBehavior.php
- Model(array)
- 0Tag/Model/Tag.php
- 1Tag/Model/TagAppModel.php
- Behavior(array)
- UniqueKey(array)
- Behavior(array)
- 0UniqueKey/Model/Behavior/UniqueKeyBehavior.php
- Behavior(array)
- User(array)
- Behavior(array)
- 0User/Model/Behavior/LoggingBehavior.php
- Model(array)
- 0User/Model/User.php
- Behavior(array)
- UserAdmin(array)
- Config(array)
- 0UserAdmin/Config/bootstrap.php
- 1UserAdmin/Config/routes.php
- Config(array)
- AclBase(array)
====