- تلرانس هندسی
تلرانس هندسی
پیشرفت های فنی ، منجر به عملکرد بالاتر ، بهره وری بالاتر و قابلیت اطمینان بیشتر محصولات تولیدی میباشد. تلرانس گذاری اعمال شده بر روی قطعات و محصولات تولید شده در صنعت نیاز به تعریف تلرانس های پذیرش قابل حصول مطابق با فرایند تولید و عملکرد قطعه در محصول نهایی میباشد و ارزان سازی قطعه تولیدی با کیفیت یکی از اهداف طراحان با تجربه در طراحی و ساخت قطعه میباشد.
برای داشتن نقشه تلرانس گذاری شده مناسب، مطابق با عملکرد محصول نهایی، برای تولید و کنترل از تلرانس گذاری ابعادی و هندسی مانند تلرانس های فرم، اندازه ، راستا و مکان استفاده میشود.
هیچ چیز به قضاوت فردی سازنده یا بازرس واگذار نمی شود. تنها با استفاده از این رویکرد می توان عملکرد صحیح را تأیید و از امکانات موجود برای ارزان سازی و منطقی سازی در ساخت و بازرسی به طور کامل استفاده کرد.
با تحلیل تلرانس های ابعادی و هندسی در زنجیره ابعادی و هندسی محصولات مونتاژ شده مقدار انحراف قابل پذیرش بررسی میشود و در صورت نیاز به اصلاح تلرانس و یا مبنای اندازه گیری و ماشینکاری اقدامات اصلاحی انجام گردیده تا به اندازه و تلرانس مورد نیاز منجر گردیده و در تولید انبوه مشکل مونتاژی یا عملکردی در محصول ایجاد نگردد.
این کتاب را میتوان یک کتاب جامع تلرانس گذاری ابعادی و هندسی دانست که یک طراح و صنعتگر برای طراحی و ساخت محصولات با کیفیت نیاز دارد .
این کتاب بر اساس استاندارد بین المللی ASME Y14.5-2018 تالیف گردیده است . برای طراحی و تولید یک محصول که متشکل از قطعات منفصله میباشد قطعات تولیدی باید در یک محدوده تلرانسی ابعادی و هندسی قرار داشته باشند تا زنجیره انحرافهای ابعادی و هندسی قطعات الزامات طراحی را در محصول نهایی پوشش دهد .
بنابراین تعریف مبناهای اندازه گیری و محدوده پذیرش انحراف های ابعادی و هندسی و تحلیل تلرانس که در زنجیره ابعادی و هندسی محصول موثر میباشد یکی از نیازهای طراح برای تلرانس گذاری ابعادی و هندسی مطلوب میباشد.
در این کتاب تلرانس گذاری متناسب با نیاز های مختلف عملکردی ، راهنمای تلرانس هندسی و تلرانس ابعادی عمومی و خاص را به تفصیل شرح داده ولی مقادیر تلرانس میبایست مطابق با عملکرد قطعه در محصول طراحی شده در نظر گرفته شود.
این کتاب میتواند یکی از منابع جامع برای اندازه گذاری و تلرانس گذاری ابعادی و هندسی برای طراحان ، دانشجویان و صنعتگران باشد ، و همچنین میتواند در زمینه طراحی ، ساخت و کنترل برای تجهیزات پزشکی مورد استفاده قرار گیرد.
نویسنده از تجربیات خود در طی آموزشها و بحث های خود در مورد اندازه گیری هندسی و تلرانس در صنعت و آموزش استفاده کرده است. با این حال ، برای بهبود و ویرایش این کتاب مشتاق ارائه نظرات شما خواننده محترم میباشم. بدین منظور ایمیلاین آدرس ایمیل توسط spambots حفاظت می شود. برای دیدن شما نیاز به جاوا اسکریپت دارید و شماره تلفن 09123345784 برای ارتباط خوانندگان گرامی با نویسنده در نظر گرفته شده است.
این کتاب حاصل درک نویسنده از انواع مختلف استانداردها و برای اهداف آموزشی نوشته شده است. در موارد اختلاف ، باید استانداردهای اصلی در نظر گرفته شود. موارد عملکردی الزامات هندسی در طیف گسترده ای متفاوت است.بنابراین ، قبل از استفاده در عمل ، باید بررسی شود که آیا ارائه در کتاب با هدف خاص عملکردی متناسب است یا خیر.
طراحی و تلرانس گذاری فرآیندی پویا و مداوم است. لذا این کتاب میتواند در نسخه های چاپی آینده از ویرایش های دیگر پیروی کند .
در این سایت از استانداردها و منابع فراوان و تجربه 25 ساله مولف در زمینه تلرانس های ابعادی و هندسی و زنجیره تلرانس تالیف شده است، لذا از خوانندگان محترم تقاضا دارد که در حفظ حق نشر و کپی این اثر نویسنده را یاری نمایند.
با سپاس
علیرضا عشاق الحسینی
قانون اول تلرانس هندسی
قانون اول تلرانس هندسی
در قانون اول تلرانس هندسی اشاره بر " خطای فرم درحالت ماکزیمم متریال ایده آل است"  
تلرانس لنگی ساده
قانون اول تلرانس هندسی
19 فروردين 1403جیگ و فیکسچر تولیدی
03 بهمن 1393تلرانس لنگی ساده
20 فروردين 1403چکینگ فیکسچر شیشه
20 فروردين 1401تلرانس تقارن MMC
03 تیر 1398تلرانس ابعادی و هندسی
03 بهمن 1393
تعریف فیچرfature
20 فروردين 1403تلرانس لنگی محوری
20 فروردين 1403تلرانس گذاری حدی
20 فروردين 1403تلرانس ابعادی dimensional tolerance
20 فروردين 1403تلرانس لنگی ساده
20 فروردين 1403تلرانس ابعادی یکطرفه مثبت یا منفی
20 فروردين 1403انطباقات
20 فروردين 1403تلرانس گذاری حدی مینیم یا ماکزیمم
20 فروردين 1403تلرانس پروفایل یک طرفهunilateral
19 فروردين 1403تلرانس پروفایل تمام فیچرها allover
19 فروردين 1403
تگها
Articles
- آوریل 2024(10)
- محاسبه inner and outer boundary موقعیت شفت در حالت LMC 1403-01-21 11:19:59
- محاسبه inner and outer boundary موقعیت سوراخ در حالت LMC 1403-01-21 11:18:39
- محاسبه inner and outer boundary موقعیت سوراخ در حالت MMC 1403-01-21 10:36:30
- محاسبه inner and outer boundary موقعیت شفت در حالت RFS 1403-01-21 10:31:37
- محاسبه inner and outer boundary موقعیت سوراخ در حالت MMC 1403-01-21 10:27:07
- تحلیل تلرانس و زنجیره ابعادی 1403-01-21 06:16:05
- تلرانس گذاری حدی 1403-01-20 09:37:10
- تلرانس ابعادی dimensional tolerance 1403-01-20 09:27:42
- تلرانس ابعادی یکطرفه مثبت یا منفی 1403-01-20 07:43:00
- انطباقات 1403-01-20 07:43:00
رنگهای قالب
اشکال یابی جوملا
{ "__default": { "session": { "counter": 1, "timer": { "start": 1714101394, "last": 1714101394, "now": 1714101394 }, "token": "n3nuSPz4ibsxoolyQPWal3WUNUVDyjRc" }, "registry": { "com_content": { "category": { "filter": { "97:1484": { "tag": [ 2, 9 ] } } } } }, "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 }, "flushSessions": null } }
زمان
حافظه
70 پرس و جو ثبت شده 2392.01 ms
- زمان پرس و جو: 11.05 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 4.169 MB سطرهای بازگشتی: 0
SELECT `data`
FROM `i4x98_session`
WHERE `session_id` = X'6437653935323434396163326639356133656430393238616566313662666236'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 10.62 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() به نظر می رسد خط زیر فراخونده شده باشد. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.32 ms پس از آخرین پرس و جو: 1.52 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 4.264 MB سطرهای بازگشتی: 0
SELECT `session_id`
FROM `i4x98_session`
WHERE `session_id` = X'6437653935323434396163326639356133656430393238616566313662666236'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 7.24 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.269 MB
INSERT INTO `i4x98_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6437653935323434396163326639356133656430393238616566313662666236', 1, 1714101394, 0, '', 0)توضیحات در جستجو ممکن نیست: INSERT INTO `i4x98_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6437653935323434396163326639356133656430393238616566313662666236', 1, 1714101394, 0, '', 0)Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.02 ms Update 6.83 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.15 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 4.16 ms پس از آخرین پرس و جو: 2.91 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 4.458 MB سطرهای بازگشتی: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i4x98_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_extensions ref extension extension 82 const 45 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.04 ms Statistics 1.19 ms Preparing 0.03 ms Executing 0.01 ms Sending data 2.53 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() به نظر می رسد خط زیر فراخونده شده باشد. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.70 ms پس از آخرین پرس و جو: 2.84 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.715 MB سطرهای بازگشتی: 4
SELECT id, rules
FROM `i4x98_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_viewlevels ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 4 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.31 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.23 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 4.726 MB سطرهای بازگشتی: 1
SELECT b.id
FROM i4x98_usergroups AS a
LEFT JOIN i4x98_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.05 ms checking permissions 0.34 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.47 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.74 ms پس از آخرین پرس و جو: 0.72 ms حافظه پرس و جو: 0.031 MB حافظه قبل از پرس و جوی: 4.794 MB سطرهای بازگشتی: 121
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM i4x98_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_extensions ALL extension کلید شاخصی برای استفاده نیست NULL NULL 345 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.34 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() به نظر می رسد خط زیر فراخونده شده باشد. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.07 ms پس از آخرین پرس و جو: 84.15 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 11.349 MB سطرهای بازگشتی: 254
SELECT config_key, config_value
FROM i4x98_eshop_configsid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_eshop_configs ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 254 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.54 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php 10 EshopHelper::getConfig() JROOT/components/com_eshop/helpers/helper.php 9 EshopHelper::getConfigValue() JROOT/plugins/system/eshopcurrency/eshopcurrency.php 8 plgSystemEshopCurrency->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.73 ms پس از آخرین پرس و جو: 0.47 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 11.393 MB سطرهای بازگشتی: 0
SELECT *
FROM i4x98_eshop_currencies
WHERE currency_code != 'IRR'
AND modified_date <= '2024-04-25 06:46:34'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_eshop_currencies ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 3 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.29 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php 9 EshopHelper::updateCurrencies() JROOT/plugins/system/eshopcurrency/eshopcurrency.php 8 plgSystemEshopCurrency->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.60 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 11.399 MB
UPDATE i4x98_eshop_currencies
SET exchanged_value = 1.00000 , modified_date = '2024-04-26 06:46:34'
WHERE currency_code = 'IRR'توضیحات در جستجو ممکن نیست: UPDATE i4x98_eshop_currencies SET exchanged_value = 1.00000 , modified_date = '2024-04-26 06:46:34' WHERE currency_code = 'IRR'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init for update 0.05 ms Updating 0.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.14 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/components/com_eshop/helpers/helper.php 9 EshopHelper::updateCurrencies() JROOT/plugins/system/eshopcurrency/eshopcurrency.php 8 plgSystemEshopCurrency->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.63 ms پس از آخرین پرس و جو: 12.70 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 12.586 MB سطرهای بازگشتی: 22
SELECT *
FROM i4x98_rsform_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_rsform_config ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 22 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.48 ms پس از آخرین پرس و جو: 0.16 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 12.600 MB
UPDATE i4x98_rsform_config
SET `SettingValue`='1714101394'
WHERE `SettingName`='deleteafter.last_run'توضیحات در جستجو ممکن نیست: UPDATE i4x98_rsform_config SET `SettingValue`='1714101394' WHERE `SettingName`='deleteafter.last_run'Status Duration Starting 0.03 ms checking permissions 0.02 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.04 ms Updating 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.10 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_rsform/helpers/config.php 9 RSFormProConfig->set() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.00 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 12.605 MB سطرهای بازگشتی: 0
SELECT `FormId`,`DeleteSubmissionsAfter`
FROM `i4x98_rsform_forms`
WHERE `DeleteSubmissionsAfter` > '0'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_rsform_forms ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 8 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 1.57 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 5.39 ms پس از آخرین پرس و جو: 17.23 ms حافظه پرس و جو: 0.107 MB حافظه قبل از پرس و جوی: 14.341 MB سطرهای بازگشتی: 62
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 i4x98_menu AS m
LEFT JOIN i4x98_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 165 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 fixture_almone505480.m.component_id 1 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.03 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.37 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 4.41 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() به نظر می رسد خط زیر فراخونده شده باشد. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.51 ms پس از آخرین پرس و جو: 13.08 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 15.233 MB سطرهای بازگشتی: 4
SELECT id, home, template, s.params
FROM i4x98_template_styles as s
LEFT JOIN i4x98_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home کلید شاخصی برای استفاده نیست NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 fixture_almone505480.s.template,const 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.58 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.46 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:320 9 T3::detect() JROOT/plugins/system/t3/t3.php:81 8 plgSystemT3->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 21.73 ms پس از آخرین پرس و جو: 11.80 ms حافظه پرس و جو: 0.198 MB حافظه قبل از پرس و جوی: 16.198 MB سطرهای بازگشتی: 152
SELECT `name`,`value`
FROM `i4x98_joombank_setting`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_joombank_setting ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 150 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 21.33 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 17 JDatabaseDriver->loadAssocList() JROOT/libraries/joombank/cms/joomla/libraries/joomla.php 16 JBNJoomla::globalDbQuery() JROOT/libraries/joombank/cms/joomla/libraries/joomla.php 15 JBNJoomla::selectByQuery() JROOT/libraries/joombank/cms/joomla/libraries/joomla.php 14 JBNJoomla::selectAll() JROOT/libraries/joombank/libraries/cms.php 13 JBNCms::setSettings() JROOT/libraries/joombank/libraries/cms.php 12 JBNCms::getSetting() JROOT/libraries/joombank/libraries/bill.php 11 JBNBill->deleteTransactionWhere() JROOT/libraries/joombank/libraries/bill.php 10 JBNBill->deleteExpireTransactionsAndSendNotification() JROOT/libraries/joombank/libraries/bill.php 9 JBNBill->doCronJobActions() JROOT/plugins/system/joombank_loader/joombank_loader.php 8 plgSystemJoombank_loader->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.81 ms پس از آخرین پرس و جو: 3.18 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 16.668 MB سطرهای بازگشتی: 0
SELECT `id`,`status`,`total_amount`,`discount_amount`,`discount_code`
FROM `i4x98_joombank_transactions`
WHERE `discount_amount` > 0
AND `status` NOT IN (10,4)
AND `modified_date`<'1403/02/07 06:16:34'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_joombank_transactions ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 11 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.38 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/libraries/joombank/cms/joomla/libraries/joomla.php 12 JBNJoomla::globalDbQuery() JROOT/libraries/joombank/cms/joomla/libraries/joomla.php 11 JBNJoomla::selectByQuery() JROOT/libraries/joombank/libraries/discount.php 10 JBNDiscount->checkUserDiscounts() JROOT/libraries/joombank/libraries/bill.php 9 JBNBill->doCronJobActions() JROOT/plugins/system/joombank_loader/joombank_loader.php 8 plgSystemJoombank_loader->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.39 ms پس از آخرین پرس و جو: 0.12 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 16.677 MB سطرهای بازگشتی: 0
SELECT `id`,`code`,`status`,`total_amount`,`wallet_amount`,`user_id`
FROM `i4x98_joombank_transactions`
WHERE `wallet_amount` > 0
AND `user_id` > 0
AND `status` NOT IN (10,4)
AND `modified_date`<'1403/02/07 06:16:34'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_joombank_transactions ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 11 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/libraries/joombank/cms/joomla/libraries/joomla.php 12 JBNJoomla::globalDbQuery() JROOT/libraries/joombank/cms/joomla/libraries/joomla.php 11 JBNJoomla::selectByQuery() JROOT/libraries/joombank/libraries/users.php 10 JBNUsers->checkWalletPayTransactions() JROOT/libraries/joombank/libraries/bill.php 9 JBNBill->doCronJobActions() JROOT/plugins/system/joombank_loader/joombank_loader.php 8 plgSystemJoombank_loader->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.76 ms پس از آخرین پرس و جو: 0.99 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 16.724 MB سطرهای بازگشتی: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i4x98_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.38 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() به نظر می رسد خط زیر فراخونده شده باشد. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 0.16 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 16.715 MB
UPDATE `i4x98_extensions`
SET `params` = '{\"mediaversion\":\"fe93a77ce5f470bce020d1e59ee958a6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'توضیحات در جستجو ممکن نیست: UPDATE `i4x98_extensions` SET `params` = '{\"mediaversion\":\"fe93a77ce5f470bce020d1e59ee958a6\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.06 ms Updating 0.11 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.12 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.73 ms پس از آخرین پرس و جو: 2.05 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 16.898 MB سطرهای بازگشتی: 2
SELECT *
FROM i4x98_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_languages ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 5 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.32 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 3.94 ms پس از آخرین پرس و جو: 8.28 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 18.114 MB سطرهای بازگشتی: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `i4x98_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eshop','com_fbconnct','com_fields','com_finder','com_installer','com_jce','com_joombank','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_assets range idx_asset_name idx_asset_name 202 NULL 43 Using index condition Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.13 ms Preparing 0.03 ms Executing 0.01 ms Sending data 3.33 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.03 ms پس از آخرین پرس و جو: 0.21 ms حافظه پرس و جو: 0.068 MB حافظه قبل از پرس و جوی: 18.165 MB سطرهای بازگشتی: 284
SELECT `id`,`name`,`rules`,`parent_id`
FROM `i4x98_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_assets ALL idx_asset_name,idx_parent_id کلید شاخصی برای استفاده نیست NULL NULL 483 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.25 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.47 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.93 ms پس از آخرین پرس و جو: 2.23 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 18.482 MB سطرهای بازگشتی: 3
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 97
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 1.16 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 4.75 ms پس از آخرین پرس و جو: 1.98 ms حافظه پرس و جو: 0.042 MB حافظه قبل از پرس و جوی: 18.663 MB سطرهای بازگشتی: 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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
INNER JOIN ( SELECT DISTINCT content_item_id
FROM `i4x98_contentitem_tag_map`
WHERE tag_id IN (2,9)
AND type_alias = 'com_content.article') AS tagmap
ON tagmap.content_item_id = a.id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 97
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 03:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 03:16:34')
ORDER BY c.lft, a.ordering, a.created
LIMIT 8id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 Using temporary; با استفاده از مرتب سازی فایل 1 PRIMARY <derived2> ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 22 1 PRIMARY a eq_ref|filter PRIMARY,idx_state,idx_catid idx_state|idx_catid 5|4 const,tagmap.content_item_id 1 (13%) Using index condition; Using where; Using rowid filter 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where 2 DERIVED i4x98_contentitem_tag_map ALL idx_tag_type کلید شاخصی برای استفاده نیست NULL NULL 90 Using where; Using temporary Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.20 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.13 ms Optimizing 0.05 ms Optimizing 0.01 ms Statistics 0.28 ms Preparing 0.02 ms Creating tmp table 0.03 ms Statistics 0.63 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.05 ms Creating tmp table 0.12 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.38 ms Removing tmp table 0.02 ms Sending data 2.08 ms Creating sort index 0.07 ms Removing tmp table 0.14 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.39 ms پس از آخرین پرس و جو: 1.20 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 18.803 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
INNER JOIN ( SELECT DISTINCT content_item_id
FROM `i4x98_contentitem_tag_map`
WHERE tag_id IN (2,9)
AND type_alias = 'com_content.article') AS tagmap
ON tagmap.content_item_id = a.id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 97
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 03:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 03:16:34')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 1 PRIMARY a ref PRIMARY,idx_state,idx_catid idx_catid 4 const 25 Using where 1 PRIMARY <derived2> ref key0 key0 4 fixture_almone505480.a.id 1 Using where 2 DERIVED i4x98_contentitem_tag_map ALL idx_tag_type کلید شاخصی برای استفاده نیست NULL NULL 90 Using where; Using temporary Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Creating tmp table 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.70 ms Executing 0.02 ms Sending data 0.12 ms Removing tmp table 0.01 ms Sending data 0.90 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.26 ms پس از آخرین پرس و جو: 1.58 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 18.998 MB سطرهای بازگشتی: 0
SELECT `m`.`tag_id`,`t`.*
FROM `i4x98_contentitem_tag_map` AS m
INNER JOIN `i4x98_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 97
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ALL PRIMARY,tag_idx,idx_access کلید شاخصی برای استفاده نیست NULL NULL 12 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 fixture_almone505480.t.id 4 Using index condition; Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.48 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.36 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.87 ms پس از آخرین پرس و جو: 10.17 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 19.569 MB سطرهای بازگشتی: 3
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 97
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.29 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 16 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 15 Joomla\CMS\Router\Route::_() JROOT/plugins/content/jw_disqus/jw_disqus.php:172 14 plgContentJw_disqus->renderDisqus() JROOT/plugins/content/jw_disqus/jw_disqus.php:44 13 plgContentJw_disqus->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.43 ms پس از آخرین پرس و جو: 210.42 ms حافظه پرس و جو: 0.135 MB حافظه قبل از پرس و جوی: 22.401 MB سطرهای بازگشتی: 25
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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 97
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 03:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 03:16:34')
ORDER BY c.lft, a.ordering, a.created ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref idx_state,idx_catid idx_catid 4 const 25 Using where; با استفاده از مرتب سازی فایل 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.23 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 1.36 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.09 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 9 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 8 ContentModelArticles->getItems() JROOT/plugins/system/plg_sj_content_listing_ajax/plg_sj_content_listing_ajax.php:125 7 plgSystemPlg_Sj_Content_Listing_Ajax->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.37 ms پس از آخرین پرس و جو: 3.97 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 22.484 MB سطرهای بازگشتی: 1
SELECT template_style_id
FROM i4x98_menu
WHERE id = 1484id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:187 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:31 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/jm_iliya/includes/frame_inc.php 8 include_once JROOT/templates/jm_iliya/includes/frame_inc.php JROOT/templates/jm_iliya/index.php:23 7 require JROOT/templates/jm_iliya/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.43 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 22.490 MB سطرهای بازگشتی: 1
SELECT id
FROM i4x98_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_template_styles ref idx_client_id,idx_client_id_home idx_client_id_home 1 const 4 Using where; Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:191 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:31 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/jm_iliya/includes/frame_inc.php 8 include_once JROOT/templates/jm_iliya/includes/frame_inc.php JROOT/templates/jm_iliya/index.php:23 7 require JROOT/templates/jm_iliya/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 6.43 ms پس از آخرین پرس و جو: 1.89 ms حافظه پرس و جو: 0.044 MB حافظه قبل از پرس و جوی: 22.595 MB سطرهای بازگشتی: 23
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM i4x98_modules AS m
LEFT JOIN i4x98_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN i4x98_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 <= '2024-04-26 03:16:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 03:16:34')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1484 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds کلید شاخصی برای استفاده نیست NULL NULL 116 Using where; با استفاده از مرتب سازی فایل 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 fixture_almone505480.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 fixture_almone505480.m.id 3 Using where; Using index Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.37 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 5.47 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() به نظر می رسد خط زیر فراخونده شده باشد. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:177 11 YtFrameworkRenderXML->getBlocks() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:115 10 YtFrameworkRenderXML->getTagBody() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49 9 YtFrameworkRenderXML->YtFrameworkRenderXML() JROOT/templates/jm_iliya/includes/frame_inc.php 8 include_once JROOT/templates/jm_iliya/includes/frame_inc.php JROOT/templates/jm_iliya/index.php:23 7 require JROOT/templates/jm_iliya/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.37 ms پس از آخرین پرس و جو: 1.41 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 22.677 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1484id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:175 8 YtFrameworkTemplate->isHomePage() JROOT/templates/jm_iliya/index.php:75 7 require JROOT/templates/jm_iliya/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.33 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.021 MB حافظه قبل از پرس و جوی: 22.683 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1484id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:176 8 YtFrameworkTemplate->isHomePage() JROOT/templates/jm_iliya/index.php:75 7 require JROOT/templates/jm_iliya/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.35 ms پس از آخرین پرس و جو: 1.45 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 22.729 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1484id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 11 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:175 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:328 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/jm_iliya/includes/block-content.php 8 include JROOT/templates/jm_iliya/includes/block-content.php JROOT/templates/jm_iliya/index.php:201 7 require JROOT/templates/jm_iliya/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.44 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 22.735 MB سطرهای بازگشتی: 1
SELECT home
FROM i4x98_menu
WHERE id=1484id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:176 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:328 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/jm_iliya/includes/block-content.php 8 include JROOT/templates/jm_iliya/includes/block-content.php JROOT/templates/jm_iliya/index.php:201 7 require JROOT/templates/jm_iliya/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.41 ms پس از آخرین پرس و جو: 5.77 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 22.865 MB سطرهای بازگشتی: 1
SELECT *
FROM i4x98_modules
WHERE id='405'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_modules const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:101 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 6.22 ms پس از آخرین پرس و جو: 1.11 ms حافظه پرس و جو: 0.067 MB حافظه قبل از پرس و جوی: 22.929 MB سطرهای بازگشتی: 6
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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid IN (112,118,119,120,126,86,116,136,127,80,115,137,97,117)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 03:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 03:16:34')
ORDER BY a.hits DESC
LIMIT 6id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_state,idx_catid idx_catid 4 NULL 86 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 fixture_almone505480.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 5.37 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 24 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 23 ContentModelArticles->getItems() JROOT/modules/mod_articles_popular/helper.php:77 22 ModArticlesPopularHelper::getList() JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 21 include JROOT/modules/mod_articles_popular/mod_articles_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.76 ms پس از آخرین پرس و جو: 0.65 ms حافظه پرس و جو: 0.035 MB حافظه قبل از پرس و جوی: 23.045 MB سطرهای بازگشتی: 6
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 112
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.15 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 35 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 34 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 33 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 32 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 31 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 30 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 29 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 28 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 27 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 26 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 25 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 24 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 23 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_popular/helper.php:89 22 ModArticlesPopularHelper::getList() JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 21 include JROOT/modules/mod_articles_popular/mod_articles_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.65 ms پس از آخرین پرس و جو: 0.33 ms حافظه پرس و جو: 0.034 MB حافظه قبل از پرس و جوی: 23.086 MB سطرهای بازگشتی: 4
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 116
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 35 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 34 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 33 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 32 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 31 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 30 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 29 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 28 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 27 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 26 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 25 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 24 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 23 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_popular/helper.php:89 22 ModArticlesPopularHelper::getList() JROOT/modules/mod_articles_popular/mod_articles_popular.php:15 21 include JROOT/modules/mod_articles_popular/mod_articles_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.32 ms پس از آخرین پرس و جو: 6.47 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 23.066 MB سطرهای بازگشتی: 1
SELECT *
FROM i4x98_modules
WHERE id='402'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_modules const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:101 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.89 ms پس از آخرین پرس و جو: 1.12 ms حافظه پرس و جو: 0.067 MB حافظه قبل از پرس و جوی: 23.129 MB سطرهای بازگشتی: 10
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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid IN (112,118,119,120,90,87,88,86,116,94,80,115,97,117)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 03:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 03:16:34')
ORDER BY a.created DESC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_state,idx_catid idx_catid 4 NULL 114 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 fixture_almone505480.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.09 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.18 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 24 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 23 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:123 22 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 21 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.66 ms پس از آخرین پرس و جو: 1.02 ms حافظه پرس و جو: 0.034 MB حافظه قبل از پرس و جوی: 23.301 MB سطرهای بازگشتی: 3
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 117
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 35 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 34 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 33 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 32 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 31 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 30 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 29 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 28 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 27 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 26 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 25 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 24 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 23 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_latest/helper.php:135 22 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 21 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 20 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 19 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:107 18 plgContentLoadModuleInArticle->load_module() JROOT/plugins/content/loadmoduleinarticle/loadmoduleinarticle.php:74 17 plgContentLoadModuleInArticle->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 5.18 ms پس از آخرین پرس و جو: 12.62 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 23.329 MB سطرهای بازگشتی: 10
SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `i4x98_contentitem_tag_map` AS `m`
INNER JOIN `i4x98_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `i4x98_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`
WHERE `t`.`access` IN (1,1)
AND `t`.`published` = 1
AND `m`.`type_alias` = `c`.`core_type_alias`
AND `c`.`core_state` = 1
AND (`c`.`core_access` IN (1,1) OR `c`.`core_access` = 0)
AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-04-26 03:16:34')
AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2024-04-26 03:16:34')
GROUP BY `tag_id`,`title`,`access`,`alias`
ORDER BY `count` DESC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref PRIMARY,tag_idx,idx_access,idx_content_type tag_idx 1 const 34 Using index condition; Using where; Using temporary; با استفاده از مرتب سازی فایل 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_core_content_id 4 fixture_almone505480.c.core_content_id 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 fixture_almone505480.m.tag_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.68 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 3.58 ms Creating sort index 0.07 ms Removing tmp table 0.15 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/modules/mod_tags_popular/helper.php:134 14 ModTagsPopularHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:596 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_tags_popular/mod_tags_popular.php:22 10 include JROOT/modules/mod_tags_popular/mod_tags_popular.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.47 ms پس از آخرین پرس و جو: 4.04 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 23.514 MB سطرهای بازگشتی: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `i4x98_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 fixture_almone505480.c.id 2 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 1.49 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/categories.php:115 15 ContentModelCategories->getItems() JROOT/modules/mod_articles_category/helper.php:142 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.07 ms پس از آخرین پرس و جو: 0.23 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 23.532 MB سطرهای بازگشتی: 4
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `i4x98_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 96
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 fixture_almone505480.c.id 2 Using index condition; Using where Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.13 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.06 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/categories.php:115 15 ContentModelCategories->getItems() JROOT/modules/mod_articles_category/helper.php:142 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.10 ms پس از آخرین پرس و جو: 0.22 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 23.556 MB سطرهای بازگشتی: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `i4x98_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 97
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 fixture_almone505480.c.id 2 Using index condition; Using where Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/categories.php:115 15 ContentModelCategories->getItems() JROOT/modules/mod_articles_category/helper.php:142 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 3.59 ms پس از آخرین پرس و جو: 0.24 ms حافظه پرس و جو: 0.064 MB حافظه قبل از پرس و جوی: 23.573 MB سطرهای بازگشتی: 10
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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid NOT IN (9,96,97)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 03:16:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 03:16:34')
ORDER BY publish_up DESC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range idx_state,idx_catid idx_catid 4 NULL 186 Using index condition; Using where; با استفاده از مرتب سازی فایل 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 fixture_almone505480.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.id 1 Using where Status Duration Starting 0.15 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 2.85 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/modules/mod_articles_category/helper.php:224 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.70 ms پس از آخرین پرس و جو: 0.86 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 23.739 MB سطرهای بازگشتی: 3
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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 142
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right کلید شاخصی برای استفاده نیست NULL NULL 106 Using where; با استفاده از مرتب سازی فایل Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() به نظر می رسد خط زیر فراخونده شده باشد. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 16 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 15 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_category/helper.php:260 14 ModArticlesCategoryHelper::getList() به نظر می رسد خط زیر فراخونده شده باشد. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:566 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2245.36 ms پس از آخرین پرس و جو: 3.77 ms حافظه پرس و جو: 62.221 MB حافظه قبل از پرس و جوی: 23.629 MB سطرهای بازگشتی: 1160389
SELECT guest, client_id
FROM i4x98_session
WHERE client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_session ref client_id_guest client_id_guest 2 const 742105 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 10.64 ms Preparing 0.05 ms Executing 0.01 ms Sending data 2212.97 ms End of update loop 0.04 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:45 11 ModWhosonlineHelper::getOnlineCount() JROOT/modules/mod_whosonline/mod_whosonline.php:19 10 include JROOT/modules/mod_whosonline/mod_whosonline.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 6.91 ms پس از آخرین پرس و جو: 1692.49 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 39.652 MB سطرهای بازگشتی: 1
SELECT SUM(hits) AS count_hits
FROM i4x98_content
WHERE state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_content ALL idx_state کلید شاخصی برای استفاده نیست NULL NULL 190 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.59 ms Preparing 0.05 ms Executing 0.01 ms Sending data 5.58 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/modules/mod_stats/helper.php:129 11 ModStatsHelper::getList() JROOT/modules/mod_stats/mod_stats.php:17 10 include JROOT/modules/mod_stats/mod_stats.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.42 ms پس از آخرین پرس و جو: 7.30 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 40.423 MB
CREATE TABLE IF NOT EXISTS i4x98_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
توضیحات در جستجو ممکن نیست: CREATE TABLE IF NOT EXISTS i4x98_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.10 ms After opening tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Commit implicit 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1404 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.51 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 40.430 MB سطرهای بازگشتی: 1
SELECT count( * ) AS records, MAX( id ) AS max
FROM i4x98_vvisitcounterid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL کلید شاخصی برای استفاده نیست NULL NULL NULL Select tables optimized away Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.08 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 14 JDatabaseDriver->loadRow() JROOT/modules/mod_vvisit_counter/helper.php:1417 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.45 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 40.438 MB
DELETE
FROM i4x98_vvisitcounter
WHERE id<='101530'توضیحات در جستجو ممکن نیست: DELETE FROM i4x98_vvisitcounter WHERE id<='101530'Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.08 ms Updating 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1560 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.21 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 40.445 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE ip=UNHEX(SHA1('3.139.240.142'))
AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter ref ip,iptm iptm 20 const 1 Using where; Using index Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.71 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1612 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 40.453 MB
INSERT INTO i4x98_vvisitcounter ( tm, ip, data )
VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.139.240.142')) , NULL )توضیحات در جستجو ممکن نیست: INSERT INTO i4x98_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.139.240.142')) , NULL )Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Update 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.05 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/modules/mod_vvisit_counter/helper.php:1651 13 modVisitCounterHelper->init() JROOT/modules/mod_vvisit_counter/helper.php:482 12 modVisitCounterHelper->__construct() JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.51 ms پس از آخرین پرس و جو: 0.09 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 40.460 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 18 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1920 13 modVisitCounterHelper->sql_today_visitors() JROOT/modules/mod_vvisit_counter/helper.php:763 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 40.468 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
AND UNIX_TIMESTAMP(DATE(NOW()))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 119 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1935 13 modVisitCounterHelper->sql_yesterday_visitors() JROOT/modules/mod_vvisit_counter/helper.php:774 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.67 ms پس از آخرین پرس و جو: 0.10 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 40.477 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN 1713731400
AND 1714336200id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 380 Using where; Using index Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.23 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1979 13 modVisitCounterHelper->sql_week_visitors() JROOT/modules/mod_vvisit_counter/helper.php:784 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.60 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 40.485 MB سطرهای بازگشتی: 1
SELECT COUNT(*)
FROM i4x98_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01"))
AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_vvisitcounter range tm tm 4 NULL 2135 Using where; Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 1.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/modules/mod_vvisit_counter/helper.php:1994 13 modVisitCounterHelper->sql_month_visitors() JROOT/modules/mod_vvisit_counter/helper.php:808 12 modVisitCounterHelper->renderPeopleTable() JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 11 require JROOT/modules/mod_vvisit_counter/tmpl/default.php JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 10 include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.42 ms پس از آخرین پرس و جو: 39.79 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 41.225 MBپرس و جوی تکراری: #65
LOCK TABLES `i4x98_extensions` WRITE
توضیحات در جستجو ممکن نیست: LOCK TABLES `i4x98_extensions` WRITEStatus Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.05 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:551 8 JDatabaseDriverMysqli->lockTable() JROOT/plugins/system/eshopnotify/eshopnotify.php 7 plgSystemEshopNotify->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.71 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 41.229 MB
UPDATE i4x98_extensions
SET params='{\"time_period\":\"30\",\"number_emails\":\"30\",\"bcc_email\":\"\",\"last_run\":1714101398}'
WHERE `element` = "eshopnotify"
AND `folder`="system"توضیحات در جستجو ممکن نیست: UPDATE i4x98_extensions SET params='{\"time_period\":\"30\",\"number_emails\":\"30\",\"bcc_email\":\"\",\"last_run\":1714101398}' WHERE `element` = "eshopnotify" AND `folder`="system"Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.01 ms After opening tables 0.02 ms init for update 0.66 ms Updating 0.61 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.16 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/eshopnotify/eshopnotify.php 7 plgSystemEshopNotify->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.21 ms پس از آخرین پرس و جو: 1.41 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 41.334 MBپرس و جوی تکراری: #67
UNLOCK TABLES
توضیحات در جستجو ممکن نیست: UNLOCK TABLESStatus Duration Starting 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:926 8 JDatabaseDriverMysqli->unlockTables() JROOT/plugins/system/eshopnotify/eshopnotify.php 7 plgSystemEshopNotify->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 9.55 ms پس از آخرین پرس و جو: 0.14 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 41.352 MB سطرهای بازگشتی: 0
SELECT a.*, b.product_name
FROM i4x98_eshop_notify AS a
INNER JOIN i4x98_eshop_productdetails AS b
ON a.product_id = b.product_id
INNER JOIN i4x98_eshop_products AS c
ON (a.product_id = c.id
AND c.product_quantity > 0)
WHERE a.sent_email = 0
AND b.language = a.language
ORDER BY a.id
LIMIT 30id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a index NULL PRIMARY 4 NULL 2 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 fixture_almone505480.a.product_id 1 Using where 1 SIMPLE b ref product_id product_id 5 fixture_almone505480.a.product_id 2 Using where Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 8.46 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.23 ms Unlocking tables 0.02 ms closing tables 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.04 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php 8 EshopHelper::sendNotify() JROOT/plugins/system/eshopnotify/eshopnotify.php 7 plgSystemEshopNotify->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.27 ms پس از آخرین پرس و جو: 0.22 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 41.373 MBپرس و جوی تکراری: #61
LOCK TABLES `i4x98_extensions` WRITE
توضیحات در جستجو ممکن نیست: LOCK TABLES `i4x98_extensions` WRITEStatus Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:551 8 JDatabaseDriverMysqli->lockTable() JROOT/plugins/system/eshopreminder/eshopreminder.php 7 plgSystemEshopReminder->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.56 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 41.383 MB
UPDATE i4x98_extensions
SET params='{\"time_period\":\"30\",\"number_products\":\"10\",\"received_emails\":\"\",\"last_run\":1714101398}'
WHERE `element` = "eshopreminder"
AND `folder`="system"توضیحات در جستجو ممکن نیست: UPDATE i4x98_extensions SET params='{\"time_period\":\"30\",\"number_products\":\"10\",\"received_emails\":\"\",\"last_run\":1714101398}' WHERE `element` = "eshopreminder" AND `folder`="system"Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.01 ms After opening tables 0.01 ms init for update 0.10 ms Updating 0.09 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.12 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/eshopreminder/eshopreminder.php 7 plgSystemEshopReminder->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 0.16 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 41.389 MBپرس و جوی تکراری: #63
UNLOCK TABLES
توضیحات در جستجو ممکن نیست: UNLOCK TABLESStatus Duration Starting 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:926 8 JDatabaseDriverMysqli->unlockTables() JROOT/plugins/system/eshopreminder/eshopreminder.php 7 plgSystemEshopReminder->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.70 ms پس از آخرین پرس و جو: 0.15 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 41.406 MB سطرهای بازگشتی: 0
SELECT a.id, a.product_quantity, b.product_name
FROM i4x98_eshop_products AS a
INNER JOIN i4x98_eshop_productdetails AS b
ON (a.id = b.product_id)
WHERE b.language = "fa-IR"
AND ((a.product_inventory_global = 1
AND 0 > 0
AND a.product_quantity <= 0) OR (a.product_inventory_global = 0
AND a.product_threshold > 0
AND a.product_quantity <= a.product_threshold))
AND (a.product_threshold_notify IS NULL OR a.product_threshold_notify != 1)
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ALL PRIMARY کلید شاخصی برای استفاده نیست NULL NULL 54 Using where 1 SIMPLE b ref product_id product_id 5 fixture_almone505480.a.id 2 Using where Status Duration Starting 0.08 ms checking permissions 0.04 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.06 ms Statistics 0.04 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/components/com_eshop/helpers/helper.php 8 EshopHelper::sendReminder() JROOT/plugins/system/eshopreminder/eshopreminder.php 7 plgSystemEshopReminder->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.23 ms پس از آخرین پرس و جو: 6.38 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 42.070 MB سطرهای بازگشتی: 139
SELECT *
FROM i4x98_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_acymailing_config ALL NULL کلید شاخصی برای استفاده نیست NULL NULL 139 Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.64 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:481 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:822 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.27 ms پس از آخرین پرس و جو: 5.31 ms حافظه پرس و جو: 0.020 MB حافظه قبل از پرس و جوی: 42.400 MB سطرهای بازگشتی: 1
SELECT template
FROM i4x98_template_styles
WHERE home = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i4x98_template_styles ALL idx_client_id,idx_client_id_home کلید شاخصی برای استفاده نیست NULL NULL 6 Using where Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.05 ms Statistics 0.51 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.24 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/yt.php:281 8 plgSystemYt->nameOfSJTemplate() JROOT/plugins/system/yt/yt.php:162 7 plgSystemYt->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
48 نوع پرس و جو ثبت شده
انتخاب جداول:
6 × 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 `i4x98_categories` AS `s`
INNER JOIN `i4x98_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)5 × SELECT COUNT(*)
FROM i4x98_vvisitcounter4 × SELECT home
FROM i4x98_menu4 × 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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `i4x98_content` AS `i`2 × SELECT *
FROM i4x98_modules2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `i4x98_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `i4x98_assets`1 × SELECT `data`
FROM `i4x98_session`1 × SELECT id
FROM i4x98_template_styles1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM i4x98_modules AS m
LEFT JOIN i4x98_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN i4x98_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT guest, client_id
FROM i4x98_session1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `i4x98_contentitem_tag_map` AS `m`
INNER JOIN `i4x98_tags` AS `t`
ON `tag_id` = t.id
INNER JOIN `i4x98_ucm_content` AS `c`
ON `m`.`core_content_id` = `c`.`core_content_id`1 × SELECT SUM(hits) AS count_hits
FROM i4x98_content1 × SELECT count( * ) AS records, MAX( id ) AS max
FROM i4x98_vvisitcounte1 × SELECT a.*, b.product_name
FROM i4x98_eshop_notify AS a
INNER JOIN i4x98_eshop_productdetails AS b
ON a.product_id = b.product_id
INNER JOIN i4x98_eshop_products AS c
ON (a.product_id = c.id
AND c.product_quantity > 0)1 × SELECT a.id, a.product_quantity, b.product_name
FROM i4x98_eshop_products AS a
INNER JOIN i4x98_eshop_productdetails AS b
ON (a.id = b.product_id)1 × SELECT *
FROM i4x98_acymailing_confi1 × SELECT template_style_id
FROM i4x98_menu1 × 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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
INNER JOIN ( SELECT DISTINCT content_item_id
FROM `i4x98_contentitem_tag_map`1 × SELECT `m`.`tag_id`,`t`.*
FROM `i4x98_contentitem_tag_map` AS m
INNER JOIN `i4x98_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `FormId`,`DeleteSubmissionsAfter`
FROM `i4x98_rsform_forms`1 × SELECT id, rules
FROM `i4x98_viewlevels1 × SELECT b.id
FROM i4x98_usergroups AS a
LEFT JOIN i4x98_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM i4x98_extensions1 × SELECT config_key, config_value
FROM i4x98_eshop_config1 × SELECT *
FROM i4x98_eshop_currencies1 × SELECT *
FROM i4x98_rsform_confi1 × 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 i4x98_menu AS m
LEFT JOIN i4x98_extensions AS e
ON m.component_id = e.extension_id1 × SELECT COUNT(*)
FROM i4x98_content AS a
LEFT JOIN i4x98_categories AS c
ON c.id = a.catid
LEFT JOIN i4x98_users AS ua
ON ua.id = a.created_by
LEFT JOIN i4x98_users AS uam
ON uam.id = a.modified_by
LEFT JOIN i4x98_categories as parent
ON parent.id = c.parent_id
LEFT JOIN i4x98_content_rating AS v
ON a.id = v.content_id
INNER JOIN ( SELECT DISTINCT content_item_id
FROM `i4x98_contentitem_tag_map`1 × SELECT id, home, template, s.params
FROM i4x98_template_styles as s
LEFT JOIN i4x98_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `name`,`value`
FROM `i4x98_joombank_setting1 × SELECT `id`,`status`,`total_amount`,`discount_amount`,`discount_code`
FROM `i4x98_joombank_transactions`1 × SELECT `id`,`code`,`status`,`total_amount`,`wallet_amount`,`user_id`
FROM `i4x98_joombank_transactions`1 × SELECT *
FROM i4x98_languages1 × SELECT `session_id`
FROM `i4x98_session`1 × SELECT template
FROM i4x98_template_styles
سایر جداول:
2 × LOCK TABLES `i4x98_extensions` WRIT
2 × UNLOCK TABLE
1 × INSERT INTO `i4x98_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6437653935323434396163326639356133656430393238616566313662666236', 1, 1714101394, 0, '', 01 × UPDATE i4x98_eshop_currencies
SET exchanged_value = 1.00000 , modified_date = '2024-04-26 06:46:34'1 × UPDATE i4x98_rsform_config
SET `SettingValue`='1714101394'1 × UPDATE `i4x98_extensions`
SET `params` = '{\"mediaversion\":\"fe93a77ce5f470bce020d1e59ee958a6\"}'1 × CREATE TABLE IF NOT EXISTS i4x98_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=
1 × DELETE
FROM i4x98_vvisitcounter1 × INSERT INTO i4x98_vvisitcounter ( tm, ip, data )
VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.139.240.142')) , NULL1 × UPDATE i4x98_extensions
SET params='{\"time_period\":\"30\",\"number_emails\":\"30\",\"bcc_email\":\"\",\"last_run\":1714101398}'1 × UPDATE i4x98_extensions
SET params='{\"time_period\":\"30\",\"number_products\":\"10\",\"received_emails\":\"\",\"last_run\":1714101398}'
تلفن :09123345784