افتتاح شبکه الجامعات المجازیه للعالم الإسلامی

A A A

**التفاصيل**: **المجموعة: News**; **انشأ بتاريخ: **25 **شباط/فبراير** 2014****

شبکه الجامعات المجازیه التابع للعالم الاسلامی، غداً الاحد 18دی 1390فی جامعة بیام نور بواسطه البروفسور عطاءالرحمن سیفتتح غداً.

??COM_KOMENTO_FORM_LEAVE_YOUR_COMMENTS??

??COM_KOMENTO_FORM_POST_COMMENT_AS_GUEST??

??COM_KOMENTO_COMMENTS??

??COM_KOMENTO_COMMENTS_NO_COMMENT??

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

الدورة

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714088817,
                "last": 1714088817,
                "now": 1714088817
            },
            "token": "QFWJkDXW08XptvtfnI6NJdR3xv8gHOLZ"
        },
        "registry": {
            "jm-services": {
                "themer": {
                    "state": "{\"JMcolorVersion\":\"#017eba\",\"JMpageBackground\":\"#f4f4f4\",\"JMcomponentBackground\":\"#ffffff\",\"JMcomponentBorder\":\"#e7e7e7\",\"JMbaseFontColor\":\"#898989\",\"JMarticleFontColor\":\"#2f2f2f\",\"JMtopbarBackground\":\"#ffffff\",\"JMtopbarBorder\":\"#e7e7e7\",\"JMtopbarFontColor\":\"#898989\",\"JMtopmenuBackground\":\"#ffffff\",\"JMtopmenuBorder\":\"#e7e7e7\",\"JMtopmenuFontColor\":\"#017eba\",\"JMmoduleBackground\":\"#ffffff\",\"JMmoduleBorder\":\"#e7e7e7\",\"JMmoduleFontColor\":\"#898989\",\"JMcolorBox1Background\":\"#017eba\",\"JMcolorBox2Background\":\"#a0b046\",\"JMcolorBox3Background\":\"#f78145\",\"JMfooterBackground\":\"#e7e7e7\",\"JMfooterBorder\":\"#dedede\",\"JMfooterFontColor\":\"#898989\",\"logo\":\"images\\/users\\/9.jpg\",\"logoText\":\"\",\"siteDescription\":\"\",\"fontSizeSwitcher\":\"1\",\"backToTop\":\"1\",\"favIconImg\":\"\",\"JMfluidGridContainerLg\":\"1170px\",\"JMbaseSpace\":\"30px\",\"columnLeftWidth\":\"3\",\"columnRightWidth\":\"3\",\"responsiveLayout\":\"1\",\"DisableComponentDisplay\":[\"435\"],\"layout\":\"default\",\"JMbaseFontSize\":\"16px\",\"bodyFontType\":\"3;bodyGeneratedWebFont\",\"bodyFontFamily\":\"Arial, Helvetica, sans-serif\",\"bodyCustomFont\":\"p30\",\"bodyGoogleWebFontUrl\":\"http:\\/\\/fonts.googleapis.com\\/css?family=Lato:400,300,300italic,400italic,700,700italic,900,900italic\",\"bodyGoogleWebFontFamily\":\"'Lato', 'sans-serif'\",\"bodyGeneratedWebFont\":\"p30\",\"JMtopmenuFontSize\":\"16px\",\"djmenuFontType\":\"3;djmenuGeneratedWebFont\",\"djmenuFontFamily\":\"Tahoma\",\"djmenuCustomFont\":\"p30\",\"djmenuGoogleWebFontUrl\":\"http:\\/\\/fonts.googleapis.com\\/css?family=Lato:400,300,300italic,400italic,700,700italic,900,900italic\",\"djmenuGoogleWebFontFamily\":\"'Lato', 'sans-serif'\",\"djmenuGeneratedWebFont\":\"p30\",\"JMmoduleTitleFontSize\":\"20px\",\"headingsFontType\":\"3;headingsGeneratedWebFont\",\"headingsFontFamily\":\"Arial, Helvetica, sans-serif\",\"headingsCustomFont\":\"p30\",\"headingsGoogleWebFontUrl\":\"http:\\/\\/fonts.googleapis.com\\/css?family=Lato:400,300,300italic,400italic,700,700italic,900,900italic\",\"headingsGoogleWebFontFamily\":\"'Lato', 'sans-serif'\",\"headingsGeneratedWebFont\":\"p30\",\"JMarticleTitleFontSize\":\"32px\",\"articlesFontType\":\"3;articlesGeneratedWebFont\",\"articlesFontFamily\":\"Arial, Helvetica, sans-serif\",\"articlesCustomFont\":\"p30\",\"articlesGoogleWebFontUrl\":\"http:\\/\\/fonts.googleapis.com\\/css?family=Lato:400,300,300italic,400italic,700,700italic,900,900italic\",\"articlesGoogleWebFontFamily\":\"'Lato', 'sans-serif'\",\"articlesGeneratedWebFont\":\"p30\",\"advancedFontSize\":\"50px\",\"advancedFontType\":\"3;advancedGeneratedWebFont\",\"advancedFontFamily\":\"Arial, Helvetica, sans-serif\",\"advancedCustomFont\":\"p30\",\"advancedGoogleWebFontUrl\":\"\",\"advancedGoogleWebFontFamily\":\"\",\"advancedGeneratedWebFont\":\"p30\",\"advancedSelectors\":\"\",\"devmode\":\"1\",\"themermode\":\"1\",\"themerlogin\":\"1\",\"codeInjection\":\"<script><\\/script>\",\"cssCompress\":\"1\",\"jsCompress\":\"1\",\"skipCompress\":\"\",\"config\":\"\",\"JMbaseFontFamily\":\"p30\",\"JMmoduleTitleFontFamily\":\"p30\",\"JMtopmenuFontFamily\":\"p30\",\"JMarticleTitleFontFamily\":\"p30\"}"
                }
            }
        },
        "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"
        }
    }
}

معلومات الملف الشخصي

الوقت

الذاكرة

**الوقت**: 59.23 ms / 59.23 ms **الذاكرة**: 0.547 MB / 0.88 MB Application: afterLoad

**الوقت**: 4046.53 ms / 4105.76 ms **الذاكرة**: 2.520 MB / 3.40 MB Application: afterInitialise

**الوقت**: 118.28 ms / 4224.04 ms **الذاكرة**: 0.914 MB / 4.32 MB Application: afterRoute

**الوقت**: 0.26 ms / 4224.30 ms **الذاكرة**: 0.024 MB / 4.34 MB Application: beforeRenderComponent com_content

**الوقت**: 7.05 ms / 4231.36 ms **الذاكرة**: 0.052 MB / 4.39 MB Application: Before Access::preloadComponents (all components)

**الوقت**: 2.33 ms / 4233.69 ms **الذاكرة**: 0.061 MB / 4.45 MB Application: After Access::preloadComponents (all components)

**الوقت**: 0.03 ms / 4233.72 ms **الذاكرة**: -0.004 MB / 4.45 MB Application: Before Access::preloadPermissions (com_content)

**الوقت**: 1.53 ms / 4235.25 ms **الذاكرة**: 0.114 MB / 4.56 MB Application: After Access::preloadPermissions (com_content)

**الوقت**: 0.03 ms / 4235.28 ms **الذاكرة**: -0.007 MB / 4.56 MB Application: Before Access::getAssetRules (id:465 name:com_content.article.158)

**الوقت**: 1.22 ms / 4236.50 ms **الذاكرة**: 0.024 MB / 4.58 MB Application: After Access::getAssetRules (id:465 name:com_content.article.158)

**الوقت**: 142.80 ms / 4379.30 ms **الذاكرة**: 1.015 MB / 5.60 MB Application: afterRenderComponent com_content

**الوقت**: 17.67 ms / 4396.97 ms **الذاكرة**: 0.033 MB / 5.63 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**الوقت**: 0.11 ms / 4397.08 ms **الذاكرة**: 0.007 MB / 5.63 MB Application: After Access::getAssetRules (id:8 name:com_content)

**الوقت**: 2.82 ms / 4399.90 ms **الذاكرة**: 0.011 MB / 5.65 MB Application: afterDispatch

**الوقت**: 11.72 ms / 4411.62 ms **الذاكرة**: 0.113 MB / 5.76 MB Application: beforeRenderModule mod_currentdatetime (تاریخ و زمان فعلی)

**الوقت**: 9.61 ms / 4421.23 ms **الذاكرة**: 0.137 MB / 5.90 MB Application: afterRenderModule mod_currentdatetime (تاریخ و زمان فعلی)

**الوقت**: 1.70 ms / 4422.92 ms **الذاكرة**: 0.016 MB / 5.91 MB Application: beforeRenderModule mod_articles_popular (الأخبار الشعبية)

**الوقت**: 7.87 ms / 4430.80 ms **الذاكرة**: 0.172 MB / 6.08 MB Application: afterRenderModule mod_articles_popular (الأخبار الشعبية)

**الوقت**: 1.12 ms / 4431.91 ms **الذاكرة**: -0.128 MB / 5.96 MB Application: beforeRenderModule mod_jm_social_icons (الشبكات الاجتماعية)

**الوقت**: 1.81 ms / 4433.72 ms **الذاكرة**: 0.034 MB / 5.99 MB Application: afterRenderModule mod_jm_social_icons (الشبكات الاجتماعية)

**الوقت**: 0.74 ms / 4434.46 ms **الذاكرة**: -0.038 MB / 5.95 MB Application: beforeRenderModule mod_coalawebtraffic (إحصاءات الزيارة)

**الوقت**: 14.16 ms / 4448.62 ms **الذاكرة**: 0.122 MB / 6.08 MB Application: afterRenderModule mod_coalawebtraffic (إحصاءات الزيارة)

**الوقت**: 3.82 ms / 4452.45 ms **الذاكرة**: -0.047 MB / 6.03 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

**الوقت**: 2.49 ms / 4454.94 ms **الذاكرة**: 0.015 MB / 6.04 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

**الوقت**: 0.98 ms / 4455.91 ms **الذاكرة**: 0.000 MB / 6.04 MB Application: beforeRenderModule mod_djmenu (DJ-Menu-arabic)

**الوقت**: 5.02 ms / 4460.94 ms **الذاكرة**: 0.095 MB / 6.14 MB Application: afterRenderModule mod_djmenu (DJ-Menu-arabic)

**الوقت**: 0.55 ms / 4461.48 ms **الذاكرة**: -0.031 MB / 6.11 MB Application: beforeRenderModule mod_login (ورود)

**الوقت**: 6.99 ms / 4468.47 ms **الذاكرة**: 0.037 MB / 6.14 MB Application: afterRenderModule mod_login (ورود)

**الوقت**: 0.08 ms / 4468.55 ms **الذاكرة**: -0.002 MB / 6.14 MB Application: beforeRenderModule mod_languages (language)

**الوقت**: 7.21 ms / 4475.77 ms **الذاكرة**: 0.030 MB / 6.17 MB Application: afterRenderModule mod_languages (language)

**الوقت**: 7.13 ms / 4482.89 ms **الذاكرة**: 0.119 MB / 6.29 MB Application: afterRender

**كافة إستعلامات قاعدة البيانات: 3952.91 ms**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_session	const	PRIMARY	PRIMARY	194	const	1

#	المتصل	الملف ورقم السطر
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	*نفس الاستدعاء في خط أدناه.*
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	المتصل	الملف ورقم السطر
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3064313633623433613335663135633739666563316239636562343237613232', 1, 1714088817, 0, '', 0)**

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**وقت الإستعلام: 0.85 ms** **قبل آخر إستعلام: 15.03 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.535 MB** **إرجاع الصفوف: 5**

SELECT id, rules

  FROM `pdu4x_viewlevels`

**التوضيح**

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

**البروفايل**

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.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.04 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.95 ms** **قبل آخر إستعلام: 0.12 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 1.548 MB** **إرجاع الصفوف: 2**

SELECT b.id

  FROM pdu4x_usergroups AS a

  LEFT JOIN pdu4x_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

**التوضيح**

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	2	Using where; Using index

**البروفايل**

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.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.34 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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

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

#	المتصل	الملف ورقم السطر
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.63 ms** **قبل آخر إستعلام: 76.82 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.245 MB** **إرجاع الصفوف: 0**

SELECT ip

  FROM `pdu4x_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:106
8	plgSystemCwtrafficCount->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.43 ms** **قبل آخر إستعلام: 0.13 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.250 MB** **إرجاع الصفوف: 0**

SELECT botname

  FROM `pdu4x_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:126
8	plgSystemCwtrafficCount->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 134.47 ms** **قبل آخر إستعلام: 0.18 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.255 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic`

  WHERE ip = '3.142.250.114' 
  AND tm + '86400'>'1714088817'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_cwtraffic	index	NULL	unique_tm_ip	156	NULL	217372	Using where; Using index

**البروفايل**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	133.93 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:163
8	plgSystemCwtrafficCount->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.59 ms** **قبل آخر إستعلام: 0.32 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.261 MB**

INSERT INTO `pdu4x_cwtraffic`
(tm, ip, browser, bversion, platform, referer) 
  VALUES 
('1714088817','3.142.250.114','Mozilla','5.0','unknown','**-**')

**التوضيح**

**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_cwtraffic` (tm, ip, browser, bversion, platform, referer) VALUES ('1714088817','3.142.250.114','Mozilla','5.0','unknown','**-**')**

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:172
8	plgSystemCwtrafficCount->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 3720.67 ms** **قبل آخر إستعلام: 0.24 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.268 MB** **إرجاع الصفوف: 0**

SELECT id, 
  LEFT( tm, 9 ) , ip, count(*)

  FROM `pdu4x_cwtraffic`

  GROUP BY 
  LEFT( tm, 9 ) , ip

  HAVING count(*) > 1 
  LIMIT 50

**التوضيح**

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

**البروفايل**

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	190.24 ms
Converting HEAP to Aria	39.97 ms
Creating index	0.05 ms
Repair by sorting	81.04 ms
Saving state	0.05 ms
Creating index	0.01 ms
Converting HEAP to Aria	0.10 ms
Sending data	3299.69 ms
Creating sort index	71.81 ms
Removing tmp table	36.97 ms
Creating sort index	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:66
8	plgSystemCwtrafficClean->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.57 ms** **قبل آخر إستعلام: 0.21 ms** **إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 2.272 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic_whoisonline`

  WHERE ip = '59701874'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_cwtraffic_whoisonline	const	ip	ip	8	const	1	Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:75
8	plgSystemCwtrafficOnline->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.52 ms** **قبل آخر إستعلام: 0.21 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.277 MB**

INSERT INTO `pdu4x_cwtraffic_whoisonline`
(ip,country_name, country_code, city,  dt) 
  VALUES 
('59701874','unknown country','xx','unknown city',NOW())

**التوضيح**

**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_cwtraffic_whoisonline` (ip,country_name, country_code, city, dt) VALUES ('59701874','unknown country','xx','unknown city',NOW())**

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:106
8	plgSystemCwtrafficOnline->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.48 ms** **قبل آخر إستعلام: 0.12 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.282 MB**

DELETE 

  FROM `pdu4x_cwtraffic_whoisonline`

  WHERE dt < SUBTIME(NOW(),'0 0:10:0')

**التوضيح**

**التوضيح غير ممكن للإستعلام: DELETE FROM `pdu4x_cwtraffic_whoisonline` WHERE dt < SUBTIME(NOW(),'0 0:10:0')**

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/cwtrafficonline/cwtrafficonline.php:120
8	plgSystemCwtrafficOnline->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 7.45 ms** **قبل آخر إستعلام: 2.53 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.304 MB** **إرجاع الصفوف: 1**

SELECT timestamp

  FROM pdu4x_zt_visitor_counter

  WHERE ipaddress = '3.142.250.114' 
  AND useragent LIKE "%other%"

  ORDER BY timestamp DESC 
  LIMIT 1

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_zt_visitor_counter	index	NULL	timestamp	4	NULL	1	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/zt_visitor_counter/helper.php:65
9	plgZTVisitorCounterHelper::getLastVisit()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42
8	plgSystemZT_Visitor_Counter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 4.78 ms** **قبل آخر إستعلام: 0.27 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 2.309 MB**

INSERT INTO `pdu4x_zt_visitor_counter`
(`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) 
  VALUES 
(null, '1714089721', 1 , 1 , '3.142.250.114', 'other')

**التوضيح**

**التوضيح غير ممكن للإستعلام: INSERT INTO `pdu4x_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) VALUES (null, '1714089721', 1 , 1 , '3.142.250.114', 'other')**

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/zt_visitor_counter/helper.php:31
9	plgZTVisitorCounterHelper::addVisits()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:46
8	plgSystemZT_Visitor_Counter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.75 ms** **قبل آخر إستعلام: 0.28 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.314 MB** **إرجاع الصفوف: 0**

**الإستعلامات المتكررة**: #17 #18 #19

SELECT c.id

  FROM pdu4x_content AS c

  WHERE c.catid = '0' 
  AND c.publish_down != '0000-00-00 00:00:00' 
  AND c.publish_down <= '2024-04-25 23:47:01'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_catid	idx_catid	4	const	1	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/autoarchive/autoarchive.php:113
10	plgSystemAutoArchive->artRead()	JROOT/plugins/system/autoarchive/autoarchive.php:33
9	plgSystemAutoArchive->kat2kat()	JROOT/plugins/system/autoarchive/autoarchive.php:22
8	plgSystemAutoArchive->OnAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.50 ms** **قبل آخر إستعلام: 0.17 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 2.321 MB** **إرجاع الصفوف: 0**

**الإستعلامات المتكررة**: #16 #18 #19

SELECT c.id

  FROM pdu4x_content AS c

  WHERE c.catid = '0' 
  AND c.publish_down != '0000-00-00 00:00:00' 
  AND c.publish_down <= '2024-04-25 23:47:01'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_catid	idx_catid	4	const	1	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/autoarchive/autoarchive.php:113
10	plgSystemAutoArchive->artRead()	JROOT/plugins/system/autoarchive/autoarchive.php:82
9	plgSystemAutoArchive->kat2other()	JROOT/plugins/system/autoarchive/autoarchive.php:23
8	plgSystemAutoArchive->OnAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.54 ms** **قبل آخر إستعلام: 0.16 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.327 MB** **إرجاع الصفوف: 0**

**الإستعلامات المتكررة**: #16 #17 #19

SELECT c.id

  FROM pdu4x_content AS c

  WHERE c.catid = '0' 
  AND c.publish_down != '0000-00-00 00:00:00' 
  AND c.publish_down <= '2024-04-25 23:47:01'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_catid	idx_catid	4	const	1	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/autoarchive/autoarchive.php:113
10	plgSystemAutoArchive->artRead()	JROOT/plugins/system/autoarchive/autoarchive.php:82
9	plgSystemAutoArchive->kat2other()	JROOT/plugins/system/autoarchive/autoarchive.php:24
8	plgSystemAutoArchive->OnAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.49 ms** **قبل آخر إستعلام: 0.16 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 2.333 MB** **إرجاع الصفوف: 0**

**الإستعلامات المتكررة**: #16 #17 #18

SELECT c.id

  FROM pdu4x_content AS c

  WHERE c.catid = '0' 
  AND c.publish_down != '0000-00-00 00:00:00' 
  AND c.publish_down <= '2024-04-25 23:47:01'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_catid	idx_catid	4	const	1	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/autoarchive/autoarchive.php:113
10	plgSystemAutoArchive->artRead()	JROOT/plugins/system/autoarchive/autoarchive.php:82
9	plgSystemAutoArchive->kat2other()	JROOT/plugins/system/autoarchive/autoarchive.php:25
8	plgSystemAutoArchive->OnAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.49 ms** **قبل آخر إستعلام: 42.10 ms** **إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 3.616 MB** **إرجاع الصفوف: 2**

SHOW FULL COLUMNS 
  FROM `pdu4x_komento_configs`

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.77 ms** **قبل آخر إستعلام: 1.11 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 3.632 MB** **إرجاع الصفوف: 1**

SELECT *

  FROM pdu4x_komento_configs

  WHERE `component` = 'com_komento'

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.17 ms** **قبل آخر إستعلام: 24.31 ms** **إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 4.061 MB** **إرجاع الصفوف: 0**

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 `pdu4x_categories` AS `s`

  INNER JOIN `pdu4x_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ar-AA','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 158

  ORDER BY c.lft

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**البروفايل**

Status	Duration
Starting	0.18 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.10 ms
Optimizing	0.06 ms
Statistics	0.36 ms
Preparing	0.02 ms
Executing	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.76 ms** **قبل آخر إستعلام: 0.11 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.066 MB** **إرجاع الصفوف: 1**

SELECT `alias`,`catid`

  FROM `pdu4x_content`

  WHERE `id` = 158

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 2.09 ms** **قبل آخر إستعلام: 0.48 ms** **إستعلام الذاكرة: 0.053 MB الذاكرة بعد الإستعلام: 4.074 MB** **إرجاع الصفوف: 12**

SELECT id, home, template, s.params

  FROM pdu4x_template_styles as s

  LEFT JOIN pdu4x_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ref\|filter	idx_template,idx_client_id,idx_client_id_home	idx_template\|idx_client_id	202\|1	javanma2_asli.e.element	1 (86%)	Using index condition; Using where; Using rowid filter

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jmframework/jmframework.php:402
9	plgSystemJMFramework->getTemplateName()	JROOT/plugins/system/jmframework/jmframework.php:92
8	plgSystemJMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 5.65 ms** **قبل آخر إستعلام: 16.16 ms** **إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 4.177 MB**

UPDATE `pdu4x_extensions`

  SET `params` = '{\"mediaversion\":\"f6a0eab61e0e93feb5c7162237ad925a\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**التوضيح**

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

**البروفايل**

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	1.79 ms
Updating	0.31 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	3.12 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	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/jmframework/jmframework.php:127
8	plgSystemJMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 4.65 ms** **قبل آخر إستعلام: 30.47 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 4.339 MB** **إرجاع الصفوف: 12**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM pdu4x_modules AS m

  LEFT JOIN pdu4x_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN pdu4x_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-25 23:47:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 23:47:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 954 OR mm.menuid <= 0) 
  AND m.language IN ('ar-AA','*')

  ORDER BY m.position, m.ordering

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	81	Using index condition; Using where; استعمال ترتيب الملفات
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	javanma2_asli.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	javanma2_asli.m.id	1	Using where; Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	*نفس الاستدعاء في خط أدناه.*
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:257
12	JMFTemplate->countModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:253
11	JMFTemplate->checkModules()	JROOT/templates/jm-services/lib/jm_template.php:19
10	JMTemplate->postSetUp()	JROOT/plugins/system/jmframework/includes/libraries/template.php:106
9	JMFTemplate->__construct()	JROOT/plugins/system/jmframework/jmframework.php:129
8	plgSystemJMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 2.07 ms** **قبل آخر إستعلام: 8.01 ms** **إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 4.395 MB** **إرجاع الصفوف: 45**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `pdu4x_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_egoltarchive','com_fields','com_finder','com_installer','com_jalaliarchive','com_jimigrator','com_joominastat','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.25 ms** **قبل آخر إستعلام: 0.23 ms** **إستعلام الذاكرة: 0.034 MB الذاكرة بعد الإستعلام: 4.450 MB** **إرجاع الصفوف: 118**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `pdu4x_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_assets	ALL	idx_asset_name,idx_parent_id	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	378	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.50 ms** **قبل آخر إستعلام: 2.55 ms** **إستعلام الذاكرة: 0.031 MB الذاكرة بعد الإستعلام: 4.583 MB** **إرجاع الصفوف: 31**

SHOW FULL COLUMNS 
  FROM `pdu4x_content`

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 3.71 ms** **قبل آخر إستعلام: 6.10 ms** **إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 4.702 MB**

UPDATE pdu4x_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '158'

**التوضيح**

**التوضيح غير ممكن للإستعلام: UPDATE pdu4x_content SET `hits` = (`hits` + 1) WHERE `id` = '158'**

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.55 ms** **قبل آخر إستعلام: 4.45 ms** **إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.748 MB** **إرجاع الصفوف: 1**

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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

  FROM pdu4x_content AS a

  INNER JOIN pdu4x_categories AS c 
  on c.id = a.catid

  LEFT JOIN pdu4x_users AS u 
  on u.id = a.created_by

  LEFT JOIN pdu4x_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN pdu4x_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 158 
  AND c.published > 0 
  AND a.language in ('ar-AA','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 23:47:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 23:47:01') 
  AND (a.state = 1 OR a.state =2)

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.60 ms** **قبل آخر إستعلام: 3.85 ms** **إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 4.845 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 `pdu4x_categories` AS `s`

  INNER JOIN `pdu4x_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ar-AA','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 97

  ORDER BY c.lft

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	82	Using where; استعمال ترتيب الملفات

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	*نفس الاستدعاء في خط أدناه.*
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.26 ms** **قبل آخر إستعلام: 1.35 ms** **إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 4.876 MB** **إرجاع الصفوف: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `pdu4x_contentitem_tag_map` AS m 

  INNER JOIN `pdu4x_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 158 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	12	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	javanma2_asli.t.id	8	Using index condition; Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 3.71 ms** **قبل آخر إستعلام: 23.64 ms** **إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 5.011 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 pdu4x_fields AS a

  LEFT JOIN `pdu4x_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN pdu4x_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN pdu4x_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN pdu4x_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN pdu4x_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `pdu4x_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (97,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','ar-AA')

  ORDER BY a.ordering ASC

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	javanma2_asli.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	javanma2_asli.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	javanma2_asli.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	javanma2_asli.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	javanma2_asli.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	javanma2_asli.a.id	1	Using where; Using index; Distinct

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 2.79 ms** **قبل آخر إستعلام: 13.48 ms** **إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 5.135 MB** **إرجاع الصفوف: 10**

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM pdu4x_content AS a

  LEFT JOIN pdu4x_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 97 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-25 23:47:01') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-25 23:47:01') 
  AND a.language in ('ar-AA','*')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_access,idx_state,idx_catid,idx_language	idx_language	28	NULL	23	Using index condition; Using where; استعمال ترتيب الملفات
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.48 ms** **قبل آخر إستعلام: 3.91 ms** **إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 5.171 MB** **إرجاع الصفوف: 1**

SELECT *

  FROM pdu4x_komento_configs

  WHERE `component` = 'com_content'

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
19	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:202
18	Komento::getConfig()	JROOT/components/com_komento/komento_plugins/com_content.php:225
17	KomentoComcontent->onBeforeLoad()	JROOT/components/com_komento/helpers/helper.php:688
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.60 ms** **قبل آخر إستعلام: 1.64 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 5.202 MB** **إرجاع الصفوف: 1**

SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `pdu4x_content` AS a 
  LEFT JOIN `pdu4x_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `pdu4x_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `pdu4x_categories` AS parent 
  ON parent.id = c.parent_id 
  WHERE a.id = '158'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/komento_plugins/com_content.php:54
17	KomentoComcontent->load()	JROOT/components/com_komento/helpers/helper.php:743
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.39 ms** **قبل آخر إستعلام: 3.21 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 5.218 MB** **إرجاع الصفوف: 0**

SELECT `id` 
  FROM `pdu4x_komento_mailq` 
  WHERE `status` = '0' 
  ORDER BY `created` ASC 
  LIMIT 0, 5

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_komento_mailq	ref	komento_mailq_status	komento_mailq_status	1	const	1	Using where; استعمال ترتيب الملفات

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
21	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
20	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
19	KomentoSql->__call()	JROOT/components/com_komento/classes/mailqueue.php:49
18	KomentoMailQueue->send()	JROOT/components/com_komento/classes/mailqueue.php:24
17	KomentoMailQueue->sendOnPageLoad()	JROOT/components/com_komento/helpers/helper.php:848
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.79 ms** **قبل آخر إستعلام: 2.78 ms** **إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 5.307 MB** **إرجاع الصفوف: 1**

SELECT `rules` 
  FROM `pdu4x_komento_acl` 
  WHERE `cid` = '9' 
  AND `type` = 'usergroup' 
  AND `component` = 'com_content' 
  ORDER BY `id` ASC

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_komento_acl	index	komento_acl_content_type	PRIMARY	8	NULL	9	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
21	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
20	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:133
19	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:246
18	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:31
17	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:858
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.49 ms** **قبل آخر إستعلام: 0.19 ms** **إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 5.321 MB** **إرجاع الصفوف: 0**

SELECT `rules` 
  FROM `pdu4x_komento_acl` 
  WHERE `cid` = '0' 
  AND `type` = 'user' 
  AND `component` = 'com_content' 
  ORDER BY `id` ASC

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_komento_acl	ref	komento_acl_content_type	komento_acl_content_type	767	const	1	Using index condition; Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
21	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
20	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:137
19	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:246
18	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:31
17	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:858
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.10 ms** **قبل آخر إستعلام: 28.18 ms** **إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 5.490 MB** **إرجاع الصفوف: 1**

SELECT COUNT(1) 
  FROM `pdu4x_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '158' 
  AND `published` = '1'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using where; Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:73
17	KomentoModelComments->getCount()	JROOT/components/com_komento/helpers/helper.php:869
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.66 ms** **قبل آخر إستعلام: 0.19 ms** **إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 5.499 MB** **إرجاع الصفوف: 1**

SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total` 
  FROM `pdu4x_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '158' 
  AND `published` = '1' 
  AND `ratings` !='' 
  ORDER BY `created` ASC 
  LIMIT 0,10

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:108
17	KomentoModelComments->getOverallRatings()	JROOT/components/com_komento/helpers/helper.php:872
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.72 ms** **قبل آخر إستعلام: 0.32 ms** **إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 5.511 MB** **إرجاع الصفوف: 0**

SELECT * 
  FROM `pdu4x_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '158' 
  AND `published` = '1' 
  ORDER BY `lft` ASC 
  LIMIT 0,10

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; Using where

**البروفايل**

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.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	المتصل	الملف ورقم السطر
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:146
17	KomentoModelComments->getComments()	JROOT/components/com_komento/helpers/helper.php:964
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.61 ms** **قبل آخر إستعلام: 13.71 ms** **إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 5.583 MB** **إرجاع الصفوف: 1**

SELECT COUNT(1) 
  FROM `pdu4x_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '158' 
  AND `published` = '1' 
  AND `sticked` = '1'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:73
21	KomentoModelComments->getCount()	JROOT/components/com_komento/themes/kuro/comment/famelist.php:29
20	include JROOT/components/com_komento/themes/kuro/comment/famelist.php	JROOT/components/com_komento/classes/themes.php:128
19	KomentoThemes->fetch()	JROOT/components/com_komento/themes/kuro/comment/box.php:58
18	include JROOT/components/com_komento/themes/kuro/comment/box.php	JROOT/components/com_komento/classes/themes.php:128
17	KomentoThemes->fetch()	JROOT/components/com_komento/helpers/helper.php:982
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 2.20 ms** **قبل آخر إستعلام: 0.12 ms** **إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 5.595 MB** **إرجاع الصفوف: 1**

SELECT COUNT(1) 
  FROM (SELECT comments.*, COUNT(actions.comment_id) AS likes 
  FROM `pdu4x_komento_comments` AS comments 
  LEFT JOIN `pdu4x_komento_actions` AS actions 
  ON comments.id = actions.comment_id 
  WHERE comments.component = 'com_content' 
  AND comments.cid IN (158) 
  AND comments.published = '1' 
  AND actions.type = 'likes' 
  GROUP BY actions.comment_id) AS x

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	2
2	DERIVED	comments	ref	PRIMARY,komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; Using where; Using temporary; استعمال ترتيب الملفات
2	DERIVED	actions	ref	komento_actions,komento_actions_comment_id	komento_actions	70	const,javanma2_asli.comments.id	1	Using where; Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:1216
21	KomentoModelComments->getTotalPopularComments()	JROOT/components/com_komento/themes/kuro/comment/famelist.php:32
20	include JROOT/components/com_komento/themes/kuro/comment/famelist.php	JROOT/components/com_komento/classes/themes.php:128
19	KomentoThemes->fetch()	JROOT/components/com_komento/themes/kuro/comment/box.php:58
18	include JROOT/components/com_komento/themes/kuro/comment/box.php	JROOT/components/com_komento/classes/themes.php:128
17	KomentoThemes->fetch()	JROOT/components/com_komento/helpers/helper.php:982
16	Komento::commentify()	JROOT/plugins/content/komento/komento.php:166
15	plgContentKomento->execute()	JROOT/plugins/content/komento/komento.php:80
14	plgContentKomento->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 13.21 ms** **قبل آخر إستعلام: 10.72 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 5.600 MB** **إرجاع الصفوف: 5**

SELECT language,id

  FROM `pdu4x_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_menu	ALL	idx_client_id_parent_id_alias_language	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	916	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.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	5.92 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	6.72 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.58 ms** **قبل آخر إستعلام: 0.63 ms** **إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 5.610 MB** **إرجاع الصفوف: 1**

SELECT `alias`

  FROM `pdu4x_content`

  WHERE id = '158'

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	*نفس الاستدعاء في خط أدناه.*
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.55 ms** **قبل آخر إستعلام: 0.26 ms** **إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 5.618 MB** **إرجاع الصفوف: 1**

SELECT alias

  FROM pdu4x_content

  WHERE id=158

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.94 ms** **قبل آخر إستعلام: 3.52 ms** **إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 5.640 MB** **إرجاع الصفوف: 0**

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `pdu4x_content` AS `c`

  INNER JOIN `pdu4x_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `pdu4x_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `pdu4x_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `pdu4x_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 158 
  AND c2.access IN (1,1,5) 
  AND c2.language != 'ar-AA' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-04-25 23:47:01') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-04-25 23:47:01') 
  AND c2.state = 1

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 1.80 ms** **قبل آخر إستعلام: 27.85 ms** **إستعلام الذاكرة: 0.068 MB الذاكرة بعد الإستعلام: 5.948 MB** **إرجاع الصفوف: 8**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM pdu4x_content AS a

  LEFT JOIN pdu4x_categories AS c 
  ON c.id = a.catid

  LEFT JOIN pdu4x_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN pdu4x_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN pdu4x_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN pdu4x_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (97) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 23:47:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 23:47:01') 
  AND a.language IN ('ar-AA','*')

  ORDER BY a.hits DESC 
  LIMIT 8

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	range	idx_access,idx_state,idx_catid,idx_language	idx_language	28	NULL	23	Using index condition; Using where; استعمال ترتيب الملفات
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	javanma2_asli.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	javanma2_asli.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	javanma2_asli.a.id	1	Using where

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
22	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
21	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
20	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	*نفس الاستدعاء في خط أدناه.*
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:606
16	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.45 ms** **قبل آخر إستعلام: 7.37 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 5.990 MB** **إرجاع الصفوف: 1**

SELECT TCOUNT

  FROM `pdu4x_cwtraffic_total`

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:80
18	mod_coalawebtrafficHelper->read()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.29 ms** **قبل آخر إستعلام: 0.12 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.000 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic`

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:87
18	mod_coalawebtrafficHelper->read()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.50 ms** **قبل آخر إستعلام: 0.12 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.011 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic`

  WHERE tm > '1714077000'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	38	Using where; Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:97
18	mod_coalawebtrafficHelper->read()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.78 ms** **قبل آخر إستعلام: 0.13 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.021 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic`

  WHERE tm > '1713990600' 
  AND tm < '1714077000'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	178	Using where; Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:106
18	mod_coalawebtrafficHelper->read()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 2.08 ms** **قبل آخر إستعلام: 0.16 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.031 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic`

  WHERE tm >= '1713558600'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	1279	Using where; Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:114
18	mod_coalawebtrafficHelper->read()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 5.49 ms** **قبل آخر إستعلام: 0.12 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.042 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic`

  WHERE tm >= '1711917000'

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pdu4x_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	4147	Using where; Using index

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:122
18	mod_coalawebtrafficHelper->read()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:69
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.29 ms** **قبل آخر إستعلام: 0.30 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.061 MB** **إرجاع الصفوف: 1**

SELECT count(*)

  FROM `pdu4x_cwtraffic_whoisonline`

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/modules/mod_coalawebtraffic/helper.php:137
18	mod_coalawebtrafficHelper::getRealCount()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:124
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.60 ms** **قبل آخر إستعلام: 0.11 ms** **إستعلام الذاكرة: 0.026 MB الذاكرة بعد الإستعلام: 6.073 MB** **إرجاع الصفوف: 1**

SELECT a.country_code, a.country_name, COUNT(1) as num

  FROM `pdu4x_cwtraffic_whoisonline` AS `a`

  WHERE `a`.`country_code` IS NOT NULL 

  GROUP BY a.country_code, a.country_name

  ORDER BY `num` DESC  
  LIMIT 5

**التوضيح**

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

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_coalawebtraffic/helper.php:153
18	mod_coalawebtrafficHelper::getCountries()	JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php:125
17	include JROOT/modules/mod_coalawebtraffic/mod_coalawebtraffic.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/template.php:429
14	JMFTemplate->renderModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:563
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-services/tpl/blocks/footer-mod.php:16
12	include JROOT/templates/jm-services/tpl/blocks/footer-mod.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
11	JMFTemplate->renderBlock()	JROOT/templates/jm-services/tpl/default.php:38
10	include JROOT/templates/jm-services/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:386
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:393
8	JMFTemplate->renderScheme()	JROOT/templates/jm-services/index.php:19
7	require JROOT/templates/jm-services/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**وقت الإستعلام: 0.71 ms** **قبل آخر إستعلام: 24.42 ms** **إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 6.173 MB** **إرجاع الصفوف: 0**

SELECT `c2`.`language`,`c2`.`id`

  FROM `pdu4x_menu` AS `c`

  INNER JOIN `pdu4x_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `pdu4x_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `pdu4x_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 954

**التوضيح**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**البروفايل**

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

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

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

**5 × SELECT count(*) 
  FROM `pdu4x_cwtraffic` **

**4 × SELECT c.id 
  FROM pdu4x_content AS c **

**2 × SELECT COUNT(1) 
  FROM `pdu4x_komento_comments` **

**2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `pdu4x_assets` **

**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 `pdu4x_categories` AS `s` 
  INNER JOIN `pdu4x_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ar-AA','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt) **

**2 × SELECT * 
  FROM pdu4x_komento_configs **

**2 × SELECT `rules` 
  FROM `pdu4x_komento_acl` **

**1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM pdu4x_content AS a 
  LEFT JOIN pdu4x_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN pdu4x_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN pdu4x_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN pdu4x_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pdu4x_content_rating AS v 
  ON a.id = v.content_id **

**1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `pdu4x_content` AS `c` 
  INNER JOIN `pdu4x_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `pdu4x_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `pdu4x_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `pdu4x_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content' **

**1 × SELECT alias 
  FROM pdu4x_content **

**1 × SELECT `id` 
  FROM `pdu4x_komento_mailq` **

**1 × SELECT TCOUNT 
  FROM `pdu4x_cwtraffic_total **

**1 × SELECT count(*) 
  FROM `pdu4x_cwtraffic **

**1 × SELECT `alias` 
  FROM `pdu4x_content` **

**1 × SELECT language,id 
  FROM `pdu4x_menu` **

**1 × SELECT COUNT(1) 
  FROM (SELECT comments.*, COUNT(actions.comment_id) AS likes 
  FROM `pdu4x_komento_comments` AS comments 
  LEFT JOIN `pdu4x_komento_actions` AS actions 
  ON comments.id = actions.comment_id **

**1 × SELECT count(*) 
  FROM `pdu4x_cwtraffic_whoisonline **

**1 × SELECT * 
  FROM `pdu4x_komento_comments` **

**1 × SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total` 
  FROM `pdu4x_komento_comments` **

**1 × SELECT a.country_code, a.country_name, COUNT(1) as num 
  FROM `pdu4x_cwtraffic_whoisonline` AS `a` **

**1 × SELECT `data` 
  FROM `pdu4x_session` **

**1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM pdu4x_fields AS a 
  LEFT JOIN `pdu4x_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN pdu4x_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN pdu4x_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN pdu4x_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN pdu4x_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `pdu4x_fields_categories` AS fc 
  ON fc.field_id = a.id **

**1 × SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `pdu4x_content` AS a 
  LEFT JOIN `pdu4x_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `pdu4x_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `pdu4x_categories` AS parent 
  ON parent.id = c.parent_id **

**1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM pdu4x_content AS a 
  LEFT JOIN pdu4x_categories AS cc 
  ON cc.id = a.catid **

**1 × SELECT `session_id` 
  FROM `pdu4x_session` **

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `pdu4x_contentitem_tag_map` AS m  
  INNER JOIN `pdu4x_tags` AS t  
  ON `m`.`tag_id` = `t`.`id` **

**1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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 
  FROM pdu4x_content AS a 
  INNER JOIN pdu4x_categories AS c 
  on c.id = a.catid 
  LEFT JOIN pdu4x_users AS u 
  on u.id = a.created_by 
  LEFT JOIN pdu4x_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pdu4x_content_rating AS v 
  ON a.id = v.content_id **

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pdu4x_modules AS m 
  LEFT JOIN pdu4x_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pdu4x_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id **

**1 × SELECT id, home, template, s.params 
  FROM pdu4x_template_styles as s 
  LEFT JOIN pdu4x_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id **

**1 × SELECT `alias`,`catid` 
  FROM `pdu4x_content` **

**1 × SELECT timestamp 
  FROM pdu4x_zt_visitor_counter **

**1 × SELECT count(*) 
  FROM `pdu4x_cwtraffic_whoisonline` **

**1 × SELECT id, 
  LEFT( tm, 9 ) , ip, count(*) 
  FROM `pdu4x_cwtraffic` 
  GROUP BY 
  LEFT( tm, 9 ) , ip 
  HAVING count(*) > 1 
  LIMIT 5 **

**1 × SELECT botname 
  FROM `pdu4x_cwtraffic_knownips` **

**1 × SELECT ip 
  FROM `pdu4x_cwtraffic_knownips` **

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

**1 × SELECT id, rules 
  FROM `pdu4x_viewlevels **

**1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `pdu4x_menu` AS `c` 
  INNER JOIN `pdu4x_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `pdu4x_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `pdu4x_menu` AS `c2` 
  ON a2.id = c2.`id` **

جداول أخرى:

**1 × INSERT INTO `pdu4x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3064313633623433613335663135633739666563316239636562343237613232', 1, 1714088817, 0, '', 0 **

**1 × INSERT INTO `pdu4x_cwtraffic` (tm, ip, browser, bversion, platform, referer) 
  VALUES  ('1714088817','3.142.250.114','Mozilla','5.0','unknown','**-**' **

**1 × INSERT INTO `pdu4x_cwtraffic_whoisonline` (ip,country_name, country_code, city,  dt) 
  VALUES  ('59701874','unknown country','xx','unknown city',NOW() **

**1 × DELETE  
  FROM `pdu4x_cwtraffic_whoisonline` **

**1 × INSERT INTO `pdu4x_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) 
  VALUES  (null, '1714089721', 1 , 1 , '3.142.250.114', 'other' **

**1 × SHOW FULL COLUMNS 
  FROM `pdu4x_komento_configs **

**1 × UPDATE `pdu4x_extensions` 
  SET `params` = '{\"mediaversion\":\"f6a0eab61e0e93feb5c7162237ad925a\"}' **

**1 × SHOW FULL COLUMNS 
  FROM `pdu4x_content **

**1 × UPDATE pdu4x_content 
  SET `hits` = (`hits` + 1) **

تحليل الأخطاء في ملفات اللغة

ملفات اللغة محملة

**تحميل** : JROOT/language/ar-AA/ar-AA.ini
**تحميل** : JROOT/language/ar-AA/ar-AA.lib_joomla.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_cwtrafficcount.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/plg_system_cwtrafficcount.ini
**لم يتم تحميل** : JROOT/plugins/system/cwtrafficcount/language/ar-AA/ar-AA.plg_system_cwtrafficcount.ini
**لم يتم تحميل** : JROOT/plugins/system/cwtrafficcount/language/ar-AA/plg_system_cwtrafficcount.ini
**لم يتم تحميل** : JROOT/language/ar-AA/ar-AA.com_coalawebtraffic.ini
**لم يتم تحميل** : JROOT/language/ar-AA/com_coalawebtraffic.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_cwtrafficclean.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/plg_system_cwtrafficclean.ini
**لم يتم تحميل** : JROOT/plugins/system/cwtrafficclean/language/ar-AA/ar-AA.plg_system_cwtrafficclean.ini
**لم يتم تحميل** : JROOT/plugins/system/cwtrafficclean/language/ar-AA/plg_system_cwtrafficclean.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_cwtrafficonline.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/plg_system_cwtrafficonline.ini
**لم يتم تحميل** : JROOT/plugins/system/cwtrafficonline/language/ar-AA/ar-AA.plg_system_cwtrafficonline.ini
**لم يتم تحميل** : JROOT/plugins/system/cwtrafficonline/language/ar-AA/plg_system_cwtrafficonline.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_cwgears.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/plg_system_cwgears.ini
**لم يتم تحميل** : JROOT/plugins/system/cwgears/language/ar-AA/ar-AA.plg_system_cwgears.ini
**لم يتم تحميل** : JROOT/plugins/system/cwgears/language/ar-AA/plg_system_cwgears.ini
**تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_updatenotification.ini
**تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_fields.ini
**تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_logrotation.ini
**تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_logout.ini
**لم يتم تحميل** : JROOT/language/ar-AA/ar-AA.lib_egoltframework.ini
**لم يتم تحميل** : JROOT/language/ar-AA/lib_egoltframework.ini
**لم يتم تحميل** : JROOT/language/ar-AA/ar-AA.com_komento.ini
**لم يتم تحميل** : JROOT/language/ar-AA/com_komento.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_jmframework.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/plg_system_jmframework.ini
**لم يتم تحميل** : JROOT/plugins/system/jmframework/language/ar-AA/ar-AA.plg_system_jmframework.ini
**لم يتم تحميل** : JROOT/plugins/system/jmframework/language/ar-AA/plg_system_jmframework.ini
**لم يتم تحميل** : JROOT/administrator/language/en-GB/en-GB.tpl_jm-services.ini
**لم يتم تحميل** : JROOT/administrator/language/en-GB/tpl_jm-services.ini
**تحميل** : JROOT/templates/jm-services/language/en-GB/en-GB.tpl_jm-services.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.tpl_jm-services.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/tpl_jm-services.ini
**لم يتم تحميل** : JROOT/templates/jm-services/language/ar-AA/ar-AA.tpl_jm-services.ini
**لم يتم تحميل** : JROOT/templates/jm-services/language/ar-AA/tpl_jm-services.ini
**لم يتم تحميل** : JROOT/language/ar-AA/ar-AA.tpl_jm-services.ini
**لم يتم تحميل** : JROOT/language/ar-AA/tpl_jm-services.ini
**تحميل** : JROOT/language/ar-AA/ar-AA.com_content.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_content_phocadownload.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/plg_content_phocadownload.ini
**لم يتم تحميل** : JROOT/plugins/content/phocadownload/language/ar-AA/ar-AA.plg_content_phocadownload.ini
**لم يتم تحميل** : JROOT/plugins/content/phocadownload/language/ar-AA/plg_content_phocadownload.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_content_simplepopup.ini
**لم يتم تحميل** : JROOT/administrator/language/ar-AA/plg_content_simplepopup.ini
**لم يتم تحميل** : JROOT/plugins/content/simplepopup/language/ar-AA/ar-AA.plg_content_simplepopup.ini
**لم يتم تحميل** : JROOT/plugins/content/simplepopup/language/ar-AA/plg_content_simplepopup.ini
**تحميل** : JROOT/language/ar-AA/ar-AA.mod_currentdatetime.ini
**تحميل** : JROOT/modules/mod_currentdatetime/language/ar-AA/ar-AA.mod_currentdatetime.ini
**تحميل** : JROOT/language/ar-AA/ar-AA.mod_articles_popular.ini
**لم يتم تحميل** : JROOT/language/ar-AA/ar-AA.mod_jm_social_icons.ini
**لم يتم تحميل** : JROOT/language/ar-AA/mod_jm_social_icons.ini
**لم يتم تحميل** : JROOT/modules/mod_jm_social_icons/language/ar-AA/ar-AA.mod_jm_social_icons.ini
**لم يتم تحميل** : JROOT/modules/mod_jm_social_icons/language/ar-AA/mod_jm_social_icons.ini
**لم يتم تحميل** : JROOT/language/ar-AA/ar-AA.mod_coalawebtraffic.ini
**لم يتم تحميل** : JROOT/language/ar-AA/mod_coalawebtraffic.ini
**لم يتم تحميل** : JROOT/modules/mod_coalawebtraffic/language/ar-AA/ar-AA.mod_coalawebtraffic.ini
**لم يتم تحميل** : JROOT/modules/mod_coalawebtraffic/language/ar-AA/mod_coalawebtraffic.ini
**تحميل** : JROOT/language/ar-AA/ar-AA.mod_breadcrumbs.ini
**لم يتم تحميل** : JROOT/language/ar-AA/ar-AA.mod_djmenu.ini
**لم يتم تحميل** : JROOT/language/ar-AA/mod_djmenu.ini
**لم يتم تحميل** : JROOT/modules/mod_djmenu/language/ar-AA/ar-AA.mod_djmenu.ini
**لم يتم تحميل** : JROOT/modules/mod_djmenu/language/ar-AA/mod_djmenu.ini
**تحميل** : JROOT/language/ar-AA/ar-AA.mod_login.ini
**تحميل** : JROOT/language/ar-AA/ar-AA.mod_languages.ini
**تحميل** : JROOT/administrator/language/ar-AA/ar-AA.plg_system_debug.ini

المصفوفات الغير مترجمة


# JROOT/libraries/src/Language/Text.php

COM_KOMENTO_COMMENTS="KOMENTO COMMENTS"
COM_KOMENTO_COMMENTS_NO_COMMENT="KOMENTO COMMENTS NO COMMENT"
COM_KOMENTO_COMMENT_WHERE_ARE_YOU="KOMENTO COMMENT WHERE ARE YOU"
COM_KOMENTO_FORM_CHARACTER_BETWEEN="KOMENTO FORM CHARACTER BETWEEN"
COM_KOMENTO_FORM_CHARACTER_RESTRICTION="KOMENTO FORM CHARACTER RESTRICTION"
COM_KOMENTO_FORM_EMAIL="KOMENTO FORM EMAIL"
COM_KOMENTO_FORM_LEAVE_YOUR_COMMENTS="KOMENTO FORM LEAVE YOUR COMMENTS"
COM_KOMENTO_FORM_LOCATION_AUTODETECT="KOMENTO FORM LOCATION AUTODETECT"
COM_KOMENTO_FORM_NAME="KOMENTO FORM NAME"
COM_KOMENTO_FORM_POST_COMMENT_AS_GUEST="KOMENTO FORM POST COMMENT AS GUEST"
COM_KOMENTO_FORM_REQUIRED="KOMENTO FORM REQUIRED"
COM_KOMENTO_FORM_SUBMIT="KOMENTO FORM SUBMIT"
COM_KOMENTO_FORM_USER_COMMENTS_WILL_BE_MODERATED="KOMENTO FORM USER COMMENTS WILL BE MODERATED"
COM_KOMENTO_FORM_WEBSITE="KOMENTO FORM WEBSITE"
COM_KOMENTO_GUEST="KOMENTO GUEST"
COM_KOMENTO_LOVIES_TITLE="KOMENTO LOVIES TITLE"
COM_KOMENTO_SORT_LATEST="KOMENTO SORT LATEST"
COM_KOMENTO_SORT_OLDEST="KOMENTO SORT OLDEST"
COM_KOMENTO_STICKIES_TITLE="KOMENTO STICKIES TITLE"
COM_KOMENTO_SUBSCRIBE_EMAIL="KOMENTO SUBSCRIBE EMAIL"
MOD_CWTRAFFIC_HORTEXT="CWTRAFFIC HORTEXT"
MOD_CWTRAFFIC_MONTH="CWTRAFFIC MONTH"
MOD_CWTRAFFIC_POWERED="CWTRAFFIC POWERED"
MOD_CWTRAFFIC_SUBTITLE_WHO="CWTRAFFIC SUBTITLE WHO"
MOD_CWTRAFFIC_TITLE_VISITOR="CWTRAFFIC TITLE VISITOR"
MOD_CWTRAFFIC_TITLE_WHO="CWTRAFFIC TITLE WHO"
MOD_CWTRAFFIC_TODAY="CWTRAFFIC TODAY"
MOD_CWTRAFFIC_TOTAL="CWTRAFFIC TOTAL"
MOD_CWTRAFFIC_VISITOR_IP="CWTRAFFIC VISITOR IP"
MOD_CWTRAFFIC_V_BROWSER="CWTRAFFIC V BROWSER"
MOD_CWTRAFFIC_V_BROWSER_VERSION="CWTRAFFIC V BROWSER VERSION"
MOD_CWTRAFFIC_V_OS="CWTRAFFIC V OS"
MOD_CWTRAFFIC_WEEK="CWTRAFFIC WEEK"
MOD_CWTRAFFIC_YESTERDAY="CWTRAFFIC YESTERDAY"
PLG_SYSTEM_JMFRAMEWORK_THEMER_WAIT="SYSTEM JMFRAMEWORK THEMER WAIT"
PLG_SYSTEM_JMFRAMEWORK_THEMER_WAIT_APPLYING="SYSTEM JMFRAMEWORK THEMER WAIT APPLYING"
PLG_SYSTEM_JMFRAMEWORK_THEMER_WAIT_RELOADING="SYSTEM JMFRAMEWORK THEMER WAIT RELOADING"
PLG_SYSTEM_JMFRAMEWORK_THEMER_WAIT_SAVING="SYSTEM JMFRAMEWORK THEMER WAIT SAVING"
PLG_SYSTEM_JMFRAMEWORK_THEME_ACCESS_ERROR="SYSTEM JMFRAMEWORK THEME ACCESS ERROR"
PLG_SYSTEM_JMFRAMEWORK_THEME_BAD_REQUEST_ERROR="SYSTEM JMFRAMEWORK THEME BAD REQUEST ERROR"
PLG_SYSTEM_JMFRAMEWORK_THEME_LOGIN_ERROR="SYSTEM JMFRAMEWORK THEME LOGIN ERROR"