Deprecated: Non-static method Joomla\CMS\Application\SiteApplication::getMenu() should not be called statically in /home/fairchildhousing/public_html/components/com_posthousing/router.php on line 81

Deprecated: Non-static method Joomla\CMS\Application\CMSApplication::getMenu() should not be called statically in /home/fairchildhousing/public_html/libraries/src/Application/SiteApplication.php on line 275

Notice: Undefined variable: this in /home/fairchildhousing/public_html/libraries/src/Application/CMSApplication.php on line 370
Fort Bragg, NC | Apartments

Fort Bragg, NC

Apartments

Joomla! Debug Console

Database Queries

56 Queries Logged 233.42 ms

21 duplicate found!

9 duplicates: #9 #11 #18 #27 #36 #43 #44 #53 #56

2 duplicates: #22 #28

2 duplicates: #23 #52

4 duplicates: #24 #30 #37 #45

2 duplicates: #29 #51

2 duplicates: #32 #46

Query Time: 0.35 ms Query memory: 0.027 MB Memory before query: 1.193 MB Rows returned: 0

SELECT `data`

  FROM `m6w3o_session`

  WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034'

Explain

EXPLAIN not possible on query: SELECT `data` FROM `m6w3o_session` WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034'

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/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.25 ms After last query: 0.44 ms Query memory: 0.023 MB Memory before query: 1.273 MB Rows returned: 0

SELECT `session_id`

  FROM `m6w3o_session`

  WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034' 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT `session_id` FROM `m6w3o_session` WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034' LIMIT 1

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: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

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

Query Time: 1.76 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 1.280 MB

INSERT INTO `m6w3o_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6f76396137706d727062756c633771387072396b676b726d3034', 1, 1601580035, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `m6w3o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6f76396137706d727062756c633771387072396b676b726d3034', 1, 1601580035, 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.80 ms After last query: 0.87 ms Query memory: 0.034 MB Memory before query: 1.317 MB Rows returned: 37

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

  FROM `m6w3o_extensions`

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

Explain

EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `m6w3o_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1

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.54 ms After last query: 0.86 ms Query memory: 0.025 MB Memory before query: 1.355 MB Rows returned: 7

SELECT id, rules

  FROM `m6w3o_viewlevels`

Explain

EXPLAIN not possible on query: SELECT id, rules FROM `m6w3o_viewlevels`

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.15 ms Query memory: 0.025 MB Memory before query: 1.371 MB Rows returned: 2

SELECT b.id

  FROM m6w3o_usergroups AS a

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

  WHERE a.id = 9

Explain

EXPLAIN not possible on query: SELECT b.id FROM m6w3o_usergroups AS a LEFT JOIN m6w3o_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9

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.88 ms After last query: 0.23 ms Query memory: 0.038 MB Memory before query: 1.395 MB Rows returned: 90

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

  FROM m6w3o_extensions

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

  ORDER BY ordering

Explain

EXPLAIN not possible on query: SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM m6w3o_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering

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: 0.96 ms After last query: 13.85 ms Query memory: 0.032 MB Memory before query: 4.238 MB Rows returned: 37

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

  FROM `m6w3o_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_joompassswap','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_posthousing','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

EXPLAIN not possible on query: SELECT `id`,`name`,`rules`,`parent_id` FROM `m6w3o_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_joompassswap','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_posthousing','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

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/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/homepage/homepage.php:16
8	plgSystemHomepage->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 1.10 ms Query memory: 0.031 MB Memory before query: 4.391 MB Rows returned: 1

Duplicate queries: #11 #18 #27 #36 #43 #44 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
10	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
9	PostHousingModelBase->getBase()	JROOT/plugins/system/homepage/homepage.php:28
8	plgSystemHomepage->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 1.05 ms Query memory: 0.039 MB Memory before query: 4.443 MB Rows returned: 13

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

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

EXPLAIN not possible on query: 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 m6w3o_menu AS m LEFT JOIN m6w3o_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

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:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php: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.02 ms After last query: 4.38 ms Query memory: 0.031 MB Memory before query: 4.641 MB Rows returned: 1

Duplicate queries: #9 #18 #27 #36 #43 #44 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
11	PostHousingModelBase->getBase()	JROOT/components/com_posthousing/router.php:75
10	PostHousingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.22 ms After last query: 0.31 ms Query memory: 0.033 MB Memory before query: 4.662 MB Rows returned: 87

SELECT c.id, c.name

  FROM m6w3o_com_posthousing_businesses_categories AS c 
  GROUP BY c.name

Explain

EXPLAIN not possible on query: SELECT c.id, c.name FROM m6w3o_com_posthousing_businesses_categories AS c GROUP BY c.name

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:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_posthousing/models/common.php:133
11	PostHousingModelCommon->getBusinessCategories()	JROOT/components/com_posthousing/router.php:130
10	PostHousingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 1.00 ms Query memory: 0.027 MB Memory before query: 4.696 MB Rows returned: 1

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

  FROM `m6w3o_extensions`

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

Explain

EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `m6w3o_extensions` WHERE `type` = 'library' AND `element` = 'joomla'

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: 1.42 ms After last query: 0.24 ms Query memory: 0.007 MB Memory before query: 4.697 MB

UPDATE `m6w3o_extensions`

  SET `params` = '{\"mediaversion\":\"5e68f2de8c4ccf86d86ec3a93c61dbab\"}'

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

Explain

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

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.46 ms After last query: 0.57 ms Query memory: 0.026 MB Memory before query: 4.730 MB Rows returned: 1

SELECT *

  FROM m6w3o_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_languages WHERE published=1 ORDER BY ordering ASC

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.59 ms After last query: 0.32 ms Query memory: 0.022 MB Memory before query: 4.747 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM m6w3o_template_styles as s

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

EXPLAIN not possible on query: SELECT id, home, template, s.params FROM m6w3o_template_styles as s LEFT JOIN m6w3o_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

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: 2.06 ms Query memory: 0.028 MB Memory before query: 4.888 MB Rows returned: 1

SELECT * 
  FROM m6w3o_com_posthousing_businesses_categories 
  WHERE id = '54'

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_businesses_categories WHERE id = '54'

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:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/businesses.php:187
11	PostHousingModelBusinesses->getCategoryInfo()	JROOT/components/com_posthousing/views/businesses/view.html.php:55
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.00 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 4.910 MB Rows returned: 1

Duplicate queries: #9 #11 #27 #36 #43 #44 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
11	PostHousingModelBase->getBase()	JROOT/components/com_posthousing/views/businesses/view.html.php:66
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.43 ms After last query: 0.11 ms Query memory: 0.041 MB Memory before query: 4.930 MB Rows returned: 0

SELECT * 
  FROM m6w3o_com_posthousing_businesses 
  WHERE id = ''

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_businesses WHERE id = ''

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:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/businesses.php:101
11	PostHousingModelBusinesses->getBusiness()	JROOT/components/com_posthousing/views/businesses/view.html.php:81
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.56 ms After last query: 0.13 ms Query memory: 0.028 MB Memory before query: 4.948 MB Rows returned: 8

SELECT * 
  FROM m6w3o_com_posthousing_businesses_images 
  WHERE business_id = '' 
  ORDER BY image_number ASC

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_businesses_images WHERE business_id = '' ORDER BY image_number ASC

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:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_posthousing/models/businesses.php:135
11	PostHousingModelBusinesses->getBusiness()	JROOT/components/com_posthousing/views/businesses/view.html.php:81
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.19 ms After last query: 2.44 ms Query memory: 0.086 MB Memory before query: 5.111 MB Rows returned: 8

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM m6w3o_modules AS m

  LEFT JOIN m6w3o_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN m6w3o_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-01 19:20:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-01 19:20:35') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM m6w3o_modules AS m LEFT JOIN m6w3o_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN m6w3o_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-01 19:20:35') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-01 19:20:35') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 116 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:17
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.93 ms After last query: 0.27 ms Query memory: 0.029 MB Memory before query: 5.199 MB Rows returned: 1

Duplicate queries: #28

SELECT b.id, b.name, b.phone, b.website, c.name AS categoryname

  FROM m6w3o_com_posthousing_businesses AS b

  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

  WHERE b.date_expiration > '1601580035' 
  AND c.name != 'Sample Category' 
  AND b.active = 1 
  AND b.base =37

  ORDER BY RAND() 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT b.id, b.name, b.phone, b.website, c.name AS categoryname FROM m6w3o_com_posthousing_businesses AS b INNER JOIN m6w3o_com_posthousing_businesses_categories AS c ON b.category = c.id WHERE b.date_expiration > '1601580035' AND c.name != 'Sample Category' AND b.active = 1 AND b.base =37 ORDER BY RAND() LIMIT 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:154
14	PostHousingModelCommon->getBaseSponsor()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:21
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.15 ms Query memory: 0.028 MB Memory before query: 5.223 MB Rows returned: 1

Duplicate queries: #52

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 45867

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 45867 ORDER BY image_number ASC LIMIT 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:194
14	PostHousingModelCommon->getBaseSponsorImage()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:23
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.92 ms After last query: 0.11 ms Query memory: 0.030 MB Memory before query: 5.243 MB Rows returned: 4

Duplicate queries: #30 #37 #45

SELECT c.* 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id  
  WHERE ((b.date_expiration > 1601580035 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 37 
  AND c.id != 0  
  GROUP BY c.id 
  ORDER BY c.name

Explain

EXPLAIN not possible on query: SELECT c.* FROM m6w3o_com_posthousing_businesses AS b INNER JOIN m6w3o_com_posthousing_businesses_categories AS c ON b.category = c.id WHERE ((b.date_expiration > 1601580035 AND b.active = 1) OR b.reserved = 1) AND b.base = 37 AND c.id != 0 GROUP BY c.id ORDER BY c.name

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/components/com_posthousing/models/base.php:322
14	PostHousingModelBase->getBaseBusinessCategories()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:27
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.04 ms After last query: 0.15 ms Query memory: 0.042 MB Memory before query: 5.271 MB Rows returned: 0

SELECT b.*, c.name AS categoryname 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id 
  WHERE b.base = '37' 
  AND b.category = '54' 
  AND ((b.date_expiration > 1601580035 
  AND b.active = 1) OR (b.reserved = 1)) 
  GROUP BY b.id

Explain

EXPLAIN not possible on query: SELECT b.*, c.name AS categoryname FROM m6w3o_com_posthousing_businesses AS b INNER JOIN m6w3o_com_posthousing_businesses_categories AS c ON b.category = c.id WHERE b.base = '37' AND b.category = '54' AND ((b.date_expiration > 1601580035 AND b.active = 1) OR (b.reserved = 1)) GROUP BY b.id

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/components/com_posthousing/models/businesses.php:33
14	PostHousingModelBusinesses->getCategoryBusinesses()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:33
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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: 12.67 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 5.296 MB Rows returned: 1

SELECT id, content, formatted

  FROM m6w3o_com_posthousing_bases_content

  WHERE base = 37 
  AND layout = 'apartments'

Explain

EXPLAIN not possible on query: SELECT id, content, formatted FROM m6w3o_com_posthousing_bases_content WHERE base = 37 AND layout = 'apartments'

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:26
14	PostHousingModelCommon->getBaseContent()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:43
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.05 ms After last query: 1.55 ms Query memory: 0.038 MB Memory before query: 5.414 MB Rows returned: 1

Duplicate queries: #9 #11 #18 #36 #43 #44 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
19	PostHousingModelBase->getBase()	JROOT/tmp/htmlvmlMi7:18
18	include_once JROOT/tmp/htmlvmlMi7	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:76
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.14 ms After last query: 0.15 ms Query memory: 0.033 MB Memory before query: 5.450 MB Rows returned: 1

Duplicate queries: #22

SELECT b.id, b.name, b.phone, b.website, c.name AS categoryname

  FROM m6w3o_com_posthousing_businesses AS b

  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

  WHERE b.date_expiration > '1601580035' 
  AND c.name != 'Sample Category' 
  AND b.active = 1 
  AND b.base =37

  ORDER BY RAND() 
  LIMIT 1

Explain

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:154
19	PostHousingModelCommon->getBaseSponsor()	JROOT/tmp/htmlvmlMi7:26
18	include_once JROOT/tmp/htmlvmlMi7	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:76
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.50 ms After last query: 0.14 ms Query memory: 0.032 MB Memory before query: 5.482 MB Rows returned: 1

Duplicate queries: #51

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 39610

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 39610 ORDER BY image_number ASC LIMIT 1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:194
19	PostHousingModelCommon->getBaseSponsorImage()	JROOT/tmp/htmlvmlMi7:28
18	include_once JROOT/tmp/htmlvmlMi7	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:76
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.00 ms After last query: 0.12 ms Query memory: 0.034 MB Memory before query: 5.510 MB Rows returned: 4

Duplicate queries: #24 #37 #45

SELECT c.* 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id  
  WHERE ((b.date_expiration > 1601580035 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 37 
  AND c.id != 0  
  GROUP BY c.id 
  ORDER BY c.name

Explain

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_posthousing/models/base.php:322
19	PostHousingModelBase->getBaseBusinessCategories()	JROOT/tmp/htmlvmlMi7:32
18	include_once JROOT/tmp/htmlvmlMi7	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:76
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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: 6.49 ms After last query: 0.15 ms Query memory: 0.034 MB Memory before query: 5.549 MB Rows returned: 26

SELECT layout

  FROM m6w3o_com_posthousing_bases_content

  WHERE base = 37

  GROUP BY layout

  ORDER BY layout ASC

Explain

EXPLAIN not possible on query: SELECT layout FROM m6w3o_com_posthousing_bases_content WHERE base = 37 GROUP BY layout ORDER BY layout ASC

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_posthousing/models/base.php:236
19	PostHousingModelBase->getBaseSections()	JROOT/tmp/htmlvmlMi7:33
18	include_once JROOT/tmp/htmlvmlMi7	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:76
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.46 ms After last query: 0.28 ms Query memory: 0.033 MB Memory before query: 5.585 MB Rows returned: 13

Duplicate queries: #46

SELECT id

  FROM m6w3o_com_posthousing_bases_gates

  WHERE base = '37'

Explain

EXPLAIN not possible on query: SELECT id FROM m6w3o_com_posthousing_bases_gates WHERE base = '37'

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_posthousing/models/base.php:103
19	PostHousingModelBase->checkGates()	JROOT/tmp/htmlvmlMi7:40
18	include_once JROOT/tmp/htmlvmlMi7	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:76
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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: 0.12 ms Query memory: 0.034 MB Memory before query: 5.623 MB Rows returned: 10

SELECT id

  FROM m6w3o_com_posthousing_bases_recreation

  WHERE base = '37'

Explain

EXPLAIN not possible on query: SELECT id FROM m6w3o_com_posthousing_bases_recreation WHERE base = '37'

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:62
19	PostHousingModelCommon->checkRecreation()	JROOT/tmp/htmlvmlMi7:42
18	include_once JROOT/tmp/htmlvmlMi7	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:76
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.58 ms After last query: 2.40 ms Query memory: 0.043 MB Memory before query: 5.648 MB Rows returned: 1

SELECT b.*,c.name AS businesscategory

  FROM m6w3o_com_posthousing_businesses AS b

  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

  WHERE b.id = 1

Explain

EXPLAIN not possible on query: SELECT b.*,c.name AS businesscategory FROM m6w3o_com_posthousing_businesses AS b INNER JOIN m6w3o_com_posthousing_businesses_categories AS c ON b.category = c.id WHERE b.id = 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:461
14	PostHousingModelCommon->getSampleBusiness()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:184
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.53 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 5.681 MB Rows returned: 8

SELECT image_number, image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 1 
  ORDER BY image_number

Explain

EXPLAIN not possible on query: SELECT image_number, image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 1 ORDER BY image_number

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/components/com_posthousing/models/common.php:469
14	PostHousingModelCommon->getSampleBusiness()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:184
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.99 ms After last query: 1.39 ms Query memory: 0.038 MB Memory before query: 5.780 MB Rows returned: 1

Duplicate queries: #9 #11 #18 #27 #43 #44 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
19	PostHousingModelBase->getBase()	JROOT/tmp/htmlpk2TJS:20
18	include_once JROOT/tmp/htmlpk2TJS	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:231
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.00 ms After last query: 0.13 ms Query memory: 0.034 MB Memory before query: 5.814 MB Rows returned: 4

Duplicate queries: #24 #30 #45

SELECT c.* 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id  
  WHERE ((b.date_expiration > 1601580035 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 37 
  AND c.id != 0  
  GROUP BY c.id 
  ORDER BY c.name

Explain

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_posthousing/models/base.php:322
19	PostHousingModelBase->getBaseBusinessCategories()	JROOT/tmp/htmlpk2TJS:25
18	include_once JROOT/tmp/htmlpk2TJS	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:231
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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: 71.52 ms After last query: 0.20 ms Query memory: 0.034 MB Memory before query: 5.854 MB Rows returned: 1

SELECT id, street, price, show_address, externalid

  FROM m6w3o_com_posthousing_properties_rentals

  WHERE price > 0 
  AND base = 37 
  AND active = 1 
  AND date_expiration > '1601580035'
  AND id IN (SELECT property_id 
  FROM m6w3o_com_posthousing_properties_images)

  ORDER BY RAND() 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT id, street, price, show_address, externalid FROM m6w3o_com_posthousing_properties_rentals WHERE price > 0 AND base = 37 AND active = 1 AND date_expiration > '1601580035'AND id IN (SELECT property_id FROM m6w3o_com_posthousing_properties_images) ORDER BY RAND() LIMIT 1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:485
19	PostHousingModelCommon->getRandomProperty()	JROOT/tmp/htmlpk2TJS:29
18	include_once JROOT/tmp/htmlpk2TJS	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:231
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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: 51.68 ms After last query: 0.20 ms Query memory: 0.032 MB Memory before query: 5.886 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_properties_images

  WHERE property_id ='168356' 
  AND type = 'rent'

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_properties_images WHERE property_id ='168356' AND type = 'rent' ORDER BY image_number ASC LIMIT 1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:500
19	PostHousingModelCommon->getRandomProperty()	JROOT/tmp/htmlpk2TJS:29
18	include_once JROOT/tmp/htmlpk2TJS	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:231
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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: 2.75 ms After last query: 0.16 ms Query memory: 0.034 MB Memory before query: 5.918 MB Rows returned: 0

SELECT id, street, price, show_address, externalid

  FROM m6w3o_com_posthousing_properties_fsbo

  WHERE price > 0 
  AND base = 37 
  AND active = 1 
  AND date_expiration > '1601580035'
  AND id IN (SELECT property_id 
  FROM m6w3o_com_posthousing_properties_images)

  ORDER BY RAND() 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT id, street, price, show_address, externalid FROM m6w3o_com_posthousing_properties_fsbo WHERE price > 0 AND base = 37 AND active = 1 AND date_expiration > '1601580035'AND id IN (SELECT property_id FROM m6w3o_com_posthousing_properties_images) ORDER BY RAND() LIMIT 1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:512
19	PostHousingModelCommon->getRandomProperty()	JROOT/tmp/htmlpk2TJS:29
18	include_once JROOT/tmp/htmlpk2TJS	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:231
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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: 51.91 ms After last query: 0.18 ms Query memory: 0.032 MB Memory before query: 5.949 MB Rows returned: 0

SELECT image

  FROM m6w3o_com_posthousing_properties_images

  WHERE property_id ='' 
  AND type = 'fsbo'

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_properties_images WHERE property_id ='' AND type = 'fsbo' ORDER BY image_number ASC LIMIT 1

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:526
19	PostHousingModelCommon->getRandomProperty()	JROOT/tmp/htmlpk2TJS:29
18	include_once JROOT/tmp/htmlpk2TJS	JROOT/modules/mod_flexi_customcode/helper.php:25
17	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
16	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
15	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php:231
13	include JROOT/components/com_posthousing/views/businesses/tmpl/businesseslist.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_posthousing/views/businesses/view.html.php:116
10	PostHousingViewBusinesses->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_posthousing/controller.php:25
8	PostHousingController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_posthousing/posthousing.php:19
6	require_once JROOT/components/com_posthousing/posthousing.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.25 ms After last query: 2.16 ms Query memory: 0.045 MB Memory before query: 5.932 MB Rows returned: 227

SELECT id, domainname

  FROM m6w3o_com_posthousing_bases

  ORDER BY branch ASC, name ASC

Explain

EXPLAIN not possible on query: SELECT id, domainname FROM m6w3o_com_posthousing_bases ORDER BY branch ASC, name ASC

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:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_posthousing/models/base.php:252
8	PostHousingModelBase->getDomainNames()	JROOT/templates/posthousing/index.php:36
7	require JROOT/templates/posthousing/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.65 ms After last query: 2.74 ms Query memory: 0.034 MB Memory before query: 6.029 MB Rows returned: 1

Duplicate queries: #9 #11 #18 #27 #36 #44 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
14	PostHousingModelBase->getBase()	JROOT/tmp/htmleABUkc:17
13	include_once JROOT/tmp/htmleABUkc	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.64 ms After last query: 0.95 ms Query memory: 0.034 MB Memory before query: 6.090 MB Rows returned: 1

Duplicate queries: #9 #11 #18 #27 #36 #43 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
14	PostHousingModelBase->getBase()	JROOT/tmp/htmlObwRcY:18
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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: 0.08 ms Query memory: 0.030 MB Memory before query: 6.116 MB Rows returned: 4

Duplicate queries: #24 #30 #37

SELECT c.* 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id  
  WHERE ((b.date_expiration > 1601580035 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 37 
  AND c.id != 0  
  GROUP BY c.id 
  ORDER BY c.name

Explain

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/components/com_posthousing/models/base.php:322
14	PostHousingModelBase->getBaseBusinessCategories()	JROOT/tmp/htmlObwRcY:24
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.52 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 6.145 MB Rows returned: 13

Duplicate queries: #32

SELECT id

  FROM m6w3o_com_posthousing_bases_gates

  WHERE base = '37'

Explain

EXPLAIN not possible on query: SELECT id FROM m6w3o_com_posthousing_bases_gates WHERE base = '37'

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/components/com_posthousing/models/base.php:103
14	PostHousingModelBase->checkGates()	JROOT/tmp/htmlObwRcY:30
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.62 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 6.171 MB Rows returned: 5

SELECT b.id, b.name, b.phone, b.website, c.name AS categoryname

  FROM m6w3o_com_posthousing_businesses AS b

  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

  WHERE b.date_expiration > '1601580035' 
  AND c.name != 'Sample Category' 
  AND b.active = 1 
  AND b.base ='37'

  ORDER BY RAND()

Explain

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/components/com_posthousing/models/common.php:180
14	PostHousingModelCommon->getBaseSponsors()	JROOT/tmp/htmlObwRcY:48
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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: 0.10 ms Query memory: 0.028 MB Memory before query: 6.199 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 44516

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 44516 ORDER BY image_number ASC LIMIT 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:194
14	PostHousingModelCommon->getBaseSponsorImage()	JROOT/tmp/htmlObwRcY:63
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.24 ms Query memory: 0.028 MB Memory before query: 6.223 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 45865

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 45865 ORDER BY image_number ASC LIMIT 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:194
14	PostHousingModelCommon->getBaseSponsorImage()	JROOT/tmp/htmlObwRcY:79
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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: 0.24 ms Query memory: 0.028 MB Memory before query: 6.248 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 45856

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 45856 ORDER BY image_number ASC LIMIT 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:194
14	PostHousingModelCommon->getBaseSponsorImage()	JROOT/tmp/htmlObwRcY:79
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.33 ms After last query: 0.22 ms Query memory: 0.028 MB Memory before query: 6.272 MB Rows returned: 1

Duplicate queries: #29

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 39610

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 39610 ORDER BY image_number ASC LIMIT 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:194
14	PostHousingModelCommon->getBaseSponsorImage()	JROOT/tmp/htmlObwRcY:79
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.29 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 6.296 MB Rows returned: 1

Duplicate queries: #23

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 45867

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 45867 ORDER BY image_number ASC LIMIT 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/common.php:194
14	PostHousingModelCommon->getBaseSponsorImage()	JROOT/tmp/htmlObwRcY:79
13	include_once JROOT/tmp/htmlObwRcY	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.63 ms After last query: 1.48 ms Query memory: 0.034 MB Memory before query: 6.355 MB Rows returned: 1

Duplicate queries: #9 #11 #18 #27 #36 #43 #44 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
14	PostHousingModelBase->getBase()	JROOT/tmp/html7jWK5J:36
13	include_once JROOT/tmp/html7jWK5J	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.10 ms Query memory: 0.034 MB Memory before query: 6.381 MB Rows returned: 86

SELECT name 
  FROM m6w3o_com_posthousing_businesses_categories 
  WHERE id != 1

Explain

EXPLAIN not possible on query: SELECT name FROM m6w3o_com_posthousing_businesses_categories WHERE id != 1

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/components/com_posthousing/models/businesses.php:495
14	PostHousingModelBusinesses->getCategories()	JROOT/tmp/html7jWK5J:39
13	include_once JROOT/tmp/html7jWK5J	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.40 ms Query memory: 0.028 MB Memory before query: 6.422 MB Rows returned: 0

SELECT name

  FROM m6w3o_com_posthousing_bases_directory_categories

  WHERE id = ''

Explain

EXPLAIN not possible on query: SELECT name FROM m6w3o_com_posthousing_bases_directory_categories WHERE id = ''

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:377
14	PostHousingModelBase->getDirectoryListingCategory()	JROOT/tmp/html7jWK5J:57
13	include_once JROOT/tmp/html7jWK5J	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.67 ms After last query: 0.68 ms Query memory: 0.034 MB Memory before query: 6.367 MB Rows returned: 1

Duplicate queries: #9 #11 #18 #27 #36 #43 #44 #53

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
14	PostHousingModelBase->getBase()	JROOT/tmp/htmlay72Yv:8
13	include_once JROOT/tmp/htmlay72Yv	JROOT/modules/mod_flexi_customcode/helper.php:25
12	modFlexiCustomCode::parsePHPviaFile()	JROOT/modules/mod_flexi_customcode/tmpl/default.php:66
11	require JROOT/modules/mod_flexi_customcode/tmpl/default.php	JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php:22
10	include JROOT/modules/mod_flexi_customcode/mod_flexi_customcode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.]

34 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT * 
  FROM m6w3o_com_posthousing_bases

7 × SELECT image 
  FROM m6w3o_com_posthousing_businesses_images

4 × SELECT c.* 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

3 × SELECT b.id, b.name, b.phone, b.website, c.name AS categoryname 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

2 × SELECT image 
  FROM m6w3o_com_posthousing_properties_images

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `m6w3o_extensions`

2 × SELECT id 
  FROM m6w3o_com_posthousing_bases_gates

1 × SELECT id, domainname 
  FROM m6w3o_com_posthousing_bases

1 × SELECT id, street, price, show_address, externalid 
  FROM m6w3o_com_posthousing_properties_fsbo

1 × SELECT name 
  FROM m6w3o_com_posthousing_businesses_categories

1 × SELECT image_number, image 
  FROM m6w3o_com_posthousing_businesses_images

1 × SELECT b.*,c.name AS businesscategory 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

1 × SELECT id 
  FROM m6w3o_com_posthousing_bases_recreation

1 × SELECT layout 
  FROM m6w3o_com_posthousing_bases_content

1 × SELECT id, content, formatted 
  FROM m6w3o_com_posthousing_bases_content

1 × SELECT b.*, c.name AS categoryname 
  FROM m6w3o_com_posthousing_businesses AS b 
  INNER JOIN m6w3o_com_posthousing_businesses_categories AS c 
  ON b.category = c.id

1 × SELECT id, street, price, show_address, externalid 
  FROM m6w3o_com_posthousing_properties_rentals

1 × SELECT `data` 
  FROM `m6w3o_session`

1 × SELECT `session_id` 
  FROM `m6w3o_session`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM m6w3o_modules AS m 
  LEFT JOIN m6w3o_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN m6w3o_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM m6w3o_com_posthousing_businesses_images

1 × SELECT * 
  FROM m6w3o_com_posthousing_businesses

1 × SELECT * 
  FROM m6w3o_com_posthousing_businesses_categories

1 × SELECT id, home, template, s.params 
  FROM m6w3o_template_styles as s 
  LEFT JOIN m6w3o_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM m6w3o_languages
```

1 × SELECT c.id, c.name 
  FROM m6w3o_com_posthousing_businesses_categories AS c 
  GROUP BY c.nam

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM m6w3o_menu AS m 
  LEFT JOIN m6w3o_extensions AS e 
  ON m.component_id = e.extension_id

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM m6w3o_extensions

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

1 × SELECT id, rules 
  FROM `m6w3o_viewlevels

1 × SELECT name 
  FROM m6w3o_com_posthousing_bases_directory_categories

OTHER Tables:

1 × INSERT INTO `m6w3o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6f76396137706d727062756c633771387072396b676b726d3034', 1, 1601580035, 0, '', 0

1 × UPDATE `m6w3o_extensions` 
  SET `params` = '{\"mediaversion\":\"5e68f2de8c4ccf86d86ec3a93c61dbab\"}'

Log Messages

Warning: Creating default object from empty value in /home/fairchildhousing/public_html/components/com_posthousing/models/businesses.php on line 155

Notice: Undefined property: stdClass::$id in /home/fairchildhousing/public_html/components/com_posthousing/views/businesses/view.html.php on line 105

Post Life

Local Businesses

SecurCare Self Storage

910-339-7031

Visit Our Website

Advertise

List Your Business

Helpful Resources

Information

My Account

Fort Bragg, NC Area Apartments

Apartment complexes offer a variety of amenities for families including proximity to shops and dining establishments. Some have on-site amenities such as a swimming pool and clubhouse.

Sample Business Ad - Your Company Name Here

Address: 123 Some St - Suite A Somewhere, WA 98516

Phone: 1234567890

Military Specials Offered

View Business Details

Own or manage a military friendly apartment complex close to Fort Bragg, NC? Go to our business sign up page.

Warning: Creating default object from empty value in /home/fairchildhousing/public_html/components/com_posthousing/models/common.php on line 513

Notice: Undefined property: stdClass::$externalid in /home/fairchildhousing/public_html/components/com_posthousing/models/common.php on line 519

Notice: Undefined property: stdClass::$id in /home/fairchildhousing/public_html/components/com_posthousing/models/common.php on line 522

Notice: Trying to get property of non-object in /home/fairchildhousing/public_html/components/com_posthousing/models/common.php on line 527

Off Post Housing

Off Post Resources

On Post Resources

Quick Links

Fort Bragg, NC Off Post Housing

Military Friendly Local Businesses

Dr. Zack Smith Orthodontics

910-323-5821

910-273-5253

910-381-1341

SecurCare Self Storage

910-339-7031

Visit Our Website

GoPrime Mortgage, Inc
Company NMLS ID 69551
Loan Officer NMLS ID 1099198

919-343-1300

Visit Our Website

View by Business Category

Joomla! Debug Console

Database Queries

56 Queries Logged 233.42 ms

21 duplicate found!

9 duplicates: #9 #11 #18 #27 #36 #43 #44 #53 #56

2 duplicates: #22 #28

2 duplicates: #23 #52

4 duplicates: #24 #30 #37 #45

2 duplicates: #29 #51

2 duplicates: #32 #46

Query Time: 0.35 ms Query memory: 0.027 MB Memory before query: 1.193 MB Rows returned: 0

SELECT `data`

  FROM `m6w3o_session`

  WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034'

Explain

EXPLAIN not possible on query: SELECT `data` FROM `m6w3o_session` WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034'

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/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.25 ms After last query: 0.44 ms Query memory: 0.023 MB Memory before query: 1.273 MB Rows returned: 0

SELECT `session_id`

  FROM `m6w3o_session`

  WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034' 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT `session_id` FROM `m6w3o_session` WHERE `session_id` = X'6f76396137706d727062756c633771387072396b676b726d3034' LIMIT 1

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: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

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

Query Time: 1.76 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 1.280 MB

INSERT INTO `m6w3o_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6f76396137706d727062756c633771387072396b676b726d3034', 1, 1601580035, 0, '', 0)

Explain

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.80 ms After last query: 0.87 ms Query memory: 0.034 MB Memory before query: 1.317 MB Rows returned: 37

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

  FROM `m6w3o_extensions`

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

Explain

EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `m6w3o_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1

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.54 ms After last query: 0.86 ms Query memory: 0.025 MB Memory before query: 1.355 MB Rows returned: 7

