Join the Arpan Family

See Our Classes

Shine on Stage

Learn about our Performances

Reach the Finish Line

Learn About Our Arangetrams

In the Company of Experts

Meet our Team

ARPAN

Arpan (say "Ur-Pun") in Sanskrit means to present or to offer in dedication. Our efforts are an offering (Arpan) to the entire community in Seattle, WA right from the inner depths of a diverse cultural melting pot that is India.

Our Mission

Arpan Dance Theatre is a performing arts organization dedicated to promoting the Folk & Classical traditions of India including dance, music, theatre, puppetry, folklore, traditions and values. We strive to bring together like-minded artists who value traditions passed down through the ages while thinking out of the box to create works that have relevance to our modern lives.

Our Academy

Through our academy arm, our mission is to create next-gen dancers who are highly trained not just in technique but are empowered in mind and spirit to make a difference.

At Arpan , we try to stay away from 'filmi' 'techno' interpretations because it is just not our expertise!

Our Quest

Our creative director is on a quest to make a difference in building awareness through the performing arts about social issues such as nature conservancy, domestic violence, mental health, body image among dancers and building empathy.

For more about her works, please visit www.dance.joycekpaul.com

Meet the Team

Joyce Paul Siamak
Founder & Artistic Director
Namaste! I love teaching and helping others find joy through rhythm, melody, movement and meditation.
Stepanka Newman
Teaching Assistant
Namaste! I am Stepanka, disciple of Dr. Joyce Paul Siamak. I love Indian philosophy, music & dance and enjoy teaching at Arpan. I am honoured to hone my art with Guruji.
Savitha Srinivasan
Student Teaching Assistant
Savitha's passion for Bharatanatyam is evident in her deep involvement in all things dance. A fan of Van Gogh, she has been been running "Handmade by Savitha" since she was 5!

Our Classes

Classes at ARPAN are based on our Director's extensive knowledge of the human body, its physiology, movement and over three decades of training and practice in Bharatanatyam and Mohiniyattam.

Technique Classes

Technique classes (Beginner, Intermediate, Senior and Advanced) are held throughout the week. Polish your Angashuddham, learn about math, geometry in space and kinaesthetics of nritta.

Repertoire Classes

Repertoire classes include the typical Kalakshetra margam pieces. Also taught are concepts of choreography and acclaimed choreographic works by Dr. Joyce Paul Siamak.

Personal Intensives with the Choreographer

Personal sessions with the choreographer help you fine tune your dancing and learn intimate details of the process of choreography. Brainstorm your own concepts and bring them to life in this unique class.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1760730737,
                "last": 1760730737,
                "now": 1760730737
            },
            "token": "RpaYan4FANLNcIsfmOEMTc9viZJrMIkr"
        },
        "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

Memory Usage

Database Queries

27 Queries Logged 33.38 ms

14 duplicate found!

3 duplicates: #5 #18 #19

3 duplicates: #11 #12 #13

2 duplicates: #16 #17

3 duplicates: #21 #23 #25

3 duplicates: #22 #24 #26

Query Time: 0.89 ms Query memory: 0.023 MB Memory before query: 1.031 MB Rows returned: 1

SELECT `data`

  FROM `arpanarts_session`

  WHERE `session_id` = X'6230306139326164326639303430653136633332346235656438323130356639'

Explain

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

Profile

Status	Duration
starting	0.22 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.03 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.03 ms
end	0.02 ms
query end	0.04 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.04 ms

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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.70 ms After last query: 1.45 ms Query memory: 0.021 MB Memory before query: 1.198 MB Rows returned: 6

SELECT id, rules

  FROM `arpanarts_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.09 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.05 ms

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:318
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:225
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.80 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.210 MB Rows returned: 2

SELECT b.id

  FROM arpanarts_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

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:318
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:225
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: 13.94 ms Query memory: 0.007 MB Memory before query: 1.668 MB

UPDATE `arpanarts_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.24 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.15 ms
updating	0.11 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	1.54 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
8	plgSystemHelix->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:668
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:225
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.80 ms After last query: 2.91 ms Query memory: 0.021 MB Memory before query: 1.858 MB Rows returned: 1

Duplicate queries: #18 #19

SELECT `template`

  FROM `arpanarts_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	16.67	Using where

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.02 ms
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.07 ms
executing	0.06 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->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:668
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:225
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.49 ms After last query: 12.31 ms Query memory: 0.028 MB Memory before query: 2.181 MB Rows returned: 44

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

  FROM `arpanarts_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_flexicontact','com_formmaker','com_installer','com_jce','com_jevents','com_jevlocations','com_joomlaupdate','com_k2','com_kunena','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_speasyimagegallery','com_sppagebuilder','com_tags','com_templates','com_timetable','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	162	28.40	Using where

Profile

Status	Duration
starting	0.25 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.06 ms
executing	0.45 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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_sppagebuilder/models/page.php:33
11	SppagebuilderModelPage->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_sppagebuilder/models/page.php:140
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:78
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.14 ms After last query: 2.58 ms Query memory: 0.027 MB Memory before query: 2.314 MB Rows returned: 25

SHOW FULL COLUMNS 
  FROM `arpanarts_sppagebuilder`

Explain

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

Profile

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	1.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.99 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.09 ms
executing	0.12 ms
checking permissions	0.09 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.11 ms
checking permissions	0.08 ms
checking permissions	0.07 ms
checking permissions	0.07 ms
checking permissions	0.07 ms
checking permissions	0.06 ms
checking permissions	0.08 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.07 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
checking permissions	0.06 ms
checking permissions	0.09 ms
checking permissions	0.09 ms
checking permissions	0.09 ms
checking permissions	0.08 ms
checking permissions	0.07 ms
checking permissions	0.09 ms
checking permissions	0.10 ms
checking permissions	0.07 ms
checking permissions	0.07 ms
checking permissions	0.09 ms
checking permissions	0.16 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.05 ms
freeing items	0.14 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:18
11	SppagebuilderTablePage->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:141
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:78
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 1.51 ms Query memory: 0.092 MB Memory before query: 2.352 MB Rows returned: 1

SELECT *

  FROM arpanarts_sppagebuilder

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_sppagebuilder	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.07 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_sppagebuilder/models/page.php:142
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:78
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.32 ms Query memory: 0.006 MB Memory before query: 2.391 MB

UPDATE arpanarts_sppagebuilder

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

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.07 ms
updating	0.10 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	1.11 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_sppagebuilder/models/page.php:143
9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:78
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.16 ms After last query: 4.55 ms Query memory: 0.093 MB Memory before query: 2.399 MB Rows returned: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM arpanarts_sppagebuilder as a

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

  LEFT JOIN arpanarts_users AS ua 
  ON ua.id = a.created_by

  WHERE a.id = 1 
  AND a.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
1	SIMPLE	l	NULL	const	idx_langcode	idx_langcode	28	const	0	0.00	unique row not found
1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.03 ms
executing	0.09 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.06 ms
freeing items	0.11 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:86
13	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:27
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.65 ms Query memory: 0.024 MB Memory before query: 2.441 MB Rows returned: 5

Duplicate queries: #12 #13

SELECT `id`

  FROM `arpanarts_menu`

  WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=1%' 
  AND `published` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	116	1.11	Using where

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.22 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/helpers/route.php:95
15	SppagebuilderHelperRoute::getMenuItemId()	JROOT/components/com_sppagebuilder/helpers/route.php:52
14	SppagebuilderHelperRoute::getPageRoute()	JROOT/components/com_sppagebuilder/models/page.php:95
13	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:27
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.69 ms After last query: 1.02 ms Query memory: 0.024 MB Memory before query: 2.451 MB Rows returned: 5

Duplicate queries: #11 #13

SELECT `id`

  FROM `arpanarts_menu`

  WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=1%' 
  AND `published` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	116	1.11	Using where

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.18 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/helpers/route.php:95
15	SppagebuilderHelperRoute::getMenuItemId()	JROOT/components/com_sppagebuilder/helpers/route.php:74
14	SppagebuilderHelperRoute::getFormRoute()	JROOT/components/com_sppagebuilder/models/page.php:96
13	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:27
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 2.459 MB Rows returned: 5

Duplicate queries: #11 #12

SELECT `id`

  FROM `arpanarts_menu`

  WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=1%' 
  AND `published` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	116	1.11	Using where

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.15 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.04 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/helpers/route.php:95
15	SppagebuilderHelperRoute::getMenuItemId()	JROOT/components/com_sppagebuilder/helpers/route.php:76
14	SppagebuilderHelperRoute::getFormRoute()	JROOT/components/com_sppagebuilder/models/page.php:96
13	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:27
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.74 ms After last query: 0.30 ms Query memory: 0.024 MB Memory before query: 2.468 MB Rows returned: 3

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

  FROM `arpanarts_assets`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	162	25.71	Using where

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.03 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.14 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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_sppagebuilder/views/page/view.html.php:29
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.38 ms After last query: 5.82 ms Query memory: 0.027 MB Memory before query: 2.500 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `arpanarts_assets`

Explain

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

Profile

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.03 ms
starting	1.15 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	1.21 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.05 ms
statistics	0.17 ms
preparing	0.07 ms
Creating tmp table	0.11 ms
executing	0.17 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.12 ms
checking permissions	0.08 ms
checking permissions	0.07 ms
checking permissions	0.08 ms
checking permissions	0.08 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.08 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
16	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
15	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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_sppagebuilder/views/page/view.html.php:29
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.25 ms Query memory: 0.024 MB Memory before query: 2.522 MB Rows returned: 0

Duplicate queries: #17

SELECT *

  FROM arpanarts_assets

  WHERE `name` = 'com_sppagebuilder.page.1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	0.03 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
15	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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_sppagebuilder/views/page/view.html.php:29
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.22 ms Query memory: 0.025 MB Memory before query: 2.532 MB Rows returned: 0

Duplicate queries: #16

SELECT *

  FROM arpanarts_assets

  WHERE `name` = 'com_sppagebuilder.page.1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
15	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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_sppagebuilder/views/page/view.html.php:30
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.03 ms After last query: 6.65 ms Query memory: 0.025 MB Memory before query: 2.626 MB Rows returned: 1

Duplicate queries: #5 #19

SELECT `template`

  FROM `arpanarts_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	16.67	Using where

Profile

Status	Duration
starting	0.23 ms
Executing hook on transaction	0.03 ms
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.10 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:831
17	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
16	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:959
15	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:18
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 98.39 ms Query memory: 0.025 MB Memory before query: 2.985 MB Rows returned: 1

Duplicate queries: #5 #18

SELECT `template`

  FROM `arpanarts_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	16.67	Using where

Profile

Status	Duration
starting	0.27 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.07 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:43
17	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:51
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.32 ms After last query: 5.78 ms Query memory: 0.026 MB Memory before query: 3.122 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id

  FROM (
SELECT id,title,level,published,parent_id,lft,rgt

  FROM arpanarts_tags

  WHERE `published` = '1') AS a

  LEFT JOIN `arpanarts_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE `a`.`level` != '0'

  ORDER BY a.lft ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	arpanarts_tags	NULL	ref	tag_idx	tag_idx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	b	NULL	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Range checked for each record (index map: 0x10); Distinct

Profile

Status	Duration
starting	0.27 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.15 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
executing	0.12 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.03 ms
closing tables	0.05 ms
freeing items	0.09 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:265
18	SpPgaeBuilderBase::getArticleTags()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:165
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.99 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 3.192 MB Rows returned: 1

Duplicate queries: #23 #25

SELECT a.enabled

  FROM `arpanarts_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	290	10.00	Using where

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.39 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:702
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:174
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.74 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 3.200 MB Rows returned: 0

Duplicate queries: #24 #26

SELECT m.* 
  FROM arpanarts_k2_categories m 
  WHERE trash = 0 
  ORDER BY parent, ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	trash	trash	2	const	1	100.00	Using filesort

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.06 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:711
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:174
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.94 ms After last query: 1.36 ms Query memory: 0.026 MB Memory before query: 3.218 MB Rows returned: 1

Duplicate queries: #21 #25

SELECT a.enabled

  FROM `arpanarts_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	290	10.00	Using where

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.35 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:702
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:281
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.05 ms Query memory: 0.026 MB Memory before query: 3.226 MB Rows returned: 0

Duplicate queries: #22 #26

SELECT m.* 
  FROM arpanarts_k2_categories m 
  WHERE trash = 0 
  ORDER BY parent, ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	trash	trash	2	const	1	100.00	Using filesort

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.04 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:711
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:281
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.02 ms After last query: 1.60 ms Query memory: 0.026 MB Memory before query: 3.266 MB Rows returned: 1

Duplicate queries: #21 #23

SELECT a.enabled

  FROM `arpanarts_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	290	10.00	Using where

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.35 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:702
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
17	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.69 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 3.274 MB Rows returned: 0

Duplicate queries: #22 #24

SELECT m.* 
  FROM arpanarts_k2_categories m 
  WHERE trash = 0 
  ORDER BY parent, ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	trash	trash	2	const	1	100.00	Using filesort

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.06 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:711
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
17	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 32.02 ms Query memory: 0.026 MB Memory before query: 4.013 MB Rows returned: 0

SELECT a.enabled

  FROM `arpanarts_extensions` AS `a`

  WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	100.00	Using index condition

Profile

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:615
18	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
17	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:82
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:244
15	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
14	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:48
11	SppagebuilderViewPage->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:81
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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:225
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.]

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT a.enabled 
  FROM `arpanarts_extensions` AS `a`

3 × SELECT `template` 
  FROM `arpanarts_template_styles`

3 × SELECT `id` 
  FROM `arpanarts_menu`

3 × SELECT m.* 
  FROM arpanarts_k2_categories m

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

```
2 × SELECT * 
  FROM arpanarts_assets
```

1 × SELECT `data` 
  FROM `arpanarts_session`

1 × SELECT id, rules 
  FROM `arpanarts_viewlevels

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

1 × SELECT * 
  FROM arpanarts_sppagebuilder

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM arpanarts_sppagebuilder as a 
  LEFT JOIN `arpanarts_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN arpanarts_users AS ua 
  ON ua.id = a.created_by

1 × SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id 
  FROM ( SELECT id,title,level,published,parent_id,lft,rgt 
  FROM arpanarts_tags

OTHER Tables:

1 × UPDATE `arpanarts_extensions` 
  SET `params` = '{\"mediaversion\":\"b0d7d28937868fa52caf32598b5cb8a5\"}'

1 × SHOW FULL COLUMNS 
  FROM `arpanarts_sppagebuilder

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

1 × SHOW FULL COLUMNS 
  FROM `arpanarts_assets

Join the Arpan Family

Shine on Stage

Reach the Finish Line

In the Company of Experts

ARPAN

Arpan (say "Ur-Pun") in Sanskrit means to present or to offer in dedication. Our efforts are an offering (Arpan) to the entire community in Seattle, WA right from the inner depths of a diverse cultural melting pot that is India.

Our Mission

Our Academy

Our Quest

Meet the Team

Joyce Paul Siamak

Stepanka Newman

Savitha Srinivasan

Our Classes

Technique Classes

Repertoire Classes

Personal Intensives with the Choreographer

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

27 Queries Logged 33.38 ms

14 duplicate found!

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: