Schindler's Ark | Schindler's List | One Hero Among The Nation

Donate

CALL US: 800-208-0219

Our Vision

We are a Christian Zionist ministry whose vision is to build an alliance between Christians and Jews, Israel and the USA. We share God's vision for the in-gathering of the Jews to their homeland, the natural and spiritual restoration of the nation of Israel and Israel’s right to defend itself as a sovereign nation and biblical restoration.

our mission

What We Do

We host tours to Israel and the Holy Lands, arrange conferences, events and support pro-Israel organizations and causes. We teach about our Hebraic roots and work to connect Christians to Israel and their biblical faith. We promote reconciliation on behalf of Christians to Jews and bring restitution to the people of Israel.

Give Today

Get Involved

Learn of the multiple ways to bless Israel and participate with us to strengthen our connection to the foundations of our faith. Enlist in our efforts to comfort and pray for Jerusalem, give to those in need, attend local and national solidarity events, come to Israel, and volunteer to be part of this miracle of restoration in the Holy Land.

Join Us

"SCHINDLER'S LIST" SURVIVORS INSPIRE MOVIE

Thomas Keneally wrote about Oskar Schindler righteous acts to save the lives of his Jewish workers during the Holocaust in his book “Schindler’s Ark”. It is based on the testimonies of the Schindler survivors who wanted to honor this brave German whose exceptional heroism saved over 1,000 of their lives. Steven Spielberg later made the movie “Schindler’s List”, emphasizing the Book of Life and the names God has written in it for eternal life.

Schindler's List opens with a close-up of hands lighting the Shabbat candles and the sound of a Hebrew prayer as darkness descends on the Jewish home. It is 1939 at the outset of the German forced relocation of Polish Jews to the Krakow ghetto. During this period, a German businessman from Moravia, Oskar Schindler, arrives in Krakow with the intent to make money from the Jews' relocation. A member of the Nazi party, Schindler entertains and praises SS officials in charge of procurement in ord...

Israel/Jerusalem Real Time

“We just returned to Israel are happy to report its better than ever! The nation continues
to be restored and all aspects of tourism are improved and developing, a fast forward
preparing the way of the Lord and becoming a Light to the World as a Biblical. Nation.”

Israelis and Tourists Both Celebrate as Visitors Return to the Holy Land in Pre-Pandemic Numbers” | CBN

Subscribe to Our Newsletter

Schindler's Society

“Many peoples will come and say, “Come, let us go up to the mountain of the Lord, to the temple of the God of Jacob. He will teach us his ways, so that we may walk in his paths.” The law will go out from Zion, the word of the Lord from Jerusalem”. ~ Isaiah 2:3

Learn More

ISRAEL TIMELINE

Celebrating over 3,000 years.

Help Become A Partner

Where do you feel called? Working with Holocaust history, aiding the Aliyah, joining a tour so the Bible come to life, comforting victims of terror, praying, advocating in our government, volunteering?

Read more >>

Upcoming Events

Check out our exciting speakers, conferences, tours and volunteer opportunities. Participate anywhere! We are here to serve you in providing opportunities to connect you with the people and land of Israel.

Read more >>

Donate To The Ministries

Your donations are personally distributed to those in need to provide you with a tangible connection in Israel. Experience God’s promises for you and your household which will be multiplied in marvelous ways.

Read more >>

Join us in the holy land and experience a modern miracle!

Join Us

Our Address:

2514 Jamacha Road
Suite 502-120
El Cajon, CA 92019

Contact Us

Phone:	800-208-0219
	510-677-4215

This email address is being protected from spambots. You need JavaScript enabled to view it.

Get Involved

S5 Box

Main Menu

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732174470,
                "last": 1732174470,
                "now": 1732174470
            }
        },
        "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: 36.16 ms / 36.16 ms Memory: 0.554 MB / 0.89 MB Application: afterLoad

Time: 86.77 ms / 122.93 ms Memory: 1.124 MB / 2.02 MB Application: afterInitialise

Time: 53.62 ms / 176.56 ms Memory: 0.343 MB / 2.36 MB Application: afterRoute

Time: 2.38 ms / 178.94 ms Memory: 0.031 MB / 2.39 MB Application: beforeRenderComponent com_content

Time: 13.16 ms / 192.10 ms Memory: 0.117 MB / 2.51 MB Application: Before Access::preloadComponents (all components)

Time: 1.08 ms / 193.18 ms Memory: 0.057 MB / 2.57 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 193.20 ms Memory: -0.003 MB / 2.56 MB Application: Before Access::preloadPermissions (com_content)

Time: 0.40 ms / 193.59 ms Memory: 0.055 MB / 2.62 MB Application: After Access::preloadPermissions (com_content)

Time: 0.02 ms / 193.61 ms Memory: -0.001 MB / 2.62 MB Application: Before Access::getAssetRules (id:73 name:com_content.article.34)

Time: 4.56 ms / 198.17 ms Memory: 0.009 MB / 2.63 MB Application: After Access::getAssetRules (id:73 name:com_content.article.34)

Time: 79.12 ms / 277.28 ms Memory: 0.489 MB / 3.11 MB Application: afterRenderComponent com_content

Time: 2.49 ms / 279.77 ms Memory: 0.008 MB / 3.12 MB Application: afterDispatch

Time: 56.67 ms / 336.45 ms Memory: 0.468 MB / 3.59 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Time: 1.78 ms / 338.22 ms Memory: 0.026 MB / 3.62 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 8.36 ms / 346.58 ms Memory: 0.014 MB / 3.63 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.60 ms / 347.18 ms Memory: -0.018 MB / 3.61 MB Application: afterRenderModule mod_s5_box (S5 Box)

Time: 0.07 ms / 347.25 ms Memory: -0.004 MB / 3.61 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 2.21 ms / 349.47 ms Memory: 0.014 MB / 3.62 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.10 ms / 349.57 ms Memory: -0.000 MB / 3.62 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Time: 0.98 ms / 350.55 ms Memory: 0.005 MB / 3.63 MB Application: afterRenderModule mod_menu (Bottom Menu)

Time: 0.06 ms / 350.61 ms Memory: -0.003 MB / 3.62 MB Application: beforeRenderModule mod_whosonline (Who's Online)

Time: 1.77 ms / 352.39 ms Memory: 0.034 MB / 3.66 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.05 ms / 352.44 ms Memory: 0.007 MB / 3.66 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 1.66 ms / 354.09 ms Memory: -0.010 MB / 3.65 MB Application: afterRenderModule mod_whosonline (Who's Online)

Time: 0.08 ms / 354.18 ms Memory: -0.002 MB / 3.65 MB Application: beforeRenderModule mod_menu (Get Involved)

Time: 1.40 ms / 355.58 ms Memory: 0.019 MB / 3.67 MB Application: afterRenderModule mod_menu (Get Involved)

Time: 0.07 ms / 355.64 ms Memory: -0.001 MB / 3.67 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 9.72 ms / 365.36 ms Memory: 0.006 MB / 3.68 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.08 ms / 365.44 ms Memory: -0.001 MB / 3.67 MB Application: beforeRenderModule mod_custom (Our Address:)

Time: 0.59 ms / 366.03 ms Memory: 0.004 MB / 3.68 MB Application: afterRenderModule mod_custom (Our Address:)

Time: 0.05 ms / 366.08 ms Memory: -0.001 MB / 3.68 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.48 ms / 366.56 ms Memory: 0.004 MB / 3.68 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.04 ms / 366.60 ms Memory: -0.001 MB / 3.68 MB Application: beforeRenderModule mod_custom (Get Involved)

Time: 0.37 ms / 366.97 ms Memory: 0.006 MB / 3.69 MB Application: afterRenderModule mod_custom (Get Involved)

Time: 0.04 ms / 367.00 ms Memory: -0.000 MB / 3.69 MB Application: beforeRenderModule mod_custom (Involvement Can Start Today)

Time: 0.41 ms / 367.41 ms Memory: 0.004 MB / 3.69 MB Application: afterRenderModule mod_custom (Involvement Can Start Today)

Time: 0.05 ms / 367.46 ms Memory: -0.001 MB / 3.69 MB Application: beforeRenderModule mod_custom (Israel/Jerusalem Real Time)

Time: 0.46 ms / 367.93 ms Memory: 0.004 MB / 3.69 MB Application: afterRenderModule mod_custom (Israel/Jerusalem Real Time)

Time: 0.02 ms / 367.95 ms Memory: -0.001 MB / 3.69 MB Application: beforeRenderModule mod_custom (Subscribe to Our Newsletter)

Time: 0.47 ms / 368.42 ms Memory: 0.004 MB / 3.70 MB Application: afterRenderModule mod_custom (Subscribe to Our Newsletter)

Time: 0.02 ms / 368.44 ms Memory: 0.002 MB / 3.70 MB Application: beforeRenderModule mod_custom (Schindler's Society)

Time: 0.43 ms / 368.87 ms Memory: 0.004 MB / 3.70 MB Application: afterRenderModule mod_custom (Schindler's Society)

Time: 0.02 ms / 368.89 ms Memory: 0.004 MB / 3.71 MB Application: beforeRenderModule mod_custom (ISRAEL TIMELINE)

Time: 0.43 ms / 369.31 ms Memory: 0.004 MB / 3.71 MB Application: afterRenderModule mod_custom (ISRAEL TIMELINE)

Time: 0.06 ms / 369.37 ms Memory: -0.001 MB / 3.71 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.23 ms / 371.60 ms Memory: 0.008 MB / 3.72 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.05 ms / 371.65 ms Memory: -0.003 MB / 3.71 MB Application: beforeRenderModule mod_custom (“Schindler’s List” survivors inspire movie)

Time: 0.61 ms / 372.26 ms Memory: 0.003 MB / 3.72 MB Application: afterRenderModule mod_custom (“Schindler’s List” survivors inspire movie)

Time: 0.06 ms / 372.32 ms Memory: 0.003 MB / 3.72 MB Application: beforeRenderModule mod_s5_imageslide (S5 Image Slide v2)

Time: 2.24 ms / 374.56 ms Memory: 0.027 MB / 3.75 MB Application: beforeRenderModule mod_custom (imageslide_1)

Time: 0.15 ms / 374.71 ms Memory: 0.003 MB / 3.75 MB Application: afterRenderModule mod_custom (imageslide_1)

Time: 0.01 ms / 374.72 ms Memory: -0.001 MB / 3.75 MB Application: beforeRenderModule mod_custom (imageslide_2)

Time: 0.11 ms / 374.84 ms Memory: 0.003 MB / 3.75 MB Application: afterRenderModule mod_custom (imageslide_2)

Time: 0.55 ms / 375.38 ms Memory: -0.006 MB / 3.75 MB Application: afterRenderModule mod_s5_imageslide (S5 Image Slide v2)

Time: 0.05 ms / 375.43 ms Memory: -0.010 MB / 3.74 MB Application: beforeRenderModule mod_custom (Get Involved)

Time: 0.41 ms / 375.84 ms Memory: 0.004 MB / 3.74 MB Application: afterRenderModule mod_custom (Get Involved)

Time: 0.04 ms / 375.88 ms Memory: -0.001 MB / 3.74 MB Application: beforeRenderModule mod_custom (What We Do)

Time: 0.38 ms / 376.26 ms Memory: 0.004 MB / 3.74 MB Application: afterRenderModule mod_custom (What We Do)

Time: 0.03 ms / 376.29 ms Memory: -0.000 MB / 3.74 MB Application: beforeRenderModule mod_custom (Our Vision)

Time: 0.36 ms / 376.65 ms Memory: 0.004 MB / 3.75 MB Application: afterRenderModule mod_custom (Our Vision)

Time: 0.05 ms / 376.70 ms Memory: 0.005 MB / 3.75 MB Application: beforeRenderModule mod_s5_image_and_content_fader (Image and Content Fader)

Time: 2.06 ms / 378.76 ms Memory: 0.015 MB / 3.77 MB Application: afterRenderModule mod_s5_image_and_content_fader (Image and Content Fader)

Time: 5.13 ms / 383.89 ms Memory: 0.171 MB / 3.94 MB Application: afterRender

Database queries total: 24.43 ms

Memory Usage

Database Queries

32 Queries Logged 24.43 ms

5 duplicate found!

3 duplicates: #8 #28 #29

2 duplicates: #26 #27

Query Time: 0.48 ms Query memory: 0.023 MB Memory before query: 1.366 MB Rows returned: 0

SELECT `data`

  FROM `htiur_session`

  WHERE `session_id` = X'3039316334623530313863663261316535623861613034316365316332633164'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.17 ms After last query: 2.12 ms Query memory: 0.020 MB Memory before query: 1.381 MB Rows returned: 0

SELECT `session_id`

  FROM `htiur_session`

  WHERE `session_id` = X'3039316334623530313863663261316535623861613034316365316332633164' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
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: 1.08 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 1.386 MB

INSERT INTO `htiur_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3039316334623530313863663261316535623861613034316365316332633164', 1, 1732174470, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `htiur_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3039316334623530313863663261316535623861613034316365316332633164', 1, 1732174470, 0, '', 0)

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.93 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
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.57 ms After last query: 4.63 ms Query memory: 0.025 MB Memory before query: 1.481 MB Rows returned: 41

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

  FROM `htiur_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	htiur_extensions	NULL	ref	extension	extension	82	const	41	1.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.28 ms After last query: 4.37 ms Query memory: 0.021 MB Memory before query: 1.508 MB Rows returned: 3

SELECT id, rules

  FROM `htiur_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.33 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.519 MB Rows returned: 1

SELECT b.id

  FROM htiur_usergroups AS a

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

  WHERE a.id = 1

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	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 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: 0.67 ms After last query: 1.72 ms Query memory: 0.030 MB Memory before query: 1.540 MB Rows returned: 96

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

  FROM htiur_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	htiur_extensions	NULL	ref	extension	extension	82	const	158	0.40	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.47 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
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.90 ms After last query: 33.20 ms Query memory: 0.048 MB Memory before query: 2.045 MB Rows returned: 21

Duplicate queries: #28 #29

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

  LEFT JOIN htiur_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	99	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	ark77_schindlersark.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.33 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
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:1141
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: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.41 ms After last query: 38.43 ms Query memory: 0.025 MB Memory before query: 2.345 MB Rows returned: 1

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

  FROM `htiur_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	htiur_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/twojtoolbox/twojtoolbox.php:59
8	plgSystemTwojToolbox->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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: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.35 ms After last query: 0.21 ms Query memory: 0.006 MB Memory before query: 2.338 MB

UPDATE `htiur_extensions`

  SET `params` = '{\"mediaversion\":\"7ce89d2d22a9fe50834a90d12b9f8042\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	htiur_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.06 ms
updating	0.07 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/twojtoolbox/twojtoolbox.php:59
8	plgSystemTwojToolbox->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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: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.77 ms After last query: 4.85 ms Query memory: 0.020 MB Memory before query: 2.357 MB Rows returned: 0

SELECT id

  FROM htiur_twojtoolbox_menu

  WHERE itemid = 101 OR itemid = -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.04 ms
checking permissions	0.00 ms
Opening tables	0.56 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/twojtoolbox/twojtoolbox.php:78
8	plgSystemTwojToolbox->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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: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.54 ms After last query: 0.73 ms Query memory: 0.019 MB Memory before query: 2.375 MB Rows returned: 1

SELECT *

  FROM htiur_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.71 ms After last query: 0.19 ms Query memory: 0.019 MB Memory before query: 2.387 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM htiur_template_styles as s

  LEFT JOIN htiur_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	9	66.67	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	ark77_schindlersark.s.template,const	1	4.50	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.87 ms After last query: 13.77 ms Query memory: 0.028 MB Memory before query: 2.512 MB Rows returned: 41

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

  FROM `htiur_assets`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.18 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.23 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
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:702
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: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.29 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 2.564 MB Rows returned: 50

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

  FROM `htiur_assets`

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
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:702
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: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.19 ms After last query: 12.01 ms Query memory: 0.031 MB Memory before query: 2.629 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `htiur_content`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.28 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 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/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
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:702
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: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: 7.59 ms Query memory: 0.006 MB Memory before query: 2.743 MB

UPDATE htiur_content

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

  WHERE `id` = '34'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	htiur_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.04 ms
updating	0.07 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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_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:702
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: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.18 ms After last query: 3.98 ms Query memory: 0.039 MB Memory before query: 2.769 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 htiur_content AS a

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

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

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

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

  WHERE a.id = 34 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 07:34:30') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 07:34:30') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.53 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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: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.87 ms After last query: 4.32 ms Query memory: 0.022 MB Memory before query: 2.878 MB Rows returned: 0

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

  FROM `htiur_contentitem_tag_map` AS m 

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

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

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.40 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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: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.68 ms After last query: 18.90 ms Query memory: 0.026 MB Memory before query: 2.995 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 `htiur_categories` AS `s`

  INNER JOIN `htiur_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) 
  AND c.published = 1 
  AND s.id = 8

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	22	9.92	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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: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.72 ms After last query: 1.26 ms Query memory: 0.025 MB Memory before query: 3.016 MB Rows returned: 0

SELECT DISTINCT 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 htiur_fields AS a

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

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

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

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

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

  LEFT JOIN `htiur_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 (8,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.53 ms
init	0.12 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.21 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.31 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
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:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
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:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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: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.19 ms After last query: 34.89 ms Query memory: 0.022 MB Memory before query: 3.177 MB Rows returned: 1

SELECT * 
  FROM htiur_template_styles 
  WHERE template = 'bigpicture';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	htiur_template_styles	NULL	ref	idx_template	idx_template	202	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/templates/bigpicture/vertex/parameters.php:20
9	getTemplateName()	JROOT/templates/bigpicture/vertex/parameters.php:169
8	require JROOT/templates/bigpicture/vertex/parameters.php	JROOT/templates/bigpicture/index.php:21
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 3.184 MB Rows returned: 0

SELECT * 
  FROM htiur_menu 
  WHERE template_style_id IN (12) 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.20 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/templates/bigpicture/vertex/parameters.php:45
9	getTemplateName()	JROOT/templates/bigpicture/vertex/parameters.php:169
8	require JROOT/templates/bigpicture/vertex/parameters.php	JROOT/templates/bigpicture/index.php:21
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 10.35 ms Query memory: 0.021 MB Memory before query: 3.285 MB Rows returned: 1

SELECT title 
  FROM htiur_content 
  WHERE id=34

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/templates/bigpicture/vertex/module_calcs.php:30
8	require JROOT/templates/bigpicture/vertex/module_calcs.php	JROOT/templates/bigpicture/index.php:23
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.54 ms After last query: 2.73 ms Query memory: 0.043 MB Memory before query: 3.314 MB Rows returned: 30

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

  FROM htiur_modules AS m

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

  LEFT JOIN htiur_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-11-21 07:34:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 07:34:30') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	50	0.93	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	ark77_schindlersark.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	ark77_schindlersark.m.id	2	40.00	Using where; Using index

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.34 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.82 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/bigpicture/vertex/module_calcs.php:41
8	require JROOT/templates/bigpicture/vertex/module_calcs.php	JROOT/templates/bigpicture/index.php:23
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 12.88 ms Query memory: 0.023 MB Memory before query: 3.350 MB Rows returned: 0

Duplicate queries: #27

SELECT menutype  
  FROM  htiur_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	htiur_menu	NULL	ref	idx_language	idx_language	28	const	1	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/templates/bigpicture/vertex/responsive/responsive_mobile_menu.php:284
10	include JROOT/templates/bigpicture/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/bigpicture/vertex/responsive/responsive_mobile_top_bar.php:169
9	require JROOT/templates/bigpicture/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/bigpicture/vertex/includes/vertex_includes_top.php:12
8	require JROOT/templates/bigpicture/vertex/includes/vertex_includes_top.php	JROOT/templates/bigpicture/index.php:76
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 7.18 ms Query memory: 0.021 MB Memory before query: 3.456 MB Rows returned: 0

Duplicate queries: #26

SELECT menutype  
  FROM  htiur_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	htiur_menu	NULL	ref	idx_language	idx_language	28	const	1	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/templates/bigpicture/vertex/s5flex_menu/default.php:45
8	include JROOT/templates/bigpicture/vertex/s5flex_menu/default.php	JROOT/templates/bigpicture/index.php:98
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.70 ms After last query: 7.00 ms Query memory: 0.048 MB Memory before query: 3.486 MB Rows returned: 21

Duplicate queries: #8 #29

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

  LEFT JOIN htiur_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	99	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	ark77_schindlersark.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.37 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
16	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
13	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
12	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
11	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/templates/bigpicture/vertex/s5flex_menu/helpers.php:75
10	S5modMainMenuHelper::getList()	JROOT/templates/bigpicture/vertex/s5flex_menu/helpers.php:274
9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/bigpicture/vertex/s5flex_menu/default.php:54
8	include JROOT/templates/bigpicture/vertex/s5flex_menu/default.php	JROOT/templates/bigpicture/index.php:98
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 0.39 ms Query memory: 0.049 MB Memory before query: 3.574 MB Rows returned: 21

Duplicate queries: #8 #28

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

  LEFT JOIN htiur_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	99	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	ark77_schindlersark.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.41 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/templates/bigpicture/vertex/s5flex_menu/helpers.php:78
10	S5modMainMenuHelper::getList()	JROOT/templates/bigpicture/vertex/s5flex_menu/helpers.php:274
9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/bigpicture/vertex/s5flex_menu/default.php:54
8	include JROOT/templates/bigpicture/vertex/s5flex_menu/default.php	JROOT/templates/bigpicture/index.php:98
7	require JROOT/templates/bigpicture/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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: 18.22 ms Query memory: 0.026 MB Memory before query: 3.630 MB Rows returned: 0

SELECT DISTINCT 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 htiur_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.19 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.05 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.19 ms After last query: 3.24 ms Query memory: 0.023 MB Memory before query: 3.648 MB Rows returned: 27

SELECT guest, client_id

  FROM htiur_session

  WHERE client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	htiur_session	NULL	ref	client_id_guest	client_id_guest	2	const	27	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:45
11	ModWhosonlineHelper::getOnlineCount()	JROOT/modules/mod_whosonline/mod_whosonline.php:19
10	include JROOT/modules/mod_whosonline/mod_whosonline.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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 3.663 MB Rows returned: 0

SELECT `a`.`username`,`a`.`userid`,`a`.`client_id`

  FROM htiur_session AS a

  WHERE `a`.`userid` != 0 
  AND `a`.`client_id` = 0

  GROUP BY `a`.`username`,`a`.`userid`,`a`.`client_id`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	userid,client_id_guest	userid	5	NULL	2	100.00	Using index condition; Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_whosonline/helper.php:118
11	ModWhosonlineHelper::getOnlineUserNames()	JROOT/modules/mod_whosonline/mod_whosonline.php:24
10	include JROOT/modules/mod_whosonline/mod_whosonline.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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × 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 htiur_menu AS m 
  LEFT JOIN htiur_extensions AS e 
  ON m.component_id = e.extension_id

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

2 × SELECT menutype  
  FROM  htiur_menu

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

1 × SELECT `data` 
  FROM `htiur_session`

1 × SELECT DISTINCT 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 htiur_fields AS a 
  LEFT JOIN `htiur_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN htiur_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN htiur_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN htiur_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN htiur_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `htiur_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT guest, client_id 
  FROM htiur_session

1 × SELECT DISTINCT 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 htiur_fields AS a 
  LEFT JOIN `htiur_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN htiur_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN htiur_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN htiur_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN htiur_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT title 
  FROM htiur_content

```
1 × SELECT * 
  FROM htiur_menu
```

1 × SELECT * 
  FROM htiur_template_styles

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 htiur_content AS a 
  INNER JOIN htiur_categories AS c 
  on c.id = a.catid 
  LEFT JOIN htiur_users AS u 
  on u.id = a.created_by 
  LEFT JOIN htiur_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN htiur_content_rating AS v 
  ON a.id = v.content_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 `htiur_categories` AS `s` 
  INNER JOIN `htiur_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 `htiur_contentitem_tag_map` AS m  
  INNER JOIN `htiur_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT `session_id` 
  FROM `htiur_session`

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

```
1 × SELECT * 
  FROM htiur_languages
```

1 × SELECT id 
  FROM htiur_twojtoolbox_menu

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

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

1 × SELECT id, rules 
  FROM `htiur_viewlevels

1 × SELECT `a`.`username`,`a`.`userid`,`a`.`client_id` 
  FROM htiur_session AS a

OTHER Tables:

1 × INSERT INTO `htiur_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3039316334623530313863663261316535623861613034316365316332633164', 1, 1732174470, 0, '', 0

1 × UPDATE `htiur_extensions` 
  SET `params` = '{\"mediaversion\":\"7ce89d2d22a9fe50834a90d12b9f8042\"}'

1 × SHOW FULL COLUMNS 
  FROM `htiur_content

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

He walked this land that you may live,

Notzrim ~ Hebrew for Christians

Rosemary Schindler Garlow

Our Vision

What We Do

Get Involved

"SCHINDLER'S LIST" SURVIVORS INSPIRE MOVIE

Israel/Jerusalem Real Time

Subscribe to Our Newsletter

Schindler's Society

ISRAEL TIMELINE

Involvement Can Start Today

Help Become A Partner

Upcoming Events

Donate To The Ministries

Our Address:

Contact Us

Get Involved

Who's Online

S5 Box

Main Menu

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

32 Queries Logged 24.43 ms

5 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

He walked this land that you may live,

Notzrim ~ Hebrew for Christians

Rosemary Schindler Garlow

Our Vision

What We Do

Get Involved

"SCHINDLER'S LIST" SURVIVORS INSPIRE MOVIE

Israel/Jerusalem Real Time

Subscribe to Our Newsletter

Sign up to receive the Schindler’s Ark Newsletter

Schindler's Society

ISRAEL TIMELINE

Involvement Can Start Today

Help Become A Partner

Upcoming Events

Donate To The Ministries

Our Address:

Contact Us

Get Involved

Who's Online

S5 Box

Main Menu

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

32 Queries Logged 24.43 ms

5 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: