عرض العناصر حسب علامة : فوائد الليمون
الخميس, 21 تشرين2/نوفمبر 2013 22:16
خصائص الليمون وفوائده
خصائص الليمون وفوائده
خصائص الليمون وفوائده:
وحدة تحكم تشخيص الأخطاء لجوملا
{
"__default": {
"session": {
"counter": 4,
"timer": {
"start": 1779360575,
"last": 1779360595,
"now": 1779360600
}
},
"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"
}
}
}
الوقت
الذاكرة
الوقت: 29.78 ms / 29.78 ms الذاكرة: 2.011 MB / 2.39 MB Application: afterLoad
الوقت: 81.70 ms / 111.49 ms الذاكرة: 5.327 MB / 7.72 MB Application: afterInitialise
الوقت: 30.34 ms / 141.83 ms الذاكرة: 1.371 MB / 9.09 MB Application: afterRoute
الوقت: 0.55 ms / 142.38 ms الذاكرة: 0.021 MB / 9.11 MB Application: beforeRenderComponent com_k2
الوقت: 0.30 ms / 142.68 ms الذاكرة: 0.027 MB / 9.14 MB Application: Before Access::preloadComponents (all components)
الوقت: 1.08 ms / 143.76 ms الذاكرة: 0.059 MB / 9.20 MB Application: After Access::preloadComponents (all components)
الوقت: 0.03 ms / 143.79 ms الذاكرة: -0.005 MB / 9.19 MB Application: Before Access::getAssetRules (id:411 name:com_k2)
الوقت: 0.94 ms / 144.73 ms الذاكرة: 0.028 MB / 9.22 MB Application: After Access::getAssetRules (id:411 name:com_k2)
الوقت: 55.26 ms / 200.00 ms الذاكرة: 2.733 MB / 11.95 MB Application: afterRenderComponent com_k2
الوقت: 4.59 ms / 204.58 ms الذاكرة: 0.109 MB / 12.06 MB Application: afterDispatch
الوقت: 236.47 ms / 441.05 ms الذاكرة: 2.412 MB / 14.48 MB Application: afterRender
كافة إستعلامات قاعدة البيانات: 12.15 ms
14.66 MB (15,376,136 بايت (Bytes))
19 الاستعلامات المسجلة 12.15 ms
- وقت الإستعلام: 0.31 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.788 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.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 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.01 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.31 ms قبل آخر إستعلام: 0.10 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.800 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.07 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 # المتصل الملف ورقم السطر 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.33 ms قبل آخر إستعلام: 62.49 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 8.449 MB
UPDATE `jaqtf_extensions`
SET `params` = '{\"mediaversion\":\"201988a6cfcad0ee40141e4df46a55c3\"}'
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.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.09 ms updating 0.11 ms end 0.01 ms query end 0.90 ms closing tables 0.01 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: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 - وقت الإستعلام: 0.89 ms قبل آخر إستعلام: 13.48 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 9.144 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.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.02 ms executing 0.00 ms Sending data 0.49 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 # المتصل الملف ورقم السطر 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 2.48 ms قبل آخر إستعلام: 20.99 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 10.648 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.04 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.01 ms preparing 0.01 ms executing 0.01 ms Sending data 2.20 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.32 ms قبل آخر إستعلام: 1.73 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.686 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.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.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.16 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 1.37 ms قبل آخر إستعلام: 0.07 ms إستعلام الذاكرة: 0.039 MB الذاكرة بعد الإستعلام: 10.695 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:50:00')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:50:00')
AND i.id IN(SELECT itemID
FROM jaqtf_k2_tags_xref
WHERE tagID=412)
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:50:00') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:50:00') AND i.id IN(SELECT itemID FROM jaqtf_k2_tags_xref WHERE tagID=412) 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.18 ms init 0.09 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.25 ms preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.28 ms Creating sort index 0.10 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.04 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.59 ms قبل آخر إستعلام: 0.07 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.720 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:50:00')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:50:00')
AND i.id IN(SELECT itemID
FROM jaqtf_k2_tags_xref
WHERE tagID=412)التوضيح غير ممكن للإستعلام: /* 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:50:00') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:50:00') AND i.id IN(SELECT itemID FROM jaqtf_k2_tags_xref WHERE tagID=412)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.18 ms preparing 0.04 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms removing tmp table 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: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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.55 ms قبل آخر إستعلام: 2.22 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 10.840 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.11 ms init 0.01 ms System lock 0.01 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.02 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:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 14 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.24 ms قبل آخر إستعلام: 2.01 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 10.914 MB إرجاع الصفوف: 1
SELECT *
FROM jaqtf_k2_categories
WHERE id = '14'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.02 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.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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.56 ms قبل آخر إستعلام: 2.16 ms إستعلام الذاكرة: 0.031 MB الذاكرة بعد الإستعلام: 11.049 MB إرجاع الصفوف: 17
SHOW FULL COLUMNS
FROM `jaqtf_users`التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `jaqtf_users`Status Duration starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 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 checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.03 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 26 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 25 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 24 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 23 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 22 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 21 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 20 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 19 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 18 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 17 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:210 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.18 ms قبل آخر إستعلام: 0.12 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.082 MB إرجاع الصفوف: 0
SELECT *
FROM `jaqtf_users`
WHERE `id` = 62id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL لا يوجد مفتاح رئيسي يمكن استخدامه NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 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 executing 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 22 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 21 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 20 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 19 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 18 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 17 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:210 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.28 ms قبل آخر إستعلام: 3.84 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.311 MB إرجاع الصفوف: 1
SELECT id, gender, description, image, url, `
group`, plugins
FROM jaqtf_k2_users
WHERE userID=62id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_users NULL ref userID userID 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 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.04 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/components/com_k2/models/item.php:1702 17 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:214 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.27 ms قبل آخر إستعلام: 0.06 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.321 MB إرجاع الصفوف: 1
SELECT COUNT(*)
FROM jaqtf_k2_comments
WHERE itemID=653
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.07 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.02 ms end 0.01 ms query end 0.01 ms closing tables 0.00 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 1.04 ms قبل آخر إستعلام: 6.26 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.557 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 (14,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.13 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.15 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.01 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.04 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 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:194 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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.38 ms قبل آخر إستعلام: 4.21 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 11.863 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.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.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.02 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: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:655 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.31 ms قبل آخر إستعلام: 4.48 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 11.962 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.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.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.38 ms قبل آخر إستعلام: 22.11 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 12.602 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.03 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.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 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 # المتصل الملف ورقم السطر 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: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.38 ms قبل آخر إستعلام: 10.77 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 13.840 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.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.09 ms preparing 0.02 ms executing 0.01 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.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: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
19 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً
تحديد الجداول:
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 *
FROM `jaqtf_users`1 × SELECT id, gender, description, image, url, `
group`, plugins
FROM jaqtf_k2_users1 × 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 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\":\"201988a6cfcad0ee40141e4df46a55c3\"}'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_categories1 × SHOW FULL COLUMNS
FROM `jaqtf_users