1.jpg)
**ادامه مطلب ...**
نیکان کیفیت اندیش
مشاوره سیستم های مدیریت
نیکان کیفیت اندیش
برگزاری دوره های آموزشی تخصصی
نیکان کیفیت اندیش
تدوین استاندارد های ملی
نیکان کیفیت اندیش
دریافت نشان استاندارد
- اختتامیه دومین دوره مسابقه مبلمان صادراتی (منزل) و اولین دوره مسابقه صندلی اداری استاندارد
- بازدید آقای دکتر سرشتی ریاست پژوهشگاه استاندارد از غرفه اولین دوره مسابقه صندلی اداری استاندارد
- گزارش روزنامه دنیای اقتصاد از برگزاری اولین مسابقه مبلمان صادراتی ایران
- مهلت ثبت نام مسابقه مبلمان صادراتی تا 15 آبان ماه تمدید شد
- برگزاری اولین دوره مسابقه مبلمان صادراتی ایران
اختتامیه دومین دوره مسابقه مبلمان صادراتی (منزل) و اولین دوره مسابقه صندلی اداری استاندارد
مراسم اختتامیه دومین دوره مبلمان صادراتی (منزل ) و اختتامیه اولین دوره مسابقه صندلی اداری استاندارد ، همزمان با اختتامیه نمایشگاه بین المللی مبلمان اداری در محل نمایشگاه های بین المللی ایران برگزار شد .
**ادامه مطلب ...**بازدید آقای دکتر سرشتی ریاست پژوهشگاه استاندارد از غرفه اولین دوره مسابقه صندلی اداری استاندارد
گزارش روزنامه دنیای اقتصاد از برگزاری اولین مسابقه مبلمان صادراتی ایران
با همکاری پژوهشگاه استاندارد ایران
گروه بنگاه‌ها: اتحادیه تولیدکنندگان و صادرکنندگان مبلمان ایران با هدف توسعه صادرات مبلمان کشور با حمایت و همکاری پژوهشگاه استاندارد ایران اولین دوره مسابقه مبلمان صادراتی ایران را برگزار می‌کند. دکتر بهزاد سعیدی‌رضوی رئیس پژوهشکده برق، مکانیک و ساختمان پژوهشگاه استاندارد ایران با اشاره به استراتژی پژوهشگاه استاندارد گفت: روند این مسابقه با همکاری اتحادیه تولیدکنندگان و صادرکنندگان مبلمان از هم اکنون آغاز شده و نتایج آن در دی ماه اعلام خواهد شد.
Template Settings
Color
For each color, the params below will give default values
Blue
Red
Oranges
Green
Purple
Pink
Body
Background Color
Link Color
Text Color
Header
Background Color
Select layout
Select menu
Google Font
Body Font-size
Body Font-family
Direction
**میزکار رفع اشکال جوملا**
**Time**
**Memory**
**Time**: 0.0 ms / 0.0 ms **Memory**: 0.330 MB / 0.33 MB Application: afterLoad
**Time**: 29.9 ms / 29.9 ms **Memory**: 1.730 MB / 2.06 MB Application: afterInitialise
**Time**: 4.3 ms / 34.2 ms **Memory**: 0.406 MB / 2.47 MB Application: afterRoute
**Time**: 52.7 ms / 86.8 ms **Memory**: 1.022 MB / 3.49 MB Application: afterDispatch
**Time**: 22.4 ms / 109.2 ms **Memory**: 0.362 MB / 3.85 MB Application: beforeRenderModule mod_stats (آمار سایت)
**Time**: 2.5 ms / 111.7 ms **Memory**: 0.040 MB / 3.89 MB Application: afterRenderModule mod_stats (آمار سایت)
**Time**: 0.1 ms / 111.8 ms **Memory**: 0.000 MB / 3.88 MB Application: beforeRenderModule mod_articles_latest (آخرین خبر)
**Time**: 6.9 ms / 118.7 ms **Memory**: 0.371 MB / 4.26 MB Application: afterRenderModule mod_articles_latest (آخرین خبر)
**Time**: 0.1 ms / 118.8 ms **Memory**: 0.000 MB / 4.10 MB Application: beforeRenderModule mod_articles_news (خبر های مهم)
**Time**: 4.2 ms / 123.0 ms **Memory**: 0.211 MB / 4.31 MB Application: afterRenderModule mod_articles_news (خبر های مهم)
**Time**: 0.2 ms / 123.3 ms **Memory**: 0.000 MB / 4.23 MB Application: beforeRenderModule mod_slideshowck (اسلاید تصاویر نیکان کیفیت اندیش)
**Time**: 3.2 ms / 126.5 ms **Memory**: 0.121 MB / 4.35 MB Application: afterRenderModule mod_slideshowck (اسلاید تصاویر نیکان کیفیت اندیش)
**Time**: 0.1 ms / 126.6 ms **Memory**: 0.000 MB / 4.32 MB Application: beforeRenderModule mod_search (جستجو)
**Time**: 1.1 ms / 127.8 ms **Memory**: 0.040 MB / 4.36 MB Application: afterRenderModule mod_search (جستجو)
**Time**: 0.1 ms / 127.8 ms **Memory**: 0.000 MB / 4.35 MB Application: beforeRenderModule mod_languages (انتخاب کننده زبان)
**Time**: 2.7 ms / 130.5 ms **Memory**: 0.197 MB / 4.55 MB Application: afterRenderModule mod_languages (انتخاب کننده زبان)
**Time**: 5.0 ms / 135.5 ms **Memory**: 0.143 MB / 4.69 MB Application: afterRender
**Database queries total: 96.2 ms**
5.97 MB (6**,**259**,**296 **بایت**)
**50 پرس و جو های ثبت شده** 96.2 ms
**12 duplicate found!**
- **Query Time: 0.25 ms** **Query memory: 0.013 MB Memory before query: 0.741 MB** **Rows returned: 0**
SELECT `data`
FROM `jd25f_session`
WHERE `session_id` = 'uol7o99ru6f16lk8d0qsjni292'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_session const PRIMARY PRIMARY 602 const 1 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.3 ms Reset for next command 0.0 ms JROOT/libraries/joomla/session/storage/database.php:46JROOT/libraries/joomla/session/session.php:658JROOT/libraries/joomla/session/session.php:596JROOT/libraries/cms/application/cms.php:668JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:328JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - **Query Time: 0.17 ms** **After last query: 0.57 ms** **Query memory: 0.010 MB Memory before query: 0.788 MB** **Rows returned: 0**
SELECT `session_id`
FROM `jd25f_session`
WHERE `session_id` = 'uol7o99ru6f16lk8d0qsjni292'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_session const PRIMARY PRIMARY 602 const 1 100.00 Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/cms/application/cms.php:175JROOT/libraries/cms/application/cms.php:694JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:328JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - **Query Time: 0.95 ms** **After last query: 0.13 ms** **Query memory: 0.009 MB Memory before query: 0.800 MB**
INSERT INTO `jd25f_session` (`session_id`, `client_id`, `time`)
VALUES ('uol7o99ru6f16lk8d0qsjni292', 0, '1603298926')**EXPLAIN not possible on query: INSERT INTO `jd25f_session` (`session_id`, `client_id`, `time`) VALUES ('uol7o99ru6f16lk8d0qsjni292', 0, '1603298926')**Status Duration Starting 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Init for update 0.0 ms Update 0.0 ms Waiting for query cache lock 0.0 ms Update 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.8 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/application/cms.php:207JROOT/libraries/cms/application/cms.php:694JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:328JROOT/libraries/joomla/factory.php:124JROOT/index.php:37 - **Query Time: 0.25 ms** **After last query: 0.83 ms** **Query memory: 0.012 MB Memory before query: 0.880 MB** **Rows returned: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jd25f_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/application/site.php:570JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.08 ms** **After last query: 0.43 ms** **Query memory: 0.012 MB Memory before query: 0.897 MB** **Rows returned: 2**
SELECT b.id
FROM jd25f_usergroups AS a
LEFT JOIN jd25f_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 100.00 Using where; Using index Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/access/access.php:334JROOT/libraries/joomla/access/access.php:403JROOT/libraries/joomla/user/user.php:428JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 1.83 ms** **After last query: 0.15 ms** **Query memory: 0.011 MB Memory before query: 0.916 MB** **Rows returned: 5**
SELECT id, rules
FROM `jd25f_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_viewlevels ALL NULL **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 5 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 1.6 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/joomla/access/access.php:420JROOT/libraries/joomla/user/user.php:428JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.42 ms** **After last query: 0.22 ms** **Query memory: 0.009 MB Memory before query: 0.935 MB** **Rows returned: 55**
SELECT folder AS type, element AS name, params
FROM jd25f_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref extension extension 62 const 58 100.00 Using index condition; Using where; **استفاده از مرتب سازی فایل** Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.2 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/cms/plugin/helper.php:312JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.08 ms** **After last query: 1.14 ms** **Query memory: 0.011 MB Memory before query: 1.065 MB** **Rows returned: 2**
SELECT *
FROM jd25f_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_languages ALL NULL **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 2 100.00 Using where; **استفاده از مرتب سازی فایل** Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/language/helper.php:166JROOT/plugins/system/languagefilter/languagefilter.php:67JROOT/libraries/cms/plugin/helper.php:257JROOT/libraries/cms/plugin/helper.php:172JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.20 ms** **After last query: 0.22 ms** **Query memory: 0.015 MB Memory before query: 1.101 MB** **Rows returned: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jd25f_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/plugins/system/languagefilter/languagefilter.php:69JROOT/libraries/cms/plugin/helper.php:257JROOT/libraries/cms/plugin/helper.php:172JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.07 ms** **After last query: 0.23 ms** **Query memory: 0.011 MB Memory before query: 1.104 MB** **Rows returned: 1**
SELECT COUNT(*)
FROM `jd25f_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 20 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32JROOT/plugins/system/languagefilter/languagefilter.php:71JROOT/libraries/cms/plugin/helper.php:257JROOT/libraries/cms/plugin/helper.php:172JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.21 ms** **After last query: 5.34 ms** **Query memory: 0.011 MB Memory before query: 1.415 MB** **Rows returned: 1**
SELECT `enabled`
FROM `jd25f_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/plugins/system/backuponupdate/backuponupdate.php:50JROOT/libraries/cms/plugin/helper.php:232JROOT/libraries/cms/plugin/helper.php:172JROOT/libraries/cms/application/cms.php:582JROOT/libraries/cms/application/site.php:649JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.08 ms** **After last query: 3.18 ms** **Query memory: 0.015 MB Memory before query: 1.595 MB** **Rows returned: 1**
SELECT template
FROM jd25f_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_template_styles ALL idx_home **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 10 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/plugins/system/yt/yt.php:162JROOT/plugins/system/yt/includes/core/defines.php:28JROOT/plugins/system/yt/yt.php:18JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:583JROOT/libraries/cms/application/site.php:649JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.46 ms** **After last query: 8.66 ms** **Query memory: 0.018 MB Memory before query: 2.083 MB** **Rows returned: 19**
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 jd25f_menu AS m
LEFT JOIN jd25f_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.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 19 100.00 Using index condition; Using where; **استفاده از مرتب سازی فایل** 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 nkair_nka.m.component_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms Waiting for query cache lock 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/menu/site.php:47JROOT/libraries/cms/menu/menu.php:64JROOT/libraries/cms/menu/menu.php:118JROOT/libraries/cms/application/cms.php:353JROOT/libraries/cms/application/site.php:279JROOT/libraries/cms/router/site.php:218JROOT/libraries/cms/router/router.php:408JROOT/libraries/cms/router/router.php:192JROOT/libraries/cms/router/site.php:90JROOT/libraries/cms/application/cms.php:1018JROOT/libraries/cms/application/site.php:749JROOT/libraries/cms/application/site.php:231JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.21 ms** **After last query: 1.37 ms** **Query memory: 0.022 MB Memory before query: 2.378 MB** **Rows returned: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jd25f_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using index condition Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/library/helper.php:156JROOT/libraries/cms/library/helper.php:47JROOT/libraries/cms/library/helper.php:90JROOT/libraries/cms/version/version.php:179JROOT/libraries/joomla/factory.php:734JROOT/libraries/joomla/factory.php:215JROOT/plugins/system/sef/sef.php:30JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1027JROOT/libraries/cms/application/site.php:749JROOT/libraries/cms/application/site.php:231JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 1.02 ms** **After last query: 0.17 ms** **Query memory: 0.017 MB Memory before query: 2.386 MB**
UPDATE `jd25f_extensions`
SET `params` = '{\"mediaversion\":\"5c3973f1a44f8198ff217a755ce0f00c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions range element_clientid,element_folder_clientid,extension extension 364 NULL 1 100.00 Using where Status Duration Starting 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Init for update 0.0 ms Updating 0.0 ms End of update loop 0.0 ms Waiting for query cache lock 0.0 ms End of update loop 0.2 ms Query end 0.0 ms Commit 0.6 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/library/helper.php:119JROOT/libraries/cms/version/version.php:230JROOT/libraries/cms/version/version.php:189JROOT/libraries/joomla/factory.php:734JROOT/libraries/joomla/factory.php:215JROOT/plugins/system/sef/sef.php:30JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1027JROOT/libraries/cms/application/site.php:749JROOT/libraries/cms/application/site.php:231JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.22 ms** **After last query: 0.67 ms** **Query memory: 0.013 MB Memory before query: 2.486 MB** **Rows returned: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jd25f_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/application/site.php:328JROOT/libraries/cms/application/site.php:135JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.27 ms** **After last query: 0.45 ms** **Query memory: 0.008 MB Memory before query: 2.521 MB** **Rows returned: 8**
SELECT id, home, template, s.params
FROM jd25f_template_styles as s
LEFT JOIN jd25f_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 = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_template **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 10 100.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 nkair_nka.s.template,const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/cms/application/site.php:486JROOT/libraries/cms/application/site.php:165JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.19 ms** **After last query: 3.51 ms** **Query memory: 0.022 MB Memory before query: 2.790 MB** **Rows returned: 1**
SELECT a.rules
FROM jd25f_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/access/access.php:248JROOT/libraries/joomla/user/user.php:364JROOT/components/com_content/models/article.php:55JROOT/libraries/legacy/model/legacy.php:415JROOT/components/com_content/models/article.php:75JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/article/view.html.php:44JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.08 ms** **After last query: 0.25 ms** **Query memory: 0.023 MB Memory before query: 2.823 MB** **Rows returned: 2**
SELECT b.rules
FROM jd25f_assets AS a
LEFT JOIN jd25f_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; **استفاده از مرتب سازی فایل** 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 10 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/access/access.php:248JROOT/libraries/joomla/access/access.php:109JROOT/libraries/joomla/user/user.php:373JROOT/components/com_content/models/article.php:55JROOT/libraries/legacy/model/legacy.php:415JROOT/components/com_content/models/article.php:75JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/article/view.html.php:44JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.91 ms** **After last query: 0.30 ms** **Query memory: 0.017 MB Memory before query: 2.863 MB** **Rows returned: 1**
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 jd25f_content AS a
LEFT JOIN jd25f_categories AS c
on c.id = a.catid
LEFT JOIN jd25f_users AS u
on u.id = a.created_by
LEFT JOIN jd25f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jd25f_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.language in ('fa-IR','*')
AND a.id = 14
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-21 16:48:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-21 16:48:46')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a const PRIMARY,idx_state,idx_language PRIMARY 4 const 1 100.00 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 100.00 1 PRIMARY u const PRIMARY PRIMARY 4 const 1 100.00 1 PRIMARY parent const PRIMARY PRIMARY 4 const 1 100.00 1 PRIMARY v const PRIMARY PRIMARY 4 const 0 0.00 Unique row not found 1 PRIMARY <derived2> ref key0 key0 5 const 0 0.00 2 LATERAL DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 1 100.00 Using index condition 2 LATERAL DERIVED cat const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.1 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Statistics 0.5 ms Preparing 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Removing tmp table 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/components/com_content/models/article.php:158JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/article/view.html.php:44JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.09 ms** **After last query: 0.62 ms** **Query memory: 0.018 MB Memory before query: 2.970 MB** **Rows returned: 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 jd25f_categories as c
LEFT JOIN jd25f_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=2
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; **استفاده از مرتب سازی فایل** 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 9 66.67 Using where 1 PRIMARY <derived2> ref key0 key0 5 nkair_nka.c.id 2 100.00 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; **استفاده از مرتب سازی فایل** 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 9 100.00 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/legacy/categories/categories.php:288JROOT/libraries/legacy/categories/categories.php:181JROOT/components/com_content/helpers/route.php:41JROOT/components/com_content/views/article/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.20 ms** **After last query: 0.86 ms** **Query memory: 0.021 MB Memory before query: 3.055 MB** **Rows returned: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jd25f_extensions
WHERE `type` = 'component'
AND `element` = 'com_tags'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/libraries/cms/helper/tags.php:392JROOT/components/com_content/views/article/view.html.php:155JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.66 ms** **After last query: 0.14 ms** **Query memory: 0.016 MB Memory before query: 3.065 MB** **Rows returned: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 14
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.4 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/views/article/view.html.php:155JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.45 ms** **After last query: 1.52 ms** **Query memory: 0.022 MB Memory before query: 3.200 MB** **Rows returned: 30**
SHOW FULL COLUMNS
FROM `jd25f_content`**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jd25f_content`**Status Duration Starting 0.0 ms Checking permissions 0.0 ms Closing tables 0.0 ms Opening tables 0.1 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Filling schema table 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms Checking permissions 0.1 ms Closing tables 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Removing tmp table 0.1 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/table/table.php:237JROOT/libraries/joomla/table/table.php:158JROOT/libraries/legacy/table/content.php:31JROOT/libraries/joomla/table/table.php:301JROOT/components/com_content/models/article.php:263JROOT/components/com_content/views/article/view.html.php:176JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.21 ms** **After last query: 0.70 ms** **Query memory: 0.017 MB Memory before query: 3.328 MB** **Rows returned: 1**
SELECT *
FROM jd25f_content
WHERE `id` = '14'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_content const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/table/table.php:723JROOT/components/com_content/models/article.php:264JROOT/components/com_content/views/article/view.html.php:176JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 34.69 ms** **After last query: 0.15 ms** **Query memory: 0.016 MB Memory before query: 3.349 MB**
UPDATE jd25f_content
SET `hits` = (`hits` + 1)
WHERE `id` = '14'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_content range PRIMARY PRIMARY 4 NULL 1 100.00 Using where Status Duration Starting 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Init for update 0.0 ms Updating 0.0 ms End of update loop 0.0 ms Waiting for query cache lock 0.0 ms End of update loop 0.6 ms Query end 0.0 ms Commit 33.9 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/table/table.php:1233JROOT/components/com_content/models/article.php:265JROOT/components/com_content/views/article/view.html.php:176JROOT/libraries/legacy/controller/legacy.php:693JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.26 ms** **After last query: 3.82 ms** **Query memory: 0.013 MB Memory before query: 3.432 MB** **Rows returned: 0****Duplicate queries**: #48
SELECT m2.language, m2.id
FROM jd25f_menu as m
INNER JOIN jd25f_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN jd25f_associations as a2
ON a.key=a2.key
INNER JOIN jd25f_menu as m2
ON a2.id=m2.id
WHERE m.id=101id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_menus/helpers/menus.php:257JROOT/plugins/system/languagefilter/languagefilter.php:592JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.76 ms** **After last query: 0.43 ms** **Query memory: 0.015 MB Memory before query: 3.457 MB** **Rows returned: 1****Duplicate queries**: #49
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jd25f_content` AS `c`
INNER JOIN `jd25f_associations` AS `a`
ON a.id = c.id
AND a.context='com_content.item'
INNER JOIN `jd25f_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `jd25f_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jd25f_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 14id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 1 SIMPLE a2 ref idx_key idx_key 96 const 1 100.00 Using index 1 SIMPLE c2 eq_ref PRIMARY,idx_catid PRIMARY 4 nkair_nka.a2.id 1 100.00 Using where 1 SIMPLE ca eq_ref PRIMARY,cat_idx PRIMARY 4 nkair_nka.c2.catid 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.4 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.1 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/language/associations.php:83JROOT/components/com_content/helpers/association.php:48JROOT/plugins/system/languagefilter/languagefilter.php:603JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - **Query Time: 0.19 ms** **After last query: 1.35 ms** **Query memory: 0.015 MB Memory before query: 3.530 MB** **Rows returned: 1**
SELECT template_style_id
FROM jd25f_menu
WHERE id = 101id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_menu const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/plugins/system/yt/includes/site/lib/yt_template.php:112JROOT/plugins/system/yt/includes/site/lib/yt_template.php:28JROOT/templates/sj_plus/includes/frame_inc.php:37JROOT/templates/sj_plus/index.php:21JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.08 ms** **After last query: 0.06 ms** **Query memory: 0.015 MB Memory before query: 3.546 MB** **Rows returned: 1**
SELECT id
FROM jd25f_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_template_styles ALL idx_home **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 10 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/plugins/system/yt/includes/site/lib/yt_template.php:116JROOT/plugins/system/yt/includes/site/lib/yt_template.php:28JROOT/templates/sj_plus/includes/frame_inc.php:37JROOT/templates/sj_plus/index.php:21JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.43 ms** **After last query: 0.72 ms** **Query memory: 0.020 MB Memory before query: 3.593 MB** **Rows returned: 9**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jd25f_modules AS m
LEFT JOIN jd25f_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jd25f_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-21 16:48:46')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-21 16:48:46')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
AND m.language IN ('fa-IR','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 13 100.00 Using index condition; Using where; **استفاده از مرتب سازی فایل** 1 SIMPLE mm ref PRIMARY PRIMARY 4 nkair_nka.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 nkair_nka.m.module,const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/module/helper.php:376JROOT/libraries/cms/module/helper.php:84JROOT/libraries/joomla/document/html/html.php:497JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:182JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:109JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:43JROOT/templates/sj_plus/includes/frame_inc.php:82JROOT/templates/sj_plus/index.php:21JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.22 ms** **After last query: 7.28 ms** **Query memory: 0.013 MB Memory before query: 3.750 MB** **Rows returned: 1****Duplicate queries**: #33
SELECT home
FROM jd25f_menu
WHERE id=101id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_menu const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/plugins/system/yt/includes/site/lib/yt_template.php:101JROOT/templates/sj_plus/index.php:47JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.08 ms** **After last query: 0.06 ms** **Query memory: 0.013 MB Memory before query: 3.764 MB** **Rows returned: 1****Duplicate queries**: #32
SELECT home
FROM jd25f_menu
WHERE id=101id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_menu const PRIMARY PRIMARY 4 const 1 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/plugins/system/yt/includes/site/lib/yt_template.php:102JROOT/templates/sj_plus/index.php:47JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.21 ms** **After last query: 3.29 ms** **Query memory: 0.033 MB Memory before query: 3.971 MB** **Rows returned: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jd25f_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:91JROOT/components/com_contact/router.php:37JROOT/libraries/cms/router/site.php:463JROOT/libraries/cms/router/site.php:426JROOT/libraries/cms/router/router.php:231JROOT/libraries/cms/router/site.php:106JROOT/libraries/joomla/application/route.php:64JROOT/templates/sj_plus/menusys/ytmenu.php:353JROOT/templates/sj_plus/menusys/class/moo/tmpl/default.php:61JROOT/templates/sj_plus/menusys/ytmenu.php:150JROOT/templates/sj_plus/menusys/class/moo/tmpl/default.php:29JROOT/templates/sj_plus/menusys/ytmenu.php:150JROOT/plugins/system/yt/includes/site/lib/yt_template.php:195JROOT/plugins/system/yt/includes/site/lib/yt_template.php:385JROOT/plugins/system/yt/includes/site/lib/yt_template.php:301JROOT/templates/sj_plus/index.php:149JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.09 ms** **After last query: 8.91 ms** **Query memory: 0.015 MB Memory before query: 3.822 MB** **Rows returned: 2**
SELECT b.rules
FROM jd25f_assets AS a
LEFT JOIN jd25f_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_menus')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; **استفاده از مرتب سازی فایل** 1 SIMPLE b ALL idx_lft_rgt **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 113 44.25 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/access/access.php:248JROOT/libraries/joomla/access/access.php:109JROOT/libraries/joomla/user/user.php:373JROOT/libraries/joomla/document/html/renderer/modules.php:42JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.64 ms** **After last query: 1.71 ms** **Query memory: 0.016 MB Memory before query: 3.880 MB** **Rows returned: 1**
SELECT SUM(hits) AS count_hits
FROM jd25f_content
WHERE state = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_content ref idx_state idx_state 1 const 27 100.00 Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.5 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/modules/mod_stats/helper.php:128JROOT/modules/mod_stats/mod_stats.php:18JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.82 ms** **After last query: 2.12 ms** **Query memory: 0.020 MB Memory before query: 3.976 MB** **Rows returned: 5**
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jd25f_content AS a
LEFT JOIN jd25f_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jd25f_categories AS c
ON c.id = a.catid
LEFT JOIN jd25f_users AS ua
ON ua.id = a.created_by
LEFT JOIN jd25f_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jd25f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jd25f_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-21 16:48:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-21 16:48:46')
AND a.language in ('fa-IR','*')
ORDER BY a.created DESC
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 PRIMARY a ref idx_access,idx_catid,idx_language idx_catid 4 const 13 100.00 Using where; **استفاده از مرتب سازی فایل** 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 nkair_nka.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 nkair_nka.a.modified_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 nkair_nka.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 1 100.00 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; **استفاده از مرتب سازی فایل** 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 9 100.00 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.1 ms Checking permissions 0.0 ms Opening tables 0.1 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.1 ms Optimizing 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.0 ms Removing tmp table 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.1 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Removing tmp table 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_content/models/articles.php:537JROOT/modules/mod_articles_latest/helper.php:112JROOT/modules/mod_articles_latest/mod_articles_latest.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.25 ms** **After last query: 0.38 ms** **Query memory: 0.018 MB Memory before query: 4.082 MB** **Rows returned: 0****Duplicate queries**: #45
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 29
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_latest/helper.php:112JROOT/modules/mod_articles_latest/mod_articles_latest.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.24 ms** **After last query: 0.26 ms** **Query memory: 0.018 MB Memory before query: 4.120 MB** **Rows returned: 0****Duplicate queries**: #46
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 27
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_latest/helper.php:112JROOT/modules/mod_articles_latest/mod_articles_latest.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.22 ms** **After last query: 0.26 ms** **Query memory: 0.018 MB Memory before query: 4.157 MB** **Rows returned: 0****Duplicate queries**: #47
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 25
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_latest/helper.php:112JROOT/modules/mod_articles_latest/mod_articles_latest.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.25 ms** **After last query: 0.25 ms** **Query memory: 0.018 MB Memory before query: 4.195 MB** **Rows returned: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 24
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_latest/helper.php:112JROOT/modules/mod_articles_latest/mod_articles_latest.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.25 ms** **After last query: 0.21 ms** **Query memory: 0.018 MB Memory before query: 4.228 MB** **Rows returned: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 22
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Executing 0.0 ms Sending data 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_latest/helper.php:112JROOT/modules/mod_articles_latest/mod_articles_latest.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.73 ms** **After last query: 0.12 ms** **Query memory: 0.020 MB Memory before query: 4.252 MB** **Rows returned: 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 jd25f_categories as c
LEFT JOIN jd25f_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=8
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; **استفاده از مرتب سازی فایل** 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 9 66.67 Using where 1 PRIMARY <derived2> ref key0 key0 5 nkair_nka.c.id 2 100.00 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; **استفاده از مرتب سازی فایل** 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 9 100.00 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.1 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Optimizing 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Statistics 0.1 ms Preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.0 ms Removing tmp table 0.0 ms Creating sort index 0.1 ms Creating sort index 0.0 ms Removing tmp table 0.1 ms Creating sort index 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Removing tmp table 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.0 ms Reset for next command 0.0 ms JROOT/libraries/legacy/categories/categories.php:288JROOT/libraries/legacy/categories/categories.php:181JROOT/components/com_content/helpers/route.php:41JROOT/modules/mod_articles_latest/helper.php:122JROOT/modules/mod_articles_latest/mod_articles_latest.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.63 ms** **After last query: 2.32 ms** **Query memory: 0.020 MB Memory before query: 4.147 MB** **Rows returned: 3**
SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jd25f_content AS a
LEFT JOIN jd25f_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jd25f_categories AS c
ON c.id = a.catid
LEFT JOIN jd25f_users AS ua
ON ua.id = a.created_by
LEFT JOIN jd25f_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jd25f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jd25f_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-21 16:48:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-21 16:48:46')
AND a.language in ('fa-IR','*')
ORDER BY a.publish_up DESC
LIMIT 0, 3id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 1 PRIMARY a ref idx_access,idx_catid,idx_language idx_catid 4 const 13 100.00 Using where; **استفاده از مرتب سازی فایل** 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 nkair_nka.a.created_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 nkair_nka.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref key0 key0 5 const 1 100.00 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; **استفاده از مرتب سازی فایل** 2 DERIVED cat index PRIMARY,idx_left_right idx_left_right 8 NULL 9 100.00 Using where; Using index; Using join buffer (flat, BNL join) Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.1 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Waiting for query cache lock 0.0 ms Init 0.1 ms Optimizing 0.0 ms Optimizing 0.0 ms Statistics 0.0 ms Statistics 0.0 ms Preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms Preparing 0.0 ms Unlocking tables 0.0 ms Preparing 0.0 ms Sorting result 0.0 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms Executing 0.0 ms Sending data 0.0 ms Creating sort index 0.0 ms Removing tmp table 0.0 ms Creating sort index 0.0 ms Waiting for query cache lock 0.0 ms Creating sort index 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 0.0 ms Closing tables 0.0 ms Removing tmp table 0.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Waiting for query cache lock 0.0 ms Updating status 0.0 ms Storing result in query cache 0.1 ms Reset for next command 0.0 ms JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_content/models/articles.php:537JROOT/modules/mod_articles_news/helper.php:82JROOT/modules/mod_articles_news/mod_articles_news.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.07 ms** **After last query: 0.33 ms** **Query memory: 0.019 MB Memory before query: 4.230 MB** **Rows returned: 0****Duplicate queries**: #38
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 29
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_news/helper.php:82JROOT/modules/mod_articles_news/mod_articles_news.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.07 ms** **After last query: 0.27 ms** **Query memory: 0.018 MB Memory before query: 4.268 MB** **Rows returned: 0****Duplicate queries**: #39
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 27
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_news/helper.php:82JROOT/modules/mod_articles_news/mod_articles_news.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.06 ms** **After last query: 0.24 ms** **Query memory: 0.018 MB Memory before query: 4.306 MB** **Rows returned: 0****Duplicate queries**: #40
SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 25
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type,idx_tag **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL 32 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nkair_nka.m.tag_id 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_content/models/articles.php:663JROOT/modules/mod_articles_news/helper.php:82JROOT/modules/mod_articles_news/mod_articles_news.php:15JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.09 ms** **After last query: 6.83 ms** **Query memory: 0.017 MB Memory before query: 4.386 MB** **Rows returned: 0****Duplicate queries**: #27
SELECT m2.language, m2.id
FROM jd25f_menu as m
INNER JOIN jd25f_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN jd25f_associations as a2
ON a.key=a2.key
INNER JOIN jd25f_menu as m2
ON a2.id=m2.id
WHERE m.id=101id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL **هیچ کلید شاخصی را نمی توان استفاده کرد** NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/administrator/components/com_menus/helpers/menus.php:257JROOT/modules/mod_languages/helper.php:58JROOT/modules/mod_languages/mod_languages.php:18JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 0.06 ms** **After last query: 0.27 ms** **Query memory: 0.019 MB Memory before query: 4.407 MB** **Rows returned: 1****Duplicate queries**: #28
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jd25f_content` AS `c`
INNER JOIN `jd25f_associations` AS `a`
ON a.id = c.id
AND a.context='com_content.item'
INNER JOIN `jd25f_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `jd25f_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jd25f_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 14id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 1 SIMPLE a2 ref idx_key idx_key 96 const 1 100.00 Using index 1 SIMPLE c2 eq_ref PRIMARY,idx_catid PRIMARY 4 nkair_nka.a2.id 1 100.00 Using where 1 SIMPLE ca eq_ref PRIMARY,cat_idx PRIMARY 4 nkair_nka.c2.catid 1 100.00 Using where Status Duration Starting 0.0 ms Waiting for query cache lock 0.0 ms Init 0.0 ms Checking query cache for query 0.0 ms Checking privileges on cached 0.0 ms Checking permissions 0.0 ms Sending cached result to clien 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/cms/language/associations.php:83JROOT/components/com_content/helpers/association.php:48JROOT/modules/mod_languages/helper.php:69JROOT/modules/mod_languages/mod_languages.php:18JROOT/libraries/cms/module/helper.php:190JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:40 - **Query Time: 45.22 ms** **After last query: 6.77 ms** **Query memory: 0.003 MB Memory before query: 4.688 MB**
UPDATE `jd25f_session`
SET `data` = 'NwJixFhz9G7xqL0nie05o_l3PgkQrQcYBT__8qCMK5_z0qUJbnGcIN_MApTbSyy8Heq0sSN9ZlE9dxK4QMQZ_P925l-viD8i8IsU2TStV65lANccqVCcbzMg1nqq-cJLT94_uj7LpEWBRDmi-GOERZsfm6t9WcAjxdvlS5z5A0oDrWLgA5yPK63iUFamfGTjSPjQos1CDQ9PyDLBhCU4Ltfl5BzHKlY85HA2zRbSnk4UPQnnqoI9o-5AyO5AQpTAjlU8O_mnuZI4EmBb3ywncs5L1wtZC_f6NiPnnpNolGQOnzM6K-W7V5zSV-V-vEo2GVMEAa4FkvW0dB48J02AjVBSy7Q-mK4RwkloMe5nA76wGEssJNOS3wcA8FoTdAC5_hWEQEAoaX3ukWQOEp-PzNgnti8MaiFv_mYF_cBWfkilXWMFw0bV6-2R2QbpY-K0NEAPtsDSUEbMx3L-u9lRV_GbEkTCZ6zNszp-faqpeASnjXekhmm-TVBe8FiodTCkVpAVbH62KXl_jUzPpbPREpdXjY5KdsV5Xj-7jJXxpHiYZjNo5gHflRY0nxvZqm5LW5EHxVJf3ZqkTQAxe3GCeF3kMwlEIS7gtZ8leSzn-OCWNv3tSuuOL39BTp8e13SiEwRqYfxfwMSzHfRkMHM2Yn3bHaImiljiYTqQzEgQAe7XyYyvJuGy8jQbAi12LUT8aiZuyck3yvcirJJsXlJcdk9KEZvTFOaJZ-neVopzJAyPslK9hwlZpk04CUCHKHbHJ4ySZZlw2Ay8KT96JMgZhe3A0n9QM6kQ1JOWU5lPM74qUVE-lszAMm-MZjtmenbpt62m3MTSH1ZlTuhz9lpa9PCtOf20f7qCd1XFqjMtbSkfOkO2CHAvszkQ0n741jakmGQwVWXBuSKofbcyvzLDtiSFuhCwhuFtvGp24Nm5R9WBBWfgOcCS2k_08KkY7PQkiZpjpqJ4tfDVUJN6uJHVMpHf-5WqQXTwosM5riOaN6QgaXV1DqV-Qqm9PkygKNr9lBdlnUgewGrIrKQ3OutW7dQv7etQhMPVcDPyQeUH3xLQzpNSVsDoPX7z5f5T89or5TXc_VMgjA4LDVxVg02CIXFguj2i-DLwRDC7J6kvdhqNLomaqUIm2zOwmy_-bB4bx7cBsyHI9cymI1Pp9TCqeZS9Hj2Dx-RrHccyZ1Q9IgGxouPLmIPv53OO4lwarOhdUbYxVJa6ZM3RhFJmETIj_gJj_r3-Czs2CGq6Q-UqzX7ad6W2FgYKBQIgnFmsWnPH0KlIUH2JnOKgkdYe5f_-plv9xhfRZrYsEoEgsZgJc1E.' , `time` = '1603298926'
WHERE `session_id` = 'uol7o99ru6f16lk8d0qsjni292'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jd25f_session range PRIMARY PRIMARY 602 NULL 1 100.00 Using where Status Duration Starting 0.0 ms Checking permissions 0.0 ms Opening tables 0.0 ms After opening tables 0.0 ms System lock 0.0 ms Table lock 0.0 ms Init for update 0.0 ms Updating 0.0 ms End of update loop 0.0 ms Waiting for query cache lock 0.0 ms End of update loop 0.0 ms Query end 0.0 ms Commit 45.0 ms Closing tables 0.0 ms Unlocking tables 0.0 ms Closing tables 0.0 ms Starting cleanup 0.0 ms Freeing items 0.0 ms Updating status 0.0 ms Reset for next command 0.0 ms JROOT/libraries/joomla/session/storage/database.php:85
**32 نوع پرس و جو پایان یافته، مرتب شده بر اساس رخنمون.**
**انتخاب جداول:**
**9 × SELECT `m`.`tag_id`,`t`.*
FROM `jd25f_contentitem_tag_map` AS m
INNER JOIN `jd25f_tags` AS t
ON `m`.`tag_id` = `t`.`id`****6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jd25f_extensions****2 × SELECT home
FROM jd25f_menu****2 × SELECT m2.language, m2.id
FROM jd25f_menu as m
INNER JOIN jd25f_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN jd25f_associations as a2
ON a.key=a2.key
INNER JOIN jd25f_menu as m2
ON a2.id=m2.id****2 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jd25f_content` AS `c`
INNER JOIN `jd25f_associations` AS `a`
ON a.id = c.id
AND a.context='com_content.item'
INNER JOIN `jd25f_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `jd25f_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jd25f_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'****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 jd25f_categories as c
LEFT JOIN jd25f_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt****2 × SELECT b.rules
FROM jd25f_assets AS a
LEFT JOIN jd25f_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt****1 × SELECT id
FROM jd25f_template_styles****1 × SELECT template_style_id
FROM jd25f_menu****1 × SELECT b.id
FROM jd25f_usergroups AS a
LEFT JOIN jd25f_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt****1 × SELECT id, rules
FROM `jd25f_viewlevels****1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jd25f_modules AS m
LEFT JOIN jd25f_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jd25f_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id****1 × SELECT `session_id`
FROM `jd25f_session`****1 × SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jd25f_content AS a
LEFT JOIN jd25f_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jd25f_categories AS c
ON c.id = a.catid
LEFT JOIN jd25f_users AS ua
ON ua.id = a.created_by
LEFT JOIN jd25f_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jd25f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jd25f_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt****1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jd25f_content AS a
LEFT JOIN jd25f_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jd25f_categories AS c
ON c.id = a.catid
LEFT JOIN jd25f_users AS ua
ON ua.id = a.created_by
LEFT JOIN jd25f_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jd25f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jd25f_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt****1 × SELECT SUM(hits) AS count_hits
FROM jd25f_content****1 × SELECT *
FROM jd25f_content****1 × SELECT folder AS type, element AS name, params
FROM jd25f_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 jd25f_menu AS m
LEFT JOIN jd25f_extensions AS e
ON m.component_id = e.extension_id****1 × SELECT template
FROM jd25f_template_styles****1 × SELECT `enabled`
FROM `jd25f_extensions`****1 × SELECT id, home, template, s.params
FROM jd25f_template_styles as s
LEFT JOIN jd25f_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id****1 × SELECT a.rules
FROM jd25f_assets AS a****1 × SELECT *
FROM jd25f_languages****1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 jd25f_content AS a
LEFT JOIN jd25f_categories AS c
on c.id = a.catid
LEFT JOIN jd25f_users AS u
on u.id = a.created_by
LEFT JOIN jd25f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jd25f_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jd25f_categories AS cat JOIN jd25f_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt****1 × SELECT `data`
FROM `jd25f_session`****1 × SELECT COUNT(*)
FROM `jd25f_menu`**
**سایر جداول:**
**1 × UPDATE `jd25f_session`
SET `data` = 'NwJixFhz9G7xqL0nie05o_l3PgkQrQcYBT__8qCMK5_z0qUJbnGcIN_MApTbSyy8Heq0sSN9ZlE9dxK4QMQZ_P925l-viD8i8IsU2TStV65lANccqVCcbzMg1nqq-cJLT94_uj7LpEWBRDmi-GOERZsfm6t9WcAjxdvlS5z5A0oDrWLgA5yPK63iUFamfGTjSPjQos1CDQ9PyDLBhCU4Ltfl5BzHKlY85HA2zRbSnk4UPQnnqoI9o-5AyO5AQpTAjlU8O_mnuZI4EmBb3ywncs5L1wtZC_f6NiPnnpNolGQOnzM6K-W7V5zSV-V-vEo2GVMEAa4FkvW0dB48J02AjVBSy7Q-mK4RwkloMe5nA76wGEssJNOS3wcA8FoTdAC5_hWEQEAoaX3ukWQOEp-PzNgnti8MaiFv_mYF_cBWfkilXWMFw0bV6-2R2QbpY-K0NEAPtsDSUEbMx3L-u9lRV_GbEkTCZ6zNszp-faqpeASnjXekhmm-TVBe8FiodTCkVpAVbH62KXl_jUzPpbPREpdXjY5KdsV5Xj-7jJXxpHiYZjNo5gHflRY0nxvZqm5LW5EHxVJf3ZqkTQAxe3GCeF3kMwlEIS7gtZ8leSzn-OCWNv3tSuuOL39BTp8e13SiEwRqYfxfwMSzHfRkMHM2Yn3bHaImiljiYTqQzEgQAe7XyYyvJuGy8jQbAi12LUT8aiZuyck3yvcirJJsXlJcdk9KEZvTFOaJZ-neVopzJAyPslK9hwlZpk04CUCHKHbHJ4ySZZlw2Ay8KT96JMgZhe3A0n9QM6kQ1JOWU5lPM74qUVE-lszAMm-MZjtmenbpt62m3MTSH1ZlTuhz9lpa9PCtOf20f7qCd1XFqjMtbSkfOkO2CHAvszkQ0n741jakmGQwVWXBuSKofbcyvzLDtiSFuhCwhuFtvGp24Nm5R9WBBWfgOcCS2k_08KkY7PQkiZpjpqJ4tfDVUJN6uJHVMpHf-5WqQXTwosM5riOaN6QgaXV1DqV-Qqm9PkygKNr9lBdlnUgewGrIrKQ3OutW7dQv7etQhMPVcDPyQeUH3xLQzpNSVsDoPX7z5f5T89or5TXc_VMgjA4LDVxVg02CIXFguj2i-DLwRDC7J6kvdhqNLomaqUIm2zOwmy_-bB4bx7cBsyHI9cymI1Pp9TCqeZS9Hj2Dx-RrHccyZ1Q9IgGxouPLmIPv53OO4lwarOhdUbYxVJa6ZM3RhFJmETIj_gJj_r3-Czs2CGq6Q-UqzX7ad6W2FgYKBQIgnFmsWnPH0KlIUH2JnOKgkdYe5f_-plv9xhfRZrYsEoEgsZgJc1E.' , `time` = '1603298926'****1 × UPDATE jd25f_content
SET `hits` = (`hits` + 1)****1 × SHOW FULL COLUMNS
FROM `jd25f_content****1 × UPDATE `jd25f_extensions`
SET `params` = '{\"mediaversion\":\"5c3973f1a44f8198ff217a755ce0f00c\"}'****1 × INSERT INTO `jd25f_session` (`session_id`, `client_id`, `time`)
VALUES ('uol7o99ru6f16lk8d0qsjni292', 0, '1603298926'**
- JROOT/language/en-GB/en-GB.tpl_sj_plus.ini : خطا در خط های 156
- JROOT/templates/sj_plus/language/en-GB/en-GB.tpl_sj_plus.ini : خطا در خط های 156
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.ini
- **خوانده شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_logout.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.lib_joomla.ini
- **خوانده نشده** : JROOT/language/fa-IR/fa-IR.tpl_sj_plus.ini
- **خوانده شده** : JROOT/language/en-GB/en-GB.tpl_sj_plus.ini
- **خوانده نشده** : JROOT/templates/sj_plus/language/fa-IR/fa-IR.tpl_sj_plus.ini
- **خوانده شده** : JROOT/templates/sj_plus/language/en-GB/en-GB.tpl_sj_plus.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.com_content.ini
- **خوانده شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_content_pagebreak.ini
- **خوانده شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_content_vote.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.mod_stats.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.mod_articles_latest.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.mod_articles_news.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.mod_slideshowck.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.mod_search.ini
- **خوانده شده** : JROOT/language/fa-IR/fa-IR.mod_languages.ini
- **خوانده شده** : JROOT/administrator/language/fa-IR/fa-IR.plg_system_debug.ini
**هیچکدام**