- Home
- About
- Producers
- Wine
- Spirits
- News & Events
- Contact
- Terms & Conditions
- Sitemap
- Enjoy responsibly - drinkaware.co.uk
- Cornas 'Les Versantes'
- Saint-Joseph Rouge 'Grand Angle'
- Aglianico Beneventano
- Aglianico Quirico
- Albana di Romagna 'Isola'
- Albariño
- Albariño Natural
- Albariño Tradición
- Alta Langa DOCG Extra Brut
- Alta Valle della Greve 'Capogatto'
- Alta Valle della Greve 'Il Carbonaione'
- Alta Valle della Greve 'Piantonaia'
- Amaretto
- Amaro Laziale
- Amarone della Valpolicella Classico Sant'Urbano
- Amarone della Valpolicella Classico Sant'Urbano
- Amarone della Valpolicella Classico Sant'Urbano
- Amarone della Valpolicella Classico Sant'Urbano
- Amarone della Valpolicella Riserva
- Americano 1907 Barrel Finished Cocktail
- Aperitivo
- Arcum
- Asolo Prosecco Superiore DOCG Extra Dry
- Barbados Rhapsody Blended Rum (2022 Edition)
- Barbados Rum Cask 1 (2021 Edition) 2001
- Barbaresco
- Barbaresco - Magnum
- Barbaresco Double - Magnum
- Barbaresco Riserva 'Asili'
- Barbaresco Riserva 'Don Fiorino'
- Barbaresco Riserva 'Montefico'
- Barbaresco Riserva 'Montestefano'
- Barbaresco Riserva 'Muncagota'
- Barbaresco Riserva 'Ovello'
- Barbaresco Riserva 'Pajé'
- Barbaresco Riserva 'Pora'
- Barbaresco Riserva 'Rabajà'
- Barbaresco Riserva 'Rio Sordo'
- Barbera D'Alba
- Barbera d'Asti
- Barbera d'Asti Superiore Nizza
- Barolo
- Barolo 'Undicicomuni'
- Barolo Brunate
- Barolo Brunate
- Barolo Brunate - Magnum
- Barolo Bussia
- Barolo Cannubi
- Barolo Castello
- Barolo Cerretta
- Barolo Classico
- Barolo Classico - Magnum
- Barolo Prapò
- Barolo Ravera
- Barolo Riserva Bussia Vigna Mondoca
- Barolo Riserva Vignarionda
- Barolo Riserva Vignarionda - Magnum
- Barolo Riserva Vignarionda - Magnum
- Barolo Serralunga
- Barolo Serralunga - Half Bottle
- Barolo Serralunga - Magnum
- Barolo Vignarionda
- Barolo Villero
- Beaujolais Villages 'Stellogonie'
- Bianco Friuli Colli Orientali
- Bitter
- Boca - Organic
- Bollicine Rosé
- Bourgogne Chardonnay
- Bourgogne Chardonnay
- Bourgogne Pinot Noir
- Bourgogne Pinot Noir 'Les Ardillers'
- Bramaterra
- Bramaterra Rocce di Luce
- Bramaterra Salero
- Branco
- Brandy 10Yrs
- Brandy 23Yrs
- Brunello di Montalcino
- Brunello di Montalcino
- Brunello di Montalcino 'La Casa'
- Brunello di Montalcino 'La Casa'
- Brunello di Montalcino - Half Bottle
- Brunello di Montalcino - Magnum
- Brunello di Montalcino Filo di Seta
- Brunello di Montalcino Rio Cassero
- Brunello di Montalcino Riserva
- Brut Reserve
- Cabernet Franc
- Calabria Bianco 'Manere'
- Canaiolo
- Cannonau di Sardegna 'Lillové'
- Cannonau di Sardegna Riserva Dule
- Carema Classico
- Carema Etichetta Bianca
- Carema Etichetta Bianca - Magnum
- Carema Etichetta Nera
- Carema Etichetta Nera - Magnum
- Carema Riserva
- Carema Selezione
- Carjcanti - Organic
- Cerasuolo di Vittoria
- Chablis
- Chablis - Half Bottle
- Chablis Archives
- Chablis Archives Vieilles Vignes
- Chablis Pérégrinations Chronique
- Chablis Premier Cru Côte de Jouan
- Chablis Premier Cru Vaillons
- Champagne Grand Cru Blanc de Blancs 'Les Sillons'
- Champagne Grand Cru Blanc de Blancs Extra Brut 'L’Évidence'
- Champagne Grand Cru Blanc de Blancs Extra Brut 'L’Évidence' - Magnum
- Champagne Grand Cru Blanc de Blancs Millésime
- Champagne Intuition Brut
- Champagne Intuition Rosé Brut
- Champagne L’Éloquente Brut
- Chardonnay
- Chardonnay
- Chardonnay 'Monopolia Sannicola'
- Chardonnay Friuli Colli Orientali
- Chardonnay Kreuth
- Chardonnay Kreuth - Magnum
- Chardonnay Somereto
- Chardonnay Tradition
- Châteauneuf du Pape Blanc
- Châteauneuf du Pape Rouge
- Cherry Brandy
- Chianti 'Biskero' - Organic
- Chianti 'Biskero' - Organic - Magnum
- Chianti Classico
- Chianti Classico - Half Bottle - Organic
- Chianti Classico - Organic
- Chianti Classico Riserva 'Cortevecchia' - Organic
- Chiaretto Riviera del Garda Classico 'San Donino'
- Cialla Bianco
- Cialla Bianco - Magnum
- Cirò Bianco - Organic
- Cirò Rosato - Organic
- Cirò Rosso Classico Superiore - Organic
- Coffee Brandy
- Cognac Grande Champagne N.72 (2021 Edition)
- Colección Malbec
- Colline Novaresi DOC Agamium
- Collines Rhodaniennes Syrah 'Les Jardins de Chavagnac'
- Corvina
- Costa Toscana Birillo - Organic
- Coste della Sesia 'Rossonoah'
- Coste della Sesia Nebbiolo 'Orbello'
- Coste della Sesia Rosato 'Majoli'
- Côtes de Gascogne Blanc
- Côtes de Provence Rosé
- Côtes du Rhône Blanc
- Côtes du Rhône Rouge
- Croatina Colli Tortonesi 'Montemirano'
- Crozes-Hermitage
- Cuvée Auslese
- Demerara Rum Cask N.1700051 (2020 Edition)
- Distillato di Albicocche Val Venosta
- Distillato di Bacche di Sambuco
- Distillato di Ciliegie Duroni
- Distillato di Lamponi Selvatici
- Distillato di Mele Decio di Belfiore
- Distillato di Pere Williams
- Distillato di Pesche Saturno
- Distillato di Prugne Selvatiche
- Distillato di Prunus Aurum
- Distillato di Ribes Nero
- Distillato di Uva Isabella
- Distillato di Vino (Brandy)
- Doi Raps
- Dolcetto D'Alba Roussot
- Dolcetto Diano d'Alba 'Sorì del Cascinotto'
- Dusk Manhatten Cherry Brandy
- Dusk Negroni Brandy
- Erbaluce di Caluso Etichetta Verde
- Etna Bianco
- Etna Bianco Gamma
- Etna Rosso
- Etna Rosso Il Purgatorio
- Extra Brut Rosé Metodo Classico 'Rosanna'
- Falanghina Beneventano
- Fiano
- Fiano 'Il Cupo'
- Fiano - Organic
- Fiano Puglia
- Freisa Colli Tortonesi Braghé
- Friulano Buri Bellaria
- Friulano Collio 'San Lorenzo'
- Friulano Friuli Colli Orientali
- Furmint
- Gattinara Riserva
- Gattinara Riserva - Double Magnum
- Gattinara Riserva - Magnum
- Gattinara Selezione
- Gattinara Selezione - Double Magnum
- Gattinara Selezione - Magnum
- Gattinara Tre Vigne
- Gavi
- Gavi
- Gavi del Comune di Gavi
- Genziana Superiore
- Gewürztraminer Tradition
- Ghemme Anno Primo
- Ghemme Collis Breclemae
- Ghemme Collis Breclemae
- Ghemme Collis Breclemae
- Ghemme Collis Carellae
- Ghemme Collis Carellae
- Ghyll Valley White
- Gin
- Gin Juniperus Cask Finish
- Grappa Classica
- Grappa di Amarone
- Grappa di Bassano
- Grappa di Brunello di Montalcino
- Grappa di Cabernet Sauvignon
- Grappa di Moscato Giallo
- Grappa di Nebbiolo
- Grappa di Nebbiolo (Barrel Aged)
- Grappa di Ribolla Gravner
- Grappa Tabacco Amarone
- Greco
- Greco di Tufo
- Grillo 'Lumà'
- Grillo 'Rocce di Pietra Longa' - Organic
- Grillo-Catarratto Giato Bianco - Organic
- Grüner Veltliner - Organic
- Grüner Veltliner Beerenauslese - Half Bottle
- Haiti Rum Cask N.23 (2022 Edition)
- Islay Single Malt Scotch Whisky (2022 Edition)
- Islay Single Malt Scotch Whisky Caol Ila Cask N.2100012 (2022 Edition)
- Islay Single Malt Scotch Whisky Caol Ila Cask N.301632 (2021 Edition)
- Italian Espresso Coffee Liqueur Ninebar
- Jamaica Rhapsody Blended Rum (2022 Edition)
- Jamaica Rum Cask N.435083 (2021 Edition)
- Jerry Thomas Instant Age Classic Oak Aromatic Bitter
- Kerner
- Kerner 'Aristos'
- Lagrein 'Rubeno'
- Lagrein Riserva 'Gries'
- Lagrein Riserva 'Porphyr'
- Lagrein Rosé Tradition
- Langhe Freisa
- Langhe Nascetta del Comune di Novello
- Langhe Nebbiolo
- Langhe Nebbiolo
- Langhe Riesling Hérzu
- Lessona
- Lessona
- Lessona San Sebastiano allo Zoppo
- Limoncello di Amalfi
- Limoncello Primitivo
- Liquore di Assenzio Bianco (Absinthe Liqueur)
- Liquore di Bergamotto (Bergamot Liqueur)
- Liquore di Camomilla (Chamomile Liqueur)
- Liquore di China (Cinchona Liqueur)
- Liquore di Chinotto
- Liquore di Ciliegia (Cherry Liqueur)
- Liquore di Doppio-Carvi (Caraway Liqueur)
- Liquore di Fernet
- Liquore di Gelsomino (Jasmine Liqueur)
- Liquore di Lampone (Raspberry Liqueur)
- Liquore di Nocciola (Hazelnut Liqueur)
- Liquore di Pino Mugo (Pine Liqueur)
- Liquore di Rabarbaro (Rhubarb Liqueur)
- Liquore di Rosa (Rose Liqueur)
- Liquore di Sambuco (Elderflower Liqueur)
- Liquore di Tamarindo (Tamarind Liqueur)
- Liquore di Uva Fragola (Fox Grape Liqueur)
- Liquore di Violetta (Violet Liqueur)
- Liquore di Zafferano (Saffron Liqueur)
- Liquore di Zenzero (Ginger Liqueur)
- Liquore Nocino - Organic
- Lugana 'Selva'
- Lussac-Saint-Émilion 'Château Chéreau'
- Lussac-Saint-Émilion 'L'Egérie du Château Chéreau'
- Macon Prissé
- Malvasia Collio 'Vigna 80 Anni'
- Malvasia-Chardonnay
- Manzoni Bianco
- Martinez 1887 Barrel Finished Cocktail
- McLaren Vale Shiraz
- Mencía La Premisa
- Merlot Friuli Colli Orientali Buri
- Merlot Friuli Colli Orientali Filip
- Merlot Massarac
- Metodo Classico Pas Dosé 'Nebolè'
- Montepulciano d'Abruzzo 'Malandrino' - Organic
- Montepulciano d'Abruzzo - Organic
- Morgon Charmes
- Moscato d'Asti
- Moscato d'Asti - Half Bottle
- Mtsvane
- Müller-Thurgau
- Nachschlag 'Bright Side of Life'
- Nebbiolo Coste della Sesia
- Negroamaro - Organic
- Negroni 1919 Barrel Finished Cocktail
- Nerello Mascalese 'Pietre a Purtedda da Ginestra' - Organic
- Nero d'Avola Terre Siciliane
- Nero d'Avola-Perricone Giato Rosso - Organic
- Nero di Troia 'Lampryris' - Organic
- Nero di Troia - Organic
- Nero di Troia Rosato Pét-Nat Ancestrale - Organic
- NeroBaronj - Organic
- NeroBufaleffj - Organic
- NeroSanloré - Organic
- NeroSanloré - Organic
- New Orange Brandy
- Obvius Bianco - Organic
- Old Tom Gin
- Orange Brandy
- Orange Kisi
- Orange Liquor (2021 Edition)
- Pacific Oblivion Rum Cask N.50 (2021 Edition)
- Pario
- Passito di Pantelleria
- Pecorino 'Giulia'
- Per Filo - Organic
- Phigaia 'After The Red'
- Piemonte Bianco 'Piandoro'
- Pinot Bianco 'Finado'
- Pinot Bianco Rarity
- Pinot Bianco Riserva 'Vorberg'
- Pinot Bianco Riserva 'Vorberg' - Magnum
- Pinot Bianco Tradition
- Pinot Grigio
- Pinot Grigio Ronco Calaj
- Pinot Grigio Tradition
- Pinot Grigio Veneto
- Pinot Gris
- Pinot Noir Gumpoldskirchen Grillenhügel - Organic
- Pinot Noir Holzspur - Organic
- Pinot Noir Riserva 'Monticol'
- Pinot Noir Tattendorf - Organic
- Pinot Noir Tattendorf - Organic
- Pinot Noir Tradition
- Pomerol 'Domaine de la Pointe'
- Port 10 Year Old Tawny
- Port Late Bottle Vintage
- Premium Furmint Nagy Somlói
- Primitivo - Organic
- Primitivo di Manduria 'Magnifico Rosso Fuoco'
- Primitivo Puglia
- Priorat DOQ '90 Minuts'
- Prosecco Spumante DOC Extra Dry
- Recantina
- Recioto della Valpolicella Classico
- Recioto della Valpolicella Classico La Roggia
- Refosco dal Peduncolo Rosso
- Refosco Friuli Colli Orientali Cossut
- Régnié Archambault
- Rhum Rhum Blanc Agricole (Green)
- Rhum Rhum Blanc Agricole (Orange)
- Rhum Rhum Libération 45% (NLA)
- Rhum Rhum Libération 58% (NLA)
- Ribolla Gialla
- Ribolla Gialla Friuli Colli Orientali Pettarin
- Riesling
- Rioja Alavesa
- Rioja Alavesa 'letras minúsculas'
- Rioja Alavesa Garnacha Blanca 'Cifras'
- Rioja Alavesa Garnacha Tinta 'Cifras'
- Rioja Alavesa Malvasia 'La Greña'
- Rkatsiteli
- Rosato Puglia
- Rosé
- Rose Gin
- Rosso Buri Bellaria
- Rosso del Veronese
- Rosso dell'Abazia
- Rosso di Montalcino
- Rosso di Montefalco
- Rosso Dottor Palazzolo
- Rosso Friuli Colli Orientali
- Rossojbleo - Organic
- Roter Eiswein - Half Bottle - Organic
- Rotgipfler 'Satzing' - Organic
- Rotgipfler - Organic
- Rùbeo
- Sagrantino di Montefalco Riserva 'Il Domenico'
- Saint Véran
- Saint-Joseph Blanc 'Grand Angle'
- Samba Blended Rum (2022 Edition)
- Sambuca Fina
- Sämling Trockenbeerenauslese - Half Bottle
- Sämling Trockenbeerenauslese - Half Bottle
- San Martino della Battaglia 'Campo del Soglio'
- Sancerre 'Silex' - Organic
- Sangiovese di Romagna Superiore 'Balitore'
- Sangiovese di Toscana
- Sangiovese Rubicone
- Sangiovese-Merlot
- Saperavi
- Sauvignon 'Quarz'
- Sauvignon 'Quarz' - Magnum
- Sauvignon 'Winkl'
- Sauvignon Blanc
- Sauvignon Blanc
- Sauvignon Blanc Andrius
- Sauvignon Blanc Earth Series
- Sauvignon Friuli Colli Orientali
- Sauvignon Friuli Colli Orientali Casa Rossa
- Sauvignon Friuli Colli Orientali Saurint
- Sauvignon Friuli Colli Orientali Zitelle
- Sauvignon Iris
- Sauvignon Lozeta
- Sauvignon Peri
- Sauvignon Serena
- Sauvignon Sol
- Scheurebe 'Cyriakusberg'
- Schioppettino
- Schioppettino di Cialla
- Schioppettino RiNera
- Silvaner
- Single Malt Irish Whisky Cask N.10049 (2021 Edition)
- Single Malt Scotch Whisky Bowmore Sherry Cask N.54 (2021 Edition)
- Single Malt Scotch Whisky Magnifico Macallan Cask N.1219 (2022 Edition)
- Single Malt Scotch Whisky Magnifico Springbank Cask N.567 (2022 Edition)
- Single Malt Scotch Whisky Magnifico Springbank Cask N.63 (2021 Edition)
- Sirkel Chenin Blanc
- Sirkel Shiraz Viognier
- Soave Classico
- Soave Classico - Half Bottle
- Soave Classico Casette Foscarino
- Soave Mito
- Spätlese Merlot
- Speyside Single Malt Scotch Whisky (2022 Edition)
- Speyside Single Malt Scotch Whisky Braeval Cask N.165697 (2022 Edition)
- Speyside Single Malt Scotch Whisky Glentauchers Cask N.901229 (2022 Edition)
- SPQR Blended Rum (2022 Edition)
- St. Laurent - Organic
- Sylvaner 'Sabiona'
- Syrah 'Lumà'
- Taurasi
- Terlaner Cuvée
- Terlaner Cuvée - Half Bottle
- Terlaner Cuvée - Magnum
- Terlaner Cuvée Riserva 'Nova Domus'
- Terlaner Cuvée Riserva 'Nova Domus' - Magnum
- Terlaner I Grande Cuvée Primo
- Terlaner I Grande Cuvée Primo - Magnum
- Timorasso Colli Tortonesi Bricco San Michele
- Timorasso Colli Tortonesi Cavallina
- Tinto
- Toscana Rosso Brio
- Toscana Rosso Romitorio
- Trebbiano d'Abruzzo - Organic
- Trebbiano Rubicone
- Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica'
- Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Half Bottle
- Valdobbiadene DOCG Prosecco Superiore 'Bosco di Gica' - Magnum
- Valdobbiadene DOCG Prosecco Superiore Rive di Farra di Soligo 'Col Credas'
- Valdobbiadene DOCG Prosecco Superiore Sui Lieviti Brut Nature 'Col Fondo'
- Valpolicella Classico
- Valpolicella Classico Superiore Ripasso
- Valpolicella Classico Superiore Sant'Urbano
- Veneto Rosso IGT
- Verdicchio di Matelica - Organic
- Verduno Pelaverga
- Verduzzo di Cialla
- Verduzzo di Cialla - Half Bottle
- Vermentino di Sardegna Manzanile
- Vermouth Bianco
- Vermouth di Torino Superiore Bianco
- Vermouth di Torino Superiore Rosso
- Vermouth Rosso
- Vernaccia di San Gimignano - Organic
- Vernaccia di San Gimignano Riserva - Organic
- Vernaccia di San Gimignano Vigna Santa Margherita - Organic
- Vin Santo 'Sant'Andrea Corsini'
- Vino Nobile di Montepulciano 'Salco' - Organic
- Vino Nobile di Montepulciano - Half Bottle - Organic
- Vino Nobile di Montepulciano - Magnum - Organic
- Vino Nobile di Montepulciano - Organic
- Watervale Riesling
- Weissburgunder
- Wien.1
- Wien.2
- Yehmon Classic Blended Rum (2022 Edition)
- Yehmon Retro Blended Rum (2022 Edition)
- Yehmon Vintage Blended Rum (2022 Edition)
- Zweigelt - Organic
- Adami
- Adanti
- Adelina
- Amoterra
- Antica Distilleria Quaglia
- Antichi Vigneti di Cantalupo
- ArnaldoRivera
- Ascione-Alongi
- Balìa di Zola
- Bèrto
- Besas
- Black Cottage
- Bodegas Estraunza
- Bodegas Tierra - Creaciones Exeo
- Caiaffa
- Cantina Andriano
- Cantina Terlano
- Cantina Valle Isarco
- Cantine Cellaro
- Caparzo
- Capovilla Distillati
- Castello Romitorio
- Cataldi Madonna
- Centopassi
- Claudio Mariotto
- Colazingari Liquori
- Domaine Azzara
- Domaine Begue-Mathiot
- Domaine de la Pierre des Dames
- Domaine des Pérégrins
- Domaine Raphaël Chopin
- Ettore Germano
- Familie Reinisch
- Federico Curtaz
- Ferrando
- Folli & Benato
- Fondo Indizeno
- Francesco Rinaldi
- François Le Saint
- Gabbas
- Gulfi
- Highweald Wine Estate
- I Clivi
- Jean de la Fontaine
- L'Arco
- Lagar de Costa
- Lapilli
- Legras & Haas
- Maison Étoilée
- Miani
- Monte Tondo
- Monteleone
- Mr. Quail & J.T
- Noah
- Oddero
- Olivier & Lafont
- Panizzi
- Paolo Saracco
- Passagem
- Pfaffl
- Pietracupa
- Poggio Scalette
- Produttori del Barbaresco
- Produttori del Carema
- Rhum Rhum
- Ronchi di Cialla
- Ronco del Gnemiz
- Russolo
- Salcheto
- Samaroli
- Scali
- Selva Capuzza
- Serafini & Vidotto
- Solidea
- Speri
- Tenuta del Conte
- Tenuta Marsiliana - Principe Corsini
- Tenute Guardasole
- Tenute Sella
- Terra di Limoni
- Thomas Farge
- Tiko Estate
- Tinkture
- Tornai Pincészet
- Travaglini
- Trossos del Priorat
- Verus
- Vignobles Silvestrini
- Villa Le Corti - Principe Corsini
- Villa Zarri
- Vincent Wengier
- Vinos Valtuille
- Weingut Tschida Angerhof
- Winzerhof Stahl
- Argentina
- Australia
- Austria
- France
- Georgia
- Germany
- Guadeloupe
- Hungary
- Italy
- New Zealand
- Portugal
- Slovenia
- South Africa
- Spain
- The Netherlands
- The United Kingdom
-
- History
- Session
-
Request +
Request
Cake Params
- pluginfrontpage
- controllerfrontpage_pages
- actiondisplay
- named(empty)
- pass(array)
- 0sitemap
- isAjax(false)
Post data
No post data.
Query string
No querystring data.
Cookie
To view Cookies, add CookieComponent to Controller
Current Route
- keys(empty)
- options(empty)
- defaults(array)
- pluginfrontpage
- controllerfrontpage_pages
- actiondisplay
- template/*
==== -
Sql Log +
Sql Logs
default
Total Time: 53 ms
Total Queries: 71 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` = '/sitemap' 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` = '/sitemap' AND `FrontpagePage`.`status` = 1 LIMIT 1 1 1 0 SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 6 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` <= 24 AND `FrontpagePage`.`nright` >= 25 ORDER BY `FrontpagePage`.`nleft` asc 2 2 0 SELECT `FrontpageContentCategory`.`id` FROM `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'hero' LIMIT 1 1 1 0 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`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`extract`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Image`.`google_drive_file_id`, `Quote`.`id`, `Quote`.`uid`, `Quote`.`title`, `Quote`.`text`, `Quote`.`quotee`, `Quote`.`image_id`, `Quote`.`sorting`, `Quote`.`status`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` LEFT JOIN `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `astrum`.`oc_quotes` AS `Quote` ON (`FrontpageContent`.`quote_id` = `Quote`.`id`) WHERE `FrontpageContent`.`frontpage_page_id` = 6 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 1 ORDER BY `FrontpageContent`.`sorting` asc 0 0 0 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 `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`, `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_routes` AS `FrontpageRoute` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRoute`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRoute`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRoute`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRoute`.`status` = 1 AND NOT (`FrontpagePage`.`id` IS NULL) 30 30 1 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` = 5 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 10 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 4 4 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`, `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_routes` AS `FrontpageRoute` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRoute`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRoute`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRoute`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRoute`.`status` = 1 AND NOT (`FrontpagePage`.`id` IS NULL) 30 30 1 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` = 43 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 42 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 44 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 45 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 11 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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`, `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_routes` AS `FrontpageRoute` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRoute`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRoute`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRoute`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRoute`.`status` = 1 AND NOT (`FrontpagePage`.`id` IS NULL) 30 30 1 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` = 35 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 36 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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 `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`, `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_routes` AS `FrontpageRoute` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRoute`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRoute`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRoute`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRoute`.`status` = 1 AND NOT (`FrontpagePage`.`id` IS NULL) 30 30 1 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` = 32 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 33 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 0 0 0 SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`external_url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`logged_in_only`, `FrontpagePage`.`logged_out_only`, `FrontpagePage`.`user_landing_page`, `FrontpagePage`.`overlay`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `astrum`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 51 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 2 2 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`, `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_routes` AS `FrontpageRoute` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRoute`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRoute`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRoute`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRoute`.`status` = 1 AND NOT (`FrontpagePage`.`id` IS NULL) 30 30 1 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` = 52 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 53 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 8 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 13 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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`, `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_routes` AS `FrontpageRoute` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRoute`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRoute`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRoute`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRoute`.`status` = 1 AND NOT (`FrontpagePage`.`id` IS NULL) 30 30 1 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` = 55 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 19 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 0 0 0 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 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`, `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_routes` AS `FrontpageRoute` LEFT JOIN `astrum`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRoute`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`FrontpageRoute`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`FrontpageRoute`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRoute`.`status` = 1 AND NOT (`FrontpagePage`.`id` IS NULL) 30 30 1 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` = 3 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 6 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` 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` = 48 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 0 0 0 SELECT `Product`.`id`, `Product`.`uid`, `Product`.`title`, `Product`.`slug`, `Product`.`code`, `Product`.`business_price`, `Product`.`product_category_id`, `Product`.`product_grape_variety_id`, `Product`.`geography_region_id`, `Product`.`vintage`, `Product`.`vineage`, `Product`.`product_producer_id`, `Product`.`product_distributor_id`, `Product`.`product_range_id`, `Product`.`soil`, `Product`.`training`, `Product`.`yield`, `Product`.`ageing`, `Product`.`vinification`, `Product`.`alcohol`, `Product`.`product_bottle_closure_type_id`, `Product`.`product_bottle_size_id`, `Product`.`product_case_size_id`, `Product`.`ph_level`, `Product`.`acidity`, `Product`.`residual_sugar_content`, `Product`.`method_and_production`, `Product`.`tasting_notes`, `Product`.`food_match`, `Product`.`status`, `Product`.`sorting`, `Product`.`created`, `Product`.`created_by`, `Product`.`modified`, `Product`.`modified_by`, `ProductProducer`.`id`, `ProductProducer`.`uid`, `ProductProducer`.`name`, `ProductProducer`.`slug`, `ProductProducer`.`address`, `ProductProducer`.`geography_region_id`, `ProductProducer`.`telephone`, `ProductProducer`.`fax`, `ProductProducer`.`email`, `ProductProducer`.`website`, `ProductProducer`.`year_established`, `ProductProducer`.`total_hectares`, `ProductProducer`.`vintner_names`, `ProductProducer`.`description`, `ProductProducer`.`quotes`, `ProductProducer`.`logo_id`, `ProductProducer`.`latitude`, `ProductProducer`.`longitude`, `ProductProducer`.`pdf_new`, `ProductProducer`.`status`, `ProductProducer`.`sorting`, `ProductProducer`.`created`, `ProductProducer`.`created_by`, `ProductProducer`.`modified`, `ProductProducer`.`modified_by`, `ProductDistributor`.`id`, `ProductDistributor`.`uid`, `ProductDistributor`.`title`, `ProductDistributor`.`slug`, `ProductDistributor`.`image_id`, `ProductDistributor`.`status`, `ProductDistributor`.`sorting`, `ProductDistributor`.`created`, `ProductDistributor`.`created_by`, `ProductDistributor`.`modified`, `ProductDistributor`.`modified_by`, `ProductRange`.`id`, `ProductRange`.`uid`, `ProductRange`.`title`, `ProductRange`.`slug`, `ProductRange`.`image_id`, `ProductRange`.`status`, `ProductRange`.`sorting`, `ProductRange`.`created`, `ProductRange`.`created_by`, `ProductRange`.`modified`, `ProductRange`.`modified_by`, `ProductCaseSize`.`id`, `ProductCaseSize`.`uid`, `ProductCaseSize`.`title`, `ProductCaseSize`.`slug`, `ProductCaseSize`.`sorting`, `ProductCaseSize`.`status`, `ProductCaseSize`.`created`, `ProductCaseSize`.`created_by`, `ProductCaseSize`.`modified`, `ProductCaseSize`.`modified_by`, `ProductBottleSize`.`id`, `ProductBottleSize`.`uid`, `ProductBottleSize`.`title`, `ProductBottleSize`.`code`, `ProductBottleSize`.`slug`, `ProductBottleSize`.`sorting`, `ProductBottleSize`.`status`, `ProductBottleSize`.`created`, `ProductBottleSize`.`created_by`, `ProductBottleSize`.`modified`, `ProductBottleSize`.`modified_by`, `ProductBottleClosureType`.`id`, `ProductBottleClosureType`.`uid`, `ProductBottleClosureType`.`title`, `ProductBottleClosureType`.`slug`, `ProductBottleClosureType`.`sorting`, `ProductBottleClosureType`.`status`, `ProductBottleClosureType`.`created`, `ProductBottleClosureType`.`created_by`, `ProductBottleClosureType`.`modified`, `ProductBottleClosureType`.`modified_by`, `GeographyRegion`.`id`, `GeographyRegion`.`uid`, `GeographyRegion`.`geography_country_id`, `GeographyRegion`.`product_count`, `GeographyRegion`.`product_producer_count`, `GeographyRegion`.`title`, `GeographyRegion`.`slug`, `GeographyRegion`.`status`, `GeographyRegion`.`sorting`, `GeographyRegion`.`created`, `GeographyRegion`.`created_by`, `GeographyRegion`.`modified`, `GeographyRegion`.`modified_by`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_count`, ")")) AS `GeographyRegion__product_combo_title`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_producer_count`, ")")) AS `GeographyRegion__product_producer_combo_title`, `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_products` AS `Product` LEFT JOIN `astrum`.`oc_product_producers` AS `ProductProducer` ON (`Product`.`product_producer_id` = `ProductProducer`.`id`) LEFT JOIN `astrum`.`oc_product_distributors` AS `ProductDistributor` ON (`Product`.`product_distributor_id` = `ProductDistributor`.`id`) LEFT JOIN `astrum`.`oc_product_ranges` AS `ProductRange` ON (`Product`.`product_range_id` = `ProductRange`.`id`) LEFT JOIN `astrum`.`oc_product_case_sizes` AS `ProductCaseSize` ON (`Product`.`product_case_size_id` = `ProductCaseSize`.`id`) LEFT JOIN `astrum`.`oc_product_bottle_sizes` AS `ProductBottleSize` ON (`Product`.`product_bottle_size_id` = `ProductBottleSize`.`id`) LEFT JOIN `astrum`.`oc_product_bottle_closure_types` AS `ProductBottleClosureType` ON (`Product`.`product_bottle_closure_type_id` = `ProductBottleClosureType`.`id`) LEFT JOIN `astrum`.`oc_geography_regions` AS `GeographyRegion` ON (`Product`.`geography_region_id` = `GeographyRegion`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Product`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Product`.`modified_by` = `ModifiedBy`.`id`) WHERE `Product`.`status` = '1' ORDER BY `Product`.`title` asc 483 483 20 SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`title`, `ProductImage`.`image_id`, `ProductImage`.`status`, `ProductImage`.`sorting`, `ProductImage`.`created`, `ProductImage`.`created_by`, `ProductImage`.`modified`, `ProductImage`.`modified_by` FROM `astrum`.`oc_product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (1094, 1093, 779, 1038, 1187, 417, 865, 990, 884, 1190, 1189, 1191, 963, 1212, 1266, 1217, 1267, 1268, 880, 919, 601, 1227, 838, 1155, 1173, 108, 109, 110, 115, 1180, 113, 111, 112, 114, 117, 116, 561, 118, 588, 1128, 855, 103, 1062, 560, 1136, 1137, 1201, 106, 1199, 934, 882, 914, 936, 1200, 1058, 1033, 1278, 1279, 443, 97, 98, 1064, 845, 1288, 939, 602, 931, 193, 1084, 1282, 1285, 1273, 1140, 1107, 1108, 1256, 309, 704, 452, 955, 454, 1223, 453, 608, 956, 460, 554, 1119, 1052, 1133, 1185, 687, 686, 403, 137, 1276, 339, 1277, 493, 940, 1021, 1020, 1085, 1123, 1081, 1211, 1210, 1209, 1125, 980, 977, 978, 1048, 979, 981, 792, 1225, 1242, 976, 742, 655, 1206, 1248, 143, 1088, 1091, 536, 430, 868, 1188, 408, 257, 259, 1080, 388, 387, 1131, 1197, 1132, 537, 1163, 1271, 943, 1270, 810, 436, 877, 1117, 1183, 1202, 922, 1087, 1089, 1247, 1090, 569, 1153, 324, 1127, 320, 325, 988, 318, 321, 322, 989, 323, 317, 316, 984, 669, 1178, 1110, 1109, 136, 1193, 1195, 1194, 1196, 446, 565, 421, 274, 1007, 350, 993, 952, 973, 222, 1269, 133, 135, 734, 405, 1281, 130, 131, 123, 783, 121, 1213, 146, 1144, 945, 1145, 1272, 944, 1146, 1224, 604, 694, 516, 312, 310, 314, 1172, 313, 315, 891, 738, 326, 420, 566, 407, 427, 679, 490, 1249, 1157, 1159, 1151, 1012, 1235, 1160, 1011, 689, 873, 930, 624, 164, 166, 1232, 1244, 1067, 107, 842, 92, 1141, 941, 1280, 303, 1192, 515, 514, 512, 1147, 513, 701, 616, 666, 1263, 615, 888, 553, 700, 864, 887, 1265, 1184, 863, 1148, 1264, 307, 1246, 499, 503, 1283, 974, 346, 1134, 918, 1135, 1204, 338, 159, 234, 1240, 244, 1129, 1286, 126, 127, 1254, 169, 1097, 404, 696, 917, 894, 351, 680, 1231, 803, 1230, 1023, 1024, 1026, 1027, 1111, 683, 892, 695, 1069, 1164, 1013, 1228, 287, 242, 899, 196, 1139, 167, 1176, 148, 149, 144, 413, 230, 145, 343, 415, 36, 360, 165, 35, 1261, 163, 500, 1260, 1259, 1057, 697, 550, 352, 867, 340, 195, 1229, 1218, 1236, 1055, 1287, 306, 1174, 739, 740, 386, 219, 81, 1205, 933, 1234, 982, 1245, 1070, 837, 1120, 852, 1289, 1226, 440, 469, 267, 1252, 744, 1022, 329, 678, 32, 1250, 801, 1284, 1092, 1165, 304, 1042, 1043, 1238, 835, 1186, 451, 429, 348, 1071, 150, 151, 147, 416, 1017, 1207, 757, 746, 1219, 1220, 747, 1222, 1221, 703, 1253, 813, 1101, 707, 390, 548, 1241, 1158, 1150, 1161, 1168, 1167, 589, 961, 795, 1243, 1118, 794, 1182, 1166, 1152, 1156, 1162, 38, 1114, 355, 275, 141, 142, 656, 152, 449, 472, 1116, 994, 995, 1257, 959, 958, 1039, 342, 189, 190, 191, 192, 949, 1214, 1215, 1216, 447, 1175, 1179, 1138, 1112, 688, 622, 889, 890, 511, 985, 987, 986, 1106, 594, 254, 597, 253, 642, 1098, 48, 419, 1169, 1170, 1171, 34) 480 480 1 SELECT `ProductBox`.`id`, `ProductBox`.`product_id`, `ProductBox`.`title`, `ProductBox`.`text`, `ProductBox`.`image_id`, `ProductBox`.`document_id`, `ProductBox`.`document_title`, `ProductBox`.`status`, `ProductBox`.`sorting`, `ProductBox`.`created`, `ProductBox`.`created_by`, `ProductBox`.`modified`, `ProductBox`.`modified_by` FROM `astrum`.`oc_product_boxes` AS `ProductBox` WHERE `ProductBox`.`product_id` IN (1094, 1093, 779, 1038, 1187, 417, 865, 990, 884, 1190, 1189, 1191, 963, 1212, 1266, 1217, 1267, 1268, 880, 919, 601, 1227, 838, 1155, 1173, 108, 109, 110, 115, 1180, 113, 111, 112, 114, 117, 116, 561, 118, 588, 1128, 855, 103, 1062, 560, 1136, 1137, 1201, 106, 1199, 934, 882, 914, 936, 1200, 1058, 1033, 1278, 1279, 443, 97, 98, 1064, 845, 1288, 939, 602, 931, 193, 1084, 1282, 1285, 1273, 1140, 1107, 1108, 1256, 309, 704, 452, 955, 454, 1223, 453, 608, 956, 460, 554, 1119, 1052, 1133, 1185, 687, 686, 403, 137, 1276, 339, 1277, 493, 940, 1021, 1020, 1085, 1123, 1081, 1211, 1210, 1209, 1125, 980, 977, 978, 1048, 979, 981, 792, 1225, 1242, 976, 742, 655, 1206, 1248, 143, 1088, 1091, 536, 430, 868, 1188, 408, 257, 259, 1080, 388, 387, 1131, 1197, 1132, 537, 1163, 1271, 943, 1270, 810, 436, 877, 1117, 1183, 1202, 922, 1087, 1089, 1247, 1090, 569, 1153, 324, 1127, 320, 325, 988, 318, 321, 322, 989, 323, 317, 316, 984, 669, 1178, 1110, 1109, 136, 1193, 1195, 1194, 1196, 446, 565, 421, 274, 1007, 350, 993, 952, 973, 222, 1269, 133, 135, 734, 405, 1281, 130, 131, 123, 783, 121, 1213, 146, 1144, 945, 1145, 1272, 944, 1146, 1224, 604, 694, 516, 312, 310, 314, 1172, 313, 315, 891, 738, 326, 420, 566, 407, 427, 679, 490, 1249, 1157, 1159, 1151, 1012, 1235, 1160, 1011, 689, 873, 930, 624, 164, 166, 1232, 1244, 1067, 107, 842, 92, 1141, 941, 1280, 303, 1192, 515, 514, 512, 1147, 513, 701, 616, 666, 1263, 615, 888, 553, 700, 864, 887, 1265, 1184, 863, 1148, 1264, 307, 1246, 499, 503, 1283, 974, 346, 1134, 918, 1135, 1204, 338, 159, 234, 1240, 244, 1129, 1286, 126, 127, 1254, 169, 1097, 404, 696, 917, 894, 351, 680, 1231, 803, 1230, 1023, 1024, 1026, 1027, 1111, 683, 892, 695, 1069, 1164, 1013, 1228, 287, 242, 899, 196, 1139, 167, 1176, 148, 149, 144, 413, 230, 145, 343, 415, 36, 360, 165, 35, 1261, 163, 500, 1260, 1259, 1057, 697, 550, 352, 867, 340, 195, 1229, 1218, 1236, 1055, 1287, 306, 1174, 739, 740, 386, 219, 81, 1205, 933, 1234, 982, 1245, 1070, 837, 1120, 852, 1289, 1226, 440, 469, 267, 1252, 744, 1022, 329, 678, 32, 1250, 801, 1284, 1092, 1165, 304, 1042, 1043, 1238, 835, 1186, 451, 429, 348, 1071, 150, 151, 147, 416, 1017, 1207, 757, 746, 1219, 1220, 747, 1222, 1221, 703, 1253, 813, 1101, 707, 390, 548, 1241, 1158, 1150, 1161, 1168, 1167, 589, 961, 795, 1243, 1118, 794, 1182, 1166, 1152, 1156, 1162, 38, 1114, 355, 275, 141, 142, 656, 152, 449, 472, 1116, 994, 995, 1257, 959, 958, 1039, 342, 189, 190, 191, 192, 949, 1214, 1215, 1216, 447, 1175, 1179, 1138, 1112, 688, 622, 889, 890, 511, 985, 987, 986, 1106, 594, 254, 597, 253, 642, 1098, 48, 419, 1169, 1170, 1171, 34) 0 0 0 SELECT `ProductFrontpageUserGroupPrice`.`id`, `ProductFrontpageUserGroupPrice`.`frontpage_user_group_id`, `ProductFrontpageUserGroupPrice`.`product_id`, `ProductFrontpageUserGroupPrice`.`price`, `ProductFrontpageUserGroupPrice`.`created`, `ProductFrontpageUserGroupPrice`.`created_by`, `ProductFrontpageUserGroupPrice`.`modified`, `ProductFrontpageUserGroupPrice`.`modified_by` FROM `astrum`.`oc_product_frontpage_user_group_prices` AS `ProductFrontpageUserGroupPrice` WHERE `ProductFrontpageUserGroupPrice`.`product_id` IN (1094, 1093, 779, 1038, 1187, 417, 865, 990, 884, 1190, 1189, 1191, 963, 1212, 1266, 1217, 1267, 1268, 880, 919, 601, 1227, 838, 1155, 1173, 108, 109, 110, 115, 1180, 113, 111, 112, 114, 117, 116, 561, 118, 588, 1128, 855, 103, 1062, 560, 1136, 1137, 1201, 106, 1199, 934, 882, 914, 936, 1200, 1058, 1033, 1278, 1279, 443, 97, 98, 1064, 845, 1288, 939, 602, 931, 193, 1084, 1282, 1285, 1273, 1140, 1107, 1108, 1256, 309, 704, 452, 955, 454, 1223, 453, 608, 956, 460, 554, 1119, 1052, 1133, 1185, 687, 686, 403, 137, 1276, 339, 1277, 493, 940, 1021, 1020, 1085, 1123, 1081, 1211, 1210, 1209, 1125, 980, 977, 978, 1048, 979, 981, 792, 1225, 1242, 976, 742, 655, 1206, 1248, 143, 1088, 1091, 536, 430, 868, 1188, 408, 257, 259, 1080, 388, 387, 1131, 1197, 1132, 537, 1163, 1271, 943, 1270, 810, 436, 877, 1117, 1183, 1202, 922, 1087, 1089, 1247, 1090, 569, 1153, 324, 1127, 320, 325, 988, 318, 321, 322, 989, 323, 317, 316, 984, 669, 1178, 1110, 1109, 136, 1193, 1195, 1194, 1196, 446, 565, 421, 274, 1007, 350, 993, 952, 973, 222, 1269, 133, 135, 734, 405, 1281, 130, 131, 123, 783, 121, 1213, 146, 1144, 945, 1145, 1272, 944, 1146, 1224, 604, 694, 516, 312, 310, 314, 1172, 313, 315, 891, 738, 326, 420, 566, 407, 427, 679, 490, 1249, 1157, 1159, 1151, 1012, 1235, 1160, 1011, 689, 873, 930, 624, 164, 166, 1232, 1244, 1067, 107, 842, 92, 1141, 941, 1280, 303, 1192, 515, 514, 512, 1147, 513, 701, 616, 666, 1263, 615, 888, 553, 700, 864, 887, 1265, 1184, 863, 1148, 1264, 307, 1246, 499, 503, 1283, 974, 346, 1134, 918, 1135, 1204, 338, 159, 234, 1240, 244, 1129, 1286, 126, 127, 1254, 169, 1097, 404, 696, 917, 894, 351, 680, 1231, 803, 1230, 1023, 1024, 1026, 1027, 1111, 683, 892, 695, 1069, 1164, 1013, 1228, 287, 242, 899, 196, 1139, 167, 1176, 148, 149, 144, 413, 230, 145, 343, 415, 36, 360, 165, 35, 1261, 163, 500, 1260, 1259, 1057, 697, 550, 352, 867, 340, 195, 1229, 1218, 1236, 1055, 1287, 306, 1174, 739, 740, 386, 219, 81, 1205, 933, 1234, 982, 1245, 1070, 837, 1120, 852, 1289, 1226, 440, 469, 267, 1252, 744, 1022, 329, 678, 32, 1250, 801, 1284, 1092, 1165, 304, 1042, 1043, 1238, 835, 1186, 451, 429, 348, 1071, 150, 151, 147, 416, 1017, 1207, 757, 746, 1219, 1220, 747, 1222, 1221, 703, 1253, 813, 1101, 707, 390, 548, 1241, 1158, 1150, 1161, 1168, 1167, 589, 961, 795, 1243, 1118, 794, 1182, 1166, 1152, 1156, 1162, 38, 1114, 355, 275, 141, 142, 656, 152, 449, 472, 1116, 994, 995, 1257, 959, 958, 1039, 342, 189, 190, 191, 192, 949, 1214, 1215, 1216, 447, 1175, 1179, 1138, 1112, 688, 622, 889, 890, 511, 985, 987, 986, 1106, 594, 254, 597, 253, 642, 1098, 48, 419, 1169, 1170, 1171, 34) 966 966 1 SELECT `ProductGrapeVarietyProduct`.`id`, `ProductGrapeVarietyProduct`.`product_id`, `ProductGrapeVarietyProduct`.`product_grape_variety_id`, `ProductGrapeVarietyProduct`.`percentage`, `ProductGrapeVarietyProduct`.`created`, `ProductGrapeVarietyProduct`.`created_by`, `ProductGrapeVarietyProduct`.`modified`, `ProductGrapeVarietyProduct`.`modified_by` FROM `astrum`.`oc_product_grape_variety_products` AS `ProductGrapeVarietyProduct` WHERE `ProductGrapeVarietyProduct`.`product_id` IN (1094, 1093, 779, 1038, 1187, 417, 865, 990, 884, 1190, 1189, 1191, 963, 1212, 1266, 1217, 1267, 1268, 880, 919, 601, 1227, 838, 1155, 1173, 108, 109, 110, 115, 1180, 113, 111, 112, 114, 117, 116, 561, 118, 588, 1128, 855, 103, 1062, 560, 1136, 1137, 1201, 106, 1199, 934, 882, 914, 936, 1200, 1058, 1033, 1278, 1279, 443, 97, 98, 1064, 845, 1288, 939, 602, 931, 193, 1084, 1282, 1285, 1273, 1140, 1107, 1108, 1256, 309, 704, 452, 955, 454, 1223, 453, 608, 956, 460, 554, 1119, 1052, 1133, 1185, 687, 686, 403, 137, 1276, 339, 1277, 493, 940, 1021, 1020, 1085, 1123, 1081, 1211, 1210, 1209, 1125, 980, 977, 978, 1048, 979, 981, 792, 1225, 1242, 976, 742, 655, 1206, 1248, 143, 1088, 1091, 536, 430, 868, 1188, 408, 257, 259, 1080, 388, 387, 1131, 1197, 1132, 537, 1163, 1271, 943, 1270, 810, 436, 877, 1117, 1183, 1202, 922, 1087, 1089, 1247, 1090, 569, 1153, 324, 1127, 320, 325, 988, 318, 321, 322, 989, 323, 317, 316, 984, 669, 1178, 1110, 1109, 136, 1193, 1195, 1194, 1196, 446, 565, 421, 274, 1007, 350, 993, 952, 973, 222, 1269, 133, 135, 734, 405, 1281, 130, 131, 123, 783, 121, 1213, 146, 1144, 945, 1145, 1272, 944, 1146, 1224, 604, 694, 516, 312, 310, 314, 1172, 313, 315, 891, 738, 326, 420, 566, 407, 427, 679, 490, 1249, 1157, 1159, 1151, 1012, 1235, 1160, 1011, 689, 873, 930, 624, 164, 166, 1232, 1244, 1067, 107, 842, 92, 1141, 941, 1280, 303, 1192, 515, 514, 512, 1147, 513, 701, 616, 666, 1263, 615, 888, 553, 700, 864, 887, 1265, 1184, 863, 1148, 1264, 307, 1246, 499, 503, 1283, 974, 346, 1134, 918, 1135, 1204, 338, 159, 234, 1240, 244, 1129, 1286, 126, 127, 1254, 169, 1097, 404, 696, 917, 894, 351, 680, 1231, 803, 1230, 1023, 1024, 1026, 1027, 1111, 683, 892, 695, 1069, 1164, 1013, 1228, 287, 242, 899, 196, 1139, 167, 1176, 148, 149, 144, 413, 230, 145, 343, 415, 36, 360, 165, 35, 1261, 163, 500, 1260, 1259, 1057, 697, 550, 352, 867, 340, 195, 1229, 1218, 1236, 1055, 1287, 306, 1174, 739, 740, 386, 219, 81, 1205, 933, 1234, 982, 1245, 1070, 837, 1120, 852, 1289, 1226, 440, 469, 267, 1252, 744, 1022, 329, 678, 32, 1250, 801, 1284, 1092, 1165, 304, 1042, 1043, 1238, 835, 1186, 451, 429, 348, 1071, 150, 151, 147, 416, 1017, 1207, 757, 746, 1219, 1220, 747, 1222, 1221, 703, 1253, 813, 1101, 707, 390, 548, 1241, 1158, 1150, 1161, 1168, 1167, 589, 961, 795, 1243, 1118, 794, 1182, 1166, 1152, 1156, 1162, 38, 1114, 355, 275, 141, 142, 656, 152, 449, 472, 1116, 994, 995, 1257, 959, 958, 1039, 342, 189, 190, 191, 192, 949, 1214, 1215, 1216, 447, 1175, 1179, 1138, 1112, 688, 622, 889, 890, 511, 985, 987, 986, 1106, 594, 254, 597, 253, 642, 1098, 48, 419, 1169, 1170, 1171, 34) ORDER BY `ProductGrapeVarietyProduct`.`percentage` desc 664 664 1 SELECT `ProductCategory`.`id`, `ProductCategory`.`uid`, `ProductCategory`.`title`, `ProductCategory`.`slug`, `ProductCategory`.`attribute`, `ProductCategory`.`product_count`, `ProductCategory`.`group`, `ProductCategory`.`sorting`, `ProductCategory`.`status`, `ProductCategory`.`created`, `ProductCategory`.`created_by`, `ProductCategory`.`modified`, `ProductCategory`.`modified_by`, (CONCAT(`ProductCategory`.`title`, " (", `ProductCategory`.`product_count`, ")")) AS `ProductCategory__combo_title`, `ProductCategoriesProduct`.`id`, `ProductCategoriesProduct`.`product_id`, `ProductCategoriesProduct`.`product_category_id` FROM `astrum`.`oc_product_categories` AS `ProductCategory` JOIN `astrum`.`oc_product_categories_products` AS `ProductCategoriesProduct` ON (`ProductCategoriesProduct`.`product_id` IN (1094, 1093, 779, 1038, 1187, 417, 865, 990, 884, 1190, 1189, 1191, 963, 1212, 1266, 1217, 1267, 1268, 880, 919, 601, 1227, 838, 1155, 1173, 108, 109, 110, 115, 1180, 113, 111, 112, 114, 117, 116, 561, 118, 588, 1128, 855, 103, 1062, 560, 1136, 1137, 1201, 106, 1199, 934, 882, 914, 936, 1200, 1058, 1033, 1278, 1279, 443, 97, 98, 1064, 845, 1288, 939, 602, 931, 193, 1084, 1282, 1285, 1273, 1140, 1107, 1108, 1256, 309, 704, 452, 955, 454, 1223, 453, 608, 956, 460, 554, 1119, 1052, 1133, 1185, 687, 686, 403, 137, 1276, 339, 1277, 493, 940, 1021, 1020, 1085, 1123, 1081, 1211, 1210, 1209, 1125, 980, 977, 978, 1048, 979, 981, 792, 1225, 1242, 976, 742, 655, 1206, 1248, 143, 1088, 1091, 536, 430, 868, 1188, 408, 257, 259, 1080, 388, 387, 1131, 1197, 1132, 537, 1163, 1271, 943, 1270, 810, 436, 877, 1117, 1183, 1202, 922, 1087, 1089, 1247, 1090, 569, 1153, 324, 1127, 320, 325, 988, 318, 321, 322, 989, 323, 317, 316, 984, 669, 1178, 1110, 1109, 136, 1193, 1195, 1194, 1196, 446, 565, 421, 274, 1007, 350, 993, 952, 973, 222, 1269, 133, 135, 734, 405, 1281, 130, 131, 123, 783, 121, 1213, 146, 1144, 945, 1145, 1272, 944, 1146, 1224, 604, 694, 516, 312, 310, 314, 1172, 313, 315, 891, 738, 326, 420, 566, 407, 427, 679, 490, 1249, 1157, 1159, 1151, 1012, 1235, 1160, 1011, 689, 873, 930, 624, 164, 166, 1232, 1244, 1067, 107, 842, 92, 1141, 941, 1280, 303, 1192, 515, 514, 512, 1147, 513, 701, 616, 666, 1263, 615, 888, 553, 700, 864, 887, 1265, 1184, 863, 1148, 1264, 307, 1246, 499, 503, 1283, 974, 346, 1134, 918, 1135, 1204, 338, 159, 234, 1240, 244, 1129, 1286, 126, 127, 1254, 169, 1097, 404, 696, 917, 894, 351, 680, 1231, 803, 1230, 1023, 1024, 1026, 1027, 1111, 683, 892, 695, 1069, 1164, 1013, 1228, 287, 242, 899, 196, 1139, 167, 1176, 148, 149, 144, 413, 230, 145, 343, 415, 36, 360, 165, 35, 1261, 163, 500, 1260, 1259, 1057, 697, 550, 352, 867, 340, 195, 1229, 1218, 1236, 1055, 1287, 306, 1174, 739, 740, 386, 219, 81, 1205, 933, 1234, 982, 1245, 1070, 837, 1120, 852, 1289, 1226, 440, 469, 267, 1252, 744, 1022, 329, 678, 32, 1250, 801, 1284, 1092, 1165, 304, 1042, 1043, 1238, 835, 1186, 451, 429, 348, 1071, 150, 151, 147, 416, 1017, 1207, 757, 746, 1219, 1220, 747, 1222, 1221, 703, 1253, 813, 1101, 707, 390, 548, 1241, 1158, 1150, 1161, 1168, 1167, 589, 961, 795, 1243, 1118, 794, 1182, 1166, 1152, 1156, 1162, 38, 1114, 355, 275, 141, 142, 656, 152, 449, 472, 1116, 994, 995, 1257, 959, 958, 1039, 342, 189, 190, 191, 192, 949, 1214, 1215, 1216, 447, 1175, 1179, 1138, 1112, 688, 622, 889, 890, 511, 985, 987, 986, 1106, 594, 254, 597, 253, 642, 1098, 48, 419, 1169, 1170, 1171, 34) AND `ProductCategoriesProduct`.`product_category_id` = `ProductCategory`.`id`) 821 821 8 SELECT `ProductProducer`.`id`, `ProductProducer`.`uid`, `ProductProducer`.`name`, `ProductProducer`.`slug`, `ProductProducer`.`address`, `ProductProducer`.`geography_region_id`, `ProductProducer`.`telephone`, `ProductProducer`.`fax`, `ProductProducer`.`email`, `ProductProducer`.`website`, `ProductProducer`.`year_established`, `ProductProducer`.`total_hectares`, `ProductProducer`.`vintner_names`, `ProductProducer`.`description`, `ProductProducer`.`quotes`, `ProductProducer`.`logo_id`, `ProductProducer`.`latitude`, `ProductProducer`.`longitude`, `ProductProducer`.`pdf_new`, `ProductProducer`.`status`, `ProductProducer`.`sorting`, `ProductProducer`.`created`, `ProductProducer`.`created_by`, `ProductProducer`.`modified`, `ProductProducer`.`modified_by`, `GeographyRegion`.`id`, `GeographyRegion`.`uid`, `GeographyRegion`.`geography_country_id`, `GeographyRegion`.`product_count`, `GeographyRegion`.`product_producer_count`, `GeographyRegion`.`title`, `GeographyRegion`.`slug`, `GeographyRegion`.`status`, `GeographyRegion`.`sorting`, `GeographyRegion`.`created`, `GeographyRegion`.`created_by`, `GeographyRegion`.`modified`, `GeographyRegion`.`modified_by`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_count`, ")")) AS `GeographyRegion__product_combo_title`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_producer_count`, ")")) AS `GeographyRegion__product_producer_combo_title`, `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`, `ProductFeaturedProducer`.`id`, `ProductFeaturedProducer`.`product_producer_id`, `ProductFeaturedProducer`.`text`, `ProductFeaturedProducer`.`status`, `ProductFeaturedProducer`.`sorting`, `ProductFeaturedProducer`.`created`, `ProductFeaturedProducer`.`created_by`, `ProductFeaturedProducer`.`modified`, `ProductFeaturedProducer`.`modified_by` FROM `astrum`.`oc_product_producers` AS `ProductProducer` LEFT JOIN `astrum`.`oc_geography_regions` AS `GeographyRegion` ON (`ProductProducer`.`geography_region_id` = `GeographyRegion`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`ProductProducer`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`ProductProducer`.`modified_by` = `ModifiedBy`.`id`) LEFT JOIN `astrum`.`oc_product_featured_producers` AS `ProductFeaturedProducer` ON (`ProductFeaturedProducer`.`product_producer_id` = `ProductProducer`.`id`) WHERE `ProductProducer`.`status` = '1' ORDER BY `ProductProducer`.`name` asc 94 94 6 maybe slow SELECT `Product`.`id`, `Product`.`uid`, `Product`.`title`, `Product`.`slug`, `Product`.`code`, `Product`.`business_price`, `Product`.`product_category_id`, `Product`.`product_grape_variety_id`, `Product`.`geography_region_id`, `Product`.`vintage`, `Product`.`vineage`, `Product`.`product_producer_id`, `Product`.`product_distributor_id`, `Product`.`product_range_id`, `Product`.`soil`, `Product`.`training`, `Product`.`yield`, `Product`.`ageing`, `Product`.`vinification`, `Product`.`alcohol`, `Product`.`product_bottle_closure_type_id`, `Product`.`product_bottle_size_id`, `Product`.`product_case_size_id`, `Product`.`ph_level`, `Product`.`acidity`, `Product`.`residual_sugar_content`, `Product`.`method_and_production`, `Product`.`tasting_notes`, `Product`.`food_match`, `Product`.`status`, `Product`.`sorting`, `Product`.`created`, `Product`.`created_by`, `Product`.`modified`, `Product`.`modified_by` FROM `astrum`.`oc_products` AS `Product` WHERE `Product`.`product_producer_id` IN (12, 33, 93, 161, 81, 124, 139, 157, 156, 129, 150, 8, 164, 123, 97, 34, 68, 118, 15, 75, 37, 125, 38, 39, 135, 41, 171, 153, 170, 146, 169, 21, 47, 159, 1, 5, 133, 4, 111, 96, 138, 151, 131, 108, 166, 24, 87, 132, 168, 69, 109, 158, 130, 95, 114, 145, 134, 27, 167, 46, 54, 155, 7, 2, 50, 72, 83, 56, 57, 98, 85, 61, 62, 64, 165, 152, 53, 122, 67, 58, 148, 140, 115, 51, 6, 117, 19, 79, 29, 59, 149, 163, 48, 144) 796 796 5 SELECT `ProductProducerImage`.`id`, `ProductProducerImage`.`product_producer_id`, `ProductProducerImage`.`title`, `ProductProducerImage`.`image_id`, `ProductProducerImage`.`status`, `ProductProducerImage`.`sorting`, `ProductProducerImage`.`created`, `ProductProducerImage`.`created_by`, `ProductProducerImage`.`modified`, `ProductProducerImage`.`modified_by` FROM `astrum`.`oc_product_producer_images` AS `ProductProducerImage` WHERE `ProductProducerImage`.`product_producer_id` IN (12, 33, 93, 161, 81, 124, 139, 157, 156, 129, 150, 8, 164, 123, 97, 34, 68, 118, 15, 75, 37, 125, 38, 39, 135, 41, 171, 153, 170, 146, 169, 21, 47, 159, 1, 5, 133, 4, 111, 96, 138, 151, 131, 108, 166, 24, 87, 132, 168, 69, 109, 158, 130, 95, 114, 145, 134, 27, 167, 46, 54, 155, 7, 2, 50, 72, 83, 56, 57, 98, 85, 61, 62, 64, 165, 152, 53, 122, 67, 58, 148, 140, 115, 51, 6, 117, 19, 79, 29, 59, 149, 163, 48, 144) 491 491 1 SELECT `GeographyCountry`.`id`, `GeographyCountry`.`uid`, `GeographyCountry`.`product_count`, `GeographyCountry`.`product_producer_count`, `GeographyCountry`.`title`, `GeographyCountry`.`slug`, `GeographyCountry`.`image_area_coordinates`, `GeographyCountry`.`image_area_coordinates_spirit`, `GeographyCountry`.`description`, `GeographyCountry`.`description_spirit`, `GeographyCountry`.`image_id`, `GeographyCountry`.`image_id_spirit`, `GeographyCountry`.`show_regions_in_pdf`, `GeographyCountry`.`status`, `GeographyCountry`.`created`, `GeographyCountry`.`created_by`, `GeographyCountry`.`modified`, `GeographyCountry`.`modified_by`, (CONCAT(`GeographyCountry`.`title`, " (", `GeographyCountry`.`product_count`, ")")) AS `GeographyCountry__product_combo_title`, (CONCAT(`GeographyCountry`.`title`, " (", `GeographyCountry`.`product_producer_count`, ")")) AS `GeographyCountry__product_producer_combo_title`, `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_geography_countries` AS `GeographyCountry` LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`GeographyCountry`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`GeographyCountry`.`modified_by` = `ModifiedBy`.`id`) WHERE `GeographyCountry`.`status` = '1' ORDER BY `GeographyCountry`.`title` asc 16 16 1 maybe slow SELECT `GeographyRegion`.`id`, `GeographyRegion`.`uid`, `GeographyRegion`.`geography_country_id`, `GeographyRegion`.`product_count`, `GeographyRegion`.`product_producer_count`, `GeographyRegion`.`title`, `GeographyRegion`.`slug`, `GeographyRegion`.`status`, `GeographyRegion`.`sorting`, `GeographyRegion`.`created`, `GeographyRegion`.`created_by`, `GeographyRegion`.`modified`, `GeographyRegion`.`modified_by`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_count`, ")")) AS `GeographyRegion__product_combo_title`, (CONCAT(`GeographyRegion`.`title`, " (", `GeographyRegion`.`product_producer_count`, ")")) AS `GeographyRegion__product_producer_combo_title` FROM `astrum`.`oc_geography_regions` AS `GeographyRegion` WHERE `GeographyRegion`.`geography_country_id` IN (14, 13, 1, 2, 15, 3, 9, 4, 5, 6, 16, 7, 11, 8, 12, 10) 62 62 0 SELECT `FrontpageContentCategory`.`id` FROM `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'article' LIMIT 1 1 1 0 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`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`extract`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Image`.`google_drive_file_id`, `Quote`.`id`, `Quote`.`uid`, `Quote`.`title`, `Quote`.`text`, `Quote`.`quotee`, `Quote`.`image_id`, `Quote`.`sorting`, `Quote`.`status`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `astrum`.`oc_frontpage_contents` AS `FrontpageContent` LEFT JOIN `astrum`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `astrum`.`oc_quotes` AS `Quote` ON (`FrontpageContent`.`quote_id` = `Quote`.`id`) WHERE `FrontpageContent`.`frontpage_page_id` = 6 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 2 ORDER BY `FrontpageContent`.`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 0 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 0 SELECT `Asset`.`id`, `Asset`.`parent_id`, `Asset`.`uid`, `Asset`.`name`, `Asset`.`caption`, `Asset`.`ext`, `Asset`.`size`, `Asset`.`width`, `Asset`.`height`, `Asset`.`extract`, `Asset`.`created`, `Asset`.`created_by`, `Asset`.`modified`, `Asset`.`modified_by`, `Asset`.`sorting`, `Asset`.`status`, `Asset`.`path`, `Asset`.`tags`, `Asset`.`crop_params`, `Asset`.`flash_video_ready`, `Asset`.`video_thumbnail_ready`, `Asset`.`asset_folder_id`, `Asset`.`object`, `Asset`.`object_id`, `Asset`.`object_alias`, `Asset`.`google_drive_file_id`, `AssetFolder`.`id`, `AssetFolder`.`parent_id`, `AssetFolder`.`nleft`, `AssetFolder`.`nright`, `AssetFolder`.`name`, `AssetFolder`.`path`, `AssetFolder`.`asset_count`, `AssetFolder`.`created`, `AssetFolder`.`created_by`, `AssetFolder`.`modified`, `AssetFolder`.`modified_by`, `SourceAsset`.`id`, `SourceAsset`.`parent_id`, `SourceAsset`.`uid`, `SourceAsset`.`name`, `SourceAsset`.`caption`, `SourceAsset`.`ext`, `SourceAsset`.`size`, `SourceAsset`.`width`, `SourceAsset`.`height`, `SourceAsset`.`extract`, `SourceAsset`.`created`, `SourceAsset`.`created_by`, `SourceAsset`.`modified`, `SourceAsset`.`modified_by`, `SourceAsset`.`sorting`, `SourceAsset`.`status`, `SourceAsset`.`path`, `SourceAsset`.`tags`, `SourceAsset`.`crop_params`, `SourceAsset`.`flash_video_ready`, `SourceAsset`.`video_thumbnail_ready`, `SourceAsset`.`asset_folder_id`, `SourceAsset`.`object`, `SourceAsset`.`object_id`, `SourceAsset`.`object_alias`, `SourceAsset`.`google_drive_file_id`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `astrum`.`oc_assets` AS `Asset` LEFT JOIN `astrum`.`oc_asset_folders` AS `AssetFolder` ON (`Asset`.`asset_folder_id` = `AssetFolder`.`id`) LEFT JOIN `astrum`.`oc_assets` AS `SourceAsset` ON (`Asset`.`parent_id` = `SourceAsset`.`id`) LEFT JOIN `astrum`.`oc_users` AS `CreatedBy` ON (`Asset`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `astrum`.`oc_users` AS `ModifiedBy` ON (`Asset`.`modified_by` = `ModifiedBy`.`id`) WHERE `Asset`.`id` = 3503 LIMIT 1 1 1 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` = 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` = 6 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` <= 24 AND `FrontpagePage`.`nright` >= 25 ORDER BY `FrontpagePage`.`nleft` asc 2 2 0 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 (2, 6) ORDER BY `FrontpageContent`.`sorting` asc 0 0 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 (2, 6) 0 0 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 (2, 6) 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` = 6 AND `FrontpagePage`.`type` = ('page') AND `FrontpagePage`.`logged_in_only` != '1' ORDER BY `FrontpagePage`.`nleft` asc 0 0 0 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 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 33.79 MB
Message Memory use Component initialization 2.42 MB Controller action start 4.34 MB Controller render start 4.46 MB View render complete 10.16 MB Timers
Total Request Time: 871 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 35.63 Event: Controller.initialize 20.17 Event: Controller.startup 0.62 Controller action 0.46 Event: Controller.beforeRender 13.14 » Processing toolbar data 12.96 Rendering View 718.53 » Event: View.beforeRender 0.03 » Rendering APP/Plugin/Frontpage/View/FrontpagePages/sitemap.ctp 676.18 » » Rendering APP/Plugin/Frontpage/View/Elements/single-column.ctp 12.67 » Rendering APP/Plugin/Frontpage/View/Elements/sitemap.ctp #2 666.19 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp 11.26 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #2 6.79 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #3 6.36 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #4 2.86 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #5 2.64 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #6 1.78 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #7 6.22 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #8 6.18 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #9 2.01 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #10 6.15 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #11 6.01 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #12 1.92 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #13 6.13 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #14 6.04 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #15 1.96 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #16 1.89 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #17 5.97 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #18 5.95 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #19 1.86 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #20 1.03 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #21 5.67 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #22 1.72 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #23 1.66 » » » Rendering APP/Plugin/Frontpage/View/Elements/sitemap_item.ctp #24 0.86 » » » Rendering APP/Plugin/Product/View/Elements/product/sitemap-item.ctp 476.45 » » » Rendering APP/Plugin/Product/View/Elements/product_producer/sitemap-item.ctp #2 110.13 » » » Rendering APP/Plugin/Geography/View/Elements/geography_country/sitemap-item.ctp #3 11.21 » » Rendering APP/Plugin/Frontpage/View/Elements/single-column.ctp #2 2.91 » Event: View.afterRender 0.13 » Event: View.beforeLayout 0.03 » Rendering APP/Plugin/Frontpage/View/Layouts/default.ctp 37.67 » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp 2.35 » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2 2.51 » » Rendering APP/Plugin/Frontpage/View/Elements/document/header.ctp 1.46 » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/navigation.ctp #3 0.82 » » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp 0.33 » » Rendering APP/Plugin/Frontpage/View/Elements/page/header.ctp #2 13.21 » » » Rendering APP/Plugin/Frontpage/View/Elements/sidetap/toggle.ctp #2 0.39 » » » Rendering APP/Plugin/Frontpage/View/Elements/social_sharing.ctp 2.94 » » » » Rendering APP/Plugin/Frontpage/View/Elements/share.ctp 1.94 » » Rendering APP/Plugin/Frontpage/View/Elements/sidebar.ctp 8.09 » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav.ctp 7.45 » » » » Rendering APP/Plugin/Frontpage/View/Elements/sub_nav_item.ctp 0.99 » » Rendering APP/Plugin/Frontpage/View/Elements/page/footer.ctp 2.83 » » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #4 2.16 » » Rendering APP/Plugin/Frontpage/View/Elements/document/footer.ctp #2 1.01 Event: View.afterLayout 0.00 ==== - Log
-
Variables +
View Variables
- title_for_layoutAstrum Wine Cellars | Sitemap
- crumbs(array)
- 0(array)
- titleHome
- url/
- options(null)
- 1(array)
- titleSitemap
- url/sitemap
- options(null)
- 0(array)
- ProductLib(object)
- activePages(array)
- 02
- 16
- page(array)
- FrontpagePage(array)
- id6
- parent_id2
- nleft24
- nright25
- level0
- sorting0
- nameSitemap
- titleSitemap
- slugsitemap
- typepage
- url/sitemap
- external_url(null)
- folder_key(null)
- alias_id(null)
- meta_title(null)
- meta_keywords
- meta_description
- in_sitemap(true)
- sitemap_modified2012-08-29 16:06:58
- sitemap_changesmonthly
- sitemap_priority0.7
- is_homepage(false)
- in_routes(true)
- in_navigation(true)
- logged_in_only(false)
- logged_out_only(false)
- user_landing_page(false)
- overlay(false)
- is_404page(false)
- layout_filedefault
- layout_file_recursive0
- view_filesitemap
- view_file_recursive0
- use_url_as_view0
- meta_title_template(null)
- options(null)
- options_local(null)
- tags
- notes(null)
- created2012-08-29 16:06:58
- created_by(null)
- modified2012-08-31 01:39:37
- modified_by4
- 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)
- Loaded Helpers(array)
- 0Frontpage
- 1Cache
- 2AppTable
- 3Form
- 4Asset
- 5AssetCompress
- 6CookieCompliance
- 7FrontpageSitemap
- 8Html
- 9Js
- 10Pager
- 11Text
- 12Time
- 13Number
- 14GoogleMapV3
- 15Avatar
- 16SimpleGraph
- 17DebugTimer
- 18Toolbar
- 19AppJqueryEngine
- 20Session
- 21HtmlToolbar
==== -
Environment +
App Constants
Constant Value GWINE wine GSPIRIT spirit CakePHP Constants
Constant Value APP /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/ APP_DIR app APPLIBS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/Lib/ CACHE /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/cache/ CAKE /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/Cake/ CAKE_CORE_INCLUDE_PATH /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib CORE_PATH /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/ CAKE_VERSION 2.4.6 CSS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/css/ CSS_URL css/ DS / FULL_BASE_URL https://www.astrumwinecellars.com IMAGES /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/img/ IMAGES_URL img/ JS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/js/ JS_URL js/ LOGS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/logs/ ROOT /var/www/vhosts/astrumwinecellars.com/httpdocs/live TESTS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/Test/ TMP /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/tmp/ VENDORS /var/www/vhosts/astrumwinecellars.com/httpdocs/live/vendors/ WEBROOT_DIR webroot WWW_ROOT /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/ PHP Environment
Environment Variable Value Php Version 5.6.40 User astrum Home /var/www/vhosts/astrumwinecellars.com Fcgi Role RESPONDER Redirect Redirect Unique Id Zustabl-544QCQ@F9npPiwAAAoQ Redirect Redirect Script Url /sitemap Redirect Redirect Script Uri https://www.astrumwinecellars.com/sitemap Redirect Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Redirect Redirect Passenger Compile Native Support Binary 0 Redirect Redirect Passenger Download Native Support Binary 0 Redirect Redirect Https on Redirect Redirect Status 200 Redirect Unique Id Zustabl-544QCQ@F9npPiwAAAoQ Redirect Script Url /sitemap Redirect Script Uri https://www.astrumwinecellars.com/sitemap Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Redirect Passenger Compile Native Support Binary 0 Redirect Passenger Download Native Support Binary 0 Redirect Https on Redirect Status 200 Unique Id Zustabl-544QCQ@F9npPiwAAAoQ Script Url /sitemap Script Uri https://www.astrumwinecellars.com/sitemap Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins Passenger Compile Native Support Binary 0 Passenger Download Native Support Binary 0 Https on Proxy-nokeepalive 1 Http Host www.astrumwinecellars.com Http X Real Ip 18.207.133.13 Http X Accel Internal /internal-nginx-static-location Http Connection close Http User Agent CCBot/2.0 (https://commoncrawl.org/faq/) Http Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Http Accept Language en-US,en;q=0.5 Http If Modified Since Sat, 18 May 2024 11:12:21 GMT Http Accept Encoding br,gzip Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin Server Signature Server Software Apache Server Name www.astrumwinecellars.com Server Addr 10.2.132.5 Server Port 443 Remote Addr 18.207.133.13 Document Root /var/www/vhosts/astrumwinecellars.com/httpdocs/live Request Scheme https Context Prefix Context Document Root /var/www/vhosts/astrumwinecellars.com/httpdocs/live Server Admin root@localhost Script Filename /var/www/vhosts/astrumwinecellars.com/httpdocs/live/app/webroot/index.php Remote Port 56316 Redirect Query String /sitemap Redirect Url /app/webroot/sitemap Gateway Interface CGI/1.1 Server Protocol HTTP/1.0 Request Method GET Query String /sitemap Request Uri /sitemap Script Name /app/webroot/index.php Php Self /app/webroot/index.php Request Time Float 1726688617.7663 Request Time 1726688617 ==== -
Include +
Included Files
Include Paths
- 0/var/www/vhosts/astrumwinecellars.com/httpdocs/live/lib
- 2/opt/plesk/php/5.6/share/pear
- 3-> /var/www/vhosts/astrumwinecellars.com/httpdocs/live/cake/lib/Cake/
Included Files
- core(array)
- Behavior(array)
- 0CORE/Model/Behavior/ContainableBehavior.php
- 1CORE/Model/Behavior/TreeBehavior.php
- 2CORE/Model/Behavior/AclBehavior.php
- Cache(array)
- 0CORE/Cache/Cache.php
- 1CORE/Cache/Engine/FileEngine.php
- 2CORE/Cache/CacheEngine.php
- Component(array)
- 0CORE/Controller/Component/SessionComponent.php
- 1CORE/Controller/Component/RequestHandlerComponent.php
- 2CORE/Controller/Component/CookieComponent.php
- 3CORE/Controller/Component/AuthComponent.php
- 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/Set.php
- 7CORE/Utility/ClassRegistry.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
- Controller(array)
- 0Frontpage/Controller/FrontpagePagesController.php
- 1Frontpage/Controller/FrontpageAppController.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)
- 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
- Plugin(array)
- 0Product/Lib/ProductLib.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)
- 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)
====