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": 1715162654,
                "last": 1715162654,
                "now": 1715162654
            },
            "token": "JuqYlvEIpQHCIImNJY0exIQZseD9YS6M"
        },
        "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": 45
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 5.10 ms / 5.10 ms Memoria: 0.416 MB / 0.74 MB Application: afterLoad

Fecha y hora: 16.96 ms / 22.06 ms Memoria: 0.827 MB / 1.57 MB Application: afterInitialise

Fecha y hora: 6.03 ms / 28.09 ms Memoria: 0.474 MB / 2.04 MB Application: afterRoute

Fecha y hora: 1.10 ms / 29.19 ms Memoria: 0.042 MB / 2.08 MB Application: beforeRenderComponent com_osproperty

Fecha y hora: 42.78 ms / 71.97 ms Memoria: 1.039 MB / 3.12 MB Application: afterRenderComponent com_osproperty

Fecha y hora: 0.75 ms / 72.72 ms Memoria: 0.009 MB / 3.13 MB Application: afterDispatch

Fecha y hora: 3.48 ms / 76.20 ms Memoria: 0.180 MB / 3.31 MB Application: beforeRenderModule mod_ebwhatsappchat (EB Whatsapp Chat)

Fecha y hora: 0.57 ms / 76.77 ms Memoria: 0.016 MB / 3.33 MB Application: afterRenderRawModule mod_ebwhatsappchat (EB Whatsapp Chat)

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

Fecha y hora: 0.81 ms / 77.58 ms Memoria: 0.059 MB / 3.39 MB Application: afterRenderModule mod_ebwhatsappchat (EB Whatsapp Chat)

Fecha y hora: 0.07 ms / 77.65 ms Memoria: 0.012 MB / 3.40 MB Application: beforeRenderModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 18.28 ms / 95.93 ms Memoria: 0.184 MB / 3.58 MB Application: afterRenderRawModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 0.02 ms / 95.94 ms Memoria: -0.038 MB / 3.54 MB Application: beforeRenderModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 0.20 ms / 96.14 ms Memoria: 0.002 MB / 3.55 MB Application: afterRenderModule mod_ospropertyrandom (Propiedad Destacada)

Fecha y hora: 0.62 ms / 96.76 ms Memoria: 0.021 MB / 3.57 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 1.04 ms / 97.81 ms Memoria: 0.031 MB / 3.60 MB Application: afterRenderRawModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.01 ms / 97.82 ms Memoria: -0.004 MB / 3.59 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.14 ms / 97.95 ms Memoria: 0.004 MB / 3.60 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.36 ms / 98.31 ms Memoria: 0.005 MB / 3.60 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 2.76 ms / 101.06 ms Memoria: 0.142 MB / 3.75 MB Application: afterRenderRawModule mod_menu (Main Menu)

Fecha y hora: 0.01 ms / 101.07 ms Memoria: -0.003 MB / 3.74 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 0.17 ms / 101.24 ms Memoria: 0.002 MB / 3.75 MB Application: afterRenderModule mod_menu (Main Menu)

Fecha y hora: 3.69 ms / 104.94 ms Memoria: 0.217 MB / 3.96 MB Application: afterRender

Total de consultas a la base de datos: 54.79 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'3963316365393663613838653138393439376130343362316339393135336466', 1, 1715162654, 0, '', 0)

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
update	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.53 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: 0.26 ms Después de la última consulta: 1.07 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.01 ms
init	0.00 ms
System lock	0.02 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.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: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.23 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.126 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.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.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.29 ms Después de la última consulta: 9.11 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.935 MB Filas devueltas: 1

SELECT `query`

  FROM qb4sq_osrs_urls

  WHERE md5_key="89aa4b196b48c8a13a6549bb1eaebd80"

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.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	1.98 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
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.39 ms Después de la última consulta: 1.76 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 2.046 MB

UPDATE `qb4sq_extensions`

  SET `params` = '{\"mediaversion\":\"3fbd157a7bbc66d29bab5dd85f2e692a\"}'

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

Explicar

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

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.11 ms
updating	0.06 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
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: 3.17 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 2.504 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.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 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.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.16 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 2.510 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.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.03 ms
updating	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
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.16 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.047 MB memoria antes de la consulta: 2.517 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.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
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.20 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 2.760 MB Filas devueltas: 1

Consultas duplicadas: #14 #36

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.04 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
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.27 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 2.768 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.02 ms
executing	0.04 ms
end	0.02 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.26 ms Después de la última consulta: 1.08 ms Consulta a la memoria: 0.048 MB memoria antes de la consulta: 2.779 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	1.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
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.14 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.031 MB Filas devueltas: 1

Consultas duplicadas: #11 #36

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.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
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.17 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.047 MB memoria antes de la consulta: 2.600 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.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.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: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.17 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.651 MB Filas devueltas: 1

Consultas duplicadas: #28

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

Select * 
  from qb4sq_osrs_agents 
  where id = '45'

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.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.16 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.669 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.74 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.684 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 "%45%" ) 
  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.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.02 ms
statistics	0.04 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.00 ms

Llamada de pila

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

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

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

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

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.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: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.75 ms Después de la última consulta: 0.78 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 "89aa4b196b48c8a13a6549bb1eaebd80"

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.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.38 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.25 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.01 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.00 ms
System lock	0.01 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
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.42 ms Después de la última consulta: 0.04 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.25 ms Después de la última consulta: 0.04 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 = '123'

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.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: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: 2.44 ms Después de la última consulta: 0.04 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 = '45' 
  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.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.05 ms
preparing	0.03 ms
executing	1.80 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: 2.44 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 2.793 MB Filas devueltas: 2

Select id,pro_name,hits 
  from qb4sq_osrs_properties 
  where hits > 0  
  and agent_id = '45' 
  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.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	1.86 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

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

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

Tiempo de la consulta: 1.75 ms Después de la última consulta: 0.05 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 = '45' 
  and published = '1' 
  and approved = '1' 
  and number_votes > 0 
  order by (total_points/number_votes) desc 
  limit 5

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	1.53 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.19 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.810 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.03 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.17 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.831 MB Filas devueltas: 1

Select agent_type 
  from qb4sq_osrs_agents 
  where id = '45'

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

Llamada de pila

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

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

Tiempo de la consulta: 0.12 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.838 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.15 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.846 MB Filas devueltas: 0

Select state_code 
  from qb4sq_osrs_states 
  where id = '0'

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.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.17 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.854 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_countries 
  where id = '123'

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.77 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.879 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.09 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.10 ms
preparing	0.02 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
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.34 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.883 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.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.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.59 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.896 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.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	2.34 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
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.43 ms Después de la última consulta: 0.65 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.898 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.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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/helpers/helper.php:3047
12	OSPHelper::getConfig()	JROOT/components/com_osproperty/helpers/helper.php:2961
11	OSPHelper::userOneState()	JROOT/components/com_osproperty/classes/listing.php:2833
10	OspropertyListing::listProperties()	JROOT/components/com_osproperty/classes/agent.html.php:1190
9	HTML_OspropertyAgent::agentInfoForm()	JROOT/components/com_osproperty/classes/agent.php:464
8	OspropertyAgent::agentInfo()	JROOT/components/com_osproperty/classes/agent.php:59
7	OspropertyAgent::display()	JROOT/components/com_osproperty/osproperty.php:263
6	require_once JROOT/components/com_osproperty/osproperty.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.24 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.927 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.country = '120' 
  AND a.agent_id = '45' 
  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-08 10:04:14'  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-08 10:04:14'  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	e	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	g	NULL	ref	pid	pid	5	crealtor_pagina_es.a.id	1	100.00	Using index

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.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.01 ms
optimizing	0.06 ms
statistics	0.16 ms
preparing	0.08 ms
executing	1.63 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.83 ms Después de la última consulta: 1.04 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 3.094 MB Filas devueltas: 0

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.country = '120' 
  AND a.agent_id = '45' 
  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-08 10:04:14'  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-08 10:04:14'  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.08 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
executing	1.94 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.18 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.101 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.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.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
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.42 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.109 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.03 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/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.32 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.118 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.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: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: 2.27 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.125 MB Filas devueltas: 8

Select id as value,state_name as text, state_name 
  from qb4sq_osrs_states 
  where published = 1  
  and country_id = '120' 
  and id in (Select state 
  from qb4sq_osrs_properties 
  where approved = '1' 
  and published = '1') 
  order by state_name

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	qb4sq_osrs_states	NULL	ref	PRIMARY,country_id,published	country_id	4	const	7	93.75	Using where; Usando 'filesort'
1	SIMPLE	<subquery2>	NULL	eq_ref	<auto_distinct_key>	<auto_distinct_key>	5	crealtor_pagina_es.qb4sq_osrs_states.id	1	100.00	NULL
2	MATERIALIZED	qb4sq_osrs_properties	NULL	ref	published,approved	published	2	const	317	99.46	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.03 ms
init	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	1.65 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osproperty/helpers/common.php:206
11	HelperOspropertyCommon::makeStateList()	JROOT/components/com_osproperty/classes/listing.php:3351
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.49 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.169 MB Filas devueltas: 34

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.19 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
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.20 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 3.201 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_themes 
  where name like 'theme3'

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.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
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.52 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.236 MB Filas devueltas: 1

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

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
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.58 ms Después de la última consulta: 2.60 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 3.302 MB Filas devueltas: 10

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-08 10:04:14') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-08 10:04:14') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 124 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.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.25 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
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: 7.99 ms Después de la última consulta: 2.93 ms Consulta a la memoria: 0.067 MB memoria antes de la consulta: 3.423 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-08 10:04:14'  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-08 10:04:14'  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.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.05 ms
executing	6.79 ms
end	0.01 ms
query end	0.47 ms
closing tables	0.02 ms
freeing items	0.04 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:1701
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_ospropertyrandom/helper.php:263
12	modOSpropertyramdomHelper->getProperty()	JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php:39
11	include JROOT/modules/mod_ospropertyrandom/mod_ospropertyrandom.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.446 MB Filas devueltas: 19

