Eric Lundmark, Målarmästare

Antal personer i registret:

24643 efter den senaste dataimporten 12 Aug 2023

Eric Lundmark föddes 20 juni 1809 i Jäder socken i Södermanland. Gården föräldrarna bodde på hette Svedlunda Nr 1 och finns fortfarande idag men genom åren har namnet förändrats till dagens Svilunda. Jäder ligger mellan Strängnäs och Eskilstuna, några kilometer norr om E20.

Svilunda Nr 1, Erik Lundmark föddes i detta hus Föräldrarna var Smedmästaren Olof Janson Jäderholm och hans hustru Brita Pehrsdotter, tyvärr avled modern Brita ett halvår efter Erics födelse. Smedmästaren gifte snart om sig med en kvinna från Barkarö i Västmanland, hon hette Christina Andersdotter Barklund och blev således Erics styvmor.

Enligt berättelser i släkten så ska Smedmästaren Jäderholm varit elak mot sina fruar vilket ledde till att sonen Eric inte tog sin fars namn utan konstruerade ett eget efternamn utifrån styvmoderns namn och härkomst. Det var vanligt då att man skapade sig ett eget efternamn, precis som fadern gjort när han tog sig namnet Jäderholm efter som han var född i Jäder socken. Eric tog sig namnet Lundmark efter styvmoderns Lund i Barklund och lade till ordet mark som var en vanligt tillägg i efternamn.

Jag har hittat ny information om hur Eric fick sitt efternamn. I födelseboken för Erics mor framgår att ett av dopvittnena var Klockaren Lundmark, eftersom Svedlunda ligger nära Jäders kyrka så fanns denne Lundmark troligen i grannskapet även när Eric var liten. Jag finner det mer troligt att det är härifrån han tagit namnet Lundmark.

Eric flyttade redan vid femton års ålder tilll Eskilstuna för att bli målarlärling och sedemera ta mästarbrev. Så 1832 flyttar han till Arboga där han lever sitt resterande liv och är målarmästare. Där träffar han ganska snart en kvinna vid namn Maria Margareta Berglund som har arbetat några år som piga i Arboga, hon är född 11 augusti 1807 i Fellingsbro. Eric och Maria gifter sig 28 april 1833. De lever tillsammans i flera år innan de får sin ende son som får namnet Ernst Leonard. Sonen föds 26 augusti 1839.

Enligt ett brev där Erics barnbarn, Sigrid Lundmark, berättar om en historia när Eric och Maria är nygifta. Det gick en koleraepedemi i Arboga på hösten 1833, med den stora risken för smitta påbjöds att liken efter de insjuknade skulle omedelbart i jorden. Många lär ha begravts levande då sjukdomen tydligen gjorde att de riktigt medtagna verkade döda. Maria insjuknade i koleran, hon var då gravid och låg svårt medtagen och verkade död. Eric vägrade släppa in någon för att hämta hustrun. Man tänkte tvinga sig in men Eric bommade för dörren. Han behandlade henne med senapsdegar och massage m.m så att hon till slut kryade på sig. Hon födde sedan den 26 januari 1834 en dotter som fick namnet Carolina Erika. Flickan avled några dagar före sin årsdag den 23 Januari 1835. Det står inget om dödsorsak men troligen berodde det på sviter efter moderns kolera under graviditeten.

Eric Lundmark blir änkling när hustrun avlider 1853 och sonen Ernst är då bara 14 år gammal.

I en av husförhörslängderna anges att Eric 1868 dömdes för snatteri för att ha tillgripit timmer ute i markerna. Domen är från Glanshammars häradsrätt, det står dock inte vilket straff han fick för detta brott.

Eric lever resten av sitt liv som ogift i Arboga. Han får en änka vid namn Johanna Dalin som inneboende 1879, och de följs åt resten av deras liv. I senare husförhörslängder står hon som hans hushållerska. Fru Dalin omnämns även i ett brev från sonen till sin far efter julen 1880 alltså bara en kort tid efter att hon flyttat in. Brevet återges på annan plats. Fru Dalin avlider 1891 och Eric får leva sitt sista år i ensamhet.

Tråkigt nog så överlever Eric sin son Ernst som avlider redan vid 52 års ålder. Själv dör Eric året efter vid en ålder av 83 år.

Källor:

Jäder C:3 (1792-1846) bild 45
Arboga stadsförsamling EI:2 (1776-1853) Bild 66
Jäder B:1 Bild 71
Arboga stadsförsamling AIa:8a (1825-1835) Bild 486 / sid 480
Arboga stadsförsamling AIa:12b (1866-1871) Bild 199 / sid 186
Arboga stadsförsamling AIa:15c (1881-1885) Bild 114 / sid 484b
Arboga stadsförsamling F:7 (1873-1894) Bild 288
Familjebrev

Uppgifter: Skapad den torsdag, 28 juli 2011 15:46; Senast uppdaterad onsdag, 04 mars 2020 09:02

Vet du något?

Om du är släkt på något sätt med någon av de personer som finns i mitt register vill jag gärna ha kontakt med dig för att uppdatera alla uppgifter. Vet du något intressant om någon person från förr i tiden som kan berättas är det också intressant.

Joomlas felsökningskonsoll

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701948058,
                "last": 1701948058,
                "now": 1701948058
            },
            "token": "USKMm8kEI6vZxugXbEU3UqzVfVcZ4BeO"
        },
        "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
        },
        "gantry-current-template": "rt_nuance",
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-name": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-logo-type": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-logo-custom-image": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-accent-color1": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-accent-color2": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-pagesurround-background1": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-pagesurround-background2": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-pagesurround-background3": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-pagesurround-type": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-pagesurround-custompagesurround-image": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-headersurround-background": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-headersurround-type": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-headersurround-customheadersurround-image": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-maintop-textcolor": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-maintop-background": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-mainbody-overlay": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-expandedbottom-textcolor": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-expandedbottom-background": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-expandedbottom-type": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-expandedbottom-customexpandedbottom-image": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-extension-textcolor": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-extension-background": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-bottom-textcolor": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-bottom-background": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-footer-textcolor": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-footer-background": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-font-family": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-font-size-is": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-menu-type": null,
        "nuance-e7fc7859c063e5b0ca99e822ec3df8ad-layout-mode": null,
        "wb_sh404sef_404_redirect_message": null
    }
}

Profilinformation

Tid

Minne

Tid: 10.87 ms / 10.87 ms Minne: 0.403 MB / 0.76 MB Application: afterLoad

Tid: 58.27 ms / 69.14 ms Minne: 2.290 MB / 3.05 MB Application: afterInitialise

Tid: 9.00 ms / 78.14 ms Minne: 0.320 MB / 3.37 MB Application: Before Access::preloadComponents (all components)

Tid: 0.61 ms / 78.75 ms Minne: 0.063 MB / 3.43 MB Application: After Access::preloadComponents (all components)

Tid: 0.03 ms / 78.77 ms Minne: 0.000 MB / 3.43 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Tid: 0.30 ms / 79.07 ms Minne: 0.008 MB / 3.44 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Tid: 1.19 ms / 80.26 ms Minne: 0.059 MB / 3.50 MB Application: afterRoute

Tid: 1.88 ms / 82.14 ms Minne: 0.152 MB / 3.65 MB Application: beforeRenderComponent com_content

Tid: 1.79 ms / 83.92 ms Minne: 0.046 MB / 3.69 MB Application: Before Access::preloadPermissions (com_content)

Tid: 0.87 ms / 84.80 ms Minne: 0.056 MB / 3.75 MB Application: After Access::preloadPermissions (com_content)

Tid: 0.05 ms / 84.85 ms Minne: 0.000 MB / 3.75 MB Application: Before Access::getAssetRules (id:107 name:com_content.article.86)

Tid: 0.13 ms / 84.98 ms Minne: 0.007 MB / 3.75 MB Application: After Access::getAssetRules (id:107 name:com_content.article.86)

Tid: 23.86 ms / 108.84 ms Minne: 0.403 MB / 4.16 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tid: 0.07 ms / 108.91 ms Minne: 0.007 MB / 4.16 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tid: 29.53 ms / 138.44 ms Minne: 0.952 MB / 5.12 MB Application: afterRenderComponent com_content

Tid: 40.41 ms / 178.85 ms Minne: 0.256 MB / 5.37 MB Application: afterDispatch

Tid: 8.37 ms / 187.22 ms Minne: 0.260 MB / 5.63 MB Application: beforeRenderModule mod_roknavmenu ()

Tid: 8.87 ms / 196.08 ms Minne: 0.289 MB / 5.92 MB Application: afterRenderModule mod_roknavmenu ()

Tid: 4.97 ms / 201.06 ms Minne: 0.005 MB / 5.92 MB Application: beforeRenderModule mod_custom (Copyright)

Tid: 0.39 ms / 201.44 ms Minne: 0.006 MB / 5.93 MB Application: afterRenderModule mod_custom (Copyright)

Tid: 0.05 ms / 201.49 ms Minne: 0.000 MB / 5.93 MB Application: beforeRenderModule mod_custom (Sitemap)

Tid: 1.73 ms / 203.22 ms Minne: 0.012 MB / 5.94 MB Application: afterRenderModule mod_custom (Sitemap)

Tid: 0.05 ms / 203.26 ms Minne: 0.000 MB / 5.94 MB Application: beforeRenderModule mod_custom (Vet du något?)

Tid: 0.73 ms / 204.00 ms Minne: 0.005 MB / 5.95 MB Application: afterRenderModule mod_custom (Vet du något?)

Tid: 0.05 ms / 204.04 ms Minne: 0.000 MB / 5.95 MB Application: beforeRenderModule mod_articles_latest (Berättelser)

Tid: 0.65 ms / 204.70 ms Minne: 0.036 MB / 5.98 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tid: 0.01 ms / 204.71 ms Minne: 0.002 MB / 5.98 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tid: 6.09 ms / 210.80 ms Minne: 0.525 MB / 6.51 MB Application: afterRenderModule mod_articles_latest (Berättelser)

Tid: 0.06 ms / 210.86 ms Minne: 0.000 MB / 6.02 MB Application: beforeRenderModule mod_visitorcounter (Antal besök)

Tid: 5.64 ms / 216.50 ms Minne: 0.078 MB / 6.10 MB Application: afterRenderModule mod_visitorcounter (Antal besök)

Tid: 0.09 ms / 216.59 ms Minne: 0.000 MB / 6.09 MB Application: beforeRenderModule mod_custom (På dagens datum)

Tid: 0.44 ms / 217.03 ms Minne: 0.004 MB / 6.10 MB Application: afterRenderModule mod_custom (På dagens datum)

Tid: 0.06 ms / 217.09 ms Minne: 0.003 MB / 6.10 MB Application: beforeRenderModule mod_custom (Besökare)

Tid: 0.38 ms / 217.47 ms Minne: 0.006 MB / 6.11 MB Application: afterRenderModule mod_custom (Besökare)

Tid: 0.12 ms / 217.60 ms Minne: 0.000 MB / 6.11 MB Application: beforeRenderModule mod_custom (Registret)

Tid: 0.36 ms / 217.96 ms Minne: 0.003 MB / 6.11 MB Application: afterRenderModule mod_custom (Registret)

Tid: 0.12 ms / 218.08 ms Minne: 0.001 MB / 6.11 MB Application: beforeRenderModule mod_rokajaxsearch (Sök)

Tid: 1.78 ms / 219.87 ms Minne: 0.013 MB / 6.12 MB Application: afterRenderModule mod_rokajaxsearch (Sök)

Tid: 145.69 ms / 365.55 ms Minne: 0.549 MB / 6.67 MB Application: afterRender

Databasfrågor totalt: 28.65 ms

Minnesanvändning

Databasfrågor

69 loggade SQL-frågor 28.65 ms

15 duplikat funna!

2 duplikat: #8 #9

2 duplikat: #13 #15

2 duplikat: #16 #17

5 duplikat: #29 #48 #49 #50 #51

2 duplikat: #40 #42

2 duplikat: #41 #43

Frågetid: 0.31 ms Frågeminne: 0.023 MB Minne före fråga: 1.043 MB Returnerade rader: 0

SELECT `data`

  FROM `uadxs_session`

  WHERE `session_id` = X'6637313636326364653265393866353962353536333437623132353064343833'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_session	const	PRIMARY	PRIMARY	194	const	1

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Samma som samtal i raden nedan.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.27 ms Efter sista fråga: 0.39 ms Frågeminne: 0.020 MB Minne före fråga: 1.057 MB Returnerade rader: 0

SELECT `session_id`

  FROM `uadxs_session`

  WHERE `session_id` = X'6637313636326364653265393866353962353536333437623132353064343833' 
  LIMIT 1

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.33 ms Efter sista fråga: 0.07 ms Frågeminne: 0.004 MB Minne före fråga: 1.062 MB

INSERT INTO `uadxs_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6637313636326364653265393866353962353536333437623132353064343833', 1, 1701948058, 0, '', 0)

Förklara

EXPLAIN inte möjlig i fråga: INSERT INTO `uadxs_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6637313636326364653265393866353962353536333437623132353064343833', 1, 1701948058, 0, '', 0)

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.05 ms
Writing to binlog	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.47 ms Efter sista fråga: 0.71 ms Frågeminne: 0.040 MB Minne före fråga: 1.094 MB Returnerade rader: 45

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `uadxs_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ref	extension	extension	82	const	45	Using index condition; Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Anropsstack

#	Uppringare	Fil och radnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Samma som samtal i raden nedan.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.21 ms Efter sista fråga: 0.68 ms Frågeminne: 0.021 MB Minne före fråga: 1.142 MB Returnerade rader: 5

SELECT id, rules

  FROM `uadxs_viewlevels`

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_viewlevels	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	5

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.26 ms Efter sista fråga: 0.09 ms Frågeminne: 0.021 MB Minne före fråga: 1.154 MB Returnerade rader: 2

SELECT b.id

  FROM uadxs_usergroups AS a

  LEFT JOIN uadxs_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.60 ms Efter sista fråga: 0.18 ms Frågeminne: 0.031 MB Minne före fråga: 1.175 MB Returnerade rader: 123

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM uadxs_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ALL	extension	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	269	Using where; Använder filsortering

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.32 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Samma som samtal i raden nedan.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.25 ms Efter sista fråga: 6.04 ms Frågeminne: 0.022 MB Minne före fråga: 1.625 MB Returnerade rader: 1

Duplikatfrågor: #9

SELECT template

  FROM uadxs_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.20 ms Efter sista fråga: 0.04 ms Frågeminne: 0.023 MB Minne före fråga: 1.633 MB Returnerade rader: 1

Duplikatfrågor: #8

SELECT template

  FROM uadxs_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.23 ms Efter sista fråga: 1.40 ms Frågeminne: 0.021 MB Minne före fråga: 1.773 MB Returnerade rader: 2

SELECT extension, file, type

  FROM uadxs_rokcommon_configs

  ORDER BY priority

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_rokcommon_configs	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	2	Använder filsortering

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.45 ms Efter sista fråga: 9.77 ms Frågeminne: 0.025 MB Minne före fråga: 2.200 MB Returnerade rader: 18

SHOW FULL COLUMNS 
  FROM `uadxs_extensions`

Förklara

EXPLAIN inte möjlig i fråga: SHOW FULL COLUMNS FROM `uadxs_extensions`

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.06 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.26 ms Efter sista fråga: 0.32 ms Frågeminne: 0.021 MB Minne före fråga: 2.231 MB Returnerade rader: 1

SELECT `extension_id`

  FROM `uadxs_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.23 ms Efter sista fråga: 0.07 ms Frågeminne: 0.021 MB Minne före fråga: 2.237 MB Returnerade rader: 1

Duplikatfrågor: #15

SELECT *

  FROM uadxs_extensions

  WHERE `extension_id` = '10014'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.21 ms Efter sista fråga: 0.07 ms Frågeminne: 0.021 MB Minne före fråga: 2.242 MB Returnerade rader: 1

SELECT `extension_id`

  FROM `uadxs_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.24 ms Efter sista fråga: 0.05 ms Frågeminne: 0.021 MB Minne före fråga: 2.248 MB Returnerade rader: 1

Duplikatfrågor: #13

SELECT *

  FROM uadxs_extensions

  WHERE `extension_id` = '10014'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.41 ms Efter sista fråga: 18.30 ms Frågeminne: 0.024 MB Minne före fråga: 2.438 MB Returnerade rader: 1

Duplikatfrågor: #17

SELECT extension_id AS id, element AS "option", params, enabled

  FROM uadxs_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_advancedmodules'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	Samma som samtal i raden nedan.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:90
15	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
14	RokSprocket_Addon_AdvancedModuleManager->__construct()	Samma som samtal i raden nedan.
13	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
12	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
11	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
10	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
9	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.26 ms Efter sista fråga: 0.04 ms Frågeminne: 0.024 MB Minne före fråga: 2.433 MB Returnerade rader: 1

Duplikatfrågor: #16

SELECT extension_id AS id, element AS "option", params, enabled

  FROM uadxs_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_advancedmodules'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:92
15	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
14	RokSprocket_Addon_AdvancedModuleManager->__construct()	Samma som samtal i raden nedan.
13	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
12	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
11	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
10	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
9	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.27 ms Efter sista fråga: 4.02 ms Frågeminne: 0.022 MB Minne före fråga: 2.558 MB Returnerade rader: 2

SELECT *

  FROM uadxs_languages

  ORDER BY ordering ASC

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_languages	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	2	Använder filsortering

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:85
10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:101
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.54 ms Efter sista fråga: 0.75 ms Frågeminne: 0.068 MB Minne före fråga: 2.594 MB Returnerade rader: 31

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 uadxs_menu AS m

  LEFT JOIN uadxs_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

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	Using index condition; Using where; Använder filsortering
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.23 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
19	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Samma som samtal i raden nedan.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
16	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
15	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
14	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
13	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
12	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
11	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:131
10	Sh404sefClassPageinfo->loadHomepages()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:103
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.27 ms Efter sista fråga: 1.13 ms Frågeminne: 0.023 MB Minne före fråga: 2.852 MB Returnerade rader: 1

SELECT `params` 
  FROM uadxs_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:668
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:126
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.27 ms Efter sista fråga: 8.27 ms Frågeminne: 0.024 MB Minne före fråga: 3.222 MB Returnerade rader: 0

SELECT * 
  FROM `uadxs_sh404sef_aliases` 
  WHERE `state` = 1 
  and (`alias` = 'personliga-historier/eric-lundmark-malarmaestare.html') 
  order by `ordering` asc

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_sh404sef_aliases	ref	state,alias	state	1	const	1	Using where; Använder filsortering

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:222
15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:703
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
10	Sh404sefClassRouterInternal->preprocessParseRule()	Samma som samtal i raden nedan.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.22 ms Efter sista fråga: 0.20 ms Frågeminne: 0.025 MB Minne före fråga: 3.235 MB Returnerade rader: 0

SELECT * 
  FROM uadxs_sh404sef_aliases 
  WHERE state = 1 
  and (type = 1 or type = 2);

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_sh404sef_aliases	ref	type,state	state	1	const	1	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:287
15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:117
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:703
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
10	Sh404sefClassRouterInternal->preprocessParseRule()	Samma som samtal i raden nedan.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.19 ms Efter sista fråga: 0.06 ms Frågeminne: 0.023 MB Minne före fråga: 3.243 MB Returnerade rader: 0

SELECT * 
  FROM uadxs_sh404sef_pageids 
  WHERE `pageid`='personliga-historier/eric-lundmark-malarmaestare.html';

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_sh404sef_pageids	ref	alias	alias	762	const	1	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:2349
11	Sh404sefClassRouterInternal->_checkShurls()	JROOT/administrator/components/com_sh404sef/classes/router.php:296
10	Sh404sefClassRouterInternal->preprocessParseRule()	Samma som samtal i raden nedan.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.23 ms Efter sista fråga: 0.22 ms Frågeminne: 0.025 MB Minne före fråga: 3.254 MB Returnerade rader: 2

SELECT *

  FROM uadxs_languages

  WHERE published=1

  ORDER BY ordering ASC

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_languages	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	2	Using where; Använder filsortering

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
17	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/classes/router.php:2059
16	Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:2027
15	Sh404sefClassRouterInternal->_isSimpleEncodingSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1970
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1434
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2628
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:456
11	Sh404sefClassRouterInternal->parseRule()	Samma som samtal i raden nedan.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.40 ms Efter sista fråga: 0.52 ms Frågeminne: 0.025 MB Minne före fråga: 3.276 MB Returnerade rader: 1

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM uadxs_sh404sef_urls 
  WHERE `oldurl`='personliga-historier/eric-lundmark-malarmaestare.html' 
  ORDER BY `rank`;

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_sh404sef_urls	ref	oldurl	oldurl	573	const	1	Using where; Använder filsortering

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1984
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1434
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2628
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:456
11	Sh404sefClassRouterInternal->parseRule()	Samma som samtal i raden nedan.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.28 ms Efter sista fråga: 0.20 ms Frågeminne: 0.008 MB Minne före fråga: 3.287 MB

UPDATE `uadxs_sh404sef_urls` 
  SET `cpt`=1193, `last_hit`='2023-12-07 11:20:58' 
  WHERE `id`='33097' 
  AND `rank`=0;

Förklara

EXPLAIN inte möjlig i fråga: UPDATE `uadxs_sh404sef_urls` SET `cpt`=1193, `last_hit`='2023-12-07 11:20:58' WHERE `id`='33097' AND `rank`=0;

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.03 ms
Writing to binlog	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
17	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1453
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2628
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:456
11	Sh404sefClassRouterInternal->parseRule()	Samma som samtal i raden nedan.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.46 ms Efter sista fråga: 1.20 ms Frågeminne: 0.027 MB Minne före fråga: 3.375 MB Returnerade rader: 45

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `uadxs_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dmhelper','com_fields','com_finder','com_flexicontact','com_gantry','com_installer','com_jce','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_regularlabsmanager','com_rokcandy','com_roksprocket','com_search','com_sh404sef','com_slideshowck','com_tags','com_templates','com_users','com_wrapper')

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_assets	ALL	idx_asset_name	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	134	Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.13 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:97
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.23 ms Efter sista fråga: 0.49 ms Frågeminne: 0.024 MB Minne före fråga: 3.452 MB Returnerade rader: 9

SELECT * 
  FROM uadxs_rokcandy 
  WHERE published=1

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_rokcandy	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	9	Using where

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
13	RokCandyHelper::getUserMacros()	Samma som samtal i raden nedan.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.31 ms Efter sista fråga: 0.15 ms Frågeminne: 0.024 MB Minne före fråga: 3.464 MB Returnerade rader: 4

Duplikatfrågor: #48 #49 #50 #51

SELECT id, home, template, s.params

  FROM uadxs_template_styles as s

  LEFT JOIN uadxs_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

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	4000812-jansuhr7.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53
14	RokCandyHelper::readIniFile()	Samma som samtal i raden nedan.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44
10	RokCandyHelper::getTemplateOverrides()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.25 ms Efter sista fråga: 0.62 ms Frågeminne: 0.022 MB Minne före fråga: 3.514 MB Returnerade rader: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `uadxs_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Samma som samtal i raden nedan.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.24 ms Efter sista fråga: 0.10 ms Frågeminne: 0.005 MB Minne före fråga: 3.505 MB

UPDATE `uadxs_extensions`

  SET `params` = '{\"mediaversion\":\"9278830f102884d69d53bb0ef54804b8\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Förklara

EXPLAIN inte möjlig i fråga: UPDATE `uadxs_extensions` SET `params` = '{\"mediaversion\":\"9278830f102884d69d53bb0ef54804b8\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.03 ms
Writing to binlog	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.45 ms Efter sista fråga: 3.04 ms Frågeminne: 0.029 MB Minne före fråga: 3.696 MB Returnerade rader: 57

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `uadxs_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_assets	ALL	idx_asset_name,idx_parent_id	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	134	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.50 ms Efter sista fråga: 1.98 ms Frågeminne: 0.032 MB Minne före fråga: 3.765 MB Returnerade rader: 31

SHOW FULL COLUMNS 
  FROM `uadxs_content`

Förklara

EXPLAIN inte möjlig i fråga: SHOW FULL COLUMNS FROM `uadxs_content`

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.09 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.07 ms
closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.38 ms Efter sista fråga: 3.01 ms Frågeminne: 0.005 MB Minne före fråga: 3.814 MB

UPDATE uadxs_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '86'

Förklara

EXPLAIN inte möjlig i fråga: UPDATE uadxs_content SET `hits` = (`hits` + 1) WHERE `id` = '86'

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.05 ms
Writing to binlog	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.71 ms Efter sista fråga: 2.35 ms Frågeminne: 0.038 MB Minne före fråga: 3.838 MB Returnerade rader: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM uadxs_content AS a

  INNER JOIN uadxs_categories AS c 
  on c.id = a.catid

  LEFT JOIN uadxs_users AS u 
  on u.id = a.created_by

  LEFT JOIN uadxs_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN uadxs_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 86 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-07 11:20:58') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-07 11:20:58') 
  AND (a.state = 1 OR a.state =2)

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.57 ms Efter sista fråga: 3.86 ms Frågeminne: 0.027 MB Minne före fråga: 3.948 MB Returnerade rader: 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 `uadxs_categories` AS `s`

  INNER JOIN `uadxs_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 = 80

  ORDER BY c.lft

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	10 (23%)	Using index condition; Using where; Using rowid filter

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Samma som samtal i raden nedan.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.45 ms Efter sista fråga: 2.29 ms Frågeminne: 0.022 MB Minne före fråga: 4.004 MB Returnerade rader: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `uadxs_contentitem_tag_map` AS m 

  INNER JOIN `uadxs_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 86 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	4000812-jansuhr7.m.tag_id	1	Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.75 ms Efter sista fråga: 3.08 ms Frågeminne: 0.025 MB Minne före fråga: 4.124 MB Returnerade rader: 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 uadxs_fields AS a

  LEFT JOIN `uadxs_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN uadxs_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN uadxs_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN uadxs_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN uadxs_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `uadxs_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 (80,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

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Använder filsortering
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	4000812-jansuhr7.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
Creating sort index	0.02 ms
Removing tmp table	0.02 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.51 ms Efter sista fråga: 4.91 ms Frågeminne: 0.029 MB Minne före fråga: 4.171 MB Returnerade rader: 16

SHOW FULL COLUMNS 
  FROM `uadxs_users`

Förklara

EXPLAIN inte möjlig i fråga: SHOW FULL COLUMNS FROM `uadxs_users`

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.08 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.05 ms
closing tables	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
16	Joomla\CMS\User\User::getTable()	JROOT/plugins/system/sourcerer/src/Security.php:60
15	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/sourcerer.php:91
14	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
13	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.25 ms Efter sista fråga: 0.16 ms Frågeminne: 0.025 MB Minne före fråga: 4.200 MB Returnerade rader: 1

Duplikatfrågor: #42

SELECT *

  FROM `uadxs_users`

  WHERE `id` = 6

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_users	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
16	Joomla\CMS\Table\User->load()	JROOT/plugins/system/sourcerer/src/Security.php:62
15	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/sourcerer.php:91
14	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
13	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.26 ms Efter sista fråga: 0.60 ms Frågeminne: 0.024 MB Minne före fråga: 4.211 MB Returnerade rader: 1

Duplikatfrågor: #43

SELECT `g`.`id`,`g`.`title`

  FROM `uadxs_usergroups` AS g

  INNER JOIN `uadxs_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 6

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.m.group_id	1

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
16	Joomla\CMS\Table\User->load()	JROOT/plugins/system/sourcerer/src/Security.php:62
15	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/sourcerer.php:91
14	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
13	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.24 ms Efter sista fråga: 0.13 ms Frågeminne: 0.026 MB Minne före fråga: 4.221 MB Returnerade rader: 1

Duplikatfrågor: #40

SELECT *

  FROM `uadxs_users`

  WHERE `id` = 6

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_users	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
16	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/sourcerer/src/Security.php:64
15	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/sourcerer.php:91
14	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
13	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.22 ms Efter sista fråga: 0.10 ms Frågeminne: 0.026 MB Minne före fråga: 4.233 MB Returnerade rader: 1

Duplikatfrågor: #41

SELECT `g`.`id`,`g`.`title`

  FROM `uadxs_usergroups` AS g

  INNER JOIN `uadxs_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 6

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.m.group_id	1

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
16	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/sourcerer/src/Security.php:64
15	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/sourcerer.php:91
14	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
13	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.26 ms Efter sista fråga: 0.06 ms Frågeminne: 0.025 MB Minne före fråga: 4.243 MB Returnerade rader: 2

SELECT b.id

  FROM uadxs_user_usergroup_map AS map

  LEFT JOIN uadxs_usergroups AS a 
  ON a.id = map.group_id

  LEFT JOIN uadxs_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE map.user_id = 6

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	4000812-jansuhr7.map.group_id	1
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	9	Range checked for each record (index map: 0x10)

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
17	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
16	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/plugins/system/sourcerer/src/Security.php:67
15	RegularLabs\Plugin\System\Sourcerer\Security::set()	JROOT/plugins/system/sourcerer/sourcerer.php:91
14	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
13	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.46 ms Efter sista fråga: 0.85 ms Frågeminne: 0.035 MB Minne före fråga: 4.272 MB Returnerade rader: 41

SHOW FULL COLUMNS 
  FROM `uadxs_sh404sef_metas`

Förklara

EXPLAIN inte möjlig i fråga: SHOW FULL COLUMNS FROM `uadxs_sh404sef_metas`

Profil

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.08 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.08 ms
closing tables	0.00 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:138
18	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:37
16	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
15	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:515
14	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:347
13	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.29 ms Efter sista fråga: 0.11 ms Frågeminne: 0.025 MB Minne före fråga: 4.322 MB Returnerade rader: 0

SELECT * 
  FROM uadxs_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_content&Itemid=519&catid=80&id=86&lang=sv&view=article';

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uadxs_sh404sef_metas	ref	newurl	newurl	573	const	1	Using where

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
19	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
18	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
17	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:38
16	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
15	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:515
14	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:347
13	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.62 ms Efter sista fråga: 2.08 ms Frågeminne: 0.026 MB Minne före fråga: 4.381 MB Returnerade rader: 29

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM uadxs_content AS a

  LEFT JOIN uadxs_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 80 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-07 11:20:58') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-07 11:20:58')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	26	Using intersect(idx_catid,idx_state); Using where; Använder filsortering
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.49 ms Efter sista fråga: 14.68 ms Frågeminne: 0.027 MB Minne före fråga: 5.069 MB Returnerade rader: 4

Duplikatfrågor: #29 #49 #50 #51

SELECT id, home, template, s.params

  FROM uadxs_template_styles as s

  LEFT JOIN uadxs_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

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	4000812-jansuhr7.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
20	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_nuance/html/com_content/article/default.php:14
13	include JROOT/templates/rt_nuance/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.36 ms Efter sista fråga: 0.41 ms Frågeminne: 0.027 MB Minne före fråga: 5.082 MB Returnerade rader: 4

Duplikatfrågor: #29 #48 #50 #51

SELECT id, home, template, s.params

  FROM uadxs_template_styles as s

  LEFT JOIN uadxs_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

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	4000812-jansuhr7.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
21	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
20	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_nuance/html/com_content/article/default.php:14
13	include JROOT/templates/rt_nuance/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.35 ms Efter sista fråga: 0.25 ms Frågeminne: 0.027 MB Minne före fråga: 5.093 MB Returnerade rader: 4

Duplikatfrågor: #29 #48 #49 #51

SELECT id, home, template, s.params

  FROM uadxs_template_styles as s

  LEFT JOIN uadxs_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

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	4000812-jansuhr7.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
20	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_nuance/html/com_content/article/default.php:14
13	include JROOT/templates/rt_nuance/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.34 ms Efter sista fråga: 0.23 ms Frågeminne: 0.027 MB Minne före fråga: 5.104 MB Returnerade rader: 4

Duplikatfrågor: #29 #48 #49 #50

SELECT id, home, template, s.params

  FROM uadxs_template_styles as s

  LEFT JOIN uadxs_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.c

Antal personer i registret: