عرض العناصر حسب علامة : الكرواسون البيتي اللذيذ
الأحد, 26 أيار 2013 05:48
الكرواسون البيتي اللذيذ
الكرواسون البيتي اللذيذ
المقادير:
وحدة تحكم تشخيص الأخطاء لجوملا
{
"__default": {
"session": {
"counter": 4,
"timer": {
"start": 1779359181,
"last": 1779359197,
"now": 1779359205
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "ar-AA"
}
}
}
الوقت
الذاكرة
الوقت: 24.78 ms / 24.78 ms الذاكرة: 1.696 MB / 2.08 MB Application: afterLoad
الوقت: 92.18 ms / 116.96 ms الذاكرة: 5.928 MB / 8.01 MB Application: afterInitialise
الوقت: 30.38 ms / 147.33 ms الذاكرة: 1.249 MB / 9.26 MB Application: afterRoute
الوقت: 0.61 ms / 147.94 ms الذاكرة: 0.022 MB / 9.28 MB Application: beforeRenderComponent com_k2
الوقت: 0.35 ms / 148.29 ms الذاكرة: 0.027 MB / 9.30 MB Application: Before Access::preloadComponents (all components)
الوقت: 1.38 ms / 149.67 ms الذاكرة: 0.059 MB / 9.36 MB Application: After Access::preloadComponents (all components)
الوقت: 0.06 ms / 149.73 ms الذاكرة: -0.005 MB / 9.36 MB Application: Before Access::getAssetRules (id:411 name:com_k2)
الوقت: 1.02 ms / 150.75 ms الذاكرة: 0.028 MB / 9.39 MB Application: After Access::getAssetRules (id:411 name:com_k2)
الوقت: 48.83 ms / 199.58 ms الذاكرة: 2.268 MB / 11.65 MB Application: afterRenderComponent com_k2
الوقت: 4.90 ms / 204.49 ms الذاكرة: 0.107 MB / 11.76 MB Application: afterDispatch
الوقت: 249.15 ms / 453.64 ms الذاكرة: 2.482 MB / 14.24 MB Application: afterRender
كافة إستعلامات قاعدة البيانات: 13.27 ms
14.42 MB (15,121,288 بايت (Bytes))
18 الاستعلامات المسجلة 13.27 ms
- وقت الإستعلام: 0.38 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 3.938 MB إرجاع الصفوف: 1
SELECT `session_id`
FROM `jaqtf_session`
WHERE `session_id` = X'32746c736d346a7037746c6b6f7134347369636f717373316d37'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # المتصل الملف ورقم السطر 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:834 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:392 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - وقت الإستعلام: 0.35 ms قبل آخر إستعلام: 9.83 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.530 MB إرجاع الصفوف: 4
SELECT id, rules
FROM `jaqtf_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_viewlevels NULL ALL NULL لا يوجد مفتاح رئيسي يمكن استخدامه NULL NULL 4 100.00 NULL Status Duration starting 0.07 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.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # المتصل الملف ورقم السطر 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.30 ms قبل آخر إستعلام: 0.09 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.542 MB إرجاع الصفوف: 1
SELECT b.id
FROM jaqtf_usergroups AS a
LEFT JOIN jaqtf_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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.04 ms checking permissions 0.01 ms checking permissions 0.00 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.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 1.63 ms قبل آخر إستعلام: 71.72 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 8.735 MB
UPDATE `jaqtf_extensions`
SET `params` = '{\"mediaversion\":\"101dcef33138235fbc3e68514bc38339\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jaqtf_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.11 ms updating 0.10 ms end 0.01 ms query end 1.09 ms closing tables 0.02 ms freeing items 0.02 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/helixultimate/helixultimate.php:134 8 plgSystemHelixultimate->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:1196 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 1.15 ms قبل آخر إستعلام: 12.50 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 9.309 MB إرجاع الصفوف: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jaqtf_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jch_optimize','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocafavicon','com_phocafont','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_assets NULL range idx_asset_name idx_asset_name 202 NULL 44 100.00 Using index condition Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.17 ms preparing 0.02 ms executing 0.00 ms Sending data 0.52 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # المتصل الملف ورقم السطر 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 11 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 10 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 9 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 8 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 7 Joomla\CMS\User\User->authorise() JROOT/components/com_k2/k2.php:15 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 2.11 ms قبل آخر إستعلام: 19.23 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 10.587 MB إرجاع الصفوف: 1
SELECT id, name, description
FROM jaqtf_k2_tags
WHERE name = 'الكرواسون البيتي اللذيذ'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_tags NULL ALL NULL لا يوجد مفتاح رئيسي يمكن استخدامه NULL NULL 1823 10.00 Using where Status Duration starting 0.08 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.02 ms preparing 0.01 ms executing 0.00 ms Sending data 1.74 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/views/itemlist/view.html.php:288 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.53 ms قبل آخر إستعلام: 1.82 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.688 MB إرجاع الصفوف: 1
SELECT id
FROM jaqtf_k2_tags
WHERE name='الكرواسون البيتي اللذيذ'
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_tags NULL ALL NULL لا يوجد مفتاح رئيسي يمكن استخدامه NULL NULL 1823 10.00 Using where Status Duration starting 0.04 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.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.30 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:211 13 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 1.13 ms قبل آخر إستعلام: 0.08 ms إستعلام الذاكرة: 0.039 MB الذاكرة بعد الإستعلام: 10.696 MB إرجاع الصفوف: 1
/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jaqtf_k2_items AS i
INNER JOIN jaqtf_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1)
AND c.trash = 0
AND c.language IN('ar-AA', '*')
AND i.language IN('ar-AA', '*')
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-21 10:26:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:26:45')
AND i.id IN(SELECT itemID
FROM jaqtf_k2_tags_xref
WHERE tagID=967)
GROUP BY i.id
ORDER BY i.id DESC
LIMIT 0, 6التوضيح غير ممكن للإستعلام: /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM jaqtf_k2_items AS i INNER JOIN jaqtf_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND c.language IN('ar-AA', '*') AND i.language IN('ar-AA', '*') AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-21 10:26:45') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:26:45') AND i.id IN(SELECT itemID FROM jaqtf_k2_tags_xref WHERE tagID=967) GROUP BY i.id ORDER BY i.id DESC LIMIT 0, 6Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.23 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.26 ms Creating sort index 0.08 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:335 13 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.51 ms قبل آخر إستعلام: 0.06 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.717 MB إرجاع الصفوف: 1
/* Frontend / K2 / Items Count */ SELECT COUNT(DISTINCT i.id)
FROM jaqtf_k2_items AS i
INNER JOIN jaqtf_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1)
AND c.trash = 0
AND c.language IN('ar-AA', '*')
AND i.language IN('ar-AA', '*')
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-21 10:26:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:26:45')
AND i.id IN(SELECT itemID
FROM jaqtf_k2_tags_xref
WHERE tagID=967)التوضيح غير ممكن للإستعلام: /* Frontend / K2 / Items Count */ SELECT COUNT(DISTINCT i.id) FROM jaqtf_k2_items AS i INNER JOIN jaqtf_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND c.language IN('ar-AA', '*') AND i.language IN('ar-AA', '*') AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-21 10:26:45') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:26:45') AND i.id IN(SELECT itemID FROM jaqtf_k2_tags_xref WHERE tagID=967)Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.04 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:345 13 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.53 ms قبل آخر إستعلام: 2.25 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 10.841 MB إرجاع الصفوف: 14
SHOW FULL COLUMNS
FROM `jaqtf_k2_categories`التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `jaqtf_k2_categories`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 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.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 Sending data 0.05 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.02 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 14 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:312 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/views/itemlist/view.html.php:729 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.35 ms قبل آخر إستعلام: 2.09 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 10.899 MB إرجاع الصفوف: 1
SELECT *
FROM jaqtf_k2_categories
WHERE id = '709'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 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.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 17 TableK2Category->load() JROOT/components/com_k2/models/item.php:65 16 K2ModelItem->prepareItem() نفس الاستدعاء في خط أدناه. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.30 ms قبل آخر إستعلام: 1.58 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 10.970 MB إرجاع الصفوف: 1
SELECT COUNT(*)
FROM jaqtf_k2_comments
WHERE itemID=602
AND published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_comments NULL ref itemID,published,latestComments,countComments itemID 4 const 1 57.14 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 17 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 16 K2ModelItem->prepareItem() نفس الاستدعاء في خط أدناه. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:731 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.96 ms قبل آخر إستعلام: 6.09 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.211 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 jaqtf_fields AS a
LEFT JOIN `jaqtf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jaqtf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jaqtf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jaqtf_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jaqtf_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jaqtf_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (709,0))
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 ASCid 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 mourasi1_mourasiloon.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 mourasi1_mourasiloon.a.checked_out 1 100.00 Using where 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 mourasi1_mourasiloon.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 mourasi1_mourasiloon.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 mourasi1_mourasiloon.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 mourasi1_mourasiloon.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.17 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # المتصل الملف ورقم السطر 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 19 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 16 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:674 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/itemlist/view.html.php:740 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.58 ms قبل آخر إستعلام: 4.41 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 11.578 MB إرجاع الصفوف: 27
SELECT id
FROM jaqtf_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_categories NULL range category,published,access,trash,idx_category category 8 NULL 27 100.00 Using where; Using index Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:225 13 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/itemlist/view.html.php:788 12 K2ViewItemlist->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/itemlist.php:50 8 K2ControllerItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.41 ms قبل آخر إستعلام: 5.57 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 11.659 MB إرجاع الصفوف: 1
SELECT language,id
FROM `jaqtf_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 36 1.00 Using where Status Duration starting 0.05 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.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.98 ms قبل آخر إستعلام: 12.73 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.902 MB إرجاع الصفوف: 18
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jaqtf_modules AS m
LEFT JOIN jaqtf_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jaqtf_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 <= '2026-05-21 10:26:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-21 10:26:45')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 913 OR mm.menuid <= 0)
AND m.language IN ('ar-AA','*')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds,idx_language published 6 NULL 7 1.46 Using index condition; Using where; استعمال ترتيب الملفات 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 mourasi1_mourasiloon.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 mourasi1_mourasiloon.m.id 9 40.00 Using where; Using index Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # المتصل الملف ورقم السطر 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() نفس الاستدعاء في خط أدناه. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/protostar/index.php:100 7 require JROOT/templates/protostar/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1104 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.55 ms قبل آخر إستعلام: 10.90 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 12.369 MB إرجاع الصفوف: 0
SELECT a.*
FROM jaqtf_phocafont_font AS a
WHERE a.published = 1
AND a.defaultfont = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref cat_idx cat_idx 1 const 1 33.33 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 9 JDatabaseDriver->loadObject() JROOT/plugins/system/phocafont/phocafont.php:119 8 plgSystemPhocaFont->onAfterRenderCssRulesWrite() JROOT/plugins/system/phocafont/phocafont.php:61 7 plgSystemPhocaFont->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:1124 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.53 ms قبل آخر إستعلام: 11.35 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 13.545 MB إرجاع الصفوف: 1
SELECT folder AS type, element AS name, params, extension_id
FROM jaqtf_extensions
WHERE element = 'jch_optimize'
AND type = 'plugin'
AND folder = 'system'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 5.00 Using where Status Duration starting 0.09 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.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/plugins/system/jch_optimize/src/Plugin.php:74 17 JchOptimize\Platform\Plugin::loadjch() JROOT/plugins/system/jch_optimize/src/Plugin.php:47 16 JchOptimize\Platform\Plugin::getPlugin() JROOT/plugins/system/jch_optimize/src/Plugin.php:91 15 JchOptimize\Platform\Plugin::getPluginParams() JROOT/plugins/system/jch_optimize/src/Cache.php:110 14 JchOptimize\Platform\Cache::getLifetime() JROOT/plugins/system/jch_optimize/src/Cache.php:92 13 JchOptimize\Platform\Cache::getCacheObject() JROOT/plugins/system/jch_optimize/src/Cache.php:127 12 JchOptimize\Platform\Cache::getCache() JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Html/Callbacks/CombineJsCss.php:54 11 JchOptimize\Core\Html\Callbacks\CombineJsCss->__construct() JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Html/Processor.php:135 10 JchOptimize\Core\Html\Processor->processCombineJsCss() JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Optimize.php:108 9 JchOptimize\Core\Optimize->process() JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Optimize.php:90 8 JchOptimize\Core\Optimize::optimize() JROOT/plugins/system/jch_optimize/jch_optimize.php:95 7 plgSystemJCH_Optimize->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:1124 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
18 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً
تحديد الجداول:
1 × SELECT `session_id`
FROM `jaqtf_session`1 × SELECT id, rules
FROM `jaqtf_viewlevels1 × SELECT b.id
FROM jaqtf_usergroups AS a
LEFT JOIN jaqtf_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jaqtf_assets`1 × SELECT id, name, description
FROM jaqtf_k2_tags1 × SELECT id
FROM jaqtf_k2_tags1 × SELECT *
FROM jaqtf_k2_categories1 × SELECT COUNT(*)
FROM jaqtf_k2_comments1 × 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 jaqtf_fields AS a
LEFT JOIN `jaqtf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jaqtf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jaqtf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jaqtf_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jaqtf_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jaqtf_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT id
FROM jaqtf_k2_categories1 × SELECT language,id
FROM `jaqtf_menu`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jaqtf_modules AS m
LEFT JOIN jaqtf_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jaqtf_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT a.*
FROM jaqtf_phocafont_font AS a1 × SELECT folder AS type, element AS name, params, extension_id
FROM jaqtf_extensions
جداول أخرى:
1 × UPDATE `jaqtf_extensions`
SET `params` = '{\"mediaversion\":\"101dcef33138235fbc3e68514bc38339\"}'1 × /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jaqtf_k2_items AS i
INNER JOIN jaqtf_k2_categories AS c
ON c.id = i.catid1 × /* Frontend / K2 / Items Count */ SELECT COUNT(DISTINCT i.id)
FROM jaqtf_k2_items AS i
INNER JOIN jaqtf_k2_categories AS c
ON c.id = i.catid1 × SHOW FULL COLUMNS
FROM `jaqtf_k2_categories