Разместить объявление

Notice: Trying to access array offset on value of type null in /var/www/www-root/data/www/autogrodno.by/components/com_expautospro/helpers/ExpAutosProCategories.php on line 76

Notice: Trying to access array offset on value of type null in /var/www/www-root/data/www/autogrodno.by/components/com_expautospro/router.php on line 166

Notice: Trying to access array offset on value of type null in /var/www/www-root/data/www/autogrodno.by/components/com_expautospro/router.php on line 202

Год выпуска:
Цена, USD

+ еще

Продажа автомобилей в Беларуси

Консоль отладки

Сессия

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1766708049,
                "last": 1766708049,
                "now": 1766708053
            },
            "token": "WRxNyQ0VhUCJyTONjWn3cgzCuXK0SqDT"
        },
        "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
        }
    }
}

Профилирование

Время

Память

Время: 2.34 ms / 2.34 ms Память: 0.415 MB / 0.75 MB Application: afterLoad

Время: 49.71 ms / 52.05 ms Память: 4.493 MB / 5.24 MB Application: afterInitialise

Время: 17.73 ms / 69.78 ms Память: 1.554 MB / 6.79 MB Application: afterRoute

Время: 1.00 ms / 70.79 ms Память: 0.021 MB / 6.82 MB Application: beforeRenderComponent com_expautospro

Время: 188.60 ms / 259.39 ms Память: 21.530 MB / 28.35 MB Application: beforeRenderModule mod_expautospro_search_ajax (Поиск ExpAuto MOBILE TOP)

Время: 118.07 ms / 377.46 ms Память: 0.874 MB / 29.22 MB Application: afterRenderModule mod_expautospro_search_ajax (Поиск ExpAuto MOBILE TOP)

Время: 1.81 ms / 379.27 ms Память: -0.311 MB / 28.91 MB Application: afterRenderComponent com_expautospro

Время: 3.41 ms / 382.68 ms Память: 0.102 MB / 29.01 MB Application: afterDispatch

Время: 15.84 ms / 398.52 ms Память: 0.241 MB / 29.25 MB Application: beforeRenderModule mod_menu ()

Время: 2.73 ms / 401.25 ms Память: 0.160 MB / 29.41 MB Application: afterRenderModule mod_menu ()

Время: 0.46 ms / 401.71 ms Память: -0.013 MB / 29.40 MB Application: beforeRenderModule mod_banners (Баннеры над всем сайтом YooPro)

Время: 9.42 ms / 411.12 ms Память: 0.048 MB / 29.45 MB Application: afterRenderModule mod_banners (Баннеры над всем сайтом YooPro)

Время: 0.35 ms / 411.48 ms Память: -0.007 MB / 29.44 MB Application: beforeRenderModule mod_menu ()

Время: 1.53 ms / 413.01 ms Память: 0.019 MB / 29.46 MB Application: afterRenderModule mod_menu ()

Время: 0.48 ms / 413.49 ms Память: -0.008 MB / 29.45 MB Application: beforeRenderModule mod_login (Login Form)

Время: 3.47 ms / 416.96 ms Память: 0.082 MB / 29.53 MB Application: afterRenderModule mod_login (Login Form)

Время: 0.40 ms / 417.36 ms Память: -0.003 MB / 29.53 MB Application: beforeRenderModule mod_custom ()

Время: 2.59 ms / 419.95 ms Память: 0.029 MB / 29.56 MB Application: afterRenderModule mod_custom ()

Время: 11.65 ms / 431.60 ms Память: 0.293 MB / 29.85 MB Application: afterRender

Время запросов к базе данных: 83.36 ms

Использование памяти

Запросы к базе данных

63 запросов зарегистрировано 83.36 ms

30 повторяющихся запросов зарегистрировано

6 повторяющихся запросов: #11 #12 #14 #15 #19 #20

2 повторяющихся запросов: #16 #21

2 повторяющихся запросов: #28 #41

2 повторяющихся запросов: #29 #42

2 повторяющихся запросов: #30 #43

2 повторяющихся запросов: #31 #44

2 повторяющихся запросов: #32 #45

2 повторяющихся запросов: #33 #46

2 повторяющихся запросов: #34 #47

2 повторяющихся запросов: #35 #48

2 повторяющихся запросов: #36 #49

2 повторяющихся запросов: #37 #50

2 повторяющихся запросов: #38 #51

Время запроса: 0.36 ms Память запроса: 0.023 MB. Память перед запросом: 1.027 MB Возвращено строк: 1

SELECT `data`

  FROM `ja25_session`

  WHERE `session_id` = X'3932343734336532343430343661323336323033393530366266313732303031'

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Такой же, как вызов в строке ниже
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.28 ms После последнего запроса: 1.05 ms Память запроса: 0.021 MB. Память перед запросом: 1.145 MB Возвращено строк: 10

SELECT id, rules

  FROM `ja25_viewlevels`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_viewlevels	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	10	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.28 ms После последнего запроса: 0.09 ms Память запроса: 0.021 MB. Память перед запросом: 1.159 MB Возвращено строк: 2

SELECT b.id

  FROM ja25_usergroups AS a

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

  WHERE a.id = 17

План запросов (Explain)

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

Профиль

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
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.88 ms После последнего запроса: 25.15 ms Память запроса: 0.006 MB. Память перед запросом: 4.010 MB

UPDATE `ja25_extensions`

  SET `params` = '{\"mediaversion\":\"6b9edba7c9d9ed2bb7a4f2517ca3b35c\"}'

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

План запросов (Explain)

EXPLAIN недоступен для UPDATE `ja25_extensions` SET `params` = '{\"mediaversion\":\"6b9edba7c9d9ed2bb7a4f2517ca3b35c\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профиль

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.29 ms
updating	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djclassifiedsyt/djclassifiedsyt.php:57
8	plgSystemDjclassifiedsyt->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.49 ms После последнего запроса: 1.75 ms Память запроса: 0.021 MB. Память перед запросом: 4.464 MB Возвращено строк: 1

SELECT custom_data

  FROM ja25_extensions

  WHERE element = 'yooessentials' 
  AND folder = 'system'

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/yooessentials/helper.php:153
9	plgSystemYooessentials23Helper::fetchConfig()	JROOT/plugins/system/yooessentials/yooessentials.php:58
8	plgSystemYooessentials->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 3.50 ms После последнего запроса: 5.59 ms Память запроса: 0.008 MB. Память перед запросом: 5.086 MB

CREATE TABLE IF NOT EXISTS `ja25_zoo_jbzoo_config` (`
  group` VARCHAR(150) NULL DEFAULT NULL,
 `key` VARCHAR(100) NULL DEFAULT NULL,
 `value` TEXT NULL,
 `type` VARCHAR(10) NULL DEFAULT 'string',
 UNIQUE INDEX `group_key` (`
  group`, `key`),
 INDEX `
  group` (`
  group`),
 INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM;

План запросов (Explain)

EXPLAIN недоступен для CREATE TABLE IF NOT EXISTS `ja25_zoo_jbzoo_config` (`group` VARCHAR(150) NULL DEFAULT NULL, `key` VARCHAR(100) NULL DEFAULT NULL, `value` TEXT NULL, `type` VARCHAR(10) NULL DEFAULT 'string', UNIQUE INDEX `group_key` (`group`, `key`), INDEX `group` (`group`), INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM;

Профиль

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.00 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	3.20 ms
waiting for handler commit	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
waiting for handler commit	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:66
16	DatabaseHelper->query()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:405
15	JBTablesHelper->createTable()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:184
14	JBTablesHelper->checkConfig()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:56
13	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:43
12	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:54
11	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:42
10	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:96
9	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:170
8	plgSystemJBZoo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.58 ms После последнего запроса: 0.20 ms Память запроса: 0.027 MB. Память перед запросом: 5.095 MB Возвращено строк: 49

SELECT CONCAT_WS(".", `
  group`, `key`) as group_key, 
	`value`, 
	`type`

  FROM ja25_zoo_jbzoo_config

  LIMIT 1000

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_zoo_jbzoo_config	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	49	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:156
16	JBModel->_query()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:108
15	JBModel->fetchAll()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:235
14	JBModelConfig->_init()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:57
13	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:43
12	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:54
11	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:42
10	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:96
9	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:170
8	plgSystemJBZoo->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.34 ms После последнего запроса: 4.57 ms Память запроса: 0.061 MB. Память перед запросом: 5.333 MB Возвращено строк: 1

SELECT params

  FROM ja25_expautos_config

  WHERE id = 1

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_expautospro/helpers/ExpAutosProConfigs.php:34
12	ExpAutosProConfigs::getExpConfigDb()	JROOT/components/com_expautospro/helpers/ExpAutosProConfigs.php:45
11	ExpAutosProConfigs::getExpConfig()	JROOT/components/com_expautospro/router.php:502
10	ExpautosproParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.46 ms После последнего запроса: 2.75 ms Память запроса: 0.035 MB. Память перед запросом: 5.680 MB Возвращено строк: 1

SELECT custom_data 
  FROM ja25_extensions 
  WHERE element = 'yooessentials' 
  AND folder = 'system' 
  LIMIT 1

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
46	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
45	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/yooessentials/modules/platform-joomla/src/Database.php:52
44	ZOOlanders\YOOessentials\Joomla\Database->fetchAssoc()	JROOT/plugins/system/yooessentials/modules/platform-joomla/src/ConfigRepository.php:51
43	ZOOlanders\YOOessentials\Joomla\ConfigRepository->load()	JROOT/plugins/system/yooessentials/modules/core-config/src/Config.php:20
42	ZOOlanders\YOOessentials\Config\Config->__construct()	Такой же, как вызов в строке ниже
41	ReflectionClass->newInstanceArgs()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:184
40	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:156
39	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/packages/container/src/Container.php:343
38	YOOtheme\Container->resolveService()	JROOT/templates/yootheme/packages/application/src/Application.php:146
37	YOOtheme\Application->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124
36	YOOtheme\HookCollection->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30
35	YOOtheme\HookCollection->call()	JROOT/templates/yootheme/packages/utils/src/Hook.php:17
34	YOOtheme\Hook::call()	JROOT/templates/yootheme/packages/application/src/Application.php:146
33	YOOtheme\Application->resolveService()	JROOT/templates/yootheme/packages/container/src/Container.php:315
32	YOOtheme\Container->resolve()	JROOT/templates/yootheme/packages/container/src/Container.php:91
31	YOOtheme\Container->get()	JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:84
30	YOOtheme\Container\ParameterResolver->resolveDependencies()	JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:33
29	YOOtheme\Container\ParameterResolver->resolve()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:182
28	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:156
27	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/packages/container/src/Container.php:343
26	YOOtheme\Container->resolveService()	JROOT/templates/yootheme/packages/application/src/Application.php:146
25	YOOtheme\Application->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124
24	YOOtheme\HookCollection->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30
23	YOOtheme\HookCollection->call()	JROOT/templates/yootheme/packages/utils/src/Hook.php:17
22	YOOtheme\Hook::call()	JROOT/templates/yootheme/packages/application/src/Application.php:146
21	YOOtheme\Application->resolveService()	JROOT/templates/yootheme/packages/container/src/Container.php:315
20	YOOtheme\Container->resolve()	JROOT/templates/yootheme/packages/container/src/Container.php:91
19	YOOtheme\Container->get()	JROOT/templates/yootheme/packages/container/src/Container.php:230
18	YOOtheme\Container->callback()	JROOT/templates/yootheme/packages/container/src/Container.php:252
17	YOOtheme\Container->call()	JROOT/templates/yootheme/packages/application/src/Application/EventLoader.php:59
16	YOOtheme\Application\EventLoader->YOOtheme\Application\{closure}()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:115
15	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:45
14	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/packages/utils/src/Event.php:47
13	YOOtheme\Event::emit()	JROOT/templates/yootheme/packages/theme-joomla/src/ThemeLoader.php:38
12	YOOtheme\Theme\Joomla\ThemeLoader::initTheme()	JROOT/templates/yootheme/packages/container/src/Container.php:262
11	YOOtheme\Container->call()	JROOT/templates/yootheme/packages/application/src/Application/EventLoader.php:59
10	YOOtheme\Application\EventLoader->YOOtheme\Application\{closure}()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:115
9	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:45
8	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/packages/platform-joomla/src/Dispatcher.php:66
7	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.58 ms После последнего запроса: 19.48 ms Память запроса: 0.022 MB. Память перед запросом: 7.155 MB Возвращено строк: 2

SELECT id

  FROM ja25_expautos_expuser

  WHERE userid = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_expuser	NULL	ref	idexpus_userid	idexpus_userid	4	const	2	100.00	Using index

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_expautospro/helpers/ExpAutosProUsers.php:42
10	ExpAutosProUsers::getExpDbUserId()	JROOT/components/com_expautospro/helpers/ExpAutosProUsers.php:25
9	ExpAutosProUsers::getExpDbo()	JROOT/components/com_expautospro/controller.php:45
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 5.02 ms После последнего запроса: 14.17 ms Память запроса: 0.024 MB. Память перед запросом: 7.617 MB Возвращено строк: 0

Повторяющиеся запросы: #12 #14 #15 #19 #20

SELECT a.userid

  FROM `ja25_expautos_expuser` AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state > 0 
  AND a.company_id = 53652 
  AND a.company_enable = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	5.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_expautospro/helpers/ExpAutosProUsers.php:286
16	ExpAutosProUsers::getUseridByCompany()	JROOT/components/com_expautospro/models/explist.php:726
15	ExpautosproModelExplist->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_expautospro/models/explist.php:1055
12	ExpautosproModelExplist->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:43
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 4.24 ms После последнего запроса: 0.11 ms Память запроса: 0.024 MB. Память перед запросом: 7.626 MB Возвращено строк: 0

Повторяющиеся запросы: #11 #14 #15 #19 #20

SELECT a.userid

  FROM `ja25_expautos_expuser` AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state > 0 
  AND a.company_id = 53652 
  AND a.company_enable = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	5.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/components/com_expautospro/models/explist.php:866
15	ExpautosproModelExplist->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_expautospro/models/explist.php:1055
12	ExpautosproModelExplist->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:43
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 1.78 ms После последнего запроса: 0.17 ms Память запроса: 0.073 MB. Память перед запросом: 7.547 MB Возвращено строк: 0

SELECT a.*, IF( a.bprice != "",a.bprice,a.price ) price ,a.price AS aprice, a.bprice AS bprice, a.imgmain AS img_name ,c.title AS category_name, c.id AS categid, c.itemtype AS catitemtype,mk.id AS mkid,mk.name AS make_name,md.id AS mdid,md.name AS model_name,bt.id AS btid,bt.name AS bodytype_name,dr.id AS drid,dr.name AS drive_name,ecl.id AS eclid,ecl.name AS extcolor_name, ecl.image AS extcolor_image, ecl.csscode AS csscode_color,tr.id AS trid,tr.name AS trans_name, tr.code AS trans_code,fl.id AS flid,fl.name AS fuel_name, fl.code AS fuel_code,user.id AS userwid,user.name AS user_name, user.username AS user_username, user.email AS user_email,expusercountry.id AS expusercountrywid,expuserstate.id AS expuserstatewid,expusercity.id AS expusercitywid,expuser.id AS expuser_id,expuser.lastname AS expuser_lastname, expuser.companyname AS expuser_companyname,expuser.street AS expuser_street,expuser.phone AS expuser_phone,expuser.web AS expuser_web, expuser.logo AS expuser_logo,expuser.headerimg AS expuser_headerimg, expuser.customimg AS expuser_customimg,expuser.zipcode AS expuser_zipcode, expuser.fax AS expuser_fax,expuser.mobphone AS expuser_mobphone, expuser.userinfo AS expuser_userinfo,expuser.utop AS expuser_utop, expuser.ucommercial AS expuser_ucommercial,expuser.uspecial AS expuser_uspecial,expusercountry.name AS expuser_country, expusercity.city_name AS expuser_city,expuserstate.name AS expuser_state,expuser.latitude AS expuser_latitude,expuser.longitude AS expuser_longitude,cnt.id AS cntid,cnt.name AS cnt_name,st.id AS stid,st.name AS st_name,ct.id AS ctid,ct.city_name AS ct_name,ag.title AS access_level

  FROM ja25_expautos_admanager as a

  LEFT JOIN ja25_expautos_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ja25_expautos_make AS mk 
  ON mk.id = a.make

  LEFT JOIN ja25_expautos_model AS md 
  ON md.id = a.model

  LEFT JOIN ja25_expautos_bodytype AS bt 
  ON bt.id = a.bodytype

  LEFT JOIN ja25_expautos_drive AS dr 
  ON dr.id = a.drive

  LEFT JOIN ja25_expautos_color AS ecl 
  ON ecl.id = a.extcolor

  LEFT JOIN ja25_expautos_trans AS tr 
  ON tr.id = a.trans

  LEFT JOIN ja25_expautos_fuel AS fl 
  ON fl.id = a.fuel

  LEFT JOIN ja25_users AS user 
  ON user.id = a.user

  LEFT JOIN ja25_expautos_expuser AS expuser 
  ON expuser.userid = a.user

  LEFT JOIN ja25_expautos_country AS expusercountry 
  ON expusercountry.id = expuser.country

  LEFT JOIN ja25_expautos_state AS expuserstate 
  ON expuserstate.id = expuser.expstate

  LEFT JOIN ja25_expautos_cities AS expusercity 
  ON expusercity.id = expuser.city

  LEFT JOIN ja25_expautos_country AS cnt 
  ON cnt.id = a.country

  LEFT JOIN ja25_expautos_state AS st 
  ON st.id = a.expstate

  LEFT JOIN ja25_expautos_cities AS ct 
  ON ct.id = a.city

  LEFT JOIN ja25_viewlevels AS ag 
  ON ag.id = a.access 
  AND ag.id = c.access

  WHERE a.user != "" 
  AND a.user > 0 
  AND c.published = 1 
  AND c.access IN (1,1,10) 
  AND a.state=1 
  AND a.solid != 1 
  AND a.user = 53652

  ORDER BY a.ftop DESC, a.id desc 
  LIMIT 20

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idexpam_state,idexpam_catid,idexpam_solid,idexpam_user	idexpam_user	4	const	1	95.32	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.catid	1	33.33	Using where
1	SIMPLE	mk	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.make	1	100.00	NULL
1	SIMPLE	md	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.model	1	100.00	NULL
1	SIMPLE	bt	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.bodytype	1	100.00	NULL
1	SIMPLE	dr	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.drive	1	100.00	NULL
1	SIMPLE	ecl	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.extcolor	1	100.00	NULL
1	SIMPLE	tr	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.trans	1	100.00	NULL
1	SIMPLE	fl	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.fuel	1	100.00	NULL
1	SIMPLE	user	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	expuser	NULL	ref	idexpus_userid	idexpus_userid	4	const	1	100.00	NULL
1	SIMPLE	expusercountry	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.country	1	100.00	NULL
1	SIMPLE	expuserstate	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.expstate	1	100.00	NULL
1	SIMPLE	expusercity	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.city	1	100.00	Using index condition
1	SIMPLE	cnt	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.country	1	100.00	NULL
1	SIMPLE	st	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.expstate	1	100.00	NULL
1	SIMPLE	ct	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.city	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.access	1	100.00	Using index condition

Профиль

Status	Duration
starting	0.29 ms
Executing hook on transaction	0.01 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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.62 ms
init	0.01 ms
System lock	0.04 ms
optimizing	0.05 ms
statistics	0.17 ms
preparing	0.08 ms
executing	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_expautospro/models/explist.php:1055
12	ExpautosproModelExplist->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:43
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 5.00 ms После последнего запроса: 0.83 ms Память запроса: 0.024 MB. Память перед запросом: 7.572 MB Возвращено строк: 0

Повторяющиеся запросы: #11 #12 #15 #19 #20

SELECT a.userid

  FROM `ja25_expautos_expuser` AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state > 0 
  AND a.company_id = 53652 
  AND a.company_enable = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	5.00	Using where

Профиль

Status	Duration
starting	0.07 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.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	4.51 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_expautospro/helpers/ExpAutosProUsers.php:286
15	ExpAutosProUsers::getUseridByCompany()	JROOT/components/com_expautospro/models/explist.php:726
14	ExpautosproModelExplist->getListQuery()	JROOT/components/com_expautospro/models/explist.php:909
13	ExpautosproModelExplist->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:45
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 4.53 ms После последнего запроса: 0.14 ms Память запроса: 0.023 MB. Память перед запросом: 7.580 MB Возвращено строк: 0

Повторяющиеся запросы: #11 #12 #14 #19 #20

SELECT a.userid

  FROM `ja25_expautos_expuser` AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state > 0 
  AND a.company_id = 53652 
  AND a.company_enable = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	5.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/components/com_expautospro/models/explist.php:866
14	ExpautosproModelExplist->getListQuery()	JROOT/components/com_expautospro/models/explist.php:909
13	ExpautosproModelExplist->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:45
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.90 ms После последнего запроса: 0.26 ms Память запроса: 0.023 MB. Память перед запросом: 7.507 MB Возвращено строк: 1

Повторяющиеся запросы: #21

SELECT COUNT(*)

  FROM ja25_expautos_admanager as a

  LEFT JOIN ja25_expautos_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ja25_expautos_make AS mk 
  ON mk.id = a.make

  LEFT JOIN ja25_expautos_model AS md 
  ON md.id = a.model

  LEFT JOIN ja25_expautos_bodytype AS bt 
  ON bt.id = a.bodytype

  LEFT JOIN ja25_expautos_drive AS dr 
  ON dr.id = a.drive

  LEFT JOIN ja25_expautos_color AS ecl 
  ON ecl.id = a.extcolor

  LEFT JOIN ja25_expautos_trans AS tr 
  ON tr.id = a.trans

  LEFT JOIN ja25_expautos_fuel AS fl 
  ON fl.id = a.fuel

  LEFT JOIN ja25_users AS user 
  ON user.id = a.user

  LEFT JOIN ja25_expautos_expuser AS expuser 
  ON expuser.userid = a.user

  LEFT JOIN ja25_expautos_country AS expusercountry 
  ON expusercountry.id = expuser.country

  LEFT JOIN ja25_expautos_state AS expuserstate 
  ON expuserstate.id = expuser.expstate

  LEFT JOIN ja25_expautos_cities AS expusercity 
  ON expusercity.id = expuser.city

  LEFT JOIN ja25_expautos_country AS cnt 
  ON cnt.id = a.country

  LEFT JOIN ja25_expautos_state AS st 
  ON st.id = a.expstate

  LEFT JOIN ja25_expautos_cities AS ct 
  ON ct.id = a.city

  LEFT JOIN ja25_viewlevels AS ag 
  ON ag.id = a.access 
  AND ag.id = c.access

  WHERE a.user != "" 
  AND a.user > 0 
  AND c.published = 1 
  AND c.access IN (1,1,10) 
  AND a.state=1 
  AND a.solid != 1 
  AND a.user = 53652

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idexpam_state,idexpam_catid,idexpam_solid,idexpam_user	idexpam_user	4	const	1	95.32	Using index condition; Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.catid	1	33.33	Using where
1	SIMPLE	mk	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.make	1	100.00	Using index
1	SIMPLE	md	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.model	1	100.00	Using index
1	SIMPLE	bt	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.bodytype	1	100.00	Using index
1	SIMPLE	dr	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.drive	1	100.00	Using index
1	SIMPLE	ecl	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.extcolor	1	100.00	Using index
1	SIMPLE	tr	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.trans	1	100.00	Using index
1	SIMPLE	fl	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.fuel	1	100.00	Using index
1	SIMPLE	user	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	expuser	NULL	ref	idexpus_userid	idexpus_userid	4	const	1	100.00	NULL
1	SIMPLE	expusercountry	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.country	1	100.00	Using index
1	SIMPLE	expuserstate	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.expstate	1	100.00	Using index
1	SIMPLE	expusercity	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.city	1	100.00	Using where; Using index
1	SIMPLE	cnt	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.country	1	100.00	Using index
1	SIMPLE	st	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.expstate	1	100.00	Using index
1	SIMPLE	ct	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.city	1	100.00	Using index
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.access	1	100.00	Using where; Using index

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_expautospro/models/explist.php:909
13	ExpautosproModelExplist->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:45
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.43 ms После последнего запроса: 0.13 ms Память запроса: 0.024 MB. Память перед запросом: 7.498 MB Возвращено строк: 6

SELECT explevel.id,explevel.userlevel,explevel.params,ugroup.title

  FROM ja25_expautos_userlevel AS explevel

  LEFT JOIN `ja25_usergroups` AS ugroup 
  ON ugroup.id = explevel.userlevel

  ORDER BY explevel.ordering ASC

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	explevel	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	6	100.00	Используется сортировка файлов
1	SIMPLE	ugroup	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.explevel.userlevel	1	100.00	Using index condition

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/components/com_expautospro/helpers/ExpAutosProDealersParams.php:47
14	ExpAutosProDealersParams::getExpDealersParamsDb()	JROOT/components/com_expautospro/helpers/ExpAutosProDealersParams.php:63
13	ExpAutosProDealersParams::getExpDealersConfig()	JROOT/components/com_expautospro/models/explist.php:247
12	ExpautosproModelExplist->getExpgroupfields()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:46
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.26 ms После последнего запроса: 0.16 ms Память запроса: 0.023 MB. Память перед запросом: 7.515 MB Возвращено строк: 1

SELECT a.id

  FROM ja25_user_usergroup_map AS map

  LEFT JOIN ja25_usergroups AS a 
  ON a.id = map.group_id

  WHERE map.user_id = 53652

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	map	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.map.group_id	1	100.00	Using index

Профиль

Status	Duration
starting	0.04 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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
14	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/components/com_expautospro/helpers/ExpAutosProDealersParams.php:64
13	ExpAutosProDealersParams::getExpDealersConfig()	JROOT/components/com_expautospro/models/explist.php:247
12	ExpautosproModelExplist->getExpgroupfields()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:46
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 3.97 ms После последнего запроса: 0.99 ms Память запроса: 0.024 MB. Память перед запросом: 7.715 MB Возвращено строк: 0

Повторяющиеся запросы: #11 #12 #14 #15 #20

SELECT a.userid

  FROM `ja25_expautos_expuser` AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state > 0 
  AND a.company_id = 53652 
  AND a.company_enable = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	5.00	Using where

Профиль

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
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	3.61 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_expautospro/helpers/ExpAutosProUsers.php:286
15	ExpAutosProUsers::getUseridByCompany()	JROOT/components/com_expautospro/models/explist.php:726
14	ExpautosproModelExplist->getListQuery()	JROOT/components/com_expautospro/models/explist.php:909
13	ExpautosproModelExplist->getTotal()	JROOT/components/com_expautospro/models/explist.php:916
12	ExpautosproModelExplist->getExpPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:49
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 3.95 ms После последнего запроса: 0.08 ms Память запроса: 0.023 MB. Память перед запросом: 7.723 MB Возвращено строк: 0

Повторяющиеся запросы: #11 #12 #14 #15 #19

SELECT a.userid

  FROM `ja25_expautos_expuser` AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state > 0 
  AND a.company_id = 53652 
  AND a.company_enable = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	5.00	Using where

Профиль

Status	Duration
starting	0.05 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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	3.62 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/components/com_expautospro/models/explist.php:866
14	ExpautosproModelExplist->getListQuery()	JROOT/components/com_expautospro/models/explist.php:909
13	ExpautosproModelExplist->getTotal()	JROOT/components/com_expautospro/models/explist.php:916
12	ExpautosproModelExplist->getExpPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:49
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.83 ms После последнего запроса: 0.21 ms Память запроса: 0.023 MB. Память перед запросом: 7.651 MB Возвращено строк: 1

Повторяющиеся запросы: #16

SELECT COUNT(*)

  FROM ja25_expautos_admanager as a

  LEFT JOIN ja25_expautos_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ja25_expautos_make AS mk 
  ON mk.id = a.make

  LEFT JOIN ja25_expautos_model AS md 
  ON md.id = a.model

  LEFT JOIN ja25_expautos_bodytype AS bt 
  ON bt.id = a.bodytype

  LEFT JOIN ja25_expautos_drive AS dr 
  ON dr.id = a.drive

  LEFT JOIN ja25_expautos_color AS ecl 
  ON ecl.id = a.extcolor

  LEFT JOIN ja25_expautos_trans AS tr 
  ON tr.id = a.trans

  LEFT JOIN ja25_expautos_fuel AS fl 
  ON fl.id = a.fuel

  LEFT JOIN ja25_users AS user 
  ON user.id = a.user

  LEFT JOIN ja25_expautos_expuser AS expuser 
  ON expuser.userid = a.user

  LEFT JOIN ja25_expautos_country AS expusercountry 
  ON expusercountry.id = expuser.country

  LEFT JOIN ja25_expautos_state AS expuserstate 
  ON expuserstate.id = expuser.expstate

  LEFT JOIN ja25_expautos_cities AS expusercity 
  ON expusercity.id = expuser.city

  LEFT JOIN ja25_expautos_country AS cnt 
  ON cnt.id = a.country

  LEFT JOIN ja25_expautos_state AS st 
  ON st.id = a.expstate

  LEFT JOIN ja25_expautos_cities AS ct 
  ON ct.id = a.city

  LEFT JOIN ja25_viewlevels AS ag 
  ON ag.id = a.access 
  AND ag.id = c.access

  WHERE a.user != "" 
  AND a.user > 0 
  AND c.published = 1 
  AND c.access IN (1,1,10) 
  AND a.state=1 
  AND a.solid != 1 
  AND a.user = 53652

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idexpam_state,idexpam_catid,idexpam_solid,idexpam_user	idexpam_user	4	const	1	95.32	Using index condition; Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.catid	1	33.33	Using where
1	SIMPLE	mk	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.make	1	100.00	Using index
1	SIMPLE	md	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.model	1	100.00	Using index
1	SIMPLE	bt	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.bodytype	1	100.00	Using index
1	SIMPLE	dr	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.drive	1	100.00	Using index
1	SIMPLE	ecl	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.extcolor	1	100.00	Using index
1	SIMPLE	tr	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.trans	1	100.00	Using index
1	SIMPLE	fl	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.fuel	1	100.00	Using index
1	SIMPLE	user	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	expuser	NULL	ref	idexpus_userid	idexpus_userid	4	const	1	100.00	NULL
1	SIMPLE	expusercountry	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.country	1	100.00	Using index
1	SIMPLE	expuserstate	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.expstate	1	100.00	Using index
1	SIMPLE	expusercity	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.expuser.city	1	100.00	Using where; Using index
1	SIMPLE	cnt	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.country	1	100.00	Using index
1	SIMPLE	st	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.expstate	1	100.00	Using index
1	SIMPLE	ct	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.city	1	100.00	Using index
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.access	1	100.00	Using where; Using index

Профиль

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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.13 ms
preparing	0.07 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_expautospro/models/explist.php:909
13	ExpautosproModelExplist->getTotal()	JROOT/components/com_expautospro/models/explist.php:916
12	ExpautosproModelExplist->getExpPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_expautospro/views/explist/view.html.php:49
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 6.05 ms После последнего запроса: 74.24 ms Память запроса: 5.561 MB. Память перед запросом: 9.270 MB Возвращено строк: 1

SELECT custom_data 
  FROM ja25_extensions 
  WHERE element = 'yootheme' 
  AND folder = 'system' 
  LIMIT 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_extensions	NULL	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
51	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
50	JDatabaseDriver->loadResult()	JROOT/templates/yootheme/packages/platform-joomla/src/Storage.php:30
49	YOOtheme\Joomla\Storage->__construct()	Такой же, как вызов в строке ниже
48	ReflectionClass->newInstanceArgs()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:184
47	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:156
46	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/packages/container/src/Container.php:343
45	YOOtheme\Container->resolveService()	JROOT/templates/yootheme/packages/application/src/Application.php:146
44	YOOtheme\Application->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124
43	YOOtheme\HookCollection->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30
42	YOOtheme\HookCollection->call()	JROOT/templates/yootheme/packages/utils/src/Hook.php:17
41	YOOtheme\Hook::call()	JROOT/templates/yootheme/packages/application/src/Application.php:146
40	YOOtheme\Application->resolveService()	JROOT/templates/yootheme/packages/container/src/Container.php:315
39	YOOtheme\Container->resolve()	JROOT/templates/yootheme/packages/container/src/Container.php:91
38	YOOtheme\Container->get()	JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:84
37	YOOtheme\Container\ParameterResolver->resolveDependencies()	JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:33
36	YOOtheme\Container\ParameterResolver->resolve()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:182
35	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/packages/container/src/Container/Service.php:156
34	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/packages/container/src/Container.php:343
33	YOOtheme\Container->resolveService()	JROOT/templates/yootheme/packages/application/src/Application.php:146
32	YOOtheme\Application->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:124
31	YOOtheme\HookCollection->YOOtheme\{closure}()	JROOT/templates/yootheme/packages/utils/src/HookCollection.php:30
30	YOOtheme\HookCollection->call()	JROOT/templates/yootheme/packages/utils/src/Hook.php:17
29	YOOtheme\Hook::call()	JROOT/templates/yootheme/packages/application/src/Application.php:146
28	YOOtheme\Application->resolveService()	JROOT/templates/yootheme/packages/container/src/Container.php:315
27	YOOtheme\Container->resolve()	JROOT/templates/yootheme/packages/container/src/Container.php:91
26	YOOtheme\Container->get()	JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:84
25	YOOtheme\Container\ParameterResolver->resolveDependencies()	JROOT/templates/yootheme/packages/container/src/Container/ParameterResolver.php:33
24	YOOtheme\Container\ParameterResolver->resolve()	JROOT/templates/yootheme/packages/container/src/Container.php:259
23	YOOtheme\Container->call()	JROOT/templates/yootheme/packages/application/src/Application/EventLoader.php:59
22	YOOtheme\Application\EventLoader->YOOtheme\Application\{closure}()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:115
21	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:45
20	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/packages/platform-joomla/src/Dispatcher.php:66
19	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/yootheme/packages/theme-joomla/src/Listener/LoadTemplate.php:34
16	YOOtheme\Theme\Joomla\Listener\LoadTemplate->YOOtheme\Theme\Joomla\Listener\{closure}()	JROOT/templates/yootheme/packages/theme-joomla/src/StreamWrapper.php:49
15	YOOtheme\Theme\Joomla\StreamWrapper->url_stat()	Такой же, как вызов в строке ниже
14	file_exists()	JROOT/libraries/src/Filesystem/Path.php:335
13	Joomla\CMS\Filesystem\Path::find()	JROOT/libraries/src/MVC/View/HtmlView.php:676
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 4.24 ms После последнего запроса: 44.64 ms Память запроса: 0.199 MB. Память перед запросом: 27.985 MB Возвращено строк: 43

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

  FROM ja25_modules AS m

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

  LEFT JOIN ja25_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 <= '2025-12-26 00:14:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-26 00:14:13') 
  AND m.access IN (1,1,10) 
  AND m.client_id = 0 
  AND (mm.menuid = 300172 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	131	1.60	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	ntestos.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	ntestos.m.id	10	40.00	Using where; Using index

Профиль

Status	Duration
starting	0.17 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.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.12 ms
preparing	0.07 ms
executing	3.47 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
16	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_expautospro/helpers/helper.php:44
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.87 ms После последнего запроса: 23.43 ms Память запроса: 0.028 MB. Память перед запросом: 28.439 MB Возвращено строк: 1

SELECT a.*, a.id AS value, a.title AS text, a.parent_id AS parent_id, a.ecount AS catecount, a.description AS description, a.itemtype AS catitemtype

  FROM ja25_expautos_categories AS a

  LEFT JOIN `ja25_expautos_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE a.level > 0 
  AND a.access IN (1,1,10) 
  AND a.published = 1

  GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.parent_id, a.published

  ORDER BY a.lft ASC

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	3	33.33	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	b	NULL	ALL	idx_left_right	INDEX KEY не используется	NULL	NULL	3	100.00	Range checked for each record (index map: 0x2)

Профиль

Status	Duration
starting	0.09 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.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Creating tmp table	0.09 ms
executing	0.26 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:66
22	ExpAutosProCategories::getCategories()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:37
21	ExpAutosProCategories::initialize()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:187
20	ExpAutosProCategories::getCategoriesOptions()	JROOT/modules/mod_expautospro_search_ajax/helper.php:109
19	ModExpautosSearchAjax::getList()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:19
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 2.10 ms После последнего запроса: 6.41 ms Память запроса: 0.034 MB. Память перед запросом: 28.621 MB Возвращено строк: 28

SHOW FULL COLUMNS 
  FROM `ja25_expautos_categories`

План запросов (Explain)

EXPLAIN недоступен для SHOW FULL COLUMNS FROM `ja25_expautos_categories`

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
25	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_expautospro/tables/expcategory.php:27
24	ExpAutosProTableExpcategory->__construct()	JROOT/libraries/src/Table/Table.php:328
23	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:180
22	ExpAutosProCategories::getCategoriesisLeaf()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:168
21	ExpAutosProCategories::getCategoriesCountsNum()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:194
20	ExpAutosProCategories::getCategoriesOptions()	JROOT/modules/mod_expautospro_search_ajax/helper.php:109
19	ModExpautosSearchAjax::getList()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:19
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.27 ms После последнего запроса: 0.33 ms Память запроса: 0.028 MB. Память перед запросом: 28.666 MB Возвращено строк: 1

SELECT id, parent_id, level, lft, rgt

  FROM ja25_expautos_categories

  WHERE id = 90 
  LIMIT 1

План запросов (Explain)

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

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 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
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/libraries/src/Table/Nested.php:1612
24	Joomla\CMS\Table\Nested->_getNode()	JROOT/libraries/src/Table/Nested.php:200
23	Joomla\CMS\Table\Nested->isLeaf()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:181
22	ExpAutosProCategories::getCategoriesisLeaf()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:168
21	ExpAutosProCategories::getCategoriesCountsNum()	JROOT/components/com_expautospro/helpers/ExpAutosProCategories.php:194
20	ExpAutosProCategories::getCategoriesOptions()	JROOT/modules/mod_expautospro_search_ajax/helper.php:109
19	ModExpautosSearchAjax::getList()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:19
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 2.30 ms После последнего запроса: 1.08 ms Память запроса: 0.093 MB. Память перед запросом: 28.780 MB Возвращено строк: 181

SELECT a.*, a.id AS value, a.name AS text,c.title AS category_name

  FROM ja25_expautos_make AS a

  LEFT JOIN ja25_expautos_categories AS c 
  ON c.id = a.catid

  WHERE a.state >= 0

  ORDER BY a.name asc

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idexpmk_state	INDEX KEY не используется	NULL	NULL	182	100.00	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	c	NULL	ALL	PRIMARY	INDEX KEY не используется	NULL	NULL	3	100.00	Using where; Using join buffer (hash join)

Профиль

Status	Duration
starting	0.06 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.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Creating tmp table	0.12 ms
executing	1.80 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
23	JDatabaseDriver->loadAssocList()	JROOT/components/com_expautospro/helpers/ExpAutosProMakes.php:56
22	ExpAutosProMakes::getExpMakesData()	JROOT/components/com_expautospro/helpers/ExpAutosProMakes.php:32
21	ExpAutosProMakes::initialize()	JROOT/components/com_expautospro/helpers/ExpAutosProMakes.php:147
20	ExpAutosProMakes::getMakesOptions()	JROOT/modules/mod_expautospro_search_ajax/helper.php:163
19	ModExpautosSearchAjax::getMake()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:26
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.39 ms После последнего запроса: 15.23 ms Память запроса: 0.027 MB. Память перед запросом: 28.798 MB Возвращено строк: 4

Повторяющиеся запросы: #41

SELECT id As value, name As text

  FROM `ja25_expautos_condition`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_condition	NULL	ref	idexpcn_state	idexpcn_state	1	const	3	100.00	Используется сортировка файлов

Профиль

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.05 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
20	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:328
19	ModExpautosSearchAjax::getCondition()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:29
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.39 ms После последнего запроса: 1.01 ms Память запроса: 0.028 MB. Память перед запросом: 28.810 MB Возвращено строк: 15

Повторяющиеся запросы: #42

SELECT id As value, `name` As text, a.ecount As count

  FROM `ja25_expautos_bodytype` AS a

  WHERE `a`.`catid` = '90' 
  AND a.state > 0

  ORDER BY `a`.`ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idexpbt_state	INDEX KEY не используется	NULL	NULL	21	10.00	Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:134
20	ExpAutosProFields::getExpSelect()	JROOT/modules/mod_expautospro_search_ajax/helper.php:358
19	ModExpautosSearchAjax::getBodytype()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:30
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.38 ms После последнего запроса: 3.33 ms Память запроса: 0.027 MB. Память перед запросом: 28.822 MB Возвращено строк: 0

Повторяющиеся запросы: #43

SELECT id As value, `name` As text

  FROM `ja25_expautos_extrafield1` AS a

  WHERE `a`.`catid` = '90' 
  AND a.state > 0

  ORDER BY `a`.`ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	19	5.26	Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:134
20	ExpAutosProFields::getExpSelect()	JROOT/modules/mod_expautospro_search_ajax/helper.php:403
19	ModExpautosSearchAjax::getExtrafield1()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:31
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.28 ms После последнего запроса: 0.45 ms Память запроса: 0.027 MB. Память перед запросом: 28.833 MB Возвращено строк: 2

Повторяющиеся запросы: #44

SELECT id As value, name As text

  FROM `ja25_expautos_extrafield2`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_extrafield2	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	50.00	Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
20	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:437
19	ModExpautosSearchAjax::getExtrafield2()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:32
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.29 ms После последнего запроса: 0.53 ms Память запроса: 0.027 MB. Память перед запросом: 28.845 MB Возвращено строк: 0

Повторяющиеся запросы: #45

SELECT id As value, name As text

  FROM `ja25_expautos_extrafield3`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_extrafield3	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	Using where; Используется сортировка файлов

Профиль

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.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
20	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:457
19	ModExpautosSearchAjax::getExtrafield3()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:33
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.27 ms После последнего запроса: 1.50 ms Память запроса: 0.028 MB. Память перед запросом: 28.868 MB Возвращено строк: 7

Повторяющиеся запросы: #46

SELECT id As value, name As text

  FROM `ja25_expautos_fuel`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_fuel	NULL	ref	idexpfl_state	idexpfl_state	1	const	6	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
20	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:908
19	ModExpautosSearchAjax::getFuel()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:39
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.27 ms После последнего запроса: 1.30 ms Память запроса: 0.027 MB. Память перед запросом: 28.881 MB Возвращено строк: 3

Повторяющиеся запросы: #47

SELECT id As value, name As text

  FROM `ja25_expautos_drive`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_drive	NULL	ref	idexpdr_state	idexpdr_state	1	const	2	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
20	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:928
19	ModExpautosSearchAjax::getDrive()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:40
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.23 ms После последнего запроса: 0.60 ms Память запроса: 0.027 MB. Память перед запросом: 28.892 MB Возвращено строк: 2

Повторяющиеся запросы: #48

SELECT id As value, name As text

  FROM `ja25_expautos_trans`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_trans	NULL	ref	idexptr_state	idexptr_state	1	const	1	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
20	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:948
19	ModExpautosSearchAjax::getTrans()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:41
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.28 ms После последнего запроса: 0.64 ms Память запроса: 0.027 MB. Память перед запросом: 28.904 MB Возвращено строк: 1

Повторяющиеся запросы: #49

SELECT id AS value, name AS text

  FROM `ja25_expautos_country`

  WHERE state > 0

  ORDER BY name

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_country	NULL	range	idexpct_state	idexpct_state	1	NULL	1	100.00	Using index condition; Используется сортировка файлов

Профиль

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.02 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/ExpAutosProLocation.php:52
20	ExpAutosProLocation::getCountry()	JROOT/modules/mod_expautospro_search_ajax/helper.php:980
19	ModExpautosSearchAjax::getCountry()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:42
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 3.96 ms После последнего запроса: 0.41 ms Память запроса: 0.032 MB. Память перед запросом: 28.917 MB Возвращено строк: 128

Повторяющиеся запросы: #50

SELECT a.userid As value, us.username As text

  FROM ja25_expautos_expuser AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	100.00	Using where

Профиль

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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	3.60 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_expautospro_search_ajax/helper.php:1077
19	ModExpautosSearchAjax::getDealer()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:45
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.37 ms После последнего запроса: 1.18 ms Память запроса: 0.028 MB. Память перед запросом: 28.936 MB Возвращено строк: 17

Повторяющиеся запросы: #51

SELECT id As value, name As text

  FROM `ja25_expautos_color`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_color	NULL	ref	idexpcl_state	idexpcl_state	1	const	16	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
20	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:1251
19	ModExpautosSearchAjax::getColor()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:54
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.38 ms После последнего запроса: 3.80 ms Память запроса: 0.027 MB. Память перед запросом: 29.035 MB Возвращено строк: 2

SELECT id, cname, exchange, cvariable, expicon, priceformat, moneyformat

  FROM ja25_expautos_currency

  WHERE state = 1

  ORDER BY ordering ASC

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_currency	NULL	ref	idexpcr_state	idexpcr_state	1	const	2	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
22	JDatabaseDriver->loadAssocList()	JROOT/components/com_expautospro/helpers/ExpAutosProPrice.php:161
21	ExpAutosProPrice::getExpPriceDb()	JROOT/components/com_expautospro/helpers/ExpAutosProPrice.php:224
20	ExpAutosProPrice::getExpPriceCharacter()	JROOT/modules/mod_expautospro_search_ajax/helper.php:752
19	ModExpautosSearchAjax::getPriceSlide()	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:59
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.32 ms После последнего запроса: 5.11 ms Память запроса: 0.028 MB. Память перед запросом: 29.064 MB Возвращено строк: 1

SELECT params

  FROM ja25_modules

  WHERE id = 570

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_expautospro/helpers/ExpAutosProGetParams.php:34
21	ExpAutosProGetParams->getExpDbConfig()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:34
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.58 ms После последнего запроса: 17.60 ms Память запроса: 0.028 MB. Память перед запросом: 29.192 MB Возвращено строк: 4

Повторяющиеся запросы: #28

SELECT id As value, name As text

  FROM `ja25_expautos_condition`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_condition	NULL	ref	idexpcn_state	idexpcn_state	1	const	3	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
23	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:328
22	ModExpautosSearchAjax::getCondition()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:97
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.54 ms После последнего запроса: 0.79 ms Память запроса: 0.029 MB. Память перед запросом: 29.205 MB Возвращено строк: 15

Повторяющиеся запросы: #29

SELECT id As value, `name` As text, a.ecount As count

  FROM `ja25_expautos_bodytype` AS a

  WHERE `a`.`catid` = '90' 
  AND a.state > 0

  ORDER BY `a`.`ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idexpbt_state	INDEX KEY не используется	NULL	NULL	21	10.00	Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:134
23	ExpAutosProFields::getExpSelect()	JROOT/modules/mod_expautospro_search_ajax/helper.php:358
22	ModExpautosSearchAjax::getBodytype()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:98
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.42 ms После последнего запроса: 2.77 ms Память запроса: 0.028 MB. Память перед запросом: 29.219 MB Возвращено строк: 0

Повторяющиеся запросы: #30

SELECT id As value, `name` As text

  FROM `ja25_expautos_extrafield1` AS a

  WHERE `a`.`catid` = '90' 
  AND a.state > 0

  ORDER BY `a`.`ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	19	5.26	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 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.02 ms
preparing	0.02 ms
executing	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:134
23	ExpAutosProFields::getExpSelect()	JROOT/modules/mod_expautospro_search_ajax/helper.php:403
22	ModExpautosSearchAjax::getExtrafield1()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:99
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.39 ms После последнего запроса: 0.29 ms Память запроса: 0.028 MB. Память перед запросом: 29.231 MB Возвращено строк: 2

Повторяющиеся запросы: #31

SELECT id As value, name As text

  FROM `ja25_expautos_extrafield2`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_extrafield2	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	50.00	Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
23	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:437
22	ModExpautosSearchAjax::getExtrafield2()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:100
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.34 ms После последнего запроса: 0.41 ms Память запроса: 0.028 MB. Память перед запросом: 29.244 MB Возвращено строк: 0

Повторяющиеся запросы: #32

SELECT id As value, name As text

  FROM `ja25_expautos_extrafield3`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_extrafield3	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
23	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:457
22	ModExpautosSearchAjax::getExtrafield3()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:101
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.45 ms После последнего запроса: 1.49 ms Память запроса: 0.029 MB. Память перед запросом: 29.262 MB Возвращено строк: 7

Повторяющиеся запросы: #33

SELECT id As value, name As text

  FROM `ja25_expautos_fuel`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_fuel	NULL	ref	idexpfl_state	idexpfl_state	1	const	6	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
23	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:908
22	ModExpautosSearchAjax::getFuel()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:107
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.35 ms После последнего запроса: 1.23 ms Память запроса: 0.028 MB. Память перед запросом: 29.275 MB Возвращено строк: 3

Повторяющиеся запросы: #34

SELECT id As value, name As text

  FROM `ja25_expautos_drive`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_drive	NULL	ref	idexpdr_state	idexpdr_state	1	const	2	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
23	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:928
22	ModExpautosSearchAjax::getDrive()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:108
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.35 ms После последнего запроса: 0.56 ms Память запроса: 0.028 MB. Память перед запросом: 29.288 MB Возвращено строк: 2

Повторяющиеся запросы: #35

SELECT id As value, name As text

  FROM `ja25_expautos_trans`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_trans	NULL	ref	idexptr_state	idexptr_state	1	const	1	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
23	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:948
22	ModExpautosSearchAjax::getTrans()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:109
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.47 ms После последнего запроса: 0.46 ms Память запроса: 0.028 MB. Память перед запросом: 29.301 MB Возвращено строк: 1

Повторяющиеся запросы: #36

SELECT id AS value, name AS text

  FROM `ja25_expautos_country`

  WHERE state > 0

  ORDER BY name

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_country	NULL	range	idexpct_state	idexpct_state	1	NULL	1	100.00	Using index condition; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/ExpAutosProLocation.php:52
23	ExpAutosProLocation::getCountry()	JROOT/modules/mod_expautospro_search_ajax/helper.php:980
22	ModExpautosSearchAjax::getCountry()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:110
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 5.05 ms После последнего запроса: 0.38 ms Память запроса: 0.034 MB. Память перед запросом: 29.315 MB Возвращено строк: 128

Повторяющиеся запросы: #37

SELECT a.userid As value, us.username As text

  FROM ja25_expautos_expuser AS a

  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

  WHERE a.state = 1 
  AND us.block = 0

  ORDER BY us.username

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	us	NULL	ref	PRIMARY,idx_block	idx_block	1	const	429	100.00	Using where; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idexpus_userid,idexpus_state	idexpus_userid	4	ntestos.us.id	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_expautospro_search_ajax/helper.php:1077
22	ModExpautosSearchAjax::getDealer()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:113
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.42 ms После последнего запроса: 1.14 ms Память запроса: 0.029 MB. Память перед запросом: 29.336 MB Возвращено строк: 17

Повторяющиеся запросы: #38

SELECT id As value, name As text

  FROM `ja25_expautos_color`

  WHERE state = '1'

  ORDER BY `ordering`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_expautos_color	NULL	ref	idexpcl_state	idexpcl_state	1	const	16	100.00	Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_expautospro/helpers/expfields.php:89
23	ExpAutosProFields::getExpSelectStd()	JROOT/modules/mod_expautospro_search_ajax/helper.php:1251
22	ModExpautosSearchAjax::getColor()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:122
21	ExpAutosProSearchStyle::getExpHtmlSearch()	JROOT/components/com_expautospro/helpers/ExpAutosProSearch.php:53
20	ExpAutosProSearch::getExpSearchMod()	JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php:120
19	require JROOT/modules/mod_expautospro_search_ajax/tmpl/default-bootstrapeasy-ui-dropdown.php	JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php:69
18	include JROOT/modules/mod_expautospro_search_ajax/mod_expautospro_search_ajax.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/components/com_expautospro/helpers/helper.php:51
15	ExpAutosProHelper::load_module_position()	JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php:232
14	include_once JROOT/components/com_expautospro/skins/explist/default_jam_list/default.php	JROOT/components/com_expautospro/views/explist/tmpl/default.php:27
13	include JROOT/components/com_expautospro/views/explist/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_expautospro/views/explist/view.html.php:66
10	ExpautosproViewExplist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_expautospro/controller.php:59
8	ExpautosproController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_expautospro/expautospro.php:26
6	require_once JROOT/components/com_expautospro/expautospro.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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.38 ms После последнего запроса: 30.48 ms Память запроса: 0.022 MB. Память перед запросом: 29.424 MB Возвращено строк: 0

SELECT *

  FROM ja25_banners

  WHERE '2025-12-26 00:14:13' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Impossible WHERE

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/packages/theme-joomla-modules/src/ModulesRenderer.php:38
7	YOOtheme\Theme\Joomla\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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.85 ms После последнего запроса: 0.27 ms Память запроса: 0.023 MB. Память перед запросом: 29.441 MB Возвращено строк: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM ja25_banners as a

  LEFT JOIN ja25_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-26 00:14:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-26 00:14:13') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
  AND a.cid = 1 
  AND cl.state = 1

  ORDER BY a.sticky DESC, RAND()  
  LIMIT 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cl	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; Используется сортировка файлов
1	SIMPLE	a	NULL	ref	idx_state	idx_state	1	const	31	0.64	Using where

Профиль

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
Opening tables	0.05 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/packages/theme-joomla-modules/src/ModulesRenderer.php:38
7	YOOtheme\Theme\Joomla\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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 3.01 ms После последнего запроса: 0.39 ms Память запроса: 0.006 MB. Память перед запросом: 29.454 MB

UPDATE ja25_banners

  SET impmade = (impmade + 1)

  WHERE id IN (125)

План запросов (Explain)

EXPLAIN недоступен для UPDATE ja25_banners SET impmade = (impmade + 1) WHERE id IN (125)

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:268
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/packages/theme-joomla-modules/src/ModulesRenderer.php:38
7	YOOtheme\Theme\Joomla\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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 3.27 ms После последнего запроса: 0.06 ms Память запроса: 0.006 MB. Память перед запросом: 29.460 MB

UPDATE ja25_banner_tracks

  SET `count` = (`count` + 1)

  WHERE track_type=1 
  AND banner_id=125 
  AND track_date='2025-12-26 00:00:00'

План запросов (Explain)

EXPLAIN недоступен для UPDATE ja25_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=125 AND track_date='2025-12-26 00:00:00'

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.08 ms
updating	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	2.87 ms
closing tables	0.07 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:306
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/packages/theme-joomla-modules/src/ModulesRenderer.php:38
7	YOOtheme\Theme\Joomla\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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 1.01 ms После последнего запроса: 7.96 ms Память запроса: 0.026 MB. Память перед запросом: 29.566 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ja25_fields AS a

  LEFT JOIN `ja25_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ja25_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ja25_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ja25_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ja25_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,10) 
  AND (a.group_id = 0 OR g.access IN (1,1,10)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	7.14	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	ntestos.a.language	1	100.00	Using index condition
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.access	1	100.00	Using index condition
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.created_user_id	1	100.00	Using index condition
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	ntestos.a.group_id	1	100.00	Using where

Профиль

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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.23 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/packages/theme-joomla-modules/src/ModulesRenderer.php:38
7	YOOtheme\Theme\Joomla\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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.50 ms После последнего запроса: 1.34 ms Память запроса: 0.025 MB. Память перед запросом: 29.562 MB Возвращено строк: 1

SELECT *

  FROM `ja25_extensions`

  WHERE `element` = 'com_gsd' 
  AND `type` = 'component'

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:160
17	NRFramework\Extension::get()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:245
16	NRFramework\Extension::isEnabled()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:228
15	NRFramework\Extension::componentIsEnabled()	JROOT/plugins/system/gsd/gsd.php:516
14	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:559
13	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:62
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 1.42 ms После последнего запроса: 0.26 ms Память запроса: 0.026 MB. Память перед запросом: 29.576 MB Возвращено строк: 2

SHOW FULL COLUMNS 
  FROM `ja25_gsd_config`

План запросов (Explain)

EXPLAIN недоступен для SHOW FULL COLUMNS FROM `ja25_gsd_config`

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:27
17	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:434
15	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:528
14	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:559
13	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:62
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.13 ms Память запроса: 0.024 MB. Память перед запросом: 29.591 MB Возвращено строк: 1

SELECT *

  FROM ja25_gsd_config

  WHERE `name` = 'config'

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_gsd_config	NULL	system	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:435
15	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:528
14	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:559
13	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:62
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.35 ms После последнего запроса: 3.74 ms Память запроса: 0.022 MB. Память перед запросом: 29.670 MB Возвращено строк: 0

SELECT *
 
  FROM ja25_jmap_metainfo
 
  WHERE `linkurl` = 'https://autogrodno.by/market-auto/list/userid/53652.html'
 
  AND `published` = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_jmap_metainfo	NULL	ref	published	published	1	const	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:760
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 0.04 ms Память запроса: 0.022 MB. Память перед запросом: 29.676 MB Возвращено строк: 0

SELECT *
 
  FROM ja25_jmap_canonicals
 
  WHERE `linkurl` = 'https://autogrodno.by/market-auto/list/userid/53652.html'

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_jmap_canonicals	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:860
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.25 ms После последнего запроса: 1.83 ms Память запроса: 0.020 MB. Память перед запросом: 29.784 MB Возвращено строк: 0

SELECT *
 
  FROM ja25_jmap_headings
 
  WHERE `linkurl` = 'https://autogrodno.by/market-auto/list/userid/53652.html'

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_jmap_headings	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:1176
7	plgSystemJMap->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.27 ms После последнего запроса: 0.05 ms Память запроса: 0.020 MB. Память перед запросом: 29.788 MB Возвращено строк: 0

SELECT
 `original_text`,
 `target_text`,
 `original_text_regex`,
 `target_text_regex`
 
  FROM
 `ja25_jmap_text_replacements`
 
  WHERE
`published` = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ja25_jmap_text_replacements	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jmap/jmap.php:397
8	plgSystemJMap->patternReplacements()	JROOT/plugins/system/jmap/jmap.php:1257
7	plgSystemJMap->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

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

44 типов запросов зарегистрировано (отсортировано по вхождениям)

Запросы типа SELECT:

6 × SELECT a.userid 
  FROM `ja25_expautos_expuser` AS a 
  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

3 × SELECT custom_data 
  FROM ja25_extensions

2 × SELECT id As value, name As text 
  FROM `ja25_expautos_extrafield2`

2 × SELECT id As value, name As text 
  FROM `ja25_expautos_color`

2 × SELECT id As value, name As text 
  FROM `ja25_expautos_drive`

2 × SELECT id As value, name As text 
  FROM `ja25_expautos_fuel`

2 × SELECT id As value, name As text 
  FROM `ja25_expautos_extrafield3`

2 × SELECT a.userid As value, us.username As text 
  FROM ja25_expautos_expuser AS a 
  LEFT JOIN ja25_users AS us 
  ON us.id = a.userid

2 × SELECT id As value, `name` As text 
  FROM `ja25_expautos_extrafield1` AS a

2 × SELECT id As value, `name` As text, a.ecount As count 
  FROM `ja25_expautos_bodytype` AS a

2 × SELECT id As value, name As text 
  FROM `ja25_expautos_condition`

2 × SELECT id As value, name As text 
  FROM `ja25_expautos_trans`

2 × SELECT id AS value, name AS text 
  FROM `ja25_expautos_country`

2 × SELECT COUNT(*) 
  FROM ja25_expautos_admanager as a 
  LEFT JOIN ja25_expautos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ja25_expautos_make AS mk 
  ON mk.id = a.make 
  LEFT JOIN ja25_expautos_model AS md 
  ON md.id = a.model 
  LEFT JOIN ja25_expautos_bodytype AS bt 
  ON bt.id = a.bodytype 
  LEFT JOIN ja25_expautos_drive AS dr 
  ON dr.id = a.drive 
  LEFT JOIN ja25_expautos_color AS ecl 
  ON ecl.id = a.extcolor 
  LEFT JOIN ja25_expautos_trans AS tr 
  ON tr.id = a.trans 
  LEFT JOIN ja25_expautos_fuel AS fl 
  ON fl.id = a.fuel 
  LEFT JOIN ja25_users AS user 
  ON user.id = a.user 
  LEFT JOIN ja25_expautos_expuser AS expuser 
  ON expuser.userid = a.user 
  LEFT JOIN ja25_expautos_country AS expusercountry 
  ON expusercountry.id = expuser.country 
  LEFT JOIN ja25_expautos_state AS expuserstate 
  ON expuserstate.id = expuser.expstate 
  LEFT JOIN ja25_expautos_cities AS expusercity 
  ON expusercity.id = expuser.city 
  LEFT JOIN ja25_expautos_country AS cnt 
  ON cnt.id = a.country 
  LEFT JOIN ja25_expautos_state AS st 
  ON st.id = a.expstate 
  LEFT JOIN ja25_expautos_cities AS ct 
  ON ct.id = a.city 
  LEFT JOIN ja25_viewlevels AS ag 
  ON ag.id = a.access 
  AND ag.id = c.access

1 × SELECT params 
  FROM ja25_modules

1 × SELECT id, cname, exchange, cvariable, expicon, priceformat, moneyformat 
  FROM ja25_expautos_currency

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM ja25_banners as a 
  LEFT JOIN ja25_banner_clients AS cl 
  ON cl.id = a.cid

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM ja25_fields AS a 
  LEFT JOIN `ja25_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ja25_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ja25_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ja25_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ja25_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT * 
  FROM `ja25_extensions`

```
1 × SELECT * 
  FROM ja25_gsd_config
```

1 × SELECT *  
  FROM ja25_jmap_metainfo

1 × SELECT *  
  FROM ja25_jmap_canonicals

1 × SELECT *  
  FROM ja25_jmap_headings

```
1 × SELECT * 
  FROM ja25_banners
```

1 × SELECT `data` 
  FROM `ja25_session`

1 × SELECT id, rules 
  FROM `ja25_viewlevels

1 × SELECT a.*, a.id AS value, a.name AS text,c.title AS category_name 
  FROM ja25_expautos_make AS a 
  LEFT JOIN ja25_expautos_categories AS c 
  ON c.id = a.catid

1 × SELECT id, parent_id, level, lft, rgt 
  FROM ja25_expautos_categories

1 × SELECT a.*, a.id AS value, a.title AS text, a.parent_id AS parent_id, a.ecount AS catecount, a.description AS description, a.itemtype AS catitemtype 
  FROM ja25_expautos_categories AS a 
  LEFT JOIN `ja25_expautos_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

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

1 × SELECT a.id 
  FROM ja25_user_usergroup_map AS map 
  LEFT JOIN ja25_usergroups AS a 
  ON a.id = map.group_id

1 × SELECT explevel.id,explevel.userlevel,explevel.params,ugroup.title 
  FROM ja25_expautos_userlevel AS explevel 
  LEFT JOIN `ja25_usergroups` AS ugroup 
  ON ugroup.id = explevel.userlevel

1 × SELECT a.*, IF( a.bprice != "",a.bprice,a.price ) price ,a.price AS aprice, a.bprice AS bprice, a.imgmain AS img_name ,c.title AS category_name, c.id AS categid, c.itemtype AS catitemtype,mk.id AS mkid,mk.name AS make_name,md.id AS mdid,md.name AS model_name,bt.id AS btid,bt.name AS bodytype_name,dr.id AS drid,dr.name AS drive_name,ecl.id AS eclid,ecl.name AS extcolor_name, ecl.image AS extcolor_image, ecl.csscode AS csscode_color,tr.id AS trid,tr.name AS trans_name, tr.code AS trans_code,fl.id AS flid,fl.name AS fuel_name, fl.code AS fuel_code,user.id AS userwid,user.name AS user_name, user.username AS user_username, user.email AS user_email,expusercountry.id AS expusercountrywid,expuserstate.id AS expuserstatewid,expusercity.id AS expusercitywid,expuser.id AS expuser_id,expuser.lastname AS expuser_lastname, expuser.companyname AS expuser_companyname,expuser.street AS expuser_street,expuser.phone AS expuser_phone,expuser.web AS expuser_web, expuser.logo AS expuser_logo,expuser.headerimg AS expuser_headerimg, expuser.customimg AS expuser_customimg,expuser.zipcode AS expuser_zipcode, expuser.fax AS expuser_fax,expuser.mobphone AS expuser_mobphone, expuser.userinfo AS expuser_userinfo,expuser.utop AS expuser_utop, expuser.ucommercial AS expuser_ucommercial,expuser.uspecial AS expuser_uspecial,expusercountry.name AS expuser_country, expusercity.city_name AS expuser_city,expuserstate.name AS expuser_state,expuser.latitude AS expuser_latitude,expuser.longitude AS expuser_longitude,cnt.id AS cntid,cnt.name AS cnt_name,st.id AS stid,st.name AS st_name,ct.id AS ctid,ct.city_name AS ct_name,ag.title AS access_level 
  FROM ja25_expautos_admanager as a 
  LEFT JOIN ja25_expautos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ja25_expautos_make AS mk 
  ON mk.id = a.make 
  LEFT JOIN ja25_expautos_model AS md 
  ON md.id = a.model 
  LEFT JOIN ja25_expautos_bodytype AS bt 
  ON bt.id = a.bodytype 
  LEFT JOIN ja25_expautos_drive AS dr 
  ON dr.id = a.drive 
  LEFT JOIN ja25_expautos_color AS ecl 
  ON ecl.id = a.extcolor 
  LEFT JOIN ja25_expautos_trans AS tr 
  ON tr.id = a.trans 
  LEFT JOIN ja25_expautos_fuel AS fl 
  ON fl.id = a.fuel 
  LEFT JOIN ja25_users AS user 
  ON user.id = a.user 
  LEFT JOIN ja25_expautos_expuser AS expuser 
  ON expuser.userid = a.user 
  LEFT JOIN ja25_expautos_country AS expusercountry 
  ON expusercountry.id = expuser.country 
  LEFT JOIN ja25_expautos_state AS expuserstate 
  ON expuserstate.id = expuser.expstate 
  LEFT JOIN ja25_expautos_cities AS expusercity 
  ON expusercity.id = expuser.city 
  LEFT JOIN ja25_expautos_country AS cnt 
  ON cnt.id = a.country 
  LEFT JOIN ja25_expautos_state AS st 
  ON st.id = a.expstate 
  LEFT JOIN ja25_expautos_cities AS ct 
  ON ct.id = a.city 
  LEFT JOIN ja25_viewlevels AS ag 
  ON ag.id = a.access 
  AND ag.id = c.access

1 × SELECT id 
  FROM ja25_expautos_expuser

1 × SELECT params 
  FROM ja25_expautos_config

1 × SELECT CONCAT_WS(".", `
  group`, `key`) as group_key,   `value`,   `type` 
  FROM ja25_zoo_jbzoo_config 
  LIMIT 100

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

1 × SELECT  `original_text`,  `target_text`,  `original_text_regex`,  `target_text_regex`  
  FROM  `ja25_jmap_text_replacements`

Запросы типа OTHER:

1 × UPDATE `ja25_extensions` 
  SET `params` = '{\"mediaversion\":\"6b9edba7c9d9ed2bb7a4f2517ca3b35c\"}'

1 × CREATE TABLE IF NOT EXISTS `ja25_zoo_jbzoo_config` (`
  group` VARCHAR(150) NULL DEFAULT NULL,  `key` VARCHAR(100) NULL DEFAULT NULL,  `value` TEXT NULL,  `type` VARCHAR(10) NULL DEFAULT 'string',  UNIQUE INDEX `group_key` (`
  group`, `key`),  INDEX `
  group` (`
  group`),  INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM

1 × SHOW FULL COLUMNS 
  FROM `ja25_expautos_categories

1 × UPDATE ja25_banners 
  SET impmade = (impmade + 1)

1 × UPDATE ja25_banner_tracks 
  SET `count` = (`count` + 1)

1 × SHOW FULL COLUMNS 
  FROM `ja25_gsd_config