|
|
|
 اداره کل آزمايشگاه فني و
|
انجمن صنفی کارفرمایی شرکتهای بازرسی فنی خراسان رضوی
The Khorasan Razavi Society of Technical Inspection
-
شما اینجا هستید:
- خانه
انجمن صنفی کارفرمایی شرکتهای بازرسی فنی خراسان رضوی
اشکال یابی جوملا
زمان
حافظه
زمان: 0.0 ms / 0.0 ms حافظه: 0.334 MB / 0.33 MB Application: afterLoad
زمان: 34.8 ms / 34.9 ms حافظه: 1.148 MB / 1.48 MB Application: afterInitialise
زمان: 9.3 ms / 44.2 ms حافظه: 0.394 MB / 1.88 MB Application: afterRoute
زمان: 32.8 ms / 77.0 ms حافظه: 0.919 MB / 2.79 MB Application: afterDispatch
زمان: 4.8 ms / 81.7 ms حافظه: 0.165 MB / 2.96 MB Application: beforeRenderModule mod_weblinks (سایت های مرتبط )
زمان: 11.0 ms / 92.8 ms حافظه: 0.307 MB / 3.27 MB Application: afterRenderModule mod_weblinks (سایت های مرتبط )
زمان: 0.1 ms / 92.9 ms حافظه: 0.000 MB / 3.21 MB Application: beforeRenderModule mod_weblinks (سایت های مرتبط )
زمان: 8.5 ms / 101.4 ms حافظه: 0.215 MB / 3.43 MB Application: afterRenderModule mod_weblinks (سایت های مرتبط )
زمان: 0.2 ms / 101.6 ms حافظه: 0.000 MB / 3.37 MB Application: beforeRenderModule mod_weblinks (سایت های مرتبط)
زمان: 7.6 ms / 109.1 ms حافظه: 0.188 MB / 3.56 MB Application: afterRenderModule mod_weblinks (سایت های مرتبط)
زمان: 0.3 ms / 109.4 ms حافظه: 0.000 MB / 3.53 MB Application: beforeRenderModule mod_vvisit_counter (آمار سایت)
زمان: 9.7 ms / 119.1 ms حافظه: 0.456 MB / 3.98 MB Application: afterRenderModule mod_vvisit_counter (آمار سایت)
زمان: 0.2 ms / 119.3 ms حافظه: 0.000 MB / 3.92 MB Application: beforeRenderModule mod_custom (تلگرام)
زمان: 2.6 ms / 121.9 ms حافظه: 0.010 MB / 3.93 MB Application: afterRenderModule mod_custom (تلگرام)
زمان: 0.2 ms / 122.1 ms حافظه: 0.000 MB / 3.93 MB Application: beforeRenderModule mod_custom (نرم افزار محاسبه وزن جوش)
زمان: 0.6 ms / 122.7 ms حافظه: 0.006 MB / 3.94 MB Application: afterRenderModule mod_custom (نرم افزار محاسبه وزن جوش)
زمان: 0.2 ms / 122.9 ms حافظه: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_articles_latest (اخبار)
زمان: 6.1 ms / 129.1 ms حافظه: 0.071 MB / 4.01 MB Application: afterRenderModule mod_articles_latest (اخبار)
زمان: 0.2 ms / 129.3 ms حافظه: 0.000 MB / 4.00 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
زمان: 3.1 ms / 132.4 ms حافظه: 0.017 MB / 4.02 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
زمان: 0.2 ms / 132.6 ms حافظه: 0.000 MB / 4.02 MB Application: beforeRenderModule mod_news_flash (mod_news_flash)
زمان: 2.6 ms / 135.2 ms حافظه: 0.028 MB / 4.04 MB Application: afterRenderModule mod_news_flash (mod_news_flash)
زمان: 0.4 ms / 135.5 ms حافظه: 0.002 MB / 4.05 MB Application: beforeRenderModule mod_as_artslider (AS ArtSlider)
زمان: 15.1 ms / 150.6 ms حافظه: 0.221 MB / 4.27 MB Application: afterRenderModule mod_as_artslider (AS ArtSlider)
زمان: 0.4 ms / 151.0 ms حافظه: 0.000 MB / 4.17 MB Application: beforeRenderModule mod_as_menu (AS Menu)
زمان: 10.7 ms / 161.6 ms حافظه: 0.116 MB / 4.28 MB Application: afterRenderModule mod_as_menu (AS Menu)
زمان: 0.2 ms / 161.8 ms حافظه: 0.000 MB / 4.28 MB Application: beforeRenderModule mod_custom (عنوان سایت)
زمان: 0.5 ms / 162.4 ms حافظه: 0.006 MB / 4.28 MB Application: afterRenderModule mod_custom (عنوان سایت)
زمان: 7.0 ms / 169.4 ms حافظه: 0.069 MB / 4.35 MB Application: afterRender
جمع پرس و جوی بانک اطلاعاتی: 62.7 ms
4.95 MB (5,187,944 بایت)
65 پرس و جو ثبت شده 62.7 ms
- زمان پرس و جو: 0.39 ms
SELECT `data`
FROM `jljvi_session`
WHERE `session_id` = 'vhfvcq21c3u9lg3bpirk163go1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_session NULL const PRIMARY PRIMARY 602 const 1 100.00 NULL عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.45 ms پس از آخرین پرس و جو: 0.85 ms
DELETE
FROM `jljvi_session`
WHERE `time` < '1653404541'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE jljvi_session NULL range time time 45 const 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/application/cms.php:685JROOT/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 - زمان پرس و جو: 0.36 ms پس از آخرین پرس و جو: 0.20 ms
SELECT `session_id`
FROM `jljvi_session`
WHERE `session_id` = 'vhfvcq21c3u9lg3bpirk163go1'
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_session NULL const PRIMARY PRIMARY 602 const 1 100.00 Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 2.52 ms پس از آخرین پرس و جو: 0.21 ms
INSERT INTO `jljvi_session` (`session_id`, `client_id`, `time`)
VALUES ('vhfvcq21c3u9lg3bpirk163go1', 0, '1653405442')توضیحات در جستجو ممکن نیست: INSERT INTO `jljvi_session` (`session_id`, `client_id`, `time`) VALUES ('vhfvcq21c3u9lg3bpirk163go1', 0, '1653405442')عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.74 ms پس از آخرین پرس و جو: 1.51 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM jljvi_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.61 ms پس از آخرین پرس و جو: 0.74 ms
SELECT b.id
FROM jljvi_usergroups AS a
LEFT JOIN jljvi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.36 ms پس از آخرین پرس و جو: 0.28 ms
SELECT id, rules
FROM `jljvi_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_viewlevels NULL ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 5 100.00 NULL عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 1.13 ms پس از آخرین پرس و جو: 0.26 ms
SELECT folder AS type, element AS name, params
FROM jljvi_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_extensions NULL ref extension extension 62 const 71 3.33 Using index condition; Using where; با استفاده از مرتب سازی فایل عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.61 ms پس از آخرین پرس و جو: 0.55 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM jljvi_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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:628JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - زمان پرس و جو: 1.25 ms پس از آخرین پرس و جو: 11.36 ms
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 jljvi_menu AS m
LEFT JOIN jljvi_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 35 3.33 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.m.component_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.59 ms پس از آخرین پرس و جو: 1.48 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM jljvi_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 2.58 ms پس از آخرین پرس و جو: 0.28 ms
UPDATE `jljvi_extensions`
SET `params` = '{\"mediaversion\":\"508ddc827732f503f769b05c38e83009\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jljvi_extensions NULL range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.69 ms پس از آخرین پرس و جو: 1.22 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM jljvi_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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_content/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/plugins/system/sef/sef.php:49JROOT/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 - زمان پرس و جو: 0.49 ms پس از آخرین پرس و جو: 0.90 ms
SELECT *
FROM jljvi_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_languages NULL ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where; با استفاده از مرتب سازی فایل عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/joomla/language/helper.php:166JROOT/libraries/cms/application/site.php:336JROOT/libraries/cms/application/site.php:135JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:40 - زمان پرس و جو: 0.76 ms پس از آخرین پرس و جو: 0.59 ms
SELECT id, home, template, s.params
FROM jljvi_template_styles as s
LEFT JOIN jljvi_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template کلید شاخصی برای استفاده نیست NULL NULL 5 20.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 303 khsticom_anjoman.s.template,const 1 4.63 Using index condition; Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 4.90 ms
SELECT a.rules
FROM jljvi_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.85 ms پس از آخرین پرس و جو: 0.56 ms
SELECT b.rules
FROM jljvi_assets AS a
LEFT JOIN jljvi_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; با استفاده از مرتب سازی فایل 1 SIMPLE b NULL range idx_lft_rgt idx_lft_rgt 4 NULL 10 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 1.98 ms پس از آخرین پرس و جو: 0.62 ms
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 jljvi_content AS a
LEFT JOIN jljvi_categories AS c
on c.id = a.catid
LEFT JOIN jljvi_users AS u
on u.id = a.created_by
LEFT JOIN jljvi_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jljvi_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jljvi_categories AS cat JOIN jljvi_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.id = 8
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL const PRIMARY,idx_state PRIMARY 4 const 1 100.00 NULL 1 PRIMARY c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 const 1 100.00 Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 1 100.00 Using index condition; Using temporary; با استفاده از مرتب سازی فایل 2 DERIVED cat NULL index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 14 11.11 Using where; Using index; Using join buffer (Block Nested Loop) عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 2.66 ms پس از آخرین پرس و جو: 1.41 ms
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 jljvi_categories as c
LEFT JOIN jljvi_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 jljvi_categories AS cat JOIN jljvi_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=13
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 partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; با استفاده از مرتب سازی فایل 1 PRIMARY c NULL ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 14 31.74 Using where 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 khsticom_anjoman.c.id 2 100.00 Using where; Not exists; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; با استفاده از مرتب سازی فایل 2 DERIVED cat NULL index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 14 11.11 Using where; Using index; Using join buffer (Block Nested Loop) عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.63 ms پس از آخرین پرس و جو: 1.44 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM jljvi_extensions
WHERE `type` = 'component'
AND `element` = 'com_tags'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.76 ms پس از آخرین پرس و جو: 0.26 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 1.52 ms پس از آخرین پرس و جو: 3.35 ms
SHOW FULL COLUMNS
FROM `jljvi_content`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `jljvi_content`عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 0.60 ms پس از آخرین پرس و جو: 1.48 ms
SELECT *
FROM jljvi_content
WHERE `id` = '8'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 2.61 ms پس از آخرین پرس و جو: 0.26 ms
UPDATE jljvi_content
SET `hits` = (`hits` + 1)
WHERE `id` = '8'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jljvi_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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 - زمان پرس و جو: 1.69 ms پس از آخرین پرس و جو: 5.03 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jljvi_modules AS m
LEFT JOIN jljvi_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jljvi_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 <= '2022-05-24 15:17:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-24 15:17:22')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 17 2.63 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 303 khsticom_anjoman.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 khsticom_anjoman.m.id 1 40.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/module/helper.php:376JROOT/libraries/cms/module/helper.php:84JROOT/libraries/joomla/document/html/html.php:497JROOT/templates/as002058free/includes/includes.php:70JROOT/templates/as002058free/index.php:13JROOT/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 - زمان پرس و جو: 0.64 ms پس از آخرین پرس و جو: 3.63 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM jljvi_extensions
WHERE `type` = 'component'
AND `element` = 'com_weblinks'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)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/modules/mod_weblinks/helper.php:53JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.97 ms پس از آخرین پرس و جو: 0.56 ms
SELECT COUNT(*)
FROM `jljvi_weblinks` AS a
LEFT JOIN jljvi_categories AS c
ON c.id = a.catid
LEFT JOIN jljvi_users AS ua
ON ua.id = a.created_by
LEFT JOIN jljvi_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 6
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 6 13.60 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.modified_by 1 100.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/legacy/model/legacy.php:327JROOT/libraries/legacy/model/list.php:276JROOT/libraries/legacy/model/list.php:310JROOT/libraries/legacy/model/list.php:171JROOT/components/com_weblinks/models/category.php:82JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 1.35 ms پس از آخرین پرس و جو: 0.16 ms
SELECT a.*, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `jljvi_weblinks` AS a
LEFT JOIN jljvi_categories AS c
ON c.id = a.catid
LEFT JOIN jljvi_users AS ua
ON ua.id = a.created_by
LEFT JOIN jljvi_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 6
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')
ORDER BY title asc
LIMIT 0, 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 با استفاده از مرتب سازی فایل 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 6 13.60 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.modified_by 1 100.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_weblinks/models/category.php:82JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.75 ms پس از آخرین پرس و جو: 0.34 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 5
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.65 ms پس از آخرین پرس و جو: 0.23 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 6
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.63 ms پس از آخرین پرس و جو: 0.22 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.59 ms پس از آخرین پرس و جو: 0.22 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 19
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.60 ms پس از آخرین پرس و جو: 0.20 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 13
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.60 ms پس از آخرین پرس و جو: 0.24 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 17
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 1.03 ms پس از آخرین پرس و جو: 1.14 ms
SELECT COUNT(*)
FROM `jljvi_weblinks` AS a
LEFT JOIN jljvi_categories AS c
ON c.id = a.catid
LEFT JOIN jljvi_users AS ua
ON ua.id = a.created_by
LEFT JOIN jljvi_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 12
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 6 13.60 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.modified_by 1 100.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/legacy/model/legacy.php:327JROOT/libraries/legacy/model/list.php:276JROOT/libraries/legacy/model/list.php:310JROOT/libraries/legacy/model/list.php:171JROOT/components/com_weblinks/models/category.php:82JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 1.44 ms پس از آخرین پرس و جو: 0.30 ms
SELECT a.*, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `jljvi_weblinks` AS a
LEFT JOIN jljvi_categories AS c
ON c.id = a.catid
LEFT JOIN jljvi_users AS ua
ON ua.id = a.created_by
LEFT JOIN jljvi_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 12
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')
ORDER BY title asc
LIMIT 0, 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 با استفاده از مرتب سازی فایل 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 6 13.60 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.modified_by 1 100.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_weblinks/models/category.php:82JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.65 ms پس از آخرین پرس و جو: 0.32 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 16
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.64 ms پس از آخرین پرس و جو: 0.23 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 14
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 0.22 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 15
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 0.20 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 18
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.57 ms پس از آخرین پرس و جو: 0.19 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 10
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.56 ms پس از آخرین پرس و جو: 0.19 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 11
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 1.06 ms پس از آخرین پرس و جو: 0.96 ms
SELECT COUNT(*)
FROM `jljvi_weblinks` AS a
LEFT JOIN jljvi_categories AS c
ON c.id = a.catid
LEFT JOIN jljvi_users AS ua
ON ua.id = a.created_by
LEFT JOIN jljvi_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 9
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 8 13.60 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.modified_by 1 100.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/legacy/model/legacy.php:327JROOT/libraries/legacy/model/list.php:276JROOT/libraries/legacy/model/list.php:310JROOT/libraries/legacy/model/list.php:171JROOT/components/com_weblinks/models/category.php:82JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 1.29 ms پس از آخرین پرس و جو: 0.14 ms
SELECT a.*, c.published AS c_published,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `jljvi_weblinks` AS a
LEFT JOIN jljvi_categories AS c
ON c.id = a.catid
LEFT JOIN jljvi_users AS ua
ON ua.id = a.created_by
LEFT JOIN jljvi_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 9
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')
ORDER BY title asc
LIMIT 0, 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 با استفاده از مرتب سازی فایل 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 8 13.60 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.modified_by 1 100.00 Using where; Using index عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_weblinks/models/category.php:82JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.66 ms پس از آخرین پرس و جو: 0.28 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 12
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.61 ms پس از آخرین پرس و جو: 0.20 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 8
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.60 ms پس از آخرین پرس و جو: 0.24 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 4
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 0.22 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 7
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.61 ms پس از آخرین پرس و جو: 0.23 ms
SELECT `m`.`tag_id`,`t`.*
FROM `jljvi_contentitem_tag_map` AS m
INNER JOIN `jljvi_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_weblinks.weblink'
AND `m`.`content_item_id` = 1
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type,idx_tag کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 khsticom_anjoman.m.tag_id 1 100.00 Using where عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/libraries/cms/helper/tags.php:412JROOT/components/com_weblinks/models/category.php:95JROOT/modules/mod_weblinks/helper.php:93JROOT/modules/mod_weblinks/mod_weblinks.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 - زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 5.13 ms
CREATE TABLE IF NOT EXISTS jljvi_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
توضیحات در جستجو ممکن نیست: CREATE TABLE IF NOT EXISTS jljvi_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/modules/mod_vvisit_counter/helper.php:1404JROOT/modules/mod_vvisit_counter/helper.php:482JROOT/modules/mod_vvisit_counter/tmpl/default.php:21JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21JROOT/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 - زمان پرس و جو: 0.32 ms پس از آخرین پرس و جو: 0.10 ms
SELECT count( * ) AS records, MAX( id ) AS max
FROM jljvi_vvisitcounterid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL NULL Select tables optimized away عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)JROOT/modules/mod_vvisit_counter/helper.php:1417JROOT/modules/mod_vvisit_counter/helper.php:482JROOT/modules/mod_vvisit_counter/tmpl/default.php:21JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21JROOT/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 - زمان پرس و جو: 0.99 ms پس از آخرین پرس و جو: 0.11 ms
SELECT COUNT(*)
FROM jljvi_vvisitcounter
WHERE ip=UNHEX(SHA1('18.232.52.135'))
AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '5' )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_vvisitcounter NULL ref ip,iptm iptm 20 const 2 100.00 Using where; Using index Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.1 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.6 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/modules/mod_vvisit_counter/helper.php:1612JROOT/modules/mod_vvisit_counter/helper.php:482JROOT/modules/mod_vvisit_counter/tmpl/default.php:21JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21JROOT/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 - زمان پرس و جو: 0.39 ms پس از آخرین پرس و جو: 0.10 ms
INSERT INTO jljvi_vvisitcounter ( tm, ip, data )
VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.232.52.135')) , NULL )توضیحات در جستجو ممکن نیست: INSERT INTO jljvi_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.232.52.135')) , NULL )Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms update 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.1 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/modules/mod_vvisit_counter/helper.php:1651JROOT/modules/mod_vvisit_counter/helper.php:482JROOT/modules/mod_vvisit_counter/tmpl/default.php:21JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21JROOT/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 - زمان پرس و جو: 0.43 ms پس از آخرین پرس و جو: 0.11 ms
SELECT COUNT(*)
FROM jljvi_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_vvisitcounter NULL range tm tm 4 NULL 78 100.00 Using where; Using index Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms executing 0.0 ms Sending data 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/modules/mod_vvisit_counter/helper.php:1920JROOT/modules/mod_vvisit_counter/helper.php:763JROOT/modules/mod_vvisit_counter/tmpl/default.php:26JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21JROOT/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 - زمان پرس و جو: 0.40 ms پس از آخرین پرس و جو: 0.09 ms
SELECT COUNT(*)
FROM jljvi_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
AND UNIX_TIMESTAMP(DATE(NOW()))id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_vvisitcounter NULL range tm tm 4 NULL 68 100.00 Using where; Using index Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms executing 0.0 ms Sending data 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/modules/mod_vvisit_counter/helper.php:1935JROOT/modules/mod_vvisit_counter/helper.php:774JROOT/modules/mod_vvisit_counter/tmpl/default.php:26JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21JROOT/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 - زمان پرس و جو: 0.54 ms پس از آخرین پرس و جو: 0.20 ms
SELECT COUNT(*)
FROM jljvi_vvisitcounter
WHERE tm BETWEEN 1653091200
AND 1653696000id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jljvi_vvisitcounter NULL range tm tm 4 NULL 282 100.00 Using where; Using index Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.2 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/modules/mod_vvisit_counter/helper.php:1979JROOT/modules/mod_vvisit_counter/helper.php:784JROOT/modules/mod_vvisit_counter/tmpl/default.php:26JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21JROOT/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 - زمان پرس و جو: 1.97 ms پس از آخرین پرس و جو: 8.30 ms
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 jljvi_content AS a
LEFT JOIN jljvi_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jljvi_categories AS c
ON c.id = a.catid
LEFT JOIN jljvi_users AS ua
ON ua.id = a.created_by
LEFT JOIN jljvi_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jljvi_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jljvi_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jljvi_categories AS cat JOIN jljvi_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 (14)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-24 15:17:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 15:17:22')
ORDER BY a.publish_up DESC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 با استفاده از مرتب سازی فایل 1 PRIMARY a NULL ref idx_access,idx_catid idx_catid 4 const 1 16.00 Using index condition; Using where 1 PRIMARY fp NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.id 1 100.00 Using where; Using index 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.created_by 1 100.00 Using where 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.modified_by 1 100.00 Using where 1 PRIMARY parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v NULL eq_ref PRIMARY PRIMARY 4 khsticom_anjoman.a.id 1 100.00 Using where 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 const 1 100.00 Using where; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; با استفاده از مرتب سازی فایل 2 DERIVED cat NULL index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 14 11.11 Using where; Using index; Using join buffer (Block Nested Loop) Status Duration starting 0.4 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.2 ms System lock 0.0 ms optimizing 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms statistics 0.2 ms preparing 0.1 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.1 ms Creating sort index 0.0 ms end 0.0 ms query end 0.0 ms removing tmp table 0.0 ms query end 0.0 ms closing tables 0.0 ms removing tmp table 0.0 ms closing tables 0.0 ms freeing items 0.1 ms cleaning up 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 - زمان پرس و جو: 1.44 ms پس از آخرین پرس و جو: 4.65 ms