تماس با ما
اشکال یابی جوملا {
" __default " : {
" session " : {
" counter " : 1,
" timer " : {
" start " : 1585471795,
" last " : 1585471795,
" now " : 1585471795
},
" token " : "m46rM3SUJZjX3rY1Kr4n2SPLKaM7R5Nd"
},
" registry " : {},
" user " : {
" id " : 0,
" name " : null ,
" username " : null ,
" email " : null ,
" password " : null ,
" password_clear " : "" ,
" block " : null ,
" sendEmail " : 0,
" registerDate " : null ,
" lastvisitDate " : null ,
" activation " : null ,
" params " : null ,
" groups " : [],
" guest " : 1,
" lastResetTime " : null ,
" resetCount " : null ,
" requireReset " : null ,
" aid " : 0
},
" com_mailto " : {
" links " : {
" 7a1e42edb4b5a20142453ecd6c86bc9cd945dee9 " : {
" link " : "http:\/\/www.drraminasadi.ir\/index.php\/profesional-articles\/hypothyroidism" ,
" expiry " : 1585471796
}
}
}
},
" __sige " : {
" sigcount " : null ,
" sigcountarticles " : null
}
}
زمان حافظه زمان: 28.62 ms / 28.62 ms حافظه: 0.450 MB / 0.58 MB Application: afterLoad
زمان: 126.61 ms / 155.23 ms حافظه: 2.635 MB / 3.22 MB Application: afterInitialise
زمان: 29.77 ms / 185.00 ms حافظه: 0.553 MB / 3.77 MB Application: afterRoute
زمان: 25.12 ms / 210.12 ms حافظه: 0.220 MB / 3.99 MB Application: beforeRenderComponent com_content
زمان: 24.07 ms / 234.19 ms حافظه: 0.587 MB / 4.58 MB Application: Start JAccess::getAssetRules Old (1)
زمان: 6.63 ms / 240.82 ms حافظه: 0.037 MB / 4.62 MB Application: Finish JAccess::getAssetRules Old (1)
زمان: 0.05 ms / 240.87 ms حافظه: 0.000 MB / 4.61 MB Application: Start JAccess::preload(components)
زمان: 6.72 ms / 247.59 ms حافظه: 0.156 MB / 4.77 MB Application: Finish JAccess::preload(components)
زمان: 80.45 ms / 328.04 ms حافظه: 1.154 MB / 5.92 MB Application: New JAccess Preloading Process(com_content.article)
زمان: 2.16 ms / 330.20 ms حافظه: 0.027 MB / 5.95 MB Application: After preloadPermissionsParentIdMapping (com_content.article)
زمان: 4.07 ms / 334.28 ms حافظه: 0.059 MB / 6.01 MB Application: After preloadPermissions (com_content.article)
زمان: 0.02 ms / 334.30 ms حافظه: 0.001 MB / 6.01 MB Application: End New JAccess Preloading Process(com_content.article)
زمان: 0.03 ms / 334.32 ms حافظه: 0.001 MB / 6.01 MB Application: Start JAccess::getAssetRules New (com_content.article.20)
زمان: 0.18 ms / 334.50 ms حافظه: 0.006 MB / 6.02 MB Application: Finish JAccess::getAssetRules New (com_content.article.20)
زمان: 37.20 ms / 371.70 ms حافظه: 0.539 MB / 6.56 MB Application: afterRenderComponent com_content
زمان: 1.31 ms / 373.01 ms حافظه: 0.004 MB / 6.56 MB Application: afterDispatch
زمان: 15.60 ms / 388.62 ms حافظه: 0.130 MB / 6.69 MB Application: beforeRenderModule mod_flexi_customcode (ماژول کپی رایت)
زمان: 7.54 ms / 396.16 ms حافظه: 0.031 MB / 6.72 MB Application: afterRenderModule mod_flexi_customcode (ماژول کپی رایت)
زمان: 0.22 ms / 396.38 ms حافظه: 0.000 MB / 6.72 MB Application: beforeRenderModule mod_flexi_customcode (تماس با ما)
زمان: 5.90 ms / 402.28 ms حافظه: 0.009 MB / 6.73 MB Application: afterRenderModule mod_flexi_customcode (تماس با ما)
زمان: 0.24 ms / 402.52 ms حافظه: 0.001 MB / 6.73 MB Application: beforeRenderModule mod_flexi_customcode (ماژول آدرس و پی نوشت)
زمان: 12.50 ms / 415.02 ms حافظه: 0.026 MB / 6.75 MB Application: afterRenderModule mod_flexi_customcode (ماژول آدرس و پی نوشت)
زمان: 0.20 ms / 415.23 ms حافظه: 0.000 MB / 6.74 MB Application: beforeRenderModule mod_stats (آمار سایت)
زمان: 12.53 ms / 427.76 ms حافظه: 0.068 MB / 6.81 MB Application: afterRenderModule mod_stats (آمار سایت)
زمان: 0.08 ms / 427.84 ms حافظه: 0.000 MB / 6.80 MB Application: beforeRenderModule mod_articles_latest (آخرین مطالب)
زمان: 41.71 ms / 469.55 ms حافظه: 0.401 MB / 7.20 MB Application: afterRenderModule mod_articles_latest (آخرین مطالب)
زمان: 0.21 ms / 469.77 ms حافظه: 0.000 MB / 7.05 MB Application: beforeRenderModule mod_articles_popular (مطالب پربازدید)
زمان: 31.72 ms / 501.49 ms حافظه: 0.254 MB / 7.31 MB Application: afterRenderModule mod_articles_popular (مطالب پربازدید)
زمان: 0.35 ms / 501.84 ms حافظه: 0.000 MB / 7.15 MB Application: beforeRenderModule mod_login (ورود به سایت)
زمان: 8.02 ms / 509.87 ms حافظه: 0.116 MB / 7.27 MB Application: afterRenderModule mod_login (ورود به سایت)
زمان: 0.11 ms / 509.98 ms حافظه: 0.000 MB / 7.26 MB Application: beforeRenderModule mod_breadcrumbs (مسیر سایت)
زمان: 3.30 ms / 513.28 ms حافظه: 0.024 MB / 7.29 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)
زمان: 0.28 ms / 513.56 ms حافظه: 0.004 MB / 7.29 MB Application: beforeRenderModule mod_maximenuck (منوی(Maximenu CK))
زمان: 50.08 ms / 563.64 ms حافظه: 0.696 MB / 7.99 MB Application: afterRenderModule mod_maximenuck (منوی(Maximenu CK))
زمان: 12.99 ms / 576.63 ms حافظه: 0.151 MB / 8.14 MB Application: afterRender
جمع پرس و جوی بانک اطلاعاتی: 210.88 ms
8.26 MB (8,663,440 بایت )
45 پرس و جو ثبت شده 210.88 ms زمان پرس و جو: 5.23 ms
SELECT `data`
FROM `iovqe_session `
WHERE `session_id` = 'mtonoe4vcpu83j1rm24nel3uj1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 14 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 13 JDatabaseDriver->loadResult() JROOT\libraries\joomla\session\storage\database.php:44 12 JSessionStorageDatabase->read() به نظر می رسد خط زیر فراخونده شده باشد. 11 session_start() JROOT\libraries\joomla\session\handler\native.php:259 10 JSessionHandlerNative->doSessionStart() JROOT\libraries\joomla\session\handler\native.php:49 9 JSessionHandlerNative->start() JROOT\libraries\joomla\session\handler\joomla.php:81 8 JSessionHandlerJoomla->start() JROOT\libraries\joomla\session\session.php:636 7 JSession->_start() JROOT\libraries\joomla\session\session.php:596 6 JSession->start() JROOT\libraries\cms\application\cms.php:773 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 1.46 ms پس از آخرین پرس و جو: 5.60 ms
DELETE
FROM `iovqe_session `
WHERE `time` < '1585470895'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE iovqe_session NULL range time time 59 const 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 6 JDatabaseDriverPdo->execute() JROOT\libraries\cms\application\cms.php:790 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 1.42 ms پس از آخرین پرس و جو: 0.21 ms
SELECT `session_id`
FROM `iovqe_session `
WHERE `session_id` = 'mtonoe4vcpu83j1rm24nel3uj1' LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 8 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 7 JDatabaseDriver->loadResult() JROOT\libraries\cms\application\cms.php:176 6 JApplicationCms->checkSession() JROOT\libraries\cms\application\cms.php:799 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 8.67 ms پس از آخرین پرس و جو: 0.34 ms
INSERT INTO `iovqe_session `
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('mtonoe4vcpu83j1rm24nel3uj1', 0, 1, '1585471795', 0, '')توضیحات در جستجو ممکن نیست: INSERT INTO `iovqe_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('mtonoe4vcpu83j1rm24nel3uj1', 0, 1, '1585471795', 0, '')
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 7 JDatabaseDriverPdo->execute() JROOT\libraries\cms\application\cms.php:212 6 JApplicationCms->checkSession() JROOT\libraries\cms\application\cms.php:799 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 12.40 ms پس از آخرین پرس و جو: 5.44 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iovqe_extensions `
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_extensions NULL ref extension extension 82 const 32 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 10 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 9 JDatabaseDriver->loadObjectList() به نظر می رسد خط زیر فراخونده شده باشد. 8 call_user_func_array() JROOT\libraries\joomla\cache\controller\callback.php:152 7 JCacheControllerCallback->get() JROOT\libraries\cms\component\helper.php:448 6 JComponentHelper::load() JROOT\libraries\cms\component\helper.php:43 5 JComponentHelper::getComponent() JROOT\libraries\cms\component\helper.php:120 4 JComponentHelper::getParams() JROOT\libraries\cms\application\site.php:589 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.57 ms پس از آخرین پرس و جو: 2.97 ms
SELECT b.id
FROM iovqe_usergroups AS a
LEFT JOIN iovqe_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 index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 100.00 Using where; Using index
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 11 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT\libraries\joomla\access\access.php:835 9 JAccess::getGroupsByUser() JROOT\libraries\joomla\access\access.php:904 8 JAccess::getAuthorisedViewLevels() JROOT\libraries\joomla\user\user.php:454 7 JUser->getAuthorisedViewLevels() JROOT\libraries\cms\plugin\helper.php:296 6 JPluginHelper::load() JROOT\libraries\cms\plugin\helper.php:86 5 JPluginHelper::getPlugin() JROOT\libraries\cms\plugin\helper.php:128 4 JPluginHelper::isEnabled() JROOT\libraries\cms\application\site.php:599 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.52 ms پس از آخرین پرس و جو: 1.77 ms
SELECT id, rules
FROM `iovqe_viewlevels `id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_viewlevels NULL ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 5 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 10 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1494 9 JDatabaseDriver->loadAssocList() JROOT\libraries\joomla\access\access.php:921 8 JAccess::getAuthorisedViewLevels() JROOT\libraries\joomla\user\user.php:454 7 JUser->getAuthorisedViewLevels() JROOT\libraries\cms\plugin\helper.php:296 6 JPluginHelper::load() JROOT\libraries\cms\plugin\helper.php:86 5 JPluginHelper::getPlugin() JROOT\libraries\cms\plugin\helper.php:128 4 JPluginHelper::isEnabled() JROOT\libraries\cms\application\site.php:599 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.61 ms پس از آخرین پرس و جو: 0.29 ms
SELECT folder AS type, element AS name, params
FROM iovqe_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) 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 iovqe_extensions NULL ref extension extension 82 const 60 0.71 Using index condition; Using where; با استفاده از مرتب سازی فایل
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 8 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 7 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\plugin\helper.php:310 6 JPluginHelper::load() JROOT\libraries\cms\plugin\helper.php:86 5 JPluginHelper::getPlugin() JROOT\libraries\cms\plugin\helper.php:128 4 JPluginHelper::isEnabled() JROOT\libraries\cms\application\site.php:599 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 10.24 ms پس از آخرین پرس و جو: 30.16 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 iovqe_menu AS m
LEFT JOIN iovqe_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 28 3.33 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dr_ramin_asadi_13962017.m.component_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 16 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\menu\site.php:86 14 JMenuSite->load() JROOT\libraries\cms\menu\menu.php:74 13 JMenu->__construct() JROOT\libraries\cms\menu\site.php:57 12 JMenuSite->__construct() JROOT\libraries\cms\menu\menu.php:145 11 JMenu::getInstance() JROOT\libraries\cms\application\cms.php:439 10 JApplicationCms->getMenu() JROOT\libraries\cms\application\site.php:272 9 JApplicationSite->getMenu() JROOT\libraries\cms\router\site.php:57 8 JRouterSite->__construct() JROOT\libraries\cms\router\router.php:197 7 JRouter::getInstance() JROOT\libraries\cms\application\cms.php:535 6 JApplicationCms::getRouter() JROOT\libraries\cms\application\site.php:407 5 JApplicationSite::getRouter() JROOT\libraries\cms\application\cms.php:1115 4 JApplicationCms->route() JROOT\libraries\cms\application\site.php:791 3 JApplicationSite->route() JROOT\libraries\cms\application\site.php:215 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.78 ms پس از آخرین پرس و جو: 17.00 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iovqe_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 14 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1650 13 JDatabaseDriver->loadObject() به نظر می رسد خط زیر فراخونده شده باشد. 12 call_user_func_array() JROOT\libraries\joomla\cache\controller\callback.php:152 11 JCacheControllerCallback->get() JROOT\libraries\cms\library\helper.php:156 10 JLibraryHelper::_load() JROOT\libraries\cms\library\helper.php:47 9 JLibraryHelper::getLibrary() JROOT\libraries\cms\library\helper.php:90 8 JLibraryHelper::getParams() JROOT\libraries\cms\version\version.php:274 7 JVersion->getMediaVersion() JROOT\libraries\joomla\factory.php:755 6 JFactory::createDocument() JROOT\libraries\joomla\factory.php:216 5 JFactory::getDocument() JROOT\libraries\joomla\application\web.php:977 4 JApplicationWeb->loadDocument() JROOT\libraries\cms\application\site.php:130 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 8.07 ms پس از آخرین پرس و جو: 0.46 ms
UPDATE `iovqe_extensions `
SET `params` = '{\"mediaversion\":\"e4a0e738d7796eff466b6aea9285375f\"}'
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE iovqe_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 10 JDatabaseDriverPdo->execute() JROOT\libraries\cms\library\helper.php:119 9 JLibraryHelper::saveParams() JROOT\libraries\cms\version\version.php:325 8 JVersion->setMediaVersion() JROOT\libraries\cms\version\version.php:284 7 JVersion->getMediaVersion() JROOT\libraries\joomla\factory.php:755 6 JFactory::createDocument() JROOT\libraries\joomla\factory.php:216 5 JFactory::getDocument() JROOT\libraries\joomla\application\web.php:977 4 JApplicationWeb->loadDocument() JROOT\libraries\cms\application\site.php:130 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 5.28 ms پس از آخرین پرس و جو: 3.67 ms
SELECT *
FROM iovqe_languages
WHERE published= 1
ORDER BY ordering ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_languages NULL ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 2 50.00 Using where; با استفاده از مرتب سازی فایل
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 7 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 6 JDatabaseDriver->loadObjectList() JROOT\libraries\joomla\language\helper.php:164 5 JLanguageHelper::getLanguages() JROOT\libraries\cms\application\site.php:329 4 JApplicationSite->getParams() JROOT\libraries\cms\application\site.php:135 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 3.15 ms پس از آخرین پرس و جو: 0.91 ms
SELECT id, home, template, s.params
FROM iovqe_template_styles as s
LEFT JOIN iovqe_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 403 dr_ramin_asadi_13962017.s.template,const 1 4.61 Using index condition; Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 6 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 5 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\application\site.php:484 4 JApplicationSite->getTemplate() JROOT\libraries\cms\application\site.php:165 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 5.19 ms پس از آخرین پرس و جو: 15.00 ms
SHOW FULL COLUMNS FROM `iovqe_assets `توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `iovqe_assets`
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 21 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 20 JDatabaseDriver->loadObjectList() JROOT\libraries\joomla\database\driver\pdomysql.php:320 19 JDatabaseDriverPdomysql->getTableColumns() JROOT\libraries\joomla\table\table.php:241 18 JTable->getFields() JROOT\libraries\joomla\table\table.php:162 17 JTable->__construct() JROOT\libraries\joomla\table\asset.php:60 16 JTableAsset->__construct() JROOT\libraries\joomla\table\table.php:308 15 JTable::getInstance() JROOT\libraries\joomla\access\access.php:696 14 JAccess::getExtensionNameFromAsset() JROOT\libraries\joomla\access\access.php:555 13 JAccess::getAssetRules() JROOT\libraries\joomla\user\user.php:385 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.76 ms پس از آخرین پرس و جو: 2.62 ms
SELECT *
FROM iovqe_assets
WHERE `id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_assets NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 17 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1453 16 JDatabaseDriver->loadAssoc() JROOT\libraries\joomla\table\table.php:719 15 JTable->load() JROOT\libraries\joomla\access\access.php:697 14 JAccess::getExtensionNameFromAsset() JROOT\libraries\joomla\access\access.php:555 13 JAccess::getAssetRules() JROOT\libraries\joomla\user\user.php:385 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.50 ms پس از آخرین پرس و جو: 0.28 ms
SELECT a.rules
FROM iovqe_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index_merge PRIMARY,idx_asset_name PRIMARY,idx_asset_name 4,202 NULL 2 100.00 Using union(PRIMARY,idx_asset_name); Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1538 14 JDatabaseDriver->loadColumn() JROOT\libraries\joomla\access\access.php:652 13 JAccess::getAssetRules() JROOT\libraries\joomla\user\user.php:385 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.90 ms پس از آخرین پرس و جو: 2.20 ms
SELECT element
FROM iovqe_extensions
WHERE type = 'component' AND enabled = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_extensions NULL ref extension extension 82 const 32 10.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 17 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1538 16 JDatabaseDriver->loadColumn() JROOT\libraries\joomla\access\access.php:413 15 JAccess::preloadComponents() JROOT\libraries\joomla\access\access.php:213 14 JAccess::preload() JROOT\libraries\joomla\access\access.php:168 13 JAccess::check() JROOT\libraries\joomla\user\user.php:394 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.80 ms پس از آخرین پرس و جو: 0.33 ms
SELECT a.name, a.rules
FROM iovqe_assets AS a
WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL idx_asset_name کلید شاخصی برای استفاده نیست NULL NULL 97 34.02 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 17 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1494 16 JDatabaseDriver->loadAssocList() JROOT\libraries\joomla\access\access.php:441 15 JAccess::preloadComponents() JROOT\libraries\joomla\access\access.php:213 14 JAccess::preload() JROOT\libraries\joomla\access\access.php:168 13 JAccess::check() JROOT\libraries\joomla\user\user.php:394 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.60 ms پس از آخرین پرس و جو: 3.39 ms
SHOW FULL COLUMNS FROM `iovqe_content `توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `iovqe_content`
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 16 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT\libraries\joomla\database\driver\pdomysql.php:320 14 JDatabaseDriverPdomysql->getTableColumns() JROOT\libraries\joomla\table\table.php:241 13 JTable->getFields() JROOT\libraries\joomla\table\table.php:162 12 JTable->__construct() JROOT\libraries\legacy\table\content.php:31 11 JTableContent->__construct() JROOT\libraries\joomla\table\table.php:308 10 JTable::getInstance() JROOT\components\com_content\models\article.php:264 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.17 ms پس از آخرین پرس و جو: 5.93 ms
SELECT *
FROM iovqe_content
WHERE `id` = '20'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 12 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1453 11 JDatabaseDriver->loadAssoc() JROOT\libraries\joomla\table\table.php:719 10 JTable->load() JROOT\components\com_content\models\article.php:265 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 8.74 ms پس از آخرین پرس و جو: 0.43 ms
UPDATE iovqe_content
SET `hits` = (`hits` + 1)
WHERE `id` = '20'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE iovqe_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 11 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\table\table.php:1228 10 JTable->hit() JROOT\components\com_content\models\article.php:266 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 21.65 ms پس از آخرین پرس و جو: 3.31 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 iovqe_content AS a
LEFT JOIN iovqe_categories AS c = a.catid
LEFT JOIN iovqe_users AS u = a.created_by
LEFT JOIN iovqe_categories as parent ON parent.id = c.parent_id
LEFT JOIN iovqe_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM iovqe_categories AS cat JOIN iovqe_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 = 20 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-03-29 08:49:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-03-29 08:49:55') 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 203 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 11 11.11 Using where; Using index; Using join buffer (Block Nested Loop)
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 14 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1650 13 JDatabaseDriver->loadObject() JROOT\components\com_content\models\article.php:159 12 ContentModelArticle->getItem() JROOT\libraries\legacy\view\legacy.php:408 11 JViewLegacy->get() JROOT\components\com_content\views\article\view.html.php:42 10 ContentViewArticle->display() JROOT\libraries\legacy\controller\legacy.php:664 9 JControllerLegacy->display() JROOT\components\com_content\controller.php:113 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.08 ms پس از آخرین پرس و جو: 5.89 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 iovqe_categories as c
LEFT JOIN (SELECT cat.id as id FROM iovqe_categories AS cat JOIN iovqe_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
LEFT JOIN iovqe_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
WHERE (c.extension= 'com_content' OR c.extension= 'system') AND c.access IN (1,1,5) AND c.published = 1 AND badcats.id is null AND s.id= 2
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 11 45.45 Using where 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 dr_ramin_asadi_13962017.c.id 2 100.00 Using where; Not exists; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 203 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 11 11.11 Using where; Using index; Using join buffer (Block Nested Loop)
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\legacy\categories\categories.php:309 13 JCategories->_load() JROOT\libraries\legacy\categories\categories.php:184 12 JCategories->get() JROOT\components\com_content\helpers\route.php:44 11 ContentHelperRoute::getArticleRoute() JROOT\components\com_content\views\article\view.html.php:71 10 ContentViewArticle->display() JROOT\libraries\legacy\controller\legacy.php:664 9 JControllerLegacy->display() JROOT\components\com_content\controller.php:113 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 6.14 ms پس از آخرین پرس و جو: 1.00 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 20 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 13 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 12 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 11 JHelperTags->getItemTags() JROOT\components\com_content\views\article\view.html.php:156 10 ContentViewArticle->display() JROOT\libraries\legacy\controller\legacy.php:664 9 JControllerLegacy->display() JROOT\components\com_content\controller.php:113 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.71 ms پس از آخرین پرس و جو: 12.83 ms
SELECT a.id, a.parent_id
FROM iovqe_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL PRIMARY,idx_asset_name کلید شاخصی برای استفاده نیست NULL NULL 97 20.82 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 20 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 19 JDatabaseDriver->loadObjectList() JROOT\libraries\joomla\access\access.php:332 18 JAccess::preloadPermissionsParentIdMapping() JROOT\libraries\joomla\access\access.php:240 17 JAccess::preload() JROOT\libraries\joomla\access\access.php:168 16 JAccess::check() JROOT\libraries\joomla\user\user.php:394 15 JUser->authorise() JROOT\plugins\content\pagenavigation\pagenavigation.php:54 14 PlgContentPagenavigation->onContentBeforeDisplay() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT\libraries\joomla\event\event.php:69 12 JEvent->update() JROOT\libraries\joomla\event\dispatcher.php:159 11 JEventDispatcher->trigger() JROOT\components\com_content\views\article\view.html.php:167 10 ContentViewArticle->display() JROOT\libraries\legacy\controller\legacy.php:664 9 JControllerLegacy->display() JROOT\components\com_content\controller.php:113 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.13 ms پس از آخرین پرس و جو: 1.97 ms
SELECT a.id, a.name, a.rules
FROM iovqe_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL PRIMARY,idx_asset_name کلید شاخصی برای استفاده نیست NULL NULL 97 20.82 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 20 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1255 19 JDatabaseDriver->getIterator() JROOT\libraries\joomla\access\access.php:373 18 JAccess::preloadPermissions() JROOT\libraries\joomla\access\access.php:243 17 JAccess::preload() JROOT\libraries\joomla\access\access.php:168 16 JAccess::check() JROOT\libraries\joomla\user\user.php:394 15 JUser->authorise() JROOT\plugins\content\pagenavigation\pagenavigation.php:54 14 PlgContentPagenavigation->onContentBeforeDisplay() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT\libraries\joomla\event\event.php:69 12 JEvent->update() JROOT\libraries\joomla\event\dispatcher.php:159 11 JEventDispatcher->trigger() JROOT\components\com_content\views\article\view.html.php:167 10 ContentViewArticle->display() JROOT\libraries\legacy\controller\legacy.php:664 9 JControllerLegacy->display() JROOT\components\com_content\controller.php:113 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.75 ms پس از آخرین پرس و جو: 1.69 ms
SELECT a.id, a.title, a.catid, a.language, CASE WHEN CHAR_LENGTH (a.alias) != 0 THEN CONCAT_WS (':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH (cc.alias) != 0 THEN CONCAT_WS (':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM iovqe_content AS a
LEFT JOIN iovqe_categories AS cc ON cc.id = a.catid
WHERE a.catid = 2 AND a.state = 1 AND a.access IN (1,1,5) AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2020-03-29 08:49:55') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2020-03-29 08:49:55')
ORDER BY CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 10 16.00 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE cc NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 16 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT\plugins\content\pagenavigation\pagenavigation.php:152 14 PlgContentPagenavigation->onContentBeforeDisplay() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT\libraries\joomla\event\event.php:69 12 JEvent->update() JROOT\libraries\joomla\event\dispatcher.php:159 11 JEventDispatcher->trigger() JROOT\components\com_content\views\article\view.html.php:167 10 ContentViewArticle->display() JROOT\libraries\legacy\controller\legacy.php:664 9 JControllerLegacy->display() JROOT\components\com_content\controller.php:113 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 7.71 ms پس از آخرین پرس و جو: 38.77 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM iovqe_modules AS m
LEFT JOIN iovqe_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN iovqe_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-03-29 08:49:55') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-03-29 08:49:55') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 136 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 ref PRIMARY,published,newsfeeds published 1 const 14 3.57 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 dr_ramin_asadi_13962017.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 dr_ramin_asadi_13962017.m.id 1 40.00 Using where; Using index
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT\libraries\joomla\cache\controller\callback.php:152 12 JCacheControllerCallback->get() JROOT\libraries\cms\module\helper.php:425 11 JModuleHelper::getModuleList() JROOT\libraries\cms\module\helper.php:361 10 JModuleHelper::load() JROOT\libraries\cms\module\helper.php:84 9 JModuleHelper::getModules() JROOT\libraries\joomla\document\html.php:501 8 JDocumentHtml->countModules() JROOT\templates\koosha\index.php:34 7 require JROOT\templates\koosha\index.php JROOT\libraries\joomla\document\html.php:578 6 JDocumentHtml->_loadTemplate() JROOT\libraries\joomla\document\html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT\libraries\joomla\document\html.php:455 4 JDocumentHtml->parse() JROOT\libraries\cms\application\cms.php:1072 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.15 ms پس از آخرین پرس و جو: 33.33 ms
SELECT COUNT (id) AS count_users
FROM iovqe_users id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL NULL Select tables optimized away
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 13 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 12 JDatabaseDriver->loadResult() JROOT\modules\mod_stats\helper.php:82 11 ModStatsHelper::getList() JROOT\modules\mod_stats\mod_stats.php:17 10 include JROOT\modules\mod_stats\mod_stats.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.76 ms پس از آخرین پرس و جو: 0.24 ms
SELECT COUNT (id) AS count_items
FROM iovqe_content
WHERE state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_content NULL ref idx_state idx_state 1 const 18 100.00 Using index
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 13 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 12 JDatabaseDriver->loadResult() JROOT\modules\mod_stats\helper.php:97 11 ModStatsHelper::getList() JROOT\modules\mod_stats\mod_stats.php:17 10 include JROOT\modules\mod_stats\mod_stats.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.42 ms پس از آخرین پرس و جو: 0.33 ms
SELECT COUNT (`extension_id`)
FROM `iovqe_extensions `
WHERE `element` = 'com_weblinks' AND `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 14 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 13 JDatabaseDriver->loadResult() JROOT\libraries\cms\component\helper.php:104 12 JComponentHelper::isInstalled() JROOT\modules\mod_stats\helper.php:120 11 ModStatsHelper::getList() JROOT\modules\mod_stats\mod_stats.php:17 10 include JROOT\modules\mod_stats\mod_stats.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.52 ms پس از آخرین پرس و جو: 0.21 ms
SELECT SUM (hits) AS count_hits
FROM iovqe_content
WHERE state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_content NULL ref idx_state idx_state 1 const 18 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 13 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 12 JDatabaseDriver->loadResult() JROOT\modules\mod_stats\helper.php:158 11 ModStatsHelper::getList() JROOT\modules\mod_stats\mod_stats.php:17 10 include JROOT\modules\mod_stats\mod_stats.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 16.92 ms پس از آخرین پرس و جو: 6.82 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 iovqe_content AS a
LEFT JOIN iovqe_categories AS c ON c.id = a.catid
LEFT JOIN iovqe_users AS ua ON ua.id = a.created_by
LEFT JOIN iovqe_users AS uam ON uam.id = a.modified_by
LEFT JOIN iovqe_categories as parent ON parent.id = c.parent_id
LEFT JOIN iovqe_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM iovqe_categories AS cat JOIN iovqe_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-03-29 08:49:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-03-29 08:49:55')
ORDER BY a.created DESC LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL range idx_access,idx_catid idx_access 4 NULL 24 16.00 Using index condition; Using where; Using temporary; با استفاده از مرتب سازی فایل 1 PRIMARY ua NULL ALL PRIMARY کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY uam NULL ALL PRIMARY کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY c NULL eq_ref PRIMARY,idx_access PRIMARY 4 dr_ramin_asadi_13962017.a.catid 1 100.00 Using where 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 dr_ramin_asadi_13962017.c.parent_id 1 100.00 Using where 1 PRIMARY v NULL ALL PRIMARY کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 dr_ramin_asadi_13962017.c.id 2 100.00 Using where; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 203 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 11 11.11 Using where; Using index; Using join buffer (Block Nested Loop)
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 16 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT\libraries\legacy\model\legacy.php:310 14 JModelLegacy->_getList() JROOT\libraries\legacy\model\list.php:183 13 JModelList->getItems() JROOT\components\com_content\models\articles.php:565 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_latest\helper.php:113 11 ModArticlesLatestHelper::getList() JROOT\modules\mod_articles_latest\mod_articles_latest.php:15 10 include JROOT\modules\mod_articles_latest\mod_articles_latest.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 5.17 ms پس از آخرین پرس و جو: 0.99 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 23 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_latest\helper.php:113 11 ModArticlesLatestHelper::getList() JROOT\modules\mod_articles_latest\mod_articles_latest.php:15 10 include JROOT\modules\mod_articles_latest\mod_articles_latest.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.87 ms پس از آخرین پرس و جو: 0.50 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_latest\helper.php:113 11 ModArticlesLatestHelper::getList() JROOT\modules\mod_articles_latest\mod_articles_latest.php:15 10 include JROOT\modules\mod_articles_latest\mod_articles_latest.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.55 ms پس از آخرین پرس و جو: 0.85 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 21 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_latest\helper.php:113 11 ModArticlesLatestHelper::getList() JROOT\modules\mod_articles_latest\mod_articles_latest.php:15 10 include JROOT\modules\mod_articles_latest\mod_articles_latest.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.11 ms پس از آخرین پرس و جو: 0.72 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 20 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_latest\helper.php:113 11 ModArticlesLatestHelper::getList() JROOT\modules\mod_articles_latest\mod_articles_latest.php:15 10 include JROOT\modules\mod_articles_latest\mod_articles_latest.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.10 ms پس از آخرین پرس و جو: 0.72 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_latest\helper.php:113 11 ModArticlesLatestHelper::getList() JROOT\modules\mod_articles_latest\mod_articles_latest.php:15 10 include JROOT\modules\mod_articles_latest\mod_articles_latest.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 11.57 ms پس از آخرین پرس و جو: 7.53 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 iovqe_content AS a
LEFT JOIN iovqe_categories AS c ON c.id = a.catid
LEFT JOIN iovqe_users AS ua ON ua.id = a.created_by
LEFT JOIN iovqe_users AS uam ON uam.id = a.modified_by
LEFT JOIN iovqe_categories as parent ON parent.id = c.parent_id
LEFT JOIN iovqe_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM iovqe_categories AS cat JOIN iovqe_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-03-29 08:49:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-03-29 08:49:55')
ORDER BY a.hits DESC LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL range idx_access,idx_catid idx_access 4 NULL 24 16.00 Using index condition; Using where; Using temporary; با استفاده از مرتب سازی فایل 1 PRIMARY ua NULL ALL PRIMARY کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY uam NULL ALL PRIMARY کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY c NULL eq_ref PRIMARY,idx_access PRIMARY 4 dr_ramin_asadi_13962017.a.catid 1 100.00 Using where 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 dr_ramin_asadi_13962017.c.parent_id 1 100.00 Using where 1 PRIMARY v NULL ALL PRIMARY کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 dr_ramin_asadi_13962017.c.id 2 100.00 Using where; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 203 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 11 11.11 Using where; Using index; Using join buffer (Block Nested Loop)
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 16 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT\libraries\legacy\model\legacy.php:310 14 JModelLegacy->_getList() JROOT\libraries\legacy\model\list.php:183 13 JModelList->getItems() JROOT\components\com_content\models\articles.php:565 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_popular\helper.php:73 11 ModArticlesPopularHelper::getList() JROOT\modules\mod_articles_popular\mod_articles_popular.php:15 10 include JROOT\modules\mod_articles_popular\mod_articles_popular.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.93 ms پس از آخرین پرس و جو: 1.19 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_popular\helper.php:73 11 ModArticlesPopularHelper::getList() JROOT\modules\mod_articles_popular\mod_articles_popular.php:15 10 include JROOT\modules\mod_articles_popular\mod_articles_popular.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.00 ms پس از آخرین پرس و جو: 0.47 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 20 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_popular\helper.php:73 11 ModArticlesPopularHelper::getList() JROOT\modules\mod_articles_popular\mod_articles_popular.php:15 10 include JROOT\modules\mod_articles_popular\mod_articles_popular.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.33 ms پس از آخرین پرس و جو: 0.85 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 23 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_popular\helper.php:73 11 ModArticlesPopularHelper::getList() JROOT\modules\mod_articles_popular\mod_articles_popular.php:15 10 include JROOT\modules\mod_articles_popular\mod_articles_popular.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.00 ms پس از آخرین پرس و جو: 1.05 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_popular\helper.php:73 11 ModArticlesPopularHelper::getList() JROOT\modules\mod_articles_popular\mod_articles_popular.php:15 10 include JROOT\modules\mod_articles_popular\mod_articles_popular.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.39 ms پس از آخرین پرس و جو: 0.53 ms
SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 21 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 کلید شاخصی برای استفاده نیست NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dr_ramin_asadi_13962017.m.tag_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\helper\tags.php:435 13 JHelperTags->getItemTags() JROOT\components\com_content\models\articles.php:693 12 ContentModelArticles->getItems() JROOT\modules\mod_articles_popular\helper.php:73 11 ModArticlesPopularHelper::getList() JROOT\modules\mod_articles_popular\mod_articles_popular.php:15 10 include JROOT\modules\mod_articles_popular\mod_articles_popular.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.83 ms پس از آخرین پرس و جو: 22.78 ms
SELECT *
FROM iovqe_modules
WHERE published= 1
ORDER BY id
;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_modules NULL ref published published 1 const 23 100.00 Using index condition; با استفاده از مرتب سازی فایل
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 14 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT\modules\mod_maximenuck\helper.php:442 12 modMaximenuckHelper::CreateModulesList() JROOT\modules\mod_maximenuck\helper.php:62 11 modMaximenuckHelper::getItems() JROOT\modules\mod_maximenuck\mod_maximenuck.php:44 10 include JROOT\modules\mod_maximenuck\mod_maximenuck.php JROOT\libraries\cms\module\helper.php:199 9 JModuleHelper::renderModule() JROOT\libraries\joomla\document\renderer\html\module.php:93 8 JDocumentRendererHtmlModule->render() JROOT\libraries\joomla\document\renderer\html\modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT\libraries\joomla\document\html.php:411 6 JDocumentHtml->getBuffer() JROOT\libraries\joomla\document\html.php:702 5 JDocumentHtml->_renderTemplate() JROOT\libraries\joomla\document\html.php:477 4 JDocumentHtml->render() JROOT\libraries\cms\application\cms.php:1086 3 JApplicationCms->render() JROOT\libraries\cms\application\site.php:773 2 JApplicationSite->render() JROOT\libraries\cms\application\cms.php:267 1 JApplicationCms->execute() JROOT\index.php:49
33 نوع پرس و جو ثبت شده انتخاب جداول: 11 × SELECT `m`.`tag_id`,`t`.*
FROM `iovqe_contentitem_tag_map ` AS m
INNER JOIN `iovqe_tags ` AS t ON `m`.`tag_id` = `t`.`id` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iovqe_extensions ` 2 × 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 iovqe_content AS a
LEFT JOIN iovqe_categories AS c ON c.id = a.catid
LEFT JOIN iovqe_users AS ua ON ua.id = a.created_by
LEFT JOIN iovqe_users AS uam ON uam.id = a.modified_by
LEFT JOIN iovqe_categories as parent ON parent.id = c.parent_id
LEFT JOIN iovqe_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM iovqe_categories AS cat JOIN iovqe_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt 1 × SELECT a.id, a.title, a.catid, a.language, CASE WHEN CHAR_LENGTH (a.alias) != 0 THEN CONCAT_WS (':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH (cc.alias) != 0 THEN CONCAT_WS (':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM iovqe_content AS a
LEFT JOIN iovqe_categories AS cc ON cc.id = a.catid 1 × SELECT a.id, a.name, a.rules
FROM iovqe_assets AS a 1 × SELECT a.id, a.parent_id
FROM iovqe_assets AS a 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH (c.alias) != 0 THEN CONCAT_WS (':', c.id, c.alias) ELSE c.id END as slug
FROM iovqe_categories as c
LEFT JOIN (SELECT cat.id as id FROM iovqe_categories AS cat JOIN iovqe_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM iovqe_modules AS m
LEFT JOIN iovqe_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN iovqe_extensions AS e ON e.element = m.module AND e.client_id = m.client_id 1 × SELECT COUNT (id) AS count_items
FROM iovqe_content 1 × SELECT * FROM iovqe_modules 1 × SELECT SUM (hits) AS count_hits
FROM iovqe_content 1 × SELECT COUNT (`extension_id`)
FROM `iovqe_extensions ` 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 iovqe_content AS a
LEFT JOIN iovqe_categories AS c = a.catid
LEFT JOIN iovqe_users AS u = a.created_by
LEFT JOIN iovqe_categories as parent ON parent.id = c.parent_id
LEFT JOIN iovqe_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM iovqe_categories AS cat JOIN iovqe_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt 1 × SELECT COUNT (id) AS count_users
FROM iovqe_user 1 × SELECT *
FROM iovqe_content 1 × SELECT folder AS type, element AS name, params
FROM iovqe_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 iovqe_menu AS m
LEFT JOIN iovqe_extensions AS e ON m.component_id = e.extension_id 1 × SELECT id, rules
FROM `iovqe_viewlevels 1 × SELECT b.id
FROM iovqe_usergroups AS a
LEFT JOIN iovqe_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT `session_id`
FROM `iovqe_session ` 1 × SELECT *
FROM iovqe_languages 1 × SELECT id, home, template, s.params
FROM iovqe_template_styles as s
LEFT JOIN iovqe_extensions as e ON e.element= s.template AND e.type= 'template' AND e.client_id= s.client_id 1 × SELECT a.name, a.rules
FROM iovqe_assets AS a 1 × SELECT element
FROM iovqe_extensions 1 × SELECT a.rules
FROM iovqe_assets AS a 1 × SELECT *
FROM iovqe_assets 1 × SELECT `data`
FROM `iovqe_session ` سایر جداول: 1 × SHOW FULL COLUMNS FROM `iovqe_content 1 × UPDATE iovqe_content
SET `hits` = (`hits` + 1) 1 × SHOW FULL COLUMNS FROM `iovqe_assets 1 × UPDATE `iovqe_extensions `
SET `params` = '{\"mediaversion\":\"e4a0e738d7796eff466b6aea9285375f\"}' 1 × INSERT INTO `iovqe_session `
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('mtonoe4vcpu83j1rm24nel3uj1', 0, 1, '1585471795', 0, '' 1 × DELETE
FROM `iovqe_session `
ارتباطات:
لینک های مفید:
صفحات اجتماعی:
توئیتر
اشکال یابی جوملا {
" __default " : {
" session " : {
" counter " : 1,
" timer " : {
" start " : 1585471795,
" last " : 1585471795,
" now " : 1585471795
},
" token " : "m46rM3SUJZjX3rY1Kr4n2SPLKaM7R5Nd"
},
" registry " : {},
" user " : {
" id " : 0,
" name " : null ,
" username " : null ,
" email " : null ,
" password " : null ,
" password_clear " : "" ,
" block " : null ,
" sendEmail " : 0,
" registerDate " : null ,
" lastvisitDate " : null ,
" activation " : null ,
" params " : null ,
" groups " : [],
" guest " : 1,
" lastResetTime " : null ,
" resetCount " : null ,
" requireReset " : null ,
" aid " : 0
},
" com_mailto " : {
" links " : {
" 7a1e42edb4b5a20142453ecd6c86bc9cd945dee9 " : {
" link " : "http:\/\/www.drraminasadi.ir\/index.php\/profesional-articles\/hypothyroidism" ,
" expiry " : 1585471796
}
}
}
},
" __sige " : {
" sigcount " : null ,
" sigcountarticles " : null
}
}
زمان حافظه زمان: 28.62 ms / 28.62 ms حافظه: 0.450 MB / 0.58 MB Application: afterLoad
زمان: 126.61 ms / 155.23 ms حافظه: 2.635 MB / 3.22 MB Application: afterInitialise
زمان: 29.77 ms / 185.00 ms حافظه: 0.553 MB / 3.77 MB Application: afterRoute
زمان: 25.12 ms / 210.12 ms حافظه: 0.220 MB / 3.99 MB Application: beforeRenderComponent com_content
زمان: 24.07 ms / 234.19 ms حافظه: 0.587 MB / 4.58 MB Application: Start JAccess::getAssetRules Old (1)
زمان: 6.63 ms / 240.82 ms حافظه: 0.037 MB / 4.62 MB Application: Finish JAccess::getAssetRules Old (1)
زمان: 0.05 ms / 240.87 ms حافظه: 0.000 MB / 4.61 MB Application: Start JAccess::preload(components)
زمان: 6.72 ms / 247.59 ms حافظه: 0.156 MB / 4.77 MB Application: Finish JAccess::preload(components)
زمان: 80.45 ms / 328.04 ms حافظه: 1.154 MB / 5.92 MB Application: New JAccess Preloading Process(com_content.article)
زمان: 2.16 ms / 330.20 ms حافظه: 0.027 MB / 5.95 MB Application: After preloadPermissionsParentIdMapping (com_content.article)
زمان: 4.07 ms / 334.28 ms حافظه: 0.059 MB / 6.01 MB Application: After preloadPermissions (com_content.article)
زمان: 0.02 ms / 334.30 ms حافظه: 0.001 MB / 6.01 MB Application: End New JAccess Preloading Process(com_content.article)
زمان: 0.03 ms / 334.32 ms حافظه: 0.001 MB / 6.01 MB Application: Start JAccess::getAssetRules New (com_content.article.20)
زمان: 0.18 ms / 334.50 ms حافظه: 0.006 MB / 6.02 MB Application: Finish JAccess::getAssetRules New (com_content.article.20)
زمان: 37.20 ms / 371.70 ms حافظه: 0.539 MB / 6.56 MB Application: afterRenderComponent com_content
زمان: 1.31 ms / 373.01 ms حافظه: 0.004 MB / 6.56 MB Application: afterDispatch
زمان: 15.60 ms / 388.62 ms حافظه: 0.130 MB / 6.69 MB Application: beforeRenderModule mod_flexi_customcode (ماژول کپی رایت)
زمان: 7.54 ms / 396.16 ms حافظه: 0.031 MB / 6.72 MB Application: afterRenderModule mod_flexi_customcode (ماژول کپی رایت)
زمان: 0.22 ms / 396.38 ms حافظه: 0.000 MB / 6.72 MB Application: beforeRenderModule mod_flexi_customcode (تماس با ما)
زمان: 5.90 ms / 402.28 ms حافظه: 0.009 MB / 6.73 MB Application: afterRenderModule mod_flexi_customcode (تماس با ما)
زمان: 0.24 ms / 402.52 ms حافظه: 0.001 MB / 6.73 MB Application: beforeRenderModule mod_flexi_customcode (ماژول آدرس و پی نوشت)
زمان: 12.50 ms / 415.02 ms حافظه: 0.026 MB / 6.75 MB Application: afterRenderModule mod_flexi_customcode (ماژول آدرس و پی نوشت)
زمان: 0.20 ms / 415.23 ms حافظه: 0.000 MB / 6.74 MB Application: beforeRenderModule mod_stats (آمار سایت)
زمان: 12.53 ms / 427.76 ms حافظه: 0.068 MB / 6.81 MB Application: afterRenderModule mod_stats (آمار سایت)
زمان: 0.08 ms / 427.84 ms حافظه: 0.000 MB / 6.80 MB Application: beforeRenderModule mod_articles_latest (آخرین مطالب)
زمان: 41.71 ms / 469.55 ms حافظه: 0.401 MB / 7.20 MB Application: afterRenderModule mod_articles_latest (آخرین مطالب)
زمان: 0.21 ms / 469.77 ms حافظه: 0.000 MB / 7.05 MB Application: beforeRenderModule mod_articles_popular (مطالب پربازدید)
زمان: 31.72 ms / 501.49 ms حافظه: 0.254 MB / 7.31 MB Application: afterRenderModule mod_articles_popular (مطالب پربازدید)
زمان: 0.35 ms / 501.84 ms حافظه: 0.000 MB / 7.15 MB Application: beforeRenderModule mod_login (ورود به سایت)
زمان: 8.02 ms / 509.87 ms حافظه: 0.116 MB / 7.27 MB Application: afterRenderModule mod_login (ورود به سایت)
زمان: 0.11 ms / 509.98 ms حافظه: 0.000 MB / 7.26 MB Application: beforeRenderModule mod_breadcrumbs (مسیر سایت)
زمان: 3.30 ms / 513.28 ms حافظه: 0.024 MB / 7.29 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)
زمان: 0.28 ms / 513.56 ms حافظه: 0.004 MB / 7.29 MB Application: beforeRenderModule mod_maximenuck (منوی(Maximenu CK))
زمان: 50.08 ms / 563.64 ms حافظه: 0.696 MB / 7.99 MB Application: afterRenderModule mod_maximenuck (منوی(Maximenu CK))
زمان: 12.99 ms / 576.63 ms حافظه: 0.151 MB / 8.14 MB Application: afterRender
جمع پرس و جوی بانک اطلاعاتی: 210.88 ms
8.26 MB (8,663,440 بایت )
45 پرس و جو ثبت شده 210.88 ms زمان پرس و جو: 5.23 ms
SELECT `data`
FROM `iovqe_session `
WHERE `session_id` = 'mtonoe4vcpu83j1rm24nel3uj1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 14 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 13 JDatabaseDriver->loadResult() JROOT\libraries\joomla\session\storage\database.php:44 12 JSessionStorageDatabase->read() به نظر می رسد خط زیر فراخونده شده باشد. 11 session_start() JROOT\libraries\joomla\session\handler\native.php:259 10 JSessionHandlerNative->doSessionStart() JROOT\libraries\joomla\session\handler\native.php:49 9 JSessionHandlerNative->start() JROOT\libraries\joomla\session\handler\joomla.php:81 8 JSessionHandlerJoomla->start() JROOT\libraries\joomla\session\session.php:636 7 JSession->_start() JROOT\libraries\joomla\session\session.php:596 6 JSession->start() JROOT\libraries\cms\application\cms.php:773 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 1.46 ms پس از آخرین پرس و جو: 5.60 ms
DELETE
FROM `iovqe_session `
WHERE `time` < '1585470895'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE iovqe_session NULL range time time 59 const 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 6 JDatabaseDriverPdo->execute() JROOT\libraries\cms\application\cms.php:790 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 1.42 ms پس از آخرین پرس و جو: 0.21 ms
SELECT `session_id`
FROM `iovqe_session `
WHERE `session_id` = 'mtonoe4vcpu83j1rm24nel3uj1' LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 8 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1728 7 JDatabaseDriver->loadResult() JROOT\libraries\cms\application\cms.php:176 6 JApplicationCms->checkSession() JROOT\libraries\cms\application\cms.php:799 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 8.67 ms پس از آخرین پرس و جو: 0.34 ms
INSERT INTO `iovqe_session `
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('mtonoe4vcpu83j1rm24nel3uj1', 0, 1, '1585471795', 0, '')توضیحات در جستجو ممکن نیست: INSERT INTO `iovqe_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('mtonoe4vcpu83j1rm24nel3uj1', 0, 1, '1585471795', 0, '')
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 7 JDatabaseDriverPdo->execute() JROOT\libraries\cms\application\cms.php:212 6 JApplicationCms->checkSession() JROOT\libraries\cms\application\cms.php:799 5 JApplicationCms->loadSession() JROOT\libraries\cms\application\cms.php:131 4 JApplicationCms->__construct() JROOT\libraries\cms\application\site.php:63 3 JApplicationSite->__construct() JROOT\libraries\cms\application\cms.php:408 2 JApplicationCms::getInstance() JROOT\libraries\joomla\factory.php:125 1 JFactory::getApplication() JROOT\index.php:46
زمان پرس و جو: 12.40 ms پس از آخرین پرس و جو: 5.44 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iovqe_extensions `
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_extensions NULL ref extension extension 82 const 32 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 10 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 9 JDatabaseDriver->loadObjectList() به نظر می رسد خط زیر فراخونده شده باشد. 8 call_user_func_array() JROOT\libraries\joomla\cache\controller\callback.php:152 7 JCacheControllerCallback->get() JROOT\libraries\cms\component\helper.php:448 6 JComponentHelper::load() JROOT\libraries\cms\component\helper.php:43 5 JComponentHelper::getComponent() JROOT\libraries\cms\component\helper.php:120 4 JComponentHelper::getParams() JROOT\libraries\cms\application\site.php:589 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.57 ms پس از آخرین پرس و جو: 2.97 ms
SELECT b.id
FROM iovqe_usergroups AS a
LEFT JOIN iovqe_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 index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 100.00 Using where; Using index
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 11 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT\libraries\joomla\access\access.php:835 9 JAccess::getGroupsByUser() JROOT\libraries\joomla\access\access.php:904 8 JAccess::getAuthorisedViewLevels() JROOT\libraries\joomla\user\user.php:454 7 JUser->getAuthorisedViewLevels() JROOT\libraries\cms\plugin\helper.php:296 6 JPluginHelper::load() JROOT\libraries\cms\plugin\helper.php:86 5 JPluginHelper::getPlugin() JROOT\libraries\cms\plugin\helper.php:128 4 JPluginHelper::isEnabled() JROOT\libraries\cms\application\site.php:599 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.52 ms پس از آخرین پرس و جو: 1.77 ms
SELECT id, rules
FROM `iovqe_viewlevels `id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_viewlevels NULL ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 5 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 10 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1494 9 JDatabaseDriver->loadAssocList() JROOT\libraries\joomla\access\access.php:921 8 JAccess::getAuthorisedViewLevels() JROOT\libraries\joomla\user\user.php:454 7 JUser->getAuthorisedViewLevels() JROOT\libraries\cms\plugin\helper.php:296 6 JPluginHelper::load() JROOT\libraries\cms\plugin\helper.php:86 5 JPluginHelper::getPlugin() JROOT\libraries\cms\plugin\helper.php:128 4 JPluginHelper::isEnabled() JROOT\libraries\cms\application\site.php:599 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.61 ms پس از آخرین پرس و جو: 0.29 ms
SELECT folder AS type, element AS name, params
FROM iovqe_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) 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 iovqe_extensions NULL ref extension extension 82 const 60 0.71 Using index condition; Using where; با استفاده از مرتب سازی فایل
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 8 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 7 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\plugin\helper.php:310 6 JPluginHelper::load() JROOT\libraries\cms\plugin\helper.php:86 5 JPluginHelper::getPlugin() JROOT\libraries\cms\plugin\helper.php:128 4 JPluginHelper::isEnabled() JROOT\libraries\cms\application\site.php:599 3 JApplicationSite->initialiseApp() JROOT\libraries\cms\application\site.php:209 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 10.24 ms پس از آخرین پرس و جو: 30.16 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 iovqe_menu AS m
LEFT JOIN iovqe_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 28 3.33 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dr_ramin_asadi_13962017.m.component_id 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 16 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\menu\site.php:86 14 JMenuSite->load() JROOT\libraries\cms\menu\menu.php:74 13 JMenu->__construct() JROOT\libraries\cms\menu\site.php:57 12 JMenuSite->__construct() JROOT\libraries\cms\menu\menu.php:145 11 JMenu::getInstance() JROOT\libraries\cms\application\cms.php:439 10 JApplicationCms->getMenu() JROOT\libraries\cms\application\site.php:272 9 JApplicationSite->getMenu() JROOT\libraries\cms\router\site.php:57 8 JRouterSite->__construct() JROOT\libraries\cms\router\router.php:197 7 JRouter::getInstance() JROOT\libraries\cms\application\cms.php:535 6 JApplicationCms::getRouter() JROOT\libraries\cms\application\site.php:407 5 JApplicationSite::getRouter() JROOT\libraries\cms\application\cms.php:1115 4 JApplicationCms->route() JROOT\libraries\cms\application\site.php:791 3 JApplicationSite->route() JROOT\libraries\cms\application\site.php:215 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.78 ms پس از آخرین پرس و جو: 17.00 ms
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iovqe_extensions `
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 14 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1650 13 JDatabaseDriver->loadObject() به نظر می رسد خط زیر فراخونده شده باشد. 12 call_user_func_array() JROOT\libraries\joomla\cache\controller\callback.php:152 11 JCacheControllerCallback->get() JROOT\libraries\cms\library\helper.php:156 10 JLibraryHelper::_load() JROOT\libraries\cms\library\helper.php:47 9 JLibraryHelper::getLibrary() JROOT\libraries\cms\library\helper.php:90 8 JLibraryHelper::getParams() JROOT\libraries\cms\version\version.php:274 7 JVersion->getMediaVersion() JROOT\libraries\joomla\factory.php:755 6 JFactory::createDocument() JROOT\libraries\joomla\factory.php:216 5 JFactory::getDocument() JROOT\libraries\joomla\application\web.php:977 4 JApplicationWeb->loadDocument() JROOT\libraries\cms\application\site.php:130 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 8.07 ms پس از آخرین پرس و جو: 0.46 ms
UPDATE `iovqe_extensions `
SET `params` = '{\"mediaversion\":\"e4a0e738d7796eff466b6aea9285375f\"}'
WHERE `type` = 'library' AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE iovqe_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 10 JDatabaseDriverPdo->execute() JROOT\libraries\cms\library\helper.php:119 9 JLibraryHelper::saveParams() JROOT\libraries\cms\version\version.php:325 8 JVersion->setMediaVersion() JROOT\libraries\cms\version\version.php:284 7 JVersion->getMediaVersion() JROOT\libraries\joomla\factory.php:755 6 JFactory::createDocument() JROOT\libraries\joomla\factory.php:216 5 JFactory::getDocument() JROOT\libraries\joomla\application\web.php:977 4 JApplicationWeb->loadDocument() JROOT\libraries\cms\application\site.php:130 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 5.28 ms پس از آخرین پرس و جو: 3.67 ms
SELECT *
FROM iovqe_languages
WHERE published= 1
ORDER BY ordering ASC id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_languages NULL ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 2 50.00 Using where; با استفاده از مرتب سازی فایل
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 7 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 6 JDatabaseDriver->loadObjectList() JROOT\libraries\joomla\language\helper.php:164 5 JLanguageHelper::getLanguages() JROOT\libraries\cms\application\site.php:329 4 JApplicationSite->getParams() JROOT\libraries\cms\application\site.php:135 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 3.15 ms پس از آخرین پرس و جو: 0.91 ms
SELECT id, home, template, s.params
FROM iovqe_template_styles as s
LEFT JOIN iovqe_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 403 dr_ramin_asadi_13962017.s.template,const 1 4.61 Using index condition; Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 6 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 5 JDatabaseDriver->loadObjectList() JROOT\libraries\cms\application\site.php:484 4 JApplicationSite->getTemplate() JROOT\libraries\cms\application\site.php:165 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 5.19 ms پس از آخرین پرس و جو: 15.00 ms
SHOW FULL COLUMNS FROM `iovqe_assets `توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `iovqe_assets`
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 21 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1689 20 JDatabaseDriver->loadObjectList() JROOT\libraries\joomla\database\driver\pdomysql.php:320 19 JDatabaseDriverPdomysql->getTableColumns() JROOT\libraries\joomla\table\table.php:241 18 JTable->getFields() JROOT\libraries\joomla\table\table.php:162 17 JTable->__construct() JROOT\libraries\joomla\table\asset.php:60 16 JTableAsset->__construct() JROOT\libraries\joomla\table\table.php:308 15 JTable::getInstance() JROOT\libraries\joomla\access\access.php:696 14 JAccess::getExtensionNameFromAsset() JROOT\libraries\joomla\access\access.php:555 13 JAccess::getAssetRules() JROOT\libraries\joomla\user\user.php:385 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.76 ms پس از آخرین پرس و جو: 2.62 ms
SELECT *
FROM iovqe_assets
WHERE `id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_assets NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 17 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1453 16 JDatabaseDriver->loadAssoc() JROOT\libraries\joomla\table\table.php:719 15 JTable->load() JROOT\libraries\joomla\access\access.php:697 14 JAccess::getExtensionNameFromAsset() JROOT\libraries\joomla\access\access.php:555 13 JAccess::getAssetRules() JROOT\libraries\joomla\user\user.php:385 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 4.50 ms پس از آخرین پرس و جو: 0.28 ms
SELECT a.rules
FROM iovqe_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index_merge PRIMARY,idx_asset_name PRIMARY,idx_asset_name 4,202 NULL 2 100.00 Using union(PRIMARY,idx_asset_name); Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 15 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1538 14 JDatabaseDriver->loadColumn() JROOT\libraries\joomla\access\access.php:652 13 JAccess::getAssetRules() JROOT\libraries\joomla\user\user.php:385 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 1.90 ms پس از آخرین پرس و جو: 2.20 ms
SELECT element
FROM iovqe_extensions
WHERE type = 'component' AND enabled = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE iovqe_extensions NULL ref extension extension 82 const 32 10.00 Using where
عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)
# فراخوانده فایل و شماره خط 17 JDatabaseDriverPdo->execute() JROOT\libraries\joomla\database\driver.php:1538 16 JDatabaseDriver->loadColumn() JROOT\libraries\joomla\access\access.php:413 15 JAccess::preloadComponents() JROOT\libraries\joomla\access\access.php:213 14 JAccess::preload() JROOT\libraries\joomla\access\access.php:168 13 JAccess::check() JROOT\libraries\joomla\user\user.php:394 12 JUser->authorise() JROOT\components\com_content\models\article.php:55 11 ContentModelArticle->populateState() JROOT\libraries\legacy\model\legacy.php:435 10 JModelLegacy->getState() JROOT\components\com_content\models\article.php:262 9 ContentModelArticle->hit() JROOT\components\com_content\controller.php:109 8 ContentController->display() JROOT\libraries\legacy\controller\legacy.php:702 7 JControllerLegacy->execute() JROOT\components\com_content\content.php:38 6 require_once JROOT\components\com_content\content.php JROOT\libraries\cms\component\helper.php:405 5 JComponentHelper::executeComponent() JROOT\libraries\cms\component\helper.php:380 4 JComponentHelper::renderComponent() JROOT\libraries\cms\application\site.php:191 3 JApplicationSite->dispatch() JROOT\libraries\cms\application\site.php:230 2 JApplicationSite->doExecute() JROOT\libraries\cms\application\cms.php:261 1 JApplicationCms->execute() JROOT\index.php:49
زمان پرس و جو: 2.80 ms پس از آخرین پرس و جو: 0.33 ms
صفحات اجتماعی: