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

Fort Wainwright, AK

Condo For Rent by Owner

Joomla! Debug Console

Database Queries

45 Queries Logged 297.49 ms

15 duplicate found!

9 duplicates: #9 #11 #16 #21 #29 #36 #37 #41 #45

2 duplicates: #18 #44

2 duplicates: #25 #30

2 duplicates: #27 #39

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

SELECT `data`

  FROM `m6w3o_session`

  WHERE `session_id` = X'657266353630616337706a38706b7436316a6537616469706332'

Explain

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

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.27 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 1.274 MB Rows returned: 0

SELECT `session_id`

  FROM `m6w3o_session`

  WHERE `session_id` = X'657266353630616337706a38706b7436316a6537616469706332' 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT `session_id` FROM `m6w3o_session` WHERE `session_id` = X'657266353630616337706a38706b7436316a6537616469706332' 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.69 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 1.281 MB

INSERT INTO `m6w3o_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'657266353630616337706a38706b7436316a6537616469706332', 1, 1601499441, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `m6w3o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'657266353630616337706a38706b7436316a6537616469706332', 1, 1601499441, 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.58 ms After last query: 0.74 ms Query memory: 0.034 MB Memory before query: 1.318 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.31 ms After last query: 0.66 ms Query memory: 0.025 MB Memory before query: 1.356 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.32 ms After last query: 0.11 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.90 ms After last query: 0.21 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.61 ms After last query: 8.61 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: 0.67 ms After last query: 0.71 ms Query memory: 0.031 MB Memory before query: 4.391 MB Rows returned: 1

Duplicate queries: #11 #16 #21 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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.57 ms After last query: 0.77 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: 0.62 ms After last query: 2.81 ms Query memory: 0.031 MB Memory before query: 4.641 MB Rows returned: 1

Duplicate queries: #9 #16 #21 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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: 0.32 ms After last query: 0.32 ms Query memory: 0.027 MB Memory before query: 4.679 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: 2.22 ms After last query: 0.17 ms Query memory: 0.007 MB Memory before query: 4.680 MB

UPDATE `m6w3o_extensions`

  SET `params` = '{\"mediaversion\":\"14d5736039f73cf2a77ba643864970f0\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `m6w3o_extensions` SET `params` = '{\"mediaversion\":\"14d5736039f73cf2a77ba643864970f0\"}' 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.32 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 4.713 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.40 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 4.730 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.62 ms After last query: 1.42 ms Query memory: 0.032 MB Memory before query: 4.868 MB Rows returned: 1

Duplicate queries: #9 #11 #21 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/listings/view.html.php:53
10	PostHousingViewListings->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.30 ms After last query: 0.10 ms Query memory: 0.028 MB Memory before query: 4.892 MB Rows returned: 1

SELECT *

  FROM m6w3o_com_posthousing_branches

  WHERE id = '2' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_branches WHERE id = '2' 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:135
11	PostHousingModelBase->getBranchInfo()	JROOT/components/com_posthousing/views/listings/view.html.php:54
10	PostHousingViewListings->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: 2.81 ms Query memory: 0.050 MB Memory before query: 5.024 MB Rows returned: 1

Duplicate queries: #44

SELECT * 
  FROM m6w3o_com_posthousing_properties_rentals 
  WHERE id = '165772'

Explain

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

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/listings.php:119
11	PostHousingModelListings->getListingById()	JROOT/components/com_posthousing/views/listings/view.html.php:131
10	PostHousingViewListings->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.86 ms After last query: 0.47 ms Query memory: 0.086 MB Memory before query: 5.109 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-09-30 20:57:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-30 20:57:21') 
  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-09-30 20:57:21') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-30 20:57:21') 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/listings/tmpl/details.php:14
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 48.25 ms After last query: 0.24 ms Query memory: 0.031 MB Memory before query: 5.194 MB Rows returned: 14

SELECT * 
  FROM m6w3o_com_posthousing_properties_images 
  WHERE property_id = '165772' 
  AND type = 'rent' 
  GROUP BY image 
  ORDER BY image_number ASC

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_properties_images WHERE property_id = '165772' AND type = 'rent' GROUP BY image ORDER BY image_number ASC

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/listings.php:185
14	PostHousingModelListings->getImages()	JROOT/components/com_posthousing/views/listings/tmpl/details.php:54
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.60 ms After last query: 4.12 ms Query memory: 0.038 MB Memory before query: 5.406 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/htmlpmUArD:18
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.51 ms After last query: 0.11 ms Query memory: 0.033 MB Memory before query: 5.442 MB Rows returned: 0

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 > '1601499441' 
  AND c.name != 'Sample Category' 
  AND b.active = 1 
  AND b.base =60

  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 > '1601499441' AND c.name != 'Sample Category' AND b.active = 1 AND b.base =60 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:154
19	PostHousingModelCommon->getBaseSponsor()	JROOT/tmp/htmlpmUArD:26
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 4.87 ms After last query: 0.10 ms Query memory: 0.033 MB Memory before query: 5.473 MB Rows returned: 1

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 c.name = 'Sample Category'

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:164
19	PostHousingModelCommon->getBaseSponsor()	JROOT/tmp/htmlpmUArD:26
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.32 ms After last query: 0.10 ms Query memory: 0.032 MB Memory before query: 5.504 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 1

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 1 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/htmlpmUArD:28
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.47 ms After last query: 0.09 ms Query memory: 0.033 MB Memory before query: 5.533 MB Rows returned: 0

Duplicate queries: #30

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 > 1601499441 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 60 
  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 > 1601499441 AND b.active = 1) OR b.reserved = 1) AND b.base = 60 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
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/htmlpmUArD:32
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 4.15 ms After last query: 0.11 ms Query memory: 0.034 MB Memory before query: 5.567 MB Rows returned: 26

SELECT layout

  FROM m6w3o_com_posthousing_bases_content

  WHERE base = 60

  GROUP BY layout

  ORDER BY layout ASC

Explain

EXPLAIN not possible on query: SELECT layout FROM m6w3o_com_posthousing_bases_content WHERE base = 60 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/htmlpmUArD:33
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.57 ms After last query: 0.16 ms Query memory: 0.033 MB Memory before query: 5.604 MB Rows returned: 4

Duplicate queries: #39

SELECT id

  FROM m6w3o_com_posthousing_bases_gates

  WHERE base = '60'

Explain

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

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/htmlpmUArD:40
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.28 ms After last query: 0.10 ms Query memory: 0.033 MB Memory before query: 5.635 MB Rows returned: 8

SELECT id

  FROM m6w3o_com_posthousing_bases_recreation

  WHERE base = '60'

Explain

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

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/htmlpmUArD:42
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.63 ms After last query: 2.15 ms Query memory: 0.038 MB Memory before query: 5.684 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #21 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/html63AEyI:20
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.08 ms Query memory: 0.033 MB Memory before query: 5.718 MB Rows returned: 0

Duplicate queries: #25

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 > 1601499441 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 60 
  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/html63AEyI:25
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 61.11 ms After last query: 0.13 ms Query memory: 0.034 MB Memory before query: 5.754 MB Rows returned: 1

SELECT id, street, price, show_address, externalid

  FROM m6w3o_com_posthousing_properties_rentals

  WHERE price > 0 
  AND base = 60 
  AND active = 1 
  AND date_expiration > '1601499441'
  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 = 60 AND active = 1 AND date_expiration > '1601499441'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/html63AEyI:29
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 50.63 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 5.785 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_properties_images

  WHERE property_id ='165772' 
  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 ='165772' 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/html63AEyI:29
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 55.62 ms After last query: 0.11 ms Query memory: 0.035 MB Memory before query: 5.824 MB Rows returned: 1

