When the Digital eXperience Guardian is physically ready, then is the time for the software installation.
The DXG software installs like any other Windows software on a variety of Windows operating systems, from XP to 8.1. There are two pieces, the DXG GUI which runs the sequence files and the DXG Finder, which locates the DXG units on the networks and assists in configuring them.
Let's not go through the steps of installing a Windows program. If you are not up to that task, please ask for assistance.
Once both programs are installed, double-click on the DXG Finder. The DXG Finder will run but will not communicate much until a Digital eXperience Guardian is plugged into a network that is also attached to the computer that the program is running on. Therefore, lets go through the steps required to talk to the DXG – which are copied from the Ceiling Installation page.
The DXG is powered by a technology called Power over Ethernet (also known as PoE, with the small 'o'.) Briefly, this internationally standardized technology allows power and Ethernet signals to co-exist on a CAT-5 or CAT-6 cable, then into the RJ-45 connector of the equipment. The power is then separated and used as if they had come over separate cables.
The mixing of data and power is done at one of two places. Either there is a separate PoE Insertion device, or there is an Ethernet Switch that is PoE capable. Often these switches will only power 4 of the available ports – watch out for that. Either technique works, either technique adds yet another potential point of failure to your system, but the Ethernet Switch is the better long term solution. In either case, there is a restriction of 100 meter cable length.
In addition to the RJ-45 connector, there is a connector called a DB-9 on the rear of the DXG which is used to carry power to the colorimeter sensor, and carry the colorimeter signals back to the DXG processor located in the saucer section. This cable doesn't need to be connected in order to set up a DXG with a network – i.e., several DXG units can be configured simultaneously at the tech bench without sensors attached.
NB: When purchasing a cable with DB-9 connectors at each end (one male, one female – often called an RS-422 cable), make certain that all 9 pins are carried through with cable between them. There are some uses of this style of cable that allow manufacturers to only implement 4 or 5 connectors. These will not work.
Since these cables will be used to carry power – albeit low voltage power – please consult a local Code expert about whether you situation requires "plenum rated cable". (See: Cable-Selection-for-RS422-and-RS485-Systems)
An easy alternative to buying a pre-made RS-232 style cable is to purchase a reel of flat 'ribbon' cable and the male and female connectors for it. As you can see from this linked YouTube 'how to', it is a simple process: Flat ribbon cable assembly - YouTube
Depending on your particular setup, a message will appear that suggests that you use the Finder, and the Finder program will be automatically opened for you. In some circumstances you will need to find and open the Finder yourself.
If the Finder sees that there is more than one network to connect to, it will ask you to choose.
The DXG Finder program will show a list of available DXG units on the left side. Select one by clicking on it once. Numbers will appear in their appropriate spots, informing you of particular network information.
This is where you change the IP addresses of the DXG units. See Assigning the IP Address of the DXG below. Unless your IP network addresses are being changed from the first installation – for example, if the server or gateway computer addresses change – it is probably unnecessary to change any of the other numbers.
In the heading portion there are spaces to fill in during the first installation. Put appropriate information in them. For example, in the space marked "Name" under the word "Location", type the name of the Cinema and in the space marked "Name" (under the word "Auditorium") type the name of the auditorium. In other words, if the name of the auditorium for the serial number that matches the DXG in that room is "1", then put a "1" into that spot. If the name of the cinema is "Energia", type "Energia" into the spot.
Likewise, if the corporate room ID for the Cinema is AAA111, type that into the Location ID spot, and if the corporate ID of the particular auditorium is GreatSpace, type GreatSpace into the ID space.
It is possible to change these designations later, but it will require the work of renaming folders in a directory. Not difficult, but it is easier to do it correctly the first time.
Enclosure Angle and Flip
The DXG was designed with two mounting systems: on a tripod with the center microphone facing up (click Enclosure Flip) or mounted to the ceiling with the center microphone facing down (leave the Flip box unchecked). The computer needs to know this and also needs to know if the nose of the DXG is pointing forward toward the screen (place 180 into the Angle box), or place a 0 if it is pointing toward the projector. (One might imagine that setting up multiple screen systems will have other angles.)
Assigning the IP Address of the DXG
The DXG is natively assigned the address XXX.XXX.XXX.150, the X's based upon the system data that the Finder finds itself in. Multiple DXG systems will need to be manually assigned different IP address. We recommend that you stay with the 150 series, for example assigning Auditorium 1 the .151 address, Auditorium 2 the .152 address, on up to the highest number auditorium number, for example Auditorium 16 being xxx.xxx.xxx.166
Click "Assign" to put the information into the Configuration File
If everything looks right, click the "Assign" button.
Repeat for the rest of your DXG units.
You can do a ping to confirm that these IP addresses are really being talked to.
If there is something odd and you need to start again, try renaming the DXG.config file in C:ProgramData/DSP/DXG. This will allow you to start over again. Re-installing the GUI software will also recreate a new folder system. Therefore, this is the time to review your backup system on the local computer being used with your Digital eXperience Guardians.
As always, consult the Forum for any FAQs or hints from other installers, or call, or write.
{ "__default": { "session": { "counter": 2, "timer": { "start": 1716172560, "last": 1716172560, "now": 1716172561 }, "client": { "forwarded": "3.142.114.245" }, "token": "Fq7oswHBfkG49cHr84cYjslAMDLQB4nk" }, "registry": { "com_attachments": { "current_url": "&return=aHR0cHM6Ly93d3cuZGlnaXRhbHRlc3R0b29scy5jb20vaW5kZXgucGhwP29wdGlvbj1jb21fY29udGVudCZ2aWV3PWFydGljbGUmaWQ9MTA0OmR4Zy1pcC1zZXQtdXAmY2F0aWQ9NzkmdG1wbD1jb21wb25lbnQmcHJpbnQ9MSZsYXlvdXQ9ZGVmYXVsdCZJdGVtaWQ9NTQ3" } }, "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 } } }
SELECT `data`
FROM `xlqe2_session`
WHERE `session_id` = X'71763374677472337236706a386a737573626b3567336d6f7533'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_session | const | PRIMARY | PRIMARY | 194 | const | 1 |
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 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.01 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.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
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:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xlqe2_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_extensions | ref | extension | extension | 82 | const | 57 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.09 ms |
Preparing | 0.04 ms |
Executing | 0.00 ms |
Sending data | 0.36 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.01 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.01 ms |
# | Caller | File and line number |
---|---|---|
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}() | Same as call in the line below. |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `xlqe2_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.07 ms |
End of update loop | 0.01 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.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
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:318 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM xlqe2_usergroups AS a
LEFT JOIN xlqe2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
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 | 1 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.03 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.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
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:318 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM xlqe2_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 342 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.80 ms |
End of update loop | 0.01 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.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
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:356 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
DELETE
FROM `xlqe2_mi_iptable`
WHERE DATE_ADD(`lasthacktime`, INTERVAL 300 SECOND) < NOW()
AND `autodelete`=1;
Status | Duration |
---|---|
Starting | 0.26 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
init for update | 0.01 ms |
init | 0.04 ms |
Deleting from main table | 0.01 ms |
init | 0.00 ms |
System lock | 0.01 ms |
table lock | 0.00 ms |
init | 0.00 ms |
init for update | 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.01 ms |
Waiting for query cache lock | 0.00 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:44 |
8 | plgSystemMarcosinterceptor->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:668 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
from `xlqe2_mi_iptable`
WHERE ip = 2890205098
AND `hackcount` >= 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.03 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.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.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:51 |
8 | plgSystemMarcosinterceptor->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:668 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT COUNT(*)
from `xlqe2_mi_iptable`
WHERE ip = 2890205098
AND `hackcount` >= 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.02 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.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:52 |
8 | plgSystemMarcosinterceptor->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:668 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 xlqe2_menu AS m
LEFT JOIN xlqe2_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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 234 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | dtt1.m.component_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.17 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.12 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.69 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xlqe2_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.15 ms |
Preparing | 0.04 ms |
Executing | 0.00 ms |
Sending data | 0.08 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.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jatypo/jatypo.php:55 |
8 | plgSystemJATypo->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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `xlqe2_extensions`
SET `params` = '{\"mediaversion\":\"126359ede73cf48384e002c193c8908b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
checking permissions | 0.00 ms |
After opening tables | 0.00 ms |
init for update | 0.01 ms |
init | 0.02 ms |
Updating main table | 0.01 ms |
init | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.00 ms |
init for update | 0.10 ms |
Updating | 0.06 ms |
End of update loop | 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.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jatypo/jatypo.php:55 |
8 | plgSystemJATypo->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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM xlqe2_template_styles as s
LEFT JOIN xlqe2_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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | dtt1.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.15 ms |
Preparing | 0.05 ms |
Executing | 0.00 ms |
Sending data | 0.12 ms |
End of update loop | 0.01 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.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
19 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
18 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
17 | Joomla\CMS\HTML\HTMLHelper::script() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/behavior.php:63 |
13 | JHtmlBehavior::framework() | JROOT/libraries/cms/html/behavior.php:60 |
12 | JHtmlBehavior::framework() | Same as call in the line below. |
11 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
10 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
9 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/plugins/system/jatypo/jatypo.php:61 |
8 | plgSystemJATypo->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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM xlqe2_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.07 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
12 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
11 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:248 |
10 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:244 |
9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:390 |
8 | plgSystemK2->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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xlqe2_modules AS m
LEFT JOIN xlqe2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xlqe2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-20 02:36:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 02:36:01')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 547 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | PRIMARY,published,newsfeeds | NO INDEX KEY COULD BE USED | NULL | NULL | 142 | Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | dtt1.m.module,const | 1 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | dtt1.m.id | 2 | Using where |
Status | Duration |
---|---|
Starting | 0.20 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.09 ms |
Optimizing | 0.07 ms |
Statistics | 0.13 ms |
Preparing | 0.07 ms |
Sorting result | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.99 ms |
End of update loop | 0.02 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.02 ms |
Updating status | 0.07 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
17 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
16 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
15 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
14 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/jat3/jat3/core/template.php:1213 |
13 | T3Template->countModules() | JROOT/plugins/system/jat3/jat3/core/template.php:710 |
12 | T3Template->hasBlock() | JROOT/plugins/system/jat3/jat3/core/template.php:1081 |
11 | T3Template->parseLayout() | JROOT/plugins/system/jat3/jat3/core/template.php:727 |
10 | T3Template->loadLayout() | JROOT/plugins/system/jat3/jat3/core/framework.php:153 |
9 | T3Framework::init_layout() | JROOT/plugins/system/jat3/jat3.php:276 |
8 | plgSystemJAT3->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:1190 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `xlqe2_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_form','com_installer','com_issuetracker','com_jaextmanager','com_jce','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osefileman','com_pfcomments','com_pfforum','com_pfmilestones','com_pfprojects','com_pfrepo','com_pftasks','com_pftime','com_pfusers','com_plugins','com_postinstall','com_privacy','com_projectfork','com_redirect','com_search','com_spambotcheck','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_assets | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 270 | Using where |
Status | Duration |
---|---|
Starting | 0.15 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.08 ms |
Optimizing | 0.02 ms |
Statistics | 0.15 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.38 ms |
End of update loop | 0.01 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.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
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:457 |
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:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `xlqe2_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 270 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.01 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.10 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.36 ms |
End of update loop | 0.01 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.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
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:457 |
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:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `xlqe2_content`
Status | Duration |
---|---|
Starting | 0.09 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.42 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
table lock | 0.05 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.07 ms |
After opening tables | 0.01 ms |
checking permissions | 0.18 ms |
closing tables | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.08 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.17 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.00 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
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:328 |
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:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE xlqe2_content
SET `hits` = (`hits` + 1)
WHERE `id` = '104'
Status | Duration |
---|---|
Starting | 0.18 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
checking permissions | 0.00 ms |
After opening tables | 0.01 ms |
init for update | 0.01 ms |
init | 0.04 ms |
Updating main table | 0.02 ms |
init | 0.01 ms |
System lock | 0.00 ms |
table lock | 0.00 ms |
init | 0.01 ms |
init for update | 0.07 ms |
Updating | 0.19 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
End of update loop | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.73 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
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:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 xlqe2_content AS a
INNER JOIN xlqe2_categories AS c
on c.id = a.catid
LEFT JOIN xlqe2_users AS u
on u.id = a.created_by
LEFT JOIN xlqe2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN xlqe2_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 104
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-20 02:36:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-20 02:36:01')
AND (a.state = 1 OR a.state =2)
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 | Unique row not found |
1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | v | const | PRIMARY | PRIMARY | 4 | const | 1 | Unique row not found |
Status | Duration |
---|---|
Starting | 0.25 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.12 ms |
Optimizing | 0.08 ms |
Statistics | 0.27 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.00 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.07 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
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/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348 |
11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `xlqe2_categories` AS `s`
INNER JOIN `xlqe2_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)
AND c.published = 1
AND s.id = 79
ORDER BY c.lft
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 | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 71 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.24 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.12 ms |
Optimizing | 0.08 ms |
Statistics | 0.20 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.00 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.24 ms |
End of update loop | 0.01 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.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
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() | Same as call in the line below. |
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:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `xlqe2_contentitem_tag_map` AS m
INNER JOIN `xlqe2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 104
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ref | PRIMARY,tag_idx,idx_access | tag_idx | 5 | const,const | 1 | |
1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | dtt1.t.id | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.14 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 0.12 ms |
Preparing | 0.05 ms |
Executing | 0.00 ms |
Sending data | 0.12 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.06 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
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:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 xlqe2_fields AS a
LEFT JOIN `xlqe2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xlqe2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xlqe2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xlqe2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xlqe2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `xlqe2_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 (79,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
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; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | dtt1.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | dtt1.a.checked_out | 1 | |
1 | SIMPLE | ag | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | dtt1.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | dtt1.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | dtt1.a.id | 1 | Using where; Distinct |
Status | Duration |
---|---|
Starting | 0.22 ms |
checking permissions | 0.03 ms |
Opening tables | 0.12 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.09 ms |
Optimizing | 0.05 ms |
Statistics | 0.28 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.09 ms |
Sorting result | 0.02 ms |
Executing | 0.00 ms |
Sending data | 0.43 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.07 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.11 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
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:194 |
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:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT created_by, catid
FROM xlqe2_content
WHERE id = 104
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | xlqe2_content | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.00 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.00 ms |
Sending data | 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.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809 |
14 | AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() | JROOT/plugins/content/attachments/attachments.php:319 |
13 | plgContentAttachments->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:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.*, u.name as creator_name
FROM xlqe2_attachments AS a
LEFT JOIN xlqe2_users AS u
ON u.id = a.created_by
WHERE a.parent_id=104
AND a.state = 1
AND a.parent_type='com_content'
AND a.parent_entity='article'
AND a.access IN (1)
ORDER BY filename
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | Using where; Using filesort |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | dtt1.a.created_by | 1 |
Status | Duration |
---|---|
Starting | 0.15 ms |
checking permissions | 0.01 ms |
Opening tables | 0.15 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.01 ms |
init | 0.10 ms |
Optimizing | 0.05 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.07 ms |
End of update loop | 0.01 ms |
Query end | 0.00 ms |
Commit | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.00 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_attachments/models/attachments.php:436 |
17 | AttachmentsModelAttachments->getAttachmentsList() | JROOT/components/com_attachments/models/attachments.php:514 |
16 | AttachmentsModelAttachments->someVisible() | JROOT/components/com_attachments/controllers/attachments.php:98 |
15 | AttachmentsControllerAttachments->displayString() | JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911 |
14 | AttachmentsPlugin->insertAttachmentsList() | JROOT/plugins/content/attachments/attachments.php:325 |
13 | plgContentAttachments->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:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
DELETE
FROM `xlqe2_session`
WHERE `time` < 1716154561
Status | Duration |
---|---|
Starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
init for update | 0.01 ms |
init | 0.03 ms |
Deleting from main table | 0.00 ms |
init | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.00 ms |
init | 0.01 ms |
init for update | 0.06 ms |
Updating | 0.22 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
End of update loop | 0.02 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
Commit | 0.34 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/session/storage/database.php:156 |
7 | JSessionStorageDatabase->gc() | JROOT/libraries/src/Session/Session.php:837 |
6 | Joomla\CMS\Session\Session->gc() | JROOT/plugins/system/sessiongc/sessiongc.php:60 |
5 | PlgSystemSessionGc->onAfterRespond() | JROOT/libraries/joomla/event/event.php:70 |
4 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
3 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
2 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:247 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xlqe2_extensions`
2 × SELECT COUNT(*)
from `xlqe2_mi_iptable`
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `xlqe2_assets`
1 × SELECT `data`
FROM `xlqe2_session`
1 × SELECT id, rules
FROM `xlqe2_viewlevels
1 × SELECT b.id
FROM xlqe2_usergroups AS a
LEFT JOIN xlqe2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM xlqe2_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM xlqe2_menu AS m
LEFT JOIN xlqe2_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params
FROM xlqe2_template_styles as s
LEFT JOIN xlqe2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM xlqe2_languages
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xlqe2_modules AS m
LEFT JOIN xlqe2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xlqe2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
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 xlqe2_content AS a
INNER JOIN xlqe2_categories AS c
on c.id = a.catid
LEFT JOIN xlqe2_users AS u
on u.id = a.created_by
LEFT JOIN xlqe2_categories as parent
ON parent.id = c.parent_id
LEFT JOIN xlqe2_content_rating AS v
ON a.id = v.content_id
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `xlqe2_categories` AS `s`
INNER JOIN `xlqe2_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
1 × SELECT `m`.`tag_id`,`t`.*
FROM `xlqe2_contentitem_tag_map` AS m
INNER JOIN `xlqe2_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM xlqe2_fields AS a
LEFT JOIN `xlqe2_languages` AS l
ON l.lang_code = a.language
LEFT JOIN xlqe2_users AS uc
ON uc.id=a.checked_out
LEFT JOIN xlqe2_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN xlqe2_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN xlqe2_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `xlqe2_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT created_by, catid
FROM xlqe2_content
1 × SELECT a.*, u.name as creator_name
FROM xlqe2_attachments AS a
LEFT JOIN xlqe2_users AS u
ON u.id = a.created_by
1 × DELETE
FROM `xlqe2_mi_iptable`
1 × UPDATE `xlqe2_extensions`
SET `params` = '{\"mediaversion\":\"126359ede73cf48384e002c193c8908b\"}'
1 × SHOW FULL COLUMNS
FROM `xlqe2_content
1 × UPDATE xlqe2_content
SET `hits` = (`hits` + 1)
1 × DELETE
FROM `xlqe2_session`