Open Educational Resources / Open Source Physics @ Singapore

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1777099621,
                "last": 1777099622,
                "now": 1777099622
            },
            "token": "b5v75KCI2asJNaLTVU5nVLeCrughMLTI"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "765c196b78d8ed2b16bbf8a9ed94e3e5fbbbc551",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "0068e61404adfd8e0707134d86541fc8ca899d37": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1501-world-war-ii-outbreak-factors-visualization-interactive-history-tool",
                    "expiry": 1777099621
                },
                "3af7513fb69432733e8555c0b0f5cd0801261e14": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1500-world-war-ii-causes-concept-mapping-historical-analysis-tool",
                    "expiry": 1777099621
                },
                "aa784823f931e1b299fa0ba2d5c2bec651d2a0f6": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1499-word-typing-challenge-keyboard-skills-and-speed-practice",
                    "expiry": 1777099621
                },
                "9b422e1020bca2bd961bb209cdb77228c0fd7605": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1498-vocab-speed-challenge-fast-paced-vocabulary-game",
                    "expiry": 1777099621
                },
                "6c5e1f7a2c984b063ab0d30b46a09bcc1b6d0a88": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1497-visual-lyrics-interactive-song-analysis-and-comprehension-tool",
                    "expiry": 1777099621
                },
                "765c196b78d8ed2b16bbf8a9ed94e3e5fbbbc551": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1496-virtual-synthesizer-workstation-digital-music-creation-tool",
                    "expiry": 1777099621
                },
                "e6979da4fcbd5984eb47742430c1d391ab45da90": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1493-tropical-rainforest-layers-interactive-ecosystem-exploration-tool",
                    "expiry": 1777099621
                },
                "a454256a6fac3c33feea98ad1483b89313d7f4fb": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1492-trigonometry-unit-circle-interactive-angle-and-coordinate-explorer",
                    "expiry": 1777099621
                },
                "65afd01fd5de0ffb90466a9ac9c6d482102d401f": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1491-trigonometric-functions-matching-assessment-mathematics-practice-tool",
                    "expiry": 1777099621
                },
                "ee7649fb22d16cad48fbc341fce97b0d60cd909a": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1470-permission-quest-social-skills-game-2",
                    "expiry": 1777099621
                },
                "d8fcd73c485004742e54806c3040d0199bae39b4": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1469-peribahasa-matching-game",
                    "expiry": 1777099621
                },
                "ad5265f9759dfed17f0c2b2a37108eac7a67870b": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1468-perimeter-sticker-game",
                    "expiry": 1777099621
                },
                "972b5170bf68c8dbce329474ad9ff9ea72fa118f": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1467-paper-chromatography-investigation",
                    "expiry": 1777099621
                },
                "d57e4678792f4829ed85fa53792114fcc23aa269": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1466-past-tense-verb-quiz",
                    "expiry": 1777099621
                },
                "0b6d1ec199c9cba01c0987a1e4b8ba524ab72895": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1465-past-tense-verb-shooter",
                    "expiry": 1777099621
                },
                "9e375478dd8c0889e498ce6552b80b9ebbc842c0": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1464-pedestrian-safety-explorer",
                    "expiry": 1777099621
                },
                "d4a160aabc564c8cb2b78db961cd548c75d131c5": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1463-peribahasa-interaktif",
                    "expiry": 1777099621
                },
                "1a7daebf0e69955f95b95669aee95217a1bec378": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1462-one-thousand-buckets-of-water-oral-interaction",
                    "expiry": 1777099621
                },
                "1206c9cc909167e240b49cbf5bfbc90fc752ed1b": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1461-outdoor-day-trip-essentials",
                    "expiry": 1777099621
                },
                "2bd59ecb77df8dd0a9fd5903de59ac20d272622d": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1460-natural-selection-simulation",
                    "expiry": 1777099621
                },
                "31d1fda258cf4e30737aa15ceace19594e08ff04": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1459-number-line-estimation-game",
                    "expiry": 1777099621
                },
                "678ebd50dbacb8bcc77be8e90daa7eb4344b27f2": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1435-food-web-builder-level-1",
                    "expiry": 1777099621
                },
                "0b7026d8584d0cdd37acded2796acf9956824c1b": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1434-fire-investigator-s-case",
                    "expiry": 1777099621
                },
                "8d00d269e157f53fa34425167602138fd00b6563": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1433-equivalent-fractions-memory-game",
                    "expiry": 1777099621
                },
                "21ee94ce24e3cd277abdac9c11b6c93195565382": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1198-submarine-simulation-1d-with-javascript-simulation-applet-html5",
                    "expiry": 1777099621
                },
                "f016cd23cbc186763c013100a625c2a384935e44": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1195-lol-energy-diagram-kosong-version-for-teacher-peer-discussion-javascript-simulation-applet-html5",
                    "expiry": 1777099621
                },
                "0fe6c74fbf370ce2bd89eb0ed8a749a2753a4dbf": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/1194-boost-your-math-proficiency-explore-designating-the-floors-inspired-by-an-interactive-math-textbook-work-in-progress",
                    "expiry": 1777099621
                },
                "91b91471ece5f8f35de9bb9a9e3b99b7cc397400": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/851-test-4",
                    "expiry": 1777099621
                },
                "0e07691b6c60447cc35cc5a1e9b39fc8c79a1300": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/research",
                    "expiry": 1777099621
                },
                "40b0ecb531f78b5c86d779218999a9df21680bec": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/12-troubleshooting",
                    "expiry": 1777099621
                },
                "0672516bf526a1cd5ac84490fa2217570fd8346d": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php/interactive-resources/physics/03-thermal-physics/thermodynamic-systems/04-thermal-properties-of-matter/2-uncategorised/3-about-oer-sg",
                    "expiry": 1777099621
                },
                "0bd36221c924eacd1cee61e248e642a97d0a3051": {
                    "link": "https://sg.iwant2study.org/ospsgx/index.php",
                    "expiry": 1777099621
                }
            }
        }
    }
}

Profile Information

Memory Usage

Database Queries

17 Queries Logged 10.96 ms

4 duplicate found!

2 duplicates: #6 #16

2 duplicates: #8 #9

Query Time: 0.22 ms Query memory: 0.039 MB Memory before query: 4.164 MB Rows returned: 1

SELECT `data`

  FROM `ospsg_session`

  WHERE `session_id` = X'6239303139336362353964373937643533646430303463613931356263376164'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ospsg_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 3.56 ms Query memory: 0.021 MB Memory before query: 4.853 MB Rows returned: 5

SELECT id, rules

  FROM `ospsg_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ospsg_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.865 MB Rows returned: 1

SELECT b.id

  FROM ospsg_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 20.20 ms Query memory: 0.020 MB Memory before query: 8.283 MB Rows returned: 1

SELECT count(*)

  FROM `ospsg_cwgears_schedule`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Select tables optimized away

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
8	plgSystemCwgears->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.13 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 8.289 MB Rows returned: 1

SELECT count(*)

  FROM `ospsg_cwgears_schedule`

  WHERE time + '3600'<'1777099622'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
8	plgSystemCwgears->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.72 ms After last query: 15.59 ms Query memory: 0.026 MB Memory before query: 12.114 MB Rows returned: 142

Duplicate queries: #16

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:116
10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
8	plgSystemAcymtriggers->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 0.44 ms Query memory: 0.034 MB Memory before query: 12.156 MB Rows returned: 132

SELECT * 
  FROM ospsg_acym_configuration

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ospsg_acym_configuration	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	132	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.10 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:21
14	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:37
13	acym_config()	JROOT/administrator/components/com_acym/libraries/object.php:14
12	AcyMailing\Libraries\acymObject->__construct()	JROOT/administrator/components/com_acym/classes/plugin.php:13
11	AcyMailing\Classes\PluginClass->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:76
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
8	plgSystemAcymtriggers->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 12.241 MB Rows returned: 2

Duplicate queries: #9

SELECT * 
  FROM ospsg_acym_plugin

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ospsg_acym_plugin	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:58
12	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/classes/plugin.php:20
11	AcyMailing\Classes\PluginClass->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:76
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
8	plgSystemAcymtriggers->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.12 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 12.251 MB Rows returned: 2

Duplicate queries: #8

SELECT * 
  FROM ospsg_acym_plugin

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ospsg_acym_plugin	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:58
11	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:77
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
8	plgSystemAcymtriggers->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.15 ms After last query: 3.94 ms Query memory: 0.023 MB Memory before query: 13.605 MB Rows returned: 9

SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` 
        
  FROM ospsg_usergroups AS `groups`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	groups	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/user.php:46
12	acym_getGroups()	JROOT/administrator/components/com_acym/dynamics/createuser/plugin.php:21
11	plgAcymcreateuser->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:118
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
8	plgSystemAcymtriggers->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.69 ms After last query: 8.26 ms Query memory: 0.006 MB Memory before query: 15.292 MB

UPDATE `ospsg_extensions`

  SET `params` = '{\"mediaversion\":\"b6d251136f4e9d79f23c06dcf3902c55\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `ospsg_extensions` SET `params` = '{\"mediaversion\":\"b6d251136f4e9d79f23c06dcf3902c55\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.06 ms
updating	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	4.42 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	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/cwgears/cwgears.php:200
8	plgSystemCwgears->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.55 ms After last query: 10.28 ms Query memory: 0.027 MB Memory before query: 16.813 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ospsg_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_mailto.mailto' 
  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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	iwtstudy_ospsgx.a.language	1	100.00	Using index condition
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	iwtstudy_ospsgx.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	iwtstudy_ospsgx.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	iwtstudy_ospsgx.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	iwtstudy_ospsgx.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_mailto/models/mailto.php:35
12	MailtoModelMailto->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_mailto/views/mailto/view.html.php:30
10	MailtoViewMailto->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mailto/controller.php:29
8	MailtoController->mailto()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mailto/mailto.php:16
6	require_once JROOT/components/com_mailto/mailto.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 7.60 ms Query memory: 0.022 MB Memory before query: 17.501 MB Rows returned: 0

SELECT uikit

  FROM `ospsg_cwgears`

  WHERE url = 'https://sg.iwant2study.org/ospsgx/index.php/component/mailto/?link=765c196b78d8ed2b16bbf8a9ed94e3e5fbbbc551&template=protostartina&tmpl=component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.10 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 17.508 MB Rows returned: 0

SELECT uikit_plus

  FROM `ospsg_cwgears`

  WHERE url = 'https://sg.iwant2study.org/ospsgx/index.php/component/mailto/?link=765c196b78d8ed2b16bbf8a9ed94e3e5fbbbc551&template=protostartina&tmpl=component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 0.51 ms Query memory: 0.020 MB Memory before query: 17.534 MB Rows returned: 1

SELECT `value` 
  FROM ospsg_acym_configuration 
  WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ospsg_acym_configuration	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	132	20.99	Using where

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.12 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/acymtriggers/acymtriggers.php:215
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:208
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.54 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 17.542 MB Rows returned: 142

Duplicate queries: #6

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:116
10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:258
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:208
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.46 ms After last query: 0.78 ms Query memory: 0.027 MB Memory before query: 17.649 MB Rows returned: 42

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

  FROM `ospsg_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contenttemplater','com_cpanel','com_extplorer','com_fields','com_finder','com_hitstepsanalytics','com_installer','com_ipmapping','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ospsg_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	43	100.00	Using index condition

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.25 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:49
9	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/sourcerer.php:145
8	PlgSystemSourcerer->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/SystemPlugin.php:147
7	RegularLabs\Library\SystemPlugin->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

15 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
2 × SELECT * 
  FROM ospsg_acym_plugi
```

1 × SELECT `data` 
  FROM `ospsg_session`

1 × SELECT id, rules 
  FROM `ospsg_viewlevels

1 × SELECT b.id 
  FROM ospsg_usergroups AS a 
  LEFT JOIN ospsg_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT count(*) 
  FROM `ospsg_cwgears_schedule

1 × SELECT count(*) 
  FROM `ospsg_cwgears_schedule`

1 × SELECT * 
  FROM ospsg_acym_configuratio

1 × SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`          
  FROM ospsg_usergroups AS `groups

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 ospsg_fields AS a 
  LEFT JOIN `ospsg_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ospsg_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ospsg_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ospsg_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ospsg_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT uikit 
  FROM `ospsg_cwgears`

1 × SELECT uikit_plus 
  FROM `ospsg_cwgears`

1 × SELECT `value` 
  FROM ospsg_acym_configuration

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ospsg_assets`

OTHER Tables:

```
2 × SHOW TABLE
```

1 × UPDATE `ospsg_extensions` 
  SET `params` = '{\"mediaversion\":\"b6d251136f4e9d79f23c06dcf3902c55\"}'

Email this link to a friend.

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

17 Queries Logged 10.96 ms

4 duplicate found!

15 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: