القس هيثم حلاوي

آية الأسبوع

"بِسَلاَمَةٍ أَضْطَجعُ بَلْ أَيْضًا أَنَامُ، لأَنَّكَ أَنْتَ يَا رَبُّ مُنْفَرِدًا فِي طُمَأْنِينَةٍ تُسَكِّنُنِي." (مز 4: 8)

أجدد المواعظ

كل العظات

أرشيف المواعظ

التفاصيل: الموقع

Haytham Halawi is the pastor of Christ Bible Baptist Church in Jal el dib Lebanon.

عظات
سلسلة

المشغل يحتاج إلى جافا سكريبت.

العنوان	الكتاب المقدس	التاريخ	سلسلة
صوم كتابي او صوم تقليدي		14-03-09	عظات
لماذا أعتمد يسوع عند يوحنا المعمدان؟	Matthew 3:13-17	13-10-20	عظات
متطلبات حياة البناء	نحميا 10و11	13-07-16	المؤمن البناء في كنيسة المسيح
أم عظيمة تساهم بولادة ابنها مرتين	ملوك الثاني 4 : 8 - 37	13-03-24	عظات
إندراوس المؤمن المبادِر	بوحنا 1 : 35 - 42	12-03-11	عظات
تأثيرات المستقبل العتيد على حاضر المؤمن	متى 17 : 1 - 23	11-08-31	المستقبل العتيد للمؤمن
لماذا يخطيء المؤمن	رسالة يوحنا الأولى 5 : 18	11-05-01	عظات
أمٌ عظيمٌ إيمانها	متى 15 : 21 - 28	11-03-20	عظات
ثلاث خطوات لتتمبم مشيئة الله	رسالة كورنثوس الثانية 8 : 10 - 11	11-02-13	عظات
بالرحمة نصنع الأقرباء	لوقا 10 : 25	10-11-07	عظات
دروس من كلمات يسوع المصلوب	لوقا 23 : 33 - 34	10-09-19	عظات
الرب المصدر الوحيد للفرح الدائم	فيلبي 4 : 4	10-05-30	عظات
بين الماضي والمستقبل لا بد من نصب حجر المعونة	صموئيل الأول 7 : 1 - 12	10-04-11	عظات
فجر قيامة المسيح بدّد ظلمات الموت - الجزء الأول	متى 27 : 45 - 56 و 28 : 1 - 20	10-04-04	عظات
فجر قيامة المسيح بدّد ظلمات الموت - الجزء الثاني	متى 27 : 45 - 56 و 28 : 1 - 20	10-04-04	عظات
الله المعلم العظيم	أمثال 1 : 20	10-03-14	عظات
الوعود الإلهية والمسؤولية البشرية	أمثال 21 : 31 و إرميا 1	10-02-07	عظات
المسيح صورة الله الكاملة	يوحنا 14 : 7 - 14	09-12-13	عظات
الأسباب التي تدفعنا للإلتجاء الى أرض أعداء الرب	صموئيل الأول 27 : 1 - 12	09-10-18	عظات
تأمّل في شخصية إسحق	تكوين 23 - 23	09-10-04	عظات

الصفحة 1 من 3

البداية
السابق
1
2
3
التالي
النهاية

العنوان	الوصف
عظات
الطاعة
المستقبل العتيد للمؤمن
المؤمن البناء في كنيسة المسيح

Additional information

Close info

القائمة الرئيسية

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

الدورة

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1750970917,
                "last": 1750970917,
                "now": 1750970917
            },
            "client": {
                "forwarded": "216.73.216.224"
            },
            "token": "08cah9NKRyeG5AcoaAkO1La2Bzdflwtz"
        },
        "registry": {
            "com_sermonspeaker": {
                "sermons": {
                    "speaker": {
                        "limitstart": 0
                    }
                },
                "series": {
                    "filter": {
                        "speaker": 10000
                    },
                    "limitstart": 0
                }
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "866b5ee93580dd2578a2005d64d95b4f001588da": {
                    "link": "https:\/\/archive.cbbclebanon.com\/index.php\/sermons-100006\/speaker\/10000-2013-07-30-15-59-43?catid=70",
                    "expiry": 1750970917
                }
            }
        }
    }
}

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

الوقت

الذاكرة

الوقت: 14.94 ms / 14.94 ms الذاكرة: 1.616 MB / 1.96 MB Application: afterLoad

الوقت: 57.72 ms / 72.66 ms الذاكرة: 3.525 MB / 5.48 MB Application: afterInitialise

الوقت: 16.59 ms / 89.25 ms الذاكرة: 0.913 MB / 6.40 MB Application: afterRoute

الوقت: 8.00 ms / 97.24 ms الذاكرة: 0.346 MB / 6.74 MB Application: beforeRenderComponent com_sermonspeaker

الوقت: 13.59 ms / 110.84 ms الذاكرة: 1.095 MB / 7.84 MB Application: Before Access::preloadComponents (all components)

الوقت: 1.24 ms / 112.07 ms الذاكرة: 0.055 MB / 7.89 MB Application: After Access::preloadComponents (all components)

الوقت: 0.03 ms / 112.11 ms الذاكرة: 0.000 MB / 7.89 MB Application: Before Access::getAssetRules (id:240 name:com_sermonspeaker)

الوقت: 0.62 ms / 112.73 ms الذاكرة: 0.028 MB / 7.92 MB Application: After Access::getAssetRules (id:240 name:com_sermonspeaker)

الوقت: 104.45 ms / 217.18 ms الذاكرة: 0.339 MB / 8.26 MB Application: Before Access::preloadPermissions (com_sermonspeaker)

الوقت: 1.18 ms / 218.36 ms الذاكرة: 0.012 MB / 8.27 MB Application: After Access::preloadPermissions (com_sermonspeaker)

الوقت: 0.03 ms / 218.39 ms الذاكرة: 0.000 MB / 8.27 MB Application: Before Access::getAssetRules (id:241 name:com_sermonspeaker.category.70)

الوقت: 0.11 ms / 218.50 ms الذاكرة: 0.007 MB / 8.28 MB Application: After Access::getAssetRules (id:241 name:com_sermonspeaker.category.70)

الوقت: 77.82 ms / 296.33 ms الذاكرة: 1.874 MB / 10.15 MB Application: afterRenderComponent com_sermonspeaker

الوقت: 0.44 ms / 296.76 ms الذاكرة: 0.003 MB / 10.15 MB Application: afterDispatch

الوقت: 4.97 ms / 301.73 ms الذاكرة: 0.160 MB / 10.31 MB Application: beforeRenderModule mod_menu (القائمة الرئيسية)

الوقت: 5.58 ms / 307.32 ms الذاكرة: 0.169 MB / 10.48 MB Application: afterRenderModule mod_menu (القائمة الرئيسية)

الوقت: 0.04 ms / 307.36 ms الذاكرة: 0.000 MB / 10.48 MB Application: beforeRenderModule mod_search (Search)

الوقت: 1.32 ms / 308.68 ms الذاكرة: 0.016 MB / 10.49 MB Application: afterRenderModule mod_search (Search)

الوقت: 0.07 ms / 308.75 ms الذاكرة: 0.000 MB / 10.49 MB Application: beforeRenderModule mod_sermonarchive (أرشيف المواعظ)

الوقت: 9.59 ms / 318.34 ms الذاكرة: 0.049 MB / 10.54 MB Application: afterRenderModule mod_sermonarchive (أرشيف المواعظ)

الوقت: 0.08 ms / 318.42 ms الذاكرة: 0.000 MB / 10.54 MB Application: beforeRenderModule mod_latestsermons (أجدد المواعظ)

الوقت: 8.57 ms / 326.99 ms الذاكرة: 0.093 MB / 10.63 MB Application: afterRenderModule mod_latestsermons (أجدد المواعظ)

الوقت: 0.09 ms / 327.08 ms الذاكرة: 0.000 MB / 10.60 MB Application: beforeRenderModule mod_rquotes (آية الأسبوع)

الوقت: 2.32 ms / 329.39 ms الذاكرة: 0.056 MB / 10.66 MB Application: afterRenderModule mod_rquotes (آية الأسبوع)

الوقت: 2.60 ms / 331.99 ms الذاكرة: 0.166 MB / 10.82 MB Application: afterRender

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	المتصل	الملف ورقم السطر
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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

البروفايل

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
update	0.14 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	1.45 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.71 ms قبل آخر إستعلام: 2.74 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 4.033 MB إرجاع الصفوف: 38

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j25_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	NULL	ref	extension	extension	82	const	38	1.00	Using where

البروفايل

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.15 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	نفس الاستدعاء في خط أدناه.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.44 ms قبل آخر إستعلام: 2.30 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.241 MB إرجاع الصفوف: 3

SELECT id, rules

  FROM `j25_viewlevels`

التوضيح

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

البروفايل

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.57 ms قبل آخر إستعلام: 0.09 ms إستعلام الذاكرة: 0.021 MB الذاكرة بعد الإستعلام: 4.252 MB إرجاع الصفوف: 1

SELECT b.id

  FROM j25_usergroups AS a

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

  WHERE a.id = 1

التوضيح

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

البروفايل

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 1.01 ms قبل آخر إستعلام: 0.71 ms إستعلام الذاكرة: 0.030 MB الذاكرة بعد الإستعلام: 4.323 MB إرجاع الصفوف: 80

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM j25_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	NULL	ref	extension	extension	82	const	102	0.46	Using where; استعمال ترتيب الملفات