SELECT id, street, price, show_address, externalid

  FROM m6w3o_com_posthousing_properties_fsbo

  WHERE price > 0 
  AND base = 60 
  AND active = 1 
  AND date_expiration > '1601499441'
  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 = 60 AND active = 1 AND date_expiration > '1601499441'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/html63AEyI:29
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 50.77 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 5.857 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_properties_images

  WHERE property_id ='91773' 
  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 ='91773' 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/html63AEyI:29
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.10 ms After last query: 2.04 ms Query memory: 0.045 MB Memory before query: 5.857 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.63 ms After last query: 2.72 ms Query memory: 0.034 MB Memory before query: 5.953 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #21 #29 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/htmlW5uTrZ:17
13	include_once JROOT/tmp/htmlW5uTrZ	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.60 ms After last query: 0.92 ms Query memory: 0.034 MB Memory before query: 6.014 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #21 #29 #36 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/htmlEqvf54:18
13	include_once JROOT/tmp/htmlEqvf54	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.51 ms After last query: 0.08 ms Query memory: 0.029 MB Memory before query: 6.040 MB Rows returned: 0

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 > 1601499442 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 60 
  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 > 1601499442 AND b.active = 1) OR b.reserved = 1) AND b.base = 60 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/tmp/htmlEqvf54:24
13	include_once JROOT/tmp/htmlEqvf54	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.50 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 6.065 MB Rows returned: 4

Duplicate queries: #27

SELECT id

  FROM m6w3o_com_posthousing_bases_gates

  WHERE base = '60'

Explain

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

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/htmlEqvf54:30
13	include_once JROOT/tmp/htmlEqvf54	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.42 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 6.090 MB Rows returned: 0

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 > '1601499442' 
  AND c.name != 'Sample Category' 
  AND b.active = 1 
  AND b.base ='60'

  ORDER BY RAND()

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 > '1601499442' AND c.name != 'Sample Category' AND b.active = 1 AND b.base ='60' ORDER BY RAND()

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/htmlEqvf54:48
13	include_once JROOT/tmp/htmlEqvf54	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.27 ms Query memory: 0.034 MB Memory before query: 6.143 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #21 #29 #36 #37 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/htmlCVY5Ia:36
13	include_once JROOT/tmp/htmlCVY5Ia	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.31 ms After last query: 0.10 ms Query memory: 0.034 MB Memory before query: 6.169 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/htmlCVY5Ia:39
13	include_once JROOT/tmp/htmlCVY5Ia	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.24 ms After last query: 0.38 ms Query memory: 0.028 MB Memory before query: 6.210 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/htmlCVY5Ia:57
13	include_once JROOT/tmp/htmlCVY5Ia	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.36 ms After last query: 0.13 ms Query memory: 0.052 MB Memory before query: 6.232 MB Rows returned: 1

Duplicate queries: #18

SELECT * 
  FROM m6w3o_com_posthousing_properties_rentals 
  WHERE id = '165772'

Explain

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

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/listings.php:119
14	PostHousingModelListings->getListingById()	JROOT/tmp/htmlCVY5Ia:64
13	include_once JROOT/tmp/htmlCVY5Ia	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: 0.69 ms Query memory: 0.034 MB Memory before query: 6.180 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #21 #29 #36 #37 #41

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/htmll32ong:8
13	include_once JROOT/tmp/htmll32ong	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.]

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT * 
  FROM m6w3o_com_posthousing_bases

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

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

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

2 × SELECT image 
  FROM m6w3o_com_posthousing_properties_images

2 × SELECT id 
  FROM m6w3o_com_posthousing_bases_gates

2 × SELECT * 
  FROM m6w3o_com_posthousing_properties_rentals

1 × SELECT `data` 
  FROM `m6w3o_session`

1 × SELECT name 
  FROM m6w3o_com_posthousing_businesses_categories

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 id, street, price, show_address, externalid 
  FROM m6w3o_com_posthousing_properties_rentals

1 × SELECT id 
  FROM m6w3o_com_posthousing_bases_recreation

1 × SELECT layout 
  FROM m6w3o_com_posthousing_bases_content

1 × SELECT image 
  FROM m6w3o_com_posthousing_businesses_images

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_properties_images

1 × SELECT `session_id` 
  FROM `m6w3o_session`

1 × SELECT * 
  FROM m6w3o_com_posthousing_branches

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 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'657266353630616337706a38706b7436316a6537616469706332', 1, 1601499441, 0, '', 0

1 × UPDATE `m6w3o_extensions` 
  SET `params` = '{\"mediaversion\":\"14d5736039f73cf2a77ba643864970f0\"}'

Log Messages

Notice: Undefined offset: 0 in /home/fairchildhousing/public_html/components/com_posthousing/views/listings/tmpl/details.php on line 66

Post Life

Local Businesses

Sample Business

1234567890

Visit Our Website

Advertise

List Your Business

Information

My Account

141 dunkel st #7 - Fairbanks , AK 99701

⟨

1 of 14

⟩

Price: $1,450

Date Posted: 10-06-2019

Bedrooms: 2

Bathrooms: 1

Living Area: 0 sq. ft.

Notice: Undefined property: stdClass::$payment_name in /home/fairchildhousing/public_html/components/com_posthousing/views/listings/tmpl/details.php on line 151

Send Message to Owner

141 dunkel st #7 Description

Luxurious condo, recently remodeled 2 bedroom 1 bathroom High End ground level condo. Located minutes from Ft. Wainwright, Fairbanks Memorial Hospital, University, schools and all amenities. Tile throughout, brand new kitchen, Bathroom features a soaking roman tub. Fully furnished, washer/dryer in unit, Carport parking, No pets, No smoking. $1450/month, plus electric. 1st and last month due at signing by a form of a certified cashiers check, $500 security deposit due at signing by a form of a certified cashiers check., Easy military terms., Month to month, 6 month, 1yr terms available. Unit will be available November 1st.

Distance to Base: 1 mile

Drive time to Fort Wainwright, AK: 3 minutes

Notice: Undefined property: stdClass::$terms in /home/fairchildhousing/public_html/components/com_posthousing/views/listings/tmpl/details.php on line 217

Parking Type: Carport-Attached

Covered Parking Spaces: 1

Available Amenities: Cable Ready, Ceiling Fan(s), Security System

Furnished Appliances: Microwave, Range / Oven, Refrigerator

Flooring Types: Ceramic Tile

Lot Location: Paved Street, Sidewalk

Available Utilities

Notice: Undefined property: stdClass::$water_sourcesv in /home/fairchildhousing/public_html/components/com_posthousing/views/listings/tmpl/details.php on line 312

Heating & Cooling Source: Baseboard

Energy Sources: Electric

Sewage System: Sewer Connected

Map Location of 141 dunkel st #7

Off Post Housing

Off Post Resources

On Post Resources

Quick Links

Fort Wainwright, AK Off Post Housing

Joomla! Debug Console

Database Queries

45 Queries Logged 297.49 ms

15 duplicate found!

9 duplicates: #9 #11 #16 #21 #29 #36 #37 #41 #45

2 duplicates: #18 #44

2 duplicates: #25 #30

2 duplicates: #27 #39

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

SELECT `data`

  FROM `m6w3o_session`

  WHERE `session_id` = X'657266353630616337706a38706b7436316a6537616469706332'

Explain

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

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.27 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 1.274 MB Rows returned: 0

SELECT `session_id`

  FROM `m6w3o_session`

  WHERE `session_id` = X'657266353630616337706a38706b7436316a6537616469706332' 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT `session_id` FROM `m6w3o_session` WHERE `session_id` = X'657266353630616337706a38706b7436316a6537616469706332' 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.69 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 1.281 MB

INSERT INTO `m6w3o_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'657266353630616337706a38706b7436316a6537616469706332', 1, 1601499441, 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.58 ms After last query: 0.74 ms Query memory: 0.034 MB Memory before query: 1.318 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.31 ms After last query: 0.66 ms Query memory: 0.025 MB Memory before query: 1.356 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.32 ms After last query: 0.11 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.90 ms After last query: 0.21 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.61 ms After last query: 8.61 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: 0.67 ms After last query: 0.71 ms Query memory: 0.031 MB Memory before query: 4.391 MB Rows returned: 1

Duplicate queries: #11 #16 #21 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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.57 ms After last query: 0.77 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: 0.62 ms After last query: 2.81 ms Query memory: 0.031 MB Memory before query: 4.641 MB Rows returned: 1

Duplicate queries: #9 #16 #21 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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: 0.32 ms After last query: 0.32 ms Query memory: 0.027 MB Memory before query: 4.679 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: 2.22 ms After last query: 0.17 ms Query memory: 0.007 MB Memory before query: 4.680 MB

UPDATE `m6w3o_extensions`

  SET `params` = '{\"mediaversion\":\"14d5736039f73cf2a77ba643864970f0\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `m6w3o_extensions` SET `params` = '{\"mediaversion\":\"14d5736039f73cf2a77ba643864970f0\"}' 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.32 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 4.713 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.40 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 4.730 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

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.62 ms After last query: 1.42 ms Query memory: 0.032 MB Memory before query: 4.868 MB Rows returned: 1

Duplicate queries: #9 #11 #21 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/listings/view.html.php:53
10	PostHousingViewListings->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.30 ms After last query: 0.10 ms Query memory: 0.028 MB Memory before query: 4.892 MB Rows returned: 1

SELECT *

  FROM m6w3o_com_posthousing_branches

  WHERE id = '2' 
  AND published = 1

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_branches WHERE id = '2' 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:135
11	PostHousingModelBase->getBranchInfo()	JROOT/components/com_posthousing/views/listings/view.html.php:54
10	PostHousingViewListings->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: 2.81 ms Query memory: 0.050 MB Memory before query: 5.024 MB Rows returned: 1

Duplicate queries: #44

SELECT * 
  FROM m6w3o_com_posthousing_properties_rentals 
  WHERE id = '165772'

Explain

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

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/listings.php:119
11	PostHousingModelListings->getListingById()	JROOT/components/com_posthousing/views/listings/view.html.php:131
10	PostHousingViewListings->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.86 ms After last query: 0.47 ms Query memory: 0.086 MB Memory before query: 5.109 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-09-30 20:57:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-30 20:57:21') 
  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

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/listings/tmpl/details.php:14
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 48.25 ms After last query: 0.24 ms Query memory: 0.031 MB Memory before query: 5.194 MB Rows returned: 14

SELECT * 
  FROM m6w3o_com_posthousing_properties_images 
  WHERE property_id = '165772' 
  AND type = 'rent' 
  GROUP BY image 
  ORDER BY image_number ASC

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_properties_images WHERE property_id = '165772' AND type = 'rent' GROUP BY image ORDER BY image_number ASC

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/listings.php:185
14	PostHousingModelListings->getImages()	JROOT/components/com_posthousing/views/listings/tmpl/details.php:54
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.60 ms After last query: 4.12 ms Query memory: 0.038 MB Memory before query: 5.406 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #29 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/htmlpmUArD:18
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.51 ms After last query: 0.11 ms Query memory: 0.033 MB Memory before query: 5.442 MB Rows returned: 0

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 > '1601499441' 
  AND c.name != 'Sample Category' 
  AND b.active = 1 
  AND b.base =60

  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/htmlpmUArD:26
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 4.87 ms After last query: 0.10 ms Query memory: 0.033 MB Memory before query: 5.473 MB Rows returned: 1

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 c.name = 'Sample Category'

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:164
19	PostHousingModelCommon->getBaseSponsor()	JROOT/tmp/htmlpmUArD:26
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.32 ms After last query: 0.10 ms Query memory: 0.032 MB Memory before query: 5.504 MB Rows returned: 1

SELECT image

  FROM m6w3o_com_posthousing_businesses_images

  WHERE business_id = 1

  ORDER BY image_number ASC 
  LIMIT 1

Explain

EXPLAIN not possible on query: SELECT image FROM m6w3o_com_posthousing_businesses_images WHERE business_id = 1 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/htmlpmUArD:28
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.47 ms After last query: 0.09 ms Query memory: 0.033 MB Memory before query: 5.533 MB Rows returned: 0

Duplicate queries: #30

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 > 1601499441 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 60 
  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/htmlpmUArD:32
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 4.15 ms After last query: 0.11 ms Query memory: 0.034 MB Memory before query: 5.567 MB Rows returned: 26

SELECT layout

  FROM m6w3o_com_posthousing_bases_content

  WHERE base = 60

  GROUP BY layout

  ORDER BY layout ASC

Explain

EXPLAIN not possible on query: SELECT layout FROM m6w3o_com_posthousing_bases_content WHERE base = 60 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/htmlpmUArD:33
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.57 ms After last query: 0.16 ms Query memory: 0.033 MB Memory before query: 5.604 MB Rows returned: 4

Duplicate queries: #39

SELECT id

  FROM m6w3o_com_posthousing_bases_gates

  WHERE base = '60'

Explain

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

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/htmlpmUArD:40
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.28 ms After last query: 0.10 ms Query memory: 0.033 MB Memory before query: 5.635 MB Rows returned: 8

SELECT id

  FROM m6w3o_com_posthousing_bases_recreation

  WHERE base = '60'

Explain

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

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/htmlpmUArD:42
18	include_once JROOT/tmp/htmlpmUArD	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/listings/tmpl/details.php:74
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.63 ms After last query: 2.15 ms Query memory: 0.038 MB Memory before query: 5.684 MB Rows returned: 1

Duplicate queries: #9 #11 #16 #21 #36 #37 #41 #45

SELECT *

  FROM m6w3o_com_posthousing_bases

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

Explain

EXPLAIN not possible on query: SELECT * FROM m6w3o_com_posthousing_bases WHERE LOWER(domainname) = 'fortwainwrighthousing.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/html63AEyI:20
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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.08 ms Query memory: 0.033 MB Memory before query: 5.718 MB Rows returned: 0

Duplicate queries: #25

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 > 1601499441 
  AND b.active = 1) OR b.reserved = 1) 
  AND b.base = 60 
  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/html63AEyI:25
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 61.11 ms After last query: 0.13 ms Query memory: 0.034 MB Memory before query: 5.754 MB Rows returned: 1

SELECT id, street, price, show_address, externalid

  FROM m6w3o_com_posthousing_properties_rentals

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

  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:485
19	PostHousingModelCommon->getRandomProperty()	JROOT/tmp/html63AEyI:29
18	include_once JROOT/tmp/html63AEyI	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/listings/tmpl/details.php:455
13	include JROOT/components/com_posthousing/views/listings/tmpl/details.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/listings/view.html.php:163
10	PostHousingViewListings->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: 50.63 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 5.785 MB Rows returned: 1

Fort Wainwright, AK

Condo For Rent by Owner

Joomla! Debug Console

Database Queries

45 Queries Logged 297.49 ms

15 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Log Messages

1 messages logged

Post Life

Local Businesses

Advertise

Information

My Account

141 dunkel st #7 - Fairbanks , AK 99701

Price: $1,450

141 dunkel st #7 Description

Available Utilities

Map Location of 141 dunkel st #7

Off Post Housing

Off Post Resources

On Post Resources

Quick Links

Joomla! Debug Console

Database Queries

45 Queries Logged 297.49 ms

15 duplicate found!