
ين روش بر اساس مقايسه زوجي بنا نهاده شده است و امکان بررسي سناريوهاي مختلف را به مديران و برنامهريزان ميدهد (قدسي پور،1381). روش ارزيابي چند معياره AHP با در نظر
اين روش ارزيابي براي اولين بار توسط توماس ال ساعتي[2] در سال 1980 مطرح گرديد. اين روش بر اساس مقايسه زوجي بنا نهاده شده است و امکان بررسي سناريوهاي مختلف را به مديران و برنامهريزان ميدهد (قدسي پور،1381). روش ارزيابي چند معياره AHP با در نظر گرفتن اثر همزمان کليه معيارهاي دخيل و مقايسه امتيازات آنها، به اولويت بندي گزينهها پرداخته و با به کار گيري روابط معرفي شده گزينه مطلوب را تعيين مي نمايد (صادقپور و ديگران، 1383).
در اين تکنيک ابتدا ساختار سلسله مراتبي مسئله ساخته مي شود و سپس با مقايسه زوجي بين معيارها و شاخصهاي مورد مطالعه، وزن نسبي هريک از آن شاخصها تعيين ميگردد و سپس با توجه به وزنهاي بدست آمده ارزش هر يک از نمونههاي مورد مطالعه محاسبه ميگردد (جواهري و داغستاني؛1385: 8).
در دهههاي اخير مدلهاي ارزيابي چند معياري مختلفي مورد استفاده قرار گرفته است، كه از آن جمله ميتوان به مدل «تحليل سيستم[3]»، «تئوري مطلوبيت چند مشخصه[4]» ، «تصميمگيري چند معياري[5]»، «تئوري قضاوت اجتماعي[6]» و مدل «ارزيابي چندمعياري فرايند تحليل سلسله مراتبي[7]» اشاره نمود. در مطالعات حاضر از مدل ارزيابي چندمعياري فرايند تحليل سلسله مراتبي استفاده ميشود. اين مدل كه از پنج مرحله اصلي تشكيل ميشود، ميتواند با به كارگيري همزمان شاخصهای كمي و كيفي و در شرايطي كه شاخصهای تصميمگيري متعدد، شرايط انتخاب را با مشكل مواجه ميسازد، موثر واقع شود. در ادامه، مراحل فرايند انجام مدل تحليل سلسله مراتبي تشریح شدهاست.
روال كار مدل AHP، با مشخص كردن عناصر تصميمگيري و اولويت دادن به آنها آغاز ميشود. اين عناصر شامل شيوههاي مختلف انجام كار و اولويت دادن به سنجه ها يا معیارها ميباشند.
1-1-1-1- مر حله اول: ساختن درخت سلسله مراتبي
مرحله اول فرایند تحلیل سلسله مراتبی، ايجاد يك ساختار سلسله مراتبي از موضوع مورد بررسي ميباشد كه در آن هدف، معيارها، زيرمعيارها و گزينهها و ارتباط میان آنها نشان داده ميشود.
به پرسش اصلي تحقيق، يا مشكلي كه قصد حل آن را داریم، هدف گفته ميشود. هدف بالاترين سطح درخت سلسله مراتبي است و تنها يك پارامتر دارد كه انتخاب آن وظيفه بالاترين سطح تصميمگيري پروژه ميباشد.
ملاكهاي متضمن هدف و سازنده آن معيارهای ما را تشکیل میدهند. معيارها در واقع سنگ محك هدف يا وسيله اندازهگيري آن ميباشد. هر اندازه معيارها بيشتر اجزاء هدف را پوشش دهند و بيشتر بيان كننده هدف باشند، احتمال گرفتن نتيجه دقيقتر افزايش خواهد يافت. معيارها دومين سطح درخت سلسله مراتبي پس از هدف ميباشند. در اين سطح ميتوانيم بنا به ضرورت به تعداد مورد نياز معيار در سطح افقي ترسيم و تنظيم نماييم. معيارها قابل تقسيم به زير معيارها و زيرمعيارها قابل تقسيم به زيرمعيارهاي بعدي ميباشند. اين وضعيت ميتواند بسته به ضرورت تا n زيرمعيار در سطح عمودي و افقي افزايش پيدا نمايد.
گزینهها در واقع منظور و مقصد هدف در درخت سلسله مراتبي ميباشند و پاسخ هدف از ميان گزینههاي ترسيم شده به دست ميآيد. گزینهها، آخرين سطح درخت سلسله مراتبي ميباشند.
1-1-1-2- تعيين ضريب اهميت معيارها و زيرمعيارها
برای تعیین ضریب اهمیت (وزن) نسبی معیارها از روش دلفی استفاده شده است. مزیت این روش در این است که گروهی از خبرگان در خصوص اهمیت یا وزن معیار به اجماع می رسند. در اینجا ابتدا معیار ها مشخص شده و سپس آنها برای وزن دهی یا تعیین اهمیت آنها در اختیار خبرگان قرار گرفته و پاسخ ها تجزیه و تحلیل شد. در گام بعد پاسخ های اکثریت و محدوده اجماع اکثریت و پاسخ های مرحله اول خبرگان در پرسش نامه درج گردید. در مرحله دوم پرسش نامه از خبرگان خواسته شد تا در صورت تمایل پاسخ های مورد نظر خود را قید نمایند و در صورت تمایل آنها را تغییر دهند.زیرمعیارها، نیز دوبهدو با هم مقایسه شدند. وزن هر عامل نشاندهنده اهمیت و ارزش آن نسبت به عوامل دیگر است. بنابراین انتخاب آگاهانه و صحیح وزنها کمک بزرگی در جهت تعیین هدف مورد نظر مینماید.
مقایسههای دوبهدو، در یک ماتریس n×n ثبت میشوند و این ماتریس، ماتریس مقایسه دودویی معیارها نامیده میشود. جدول شماره 1 مقیاس 9 کمیتی ساعتی برای مقایسه دودویی معیارها را نشان میدهد.
جدول شماره 1- مقیاس 9 کمیتی ساعتی برای مقایسه دودویی معیارها
امتیاز |
تعریف |
توضیح |
1 |
اهمیت مساوی |
در تحقق هدف دو معیار اهمیت مساوی دارند. |
3 |
اهمیت اندکی بیشتر |
تجربه نشان میدهد که اهمیت i اندکی بیشتر از j است |
5 |
اهمیت بیشتر |
تجربه نشان میدهد که اهمیت i بیشتر از j است |
7 |
اهمیت خیلی بیشتر |
تجربه نشان میدهد که اهمیت i خیلی بیشتر از j است. |
9 |
اهمیت مطلق |
اهمیت خیلی بیشتر iبه j به اثبات رسیده است. |
2و4و6و8 |
هنگامی که حالتهای میانه وجود دارد. |
مأخذ: زبردست (1380)
براي محاسبه ضريب اهميت شاخصها، چهار روش عمده زير مطرح هستند:
روش حداقل مربعات[8]
روش حداقل مربعات لگاريتمي[9]
روش بردار ويژه[10]
روشهاي تقريبي[11]
از روشهاي فوق، روش بردار ويژه بيشتر مورد استفاده قرار ميگيرد. اما اگر ماتريس دودویی شاخصها داراي ابعاد بزرگي باشد، محاسبه مقادير و بردارهاي ويژه طولاني و وقتگير خواهد بود. به همين دليل از چهار روش تقريبي زير بدين منظور استفاده ميشود:
1. روش مجموع سطري
2. روش مجموع ستوني
3. روش ميانگين حسابي
4. روش ميانگين هندسي
در روش محاسبه ميانگين هندسي، براي محاسبه ضريب اهميت شاخصها، ابتدا ميانگين هندسي رديفهاي ماتريس دودویی شاخصها را بدست آورده و سپس آنها را «نرماليزه[12]» ميكنند. براي بدست آوردن ضريب اهميت زیر شاخصها، از همان روش تعيين ضريب اهميت شاخصها و از همان جدول 9 كميتي مقايسه دودوئي شاخصها استفاده ميشود. به هنگام مقايسه زوجي مي بايست به اصول زير توجه نمود.
اصل اول- شرط معکوسي[13]: اگر ترجيح عنصر A بر عنصر B برابر n باشد ترجيح عنصر B بر عنصر A برابر n/1خواهد بود.
اصل دوم- همگني[14]: عنصر A با عنصر B بايد همگن و قابل قياس باشند. به بيان ديگر برتري عنصر A بر عنصر B نمي تواند بينهايت يا صفر باشد.
اصل سوم- وابستگي[15]: هر عنصر سلسله مراتبي به عنصر سطح بالاتر خود ميتواند وابسته باشد و به صورت خطي اين وابستگي تا بالاترين سطح ميتواند ادامه داشته باشد.
اصل چهارم- انتظارات[16]: هرگاه تغيير در ساختمان سلسله مراتبي رخ دهد، فرايند ارزيابي بايد مجدداً انجام گيرد.
1-1-1-3- مر حله سوم: تعیین امتیاز گزینهها
پس از تعیین ضرایب اهمیت معیارها و زیرمعیارها، ضریب اهمیت گزینهها را باید تعیین کرد. در این مرحله، ارجحیت هر یک از گزینهها در ارتباط با هریک از زیرمعیارها و اگر معیاری، زیرمعیار نداشت مستقیماً با خود آن معیار مورد قضاوت و داوری قرار میگیرد. مبنای این قضاوت، همان مقیاس 9 کمیتی ساعتی است، با این تفاوت که در مقایسه گزینهها در ارتباط با هر یک از زیرمعیارها ـ یا معیارها ـ، بحث «کدام گزینه مهمتر است؟» مطرح نیست، بلکه «کدام گزینه ارجح است و چقدر؟» مطرح است. بنابراین مقیاس 9 کمیتی ساعتی به شرح جدول 2، مبنای قضاوت گزینهها، قرار خواهد گرفت (زبردست،1380).
جدول شماره 2- مقیاس 9 کمیتی ساعتی برای مقایسه دودویی گزینهها
امتیاز |
تعریف |
1 |
ترجیح یکسان |
3 |
کمی ارجح |
5 |
ترجیح بیشتر |
7 |
ترجیح خیلی بیشتر |
9 |
کاملاً ارجح |
2و4و6و8 |
ترجیحات بینابین |
مأخذ: زبردست، 1380
1-1-1-4- مرحله چهارم: تعیین امتیاز نهایی (اولویت) گزینهها (وزن مطلق)
در اين مرحله از تلفيق ضرايب اهميت مزبور، امتياز نهايي هر گزينه تعيين خواهد شد. براي اين كار از «اصل تركيب سلسله مراتبي[17]» كه منجربه يك «بردار اولويت» با در نظر گرفتن همه قضاوتها در تمامي سطوح سلسله مراتبي ميشود، استفاده شده است (فرمول).
(فرمول1)
كه در آن:
: امتیاز نهایی گزینه j
: ضريب اهميت شاخص K
: ضريب اهميت زيرشاخص i
: امتياز گزينه j در ارتباط با شاخص یا زيرشاخص i
1-1-1-5- مرحله پنجم: بررسی سازگاری در قضاوتها
هنگامی که اهميت شاخص ها نسبت به يكديگر برآورد ميشود، احتمال ناهماهنگي در قضاوتها وجود دارد. بنابراین لازم است از سنجهاي استفاده گردد كه ميزان ناهماهنگي داوريها را نمايان سازد. يكي از مزيتهاي فرايند تحليل سلسله مراتبي، امكان بررسي سازگاري در قضاوتهاي انجام شده براي تعيين ضريب اهميت شاخصها و زیر شاخصها است. سازوكاري كه اين مدل براي بررسي ناسازگاري در قضاوتها در نظر ميگيرد، محاسبه ضريبي به نام « ضريب ناسازگاري[18] » است كه از تقسيم «شاخص ناسازگاري[19]» به «شاخص تصادفي بودن[20]» حاصل ميشود. چناچه اين ضريب كوچكتر از يك دهم باشد، سازگاري در قضاوتها مورد قبول است ودر غیر این صورت لازم است در قضاوتها تجديدنظر نمود. به عبارت ديگر ماتريس مقايسه دودويی شاخصها بايد مجدداً تشكيل شود. شاخص ناسازگاري به طريق زير بدست ميآيد (فرمول1ـ1).
(فرمول1ـ1)
C.I = شاخص ناسازگاري
شاخصهاي تصادفي بودن با توجه به تعداد شاخصها و از جدول قابل استخراج است.
جدول شماره 3- شاخص تصادفي بودن (R.L)
n |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
R.I |
0.0 |
0.58 |
0.9 |
1.12 |
1.1 |
1.32 |
1.41 |
1.45 |
1.49 |
1.51 |
1.48 |
1.56 |
1.57 |
1.59 |
مأخذ: Bowen,1993 : 346
در روش ميانگين هندسي كه يك روش تقريبي است، به جاي محاسبه مقدار ويژه ماكزيمم () از L استفاده ميشود (فرمول1ـ2).
(فرمول1ـ2)
كه در آن برداري است كه ضريب ماتريس مقايسه دودويی شاخصها در بردار (بردار وزن يا ضريب اهيمت شاخصها) بدست ميآيد. بررسي سازگاري قضاوتها در ماتريسهاي مقايسه دودویي شاخصها حاكي از آن است كه سازگاري درقضاوتها رعايت شده است (فرمول1ـ3).
(فرمول1ـ3)
ضریب ناسازگاری
الف) ماتريس سازگار و خصوصيات آن
اگر n معيار به شرح داشته باشيم و ماتريس مقايسه زوجي آنها به صورت زير باشد:
که در آن ترجيح عنصر را بر نشان ميدهد. چنانچه در اين ماتريس داشته باشيم:
آنگاه ميگوييم ماتريس A سازگار است. هر ماتريس سازگار داراي خصوصيات زير است:
مقدار وزن عناصر برابر مقدار استانداردشده هر عنصر مي باشد.
مقدار ويژه برابر طول ماتريس است ( ).
مقدار ناسازگاري دراين ماتريس صفر است.
ب) ماتريس ناسازگار و خصوصيات آن
قضيه يک – اگر مقادير ويژه ماتريس مقايسه زوجي A باشد مجموع مقادير آنها برابر n است.
قضيه دو – بزرگترين مقدار ويژههمواره بزرگتر يا مساوي n است (در اين صورت برخي از ها منفي خواهند بود).
قضيه سه – اگر عناصر ماتريس مقدار کمي از حالت سازگاري فاصله بگيرد ، مقدار ويژه آن نيز مقدار کمي از حالت سازگاري خود فاصله خواهد گرفت.
که در آن w و به ترتيب بردار ويژه و مقدار ويژه ماتريس A ميباشد. يک مقدار ويژه برابر n بوده (بزرگترين مقدار ويژه) و بقيه آنها برابر صفر هستند. بنابراين در اين حالت ميتوان نوشت:
در حالتي که ماتريس مقايسه زوجي A ناسازگار باشد طبق قضيه 3، کمي از n فاصله ميگيرد که ميتوان نوشت: و شاخص ناسازگاري را از طریق فرمول 4 بدست آورد.
(فرمول1ـ4)
[1]. Analytic Hierarchy Process
[2]. Tomas L. Saati
[3].Decision Analysis (DA)
[4]. Multi Attribute Utility Theory (MAUT)
[5].Multi Criteria Decision Making (MCDM)
[6].Social Judgment Theory (SJT)
[7].Analytic Hierarchy Process (AHP)
[8] Least Squares Method
[9] Logarithmic Least Squares Method
[10]Eigenvector Method
[11]Approximation Method
1. تقسيم هر عدد به مجموع آنها را نرماليزه كردن می گویند.
[13]. Reciprocal Condition
[14]. Homogeneity
[15]. Dependency
[16]. Expectation
[17].Principle of Hierarchic Composition
[18]Inconsistency Ratio (IR)
[19]. Inconsistency Index (II)
[20]. Random Index (RI)
{ "__default": { "session": { "counter": 2, "timer": { "start": 1743641196, "last": 1743641196, "now": 1743641198 }, "token": "nVHOjNkNEvRVnDFgUYhprpQ2IqvwUcen" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } } }
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iez5d_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 | iez5d_extensions | NULL | ref | extension | extension | 82 | const | 43 | 1.00 | Using where |
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.61 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.04 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:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `iez5d_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_viewlevels | NULL | ALL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 4 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM iez5d_usergroups AS a
LEFT JOIN iez5d_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 | 2 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.33 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 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:318 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM iez5d_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 | iez5d_extensions | NULL | ref | extension | extension | 82 | const | 183 | 0.40 | Using index condition; Using where; با استفاده از مرتب سازی فایل |
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 3.29 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 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:351 |
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:356 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `path`
FROM iez5d_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.18 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `file`
FROM iez5d_rsfirewall_hashes
WHERE `type`='protect'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_rsfirewall_hashes | NULL | ALL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 44 | 10.00 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_rsfirewall_configuration
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_rsfirewall_configuration | NULL | ALL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 66 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.02 ms |
System lock | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php |
8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `iez5d_rsfirewall_logs`
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.21 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.02 ms |
Opening tables | 0.20 ms |
checking permissions | 0.04 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.06 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php |
11 | RsfirewallTableLogs->__construct() | JROOT/libraries/src/Table/Table.php:328 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php |
9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php |
8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
7 | plgSystemRsfirewall->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_languages
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_languages | NULL | system | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.25 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.03 ms |
executing | 0.02 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_sh404sef/helpers/language.php:215 |
12 | Sh404sefHelperLanguage::getAllContentLanguages() | JROOT/administrator/components/com_sh404sef/helpers/language.php:167 |
11 | Sh404sefHelperLanguage::getUrlCodeFromTag() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84 |
10 | Sh404sefClassPageinfo->setCurrentLanguage() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100 |
9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:63 |
8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 iez5d_menu AS m
LEFT JOIN iez5d_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 | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 254 | 10.00 | Using index condition; Using where; با استفاده از مرتب سازی فایل |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | rostashahr_rosta.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 4.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
19 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | به نظر می رسد خط زیر فراخونده شده باشد. |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
16 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
15 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
14 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
13 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
12 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
11 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:130 |
10 | Sh404sefClassPageinfo->loadHomepages() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:102 |
9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:63 |
8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `params`
FROM iez5d_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.17 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714 |
14 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363 |
13 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
12 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/general.php:143 |
11 | Sh404sefHelperGeneral::getComponentParams() | JROOT/administrator/components/com_sh404sef/classes/config.php:638 |
10 | Sh404sefClassConfig->__construct() | JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119 |
9 | Sh404sefFactory::getConfig() | JROOT/plugins/system/sh404sef/sh404sef.php:86 |
8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `iez5d_categories` AS `s`
INNER JOIN `iez5d_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_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 222
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.38 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.03 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `alias`,`catid`
FROM `iez5d_content`
WHERE `id` = 222
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 1.46 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_rsfirewall_hashes
WHERE (`type`='3.10.8' OR `type`='protect')
AND `flag`!='C'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_rsfirewall_hashes | NULL | ALL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 44 | 17.10 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_rsfirewall_snapshots
WHERE `type`='protect'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php |
9 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `ip`,`reason`
FROM iez5d_rsfirewall_lists
WHERE (`ip`='18.222.121.40' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.16 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
10 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
9 | plgSystemRsfirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `ip`,`reason`
FROM iez5d_rsfirewall_lists
WHERE (`ip`='18.222.121.40' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
10 | plgSystemRsfirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
9 | plgSystemRsfirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_rsfirewall_exceptions
WHERE `published`='1'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
9 | plgSystemRsfirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php |
8 | plgSystemRsfirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iez5d_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.25 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | به نظر می رسد خط زیر فراخونده شده باشد. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:460 |
8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `iez5d_extensions`
SET `params` = '{\"mediaversion\":\"23c78096ff3872222664f40aef5d46f3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | iez5d_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.03 ms |
System lock | 0.16 ms |
updating | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:460 |
8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_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 | iez5d_languages | NULL | system | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
12 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
11 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:274 |
10 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:55 |
9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:478 |
8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM `iez5d_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_jcomments_settings | NULL | ALL | PRIMARY | کلید شاخصی برای استفاده نیست | NULL | NULL | 91 | 97.80 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.24 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.09 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
14 | JCommentsCfg::_load() | به نظر می رسد خط زیر فراخونده شده باشد. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/classes/config.php:159 |
11 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
10 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM iez5d_template_styles as s
LEFT JOIN iez5d_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 | 5 | 1.00 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | rostashahr_rosta.e.element | 1 | 60.00 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.21 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.18 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/components/com_jcomments/helpers/system.php:46 |
9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `iez5d_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eshopimportpro','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_jchoptimize','com_jcomments','com_jmap','com_joominaflileselling','com_joomlaupdate','com_k2','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_rsfirewall','com_rsform','com_search','com_sh404sef','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 50 | 100.00 | Using index condition |
Status | Duration |
---|---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.28 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.20 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.26 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.03 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `iez5d_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_assets | NULL | ALL | idx_asset_name,idx_parent_id | کلید شاخصی برای استفاده نیست | NULL | NULL | 1064 | 21.50 | Using where |
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
Sending data | 0.89 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.03 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNS
FROM `iez5d_content`
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.18 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Opening tables | 0.05 ms |
checking permissions | 0.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.14 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:328 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE iez5d_content
SET `hits` = (`hits` + 1)
WHERE `id` = '222'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | iez5d_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.02 ms |
System lock | 0.03 ms |
updating | 0.18 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM iez5d_content AS a
INNER JOIN iez5d_categories AS c
on c.id = a.catid
LEFT JOIN iez5d_users AS u
on u.id = a.created_by
LEFT JOIN iez5d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN iez5d_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 222
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-04-03 00:46:38')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-03 00:46:38')
AND (a.state = 1 OR a.state =2)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.17 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.44 ms |
init | 0.09 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.26 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.17 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.04 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
12 | ContentModelArticle->getItem() | JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348 |
11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `iez5d_categories` AS `s`
INNER JOIN `iez5d_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_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 116
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 | ALL | cat_idx,idx_access,idx_left_right | کلید شاخصی برای استفاده نیست | NULL | NULL | 133 | 23.74 | Using where |
Status | Duration |
---|---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.31 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.28 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
22 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
21 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
20 | ContentRouter->getCategorySegment() | به نظر می رسد خط زیر فراخونده شده باشد. |
19 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
18 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
17 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
16 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
15 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
14 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
13 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
12 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
11 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `iez5d_contentitem_tag_map` AS m
INNER JOIN `iez5d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 222
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 | 1007 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | rostashahr_rosta.m.tag_id | 1 | 99.71 | Using where |
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.36 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 10.86 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.04 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_content/views/article/view.html.php:184 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `enabled`
FROM `iez5d_extensions`
WHERE `name` = 'com_prizmimage'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_extensions | NULL | ALL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 323 | 10.00 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/plugins/content/prizmimage/prizmimage.php:459 |
14 | PrizmImageHelper::isPrizmImageComponentEnabled() | JROOT/plugins/content/prizmimage/prizmimage.php:36 |
13 | PlgContentPrizmImage->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_content/views/article/view.html.php:192 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 iez5d_fields AS a
LEFT JOIN `iez5d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN iez5d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN iez5d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN iez5d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN iez5d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `iez5d_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (116,0,114))
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 | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.15 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.67 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `iez5d_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 589
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | contact | NULL | ref | idx_state | idx_state | 1 | const | 8 | 11.11 | Using where |
Status | Duration |
---|---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.19 ms |
init | 0.03 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.14 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/plugins/content/contact/contact.php:125 |
14 | PlgContentContact->getContactData() | JROOT/plugins/content/contact/contact.php:66 |
13 | PlgContentContact->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_jmap_metainfo
WHERE `linkurl` = 'https://rostashahr.ir/amozeshi/model/222-analytic-hierarchy-process.html'
AND `published` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:350 |
17 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
15 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
14 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
13 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
12 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
11 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/plugins/system/jat3/jat3/core/template.php:1676 |
10 | T3Template->getBuffer() | JROOT/plugins/system/jat3/jat3/core/template.php:822 |
9 | T3Template->render() | JROOT/templates/jm_maktab/index.php:20 |
8 | unknown() | JROOT/templates/jm_maktab/component.php |
7 | require JROOT/templates/jm_maktab/component.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM iez5d_acymailing_config
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | iez5d_acymailing_config | NULL | ALL | NULL | کلید شاخصی برای استفاده نیست | NULL | NULL | 158 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | فراخوانده | فایل و شماره خط |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
10 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:468 |
9 | acymailing_config() | JROOT/administrator/components/com_acymailing/helpers/helper.php:1236 |
8 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/plugins/system/regacymailing/regacymailing.php:139 |
7 | plgSystemRegacymailing->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iez5d_extensions`
2 × SELECT `ip`,`reason`
FROM iez5d_rsfirewall_lists
2 × SELECT *
FROM iez5d_languages
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `iez5d_assets`
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `iez5d_categories` AS `s`
INNER JOIN `iez5d_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 *
FROM iez5d_jmap_metainfo
1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `iez5d_contact_details` AS `contact`
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 iez5d_fields AS a
LEFT JOIN `iez5d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN iez5d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN iez5d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN iez5d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN iez5d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `iez5d_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT `enabled`
FROM `iez5d_extensions`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `iez5d_contentitem_tag_map` AS m
INNER JOIN `iez5d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM iez5d_content AS a
INNER JOIN iez5d_categories AS c
on c.id = a.catid
LEFT JOIN iez5d_users AS u
on u.id = a.created_by
LEFT JOIN iez5d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN iez5d_content_rating AS v
ON a.id = v.content_id
1 × SELECT id, home, template, s.params
FROM iez5d_template_styles as s
LEFT JOIN iez5d_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM `iez5d_jcomments_settings`
1 × SELECT *
FROM iez5d_rsfirewall_exceptions
1 × SELECT *
FROM iez5d_rsfirewall_snapshots
1 × SELECT id, rules
FROM `iez5d_viewlevels
1 × SELECT *
FROM iez5d_rsfirewall_hashes
1 × SELECT `alias`,`catid`
FROM `iez5d_content`
1 × SELECT `params`
FROM iez5d_extensions
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 iez5d_menu AS m
LEFT JOIN iez5d_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM iez5d_rsfirewall_configuratio
1 × SELECT `file`
FROM iez5d_rsfirewall_hashes
1 × SELECT `path`
FROM iez5d_rsfirewall_ignored
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM iez5d_extensions
1 × SELECT b.id
FROM iez5d_usergroups AS a
LEFT JOIN iez5d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM iez5d_acymailing_confi
1 × SHOW FULL COLUMNS
FROM `iez5d_rsfirewall_logs
1 × UPDATE `iez5d_extensions`
SET `params` = '{\"mediaversion\":\"23c78096ff3872222664f40aef5d46f3\"}'
1 × SHOW FULL COLUMNS
FROM `iez5d_content
1 × UPDATE iez5d_content
SET `hits` = (`hits` + 1)