وقت الإستعلام: 0.51 ms إستعلام الذاكرة: 0.007 MB الذاكرة بعد الإستعلام: 4.132 MB إرجاع الصفوف: 0
SELECT `data`
FROM `f9r73_session`
WHERE `session_id` = X'3766373337313932653464336365646234643863646566656632633662663634'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | نفس الاستدعاء في خط أدناه. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
وقت الإستعلام: 0.34 ms قبل آخر إستعلام: 0.84 ms إستعلام الذاكرة: 0.004 MB الذاكرة بعد الإستعلام: 4.227 MB إرجاع الصفوف: 0
SELECT `session_id`
FROM `f9r73_session`
WHERE `session_id` = X'3766373337313932653464336365646234643863646566656632633662663634'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
9 | JDatabaseDriverMysqli->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 |
وقت الإستعلام: 0.89 ms قبل آخر إستعلام: 0.06 ms إستعلام الذاكرة: 0.004 MB الذاكرة بعد الإستعلام: 4.232 MB
INSERT INTO `f9r73_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3766373337313932653464336365646234643863646566656632633662663634', 1, 1732296632, 0, '', 0)
التوضيح غير ممكن للإستعلام: INSERT INTO `f9r73_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3766373337313932653464336365646234643863646566656632633662663634', 1, 1732296632, 0, '', 0)
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
update | 0.18 ms |
end | 0.01 ms |
query end | 0.41 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
وقت الإستعلام: 0.51 ms قبل آخر إستعلام: 4.05 ms إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 4.801 MB إرجاع الصفوف: 6
SELECT id, rules
FROM `f9r73_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_viewlevels | NULL | ALL | NULL | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 6 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.11 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.62 ms قبل آخر إستعلام: 0.06 ms إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 4.814 MB إرجاع الصفوف: 1
SELECT b.id
FROM f9r73_usergroups AS a
LEFT JOIN f9r73_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 1.17 ms قبل آخر إستعلام: 44.03 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 11.400 MB
UPDATE `f9r73_extensions`
SET `params` = '{\"mediaversion\":\"2dfc82f5366834aacfab656b5f3a3889\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | f9r73_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.03 ms |
System lock | 0.20 ms |
updating | 0.16 ms |
end | 0.01 ms |
query end | 0.35 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/gzip/gzip.php:554 |
8 | PlgSystemGzip->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 |
وقت الإستعلام: 1.81 ms قبل آخر إستعلام: 11.58 ms إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 13.032 MB إرجاع الصفوف: 204
الإستعلامات المتكررة:
#38SHOW TABLES
التوضيح غير ممكن للإستعلام: SHOW TABLES
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
checking permissions | 1.16 ms |
Sending data | 0.14 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:244 |
8 | plgSystemjdownloads->onAfterRoute() | 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 |
وقت الإستعلام: 2.90 ms قبل آخر إستعلام: 6.89 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 14.294 MB إرجاع الصفوف: 47
SELECT `id`,`name`,`rules`,`parent_id`
FROM `f9r73_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_cmssecurity','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jchoptimize','com_jdownloads','com_joomgallery','com_joomlaupdate','com_jsecure','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sexypolling','com_slideshowck','com_tags','com_templates','com_users','com_visforms','com_weblinks','com_widgetkit','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_assets | NULL | ALL | idx_asset_name | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 440 | 10.91 | Using where |
Status | Duration |
---|
starting | 0.20 ms |
checking permissions | 0.01 ms |
Opening tables | 0.09 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.31 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.96 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
20 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
19 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
18 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
17 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
16 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/articles.php:115 |
15 | ContentModelArticles->populateState() | JROOT/components/com_content/models/featured.php:45 |
14 | ContentModelFeatured->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 3.50 ms قبل آخر إستعلام: 1.03 ms إستعلام الذاكرة: 0.009 MB الذاكرة بعد الإستعلام: 14.510 MB إرجاع الصفوف: 1
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM f9r73_content AS a
LEFT JOIN f9r73_categories AS c
ON c.id = a.catid
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_by
LEFT JOIN f9r73_users AS uam
ON uam.id = a.modified_by
LEFT JOIN f9r73_categories as parent
ON parent.id = c.parent_id
LEFT JOIN f9r73_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-22 17:30:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 17:30:32')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 3, 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid,idx_featured_catid | idx_featured_catid | 1 | const | 13 | 16.00 | Using where; Using temporary; استعمال ترتيب الملفات |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | hanibale_prey.a.catid | 1 | 10.00 | Using where |
1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.c.parent_id | 1 | 100.00 | Using where |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.37 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.27 ms |
init | 0.15 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.30 ms |
preparing | 0.05 ms |
Creating tmp table | 0.11 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 1.72 ms |
Creating sort index | 0.15 ms |
end | 0.01 ms |
query end | 0.02 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.12 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 |
13 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 0.80 ms قبل آخر إستعلام: 1.12 ms إستعلام الذاكرة: 0.008 MB الذاكرة بعد الإستعلام: 14.683 MB إرجاع الصفوف: 0
SELECT `m`.`tag_id`,`t`.*
FROM `f9r73_contentitem_tag_map` AS m
INNER JOIN `f9r73_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 60
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hanibale_prey.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 |
13 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 0.94 ms قبل آخر إستعلام: 0.73 ms إستعلام الذاكرة: 0.008 MB الذاكرة بعد الإستعلام: 14.765 MB إرجاع الصفوف: 1
SELECT COUNT(*)
FROM f9r73_content AS a
LEFT JOIN f9r73_categories AS c
ON c.id = a.catid
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_by
LEFT JOIN f9r73_users AS uam
ON uam.id = a.modified_by
LEFT JOIN f9r73_categories as parent
ON parent.id = c.parent_id
LEFT JOIN f9r73_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-22 17:30:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 17:30:32')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid,idx_featured_catid | idx_featured_catid | 1 | const | 13 | 16.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.created_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | hanibale_prey.a.catid | 1 | 10.00 | Using where |
1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.c.parent_id | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.25 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 |
15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
14 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
13 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:57 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 0.98 ms قبل آخر إستعلام: 8.70 ms إستعلام الذاكرة: 0.008 MB الذاكرة بعد الإستعلام: 15.906 MB إرجاع الصفوف: 2
SELECT id, link
from f9r73_menu
WHERE link LIKE 'index.php?option=com_jdownloads&view=category%'
AND published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_menu | NULL | ALL | NULL | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 188 | 1.11 | Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.54 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
15 | JDatabaseDriver->loadAssocList() | JROOT/plugins/content/jdownloads/jdownloads.php:57 |
14 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:251 |
13 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
12 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_content/views/featured/view.html.php:78 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 0.69 ms قبل آخر إستعلام: 0.04 ms إستعلام الذاكرة: 0.009 MB الذاكرة بعد الإستعلام: 15.915 MB إرجاع الصفوف: 2
SELECT id, link
from f9r73_menu
WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%'
AND published = 1
AND access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_menu | NULL | ALL | NULL | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 188 | 0.53 | Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
16 | JDatabaseDriver->loadAssocList() | JROOT/components/com_jdownloads/helpers/jdownloads.php:441 |
15 | JDHelper::getAllJDCategoryMenuIDs() | JROOT/plugins/content/jdownloads/jdownloads.php:70 |
14 | require_once JROOT/plugins/content/jdownloads/jdownloads.php | JROOT/libraries/src/Plugin/PluginHelper.php:251 |
13 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
12 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_content/views/featured/view.html.php:78 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 1.18 ms قبل آخر إستعلام: 6.63 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 16.580 MB إرجاع الصفوف: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `f9r73_categories` AS `s`
INNER JOIN `f9r73_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 21
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | استعمال ترتيب الملفات |
1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 18 | 77.14 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.23 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.21 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.33 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.11 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
14 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:102 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 1.55 ms قبل آخر إستعلام: 0.35 ms إستعلام الذاكرة: 0.009 MB الذاكرة بعد الإستعلام: 16.638 MB إرجاع الصفوف: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM f9r73_fields AS a
LEFT JOIN `f9r73_languages` AS l
ON l.lang_code = a.language
LEFT JOIN f9r73_users AS uc
ON uc.id=a.checked_out
LEFT JOIN f9r73_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN f9r73_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `f9r73_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (21,0,18))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; استعمال ترتيب الملفات |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | hanibale_prey.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.23 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.10 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.26 ms |
preparing | 0.05 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.26 ms |
Creating sort index | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
14 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
12 | JEventDispatcher->trigger() | JROOT/components/com_content/views/featured/view.html.php:102 |
11 | ContentViewFeatured->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |
وقت الإستعلام: 0.52 ms قبل آخر إستعلام: 10.59 ms إستعلام الذاكرة: 0.007 MB الذاكرة بعد الإستعلام: 17.513 MB إرجاع الصفوف: 1
SELECT params
FROM f9r73_extensions AS e
WHERE e.element='com_widgetkit'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.09 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_widgetkit/helpers/system.php:278 |
13 | SystemWidgetkitHelper->_getParams() | JROOT/administrator/components/com_widgetkit/helpers/system.php:54 |
12 | SystemWidgetkitHelper->__construct() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 |
11 | Widgetkit->loadHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 |
10 | Widgetkit->getHelper() | JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 |
9 | Widgetkit->offsetGet() | JROOT/administrator/components/com_widgetkit/widgetkit.php:17 |
8 | require_once JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 |
7 | plgSystemWidgetkit_System->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
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 |
وقت الإستعلام: 0.55 ms قبل آخر إستعلام: 0.22 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 17.602 MB إرجاع الصفوف: 1
SELECT id,template
FROM f9r73_template_styles
WHERE client_id=0
AND home=1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_template_styles | NULL | ALL | idx_client_id,idx_client_id_home | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 9 | 11.11 | Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
10 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_widgetkit/helpers/system.php:78 |
9 | SystemWidgetkitHelper->init() | JROOT/administrator/components/com_widgetkit/widgetkit.php:17 |
8 | require_once JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 |
7 | plgSystemWidgetkit_System->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
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 |
وقت الإستعلام: 2.30 ms قبل آخر إستعلام: 9.96 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 18.635 MB إرجاع الصفوف: 20
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM f9r73_modules AS m
LEFT JOIN f9r73_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN f9r73_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-22 17:30:32')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-22 17:30:32')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 6 | NULL | 27 | 1.60 | Using index condition; Using where; استعمال ترتيب الملفات |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | hanibale_prey.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | hanibale_prey.m.id | 4 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.25 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.17 ms |
preparing | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 1.28 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.11 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | نفس الاستدعاء في خط أدناه. |
17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
15 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
14 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
13 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
12 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 |
11 | Warp\Joomla\Helper\WidgetsHelper->count() | JROOT/templates/yoo_everest/layouts/theme.config.php:26 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 5.95 ms قبل آخر إستعلام: 71.85 ms إستعلام الذاكرة: 0.014 MB الذاكرة بعد الإستعلام: 19.829 MB إرجاع الصفوف: 296
SHOW FULL COLUMNS
FROM `f9r73_joomgallery_config`
التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `f9r73_joomgallery_config`
Status | Duration |
---|
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.95 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.06 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
27 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
26 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
25 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:334 |
24 | TableJoomgalleryConfig->__construct() | JROOT/libraries/src/Table/Table.php:328 |
23 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_joomgallery/helpers/config.php:374 |
22 | JoomConfig->__construct() | JROOT/administrator/components/com_joomgallery/helpers/config.php:437 |
21 | JoomConfig::getInstance() | JROOT/components/com_joomgallery/helpers/ambit.php:147 |
20 | JoomAmbit->__construct() | JROOT/components/com_joomgallery/helpers/ambit.php:220 |
19 | JoomAmbit::getInstance() | JROOT/components/com_joomgallery/interface.php:102 |
18 | JoomInterface->__construct() | JROOT/modules/mod_joomimg/mod_joomimg.php:43 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 1.21 ms قبل آخر إستعلام: 1.38 ms إستعلام الذاكرة: 0.012 MB الذاكرة بعد الإستعلام: 20.289 MB إرجاع الصفوف: 1
SELECT *
FROM f9r73_joomgallery_config
WHERE `id` = '1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_joomgallery_config | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.17 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.31 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
24 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
23 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_joomgallery/helpers/config.php:375 |
22 | JoomConfig->__construct() | JROOT/administrator/components/com_joomgallery/helpers/config.php:437 |
21 | JoomConfig::getInstance() | JROOT/components/com_joomgallery/helpers/ambit.php:147 |
20 | JoomAmbit->__construct() | JROOT/components/com_joomgallery/helpers/ambit.php:220 |
19 | JoomAmbit::getInstance() | JROOT/components/com_joomgallery/interface.php:102 |
18 | JoomInterface->__construct() | JROOT/modules/mod_joomimg/mod_joomimg.php:43 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.88 ms قبل آخر إستعلام: 5.84 ms إستعلام الذاكرة: 0.011 MB الذاكرة بعد الإستعلام: 20.591 MB إرجاع الصفوف: 3
SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
FROM f9r73_joomgallery_catg AS c
WHERE lft > 0
AND c.published = 1
AND c.access IN (1,1)
AND (c.password = '' OR c.cid IN (0))
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ALL | PRIMARY | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 5 | 20.00 | Using where; استعمال ترتيب الملفات |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.01 ms |
Opening tables | 0.25 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.14 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_joomgallery/helpers/ambit.php:492 |
20 | JoomAmbit->getCategoryStructure() | JROOT/modules/mod_joomimg/helper.php:440 |
19 | modJoomImagesHelper->getDBImages() | JROOT/modules/mod_joomimg/helper.php:47 |
18 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:52 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.81 ms قبل آخر إستعلام: 0.09 ms إستعلام الذاكرة: 0.011 MB الذاكرة بعد الإستعلام: 20.606 MB إرجاع الصفوف: 3
SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
FROM f9r73_joomgallery
WHERE approved = 1
AND published = 1
AND hidden = 0
AND access IN (1,1)
GROUP BY catid
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_joomgallery | NULL | index | idx_catid | idx_catid | 4 | NULL | 12 | 8.33 | Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.26 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.15 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_joomgallery/helpers/ambit.php:508 |
20 | JoomAmbit->getCategoryStructure() | JROOT/modules/mod_joomimg/helper.php:440 |
19 | modJoomImagesHelper->getDBImages() | JROOT/modules/mod_joomimg/helper.php:47 |
18 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:52 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 1.05 ms قبل آخر إستعلام: 0.09 ms إستعلام الذاكرة: 0.011 MB الذاكرة بعد الإستعلام: 20.617 MB إرجاع الصفوف: 12
SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,p.imgdate as imgdate,c.cid AS ccid, c.catpath AS catpath
FROM f9r73_joomgallery AS p
LEFT JOIN f9r73_joomgallery_catg AS c
ON c.cid = p.catid
WHERE c.published = 1
AND c.access IN (1,1)
AND p.published = 1
AND p.approved = 1
AND p.access IN (1,1)
AND p.catid IN (4,3,2)
AND c.hidden = 0
AND c.in_hidden = 0
AND p.hidden = 0
ORDER BY rand()
LIMIT 12
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | p | NULL | ALL | idx_catid | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 12 | 8.33 | Using where; Using temporary; استعمال ترتيب الملفات |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.p.catid | 1 | 20.00 | Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.27 ms |
Creating sort index | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_joomimg/helper.php:518 |
19 | modJoomImagesHelper->getDBImages() | JROOT/modules/mod_joomimg/helper.php:47 |
18 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:52 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 1.35 ms قبل آخر إستعلام: 0.20 ms إستعلام الذاكرة: 0.012 MB الذاكرة بعد الإستعلام: 20.644 MB إرجاع الصفوف: 1
SELECT id
FROM f9r73_menu
WHERE link LIKE '%com_joomgallery%view=gallery%'
AND access IN (1,1)
AND published = 1
AND client_id = 0
AND (language = 'ar-AA' OR language = '' OR language = '*')
ORDER BY id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_menu | NULL | ref | idx_client_id_parent_id_alias_language,idx_language | idx_client_id_parent_id_alias_language | 1 | const | 110 | 0.53 | Using index condition; Using where; استعمال ترتيب الملفات |
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.16 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.76 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
23 | JDatabaseDriver->loadResult() | JROOT/components/com_joomgallery/helpers/ambit.php:426 |
22 | JoomAmbit->getItemid() | JROOT/components/com_joomgallery/interface.php:304 |
21 | JoomInterface->getJoomId() | JROOT/components/com_joomgallery/interface.php:370 |
20 | JoomInterface->getImageLink() | JROOT/modules/mod_joomimg/helper.php:789 |
19 | modJoomImagesHelper->modContent() | JROOT/modules/mod_joomimg/helper.php:100 |
18 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:52 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.38 ms قبل آخر إستعلام: 4.89 ms إستعلام الذاكرة: 0.013 MB الذاكرة بعد الإستعلام: 20.979 MB إرجاع الصفوف: 1
SELECT catpath
FROM f9r73_joomgallery_catg
WHERE cid = 2
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_joomgallery_catg | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
27 | JDatabaseDriver->loadResult() | JROOT/components/com_joomgallery/helpers/helper.php:141 |
26 | JoomHelper::getCatPath() | JROOT/components/com_joomgallery/helpers/ambit.php:338 |
25 | JoomAmbit->getImg() | JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573 |
24 | JHtmlJoomGallery::openImage() | نفس الاستدعاء في خط أدناه. |
23 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
22 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
21 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_joomgallery/interface.php:372 |
20 | JoomInterface->getImageLink() | JROOT/modules/mod_joomimg/helper.php:789 |
19 | modJoomImagesHelper->modContent() | JROOT/modules/mod_joomimg/helper.php:100 |
18 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:52 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.44 ms قبل آخر إستعلام: 3.77 ms إستعلام الذاكرة: 0.013 MB الذاكرة بعد الإستعلام: 21.132 MB إرجاع الصفوف: 1
SELECT catpath
FROM f9r73_joomgallery_catg
WHERE cid = 4
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_joomgallery_catg | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
27 | JDatabaseDriver->loadResult() | JROOT/components/com_joomgallery/helpers/helper.php:141 |
26 | JoomHelper::getCatPath() | JROOT/components/com_joomgallery/helpers/ambit.php:338 |
25 | JoomAmbit->getImg() | JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573 |
24 | JHtmlJoomGallery::openImage() | نفس الاستدعاء في خط أدناه. |
23 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
22 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
21 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_joomgallery/interface.php:372 |
20 | JoomInterface->getImageLink() | JROOT/modules/mod_joomimg/helper.php:789 |
19 | modJoomImagesHelper->modContent() | JROOT/modules/mod_joomimg/helper.php:100 |
18 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:52 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.34 ms قبل آخر إستعلام: 5.01 ms إستعلام الذاكرة: 0.013 MB الذاكرة بعد الإستعلام: 21.167 MB إرجاع الصفوف: 1
SELECT catpath
FROM f9r73_joomgallery_catg
WHERE cid = 3
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_joomgallery_catg | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
27 | JDatabaseDriver->loadResult() | JROOT/components/com_joomgallery/helpers/helper.php:141 |
26 | JoomHelper::getCatPath() | JROOT/components/com_joomgallery/helpers/ambit.php:338 |
25 | JoomAmbit->getImg() | JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573 |
24 | JHtmlJoomGallery::openImage() | نفس الاستدعاء في خط أدناه. |
23 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
22 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
21 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_joomgallery/interface.php:372 |
20 | JoomInterface->getImageLink() | JROOT/modules/mod_joomimg/helper.php:789 |
19 | modJoomImagesHelper->modContent() | JROOT/modules/mod_joomimg/helper.php:100 |
18 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:52 |
17 | include JROOT/modules/mod_joomimg/mod_joomimg.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 2.03 ms قبل آخر إستعلام: 19.87 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 21.299 MB إرجاع الصفوف: 0
SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name
FROM `f9r73_sexy_polls` sp JOIN `f9r73_sexy_answers` sa
ON sa.id_poll = sp.id
AND sa.published = '1'
LEFT JOIN `f9r73_sexy_templates` st
ON st.id = sp.id_template
WHERE sp.published = '1'
AND sp.id_category = 1
ORDER BY sp.ordering,sp.name,sa.ordering,sa.name
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | sp | NULL | ref | PRIMARY,id_category | id_category | 3 | const | 1 | 50.00 | Using where; Using temporary; استعمال ترتيب الملفات |
1 | SIMPLE | sa | NULL | ref | id_poll | id_poll | 4 | hanibale_prey.sp.id | 3 | 11.11 | Using where |
1 | SIMPLE | st | NULL | eq_ref | PRIMARY | PRIMARY | 3 | hanibale_prey.sp.id_template | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.29 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.65 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sexypolling/helpers/helper.php:136 |
16 | SexypollingHelper->get_data() | JROOT/components/com_sexypolling/helpers/helper.php:168 |
15 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
14 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
13 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 1.07 ms قبل آخر إستعلام: 53.59 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 21.383 MB إرجاع الصفوف: 0
SELECT id
from f9r73_menu
WHERE link = 'index.php?option=com_jdownloads&view=categories'
and published = 1
AND client_id = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 110 | 1.00 | Using where |
Status | Duration |
---|
starting | 0.19 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.45 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
18 | JDatabaseDriver->loadResult() | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:31 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 30.47 ms قبل آخر إستعلام: 1.90 ms إستعلام الذاكرة: 0.011 MB الذاكرة بعد الإستعلام: 21.528 MB إرجاع الصفوف: 4
SELECT a.id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.created, a.file_date, a.publish_up, a.publish_down, a.use_timeframe, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_by, a.created_mail, a.modified_by, a.modified, a.submitted_by, a.set_aup_points, a.downloads, a.catid, a.changelog, a.password, a.password_md5, a.views, a.metakey, a.metadesc, a.robots, a.update_active, a.access, a.user_access, a.language, a.ordering, a.featured, a.published, a.checked_out, a.checked_out_time, a.modified, a.modified_by,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.metakey, a.metadesc, a.access, a.downloads, LENGTH(a.description_long) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,aa.url_download AS filename_from_other_download,c.title AS category_title, c.access AS category_access, c.alias AS category_alias, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent,u.username AS creator,u2.username AS modifier,u3.username AS user_access_name,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias,menuf.id AS menuf_itemid,menuc.id AS menuc_cat_itemid,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM f9r73_jdownloads_files AS a
LEFT JOIN f9r73_jdownloads_files AS aa
on aa.id = a.other_file_id
LEFT JOIN f9r73_jdownloads_categories AS c
ON c.id = a.catid
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_by
LEFT JOIN f9r73_users AS uam
ON uam.id = a.modified_by
LEFT JOIN f9r73_users AS u
on u.id = a.created_by
LEFT JOIN f9r73_users AS u2
on u2.id = a.modified_by
LEFT JOIN f9r73_users AS u3
on u3.id = a.user_access
LEFT JOIN f9r73_jdownloads_licenses AS l
on l.id = a.license
LEFT JOIN f9r73_jdownloads_ratings AS r
on r.file_id = a.id
LEFT JOIN f9r73_jdownloads_categories as parent
ON parent.id = c.parent_id
LEFT JOIN (SELECT id, link, access, published
from f9r73_menu
GROUP BY link) AS menuf
on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.id)
AND menuf.published = 1
AND menuf.access IN (1,1)
LEFT JOIN (SELECT id, link, access, published
from f9r73_menu
GROUP BY link) AS menuc
on menuc.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',a.catid)
AND menuc.published = 1
AND menuc.access IN (1,1)
LEFT
OUTER JOIN (SELECT cat.id as id
FROM f9r73_jdownloads_categories AS cat JOIN f9r73_jdownloads_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-22 17:30:32')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-22 17:30:32')
ORDER BY a.created DESC
LIMIT 4
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | a | NULL | ALL | idx_cat_id,idx_access | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 31 | 16.00 | Using where; Using temporary; استعمال ترتيب الملفات |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.created_by | 1 | 100.00 | Using index |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.modified_by | 1 | 100.00 | Using index |
1 | PRIMARY | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.created_by | 1 | 100.00 | NULL |
1 | PRIMARY | u2 | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.modified_by | 1 | 100.00 | NULL |
1 | PRIMARY | u3 | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.user_access | 1 | 100.00 | Using where |
1 | PRIMARY | l | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.license | 1 | 100.00 | Using where |
1 | PRIMARY | r | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.id | 1 | 100.00 | NULL |
1 | PRIMARY | aa | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.a.other_file_id | 1 | 100.00 | NULL |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | hanibale_prey.a.catid | 1 | 100.00 | Using where |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | hanibale_prey.c.parent_id | 1 | 100.00 | Using where |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 188 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | PRIMARY | <derived3> | NULL | ALL | NULL | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 188 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | PRIMARY | <derived4> | NULL | ref | <auto_key0> | <auto_key0> | 4 | hanibale_prey.a.catid | 10 | 100.00 | Using where; Using index |
4 | DERIVED | parent | NULL | ALL | idx_left_right,idx_published | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 49 | 77.55 | Using where; Using temporary; استعمال ترتيب الملفات |
4 | DERIVED | cat | NULL | index | PRIMARY,idx_access,idx_checked_out,idx_left_right,idx_language,idx_alias,idx_published | idx_left_right | 8 | NULL | 49 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
3 | DERIVED | f9r73_menu | NULL | ALL | NULL | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 188 | 100.00 | Using temporary; استعمال ترتيب الملفات |
2 | DERIVED | f9r73_menu | NULL | ALL | NULL | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 188 | 100.00 | Using temporary; استعمال ترتيب الملفات |
Status | Duration |
---|
starting | 0.53 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 2.23 ms |
init | 0.37 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.05 ms |
statistics | 0.26 ms |
preparing | 0.08 ms |
Creating tmp table | 0.11 ms |
Sorting result | 0.01 ms |
executing | 0.02 ms |
Sending data | 0.34 ms |
executing | 0.01 ms |
Sending data | 0.81 ms |
Creating sort index | 11.06 ms |
executing | 0.01 ms |
Sending data | 0.70 ms |
Creating sort index | 9.48 ms |
executing | 0.01 ms |
Sending data | 0.29 ms |
Creating sort index | 3.15 ms |
Creating sort index | 0.16 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.03 ms |
query end | 0.01 ms |
removing tmp table | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.00 ms |
closing tables | 0.03 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_jdownloads/models/downloads.php:605 |
19 | jdownloadsModelDownloads->getItems() | JROOT/modules/mod_jdownloads_latest/helper.php:63 |
18 | ModJDownloadsLatestHelper::getList() | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:98 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.78 ms قبل آخر إستعلام: 0.84 ms إستعلام الذاكرة: 0.013 MB الذاكرة بعد الإستعلام: 21.617 MB إرجاع الصفوف: 82
SELECT `id`,`name`,`rules`,`parent_id`
FROM `f9r73_assets`
WHERE `name` LIKE 'com_jdownloads.%' OR `name` = 'com_jdownloads' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_assets | NULL | ALL | idx_asset_name,idx_parent_id | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 440 | 21.74 | Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.36 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.00 ms |
# | المتصل | الملف ورقم السطر |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
24 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
23 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
22 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
21 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
20 | Joomla\CMS\User\User->authorise() | JROOT/components/com_jdownloads/models/downloads.php:645 |
19 | jdownloadsModelDownloads->getItems() | JROOT/modules/mod_jdownloads_latest/helper.php:63 |
18 | ModJDownloadsLatestHelper::getList() | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:98 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.34 ms قبل آخر إستعلام: 0.89 ms إستعلام الذاكرة: 0.011 MB الذاكرة بعد الإستعلام: 21.729 MB إرجاع الصفوف: 0
SELECT `m`.`tag_id`,`t`.*
FROM `f9r73_contentitem_tag_map` AS m
INNER JOIN `f9r73_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_jdownloads.download'
AND `m`.`content_item_id` = 56
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hanibale_prey.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.00 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
20 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_jdownloads/models/downloads.php:667 |
19 | jdownloadsModelDownloads->getItems() | JROOT/modules/mod_jdownloads_latest/helper.php:63 |
18 | ModJDownloadsLatestHelper::getList() | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:98 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.30 ms قبل آخر إستعلام: 0.75 ms إستعلام الذاكرة: 0.012 MB الذاكرة بعد الإستعلام: 21.777 MB إرجاع الصفوف: 0
SELECT `m`.`tag_id`,`t`.*
FROM `f9r73_contentitem_tag_map` AS m
INNER JOIN `f9r73_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_jdownloads.download'
AND `m`.`content_item_id` = 55
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hanibale_prey.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.00 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
20 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_jdownloads/models/downloads.php:667 |
19 | jdownloadsModelDownloads->getItems() | JROOT/modules/mod_jdownloads_latest/helper.php:63 |
18 | ModJDownloadsLatestHelper::getList() | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:98 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.28 ms قبل آخر إستعلام: 0.55 ms إستعلام الذاكرة: 0.011 MB الذاكرة بعد الإستعلام: 21.810 MB إرجاع الصفوف: 0
SELECT `m`.`tag_id`,`t`.*
FROM `f9r73_contentitem_tag_map` AS m
INNER JOIN `f9r73_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_jdownloads.download'
AND `m`.`content_item_id` = 54
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hanibale_prey.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.04 ms |
cleaning up | 0.00 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
20 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_jdownloads/models/downloads.php:667 |
19 | jdownloadsModelDownloads->getItems() | JROOT/modules/mod_jdownloads_latest/helper.php:63 |
18 | ModJDownloadsLatestHelper::getList() | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:98 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.28 ms قبل آخر إستعلام: 0.72 ms إستعلام الذاكرة: 0.011 MB الذاكرة بعد الإستعلام: 21.849 MB إرجاع الصفوف: 0
SELECT `m`.`tag_id`,`t`.*
FROM `f9r73_contentitem_tag_map` AS m
INNER JOIN `f9r73_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_jdownloads.download'
AND `m`.`content_item_id` = 53
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | لا يوجد مفتاح رئيسي يمكن استخدامه | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | hanibale_prey.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
cleaning up | 0.00 ms |
# | المتصل | الملف ورقم السطر |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
20 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_jdownloads/models/downloads.php:667 |
19 | jdownloadsModelDownloads->getItems() | JROOT/modules/mod_jdownloads_latest/helper.php:63 |
18 | ModJDownloadsLatestHelper::getList() | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:98 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.47 ms قبل آخر إستعلام: 2.13 ms إستعلام الذاكرة: 0.014 MB الذاكرة بعد الإستعلام: 21.879 MB إرجاع الصفوف: 1
SELECT alias
FROM f9r73_jdownloads_categories
WHERE id=5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_jdownloads_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.10 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
27 | JDatabaseDriver->loadResult() | JROOT/components/com_jdownloads/helpers/legacyrouter.php:146 |
26 | JdownloadsRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
25 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
24 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
23 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
22 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
21 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
20 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
19 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_jdownloads_latest/tmpl/default.php:81 |
18 | require JROOT/modules/mod_jdownloads_latest/tmpl/default.php | JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php:106 |
17 | include JROOT/modules/mod_jdownloads_latest/mod_jdownloads_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | نفس الاستدعاء في خط أدناه. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
13 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
12 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
11 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/layouts/theme.config.php:72 |
10 | include JROOT/templates/yoo_everest/layouts/theme.config.php | JROOT/templates/yoo_everest/layouts/theme.php:10 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 1.07 ms قبل آخر إستعلام: 108.16 ms إستعلام الذاكرة: 0.010 MB الذاكرة بعد الإستعلام: 22.596 MB إرجاع الصفوف: 298
SELECT guest, client_id
FROM f9r73_session
WHERE client_id = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | f9r73_session | NULL | ref | client_id_guest | client_id_guest | 2 | const | 298 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.46 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.10 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_whosonline/helper.php:45 |
17 | ModWhosonlineHelper::getOnlineCount() | JROOT/modules/mod_whosonline/mod_whosonline.php:19 |
16 | include JROOT/modules/mod_whosonline/mod_whosonline.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
13 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10 |
12 | include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
11 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69 |
10 | Warp\Joomla\Helper\WidgetsHelper->render() | JROOT/templates/yoo_everest/layouts/theme.php:112 |
9 | include JROOT/templates/yoo_everest/layouts/theme.php | JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/yoo_everest/index.php:16 |
7 | require JROOT/templates/yoo_everest/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 1.38 ms قبل آخر إستعلام: 10.40 ms إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 22.840 MB إرجاع الصفوف: 204
SHOW TABLES
التوضيح غير ممكن للإستعلام: SHOW TABLES
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
checking permissions | 0.91 ms |
Sending data | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | المتصل | الملف ورقم السطر |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
9 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
8 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:140 |
7 | plgSystemjdownloads->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
وقت الإستعلام: 0.73 ms قبل آخر إستعلام: 0.65 ms إستعلام الذاكرة: 0.008 MB الذاكرة بعد الإستعلام: 22.855 MB إرجاع الصفوف: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `f9r73_categories` AS `s`
INNER JOIN `f9r73_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_weblinks' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 15
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | استعمال ترتيب الملفات |
1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | cat_idx | 208 | NULL | 4 | 42.86 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.20 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.10 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.00 ms |
# | المتصل | الملف ورقم السطر |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
16 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
15 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_weblinks/router.php:92 |
14 | WeblinksRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:532 |
13 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:502 |
12 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
7 | PlgSystemSef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
5 × SELECT `m`.`tag_id`,`t`.*
FROM `f9r73_contentitem_tag_map` AS m
INNER JOIN `f9r73_tags` AS t
ON `m`.`tag_id` = `t`.`id`
3 × SELECT catpath
FROM f9r73_joomgallery_catg
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `f9r73_assets`
2 × SELECT id, link
from f9r73_menu
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `f9r73_categories` AS `s`
INNER JOIN `f9r73_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
1 × SELECT `data`
FROM `f9r73_session`
1 × SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
FROM f9r73_joomgallery_catg AS c
1 × SELECT alias
FROM f9r73_jdownloads_categories
1 × SELECT a.id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.created, a.file_date, a.publish_up, a.publish_down, a.use_timeframe, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_by, a.created_mail, a.modified_by, a.modified, a.submitted_by, a.set_aup_points, a.downloads, a.catid, a.changelog, a.password, a.password_md5, a.views, a.metakey, a.metadesc, a.robots, a.update_active, a.access, a.user_access, a.language, a.ordering, a.featured, a.published, a.checked_out, a.checked_out_time, a.modified, a.modified_by,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.metakey, a.metadesc, a.access, a.downloads, LENGTH(a.description_long) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,aa.url_download AS filename_from_other_download,c.title AS category_title, c.access AS category_access, c.alias AS category_alias, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent,u.username AS creator,u2.username AS modifier,u3.username AS user_access_name,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias,menuf.id AS menuf_itemid,menuc.id AS menuc_cat_itemid,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM f9r73_jdownloads_files AS a
LEFT JOIN f9r73_jdownloads_files AS aa
on aa.id = a.other_file_id
LEFT JOIN f9r73_jdownloads_categories AS c
ON c.id = a.catid
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_by
LEFT JOIN f9r73_users AS uam
ON uam.id = a.modified_by
LEFT JOIN f9r73_users AS u
on u.id = a.created_by
LEFT JOIN f9r73_users AS u2
on u2.id = a.modified_by
LEFT JOIN f9r73_users AS u3
on u3.id = a.user_access
LEFT JOIN f9r73_jdownloads_licenses AS l
on l.id = a.license
LEFT JOIN f9r73_jdownloads_ratings AS r
on r.file_id = a.id
LEFT JOIN f9r73_jdownloads_categories as parent
ON parent.id = c.parent_id
LEFT JOIN (SELECT id, link, access, published
from f9r73_menu
GROUP BY link) AS menuf
on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.id)
AND menuf.published = 1
AND menuf.access IN (1,1)
LEFT JOIN (SELECT id, link, access, published
from f9r73_menu
GROUP BY link) AS menuc
on menuc.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',a.catid)
AND menuc.published = 1
AND menuc.access IN (1,1)
LEFT
OUTER JOIN (SELECT cat.id as id
FROM f9r73_jdownloads_categories AS cat JOIN f9r73_jdownloads_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
1 × SELECT id
from f9r73_menu
1 × SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name
FROM `f9r73_sexy_polls` sp JOIN `f9r73_sexy_answers` sa
ON sa.id_poll = sp.id
AND sa.published = '1'
LEFT JOIN `f9r73_sexy_templates` st
ON st.id = sp.id_template
1 × SELECT id
FROM f9r73_menu
1 × SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,p.imgdate as imgdate,c.cid AS ccid, c.catpath AS catpath
FROM f9r73_joomgallery AS p
LEFT JOIN f9r73_joomgallery_catg AS c
ON c.cid = p.catid
1 × SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
FROM f9r73_joomgallery
1 × SELECT id,template
FROM f9r73_template_styles
1 × SELECT *
FROM f9r73_joomgallery_config
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM f9r73_modules AS m
LEFT JOIN f9r73_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN f9r73_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `session_id`
FROM `f9r73_session`
1 × SELECT params
FROM f9r73_extensions AS e
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM f9r73_fields AS a
LEFT JOIN `f9r73_languages` AS l
ON l.lang_code = a.language
LEFT JOIN f9r73_users AS uc
ON uc.id=a.checked_out
LEFT JOIN f9r73_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN f9r73_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `f9r73_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT COUNT(*)
FROM f9r73_content AS a
LEFT JOIN f9r73_categories AS c
ON c.id = a.catid
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_by
LEFT JOIN f9r73_users AS uam
ON uam.id = a.modified_by
LEFT JOIN f9r73_categories as parent
ON parent.id = c.parent_id
LEFT JOIN f9r73_content_rating AS v
ON a.id = v.content_id
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM f9r73_content AS a
LEFT JOIN f9r73_categories AS c
ON c.id = a.catid
LEFT JOIN f9r73_users AS ua
ON ua.id = a.created_by
LEFT JOIN f9r73_users AS uam
ON uam.id = a.modified_by
LEFT JOIN f9r73_categories as parent
ON parent.id = c.parent_id
LEFT JOIN f9r73_content_rating AS v
ON a.id = v.content_id
1 × SELECT b.id
FROM f9r73_usergroups AS a
LEFT JOIN f9r73_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `f9r73_viewlevels
1 × SELECT guest, client_id
FROM f9r73_session