SELECT id, rules

  FROM `m6w3o_viewlevels`

Explain

EXPLAIN not possible on query: SELECT id, rules FROM `m6w3o_viewlevels`

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.15 ms Query memory: 0.025 MB Memory before query: 1.371 MB Rows returned: 2

SELECT b.id

  FROM m6w3o_usergroups AS a

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

  WHERE a.id = 9

Explain

EXPLAIN not possible on query: SELECT b.id FROM m6w3o_usergroups AS a LEFT JOIN m6w3o_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9

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.88 ms After last query: 0.23 ms Query memory: 0.038 MB Memory before query: 1.395 MB Rows returned: 90

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

  FROM m6w3o_extensions

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

  ORDER BY ordering

Explain

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: 0.96 ms After last query: 13.85 ms Query memory: 0.032 MB Memory before query: 4.238 MB Rows returned: 37

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

  FROM `m6w3o_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_joompassswap','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_posthousing','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

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/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/homepage/homepage.php:16
8	plgSystemHomepage->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 1.10 ms Query memory: 0.031 MB Memory before query: 4.391 MB Rows returned: 1

Duplicate queries: #11 #18 #27 #36 #43 #44 #53 #56

SELECT *

  FROM m6w3o_com_posthousing_bases

  WHERE LOWER(domainname) = 'fortbragghousing.com' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortbragghousing.com' AND published = 1

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:1662
10	JDatabaseDriver->loadObject()	JROOT/components/com_posthousing/models/base.php:28
9	PostHousingModelBase->getBase()	JROOT/plugins/system/homepage/homepage.php:28
8	plgSystemHomepage->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 1.05 ms Query memory: 0.039 MB Memory before query: 4.443 MB Rows returned: 13

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

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

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:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php: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.02 ms After last query: 4.38 ms Query memory: 0.031 MB Memory before query: 4.641 MB Rows returned: 1

Fort Bragg, NC

Apartments

Joomla! Debug Console

Database Queries

56 Queries Logged 233.42 ms

21 duplicate found!

34 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Log Messages

0 messages logged

Post Life

Local Businesses

Advertise

Helpful Resources

Information

My Account

Fort Bragg, NC Area Apartments

Off Post Housing

Off Post Resources

On Post Resources

Quick Links

Military Friendly Local Businesses

View by Business Category

Joomla! Debug Console

Database Queries

56 Queries Logged 233.42 ms

21 duplicate found!