Review of Washington Wines Blog

The Top Wines of 2021

Details
Written by Rand Sealey
Published: 15 December 2021

Here is our annual listing of wines scoring 20/20 points and 19.5/20 points (using the University of California Davis 20 point system) for the year.

Wines Scoring 20/20 Points

2018 Force Majeure Estate Cabernet Sauvignon, Red Mountain ($125) - June

2019 Rotie Cellars "Big G" Estate Grenache, Walla Walla Valley ($85) - December

2019 Rotie Cellars "Love Rocks" Syrah, Rocks of Milton-Freewater, ENTAV Clone 470 ($65) December

2019 Rotie Cellars "Love Rocks" Syrah, Rocks of Milton-Freewater, ENTAV Tablas Creek Clone ($65) - December

In the January 2022 issue there will be three wines scoring 20/20 points that did not make it into the December issue

2018 Adams Bench Cabernet Sauvignon, Yakima Valley, Red Willow Vineyard ($80)

2018 Adams Bench Cabernet Sauvignon, Horse Heaven Hills, Mays Discovery Vineyard ($80)

2028 Adams Bench Cabernet Sauvignon, Columbia Valley, Stillwater Creek Vineyard ($80)

Wines Scoring 19.5/20 Points

2018 Valdemar Estates Cabernet Sauvignon, Walla Walla Valley ($70) - January

2018 Valdemar Estates Syrah, Red Mountain, Klipsun Vineyard ($80) - January

2017 Prospice Reserve Cabernet Sauvignon, Red Mountain, Quintessence Vineyard ($80) - January

2017 Pepper Bridge Cabernet Sauvignon, Walla Walla Valley ($65) - January

2017 Pepper Bridge Cabernet Sauvignon, Walla Walla Valley, Pepper Bridge Vineyard ($65) - January

2017 Pepper Bridge Cabernet Sauvignon, Walla Walla Valley, Seven Hills Vineyard ($65) - January

2017 Pepper Bridge "Trine" Red Wine, Walla Walla Valley ($70) - January

2018 Tierra Labrada Merlot, Walla Walla Valley, Elevation Vineyard ($85) - January

2018 Tierra Labrada Petit Verdot, Walla Walla Valley, Elevation Vineyard ($85) - January

2018 Tierra Labrada Cabernet Sauvignon, Walla Walla Valley, Elevation Vineyard ($95) - January

2019 Canvasback Riesling, Columbia Valley ($30) - February

2017 Canvasback Syrah, Red Mountain ($70) - February

2017 Canvasback Cabernet Franc, Red Mountain, Ciel du Cheval Vineyard ($70) - February

2017 Canvasback Cabernet Sauvignon, Red Mountain, Ciel du Cheval Vineyard ($70) - February

2017 Kontos Cellars "Brielle" Red Wine, Walla Walla Valley ($65) - March

2018 Kerloo Cellars Grenache, Yakima Valley, Lonesome Springs Vineyard ($57) - March

2018 L'Ecole No 41 Ferguson Vineyard Estate Red Wine, Walla Walla Valley ($70) - April

2018 PASXA Grenache, Walla Walla Valley, River Rock Vineyard ($80) - May

2018 PASXA Syrah, Walla Walla Valley, River Rock Vineyard ($80) - May

2018 PASXA Syrah, Walla Walla Valley, SJR Vineyard ($80) - May

2018 Avennia "Sestina" Red Wine, Columbia Valley ($75) - May

2017 Avennia Cabernet Sauvignon, Yakima Valley, Red Willow Vineyard ($95) - May

2018 DeLille Cellars Red Willow Blend Red Wine, Yakima Valley ($75) - May

2018 DeLille Cellars Chaleur Estate Red Wine, Red Mountain ($90) - May

2018 DeLille Cellars Harrison Hill Red Wine, Snipes Mountain ($105) - May 

2018 Force Majeure "Parvata" Red Wine, Red Mountain ($70) - June

2018 Force Majeure "Epinette" RedWine, Red Mountain ($95) - June

2019 Holocene "Apocrypha" Pinot Noir, Willamette Valley ($60) - June

2019 Holocene "Memorialis" Pinot Noir, Willamette Valley ($60) - June

2018 Canvasback Syrah, Walla Walla Valley, Funk Vineyard ($70) - June

2018 Canvasback "Grand Passage" Cabernet Sauvignon, Red Mountain ($84) - June

2018 Woodward Canyon Estate Reserve Red Wine, Walla Walla Valley ($89) - June

2019 Valdemar Estates Chardonnay, Yakima Valley, DuBrul Vineyard ($50) - June

2018 Valdemar Estates Cabernet Sauvignon, Red Mountain, Klipsun Vineyard ($80) - June

2018 Tero Estates Cabernet Sauvignon, Walla Walla Valley, Windrow Vineyard Hill Block ($58) - June

2018 Tero Estates Cabernet Sauvignon, Walla Walla Valley, Windrow Vineyard Plateau Block ($58) - June

2018 Tero Estates Cabernet Sauvignon, Walla Walla Valley Old Block ($58) - June

2017 Fidelitas Red Mountain Cabernet Sauvignon, Quintessence Vineyard ($70) - July

2018 Wautoma Springs "Long Vine" Clone 8 Red Wine, Columbia Valley ($100) - July

2018 Va Piano "Black Label" Syrah, Walla Walla Valley, Les Collines Vineyard ($75) August

2018 Va Piano "Black Label" Cabernet Sauvignon, Rattlesnake Hills, DuBrul Vineyard ($105) - August

2018 House of Bones Chardonnay, Columbia Gorge, Celilo Vineyard ($45) - September

2018 Proper Wines Reserve Syrah, Walla Walla Valley ($85) - September

2017 Northstar "Premier" Merlot, Columbia Valley ($80) - September

2020 Abeja Chardonnay, Washington ($45) - October

2018 Pepper Bridge Cabernet Sauvignon, Walla Walla Valley ($65) October

2018 Pepper Bridge Seven Hills Red Wine, Walla Walla Valley ($65) - October

2018 Pepper Bridge "Trine" Red Wine, Walla Walla Valley ($70) - October

2020 Canvasback Riesling, Royal Slope ($30) - October

2018 Abeja Estate Cabernet Sauvignon, Walla Walla Valley, Heather Hill Vineyard ($75) - November

2018 Kontos Cellars "Dorsey" Baker Red Wine, Walla Walla Valley ($55) - November

2018 Saviah Cellars Syrah, Walla Walla Valley, The Stones Speak Vineyard ($55) - November

2019 Brook & Bull Reserve Makbac, Walla Walla Valley ($58) - November

2019 Mark Ryan "Little Sister" Merlot, Columbia Valley ($80) - November

2019 Mark Ryan "Dead Horse" Cabernet Sauvignon, Red Mountain ($90) - November

2018 The Walls "Mahana" Syrah, Walla Walla Valley, River Rock Vineyard ($56) - November

2018 Gramercy Cellars "Langiappe" Syrah, Columbia Valley, Red Willow Vineyard ($65) - November

2018 Gramercy Cellars Estates Red Wine, Walla Walla Valley ($72) - November

2019 Valdemar Estates Chardonnay, Yakima Valley, French Creek Vineyard ($50) - December

2019 Valdemar Estates Malbec, Walla Walla Valley, Seven Hills Vineyard ($65) - December

2019 Valdemar Estates Syrah, Walla Walla Valley, Blue Mountain Vineyard ($75) - December

2018 Canvasback Cabernet Sauvignon, Red Mountain, Longwinds Vineyard ($72) - December

2018 Canvasback Cabernet Sauvignon, Red Mountain, Klipsun Vineyard ($72) - December

2018 Canvasback Cabernet Sauvignon, Red Mountain, Ciel du Cheval Vineyard ($72) - December

2019 Rotie Cellars "Little g" Grenache, Washington State ($65) - December

2019 Rotie Cellars "dre" Mourvèdre, Washington Stater ($65) - December

2018 àMaurice Cellars "Owl and Crown" Estate Cabernet Sauvignon, Walla Walla Valley ($75) - December

2017 Kontos Cellars "The Boss" Red Wine, Walla Walla Valley ($195 - 1.5 Liter) - December

2018 Sleight of Hand Cellars "Psychedelic" Syrah Walla Walla Valley, Stoney Vine Estate Vineyard ($60) - December

 

 

 

 

 

 

An Oyster and Chablis Tasting Plus More Burgundies

Details
Written by Rand Sealey
Published: 08 December 2021

An Oyster and Chablis Tasting

On Friday, December 3, Lynn and I hosted a tasting of oysters and Chablis. Six wines were served: one Chablis, three Premier Crus and two Grand Crus. The wines were accompanied by Kumamoto and Kushi oysters from Foodscape and jambon persillé (a parsley aspic which, according to my research, makes an excellent accompaniment to Chablis besides oysters). Here are my notes.

2019 Lamblin & Fils Chablis ($25 - The Thief, Walla Walla) - This communal appellation wine shows a light gold color and attractive aromas of pear, peach, melon, pear blossoms and hillside wildflowers and a hint of wintergreen. The flavors are delicate, yet well delineated, with notes of grape and pear skins and minerals. The back picks up poire and pêche liqueurs and lemon zest, followed by a crisp finish. 18+/20 points.

2019 Domaine Sylvain Chablis Premier Cru, Forêts ($39.90 - Foodscape, Walla Walla) - This is the first Premier Cru Chablis for under $40 I've seen in a long time (most are $50). It shows a brilliant lemon-gold color and floral aromas of apple, peach, melon, orange peel, apple blossoms, hillside flowers and wet stone. The flavors are crisp and resonant, yet accessible, with notes of grape and pear skins and hillside minerals. The back picks up apple and peach liqueurs and recurring orange peel, followed by a crisp, finely fruited finish. 18.5/20 points.

2019 Louis Moreau Chablis Premier Cru, Vau Ligneau ($45.90 - Foodscape) - This shows a brilliant gold color and aromas of green apple, Crenshaw melon, grapefruit, apple blossoms,  hillside flowers and wet stone. The flavors combine green and yellow fruits with oyster shell stones and and melon rind. The back reveals Calvados liqueur and grapefruit peel on the way to a bracing, steely finish. Goes great with Kumamotos. 19/20 points.

2019 Fevre-Fevre Chablis Premier Cru, Fourchaume ($48.99 - Esquin) - Brilliant gold colored, this possesses a steely, floral nose of pear, peach, lime, pear blossoms, wildflowers, and wet stone. On the palate, the wine is dynamically styled, with ripe fruits that are accented by grape and pear skins and Kimmeridgian calcareous minerals. The finish is especially exquisite for a Premier Cru, with a long, balanced finish. Judged the best 1er Cru by most tasters. 19+/20 points.

2019 Domaine Louis Michel & Fils Chablis Grand Cru, Le Clos ($99.99 - wine.com) - This is a great step above Premier Cru. It displays an iridescent gold color and rich, floral aromas of old tree pears, peach, melon, lime, apple blossoms, wildflowers and gunflint. The flavors are steely, pure high elevation Chardonnay, marked by grape and apple skins and oyster shell minerals. The resonance continues on the back with poire and pêche liqueurs, followed by a persistently minerally finish. 19.5/20 points.

2019 Domaine Drouhin Vaudon Chablis Grand Cru, Le Clos ($109.99 - wine.com) - This is made in an elegant, crisp negociant style. Brilliant lemon-gold colored, it presents floral aromas of apple, peach, melon, citrus, apple blossoms, wildflowers and wet stone. The flavors are a bit less focused than the Louis Michel Le Clos, with charming white and green fruits that are accented by grape skins and calcareous minerals. The wine finishes crisp and minerally. 19+/20 points. 

Other New Burgundies

2020 Roux Pere & Fils Mâcon La Roche-Vineuse ($18.99 - wine.com) - This offers a brilliant lemon-gold color and attractive aromas of pear, peach, grapefruit, pear tree blossoms, acacia flowers and whiffs of white incense. The flavors are fresh and bright, showing considerable Chardonnay purity, with notes of grape and pear skins, peach stones and minerals. The back picks up poire and pêche liqueurs and grapefruit peel on the way to a crisp, nicely fruited finish. Fine value. 18+/20 points.

2019 Laurent Perrachon & Fils Saint-Amour "La Gagière" ($19.99 - wine.com) - This is a lovely Cru Beaujolais. It displays a brilliant ruby color and perfumed aromas of strawberry, red currant, pomegranate, red roses, sweet pea flowers and whiffs of sweet incense. The flavors, as well, are charming, with red fruits that are imbued by red licorice, chocolate, black tea and granitic minerals. The appeal continues on the back with pressed berries, fraise and cassis liqueurs and soft charcoal, followed by a pleasingly fruited finish. 18.5/20 points.

2019 Château des Jacques Moulin-a-Vent ($24.99 - wine.com) - This Cru Beaujolais offers a brick red color and rich, earthy aromas of fraises de bois, cherries, brambly currants, black roses, tobacco, bayberry and stick incense. The flavors are thick and vigorous, with generous red fruits that are intermixed with licorice, cocoa, black tea and granitic minerals. On the back, the wine enriches further with macerated fruits, roasted nuts, fraise and cassis liqueurs, followed by a warm (14% alcohol) chewy ripe tannin finish. 18.5/20 points.

The following three wines come from a Domaine in Morey-St. Denis, that of Frederic and Michel Magnien, that has extensive holdings in the Côte de Nuits. The wines are aged in amphorae, which make them quite distinctive.

2019 Domaine Michel Magnien Bourgogne Côte d'Or Pinot Noir ($28.99 - wine.com) - From vineyards outside of the Crus of Gevrey-Chambertin, Morey-St. Denis and Vosne-Romanee, this shows a brick red color and enticing aromas of fraises de bois, red currants, blood orange, red roses, purple lilac, sweet tobacco and brambles. The flavors are ample yet deep, with red fruits that are intermixed with licorice, cocoa, black tea and hillside earth. The appeal continues on the back with pressed berries, fraise and cassis liqueurs and orange peel, followed by a ripe tannin finish. 18.5/20 points.

2018 Domaine Michel Magnien Côteaux Bourguignnons Pinot Noir ($29.99 - wine.com) - This comes from a small vineyard above the Côte de Nuits. It displays a deep crimson color and enticing aromas of raspberry, cherry, black currant, black roses, juniper berry, a hint of mint, and incense. The flavors are strikingly deep and full (sealed in by the amphorae) with red and black fruits that are intermixed with licorice, cocoa, French roast and hillside minerals. The back reveals pressed fruits, kirsch and creme de cassis liqueurs and soft charcoal, followed by a satisfying ripe tannin finish. 18.5/20 points.

2018 Domaine Michel Magnien Côte de Nuits Villages ($49.99 - wine.com) - This comes from Brochon which is situated between Fixin and Gerry-Chambertin. It shows a deep ruby color and intoxicating aromas of wild strawberries, red cherries, red currants, crushed roses, sweet tobacco, lavender and sweet incense. The flavors are deliciously ripe and mouth-filling, with lavish red fruits that are infused with licorice, cocoa, French roast and minerals. The appeal continues on the back with pressed fruits, roasted pecans, fraise and cassis liqueurs and soft charcoal, followed by a long, supple slightly grainy tannin finish. 19/20 points.

More Sparkling & French Wines

Details
Written by Rand Sealey
Published: 30 November 2021

In last week's blog, I wrote about the differences between Champagne and other sparkling wines. Since then, we've been trying other sparkling wines from Europe and the U.S. Here are our finds.

N.V. Domaine Ste Michelle Brut Sparkling Rosé, Columbia Valley ($11.99 - Safeway) - This sparkler sports a light copper-pink color, frothy bubbles and attractive aromas of strawberry, pink cherry, blood orange, cherry and orange blossoms and pink lilac. The flavors are fresh and vibrant, mouth-filling, with red fruits that are accented by cherry stones, orange peel and minerals. The back enlivens with red fruit liqueurs, orange peel and CO2 on the way to a tangy nicely fruited finish. At $11.99, this is a steal. 18+/20 points.

2017 Argyle Vintage Sparkling Wine, Willamette Valley ($24.99 - Safeway) - This vintage is comprised of 55% Chardonnay, 30% Pinot Noir and 15% Pinot Meunier. It displays an iridescent gold color, pinpoint bubbles and aromas of pear, peach, citrus, pear tree blossoms, white lilac, orange peel and white incense. The flavors are fresh and vibrant ("disgorged on demand") with white and yellow fruits that are accented by grape and pear skins and minerals. The back picks up poire and pêche liqueurs and touches of lees and brioche, followed by a CO2 enlivened Brut finish. 18.5/20 points.

N.V. Chandon, Blanc de Pinot Noir Brut Sparkling Wine, California ($18.99 - Safeway) - This copper-tinged gold colored wine offers streaming bubbles and attractive aromas of strawberry, pink chewy, grapefruit, pink roses, cherry blossoms and wildflowers. The flavors are brisk yet well textured, with notes of grape skins, cherry stones and minerals. The slightly leesy textured back picks up touches of toasted nuts, brioche and creme fraiche, followed by a true Brut finish. 18.5/20 points.

N.V. Chandon Brut Rosé Sparkling Wine, California ($18.99 - Safeway) - A blend of Chardonnay and Pinot Noir, this shows a brilliant copper-pink color, streaming bubbles and fragrant aromas of strawberry, cherry, blood orange, cherry and orange blossoms and whiffs of orange incense. The flavors are bright and vibrant, comprised of red and orange fruits that are accented by grape skins, cherry stones and minerals. The vibrancy continues on the back with fraise and kirsch liqueurs and orange peel, followed by a nicely fruited Brut finish. 18.5/20 points.

2020 La Marca Prosecco Rosé ($13.99 - Safeway) - La Marca is the best selling Italian Prosecco in the U.S., but is surprisingly good for a commercial brand. This vintage (check the date on the back) offers a copper-pink color, frothy bubbles and fresh aromas of strawberry pink cherry and orange peel. The flavors are brisk, enlivened by CO2 and accented by grape skins and cherry stones, followed on the back by strawberry liqueur and recurring orange peel on the crisp low alcohol (11%) finish. A Lynn favorite. 18+/20 points.

2020 Jeio "Bisol 1542"  Prosecco Brut Rosé ($18 - The Thief, Walla Walla) - Light copper colored, this possesses streaming bubbles and attractive aromas of strawberry, pink peach, Mandarin orange, pink roses, orange blossoms and whiffs of orange incense. The flavors are nicely fruited, with notes of grape skins, peach stones and minerals. The appeal continues on the back with strawberry and peach liqueurs and recurring orange peel, enliven by CO2 on the crisp, juicy low alcohol (11%) finish. 18+/20 points.

N.V. Loosen Bros "Dr. L" Sparkling Riesling ($19 - The Thief) - This German Sekt shows a brilliant lemon-gold color, streaming bubbles and fragrant aromas of pear, peach, grapefruit, pear blossoms, honeysuckle, clover and white incense. The flavors are bright and crisp, with white and yellow fruits that are accented by grape and, pear skins, CO2 and steely minerals. On the back, the wine enlivens further with pear and peach liqueurs and grapefruit peel, followed by a dry, persistently minerally finish. "This is delicious - has character," says Lynn. 18.5/20 points. 

N.V. Pierre Sparr Crémant d'Alsace, Brut Réserve ($19 - The Thief) - Brilliant gold colored, this emits streaming bubbles and enticing aromas of apple, pear, peach, citrus, apple blossoms, white lilac and wet stone. The flavors are bright and resonant, with notes of pear skins, peach stones and minerals. On the back, the wine enlivens further burgh poire and pêche liqueurs and touches of lemon custard and toast, followed by a lively Brut finish. "So delicious," says Lynn. 18.5/20 points.

N.V. Louis Boulliot Crémant de Bourgogne Brut Rosé, "Perle d'Aurore" ($23.99 - Safeway) - This is Pinot Noir with a bit of Gamay. It shows a brilliant copper-pink color, streaming bubbles, enticing aromas of fraises de bois, red currant, blood orange, rose petals, orange blossoms and whiffs of orange incense. The flavors are nicely balanced, with pink fruits that are enlivened by grape skins and CO2. The back picks up fraise and cassis liqueurs and orange peel, followed by a true Brut finish. "So festively pretty," says Lynn. 18.5/20 points.

N.V. Laherte Frères Champagne Extra Brut ($52 - The Thief) - Here, Extra Brut means 4.5 g/L dosage instead of 6) Composed of 60% Pinot Meunier, 30% Chardonnay and 10% Pinot Noir, it displays a light copper color, a frothy mousse and lovely aromas of Anjou pear, pink peach, blood orange, pear and orange tree blossoms and orange incense. The flavors, as well, are dramatic, with yellow and white fruits that are infused with grape and pear skins, peach stones and chalky minerals. The vibrancy continues on the back with poire and pêche liqueurs, recurring orange peel, lees and brioche, all counterpointed by CO2 on the dry, steely finish. 19/20 points.

New French Wines

Here are three Burgundies we've run across recently.

2021 Joseph Drouhin Beaujolais Nouveau ($19.90 - Foodscape, Walla Walla) - Made in carbonic maceration "nouveau" style, this displays a crimson color and ripe, young aromas of strawberry, red red currant, pomegranate, red roses, purple lilac and whiffs of ground spices. The flavors are deliciously young and fresh, with copious red fruits that are accented by grape skins, pomegranate seeds and a bit of earth. The vibrancy continues on the back with fraise and cassis liqueurs and a bit of toasted nuts on the juicy finish. 18/20 points. 

2020 Louis Jadot Beaujolais Village ($13.99 - Safeway) - This is an attractive new vintage. It offers a deep crimson color and engaging aromas of strawberry, cherry, red currant, rosebuds, purple lilac and whiffs of ground spices. The medium bodied flavors are bright and fresh, with red fruits that are intermixed with red licorice, cola and earth. The back picks up fraise and creme de cassis liqueurs in the way to a supple soft tannin finish. A tasty quaffable Beaujolais. 18/20 points.

2018 Justin Girardin Santenay Blanc, "Les Terrasses de Bievaux" ($32.99 - Esquin) - Santenay is situated at the southern end of the Côte d'Or. This Chardonnay presents a brilliant gold color and lovely aromas of Bosc pea, white peach, citrus, pear blossoms, acacia flowers and a hint of butternut. The flavors are vivid and true to variety, wish crisp yet viscous with white fruits that are imbued with grape skins, peach stones and granitic minerals. The resonance continues on the back with poire and pêche liqueurs and recurring butternut, followed by a lingering, finely fruited finish. 18.5+/20 points.

 

What is Champagne?

Details
Written by Rand Sealey
Published: 22 November 2021

"Would you like some more Champagne?" says the host, even when pouring an American sparkling wine. There is a difference between Champagne from the Champagne district of France and other sparkling wines. Anything else is not Champagne, even if it is bottle fermented. This is a critical issue for the Comité Interprofessionel du Vin de Champagne (CIVC). Legally, in the European Union, sparkling wines from outside Champagne can only be called "methode traditionelle" or "methode classique." In 2006, the U.S. banned the use of the Champagne name except for wineries already using it, being "grandfathered" (so you see Cook's or Andre being called "Champagne"). In the U.S., "methode Champenoise" is still legal, a rankling point for the CIVC. But Champagne houses owning American sparkling wine producers never use that term, only methode traditiionelle. Petilliant Naturelle wines ("Pet Nats") are called "methode ancestrale," bottle fermented sparkling wines without disgorgement. 

In the December issue of the Review of Washington Wines, you will find several American sparkling wines that are designated as methode traditiionelle or (incorrectly) methode champenoise. They are well made sparkling wines, but they are not Champagnes. 

There is a shortage of Champagne in the U.S. due to shipping delays. Many containers of Champagne and other European sparkling wines (French Cremant, Italian Prosecco, Spainish CAVA and German Sekt) are waiting to be unloaded at American seaports. A couple of weeks ago, I ordered one of our favorite brands of Champagne from Esquin and found out that it was sold out. As substitutes, I got these two which we found to be outstanding. Both come from proprietares-manipulants - grower-producers - who grow and make their own Champagnes. Generally proprietaires-manipulants produced more interesting Champagnes than those from negociant-manipulants from the well-known houses.

N.V. R. Dumont & Fils Champagne Blanc de Noirs Brut Nature ($50.99 - Esquin) - This wine was aged 4 years on the lees (instead of 3) to give it extra richness to counterpoint the zero dosage. It displays a brilliant light copper color, streaming bubbles and enticing aromas of fraises de bois, nectarine, orange peel, pink roses, orange blossoms and whiffs of orange incense. The flavors are laser-like yet rich and expansive, with notes of grape skins, nectarine stone and distinct minerality. The resonance continues on the back with bracing fruit acids counterpointed by a leesy texture and fraise and Cointreau liqueurs, all followed by a lengthy, bone dry yet finely fruited finish. 19+/20 points.

N.V. Jean Vesselle Champagne Brut Reserve ($51.99 - Esquin) - From Bouzy, which grows mostly Pinot Noir, this is a striking Champagne. It exhibits a light copper color, fine streaming bubbles and lovely aromas of wild strawberry, peach, mandarin orange, cantaloupe and orange tree blossoms. The flavors are exquisitely wrought, with red and yellow fruits that are interwoven with grape skins, peach stones and saline minerals. On the back, the wine takes a tantalizing turn with fraise and pêche liqueurs, melon rind and recurring orange peel, followed by a lingering CO2 lifted, persistently minerally Brut finish. 19+/20 points.

Happy Thanksgiving

Once again, I have to say that Thanksgiving is a distinctly American Holiday and should be celebrated with American wines. My recommendation is to have a not too tannic wine (steer away from Cabernet Sauvignon) such as a Merlot, Cabernet Franc or Pinot Noir. A sparkling wine such as those in the December issue of the Review of Washington or a California one (Chandon is one our favorites) will also do nicely. Just don't call it Champagne. Enjoy your dinner with your favorite American wine!

French Wines and California Pinots Tasted Recently

Details
Written by Rand Sealey
Published: 17 November 2021

New French Wines

Here are our latest discoveries in exceptional yet affordable French wines.

2020 Nicolas Idiart Sancerre Sauvignon Blanc ($27.99 - Esquin) - This is the first Sancerre I've seen with Sauvignon Blanc on the front label. It is a fine rendition of the grape. Brilliant lemon-gold colored, it possesses floral aromas of Anjou pear, peach, quince, Casaba melon, grapefruit, pear blossoms, jasmine and wet stone. The flavors are fresh and brisk, with notes of grape and pear skins, peach stones and chalky minerals. On the back the wine enlivens further with poire and pêche liqueurs, melon rind and grapefruit peel, followed by a persistently mineraly, crisp finish. 18.5/20 points.

2020 Régis Minet Pouilly Fumé, Vieilles Vignes ($30.99 - Esquin) - Pouilly-sur-Loire is across the river from Sancerre. This shows a brilliant light gold color and floral aromas of Bosc pear, white peach, Crenshaw melon, a hint of quince, with scents of pear blossoms, meadow flowers and wet stone. The flavors are vivid and refined, marked by grape and pear skins, cut grass and saline minerals. The resonance continues on the back with poire William liqueur and hazelnut, followed by s crisp yet silky finish. 18.5+/20 points.

2019 Domaine Perraud de la Grande Burette Mâcon-Villages, Vieilles Vignes ($18.99 - wine.com) - This offers a brilliant lemon-gold color and attractive aromas of pear, white peach, pear blossoms, acacia flowers (a trait of Mâconnais) and white incense. The flavors are pure Chardonnay, with bright white and yellow fruits that are accented by grape and pear skins and slate minerals. The vibrancy continues on the back with poire and pêche liqueurs and almond, followed by a crisp finish. A cut above the usual Mâcon Villages which gives it a plus. 18+/20 points.

2019 Jean-Marc Boillot Bourgogne Blanc ($26.99 - wine.com) - This comes from a grower in Pommard. It shows a brilliant gold color and enticing aromas of pear, white peach, citrus and wet stone, with scents of pear blossoms, acacia flowers and white incense. The flavors are mouth filling and resonate with notes of pear, peach stones and hillside minerals. On the back, the wine turns silky textured yet well delineated, with poire and pêche liqueurs, light oak (30% new) and a touch of creaminess (full malolactic) on the finish. 18.5/20 points.

2018 Justin Girardin Santenay Blanc, "Les Terrasses de Bienvaux" ($32.99 - Esquin) - Santenay is situated at the southern end of the Côte d'Or. This Chardonnay presents a brilliant gold color and lovely aromas of Bosc pear white peach, citrus, pear blossoms, wisteria and a hint of butternut. The flavors are vivid and true to variety, with crisp yet viscous white fruits that are imbued with peach stones and stony minerals. The resonance continues on the back with poire and pêche liqueurs and recurring butternut, followed by a lingering, finely fruited finish. 18.5+/20 points.

2019 Domaine de Chênepierre Chénas ($21.99 - Esquin) - Chénas is one of the least well known us of Beaujolais. This one received a Medaille d'Or at the Concours des Vins du Beaujolais. It offers a deep purplish-ruby color and engaging aromas of raspberry, black currant, black roses, purple lilac, rubbed sage and sweet incense. The flavors are generous and vigorous a fewous, with notes of red licorice, cocoa powder and schist minerals. On the back, the wine turns chewy yet silky textured, with pressed fruits, mocha, and framboise and creme de cassis liqueurs, followed by a pleasing moderate ripe tannin finish. 18.5/20 points.

 

Affordable 2019 California Pinot Noirs

I read in winemag.com (the on-line publication of the Wine Enthusiast) that the 2019 Pinot Noirs from California were exceptional and included many excellent values. I picked up a few from wine.com and at supermarkets and found them to offer high quality for their prices.

2019 Bogle Vineyards Pinot Noir, California ($10.98 - Super 1) - This was one of the Best Buys in the winemag.com article (89 points). It shows a medium brick red color and aromas of red fruits - strawberry, cherry, currant - with scents of rosebuds, orange peel and whiffs of stick incense. The medium bodied flavors are generous and fruit driven, with notes of red licorice, cola and earth. The back picks up pressed fruits, strawberry and kirsch liqueurs, followed by s well fruited soft tannin finish. 17.5/20 points.

2019 La Crema Pinot Noir, Monterey ($16.99 - Safeway) - This shows a medium brick red color and attractive aromas of strawberry, cherry, red currant, rosebuds, orange peel and wafts of orange incense. The flavors are medium bodied and direct, with pleasing red fruits that are intermixed with red licorice, cocoa powder, orange pekoe tea and Monterey wind-blown earth. The appeal continues on the back with gently pressed fruits, kirsch and recurring orange peel, followed by a plush soft tannin finish. 18/20 points.

2019 La Crema Pinot Noir, Sonoma Coast ($21.99 - Safeway) - This is a fine example of cool climate Pinot Noir. I shows a brick red color and attractive aromas of raspberry, cherry, black currant, orange peel, forest carpet and incense. The flavors are generous yet substantial, with notes of red licorice, cola, orange pekoe tea and coastal wind blown earth. On the back, the focus increases with pressed fruits, framboise and cassis liqueurs, recurring orange peel and touches of nougat and cherry preserves, followed by a pleasing moderate tannin finish, lifted by bright fruit acids. 18.5/20 points.

2019 Hartford Court Pinot Noir, Russian River Valley ($34.99 - wine.com) - The Russian River Valley in Sonoma County is one of the best AVAs for Pinot Noir. This one shows a brick red color and engaging aromas of wild strawberries, black currants, crushed rose petals, sweet tobacco, forest carpet, orange peel and sweet incense. The flavors are simultaneously lavish and deep, with copious red fruits that are intermixed with red licorice, Belgian chocolate, black tea and riverside minerals. On the back, the wine invigorates with macerated fruits, roasted pecans, recurring orange peel and soft charcoal, followed by a lingering sweetish tannin finish. The highest quality/price ratio of the Pinots tasted. 19/20 points.

2019 Hanzell "Sebella" Pinot Noir, Sonoma Coast ($35.99 - wine.com) - Brick red colored, this wine possesses attractive aromas of fraises de bois, cherries, brambly currants, crushed roses, tobacco leaf, cedar, forest carpet and orange incense. The flavors are rich and chewy, with notes of licorice root, cola, black tea and gravel and loam. The back reveals macerated berries, roasted nuts, fraise and cassis liqueurs and soft charcoal, followed by a slightly grainy ripe tannin finish. 18.5+/20 points.

2019 Melville Pinot Noir, Sta. Rita Hills ($41.99 - wine.com) - The Santa Rita Hills of the Central Coast is another fine AVA for Pinot Noir. This one shows a medium brick red color and intriguing aromas of fraises de bois, cherries, red currants, crushed red roses, mulberry, pine needles and whiffs of stick incense. The flavors, as well, are distinctive, with tasty medium bodied red fruits that are imbued with red licorice, cocoa, orange pekoe tea and Santa Rita wind blown earth. On the back, the velvety texture is enlivened by bright fruit acids on the soft tannin finish. 19/20 points. 

2019 Twomey Pinot Noir, Russian River Valley ($49.99 - wine.com and Safeway) - Twomey is a part of the Family of Silver Oak. This is the priciest but best of the Pinots tasted. It shows a brick red color and a seductive nose of fraises de bois, red cherries, brambly currants, crushed rose petals, forest carpet, orange peel and whiffs of sweet incense. The flavors, as well, are attention-getting, with lavish yet focused red fruits that are infused with red licorice, cocoa powder, Earl Grey tea and Russian River gravelly loam. On the back, the wine takes an elegant turn with pressed fruits, fraise and cassis liqueur, recurring orange peel and charcoal stick, followed by a lengthy ripe moderate tannin finish, lifted by fruit acids. 19+/20 points.

  1. Walla Walla Fall Release Weekend 2021
  2. Walla Walla Fall Release 2021 Preview
  3. A Tasting of French, Washington and Oregon Syrahs
  4. Harvest 2021 a Wrap / Some Interesting Wines

Page 5 of 127

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

Back to Top

© 2022 Review of Washington Wines Blog

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1652797259,
                "last": 1652797259,
                "now": 1652797259
            }
        },
        "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.09 ms / 12.09 ms Memory: 1.728 MB / 2.07 MB Application: afterLoad
Time: 34.88 ms / 46.97 ms Memory: 3.190 MB / 5.26 MB Application: afterInitialise
Time: 5.76 ms / 52.73 ms Memory: 0.652 MB / 5.91 MB Application: afterRoute
Time: 9.27 ms / 61.99 ms Memory: 0.290 MB / 6.20 MB Application: beforeRenderComponent com_content
Time: 4.65 ms / 66.64 ms Memory: 0.611 MB / 6.81 MB Application: Before Access::preloadComponents (all components)
Time: 0.64 ms / 67.28 ms Memory: 0.055 MB / 6.87 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 67.30 ms Memory: -0.004 MB / 6.86 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.32 ms / 67.61 ms Memory: 0.026 MB / 6.89 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 41.88 ms / 109.49 ms Memory: 2.299 MB / 9.19 MB Application: afterRenderComponent com_content
Time: 0.77 ms / 110.26 ms Memory: 0.099 MB / 9.29 MB Application: afterDispatch
Time: 3.23 ms / 113.49 ms Memory: 0.234 MB / 9.52 MB Application: afterRender

Database queries total: 37.86 ms

Memory Usage

9.92 MB (10,407,072 Bytes)

Database Queries

27 Queries Logged 37.86 ms


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

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

  3. Query Time: 8.00 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 3.762 MB
    INSERT INTO `esjqa_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3330303034383662323964613763333365363337313466313862346331663438', 1, 1652797259, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `esjqa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3330303034383662323964613763333365363337313466313862346331663438', 1, 1652797259, 0, '', 0)
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.04 ms
    end0.00 ms
    query end7.83 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.00 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.33 ms After last query: 2.21 ms Query memory: 0.029 MB Memory before query: 3.977 MB Rows returned: 35
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `esjqa_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_extensionsNULLrefextensionextension82const351.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.10 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
    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.12 ms After last query: 1.63 ms Query memory: 0.023 MB Memory before query: 4.168 MB Rows returned: 4
    SELECT id, rules
    
      FROM `esjqa_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_viewlevelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4100.00NULL
    Profile
    StatusDuration
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.00 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  8. Query Time: 0.24 ms After last query: 9.92 ms Query memory: 0.031 MB Memory before query: 5.444 MB Rows returned: 1
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM esjqa_menu AS m
      LEFT JOIN esjqa_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL110.00Using index condition; Using where; Using filesort
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.m.component_id1100.00Using where
    Profile
    StatusDuration
    starting0.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
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.04 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
    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.17 ms After last query: 4.47 ms Query memory: 0.025 MB Memory before query: 5.947 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `esjqa_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.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: 6.31 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 5.938 MB
    UPDATE `esjqa_extensions`
    
      SET `params` = '{\"mediaversion\":\"293864731d7e7619c1fabbccb8c53607\"}'
      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 end6.09 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1131
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

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

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

  14. Query Time: 13.17 ms After last query: 0.99 ms Query memory: 0.118 MB Memory before query: 7.011 MB Rows returned: 9
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM esjqa_content AS a
      INNER JOIN esjqa_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN esjqa_categories AS c
      ON c.id = a.catid
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN esjqa_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN esjqa_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN esjqa_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-17 14:20:59')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-17 14:20:59')
      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 20, 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.12 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.05 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.03 ms
    Creating sort index0.49 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.13 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.00 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.26 ms After last query: 1.80 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` = 624
      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.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.18 ms After last query: 0.10 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` = 623
      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.01 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.19 ms After last query: 0.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` = 622
      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.]

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

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

  20. Query Time: 0.23 ms After last query: 0.12 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` = 619
      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.]

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

  23. Query Time: 0.17 ms After last query: 0.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` = 616
      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.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  26. Query Time: 0.48 ms After last query: 0.36 ms Query memory: 0.037 MB Memory before query: 8.119 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.07 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
    Creating tmp table0.03 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.10 ms
    Creating sort index0.02 ms
    end0.00 ms
    query end0.00 ms
    removing tmp table0.02 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:189
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

18 Query Types Logged, Sorted by Occurrences.

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