Temps de requête : 0.89 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.112 MB
Update
kyhul_contentbuilder_articles As articles,
kyhul_content As content,
kyhul_contentbuilder_forms As forms,
kyhul_contentbuilder_registered_users As cbusers,
kyhul_users As users
Set
content.state = 0
Where
articles.article_id = content.id
And
content.state = 1
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
(
(
users.id = cbusers.user_id
And
users.block = 1
)
)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
11 | JFalangDatabase->execute() | JROOT/plugins/system/falangdriver/falang_database.php:124 |
10 | JFalangDatabase->query() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:417 |
9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362 |
8 | plgSystemContentbuilder_system->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 |
Temps de requête : 0.31 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.005 MB mémoire avant requête : 13.120 MB
Update
kyhul_contentbuilder_articles As articles,
kyhul_content As content,
kyhul_contentbuilder_forms As forms,
kyhul_contentbuilder_records As records,
kyhul_contentbuilder_registered_users As cbusers,
kyhul_users As users
Set
content.state = forms.auto_publish
Where
articles.article_id = content.id
And
content.state = 0
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
users.id = cbusers.user_id
And
records.record_id = cbusers.record_id
And
records.`type` = forms.`type`
And
users.block = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
11 | JFalangDatabase->execute() | JROOT/plugins/system/falangdriver/falang_database.php:124 |
10 | JFalangDatabase->query() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:450 |
9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362 |
8 | plgSystemContentbuilder_system->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 |
Temps de requête : 0.12 ms Après la dernière requête : 1.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.026 MB Rangées retournées : 0
Select
form.id As form_id,
form.act_as_registration,
form.default_category,
form.registration_name_field,
form.registration_username_field,
form.registration_email_field,
form.registration_email_repeat_field,
form.`last_update`,
article.`article_id`,
form.`title_field`,
form.`create_articles`,
form.`name`,
form.`use_view_name_as_title`,
form.`protect_upload_directory`,
form.`reference_id`,
records.`record_id`,
form.`type`,
form.`published_only`,
form.`own_only`,
form.`own_only_fe`,
records.`last_update` As record_last_update,
article.`last_update` As article_last_update
From
kyhul_contentbuilder_records As records
Left Join kyhul_contentbuilder_forms As form
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id )
Left Join kyhul_contentbuilder_articles As article
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.form_id = form.id
And article.record_id = records.record_id )
Left Join kyhul_content As content
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.article_id = content.id
And article.form_id = form.id
And article.record_id = records.record_id )
Where
form.`published` = 1
And
form.create_articles = 1
And
form.`type` = records.`type`
And
form.reference_id = records.reference_id
And
(
(
article.form_id = form.id
And
article.record_id = records.record_id
And
article.article_id = content.id
And
( content.state = 1 Or content.state = 0 )
And
(
form.`last_update` > article.`last_update`
Or
records.`last_update` > article.`last_update`
)
)
Or
(
form.id Is Not Null
And records.id Is Not Null
And content.id Is Null
And article.id Is Null
)
)
Limit 50
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | form | NULL | ALL | PRIMARY,reference_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 6 | 16.67 | Using where |
1 | SIMPLE | records | NULL | ref | PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6 | reference_id | 4 | db139985_7.form.reference_id | 3276 | 49.98 | Using where |
1 | SIMPLE | article | NULL | ref | record_id,record_id_2 | record_id | 12 | db139985_7.records.record_id,db139985_7.form.id | 1 | 60.00 | Using where |
1 | SIMPLE | content | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db139985_7.article.article_id | 1 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
13 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
11 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:459 |
10 | JFalangDatabase->loadAssocList() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:516 |
9 | plgSystemContentbuilder_system->onAfterInitialize() | JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362 |
8 | plgSystemContentbuilder_system->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 |
Temps de requête : 0.57 ms Après la dernière requête : 10.31 ms Mémoire de requête : 0.026 MB mémoire avant requête : 16.440 MB Rangées retournées : 2
SHOW FULL COLUMNS
FROM `kyhul_komento_configs`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `kyhul_komento_configs`
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
18 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_komento/tables/parent.php:18 |
14 | KomentoParentTable->__construct() | JROOT/administrator/components/com_komento/tables/configs.php:40 |
13 | KomentoTableConfigs->__construct() | JROOT/libraries/src/Table/Table.php:328 |
12 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_komento/tables/parent.php:49 |
11 | KomentoParentTable::getInstance() | JROOT/components/com_komento/helpers/helper.php:99 |
10 | Komento::getTable() | JROOT/components/com_komento/helpers/helper.php:228 |
9 | Komento::getKonfig() | JROOT/components/com_komento/bootstrap.php:30 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:16 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
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 |
Temps de requête : 0.07 ms Après la dernière requête : 0.60 ms Mémoire de requête : 0.024 MB mémoire avant requête : 16.458 MB Rangées retournées : 1
SELECT *
FROM kyhul_komento_configs
WHERE `component` = 'com_komento'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_komento_configs | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | 20.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
13 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
12 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
11 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_komento/helpers/helper.php:229 |
9 | Komento::getKonfig() | JROOT/components/com_komento/bootstrap.php:30 |
8 | require_once JROOT/components/com_komento/bootstrap.php | JROOT/components/com_komento/router.php:16 |
7 | require_once JROOT/components/com_komento/router.php | JROOT/libraries/src/Router/SiteRouter.php:779 |
6 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:131 |
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 |
Temps de requête : 1.26 ms Après la dernière requête : 7.86 ms Mémoire de requête : 0.104 MB mémoire avant requête : 17.084 MB Rangées retournées : 48
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM kyhul_menu AS m
LEFT JOIN kyhul_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 92 | 3.33 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db139985_7.m.component_id | 1 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/plugins/system/falangdriver/falangdriver.php:368 |
11 | plgSystemFalangdriver->parseRule() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.70 ms Mémoire de requête : 0.027 MB mémoire avant requête : 17.659 MB Rangées retournées : 10
SELECT joomlatablename,tablepkID
FROM `kyhul_falang_tableinfo`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_falang_tableinfo | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 10 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
25 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
23 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144 |
22 | FalangManager->_loadPrimaryKeyData() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57 |
21 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
20 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
19 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/plugins/system/falangdriver/falangdriver.php:368 |
11 | plgSystemFalangdriver->parseRule() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.028 MB mémoire avant requête : 17.672 MB Rangées retournées : 5
SELECT *
FROM kyhul_languages
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_languages | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | 100.00 | Utilisation du tri complet de type filesort |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
25 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
23 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319 |
22 | FalangManager->getLanguages() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 |
21 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
20 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
19 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/plugins/system/falangdriver/falangdriver.php:368 |
11 | plgSystemFalangdriver->parseRule() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
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 |
Temps de requête : 0.41 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.031 MB mémoire avant requête : 17.694 MB Rangées retournées : 14
SHOW FULL COLUMNS
FROM `kyhul_languages`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `kyhul_languages`
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
29 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
28 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
27 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
26 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
25 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
24 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_falang/tables/JFLanguage.php:54 |
23 | TableJFLanguage->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325 |
22 | FalangManager->getLanguages() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 |
21 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
20 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
19 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/plugins/system/falangdriver/falangdriver.php:368 |
11 | plgSystemFalangdriver->parseRule() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
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 |
Temps de requête : 0.17 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.051 MB mémoire avant requête : 17.738 MB Rangées retournées : 103
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM kyhul_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(408,778,781,780,779,278,436,437,758,441,442,440,443,444,439,782,786,785,783,784,258,158,364,365,787,374,370,367,371,366,372,220,212,369,270,213,148,200,214,368,388,401,403,112,173,407,414,502)
AND falang_content.reference_table='menu'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | falang_content | NULL | range | falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1 | falangContent | 310 | NULL | 110 | 10.00 | Using index condition; Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
21 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
20 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
19 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
18 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/plugins/system/falangdriver/falangdriver.php:368 |
11 | plgSystemFalangdriver->parseRule() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
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 |
Temps de requête : 0.17 ms Après la dernière requête : 6.02 ms Mémoire de requête : 0.079 MB mémoire avant requête : 18.290 MB Rangées retournées : 1
SELECT *
FROM kyhul_easyblog_configs
WHERE `name` = 'config'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_configs | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 3 | 33.33 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
17 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
16 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
15 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
14 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
13 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:581 |
12 | EB::config() | JROOT/components/com_easyblog/router.php:513 |
11 | EasyBlogRouterBase::parseRoute() | JROOT/components/com_easyblog/router.php:1264 |
10 | EasyBlogParseRoute() | 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 |
Temps de requête : 0.67 ms Après la dernière requête : 1.42 ms Mémoire de requête : 0.025 MB mémoire avant requête : 18.433 MB Rangées retournées : 0
SELECT *
FROM kyhul_easyblog_category
WHERE `alias` = 'blogger'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_category | NULL | ref | idx_category_alias,idx_category_alias_id | idx_category_alias | 803 | const | 1 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
15 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
14 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
13 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
12 | Joomla\CMS\Table\Table->load() | JROOT/components/com_easyblog/router.php:561 |
11 | EasyBlogRouterBase::parseRoute() | JROOT/components/com_easyblog/router.php:1264 |
10 | EasyBlogParseRoute() | 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 |
Temps de requête : 0.10 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.024 MB mémoire avant requête : 18.443 MB Rangées retournées : 0
SELECT *
FROM kyhul_easyblog_category
WHERE `alias` = 'blogger'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_category | NULL | ref | idx_category_alias,idx_category_alias_id | idx_category_alias | 803 | const | 1 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
15 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
14 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
13 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
12 | Joomla\CMS\Table\Table->load() | JROOT/components/com_easyblog/router.php:583 |
11 | EasyBlogRouterBase::parseRoute() | JROOT/components/com_easyblog/router.php:1264 |
10 | EasyBlogParseRoute() | 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 |
Temps de requête : 0.13 ms Après la dernière requête : 5.96 ms Mémoire de requête : 0.029 MB mémoire avant requête : 19.457 MB Rangées retournées : 55
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kyhul_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advportfoliopro','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contentbuilder','com_contenthistory','com_cpanel','com_easyblog','com_falang','com_feedgator','com_fields','com_finder','com_installer','com_jbetolo','com_jce','com_joomlaupdate','com_jotcache','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocamaps','com_phocapanorama','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_rereplacer','com_search','com_sitemapgenerator','com_smartslider3','com_tagmeta','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_assets | NULL | ALL | idx_asset_name | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 541 | 10.54 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
13 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
12 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
11 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
10 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
9 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1225 |
8 | EB::isSiteAdmin() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:136 |
7 | EB::checkEnvironment() | JROOT/components/com_easyblog/easyblog.php:20 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.37 ms Après la dernière requête : 2.95 ms Mémoire de requête : 0.006 MB mémoire avant requête : 20.027 MB
DELETE
FROM `kyhul_easyblog_mailq`
WHERE `status`='1'
AND DATEDIFF(NOW(), `created`) >='7'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | DELETE | kyhul_easyblog_mailq | NULL | range | easyblog_mailq_status,idx_mailq_statuscreated | easyblog_mailq_status | 1 | const | 1 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
12 | JFalangDatabase->execute() | JROOT/administrator/components/com_easyblog/includes/utils.php:198 |
11 | EasyBlogDbJoomla->query() | JROOT/administrator/components/com_easyblog/models/mailer.php:39 |
10 | EasyBlogModelMailer->cleanup() | JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:29 |
9 | EasyBlogMailer->dispatch() | JROOT/components/com_easyblog/services/maintenance.php:18 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 20.034 MB Rangées retournées : 0
SELECT `id`
FROM `kyhul_easyblog_mailq`
WHERE `status`='0'
ORDER BY `id` ASC
LIMIT 20
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
11 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/mailer.php:67 |
10 | EasyBlogModelMailer->getPendingEmails() | JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:32 |
9 | EasyBlogMailer->dispatch() | JROOT/components/com_easyblog/services/maintenance.php:18 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.61 ms Après la dernière requête : 7.32 ms Mémoire de requête : 0.025 MB mémoire avant requête : 21.626 MB Rangées retournées : 0
SELECT *
FROM `kyhul_easyblog_post`
WHERE `publish_up`<='2023-12-03 18:08:48'
AND `published`='2'
AND `state`='0'
ORDER BY `id`
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_post | NULL | ref | easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 | easyblog_post_blogger_list | 1 | const | 1 | 5.00 | Using index condition; Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
11 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogs.php:386 |
10 | EasyBlogModelBlogs->getScheduledPosts() | JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:51 |
9 | EasyBlogScheduler->publish() | JROOT/components/com_easyblog/services/maintenance.php:22 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.23 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.023 MB mémoire avant requête : 21.641 MB Rangées retournées : 0
SELECT id, created_by
FROM`kyhul_easyblog_post`
WHERE `publish_down` > `publish_up`
AND `publish_down` <= '2023-12-03 18:08:48'
AND `publish_down` != '0000-00-00 00:00:00'
AND `published` = '1'
AND `state` = '0'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_post | NULL | range | easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1,idx_publishdown_posts | idx_publishdown_posts | 11 | NULL | 2 | 2.89 | Using index condition; Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
11 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogs.php:542 |
10 | EasyBlogModelBlogs->getUnpublishScheduledPosts() | JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:26 |
9 | EasyBlogScheduler->unpublish() | JROOT/components/com_easyblog/services/maintenance.php:25 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.37 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.023 MB mémoire avant requête : 21.647 MB Rangées retournées : 0
SELECT *
FROM `kyhul_easyblog_uploader_tmp`
WHERE `created` <= DATE_SUB('2023-12-03 18:08:48' , INTERVAL 120 MINUTE)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
11 | JFalangDatabase->loadObject() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
10 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:165 |
9 | EasyBlogScheduler->removeTmpFiles() | JROOT/components/com_easyblog/services/maintenance.php:28 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.42 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 21.655 MB Rangées retournées : 0
SELECT a.`id`
FROM `kyhul_easyblog_post` as a
inner join `kyhul_easyblog_revisions` as b
on a.`id` = b.`post_id`
where a.`published` = '9'
and a.`created` <= DATE_SUB('2023-12-03 18:08:48', INTERVAL 3 DAY)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 | easyblog_post_published | 1 | const | 1 | 33.33 | Using where |
1 | SIMPLE | b | NULL | ref | idx_postid,idx_ordering,idx_revision_state | idx_postid | 8 | db139985_7.a.id | 1 | 100.00 | Using where; Using index |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
13 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
11 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
10 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:207 |
9 | EasyBlogScheduler->removeBlankPosts() | JROOT/components/com_easyblog/services/maintenance.php:31 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.21 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.006 MB mémoire avant requête : 21.662 MB
DELETE a, b
FROM `kyhul_easyblog_post` as a
inner join `kyhul_easyblog_revisions` as b
on a.`id` = b.`post_id`
where a.`published` = '9'
and a.`created` <= DATE_SUB('2023-12-03 18:08:48', INTERVAL 3 DAY)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | DELETE | a | NULL | ref | PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 | easyblog_post_published | 1 | const | 1 | 33.33 | Using where |
1 | DELETE | b | NULL | ref | idx_postid,idx_ordering,idx_revision_state | idx_postid | 8 | db139985_7.a.id | 1 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
11 | JFalangDatabase->execute() | JROOT/administrator/components/com_easyblog/includes/utils.php:198 |
10 | EasyBlogDbJoomla->query() | JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:220 |
9 | EasyBlogScheduler->removeBlankPosts() | JROOT/components/com_easyblog/services/maintenance.php:31 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.48 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.023 MB mémoire avant requête : 21.703 MB Rangées retournées : 0
select a.`id`, a.`user_id`, b.`name`, b.`email`
from `kyhul_easyblog_oauth` as a
inner join `kyhul_users` as b
on a.`user_id` = b.`id`
where a.`type` = 'facebook'
and a.`notify` = '0'
and a.`system` = '1'
and a.`expires` <= DATE_ADD('2023-12-03 18:08:48', INTERVAL 7 DAY)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | easyblog_oauth_user_type,idx_expiry_notify | idx_expiry_notify | 806 | const,const,const | 1 | 33.33 | Using where |
1 | SIMPLE | b | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db139985_7.a.user_id | 1 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/oauth.php:361 |
11 | EasyBlogModelOauth->getSoonTobeExpired() | JROOT/administrator/components/com_easyblog/includes/oauth/adapters/facebook/client.php:572 |
10 | EasyBlogClientFacebook->notifyAdminTokenExpiry() | JROOT/administrator/components/com_easyblog/includes/oauth/oauth.php:111 |
9 | EasyBlogOauth->notifyAdminTokenExpiry() | JROOT/components/com_easyblog/services/maintenance.php:34 |
8 | require_once JROOT/components/com_easyblog/services/maintenance.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.12 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.025 MB mémoire avant requête : 21.730 MB Rangées retournées : 1
SELECT *
FROM `kyhul_menu`
WHERE `published`='1'
AND `link` LIKE 'index.php?option=com_easyblog%'
AND `client_id` = '0'
ORDER BY `id`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 70 | 1.11 | Using index condition; Using where; Utilisation du tri complet de type filesort |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
13 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/menu.php:64 |
12 | EasyBlogModelMenu->getAssociatedMenus() | JROOT/administrator/components/com_easyblog/includes/router.php:97 |
11 | EBR::getMenus() | JROOT/administrator/components/com_easyblog/includes/router.php:453 |
10 | EBR::_() | JROOT/administrator/components/com_easyblog/includes/router.php:955 |
9 | EBR::getRoutedURL() | JROOT/components/com_easyblog/services/weblog.php:26 |
8 | require_once JROOT/components/com_easyblog/services/weblog.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.07 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.025 MB mémoire avant requête : 21.758 MB Rangées retournées : 1
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM kyhul_falang_content AS falang_content
WHERE falang_content.language_id=3
AND falang_content.published=1
AND falang_content.reference_id IN(158)
AND falang_content.reference_table='menu'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | falang_content | NULL | ref | falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1 | falangContent | 310 | const,const,const | 1 | 10.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
17 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
16 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
15 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
13 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/menu.php:64 |
12 | EasyBlogModelMenu->getAssociatedMenus() | JROOT/administrator/components/com_easyblog/includes/router.php:97 |
11 | EBR::getMenus() | JROOT/administrator/components/com_easyblog/includes/router.php:453 |
10 | EBR::_() | JROOT/administrator/components/com_easyblog/includes/router.php:955 |
9 | EBR::getRoutedURL() | JROOT/components/com_easyblog/services/weblog.php:26 |
8 | require_once JROOT/components/com_easyblog/services/weblog.php | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925 |
7 | EB::loadServices() | JROOT/components/com_easyblog/easyblog.php:27 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.09 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.032 MB mémoire avant requête : 21.774 MB Rangées retournées : 46
SELECT *
FROM `kyhul_easyblog_acl`
WHERE `published`='1'
ORDER BY `id` ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_acl | NULL | ALL | idx_acl_published,idx_acl_published_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 46 | 97.83 | Using where; Utilisation du tri complet de type filesort |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:322 |
11 | EasyBlogAcl::getRules() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:36 |
10 | EasyBlogAcl::getRuleSet() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 |
9 | EB::acl() | JROOT/components/com_easyblog/controllers/controller.php:22 |
8 | EasyBlogController->__construct() | JROOT/libraries/src/MVC/Controller/BaseController.php:313 |
7 | Joomla\CMS\MVC\Controller\BaseController::getInstance() | JROOT/components/com_easyblog/easyblog.php:33 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.07 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.028 MB mémoire avant requête : 21.796 MB Rangées retournées : 46
SELECT *
FROM `kyhul_easyblog_acl_group`
WHERE `content_id` IN (1)
AND `type`='
group'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_acl_group | NULL | ref | easyblog_post_acl_content_type | easyblog_post_acl_content_type | 810 | const,const | 46 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151 |
11 | EasyBlogAcl::getEasyBlogAclGroups() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:98 |
10 | EasyBlogAcl::getRuleSet() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 |
9 | EB::acl() | JROOT/components/com_easyblog/controllers/controller.php:22 |
8 | EasyBlogController->__construct() | JROOT/libraries/src/MVC/Controller/BaseController.php:313 |
7 | Joomla\CMS\MVC\Controller\BaseController::getInstance() | JROOT/components/com_easyblog/easyblog.php:33 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.49 ms Après la dernière requête : 1.66 ms Mémoire de requête : 0.027 MB mémoire avant requête : 22.319 MB Rangées retournées : 0
SELECT `id`
FROM `kyhul_menu`
WHERE `link`='index.php?option=com_easyblog&view=blogger'
AND `published`='1'
AND (`language`='fr-FR' OR `language`='' OR `language`='*')
AND `client_id`='0'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_menu | NULL | ref | idx_client_id_parent_id_alias_language,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 70 | 0.91 | Using index condition; Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
24 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
22 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
21 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
20 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
19 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
18 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/menu.php:436 |
17 | EasyBlogModelMenu->getMenus() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:4338 |
16 | EB::getMenuParams() | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:178 |
15 | EasyBlogThemes->__construct() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3832 |
14 | EB::template() | JROOT/components/com_easyblog/views/views.php:48 |
13 | EasyBlogView->__construct() | JROOT/components/com_easyblog/views/blogger/view.html.php:29 |
12 | EasyBlogViewBlogger->__construct() | JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89 |
11 | Joomla\CMS\MVC\Factory\LegacyFactory->createView() | JROOT/libraries/src/MVC/Controller/BaseController.php:590 |
10 | Joomla\CMS\MVC\Controller\BaseController->createView() | JROOT/libraries/src/MVC/Controller/BaseController.php:833 |
9 | Joomla\CMS\MVC\Controller\BaseController->getView() | JROOT/components/com_easyblog/controllers/controller.php:69 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 9.41 ms Après la dernière requête : 2.70 ms Mémoire de requête : 0.023 MB mémoire avant requête : 23.283 MB Rangées retournées : 2
select SQL_CALC_FOUND_ROWS count( p.id ) as `totalPost`, MAX(p.`created`) as `latestPostDate`, COUNT( DISTINCT(g.content_id) ) as `featured`, a.`id`, b.`nickname`, a.`name`, a.`username`, a.`registerDate`, a.`lastvisitDate`, b.`permalink`, IFNULL(oa.id, 0) as hasTwitter
from `kyhul_users` as a
inner JOIN `kyhul_easyblog_users` AS `b`
ON a.`id` = b.`id`
inner join `kyhul_easyblog_post` as p
on a.`id` = p.`created_by`
and not exists ( select acp2.post_id
from `kyhul_easyblog_post_category` as acp2
inner join `kyhul_easyblog_category` as cat2
on acp2.`category_id` = cat2.`id`
where acp2.`post_id` = p.`id`
and ( ( cat2.`private` = 1
and (0 = 0) ) OR ( cat2.`private` = 2
and (select count(1)
from `kyhul_easyblog_category_acl` as cacl2
where cacl2.`category_id` = cat2.`id`
and cacl2.`acl_id` = 1
and cacl2.`content_id` IN (1)) = 0 ) ) )
left join `kyhul_easyblog_featured` AS `g`
ON a.`id`= g.`content_id`
AND g.`type`= 'blogger'
left join `kyhul_easyblog_oauth` AS `oa`
ON a.`id`= oa.`user_id`
AND oa.`type`= 'twitter'
where (1 <= (select count(1)
from `kyhul_easyblog_acl_group` as ag
inner join `kyhul_easyblog_acl` as acl
on ag.`acl_id` = acl.`id`
inner join `kyhul_user_usergroup_map` as up
on ag.`content_id` = up.`group_id`
where up.`user_id` = `a`.`id`
and acl.`action` = 'add_entry'
and ag.`type` = '
group'
and ag.`status` = 1))
and `p`.`published` = '1'
and p.`state` = '0'
and a.`block` = 0
group by a.`id`
having (count(p.id) > 0)
ORDER BY a.`id` DESC
LIMIT 0,100
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | g | NULL | system | easyblog_featured_content_type,easyblog_content | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | PRIMARY | p | NULL | ref | easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 | easyblog_post_blogger_list | 1 | const | 62 | 10.00 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_username,idx_block,email,idx_name | PRIMARY | 4 | db139985_7.p.created_by | 1 | 100.00 | Using where |
1 | PRIMARY | b | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.a.id | 1 | 100.00 | Using index condition |
1 | PRIMARY | oa | NULL | ref | easyblog_oauth_user_type,idx_expiry_notify | easyblog_oauth_user_type | 806 | db139985_7.a.id,const | 1 | 100.00 | Using where |
4 | DEPENDENT SUBQUERY | acl | NULL | ref | PRIMARY,easyblog_post_acl_action | easyblog_post_acl_action | 802 | const | 1 | 100.00 | Using where |
4 | DEPENDENT SUBQUERY | ag | NULL | ref | easyblog_post_acl_content_type,easyblog_post_acl,acl_grp_acl_type | easyblog_post_acl | 8 | db139985_7.acl.id | 8 | 1.00 | Using where |
4 | DEPENDENT SUBQUERY | up | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.a.id,db139985_7.ag.content_id | 1 | 100.00 | Using where; Using index |
2 | DEPENDENT SUBQUERY | acp2 | NULL | ref | eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post | eb_post_category_post_cat | 4 | db139985_7.p.id | 2 | 100.00 | Using where; Using index |
2 | DEPENDENT SUBQUERY | cat2 | NULL | eq_ref | PRIMARY,easyblog_cat_private | PRIMARY | 8 | db139985_7.acp2.category_id | 1 | 20.00 | Using index condition; Using where |
3 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
11 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogger.php:522 |
10 | EasyBlogModelBlogger->getBloggers() | JROOT/components/com_easyblog/views/blogger/view.html.php:80 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 7.54 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.024 MB mémoire avant requête : 23.293 MB Rangées retournées : 1
select count(1)
from (select a.`id`
from `kyhul_users` as a
inner JOIN `kyhul_easyblog_users` AS `b`
ON a.`id` = b.`id`
inner join `kyhul_easyblog_post` as p
on a.`id` = p.`created_by`
and not exists ( select acp2.post_id
from `kyhul_easyblog_post_category` as acp2
inner join `kyhul_easyblog_category` as cat2
on acp2.`category_id` = cat2.`id`
where acp2.`post_id` = p.`id`
and ( ( cat2.`private` = 1
and (0 = 0) ) OR ( cat2.`private` = 2
and (select count(1)
from `kyhul_easyblog_category_acl` as cacl2
where cacl2.`category_id` = cat2.`id`
and cacl2.`acl_id` = 1
and cacl2.`content_id` IN (1)) = 0 ) ) )
left join `kyhul_easyblog_featured` AS `g`
ON a.`id`= g.`content_id`
AND g.`type`= 'blogger'
left join `kyhul_easyblog_oauth` AS `oa`
ON a.`id`= oa.`user_id`
AND oa.`type`= 'twitter'
where (1 <= (select count(1)
from `kyhul_easyblog_acl_group` as ag
inner join `kyhul_easyblog_acl` as acl
on ag.`acl_id` = acl.`id`
inner join `kyhul_user_usergroup_map` as up
on ag.`content_id` = up.`group_id`
where up.`user_id` = `a`.`id`
and acl.`action` = 'add_entry'
and ag.`type` = '
group'
and ag.`status` = 1))
and `p`.`published` = '1'
and p.`state` = '0'
and a.`block` = 0
group by a.`id`
having (count(p.id) > 0)) as x
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | <derived2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 6 | 100.00 | NULL |
2 | DERIVED | g | NULL | system | easyblog_featured_content_type,easyblog_content | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
2 | DERIVED | p | NULL | ref | easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 | easyblog_post_blogger_list | 1 | const | 62 | 10.00 | Using where; Using temporary; Utilisation du tri complet de type filesort |
2 | DERIVED | a | NULL | eq_ref | PRIMARY,idx_username,idx_block,email,idx_name | PRIMARY | 4 | db139985_7.p.created_by | 1 | 100.00 | Using where |
2 | DERIVED | b | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.a.id | 1 | 100.00 | Using where; Using index |
2 | DERIVED | oa | NULL | ref | easyblog_oauth_user_type,idx_expiry_notify | easyblog_oauth_user_type | 806 | db139985_7.a.id,const | 1 | 100.00 | Using where |
5 | DEPENDENT SUBQUERY | acl | NULL | ref | PRIMARY,easyblog_post_acl_action | easyblog_post_acl_action | 802 | const | 1 | 100.00 | Using where |
5 | DEPENDENT SUBQUERY | ag | NULL | ref | easyblog_post_acl_content_type,easyblog_post_acl,acl_grp_acl_type | easyblog_post_acl | 8 | db139985_7.acl.id | 8 | 1.00 | Using where |
5 | DEPENDENT SUBQUERY | up | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.a.id,db139985_7.ag.content_id | 1 | 100.00 | Using where; Using index |
3 | DEPENDENT SUBQUERY | acp2 | NULL | ref | eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post | eb_post_category_post_cat | 4 | db139985_7.p.id | 2 | 100.00 | Using where; Using index |
3 | DEPENDENT SUBQUERY | cat2 | NULL | eq_ref | PRIMARY,easyblog_cat_private | PRIMARY | 8 | db139985_7.acp2.category_id | 1 | 20.00 | Using index condition; Using where |
4 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
15 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
14 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
13 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
12 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
11 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogger.php:533 |
10 | EasyBlogModelBlogger->getBloggers() | JROOT/components/com_easyblog/views/blogger/view.html.php:80 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.52 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.024 MB mémoire avant requête : 23.308 MB Rangées retournées : 1
SELECT *
FROM kyhul_easyblog_meta
WHERE `content_id` = '4'
AND `type` = 'view'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_meta | NULL | ref | idx_meta_content_type | idx_meta_content_type | 86 | const,const | 1 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
15 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
14 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
13 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
12 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
11 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1958 |
10 | EB::setMeta() | JROOT/components/com_easyblog/views/blogger/view.html.php:85 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.32 ms Après la dernière requête : 0.55 ms Mémoire de requête : 0.026 MB mémoire avant requête : 23.330 MB Rangées retournées : 2
select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering`
from `kyhul_users` as u
left join `kyhul_easyblog_users` as e
ON u.`id` = e.`id`
where u.`id` IN (50,43)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | u | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 2 | 100.00 | Using where |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.u.id | 1 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
15 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
14 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/users.php:298 |
13 | EasyBlogModelUsers->getUsersMeta() | JROOT/administrator/components/com_easyblog/includes/user/user.php:171 |
12 | EasyBlogUser::loadUsers() | JROOT/administrator/components/com_easyblog/includes/user/user.php:63 |
11 | EasyBlogUser::factory() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 |
10 | EB::user() | JROOT/components/com_easyblog/views/blogger/view.html.php:116 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.35 ms Après la dernière requête : 0.89 ms Mémoire de requête : 0.030 MB mémoire avant requête : 23.797 MB Rangées retournées : 17
SHOW FULL COLUMNS
FROM `kyhul_users`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `kyhul_users`
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
25 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
23 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
20 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:41 |
19 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:328 |
18 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
17 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:877 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/administrator/components/com_easyblog/includes/user/user.php:218 |
12 | EasyBlogUser::loadUsers() | JROOT/administrator/components/com_easyblog/includes/user/user.php:63 |
11 | EasyBlogUser::factory() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 |
10 | EB::user() | JROOT/components/com_easyblog/views/blogger/view.html.php:116 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.09 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.028 MB mémoire avant requête : 23.836 MB Rangées retournées : 1
SELECT *
FROM `kyhul_users`
WHERE `id` = 43
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_users | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
21 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
20 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
19 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
18 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/User.php:87 |
17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/administrator/components/com_easyblog/includes/user/user.php:218 |
12 | EasyBlogUser::loadUsers() | JROOT/administrator/components/com_easyblog/includes/user/user.php:63 |
11 | EasyBlogUser::factory() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 |
10 | EB::user() | JROOT/components/com_easyblog/views/blogger/view.html.php:116 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.83 ms Mémoire de requête : 0.026 MB mémoire avant requête : 23.854 MB Rangées retournées : 1
SELECT `g`.`id`,`g`.`title`
FROM `kyhul_usergroups` AS g
INNER JOIN `kyhul_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 43
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db139985_7.m.group_id | 1 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
19 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:459 |
18 | JFalangDatabase->loadAssocList() | JROOT/libraries/src/Table/User.php:112 |
17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/administrator/components/com_easyblog/includes/user/user.php:218 |
12 | EasyBlogUser::loadUsers() | JROOT/administrator/components/com_easyblog/includes/user/user.php:63 |
11 | EasyBlogUser::factory() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 |
10 | EB::user() | JROOT/components/com_easyblog/views/blogger/view.html.php:116 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.09 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.027 MB mémoire avant requête : 23.867 MB Rangées retournées : 1
SELECT *
FROM `kyhul_users`
WHERE `id` = 50
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_users | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
21 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
20 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
19 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:434 |
18 | JFalangDatabase->loadAssoc() | JROOT/libraries/src/Table/User.php:87 |
17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/administrator/components/com_easyblog/includes/user/user.php:218 |
12 | EasyBlogUser::loadUsers() | JROOT/administrator/components/com_easyblog/includes/user/user.php:63 |
11 | EasyBlogUser::factory() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 |
10 | EB::user() | JROOT/components/com_easyblog/views/blogger/view.html.php:116 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.07 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.026 MB mémoire avant requête : 23.881 MB Rangées retournées : 1
SELECT `g`.`id`,`g`.`title`
FROM `kyhul_usergroups` AS g
INNER JOIN `kyhul_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 50
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | db139985_7.m.group_id | 1 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
19 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:459 |
18 | JFalangDatabase->loadAssocList() | JROOT/libraries/src/Table/User.php:112 |
17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/administrator/components/com_easyblog/includes/user/user.php:218 |
12 | EasyBlogUser::loadUsers() | JROOT/administrator/components/com_easyblog/includes/user/user.php:63 |
11 | EasyBlogUser::factory() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099 |
10 | EB::user() | JROOT/components/com_easyblog/views/blogger/view.html.php:116 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 4.59 ms Après la dernière requête : 2.38 ms Mémoire de requête : 1.695 MB mémoire avant requête : 25.705 MB Rangées retournées : 10
(select distinct p1.*, '50' as `author_id`, IFNULL(f1.`id`, 0) as `featured`
from `kyhul_easyblog_post` as p1
LEFT JOIN `kyhul_easyblog_featured` AS f1
ON p1.`id` = f1.`content_id`
AND f1.`type` = 'post'
where p1.created_by = '50'
and p1.`published` = '1'
and p1.`state` = '0'
AND p1.`access` = '0'
AND ((p1.`source_type` = 'easyblog.sitewide') OR ( p1.`source_type` = 'easyblog.team'
and 1 <= (select count(1)
from `kyhul_easyblog_team` as srcteam
where srcteam.`id` = p1.`source_id`
and srcteam.`published` = 1
and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2
and (select count(1)
from `kyhul_easyblog_team_groups` as srcteamgrp
where srcteamgrp.`team_id` = srcteam.`id`
and srcteamgrp.`group_id` IN (1) ) > 0)))))
AND (p1.`language`='fr-FR' OR p1.`language`='*' OR p1.`language`='')
and not exists ( select acp1.post_id
from `kyhul_easyblog_post_category` as acp1
inner join `kyhul_easyblog_category` as cat1
on acp1.`category_id` = cat1.`id`
where acp1.`post_id` = p1.`id`
and ( (cat1.`private` = 1
and (0 = 0)) OR (cat1.`private` = 2
and (select count(1)
from `kyhul_easyblog_category_acl` as cacl2
where cacl2.`category_id` = cat1.`id`
and cacl2.`acl_id` = 1
and cacl2.`content_id` IN (1)) = 0) ))
ORDER BY p1.`created` desc
limit 10) UNION ALL (select distinct p2.*, '43' as `author_id`, IFNULL(f2.`id`, 0) as `featured`
from `kyhul_easyblog_post` as p2
LEFT JOIN `kyhul_easyblog_featured` AS f2
ON p2.`id` = f2.`content_id`
AND f2.`type` = 'post'
where p2.created_by = '43'
and p2.`published` = '1'
and p2.`state` = '0'
AND p2.`access` = '0'
AND ((p2.`source_type` = 'easyblog.sitewide') OR ( p2.`source_type` = 'easyblog.team'
and 1 <= (select count(1)
from `kyhul_easyblog_team` as srcteam
where srcteam.`id` = p2.`source_id`
and srcteam.`published` = 1
and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2
and (select count(1)
from `kyhul_easyblog_team_groups` as srcteamgrp
where srcteamgrp.`team_id` = srcteam.`id`
and srcteamgrp.`group_id` IN (1) ) > 0)))))
AND (p2.`language`='fr-FR' OR p2.`language`='*' OR p2.`language`='')
and not exists ( select acp2.post_id
from `kyhul_easyblog_post_category` as acp2
inner join `kyhul_easyblog_category` as cat2
on acp2.`category_id` = cat2.`id`
where acp2.`post_id` = p2.`id`
and ( (cat2.`private` = 1
and (0 = 0)) OR (cat2.`private` = 2
and (select count(1)
from `kyhul_easyblog_category_acl` as cacl2
where cacl2.`category_id` = cat2.`id`
and cacl2.`acl_id` = 1
and cacl2.`content_id` IN (1)) = 0) ))
ORDER BY p2.`created` desc
limit 10)
EXPLAIN impossible sur la requête : (select distinct p1.*, '50' as `author_id`, IFNULL(f1.`id`, 0) as `featured` from `kyhul_easyblog_post` as p1 LEFT JOIN `kyhul_easyblog_featured` AS f1 ON p1.`id` = f1.`content_id` AND f1.`type` = 'post' where p1.created_by = '50' and p1.`published` = '1' and p1.`state` = '0' AND p1.`access` = '0' AND ((p1.`source_type` = 'easyblog.sitewide') OR ( p1.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `kyhul_easyblog_team` as srcteam where srcteam.`id` = p1.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `kyhul_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) AND (p1.`language`='fr-FR' OR p1.`language`='*' OR p1.`language`='') and not exists ( select acp1.post_id from `kyhul_easyblog_post_category` as acp1 inner join `kyhul_easyblog_category` as cat1 on acp1.`category_id` = cat1.`id` where acp1.`post_id` = p1.`id` and ( (cat1.`private` = 1 and (0 = 0)) OR (cat1.`private` = 2 and (select count(1) from `kyhul_easyblog_category_acl` as cacl2 where cacl2.`category_id` = cat1.`id` and cacl2.`acl_id` = 1 and cacl2.`content_id` IN (1)) = 0) )) ORDER BY p1.`created` desc limit 10) UNION ALL (select distinct p2.*, '43' as `author_id`, IFNULL(f2.`id`, 0) as `featured` from `kyhul_easyblog_post` as p2 LEFT JOIN `kyhul_easyblog_featured` AS f2 ON p2.`id` = f2.`content_id` AND f2.`type` = 'post' where p2.created_by = '43' and p2.`published` = '1' and p2.`state` = '0' AND p2.`access` = '0' AND ((p2.`source_type` = 'easyblog.sitewide') OR ( p2.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `kyhul_easyblog_team` as srcteam where srcteam.`id` = p2.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `kyhul_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (1) ) > 0))))) AND (p2.`language`='fr-FR' OR p2.`language`='*' OR p2.`language`='') and not exists ( select acp2.post_id from `kyhul_easyblog_post_category` as acp2 inner join `kyhul_easyblog_category` as cat2 on acp2.`category_id` = cat2.`id` where acp2.`post_id` = p2.`id` and ( (cat2.`private` = 1 and (0 = 0)) OR (cat2.`private` = 2 and (select count(1) from `kyhul_easyblog_category_acl` as cacl2 where cacl2.`category_id` = cat2.`id` and cacl2.`acl_id` = 1 and cacl2.`content_id` IN (1)) = 0) )) ORDER BY p2.`created` desc limit 10)
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogger.php:880 |
11 | EasyBlogModelBlogger->preloadPosts() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:73 |
10 | EasyBlogCache->insertBloggers() | JROOT/components/com_easyblog/views/blogger/view.html.php:129 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 2.48 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.023 MB mémoire avant requête : 26.891 MB Rangées retournées : 2
select count(distinct a.id) as `cnt`, c.`created_by` as `author_id`
from `kyhul_easyblog_tag` as a
inner join `kyhul_easyblog_post_tag` as b
on a.`id` = b.`tag_id`
inner join `kyhul_easyblog_post` as c
on b.`post_id` = c.`id`
where c.`created_by` IN (50,43)
and c.`published` = '1'
and c.`state` = '0'
group by c.`created_by`
order by null
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | PRIMARY,easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 | easyblog_post_blogger_list | 1 | const | 62 | 8.87 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | b | NULL | ref | easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id | easyblog_post_tag_post_id | 8 | db139985_7.c.id | 3 | 100.00 | NULL |
1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.b.tag_id | 1 | 100.00 | Using index |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogger.php:925 |
11 | EasyBlogModelBlogger->preloadTagUsed() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:93 |
10 | EasyBlogCache->insertBloggers() | JROOT/components/com_easyblog/views/blogger/view.html.php:129 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 1.46 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.023 MB mémoire avant requête : 26.898 MB Rangées retournées : 2
select count(distinct a.id) as `cnt`, c.`created_by` as `author_id`
from `kyhul_easyblog_category` as a
inner join `kyhul_easyblog_post_category` as b
ON a.`id` = b.`category_id`
inner join `kyhul_easyblog_post` as c
ON b.`post_id` = c.`id`
where c.`created_by` IN (50,43)
and c.`published` = '1'
and c.`state` = '0'
group by c.`created_by`
order by null
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | PRIMARY,easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1 | easyblog_post_blogger_list | 1 | const | 62 | 8.87 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | b | NULL | ref | eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post | eb_post_category_post_cat | 4 | db139985_7.c.id | 2 | 100.00 | Using where; Using index |
1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.b.category_id | 1 | 100.00 | Using where; Using index |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogger.php:974 |
11 | EasyBlogModelBlogger->preloadCategoryUsed() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:125 |
10 | EasyBlogCache->insertBloggers() | JROOT/components/com_easyblog/views/blogger/view.html.php:129 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.46 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 26.906 MB Rangées retournées : 0
SELECT `id`, `uid`
FROM `kyhul_easyblog_subscriptions`
WHERE `uid` IN (50,43)
AND `utype` = 'blogger'
AND `email` = ''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_subscriptions | NULL | ref | easyblog_subscriptions_types,easyblog_subscriptions_types_userid,easyblog_subscriptions_types_email,easyblog_subscriptions_email | easyblog_subscriptions_email | 402 | const | 1 | 14.29 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/blogger.php:1005 |
11 | EasyBlogModelBlogger->preloadBlogggerSubscribers() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:134 |
10 | EasyBlogCache->insertBloggers() | JROOT/components/com_easyblog/views/blogger/view.html.php:129 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.96 ms Après la dernière requête : 0.99 ms Mémoire de requête : 0.048 MB mémoire avant requête : 26.975 MB Rangées retournées : 17
select a.*, b.`post_id`, b.`primary`
from `kyhul_easyblog_category` as a
inner join `kyhul_easyblog_post_category` as b
on a.`id` = b.`category_id`
where b.`post_id` IN (1076,1120,1106,1103,1100,1095,1097,1089,1086,1072)
order by a.`lft` asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | b | NULL | range | eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post | eb_post_category_post_cat | 4 | NULL | 19 | 100.00 | Using index condition; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 8 | db139985_7.b.category_id | 1 | 100.00 | Using index condition |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
13 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/category.php:1753 |
12 | EasyBlogModelCategory->preloadByPosts() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:721 |
11 | EasyBlogCache->cacheCategories() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:372 |
10 | EasyBlogCache->insert() | JROOT/components/com_easyblog/views/blogger/view.html.php:174 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 2.04 ms Après la dernière requête : 0.66 ms Mémoire de requête : 1.334 MB mémoire avant requête : 27.090 MB Rangées retournées : 10
select a.*
from `kyhul_easyblog_revisions` as a
where a.`id` IN ( 2393,2560,2511,2501,2484,2463,2565,2438,2419,2359)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | range | PRIMARY | PRIMARY | 8 | NULL | 10 | 100.00 | Using index condition |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
13 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/revisions.php:625 |
12 | EasyBlogModelRevisions->preload() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:697 |
11 | EasyBlogCache->cacheRevisions() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:382 |
10 | EasyBlogCache->insert() | JROOT/components/com_easyblog/views/blogger/view.html.php:174 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 1.18 ms Après la dernière requête : 1.20 ms Mémoire de requête : 0.025 MB mémoire avant requête : 29.092 MB Rangées retournées : 0
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value`
from `kyhul_easyblog_category_fields_groups` as a
inner join `kyhul_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `kyhul_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `kyhul_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `kyhul_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`
LEFT JOIN `kyhul_easyblog_fields_groups_acl` AS acl
ON fg.`id` = acl.`group_id`
where p.post_id IN (1076,1120,1106,1103,1100,1095,1097,1089,1086,1072)
AND ( acl.`acl_id` IN(1)
AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
13 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/fields.php:309 |
12 | EasyBlogModelFields->preloadFields() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:484 |
11 | EasyBlogCache->cacheFields() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:392 |
10 | EasyBlogCache->insert() | JROOT/components/com_easyblog/views/blogger/view.html.php:174 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.51 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.025 MB mémoire avant requête : 29.114 MB Rangées retournées : 10
select *
from `kyhul_easyblog_meta`
where `content_id` in (1076,1120,1106,1103,1100,1095,1097,1089,1086,1072)
and `type` = 'post'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_meta | NULL | range | idx_meta_content_type | idx_meta_content_type | 86 | NULL | 26 | 100.00 | Using index condition |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
13 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/metas.php:393 |
12 | EasyBlogModelMetas->preloadPostMetas() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:413 |
11 | EasyBlogCache->cacheMetas() | JROOT/administrator/components/com_easyblog/includes/cache/cache.php:397 |
10 | EasyBlogCache->insert() | JROOT/components/com_easyblog/views/blogger/view.html.php:174 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.39 ms Après la dernière requête : 13.55 ms Mémoire de requête : 0.024 MB mémoire avant requête : 30.521 MB Rangées retournées : 0
SELECT *
FROM `kyhul_easyblog_oauth`
WHERE `user_id`='43'
AND `type`='twitter'
AND `system`='0'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_oauth | NULL | ref | easyblog_oauth_user_type,idx_expiry_notify | easyblog_oauth_user_type | 806 | const,const | 1 | 25.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
13 | JFalangDatabase->loadObject() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
12 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/tables/oauth.php:74 |
11 | EasyBlogTableOauth->loadByUser() | JROOT/administrator/components/com_easyblog/includes/socialshare/socialshare.php:31 |
10 | EasyBlogSocialShare::getLink() | JROOT/components/com_easyblog/views/blogger/view.html.php:220 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.024 MB mémoire avant requête : 30.533 MB Rangées retournées : 1
SELECT `group_id`
FROM `kyhul_user_usergroup_map`
WHERE `user_id` = '43'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_user_usergroup_map | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
15 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:178 |
14 | JFalangDatabase->loadColumn() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
13 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:58 |
12 | EasyBlogAcl::getRuleSet() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 |
11 | EB::acl() | JROOT/administrator/components/com_easyblog/includes/socialshare/socialshare.php:37 |
10 | EasyBlogSocialShare::getLink() | JROOT/components/com_easyblog/views/blogger/view.html.php:220 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.029 MB mémoire avant requête : 30.543 MB Rangées retournées : 46
SELECT *
FROM `kyhul_easyblog_acl_group`
WHERE `content_id` IN (8)
AND `type`='
group'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_acl_group | NULL | ref | easyblog_post_acl_content_type | easyblog_post_acl_content_type | 810 | const,const | 46 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
15 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
14 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151 |
13 | EasyBlogAcl::getEasyBlogAclGroups() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:65 |
12 | EasyBlogAcl::getRuleSet() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 |
11 | EB::acl() | JROOT/administrator/components/com_easyblog/includes/socialshare/socialshare.php:37 |
10 | EasyBlogSocialShare::getLink() | JROOT/components/com_easyblog/views/blogger/view.html.php:220 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.12 ms Après la dernière requête : 11.24 ms Mémoire de requête : 0.029 MB mémoire avant requête : 32.037 MB Rangées retournées : 1
SELECT `group_id`
FROM `kyhul_user_usergroup_map`
WHERE `user_id` = '50'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_user_usergroup_map | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
27 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
25 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:178 |
24 | JFalangDatabase->loadColumn() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
23 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:58 |
22 | EasyBlogAcl::getRuleSet() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 |
21 | EB::acl() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3289 |
20 | EB::isBlogger() | JROOT/administrator/components/com_easyblog/includes/profile/adapters/default/client.php:32 |
19 | EasyBlogProfileDefault->getLink() | JROOT/administrator/components/com_easyblog/includes/profile/profile.php:44 |
18 | EasyBlogProfile->getLink() | JROOT/administrator/components/com_easyblog/tables/profile.php:521 |
17 | EasyBlogTableProfile->getProfileLink() | JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php:27 |
16 | include JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
15 | EasyBlogThemes->output() | JROOT/administrator/components/com_easyblog/includes/themes/helpers/headers.php:110 |
14 | EasyBlogThemesHelperHeaders->author() | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:555 |
13 | EasyBlogThemes->html() | JROOT/components/com_easyblog/themes/wireframe/authors/default.php:67 |
12 | include JROOT/components/com_easyblog/themes/wireframe/authors/default.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
11 | EasyBlogThemes->output() | JROOT/components/com_easyblog/views/views.php:187 |
10 | EasyBlogView->display() | JROOT/components/com_easyblog/views/blogger/view.html.php:236 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.033 MB mémoire avant requête : 32.051 MB Rangées retournées : 46
SELECT *
FROM `kyhul_easyblog_acl_group`
WHERE `content_id` IN (3)
AND `type`='
group'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_acl_group | NULL | ref | easyblog_post_acl_content_type | easyblog_post_acl_content_type | 810 | const,const | 46 | 100.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
27 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
25 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
24 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151 |
23 | EasyBlogAcl::getEasyBlogAclGroups() | JROOT/administrator/components/com_easyblog/includes/acl/acl.php:65 |
22 | EasyBlogAcl::getRuleSet() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:219 |
21 | EB::acl() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3289 |
20 | EB::isBlogger() | JROOT/administrator/components/com_easyblog/includes/profile/adapters/default/client.php:32 |
19 | EasyBlogProfileDefault->getLink() | JROOT/administrator/components/com_easyblog/includes/profile/profile.php:44 |
18 | EasyBlogProfile->getLink() | JROOT/administrator/components/com_easyblog/tables/profile.php:521 |
17 | EasyBlogTableProfile->getProfileLink() | JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php:27 |
16 | include JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
15 | EasyBlogThemes->output() | JROOT/administrator/components/com_easyblog/includes/themes/helpers/headers.php:110 |
14 | EasyBlogThemesHelperHeaders->author() | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:555 |
13 | EasyBlogThemes->html() | JROOT/components/com_easyblog/themes/wireframe/authors/default.php:67 |
12 | include JROOT/components/com_easyblog/themes/wireframe/authors/default.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
11 | EasyBlogThemes->output() | JROOT/components/com_easyblog/views/views.php:187 |
10 | EasyBlogView->display() | JROOT/components/com_easyblog/views/blogger/view.html.php:236 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.18 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.027 MB mémoire avant requête : 32.086 MB Rangées retournées : 0
SELECT *
FROM `kyhul_easyblog_oauth`
WHERE `user_id`='50'
AND `type`='twitter'
AND `system`='0'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_oauth | NULL | ref | easyblog_oauth_user_type,idx_expiry_notify | easyblog_oauth_user_type | 806 | const,const | 1 | 25.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
21 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
20 | JFalangDatabase->loadObject() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
19 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/tables/oauth.php:74 |
18 | EasyBlogTableOauth->loadByUser() | JROOT/administrator/components/com_easyblog/tables/profile.php:414 |
17 | EasyBlogTableProfile->getTwitterLink() | JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php:44 |
16 | include JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
15 | EasyBlogThemes->output() | JROOT/administrator/components/com_easyblog/includes/themes/helpers/headers.php:110 |
14 | EasyBlogThemesHelperHeaders->author() | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:555 |
13 | EasyBlogThemes->html() | JROOT/components/com_easyblog/themes/wireframe/authors/default.php:67 |
12 | include JROOT/components/com_easyblog/themes/wireframe/authors/default.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
11 | EasyBlogThemes->output() | JROOT/components/com_easyblog/views/views.php:187 |
10 | EasyBlogView->display() | JROOT/components/com_easyblog/views/blogger/view.html.php:236 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.09 ms Après la dernière requête : 0.61 ms Mémoire de requête : 0.027 MB mémoire avant requête : 32.075 MB Rangées retournées : 5
select *
from kyhul_languages
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_languages | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | 100.00 | NULL |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
17 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
16 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/includes/router.php:315 |
15 | EBR::getSiteLanguageTag() | JROOT/administrator/components/com_easyblog/includes/router.php:425 |
14 | EBR::_() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:3967 |
13 | EB::_() | JROOT/components/com_easyblog/themes/wireframe/authors/default.php:123 |
12 | include JROOT/components/com_easyblog/themes/wireframe/authors/default.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
11 | EasyBlogThemes->output() | JROOT/components/com_easyblog/views/views.php:187 |
10 | EasyBlogView->display() | JROOT/components/com_easyblog/views/blogger/view.html.php:236 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.14 ms Après la dernière requête : 6.37 ms Mémoire de requête : 0.027 MB mémoire avant requête : 32.689 MB Rangées retournées : 0
SELECT *
FROM `kyhul_easyblog_oauth`
WHERE `user_id`='43'
AND `type`='twitter'
AND `system`='0'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | kyhul_easyblog_oauth | NULL | ref | easyblog_oauth_user_type,idx_expiry_notify | easyblog_oauth_user_type | 806 | const,const | 1 | 25.00 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
21 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
20 | JFalangDatabase->loadObject() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
19 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/tables/oauth.php:74 |
18 | EasyBlogTableOauth->loadByUser() | JROOT/administrator/components/com_easyblog/tables/profile.php:414 |
17 | EasyBlogTableProfile->getTwitterLink() | JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php:44 |
16 | include JROOT/components/com_easyblog/themes/wireframe/helpers/headers/author.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
15 | EasyBlogThemes->output() | JROOT/administrator/components/com_easyblog/includes/themes/helpers/headers.php:110 |
14 | EasyBlogThemesHelperHeaders->author() | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:555 |
13 | EasyBlogThemes->html() | JROOT/components/com_easyblog/themes/wireframe/authors/default.php:67 |
12 | include JROOT/components/com_easyblog/themes/wireframe/authors/default.php | JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608 |
11 | EasyBlogThemes->output() | JROOT/components/com_easyblog/views/views.php:187 |
10 | EasyBlogView->display() | JROOT/components/com_easyblog/views/blogger/view.html.php:236 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.13 ms Après la dernière requête : 12.88 ms Mémoire de requête : 0.026 MB mémoire avant requête : 34.151 MB Rangées retournées : 1
SELECT COUNT(1)
FROM `kyhul_easyblog_category_acl` as a
LEFT JOIN `kyhul_easyblog_category` as b
ON a.`category_id` = b.`id`
WHERE b.`published` = '1'
AND a.`acl_id` = '2'
AND a.`type` = 'user'
AND a.`content_id` = ''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
21 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
20 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
19 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
18 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
17 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/tables/categoryacl.php:79 |
16 | EasyBlogTableCategoryAcl->getUserAssignedCategoryACL() | JROOT/administrator/components/com_easyblog/includes/category/category.php:238 |
15 | EasyBlogCategory::genCatAccessSQL() | JROOT/administrator/components/com_easyblog/models/categories.php:607 |
14 | EasyBlogModelCategories->getParentCategories() | JROOT/administrator/components/com_easyblog/models/category.php:176 |
13 | EasyBlogModelCategory->getParentCategories() | JROOT/administrator/components/com_easyblog/includes/easyblog.php:2414 |
12 | EB::populateCategories() | JROOT/administrator/components/com_easyblog/includes/toolbar/toolbar.php:217 |
11 | EasyBlogToolbar->html() | JROOT/components/com_easyblog/views/views.php:216 |
10 | EasyBlogView->display() | JROOT/components/com_easyblog/views/blogger/view.html.php:236 |
9 | EasyBlogViewBlogger->display() | JROOT/components/com_easyblog/controllers/controller.php:105 |
8 | EasyBlogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_easyblog/easyblog.php:36 |
6 | require_once JROOT/components/com_easyblog/easyblog.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 |
Temps de requête : 0.08 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.025 MB mémoire avant requête : 34.162 MB Rangées retournées : 2
SELECT a.`id`, a.`title`, a.`alias`, a.`private`, a.`default`, a.`lft`, a.`rgt`, a.`params`
FROM `kyhul_easyblog_category` AS a
WHERE a.`parent_id` = '0'
AND a.`published` ='1'
AND (( (a.`private` = 0) OR (a.`private` = 1
AND '0' > 0) OR (a.`private` = 2
AND ( SELECT COUNT(1)
FROM `kyhul_easyblog_category_acl` as ca
WHERE ca.`category_id` = a.`id`
AND ca.`acl_id` = '2'
AND ( (ca.`content_id` IN ('1')
AND ca.`type` = '
group') OR (ca.`content_id` = '0'
AND ca.`type` = 'user') ) ) > 0 ) ))
ORDER BY a.`lft` ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | a | NULL | ref | easyblog_cat_published,easyblog_cat_parentid,easyblog_cat_private,idx_category_access | easyblog_cat_parentid | 5 | const | 2 | 90.00 | Using index condition; Using where; Utilisation du tri complet de type filesort |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
16 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_easyblog/includes/utils.php:330 |
15 | EasyBlogDbJoomla->__call() | JROOT/administrator/components/com_easyblog/models/categories.php:664 |
14 | EasyBlogModelCategories->getParentCategories() | JROOT/administrator/components/com_easyblog/models/category.php:176 |
13 | EasyBlogModelCategory->getParentC |