Review of Washington Wines Blog

New Wines from Esquin

Details
Written by Rand Sealey
Published: 23 June 2022

On June 11th, while we were in Seattle, we stopped at Esquin Wine Merchants (which I owned from 1969 to 1997), to pick up some wines to take back to Walla Walla. We have enjoyed tasting our purchases. Here's what we found. 

We picked up a few new 2021 Rosés:

2021 La Spinetta "Il Rosé di Casanova," Toscana ($19.99) - This Italian Rosé is composed of 50% Sangiovese and 50% Prugnolo. It offers a copper-tinged pink color and attractive aromas of strawberry, cherry, currant, cherry blossoms, pink roses and whiffs of pink incense. The flavors are bright and fresh, with notes of cherry stones and hillside minerals. The back picks up strawberry and cherry liqueurs on the way to a dry, finely fruited finish. 18+/20 points.

2021 Commanderie de la Bargemon Côteaux d'Aix en Provence Rosé ($20.99) - This is a lovely Rosé. It shows a brilliant copper-pink color and enticing aromas of strawberry, pomegranate, red currant, pink roses, lavender and Provençal herbs. The flavors are brisk and lively with pink fruits that are accented by grape skins, pomegranate seeds and Provence hillside minerals. The appeal continues on the back with fraise and cassis liqueurs and a twist of orange peel on the dry finish. 18.5/20 points.

2021 Pascal et Nicolas Reverdy Sancerre Rosé, "Terre de Maimbrey" Rosé ($28.99) - Produced from Pinot Noir in Maimbrey, one of the best sites in Sancerre, this is an exquisite Rosé. It displays a brilliant copper-pink color and lovely aromas of strawberry, pink cherry, tangerine, pink roses, cherry blossoms and whiffs of orange incense. The flavors are bright and dynamic, with pink and orange fruits and riverside minerals. The resonance continues on the back with fraise and cerise liqueurs and recurring tangerine peel, followed by a precise fruit acid finish. 19/20 points.

While we were at Esquin some Burgundy wines were being poured. We bought these two.

2019 Terres Secrètes Mâcon Verzé, "Croix Jarrier" ($22.99) - This Chardonnay offers a brilliant lemon-gold color and attractive aromas of pear, peach, citrus. pear blossoms, acacia flowers, lemon verbena and wet stone. The flavors are lively and true to variety, with notes of grape and pear skins and chalky minerals. The appeal continues on the back with poire and pêche liqueurs and a twist of lemon zest on the crisp, well fruited finish. 18.5/20 points.

2018 Nuiton-Beaunoy Bourgogne Côte d'Or ($26.99) - Brick red colored, this Pinot Noir emits inviting aromas of strawberry, cherry, currant, crushed roses, bayberry and sweet incense. The flavors are generous and mouth filling with definite varietal character, marked by red licorice, cocoa, medium roast coffee beans and earth. The supple yet firm back picks up fraise and cassis liqueurs and lightly toasted nuts on the way to a juicy moderate tannin and acid finish. 18.5/20 points.

And we also bought these Rhone wines. 

2020 La Font du Loup Côtes du Rhône "Le Loup" ($18.99) - This "wolf label" wine features a deep ruby color and rich aromas of raspberry, currant, plum, black roses, mulberry, tobacco, garrigue and spiced incense. The flavors are amole yet focused, with copious red fruits that are intermixed with licorice, cocoa, black tea and minerals. On the back, the wine takes a vigorous turn with macerated fruits, roasted nuts, creme de cassis and soft charcoal, followed by a spiced ripe tannin finish. 18+/20 points.

2019 Crous St. Martin Châteauneuf du Pape. "Homage à l'an 1879" ($38.99) - We have had previous vintages of Crous St. Martin and found them to be excellent values. Composed of 80% Grenache and 10% each of Syrah and Mourvèdre, this shows a deep ruby color and rich aromas of raspberry, black currant, blood orange, roses, sweet tobacco, garrigue, olive tapenade and spiced incense. The flavors are bold and velvety, with layers of up front red fruits that are intermixed with licorice, cocoa, French roast and mas minerals. On the back, the wine intensifies worth macerated fruits, roasted nuts, framboise and cassis liqueurs and recurring orange peel, followed by a lingering firm yer sweetish tannin finish. 19/20 points.

2018 Domaine Santa Duc Gigondas, "Aux Lieux Dits" ($39.99) - From select old vine vineyards, this blend of Grenache, Syrah, Mourvèdre and Cinsault exhibits a semi opaque ruby color and an intoxicating nose of raspberries, blueberries, black currants, black roses, dark tobacco, garrigue and spiced incense. The flavors are simultaneously bold and velvety, with black and blue fruits that are infused with licorice root, French roast and Montmirial earth and minerals. The back reveals roasted berries and nuts, mocha, framboise and creme de cassis liqueurs, followed by a lingering, ripe spiced tannin finish, lifted by fruit acids. 19/20 points.

Wine Deal of the Week

Esquin had this wine from Victor Palencia on sale (regular $25).

2019 La Monarcha Malbec, Columbia Valley ($19.99) - This is a mighty Malbec at a great price. It shows a purplish ruby color and rich aromas of blackberry, blueberry, plum, black roses, lavender, tobacco, black olive and wood smoke. The flavors are bold and mouth filling yet sophisticated, with black and blue fruits that are intermixed with licorice, cocoa, black tea and earth. The penetration continues on the back with macerated fruits, roasted pecans, mocha, creme de cassis and stick charcoal, followed by a satisfying ripe tannin finish. 18.5/20 points.

 

 

 

A Visit to Seattle and Woodinville

Details
Written by Rand Sealey
Published: 16 June 2022

On June 8th, Lynn and I drove over to Seattle from Walla Walla. Below are the noteworthy wine related activities we did.

After getting medical appointments over with, we had dinner at Assaggio on Thursday. The restaurant is owned by Mauro Golmarvi, our former neighbor in West Seattle and our current neighbor in Walla Walla (across Graybill Pond). The dinner was delicious, Ling cod, cooked to perfection accompanied by our favorite Italian white, the 2020 Antinori Bolgheri Vermentino (see the 10 May Blog posting below for a review).

On Friday, we drove over to Woodinville to visit three wineries. At JM Cellars on Bramble Bump, I tasted some fine new releases with owner-winemaker John Bigelow. We loved the 2021 Cinsault Rosé and 2019 Syrah. At Efeste, we had another fine Rosé from the Oldfield Estate Vineyard. The "Big Papa" Cabernet was brawny as usual. DeLille Cellars had a gorgeous 2021 Roussanne and a striking combination of 70% Malbec. These and other wines to be reviewed in the July issue of the Review of Washington Wines, on line June 24.

That evening, we had dinner with Lakeside School classmates Don F lynn and Dave Whitridge, a delicious bouillibase with some Rosés I brought. The next day, we had a Class of 1962 60th Reunion lunch with 14 other classmates at the Seattle Yacht Club. Salmon was served and I provided a Grenache themed selection of wines which were happily enjoyed.

That Saturday afternoon, we stopped by Esquin Wine & Spirits tp pick up some wines including some new 2021 Rosés and 2019 Rhone wines. There was a Burgundy tasting and we picked up a 2019 Macon-Venze and a 2018 Nuitin-Beaunoy Bourgogn Rouge, Cote d'Or. These will be reviewed in next week's Review Blog. 

On Sunday, on our way back to Walla Walla, we stopped in Prosser to visit the Thurston Wolfe Winery with Wade Wolfe and Becky Yeaman. The wines were terrific values, all $30 or less and scoring 18.5/20 and 19/20 points. Especially noteworthy were the 2020 "GSM" Blend of Grenache, Syrah and Malbec and the 2020 McKinley Springs Malbec. We had lunch at Wine O'clock were we had a well extracted 2021 Rosé and a tasty 2018 Dolcetto which went nicely with our pear and bacon pizza. No visit to Prosser is complete without a meal at this restaurant. 

Wine Deal of the Week

Starting with this posting, each week's Blog will feature an exceptional value which is not to be missed, especially if you like Cabernet Franc.

2020 Paul Buisse Chinon (Regular: $18.99) - I found this Loire Valley Cabernet Franc at the Plaza Way Safeway in Walla Walla. It was sandwiched among the domestic Cabernet Sauvignons and I purchased it for $11.49. It shows a purplish ruby color and aromas of raspberry, blueberry, black currant, black roses, tobacco, herb potpourri and stick incense. The flavors are medium bodied but substantial, with red and blue fruits that are intermixed with licorice, cocoa, black tea and calcareous minerals. On the back, the wine turns chewy textured, with pressed fruits, toasted nuts, framboise liqueur and soft charcoal, followed by a moderate tannin and acid finish. 18.5/20 points.

  

More New and Older Wines Tasted

Details
Written by Rand Sealey
Published: 02 June 2022

Below is a bevy of wines we've tasted recently, some new ones, others from our collection.

2019 Château Vieux Lazaret Châteauneuf du Pape Blanc ($48.99 - Esquin) - Web have had impressive vintages from Vieux Lazaret. Composed of 45% Grenache Blanc, 30% Clairette, 20% Bourboulenc and 5% barrel fermented Roussanne, this shows a brilliant gold color and ripe aromas of pear, peach, nectarine, tangerine, passion fruit, orange blossoms, honeysuckle, jasmine and white incense. The flavors, as well, are opulent, with rich yellow fruits that are intermixed with grape and pear skins, peach stones and mas minerals. On the back, the wine enrichens further with a leesy texture and pear and peach liqueurs, followed by a lingering, vigorous fruit acid finish. 19+/20 points.

2018 Maison Les Alexandrines Crozes-Hermitage ($26.99 - Safeway) - This is the first Crozes-Hermitage I've seen in supermarket. This one shows an inky purplish color and an intense nose of dark fruits - black currants, black cherries, black plums - with scents of black roses, madero wrapped, lavender and sultry incense. The flavors are thick, almost massive, with dark fruits that are infused with licorice, dark cocoa, French roast and calcareous minerals. The penetration continues on the back with macerated fruits, roasted walnuts, mocha and charcoal, all followed by a savory lingering ripe tannin finish. 19/20 points.

2020 Régis Minet Pouilly Fumé, "Vielles Vignes" ($29.90 - Foodscape. Walla Walla, $32.99 - Esquin) - This is our go-to  Sauvignon Blanc (Blanc Fumé) from the upper Loire Valley. Light straw colored, it possesses floral aromas of Anjou pear, Crenshaw melon, gooseberry, cut grass and wet stone. The flavors are vivid and precise, with notes of grape and pear skins and calcareous minerals. The resonance continues on the back with poire William liqueur and melon rind followed by a crisp, persistently minerally finish. Pairs beautifully with shellfish. 18.5+/20 points.

2020 Louis Jadot Beaujolais-Villages ($14.49 - Safeway) - This makes a nice luncheon red. It offers a purplish ruby color and engaging aromas of strawberry,  cherry, red currant. crushed roses, mulberry and light spices. Them flavors are medium bodied and direct with red fruits that are intermixed with red licorice, cocoa powder, medium roast coffee beans and earth. The chewy textured yet quaffable back picks up pressed berries, creme de cassis and soft charcoal on the way to a soft tannin and moderate acid finish. 18/20 points.

2019 Domaine Cuillotte Bourgogne Pinot Noir, Cuvée de Noble Souche ($28 - The Thief, Walla Walla) - From a grower in Marsannay, this is a Burgundian gem. It displays a brick red color and attractive aromas of fraises de bois, cerise and cassis, with scents of red roses, cherry blossoms and sweet incense. The flavors are deliciously supple, yet substantial. with red fruits that are imbued with licorice, cocoa, orange pekoe tea and soft earth. The appeal continues on the back with gently pressed fruits, toasted nuts, mocha, kirsch and creme de cassis, followed by a silky moderate tannin finish. 18.5+/20 points.

2017 Louis Jadot Savigny-les-Beaune Premier Cru, La Dominode ($58.99 in 2019) - From an exceptional but not as great as 2015 or 2019, this offers a medium brick red color and a rich bouquet of wild strawberries, cherries, red currants, crushed roses, tobacco, dried orange peel and sultry incense. The flavors are ample yet deep and focused, with considerable Pinot character, marked by licorice, cocoa, black tea and earth. On the back, the wine rounds out with fraise and cerise liqueurs and recurring orange peel, followed by a lot, rich finish. marled by smooth tannins. 19/20 points.

2015 Domaine Denis Mortet Gevry-Chambertin, "Mes Cinq Terroirs" ($85.99 in 2017) - This is a beautifully maturing Burgundy. It exhibits a brick red color and a rich bouquet of semi-dried fruits - raspberries, cherries, currants - with scents of dried rose petals, mulberry, tobacco, sandalwood and stick incense. The flavors are maturing into a round, deep texture - "velours" - with notes of licorice root, dark cocoa, roasted coffee and earth. The back reveals kirsch and cassis liqueurs, roasted nuts, toffee, all leading into a lengthy finish, marked by smoothing tannins. 19+/20 points.

2021 Rosé Wines Update

So far, we have tasted 55 Rosé wines from the 2021 vintage, mostly from Washington State, with a few from Oregon and just two imported ones.

Among these wines, most are amiable quaffing Rosés which will be enjoyable for summer drinking. For the most part, they do not seem to be quite as complicated as their 2020 counterparts, with a few exceptions. The three most outstanding Washington 2021 Rosés were the Saviah Sangiovese-Barbera,, L'Ecole No 41 Grenache and Canvasback Syrah. 

There will be at least ten new Rosés in the July issue of the Review of Washington Wines, including some from Woodinville wineries. Again, mostly enjoyable quaffing ones. One extraordinary and different Rosé is the 2021 Kinhaven Estate which was made from 100% Cabernet Sauvignon. 

Here are the first two 2021 imported Rosés we've tasted this year.

2021 Ameztoi Getarriako Txakolina Rubentis ($23 - The Thief) - This Rosé from the Basque region of Spain displays a pink color, a frothy rime and intriguing aromas of strawberry, cherry, pink peach, pink grapefruit, cherry blossoms, pink lavender, cut herbs and pink incense. The flavors, as well, are distinctive, with bright pink fruits that are accented by grape skins, cherry stones and minerals. The back picks up strawberry and cherry liqueurs, grapefruit peel and spritz on the light alcohol (11%) crisp, dry finish. 18.5/20 points.

2021 Caves d'Esclans "Whispering Angel" Côtes de Provence Rosé ($24 - The Thief) - This vintage shows a light copper-tinged pink color and attractive aromas of strawberry, pink cherry, pink peach, Mandarin orange, pink roses, pink lavender and pink incense. The flavors are light and fresh in a quaffable style, with pink fruits thatnare accented by grape skins, cherry stones and Esclans Valley minerals. The vivacity continues on the back with fraise and cerise liqueurs and recurring orange peel, followed by a deftly extracted finish. 18.5/20 points.

No Review Blog Next Week

On June 8, we will be leaving for Seattle, returning Sunday, June 12, so there will be no blog next week. The next blog will be on June 17 and will report on our visit to Woodinville.

 

 

Looking Ahead to July

Details
Written by Rand Sealey
Published: 25 May 2022

Now that the June issue of the Review of Washington Wines is on line, we are already working on the July issue of the Review of Washington Wines which will go on line June 24. In the Walla Walla Valley, we have already visited Saviah Cellars, Balboa and Grosgrain and have appointments lined up at Kinhaven, Revelry and Gifford Hirlinger. We will be visiting Woodinville on June 10 to catch up on Efeste, DeLille Cellars and JM Cellars. There will be a lot of exciting new wines reviewed, including Grenaches from Saviah and Grosgrain and 2021 whites from Balboa. 

In upcoming Review Blogs, I will write about wines made from the up and coming Grenache grapes, Grenache Blanc, Grenache Noir and Rosé of Grenache. There will be tasting reports on wines from around the world. And in early July, I will be taking a look at liquor privatization in Washington State ten years later. More later!

Recently Tasted International Wines

Details
Written by Rand Sealey
Published: 17 May 2022

Here are some more wines from around the world that we've tried recently.

French Wines

N.V. Langlois Crémant de Loire ($21.99 - Safeway) - Composed of 70% Cabernet Franc and 30% Pinot Noir, this displays a brilliant copper-tinged pink color, streaming bubbles and attractive aromas of strawberry, pink cherry, tangerine, cherry blossoms and pink flowers. The flavors, as well, are appealing, with bright fruits that fill the mouth, along with notes of grape skins, cherry stones and minerals. The back is enlivened by fraise and cerise liquuers and CO2 on the brisk, dry finely fruited finish. 18.5/20 points.

2016 Domaine Brussett Gigondas, "Les Secrets de Montmirial" (Purchased for $57.99 in 2018) - This is Brussett's old vine Reserve. It exhibits a deep ruby color and intense aromas of black currant, black cherry, black plum, crushed roses, dark tobacco, garrigue and spiced incense. The dark fruit flavors are intense, still youthful, with notes of licorice root, extra dark cocoa, French roast and Montmirial minerals. The penetration continues on the back with creme de cassis and kirsch liqueurs band charcoal, followed by a lengthy still ripe tannin finish. 19+/20 points.

2019 Saumaize-Michelin Pouilly-Fuissé, "Clos" Sur la Roche ($49.99 - wine.com) - From beneath the Rock of Vergisson, this is an outstanding Pouilly-Fuissé. It shows a brilliant gold color an d perfume aromas of pear-apple, white peach, citrus, apple blossoms, acacia flowers, wisteria and wet stone. The flavors are intense and mouth filling, pure Chardonnay, with notes of grape and pear skins, peach stones and Vergisson granitic minerals. On the back, the wine gains intensity, with poire and pêche liqueurs and lemon custard on the way to a lingering, finely fruited finish. "Back to France, I love it!" says Lynn. 19+/20 points.

2019 Louis Jadot Chorey-les-Beaune "Les Beaumonts" ($47.99 - wine.com) - Chorey is situated below Aloxe-Corton. This displays a brick red color and attractive aromas of strawberry, cherry, red currant, rosebuds, cherry blossoms, orange peel and whiffs of sweet incense. The flavors are medium bodied but substantial, with supple red fruits that are imbued with licorice, cocoa powder, orange pekoe tea and damp earth. The appeal continues on the back with gently pressed fruits, fraise and cerise liqueurs and soft pencil lead, followed by a smooth ripe tannin finish, For those who appreciate a charming Pinot Noir, this gets 19/20 points.

Back in 2018, when I learned that the 2015 was turning out to be a great year for Burgundy, I bought heavily into that vintage. Recently, we opened a few bottles which have turned out to be beautiful wines.

2015 Louis Jadot Côtes de Nuits Villages (Purchased for $44.99) - This multi vineyard blend shows a garnet edged brick color and rich, sultry maturing aromas of semi-dried fruits - cherries, plums, orange - with scents of crushed roses, tobacco leaf, sandalwood and stick incense. The flavors are rounding out with supple red fruits that are intermixed with licorice root, coffee beans and earth. The back reveals roasted berries, toffee, dried orange peel and smooth tannins on the suave finish. 19/20 points.

2015 Faiveley Mercurey Premier Cru, Clos ds Myglands ($44.99) - Deep garnet edge-colored (typical of a maturing Burgundy), this possesses sultry aromas of semi-dried fruits - strawberry, cherries, black currants - with scents of crushed roses, mulberry, tobacco, dried orange peel, sandalwood and incense. The flavors are rounding out with what the Burgundians call "velours," with notes of licorice, cocoa, coffee beans and Saone river minerals. On the back, the wine retains its focus, supported by pressed fruits, roasted nuts and creme de cassis, followed by a lengthy chewy tannin finish. 19/20 points.

2015 Louis Jadot Chambolle-Musigny Premier Cru, Les Fuées ($124.99) - Deep ruby-garnet colored, this wine possesses an intoxicating bouquet of wild strawberry, old tree cherry, black currant, crushed rose petals, orange peel and exotic incense. The flavors are simultaneously bold and refines with thick red fruits that are infused with licorice root, cocoa powder, black tea and granitic minerals. The penetration continues on the back with fraise and creme de cassis liqueurs, dried orange peel, suede leather and charcoal stick, followed by an ultra-long sweetish tannin finish. Will continue to age beautifully. 19.5/20 points.

2015 Domaine Jacques Fréderic Mugnier Nuits-St. Georges Premier Cru, Clos de la Maréchale ($124.99) - This is a classic Nuits-St. Georges. It exhibits a ruby-garnet color and a rich bouquet of semi dried fruits - raspberries, cherries, red currants, orange peel - with scents of dried roses, aged cigar wrapper, sandalwood and oriental incense. The flavors are rich and vigorous, with notes of licorice, cocoa, black tea and granitic minerals. On the back, the Burgundian "velours" emerges with dried fruits and orange peel on the lengthy finish. 19.5/20 points.

International Sauvignon Blancs

Recently, we picked up some Sauvignon Blancs from around the world that show what can be done with this undervalued variety.

2020 Ferrari-Carano Fumé Blanc Sauvignon Blanc, Sonoma County ($18) - Back in the 1980's Ferrari-Carano was one of the first wineries to call Sauvignon Blanc "Fumé Blanc" after the ones of the upper Loire Valley. This vintage shows a brilliant straw color and attractive aromas of pear, peach, citrus, pear blossoms, jasmine, lemongrass and green incense. The flavors are brisk yet nicely fruited, with notes of grape and pear skins and stony minerals. The vibrancy continues on the back with poire and pêche liqueurs, grapefruit peel and neutral oak on the crisp finish. "I love it," says Lynn. A bargain when purchased for $13.99. 18.5/20 points.

2021 Wautoma Springs Sauvignon Blanc, Columbia Valley ($18) - This is a bright, fresh, lively Washington Sauvignon Blanc, with notes of grape skins, melon rind and saline minerals, and a bit of passionfruit on the back adds a bit of tropicality. Full review to be in the June issue of the Review of Washington Wines. 18.5/20 points.

2020 J. de Villebois Pouilly-Fumé ($29.99 - Safeway) - This is Fumé Blanc (the local name for Sauvignon Blanc) from Pouilly-sur-Loire. It shows a brilliant lemon-gold color and striking aromas of green apple, white peach, gooseberry, lime, gunflint and white smoke. The flavors, as well, are distinctive, with white and green fruits that are accented by grape and apple skins, peach stones and Kimmeridgian marl minerals. The vibrancy continues on the back with Calvados and pêche liqueurs and lime zest on the way to a crisp, persistently minerally finish. 18.5+/20 points.

When it comes to wine, New Zealand is best known for its dry, crisp Sauvignon Blancs. Most are commercial but here are two fine examples.

2021 Whitehaven Sauvignon Blanc, Marlborough ($16.99 - Safeway)  - Light straw colored, this possesses expressive aromas of green pear, gooseberry, kiwi, lime, peat blossoms, jasmine, cut grass and wet stone. The flavors are brisk and lively yet ripe and mouthwatering, with notes of grape and pear skins and riverside minerals. The back picks up pear liqueur and lime zest on the way to a racy yet finely fruited finish. 18.5/20 points.

2021 Anthony Joseph Vidal Sauvignon Blanc, Marlborough ($28.99 - Safeway) - This displays a brilliant lemon-gold color and floral aromas of green apple, white peach, passionfruit, gooseberry, apple blossoms, lemongrass, dill and wet stone. The flavors are crisp, almost laser-like, with notes of grape and pear skins, peach stones and minerals. The resonance continues ob the back with apple and peach h. liqueurs, and three months on lees adds texture, all accented by lime zest on the brisk finish. 18.5+/20 points.

 

  1. French and Italian Wines Tasted Recently
  2. Walla Walla Valley Spring Release 2022 Preview
  3. More Wines from Burgundy and the Rhone
  4. Still More Wines Tasted Recently

Page 1 of 128

  • 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": 1656266942,
                "last": 1656266942,
                "now": 1656266942
            }
        },
        "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: 12.00 ms / 12.00 ms Memory: 1.728 MB / 2.07 MB Application: afterLoad
Time: 39.57 ms / 51.57 ms Memory: 3.189 MB / 5.26 MB Application: afterInitialise
Time: 5.98 ms / 57.55 ms Memory: 0.652 MB / 5.91 MB Application: afterRoute
Time: 8.57 ms / 66.11 ms Memory: 0.290 MB / 6.20 MB Application: beforeRenderComponent com_content
Time: 4.79 ms / 70.91 ms Memory: 0.611 MB / 6.81 MB Application: Before Access::preloadComponents (all components)
Time: 0.69 ms / 71.60 ms Memory: 0.055 MB / 6.87 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 71.62 ms Memory: -0.004 MB / 6.86 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.31 ms / 71.93 ms Memory: 0.026 MB / 6.89 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 43.79 ms / 115.72 ms Memory: 2.278 MB / 9.17 MB Application: afterRenderComponent com_content
Time: 0.80 ms / 116.52 ms Memory: 0.099 MB / 9.27 MB Application: afterDispatch
Time: 3.15 ms / 119.67 ms Memory: 0.222 MB / 9.49 MB Application: afterRender

Database queries total: 39.65 ms

Memory Usage

9.87 MB (10,350,024 Bytes)

Database Queries

27 Queries Logged 39.65 ms


  1. Query Time: 0.20 ms Query memory: 0.025 MB Memory before query: 3.591 MB Rows returned: 0
    SELECT `data`
    
      FROM `esjqa_session`
      WHERE `session_id` = X'6535333065623665316438663231636236353161353833333139626631376331'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.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
    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.15 ms After last query: 0.87 ms Query memory: 0.022 MB Memory before query: 3.755 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `esjqa_session`
      WHERE `session_id` = X'6535333065623665316438663231636236353161353833333139626631376331'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    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
    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: 8.15 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 3.760 MB
    INSERT INTO `esjqa_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6535333065623665316438663231636236353161353833333139626631376331', 1, 1656266942, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `esjqa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6535333065623665316438663231636236353161353833333139626631376331', 1, 1656266942, 0, '', 0)
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.07 ms
    end0.00 ms
    query end7.94 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.57 ms After last query: 3.09 ms Query memory: 0.029 MB Memory before query: 3.975 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.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.18 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 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.23 ms After last query: 2.51 ms Query memory: 0.023 MB Memory before query: 4.166 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.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 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.23 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.178 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.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.01 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.53 ms After last query: 0.72 ms Query memory: 0.033 MB Memory before query: 4.243 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.04 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
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.30 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 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.30 ms After last query: 10.35 ms Query memory: 0.031 MB Memory before query: 5.441 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.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 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.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/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.21 ms After last query: 4.57 ms Query memory: 0.025 MB Memory before query: 5.945 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.03 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.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
    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.84 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 5.936 MB
    UPDATE `esjqa_extensions`
    
      SET `params` = '{\"mediaversion\":\"bd46359eac9860e5b904bffdec22ae6e\"}'
      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.06 ms
    end0.01 ms
    query end5.65 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 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.25 ms After last query: 1.29 ms Query memory: 0.025 MB Memory before query: 6.180 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.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.02 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.01 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.25 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 6.193 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.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 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
    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: 5.05 ms Query memory: 0.031 MB Memory before query: 6.815 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.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.27 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 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: 14.09 ms After last query: 1.00 ms Query memory: 0.118 MB Memory before query: 7.009 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-06-26 18:09:02')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-06-26 18:09:02')
      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 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.02 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 data12.88 ms
    Creating sort index0.49 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.17 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.02 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.29 ms After last query: 1.82 ms Query memory: 0.035 MB Memory before query: 7.396 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` = 649
      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.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.02 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: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.25 ms After last query: 0.16 ms Query memory: 0.035 MB Memory before query: 7.418 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` = 648
      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.04 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.]

  17. Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 7.441 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` = 647
      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.06 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.]

  18. Query Time: 0.19 ms After last query: 0.13 ms Query memory: 0.035 MB Memory before query: 7.463 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` = 646
      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.]

  19. Query Time: 0.16 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.485 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` = 645
      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.]

  20. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.506 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` = 644
      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.20 ms After last query: 0.12 ms Query memory: 0.035 MB Memory before query: 7.528 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` = 643
      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.]

  22. Query Time: 0.18 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 7.549 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` = 642
      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.]

  23. Query Time: 0.17 ms After last query: 0.10 ms Query memory: 0.035 MB Memory before query: 7.571 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` = 641
      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.]

  24. Query Time: 5.03 ms After last query: 0.81 ms Query memory: 0.025 MB Memory before query: 7.645 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-06-26 18:09:02')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-06-26 18:09:02')
    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.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.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data4.74 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 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.32 ms After last query: 3.89 ms Query memory: 0.038 MB Memory before query: 8.073 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.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.07 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
    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.58 ms After last query: 0.39 ms Query memory: 0.037 MB Memory before query: 8.118 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.09 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.02 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.12 ms
    Creating sort index0.02 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.02 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 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.33 ms After last query: 15.32 ms Query memory: 0.026 MB Memory before query: 9.404 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-06-26 18:09:02')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-06-26 18:09:02')
      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.01 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.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: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'6535333065623665316438663231636236353161353833333139626631376331', 1, 1656266942, 0, '', 0
  2. 1 × UPDATE `esjqa_extensions` 
      SET `params` = '{\"mediaversion\":\"bd46359eac9860e5b904bffdec22ae6e\"}'