Temps de requête : 0.45 ms
SELECT `data`
FROM `rbywh_session`
WHERE `session_id` = X'72653571756e6f6f303874327334767239636e32736233693431'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | rbywh_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Même appel que celui de la ligne ci-dessous. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Temps de requête : 0.37 ms Après la dernière requête : 1.47 ms
SELECT `session_id`
FROM `rbywh_session`
WHERE `session_id` = X'72653571756e6f6f303874327334767239636e32736233693431'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | rbywh_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
9 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Temps de requête : 0.45 ms Après la dernière requête : 0.13 ms
INSERT INTO `rbywh_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'72653571756e6f6f303874327334767239636e32736233693431', 1, 1725962786, 0, '', 0)
EXPLAIN impossible sur la requête : INSERT INTO `rbywh_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'72653571756e6f6f303874327334767239636e32736233693431', 1, 1725962786, 0, '', 0)
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
8 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Temps de requête : 0.44 ms Après la dernière requête : 6.07 ms
SELECT id, rules
FROM `rbywh_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | rbywh_viewlevels | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 4 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.48 ms Après la dernière requête : 0.19 ms
SELECT b.id
FROM rbywh_usergroups AS a
LEFT JOIN rbywh_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.80 ms Après la dernière requête : 56.81 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rbywh_assets`
WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_autotweet','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailjet','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_sendinblue','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | rbywh_assets | range | idx_asset_name | idx_asset_name | 402 | NULL | 45 | Using index condition |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/plugins/system/advancedmodules/src/Document.php:28 |
11 | RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() | JROOT/plugins/system/advancedmodules/advancedmodules.php:78 |
10 | PlgSystemAdvancedModules->handleOnAfterRoute() | JROOT/libraries/regularlabs/src/Plugin.php:95 |
9 | RegularLabs\Library\Plugin->onAfterRoute() | Même appel que celui de la ligne ci-dessous. |
8 | call_user_func_array() | 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:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.50 ms Après la dernière requête : 2.91 ms
UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"5bfde08794209a2497f36c865824d2fb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN impossible sur la requête : UPDATE `rbywh_extensions`
SET `params` = '{\"mediaversion\":\"5bfde08794209a2497f36c865824d2fb\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
9 | plgSystemJComments->onAfterRoute() | Même appel que celui de la ligne ci-dessous. |
8 | call_user_func_array() | 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:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.49 ms Après la dernière requête : 48.52 ms
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM rbywh_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 4 | Using where; Utilisation du tri complet de type filesort |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736 |
11 | PhocaGalleryRenderFront::renderAllCSS() | JROOT/components/com_phocagallery/views/categories/view.html.php:42 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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 : 3.20 ms Après la dernière requête : 5.64 ms
SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.exth) as exth, min(a.extw) as extw,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM rbywh_phocagallery_categories AS cc
LEFT JOIN rbywh_phocagallery AS a
ON a.catid = cc.id
and a.published = 1
LEFT JOIN rbywh_phocagallery_user AS uc
ON uc.userid = cc.owner_id
LEFT JOIN rbywh_users AS u
ON u.id = cc.owner_id
LEFT JOIN rbywh_phocagallery_votes_statistics AS r
ON r.catid = cc.id
WHERE cc.published = 1
AND cc.approved = 1
AND cc.parent_id = 0
GROUP BY cc.id, cc.parent_id, cc.owner_id, cc.image_id, cc.title, cc.name, cc.alias, cc.image, cc.section, cc.image_position, cc.description, cc.date, cc.published, cc.approved, cc.checked_out, cc.checked_out_time, cc.editor, cc.ordering, cc.access, cc.count, cc.hits, cc.accessuserid, cc.deleteuserid, cc.uploaduserid, cc.userfolder, cc.latitude, cc.longitude, cc.zoom, cc.geotitle, cc.extid, cc.exta, cc.extu, cc.extauth, cc.extfbuid, cc.extfbcatid, cc.params, cc.metakey, cc.metadesc, cc.metadata, cc.language, a.catid, u.username, r.count, r.average, uc.avatar, uc.approved, uc.published
ORDER BY cc.id DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | uc | system | userid | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | Const row not found; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | r | system | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | Const row not found |
1 | SIMPLE | cc | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 268 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | gouesnou_joom976.cc.owner_id | 1 | |
1 | SIMPLE | a | ref | catid | catid | 5 | gouesnou_joom976.cc.id,const | 28 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_phocagallery/models/categories.php:49 |
12 | PhocagalleryModelCategories->getData() | JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425 |
11 | Joomla\CMS\MVC\View\_JHtmlView->get() | JROOT/components/com_phocagallery/views/categories/view.html.php:209 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.69 ms Après la dernière requête : 3.61 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 276
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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 : 0.12 ms
SELECT a.id, a.extid
FROM rbywh_phocagallery_categories AS a
WHERE a.parent_id = 276
AND a.published = 1
AND a.access IN(1,1,5)
ORDER BY RAND()
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | idx_access | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 268 | Using where; Using temporary; Utilisation du tri complet de type filesort |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:554 |
12 | PhocaGalleryImageFront::getRandomCategory() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:499 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.78 ms Après la dernière requête : 0.12 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 278
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 7 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.67 ms Après la dernière requête : 0.15 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 280
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.64 ms Après la dernière requête : 0.17 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 277
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.66 ms Après la dernière requête : 0.14 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 279
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.16 ms Après la dernière requête : 1.67 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 269
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 74 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.71 ms Après la dernière requête : 0.44 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 265
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 4 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.63 ms Après la dernière requête : 0.43 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 260
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.64 ms Après la dernière requête : 0.12 ms
SELECT a.id, a.extid
FROM rbywh_phocagallery_categories AS a
WHERE a.parent_id = 260
AND a.published = 1
AND a.access IN(1,1,5)
ORDER BY RAND()
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | idx_access | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 268 | Using where; Using temporary; Utilisation du tri complet de type filesort |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:554 |
12 | PhocaGalleryImageFront::getRandomCategory() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:499 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.87 ms Après la dernière requête : 0.14 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 264
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 28 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.74 ms Après la dernière requête : 0.16 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 261
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 5 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.74 ms Après la dernière requête : 0.15 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 262
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 6 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.23 ms Après la dernière requête : 0.16 ms
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM rbywh_phocagallery AS a
LEFT JOIN rbywh_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 263
AND a.published = 1
AND a.approved = 1
ORDER BY RAND()
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 84 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
12 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:503 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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.62 ms Après la dernière requête : 0.44 ms