Portfolio | Hamta Partners

“Hamta Partners completely renovated my 35 year-old townhouse. They are a talented team of an architect, interior designer, and General Contractor. They made the process head-ache free and they exceeded all my expectations in terms of taste and quality of work. The project was completed on time and on budget. I would highly recommend them and use them again on future projects.”
- Aamidi -

“I hired Hamta Inc to upgrade my downstairs bathroom. They gave me a very reasonable price. They finished within their estimated time limit. Every time I had a concern or suggestion they were always available and patient with me. I'm very happy with the company and also the result.”
- ljackson -

“Hamta Partners INC exceeded my expectations in every aspect! I am a very picky person so it was hard for me to trust just anyone's taste in remodeling my new home, but after a few consultations with their interior designer and architect, I knew I was in great hands. I fully remodeled my kitchen, living room and bathroom with them. They did such an amazing job!! My kitchen looks so chic, not even comparable to what it used to be. They have an excellent taste in design and material, the combination of materials they chose for my home turned out to be so unique and modern which is exactly what I had hoped for. They were truly professional, easy to talk to, and always there to answer my questions. I am so impressed with the results, I feel like I am living in a model home straight out of a magazine!!”
- sminal -

“We had a 3 unit renovation/remodeling project in San Francisco and HAMTA was hired as the general contractor. While we had lots of challenges typical to a project like this in a difficult city as San Francisco, the partners were very patient, honest and easy to communicate with. They did their best to keep cost as close to the estimates on the work orders and deliver the work within the timelines promised. They were very professional through out. We had some serious delays and challenges due to the city and subcontractors, which they handled very professionally. I highly recommend working with them.”
- hakimilawgroup -

“The team at Hamta Parters is excellent. My wife I and just purchased a town home and needed a great team to help us make the space our own. Hamta went above and beyond our expectations. Our place looks amazing, we highly recommend Hampta Partners.”
- Forest Zukerman -

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 40.82 ms / 40.82 ms Memory: 0.534 MB / 0.87 MB Application: afterLoad

Time: 106.78 ms / 147.60 ms Memory: 0.966 MB / 1.84 MB Application: afterInitialise

Time: 28.79 ms / 176.40 ms Memory: 0.317 MB / 2.16 MB Application: afterRoute

Time: 13.61 ms / 190.00 ms Memory: 0.057 MB / 2.21 MB Application: beforeRenderComponent com_content

Time: 10.55 ms / 200.55 ms Memory: 0.115 MB / 2.33 MB Application: Before Access::preloadComponents (all components)

Time: 3.61 ms / 204.17 ms Memory: 0.052 MB / 2.38 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 204.20 ms Memory: 0.000 MB / 2.38 MB Application: Before Access::preloadPermissions (com_content)

Time: 1.76 ms / 205.96 ms Memory: 0.021 MB / 2.40 MB Application: After Access::preloadPermissions (com_content)

Time: 0.03 ms / 205.99 ms Memory: 0.001 MB / 2.40 MB Application: Before Access::getAssetRules (id:109 name:com_content.article.12)

Time: 1.72 ms / 207.71 ms Memory: 0.009 MB / 2.41 MB Application: After Access::getAssetRules (id:109 name:com_content.article.12)

Time: 78.68 ms / 286.38 ms Memory: 0.476 MB / 2.88 MB Application: afterRenderComponent com_content

Time: 3.25 ms / 289.63 ms Memory: 0.008 MB / 2.89 MB Application: afterDispatch

Time: 10.05 ms / 299.68 ms Memory: 0.070 MB / 2.96 MB Application: beforeRenderModule mod_custom (Footer)

Time: 1.54 ms / 301.23 ms Memory: 0.006 MB / 2.97 MB Application: afterRenderModule mod_custom (Footer)

Time: 0.05 ms / 301.28 ms Memory: 0.000 MB / 2.97 MB Application: beforeRenderModule mod_chronoforms (Contact Form)

Time: 28.89 ms / 330.17 ms Memory: 0.163 MB / 3.13 MB Application: afterRenderModule mod_chronoforms (Contact Form)

Time: 0.07 ms / 330.24 ms Memory: 0.000 MB / 3.12 MB Application: beforeRenderModule mod_custom (Site - Testimonials)

Time: 0.33 ms / 330.57 ms Memory: 0.004 MB / 3.13 MB Application: afterRenderModule mod_custom (Site - Testimonials)

Time: 0.08 ms / 330.64 ms Memory: 0.001 MB / 3.13 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 5.17 ms / 335.81 ms Memory: 0.034 MB / 3.16 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.06 ms / 335.87 ms Memory: 0.000 MB / 3.16 MB Application: beforeRenderModule mod_custom (Site - Phone Top)

Time: 0.31 ms / 336.18 ms Memory: 0.003 MB / 3.16 MB Application: afterRenderModule mod_custom (Site - Phone Top)

Time: 0.04 ms / 336.22 ms Memory: 0.000 MB / 3.16 MB Application: beforeRenderModule mod_custom (Site - Logo)

Time: 0.29 ms / 336.51 ms Memory: 0.003 MB / 3.17 MB Application: afterRenderModule mod_custom (Site - Logo)

Time: 0.04 ms / 336.55 ms Memory: 0.000 MB / 3.17 MB Application: beforeRenderModule mod_custom (Portfolio - Top Bg)

Time: 0.28 ms / 336.84 ms Memory: 0.003 MB / 3.17 MB Application: afterRenderModule mod_custom (Portfolio - Top Bg)

Time: 2.20 ms / 339.03 ms Memory: 0.057 MB / 3.22 MB Application: afterRender

Database queries total: 63.92 ms

Memory Usage

Database Queries

24 Queries Logged 63.92 ms

Query Time: 2.42 ms Query memory: 0.020 MB Memory before query: 1.296 MB Rows returned: 0

SELECT `session_id`

  FROM `r6mvg_session`

  WHERE `session_id` = '1dcc6ca384084e240bcfe0b9b7d91a6e' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.26 ms
checking permissions	0.03 ms
Opening tables	0.96 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.07 ms
Unlocking tables	0.03 ms
closing tables	0.06 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.03 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 1.41 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.302 MB

INSERT INTO `r6mvg_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('1dcc6ca384084e240bcfe0b9b7d91a6e', 1, 1713589408, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `r6mvg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('1dcc6ca384084e240bcfe0b9b7d91a6e', 1, 1713589408, 0, '', 0)

Profile

Status	Duration
Starting	0.28 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init for update	0.04 ms
Update	0.26 ms
Waiting for query cache lock	0.03 ms
Update	0.03 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.07 ms
closing tables	0.04 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

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: 3.80 ms After last query: 7.43 ms Query memory: 0.024 MB Memory before query: 1.397 MB Rows returned: 35

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

  FROM `r6mvg_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r6mvg_extensions	ref	extension	extension	82	const	35	Using index condition; Using where

Profile

Status	Duration
Starting	0.24 ms
checking permissions	0.03 ms
Opening tables	0.79 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.09 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	1.49 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.20 ms After last query: 6.43 ms Query memory: 0.021 MB Memory before query: 1.422 MB Rows returned: 5

SELECT id, rules

  FROM `r6mvg_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.03 ms
Opening tables	0.69 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.07 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.14 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 2.44 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.434 MB Rows returned: 2

SELECT b.id

  FROM r6mvg_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.03 ms
Opening tables	0.77 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.06 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.14 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 3.66 ms After last query: 2.04 ms Query memory: 0.030 MB Memory before query: 1.455 MB Rows returned: 75

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

  FROM r6mvg_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	2.35 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.05 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.43 ms After last query: 31.85 ms Query memory: 0.048 MB Memory before query: 1.928 MB Rows returned: 26

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	29	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	hamtapartners_prod24.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.29 ms
checking permissions	0.03 ms
Opening tables	0.86 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.10 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.95 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.50 ms After last query: 20.79 ms Query memory: 0.022 MB Memory before query: 2.173 MB Rows returned: 1

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

  FROM `r6mvg_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.26 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.22 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.06 ms
Freeing items	0.19 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 1.36 ms After last query: 0.16 ms Query memory: 0.005 MB Memory before query: 2.165 MB

UPDATE `r6mvg_extensions`

  SET `params` = '{\"mediaversion\":\"42ff0f3421eaae31d334f37303ccfac5\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init for update	0.13 ms
Updating	0.17 ms
End of update loop	0.03 ms
Waiting for query cache lock	0.03 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.07 ms
closing tables	0.05 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

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:1129
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.44 ms After last query: 4.50 ms Query memory: 0.019 MB Memory before query: 2.196 MB Rows returned: 1

SELECT *

  FROM r6mvg_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.35 ms
checking permissions	0.04 ms
Opening tables	0.70 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.08 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.07 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 2.42 ms After last query: 0.23 ms Query memory: 0.019 MB Memory before query: 2.208 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM r6mvg_template_styles as s

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

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

Explain

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

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.03 ms
Opening tables	0.55 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.06 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.43 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 3.41 ms After last query: 10.84 ms Query memory: 0.027 MB Memory before query: 2.331 MB Rows returned: 35

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

  FROM `r6mvg_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r6mvg_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

Status	Duration
Starting	0.35 ms
checking permissions	0.04 ms
Opening tables	0.85 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.05 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.09 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
init	0.08 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.64 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.07 ms
Starting cleanup	0.06 ms
Freeing items	0.25 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.61 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 2.377 MB Rows returned: 15

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

  FROM `r6mvg_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r6mvg_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

Status	Duration
Starting	0.24 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.18 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.28 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.68 ms After last query: 3.66 ms Query memory: 0.031 MB Memory before query: 2.472 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `r6mvg_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `r6mvg_content`

Profile

Status	Duration
Starting	0.30 ms
checking permissions	0.04 ms
closing tables	0.04 ms
Opening tables	0.83 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.03 ms
Opening tables	0.96 ms
After opening tables	0.04 ms
checking permissions	0.17 ms
closing tables	0.04 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Removing tmp table	0.20 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.20 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.83 ms After last query: 7.58 ms Query memory: 0.022 MB Memory before query: 2.523 MB Rows returned: 1

SELECT *

  FROM r6mvg_content

  WHERE `id` = '12'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r6mvg_content	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.30 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.11 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.21 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.40 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 2.533 MB

UPDATE r6mvg_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '12'

Explain

EXPLAIN not possible on query: UPDATE r6mvg_content SET `hits` = (`hits` + 1) WHERE `id` = '12'

Profile

Status	Duration
Starting	0.28 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init for update	0.08 ms
Updating	0.15 ms
End of update loop	0.03 ms
Waiting for query cache lock	0.03 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.09 ms
closing tables	0.04 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.19 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.31 ms After last query: 3.26 ms Query memory: 0.024 MB Memory before query: 2.560 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM r6mvg_content AS a

  INNER JOIN r6mvg_categories AS c 
  on c.id = a.catid

  LEFT JOIN r6mvg_users AS u 
  on u.id = a.created_by

  LEFT JOIN r6mvg_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN r6mvg_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 12 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 05:03:28') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 05:03:28') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Profile

Status	Duration
Starting	0.47 ms
checking permissions	0.03 ms
Opening tables	2.16 ms
After opening tables	0.04 ms
System lock	0.04 ms
table lock	0.05 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.14 ms
Unlocking tables	0.04 ms
closing tables	0.03 ms
init	0.08 ms
Optimizing	0.07 ms
Statistics	0.19 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.22 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.26 ms After last query: 4.63 ms Query memory: 0.022 MB Memory before query: 2.670 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `r6mvg_contentitem_tag_map` AS m 

  INNER JOIN `r6mvg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 12 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hamtapartners_prod24.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.35 ms
checking permissions	0.03 ms
Opening tables	1.33 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.12 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.23 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.07 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.09 ms After last query: 15.95 ms Query memory: 0.026 MB Memory before query: 2.779 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `r6mvg_categories` AS `s`

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

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

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
Starting	0.37 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
init	0.10 ms
Optimizing	0.07 ms
Statistics	0.40 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.17 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.08 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.78 ms After last query: 1.02 ms Query memory: 0.025 MB Memory before query: 2.800 MB Rows returned: 0

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

  FROM r6mvg_fields AS a

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

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

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

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

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

  LEFT JOIN `r6mvg_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.39 ms
checking permissions	0.03 ms
Opening tables	1.65 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.12 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.07 ms
Optimizing	0.07 ms
Statistics	0.32 ms
Preparing	0.07 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.07 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.95 ms After last query: 29.90 ms Query memory: 0.024 MB Memory before query: 2.933 MB Rows returned: 9

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

  FROM r6mvg_modules AS m

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

  LEFT JOIN r6mvg_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 <= '2024-04-20 05:03:28') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 05:03:28') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 136 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	43	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	hamtapartners_prod24.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	hamtapartners_prod24.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.30 ms
checking permissions	0.03 ms
Opening tables	1.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.05 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.09 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.06 ms
Optimizing	0.07 ms
Statistics	0.16 ms
Preparing	0.08 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	2.13 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.19 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/hamta2015/index.php:135
7	require JROOT/templates/hamta2015/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
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: 2.30 ms After last query: 7.84 ms Query memory: 0.023 MB Memory before query: 3.046 MB Rows returned: 1

SELECT * 
  FROM `r6mvg_chronoforms` 
  WHERE `name` = 'frm_contact' 
  AND `published` = '1' 
  ORDER BY `id` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r6mvg_chronoforms	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.27 ms
checking permissions	0.03 ms
Opening tables	0.75 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.06 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.22 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/components/com_chronoforms/libraries/chronoform.php:74
14	CFChronoForm->getForm()	JROOT/components/com_chronoforms/libraries/chronoform.php:48
13	CFChronoForm->__construct()	JROOT/components/com_chronoforms/libraries/chronoform.php:62
12	CFChronoForm::getInstance()	JROOT/modules/mod_chronoforms/helper.php:15
11	modChronoFormsHelper::_displayForm()	JROOT/modules/mod_chronoforms/mod_chronoforms.php:57
10	include JROOT/modules/mod_chronoforms/mod_chronoforms.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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
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: 2.86 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 3.066 MB Rows returned: 10

SELECT * 
  FROM `r6mvg_chronoform_actions` 
  WHERE `chronoform_id` = '1' 
  ORDER BY `
  order`

Explain

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

Profile

Status	Duration
Starting	0.26 ms
checking permissions	0.04 ms
Opening tables	0.62 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.05 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.07 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.58 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
Starting cleanup	0.11 ms
Freeing items	0.20 ms
Updating status	0.07 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_chronoforms/libraries/chronoform.php:86
14	CFChronoForm->getForm()	JROOT/components/com_chronoforms/libraries/chronoform.php:48
13	CFChronoForm->__construct()	JROOT/components/com_chronoforms/libraries/chronoform.php:62
12	CFChronoForm::getInstance()	JROOT/modules/mod_chronoforms/helper.php:15
11	modChronoFormsHelper::_displayForm()	JROOT/modules/mod_chronoforms/mod_chronoforms.php:57
10	include JROOT/modules/mod_chronoforms/mod_chronoforms.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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
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: 1.37 ms After last query: 3.95 ms Query memory: 0.023 MB Memory before query: 3.096 MB Rows returned: 1

SELECT * 
  FROM `r6mvg_extensions` 
  WHERE `element` = 'com_chronoforms' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r6mvg_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.23 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.17 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_chronoforms/libraries/chronoform.php:358
13	CFChronoForm->__checkVal()	JROOT/components/com_chronoforms/libraries/chronoform.php:243
12	CFChronoForm->process()	JROOT/modules/mod_chronoforms/helper.php:28
11	modChronoFormsHelper::_displayForm()	JROOT/modules/mod_chronoforms/mod_chronoforms.php:57
10	include JROOT/modules/mod_chronoforms/mod_chronoforms.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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
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.]

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `r6mvg_assets`

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

1 × SELECT `session_id` 
  FROM `r6mvg_session`

1 × SELECT * 
  FROM `r6mvg_chronoform_actions`

1 × SELECT * 
  FROM `r6mvg_chronoforms`

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

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM r6mvg_fields AS a 
  LEFT JOIN `r6mvg_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN r6mvg_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN r6mvg_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN r6mvg_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN r6mvg_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `r6mvg_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `r6mvg_categories` AS `s` 
  INNER JOIN `r6mvg_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `r6mvg_contentitem_tag_map` AS m  
  INNER JOIN `r6mvg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

```
1 × SELECT * 
  FROM r6mvg_content
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM r6mvg_content AS a 
  INNER JOIN r6mvg_categories AS c 
  on c.id = a.catid 
  LEFT JOIN r6mvg_users AS u 
  on u.id = a.created_by 
  LEFT JOIN r6mvg_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN r6mvg_content_rating AS v 
  ON a.id = v.content_id

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

```
1 × SELECT * 
  FROM r6mvg_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 r6mvg_menu AS m 
  LEFT JOIN r6mvg_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `r6mvg_viewlevels

1 × SELECT * 
  FROM `r6mvg_extensions`

OTHER Tables:

1 × INSERT INTO `r6mvg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('1dcc6ca384084e240bcfe0b9b7d91a6e', 1, 1713589408, 0, '', 0

1 × UPDATE `r6mvg_extensions` 
  SET `params` = '{\"mediaversion\":\"42ff0f3421eaae31d334f37303ccfac5\"}'

1 × SHOW FULL COLUMNS 
  FROM `r6mvg_content

1 × UPDATE r6mvg_content 
  SET `hits` = (`hits` + 1)

Mill Valley Project

CA

Idylberry Rd

San Rafael

Page Street

San Francisco

Thorsen CT

Los Altos

FOLSOM AVE

San Francisco

Barneson Ave

San Mateo

Occidental Ave

San Mateo

Birch Ave

San Mateo

Sandhill CIR

Menlo Park

Portofino DR

San Carlos

Milbare Ave

Milbare

Churchil Ave

Hillsborough

Old Japaneess RD

Los Gatos

Bauer Street

San Carlos

San Jose

CA

Office Space

Glendale

WHAT OUR CUSTOMERSSAY ABOUT US

CONTACT

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

24 Queries Logged 63.92 ms

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

WHAT OUR CUSTOMERS
SAY ABOUT US