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": 1715395389,
                "last": 1715395389,
                "now": 1715395389
            },
            "token": "Jk7BOUORpIssHwvJC26HHxUgEuK5Ntel"
        },
        "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": 34
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 11.61 ms / 11.61 ms Memoria: 0.418 MB / 0.74 MB Application: afterLoad

Fecha y hora: 78.59 ms / 90.20 ms Memoria: 0.826 MB / 1.57 MB Application: afterInitialise

Fecha y hora: 65.95 ms / 156.15 ms Memoria: 0.472 MB / 2.04 MB Application: afterRoute

Fecha y hora: 3.60 ms / 159.75 ms Memoria: 0.037 MB / 2.08 MB Application: beforeRenderComponent com_osproperty

Fecha y hora: 79.66 ms / 239.41 ms Memoria: 1.268 MB / 3.35 MB Application: afterRenderComponent com_osproperty

Fecha y hora: 1.75 ms / 241.17 ms Memoria: 0.009 MB / 3.36 MB Application: afterDispatch

Fecha y hora: 14.67 ms / 255.84 ms Memoria: 0.167 MB / 3.52 MB Application: beforeRenderModule mod_ebwhatsappchat (EB Whatsapp Chat)

Fecha y hora: 3.38 ms / 259.22 ms Memoria: 0.016 MB / 3.54 MB Application: afterRenderRawModule mod_ebwhatsappchat (EB Whatsapp Chat)

Fecha y hora: 0.01 ms / 259.23 ms Memoria: -0.001 MB / 3.54 MB Application: beforeRenderModule mod_ebwhatsappchat (EB Whatsapp Chat)

Fecha y hora: 3.81 ms / 263.04 ms Memoria: 0.047 MB / 3.58 MB Application: afterRenderModule mod_ebwhatsappchat (EB Whatsapp Chat)

Fecha y hora: 0.09 ms / 263.13 ms Memoria: 0.012 MB / 3.60 MB Application: beforeRenderModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 42.68 ms / 305.81 ms Memoria: 0.161 MB / 3.76 MB Application: afterRenderRawModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 0.02 ms / 305.83 ms Memoria: -0.035 MB / 3.72 MB Application: beforeRenderModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 0.91 ms / 306.74 ms Memoria: 0.002 MB / 3.72 MB Application: afterRenderModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 13.21 ms / 319.94 ms Memoria: 0.022 MB / 3.75 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 10.41 ms / 330.35 ms Memoria: 0.206 MB / 3.95 MB Application: afterRenderRawModule mod_menu (Main Menu)

Fecha y hora: 0.03 ms / 330.38 ms Memoria: -0.195 MB / 3.76 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 0.17 ms / 330.55 ms Memoria: 0.003 MB / 3.76 MB Application: afterRenderModule mod_menu (Main Menu)

Fecha y hora: 9.52 ms / 340.07 ms Memoria: 0.338 MB / 4.10 MB Application: afterRender

Total de consultas a la base de datos: 99.31 ms

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'3662363236663161396437393166383461323533396366346166636435336435', 1, 1715395389, 0, '', 0)

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.02 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
update	9.06 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	1.25 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/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: 1.11 ms Después de la última consulta: 11.11 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.113 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.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.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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.20 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.127 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.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.04 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.49 ms Después de la última consulta: 63.17 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.933 MB Filas devueltas: 1

SELECT `query`

  FROM qb4sq_osrs_urls

  WHERE md5_key="62c428533830d84fd8bc77bf402512fc"

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.10 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.02 ms
preparing	0.02 ms
executing	2.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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.65 ms Después de la última consulta: 15.60 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 2.044 MB

UPDATE `qb4sq_extensions`

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

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

Explicar

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

Perfil

Status	Duration
starting	0.08 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.09 ms
updating	0.33 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 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.31 ms Después de la última consulta: 15.70 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 2.497 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.06 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.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.05 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
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: 2.503 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.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.03 ms
updating	0.07 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.15 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.047 MB memoria antes de la consulta: 2.510 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.01 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	0.99 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
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.15 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 2.753 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.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.01 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.26 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 2.761 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.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.05 ms
preparing	0.04 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	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
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.17 ms Después de la última consulta: 2.25 ms Consulta a la memoria: 0.048 MB memoria antes de la consulta: 2.771 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.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.99 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: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.15 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.023 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.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/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.16 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.047 MB memoria antes de la consulta: 2.593 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.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
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.19 ms Después de la última consulta: 0.40 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.639 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.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
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: 1.62 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.653 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_agents 
  where id = '34'

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.02 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: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.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.661 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.00 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.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/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.70 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.676 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 "%34%" ) 
  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.04 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.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.49 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

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.09 ms Después de la última consulta: 3.10 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.746 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.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	1.92 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: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.14 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.754 MB Filas devueltas: 1

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

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.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: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.62 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.765 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "62c428533830d84fd8bc77bf402512fc"

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	1.98 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/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.20 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.770 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.01 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
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.12 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.776 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.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
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.63 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.781 MB Filas devueltas: 1

Select country_name 
  from qb4sq_osrs_countries 
  where id = '121'

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.02 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: 4.41 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.787 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_osrs_properties 
  where agent_id = '34' 
  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.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
executing	4.11 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: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.80 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.793 MB Filas devueltas: 1

Select id,pro_name,hits 
  from qb4sq_osrs_properties 
  where hits > 0  
  and agent_id = '34' 
  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.05 ms
preparing	0.02 ms
executing	1.47 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: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: 2.16 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.799 MB Filas devueltas: 0

Select id,pro_name,(total_points/number_votes) as rated 
  from qb4sq_osrs_properties 
  where agent_id = '34' 
  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.47 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 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.42 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: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.16 ms Después de la última consulta: 0.38 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.805 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.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.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.14 ms Después de la última consulta: 1.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.867 MB Filas devueltas: 1

Select agent_type 
  from qb4sq_osrs_agents 
  where id = '34'

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.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: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.11 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.874 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.10 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.882 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.01 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.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

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.14 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.896 MB Filas devueltas: 1

Consultas duplicadas: #54

Select * 
  from qb4sq_osrs_countries 
  where id = '121'

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.01 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
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.61 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.916 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.04 ms
preparing	0.02 ms
executing	0.39 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/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.13 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.919 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.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: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.12 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.932 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	1.97 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.18 ms Después de la última consulta: 1.96 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.899 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.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.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: 1.94 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.929 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 = '34' 
  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-11 02:43:09'  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-11 02:43:09'  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.10 ms
preparing	0.06 ms
executing	1.52 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
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.37 ms Después de la última consulta: 1.65 ms Consulta a la memoria: 0.071 MB memoria antes de la consulta: 3.082 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 = '34' 
  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-11 02:43:09'  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-11 02:43:09'  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.09 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.07 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.04 ms
executing	1.91 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
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.22 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.099 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.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	0.06 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: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.80 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.105 MB Filas devueltas: 1

Consultas duplicadas: #42

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

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.65 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.82 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.112 MB Filas devueltas: 1

Consultas duplicadas: #41

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

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.02 ms
executing	1.66 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: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.25 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.120 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 ="185")

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.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: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.65 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.134 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.05 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.02 ms
statistics	0.05 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.14 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.136 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_categories 
  where id = '4'

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.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
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.07 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.149 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "8dc145fe3df6a3792aa07a30af4d89b1"

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.94 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: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.25 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.153 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 ="185")

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.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.04 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.35 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.163 MB Filas devueltas: 0

SELECT *

  FROM qb4sq_osrs_property_open

  WHERE pid='185' 
  and end_to > '2024-05-11 02:43:09'

  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.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.20 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.13 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.169 MB Filas devueltas: 0

Select * 
  from qb4sq_osrs_comments 
  where pro_id = '185' 
  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.54 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.175 MB Filas devueltas: 1

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

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	6	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.19 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: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.18 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.180 MB Filas devueltas: 1

select image 
  from qb4sq_osrs_photos 
  where pro_id = '185' 
  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	6	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.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
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.18 ms Después de la última consulta: 0.92 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.186 MB Filas devueltas: 10

Select * 
  from qb4sq_osrs_photos 
  where pro_id = '185'

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	6	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.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
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.12 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.201 MB Filas devueltas: 1

Select state_name 
  from qb4sq_osrs_states 
  where id = '10'

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.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
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.12 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.207 MB Filas devueltas: 1

Consultas duplicadas: #33

Select * 
  from qb4sq_osrs_countries 
  where id = '121'

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.12 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.214 MB Filas devueltas: 1

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

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.02 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.16 ms Después de la última consulta: 0.41 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.221 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.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.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: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.19 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.229 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.05 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.22 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.237 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.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 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.02 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.34 ms Después de la última consulta: 0.40 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.282 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.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.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
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.18 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.314 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.00 ms
statistics	0.01 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: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.32 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.349 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.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.14 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.32 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.358 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.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.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
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.24 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.376 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 = '185'

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.03 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
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 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.31 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.386 MB Filas devueltas: 1

SELECT category_id

  FROM qb4sq_osrs_property_categories

  WHERE pid="185"

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.03 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.55 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 3.403 MB Filas devueltas: 0

Select id 
  from qb4sq_menu 
  where published = '1' 
  and ((`link` like '%view=ldetails&id=185%') or (`link` like '%view=ldetails&ampid=185%'))  
  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.39 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/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.60 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.067 MB memoria antes de la consulta: 3.416 MB Filas devueltas: 30

Consultas duplicadas: #84

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: 3.420 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_menu 
  where id = '131' 
  and published = '1' 
  and (`link` like '%view=ldetails%' 
  and `link` like '%id=185%')  
  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.23 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.068 MB memoria antes de la consulta: 3.431 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_properties 
  where id = '185'

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.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
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.35 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.454 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "2a84bf817f8f1b0cc9f40b0e95cdceac"

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
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.16 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.452 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.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: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.22 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.465 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.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.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
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.33 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.472 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.09 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: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.15 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.481 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.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
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: 0.62 ms Después de la última consulta: 9.06 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 3.513 MB Filas devueltas: 9

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

  FROM qb4sq_modules AS m

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

  LEFT JOIN qb4sq_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-11 02:43:09') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-11 02:43:09') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	26	1.82	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	crealtor_pagina_es.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	crealtor_pagina_es.m.module,const	1	10.00	Using index condition; Using where

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
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.27 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:441
16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:371
15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:655
12	T3Template->countModules()	JROOT/templates/osprealhomes/tpls/blocks/header.php:18
11	include JROOT/templates/osprealhomes/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:202
10	T3Template->loadBlock()	JROOT/templates/osprealhomes/tpls/default.php:32
9	include JROOT/templates/osprealhomes/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
8	T3Template->loadLayout()	JROOT/templates/osprealhomes/index.php:34
7	require JROOT/templates/osprealhomes/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 21.59 ms Después de la última consulta: 15.44 ms Consulta a la memoria: 0.064 MB memoria antes de la consulta: 3.620 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-11 02:43:09'  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-11 02:43:09'  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.09 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.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
executing	6.77 ms
end	0.01 ms
query end	0.50 ms
closing tables	0.02 ms
freeing items	0.03 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: 1.12 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.640 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.04 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.04 ms
preparing	0.01 ms
executing	0.12 ms
end	0.00 ms
query end	0.01 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
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.09 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.648 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.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 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.75 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.664 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.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 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
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.16 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.666 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.00 ms
optimizing	0.01 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.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/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.16 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.680 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.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	1.98 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/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: 1.17 ms Después de la última consulta: 3.47 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.693 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.00 ms
starting	0.00 ms
checking permissions	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.03 ms
statistics	0.05 ms
preparing	0.02 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
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.98 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.703 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.03 ms
preparing	0.01 ms
executing	0.03 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
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: 1.19 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.710 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.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
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: 1.04 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.067 MB memoria antes de la consulta: 3.718 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.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.39 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/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.31 ms Después de la última consulta: 0.45 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.722 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.73 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.067 MB memoria antes de la consulta: 3.732 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.03 ms
Executing hook on transaction	0.01 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.03 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
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.24 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.759 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.00 ms
optimizing	0.00 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.44 ms Después de la última consulta: 36.21 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.081 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.10 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.05 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.02 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.]

59 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 count(id) 
  from qb4sq_osrs_properties

3 × Select * 
  from qb4sq_osrs_currencies

3 × Select * 
  from qb4sq_osrs_themes

2 × Select fieldvalue 
  from qb4sq_osrs_configuration

2 × SELECT id, category_name as category_name 
  FROM qb4sq_osrs_categories

2 × Select * 
  from qb4sq_osrs_countries

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 category_id 
  FROM qb4sq_osrs_property_categories

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

2 × Select * 
  from qb4sq_osrs_properties

2 × Select * 
  from qb4sq_osrs_configuratio

2 × Select count(id) 
  from qb4sq_menu

1 × Select count(id) 
  from qb4sq_osrs_comments

1 × SELECT image 
  FROM qb4sq_osrs_photos

1 × select count(id) 
  from qb4sq_osrs_photos

1 × select image 
  from qb4sq_osrs_photos

1 × Select * 
  from qb4sq_osrs_photos

1 × Select state_name 
  from qb4sq_osrs_states

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 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 count(id) 
  from qb4sq_osrs_agents

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

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

1 × Select currency_symbol 
  from qb4sq_osrs_currencies

1 × Select * 
  from qb4sq_osrs_comments

1 × SELECT `data` 
  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 * 
  FROM qb4sq_osrs_property_open

1 × Select state_name as state_name 
  from qb4sq_osrs_states

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 id,company_name,photo 
  from qb4sq_osrs_companies

1 × Select country_name 
  from qb4sq_osrs_countries

1 × SELECT category_name 
  FROM qb4sq_osrs_categories

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 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 `session_id` 
  FROM `qb4sq_session`

1 × Select * 
  from qb4sq_osrs_extra_fields

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'3662363236663161396437393166383461323533396366346166636435336435', 1, 1715395389, 0, '', 0

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

1 × UPDATE qb4sq_osrs_configuration 
  SET fieldvalue = '0'

Luz Adriana Ponce Sánchez

En Venta

SE VENDE TERRENO EN LAS PINTITAS. EL SALTO, JALISCO.

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

88 consultas registradas 99.31 ms

¡ 13 duplicaciones detectadas!

59 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: