Testimonies

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1590746130,
                "last": 1590746130,
                "now": 1590746130
            },
            "token": "rtN56oBUCrIGEmECVLjc7DkWUqSB8dQQ"
        },
        "registry": {
            "com_preachit": {
                "studylist": {
                    "ordercol": null
                }
            }
        },
        "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: 9.16 ms / 9.16 ms Memory: 0.582 MB / 0.91 MB Application: afterLoad

Time: 35.71 ms / 44.88 ms Memory: 0.965 MB / 1.88 MB Application: afterInitialise

Time: 12.32 ms / 57.19 ms Memory: 0.299 MB / 2.18 MB Application: Before Access::preloadComponents (all components)

Time: 1.28 ms / 58.47 ms Memory: 0.067 MB / 2.24 MB Application: After Access::preloadComponents (all components)

Time: 0.06 ms / 58.52 ms Memory: 0.000 MB / 2.24 MB Application: Before Access::getAssetRules (id:108 name:com_rantispam)

Time: 0.52 ms / 59.05 ms Memory: 0.009 MB / 2.25 MB Application: After Access::getAssetRules (id:108 name:com_rantispam)

Time: 0.56 ms / 59.61 ms Memory: 0.003 MB / 2.25 MB Application: afterRoute

Time: 4.83 ms / 64.44 ms Memory: 0.146 MB / 2.40 MB Application: beforeRenderComponent com_preachit

Time: 33.79 ms / 98.23 ms Memory: 0.684 MB / 3.08 MB Application: Before Access::getAssetRules (id:109 name:com_preachit)

Time: 0.07 ms / 98.30 ms Memory: 0.007 MB / 3.09 MB Application: After Access::getAssetRules (id:109 name:com_preachit)

Time: 51.23 ms / 149.53 ms Memory: 1.013 MB / 4.10 MB Application: afterRenderComponent com_preachit

Time: 1.25 ms / 150.78 ms Memory: 0.009 MB / 4.11 MB Application: afterDispatch

Time: 22.29 ms / 173.07 ms Memory: 0.240 MB / 4.35 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Time: 0.48 ms / 173.55 ms Memory: 0.025 MB / 4.38 MB Application: beforeRenderModule mod_login (Login)

Time: 4.44 ms / 177.99 ms Memory: 0.042 MB / 4.42 MB Application: afterRenderModule mod_login (Login)

Time: 0.04 ms / 178.03 ms Memory: 0.000 MB / 4.42 MB Application: beforeRenderModule mod_s5_register (Register)

Time: 6.35 ms / 184.38 ms Memory: 0.185 MB / 4.60 MB Application: afterRenderModule mod_s5_register (Register)

Time: 0.57 ms / 184.95 ms Memory: 0.000 MB / 4.59 MB Application: afterRenderModule mod_s5_box (S5 Box)

Time: 0.14 ms / 185.08 ms Memory: 0.008 MB / 4.60 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Time: 4.89 ms / 189.97 ms Memory: 0.101 MB / 4.70 MB Application: afterRenderModule mod_menu (Bottom Menu)

Time: 0.09 ms / 190.06 ms Memory: 0.000 MB / 4.70 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.63 ms / 190.69 ms Memory: 0.011 MB / 4.71 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.24 ms / 190.93 ms Memory: 0.000 MB / 4.71 MB Application: beforeRenderModule mod_custom (Information)

Time: 2.26 ms / 193.20 ms Memory: 0.032 MB / 4.74 MB Application: afterRenderModule mod_custom (Information)

Time: 0.07 ms / 193.27 ms Memory: 0.000 MB / 4.74 MB Application: beforeRenderModule mod_articles_latest (Latest News)

Time: 1.07 ms / 194.34 ms Memory: 0.099 MB / 4.84 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.07 ms / 194.41 ms Memory: 0.007 MB / 4.84 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 6.87 ms / 201.28 ms Memory: 0.198 MB / 5.04 MB Application: afterRenderModule mod_articles_latest (Latest News)

Time: 0.16 ms / 201.43 ms Memory: 0.000 MB / 4.90 MB Application: beforeRenderModule mod_menu (Quick Menu)

Time: 1.13 ms / 202.57 ms Memory: 0.033 MB / 4.94 MB Application: afterRenderModule mod_menu (Quick Menu)

Time: 0.09 ms / 202.66 ms Memory: 0.001 MB / 4.94 MB Application: beforeRenderModule mod_s5_accordion_menu (S5 Accordion Menu)

Time: 1.48 ms / 204.14 ms Memory: 0.012 MB / 4.95 MB Application: afterRenderModule mod_s5_accordion_menu (S5 Accordion Menu)

Time: 0.07 ms / 204.21 ms Memory: 0.000 MB / 4.95 MB Application: beforeRenderModule mod_search (Search)

Time: 0.64 ms / 204.85 ms Memory: 0.011 MB / 4.96 MB Application: afterRenderModule mod_search (Search)

Time: 0.06 ms / 204.91 ms Memory: 0.000 MB / 4.96 MB Application: beforeRenderModule mod_menu (Top Menu)

Time: 0.17 ms / 205.08 ms Memory: 0.003 MB / 4.96 MB Application: afterRenderModule mod_menu (Top Menu)

Time: 0.03 ms / 205.11 ms Memory: 0.000 MB / 4.96 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 1.29 ms / 206.40 ms Memory: 0.009 MB / 4.97 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 3.18 ms / 209.57 ms Memory: 0.185 MB / 5.15 MB Application: afterRender

Database queries total: 51.05 ms

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

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

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

EXPLAIN not possible on query: INSERT INTO `ms1wm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'666366683533376a3962323233316f393639366c6d64666f6c36', 1, 1590746130, 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: 0.64 ms After last query: 2.28 ms Query memory: 0.008 MB Memory before query: 1.296 MB Rows returned: 39

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

  FROM `ms1wm_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	ms1wm_extensions	ref	extension	extension	82	const	39	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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.30 ms After last query: 1.98 ms Query memory: 0.007 MB Memory before query: 1.331 MB Rows returned: 3

SELECT id, rules

  FROM `ms1wm_viewlevels`

Explain

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

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:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.46 ms Query memory: 0.007 MB Memory before query: 1.345 MB Rows returned: 1

SELECT b.id

  FROM ms1wm_usergroups AS a

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

  WHERE a.id = 1

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	NULL
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	22.22	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:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 0.61 ms Query memory: 0.007 MB Memory before query: 1.369 MB Rows returned: 88

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

  FROM ms1wm_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_extensions	ref	extension	extension	82	const	119	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:1701
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.63 ms After last query: 15.68 ms Query memory: 0.012 MB Memory before query: 1.906 MB Rows returned: 31

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM ms1wm_menu AS m

  LEFT JOIN ms1wm_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	133	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	lotwmini_lotwministries.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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php: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: 0.40 ms After last query: 8.45 ms Query memory: 0.008 MB Memory before query: 2.168 MB Rows returned: 1

SELECT COUNT(*) 
  FROM ms1wm_rantispam_banip 
  WHERE bannedip = '18.204.227.117'

Explain

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

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:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/rantispam/rantispam.php:87
9	plgSystemRAntiSpam->checkBanned()	JROOT/plugins/system/rantispam/rantispam.php:121
8	plgSystemRAntiSpam->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 0.36 ms Query memory: 0.010 MB Memory before query: 2.183 MB Rows returned: 39

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

  FROM `ms1wm_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	155	25.81	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: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/rantispam/rantispam.php:110
9	plgSystemRAntiSpam->canSubmitAnything()	JROOT/plugins/system/rantispam/rantispam.php:123
8	plgSystemRAntiSpam->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 1.79 ms Query memory: 0.009 MB Memory before query: 2.272 MB Rows returned: 1

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

  FROM `ms1wm_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_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:1662
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:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.27 ms Query memory: 0.007 MB Memory before query: 2.265 MB

UPDATE `ms1wm_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	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:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 1.59 ms Query memory: 0.005 MB Memory before query: 2.380 MB Rows returned: 1

SELECT *

  FROM ms1wm_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	ms1wm_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:1701
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.53 ms After last query: 0.35 ms Query memory: 0.004 MB Memory before query: 2.393 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM ms1wm_template_styles as s

  LEFT JOIN ms1wm_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,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	9	66.67	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	lotwmini_lotwministries.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:1701
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: 0.38 ms After last query: 6.99 ms Query memory: 0.011 MB Memory before query: 2.559 MB Rows returned: 1

SELECT `id`
            
  FROM `ms1wm_pitemplate`
            
  WHERE `def` = '1';

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/addsettings.php:59
15	PIHelperaddsettings::templateid()	JROOT/components/com_preachit/helpers/addsettings.php:108
14	PIHelperaddsettings::getPIparams()	JROOT/components/com_preachit/models/studylist.php:24
13	PreachitModelStudylist->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Controller/BaseController.php:549
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:736
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:624
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.40 ms After last query: 5.72 ms Query memory: 0.010 MB Memory before query: 2.573 MB Rows returned: 1

SELECT `params`
        
  FROM `ms1wm_pitemplate`
        
  WHERE `id` = '2';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_pitemplate	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

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:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/addsettings.php:117
14	PIHelperaddsettings::getPIparams()	JROOT/components/com_preachit/models/studylist.php:24
13	PreachitModelStudylist->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Controller/BaseController.php:549
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:736
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:624
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.75 ms After last query: 1.42 ms Query memory: 0.011 MB Memory before query: 2.618 MB Rows returned: 2

SELECT * 
  FROM ms1wm_pistudies 
  WHERE  ms1wm_pistudies.series = 6 
  AND  ms1wm_pistudies.published = 1 
  AND  (ms1wm_pistudies.access IN (1,1) OR ms1wm_pistudies.access = 0) 
  AND  (ms1wm_pistudies.saccess IN (1,1) OR ms1wm_pistudies.saccess = 0) 
  AND  ((ms1wm_pistudies.minaccess REGEXP "[[:<:]]1[[:>:]]" OR ms1wm_pistudies.minaccess REGEXP "[[:<:]]1[[:>:]]") OR ms1wm_pistudies.minaccess = 0) 
  AND  ms1wm_pistudies.language IN ('en-GB','*') 
  AND (ms1wm_pistudies.publish_up = '0000-00-00 00:00:00' OR ms1wm_pistudies.publish_up <= '2020-05-29 09:55:30') 
  AND (ms1wm_pistudies.publish_down = '0000-00-00 00:00:00' OR ms1wm_pistudies.publish_down >= '2020-05-29 09:55:30') 
  ORDER BY study_date desc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_pistudies	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	147	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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_preachit/models/studylist.php:63
14	PreachitModelStudylist->getTotal()	JROOT/components/com_preachit/models/studylist.php:32
13	PreachitModelStudylist->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:202
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Controller/BaseController.php:549
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:736
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:624
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.96 ms After last query: 3.79 ms Query memory: 0.010 MB Memory before query: 2.643 MB Rows returned: 2

SELECT * 
  FROM ms1wm_pistudies 
  WHERE  ms1wm_pistudies.series = 6 
  AND  ms1wm_pistudies.published = 1 
  AND  (ms1wm_pistudies.access IN (1,1) OR ms1wm_pistudies.access = 0) 
  AND  (ms1wm_pistudies.saccess IN (1,1) OR ms1wm_pistudies.saccess = 0) 
  AND  ((ms1wm_pistudies.minaccess REGEXP "[[:<:]]1[[:>:]]" OR ms1wm_pistudies.minaccess REGEXP "[[:<:]]1[[:>:]]") OR ms1wm_pistudies.minaccess = 0) 
  AND  ms1wm_pistudies.language IN ('en-GB','*') 
  AND (ms1wm_pistudies.publish_up = '0000-00-00 00:00:00' OR ms1wm_pistudies.publish_up <= '2020-05-29 09:55:30') 
  AND (ms1wm_pistudies.publish_down = '0000-00-00 00:00:00' OR ms1wm_pistudies.publish_down >= '2020-05-29 09:55:30') 
  ORDER BY study_date desc 
  LIMIT 0, 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_pistudies	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	147	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_preachit/models/studylist.php:53
12	PreachitModelStudylist->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_preachit/views/studylist/view.html.php:19
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.30 ms After last query: 1.79 ms Query memory: 0.009 MB Memory before query: 2.689 MB Rows returned: 1

SELECT `template`
    
  FROM `ms1wm_pitemplate`
    
  WHERE `id` = '2';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_pitemplate	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/addsettings.php:93
11	PIHelperaddsettings::template()	JROOT/components/com_preachit/views/studylist/view.html.php:56
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.27 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 2.698 MB Rows returned: 1

SELECT `cssoverride`
    
  FROM `ms1wm_pitemplate`
    
  WHERE `id` = '2';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_pitemplate	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/additional.php:179
11	PIHelperadditional::loadtempcssoverride()	JROOT/components/com_preachit/views/studylist/view.html.php:57
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.14 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 2.706 MB Rows returned: 1

SELECT `client_id`
    
  FROM `ms1wm_pitemplate`
    
  WHERE `id` = '2';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_pitemplate	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/additional.php:185
11	PIHelperadditional::loadtempcssoverride()	JROOT/components/com_preachit/views/studylist/view.html.php:57
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.31 ms After last query: 4.13 ms Query memory: 0.010 MB Memory before query: 2.795 MB Rows returned: 0

Duplicate queries: #24 #56 #58

SELECT `display_name`
        
  FROM `ms1wm_pibooks`
        
  WHERE `id` = '0';

Explain

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

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:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/scripture.php:330
14	PIHelperscripture::getbookname()	JROOT/components/com_preachit/helpers/scripture.php:62
13	PIHelperscripture->getbibleref()	JROOT/components/com_preachit/helpers/scripture.php:37
12	PIHelperscripture->__construct()	JROOT/components/com_preachit/helpers/info-builder.php:85
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.26 ms After last query: 0.08 ms Query memory: 0.010 MB Memory before query: 2.805 MB Rows returned: 0

Duplicate queries: #25 #57 #59

SELECT `book_name`
        
  FROM `ms1wm_pibooks`
        
  WHERE `id` = '0';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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/components/com_preachit/helpers/scripture.php:330
14	PIHelperscripture::getbookname()	JROOT/components/com_preachit/helpers/scripture.php:63
13	PIHelperscripture->getbibleref()	JROOT/components/com_preachit/helpers/scripture.php:37
12	PIHelperscripture->__construct()	JROOT/components/com_preachit/helpers/info-builder.php:85
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.12 ms After last query: 0.09 ms Query memory: 0.010 MB Memory before query: 2.815 MB Rows returned: 0

Duplicate queries: #22 #56 #58

SELECT `display_name`
        
  FROM `ms1wm_pibooks`
        
  WHERE `id` = '0';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/scripture.php:330
14	PIHelperscripture::getbookname()	JROOT/components/com_preachit/helpers/scripture.php:62
13	PIHelperscripture->getbibleref()	JROOT/components/com_preachit/helpers/scripture.php:38
12	PIHelperscripture->__construct()	JROOT/components/com_preachit/helpers/info-builder.php:85
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.09 ms After last query: 0.05 ms Query memory: 0.010 MB Memory before query: 2.826 MB Rows returned: 0

Duplicate queries: #23 #57 #59

SELECT `book_name`
        
  FROM `ms1wm_pibooks`
        
  WHERE `id` = '0';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/scripture.php:330
14	PIHelperscripture::getbookname()	JROOT/components/com_preachit/helpers/scripture.php:63
13	PIHelperscripture->getbibleref()	JROOT/components/com_preachit/helpers/scripture.php:38
12	PIHelperscripture->__construct()	JROOT/components/com_preachit/helpers/info-builder.php:85
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.28 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 2.836 MB Rows returned: 1

Duplicate queries: #60 #93

SELECT `series_name`
    
  FROM `ms1wm_piseries`
    
  WHERE `id` = '6';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_piseries	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 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.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:196
12	PIHelpermessageinfo::series()	JROOT/components/com_preachit/helpers/info-builder.php:91
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.17 ms After last query: 0.17 ms Query memory: 0.009 MB Memory before query: 2.845 MB Rows returned: 1

Duplicate queries: #61 #94 #100

SELECT `series_alias`
    
  FROM `ms1wm_piseries`
    
  WHERE `id` = '6';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_piseries	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:206
12	PIHelpermessageinfo::series()	JROOT/components/com_preachit/helpers/info-builder.php:91
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.22 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 2.854 MB Rows returned: 1

Duplicate queries: #62 #95

SELECT `published`
    
  FROM `ms1wm_piseries`
    
  WHERE `id` = '6';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ms1wm_piseries	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:217
12	PIHelpermessageinfo::series()	JROOT/components/com_preachit/helpers/info-builder.php:91
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.14 ms After last query: 0.33 ms Query memory: 0.009 MB Memory before query: 2.865 MB Rows returned: 0

Duplicate queries: #63

SELECT `teacher_name`
    
  FROM `ms1wm_piteachers`
    
  WHERE `id` = '';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:105
12	PIHelpermessageinfo::teacher()	JROOT/components/com_preachit/helpers/info-builder.php:92
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.17 ms After last query: 0.11 ms Query memory: 0.009 MB Memory before query: 2.874 MB Rows returned: 0

Duplicate queries: #64

SELECT `lastname`
    
  FROM `ms1wm_piteachers`
    
  WHERE `id` = '';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:113
12	PIHelpermessageinfo::teacher()	JROOT/components/com_preachit/helpers/info-builder.php:92
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.10 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 2.883 MB Rows returned: 0

Duplicate queries: #65

SELECT `teacher_alias`
    
  FROM `ms1wm_piteachers`
    
  WHERE `id` = '';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:127
12	PIHelpermessageinfo::teacher()	JROOT/components/com_preachit/helpers/info-builder.php:92
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.11 ms After last query: 0.05 ms Query memory: 0.009 MB Memory before query: 2.892 MB Rows returned: 0

Duplicate queries: #66

SELECT `published`
    
  FROM `ms1wm_piteachers`
    
  WHERE `id` = '';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:138
12	PIHelpermessageinfo::teacher()	JROOT/components/com_preachit/helpers/info-builder.php:92
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.20 ms After last query: 0.15 ms Query memory: 0.010 MB Memory before query: 2.908 MB Rows returned: 0

Duplicate queries: #67 #106

SELECT `ministry_name`
    
  FROM `ms1wm_piministry`
    
  WHERE `id` = '';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:362
12	PIHelpermessageinfo::ministry()	JROOT/components/com_preachit/helpers/info-builder.php:93
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.15 ms After last query: 0.05 ms Query memory: 0.009 MB Memory before query: 2.918 MB Rows returned: 0

Duplicate queries: #68 #107

SELECT `ministry_alias`
    
  FROM `ms1wm_piministry`
    
  WHERE `id` = '';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:371
12	PIHelpermessageinfo::ministry()	JROOT/components/com_preachit/helpers/info-builder.php:93
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.18 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 2.927 MB Rows returned: 0

Duplicate queries: #69 #108

SELECT `published`
    
  FROM `ms1wm_piministry`
    
  WHERE `id` = '';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	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
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 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.01 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:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_preachit/helpers/message-info.php:381
12	PIHelpermessageinfo::ministry()	JROOT/components/com_preachit/helpers/info-builder.php:93
11	PIHelperinfobuilder::messageinfo()	JROOT/components/com_preachit/views/studylist/view.html.php:93
10	PreachitViewStudylist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_preachit/controller.php:46
8	PreachitController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_preachit/preachit.php:18
6	require_once JROOT/components/com_preachit/preachit.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.15 ms After last query: 0.32 ms Query memory: 0.013 MB Memory before query: 2.940 MB Rows returned: 86

Testimonies

Sermons in this series

Reverence: The Days of Ananias and Sapphira are Upon Us

Testimony: Overcoming Spiritual Sloth

Home

Our Mission

Ministries

Resources

Partners

Contact Us

Quick Menu

Latest News

Information

S5 Box

Login

Register

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

121 Queries Logged 51.05 ms

72 duplicate found!