Review of Washington Wines Blog

What is Sauvignon Blanc?

Details
Written by Rand Sealey
Published: 22 August 2021

Sauvignon Blanc is widely thought of being a Bordeaux grape variety. They usually come in the high shouldered Bordeaux style bottles and the name Sauvignon Blanc sounds Bordeaux-like. Actually, the grape originated further north, in the Loire Valley. It not a white mutant of Cabernet Sauvignon. Rather, Sauvignon Blanc, crossed with Cabernet Franc, is the parent of Cabernet Sauvignon. As Cabernet Sauvignon grew in popularity in Bordeaux, so did Sauvignon Blanc for white wines. 

Sauvignon Blancs can be categorized into two main styles: Loire and Bordeaux. The former in sloped bottles and the latter in high shouldered ones. The Bordeaux style ones are sometimes blended with Semillon, the other principal white grape of Bordeaux. It is in the Loire Valley that Sauvignon Blanc is produced as a stand alone varietal. In Sancerre and Pouilly-sur-Loire, it is known as Blanc Fumé and the ones from Pouilly are called Pouilly-Fumé.  Sauvignon Blanc was introduced to California in the late 19th Century where it made good but not highly impressive wines. But in in the 1970's Robert Mondavi visited the Loire Valley after a trip to Bordeaux and fell in love with the Sauvignon Blancs of Pouilly and Sancerre and he began making a wine from select clones which he called Pouilly-Fumé. The Mondavis no longer own the winery, but a Pouilly-Fumé is still made from grapes grown at the Oakville Estate vineyard.

There are seven Sauvignon Blancs in the September issue of the Review of Washington Wines here is how they fall into these two categories, along with some others recently tasted.

Loire Style

2020 Woodward Canyon Estate Sauvignon Blanc, Walla Walla Valley ($29) - Like Robert Mondavi, Rick Small visited the Loire Valley and fell in love with Sauvignon Blancs. This version shows wonderful purity. Reviewed September. 19/20 points.

2020 Browne Family Vineyards Bitner Estate Sauvignon Blanc, Columbia Valley ($24) - Also bottled in a sloped bottle, this is a fine value when purchased for $16.99. Reviewed September. 18.5/20 points.

2020 Ferrari-Carano Fumé Blanc, Sonoma County ($18) - Ferrari-Carano was an early adopter of Fumé Blanc after Mondavi. This one shows a brilliant straw color and attractive aromas of pear, peach, grapefruit, pear and orange blossoms, lemongrass and cut herbs. The flavors are fresh and lively, with notes of grape and pear skins and saline minerals. The back picks up poire and pêche liqueurs and lemon zest on the way to a crisp, nicely fruited finish. A super buy at $13.99. 18.5/20 points.

2020 Dominique Roger Sancerre, Domaine du Carrou Sancerre ($29.99 - wine.com) - From a respected grower in Bué, this offers a brilliant gold color with aromas of Anjou pear, white peach, gooseberry, pear tree blossoms, jasmine, lemongrass and flintstone. The flavors are almost laser-like, with a beam of bright fruits that are accented by grape and pear skins and chalky minerals. The resonance continues on the back with poire and pêche liqueurs and lime zest, followed by a persistently mineraly finish. 18.5/20 points.

2019 Domaine Nicolas Gaudry Pouilly-Fumé ($22.99 - wine.com) - Today, Sancerre commands higher prices than for those from across the Loire River. This one shows a straw-gold color and slightly smoky aromas of Anjou pear, white peach, gooseberry, Crenshaw melon, pear blossoms, lemon verbena, jasmine and green incense. The flavors are vibrant and crisp yet viscous, with white and green fruits that are accented by grape and pear skins and chalky minerals. On the back, the wine takes an elegant turn with pear and peach liqueurs and precisely balanced fruit acids. Great value compared to the more trendy Sancerre. 18.5+/20 points.

2019 Hippolyte Reverdy Sancerre ($39 - The Thief, Walla Walla and Esquin) - Reverdy is our go-to Sancerre. Very precise and finely fruited, it scores 19/20 points. Reviewed in the March 10 Blog posting below.

2020 Kim Crawford Sauvignon Blanc, Marlborough ($16.99 - Safeway) - New Zealand is another country producing fine Sauvignon Blancs, particularly from the Marlborough region. This one features a light lemon-gold color and fresh aromas of pear, lemon, guava, kiwi, quince, verbena, cut grass and green incense. The flavors are crisp and laser-like, with notes of grape and pear skins and minerals. The vibrancy continues on the back with pear liqueur, lemon zest and tropical juices followed by a dry, fruity finish. 18+/20 points.

Bordeaux Style

2020 Three Rivers Sauvignon Blanc-Semillon, Red Mountain, Artz Vineyard ($38) - This 67%, 33% combination is modeled after a fine White Bordeaux such as a Graves Blanc. Reviewed September.  19/20 points. 

2020 Seven Hills Sauvignon Blanc, Columbia Valley ($20) - The grape composition is not specified, but it comes on Bordeaux-like. September issue. 18.5/20 points.

2020 Seven Hills Reserve Sauvignon Blanc, Columbia Valley ($30) - From hand-picked hillside vineyards, this shows considerable complexity. Reviewed September, 19/20 points.

2020 Chateau Ste Michelle Sauvignon Blanc, Columbia Valley ($12) - Crisply-styled, this is a super value at $7.99. 18+/20 points. 

2020 Novelty Hill Sauvignon Blanc, Columbia Valley ($20) - Another fine value when purchased for $15.99. 18+/20 points.

 

New Rhone & Burgundy Wines

Details
Written by Rand Sealey
Published: 18 August 2021

Recently, we received a shipment of new vintages of Rhone Wines and Burgundies from wine.com, an on-line purveyor of a wide selection of wines from around the world. Here's what we got.

Tavel and Gigondas

Among our favorite wines are those of Tavel (Rosés) and Gigondas (Grenache based Reds).

2020 Domaine de la Modorée Tavel Rosé, "La Dame Rousse" ($36.99) - This is pricey for a Rosé, but worth it. It displays a brilliant copper-pink color and seductive aromas of fraises de bois, pomegranate, red currants, blood orange, pink roses, orange blossoms, pink lavender and pink incense. The flavors are well extracted, yet deft, with delicious red and pink fruits that are accented by grape skins, orange peel and mas minerals. The resonance continues on the back with fraise and cassis liqueurs and, again, orange peel, followed by s lingering, lightly spiced dry yet finely fruited finish. 19/20 points. This Domaine also makes an excellent Cotes du Rhone Rose ($26.99). See posting of July 1 below. 18.5/20 points.

2018 Famille Perrin Gigondas, "La Gille" ($35.99) - From a respected South Rhone producer, this offers a deep ruby color and rich, smoky aromas of wild raspberry, cranberry, brambly currant, orange peel, crushed wild roses, mulberry, pipe tobacco, garrigue, olive tapenade and spiced incense. The flavors mirror the aromatics with generous, yet focused red and blue fruits that are intermixed with licorice, cocoa, French roast and Montmirial minerals. On the back, the wine opens up with pressed fruits, roasted nuts, framboise and crème de cassis liqueurs and charcoal, followed by a savory, juicy moderate tannin finish. 18.5+/20 points.

2017 Paul Jaboulet Gigondas, "Pierre Aiguille" ($23.99) - Composed of 80% Grenache and 10% each of Syrah and Mourvèdre, this displays a deep ruby color and enticing aromas of raspberry, black currant, crushed black roses, tobacco, black olive and spiced incense, The flavors are generous (typical of Grenache) yet focused, with loads of up front fruits that are intermixed with licorice, cocoa, French roast and rocky minerals. The penetration continues on the back with pressed fruits, framboise and cassis liqueurs, mocha, and charcoal, followed by a satisfying spiced, chewy finish. Delivers a lot of flavor for the price. 18.5/20 points.

2017 Lavau Gigondas ($27.99) - With 50% Grenache, 40% Syrah and 10% Mourvèdre, this is a robust Gigondas. It exhibits a deep ruby-crimson color and an intense nose of blackberry, black currant and black plum, with scents of black roses, pipe tobacco, garrigue (lavender and herbs), olive tapenade and spiced incense. The flavors are medium full-bodied, with ample, yet focused dark fruits that are infused with black licorice, dark cocoa, French roast and hillside minerals. On the back, the wine intensifies with macerated fruits, roasted nuts, crème de cassis, mocha and charcoal, followed by a savory ripe tannin finish. 18.5/20 points. Lavau also produces a bargain priced ($15.99) Tavel Rosé, reviewed below May 29. 18.5/20 points.

2017 Alain Jaume Gigondas, "Terrasses de Montmirial" ($37.99) - This boasts a semi opaque ruby color and an intoxicating nose of raspberry, black currant, black plum, black roses, dark tobacco, garrigue, olive tapenade and spiced incense. The flavors are thick and generous, yet focused, with layers of dark fruits that are infused with licorice, cocoa, French roast and Montmirial terraces granitic minerals. The saturation continues on the back with macerated fruits, roasted nuts, crème de cassis, toffee and burnt charcoal followed by a lingering, savory (cardamom, clove) ripe tannin finish. 19/20 points.

The Burgundies of Domaine Mongeard-Mugneret

In 2014, on our trip to France, we visited Domaine Mongeard-Mugneret in Vosne-Romanée. We saw the ancient cellar and tasted outstanding wines. The Domaine owns extensive holdings in the Côtes de Nuit and Côtes de Beaune. When I recently found the wines being offered by wine.com, I put in an order for them.

2018 Domaine Mongeard-Mugneret Bourgogne Pinot Noir ($31.99) - All Domaine produced, this presents a deep ruby color and engaging aromas of raspberry, cherry, currant, orange peel, crushed black roses, tobacco, sage and stick incense. The flavors are deliciously rich and supple, yet deep cored, with red fruits that are intermixed with licorice, cocoa, pekoe tea and earth. The appeal continues on the back with pressed fruits, mocha, framboise and crème de cassis liqueurs, recurring orange peel and soft charcoal, all followed by a smooth moderate tannin finish, lifted by bright fruit acids. "Delicious," says Lynn. 18.5/20 points.

2017 Domaine Mongeard-Mugneret Bourgogne Hautes Côtes de Nuits, "Les Dames Hughettes" ($36.99) - The Hautes Côtes is situated above the Côtes de Nuits. This wine is a fine example of high elevation Pinot Noir. It shows a brick red color and smoky aromas of fraises de bois, cherry and red currant, with scents of crushed roses, bayberry, orange peel, sagebrush and sultry incense. The flavors mirror the aromatics with medium bodied but substantial red fruits that are imbued with red licorice, cocoa powder, black tea and minerals. On the back, the wine invigorates and fleshens out, with pressed berries, roasted nuts, fraise and crème de cassis liqueurs and soft charcoal, followed by a moderate tannin and acid finish. 18.5/20 points.

2017 Domaine Mongeard-Mugneret Savigny-les-Beaune Premier Cru, Les Narbantons ($69.99) - Savigny is situated between Aloxe-Corton and Beaune. This shows a deep brick red color and rich, earthy aromas of fraises de bois, black cherries, black currants, wild roses, mulberry, tobacco, sandalwood and smoldering incense. The flavors, as well, are attention-getting, with mouth filling red fruits that are infused with licorice, cocoa powder, French roast and Savigny hillside minerals. On the back, the wine thickens with macerated fruits, grilled nuts, mocha, fraise and cerise liqueurs and crème de cassis, all followed by s lingering chewy yet satiny moderate tannin finish. 19/20 points.

2017 Domaine Mongeard-Mugneret Pernand-Vergelesses, Premier Cru, Les Vergelesses ($79.99) - From a vineyard situated near Corton, this shows a brick red color and classic aromas of fraises de bois, old tree cherries, wild currants, crushed roses, sweet tobacco, sandalwood, orange peel, violets and oriental incense. On the palate, the flavors are deliciously velvety ("velours") yet vigorous, with red fruits that are intermixed with licorice, cocoa, café au last and high elevation earth and granite. The wine builds up on the back with sensations of pressed fruits, roasted nuts, fraise and crème de cassis liqueurs and recurring orange peel, all followed seamlessly by a lingering, satiny tannin and balanced fruit acid finish. 19+/20 points.

Passing the Baton at Woodward Canyon

Details
Written by Rand Sealey
Published: 11 August 2021

Yesterday, I received an email with the following announcement from the Woodward Canyon Winery in Lowden, west of Walla Walla, quoted as follows:

Woodward Canyon is excited to announce the promotion of Jordan Dunn-Small from Director of DTC Sales to General Manager, Jordan is the daughter of founders Rick Small and Darcey Fugman-Small. She has been working at Woodward Canyon for seven years and has served as Director of DTC Sales since 2018.

Jordan grew up working at the family business during summer breaks and event weekends. Prior to officially joining the Woodward Canyon team in 2013, Jordan spent time working for the Walla Walla Valley Wine Alliance, Tertulia Cellars and Long Shadows Vintners.

Jordan's brother, Sager Small, is Vineyard Manager for Woodward Canyon Estate Vineyard and is also actively involved in sales and marketing for the winery. Rick and Darcey will move out of day-to-day operations but will continue to work on small projects, attend special events, and help mentor the next generation. They will also continue to serve on the Board of Directors.

"Having grown up in the wine industry and seeing ask of my parents' hard work, it's an honor to be entrusted with the legacy of our family business," said Jordan. "My brother and I look forward to continuing inner parents" footsteps while also bringing a new perspective to the business."

Woodward Canyon and the Small family have worked on strategic and succession planning over the last 10 years to ensure a smooth transition in family leadership for the winery that was founded in 1981 and is celebrating its 40th anniversary this year.

"Darcey and I could not be more pleased that Jordan and Sager both chose to return to Walla Walla and the family business," said Rick. "We are excited to watch them build on what we started forty years ago and take it to a new level."

I have known Rick since the winery was started in 1981. I remember him pouring his Riesling and Chardonnay (which were made while the newly planted vineyard was maturing). And his Dedication Series Cabernet Sauvignons, with labels depicting Walla Walla Valley pioneers set the benchmark for Washington Cabernets. He was also instrumental in getting approval for the Walla Walla Valley American Viticultural Area in 1984. 

Rick and Darcey were avid travelers and visited wineries and chateaux in France. In a visit to the Loire Valley, they became enchanted with the Sauvignon Blancs of Sancerre and Pouilly-sur-Loire, which became the model for the Woodward Canyon Sauvignon Blanc. 

Their contributions to the Washington wine industry are immeasurable. As the second oldest winery in the Walla Walla Valley, Woodward Canyon has a great legacy which will be continued by the next generation.

 

 

 

 

 

More Rosés Plus Esquin Hot Sheet Deals

Details
Written by Rand Sealey
Published: 06 August 2021

More New Rosé Wines

In the September issue (on line August 25) of the Review of Washington Wines, there will be four new Rosés. Here's a preview, full reviews to be in the September issue.

2020 Northstar Rosé, Walla Walla Valley ($28) - From the Northstar Estate Vineyard, this is the best Merlot Rosé tasted so far. Light copper-pink colored it possesses perfumed aromas of fraises de bois, kiwi, keymlime and orange blossoms. The flavors are simultaneously lush and crisp flavors with deftly extracted fruits and a lingering nicely juiced finish. 19/20 points.

2020 Gard Vintners "Grand Klasse" Rosé Wine, Royal Slope, Lawrence Vineyard ($25) - This 96% Grenache, 4% Mourvèdre combination offers a brilliant light pink color and aromas of strawberries, red currants, watermelon, pink roses, pink lavender with alluring light pink fruits and Royal Slope minerals, followed by a nicely fruited finish. 18.5+/20 points.

2020 Bartholomew Rosé of Counoise, Horse Heaven Hills, Coyote Canyon Vineyard ($19) - Counoise is a South Rhone variety. This version offers a light copper-pink color and aromas of strawberry, watermelon, pink flowers, pink lavender and pink incense wtih lively pink fruits that are accented by grape skins and melon rind, followed by a crisp, finely fruited finish. 18.5/20 points.

2020 Willamette Valley Vineyards "Whole Cluster" Rosé of Pinot Noir, Willamette Valley ($25) - This will be in the Values from Oregon special section. From the Dijon clone, it possesses lovely aromas of strawberry, pink cherry, red currants and pink flowers, with bright, lively flavors and precise fruit acids. Refreshing and charming. 18.5/20 points.

Other Rosés Tasted Recently

2020 Pierre-Marie Chermette Beaujolais Rosé, "Griottes" ($19.90 - Foodscape, Walla Walla) - This features a brilliant pink color and attractive aromas of strawberry, pink peach, tangerine, pink roses, orange blossoms and orange incense. The flavors are pleasingly light and sprightly, with notes of grape skins, peach stones and minerals. The vibrancy continues ob the back with strawberry and peach liqueurs and a raiser of orange peel in the dry finish. 18.5/20 points.

2020 Commanderie de la Bargemone Rosé, Côteau d'Aix en Provence ($18.99 - Esquin) - This shows a brilliant light copper-pink color and attractive aromas of strawberry, red currant, orange, orange blossoms, pink lavender and pink incense. The flavors are nicely delineated with light grape skin and hillside minerals. The back picks up fraise and cassis liqueurs and recurring orange peel, followed by a dry yet nicely fruited finish. 18.5/20 points.

2020 Conde Valdemar Rioja Rosé ($20 Valdemar Estates) - This 70% Garnacha, 30% Mazuelo combination displays a brilliant copper-pink color and attractive aromas of strawberry, pomegranate, Valencia orange, orange blossoms, pink lavender and orange incense. The flavors, as well, are appealing, with red and orange fruits that are accented by grape skins and stony minerals. The back picks up strawberry liqueur, pomegranate sees and orange peel on the way to a crisp, nicely fruited finish. 18.5/20 points.

2020 Oyster Bay Rosé, Marlborough, New Zealand ($13.99 - Safeway) - This amiable Rosé offers a light copper-pink color and attractive aromas of strawberry, pink cherry, pink peach, cherry blossoms, clover and pink incense. The flavors are brisk and lively, with pink fruits that are accented by grape skins, peach stones and minerals. The back picks up strawberry and peach liqueurs, followed by s finely fruited, crisp finish. 18/20 points.

N.V. Chandon Brut Rosé Sparkling Wine, California ($18.99 - Safeway) - This Chardonnay, Pinot Noir, Pinot Meunier combination is one of our favorites. It shows a brilliant copper-pink color, streaming bubbles and aromas of strawberry, pink cherry, tangerine, pink roses, cherry blossoms and whiffs of pink incense. The flavors are delightfully fresh and lively, with pink fruits that are accented by grape skins and cherry stones and enlivened by the CO2. The back picks up fraise and cerise liqueurs and orange peel, followed by a true Brut finish. 18.5/20 points.

Washington Wine Deals from the Esquin Hot Sheet

A couple of days ago, I received an email from Esquin Wine & Spirits with the monthly Hot Sheet featuring Washington wine specials for the August Washington Wine month. It included several wines that have been reviewed in the Review of Washington Wines.

2020 Novelty Hill Sauvignon Blanc, Columbia Valley ($13.99 - Regular $20) - Lemon-gold colored, this possesses aromas of pear, Crenshaw melon, citrus, summer flowers and lemongrass, with fresh, vibrant flavors that are marked by grape and pea skins, melon rind and minerals, followed by a crisp finish. Full review to be in the September issue. 18+/20 points.

2020 L'Ecole No 41 "Old Vines" Chenin Blanc, Yakima Valley ($14.99 - Regular $17) - This Vouvray style white offers a a lemon-gold color and attractive floral aromas of peach, kiwi, guava and citrus and vibrant flavors that are accented by peach stones and minerals, followed by an nicely fruited off-dry finish. Full review to be in the September issue. 18.5/20 points. 

2019 Helix Sangiovese, Columbia Valley, Stillwater Creek Vineyard ($21.99 - Regular $28) - This shows a medium brick red color and aromas of red fruits, plum, sun-dried tomato and herbs with charming medium bodied flavors marked by Royal Slope minerals. Full review to be in the September issue. 18.5/20 points.

2018 Freehand Cellars Cabernet Franc, Columbia Valley ($15.99 - Regular $25) - This offers a deep ruby color with rich, smoky aromas and thick, generous yet focused flavors that pick up roasted berries and nuts, followed by a savory, satisfying finish. Reviewed April 2021. 18.5/20 points.

2016 Buty "Wildebeest" Red Wine, Columbia Valley ($12.99 - Regular $20) - This combination of BDX and Rhone varieties offers rich.smoky aromas of blackberries, plums, cherries, combining the structure of BDX varieties and the mouth-filling flavors of the Rhone varieties. Reviewed May 2019. 18+/20 points. 

 

Walla Walla Valley Wine News

Details
Written by Rand Sealey
Published: 30 July 2021

The Heat Wave

So far, this summer is turning out to be the hottest on record in the Walla Walla Valley. Here's a comparison of the years 2015, the previous warmest year, and 2011. The average temperatures from April 1 to July 28 was 66.21 degrees in 2015 and 66.23 degrees in 2021. The Growing Day Degree numbers are 1961 for 2015 and 2021 for 2021. Veraison has already begun in some vineyards and the harvest is expected to be earlier than in 2015. Highs in July have usually been over 100, but moderated by cool nights. Highs are expected to ease into the 'eighties from August 5 on, which should facilitate the steady maturation of the grapes.

Tim Donahue Departs from the Community College

At the end of June, Tim Donahue departed from his position as Director of Winemaking at Institute for Enology and Viticulture at the Walla Walla Community College. where he has been since 2010. He has started his own winemaking consulting business, Horse Thief Wine Solutions. Besides his experience at the Community College, Donahue has a degree in Oenology from the University of Adelaide in South Australia and a degree in business management from the University of North Colorado. His stated aim is to be "Just a guy helping other folks' wine dreams come true."

Sabrina Leuck Named Interim Director at WWCC Wine Program

With the departure of Tim Donahue, Sabrina Leuck takes over as Interim Director of the Institute for Enology and Viticulture. She has taught there since 2011. She is from Victoria, B.C. and has a BS degree in Enology and Viticulture from Cornell University. 

  1. Reviewed Washington Wines Revisited
  2. My Take on the Ste Michelle Wine Estates Acquisition
  3. Three New Washington AVAs & Ste. Michelle Acquisition
  4. More French Wines

Page 8 of 127

  • 3
  • 4
  • ...
  • 6
  • 7
  • 8
  • 9
  • ...
  • 11
  • 12

Back to Top

© 2022 Review of Washington Wines Blog

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 11.67 ms / 11.67 ms Memory: 1.728 MB / 2.07 MB Application: afterLoad
Time: 32.77 ms / 44.44 ms Memory: 3.190 MB / 5.26 MB Application: afterInitialise
Time: 5.88 ms / 50.32 ms Memory: 0.652 MB / 5.91 MB Application: afterRoute
Time: 7.80 ms / 58.12 ms Memory: 0.290 MB / 6.20 MB Application: beforeRenderComponent com_content
Time: 4.57 ms / 62.69 ms Memory: 0.611 MB / 6.81 MB Application: Before Access::preloadComponents (all components)
Time: 0.66 ms / 63.35 ms Memory: 0.055 MB / 6.87 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 63.37 ms Memory: -0.004 MB / 6.86 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.33 ms / 63.71 ms Memory: 0.026 MB / 6.89 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 40.65 ms / 104.36 ms Memory: 2.272 MB / 9.16 MB Application: afterRenderComponent com_content
Time: 0.78 ms / 105.14 ms Memory: 0.099 MB / 9.26 MB Application: afterDispatch
Time: 3.12 ms / 108.26 ms Memory: 0.222 MB / 9.48 MB Application: afterRender

Database queries total: 33.77 ms

Memory Usage

9.87 MB (10,346,016 Bytes)

Database Queries

27 Queries Logged 33.77 ms


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

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

  4. Query Time: 0.40 ms After last query: 2.22 ms Query memory: 0.029 MB Memory before query: 3.977 MB Rows returned: 35
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `esjqa_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_extensionsNULLrefextensionextension82const351.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.11 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.14 ms After last query: 1.59 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.03 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.23 ms After last query: 0.05 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.05 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 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.42 ms After last query: 0.47 ms Query memory: 0.033 MB Memory before query: 4.245 MB Rows returned: 77
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM esjqa_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEesjqa_extensionsNULLrefextensionextension82const960.60Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.25 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.29 ms After last query: 9.91 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.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 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.52 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: 5.25 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 5.938 MB
    UPDATE `esjqa_extensions`
    
      SET `params` = '{\"mediaversion\":\"6acd40e5a2dbefb094a99628ce69af2c\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEesjqa_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.03 ms
    updating0.05 ms
    end0.01 ms
    query end5.03 ms
    closing tables0.01 ms
    freeing items0.01 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.19 ms After last query: 1.29 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.02 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.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.23 ms After last query: 0.15 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.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.53 ms After last query: 4.81 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.04 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.24 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    19Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:115
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:45
    13ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 12.27 ms After last query: 1.01 ms Query memory: 0.109 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:07:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-17 14:07:45')
      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 35, 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.14 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data11.03 ms
    Creating sort index0.53 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.12 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.34 ms After last query: 1.67 ms Query memory: 0.035 MB Memory before query: 7.392 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` = 609
      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.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.06 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.19 ms After last query: 0.10 ms Query memory: 0.035 MB Memory before query: 7.414 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` = 608
      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.]

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

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

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

  24. Query Time: 4.70 ms After last query: 0.80 ms Query memory: 0.025 MB Memory before query: 7.641 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:07:45')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-17 14:07:45')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL119.09Using where
    1SIMPLEaNULLrefPRIMARY,idx_access,idx_state,idx_catididx_catid4blogrevi_joomdb.c.id10516.00Using index condition; Using where
    1SIMPLEfpNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1100.00Using where; Using index
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.created_by1100.00Using where; Using index
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.modified_by1100.00Using where; Using index
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.c.parent_id1100.00Using where; Using index
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1100.00Using where; Using index
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data4.44 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.29 ms After last query: 3.59 ms Query memory: 0.038 MB Memory before query: 8.070 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.53 ms After last query: 0.35 ms Query memory: 0.037 MB Memory before query: 8.115 MB Rows returned: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM esjqa_fields AS a
      LEFT JOIN `esjqa_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN esjqa_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN esjqa_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN esjqa_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN esjqa_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `esjqa_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using index condition; Using where; Using temporary; Using filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28blogrevi_joomdb.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4blogrevi_joomdb.a.id1100.00Using where; Using index; Distinct
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.08 ms
    init0.04 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.34 ms After last query: 15.01 ms Query memory: 0.026 MB Memory before query: 9.400 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:07:45')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-17 14:07:45')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 2 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrangePRIMARY,published,newsfeedspublished5NULL28.33Using index condition; Using where; Using filesort
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403blogrevi_joomdb.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4blogrevi_joomdb.m.id140.00Using where; Using index
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    init0.03 ms
    System lock0.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.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: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'6338393166333331323464613663356432663465343032366235626131343438', 1, 1652796465, 0, '', 0
  2. 1 × UPDATE `esjqa_extensions` 
      SET `params` = '{\"mediaversion\":\"6acd40e5a2dbefb094a99628ce69af2c\"}'