البروفايل

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.47 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	نفس الاستدعاء في خط أدناه.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 1.79 ms قبل آخر إستعلام: 27.89 ms إستعلام الذاكرة: 0.052 MB الذاكرة بعد الإستعلام: 5.691 MB إرجاع الصفوف: 34

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM j25_menu AS m

  LEFT JOIN j25_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	117	7.01	Using where; استعمال ترتيب الملفات
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.m.component_id	1	100.00	Using where

البروفايل

Status	Duration
starting	0.23 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.91 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	نفس الاستدعاء في خط أدناه.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.76 ms قبل آخر إستعلام: 12.47 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 6.434 MB إرجاع الصفوف: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j25_extensions`

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

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

البروفايل

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.15 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	نفس الاستدعاء في خط أدناه.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 1.90 ms قبل آخر إستعلام: 0.22 ms إستعلام الذاكرة: 0.005 MB الذاكرة بعد الإستعلام: 6.425 MB

UPDATE `j25_extensions`

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

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

التوضيح

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

البروفايل

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.09 ms
updating	0.09 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	1.33 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.60 ms قبل آخر إستعلام: 1.94 ms إستعلام الذاكرة: 0.019 MB الذاكرة بعد الإستعلام: 6.715 MB إرجاع الصفوف: 1

SELECT *

  FROM j25_languages

  WHERE published=1

  ORDER BY ordering ASC

التوضيح

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

البروفايل

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.08 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 1.25 ms قبل آخر إستعلام: 0.36 ms إستعلام الذاكرة: 0.020 MB الذاكرة بعد الإستعلام: 6.729 MB إرجاع الصفوف: 13

SELECT id, home, template, s.params

  FROM j25_template_styles as s

  LEFT JOIN j25_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	13	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	awbsemin_cbbc1.e.element	1	76.47	Using index condition; Using where

البروفايل

Status	Duration
starting	0.28 ms
Executing hook on transaction	0.12 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.29 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.85 ms قبل آخر إستعلام: 10.83 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 7.675 MB إرجاع الصفوف: 1

SELECT speaker.id, speaker.title, speaker.alias, speaker.website, speaker.state, speaker.catid,
  CASE WHEN CHAR_LENGTH(speaker.alias) THEN CONCAT_WS(':', speaker.id, speaker.alias) ELSE speaker.id END as slug,speaker.checked_out, speaker.checked_out_time, speaker.language,speaker.intro, speaker.bio, speaker.pic, speaker.hits, speaker.created, speaker.created_by,speaker.metakey, speaker.metadesc, speaker.created, speaker.created_by,c.title AS category_title, c.access AS category_access,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,user.name AS author

  FROM j25_sermon_speakers AS speaker

  LEFT JOIN j25_categories AS c 
  on c.id = speaker.catid

  LEFT JOIN j25_users AS user 
  ON user.id = speaker.created_by

  WHERE (speaker.catid = 0 OR c.published = 1) 
  AND speaker.id = 10000 
  AND speaker.state = 1

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	speaker	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	user	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

البروفايل

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.14 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_sermonspeaker/models/speaker.php:89
12	SermonspeakerModelSpeaker->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:19
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.67 ms قبل آخر إستعلام: 1.51 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 7.832 MB إرجاع الصفوف: 0

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

  FROM `j25_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_sermonspeaker.speaker' 
  AND `m`.`content_item_id` = 10000 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	awbsemin_cbbc1.m.tag_id	1	100.00	Using where

البروفايل

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.10 ms
executing	0.04 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:49
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 1.06 ms قبل آخر إستعلام: 0.21 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 7.843 MB إرجاع الصفوف: 37

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

  FROM `j25_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rquote','com_search','com_sermonspeaker','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	39	100.00	Using index condition

البروفايل

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.48 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/components/com_sermonspeaker/models/sermons.php:240
12	SermonspeakerModelSermons->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:62
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 7.39 ms قبل آخر إستعلام: 0.94 ms إستعلام الذاكرة: 0.051 MB الذاكرة بعد الإستعلام: 7.929 MB إرجاع الصفوف: 20

SELECT sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.custom1, sermons.custom2, sermons.audiofilesize, sermons.videofilesize, 
  CASE WHEN CHAR_LENGTH(sermons.alias) THEN CONCAT_WS(':', sermons.id, sermons.alias) ELSE sermons.id END as slug,sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text 
  ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state, 
  CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,series.title AS series_title, series.state as series_state, series.avatar, 
  CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug,c_sermons.title AS category_title,
  CASE WHEN CHAR_LENGTH(c_sermons.alias) THEN CONCAT_WS(':', c_sermons.id, c_sermons.alias) ELSE c_sermons.id END as catslug,user.name AS author

  FROM `j25_sermon_sermons` AS sermons

  LEFT JOIN j25_sermon_scriptures AS script 
  ON script.sermon_id = sermons.id

  LEFT JOIN j25_sermon_speakers AS speakers 
  ON speakers.id = sermons.speaker_id

  LEFT JOIN j25_sermon_series AS series 
  ON series.id = sermons.series_id

  LEFT JOIN j25_categories AS c_sermons 
  ON c_sermons.id = sermons.catid

  LEFT JOIN j25_categories AS c_speaker 
  ON c_speaker.id = speakers.catid

  LEFT JOIN j25_categories AS c_series 
  ON c_series.id = series.catid

  LEFT JOIN j25_users AS user 
  ON user.id = sermons.created_by

  WHERE (sermons.catid = 0 OR (c_sermons.access IN (1,1) 
  AND c_sermons.published = 1)) 
  AND (sermons.speaker_id = 0 OR speakers.catid = 0 OR (c_speaker.access IN (1,1) 
  AND c_speaker.published = 1)) 
  AND (sermons.series_id = 0 OR series.catid = 0 OR (c_series.access IN (1,1) 
  AND c_series.published = 1)) 
  AND sermons.catid = 70 
  AND sermons.state = 1 
  AND sermons.state != -2 
  AND sermons.speaker_id = 10000

  GROUP BY sermons.id

  ORDER BY sermon_date DESC 
  LIMIT 20

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sermons	NULL	ALL	PRIMARY	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	516	0.19	Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	script	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	498	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	speakers	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	series	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.sermons.series_id	1	100.00	NULL
1	SIMPLE	c_sermons	NULL	const	PRIMARY	PRIMARY	4	const	1	5.00	Using where
1	SIMPLE	c_speaker	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.speakers.catid	1	100.00	Using where
1	SIMPLE	c_series	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.series.catid	1	100.00	Using where
1	SIMPLE	user	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.sermons.created_by	1	100.00	NULL

البروفايل

Status	Duration
starting	0.27 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Creating tmp table	0.13 ms
executing	6.07 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.04 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
11	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:64
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 36.25 ms قبل آخر إستعلام: 33.32 ms إستعلام الذاكرة: 0.068 MB الذاكرة بعد الإستعلام: 8.126 MB إرجاع الصفوف: 42

SELECT sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.custom1, sermons.custom2, sermons.audiofilesize, sermons.videofilesize, 
  CASE WHEN CHAR_LENGTH(sermons.alias) THEN CONCAT_WS(':', sermons.id, sermons.alias) ELSE sermons.id END as slug,sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text 
  ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state, 
  CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,series.title AS series_title, series.state as series_state, series.avatar, 
  CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug,c_sermons.title AS category_title,
  CASE WHEN CHAR_LENGTH(c_sermons.alias) THEN CONCAT_WS(':', c_sermons.id, c_sermons.alias) ELSE c_sermons.id END as catslug,user.name AS author

  FROM `j25_sermon_sermons` AS sermons

  LEFT JOIN j25_sermon_scriptures AS script 
  ON script.sermon_id = sermons.id

  LEFT JOIN j25_sermon_speakers AS speakers 
  ON speakers.id = sermons.speaker_id

  LEFT JOIN j25_sermon_series AS series 
  ON series.id = sermons.series_id

  LEFT JOIN j25_categories AS c_sermons 
  ON c_sermons.id = sermons.catid

  LEFT JOIN j25_categories AS c_speaker 
  ON c_speaker.id = speakers.catid

  LEFT JOIN j25_categories AS c_series 
  ON c_series.id = series.catid

  LEFT JOIN j25_users AS user 
  ON user.id = sermons.created_by

  WHERE (sermons.catid = 0 OR (c_sermons.access IN (1,1) 
  AND c_sermons.published = 1)) 
  AND (sermons.speaker_id = 0 OR speakers.catid = 0 OR (c_speaker.access IN (1,1) 
  AND c_speaker.published = 1)) 
  AND (sermons.series_id = 0 OR series.catid = 0 OR (c_series.access IN (1,1) 
  AND c_series.published = 1)) 
  AND sermons.catid = 70 
  AND sermons.state = 1 
  AND sermons.state != -2 
  AND sermons.speaker_id = 10000

  GROUP BY sermons.id

  ORDER BY sermon_date DESC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sermons	NULL	ALL	PRIMARY	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	516	0.19	Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	script	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	498	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	speakers	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	series	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.sermons.series_id	1	100.00	NULL
1	SIMPLE	c_sermons	NULL	const	PRIMARY	PRIMARY	4	const	1	5.00	Using where
1	SIMPLE	c_speaker	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.speakers.catid	1	100.00	Using where
1	SIMPLE	c_series	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.series.catid	1	100.00	Using where
1	SIMPLE	user	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.sermons.created_by	1	100.00	NULL

البروفايل

Status	Duration
starting	0.41 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.11 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
Creating tmp table	0.17 ms
executing	16.30 ms
end	0.05 ms
query end	0.01 ms
waiting for handler commit	0.06 ms
closing tables	0.04 ms
freeing items	0.13 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
12	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
11	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:65
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 4.61 ms قبل آخر إستعلام: 0.14 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 8.120 MB إرجاع الصفوف: 15

SELECT DISTINCT YEAR(`sermon_date`) AS `year`

  FROM `j25_sermon_sermons`

  WHERE `sermon_date` != '0000-00-00' 
  AND state = 1

  ORDER BY `year` ASC

التوضيح

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

البروفايل

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	3.95 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.17 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_sermonspeaker/models/sermons.php:373
11	SermonspeakerModelSermons->getYears()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:66
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 4.90 ms قبل آخر إستعلام: 0.15 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 8.133 MB إرجاع الصفوف: 12

SELECT DISTINCT MONTH(`sermon_date`) AS `value`

  FROM `j25_sermon_sermons`

  WHERE `sermon_date` != '0000-00-00' 
  AND state = 1

  ORDER BY `value` ASC

التوضيح

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

البروفايل

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	4.27 ms
end	0.08 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_sermonspeaker/models/sermons.php:340
11	SermonspeakerModelSermons->getMonths()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:67
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 5.90 ms قبل آخر إستعلام: 0.13 ms إستعلام الذاكرة: 0.022 MB الذاكرة بعد الإستعلام: 8.145 MB إرجاع الصفوف: 10

SELECT DISTINCT `book`

  FROM `j25_sermon_scriptures`

  LEFT JOIN `j25_sermon_sermons` AS `sermons` 
  ON `sermon_id` = `sermons`.`id`

  WHERE `book` != 0 
  AND `sermons`.`state` = 1

  ORDER BY `book` ASC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_sermon_scriptures	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	498	90.00	Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	sermons	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.j25_sermon_scriptures.sermon_id	1	10.00	Using where; Distinct

البروفايل

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	4.37 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_sermonspeaker/models/sermons.php:402
11	SermonspeakerModelSermons->getBooks()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:68
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 9.27 ms قبل آخر إستعلام: 1.47 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 8.213 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,(
SELECT COUNT(i.`id`)

  FROM `j25_sermon_sermons` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `j25_categories` AS `s`

  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_sermonspeaker' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 70

  ORDER BY c.lft

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	استعمال ترتيب الملفات
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	3	95.74	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	516	1.00	Using where

البروفايل

Status	Duration
starting	0.36 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.04 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.13 ms
executing	3.94 ms
executing	4.01 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
13	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
12	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_sermonspeaker/models/sermons.php:432
11	SermonspeakerModelSermons->getCategory()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:70
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.99 ms قبل آخر إستعلام: 0.84 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 8.258 MB إرجاع الصفوف: 4

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

  FROM `j25_assets`

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

التوضيح

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

البروفايل

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.02 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.34 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.02 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_sermonspeaker/models/sermons.php:442
11	SermonspeakerModelSermons->getCategory()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:70
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 12.53 ms قبل آخر إستعلام: 0.56 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 8.347 MB إرجاع الصفوف: 4

SELECT series.id, series.title, series.catid, series.avatar, 
  CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as slug, series.hits, series.series_description, series.alias, series.checked_out, series.checked_out_time,series.state, series.ordering, series.created, series.created_by,c_series.title AS category_title,
  CASE WHEN CHAR_LENGTH(c_series.alias) THEN CONCAT_WS(':', c_series.id, c_series.alias) ELSE c_series.id END as catslug,user.name AS author

  FROM `j25_sermon_series` AS series

  LEFT JOIN j25_categories AS c_series 
  ON c_series.id = series.catid

  LEFT JOIN j25_users AS user 
  ON user.id = series.created_by

  LEFT JOIN j25_sermon_sermons AS sermons 
  ON sermons.series_id = series.id

  WHERE (series.catid = 0 OR (c_series.access IN (1,1) 
  AND c_series.published = 1)) 
  AND series.catid = 70 
  AND series.state = 1 
  AND series.state != -2 
  AND sermons.speaker_id = 10000 
  AND sermons.state = 1

  GROUP BY series.id

  ORDER BY ordering ASC 
  LIMIT 20

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	series	NULL	ALL	PRIMARY	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	19	5.26	Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	c_series	NULL	const	PRIMARY	PRIMARY	4	const	1	5.00	Using where
1	SIMPLE	user	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.series.created_by	1	100.00	NULL
1	SIMPLE	sermons	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	516	0.19	Using where; Using join buffer (hash join)

البروفايل

Status	Duration
starting	0.24 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.04 ms
Creating tmp table	0.17 ms
executing	4.56 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.02 ms
freeing items	0.12 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
11	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:79
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 9.22 ms قبل آخر إستعلام: 0.30 ms إستعلام الذاكرة: 0.024 MB الذاكرة بعد الإستعلام: 8.375 MB إرجاع الصفوف: 4

SELECT series.id, series.title, series.catid, series.avatar, 
  CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as slug, series.hits, series.series_description, series.alias, series.checked_out, series.checked_out_time,series.state, series.ordering, series.created, series.created_by,c_series.title AS category_title,
  CASE WHEN CHAR_LENGTH(c_series.alias) THEN CONCAT_WS(':', c_series.id, c_series.alias) ELSE c_series.id END as catslug,user.name AS author

  FROM `j25_sermon_series` AS series

  LEFT JOIN j25_categories AS c_series 
  ON c_series.id = series.catid

  LEFT JOIN j25_users AS user 
  ON user.id = series.created_by

  LEFT JOIN j25_sermon_sermons AS sermons 
  ON sermons.series_id = series.id

  WHERE (series.catid = 0 OR (c_series.access IN (1,1) 
  AND c_series.published = 1)) 
  AND series.catid = 70 
  AND series.state = 1 
  AND series.state != -2 
  AND sermons.speaker_id = 10000 
  AND sermons.state = 1

  GROUP BY series.id

  ORDER BY ordering ASC

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	series	NULL	ALL	PRIMARY	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	19	5.26	Using where; Using temporary; استعمال ترتيب الملفات
1	SIMPLE	c_series	NULL	const	PRIMARY	PRIMARY	4	const	1	5.00	Using where
1	SIMPLE	user	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.series.created_by	1	100.00	NULL
1	SIMPLE	sermons	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	516	0.19	Using where; Using join buffer (hash join)

البروفايل

Status	Duration
starting	0.26 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.18 ms
executing	6.37 ms
end	0.03 ms
query end	0.02 ms
waiting for handler commit	0.60 ms
closing tables	0.03 ms
freeing items	0.33 ms
cleaning up	0.07 ms

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

#	المتصل	الملف ورقم السطر
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
12	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
11	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:80
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 3.33 ms قبل آخر إستعلام: 6.23 ms إستعلام الذاكرة: 0.029 MB الذاكرة بعد الإستعلام: 8.394 MB إرجاع الصفوف: 23

SHOW FULL COLUMNS 
  FROM `j25_sermon_speakers`

التوضيح

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

البروفايل

Status	Duration
starting	0.29 ms
Executing hook on transaction	0.03 ms
starting	0.06 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
Opening tables	0.67 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
Creating tmp table	0.11 ms
executing	0.11 ms
checking permissions	0.08 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.05 ms

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

#	المتصل	الملف ورقم السطر
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sermonspeaker/tables/speaker.php:18
15	SermonspeakerTableSpeaker->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/components/com_sermonspeaker/models/speaker.php:124
11	SermonspeakerModelSpeaker->hit()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:114
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 4.72 ms قبل آخر إستعلام: 1.71 ms إستعلام الذاكرة: 0.006 MB الذاكرة بعد الإستعلام: 8.501 MB

UPDATE j25_sermon_speakers

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

  WHERE `id` = '10000'

التوضيح

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

البروفايل

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.05 ms
updating	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_sermonspeaker/models/speaker.php:125
11	SermonspeakerModelSpeaker->hit()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:114
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 1.47 ms قبل آخر إستعلام: 17.24 ms إستعلام الذاكرة: 0.027 MB الذاكرة بعد الإستعلام: 9.603 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 `j25_categories` AS `s`

  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_sermonspeaker' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 70

  ORDER BY c.lft

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	استعمال ترتيب الملفات
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	3	95.74	Using index condition; Using where

البروفايل

Status	Duration
starting	0.35 ms
Executing hook on transaction	0.03 ms
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.06 ms
executing	0.14 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.14 ms
cleaning up	0.03 ms

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

#	المتصل	الملف ورقم السطر
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_sermonspeaker/helpers/route.php:234
18	SermonspeakerHelperRoute::getSpeakerRoute()	JROOT/components/com_sermonspeaker/helpers/icon.php:33
17	JHtmlIcon::email()	نفس الاستدعاء في خط أدناه.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_sermonspeaker/views/speaker/tmpl/table.php:54
13	include JROOT/components/com_sermonspeaker/views/speaker/tmpl/table.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:205
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 4.54 ms قبل آخر إستعلام: 9.17 ms إستعلام الذاكرة: 0.028 MB الذاكرة بعد الإستعلام: 10.083 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 j25_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_sermonspeaker.intro' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

التوضيح

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

البروفايل

Status	Duration
starting	0.27 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.15 ms
init	0.21 ms
System lock	0.03 ms
optimizing	0.14 ms
statistics	0.19 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.07 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
17	JHtmlContent::prepare()	نفس الاستدعاء في خط أدناه.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_sermonspeaker/views/speaker/tmpl/table.php:113
13	include JROOT/components/com_sermonspeaker/views/speaker/tmpl/table.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sermonspeaker/views/speaker/view.html.php:205
10	SermonspeakerViewSpeaker->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sermonspeaker/controller.php:72
8	SermonspeakerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sermonspeaker/sermonspeaker.php:22
6	require_once JROOT/components/com_sermonspeaker/sermonspeaker.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 1.14 ms قبل آخر إستعلام: 9.44 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.314 MB إرجاع الصفوف: 5

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

  FROM j25_modules AS m

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

  LEFT JOIN j25_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 <= '2025-06-26 20:48:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-26 20:48:37') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 100006 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	6	3.57	Using index condition; Using where; استعمال ترتيب الملفات
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	awbsemin_cbbc1.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.m.id	1	40.00	Using where; Using index

البروفايل

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.32 ms
end	0.02 ms
query end	0.02 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	نفس الاستدعاء في خط أدناه.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/beez_20/index.php:15
7	require JROOT/templates/beez_20/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 7.42 ms قبل آخر إستعلام: 9.37 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.522 MB إرجاع الصفوف: 15

SELECT YEAR(`sermon_date`) AS `year`,CONCAT_WS('-', YEAR(`sermon_date`), MONTH(`sermon_date`), '15') AS `date`,0 AS `month`

  FROM j25_sermon_sermons

  WHERE `state` = 1

  GROUP BY `year`

  ORDER BY `sermon_date` DESC

التوضيح

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

البروفايل

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.02 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	5.93 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_sermonarchive/helper.php:33
11	modSermonarchiveHelper::getList()	JROOT/modules/mod_sermonarchive/mod_sermonarchive.php:7
10	include JROOT/modules/mod_sermonarchive/mod_sermonarchive.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 5.47 ms قبل آخر إستعلام: 2.65 ms إستعلام الذاكرة: 0.025 MB الذاكرة بعد الإستعلام: 10.593 MB إرجاع الصفوف: 10

SELECT a.title, a.id, a.sermon_date, a.audiofile, a.videofile, a.sermon_time, a.picture, a.notes, a.hits,b.title as speaker_title, b.pic, b.state AS speaker_state, c.title AS series_title, c.state AS series_state,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END as speaker_slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as series_slug,cat.title AS category_title,
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END as catslug

  FROM j25_sermon_sermons AS a

  LEFT JOIN j25_sermon_speakers AS b 
  ON b.id = a.speaker_id

  LEFT JOIN j25_sermon_series AS c 
  ON c.id = a.series_id

  LEFT JOIN j25_categories AS cat 
  ON cat.id = a.catid

  WHERE a.state = 1 
  AND (a.catid = 0 OR (cat.access IN (1,1) 
  AND cat.published = 1))

  ORDER BY sermon_date DESC, (sermon_number+0) DESC 
  LIMIT 10

التوضيح

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	لا يوجد مفتاح رئيسي يمكن استخدامه	NULL	NULL	516	10.00	Using where; استعمال ترتيب الملفات
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.a.speaker_id	1	100.00	NULL
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.a.series_id	1	100.00	NULL
1	SIMPLE	cat	NULL	eq_ref	PRIMARY	PRIMARY	4	awbsemin_cbbc1.a.catid	1	100.00	Using where

البروفايل

Status	Duration
starting	0.29 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.05 ms
executing	4.56 ms
end	0.03 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_latestsermons/helper.php:123
11	modLatestsermonsHelper::getList()	JROOT/modules/mod_latestsermons/mod_latestsermons.php:6
10	include JROOT/modules/mod_latestsermons/mod_latestsermons.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

وقت الإستعلام: 0.74 ms قبل آخر إستعلام: 3.47 ms إستعلام الذاكرة: 0.023 MB الذاكرة بعد الإستعلام: 10.675 MB إرجاع الصفوف: 3

SELECT * 
  from	j25_rquote 
  WHERE published='1' 
  and catid = 71

التوضيح

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

البروفايل

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.03 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.13 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

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

#	المتصل	الملف ورقم السطر
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_rquotes/helper.php:53
11	modRquotesHelper::getRandomRquote()	JROOT/modules/mod_rquotes/mod_rquotes.php:39
10	include JROOT/modules/mod_rquotes/mod_rquotes.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

2 × SELECT sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.custom1, sermons.custom2, sermons.audiofilesize, sermons.videofilesize, 
  CASE WHEN CHAR_LENGTH(sermons.alias) THEN CONCAT_WS(':', sermons.id, sermons.alias) ELSE sermons.id END as slug,sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text 
  ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state, 
  CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,series.title AS series_title, series.state as series_state, series.avatar, 
  CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug,c_sermons.title AS category_title,
  CASE WHEN CHAR_LENGTH(c_sermons.alias) THEN CONCAT_WS(':', c_sermons.id, c_sermons.alias) ELSE c_sermons.id END as catslug,user.name AS author 
  FROM `j25_sermon_sermons` AS sermons 
  LEFT JOIN j25_sermon_scriptures AS script 
  ON script.sermon_id = sermons.id 
  LEFT JOIN j25_sermon_speakers AS speakers 
  ON speakers.id = sermons.speaker_id 
  LEFT JOIN j25_sermon_series AS series 
  ON series.id = sermons.series_id 
  LEFT JOIN j25_categories AS c_sermons 
  ON c_sermons.id = sermons.catid 
  LEFT JOIN j25_categories AS c_speaker 
  ON c_speaker.id = speakers.catid 
  LEFT JOIN j25_categories AS c_series 
  ON c_series.id = series.catid 
  LEFT JOIN j25_users AS user 
  ON user.id = sermons.created_by

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `j25_extensions`

2 × SELECT series.id, series.title, series.catid, series.avatar, 
  CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as slug, series.hits, series.series_description, series.alias, series.checked_out, series.checked_out_time,series.state, series.ordering, series.created, series.created_by,c_series.title AS category_title,
  CASE WHEN CHAR_LENGTH(c_series.alias) THEN CONCAT_WS(':', c_series.id, c_series.alias) ELSE c_series.id END as catslug,user.name AS author 
  FROM `j25_sermon_series` AS series 
  LEFT JOIN j25_categories AS c_series 
  ON c_series.id = series.catid 
  LEFT JOIN j25_users AS user 
  ON user.id = series.created_by 
  LEFT JOIN j25_sermon_sermons AS sermons 
  ON sermons.series_id = series.id

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `j25_assets`

1 × SELECT DISTINCT MONTH(`sermon_date`) AS `value` 
  FROM `j25_sermon_sermons`

1 × SELECT a.title, a.id, a.sermon_date, a.audiofile, a.videofile, a.sermon_time, a.picture, a.notes, a.hits,b.title as speaker_title, b.pic, b.state AS speaker_state, c.title AS series_title, c.state AS series_state,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END as speaker_slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as series_slug,cat.title AS category_title,
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END as catslug 
  FROM j25_sermon_sermons AS a 
  LEFT JOIN j25_sermon_speakers AS b 
  ON b.id = a.speaker_id 
  LEFT JOIN j25_sermon_series AS c 
  ON c.id = a.series_id 
  LEFT JOIN j25_categories AS cat 
  ON cat.id = a.catid

1 × SELECT YEAR(`sermon_date`) AS `year`,CONCAT_WS('-', YEAR(`sermon_date`), MONTH(`sermon_date`), '15') AS `date`,0 AS `month` 
  FROM j25_sermon_sermons

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM j25_modules AS m 
  LEFT JOIN j25_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN j25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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 j25_fields AS a 
  LEFT JOIN `j25_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN j25_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN j25_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN j25_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN j25_fields_groups AS g 
  ON g.id = a.group_id

1 × 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 `j25_categories` AS `s` 
  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × 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,( SELECT COUNT(i.`id`) 
  FROM `j25_sermon_sermons` AS `i`

1 × SELECT DISTINCT `book` 
  FROM `j25_sermon_scriptures` 
  LEFT JOIN `j25_sermon_sermons` AS `sermons` 
  ON `sermon_id` = `sermons`.`id`

1 × SELECT `data` 
  FROM `j25_session`

1 × SELECT DISTINCT YEAR(`sermon_date`) AS `year` 
  FROM `j25_sermon_sermons`

1 × SELECT `session_id` 
  FROM `j25_session`

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

1 × SELECT speaker.id, speaker.title, speaker.alias, speaker.website, speaker.state, speaker.catid,
  CASE WHEN CHAR_LENGTH(speaker.alias) THEN CONCAT_WS(':', speaker.id, speaker.alias) ELSE speaker.id END as slug,speaker.checked_out, speaker.checked_out_time, speaker.language,speaker.intro, speaker.bio, speaker.pic, speaker.hits, speaker.created, speaker.created_by,speaker.metakey, speaker.metadesc, speaker.created, speaker.created_by,c.title AS category_title, c.access AS category_access,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,user.name AS author 
  FROM j25_sermon_speakers AS speaker 
  LEFT JOIN j25_categories AS c 
  on c.id = speaker.catid 
  LEFT JOIN j25_users AS user 
  ON user.id = speaker.created_by

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

```
1 × SELECT * 
  FROM j25_languages 
```

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM j25_extensions

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

1 × SELECT id, rules 
  FROM `j25_viewlevels

```
1 × SELECT * 
  from j25_rquote 
```

جداول أخرى:

1 × INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6133346266343162306332366435376437633936356331346632303762353234', 1, 1750970917, 0, '', 0

1 × UPDATE `j25_extensions` 
  SET `params` = '{\"mediaversion\":\"fc26f10e04c7e0ccd4f1b2c786941168\"}'

1 × SHOW FULL COLUMNS 
  FROM `j25_sermon_speakers

1 × UPDATE j25_sermon_speakers 
  SET `hits` = (`hits` + 1)

Nav view search

Navigation

Search

آية الأسبوع

أجدد المواعظ

Additional information

القائمة الرئيسية

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

الدورة

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

الوقت

الذاكرة

الذاكرة المستخدمة

استعلامات قاعدة البيانات

32 الاستعلامات المسجلة 134.42 ms

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

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

جداول أخرى: