Crealtor Real Estate - Bienes Raíces en México - Información del Agente

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1715106362,
                "last": 1715106362,
                "now": 1715106362
            },
            "token": "TL6ad1hZ2vn8r6BZEC9p9m2gOKsnvAJY"
        },
        "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
        },
        "agent_id": 48
    }
}

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

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

'Explicar' no es posible en la consulta: INSERT INTO `qb4sq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3539373439633132396335336634653865383837343665336631666632366235', 1, 1715106362, 0, '', 0)

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.89 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	1.57 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.198 MB Filas devueltas: 7

SELECT id, rules

  FROM `qb4sq_viewlevels`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_viewlevels	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	7	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.211 MB Filas devueltas: 2

SELECT b.id

  FROM qb4sq_usergroups AS a

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

  WHERE a.id = 9

Explicar

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	3	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.46 ms Después de la última consulta: 14.32 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.676 MB Filas devueltas: 1

SELECT `query`

  FROM qb4sq_osrs_urls

  WHERE md5_key="e86bdd5d8908079d1ed4c06015f37eb0"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	10.00	Using where

Perfil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	2.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:873
9	OspropertyRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.40 ms Después de la última consulta: 2.44 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 2.848 MB

UPDATE `qb4sq_extensions`

  SET `params` = '{\"mediaversion\":\"495d241729d4c4846757b8a232c26e34\"}'

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

Explicar

'Explicar' no es posible en la consulta: UPDATE `qb4sq_extensions` SET `params` = '{\"mediaversion\":\"495d241729d4c4846757b8a232c26e34\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.10 ms
updating	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.50 ms Después de la última consulta: 65.72 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 11.990 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_osrs_configuration 
  where fieldname like 'integrate_membership'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_configuration	NULL	range	fieldname	fieldname	768	NULL	4	100.00	Using index condition

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/libraries/libraries.php:28
7	OSLibraries::checkMembership()	JROOT/components/com_osproperty/osproperty.php:56
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 11.996 MB

UPDATE qb4sq_osrs_configuration 
  SET fieldvalue = '0' 
  WHERE fieldname LIKE 'integrate_membership'

Explicar

'Explicar' no es posible en la consulta: UPDATE qb4sq_osrs_configuration SET fieldvalue = '0' WHERE fieldname LIKE 'integrate_membership'

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.04 ms
updating	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/components/com_osproperty/helpers/libraries/libraries.php:31
7	OSLibraries::checkMembership()	JROOT/components/com_osproperty/osproperty.php:56
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.25 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 0.047 MB memoria antes de la consulta: 12.097 MB Filas devueltas: 417

Consultas duplicadas: #13

Select * 
  from qb4sq_osrs_configuration

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_configuration	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	417	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
7	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/osproperty.php:68
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 12.340 MB Filas devueltas: 1

Consultas duplicadas: #14 #37

Select * 
  from qb4sq_osrs_currencies 
  where id = '33'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
7	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/osproperty.php:79
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 12.348 MB Filas devueltas: 0

SELECT lang_id, lang_code, title, `sef`

  FROM qb4sq_languages

  WHERE published = 1 
  AND lang_code != "es-ES"

  ORDER BY ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_languages	NULL	range	idx_langcode	idx_langcode	28	NULL	2	50.00	Using index condition; Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:367
7	OSPHelper::getLanguages()	JROOT/components/com_osproperty/osproperty.php:91
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.21 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.048 MB memoria antes de la consulta: 12.357 MB Filas devueltas: 417

Consultas duplicadas: #10

Select * 
  from qb4sq_osrs_configuration

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_configuration	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	417	100.00	NULL

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 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	1.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:50
8	OSPHelper::loadConfig()	JROOT/components/com_osproperty/helpers/helper.php:1002
7	OSPHelper::loadBootstrap()	JROOT/components/com_osproperty/osproperty.php:101
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.609 MB Filas devueltas: 1

Consultas duplicadas: #11 #37

Select * 
  from qb4sq_osrs_currencies 
  where id = '33'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:61
8	OSPHelper::loadConfig()	JROOT/components/com_osproperty/helpers/helper.php:1002
7	OSPHelper::loadBootstrap()	JROOT/components/com_osproperty/osproperty.php:101
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.22 ms Después de la última consulta: 0.50 ms Consulta a la memoria: 0.047 MB memoria antes de la consulta: 12.178 MB Filas devueltas: 417

SELECT * 
  FROM qb4sq_osrs_configuration

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_configuration	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	417	100.00	NULL

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	1.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
7	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/osproperty.php:130
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.225 MB Filas devueltas: 1

Consultas duplicadas: #29

Select * 
  from qb4sq_osrs_themes 
  where published = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_themes	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	6	16.67	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:4856
7	OSPHelper::loadThemeStyle()	JROOT/components/com_osproperty/osproperty.php:225
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.254 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_agents 
  where id = '48'

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	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.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/agent.php:423
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.262 MB Filas devueltas: 1

Select fieldvalue 
  from qb4sq_osrs_configuration 
  where fieldname like 'default_itemid'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_configuration	NULL	range	fieldname	fieldname	768	NULL	7	100.00	Using index condition

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	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.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:44
10	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/route.php:560
9	OSPRoute::getAgentItemid()	JROOT/components/com_osproperty/classes/agent.php:425
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.73 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.276 MB Filas devueltas: 0

SELECT id

  FROM qb4sq_menu

  WHERE link LIKE "%index.php?option=com_osproperty%" 
  and (  `link` LIKE "%lagents%" or   `link` LIKE "%agent_layout%" or   `link` LIKE "%agent_listing%" or   `link` LIKE "%agent_details%" or   `link` LIKE "%48%" ) 
  AND published = 1  
  and id in (101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521) 
  AND `access` IN (1,1,5)

  ORDER BY access

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.50 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:462
10	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/route.php:560
9	OSPRoute::getAgentItemid()	JROOT/components/com_osproperty/classes/agent.php:425
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.19 ms Después de la última consulta: 1.46 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 12.458 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "9232051014198fd15506bae9eda06eb0"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
15	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
9	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/classes/agent.php:433
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 12.466 MB Filas devueltas: 1

Select id, alias, name 
  from qb4sq_osrs_agents 
  where id = '48'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:284
15	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
9	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/classes/agent.php:434
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.14 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 12.477 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "e86bdd5d8908079d1ed4c06015f37eb0"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
15	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
9	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/classes/agent.php:434
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.482 MB Filas devueltas: 1

Select id,company_name,photo 
  from qb4sq_osrs_companies 
  where id = '8'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_companies	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/agent.php:439
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.488 MB Filas devueltas: 0

Select state_name as state_name 
  from qb4sq_osrs_states 
  where id = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/agent.php:449
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.13 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.493 MB Filas devueltas: 1

Select country_name 
  from qb4sq_osrs_countries 
  where id = '120'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/agent.php:451
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.81 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.499 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_osrs_properties 
  where agent_id = '48' 
  and published = '1' 
  and approved = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_properties	NULL	ref	published,approved	published	2	const	317	9.95	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	1.58 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/agent.php:454
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.79 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.505 MB Filas devueltas: 1

Select id,pro_name,hits 
  from qb4sq_osrs_properties 
  where hits > 0  
  and agent_id = '48' 
  and published = '1' 
  and approved = '1' 
  order by hits desc 
  limit 5

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_properties	NULL	ref	published,approved	published	2	const	317	3.31	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	1.58 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/agent.php:459
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.73 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.511 MB Filas devueltas: 0

Select id,pro_name,(total_points/number_votes) as rated 
  from qb4sq_osrs_properties 
  where agent_id = '48' 
  and published = '1' 
  and approved = '1' 
  and number_votes > 0 
  order by (total_points/number_votes) desc 
  limit 5

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_properties	NULL	ref	published,approved	published	2	const	317	3.31	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	1.53 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/agent.php:462
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.516 MB Filas devueltas: 1

Consultas duplicadas: #16

Select * 
  from qb4sq_osrs_themes 
  where published = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_themes	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	6	16.67	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:4900
11	OSPHelper::getThemeName()	JROOT/components/com_osproperty/classes/template.class.php:35
10	OspropertyTemplate->OspropertyTemplate()	JROOT/components/com_osproperty/classes/agent.html.php:1135
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.584 MB Filas devueltas: 1

Select agent_type 
  from qb4sq_osrs_agents 
  where id = '48'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:2525
12	OSPHelper::loadAgentType()	JROOT/components/com_osproperty/helpers/layouts/agentdetails.php:35
11	include JROOT/components/com_osproperty/helpers/layouts/agentdetails.php	JROOT/components/com_osproperty/classes/template.class.php:157
10	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/agent.html.php:1144
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.12 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.591 MB Filas devueltas: 0

Select city 
  from qb4sq_osrs_cities 
  where id = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1576
13	OSPHelper::loadCityName()	JROOT/components/com_osproperty/helpers/helper.php:1530
12	OSPHelper::generateAddress()	JROOT/components/com_osproperty/helpers/layouts/agentdetails.php:71
11	include JROOT/components/com_osproperty/helpers/layouts/agentdetails.php	JROOT/components/com_osproperty/classes/template.class.php:157
10	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/agent.html.php:1144
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.12 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.599 MB Filas devueltas: 0

Select state_code 
  from qb4sq_osrs_states 
  where id = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1591
13	OSPHelper::loadSateCode()	JROOT/components/com_osproperty/helpers/helper.php:1531
12	OSPHelper::generateAddress()	JROOT/components/com_osproperty/helpers/layouts/agentdetails.php:71
11	include JROOT/components/com_osproperty/helpers/layouts/agentdetails.php	JROOT/components/com_osproperty/classes/template.class.php:157
10	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/agent.html.php:1144
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.13 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 12.613 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_countries 
  where id = '120'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:1623
13	OSPHelper::loadCountryName()	JROOT/components/com_osproperty/helpers/helper.php:1551
12	OSPHelper::generateAddress()	JROOT/components/com_osproperty/helpers/layouts/agentdetails.php:71
11	include JROOT/components/com_osproperty/helpers/layouts/agentdetails.php	JROOT/components/com_osproperty/classes/template.class.php:157
10	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/agent.html.php:1144
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.67 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.633 MB Filas devueltas: 0

SELECT id

  FROM qb4sq_menu

  WHERE link LIKE "%index.php?option=com_osproperty%" 
  and (  `link` LIKE "%lcompanies%" or   `link` LIKE "%company_listing%" ) 
  AND published = 1  
  and id in (101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521,101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521) 
  AND `access` IN (1,1,5)

  ORDER BY access

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.43 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:462
13	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/route.php:579
12	OSPRoute::getCompanyItemid()	JROOT/components/com_osproperty/helpers/layouts/agentdetails.php:149
11	include JROOT/components/com_osproperty/helpers/layouts/agentdetails.php	JROOT/components/com_osproperty/classes/template.class.php:157
10	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/agent.html.php:1144
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 12.635 MB Filas devueltas: 1

Select id, company_alias, company_name 
  from qb4sq_osrs_companies 
  where id = '8'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_companies	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:167
18	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/layouts/agentdetails.php:149
11	include JROOT/components/com_osproperty/helpers/layouts/agentdetails.php	JROOT/components/com_osproperty/classes/template.class.php:157
10	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/agent.html.php:1144
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.13 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 12.648 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "00f4c5bc44e81e10610bf908c1518bff"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.00 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
18	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/layouts/agentdetails.php:149
11	include JROOT/components/com_osproperty/helpers/layouts/agentdetails.php	JROOT/components/com_osproperty/classes/template.class.php:157
10	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/agent.html.php:1144
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.609 MB Filas devueltas: 1

Consultas duplicadas: #11 #14

Select * 
  from qb4sq_osrs_currencies 
  where id = '33'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:3047
12	OSPHelper::getConfig()	JROOT/components/com_osproperty/helpers/helper.php:2961
11	OSPHelper::userOneState()	JROOT/components/com_osproperty/classes/listing.php:2833
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.00 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.639 MB Filas devueltas: 1

Select count(distinct a.id) 
  from qb4sq_osrs_properties as a 
  INNER JOIN qb4sq_osrs_agents as c 
  on c.id = a.agent_id 
  LEFT JOIN qb4sq_osrs_types as d 
  on d.id = a.pro_type 
  INNER JOIN qb4sq_osrs_countries as e 
  on e.id = a.country 
  LEFT JOIN qb4sq_osrs_property_categories as g 
  on g.pid = a.id 
  WHERE 1=1 
  and a.access IN (1,1,5) 
  AND a.agent_id = '48' 
  and a.published = '1' 
  and a.approved = '1'  
  AND ((a.publish_up is null or  a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2024-05-07 18:26:02'  or a.publish_up = '0000-00-00') 
  AND (a.publish_down is null  or a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2024-05-07 18:26:02'  or a.publish_down = '0000-00-00'))

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	NULL	ref	published,approved,access	published	2	const	317	0.27	Using where
1	SIMPLE	d	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.a.pro_type	1	100.00	Using index
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.a.country	1	100.00	Using index
1	SIMPLE	g	NULL	ref	pid	pid	5	crealtor_pagina_es.a.id	1	100.00	Using index

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.07 ms
executing	1.57 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:2942
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.28 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.074 MB memoria antes de la consulta: 12.763 MB Filas devueltas: 1

Select a.*,c.name as agent_name,c.photo as agent_photo, c.mobile as agent_mobile, c.phone as agent_phone,c.email as agent_email, c.optin,d.id as typeid,d.type_name as type_name,e.country_name 
  from qb4sq_osrs_properties as a 
  INNER JOIN qb4sq_osrs_agents as c 
  on c.id = a.agent_id 
  LEFT JOIN qb4sq_osrs_types as d 
  on d.id = a.pro_type 
  LEFT JOIN qb4sq_osrs_countries as e 
  on e.id = a.country 
  LEFT JOIN qb4sq_osrs_property_categories as g 
  on g.pid = a.id 
  WHERE 1=1 
  and a.access IN (1,1,5) 
  AND a.agent_id = '48' 
  and a.published = '1' 
  and a.approved = '1'  
  AND ((a.publish_up is null or  a.publish_up = '0000-00-00 00:00:00' or a.publish_up <= '2024-05-07 18:26:02'  or a.publish_up = '0000-00-00') 
  AND (a.publish_down is null  or a.publish_down = '0000-00-00 00:00:00' or a.publish_down >= '2024-05-07 18:26:02'  or a.publish_down = '0000-00-00')) 
  GROUP BY a.id 
  ORDER BY a.id desc 
  LIMIT 0, 20

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	index	PRIMARY,published,approved,access	PRIMARY	4	NULL	23	0.27	Using where; Backward index scan
1	SIMPLE	d	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.a.pro_type	1	100.00	NULL
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.a.country	1	100.00	NULL
1	SIMPLE	g	NULL	ref	pid	pid	5	crealtor_pagina_es.a.id	1	100.00	Using index

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	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
Opening tables	0.07 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	1.80 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3126
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.784 MB Filas devueltas: 0

Select * 
  from qb4sq_osrs_extra_fields 
  where published = '1'  
  and `access` IN (1,1,5) 
  and show_on_list = '1' 
  order by ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_extra_fields	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	13	7.69	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/common.php:3859
11	HelperOspropertyCommon::getExtrafieldInList()	JROOT/components/com_osproperty/classes/listing.php:3129
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.82 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.790 MB Filas devueltas: 1

Consultas duplicadas: #42

Select count(id) 
  from qb4sq_osrs_properties 
  where pro_alias like 'e4-cav1291' 
  and id <> '386'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_properties	NULL	range	PRIMARY	PRIMARY	4	NULL	370	11.11	Using index condition; Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	1.67 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1995
11	OSPHelper::generateAlias()	JROOT/components/com_osproperty/classes/listing.php:3139
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.91 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.796 MB Filas devueltas: 1

Consultas duplicadas: #41

Select count(id) 
  from qb4sq_osrs_properties 
  where pro_alias like 'e4-cav1291' 
  and id <> '386'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_properties	NULL	range	PRIMARY	PRIMARY	4	NULL	370	11.11	Using index condition; Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	1.75 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1995
11	OSPHelper::generateAlias()	JROOT/components/com_osproperty/classes/listing.php:3141
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.804 MB Filas devueltas: 1

SELECT id, category_name as category_name

  FROM qb4sq_osrs_categories

  WHERE  1 = 1 
  and `access` IN (1,1,5) 
  and id in (Select category_id 
  from qb4sq_osrs_property_categories 
  where pid ="386")

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_property_categories	NULL	ref	pid,category_id	pid	5	const	1	100.00	Using where; Start temporary
1	SIMPLE	qb4sq_osrs_categories	NULL	eq_ref	PRIMARY,access	PRIMARY	4	crealtor_pagina_es.qb4sq_osrs_property_categories.category_id	1	100.00	Using where; End temporary

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 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.01 ms
statistics	0.04 ms
preparing	0.03 ms
executing	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.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:3243
11	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3147
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.67 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.819 MB Filas devueltas: 1

SELECT id

  FROM qb4sq_menu

  WHERE link LIKE "%index.php?option=com_osproperty%" 
  and (  `link` LIKE "%category_listing%" or   `link` LIKE "%lcategory%" ) 
  AND published = 1  
  and id in (101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521,101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521,101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521) 
  AND `access` IN (1,1,5)

  ORDER BY access

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.42 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:462
12	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/helper.php:3249
11	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3147
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 12.821 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_categories 
  where id = '6'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:136
18	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/helper.php:3253
11	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3147
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.11 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 12.834 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "fc73bdd1116e9ad3dc9c004388c84db2"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	1.98 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
18	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/helper.php:3253
11	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/components/com_osproperty/classes/listing.php:3147
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.23 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.837 MB Filas devueltas: 1

SELECT category_name

  FROM qb4sq_osrs_categories

  WHERE  1 = 1 
  and `access` IN (1,1,5) 
  and id in (Select category_id 
  from qb4sq_osrs_property_categories 
  where pid ="386")

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_property_categories	NULL	ref	pid,category_id	pid	5	const	1	100.00	Using where; Start temporary
1	SIMPLE	qb4sq_osrs_categories	NULL	eq_ref	PRIMARY,access	PRIMARY	4	crealtor_pagina_es.qb4sq_osrs_property_categories.category_id	1	100.00	Using where; End temporary

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_osproperty/helpers/helper.php:3221
11	OSPHelper::getCategoryNamesOfProperty()	JROOT/components/com_osproperty/classes/listing.php:3150
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.847 MB Filas devueltas: 0

SELECT *

  FROM qb4sq_osrs_property_open

  WHERE pid='386' 
  and end_to > '2024-05-07 18:26:02'

  ORDER BY start_from

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_property_open	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	6	16.67	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3168
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.853 MB Filas devueltas: 0

Select * 
  from qb4sq_osrs_comments 
  where pro_id = '386' 
  and published = '1' 
  order by created_on desc

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/listing.php:3191
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.859 MB Filas devueltas: 1

select count(id) 
  from qb4sq_osrs_photos 
  where pro_id = '386'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_photos	NULL	ref	pro_id	pro_id	5	const	20	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:3222
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.865 MB Filas devueltas: 1

select image 
  from qb4sq_osrs_photos 
  where pro_id = '386' 
  order by ordering 
  limit 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_photos	NULL	ref	pro_id	pro_id	5	const	20	100.00	Usando 'filesort'

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.11 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:3226
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.871 MB Filas devueltas: 18

Select * 
  from qb4sq_osrs_photos 
  where pro_id = '386'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_photos	NULL	ref	pro_id	pro_id	5	const	20	100.00	NULL

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.11 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3247
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.892 MB Filas devueltas: 1

Select state_name 
  from qb4sq_osrs_states 
  where id = '14'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:1612
11	OSPHelper::loadSateName()	JROOT/components/com_osproperty/classes/listing.php:3260
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.13 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.898 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_countries 
  where id = '123'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:1623
12	OSPHelper::loadCountryName()	JROOT/components/com_osproperty/helpers/helper.php:6029
11	OSPHelper::getCountryName()	JROOT/components/com_osproperty/classes/listing.php:3265
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.11 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.904 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_osrs_comments 
  where pro_id = '386'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/classes/listing.php:3294
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.911 MB Filas devueltas: 3

Select id as value,type_name as text 
  from qb4sq_osrs_types 
  where published = '1' 
  order by ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_types	NULL	ref	published	published	2	const	2	100.00	Usando 'filesort'

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	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.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3339
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 12.920 MB Filas devueltas: 10

Select * 
  from qb4sq_osrs_categories 
  where published = '1' 
  order by ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_categories	NULL	ref	published	published	2	const	9	100.00	Usando 'filesort'

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:3110
11	OSPHelper::checkboxesCategory()	JROOT/components/com_osproperty/classes/listing.php:3344
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.928 MB Filas devueltas: 9

Select id as value, country_name as text, country_name 
  from qb4sq_osrs_countries 
  where 1=1 
  and id in (124,121,125,127,120,122,123,126,128) 
  order by country_name

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_countries	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	9	100.00	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/common.php:116
11	HelperOspropertyCommon::makeCountryList()	JROOT/components/com_osproperty/classes/listing.php:3348
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.36 ms Después de la última consulta: 0.49 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.972 MB Filas devueltas: 34

Select a.id as value, a.name as text 
  from qb4sq_osrs_agents as a 
  inner join qb4sq_users as b 
  on b.id = a.user_id 
  where a.published = '1'   
  order by a.name

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	published	published	2	const	33	100.00	Usando 'filesort'
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.a.user_id	1	100.00	Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/classes/listing.php:3414
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 13.004 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_themes 
  where name like 'theme3'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_themes	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	6	16.67	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	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.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/classes/listing.html.php:853
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.30 ms Después de la última consulta: 1.37 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.197 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_osrs_agents 
  where agent_type <> '0' 
  and published = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_agents	NULL	ref	published	published	2	const	33	90.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:2947
15	OSPHelper::checkOwnerExisting()	JROOT/components/com_osproperty/helpers/common.php:2947
14	HelperOspropertyCommon::filterForm()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:79
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.206 MB Filas devueltas: 3

Select id as value, currency_code as text 
  from qb4sq_osrs_currencies 
  where id <> '' 
  order by currency_code

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_currencies	NULL	range	PRIMARY	PRIMARY	4	NULL	4	100.00	Using index condition; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:87
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.224 MB Filas devueltas: 1

Select a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id 
  from qb4sq_osrs_properties as a 
  inner join qb4sq_osrs_agents as b 
  on b.id = a.agent_id 
  left join qb4sq_osrs_company_agents as c 
  on c.agent_id = b.id 
  where a.id = '386'

Explicar

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	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	36	100.00	Using where

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/route.php:88
14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:670
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.234 MB Filas devueltas: 1

SELECT category_id

  FROM qb4sq_osrs_property_categories

  WHERE pid="386"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_property_categories	NULL	ref	pid	pid	5	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_osproperty/helpers/helper.php:3200
15	OSPHelper::getCategoryIdsOfProperty()	JROOT/components/com_osproperty/helpers/route.php:99
14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:670
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.57 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.251 MB Filas devueltas: 0

Select id 
  from qb4sq_menu 
  where published = '1' 
  and ((`link` like '%view=ldetails&id=386%') or (`link` like '%view=ldetails&ampid=386%'))  
  and `access` IN (1,1,5)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:118
14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:670
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.57 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.067 MB memoria antes de la consulta: 13.264 MB Filas devueltas: 30

Consultas duplicadas: #83

Select * 
  from qb4sq_menu 
  where published = '1' 
  and `home` = '0' 
  and `link` like '%view=ltype%'  
  and `access` IN (1,1,5)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.40 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/route.php:125
14	OSPRoute::getItemid()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:670
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.43 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.268 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_menu 
  where id = '124' 
  and published = '1' 
  and (`link` like '%view=ldetails%' 
  and `link` like '%id=386%')  
  and `access` IN (1,1,5)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:598
21	OSPRoute::checkDirectPropertyLink()	JROOT/components/com_osproperty/router.php:328
20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:680
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.071 MB memoria antes de la consulta: 13.279 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_properties 
  where id = '386'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:357
20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:680
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.31 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.305 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "8c7c3b7d84ef797b2e750d2de116feb1"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:680
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.300 MB Filas devueltas: 0

Select * 
  from qb4sq_osrs_categories 
  where id = ''

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 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.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:136
20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:711
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.13 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.313 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "d41d8cd98f00b204e9800998ecf8427e"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:711
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.320 MB Filas devueltas: 1

Select fieldvalue 
  from qb4sq_osrs_configuration 
  where fieldname like 'general_currency_money_format'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_configuration	NULL	range	fieldname	fieldname	768	NULL	31	100.00	Using index condition

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/helper.php:7238
15	OSPHelper::showPrice()	JROOT/components/com_osproperty/helpers/helper.php:2730
14	OSPHelper::generatePrice()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:719
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.329 MB Filas devueltas: 1

Select currency_symbol 
  from qb4sq_osrs_currencies 
  where id = '33'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/common.php:1563
15	HelperOspropertyCommon::loadCurrency()	JROOT/components/com_osproperty/helpers/helper.php:2730
14	OSPHelper::generatePrice()	JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php:719
13	include JROOT/components/com_osproperty/templates/theme3/listing.html.tpl.php	JROOT/components/com_osproperty/classes/template.class.php:157
12	OspropertyTemplate->fetch()	JROOT/components/com_osproperty/classes/listing.html.php:886
11	HTML_OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/listing.php:3424
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 8.77 ms Después de la última consulta: 7.79 ms Consulta a la memoria: 0.067 MB memoria antes de la consulta: 13.583 MB Filas devueltas: 1

SELECT p.*, s.state_name, c.country_name,ty.id as typeid, ty.type_name as type_name 
  FROM qb4sq_osrs_properties AS p
    				
  INNER JOIN qb4sq_osrs_types AS ty 
  ON ty.id = p.pro_type
    				
  LEFT JOIN qb4sq_osrs_states AS s 
  ON s.id = p.state
    				
  INNER JOIN qb4sq_osrs_countries AS c 
  ON c.id = p.country
    				
  INNER JOIN qb4sq_osrs_agents as ag 
  ON p.agent_id = ag.id
    				 
  WHERE p.published = '1' 
  AND p.approved = '1'  
  AND ((p.publish_up is null or  p.publish_up = '0000-00-00 00:00:00' or p.publish_up <= '2024-05-07 18:26:02'  or p.publish_up = '0000-00-00') 
  AND (p.publish_down is null  or p.publish_down = '0000-00-00 00:00:00' or p.publish_down >= '2024-05-07 18:26:02'  or p.publish_down = '0000-00-00')) 
  and p.access IN (1,1,5) 
  ORDER BY p.created desc 
  limit 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	NULL	ref	published,approved,access	published	2	const	317	26.20	Using where; Usando 'filesort'
1	SIMPLE	ty	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.p.pro_type	1	100.00	NULL
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.p.country	1	100.00	NULL
1	SIMPLE	s	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.p.state	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.p.agent_id	1	100.00	Using index

Perfil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	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
Opening tables	0.10 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.05 ms
executing	7.57 ms
end	0.01 ms
query end	0.49 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_ospropertyrandom/helper.php:263
12	modOSpropertyramdomHelper->getProperty()	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:39
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.606 MB Filas devueltas: 19

SELECT image 
  FROM qb4sq_osrs_photos 
  WHERE pro_id = 394 
  order by ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_photos	NULL	ref	pro_id	pro_id	5	const	18	100.00	Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_ospropertyrandom/helper.php:271
12	modOSpropertyramdomHelper->getProperty()	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:39
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.615 MB Filas devueltas: 1

SELECT id, category_name as category_name

  FROM qb4sq_osrs_categories

  WHERE  1 = 1 
  and `access` IN (1,1,5) 
  and id in (Select category_id 
  from qb4sq_osrs_property_categories 
  where pid ="394")

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_property_categories	NULL	ref	pid,category_id	pid	5	const	1	100.00	Using where; Start temporary
1	SIMPLE	qb4sq_osrs_categories	NULL	eq_ref	PRIMARY,access	PRIMARY	4	crealtor_pagina_es.qb4sq_osrs_property_categories.category_id	1	100.00	Using where; End temporary

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/helper.php:3243
13	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/modules/mod_ospropertyrandom/helper.php:301
12	modOSpropertyramdomHelper->getProperty()	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:39
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.74 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.631 MB Filas devueltas: 1

SELECT id

  FROM qb4sq_menu

  WHERE link LIKE "%index.php?option=com_osproperty%" 
  and (  `link` LIKE "%category_listing%" or   `link` LIKE "%lcategory%" ) 
  AND published = 1  
  and id in (101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521,101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521,101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521,101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521,101,121,159,160,285,286,504,505,506,508,509,510,507,165,166,124,125,126,129,130,131,134,136,137,307,513,514,515,516,518,517,519,520,521) 
  AND `access` IN (1,1,5)

  ORDER BY access

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.43 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:462
14	OSPRoute::getItemid()	JROOT/components/com_osproperty/helpers/helper.php:3249
13	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/modules/mod_ospropertyrandom/helper.php:301
12	modOSpropertyramdomHelper->getProperty()	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:39
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.633 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_categories 
  where id = '3'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:136
20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/helper.php:3253
13	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/modules/mod_ospropertyrandom/helper.php:301
12	modOSpropertyramdomHelper->getProperty()	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:39
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.29 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.647 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "9b6b469f70bc4c11ee759b5c27dcc8a2"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
20	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_osproperty/helpers/helper.php:3253
13	OSPHelper::getCategoryNamesOfPropertyWithLinks()	JROOT/modules/mod_ospropertyrandom/helper.php:301
12	modOSpropertyramdomHelper->getProperty()	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:39
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.54 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.688 MB Filas devueltas: 1

Select a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id 
  from qb4sq_osrs_properties as a 
  inner join qb4sq_osrs_agents as b 
  on b.id = a.agent_id 
  left join qb4sq_osrs_company_agents as c 
  on c.agent_id = b.id 
  where a.id = '394'

Explicar

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	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	36	100.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.18 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/route.php:88
14	OSPRoute::getItemid()	JROOT/modules/mod_ospropertyrandom/helper.php:318
13	modOSpropertyramdomHelper::getItemid()	JROOT/modules/mod_ospropertyrandom/tmpl/default.php:50
12	require JROOT/modules/mod_ospropertyrandom/tmpl/default.php	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:118
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.698 MB Filas devueltas: 1

SELECT category_id

  FROM qb4sq_osrs_property_categories

  WHERE pid="394"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_property_categories	NULL	ref	pid	pid	5	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_osproperty/helpers/helper.php:3200
15	OSPHelper::getCategoryIdsOfProperty()	JROOT/components/com_osproperty/helpers/route.php:99
14	OSPRoute::getItemid()	JROOT/modules/mod_ospropertyrandom/helper.php:318
13	modOSpropertyramdomHelper::getItemid()	JROOT/modules/mod_ospropertyrandom/tmpl/default.php:50
12	require JROOT/modules/mod_ospropertyrandom/tmpl/default.php	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:118
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.706 MB Filas devueltas: 0

Select id 
  from qb4sq_menu 
  where published = '1' 
  and ((`link` like '%view=ldetails&id=394%') or (`link` like '%view=ldetails&ampid=394%'))  
  and `access` IN (1,1,5)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:118
14	OSPRoute::getItemid()	JROOT/modules/mod_ospropertyrandom/helper.php:318
13	modOSpropertyramdomHelper::getItemid()	JROOT/modules/mod_ospropertyrandom/tmpl/default.php:50
12	require JROOT/modules/mod_ospropertyrandom/tmpl/default.php	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:118
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.57 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.067 MB memoria antes de la consulta: 13.714 MB Filas devueltas: 30

Consultas duplicadas: #66

Select * 
  from qb4sq_menu 
  where published = '1' 
  and `home` = '0' 
  and `link` like '%view=ltype%'  
  and `access` IN (1,1,5)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_menu	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	113	0.88	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.40 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/route.php:125
14	OSPRoute::getItemid()	JROOT/modules/mod_ospropertyrandom/helper.php:318
13	modOSpropertyramdomHelper::getItemid()	JROOT/modules/mod_ospropertyrandom/tmpl/default.php:50
12	require JROOT/modules/mod_ospropertyrandom/tmpl/default.php	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:118
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.44 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.717 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_menu 
  where id = '125' 
  and published = '1' 
  and (`link` like '%view=ldetails%' 
  and `link` like '%id=394%')  
  and `access` IN (1,1,5)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:598
20	OSPRoute::checkDirectPropertyLink()	JROOT/components/com_osproperty/router.php:328
19	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_ospropertyrandom/tmpl/default.php:76
12	require JROOT/modules/mod_ospropertyrandom/tmpl/default.php	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:118
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.070 MB memoria antes de la consulta: 13.727 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_properties 
  where id = '394'

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:357
19	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_ospropertyrandom/tmpl/default.php:76
12	require JROOT/modules/mod_ospropertyrandom/tmpl/default.php	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:118
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.11 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.757 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "e1265ae9ba8f614281e530878a493272"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_urls	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	853	11.11	Using where

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	1.97 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/router.php:844
19	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_ospropertyrandom/tmpl/default.php:76
12	require JROOT/modules/mod_ospropertyrandom/tmpl/default.php	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:118
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.47 ms Después de la última consulta: 5.30 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 14.107 MB Filas devueltas: 2

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

  FROM `qb4sq_categories` AS `s`

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

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

  ORDER BY c.lft

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

58 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

8 × SELECT COUNT(id) 
  FROM qb4sq_osrs_urls

4 × Select * 
  from qb4sq_osrs_categories

```
4 × SELECT id 
  FROM qb4sq_menu
```

3 × Select * 
  from qb4sq_osrs_themes

3 × Select count(id) 
  from qb4sq_osrs_properties

3 × Select * 
  from qb4sq_osrs_currencies

2 × SELECT id, category_name as category_name 
  FROM qb4sq_osrs_categories

2 × Select * 
  from qb4sq_osrs_countries

2 × SELECT category_id 
  FROM qb4sq_osrs_property_categories

2 × Select fieldvalue 
  from qb4sq_osrs_configuration

2 × Select a.agent_id,a.pro_type, a.city, a.state, a.country, a.isFeatured, b.agent_type, c.company_id 
  from qb4sq_osrs_properties as a 
  inner join qb4sq_osrs_agents as b 
  on b.id = a.agent_id 
  left join qb4sq_osrs_company_agents as c 
  on c.agent_id = b.id

```
2 × Select id 
  from qb4sq_menu
```

2 × Select count(id) 
  from qb4sq_menu

2 × Select * 
  from qb4sq_osrs_configuratio

2 × Select * 
  from qb4sq_osrs_properties

```
2 × Select * 
  from qb4sq_menu
```

1 × Select state_name 
  from qb4sq_osrs_states

1 × SELECT image 
  FROM qb4sq_osrs_photos

1 × Select * 
  from qb4sq_osrs_comments

1 × select count(id) 
  from qb4sq_osrs_photos

1 × select image 
  from qb4sq_osrs_photos

1 × Select * 
  from qb4sq_osrs_photos

1 × SELECT p.*, s.state_name, c.country_name,ty.id as typeid, ty.type_name as type_name 
  FROM qb4sq_osrs_properties AS p         
  INNER JOIN qb4sq_osrs_types AS ty 
  ON ty.id = p.pro_type         
  LEFT JOIN qb4sq_osrs_states AS s 
  ON s.id = p.state         
  INNER JOIN qb4sq_osrs_countries AS c 
  ON c.id = p.country         
  INNER JOIN qb4sq_osrs_agents as ag 
  ON p.agent_id = ag.id

1 × Select id as value, country_name as text, country_name 
  from qb4sq_osrs_countries

1 × Select count(id) 
  from qb4sq_osrs_comments

1 × Select id as value,type_name as text 
  from qb4sq_osrs_types

1 × Select a.id as value, a.name as text 
  from qb4sq_osrs_agents as a 
  inner join qb4sq_users as b 
  on b.id = a.user_id

1 × Select currency_symbol 
  from qb4sq_osrs_currencies

1 × Select count(id) 
  from qb4sq_osrs_agents

1 × Select id as value, currency_code as text 
  from qb4sq_osrs_currencies

1 × SELECT * 
  FROM qb4sq_osrs_property_open

1 × SELECT `data` 
  FROM `qb4sq_session`

1 × Select count(distinct a.id) 
  from qb4sq_osrs_properties as a 
  INNER JOIN qb4sq_osrs_agents as c 
  on c.id = a.agent_id 
  LEFT JOIN qb4sq_osrs_types as d 
  on d.id = a.pro_type 
  INNER JOIN qb4sq_osrs_countries as e 
  on e.id = a.country 
  LEFT JOIN qb4sq_osrs_property_categories as g 
  on g.pid = a.id

1 × SELECT category_name 
  FROM qb4sq_osrs_categories

1 × Select id,company_name,photo 
  from qb4sq_osrs_companies

1 × SELECT id, rules 
  FROM `qb4sq_viewlevels

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

1 × SELECT `query` 
  FROM qb4sq_osrs_urls

1 × Select count(id) 
  from qb4sq_osrs_configuration

1 × SELECT lang_id, lang_code, title, `sef` 
  FROM qb4sq_languages

1 × SELECT * 
  FROM qb4sq_osrs_configuratio

1 × Select * 
  from qb4sq_osrs_agents

1 × Select id, alias, name 
  from qb4sq_osrs_agents

1 × Select state_name as state_name 
  from qb4sq_osrs_states

1 × Select * 
  from qb4sq_osrs_extra_fields

1 × Select country_name 
  from qb4sq_osrs_countries

1 × Select id,pro_name,hits 
  from qb4sq_osrs_properties

1 × Select id,pro_name,(total_points/number_votes) as rated 
  from qb4sq_osrs_properties

1 × Select agent_type 
  from qb4sq_osrs_agents

1 × Select city 
  from qb4sq_osrs_cities

1 × Select state_code 
  from qb4sq_osrs_states

1 × Select id, company_alias, company_name 
  from qb4sq_osrs_companies

1 × SELECT `session_id` 
  FROM `qb4sq_session`

1 × Select a.*,c.name as agent_name,c.photo as agent_photo, c.mobile as agent_mobile, c.phone as agent_phone,c.email as agent_email, c.optin,d.id as typeid,d.type_name as type_name,e.country_name 
  from qb4sq_osrs_properties as a 
  INNER JOIN qb4sq_osrs_agents as c 
  on c.id = a.agent_id 
  LEFT JOIN qb4sq_osrs_types as d 
  on d.id = a.pro_type 
  LEFT JOIN qb4sq_osrs_countries as e 
  on e.id = a.country 
  LEFT JOIN qb4sq_osrs_property_categories as g 
  on g.pid = a.id

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

OTRAS tablas:

1 × INSERT INTO `qb4sq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3539373439633132396335336634653865383837343665336631666632366235', 1, 1715106362, 0, '', 0

1 × UPDATE `qb4sq_extensions` 
  SET `params` = '{\"mediaversion\":\"495d241729d4c4846757b8a232c26e34\"}'

1 × UPDATE qb4sq_osrs_configuration 
  SET fieldvalue = '0'

Zaira Torres

En Venta

CASA EN VENTA EN ZIBATA, EL MARQUEZ, QRO

Crealtor.mx

Contáctanos

Oficinas en...

Propiedad Destacada

E4-COV1309, DEPARTAMENTO EN VENTA EN MAZATLÁN, FRACC. LAS GAVIOTAS 3,495,000 MXN

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

87 consultas registradas 66.81 ms

¡ 11 duplicaciones detectadas!

58 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: