آژانس ها
Better Health
Real Property
آژانس گردشگری روژانو
تهران، خیابان مطهری، نبش خیابان میرزا شیرازی، جنب بانک آینده، پلاک ۲۰۵، واحد ۲، آژانس مسافرتی روژانو, تهران, تهران
۰۲۱۸۸۳۰۵۹۳۰
آژانس گردشگری روژانو
الماس نشان
رستوران لیونا
Better Health
http://www.mapgard.com/better-health
Quisque cursus nunc ut diam pulvinar luctus. Nulla facilisi. Donec porta lorem id diam malesuada nec pretium enim euismod. Donec massa augue, lobortis eu cursus in, tincidunt ut nunc. » اطلاعات بیشتر
Real Property
http://www.mapgard.com/real-property
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc interdum mauris vitae urna ultrices, et fermentum magna convallis. Nullam quis vulputate magna. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. » اطلاعات بیشتر
آژانس گردشگری روژانو
http://www.mapgard.com/%D8%B1%D9%88%DA%98%D8%A7%D9%86%D9%88
آدرس: تهران، خیابان مطهری، نبش خیابان میرزا شیرازی، جنب بانک آینده، پلاک ۲۰۵، واحد ۲، آژانس مسافرتی روژانو, تهران, تهران
نقشه جهات
تلفن: ۰۲۱۸۸۳۰۵۹۳۰
فکس: ۰۲۱۸۸۳۱۳۳۰۷
الماس نشان
http://www.mapgard.com/%D8%A7%D9%84%D9%85%D8%A7%D8%B3-%D9%86%D8%B4%D8%A7%D9%86
شرکت خدمات مسافرت هوایی و جهانگردی الماس نشان به عنوان آژانس هواپیمایی معتبر با مجوز بند الف از سازمان هواپیمایی و مجوز بند ب از سازمان گردشگری و جهانگردی و عضو سازمان حمل و نقل هوایی یاتا در تاریخ ۱۳۸۹ در تهران تاسیس گردید.با عنایت بر تلاش و کوشش فر » اطلاعات بیشتر
رستوران لیونا
http://www.mapgard.com/%D8%B1%D8%B3%D8%AA%D9%88%D8%B1%D8%A7%D9%86-%D9%84%DB%8C%D9%88%D9%86%D8%A7
غذای ایرانی و فرنگی » اطلاعات بیشتر
اشکال یابی جوملا
{ "__default": { "session": { "counter": 1, "timer": { "start": 1757993813, "last": 1757993813, "now": 1757993813 }, "client": { "forwarded": "10.2.148.83" }, "token": "4OWVRY63QXbKUFsfTVnMB5inSjHUf1Xa" }, "registry": { "com_jbusinessdirectory": { "catalog": { "ordercol": null } } }, "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 }, "plg_system_languagefilter": { "language": "fa-IR" }, "cronjob_user": true, "lSearchType": 2, "listing-search": true, "menuItemId": "1956" } }
زمان
حافظه
زمان: 22.95 ms / 22.95 ms حافظه: 1.669 MB / 2.06 MB Application: afterLoad
زمان: 208.51 ms / 231.46 ms حافظه: 13.241 MB / 15.30 MB Application: afterInitialise
زمان: 73.57 ms / 305.03 ms حافظه: 3.216 MB / 18.51 MB Application: afterRoute
زمان: 1.51 ms / 306.54 ms حافظه: 0.030 MB / 18.54 MB Application: beforeRenderComponent com_jbusinessdirectory
زمان: 108.75 ms / 415.30 ms حافظه: 2.646 MB / 21.19 MB Application: afterRenderComponent com_jbusinessdirectory
زمان: 4.74 ms / 420.04 ms حافظه: 0.214 MB / 21.40 MB Application: Before Access::preloadComponents (all components)
زمان: 1.81 ms / 421.85 ms حافظه: 0.086 MB / 21.49 MB Application: After Access::preloadComponents (all components)
زمان: 0.04 ms / 421.89 ms حافظه: 0.000 MB / 21.48 MB Application: Before Access::getAssetRules (id:1 name:root.1)
زمان: 0.90 ms / 422.78 ms حافظه: 0.026 MB / 21.51 MB Application: After Access::getAssetRules (id:1 name:root.1)
زمان: 24.45 ms / 447.23 ms حافظه: 0.439 MB / 21.95 MB Application: afterDispatch
زمان: 16.14 ms / 463.37 ms حافظه: 2.309 MB / 24.26 MB Application: beforeRenderModule mod_menu (دیدنی های ایران بر اساس استان)
زمان: 8.52 ms / 471.90 ms حافظه: 0.203 MB / 24.46 MB Application: afterRenderModule mod_menu (دیدنی های ایران بر اساس استان)
زمان: 0.05 ms / 471.94 ms حافظه: 0.000 MB / 24.36 MB Application: beforeRenderModule mod_menu (دیدنی های ایران بر اساس مکان)
زمان: 3.62 ms / 475.56 ms حافظه: 0.064 MB / 24.42 MB Application: afterRenderModule mod_menu (دیدنی های ایران بر اساس مکان)
زمان: 0.05 ms / 475.61 ms حافظه: 0.000 MB / 24.36 MB Application: beforeRenderModule mod_menu (فرهنگ و آداب و رسوم ایران)
زمان: 2.44 ms / 478.04 ms حافظه: 0.034 MB / 24.39 MB Application: afterRenderModule mod_menu (فرهنگ و آداب و رسوم ایران)
زمان: 0.03 ms / 478.08 ms حافظه: 0.000 MB / 24.36 MB Application: beforeRenderModule mod_menu (برترین های ایران)
زمان: 3.03 ms / 481.10 ms حافظه: 0.050 MB / 24.41 MB Application: afterRenderModule mod_menu (برترین های ایران)
زمان: 1.95 ms / 483.05 ms حافظه: 0.000 MB / 24.38 MB Application: beforeRenderModule mod_menu (دیدنی های جهان بر اساس قاره)
زمان: 3.05 ms / 486.10 ms حافظه: 0.048 MB / 24.43 MB Application: afterRenderModule mod_menu (دیدنی های جهان بر اساس قاره)
زمان: 0.04 ms / 486.14 ms حافظه: 0.000 MB / 24.38 MB Application: beforeRenderModule mod_menu (دیدنی های جهان بر اساس مکان)
زمان: 3.88 ms / 490.02 ms حافظه: 0.071 MB / 24.46 MB Application: afterRenderModule mod_menu (دیدنی های جهان بر اساس مکان)
زمان: 0.04 ms / 490.06 ms حافظه: 0.000 MB / 24.39 MB Application: beforeRenderModule mod_menu (فرهنگ و آداب و رسوم جهان)
زمان: 2.81 ms / 492.87 ms حافظه: 0.041 MB / 24.43 MB Application: afterRenderModule mod_menu (فرهنگ و آداب و رسوم جهان)
زمان: 0.04 ms / 492.91 ms حافظه: 0.000 MB / 24.41 MB Application: beforeRenderModule mod_menu (برترین های جهان)
زمان: 3.33 ms / 496.25 ms حافظه: 0.056 MB / 24.46 MB Application: afterRenderModule mod_menu (برترین های جهان)
زمان: 2.45 ms / 498.69 ms حافظه: 0.000 MB / 24.42 MB Application: beforeRenderModule mod_menu (راهنمای سفر)
زمان: 1.94 ms / 500.63 ms حافظه: 0.019 MB / 24.44 MB Application: afterRenderModule mod_menu (راهنمای سفر)
زمان: 0.03 ms / 500.66 ms حافظه: 0.000 MB / 24.43 MB Application: beforeRenderModule mod_menu (راهنمای اخذ ویزا)
زمان: 2.21 ms / 502.87 ms حافظه: 0.027 MB / 24.45 MB Application: afterRenderModule mod_menu (راهنمای اخذ ویزا)
زمان: 0.04 ms / 502.91 ms حافظه: 0.000 MB / 24.43 MB Application: beforeRenderModule mod_menu (برنامه سفر و پیشنهاد سفر)
زمان: 2.75 ms / 505.65 ms حافظه: 0.040 MB / 24.47 MB Application: afterRenderModule mod_menu (برنامه سفر و پیشنهاد سفر)
زمان: 0.04 ms / 505.69 ms حافظه: 0.000 MB / 24.43 MB Application: beforeRenderModule mod_menu (بهترین زمان سفر و هزینه ها)
زمان: 2.73 ms / 508.42 ms حافظه: 0.043 MB / 24.47 MB Application: afterRenderModule mod_menu (بهترین زمان سفر و هزینه ها)
زمان: 1.63 ms / 510.05 ms حافظه: 0.000 MB / 24.45 MB Application: beforeRenderModule mod_menu (حساب های ارزی)
زمان: 2.95 ms / 512.99 ms حافظه: 0.039 MB / 24.49 MB Application: afterRenderModule mod_menu (حساب های ارزی)
زمان: 0.04 ms / 513.03 ms حافظه: 0.000 MB / 24.46 MB Application: beforeRenderModule mod_menu (راهنمای حساب ها و پرداخت های ارزی)
زمان: 2.18 ms / 515.21 ms حافظه: 0.026 MB / 24.48 MB Application: afterRenderModule mod_menu (راهنمای حساب ها و پرداخت های ارزی)
زمان: 0.04 ms / 515.25 ms حافظه: 0.000 MB / 24.46 MB Application: beforeRenderModule mod_menu (پرداخت های ارزی)
زمان: 0.97 ms / 516.22 ms حافظه: 0.004 MB / 24.46 MB Application: afterRenderModule mod_menu (پرداخت های ارزی)
زمان: 0.03 ms / 516.25 ms حافظه: 0.000 MB / 24.46 MB Application: beforeRenderModule mod_menu (ثبت نام آزمون های بین المللی و وقت سفارت)
زمان: 0.95 ms / 517.19 ms حافظه: 0.004 MB / 24.46 MB Application: afterRenderModule mod_menu (ثبت نام آزمون های بین المللی و وقت سفارت)
زمان: 1.37 ms / 518.56 ms حافظه: 0.012 MB / 24.48 MB Application: beforeRenderModule mod_menu (نکات و دانستنی های سفر)
زمان: 2.26 ms / 520.82 ms حافظه: 0.026 MB / 24.50 MB Application: afterRenderModule mod_menu (نکات و دانستنی های سفر)
زمان: 0.05 ms / 520.87 ms حافظه: 0.000 MB / 24.48 MB Application: beforeRenderModule mod_menu (راهنمای خرید)
زمان: 2.28 ms / 523.16 ms حافظه: 0.019 MB / 24.50 MB Application: afterRenderModule mod_menu (راهنمای خرید)
زمان: 0.04 ms / 523.19 ms حافظه: 0.000 MB / 24.48 MB Application: beforeRenderModule mod_menu (مجله گردشگری)
زمان: 2.15 ms / 525.35 ms حافظه: 0.026 MB / 24.51 MB Application: afterRenderModule mod_menu (مجله گردشگری)
زمان: 123.70 ms / 649.04 ms حافظه: 0.000 MB / 24.03 MB Application: beforeRenderModule mod_menu (برچسب های مفید)
زمان: 5.06 ms / 654.10 ms حافظه: 0.022 MB / 24.05 MB Application: afterRenderModule mod_menu (برچسب های مفید)
زمان: 2.35 ms / 656.45 ms حافظه: 0.007 MB / 24.06 MB Application: beforeRenderModule mod_menu (منو پایین سایت فارسی)
زمان: 5.69 ms / 662.14 ms حافظه: 0.037 MB / 24.10 MB Application: afterRenderModule mod_menu (منو پایین سایت فارسی)
زمان: 3.10 ms / 665.24 ms حافظه: 0.001 MB / 24.10 MB Application: beforeRenderModule mod_breadcrumbs (مسیر سایت)
زمان: 1.99 ms / 667.23 ms حافظه: 0.086 MB / 24.18 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)
زمان: 1.59 ms / 668.82 ms حافظه: 0.002 MB / 24.19 MB Application: beforeRenderModule mod_jbusinessdirectory (JBusinessDirectory Search)
زمان: 32.45 ms / 701.27 ms حافظه: 0.316 MB / 24.50 MB Application: afterRenderModule mod_jbusinessdirectory (JBusinessDirectory Search)
زمان: 47.11 ms / 748.37 ms حافظه: 1.687 MB / 26.19 MB Application: afterRender
جمع پرس و جوی بانک اطلاعاتی: 84.36 ms
27.19 MB (28,515,776 بایت)
81 پرس و جو ثبت شده 84.36 ms
29 تکراری پیدا شد!
- زمان پرس و جو: 0.56 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 3.867 MB سطرهای بازگشتی: 0
SELECT `data`
FROM `mqi13_session`
WHERE `session_id` = 'af459c4bac6fcb9339c7acf0d721c716'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = 'af459c4bac6fcb9339c7acf' at line 1 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.22 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.26 ms پس از آخرین پرس و جو: 1.95 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.026 MB سطرهای بازگشتی: 0
SELECT `session_id`
FROM `mqi13_session`
WHERE `session_id` = 'af459c4bac6fcb9339c7acf0d721c716'
LIMIT 1Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = 'af459c4bac6fcb933' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.24 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 4.031 MB
INSERT INTO `mqi13_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('af459c4bac6fcb9339c7acf0d721c716', 1, 1757993813, 0, '', 0)توضیحات در جستجو ممکن نیست: INSERT INTO `mqi13_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('af459c4bac6fcb9339c7acf0d721c716', 1, 1757993813, 0, '', 0)Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms update 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 10.15 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.601 MB سطرهای بازگشتی: 5
SELECT id, rules
FROM `mqi13_viewlevels`Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 4.613 MB سطرهای بازگشتی: 1
SELECT b.id
FROM mqi13_usergroups AS a
LEFT JOIN mqi13_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft ' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.16 ms پس از آخرین پرس و جو: 50.01 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 9.523 MB سطرهای بازگشتی: 2
SHOW FULL COLUMNS
FROM `mqi13_gsd_config`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `mqi13_gsd_config`Status Duration starting 0.13 ms Executing hook on transaction 0.01 ms starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.90 ms init 0.03 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.06 ms Creating tmp table 0.09 ms executing 0.20 ms checking permissions 0.12 ms checking permissions 0.07 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 11 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_gsd/tables/config.php:26 10 GSDTableConfig->__construct() JROOT/libraries/src/Table/Table.php:312 9 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_gsd/GSD/Helper.php:383 8 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:61 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.50 ms پس از آخرین پرس و جو: 1.72 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 9.552 MB سطرهای بازگشتی: 1
SELECT *
FROM mqi13_gsd_config
WHERE `name` = 'config'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__gsd_config WHERE `name` = 'config'' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_gsd/GSD/Helper.php:384 8 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:61 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.75 ms پس از آخرین پرس و جو: 82.24 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 13.925 MB سطرهای بازگشتی: 34
SELECT *
FROM mqi13_rsform_configError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__rsform_config' at line 1 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:97 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28 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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.64 ms پس از آخرین پرس و جو: 0.71 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 13.977 MB سطرهای بازگشتی: 1
SELECT `params`
FROM `mqi13_extensions`
WHERE `element` = 'web357framework'
AND `folder` = 'system'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `params` FROM `#__extensions` WHERE `element` = 'web357framework' AND ' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 12 JDatabaseDriver->loadObject() JROOT/plugins/system/web357framework/web357framework.class.php:356 11 Web357FrameworkHelperClass::getAPIKey() JROOT/plugins/system/web357framework/web357framework.class.php:46 10 Web357FrameworkHelperClass->__construct() JROOT/plugins/system/fix404errorlinks/fix404errorlinks.php:25 9 plgSystemFix404ErrorLinks::W357FrameworkHelperClass() JROOT/plugins/system/fix404errorlinks/fix404errorlinks.php:66 8 plgSystemFix404ErrorLinks->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.24 ms پس از آخرین پرس و جو: 0.13 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 13.983 MB سطرهای بازگشتی: 282
SELECT `redirects`.`old_urls_arr` AS `old_urls_arr`,`redirects`.`destination_url` AS `destination_url`,`redirects`.`http_response_status_code` AS `http_response_status_code`
FROM `mqi13_fix404_redirects` AS `redirects`
WHERE `redirects`.`state` = 1
ORDER BY `redirects`.`ordering` ASCError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `redirects`.`old_urls_arr` AS `old_urls_arr`,`redirects`.`destination_url' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.03 ms executing 1.78 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/fix404errorlinks/fix404errorlinks.php:47 9 plgSystemFix404ErrorLinks::getRedirectsDBObjectList() JROOT/plugins/system/fix404errorlinks/fix404errorlinks.php:81 8 plgSystemFix404ErrorLinks->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.87 ms پس از آخرین پرس و جو: 52.45 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 16.695 MB سطرهای بازگشتی: 1
SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `mqi13_obrss`
WHERE `published` = 1
AND `feeded` = 1
ORDER BY `ordering`Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type` FROM `#__ob' at line 1 Status Duration starting 0.19 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.02 ms Opening tables 0.33 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/obrss/obrss.php:40 8 plgSystemobrss->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.06 ms پس از آخرین پرس و جو: 2.47 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 16.841 MB
UPDATE `mqi13_extensions`
SET `params` = '{\"mediaversion\":\"5b3fa5ff07f34d0ed588cba93ab0e531\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"5b3fa5ff07f34d0ed5' at line 1 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.17 ms updating 0.16 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.40 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/obrss/obrss.php:78 8 plgSystemobrss->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.39 ms پس از آخرین پرس و جو: 18.63 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 17.765 MB سطرهای بازگشتی: 7
SHOW FULL COLUMNS
FROM `mqi13_session`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `mqi13_session`Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.91 ms init 0.02 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.05 ms Creating tmp table 0.08 ms executing 0.16 ms checking permissions 0.11 ms checking permissions 0.07 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jrealtimeanalytics/tables/session.php:163 14 JRealtimeTableSession->__construct() JROOT/libraries/src/Table/Table.php:312 13 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:135 12 JRealtimeHelpersUsers::getSessionTable() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48 11 plgSystemJRealtimeAnalytics->notifyObservers() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 10 plgSystemJRealtimeAnalytics->injectApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:544 9 plgSystemJRealtimeAnalytics->startApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:571 8 plgSystemJRealtimeAnalytics->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.36 ms پس از آخرین پرس و جو: 0.15 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 17.786 MB سطرهای بازگشتی: 1
SELECT *
FROM mqi13_session
WHERE `session_id` = 'af459c4bac6fcb9339c7acf0d721c716'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__session WHERE `session_id` = 'af459c4bac6fcb9339c7acf0d721c7' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 13 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:136 12 JRealtimeHelpersUsers::getSessionTable() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48 11 plgSystemJRealtimeAnalytics->notifyObservers() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 10 plgSystemJRealtimeAnalytics->injectApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:544 9 plgSystemJRealtimeAnalytics->startApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:571 8 plgSystemJRealtimeAnalytics->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.55 ms پس از آخرین پرس و جو: 3.42 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 17.944 MB سطرهای بازگشتی: 0
SELECT *
FROM `mqi13_realtimeanalytics_eventstats`
WHERE `type` = 'viewurl'
AND `published` = 1Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__realtimeanalytics_eventstats` WHERE `type` = 'viewurl' AN' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.21 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388 15 JRealtimeModelEventstatsObsrv::loadEventsFromDB() JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:181 14 JRealtimeModelEventstatsObsrv->trackEventVisitPage() JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:413 13 JRealtimeModelEventstatsObsrv->update() JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97 12 JRealtimeModelObservable->notify() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78 11 plgSystemJRealtimeAnalytics->notifyObservers() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 10 plgSystemJRealtimeAnalytics->injectApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:544 9 plgSystemJRealtimeAnalytics->startApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:571 8 plgSystemJRealtimeAnalytics->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.34 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 17.952 MB سطرهای بازگشتی: 0
SELECT *
FROM `mqi13_realtimeanalytics_eventstats`
WHERE `type` = 'minpages'
AND `published` = 1Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__realtimeanalytics_eventstats` WHERE `type` = 'minpages' A' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388 15 JRealtimeModelEventstatsObsrv::loadEventsFromDB() JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:231 14 JRealtimeModelEventstatsObsrv->trackEventMinPageVisited() JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:416 13 JRealtimeModelEventstatsObsrv->update() JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97 12 JRealtimeModelObservable->notify() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78 11 plgSystemJRealtimeAnalytics->notifyObservers() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152 10 plgSystemJRealtimeAnalytics->injectApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:544 9 plgSystemJRealtimeAnalytics->startApp() JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:571 8 plgSystemJRealtimeAnalytics->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.34 ms پس از آخرین پرس و جو: 0.34 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 17.961 MB سطرهای بازگشتی: 1پرس و جوی تکراری: #18
SELECT fas.*, df.*, c.currency_name, c.currency_id
FROM mqi13_jbusinessdirectory_applicationsettings fas
inner join mqi13_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join mqi13_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_idError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT fas.*, df.*, c.currency_name, c.currency_id FROM #__jbusinessdirectory' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.69 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 11 JDatabase->query() JROOT/components/com_jbusinessdirectory/assets/utils.php:68 10 JBusinessUtil::getAppSettings() JROOT/components/com_jbusinessdirectory/assets/utils.php:55 9 JBusinessUtil::getApplicationSettings() JROOT/plugins/system/urltranslator/urltranslator.php:38 8 plgSystemUrlTranslator->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.70 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 17.968 MB سطرهای بازگشتی: 1پرس و جوی تکراری: #17
SELECT fas.*, df.*, c.currency_name, c.currency_id
FROM mqi13_jbusinessdirectory_applicationsettings fas
inner join mqi13_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join mqi13_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_idError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT fas.*, df.*, c.currency_name, c.currency_id FROM #__jbusinessdirectory' at line 1 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 11 JDatabaseDriver->loadObject() JROOT/components/com_jbusinessdirectory/assets/utils.php:73 10 JBusinessUtil::getAppSettings() JROOT/components/com_jbusinessdirectory/assets/utils.php:55 9 JBusinessUtil::getApplicationSettings() JROOT/plugins/system/urltranslator/urltranslator.php:38 8 plgSystemUrlTranslator->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.58 ms پس از آخرین پرس و جو: 0.17 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 17.999 MB سطرهای بازگشتی: 0
SELECT *
FROM mqi13_jbusinessdirectory_categories c
where c.type=1
and c.alias = 'آژانس.html'
LIMIT 0, 1Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jbusinessdirectory_categories c where c.type=1 and c.alias =' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 10 JDatabaseDriver->loadObject() JROOT/plugins/system/urltranslator/urltranslator.php:166 9 plgSystemUrlTranslator->getCategoryParms() JROOT/plugins/system/urltranslator/urltranslator.php:84 8 plgSystemUrlTranslator->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.65 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 18.004 MB سطرهای بازگشتی: 0
SELECT *
FROM `mqi13_jbusinessdirectory_companies` c
where c.alias = 'آژانس.html'
LIMIT 0, 1Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__jbusinessdirectory_companies` c where c.alias = 'آژانس' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.26 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 10 JDatabaseDriver->loadObject() JROOT/plugins/system/urltranslator/urltranslator.php:124 9 plgSystemUrlTranslator->getBusinessListingParms() JROOT/plugins/system/urltranslator/urltranslator.php:86 8 plgSystemUrlTranslator->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:1119 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 5.09 ms پس از آخرین پرس و جو: 58.27 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 20.262 MB سطرهای بازگشتی: 66
SHOW FULL COLUMNS
FROM `mqi13_jbusinessdirectory_companies`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `mqi13_jbusinessdirectory_companies`Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.86 ms init 0.02 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.04 ms Creating tmp table 0.07 ms executing 0.21 ms checking permissions 0.10 ms checking permissions 0.06 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.10 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.05 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.05 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.05 ms checking permissions 0.07 ms checking permissions 0.06 ms checking permissions 0.04 ms checking permissions 0.06 ms checking permissions 0.18 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.03 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:27 15 JTableCompany->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jbusinessdirectory/models/catalog.php:66 13 JBusinessDirectoryModelCatalog->getTable() JROOT/components/com_jbusinessdirectory/models/catalog.php:90 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 4.44 ms پس از آخرین پرس و جو: 0.27 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.376 MB سطرهای بازگشتی: 5
select slec.*, mainCategory, mainCategoryId, companyName, companyId1, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from ( select cp.id, cp.name, cp.alias, cp.short_description, cp.street_number, cp.address, cp.countryId, cp.city, cp.county, cp.province, cp.area, cp.typeId, cp.website, cp.phone, cp.email, cp.state, cp.fax, cp.averageRating, cp.slogan, cp.logoLocation, cp. review_score, cp.ad_image, cp.featured,cp.publish_only_city, cp.publish_start_date, cp.publish_end_date, cp.name as companyName,cp.id as companyId1, cp.latitude, cp.longitude, cp.postalCode, cn.country_name as countryName,ct.name as typeName, count(distinct cr.id) as nr_reviews, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color
ORDER BY cg.name separator '#|') as categories, GROUP_CONCAT(DISTINCT pf.feature) as features, bc.name as mainCategory, bc.alias as mainCategoryAlias, bc.markerLocation as categoryMaker, bc.id as mainCategoryId
from mqi13_jbusinessdirectory_companies cp
left join mqi13_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join mqi13_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join mqi13_jbusinessdirectory_categories bc
on bc.id=cp.mainSubcategory
and bc.published=1
left join mqi13_jbusinessdirectory_company_reviews cr
on cr.itemId = cp.id
and cr.review_type = 1
and cr.approved=2
left join mqi13_jbusinessdirectory_countries cn
on cp.countryId=cn.id
left join mqi13_jbusinessdirectory_company_types ct
on cp.typeId=ct.id
left join mqi13_jbusinessdirectory_orders inv
on inv.company_id=cp.id
left join mqi13_jbusinessdirectory_packages p
on (inv.package_id=p.id
and p.status=1
and 0) or (p.price=0
and p.status=1
and 0)
left join mqi13_jbusinessdirectory_package_fields pf
on p.id=pf.package_id
where (cp.name like '%' or cp.name like '%' )
and cp.state=1
and (cp.approved = 2 or cp.approved= -1)
and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null)
and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
order by cp.name ) as slec
group by companyId1
order by companyName
LIMIT 0, 20Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select slec.*, mainCategory, mainCategoryId, companyName, companyId1, features, ' at line 1 Status Duration starting 0.28 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.18 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms optimizing 0.05 ms statistics 0.21 ms preparing 0.06 ms Creating tmp table 0.17 ms statistics 0.02 ms preparing 0.02 ms Creating tmp table 0.12 ms executing 0.91 ms end 0.02 ms query end 0.03 ms closing tables 0.05 ms freeing items 0.06 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:215 13 JTableCompany->getCompaniesByLetter() JROOT/components/com_jbusinessdirectory/models/catalog.php:93 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.56 ms پس از آخرین پرس و جو: 0.65 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 20.416 MB سطرهای بازگشتی: 3
SHOW FULL COLUMNS
FROM `mqi13_jbusinessdirectory_default_attributes`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `mqi13_jbusinessdirectory_default_attributes`Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.56 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.17 ms checking permissions 0.10 ms checking permissions 0.05 ms checking permissions 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:21 15 TableDefaultAttributes->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jbusinessdirectory/assets/utils.php:2895 13 JBusinessUtil::getAttributeConfiguration() JROOT/components/com_jbusinessdirectory/models/catalog.php:94 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.65 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.430 MB سطرهای بازگشتی: 40
SELECT *
FROM mqi13_jbusinessdirectory_default_attributesError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jbusinessdirectory_default_attributes' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:32 14 TableDefaultAttributes->getAttributesConfiguration() JROOT/components/com_jbusinessdirectory/assets/utils.php:2896 13 JBusinessUtil::getAttributeConfiguration() JROOT/components/com_jbusinessdirectory/models/catalog.php:94 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.72 ms پس از آخرین پرس و جو: 0.95 ms حافظه پرس و جو: 0.009 MB حافظه قبل از پرس و جوی: 20.452 MB سطرهای بازگشتی: 5
SHOW FULL COLUMNS
FROM `mqi13_jbusinessdirectory_company_attributes`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `mqi13_jbusinessdirectory_company_attributes`Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 1.05 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.65 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.04 ms Creating tmp table 0.06 ms executing 0.11 ms checking permissions 0.09 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:21 15 JTableCompanyAttributes->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jbusinessdirectory/models/catalog.php:66 13 JBusinessDirectoryModelCatalog->getTable() JROOT/components/com_jbusinessdirectory/models/catalog.php:97 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.12 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.469 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.04 ms Opening tables 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 4.29 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.478 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #67
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=12
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 3.57 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Creating tmp table 0.07 ms executing 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.16 ms freeing items 0.03 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.11 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.484 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.03 ms Opening tables 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.60 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.492 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #69
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=30
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.07 ms executing 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.12 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.498 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.04 ms Opening tables 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.57 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.507 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #75
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=35
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.06 ms executing 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.11 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.513 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.03 ms Opening tables 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.51 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 20.528 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #73
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=33
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.05 ms executing 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.11 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.536 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.04 ms Opening tables 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.56 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.544 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #71
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=31
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.06 ms executing 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 13 JTableCompanyAttributes->getCompanyAttributes() JROOT/components/com_jbusinessdirectory/models/catalog.php:98 12 JBusinessDirectoryModelCatalog->getCompaniesByLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:47 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 6.28 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.543 MB سطرهای بازگشتی: 8
SELECT DISTINCT UPPER(
LEFT(name, 1)) as letter
FROM mqi13_jbusinessdirectory_companies
ORDER BY letterError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT UPPER(LEFT(name, 1)) as letter FROM #__jbusinessdirectory_com' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 5.93 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1029 13 JTableCompany->getUsedLetters() JROOT/components/com_jbusinessdirectory/models/catalog.php:80 12 JBusinessDirectoryModelCatalog->getUsedLetter() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:48 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.57 ms پس از آخرین پرس و جو: 0.12 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 20.546 MB سطرهای بازگشتی: 9
SELECT a.id AS value, a.name AS text, a.level, a.published
FROM mqi13_jbusinessdirectory_categories AS a
LEFT JOIN `mqi13_jbusinessdirectory_categories` AS b
ON a.lft > b.lft
AND a.rgt < b.rgt
WHERE a.published = 1
AND (a.type IN (0,1))
AND a.id >1
GROUP BY a.id, a.name, a.level, a.lft, a.rgt, a.parent_id, a.published
ORDER BY a.lft ASCError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id AS value, a.name AS text, a.level, a.published FROM #__jbusinessd' at line 1 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Creating tmp table 0.17 ms executing 0.94 ms end 0.02 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/components/com_jbusinessdirectory/assets/utils.php:1727 11 JBusinessUtil::getCategoriesOptions() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:50 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.66 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.559 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #39
SELECT t.*
from mqi13_jbusinessdirectory_categories c
inner join mqi13_jbusinessdirectory_language_translations t
on c.id=t.object_id
where t.type=3
and language_tag='fa-IR'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT t.* from #__jbusinessdirectory_categories c inner join m' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.34 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 14 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:47 13 JBusinessDirectoryTranslations::getCategoriesTranslationsObjects() JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:29 12 JBusinessDirectoryTranslations::getCategoriesTranslations() JROOT/components/com_jbusinessdirectory/assets/utils.php:1728 11 JBusinessUtil::getCategoriesOptions() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:50 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.31 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.566 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #38
SELECT t.*
from mqi13_jbusinessdirectory_categories c
inner join mqi13_jbusinessdirectory_language_translations t
on c.id=t.object_id
where t.type=3
and language_tag='fa-IR'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT t.* from #__jbusinessdirectory_categories c inner join m' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:51 13 JBusinessDirectoryTranslations::getCategoriesTranslationsObjects() JROOT/administrator/components/com_jbusinessdirectory/helpers/translations.php:29 12 JBusinessDirectoryTranslations::getCategoriesTranslations() JROOT/components/com_jbusinessdirectory/assets/utils.php:1728 11 JBusinessUtil::getCategoriesOptions() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:50 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.57 ms پس از آخرین پرس و جو: 1.74 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 20.670 MB سطرهای بازگشتی: 5
select slec.*, mainCategory, mainCategoryId, companyName, companyId1, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from ( select cp.id, cp.name, cp.alias, cp.short_description, cp.street_number, cp.address, cp.countryId, cp.city, cp.county, cp.province, cp.area, cp.typeId, cp.website, cp.phone, cp.email, cp.state, cp.fax, cp.averageRating, cp.slogan, cp.logoLocation, cp. review_score, cp.ad_image, cp.featured,cp.publish_only_city, cp.publish_start_date, cp.publish_end_date, cp.name as companyName,cp.id as companyId1, cp.latitude, cp.longitude, cp.postalCode, cn.country_name as countryName,ct.name as typeName, count(distinct cr.id) as nr_reviews, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color
ORDER BY cg.name separator '#|') as categories, GROUP_CONCAT(DISTINCT pf.feature) as features, bc.name as mainCategory, bc.alias as mainCategoryAlias, bc.markerLocation as categoryMaker, bc.id as mainCategoryId
from mqi13_jbusinessdirectory_companies cp
left join mqi13_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join mqi13_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join mqi13_jbusinessdirectory_categories bc
on bc.id=cp.mainSubcategory
and bc.published=1
left join mqi13_jbusinessdirectory_company_reviews cr
on cr.itemId = cp.id
and cr.review_type = 1
and cr.approved=2
left join mqi13_jbusinessdirectory_countries cn
on cp.countryId=cn.id
left join mqi13_jbusinessdirectory_company_types ct
on cp.typeId=ct.id
left join mqi13_jbusinessdirectory_orders inv
on inv.company_id=cp.id
left join mqi13_jbusinessdirectory_packages p
on (inv.package_id=p.id
and p.status=1
and 0) or (p.price=0
and p.status=1
and 0)
left join mqi13_jbusinessdirectory_package_fields pf
on p.id=pf.package_id
where (cp.name like '%' or cp.name like '%' )
and cp.state=1
and (cp.approved = 2 or cp.approved= -1)
and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null)
and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id
order by cp.name ) as slec
group by companyId1
order by companyNameError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select slec.*, mainCategory, mainCategoryId, companyName, companyId1, features, ' at line 1 Status Duration starting 0.35 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.33 ms init 0.02 ms System lock 0.03 ms optimizing 0.01 ms optimizing 0.06 ms statistics 0.21 ms preparing 0.06 ms Creating tmp table 0.18 ms statistics 0.02 ms preparing 0.02 ms Creating tmp table 0.11 ms executing 0.84 ms end 0.02 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 15 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:223 14 JTableCompany->getTotalCompaniesByLetter() JROOT/components/com_jbusinessdirectory/models/catalog.php:117 13 JBusinessDirectoryModelCatalog->getTotalCompaniesByLetter() JROOT/components/com_jbusinessdirectory/models/catalog.php:129 12 JBusinessDirectoryModelCatalog->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:56 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 10.97 ms پس از آخرین پرس و جو: 5.43 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 20.899 MB سطرهای بازگشتی: 229
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mqi13_modules AS m
LEFT JOIN mqi13_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mqi13_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 <= '2025-09-16 03:36:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-09-16 03:36:53')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1956 OR mm.menuid <= 0)
AND m.language IN ('fa-IR','*')
ORDER BY m.position, m.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1 Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.64 ms init 0.02 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.20 ms preparing 0.06 ms executing 9.54 ms end 0.04 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() به نظر می رسد خط زیر فراخونده شده باشد. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 16 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 15 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 14 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/components/com_jbusinessdirectory/views/catalog/tmpl/default.php:51 13 include JROOT/components/com_jbusinessdirectory/views/catalog/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_jbusinessdirectory/views/catalog/view.html.php:59 10 JBusinessDirectoryViewCatalog->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jbusinessdirectory/controller.php:25 8 JBusinessDirectoryController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:66 6 require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.55 ms پس از آخرین پرس و جو: 13.90 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 21.406 MB سطرهای بازگشتی: 61
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mqi13_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','com_admin','com_ajax','com_ampz','com_associations','com_banners','com_cache','com_categories','com_checkin','com_competition','com_config','com_contact','com_content','com_contenthistory','com_contentstats','com_convertforms','com_cpanel','com_fields','com_finder','com_fix404errorlinks','com_gsd','com_hwdmediashare','com_instajoom','com_installer','com_jbusinessdirectory','com_jbusinessdirectorysubscriptions','com_jch_optimize','com_jhackguard','com_jmap','com_joomlaupdate','com_joompush','com_jrealtimeanalytics','com_k2','com_k2additionalcategories','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mymaplocations','com_newsfeeds','com_nextend2','com_obrss','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_rstbox','com_search','com_sigpro','com_smartslider3','com_solidres','com_tags','com_templates','com_users','com_weblinks','com_wrapper')Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id`,`name`,`rules`,`parent_id` FROM `#__assets` WHERE `name` IN ('roo' at line 1 Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.03 ms executing 0.76 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 15 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 14 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 13 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 12 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 11 Joomla\CMS\User\User->authorise() JROOT/plugins/system/sourcerer/src/Params.php:42 10 RegularLabs\Plugin\System\Sourcerer\Params::get() JROOT/plugins/system/sourcerer/src/Plugin.php:167 9 RegularLabs\Plugin\System\Sourcerer\Plugin->passChecks() JROOT/plugins/system/sourcerer/src/Plugin.php:57 8 RegularLabs\Plugin\System\Sourcerer\Plugin->run() JROOT/plugins/system/sourcerer/sourcerer.php:55 7 PlgSystemSourcerer->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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.48 ms پس از آخرین پرس و جو: 4.15 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 21.648 MB سطرهای بازگشتی: 0
select b.*
from mqi13_rstbox b
where b.published = 1
AND b.testmode=0Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select b.* from #__rstbox b where b.published = 1 AND b.testmode=0' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rstbox/helpers/helper.php:191 8 EBHelper::getBoxes() JROOT/plugins/system/rstbox/rstbox.php:78 7 PlgSystemRstBox->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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.31 ms پس از آخرین پرس و جو: 13.14 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 21.828 MB سطرهای بازگشتی: 2
SELECT language,id
FROM `mqi13_menu`
WHERE home = 1
AND published = 1
AND client_id = 0Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT language,id FROM `#__menu` WHERE home = 1 AND published = 1 AND client' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.82 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.89 ms پس از آخرین پرس و جو: 1.54 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 21.906 MB سطرهای بازگشتی: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `mqi13_menu` AS `c`
INNER JOIN `mqi13_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `mqi13_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `mqi13_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 1956Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `c2`.`language`,`c2`.`id` FROM `#__menu` AS `c` INNER JOIN `#__asso' at line 1 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.47 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768 7 PlgSystemLanguageFilter->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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.29 ms پس از آخرین پرس و جو: 5.29 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 22.024 MB سطرهای بازگشتی: 1
SELECT template_style_id
FROM mqi13_menu
WHERE id = 1956Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT template_style_id FROM #__menu WHERE id = 1956' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:129 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/sj_lifemag/includes/frame_inc.php:29 8 include_once JROOT/templates/sj_lifemag/includes/frame_inc.php JROOT/templates/sj_lifemag/index.php:27 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.38 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 22.030 MB سطرهای بازگشتی: 1
SELECT id
FROM mqi13_template_styles
WHERE home = 1
AND client_id = 0Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM #__template_styles WHERE home = 1 AND client_id = 0' at line 1 Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:133 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/sj_lifemag/includes/frame_inc.php:29 8 include_once JROOT/templates/sj_lifemag/includes/frame_inc.php JROOT/templates/sj_lifemag/index.php:27 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.31 ms پس از آخرین پرس و جو: 2.26 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 22.075 MB سطرهای بازگشتی: 1
SELECT home
FROM mqi13_menu
WHERE id=1956Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT home FROM #__menu WHERE id=1956' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_lifemag/index.php:121 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.22 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 22.080 MB سطرهای بازگشتی: 1
SELECT home
FROM mqi13_menu
WHERE id=1956Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT home FROM #__menu WHERE id=1956' at line 1 Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_lifemag/index.php:121 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.97 ms پس از آخرین پرس و جو: 9.56 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.213 MB سطرهای بازگشتی: 4
SELECT id,title,module,position,content,showtitle,params
FROM mqi13_modules AS m
WHERE m.access IN (1,1)
AND m.published=1
AND m.position='mega1';Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id,title,module,position,content,showtitle,params FROM #__modules AS m' at line 1 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.59 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/templates/sj_lifemag/menusys/ytmenu.php:487 14 YtMenu->loadModules() JROOT/templates/sj_lifemag/menusys/ytmenu.php:416 13 YtMenu->haveMegaContent() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:28 12 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_lifemag/index.php:230 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.02 ms پس از آخرین پرس و جو: 18.58 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.336 MB سطرهای بازگشتی: 4
SELECT id,title,module,position,content,showtitle,params
FROM mqi13_modules AS m
WHERE m.access IN (1,1)
AND m.published=1
AND m.position='mega-home';Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id,title,module,position,content,showtitle,params FROM #__modules AS m' at line 1 Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.59 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/templates/sj_lifemag/menusys/ytmenu.php:487 14 YtMenu->loadModules() JROOT/templates/sj_lifemag/menusys/ytmenu.php:416 13 YtMenu->haveMegaContent() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:28 12 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_lifemag/index.php:230 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.43 ms پس از آخرین پرس و جو: 14.15 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.379 MB سطرهای بازگشتی: 4
SELECT id,title,module,position,content,showtitle,params
FROM mqi13_modules AS m
WHERE m.access IN (1,1)
AND m.published=1
AND m.position='mega-world';Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id,title,module,position,content,showtitle,params FROM #__modules AS m' at line 1 Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.94 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/templates/sj_lifemag/menusys/ytmenu.php:487 14 YtMenu->loadModules() JROOT/templates/sj_lifemag/menusys/ytmenu.php:416 13 YtMenu->haveMegaContent() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:28 12 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_lifemag/index.php:230 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.58 ms پس از آخرین پرس و جو: 10.74 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.407 MB سطرهای بازگشتی: 4
SELECT id,title,module,position,content,showtitle,params
FROM mqi13_modules AS m
WHERE m.access IN (1,1)
AND m.published=1
AND m.id IN (773,774,775,777);Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id,title,module,position,content,showtitle,params FROM #__modules AS m' at line 1 Status Duration starting 0.12 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.08 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/templates/sj_lifemag/menusys/ytmenu.php:450 14 YtMenu->loadModules() JROOT/templates/sj_lifemag/menusys/ytmenu.php:412 13 YtMenu->haveMegaContent() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:28 12 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_lifemag/index.php:230 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.47 ms پس از آخرین پرس و جو: 8.17 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.432 MB سطرهای بازگشتی: 3
SELECT id,title,module,position,content,showtitle,params
FROM mqi13_modules AS m
WHERE m.access IN (1,1)
AND m.published=1
AND m.id IN (801,802,803);Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id,title,module,position,content,showtitle,params FROM #__modules AS m' at line 1 Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/templates/sj_lifemag/menusys/ytmenu.php:450 14 YtMenu->loadModules() JROOT/templates/sj_lifemag/menusys/ytmenu.php:412 13 YtMenu->haveMegaContent() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:28 12 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_lifemag/index.php:230 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.62 ms پس از آخرین پرس و جو: 9.71 ms حافظه پرس و جو: 0.014 MB حافظه قبل از پرس و جوی: 24.544 MB سطرهای بازگشتی: 5
SHOW FULL COLUMNS
FROM `mqi13_hwdms_config`توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `mqi13_hwdms_config`Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.56 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms Creating tmp table 0.06 ms executing 0.11 ms checking permissions 0.08 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 29 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 28 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 27 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 26 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_hwdmediashare/tables/configuration.php:24 25 hwdMediaShareTableConfiguration->__construct() JROOT/libraries/src/Table/Table.php:312 24 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_hwdmediashare/libraries/factory.php:122 23 hwdMediaShareFactory->getConfig() JROOT/components/com_hwdmediashare/router.php:29 22 hwdMediaShareRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 21 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 20 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 16 Joomla\CMS\Router\Route::_() JROOT/templates/sj_lifemag/menusys/ytmenu.php:360 15 YtMenu->getLink() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:179 14 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 13 YtMenu->getContent() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:31 12 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_lifemag/index.php:230 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.42 ms پس از آخرین پرس و جو: 0.13 ms حافظه پرس و جو: 0.012 MB حافظه قبل از پرس و جوی: 24.568 MB سطرهای بازگشتی: 1
SELECT *
FROM mqi13_hwdms_config
WHERE `id` = '1'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__hwdms_config WHERE `id` = '1'' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 25 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 24 Joomla\CMS\Table\Table->load() JROOT/components/com_hwdmediashare/libraries/factory.php:125 23 hwdMediaShareFactory->getConfig() JROOT/components/com_hwdmediashare/router.php:29 22 hwdMediaShareRouter->build() JROOT/libraries/src/Router/SiteRouter.php:528 21 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 20 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 16 Joomla\CMS\Router\Route::_() JROOT/templates/sj_lifemag/menusys/ytmenu.php:360 15 YtMenu->getLink() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:179 14 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 13 YtMenu->getContent() JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php:31 12 include JROOT/templates/sj_lifemag/menusys/class/mega/tmpl/default.php JROOT/templates/sj_lifemag/menusys/ytmenu.php:153 11 YtMenu->getContent() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219 10 YtFrameworkTemplate->getMenu() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417 9 YtFrameworkTemplate->renFeaturePos() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344 8 YtFrameworkTemplate->renPositionsNormal() JROOT/templates/sj_lifemag/index.php:230 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.40 ms پس از آخرین پرس و جو: 106.24 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 23.748 MB سطرهای بازگشتی: 1
SELECT home
FROM mqi13_menu
WHERE id=1956Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT home FROM #__menu WHERE id=1956' at line 1 Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 11 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:273 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/sj_lifemag/includes/block-content.php:95 8 include JROOT/templates/sj_lifemag/includes/block-content.php JROOT/templates/sj_lifemag/index.php:170 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.24 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 23.755 MB سطرهای بازگشتی: 1
SELECT home
FROM mqi13_menu
WHERE id=1956Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT home FROM #__menu WHERE id=1956' at line 1 Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118 10 YtFrameworkTemplate->isHomePage() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:273 9 YtFrameworkTemplate->renPositionsGroup() JROOT/templates/sj_lifemag/includes/block-content.php:95 8 include JROOT/templates/sj_lifemag/includes/block-content.php JROOT/templates/sj_lifemag/index.php:170 7 require JROOT/templates/sj_lifemag/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.74 ms پس از آخرین پرس و جو: 53.75 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 24.266 MB سطرهای بازگشتی: 9
select *
FROM mqi13_jbusinessdirectory_categories
where parent_id=1
and published=1
and type=1
order by lftError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * FROM #__jbusinessdirectory_categories where parent_id=1 and ' at line 1 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jbusinessdirectory/helper.php:18 14 modJBusinessDirectoryHelper::getMainCategories() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:60 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.28 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 24.297 MB سطرهای بازگشتی: 5
select *
FROM mqi13_jbusinessdirectory_company_types
order by nameError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * FROM #__jbusinessdirectory_company_types order by name' at line 1 Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jbusinessdirectory/helper.php:37 14 modJBusinessDirectoryHelper::getTypes() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:91 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.39 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 24.308 MB سطرهای بازگشتی: 4
select distinct county
FROM mqi13_jbusinessdirectory_companies
where state=1
and county!=""
order by county ascError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select distinct county FROM #__jbusinessdirectory_companies where state=1 and' at line 1 Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jbusinessdirectory/helper.php:60 14 modJBusinessDirectoryHelper::getRegions() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:114 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.35 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 24.317 MB سطرهای بازگشتی: 3
select distinct city
FROM mqi13_jbusinessdirectory_companies
where state=1
and city!=""
order by city ascError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select distinct city FROM #__jbusinessdirectory_companies where state=1 and c' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/modules/mod_jbusinessdirectory/helper.php:46 14 modJBusinessDirectoryHelper::getCities() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:121 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.09 ms پس از آخرین پرس و جو: 0.11 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.335 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.03 ms Opening tables 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:703 15 JTableCompany->getCompaniesByNameAndCategories() JROOT/modules/mod_jbusinessdirectory/helper.php:89 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.07 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.343 MB
SET SQL_BIG_SELECTS=1توضیحات در جستجو ممکن نیست: SET SQL_BIG_SELECTS=1Status Duration starting 0.02 ms Opening tables 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:706 15 JTableCompany->getCompaniesByNameAndCategories() JROOT/modules/mod_jbusinessdirectory/helper.php:89 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 2.79 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.014 MB حافظه قبل از پرس و جوی: 24.367 MB سطرهای بازگشتی: 5
select slec.*, mainCategory, mainCategoryId, categoryMaker, companyName, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from ( select cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile, cp.email, cp.state, cp.fax, cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.featured,cp.publish_only_city,cp.userId, cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color
ORDER BY cg.name separator '#|') as categories, GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT( DISTINCT cpt.picture_path) as pictures, bcm.name as mainCategory, bcm.alias as mainCategoryAlias ,bcm.markerLocation as categoryMaker, bcm.id as mainCategoryId, GROUP_CONCAT(DISTINCT ct.name) as typeName, #cnt.contact_name, count(distinct cr.id) as nr_reviews, GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, cn.country_name as countryName
from mqi13_jbusinessdirectory_companies cp
left join mqi13_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join mqi13_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
and cg.published=1
left join mqi13_jbusinessdirectory_categories bcm
on bcm.id=cp.mainSubcategory
and bcm.published=1
left join mqi13_jbusinessdirectory_company_reviews cr
on cr.itemId = cp.id
and cr.review_type = 1
and cr.approved=2
left join mqi13_jbusinessdirectory_company_pictures cpt
on cpt.companyId=cp.id
and cpt.picture_enable = 1 #
left join mqi13_jbusinessdirectory_company_contact cnt
on cp.id=cnt.companyId
left join mqi13_jbusinessdirectory_countries cn
on cp.countryId=cn.id
left join mqi13_jbusinessdirectory_company_types ct
on find_in_set(ct.id,cp.typeId)
left join mqi13_jbusinessdirectory_orders inv
on inv.company_id=cp.id
left join mqi13_jbusinessdirectory_packages p
on (inv.package_id=p.id
and p.status=1
and 0) or (p.price=0
and p.status=1
and 0)
left join mqi13_jbusinessdirectory_package_fields pf
on p.id=pf.package_id
where 1
and cp.state=1
and (cp.approved = 2 or cp.approved= -1)
and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null)
and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)
group by cp.id ) as slec
where 1
having 1
order by featured desc, packageOrder desc
LIMIT 0, 250Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select slec.*, mainCategory, mainCategoryId, categoryMaker, companyName, feature' at line 1 Status Duration starting 0.23 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.48 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms optimizing 0.04 ms statistics 0.18 ms preparing 0.04 ms Creating tmp table 0.18 ms statistics 0.01 ms preparing 0.14 ms executing 1.09 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:715 15 JTableCompany->getCompaniesByNameAndCategories() JROOT/modules/mod_jbusinessdirectory/helper.php:89 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.10 ms پس از آخرین پرس و جو: 0.13 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.414 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.03 ms Opening tables 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.46 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.424 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #27
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=12
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.09 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.431 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.03 ms Opening tables 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.40 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.441 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #29
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=30
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.03 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.08 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.448 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.03 ms Opening tables 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.38 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.458 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #35
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=31
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.08 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.466 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.02 ms Opening tables 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.39 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.475 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #33
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=33
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Creating tmp table 0.05 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.08 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.483 MB
SET SESSION group_concat_max_len =1000000توضیحات در جستجو ممکن نیست: SET SESSION group_concat_max_len =1000000Status Duration starting 0.02 ms Opening tables 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:33 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.38 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.008 MB حافظه قبل از پرس و جوی: 24.492 MB سطرهای بازگشتی: 0پرس و جوی تکراری: #31
select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=35
where a.status = 1
and a.attribute_type=1
group by a.id
order by a.orderingError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select a.*, GROUP_CONCAT(DISTINCT ao.name ORDER BY ao.ordering asc SEPAR' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jbusinessdirectory/tables/companyattributes.php:55 15 JTableCompanyAttributes->getCompanyAttributes() JROOT/modules/mod_jbusinessdirectory/helper.php:98 14 modJBusinessDirectoryHelper::getCompanies() JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php:130 13 include JROOT/modules/mod_jbusinessdirectory/mod_jbusinessdirectory.php JROOT/libraries/src/Helper/ModuleHelper.php:200 12 Joomla\CMS\Helper\ModuleHelper::renderModule() به نظر می رسد خط زیر فراخونده شده باشد. 11 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 10 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:605 9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.49 ms پس از آخرین پرس و جو: 7.34 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 24.430 MB سطرهای بازگشتی: 0
SELECT *
FROM `mqi13_joompush_configs`Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__joompush_configs`' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/components/com_joompush/helpers/config.php:33 13 JoompushHelpersConfig::getConfig() JROOT/plugins/system/joompush/joompush.php:97 12 PlgSystemJoompush->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.56 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 24.436 MB سطرهای بازگشتی: 0
SELECT *
FROM mqi13_jmap_metainfo
WHERE `linkurl` = 'http://www.mapgard.com/آژانس.html'
AND `published` = 1Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jmap_metainfo WHERE `linkurl` = 'http://www.mapgard.com/آ' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.05 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:407 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.44 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 24.442 MB سطرهای بازگشتی: 0
SELECT *
FROM mqi13_jmap_canonicals
WHERE `linkurl` = 'http://www.mapgard.com/آژانس.html'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jmap_canonicals WHERE `linkurl` = 'http://www.mapgard.com/' at line 1 Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # فراخوانده فایل و شماره خط 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:483 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.48 ms پس از آخرین پرس و جو: 6.23 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 24.655 MB سطرهای بازگشتی: 0
SELECT *
FROM mqi13_jmap_headings
WHERE `linkurl` = 'http://www.mapgard.com/آژانس.html'Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__jmap_headings WHERE `linkurl` = 'http://www.mapgard.com/آ' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:742 7 plgSystemJMap->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:1050 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 0.38 ms پس از آخرین پرس و جو: 15.04 ms حافظه پرس و جو: 0.005 MB حافظه قبل از پرس و جوی: 25.112 MB سطرهای بازگشتی: 1
SELECT template
FROM mqi13_template_styles
WHERE home = 1
AND client_id = 0Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT template FROM #__template_styles WHERE home = 1 AND client_id = 0' at line 1 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/yt.php:263 8 plgSystemYt->nameOfSJTemplate() JROOT/plugins/system/yt/yt.php:189 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:1050 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - زمان پرس و جو: 1.07 ms پس از آخرین پرس و جو: 5.19 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 25.642 MB سطرهای بازگشتی: 180
SELECT *
FROM mqi13_acymailing_configError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__acymailing_config' at line 1 Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.54 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # فراخوانده فایل و شماره خط 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:1050 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
55 نوع پرس و جو ثبت شده
انتخاب جداول:
5 × SELECT id,title,module,position,content,showtitle,params
FROM mqi13_modules AS m4 × SELECT home
FROM mqi13_menu2 × select slec.*, mainCategory, mainCategoryId, companyName, companyId1, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from ( select cp.id, cp.name, cp.alias, cp.short_description, cp.street_number, cp.address, cp.countryId, cp.city, cp.county, cp.province, cp.area, cp.typeId, cp.website, cp.phone, cp.email, cp.state, cp.fax, cp.averageRating, cp.slogan, cp.logoLocation, cp. review_score, cp.ad_image, cp.featured,cp.publish_only_city, cp.publish_start_date, cp.publish_end_date, cp.name as companyName,cp.id as companyId1, cp.latitude, cp.longitude, cp.postalCode, cn.country_name as countryName,ct.name as typeName, count(distinct cr.id) as nr_reviews, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color
ORDER BY cg.name separator '#|') as categories, GROUP_CONCAT(DISTINCT pf.feature) as features, bc.name as mainCategory, bc.alias as mainCategoryAlias, bc.markerLocation as categoryMaker, bc.id as mainCategoryId
from mqi13_jbusinessdirectory_companies cp
left join mqi13_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join mqi13_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
left join mqi13_jbusinessdirectory_categories bc
on bc.id=cp.mainSubcategory
and bc.published=1
left join mqi13_jbusinessdirectory_company_reviews cr
on cr.itemId = cp.id
and cr.review_type = 1
and cr.approved=2
left join mqi13_jbusinessdirectory_countries cn
on cp.countryId=cn.id
left join mqi13_jbusinessdirectory_company_types ct
on cp.typeId=ct.id
left join mqi13_jbusinessdirectory_orders inv
on inv.company_id=cp.id
left join mqi13_jbusinessdirectory_packages p
on (inv.package_id=p.id
and p.status=1
and 0) or (p.price=0
and p.status=1
and 0)
left join mqi13_jbusinessdirectory_package_fields pf
on p.id=pf.package_id2 × SELECT t.*
from mqi13_jbusinessdirectory_categories c
inner join mqi13_jbusinessdirectory_language_translations t
on c.id=t.object_id2 × select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=312 × select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=332 × select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=352 × select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=302 × SELECT *
FROM `mqi13_realtimeanalytics_eventstats`2 × SELECT fas.*, df.*, c.currency_name, c.currency_id
FROM mqi13_jbusinessdirectory_applicationsettings fas
inner join mqi13_jbusinessdirectory_date_formats df
on fas.date_format_id=df.id
inner join mqi13_jbusinessdirectory_currencies c
on fas.currency_id=c.currency_i2 × select a.*, GROUP_CONCAT(DISTINCT ao.name
ORDER BY ao.ordering asc SEPARATOR ',') options, GROUP_CONCAT(DISTINCT ao.id
ORDER BY ao.ordering asc SEPARATOR ',') optionsIDS, GROUP_CONCAT(ao.icon
ORDER BY ao.ordering asc SEPARATOR ',') optionsIcons, at.code as attributeTypeCode, ca.value as attributeValue
from mqi13_jbusinessdirectory_attributes a
left join mqi13_jbusinessdirectory_attribute_types AS at
on at.id=a.type
left join mqi13_jbusinessdirectory_attribute_options as ao
on ao.attribute_id = a.id
left join mqi13_jbusinessdirectory_company_attributes AS ca
on ca.attribute_id = a.id
and ca.company_id=121 × SELECT `data`
FROM `mqi13_session`1 × SELECT id
FROM mqi13_template_styles1 × SELECT *
FROM mqi13_hwdms_config1 × select *
FROM mqi13_jbusinessdirectory_categories1 × SELECT `c2`.`language`,`c2`.`id`
FROM `mqi13_menu` AS `c`
INNER JOIN `mqi13_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `mqi13_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `mqi13_menu` AS `c2`
ON a2.id = c2.`id`1 × select *
FROM mqi13_jbusinessdirectory_company_types1 × select distinct county
FROM mqi13_jbusinessdirectory_companies1 × select distinct city
FROM mqi13_jbusinessdirectory_companies1 × select slec.*, mainCategory, mainCategoryId, categoryMaker, companyName, features, GREATEST(if(FIND_IN_SET('featured_companies',features) ,1,0), featured) as featured
from ( select cp.name as companyName, cp.id as companyId1, cp.ad_image, cp.id, cp.name, cp.alias, cp.short_description, cp.meta_description, cp.street_number, cp.address, cp.city, cp.county, cp.province, cp.area, cp.website, cp.phone, cp.mobile, cp.email, cp.state, cp.fax, cp.averageRating, cp.slogan,cp.logoLocation, cp.activity_radius, cp. review_score, cp.creationDate, cp.featured,cp.publish_only_city,cp.userId, cp.latitude, cp.longitude, cp.keywords,cp.approved, cp.mainSubcategory, cp.countryId,cp.typeId, cp.postalCode, cp.publish_start_date, cp.publish_end_date, GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color
ORDER BY cg.name separator '#|') as categories, GROUP_CONCAT( DISTINCT cg.id) as categoryIds, GROUP_CONCAT( DISTINCT cpt.picture_path) as pictures, bcm.name as mainCategory, bcm.alias as mainCategoryAlias ,bcm.markerLocation as categoryMaker, bcm.id as mainCategoryId, GROUP_CONCAT(DISTINCT ct.name) as typeName, #cnt.contact_name, count(distinct cr.id) as nr_reviews, GROUP_CONCAT(DISTINCT pf.feature) as features, max(p.ordering) as packageOrder, cn.country_name as countryName
from mqi13_jbusinessdirectory_companies cp
left join mqi13_jbusinessdirectory_company_category cc
on cp.id=cc.companyId
left join mqi13_jbusinessdirectory_categories cg
on cg.id=cc.categoryId
and cg.published=1
left join mqi13_jbusinessdirectory_categories bcm
on bcm.id=cp.mainSubcategory
and bcm.published=1
left join mqi13_jbusinessdirectory_company_reviews cr
on cr.itemId = cp.id
and cr.review_type = 1
and cr.approved=2
left join mqi13_jbusinessdirectory_company_pictures cpt
on cpt.companyId=cp.id
and cpt.picture_enable = 1 #
left join mqi13_jbusinessdirectory_company_contact cnt
on cp.id=cnt.companyId
left join mqi13_jbusinessdirectory_countries cn
on cp.countryId=cn.id
left join mqi13_jbusinessdirectory_company_types ct
on find_in_set(ct.id,cp.typeId)
left join mqi13_jbusinessdirectory_orders inv
on inv.company_id=cp.id
left join mqi13_jbusinessdirectory_packages p
on (inv.package_id=p.id
and p.status=1
and 0) or (p.price=0
and p.status=1
and 0)
left join mqi13_jbusinessdirectory_package_fields pf
on p.id=pf.package_id1 × SELECT *
FROM `mqi13_joompush_configs1 × SELECT *
FROM mqi13_jmap_metainfo1 × SELECT *
FROM mqi13_jmap_canonicals1 × SELECT *
FROM mqi13_jmap_headings1 × SELECT template
FROM mqi13_template_styles1 × SELECT template_style_id
FROM mqi13_menu1 × SELECT a.id AS value, a.name AS text, a.level, a.published
FROM mqi13_jbusinessdirectory_categories AS a
LEFT JOIN `mqi13_jbusinessdirectory_categories` AS b
ON a.lft > b.lft
AND a.rgt < b.rgt1 × SELECT language,id
FROM `mqi13_menu`1 × SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `mqi13_obrss`1 × SELECT id, rules
FROM `mqi13_viewlevels1 × SELECT b.id
FROM mqi13_usergroups AS a
LEFT JOIN mqi13_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM mqi13_gsd_config1 × SELECT *
FROM mqi13_rsform_confi1 × SELECT `params`
FROM `mqi13_extensions`1 × SELECT `redirects`.`old_urls_arr` AS `old_urls_arr`,`redirects`.`destination_url` AS `destination_url`,`redirects`.`http_response_status_code` AS `http_response_status_code`
FROM `mqi13_fix404_redirects` AS `redirects`1 × SELECT *
FROM mqi13_session1 × select b.*
from mqi13_rstbox b1 × SELECT *
FROM mqi13_jbusinessdirectory_categories c1 × SELECT *
FROM `mqi13_jbusinessdirectory_companies` c1 × SELECT *
FROM mqi13_jbusinessdirectory_default_attribute1 × SELECT DISTINCT UPPER(
LEFT(name, 1)) as letter
FROM mqi13_jbusinessdirectory_companies1 × SELECT `session_id`
FROM `mqi13_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mqi13_modules AS m
LEFT JOIN mqi13_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mqi13_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `mqi13_assets`1 × SELECT *
FROM mqi13_acymailing_confi
سایر جداول:
11 ×
SET SESSION group_concat_max_len =1000001 × INSERT INTO `mqi13_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('af459c4bac6fcb9339c7acf0d721c716', 1, 1757993813, 0, '', 01 × SHOW FULL COLUMNS
FROM `mqi13_gsd_config1 × UPDATE `mqi13_extensions`
SET `params` = '{\"mediaversion\":\"5b3fa5ff07f34d0ed588cba93ab0e531\"}'1 × SHOW FULL COLUMNS
FROM `mqi13_session1 × SHOW FULL COLUMNS
FROM `mqi13_jbusinessdirectory_companies1 × SHOW FULL COLUMNS
FROM `mqi13_jbusinessdirectory_default_attributes1 × SHOW FULL COLUMNS
FROM `mqi13_jbusinessdirectory_company_attributes1 × SHOW FULL COLUMNS
FROM `mqi13_hwdms_config1 ×
SET SQL_BIG_SELECTS=