Review of Washington Wines Blog

An Important Announcement About French Wines

Details
Written by Rand Sealey
Published: 01 April 2022

Isn't it about time we stopped reviewing French wines in this blog? Aren't there plenty of American wines to write about in this publication? Do we need to drink so much Burgundy, Mâconnais, Bordeaux and so on? And the French think their wines are so great they put "Grand Vin" on their labels. Zut alors! Merdre! C'est tout!

Poisson d'Avril! That's what the French call April Fool. This is a fishy joke.

So here are some more new French wines we've tasted recently.

N.V. Cattin Brut Crémant d'Alsace Rosé ($18.99 - Esquin, Seattle) - This sparkling wine displays a light copper-pink color, streaming bubbles and lovely aromas of strawberry, cherry, red currant, pink roses, pink lilac and orange peel. The flavors are vibrant and mouth filling, with pink fruits, grape skins, cherry stones and Vosges minerals. The back is enlivened by fraise and cerise liqueurs and CO2, followed by a bracing finely fruited finish. 18.5/20 points.

2020 Domaine du Salvard Cheverny ($19 - The Thief, Walla Walla) - Cheverny is situated downriver from Pouilly-sur-Loire. This wine is 85% Sauvignon Blanc and 15% Chardonnay. It shows a medium lemon-gold color and fresh aromas of crisp apple, white peach, grapefruit, apple blossoms, white lilac and wet stone. The flavors are brisk yet accessible, with white and yellow fruits that are accented by grape skins, peach stones and minerals. The back picks up poire and pêche liqueurs and grapefruit peel on the way to a crisp dry yet fruited finish. This calls for shellfish. 18+/20 points.

2020 Bernard Fouquet Vouvray, "Cuvée de Silex" ($24.90 - Foodscape, Walla Walla) - Brilliant lemon-gold colored, this possesses floral aromas of Anjou pear, white peach, melon, citrus, pear blossoms, wisteria and lightly spiced white incense. The flavors are deliciously ripe and mouth filling, with vivid white and green fruits that are accented by grape and pear skins and silicate minerals. The vibrancy continues on the back with poire and pêche liqueurs, melon rind and line zest, counterpointed a touch of crème fraiche on the finely fruited finish. 18.5/20 points.

2020 Domaine de la Denante Bourgogne Chardonnay ($16.99 - Esquin) - From a grower in Davayé, Damien Martin, this is a super value. It offers a brilliant gold color and attractive aromas of apple, white peach, grapefruit, apple blossoms, acacia flowers and wet stone. The flavors are bright and true to variety, with notes of grape and pear skins and argilo-limestone minerals. The vibrancy continues on the back with pêche liqueur and grapefruit peel, followed by a pleasingly juicy, persistently minerally finish. 18.5/20 points.

2019 Raphael Sallet Mâcon-Uchizy, "Les Maranches" ($12.99 - wine.com) - Uchizy is one of the villages that can hyphenate with Mâcon. Brilliant gold colored, it possesses attractive aromas of pear, peach, citrus, pear blossoms, acacia flowers and yellow incense. The flavors are pleasing, with notes of grape and pear skins, peach stones and Mâconnais minerals. The back picks up poire and pêche liqueurs and a twist of lemon zest on the way to a nicely fruited finish. Super value. 18/20 points.

2019 Domaine William Fevre Chablis ($39 - The Thief) - From estate vineyards, this offers a brilliant lemon-gold color and distinctive aromas of Anjou pear, white peach, citrus, hillside flowers and wet stone. The flavors are simultaneously crisp and viscous, with notes of pear skin, peach stone and calcareous minerals. On the back, the wine sharpens up with poire and pêche liqueurs, melon rind and lemon zest, counterpointed by crème fraiche on the steely finish. 18.5+/20 points.

2020 Domaine de la Voûte des Crozes Côte de Brouilly ($25.99 - wine.com) - This Cru Beaujolais d'isolats a deep ruby color and perfumed aromas of raspberry, cherry, black currant, rose petals, purple lilac, sweet tobacco and sweet incense. The flavors are rich and mouth encompassing with red fruits that are replete with licorice, cocoa, black tea and hillside minerals. The saturation continues on the back with pressed fruits, framboise and cassis liqueurs and touches of tart cherries and soft charcoal followed by a lip smacking finish. Almost as good as the Thivin Côte de Brouilly for much less money. 18.5+/20 points.

2019 Domaine Toilet-Beaut Chorey-les-Beaune ($47 - The Thief) - Tollot-Beaut is a respected Domaine. This wine offers a deep brick red color and rich aromas of fraises de bois, cherry, cassis, crushed red roses, sweet pea flowers, orange peel and whiffs of sweet incense. The pure Pinot Noir flavors are simultaneously bold and supple, with layers of red fruits that are interwoven with red licorice, cocoa powder, orange pekoe tea and minerals. The back reveals pressed fruits, toasted nuts, fraise and cassis liqueurs, followed by a lavish yet taut sweetish tannin finish. When you look at a $50 Oregon Pinot, this really stands out. 19/.20 points.

2019 Famille Perrin Côtes du Rhone, Reserve ($10.99 - Safeway) - Fermented and aged in stainless steel, this shows a purplish ruby color and ripe aromas of raspberries, currants, plums, black roses, mulberry, tobacco, garrigue and spiced incense. The flavors are direct, with plenty of red and black fruits that are intermixed with licorice, cocoa, black tea and scorched earth. On the back, the wine turns chewy textured, with raspberry and cassis liqueurs and burnt charcoal, followed by a juicy, spiced moderate tannin finish. A steal at $10.99. 18/20 points.

2018 Lavau Gigondas ($26.99 - wine.com) - We have had previous vintages from Lavau, and we like this one, too. A combination of 50% Grenache, 40% Syrah and 10% Mourvèdre, it shows a deep purplish-ruby color and intense aromas of raspberry, blueberry, black currant, with scents of crushed roses, tobacco, garrigue, olive and sweet spiced incense. The flavors, as well, are attention-getting, with generous yet focused red fruits that are intermixed with licorice, cocoa, French roast and Montmirial minerals. On the back, the wine fills out with fraise and cassis liqueurs and burnt charcoal, followed by a war, spiced finish. 18.5/20 points.

Looking Ahead to April and May

Details
Written by Rand Sealey
Published: 25 March 2022

Now that the April issue of the Review of Washington Wines is on line, work on the May issue is already under way. On April 5, we will be flying to Seattle and then after a few days, flying on to Kansas City for art museum visits in KC and Bentonville, Arkansas (Crystal Bridges), returning to Walla Walla on April 15. So the June issue of the Review of Washington Wines will need to be written up and sent to our website manager before we leave. There will be no Blogs while we are travelling.

We have already visited the Alton and Gramercy wineries in Walla Walla and have appointments coming up at Mark Ryan and Deux Soldats ("Two Soldiers," new in Walla Walla). Other wineries to be included in the June issue are Prospice, Isenhower, Tranche, Brook & Bull and Saviah. More wineries include Côtes de Ciel (the first Washington Arneis white I've ever tasted), Convergence Zone and Browne Family Vineyards. There will be a bevy of new 2021 Rosés. And, believe it or not, some 2020 reds which seem to be more accessible than the more structured 2019's. The 2020's from Alton and Brook & Bull are particularly impressive. The May issue will be going on line on April 25.

The Alliance of Women in Washington Wine / More French Wines

Details
Written by Rand Sealey
Published: 17 March 2022

The Alliance of Women in Washington Wines

A couple of weeks ago, I saw on Facebook that Fiona Mack (SMAK Wines) was asking for donations to the Alliance of Women in Washington Wines in celebration of her birthday, so I made a donation. It's a worthy organization. Here's why. 

The Mission Statement is: "The Alliance of Women in Washington Wines is a safe place for your voice to be heard without judgment, and you can safely ask for advice on how to positively change your working environment or career trajectory." The goals are to Inspire, Connect and Advance. 

The Alliance provides forums for women in the wine industry, mentorship and scholarships for enology and viticulture education. For more information, go to www.awwawine.org.

The Alliance's officers are: Tiffany Britton (Brainstorm Cellars), President, K D. Organ (Coventry Vale), Vice President, Maureen Allen Johnson (Goose Ridge), Treasurer and Rebecca Alberts (Fidelitas), Secretary.

This organization deserves the support of all in the wine industry.

More New French Wines

There are some more French wines tasted recently. See last week's Blog posting for others.

N. V. Prosper Maufoux Crémant de Bourgogne Brut ($19.99 - wine.com) - Composed of 40% Chardonnay, 40% Pinot Noir and 20% Gamay, this sparking wine offers brilliant gold color, streaming bubbles and aromas of pear-apple, peach grapefruit, a hint of mango, apple blossoms, white flowers and wet stone. The flavors are fresh and lively, accented by grape skins, peach stones a minerals. The back picks up pear and peach liqueurs and touches of brioche and crème fraiche, followed by a CO2 enlivened Brut finish. 18.5/20 points.

N. V. Prosper Maufoux Crémant de Bourgogne Brut Rosé ($19.99 - wine.com) - This Rosé displays a brilliant copper-pink color, streaming bubbles and enticing aromas of strawberry, red currant, pink cherry and blood orange with scents of cherry and orange blossoms and pink incense. The flavors are bright and lively, with red fruits that are accented by grape skins, cherry stones and granitic minerals. The back is enlivened by fraise and cassis liqueurs, orange peel and CO2 on the way to a bracing, finely fruited Brut finish. 18.5/20 points.

2020 Domaine André Bonhomme Mâcon Villages, Vieilles Vignes ($19.99 - wine.com) - From a grower in Viré, this offers a brilliant lemon-gold color and attractive aromas of pear, peach, grapefruit, pear blossoms, acacia flowers and lemon verbena. The flavors are vigorous (old vines) with pure Chardonnay flavors that are accented by grape and pear skins and stony minerals. The resonance continues on the back with poire and pêche liqueurs and touches of crème fraiche, hazelnut and grapefruit, followed by a nicely fruited finish. 18.5/20 points.

2019 Louis Jadot Savigny-les-Beaune Blanc, Premier Cru, Clos des Guettes ($54.99 - wine.com) - Most Savigny-les-Beaune is red, but a small amount of white wine is produced. This one shows a brilliant lemon-gold color and lovely aromas of Bosc pear, white peach, lemon custard, pear tree blossoms, wisteria and gunflint. The flavors are pure Chardonnay, almost laser-like, with steely fruits that are imbued with grape and pear skins, peach stones and granitic minerals. The penetration continues on the back with poire and pêche liqueurs and touches of lemon custard and almonds, followed by a lingering, persistently minerally finish. 19+/20 points. 

2019 Domaine Servin Chablis, "Les Fargues" ($29.90 - Foodscape, Walla Walla) - This comes from a vineyard sandwiched between Premier Crus Vosgros and Montmains. It shows a brilliant lemon-gold color and striking aromas of green apple, white peach, lime, apple blossoms, jasmine and flintstone. The flavors are crisp and dynamic, with white and green fruits that are accented by grape and apple skins and oyster shell. The resonance continues on the back with sensations of Calvados and pêche liqueurs and lime zest, followed by a persistently minneraly finish. 18.5/20 points.

2020 Justin Girardin Bourgogne Rouge ($24.99 - Esquin) - From a grower in Santenay, this shows a purplish color, typical of a young Pinot Noir, and ripe aromas of raspberry, cherry, currant, red roses, bayberry, orange peel and whiffs of baking spices. The flavors are medium bodied, yet substantial and mouth filling, with red fruits that ate intermixed with red licorice, cocoa powder, orange pekoe tea and earth. The slightly chewy textured back picks up red fruit liqueurs and recurring orange peel on the way to a ripe, pleasing moderate tannin finish. 18.5/20 points.

2020 Clos Ste. Magdelaine Cassis Blanc ($43.99 - wine.com) - Cassis is situated just east of Marseille and this is produced from Ugni Blanc, Claudette, Marsanne and Sauvignon Blanc. It shows a brilliant gold color and intense, floral aromas of pear, peach, papaya, citrus, pear blossoms, honeysuckle, butternut and yellow incense. The flavors are simultaneously viscous and laser-like, with vivid yellow and white fruits that are accented by grape and pear skins and Provençal minerals. The back reveals poire and pêche liqueurs and touches of nougat and crème fraiche followed by a lingering precise fruit acid finish. 19/20 points.

2019 Famille Perrin Gigondas, "La Gille" ($34.99 - wine.com) - Deep ruby colored, this emits rich aromas of raspberry, black currant, black plum, black roses, tobacco, garrigue, cracked pepper and spiced incense. The flavors are generous and mouth filling, with copious red and black fruits that are infused with black licorice, dark cocoa, French roast and Montmirial minerals. The saturation continues on the back with macerated fruits, roasted nuts and crème de cassis, followed by an, again, peppery finish. 18.5/20 points.

2018 Domaine Nôtre Dame des Pallières Gigondas, "Bois des Mourres" ($32.99 - Esquin) - This combination of 80% Grenache and 10% each of Syrah and Mourvèdre offers a deep ruby color and seductivre aromas of raspberry, black currant, plum, crushed roses, tobacco, lavender and spiced incense. The flavors are ample and mouth filling, with red and black fruits that are intermixed with red licorice, cocoa, French roast and Montmirial minerals. On the back, the wine warms up with roasted berries and nuts, framboise and cassis liqueurs and burnt charcoal followed by a heady (16% alcohol) yet even tempered spice and pepper dusted finish. 18.5/20 points.

Three Walla Walla Valley Vineyards Sold / More French Wines

Details
Written by Rand Sealey
Published: 10 March 2022

Three Walla Walla Valley Vineyards Sold

The big wine industry news the past few weeks has been the sale of three choice vineyards in the South Walla Walla Valley. Here they are.

Windrow Vineyards - This property is located west of Milton-Freewater and was part of the original Seven Hills Vineyard first planted in 1981 by Dr. Herb Hendricks and Dr. James McClellan. The sale was facilitated by Michele Rennie's blue and vine group brokered by EXP Realty. The vineyard was part of the Tero Estates winery adjacent to the vineyard, for which Doug Roskelley was winemaker until he passed away in 2021 after which the property was put up for sale. The buyer has not yet been disclosed except to say that "The new owner grew up in Milton-Freewater and is very excited to be coming home. She plans to honor the legacy while taking the property to the next level."

Tertulia Cellars - This property was acquired on February 12 by Patterson Cellars in Woodinville. The winery closed in December, largely due to COVID and was put up for sale. The sale includes the Whistling Hill Vineyard adjacent to the Winery on Whitely Road on Walla Walla's Southside. The winery will be rebranded and Patterson Cellars, Walla Walla and operations will be conducted in both Woodinville and Walla Walla. 

Waliser Vineyard - On March 6, it was announced that the Waliser Vineyard in the Rocks District of Milton-Freewater has been sold to the Figgins Family Properties which owns Leonetti Cellar. The nine acre vineyard is adjacent to the Holy Roller Vineyard which is owned by the Figgins. This expands the Figgins presence in The Rocks. The Waliser Vineyard was planted by Tom Waliser in a site that was formerly an orchard. The terms on the sale were not disclosed. Tom Waliser stated, "I'm honored to see the Figgins family become its new steward."

More New French Wines

Here are some more of our finds in French wines. See last week's blog for previous ones.

N. V. Domaine Allimant-Laugner Crémant d'Alsace Brut ($21.99 - Esquin) - Blended from Pinot Blanc, Riesling and Pinot Gris, this sparkling wine offers a brilliant lemon-gold color, frothy bubbles and aromas of pear, peach, honeydew melon, apple blossoms, wildflowers, jasmine and brioche. The flavors are crisp and precise, with notes of pear skins, peach stones and slaty minerals. The back picks up poire William liqueur, melon rind and a bit of spice (from the Riesling) on the CO2 enlivened finish. 18.5/20 points.

N. V. Domaine Allimant-Laugner Crémant d'Alsace Brut Rosé ($23.99 - Esquin) - Made exclusively from Pinot Noir, this shows a brilliant copper-pink color, frothy bubbles and aromas of strawberry, pink cherry, blood orange, cherry and orange blossoms and white flowers. The flavors are pleasingly juicy and well delineated, with pink fruits that are accented by grape skins, cherry stones and Vosges minerals. The back picks up fraise and kirsch liqueurs and orange peel, all enlivened by the CO2 on the finish. 18.5/20 points.

Prince de Didonne Pineau de Charentes ($38 - The Thief, Walla Walla) - This is produced from the same grapes as for Cognac - Ugni Blanc, Colombard and Folle Blanche - fermented with residual sugar and fortified to 17% alcohol. It displays an amber color and an intriguing nose of ripe pear, yellow peach, dried orange peel and a hint of butternut. The flavors are strikingly vigorous, with notes of pear skin, orange peel and Charentais coastal minerals, followed by a lingering sweetish finish that is lifted by bracing fruit acids,. Drink as an aperitif or dessert wine. 19/20 points.

2020 Domaine Talmard Mâcon Chardonnay ($17.99 - Esquin) - This comes from the village of Chardonnay, where the grape takes its name. It shows a brilliant gold color and attractive aromas of pear-apple, white peach, grapefruit, apple blossoms, acacia flowers and a hint of butternut. The flavors, as well, are appealing, with bright fruits that are accented by pear skins, peach stones and minerals. The back picks up poire and pêche liqueurs and grapefruit peel, followed by a nicely fruited finish. "Eighteen dollars, oh my God!" says Lynn. 18.5/20 points.

2019 Domaine Cheveau Mâcon-Solutré-Pouilly, "Sur le Mont" ($24.99 - wine.com) - From a vineyard below the Rock of Solutré, this offers a brilliant lemon-gold color and floral aromas of pear, peach and citrus with scents of pear blossoms, acacia flowers and whiffs of butternut. The flavors show considerable Chardonnay character, with notes of grape and pear skins, peach stones and Solutré minerals. On the back, the wine takes on a viscous texture, along with poire and pêche liqueurs, counterpointed by bright fruit acids on the finish. "A lot of flavor, I love Chardonnay." says Lynn. 18.5/20 points.

2020 Château Thivin Brouilly "Reverdon" ($28.99 - wine.com) - From a highly regarded producer, the Famille Geoffray, this Cru Beaujolais displays purplish ruby color and enticing aromas of raspberry, blueberry, black currant, crushed roses, tobacco, purple lilac and wafts of sweet incense. The flavors are ample yet focused, with copious red and blue fruits that are intermixed with red licorice, cola, black tea and earth. The back picks up pressed fruits, roasted nuts, framboise and creme de cassis liqueurs, followed by a deliciously juicy moderate tannin finish. 18.5/20 points.

2020 Château Thivin Côte de Brouilly ($32.99 - wine.com) - This comes from the slope high above Brouilly. It displays a deep ruby-crimson color and seductive aromas of wild raspberries, black currants, blood orange, black roses, sweet pea flowers, violeta and sweet incense. The flavors are deliciously supple yet full and mouth filling, with copious red and black fruits that are intermixed with licorice, cocoa, orange pekoe tea and granitic minerals. The saturation continues on the back with pressed fruits, sweet nuts, fraise and cassis liqueurs and recurring orange peel followed by a lingering sweet-dry tannin finish. 19/20 points.

2019 Louis Jadot Monthelie, "Sous Roche," Domaine Gagey ($46.99 - wine.com) - Monthelie is situated between Volnay and Meursault. This wine exhibits a brick red color and seductive aromas of strawberry, brambly currant, blood orange, crushed roses, orange blossoms, sweet pea flowers, and whiffs of orange incense. The flavors are deliciously supple yet deep and mouth encompassing, with red fruits that are intermixed with red licorice, cocoa powder, orange pekoe tea and calcareous minerals. The wine fills out on the back with pressed berries, fraise, cassis and orange liqueurs, all followed by a lingering, ripe yet sturdy tannin finish. 19/20 points.

2019 Domaine Bachelet-Monnot Maranges Premier Cru, Clos de la Bouterie ($49.99 - wine.com) - Maranges is located at the south end of the Côte d'Or. This exhibits a deep brick red color and lovely aromas of wild strawberries, cherries, black currants, wild roses, purple lilac, sweet tobacco and sweet incense. The flavors are alluring, with ripe, supple red fruits that are imbued with licorice, cocoa, black tea and calcareous minerals. On the back, the wine fills out with macerated berries, roasted pecans, fraise and creme de cassis liqueurs and soft charcoal, all followed by a lingering balanced acid and tannin finish. 19/20 points.

 

 

Looking Ahead to April

Details
Written by Rand Sealey
Published: 04 March 2022

As off this writing, I am working on the April issue of the Review of Washington Wines. Spring is the time when wineries release new vintages, so there will be a lot of new wines. Also, I have reached out to wineries around the state to have wines shipped to me in Walla Walla. In this issue will be new wines from Amavi Cellars, Kontos Cellars Vital Wines, Three Rivers and l'Ecole no 41. From around the state there will be reviews of Cairdeas in Lake Chelan, Longship Cellars in Richland, Savage Grace in the Columbia Gorge and Freehand Cellars in Wapato. There will be several more new 2021 Rosés as well. 

The April issue will include over 30 new 2019 reds. From my impressions, that vintage looks to be an age-worthy one. The wines appear to be more structured than, say, the 2018's with firm yet ripe tannins and balanced acidity. See my blog posting of 30 September, "The 2018 and 2019 Vintages Compared," for more about this.

  1. The GG Antinori Dinner & More French Wines
  2. New 2019 Red and White Burgundies
  3. What's Ahead for the Institute for Enology and Viticulture?
  4. Walla Walla Wine News & More Burgundies

Page 2 of 127

  • 1
  • 2
  • 3
  • 4
  • ...
  • 6
  • 7
  • 8
  • 9
  • 10

Back to Top

© 2022 Review of Washington Wines Blog

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1652792989,
                "last": 1652792989,
                "now": 1652792989
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 11.52 ms / 11.52 ms Memory: 1.728 MB / 2.07 MB Application: afterLoad
Time: 35.11 ms / 46.63 ms Memory: 3.190 MB / 5.26 MB Application: afterInitialise
Time: 5.94 ms / 52.57 ms Memory: 0.652 MB / 5.91 MB Application: afterRoute
Time: 8.57 ms / 61.15 ms Memory: 0.290 MB / 6.20 MB Application: beforeRenderComponent com_content
Time: 4.58 ms / 65.72 ms Memory: 0.611 MB / 6.81 MB Application: Before Access::preloadComponents (all components)
Time: 0.67 ms / 66.40 ms Memory: 0.055 MB / 6.87 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 66.42 ms Memory: -0.004 MB / 6.86 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.31 ms / 66.73 ms Memory: 0.026 MB / 6.89 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 40.86 ms / 107.59 ms Memory: 2.277 MB / 9.17 MB Application: afterRenderComponent com_content
Time: 0.77 ms / 108.36 ms Memory: 0.099 MB / 9.27 MB Application: afterDispatch
Time: 3.11 ms / 111.47 ms Memory: 0.222 MB / 9.49 MB Application: afterRender

Database queries total: 36.34 ms

Memory Usage

9.87 MB (10,346,968 Bytes)

Database Queries

27 Queries Logged 36.34 ms


  1. Query Time: 0.21 ms Query memory: 0.025 MB Memory before query: 3.593 MB Rows returned: 0
    SELECT `data`
    
      FROM `esjqa_session`
      WHERE `session_id` = X'6664373037626337393935396633303934356339383137653164393165636265'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:854
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.11 ms After last query: 0.85 ms Query memory: 0.022 MB Memory before query: 3.757 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `esjqa_session`
      WHERE `session_id` = X'6664373037626337393935396633303934356339383137653164393165636265'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:856
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 7.82 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 3.762 MB
    INSERT INTO `esjqa_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6664373037626337393935396633303934356339383137653164393165636265', 1, 1652792989, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `esjqa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6664373037626337393935396633303934356339383137653164393165636265', 1, 1652792989, 0, '', 0)
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.04 ms
    end0.00 ms
    query end7.65 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:856
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.38 ms After last query: 2.22 ms Query memory: 0.029 MB Memory before query: 3.977 MB Rows returned: 35
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `esjqa_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_extensionsNULLrefextensionextension82const351.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.16 ms After last query: 1.60 ms Query memory: 0.023 MB Memory before query: 4.168 MB Rows returned: 4
    SELECT id, rules
    
      FROM `esjqa_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_viewlevelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4100.00NULL
    Profile
    StatusDuration
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.00 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.24 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 4.180 MB Rows returned: 2
    SELECT b.id
    
      FROM esjqa_usergroups AS a
      LEFT JOIN esjqa_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.45 ms After last query: 0.49 ms Query memory: 0.033 MB Memory before query: 4.245 MB Rows returned: 77
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM esjqa_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_extensionsNULLrefextensionextension82const960.60Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.26 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.32 ms After last query: 9.84 ms Query memory: 0.031 MB Memory before query: 5.444 MB Rows returned: 1
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM esjqa_menu AS m
      LEFT JOIN esjqa_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL110.00Using index condition; Using where; Using filesort
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.m.component_id1100.00Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:445
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:561
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1169
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.18 ms After last query: 4.57 ms Query memory: 0.025 MB Memory before query: 5.947 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `esjqa_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1131
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 5.57 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 5.938 MB
    UPDATE `esjqa_extensions`
    
      SET `params` = '{\"mediaversion\":\"fc9722730f88989f61e4505010913dae\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEesjqa_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.03 ms
    updating0.04 ms
    end0.01 ms
    query end5.36 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1131
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.30 ms After last query: 1.58 ms Query memory: 0.025 MB Memory before query: 6.182 MB Rows returned: 1
    SELECT *
    
      FROM esjqa_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_languagesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.24 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 6.195 MB Rows returned: 2
    SELECT id, home, template, s.params
    
      FROM esjqa_template_styles as s
      LEFT JOIN esjqa_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const41.25Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202blogrevi_joomdb.e.element150.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.55 ms After last query: 4.83 ms Query memory: 0.031 MB Memory before query: 6.817 MB Rows returned: 35
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `esjqa_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_assetsNULLrangeidx_asset_nameidx_asset_name202NULL36100.00Using index condition
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.26 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    19Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:115
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:45
    13ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 12.33 ms After last query: 0.98 ms Query memory: 0.122 MB Memory before query: 7.011 MB Rows returned: 9
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM esjqa_content AS a
      INNER JOIN esjqa_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN esjqa_categories AS c
      ON c.id = a.catid
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN esjqa_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN esjqa_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN esjqa_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-17 13:09:49')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-17 13:09:49')
      ORDER BY a.featured DESC, fp.ordering,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 5, 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL119.09Using where; Using temporary; Using filesort
    1SIMPLEaNULLrefPRIMARY,idx_access,idx_state,idx_catididx_catid4blogrevi_joomdb.c.id10516.00Using index condition; Using where
    1SIMPLEfpNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.modified_by1100.00Using where
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.c.parent_id1100.00Using where
    1SIMPLEvNULLALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.26 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.03 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data11.07 ms
    Creating sort index0.40 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.12 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:189
    14Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.34 ms After last query: 1.80 ms Query memory: 0.035 MB Memory before query: 7.398 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 639
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.21 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.419 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 638
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.19 ms After last query: 0.11 ms Query memory: 0.036 MB Memory before query: 7.442 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 637
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.18 ms After last query: 0.13 ms Query memory: 0.035 MB Memory before query: 7.464 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 636
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.16 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.486 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 635
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.17 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.507 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 634
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.529 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 633
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.550 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 632
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.17 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.572 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 631
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 4.62 ms After last query: 0.80 ms Query memory: 0.025 MB Memory before query: 7.646 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM esjqa_content AS a
      INNER JOIN esjqa_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN esjqa_categories AS c
      ON c.id = a.catid
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN esjqa_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN esjqa_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN esjqa_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-17 13:09:49')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-17 13:09:49')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL119.09Using where
    1SIMPLEaNULLrefPRIMARY,idx_access,idx_state,idx_catididx_catid4blogrevi_joomdb.c.id10516.00Using index condition; Using where
    1SIMPLEfpNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1100.00Using where; Using index
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.created_by1100.00Using where; Using index
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.modified_by1100.00Using where; Using index
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.c.parent_id1100.00Using where; Using index
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1100.00Using where; Using index
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data4.36 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:284
    13Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:234
    12Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:57
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.29 ms After last query: 3.74 ms Query memory: 0.038 MB Memory before query: 8.075 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `esjqa_categories` AS `s`
      INNER JOIN `esjqa_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 9
      ORDER BY c.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using filesort
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL1124.79Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:135
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:189
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.52 ms After last query: 0.34 ms Query memory: 0.037 MB Memory before query: 8.120 MB Rows returned: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM esjqa_fields AS a
      LEFT JOIN `esjqa_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN esjqa_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN esjqa_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN esjqa_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `esjqa_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using index condition; Using where; Using temporary; Using filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28blogrevi_joomdb.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4blogrevi_joomdb.a.id1100.00Using where; Using index; Distinct
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.10 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    Creating tmp table0.03 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.09 ms
    Creating sort index0.02 ms
    end0.00 ms
    query end0.00 ms
    removing tmp table0.02 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:189
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.34 ms After last query: 15.09 ms Query memory: 0.026 MB Memory before query: 9.405 MB Rows returned: 0
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM esjqa_modules AS m
      LEFT JOIN esjqa_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN esjqa_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-17 13:09:49')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-17 13:09:49')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 2 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrangePRIMARY,published,newsfeedspublished5NULL28.33Using index condition; Using where; Using filesort
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403blogrevi_joomdb.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4blogrevi_joomdb.m.id140.00Using where; Using index
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:91
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1126
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 9 × SELECT `m`.`tag_id`,`t`.* 
      FROM `esjqa_contentitem_tag_map` AS m
      INNER JOIN `esjqa_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `esjqa_extensions`
  3. 1 × SELECT `data` 
      FROM `esjqa_session`
  4. 1 × SELECT `session_id` 
      FROM `esjqa_session`
  5. 1 × SELECT id, rules 
      FROM `esjqa_viewlevels
  6. 1 × SELECT b.id 
      FROM esjqa_usergroups AS a
      LEFT JOIN esjqa_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  7. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM esjqa_extensions
  8. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM esjqa_menu AS m
      LEFT JOIN esjqa_extensions AS e
      ON m.component_id = e.extension_id
  9. 1 × SELECT * 
      FROM esjqa_languages
  10. 1 × SELECT id, home, template, s.params 
      FROM esjqa_template_styles as s
      LEFT JOIN esjqa_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  11. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `esjqa_assets`
  12. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM esjqa_content AS a
      INNER JOIN esjqa_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN esjqa_categories AS c
      ON c.id = a.catid
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN esjqa_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN esjqa_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN esjqa_content_rating AS v
      ON a.id = v.content_id
  13. 1 × SELECT COUNT(*) 
      FROM esjqa_content AS a
      INNER JOIN esjqa_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN esjqa_categories AS c
      ON c.id = a.catid
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN esjqa_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN esjqa_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN esjqa_content_rating AS v
      ON a.id = v.content_id
  14. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `esjqa_categories` AS `s`
      INNER JOIN `esjqa_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  15. 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM esjqa_fields AS a
      LEFT JOIN `esjqa_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN esjqa_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN esjqa_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN esjqa_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `esjqa_fields_categories` AS fc
      ON fc.field_id = a.id
  16. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM esjqa_modules AS m
      LEFT JOIN esjqa_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN esjqa_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
OTHER Tables:
  1. 1 × INSERT INTO `esjqa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6664373037626337393935396633303934356339383137653164393165636265', 1, 1652792989, 0, '', 0
  2. 1 × UPDATE `esjqa_extensions` 
      SET `params` = '{\"mediaversion\":\"fc9722730f88989f61e4505010913dae\"}'