Review of Washington Wines Blog

Various Wines Tasted Recently

Details
Written by Rand Sealey
Published: 19 July 2023

Here are several wines we've been drinking along with the ones going in the August issue of the Review of Washington Wines which goes on line July 25.

More New 2022 Rosés

2022 Underwood Rosé Wine, Oregon ($13.99 - Safeway) - Produced from undisclosed varieties, this is an amiable Pride Rainbow Rosé. It shows a copper-pink color and attractive aromas of strawberry, pink peach, watermelon, tangerine, pink roses, cherry blossoms, honeysuckle and pink incense. The flavors are captivating, with pink fruits that are accented by grape skins, cherry stones and minerals. The back picks up fraise and pêche liqueurs and orange peel, followed by a nicely juiced finish. Super value. 18.5/20 points.

2022 A to Z Oregon Rosé Wine ($18.99 - Safeway) - This Rosé is as pretty as the flowers on the bottle. Predominately Sangiovese, it presents a copper tinged pink color and expressive aromas of strawberries, pink cherries, pink currants, Mandarin orange, cherry blossoms and pink incense. The flavors, as well, are appealing, with bright pink and orange fruits that are accented by grape skins, cherry stones and minerals. The back picks up strawberry and cherry liqueurs and orange peel, followed by a faintly honeyed juicy finish. Lynn: 3 stars, "Excellent from front to back." 18.5+/20 points.

2022 Argyle Rosé Pinot Noir, Willamette Valley ($23.99 - Safeway) - Deep pink-tinged copper colored, this Rosé possesses intriguing aromas of strawberry, Rainier cherry, red currant, Mandarin orange, cherry blossoms and orange incense. The flavors are well extracted, with notes of grape skins, cherry stones and minerals. The back picks up fraise and kirsch liqueurs and a dollop of crème de cassis followed by a lingering, juicy finish. 18.5+/20 points.

2022 Gérard Bertrand "Coté des Roses" Rosé, Languedocuse ($20.99 - Safeway) - This Grenache, Syrah, Cinsault combination offers a light copper-tinged pink color and attractive aromas of strawberry, pink currant, tangerine, pink roses, pink lavender and pink incense. The pink theme continues on the palate with pink fruits that are accented by grape skins, tangerine peel and Languedoc minerals. The back picks up fraise and cassis liqueurs on the way to a crisp, pleasingly juicy finish. 18.5/20 points.

2022 Domaine de Fontsainte Corbières, "Gris de Gris" Rosé ($22.90 - Foodscape) - Although not indicated on the label, this is 100% Grenache from the Languedoc. It displays a light pink-tinged copper color and attractive aromas of strawberry, red currant, pomegranate, Mandarin orange, pink lilac, pink lavender and pink incense. The flavors are exquisitely balanced with pink and orange fruits that are accented by grape skins, pomegranate seeds and Languedoc scorched earth and minerals. The back picks up fraise and cassis liqueurs and orange peel, followed by a lingering lightly spiced finish. A real "find."  Lynn: 3 of 3 stars. 19/20 points.

2022 Château Thivin Beaujolais Rosé ($23 - The Thief) - Brilliant pink-tinged copper colored, this possesses enticing aromas of strawberries, red currants, Mandarin orange, pink roses, pink lilac and pink incense. The flavors are striking in that they pure Gamay in a Rosé form, with pink and orange fruits that are accented by grape skins, orange peel and minerals. The vibrancy continues on the back with fraise and cassis liqueurs and continuing orange peel, followed by a deliciously juicy finish. "Delicious and everything," says Lynn: 3of 3 stars. 19/20 points.

Other New Wines

2021 G.D. Vajra Rosso Langhe ($16.99 - Safeway) - This is tasty, robust Italian Piedmont blend of Nebbiolo, Barbera and Freisa. It shows a deep ruby color and aromas of raspberry, cherry, plum, black roses, pipe tobacco, black olive and sweet spiced incense. The flavors are ample yet focused, with copious red fruits that are intermixed with licorice, cocoa, Italian roast and Langhe hillside minerals. On the back, the wine fills out with raspberry and cherry liqueurs and plum preserves, followed by a ripe, chewy moderate tannin finish. An ideal pasta or pizza wine. 18.5/20 points.

2019 Domaine Raspail-Ay Gigondas ($49 -The Thief) - In 1970, I introduced the Raspail Gigondas from the South Rhone and it was a great seller. This vintage is outstanding. It shows a semi opaque ruby color and intoxicating aromas of blackberries, blueberries, black currants, black roses, garrigue, sandalwood, olive tapenade, wild violets and spiced incense. The flavors are bold and mouth encompassing, with lavish black and blue fruits that are infused with licorice root, 80% cacao, French press and Montmirial granite. The penetration continues on the back with macerated berries, creme de cassis and blueberry preserves, followed by a lengthy, decadently sweetish tannin finish. 19+/20 points.

2018 Beringer Cabernet Sauvignon, Knight's Valley Reserve ($49.99 - wine.com) - It was Beringer in the 1970s that put Knight's Valley in Sonoma County on the map. This vintage presents a semi opaque ruby color and intoxicating aromas of blackberries, black cherries, black plums, black roses, maduro wrapper, olive, sandalwood and stick incense. The flavors are simultaneously bold and refines, with layers of dark fruits that are infused with black licorice, bittersweet chocolate, espresso and valley floor earth and minerals. The intensity continues on the back with macerated fruits, roasted walnuts, kirsch, integrated oak and plum preserves, followed by a lingering finish that has been smoothed out by some bottle age. 19+/20 points.

Oregon Pinots

2022 A to Z Pinot Gris, Oregon ($16.99 - Safeway) - Brilliant grayish gold colored, this possesses attractive aromas of Bosc pear, Crenshaw melon, Key lime, pear blossoms, lemongrass and green incense. The flavors are fresh and brisk, with yellow and green fruits that are accented by grape and pear skins and calcareous minerals. The back is enlivened by pressed fruits, melon rind and lime zest, followed by a crisp, nicely juiced finish. 18.5/20 points.

2022 Coleho "Bunny Cuvée" Pinot Gris, Willamette Valley ($19.99 - Safeway) - This displays a brilliant gold color and fresh aromas of pear, white peach, cantaloupe, grapefruit, pear blossoms, daylilies, lemongrass and yellow incense. The flavors are bright and brisk, yet creamy textured, with yellow fruits that are intermixed with grape and pear skins and caliche minerals. The back picks up poire and peach liqueurs and melon rind on the way to a crisp, nicely juiced finish. 18.5/20 points. 

2021 Acrobat Pinot Noir, Oregon ($18.99 - Safeway) - This is a well put together "value" Pinot. It shows a medium ruby color and engaging aromas of strawberry, cherry, currant, rosebuds, bright leaf tobacco, sage and wafts of sweet incense. The flavors are medium bodied but substantial, with red fruits that are intermixed with red licorice, cocoa, orange pekoe tea and soft earth. The back picks up gently pressed berries, mocha, and crème de cassis, followed by a smooth tannin finish. 18+/20 points.

2021 Domaine Drouhin Pinot Noir, Dundee Hills ($46.99 - Safeway) - Maison Joseph Drouhin was the first Burgundy company to make Pinot Noir on Oregon in the 1970's. This one shows a deep brick red color and rich, smoky aromas of raspberry, cherry, black currant, crushed rose petals, tobacco leaf, rosemary, wild violets and stick incense. The flavors are simultaneously earthy and refined, with layers of red fruits that are intermixed with licorice, powdered cocoa, Earl Grey tea and hillside earth and minerals. On the back, the wine thickens with macerated berries, roasted nuts, mocha, kirsch and cassis liqueurs and lanolin ("legs") all followed seamlessly by a satiny, ripe moderate tannin finish. 19+/20 points.

 

Washington Liquor Privatization a Decade Later / A Super Buy from Cultura

Details
Written by Rand Sealey
Published: 14 July 2023

Liquor Privatization a Decade Later

It has been just ten years since that the initiative to privatize sales of spirts as well as wine and beer went into effect on July 1, 2013. With this, Washington State was taken out of the business of selling alcoholic beverages in state stores which is what the initiative was all about. Nearly 60% of the voters in November 2012 chose to put an end to state stores. The initiative included arcane layers of fees and taxes which took time to figure out. There is a $2.83 spirits tax and a 20.5% sales tax on spirits, both levied separately. But the effect of these taxes are mitigated by volume discounts which are permitted by the initiative. Other reductions can be found in production costs in producing spirits in huge volumes in column stills and in bottling in 1.75 liter bottles (I have seen many 1.75's in shopping carts at Safeway). All this is to the benefit of large retail operations such as Costco, Total Wine and Safeway that have the purchasing power to cut costs.

Over the past decade, the benefits of privatization have become evident with more convenience and wider choices. Stores also seem to be catering to the Gen X consumer. I have been struck by how many flavored Vodkas are being offered in just about anything. These products can be made cheaply by simply flavoring neutral spirits. These trends are also transferring to wine as more consumers are buying boxed wines and magnums. What all this means is that privatization in Washington works. And it works better than in a lot of other states. Our neighboring state, Oregon is among the states having the highest liquor prices in the country, thanks to state run stores. Washington consumers have gotten used to privatization and seem to be fine with it.

A Super Buy from Cultura

A couple of weeks ago, I saw on Facebook a posting by Erik McLaughlin about an impressive red from the Cultura winery in Zillah in the Yakima Valley. Then I happened to be in Selah with Lynn's niece who is married to a hops broker who has friends in the wine industry as well. He gave me a bottle of a Cultura wine which I found to be impressive.

2016 Cultura "Chronos" Red Wine, Yakima Valley ($40) - This bend of 50% Cabernet Sauvignon and 25% each of Merlot and Cabernet Franc offers a garnet edged ruby color and maturing aromas of blackberries, black cherries, plums, black roses, tobacco, cedar, semi dried herbs and stick incense. On the palate, the wine is thick and chewy, with aging softened dark fruits that are intermixed with licorice, Swiss chocolate, coffee grounds and dusty earth. The back reveals semi dried berries and plums, roasted nuts, kirsch and toffee, followed by a lingering, chewy, age softened tannin finish. 19/20 points.

This wine happens to be on sale at the winery for $28 a bottle, which makes it a super buy. I also will be putting in an order for other Cultura wines to be reviewed in the September issue. I am always on the lookout for under the radar wines such as this one.

Walla Walla Valley Wine News

Details
Written by Rand Sealey
Published: 06 July 2023

New Highway 12 Extended

In mid-June, the new section of Highway 12 above the old highway going through Lowden and Touchet was opened. There had been concern about how that would impact the L'Ecole No 41 and Woodward Canyon wineries in Lowden which would be bypassed by the new highway. I have found there to be no significant impact. Last week, I drove over to pick up some wines at L'Ecole for the August issue of the Review of Washington Wines. As I drove west, I came right on to the new section and I wondered if I would have to go all the way to Touchet. Then I came to a sign for the exit for Lowden and I turned on to it, got on and overpass and then down the road right to L'Ecole. Fast and easy. Actually quicker than on the old highway. Yesterday, driving back to Walla Walla, we saw signage for Woodward Canyon and L'Ecole before the Lowden exit.

Brian Rudin Leaving Canvasback for Echolands

Last week, I saw on Facebook and announcement by Brian Rudin that "After nine wonderful years at Canvasback Wines, I am departing to pursue new dreams. Making wine at Duckhorn has been a rare gift - there is no other wine company like this in the world." Joe Czarny is "Taking up the reins" at Canvasback as the "handpicked successor." It has since been announced that Brian will be working at Echolands (see below). I am absolutely sure Brain and Joe will be great in their new positions.

Echolands New Winery Under Construction

In the June 11 issue of the Walla Walla Union-Bulletin, there was an article about the new production facility, hospitality center and barrel room being constructed Mill Creek Road east of Walla Walla which will be a 27,000 square foot facility. By the new facility, 75 acres have been earmarked for a high elevation vineyard that can be dry farmed like the neighboring Walla Walla Vintners, Aluvé and Figgins vineyards. The winery will be a state of the art facility and, with Brian Rudin, the winery plans to go big. Doug Frost, an author and wine consultant in Kansas City, is the CEO and proprietor. 

Avennia to Open a Tasting Room in Walla Walla

Last week, it was announced that the Avennia Winery in Woodinville is planning to open a tasting room in Downtown Walla Walla in the newly opened Wala Wála (old spelling) Pedestrian Plaza on 1st Avenue between Main and Alder streets. "It's at the epicenter of what's going on downtown," says CEO and owner, Marty Taucher. This continues the trend of wineries outside of Walla Walla opening tasting rooms in Walla Walla. In the past two years, Guardian Cellars, Kerloo Cellars and Patterson Cellars have opened tasting rooms in the area. And Avennia's new facility will the winery's third tasting room in addition to the ones at Woodinville and Red Mountain. 

 

 

 

Looking Ahead to August / Austrian Rosés

Details
Written by Rand Sealey
Published: 29 June 2023

Looking Ahead to August

I'm now working on the August issue of the Review of Washington Wines. In the July issue, "Coming up in the August Issue" says "Walla Walla Fall Releases Preview." Actually, August is too early for reviewing Fall releases. Most of the new wines will be Summer releases, mostly onesies and twosies. These will include recent releases from Brook & Bull, Balboa, Northstar, Deux Soldats and others. A special feature will be "Super Values from L'Ecole No 41. On July 4, we will go to the Yakima Valley to visit Owen-Roe in Wapato and VanArm Cellars in Zillah. Other reports will include current vintages from Kerloo Cellars and Nefarious Cellars on Lake Chelan. 

Austrian Rosés

On Friday of last week, I was in Foodscape to pick up our order, and owner Hannah MacDonald showed me three new Austrian Rosés that had just come in. So I bought a bottle of each. We found all three to be attractively styled, suitable as either as food wines or for summer sipping.

2022 Gerhard Markowitsch Carnuntum Rosé ($21.90 - Foodscape) - This comes from the Eastern edge of Austria and is composed of 50% Zweigelt (a crossing of St. Laurent and Blaufranckisch), 30% Blaufrancisch and 10% each of Pinot Noir and Merlot. It shows a light copper-pink color and floral aromas of strawberry, pink cherry, Mandarin orange, pink roses, pink lavender and orange incense. The flavors are fresh and nicely wrought, with pink fruits that are imbued by grape skins, cherry stones and minerals. The back picks up kirsch and orange peel, followed by a pleasing pink juice finish. 18.5+/20 points.

2022 Weingut Soeliner Wagram Rosé ($22.90 - Foodscape) - From Kamptal, this is composed of 80% Zwiegelt, and 10% each of Pinot Noir and Cabernet Sauvignon. It displays a copper-tinged  pink color and attractive aromas of strawberry, cherry, tangerine, cherry blossoms and orange incense. The flavors are light but well delineated, with pink fruits that are accented by grape skins, cherry stones and minerals. On the back, the wine enlivens with berry and cherry liqueurs and orange peel, followed by a brisk, nicely juiced light alcohol (11.5%) finish. 18.5/20 points.

2022 Birgit Weiderstein Gottlesbrunn Rosé ($23.90 - Foodscape) - From Niederösterreich, this is comprised of 50% Zweigelt, 30% Pinot Noir and 20% Blaufranckisch. It offers a bright copper-pink color and attractive aromas of strawberry, pink cherry, tangerine, wild roses, orange blossoms, lavender and pink incense. The flavors are deliciously brisk and fresh, with pink and orange fruits that are accented by grape skins, cherry stones and minerals in a balanced style. The back picks up kirsch and orange peel on the way to a nicely juiced finish. 18.5/20 points.

 

Another 2022 Rosé Update

Details
Written by Rand Sealey
Published: 22 June 2023

Last weekend, I read an article in the Weekend Wall Street Journal by Lettie Teague, "Where to Turn in the Midst of a Rosé Rut." In it, she noted that Rosé wine sales are down overall, but some ones, according to retailers she interviewed, are selling well. Her recommendations in the article include three from Provence ("Provence still rules," said one retailer), one from the Languedoc and one Vin du Pays. One of these was the 2022 Whispering Angel Côtes de Provence, a brand developed by Sacha Lichine who popularized Rosé wines from 2006 on. I scored this wine 18.5+/20 points, noting its agreeable style. Another one I reviewed was the 2022 Domaine du Bagnol Cassis (a Provence sub appellation) which I scored 19/20 points. See the 31 May Blog posting for these two wines.

I, too, have noticed a rut of Rosé wines in supermarkets, with a lot of 2021's and even 2020's on shelves, including ones from Provence. The presence of older vintages is an indication of how well they are selling. But there are real gems to be found. We have found the 2022 Sancerre Rosés to be outstanding. "Sancerre through the roof," said one retailer interviewed by Lettie Teague. See the 16 May Blog posting below for the superb Pascal and Nicolas Reverdy's "Terre de Maimbray," 19.5/20 points. Also outstanding are the Domaine du Carrou, 18.5+/20 points and the Lucien Crochet, 19/20 points. Also outstanding is the 2022 La Bastide Blanche Bandol from just east of Marseille, scoring 19.5/20 points in the 24 May posting below.

There are excellent Washington State (and Oregon) Rosés as well, but the real standouts are the 2022 Mongata (June Review issue) and Canvasback (July issue), both scoring 19.5/20 points. Interestingly, both come from the Resurgent Vineyard on the South Fork of the Walla Walla River in Oregon. It's a toss up between the two. The Best Buy is the 2022 L'Ecole No 41 Grenache Rosé from the Alder Ridge Vineyard on the Horse Heaven Hills 19/20 points ($23 - April issue).

New Rosé Wines Tasted Recently

2022 Famille Perrin Côtes du Rhone Rosé ($10.99 - Safeway) - Fermented in stainless steel, this offers a light pink color and fresh aromas of strawberry, pink currant and Mandarin orange, with scents of pink roses, lilac and pink incense. The flavors are light but well delineated, with notes of grape skins, orange peel and minerals. The back picks up fraise and cassis liqueurs on the way to a brisk, juicy finish. Lynn: 3 of 3 stars. Super buy. 18.5/20 points.

2022 La Vieille Ferme Rosé ($12.29 - Super 1) - This is another super buy in French Rosé. It shows a light copper tinged pink color and attractive aromas of strawberries, pink cherries, pink currants and tangerine, with scents of pink lavender and pink incense. The flavors are fresh and sprightly, with pink fruits that are accented by grape skins, cherry stones and minerals. The vibrancy continues on the back with fraise and cassis liqueurs and tangerine peel, followed by a nicely fruited finish. Lynn: 3 stars. 18.5/20 points.

2022 Figuière Côtes de Provence Rosé, "Signature Magali" ($20 - The Thief, Walla Walla) - Composed of 35% Grenache, 35% Cinsault, 20% Syrah and 10% Cabernet Sauvignon, this displays a light copper-pink color and attractive aromas of strawberry, pink cherry, pink currant, pink grapefruit, pink roses, pink lavender and pink incense. The flavors are bright and fresh, with pink fruits that are accented by grape skins, cherry stones and Provençal minerals. The back picks up fraise and cassis liqueurs and grapefruit peel, followed by a crisp, juicy finish. A nice, approachable Rosé. 18.5/20 points. 

2022 Domaine Saint Damien Gigondas Rosé ($31 - The Thief) - Most Gigondas is red, but some Rosé is made. This one shows a brilliant copper-pink color and intriguing aromas of strawberry, pink currant, Mandarin orange, pink rose, orange blossoms and pink incense. The flavors are pleasingly juicy, leaning to orange, with notes of grape skins and Montmirial minerals. The back picks up fraise and cassis liqueurs and orange peel, followed by a lightly spiced finely fruited finish. 18.5/20 points. 

2022 Domaine Bailly-Reverdy Sancerre Rosé, "La Mercy Dieu" ($36 - The Thief) - Most Sancerre is white (Sauvignon Blanc) but some red and Rosé are made from Pinot Noir. This one is outstanding. It exhibits a brilliant copper tinged pink color and lovely aromas of strawberries, pink cherries, Mandarin orange, pink roses, daylilies and pink incense. The flavors are deliciously juicy, yet elegant, with pink fruits that are imbued with cherry stones, orange peel and upper Loire River minerals. On the back, the wine is illuminated but fraise and cerise liqueurs and a twist of orange peel, followed by a lingering, precise finish. 19/20 points. 

Here's one from Spain's Basque Region

2022 Ameztoi Getario Txaklcolina Robutis ($23 - The Thief) - This is an intriguing Rosé made from an indigenous grape. It shows a light pink color and aromas of wild strawberry, pink cherry, pink grapefruit, pink roses, lavender and pink incense. The flavors are brisk and deftly extracted, with notes of grape skins, cherry stones and Basque minerals. The back picks up cherry and kirsch liqueurs and grapefruit peel, followed by a low alcohol (11.5%) juicy finish. 18.5/20 points.

The following two wines will be in the August Review of Washington Wines with full reviews.

2022 Seven Hills Rosé of Cabernet Franc, Columbia Valley ($22) - This was released later than usual as the winery has the 2021 to move through. It shows a brilliant light pink color and attractive aromas of pink flowers and pink incense. The flavors are lightly extracted and nicely juiced. 18.5/20 points.

2022 Nefarious Rosé, Columbia Valley ($22) - This one from a Lake Chelan winery features a copper-tinged pink color and perfumed aromas, juicy flavors and an appealing fraise liqueur and orange peel accented finish. 18.5/20 points.

Finally, keep in mind that when it comes to Roses, preferences are highly personal. Certain Rosés are not for everyone. There are many styles to choose from and one should read the descriptions to determine if a wine fits one's taste.

  1. How I Pick Wines for The Blog
  2. International Wines Recently Tasted
  3. 2022 French Rosés Update
  4. Looking Ahead to July & New French Rosés

Page 3 of 141

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

Back to Top

© 2023 Review of Washington Wines Blog

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701837200,
                "last": 1701837200,
                "now": 1701837200
            }
        },
        "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: 19.80 ms / 19.80 ms Memory: 1.911 MB / 2.28 MB Application: afterLoad
Time: 52.83 ms / 72.62 ms Memory: 3.353 MB / 5.63 MB Application: afterInitialise
Time: 10.30 ms / 82.93 ms Memory: 0.960 MB / 6.59 MB Application: afterRoute
Time: 8.54 ms / 91.47 ms Memory: 0.286 MB / 6.88 MB Application: beforeRenderComponent com_content
Time: 7.33 ms / 98.79 ms Memory: 0.670 MB / 7.55 MB Application: Before Access::preloadComponents (all components)
Time: 1.85 ms / 100.64 ms Memory: 0.050 MB / 7.60 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 100.67 ms Memory: -0.001 MB / 7.60 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.45 ms / 101.12 ms Memory: 0.025 MB / 7.62 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 75.46 ms / 176.58 ms Memory: 2.101 MB / 9.73 MB Application: afterRenderComponent com_content
Time: 1.29 ms / 177.87 ms Memory: 0.160 MB / 9.89 MB Application: afterDispatch
Time: 5.24 ms / 183.11 ms Memory: 0.219 MB / 10.10 MB Application: afterRender

Database queries total: 56.59 ms

Memory Usage

10.48 MB (10,990,056 Bytes)

Database Queries

27 Queries Logged 56.59 ms


  1. Query Time: 0.61 ms Query memory: 0.022 MB Memory before query: 4.037 MB Rows returned: 0
    SELECT `data`
    
      FROM `esjqa_session`
      WHERE `session_id` = X'6233646439666161346663313037643438613366623131316666303863376462'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.01 ms
    Executing0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.03 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.01 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:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    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:386
    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.50 ms After last query: 1.48 ms Query memory: 0.020 MB Memory before query: 4.131 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `esjqa_session`
      WHERE `session_id` = X'6233646439666161346663313037643438613366623131316666303863376462'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.04 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.03 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 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:828
    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:386
    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: 3.21 ms After last query: 0.13 ms Query memory: 0.003 MB Memory before query: 4.198 MB
    INSERT INTO `esjqa_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6233646439666161346663313037643438613366623131316666303863376462', 1, 1701837200, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `esjqa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6233646439666161346663313037643438613366623131316666303863376462', 1, 1701837200, 0, '', 0)
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init for update0.02 ms
    Update0.17 ms
    Waiting for query cache lock0.01 ms
    Update0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit2.65 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.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:828
    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:386
    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.94 ms After last query: 2.67 ms Query memory: 0.021 MB Memory before query: 4.385 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_extensionsrefextensionextension82const35Using index condition; Using where
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.27 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.52 ms After last query: 3.33 ms Query memory: 0.020 MB Memory before query: 4.555 MB Rows returned: 4
    SELECT id, rules
    
      FROM `esjqa_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL4
    Profile
    StatusDuration
    Starting0.05 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.58 ms After last query: 0.18 ms Query memory: 0.020 MB Memory before query: 4.565 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbindexidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup8NULL9Using where; Using index
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.04 ms
    Statistics0.08 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.06 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 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: 1.45 ms After last query: 1.04 ms Query memory: 0.022 MB Memory before query: 4.632 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_extensionsrefextensionextension82const96Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.06 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.04 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.77 ms
    End of update loop0.03 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.96 ms After last query: 17.33 ms Query memory: 0.024 MB Memory before query: 5.881 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL1Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4blogrevi_joomdb.m.component_id1Using where
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics0.12 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.14 ms
    End of update loop0.03 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.01 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:417
    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:533
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1141
    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.77 ms After last query: 7.73 ms Query memory: 0.022 MB Memory before query: 6.629 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.10 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.10 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    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: 2.73 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 6.619 MB
    UPDATE `esjqa_extensions`
    
      SET `params` = '{\"mediaversion\":\"4acc57b6651f7ae8130c30b747e7babf\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `esjqa_extensions` SET `params` = '{\"mediaversion\":\"4acc57b6651f7ae8130c30b747e7babf\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.05 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init for update0.12 ms
    Updating0.11 ms
    End of update loop0.01 ms
    Waiting for query cache lock0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit2.10 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    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.77 ms After last query: 2.04 ms Query memory: 0.019 MB Memory before query: 6.863 MB Rows returned: 1
    SELECT *
    
      FROM esjqa_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.12 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.89 ms After last query: 0.33 ms Query memory: 0.018 MB Memory before query: 6.874 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const2
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403blogrevi_joomdb.s.template,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.10 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.04 ms
    Statistics0.11 ms
    Preparing0.05 ms
    Executing0.01 ms
    Sending data0.13 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.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: 1.68 ms After last query: 7.77 ms Query memory: 0.025 MB Memory before query: 7.553 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEesjqa_assetsrangeidx_asset_nameidx_asset_name202NULL36Using index condition
    Profile
    StatusDuration
    Starting0.11 ms
    Checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.05 ms
    Table lock0.01 ms
    Init0.09 ms
    Optimizing0.02 ms
    Statistics0.23 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.70 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.02 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.02 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: 27.65 ms After last query: 1.39 ms Query memory: 0.086 MB Memory before query: 7.685 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 <= '2023-12-06 04:33:20')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-06 04:33:20')
      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 10, 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL11Using where; Using temporary; Using filesort
    1SIMPLEarefPRIMARY,idx_access,idx_state,idx_catididx_catid4blogrevi_joomdb.c.id63Using index condition; Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4blogrevi_joomdb.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4blogrevi_joomdb.c.parent_id1Using where
    1SIMPLEveq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1Using where
    1SIMPLEfpeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1Using where
    Profile
    StatusDuration
    Starting0.37 ms
    Checking permissions0.02 ms
    Opening tables0.17 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.16 ms
    Optimizing0.09 ms
    Statistics0.17 ms
    Preparing0.10 ms
    Creating tmp table0.23 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data19.59 ms
    Creating sort index1.45 ms
    Removing tmp table4.85 ms
    Creating sort index0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    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.55 ms After last query: 2.92 ms Query memory: 0.022 MB Memory before query: 8.002 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` = 705
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.43 ms After last query: 0.29 ms Query memory: 0.022 MB Memory before query: 8.020 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` = 704
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.05 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.46 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 8.039 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` = 703
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.05 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.54 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 8.058 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` = 702
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.57 ms After last query: 0.29 ms Query memory: 0.022 MB Memory before query: 8.076 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` = 701
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.55 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 8.094 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` = 700
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.55 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 8.112 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` = 699
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.59 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 8.131 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` = 698
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.55 ms After last query: 0.29 ms Query memory: 0.022 MB Memory before query: 8.149 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` = 697
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4blogrevi_joomdb.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.08 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 5.35 ms After last query: 1.48 ms Query memory: 0.022 MB Memory before query: 8.225 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 <= '2023-12-06 04:33:20')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-06 04:33:20')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL11Using where
    1SIMPLEarefPRIMARY,idx_access,idx_state,idx_catididx_catid4blogrevi_joomdb.c.id63Using index condition; Using where
    1SIMPLEfpeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.id1Using where; Using index
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.04 ms
    Statistics0.10 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.05 ms
    Executing0.01 ms
    Sending data4.60 ms
    End of update loop0.02 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    13Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    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.93 ms After last query: 6.19 ms Query memory: 0.024 MB Memory before query: 8.694 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL11Using where; Using filesort
    Profile
    StatusDuration
    Starting0.18 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics0.11 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.11 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 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:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    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: 1.30 ms After last query: 0.62 ms Query memory: 0.024 MB Memory before query: 8.738 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28blogrevi_joomdb.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4blogrevi_joomdb.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4blogrevi_joomdb.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4blogrevi_joomdb.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4blogrevi_joomdb.a.id1Using where; Using index; Distinct
    Profile
    StatusDuration
    Starting0.17 ms
    Checking permissions0.01 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.02 ms
    Table lock0.01 ms
    Init0.06 ms
    Optimizing0.04 ms
    Statistics0.11 ms
    Preparing0.05 ms
    Creating tmp table0.07 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.26 ms
    Creating sort index0.04 ms
    Removing tmp table0.05 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    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.96 ms After last query: 24.49 ms Query memory: 0.022 MB Memory before query: 10.022 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 <= '2023-12-06 04:33:20')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-06 04:33:20')
      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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrangePRIMARY,published,newsfeedspublished5NULL2Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4blogrevi_joomdb.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403blogrevi_joomdb.m.module,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.13 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.08 ms
    Optimizing0.05 ms
    Statistics0.10 ms
    Preparing0.09 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.08 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:91
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    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'6233646439666161346663313037643438613366623131316666303863376462', 1, 1701837200, 0, '', 0
  2. 1 × UPDATE `esjqa_extensions` 
      SET `params` = '{\"mediaversion\":\"4acc57b6651f7ae8130c30b747e7babf\"}'