APÉNDICE 1 ADUANA-SECCIÓN

Chihuahua

°C

Cd. Juarez

°C

22.12.2024

Aplicaciones AAA

Calculadora de Recargo y Multas

Padron de Importadores

Padron de Importadores de Sectores Especificos

VUCEEM

Justificaciones

ADUANA-SECCIÓN


Aduana	Sección	Denominación

01	0	ACAPULCO, ACAPULCO DE JUAREZ, GUERRERO.
01		AEROPUERTO INTERNACIONAL GENERAL JUAN N. ALVAREZ, ACAPULCO, GUERRERO.
02	0	AGUA PRIETA, AGUA PRIETA, SONORA.
05	0	SUBTENIENTE LOPEZ, SUBTENIENTE LOPEZ, QUINTANA, ROO.
05	1	SUBTENIENTE LOPEZ II "CHACTEMAL", OTHÓN P. BLANCO. CHETUMAL, QUINTANA ROO
06	0	CIUDAD DEL CARMEN, CIUDAD DEL CARMEN, CAMPECHE.
06	3	SEYBAPLAYA, CHAMPOTON, CAMPECHE.
07	0	CIUDAD JUAREZ, CIUDAD JUAREZ, CHIHUAHUA.
07	1	PUENTE INTERNACIONAL ZARAGOZA-ISLETA, CIUDAD JUAREZ, CHIHUAHUA.
07	2	SAN JERONIMO-SANTA TERESA, CIUDAD JUAREZ, CHIHUAHUA.
07	3	AEROPUERTO INTERNACIONAL ABRAHAM GONZALEZ, CIUDAD JUAREZ, CHIHUAHUA.
08	0	COATZACOALCOS, COATZACOALCOS, VERACRUZ.
08		ISLA PAJARITOS, COATZACOALCOS, VERACRUZ.
11	0	ENSENADA, ENSENADA, BAJA CALIFORNIA.
11		ISLA DE LOS CEDROS, ENSENADA, BAJA CALIFORNIA.
12	0	GUAYMAS, GUAYMAS, SONORA.
12	1	AEROPUERTO INTERNACIONAL GENERAL IGNACIO PESQUEIRA GARCIA, HERMOSILLO, SONORA.
12	2	PARQUE INDUSTRIAL DYNATECH, HERMOSILLO, SONORA.
12	3	CIUDAD OBREGON ADYACENTE AL AEROPUERTO DE CIUDAD OBREGON, CAJEME, SONORA.
14	0	LA PAZ, LA PAZ, BAJA CALIFORNIA SUR.
14		LOS OLIVOS, LA PAZ, BAJA CALIFORNIA SUR.
14	2	SAN JOSE DEL CABO, LOS CABOS, BAJA CALIFORNIA SUR.
14	3	CABO SAN LUCAS, LOS CABOS, BAJA CALIFORNIA SUR.
14	4	SANTA ROSALIA, MULEGE, BAJA CALIFORNIA SUR.
14	5	LORETO, LORETO, BAJA CALIFORNIA SUR.
14	7	PICHILINGÛE, LA PAZ, BAJA CALIFORNIA SUR.
16	0	MANZANILLO, MANZANILLO, COLIMA.
16		TECOMAN, TECOMAN, COLIMA.
17	0	MATAMOROS, MATAMOROS, TAMAULIPAS.
17	1	LUCIO BLANCO-LOS INDIOS, MATAMOROS, TAMAULIPAS.
17		PUERTO EL MEZQUITAL, MATAMOROS, TAMAULIPAS.
17		AEROPUERTO INTERNACIONAL GENERAL SERVANDO CANALES, MATAMOROS, TAMAULIPAS.
18	0	MAZATLAN, MAZATLAN, SINALOA.
18	3	TOPOLOBAMPO, AHOME, SINALOA.
18	4	AEROPUERTO INTERNACIONAL DE CULIACAN, CULIACAN, SINALOA.
19	0	MEXICALI, MEXICALI, BAJA CALIFORNIA.
19	2	LOS ALGODONES, MEXICALI, BAJA CALIFORNIA.
19	3	SAN FELIPE, MEXICALI, BAJA CALIFORNIA.
20	0	MEXICO, DISTRITO FEDERAL.
20	2	IMPORTACION Y EXPORTACION DE CONTENEDORES, DELEGACION AZCAPOTZALCO, DISTRITO FEDERAL.
22	0	NACO, NACO, SONORA.
23	0	NOGALES, NOGALES, SONORA.
23	1	SASABE, SARIC, SONORA.
24	0	NUEVO LAREDO, NUEVO LAREDO, TAMAULIPAS.
24		ESTACION SANCHEZ, NUEVO LAREDO, TAMAULIPAS
24		AEROPUERTO INTERNACIONAL DE NUEVO LAREDO "QUETZALCOALT", NUEVO LAREDO, TAMAULIPAS.
25	0	OJINAGA, OJINAGA, CHIHUAHUA.
26	0	PUERTO PALOMAS, PUERTO PALOMAS, CHIHUAHUA.
27	0	PIEDRAS NEGRAS, PIEDRAS NEGRAS, COAHUILA.
27	1	AEROPUERTO INTERNACIONAL PLAN DE GUADALUPE, RAMOS ARIZPE, COAHUILA.
27		RIO ESCONDIDO, NAVA, COAHUILA.
28	0	PROGRESO, PROGRESO, YUCATAN.
28	2	AEROPUERTO INTERNACIONAL LIC. MANUEL CRESCENCIO REJON, MERIDA, YUCATAN.
30	0	CIUDAD REYNOSA, CIUDAD REYNOSA, TAMAULIPAS.
30	2	LAS FLORES, RIO BRAVO, TAMAULIPAS.
30	4	AEROPUERTO INTERNACIONAL GENERAL. LUCIO BLANCO, CIUDAD REYNOSA, TAMAULIPAS.
30	5	RIO BRAVO-DONNA, RIO BRAVO, TAMAULIPAS.
30	6	ANZALDUAS, CIUDAD REYNOSA, TAMAULIPAS.
31	0	SALINA CRUZ, SALINA CRUZ, OAXACA.
31	1	AEROPUERTO INTERNACIONAL DE OAXACA, SANTA CRUZ XOXOCOTLAN, OAXACA.
33	0	SAN LUIS RIO COLORADO, SAN LUIS RIO COLORADO, SONORA.
34	0	CIUDAD MIGUEL ALEMAN, CIUDAD MIGUEL ALEMAN, TAMAULIPAS.
34	2	GUERRERO, GUERRERO, TAMAULIPAS.
37	0	CIUDAD HIDALGO, CIUDAD HIDALGO, CHIAPAS.
37	2	CIUDAD TALISMAN, TUXTLA CHICO, CHIAPAS.
37	6	CIUDAD CUAUHTEMOC, FRONTERA COMALAPA, CHIAPAS.
37	5	PUERTO CHIAPAS, TAPACHULA, CHIAPAS.
37		AEROPUERTO INTERNACIONAL DE TAPACHULA, TAPACHULA, CHIAPAS.
38	0	TAMPICO, TAMPICO, TAMAULIPAS.
39	0	TECATE, TECATE, BAJA CALIFORNIA.
40	0	TIJUANA, TIJUANA, BAJA CALIFORNIA.
40	2	AEROPUERTO INTERNACIONAL GENERAL ABELARDO L. RODRIGUEZ, TIJUANA, BAJA CALIFORNIA.
42	0	TUXPAN, TUXPAN DE RODRIGUEZ CANO, VERACRUZ.
43	0	VERACRUZ, VERACRUZ, VERACRUZ.
43	2	AEROPUERTO INTERNACIONAL GENERAL HERIBERTO JARA CORONA, VERACRUZ, VERACRUZ.
44	0	CIUDAD ACUÑA, CIUDAD ACUÑA, COAHUILA.
46	0	TORREON, TORREON, COAHUILA.
46		GOMEZ PALACIO, GOMEZ PALACIO, DURANGO.
46		AEROPUERTO INTERNACIONAL GENERAL GUADALUPE VICTORIA, DURANGO, DURANGO.
47	0	AEROPUERTO INTERNACIONAL DE LA CIUDAD DE MEXICO, AEROPUERTO INTERNACIONAL DE LA CIUDAD DE MEXICO
47	1	SATELITE, PARA IMPORTACION Y EXPORTACION POR VIA AEREA, AEROPUERTO INTERNACIONAL BENITO JUAREZ DE LA CIUDAD DE MEXICO.
47	2	CENTRO POSTAL MECANIZADO, POR VIA POSTAL Y POR TRAFICO AEREO, AEROPUERTO INTERNACIONAL BENITO JUAREZ DE LA CIUDAD DE MEXICO.
48	0	GUADALAJARA, TLACOMULCO DE ZUÑIGA, JALISCO.
48	1	PUERTO VALLARTA, PUERTO VALLARTA, JALISCO.
48	4	TERMINAL INTERMODAL FERROVIARIA, GUADALAJARA, JALISCO.
50	0	SONOYTA, SONOYTA, SONORA.
50	1	SAN EMETERIO, GENERAL PLUTARCO ELIAS CALLES, SONORA.
50		SONORA, PITIQUITO, SONORA.
51	0	LAZARO CARDENAS, LAZARO CARDENAS, MICHOACAN.
51	1	AEROPUERTO INTERNACIONAL IXTAPA-ZIHUATANEJO, ZIHUATANEJO DE AZUETA, GUERRERO.
52	0	MONTERREY, GENERAL MARIANO ESCOBEDO, NUEVO LEON.
52	1	AEROPUERTO INTERNACIONAL GENERAL MARIANO ESCOBEDO, APODACA, NUEVO LEON.
52	3	TERMINAL FERROVIARIA KANSAS CITY SOUTHERM DE MEXICO, S.A. DE C.V. SALINAS VICTORIA A (TERMINAL FERROVIARIA), SALINAS VICTORIA, NUEVO LEON.
52	4	GENERAL ESCOBEDO, GENERAL ESCOBEDO, NUEVO LEON.
53	0	CANCUN, CANCUN, QUINTANA ROO.
53	2	AEROPUERTO INTERNACIONAL DE COZUMEL, COZUMEL, QUINTANA ROO.
53	3	PUERTO MORELOS, BENITO JUAREZ, QUINTANA ROO.
64	0	QUERETARO, SANTIAGO DE QUERETARO, QUERETARO.
64	6	AEROPUERTO INTERCONTINENTAL DE QUERETARO, MARQUES Y COLON, QUERETARO.
64		TIZAYUCA, TIZAYUCA, HIDALGO.
64	2	MORELIA, MORELIA, MICHOACAN.
64	7	HIDALGO, ATOTONILCO DE TULA, HIDALGO.
65	0	TOLUCA, TOLUCA, ESTADO DE MEXICO.
67	0	CHIHUAHUA, CHIHUAHUA, CHIHUAHUA.
67	1	PARQUE INDUSTRIAL LAS AMERICAS, CHIHUAHUA, CHIHUAHUA.
67	2	AEROPUERTO INTERNACIONAL GENERAL. ROBERTO FIERRO VILLALOBOS, CHIHUAHUA, CHIHUAHUA.
73	0	AGUASCALIENTES, AGUASCALIENTES, AGUASCALIENTES.
73	1	PARQUE MULTIMODAL INTERPUERTO, SAN LUIS POTOSI, SAN LUIS POTOSI.
73	3	AEROPUERTO INTERNACIONAL PONCIANO ARRIAGA, SOLEDAD DE GRACIANO SANCHEZ, SAN LUIS POTOSI.
73	2	AEROPUERTO INTERNACIONAL GENERAL. LEOBARDO C. RUIZ, EN CALERA ZACATECAS.
73	4	LA PILA-VILLA, VILLA DE REYES, SAN LUIS POTOSI.
73		CHICALOTE, SAN FRANCISCO DE LOS ROMO, AGUASCALIENTES.
73	5	AEROPUERTO INTERNACIONAL LIC. JESUS TERAN PEREDO, AGUASCALIENTES, AGUASCALIENTES.
75	0	PUEBLA, HEROICA PUEBLA DE ZARAGOZA, PUEBLA.
75	1	CUERNAVACA, JIUTEPEC, MORELOS.
75	2	TLAXCALA, ATLANGATEPEC, TLAXCALA.
75	4	AEROPUERTO INTERNACIONAL HERMANOS SERDAN, HUEJOTZINGO, PUEBLA.
75		LA CELULA, ORIENTAL, PUEBLA.
80	0	COLOMBIA, COLOMBIA, NUEVO LEON.
81	0	ALTAMIRA, ALTAMIRA, TAMAULIPAS.
81		AEROPUERTO INTERNACIONAL GENERAL PEDRO JOSE MENDEZ, VICTORIA, TAMAULIPAS.
82	0	CIUDAD CAMARGO, CIUDAD CAMARGO, TAMAULIPAS.
83	0	DOS BOCAS, PARAISO, TABASCO.
83	1	AEROPUERTO INTERNACIONAL C.P.A. CARLOS ROVIROSA PEREZ, CIUDAD DE VILLAHERMOSA, CENTRO, TABASCO.
83	2	FRONTERA, CENTLA, TABASCO.
83	4	EL CEIBO, TENOSIQUE, TABASCO.
84	0	GUANAJUATO, SILAO, GUANAJUATO.
84	1	CELAYA, CELAYA, GUANAJUATO.
84	2	AEROPUERTO INTERNACIONAL DE GUANAJUATO, SILAO, GUANAJUATO.

NOTAS:

* Actualizado al 10 de Septiembre del 2012, fecha de publicación en el DOF del Anexo 22 de las RCGMCE para 2012.

*El texto en color Café, son modificaciones publicadas en el D.O.F. el 10/07/2013 en la Quinta Resolución de Modificaciones a las RCGMCE para 2012.

JSN Mico is designed by JoomlaShine.com

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734886494,
                "last": 1734886494,
                "now": 1734886494
            },
            "token": "PV2TYs0le5Ot16ToBnH8B3UvE6G8aYsR"
        },
        "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
        }
    }
}

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

#	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

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

#	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

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

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
update	0.07 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 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.46 ms After last query: 11.93 ms Query memory: 0.021 MB Memory before query: 1.458 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.03 ms
checking permissions	0.00 ms
Opening tables	0.26 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.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.43 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.470 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.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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
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.21 ms After last query: 34.13 ms Query memory: 0.020 MB Memory before query: 2.080 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.02 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.00 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: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.61 ms After last query: 21.78 ms Query memory: 0.006 MB Memory before query: 3.041 MB

UPDATE `nfojm_extensions`

  SET `params` = '{\"mediaversion\":\"79dc5ad3885317b2dfcb0e51dd7c5ca2\"}'

  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.04 ms
checking permissions	0.00 ms
Opening tables	0.29 ms
init	0.02 ms
System lock	0.06 ms
updating	0.05 ms
end	0.01 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.44 ms After last query: 4.49 ms Query memory: 0.020 MB Memory before query: 3.121 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.05 ms
checking permissions	0.01 ms
Opening tables	0.18 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 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: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.13 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 3.130 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.01 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.01 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.20 ms After last query: 0.55 ms Query memory: 0.022 MB Memory before query: 3.146 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.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.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
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.28 ms After last query: 12.72 ms Query memory: 0.021 MB Memory before query: 3.166 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.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 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.77 ms After last query: 8.71 ms Query memory: 0.027 MB Memory before query: 3.393 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.07 ms
checking permissions	0.00 ms
Opening tables	0.18 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 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.37 ms After last query: 0.15 ms Query memory: 0.049 MB Memory before query: 3.441 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.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.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.01 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.48 ms After last query: 3.79 ms Query memory: 0.027 MB Memory before query: 3.642 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.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 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.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
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.16 ms After last query: 0.88 ms Query memory: 0.024 MB Memory before query: 3.665 MB Rows returned: 0

Duplicate queries: #16

SELECT *

  FROM nfojm_assets

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

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.01 ms
optimizing	0.00 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.01 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.15 ms After last query: 1.01 ms Query memory: 0.024 MB Memory before query: 3.683 MB Rows returned: 0

Duplicate queries: #15

SELECT *

  FROM nfojm_assets

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

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.00 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.01 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.71 ms After last query: 1.19 ms Query memory: 0.032 MB Memory before query: 3.682 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.01 ms
checking permissions	0.00 ms
Opening tables	0.13 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.22 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.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.01 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.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.38 ms After last query: 4.33 ms Query memory: 0.005 MB Memory before query: 3.731 MB

UPDATE nfojm_content

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

  WHERE `id` = '93'

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.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.04 ms
updating	0.08 ms
end	0.00 ms
query end	0.06 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php: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.95 ms After last query: 19.02 ms Query memory: 0.023 MB Memory before query: 3.913 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-12-22 16:54:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 16:54:54') 
  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.31 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 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: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.38 ms After last query: 3.36 ms Query memory: 0.023 MB Memory before query: 4.024 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.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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.29 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 4.032 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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 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.40 ms After last query: 218.16 ms Query memory: 0.023 MB Memory before query: 4.111 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.05 ms
checking permissions	0.00 ms
Opening tables	0.19 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.34 ms After last query: 3.69 ms Query memory: 0.023 MB Memory before query: 4.127 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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 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: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.49 ms After last query: 3.80 ms Query memory: 0.023 MB Memory before query: 4.137 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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.15 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 4.144 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 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
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.28 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 4.153 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.02 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 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: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.33 ms After last query: 1.07 ms Query memory: 0.023 MB Memory before query: 4.224 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.04 ms
checking permissions	0.00 ms
Opening tables	0.16 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: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.32 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 4.232 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.04 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.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: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.22 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 4.244 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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 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.16 ms After last query: 4.63 ms Query memory: 0.026 MB Memory before query: 4.298 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.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 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.22 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 4.308 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.02 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 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
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.17 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 4.319 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 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
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.51 ms After last query: 0.29 ms Query memory: 0.032 MB Memory before query: 4.344 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.16 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.03 ms
checking permissions	0.03 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.02 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.04 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.15 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 4.381 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.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 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.17 ms After last query: 4.09 ms Query memory: 0.028 MB Memory before query: 4.406 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.03 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.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
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.25 ms After last query: 1.59 ms Query memory: 0.013 MB Memory before query: 4.478 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.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.07 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.20 ms After last query: 0.04 ms Query memory: 0.029 MB Memory before query: 4.491 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.01 ms
init	0.02 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.04 ms
end	0.01 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.28 ms After last query: 0.28 ms Query memory: 0.027 MB Memory before query: 4.510 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.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.07 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.17 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 4.523 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.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.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
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.05 ms Query memory: 0.027 MB Memory before query: 4.540 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.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.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
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.63 ms After last query: 1.14 ms Query memory: 0.031 MB Memory before query: 4.546 MB Rows returned: 117

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
checking permissions	0.42 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 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
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.10 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 4.572 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.41 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 4.572 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.02 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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'3232343663633566626433363164363738663761363663653431353639383230', 1, 1734886494, 0, '', 0

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

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
```

Aplicaciones AAA

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

43 Queries Logged 14.39 ms

9 duplicate found!

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: