وحدة تحكم تشخيص الأخطاء لجوملا

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1779353454,
                "last": 1779353454,
                "now": 1779353454
            },
            "client": {
                "forwarded": "18.97.14.81"
            },
            "token": "YJqwtUCGVHYS9dtLvGWB47r2n054obhD"
        },
        "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
        }
    }
}

الوقت

الذاكرة

22 الاستعلامات المسجلة 78.62 ms

1. وقت الإستعلام: 0.78 ms إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 0.737 MB إرجاع الصفوف: 0

   SELECT `data`
   
     FROM `j8tjs_session`
   
     WHERE `session_id` = 'p637c172hpmlkr7k14hlcdvc41'

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j8tjs_session	const	PRIMARY	PRIMARY	766	const	1

   البروفايل

   Status	Duration
   Starting	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.03 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.10 ms
   Preparing	0.02 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	نفس الاستدعاء في خط أدناه.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

2. وقت الإستعلام: 0.59 ms قبل آخر إستعلام: 0.78 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 0.758 MB إرجاع الصفوف: 0

   SELECT `session_id`
   
     FROM `j8tjs_session`
   
     WHERE `session_id` = 'p637c172hpmlkr7k14hlcdvc41' 
     LIMIT 1

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j8tjs_session	const	PRIMARY	PRIMARY	766	const	1	Using index

   البروفايل

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.05 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

3. وقت الإستعلام: 1.36 ms قبل آخر إستعلام: 0.12 ms إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 0.763 MB

   INSERT INTO `j8tjs_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('p637c172hpmlkr7k14hlcdvc41', 0, '1779353454')

   التوضيح

   التوضيح غير ممكن للإستعلام: INSERT INTO `j8tjs_session` (`session_id`, `client_id`, `time`) VALUES ('p637c172hpmlkr7k14hlcdvc41', 0, '1779353454')

   البروفايل

   Status	Duration
   Starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.03 ms
   Update	0.10 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.73 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

4. وقت الإستعلام: 0.99 ms قبل آخر إستعلام: 0.73 ms إستعلام الذاكرة: 0.031 MB الذاكرة بعد الإستعلام: 0.797 MB إرجاع الصفوف: 37

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM j8tjs_extensions
   
     WHERE `type` = 'component'

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j8tjs_extensions	ref	extension	extension	82	const	37	Using index condition

   البروفايل

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.08 ms
   Preparing	0.04 ms
   Executing	0.02 ms
   Sending data	0.21 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.05 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

5. وقت الإستعلام: 0.82 ms قبل آخر إستعلام: 0.50 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 0.891 MB إرجاع الصفوف: 1

   SELECT b.id
   
     FROM j8tjs_usergroups AS a
   
     LEFT JOIN j8tjs_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 1

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

   البروفايل

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.08 ms
   Preparing	0.03 ms
   Unlocking tables	0.03 ms
   Preparing	0.05 ms
   Executing	0.02 ms
   Sending data	0.08 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:852
   8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:921
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

6. وقت الإستعلام: 0.64 ms قبل آخر إستعلام: 0.14 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 0.898 MB إرجاع الصفوف: 3

   SELECT id, rules
   
     FROM `j8tjs_viewlevels`

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j8tjs_viewlevels	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	3

   البروفايل

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Executing	0.02 ms
   Sending data	0.04 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.03 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:938
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

7. وقت الإستعلام: 1.27 ms قبل آخر إستعلام: 0.30 ms إستعلام الذاكرة: 0.030 MB الذاكرة بعد الإستعلام: 0.908 MB إرجاع الصفوف: 68

   SELECT folder AS type, element AS name, params
   
     FROM j8tjs_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j8tjs_extensions	ALL	extension	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	204	Using where; استعمال ترتيب الملفات

   البروفايل

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.04 ms
   Statistics	0.06 ms
   Preparing	0.04 ms
   Sorting result	0.02 ms
   Executing	0.02 ms
   Sending data	0.02 ms
   Creating sort index	0.49 ms
   End of update loop	0.03 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.05 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

8. وقت الإستعلام: 2.22 ms قبل آخر إستعلام: 6.50 ms إستعلام الذاكرة: 0.103 MB الذاكرة بعد الإستعلام: 1.342 MB إرجاع الصفوف: 84

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM j8tjs_menu AS m
   
     LEFT JOIN j8tjs_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	141	Using index condition; Using where; استعمال ترتيب الملفات
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c30commila.m.component_id	1	Using where

   البروفايل

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.08 ms
   Preparing	0.06 ms
   Sorting result	0.03 ms
   Executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	1.36 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

9. وقت الإستعلام: 0.81 ms قبل آخر إستعلام: 2.58 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 1.924 MB إرجاع الصفوف: 1

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM j8tjs_extensions
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   التوضيح

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j8tjs_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

   البروفايل

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.05 ms
   Executing	0.02 ms
   Sending data	0.05 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   استدعاء المخزن

   #	المتصل	الملف ورقم السطر
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
   11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

   ---

10. وقت الإستعلام: 1.35 ms قبل آخر إستعلام: 0.23 ms إستعلام الذاكرة: 0.007 MB الذاكرة بعد الإستعلام: 1.917 MB

    UPDATE `j8tjs_extensions`
    
      SET `params` = '{\"mediaversion\":\"a6183e3394c76c9cdbc648fbee5e1ba3\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    التوضيح

    التوضيح غير ممكن للإستعلام: UPDATE `j8tjs_extensions` SET `params` = '{\"mediaversion\":\"a6183e3394c76c9cdbc648fbee5e1ba3\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    البروفايل

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.09 ms
    Updating	0.12 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.65 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

11. وقت الإستعلام: 0.83 ms قبل آخر إستعلام: 0.55 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 1.942 MB إرجاع الصفوف: 3

    SELECT *
    
      FROM j8tjs_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j8tjs_languages	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	3	Using where; استعمال ترتيب الملفات

    البروفايل

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.07 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

12. وقت الإستعلام: 0.87 ms قبل آخر إستعلام: 0.27 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 1.957 MB إرجاع الصفوف: 6

    SELECT id, home, template, s.params
    
      FROM j8tjs_template_styles as s
    
      LEFT JOIN j8tjs_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	10	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	c30commila.s.template,const	1	Using index condition; Using where

    البروفايل

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.12 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

13. وقت الإستعلام: 23.03 ms قبل آخر إستعلام: 232.55 ms إستعلام الذاكرة: 0.137 MB الذاكرة بعد الإستعلام: 2.505 MB إرجاع الصفوف: 81

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j8tjs_modules AS m
    
      LEFT JOIN j8tjs_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN j8tjs_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-05-21 08:50:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-21 08:50:55') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 0 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	229	Using where; استعمال ترتيب الملفات
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	c30commila.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	c30commila.m.module,const	1	Using index condition; Using where

    البروفايل

    Status	Duration
    Starting	0.19 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.08 ms
    Statistics	0.20 ms
    Preparing	0.08 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	21.72 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
    15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
    14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    12	JDocumentHtml->countModules()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:49
    11	ModulesWarpHelper->count()	JROOT/templates/yoo_quantum/layouts/template.config.php:23
    10	include JROOT/templates/yoo_quantum/layouts/template.config.php	JROOT/templates/yoo_quantum/layouts/template.php:10
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

14. وقت الإستعلام: 1.88 ms قبل آخر إستعلام: 42.31 ms إستعلام الذاكرة: 0.041 MB الذاكرة بعد الإستعلام: 3.505 MB إرجاع الصفوف: 8

    SHOW FULL COLUMNS 
      FROM `j8tjs_assets`

    التوضيح

    التوضيح غير ممكن للإستعلام: SHOW FULL COLUMNS FROM `j8tjs_assets`

    البروفايل

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.52 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    checking permissions	0.12 ms
    closing tables	0.03 ms
    checking permissions	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Removing tmp table	0.18 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    28	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    27	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    26	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:304
    25	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:714
    24	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
    23	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    22	JUser->authorise()	JROOT/components/com_content/models/articles.php:467
    21	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    20	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:566
    18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

15. وقت الإستعلام: 0.74 ms قبل آخر إستعلام: 0.45 ms إستعلام الذاكرة: 0.037 MB الذاكرة بعد الإستعلام: 3.545 MB إرجاع الصفوف: 1

    SELECT *
    
      FROM j8tjs_assets
    
      WHERE `id` = '1'

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j8tjs_assets	const	PRIMARY	PRIMARY	4	const	1

    البروفايل

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
    25	JTable->load()	JROOT/libraries/joomla/access/access.php:715
    24	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
    23	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    22	JUser->authorise()	JROOT/components/com_content/models/articles.php:467
    21	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    20	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:566
    18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

16. وقت الإستعلام: 0.81 ms قبل آخر إستعلام: 0.16 ms إستعلام الذاكرة: 0.034 MB الذاكرة بعد الإستعلام: 3.561 MB إرجاع الصفوف: 1

    SELECT a.rules
    
      FROM j8tjs_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    البروفايل

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.14 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
    23	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    22	JUser->authorise()	JROOT/components/com_content/models/articles.php:467
    21	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    20	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:566
    18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

17. وقت الإستعلام: 0.89 ms قبل آخر إستعلام: 0.40 ms إستعلام الذاكرة: 0.038 MB الذاكرة بعد الإستعلام: 3.582 MB إرجاع الصفوف: 37

    SELECT element
    
      FROM j8tjs_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j8tjs_extensions	ref	extension	extension	82	const	37	Using index condition; Using where

    البروفايل

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.16 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    26	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:412
    25	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    24	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    23	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    22	JUser->authorise()	JROOT/components/com_content/models/articles.php:467
    21	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    20	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:566
    18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

18. وقت الإستعلام: 1.17 ms قبل آخر إستعلام: 0.20 ms إستعلام الذاكرة: 0.039 MB الذاكرة بعد الإستعلام: 3.607 MB إرجاع الصفوف: 36

    SELECT a.name, a.rules
    
      FROM j8tjs_assets AS a
    
      WHERE (a.name IN ('com_admin','com_admirorgallery','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_eventgallery','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocaguestbook','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	38	Using index condition

    البروفايل

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.40 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    26	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:439
    25	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    24	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    23	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    22	JUser->authorise()	JROOT/components/com_content/models/articles.php:467
    21	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    20	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:181
    19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:566
    18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

19. وقت الإستعلام: 27.17 ms قبل آخر إستعلام: 1.17 ms إستعلام الذاكرة: 0.221 MB الذاكرة بعد الإستعلام: 3.823 MB إرجاع الصفوف: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM j8tjs_content AS a
    
      LEFT JOIN j8tjs_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN j8tjs_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN j8tjs_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN j8tjs_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN j8tjs_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-21 08:50:55') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-21 08:50:55')
    
      ORDER BY a.hits DESC 
      LIMIT 5

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	v	system	PRIMARY	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	0	Const row not found; Using temporary; استعمال ترتيب الملفات
    1	PRIMARY	c	range	PRIMARY,idx_access	idx_access	5	NULL	24	Using index condition
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	c30commila.c.id	19	Using index condition; Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	c30commila.a.created_by	1	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	c30commila.a.modified_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	c30commila.c.parent_id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	c30commila.c.id	2	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using index condition; Using temporary; استعمال ترتيب الملفات
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	24	Using where; Using index; Using join buffer (flat, BNL join)

    البروفايل

    Status	Duration
    Starting	0.25 ms
    checking permissions	0.03 ms
    Opening tables	0.15 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.15 ms
    Optimizing	0.09 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Statistics	0.17 ms
    Preparing	0.05 ms
    Creating tmp table	0.04 ms
    Sorting result	0.03 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.08 ms
    Creating tmp table	0.15 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.19 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.02 ms
    Creating sort index	22.62 ms
    Creating sort index	1.92 ms
    Removing tmp table	0.31 ms
    Creating sort index	0.04 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.04 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    20	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:566
    18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

20. وقت الإستعلام: 3.31 ms قبل آخر إستعلام: 1.09 ms إستعلام الذاكرة: 0.044 MB الذاكرة بعد الإستعلام: 4.103 MB إرجاع الصفوف: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j8tjs_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j8tjs_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=9
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; استعمال ترتيب الملفات
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	24	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	c30commila.c.id	2	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using index condition; Using temporary; استعمال ترتيب الملفات
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	24	Using where; Using index; Using join buffer (flat, BNL join)

    البروفايل

    Status	Duration
    Starting	0.33 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.18 ms
    Optimizing	0.09 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Statistics	0.18 ms
    Preparing	0.08 ms
    Creating tmp table	0.04 ms
    Sorting result	0.04 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.07 ms
    Creating tmp table	0.09 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.08 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.76 ms
    Creating sort index	0.14 ms
    Removing tmp table	0.19 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.08 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    18	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_popular/helper.php:86
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

21. وقت الإستعلام: 3.65 ms قبل آخر إستعلام: 0.65 ms إستعلام الذاكرة: 0.044 MB الذاكرة بعد الإستعلام: 4.135 MB إرجاع الصفوف: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j8tjs_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j8tjs_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=12
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; استعمال ترتيب الملفات
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	24	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	c30commila.c.id	2	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using index condition; Using temporary; استعمال ترتيب الملفات
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	24	Using where; Using index; Using join buffer (flat, BNL join)

    البروفايل

    Status	Duration
    Starting	0.22 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.13 ms
    Optimizing	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Statistics	0.17 ms
    Preparing	0.05 ms
    Creating tmp table	0.03 ms
    Sorting result	0.03 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.06 ms
    Creating tmp table	0.08 ms
    Sorting result	0.06 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.69 ms
    Creating sort index	0.16 ms
    Removing tmp table	0.20 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    18	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_popular/helper.php:86
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

22. وقت الإستعلام: 3.46 ms قبل آخر إستعلام: 0.48 ms إستعلام الذاكرة: 0.044 MB الذاكرة بعد الإستعلام: 4.157 MB إرجاع الصفوف: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j8tjs_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j8tjs_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=8
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    التوضيح

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; استعمال ترتيب الملفات
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	24	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	c30commila.c.id	2	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	3	Using index condition; Using temporary; استعمال ترتيب الملفات
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	24	Using where; Using index; Using join buffer (flat, BNL join)

    البروفايل

    Status	Duration
    Starting	0.23 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.16 ms
    Optimizing	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Statistics	0.18 ms
    Preparing	0.08 ms
    Creating tmp table	0.04 ms
    Sorting result	0.04 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.07 ms
    Creating tmp table	0.08 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.08 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.03 ms
    Creating sort index	0.81 ms
    Creating sort index	0.14 ms
    Removing tmp table	0.20 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.08 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    استدعاء المخزن

    #	المتصل	الملف ورقم السطر
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    18	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_popular/helper.php:86
    17	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    16	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/cms/module/helper.php:190
    15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    14	JDocumentRendererHtmlModule->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/yoo_quantum/layouts/template.php:144
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [إضافة xdebug.file_link_format إلى توجيه ملف php.ini لروابط ملفاتك]

    ---

19 أنواع الاستعلامات المسجلة, مصنفة حسب حالة الظهور تنازلياً

تحديد الجداول:

1. 3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM j8tjs_categories as c 
     LEFT JOIN  (SELECT cat.id as id 
     FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt 

2. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM j8tjs_extensions 

3. 1 × SELECT `data` 
     FROM `j8tjs_session` 

4. 1 × SELECT `session_id` 
     FROM `j8tjs_session` 

5. 1 × SELECT b.id 
     FROM j8tjs_usergroups AS a 
     LEFT JOIN j8tjs_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt 

6. 1 × SELECT id, rules 
     FROM `j8tjs_viewlevels 

7. 1 × SELECT folder AS type, element AS name, params 
     FROM j8tjs_extensions 

8. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
     FROM j8tjs_menu AS m 
     LEFT JOIN j8tjs_extensions AS e 
     ON m.component_id = e.extension_id 

9. 1 × SELECT * 
     FROM j8tjs_languages 

10. 1 × SELECT id, home, template, s.params 
      FROM j8tjs_template_styles as s 
      LEFT JOIN j8tjs_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id 

11. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM j8tjs_modules AS m 
      LEFT JOIN j8tjs_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN j8tjs_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id 

12. 1 × SELECT * 
      FROM j8tjs_assets 

13. 1 × SELECT a.rules 
      FROM j8tjs_assets AS a 

14. 1 × SELECT element 
      FROM j8tjs_extensions 

15. 1 × SELECT a.name, a.rules 
      FROM j8tjs_assets AS a 

16. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
      FROM j8tjs_content AS a 
      LEFT JOIN j8tjs_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN j8tjs_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN j8tjs_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN j8tjs_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN j8tjs_content_rating AS v 
      ON a.id = v.content_id 
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM j8tjs_categories AS cat JOIN j8tjs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 

جداول أخرى:

1. 1 × INSERT INTO `j8tjs_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('p637c172hpmlkr7k14hlcdvc41', 0, '1779353454' 

2. 1 × UPDATE `j8tjs_extensions` 
     SET `params` = '{\"mediaversion\":\"a6183e3394c76c9cdbc648fbee5e1ba3\"}' 

3. 1 × SHOW FULL COLUMNS 
     FROM `j8tjs_assets