Pete Mesley's Dive Excursions & Training

Lust4Rust

Taking you to the worlds best Wreck Diving Locations with full technical and medical support.

Shock&Awe

Be prepared to witness some of the best Big Animal diving around. You will be in Shock&Awe!.

Dive Training

If you want to enhance your training and skills why not do it with someone who leads by doing!

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 1.31 ms / 1.31 ms Memory: 0.579 MB / 0.91 MB Application: afterLoad

Time: 15.78 ms / 17.09 ms Memory: 0.843 MB / 1.75 MB Application: afterInitialise

Time: 17.08 ms / 34.17 ms Memory: 0.272 MB / 2.03 MB Application: afterRoute

Time: 4.79 ms / 38.96 ms Memory: 0.083 MB / 2.11 MB Application: beforeRenderComponent com_content

Time: 346.16 ms / 385.13 ms Memory: 6.089 MB / 8.20 MB Application: afterRenderComponent com_content

Time: 0.54 ms / 385.67 ms Memory: 0.005 MB / 8.20 MB Application: afterDispatch

Time: 29.99 ms / 415.66 ms Memory: 0.066 MB / 8.27 MB Application: beforeRenderModule mod_custom (Footer)

Time: 1.80 ms / 417.46 ms Memory: 0.012 MB / 8.28 MB Application: afterRenderModule mod_custom (Footer)

Time: 0.05 ms / 417.51 ms Memory: 0.000 MB / 8.28 MB Application: beforeRenderModule mod_custom (Bottom)

Time: 0.10 ms / 417.61 ms Memory: 0.004 MB / 8.28 MB Application: afterRenderModule mod_custom (Bottom)

Time: 0.10 ms / 417.71 ms Memory: 0.000 MB / 8.28 MB Application: beforeRenderModule mod_custom (Home Page Boxes)

Time: 0.08 ms / 417.80 ms Memory: 0.003 MB / 8.29 MB Application: afterRenderModule mod_custom (Home Page Boxes)

Time: 0.06 ms / 417.85 ms Memory: 0.000 MB / 8.29 MB Application: beforeRenderModule mod_custom (Slideshow Home)

Time: 0.09 ms / 417.94 ms Memory: 0.003 MB / 8.29 MB Application: afterRenderModule mod_custom (Slideshow Home)

Time: 0.07 ms / 418.01 ms Memory: 0.000 MB / 8.29 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 4.59 ms / 422.60 ms Memory: 0.063 MB / 8.35 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.09 ms / 422.69 ms Memory: 0.000 MB / 8.35 MB Application: beforeRenderModule mod_custom (Top Bar)

Time: 0.08 ms / 422.77 ms Memory: 0.004 MB / 8.35 MB Application: afterRenderModule mod_custom (Top Bar)

Time: 0.06 ms / 422.83 ms Memory: 0.000 MB / 8.35 MB Application: beforeRenderModule mod_menu (Main Menu - mobile)

Time: 1.08 ms / 423.91 ms Memory: 0.006 MB / 8.36 MB Application: afterRenderModule mod_menu (Main Menu - mobile)

Time: 3.01 ms / 426.92 ms Memory: 0.048 MB / 8.41 MB Application: afterRender

Database queries total: 106.37 ms

Memory Usage

Database Queries

220 Queries Logged 106.37 ms

200 duplicate found!

2 duplicates: #14 #15

46 duplicates: #16 #17 #36 #37 #48 #49 #58 #59 #62 #63 #68 #69 #76 #77 #82 #83 #86 #87 #90 #91 #100 #101 #106 #107 #110 #111 #114 #115 #120 #121 #128 #129 #140 #141 #155 #156 #173 #174 #185 #186 #195 #196 #203 #204 #210 #211

46 duplicates: #18 #19 #38 #39 #50 #51 #60 #61 #64 #65 #70 #71 #78 #79 #84 #85 #88 #89 #92 #93 #102 #103 #108 #109 #112 #113 #116 #117 #122 #123 #130 #131 #142 #143 #157 #158 #175 #176 #187 #188 #197 #198 #205 #206 #212 #213

106 duplicates: #20 #21 #22 #23 #25 #26 #27 #28 #29 #30 #31 #32 #33 #34 #40 #41 #42 #43 #44 #45 #46 #47 #52 #53 #54 #55 #56 #57 #66 #67 #72 #73 #74 #75 #80 #81 #94 #95 #96 #97 #98 #99 #104 #105 #118 #119 #124 #125 #126 #127 #132 #133 #134 #135 #136 #137 #138 #139 #144 #145 #146 #147 #148 #149 #150 #151 #152 #153 #159 #160 #161 #162 #163 #164 #165 #166 #167 #168 #169 #170 #171 #172 #177 #178 #179 #180 #181 #182 #183 #184 #189 #190 #191 #192 #193 #194 #199 #200 #201 #202 #207 #208 #214 #215 #216 #217

Query Time: 0.49 ms Query memory: 0.005 MB Memory before query: 1.237 MB Rows returned: 0

SELECT `session_id`

  FROM `pete_session`

  WHERE `session_id` = 'c5fc92532e4e2c02913716cb8336b8d8' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.85 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 1.243 MB

INSERT INTO `pete_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('c5fc92532e4e2c02913716cb8336b8d8', 1, 1556186533, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `pete_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('c5fc92532e4e2c02913716cb8336b8d8', 1, 1556186533, 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 1.07 ms After last query: 0.32 ms Query memory: 0.006 MB Memory before query: 1.278 MB Rows returned: 37

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

  FROM `pete_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_extensions	ref	extension	extension	82	const	38	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:196
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.59 ms After last query: 0.33 ms Query memory: 0.005 MB Memory before query: 1.308 MB Rows returned: 5

SELECT id, rules

  FROM `pete_viewlevels`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.68 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 1.321 MB Rows returned: 2

SELECT b.id

  FROM pete_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 1.69 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 1.343 MB Rows returned: 83

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

  FROM pete_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_extensions	ref	extension	extension	82	const	102	100.00	Using index condition; Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
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:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.22 ms After last query: 4.26 ms Query memory: 0.009 MB Memory before query: 1.845 MB Rows returned: 11

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

  LEFT JOIN pete_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	11	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	deepmedi_petemes.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:76
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:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
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:64
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:491
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:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 15.78 ms Query memory: 0.007 MB Memory before query: 2.044 MB Rows returned: 1

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

  FROM `pete_extensions`

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 0.14 ms Query memory: 0.005 MB Memory before query: 2.036 MB

UPDATE `pete_extensions`

  SET `params` = '{\"mediaversion\":\"7e3f9b668a08bd29ae89847031a13663\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

Query Time: 0.78 ms After last query: 0.37 ms Query memory: 0.003 MB Memory before query: 2.073 MB Rows returned: 1

SELECT *

  FROM pete_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.23 ms Query memory: 0.003 MB Memory before query: 2.091 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM pete_template_styles as s

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

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	deepmedi_petemes.s.template,const	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.27 ms After last query: 15.62 ms Query memory: 0.007 MB Memory before query: 2.327 MB Rows returned: 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,(
SELECT COUNT(i.`id`)

  FROM `pete_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `pete_categories` AS `s`

  INNER JOIN `pete_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 8

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	51	88.24	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	deepmedi_petemes.c.id	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
12	ContentModelCategories->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoriesView.php:56
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.64 ms After last query: 12.27 ms Query memory: 0.013 MB Memory before query: 3.090 MB Rows returned: 31

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 `pete_categories` AS `s`

  INNER JOIN `pete_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 9

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	38	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
25	ContentRouter->getCategorySegment()	Same as call in the line below.
24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
16	Joomla\CMS\Router\Route::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:28
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 19.06 ms Query memory: 0.013 MB Memory before query: 3.605 MB Rows returned: 38

Duplicate queries: #15

select widget_name,widget_group 
  from pete_yeeditor_extensions 
  where published=1 
  order by widget_name asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	38	100.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
25	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/map.php:1012
24	require_once JROOT/plugins/editors/yeeditor/include/map.php	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:14
23	require_once JROOT/plugins/editors/yeeditor/include/functions_frontend.php	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:30
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.05 ms Query memory: 0.013 MB Memory before query: 3.618 MB Rows returned: 38

Duplicate queries: #14

select widget_name,widget_group 
  from pete_yeeditor_extensions 
  where published=1 
  order by widget_name asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	38	100.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/map.php:1016
24	require_once JROOT/plugins/editors/yeeditor/include/map.php	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:14
23	require_once JROOT/plugins/editors/yeeditor/include/functions_frontend.php	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:30
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 46.22 ms Query memory: 0.013 MB Memory before query: 4.092 MB Rows returned: 1

Duplicate queries: #17 #36 #37 #48 #49 #58 #59 #62 #63 #68 #69 #76 #77 #82 #83 #86 #87 #90 #91 #100 #101 #106 #107 #110 #111 #114 #115 #120 #121 #128 #129 #140 #141 #155 #156 #173 #174 #185 #186 #195 #196 #203 #204 #210 #211

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_load_font_awesome"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
27	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:588
25	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.05 ms Query memory: 0.014 MB Memory before query: 4.107 MB Rows returned: 1

Duplicate queries: #16 #36 #37 #48 #49 #58 #59 #62 #63 #68 #69 #76 #77 #82 #83 #86 #87 #90 #91 #100 #101 #106 #107 #110 #111 #114 #115 #120 #121 #128 #129 #140 #141 #155 #156 #173 #174 #185 #186 #195 #196 #203 #204 #210 #211

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_load_font_awesome"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
27	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:588
25	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.07 ms Query memory: 0.013 MB Memory before query: 4.121 MB Rows returned: 1

Duplicate queries: #19 #38 #39 #50 #51 #60 #61 #64 #65 #70 #71 #78 #79 #84 #85 #88 #89 #92 #93 #102 #103 #108 #109 #112 #113 #116 #117 #122 #123 #130 #131 #142 #143 #157 #158 #175 #176 #187 #188 #197 #198 #205 #206 #212 #213

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_load_cbootstrap3"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
27	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:589
25	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.05 ms Query memory: 0.013 MB Memory before query: 4.134 MB Rows returned: 1

Duplicate queries: #18 #38 #39 #50 #51 #60 #61 #64 #65 #70 #71 #78 #79 #84 #85 #88 #89 #92 #93 #102 #103 #108 #109 #112 #113 #116 #117 #122 #123 #130 #131 #142 #143 #157 #158 #175 #176 #187 #188 #197 #198 #205 #206 #212 #213

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_load_cbootstrap3"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
27	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:589
25	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 19.15 ms Query memory: 0.013 MB Memory before query: 4.208 MB Rows returned: 1

Duplicate queries: #21 #22 #23 #25 #26 #27 #28 #29 #30 #31 #32 #33 #34 #40 #41 #42 #43 #44 #45 #46 #47 #52 #53 #54 #55 #56 #57 #66 #67 #72 #73 #74 #75 #80 #81 #94 #95 #96 #97 #98 #99 #104 #105 #118 #119 #124 #125 #126 #127 #132 #133 #134 #135 #136 #137 #138 #139 #144 #145 #146 #147 #148 #149 #150 #151 #152 #153 #159 #160 #161 #162 #163 #164 #165 #166 #167 #168 #169 #170 #171 #172 #177 #178 #179 #180 #181 #182 #183 #184 #189 #190 #191 #192 #193 #194 #199 #200 #201 #202 #207 #208 #214 #215 #216 #217

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_imageglobalsizedefine"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
28	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
27	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
26	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
25	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.05 ms Query memory: 0.013 MB Memory before query: 4.221 MB Rows returned: 1

Duplicate queries: #20 #22 #23 #25 #26 #27 #28 #29 #30 #31 #32 #33 #34 #40 #41 #42 #43 #44 #45 #46 #47 #52 #53 #54 #55 #56 #57 #66 #67 #72 #73 #74 #75 #80 #81 #94 #95 #96 #97 #98 #99 #104 #105 #118 #119 #124 #125 #126 #127 #132 #133 #134 #135 #136 #137 #138 #139 #144 #145 #146 #147 #148 #149 #150 #151 #152 #153 #159 #160 #161 #162 #163 #164 #165 #166 #167 #168 #169 #170 #171 #172 #177 #178 #179 #180 #181 #182 #183 #184 #189 #190 #191 #192 #193 #194 #199 #200 #201 #202 #207 #208 #214 #215 #216 #217

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_imageglobalsizedefine"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
27	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
26	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
25	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 1.21 ms Query memory: 0.013 MB Memory before query: 4.234 MB Rows returned: 1

Duplicate queries: #20 #21 #23 #25 #26 #27 #28 #29 #30 #31 #32 #33 #34 #40 #41 #42 #43 #44 #45 #46 #47 #52 #53 #54 #55 #56 #57 #66 #67 #72 #73 #74 #75 #80 #81 #94 #95 #96 #97 #98 #99 #104 #105 #118 #119 #124 #125 #126 #127 #132 #133 #134 #135 #136 #137 #138 #139 #144 #145 #146 #147 #148 #149 #150 #151 #152 #153 #159 #160 #161 #162 #163 #164 #165 #166 #167 #168 #169 #170 #171 #172 #177 #178 #179 #180 #181 #182 #183 #184 #189 #190 #191 #192 #193 #194 #199 #200 #201 #202 #207 #208 #214 #215 #216 #217

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_imageglobalsizedefine"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
28	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
27	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
26	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
25	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.05 ms Query memory: 0.013 MB Memory before query: 4.248 MB Rows returned: 1

Duplicate queries: #20 #21 #22 #25 #26 #27 #28 #29 #30 #31 #32 #33 #34 #40 #41 #42 #43 #44 #45 #46 #47 #52 #53 #54 #55 #56 #57 #66 #67 #72 #73 #74 #75 #80 #81 #94 #95 #96 #97 #98 #99 #104 #105 #118 #119 #124 #125 #126 #127 #132 #133 #134 #135 #136 #137 #138 #139 #144 #145 #146 #147 #148 #149 #150 #151 #152 #153 #159 #160 #161 #162 #163 #164 #165 #166 #167 #168 #169 #170 #171 #172 #177 #178 #179 #180 #181 #182 #183 #184 #189 #190 #191 #192 #193 #194 #199 #200 #201 #202 #207 #208 #214 #215 #216 #217

SELECT option_value 
  from pete_yeeditor_option 
  WHERE option_name="yeeditor_imageglobalsizedefine"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pete_yeeditor_option	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
27	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
26	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
25	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.80 ms After last query: 23.46 ms Query memory: 0.016 MB Memory before query: 4.287 MB Rows returned: 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 `pete_categories` AS `s`

  INNER JOIN `pete_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 8

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	51	88.24	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
31	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
30	Joomla\CMS\Categories\Categories->get()	JROOT/templates/petemesley/helpers/data_helper.php:71
29	ZTplHelper::getCurrentCategory()	JROOT/components/com_yeeditor/widgets_ex/wgt_upcomming_trips/frontend/default/html/wgt_upcomming_trips.php:23
28	include JROOT/components/com_yeeditor/widgets_ex/wgt_upcomming_trips/frontend/default/html/wgt_upcomming_trips.php	JROOT/plugins/editors/yeeditor/include/functions.php:318
27	get_element_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:292
26	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
25	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
24	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
23	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
22	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
19	JHtmlContent::prepare()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/petemesley/html/com_content/categories/default_items.php:47
15	include JROOT/templates/petemesley/html/com_content/categories/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/petemesley/html/com_content/categories/default.php:29
13	include JROOT/templates/petemesley/html/com_content/categories/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
10	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 2.41 ms Query memory: 0.013 MB Memory before query: 4.923 MB Rows returned: 1