SELECT image 
  FROM qb4sq_osrs_photos 
  WHERE pro_id = 394 
  order by ordering

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
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.22 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.469 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.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.03 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/helper.php:7238
14	OSPHelper::showPrice()	JROOT/components/com_osproperty/helpers/helper.php:2730
13	OSPHelper::generatePrice()	JROOT/modules/mod_ospropertyrandom/helper.php:290
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.13 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.476 MB Filas devueltas: 1

Select currency_symbol 
  from qb4sq_osrs_currencies 
  where id = '33'

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.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/common.php:1563
14	HelperOspropertyCommon::loadCurrency()	JROOT/components/com_osproperty/helpers/helper.php:2730
13	OSPHelper::generatePrice()	JROOT/modules/mod_ospropertyrandom/helper.php:290
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.27 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.470 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.04 ms
preparing	0.03 ms
executing	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
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.68 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.485 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.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.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
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.14 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.487 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.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
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.14 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.501 MB Filas devueltas: 1

SELECT COUNT(id)

  FROM qb4sq_osrs_urls

  WHERE md5_key like "9b6b469f70bc4c11ee759b5c27dcc8a2"

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.518 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.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.528 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.56 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.535 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.41 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Llamada de pila

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

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

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

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.38 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.16 ms Después de la última consulta: 0.44 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.548 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.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
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.29 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.070 MB memoria antes de la consulta: 3.558 MB Filas devueltas: 1

Select * 
  from qb4sq_osrs_properties 
  where id = '394'

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.08 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.21 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.588 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.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.03 ms
preparing	0.01 ms
executing	1.95 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.10 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.17 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.590 MB Filas devueltas: 1

Select id, country_name 
  from qb4sq_osrs_countries 
  where id = '120'

Explicar

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

Perfil

Status	Duration
starting	0.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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_osproperty/router.php:519
22	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
15	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
14	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:628
9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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.05 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 3.602 MB Filas devueltas: 1

Select count(id) 
  from qb4sq_menu 
  where id = '124' 
  and published = '1'

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_osproperty/helpers/route.php:612
23	OSPRoute::compareMenuItem()	JROOT/components/com_osproperty/router.php:564
22	OspropertyRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
15	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
14	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:628
9	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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.59 ms Después de la última consulta: 6.25 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.945 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.16 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Llamada de pila

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

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

51 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

4 × SELECT COUNT(id) 
  FROM qb4sq_osrs_urls

```
3 × SELECT id 
  FROM qb4sq_menu
```

3 × Select * 
  from qb4sq_osrs_currencies

3 × Select * 
  from qb4sq_osrs_themes

2 × Select * 
  from qb4sq_osrs_categories

2 × Select count(id) 
  from qb4sq_menu

2 × Select * 
  from qb4sq_osrs_configuratio

2 × Select fieldvalue 
  from qb4sq_osrs_configuration

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

1 × Select id as value,state_name as text, state_name 
  from qb4sq_osrs_states

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 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 image 
  FROM qb4sq_osrs_photos

1 × SELECT `data` 
  FROM `qb4sq_session`

1 × Select currency_symbol 
  from qb4sq_osrs_currencies

1 × SELECT id, category_name as category_name 
  FROM qb4sq_osrs_categories

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

1 × SELECT category_id 
  FROM qb4sq_osrs_property_categories

```
1 × Select id 
  from qb4sq_menu
```
```
1 × Select * 
  from qb4sq_menu
```

1 × Select * 
  from qb4sq_osrs_properties

1 × Select id, country_name 
  from qb4sq_osrs_countries

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

1 × Select state_code 
  from qb4sq_osrs_states

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

1 × SELECT id, rules 
  FROM `qb4sq_viewlevels

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

1 × SELECT `query` 
  FROM qb4sq_osrs_urls

1 × Select count(id) 
  from qb4sq_osrs_configuration

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

1 × SELECT * 
  FROM qb4sq_osrs_configuratio

1 × Select * 
  from qb4sq_osrs_agents

1 × Select id, alias, name 
  from qb4sq_osrs_agents

1 × Select state_name as state_name 
  from qb4sq_osrs_states

1 × Select id, company_alias, company_name 
  from qb4sq_osrs_companies

1 × Select country_name 
  from qb4sq_osrs_countries

1 × Select count(id) 
  from qb4sq_osrs_properties

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

1 × Select * 
  from qb4sq_osrs_countries

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'3963316365393663613838653138393439376130343362316339393135336466', 1, 1715162654, 0, '', 0

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

1 × UPDATE qb4sq_osrs_configuration 
  SET fieldvalue = '0'

Mario Andrés Rodrigo Ugalde Salazar

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

64 consultas registradas 54.79 ms

¡ 7 duplicaciones detectadas!

51 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: