Articulo 99

Chihuahua

°C

Cd. Juarez

°C

05.11.2024

Aplicaciones AAA

Calculadora de Recargo y Multas

Padron de Importadores

Padron de Importadores de Sectores Especificos

VUCEEM

Justificaciones

TÍTULO IV REGÍMENES ADUANEROS

CAPÍTULO II DEFINITIVOS DE IMPORTACIÓN Y EXPORTACIÓN

SECCIÓN PRIMERA DE IMPORTACIÓN

ARTÍCULO 099 CÁLCULO DE CONTRIBUCIONES AL AMPARO DEL PROCEDIMIENTO DE REVISIÓN EN ORIGEN

Los importadores que realicen operaciones al amparo del procedimiento de revisión en origen calcularán, durante el mes de enero, las contribuciones y cuotas compensatorias que en los términos de este artículo deberán pagar por las importaciones efectuadas durante el ejercicio inmediato anterior, de acuerdo con lo siguiente:

I. Se determinará el margen de error en las importaciones a que tendrá derecho cada importador, dividiendo el monto total de las contribuciones y cuotas compensatorias pagadas por el importador mediante pago espontáneo que se efectúe con posterioridad al despacho de las mercancías durante el ejercicio inmediato anterior, entre el monto que resulte de sumar a dichas contribuciones y cuotas compensatorias el total que por dichos conceptos se declaró en los pedimentos de importación efectuados en el mismo periodo y que no fueron objeto del reconocimiento aduanero, verificación de mercancías en transporte o visitas domiciliarias.

art99 formula1

donde

ME= Margen de error.

CE= Monto total de contribuciones y cuotas compensatorias pagadas por el importador de manera espontánea, conforme a la fracción V del artículo 98 de esta Ley, en el ejercicio inmediato anterior.

CDV= Monto total de contribuciones y cuotas compensatorias declaradas por el importador en los pedimentos que no fueron objeto de reconocimiento aduanero, verificación de mercancías en transporte o visitas domiciliarias, en el ejercicio inmediato anterior.

II. Se determinará el porcentaje de contribuciones y cuotas compensatorias omitidas, dividiendo el monto total de las contribuciones y cuotas compensatorias omitidas detectadas con motivo del reconocimiento aduanero, verificación de mercancías en transporte o visitas domiciliarias, efectuadas en el ejercicio inmediato anterior, entre el monto que se obtenga de sumar a dichas contribuciones y cuotas compensatorias el total que por dichos conceptos se hubiera declarado en los pedimentos de importación que fueron objeto del reconocimiento aduanero, verificación de mercancías en transporte o visitas domiciliarias.

Art99 Formula2

donde

PCO = Porcentaje de contribuciones y cuotas compensatorias omitidas.

CO = Monto total de las contribuciones y cuotas compensatorias omitidas detectadas con motivo del reconocimiento aduanero, verificación de mercancías en transporte o visitas domiciliarias, en el ejercicio inmediato anterior.

CDR= Monto total de contribuciones y cuotas compensatorias declaradas por el importador en los pedimentos que fueron objeto de reconocimiento aduanero, verificación de mercancías en transporte o visitas domiciliarias, en el ejercicio inmediato anterior.

Las cantidades que resulten de realizar las operaciones a que se refieren las fracciones anteriores se expresarán en porcientos.

III. Si el porcentaje obtenido del cálculo de la fracción II es mayor que el margen de error obtenido conforme a la fracción I de este artículo, el porcentaje excedente se aplicará al total de contribuciones y cuotas compensatorias pagadas con motivo de la importación de mercancías efectuadas en el ejercicio inmediato anterior que no fueron objeto del reconocimiento aduanero, verificación de mercancías en transporte o visitas domiciliarias, incluyendo las contribuciones y cuotas compensatorias pagadas espontáneamente.

El resultado será el total de contribuciones y cuotas compensatorias que en los términos de este artículo deberán pagar las empresas a que se refiere el artículo 98 de esta Ley. Es decir si PCO > ME, entonces el monto total por concepto de contribuciones y cuotas compensatorias a pagar por el importador será igual a.

art99 formula3

El pago que se realice conforme a esta fracción se considerará efectuado por concepto de los impuestos y derechos al comercio exterior, al valor agregado, especial sobre producción y servicios, y sobre automóviles nuevos, así como por cuotas compensatorias, en la misma proporción que representen las citadas contribuciones y cuotas compensatorias respecto al monto total de las cantidades que haya pagado el importador de que se trate por cada una de las mismas, en el ejercicio por el que se efectúe el cálculo a que se refiere este artículo.

El monto total de contribuciones y cuotas compensatorias que resulte en los términos de esta fracción se pagará a más tardar el día 17 del mes de febrero del año siguiente del ejercicio que se determina.

IV. En caso de que el porcentaje de contribuciones y cuotas compensatorias omitidas, sea igual o menor que el margen de error, calculados respectivamente en los términos de las dos primeras fracciones de este artículo, no habrá lugar al pago de contribuciones o de cuotas compensatorias en los términos del mismo, por el ejercicio de que se trate.

Artículo Reformado 09-12-2013

JSN Mico is designed by JoomlaShine.com

Joomla! Debug Console

Session

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

Profile Information

Memory Usage

Database Queries

43 Queries Logged 10.22 ms

9 duplicate found!

2 duplicates: #15 #16

3 duplicates: #25 #32 #40

2 duplicates: #28 #39

2 duplicates: #34 #35

Query Time: 0.20 ms Query memory: 0.023 MB Memory before query: 1.036 MB Rows returned: 0

SELECT `data`

  FROM `nfojm_session`

  WHERE `session_id` = X'3063653866383639396463623664396666613562613234336635393266346366'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 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.00 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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.10 ms After last query: 0.31 ms Query memory: 0.020 MB Memory before query: 1.050 MB Rows returned: 0

SELECT `session_id`

  FROM `nfojm_session`

  WHERE `session_id` = X'3063653866383639396463623664396666613562613234336635393266346366' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.25 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 1.055 MB

INSERT INTO `nfojm_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3063653866383639396463623664396666613562613234336635393266346366', 1, 1730813262, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `nfojm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3063653866383639396463623664396666613562613234336635393266346366', 1, 1730813262, 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.07 ms
end	0.00 ms
query end	0.04 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.16 ms After last query: 1.25 ms Query memory: 0.021 MB Memory before query: 1.132 MB Rows returned: 5

SELECT id, rules

  FROM `nfojm_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	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.00 ms
statistics	0.01 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.01 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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.144 MB Rows returned: 2

SELECT b.id

  FROM nfojm_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 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.01 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:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 6.25 ms Query memory: 0.020 MB Memory before query: 1.684 MB Rows returned: 1

SELECT count(1)

  FROM `nfojm_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

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.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.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/plugins/system/arktypography/arktypography.php:56
8	plgSystemARKtypography->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 4.60 ms Query memory: 0.006 MB Memory before query: 2.579 MB

UPDATE `nfojm_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nfojm_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,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.01 ms
System lock	0.08 ms
updating	0.05 ms
end	0.00 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.01 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/arktypography/arktypography.php:80
8	plgSystemARKtypography->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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.38 ms Query memory: 0.020 MB Memory before query: 2.596 MB Rows returned: 1

SELECT element,views,context,types,params

  FROM nfojm_ark_editor_inline_views

  WHERE element = 'com_content' 
  LIMIT 1

Explain

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

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.00 ms
statistics	0.03 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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/inlinecontent/inlinecontent.php:112
8	PlgSystemInlineContent->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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT types

  FROM nfojm_ark_editor_inline_views

  WHERE `parent` = 'com_content'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 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.01 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/inlinecontent/inlinecontent.php:130
8	PlgSystemInlineContent->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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.40 ms Query memory: 0.022 MB Memory before query: 2.620 MB Rows returned: 1

SELECT manifest_cache

  FROM nfojm_extensions

  WHERE element LIKE 'jsn_mico_free'

Explain

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

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.03 ms
preparing	0.01 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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
12	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
11	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
10	jsn_template_framework_class_loader()	Same as call in the line below.
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 6.49 ms Query memory: 0.021 MB Memory before query: 2.640 MB Rows returned: 1

SELECT COUNT(*)

  FROM nfojm_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.05 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.05 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.00 ms
freeing items	0.01 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/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
8	PlgSystemJSNTPLFramework->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:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 1.67 ms Query memory: 0.027 MB Memory before query: 2.864 MB Rows returned: 37

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

  FROM `nfojm_assets`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 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
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:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.14 ms Query memory: 0.049 MB Memory before query: 2.912 MB Rows returned: 100

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

  FROM `nfojm_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	nfojm_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	175	24.21	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 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
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:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.38 ms Query memory: 0.027 MB Memory before query: 3.050 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `nfojm_assets`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 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.00 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

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

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

Query Time: 0.57 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 3.073 MB Rows returned: 0

Duplicate queries: #16

SELECT *

  FROM nfojm_assets

  WHERE `name` = 'com_content.article.264'

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.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
executing	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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
16	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
15	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 3.090 MB Rows returned: 0

Duplicate queries: #15

SELECT *

  FROM nfojm_assets

  WHERE `name` = 'com_content.article.264'

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.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.44 ms After last query: 0.23 ms Query memory: 0.032 MB Memory before query: 3.089 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `nfojm_content`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 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.01 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
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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 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()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.63 ms Query memory: 0.005 MB Memory before query: 3.138 MB

UPDATE nfojm_content

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

  WHERE `id` = '264'

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.05 ms
end	0.00 ms
query end	0.05 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/src/Table/Table.php:1245
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:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 3.59 ms Query memory: 0.023 MB Memory before query: 3.291 MB Rows returned: 7

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

  FROM nfojm_modules AS m

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

  LEFT JOIN nfojm_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-05 13:27:42') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-05 13:27:42') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 373 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	18	3.03	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	aaachih_jmln7.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	aaachih_jmln7.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.22 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
13	JModuleHelper::getModuleList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410
12	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
11	JModuleHelper::getModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:168
10	JSNTplUtils->countModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:498
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_mico_free/index.php:18
7	require JROOT/templates/jsn_mico_free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 1.20 ms Query memory: 0.023 MB Memory before query: 3.338 MB Rows returned: 0

SELECT m.id

  FROM nfojm_modules AS m

  INNER JOIN nfojm_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid < 0 
  AND mm.menuid = -373) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	33	4.09	Using where
1	SIMPLE	mm	NULL	eq_ref	PRIMARY	PRIMARY	8	aaachih_jmln7.m.id,const	1	100.00	Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 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.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:737
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_mico_free/template_custom.php:23
11	include_once JROOT/templates/jsn_mico_free/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_mico_free/index.php:18
7	require JROOT/templates/jsn_mico_free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT m.id

  FROM nfojm_modules AS m

  INNER JOIN nfojm_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid = 373 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != -373)) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

  GROUP BY m.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	index	PRIMARY,published,newsfeeds,idx_language	PRIMARY	4	NULL	33	4.09	Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	aaachih_jmln7.m.id	1	43.30	Using where; Using index

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:758
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_mico_free/template_custom.php:23
11	include_once JROOT/templates/jsn_mico_free/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_mico_free/index.php:18
7	require JROOT/templates/jsn_mico_free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 2.79 ms Query memory: 0.023 MB Memory before query: 3.417 MB Rows returned: 0

SELECT `name`, `value`

  FROM `nfojm_jsn_imageshow_config`

  WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
13	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
12	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
11	require_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/modules/mod_imageshow/mod_imageshow.php:20
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 3.432 MB Rows returned: 1

SELECT *

  FROM nfojm_extensions

  WHERE element='com_imageshow' 
  AND type='component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

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.05 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.03 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
13	JSNISUtils->getComponentInfo()	JROOT/modules/mod_imageshow/helper.php:24
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 3.442 MB Rows returned: 0

SELECT c.introtext, c.fulltext
				   
  FROM nfojm_imageshow_showlist sl
				   
  INNER JOIN nfojm_content c 
  ON sl.alter_autid = c.id
				   
  WHERE sl.showlist_id=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.02 ms
checking permissions	0.00 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
executing	0.01 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_show.php:85
13	JSNISShow->getArticleAuth()	JROOT/modules/mod_imageshow/helper.php:42
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 3.449 MB Rows returned: 1

Duplicate queries: #32 #40

SELECT * 
  FROM nfojm_imageshow_showlist 
  WHERE  published = 1 
  AND  showlist_id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_showlist	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 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.01 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
13	JSNISShowlist->getShowListByID()	JROOT/modules/mod_imageshow/helper.php:43
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 3.458 MB Rows returned: 1

SELECT * 
  FROM nfojm_imageshow_showcase 
  WHERE  published = 1 
  AND  showcase_id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_showcase	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	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.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcase.php:155
13	JSNISShowcase->getShowCaseByID()	JROOT/modules/mod_imageshow/helper.php:44
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 3.466 MB Rows returned: 1

SELECT * 
  FROM nfojm_imageshow_theme_profile 
  WHERE showcase_id =1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_theme_profile	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	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.01 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:341
13	JSNISShowcaseTheme->getThemeProfile()	JROOT/modules/mod_imageshow/helper.php:62
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 3.474 MB Rows returned: 3

Duplicate queries: #39

SELECT
						image_id, image_title, image_alt_text,
						image_small, image_big, image_medium,
						image_description, image_link,
						image_extid, album_extid, image_size, custom_data, exif_data,
						image_size, sync, ordering				
				   
  FROM nfojm_imageshow_images
				   
  WHERE showlist_id =1
				   
  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:47
13	JSNISImages->getImagesByShowlistID()	JROOT/modules/mod_imageshow/helper.php:89
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 3.486 MB Rows returned: 1

SELECT *
			   
  FROM nfojm_extensions
			   
  WHERE folder = 'jsnimageshow'
			   
  AND element='themeclassic'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 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.03 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:293
13	JSNISShowcaseTheme->getThemeInfo()	JROOT/modules/mod_imageshow/helper.php:137
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.83 ms Query memory: 0.026 MB Memory before query: 3.539 MB Rows returned: 1

SELECT * 
  FROM nfojm_imageshow_theme_profile 
  WHERE showcase_id = 1 
  AND theme_id = 6

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_theme_profile	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	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.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/plugins/jsnimageshow/themeclassic/models/themeclassic.php:250
19	ThemeClassic->getSkin()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:164
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 3.549 MB Rows returned: 0

SELECT * 
  FROM nfojm_imageshow_theme_classic_parameters

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.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
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/plugins/jsnimageshow/themeclassic/models/themeclassic.php:233
19	ThemeClassic->getParameters()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:166
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 3.560 MB Rows returned: 1

Duplicate queries: #25 #40

SELECT * 
  FROM nfojm_imageshow_showlist 
  WHERE  published = 1 
  AND  showlist_id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_showlist	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 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.01 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
20	JSNISShowlist->getShowListByID()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:271
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.15 ms Query memory: 0.032 MB Memory before query: 3.585 MB Rows returned: 20

SHOW FULL COLUMNS 
  FROM `nfojm_imageshow_showlist`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
23	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_imageshow/tables/showlist.php:41
22	TableShowList->__construct()	JROOT/libraries/src/Table/Table.php:312
21	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:120
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 3.622 MB Rows returned: 1

Duplicate queries: #35

SELECT *

  FROM nfojm_imageshow_showlist

  WHERE `showlist_id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_showlist	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
21	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:123
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 3.647 MB Rows returned: 1

Duplicate queries: #34

SELECT *

  FROM nfojm_imageshow_showlist

  WHERE `showlist_id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_showlist	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
24	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:20
23	JSNImagesSourcesDefault->__construct()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:18
22	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
21	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.12 ms Query memory: 0.013 MB Memory before query: 3.656 MB

UPDATE nfojm_extensions 
  SET enabled = 1 
  WHERE element LIKE 'source%' 
  AND folder = 'jsnimageshow' 
  AND enabled = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
28	JDatabase->query()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:67
27	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
26	JSNISSource->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
25	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
24	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
23	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
22	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
21	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.029 MB Memory before query: 3.669 MB Rows returned: 1

SELECT * 
  FROM nfojm_extensions 
  WHERE element LIKE 'source%' 
  AND folder = 'jsnimageshow' 
  AND enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_extensions	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	1	5.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 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.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:71
27	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
26	JSNISSource->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
25	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
24	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
23	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
22	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
21	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 3.688 MB Rows returned: 0

SELECT album_extid
				  
  FROM nfojm_imageshow_images
				  
  WHERE showlist_id =1
				  
  AND sync = 1
				  
  GROUP BY album_extid

Explain

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

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.01 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:199
23	JSNISImages->getSyncAlbumsByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:23
22	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
21	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.03 ms Query memory: 0.028 MB Memory before query: 3.701 MB Rows returned: 3

Duplicate queries: #28

SELECT
						image_id, image_title, image_alt_text,
						image_small, image_big, image_medium,
						image_description, image_link,
						image_extid, album_extid, image_size, custom_data, exif_data,
						image_size, sync, ordering				
				   
  FROM nfojm_imageshow_images
				   
  WHERE showlist_id =1
				   
  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:47
24	JSNISImages->getImagesByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:157
23	JSNImagesSourcesDefault->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:102
22	JSNImagesSourcesInternal->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/source_folder/internal_source_folder.php:409
21	JSNInternalSourceFolder->getImages2JSON()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:126
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 3.718 MB Rows returned: 1

Duplicate queries: #25 #32

SELECT * 
  FROM nfojm_imageshow_showlist 
  WHERE  published = 1 
  AND  showlist_id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_showlist	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
21	JSNISShowlist->getShowListByID()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:129
20	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:272
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 0.49 ms Query memory: 0.031 MB Memory before query: 3.723 MB Rows returned: 117

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
checking permissions	0.46 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
22	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
21	JSNConfigHelper::get()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:756
20	JSNISThemeDisplay->loadjQuery()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:297
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 3.749 MB Rows returned: 0

SELECT name,value

  FROM nfojm_jsn_imageshow_config

  WHERE 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 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/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
21	JSNConfigHelper::get()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:756
20	JSNISThemeDisplay->loadjQuery()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:297
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 3.749 MB Rows returned: 1

SELECT * 
  FROM nfojm_imageshow_theme_classic_javascript 
  WHERE theme_id = 6

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nfojm_imageshow_theme_classic_javascript	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 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.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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/plugins/jsnimageshow/themeclassic/models/themeclassic.php:224
20	ThemeClassic->getData()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:306
19	JSNISThemeDisplay->javascriptLayout()	JROOT/plugins/jsnimageshow/themeclassic/classes/jsn_is_themedisplay.php:175
18	JSNISThemeDisplay->display()	JROOT/plugins/jsnimageshow/themeclassic/themeclassic.php:128
17	plgJSNImageshowThemeClassic->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
14	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
13	JSNISShowcaseTheme->displayTheme()	JROOT/modules/mod_imageshow/helper.php:149
12	modImageShowHelper::render()	JROOT/modules/mod_imageshow/tmpl/default.php:13
11	require JROOT/modules/mod_imageshow/tmpl/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT * 
  FROM nfojm_imageshow_showlist

2 × SELECT m.id 
  FROM nfojm_modules AS m 
  INNER JOIN nfojm_modules_menu AS mm 
  ON mm.moduleid = m.id

```
2 × SELECT * 
  FROM nfojm_extensions
```

2 × SELECT       image_id, image_title, image_alt_text,       image_small, image_big, image_medium,       image_description, image_link,       image_extid, album_extid, image_size, custom_data, exif_data,       image_size, sync, ordering            
  FROM nfojm_imageshow_images

2 × SELECT * 
  FROM nfojm_imageshow_theme_profile

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

```
2 × SELECT * 
  FROM nfojm_assets
```

1 × SELECT name,value 
  FROM nfojm_jsn_imageshow_config

1 × SELECT album_extid       
  FROM nfojm_imageshow_images

1 × SELECT * 
  FROM nfojm_imageshow_theme_classic_parameter

1 × SELECT *       
  FROM nfojm_extensions

1 × SELECT * 
  FROM nfojm_imageshow_showcase

1 × SELECT c.introtext, c.fulltext        
  FROM nfojm_imageshow_showlist sl        
  INNER JOIN nfojm_content c 
  ON sl.alter_autid = c.id

1 × SELECT `data` 
  FROM `nfojm_session`

1 × SELECT `name`, `value` 
  FROM `nfojm_jsn_imageshow_config`

1 × SELECT `session_id` 
  FROM `nfojm_session`

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

1 × SELECT COUNT(*) 
  FROM nfojm_extensions

1 × SELECT manifest_cache 
  FROM nfojm_extensions

1 × SELECT types 
  FROM nfojm_ark_editor_inline_views

1 × SELECT element,views,context,types,params 
  FROM nfojm_ark_editor_inline_views

1 × SELECT count(1) 
  FROM `nfojm_session`

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

1 × SELECT id, rules 
  FROM `nfojm_viewlevels

1 × SELECT * 
  FROM nfojm_imageshow_theme_classic_javascript

OTHER Tables:

1 × INSERT INTO `nfojm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3063653866383639396463623664396666613562613234336635393266346366', 1, 1730813262, 0, '', 0

1 × UPDATE `nfojm_extensions` 
  SET `params` = '{\"mediaversion\":\"cf6a96cd5433578fe35576c57ad8bd29\"}'

1 × SHOW FULL COLUMNS 
  FROM `nfojm_assets

1 × SHOW FULL COLUMNS 
  FROM `nfojm_content

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

1 × SHOW FULL COLUMNS 
  FROM `nfojm_imageshow_showlist

1 × UPDATE nfojm_extensions 
  SET enabled = 1

```
1 × SHOW TABLE
```