عرض العناصر حسب علامة : رحمه
الإثنين, 17 كانون2/يناير 2011 00:11
الموده والرحمه
الموده والرحمه
من دلائل عظمة القرآن و إعجازه أنه حينما ذكر الزواج، لم يذكر الحب وإنما ذكر المودة... والرحمة والسكن..
وحدة تحكم تشخيص الأخطاء لجوملا
{
"__default": {
"session": {
"counter": 6,
"timer": {
"start": 1779359436,
"last": 1779359486,
"now": 1779359530
}
},
"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.94 ms / 24.94 ms الذاكرة: 1.696 MB / 2.08 MB Application: afterLoad
الوقت: 89.09 ms / 114.04 ms الذاكرة: 5.911 MB / 7.99 MB Application: afterInitialise
الوقت: 29.37 ms / 143.40 ms الذاكرة: 1.249 MB / 9.24 MB Application: afterRoute
الوقت: 0.63 ms / 144.03 ms الذاكرة: 0.021 MB / 9.26 MB Application: beforeRenderComponent com_k2
الوقت: 0.34 ms / 144.38 ms الذاكرة: 0.027 MB / 9.29 MB Application: Before Access::preloadComponents (all components)
الوقت: 2.03 ms / 146.40 ms الذاكرة: 0.059 MB / 9.34 MB Application: After Access::preloadComponents (all components)
الوقت: 0.03 ms / 146.43 ms الذاكرة: -0.005 MB / 9.34 MB Application: Before Access::getAssetRules (id:411 name:com_k2)
الوقت: 0.95 ms / 147.39 ms الذاكرة: 0.028 MB / 9.37 MB Application: After Access::getAssetRules (id:411 name:com_k2)
الوقت: 52.51 ms / 199.89 ms الذاكرة: 2.333 MB / 11.70 MB Application: afterRenderComponent com_k2
الوقت: 4.80 ms / 204.70 ms الذاكرة: 0.107 MB / 11.81 MB Application: afterDispatch
الوقت: 237.28 ms / 441.98 ms الذاكرة: 2.471 MB / 14.28 MB Application: afterRender
كافة إستعلامات قاعدة البيانات: 17.32 ms
14.47 MB (15,174,960 بايت (Bytes))
20 الاستعلامات المسجلة 17.32 ms
- وقت الإستعلام: 0.40 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.512 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.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.07 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.41 ms قبل آخر إستعلام: 0.08 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.524 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.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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.43 ms قبل آخر إستعلام: 68.72 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 8.717 MB
UPDATE `jaqtf_extensions`
SET `params` = '{\"mediaversion\":\"414288f499d122a182090934a17aaf23\"}'
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.11 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.14 ms updating 0.13 ms end 0.02 ms query end 0.81 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 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.81 ms قبل آخر إستعلام: 12.29 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 9.290 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.15 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.09 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.28 ms preparing 0.03 ms executing 0.01 ms Sending data 0.90 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 - وقت الإستعلام: 4.25 ms قبل آخر إستعلام: 17.97 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 10.568 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.07 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 3.84 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.66 ms قبل آخر إستعلام: 1.75 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.669 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.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.43 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: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.64 ms قبل آخر إستعلام: 0.07 ms إستعلام الذاكرة: 0.039 MB الذاكرة بعد الإستعلام: 10.677 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:32:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:32:10')
AND i.id IN(SELECT itemID
FROM jaqtf_k2_tags_xref
WHERE tagID=659)
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:32:10') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:32:10') AND i.id IN(SELECT itemID FROM jaqtf_k2_tags_xref WHERE tagID=659) GROUP BY i.id ORDER BY i.id DESC LIMIT 0, 6Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.21 ms init 0.11 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.33 ms preparing 0.04 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.31 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms removing tmp table 0.05 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 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.72 ms قبل آخر إستعلام: 0.06 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.697 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:32:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:32:10')
AND i.id IN(SELECT itemID
FROM jaqtf_k2_tags_xref
WHERE tagID=659)التوضيح غير ممكن للإستعلام: /* 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:32:10') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-21 10:32:10') AND i.id IN(SELECT itemID FROM jaqtf_k2_tags_xref WHERE tagID=659)Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.21 ms preparing 0.05 ms executing 0.01 ms Sending data 0.06 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: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.67 ms قبل آخر إستعلام: 2.25 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 10.821 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.13 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms Opening tables 0.01 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.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.07 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.03 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: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.28 ms قبل آخر إستعلام: 2.23 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 10.880 MB إرجاع الصفوف: 1
SELECT *
FROM jaqtf_k2_categories
WHERE id = '19'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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.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 # المتصل الملف ورقم السطر 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.59 ms قبل آخر إستعلام: 0.15 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 10.896 MB إرجاع الصفوف: 27
SELECT id, name, parent
FROM jaqtf_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
AND language IN('ar-AA', '*')
ORDER BY parentid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_categories NULL ref category,published,access,trash,language,idx_category trash 2 const 30 90.32 Using index condition; Using where; استعمال ترتيب الملفات 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.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.23 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 # المتصل الملف ورقم السطر 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:881 19 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:261 18 K2HelperRoute::findMenuItem() JROOT/components/com_k2/helpers/route.php:56 17 K2HelperRoute::getCategoryRoute() JROOT/components/com_k2/models/item.php:68 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.25 ms قبل آخر إستعلام: 0.24 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 10.923 MB إرجاع الصفوف: 1
SELECT id, alias, parent
FROM jaqtf_k2_categories
WHERE published = 1
AND id = 19id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_categories NULL const PRIMARY,category,published,idx_category PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 27 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:504 26 getCategoryProps() JROOT/components/com_k2/router.php:512 25 getCategoryPath() JROOT/components/com_k2/router.php:207 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:68 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.24 ms قبل آخر إستعلام: 0.05 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 10.937 MB إرجاع الصفوف: 1
SELECT id, alias, parent
FROM jaqtf_k2_categories
WHERE published = 1
AND id = 11id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_categories NULL const PRIMARY,category,published,idx_category PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 28 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:504 27 getCategoryProps() JROOT/components/com_k2/router.php:512 26 getCategoryPath() JROOT/components/com_k2/router.php:518 25 getCategoryPath() JROOT/components/com_k2/router.php:207 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:68 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.21 ms قبل آخر إستعلام: 0.06 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 10.950 MB إرجاع الصفوف: 1
SELECT id, alias, parent
FROM jaqtf_k2_categories
WHERE published = 1
AND id = 715id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jaqtf_k2_categories NULL const PRIMARY,category,published,idx_category PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # المتصل الملف ورقم السطر 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 29 JDatabaseDriver->loadObject() JROOT/components/com_k2/router.php:504 28 getCategoryProps() JROOT/components/com_k2/router.php:512 27 getCategoryPath() JROOT/components/com_k2/router.php:518 26 getCategoryPath() JROOT/components/com_k2/router.php:518 25 getCategoryPath() JROOT/components/com_k2/router.php:207 24 k2BuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 23 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 22 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 21 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 20 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 19 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 18 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 17 Joomla\CMS\Router\Route::_() JROOT/components/com_k2/models/item.php:68 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.38 ms قبل آخر إستعلام: 1.42 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 11.015 MB إرجاع الصفوف: 1
SELECT COUNT(*)
FROM jaqtf_k2_comments
WHERE itemID=131
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.09 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 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: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 - وقت الإستعلام: 1.46 ms قبل آخر إستعلام: 6.26 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 11.256 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 (19,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.17 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.39 ms init 0.08 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.22 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.05 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 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.40 ms قبل آخر إستعلام: 4.24 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 11.625 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.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 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.52 ms قبل آخر إستعلام: 5.20 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 11.706 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.04 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 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.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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - وقت الإستعلام: 0.54 ms قبل آخر إستعلام: 22.18 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 12.406 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.06 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 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 # المتصل الملف ورقم السطر 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.44 ms قبل آخر إستعلام: 11.02 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 13.581 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.06 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.10 ms preparing 0.02 ms executing 0.01 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 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً
تحديد الجداول:
3 × SELECT id, alias, parent
FROM jaqtf_k2_categories1 × 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 id, name, parent
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 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\":\"414288f499d122a182090934a17aaf23\"}'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