Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; GenerateManager has a deprecated constructor in /home/eazytour/public_html/administrator/components/com_hotelguide/classes/GenerateManager.class.php on line 27
HotelGuide v.3.2.0
Eazy Extranet
Warning: count(): Parameter must be an array or an object that implements Countable in /home/eazytour/public_html/components/com_hotelguide/templates/register/default/default.php on line 170
Thank you for your interest in partnering with EazyTour.
Why Partner with EazyTour®?
EazyTour.com is unique online bookings web site for Hotels, Airport transfer, golf courses & etc in Vietnam. Founded in 2011, EazyTour.com offers a wide variety of accommodation in Vietnam from 1 to 5 star luxury hotels, bed & breakfasts, and much more. Signing up with EazyTour.com will allow you to:
- Maximize the exposure of your property & the occupancy of your rooms
- Get the most revenue out of your room rates
- Use our commission-based model (no cure, no pay)
- Choose your preferred language (currently 3 languages, but it coming up 3more languages more till this year!)
- No entry fee, no sign-up or set-up costs!
- You can end the collaboration without any cost – no questions asked
- Your personal Account Manager will assist you whenever needed
- Free and easy to sign up
- Registration takes only a few minutes
First Time Registration
Please click the Register Now button to access the online application form.
After you have completed step one, we will send your login information to your e-mail.
Resume Registration
Top Hotel Destinations
Hotel Events
Hotel Tags
- April 30th Park
- Ben Thanh Market
- Bitexco Financial Tower Skydeck
- Central Mosque (Jamia Al Muslimin)
- Da Nang Beach
- Da Nang City
- Dalat Flower Gardens
- Dam Market
- Diamond Plaza
- Dinh Cau Temple
- Dong Ba Market
- Dong Khoi Street
- Golden Dragon Water Puppet Theatre
- Ha Noi
- Halong Bay Marina
- Hanoi National University
- Hanoi Opera House
- Ho Chi Minh City
- Ho Chi Minh City Hall
- Ho Chi Minh City Museum
- Ho Chi Minh Mausoleum
- Hoa Lo Prison Museum
- Hoan Kiem Lake
- Hue Museum of Royal Fine Arts
- Huyen Sy Church
- Marble Mountains
- Mariamman Temple
- Mui Ne Sand Dunes
- Museum of Cham Sculpture
- My Khe Beach
- Nha Trang City
- Nha Trang Night Market
- Nha Trang Port
- Non Nuoc Beach
- Notre Dame Cathedral
- Nowzone Fashion Mall
- Opera House
- Parkson Plaza
- Pham Ngu Lao Street
- Phan Thiet Beach
- Phu Quoc Beach
- Po Nagar Cham Towers
- Poshanu Cham Tower
- Private Beach
- Reunification Palace
- Sai Gon Tax Trade Center
- Saigon Central Post Office
- Saigon Culinary Art Center
- Saigon River
- Saigon Square
Customers
- Free Nights
- Free Upgrades
- Huge Discounts
- Airport Transfer Service
- Golf Course Booking
- Tour Booking
- Available Now!
You can book up to a whole year in advance or right up until the moment of your stay
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1566179615,
"last": 1566179615,
"now": 1566179615
},
"token": "BW7wgnM88Su2SJv6jwkiBGeqoz0t1dcr"
},
"registry": {
"currency": 157
},
"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": "en-GB"
}
}
}
Time
Memory
Time: 28.54 ms / 28.54 ms Memory: 1.532 MB / 1.90 MB Application: afterLoad
Time: 95.77 ms / 124.31 ms Memory: 4.757 MB / 6.66 MB Application: afterInitialise
Time: 13.04 ms / 137.35 ms Memory: 0.534 MB / 7.20 MB Application: afterRoute
Time: 4.42 ms / 141.77 ms Memory: 0.197 MB / 7.39 MB Application: beforeRenderComponent com_hotelguide
Time: 124.37 ms / 266.14 ms Memory: 10.868 MB / 18.26 MB Application: afterRenderComponent com_hotelguide
Time: 5.14 ms / 271.28 ms Memory: 0.195 MB / 18.45 MB Application: afterDispatch
Time: 9.67 ms / 280.95 ms Memory: 0.339 MB / 18.79 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 4.49 ms / 285.44 ms Memory: 0.191 MB / 18.98 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.07 ms / 285.51 ms Memory: 0.000 MB / 18.98 MB Application: beforeRenderModule mod_hotelguide_email (Customers)
Time: 0.48 ms / 285.99 ms Memory: 0.013 MB / 19.00 MB Application: afterRenderModule mod_hotelguide_email (Customers)
Time: 0.04 ms / 286.03 ms Memory: 0.000 MB / 18.99 MB Application: beforeRenderModule mod_menu (Hoteliers)
Time: 1.43 ms / 287.46 ms Memory: 0.017 MB / 19.01 MB Application: afterRenderModule mod_menu (Hoteliers)
Time: 0.04 ms / 287.50 ms Memory: 0.000 MB / 19.01 MB Application: beforeRenderModule mod_menu (Partners)
Time: 1.95 ms / 289.44 ms Memory: 0.030 MB / 19.04 MB Application: afterRenderModule mod_menu (Partners)
Time: 0.07 ms / 289.51 ms Memory: 0.001 MB / 19.04 MB Application: beforeRenderModule mod_hotelguide_allinone (HotelGuide All in One)
Time: 32.00 ms / 321.50 ms Memory: 0.172 MB / 19.21 MB Application: afterRenderModule mod_hotelguide_allinone (HotelGuide All in One)
Time: 0.09 ms / 321.59 ms Memory: 0.000 MB / 19.18 MB Application: beforeRenderModule mod_hotelguide_gateway (HotelGuide Gateway)
Time: 0.73 ms / 322.32 ms Memory: 0.012 MB / 19.19 MB Application: afterRenderModule mod_hotelguide_gateway (HotelGuide Gateway)
Time: 0.07 ms / 322.39 ms Memory: 0.000 MB / 19.19 MB Application: beforeRenderModule mod_falang (FaLang Language Switcher)
Time: 4.58 ms / 326.98 ms Memory: 0.218 MB / 19.41 MB Application: afterRenderModule mod_falang (FaLang Language Switcher)
Time: 0.07 ms / 327.05 ms Memory: 0.000 MB / 19.40 MB Application: beforeRenderModule mod_hotelguide_currency (HotelGuide Currency Pro)
Time: 1.24 ms / 328.29 ms Memory: 0.078 MB / 19.48 MB Application: afterRenderModule mod_hotelguide_currency (HotelGuide Currency Pro)
Time: 12.04 ms / 340.33 ms Memory: 0.229 MB / 19.71 MB Application: afterRender
Database queries total: 45.21 ms
19.77 MB (20,730,584 Bytes)
29 Queries Logged 45.21 ms
- Query Time: 1.26 ms Query memory: 0.053 MB Memory before query: 5.747 MB Rows returned: 37Duplicate queries: #6
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 258 8.80 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 eazytour_tour.m.component_id 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 24 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 23 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:130 8 PlgSystemLanguageFilter->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:686 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 2.26 ms Query memory: 0.035 MB Memory before query: 5.977 MB Rows returned: 66
SELECT joomlatablename,tablepkID
FROM `jos_falang_tableinfo`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_falang_tableinfo NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 66 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 29 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 28 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 27 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144 26 FalangManager->_loadPrimaryKeyData() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57 25 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 24 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:130 8 PlgSystemLanguageFilter->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:686 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.25 ms Query memory: 0.034 MB Memory before query: 6.002 MB Rows returned: 1
SELECT *
FROM jos_languages
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 30 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 29 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 28 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 27 JFalangDatabase->loadObjectList() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319 26 FalangManager->getLanguages() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 25 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 24 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:130 8 PlgSystemLanguageFilter->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:686 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 2.34 ms Query memory: 0.037 MB Memory before query: 6.457 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `jos_languages`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_languages`No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 34 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 33 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 32 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 31 JFalangDatabase->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 30 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 29 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 28 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_falang/tables/JFLanguage.php:54 27 TableJFLanguage->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325 26 FalangManager->getLanguages() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 25 FalangManager->__construct() JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 24 FalangManager::getInstance() JROOT/components/com_falang/helpers/falang.class.php:35 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:130 8 PlgSystemLanguageFilter->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:686 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.05 ms After last query: 0.80 ms Query memory: 0.030 MB Memory before query: 6.520 MB Rows returned: 0Duplicate queries: #7
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(295,296,297,298,299,300,301,327,302,259,101,103,119,120,121,122,123,124,125,126,127,104,113,200,201,202,280,303,304,305,306,330,307,328,329,331,332)
AND falang_content.reference_table='menu'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE falang_content NULL ref idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table language_id 4 const 1 5.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 27 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 26 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:277 25 JFalangDatabase->loadObjectList() JROOT/components/com_falang/helpers/falang.class.php:235 24 Falang::translateListWithIDs() JROOT/components/com_falang/helpers/falang.class.php:108 23 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 22 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:130 8 PlgSystemLanguageFilter->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:686 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.96 ms After last query: 8.73 ms Query memory: 0.049 MB Memory before query: 7.124 MB Rows returned: 37Duplicate queries: #1
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 258 8.80 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 eazytour_tour.m.component_id 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 20 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 18 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/plugins/system/falangdriver/falangdriver.php:368 11 plgSystemFalangdriver->parseRule() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.01 ms After last query: 0.53 ms Query memory: 0.029 MB Memory before query: 7.201 MB Rows returned: 0Duplicate queries: #5
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(295,296,297,298,299,300,301,327,302,259,101,103,119,120,121,122,123,124,125,126,127,104,113,200,201,202,280,303,304,305,306,330,307,328,329,331,332)
AND falang_content.reference_table='menu'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE falang_content NULL ref idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table language_id 4 const 1 5.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 23 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 22 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:277 21 JFalangDatabase->loadObjectList() JROOT/components/com_falang/helpers/falang.class.php:235 20 Falang::translateListWithIDs() JROOT/components/com_falang/helpers/falang.class.php:108 19 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 18 JFalangDatabase->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/plugins/system/falangdriver/falangdriver.php:368 11 plgSystemFalangdriver->parseRule() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 1.77 ms Query memory: 0.026 MB Memory before query: 7.232 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 17 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 15 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 14 JFalangDatabase->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 0.27 ms Query memory: 0.005 MB Memory before query: 7.213 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"ca045ba1dad34c59d682f3be3f1b75b3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 10 JFalangDatabase->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 2.21 ms Query memory: 0.022 MB Memory before query: 7.383 MB Rows returned: 3
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 5 20.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 eazytour_tour.s.template,const 1 4.65 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 7 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 6 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 5 JFalangDatabase->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.81 ms After last query: 40.77 ms Query memory: 0.048 MB Memory before query: 11.392 MB Rows returned: 1
SELECT *
FROM jos_hg_settings
WHERE id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_hg_settings NULL const PRIMARY,id PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 8 JFalangDatabase->loadObject() JROOT/administrator/components/com_hotelguide/classes/util.php:141 7 HGUtil::config() JROOT/components/com_hotelguide/hotelguide.php:62 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 11.417 MB Rows returned: 1
SELECT lang_code
FROM jos_languages
WHERE lang_id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_languages NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 8 JFalangDatabase->loadObject() JROOT/administrator/components/com_hotelguide/classes/util.php:145 7 HGUtil::config() JROOT/components/com_hotelguide/hotelguide.php:62 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 11.424 MB Rows returned: 1Duplicate queries: #28
SELECT code
FROM jos_hg_currency
WHERE id = 157id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_hg_currency NULL const PRIMARY,id PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 8 JFalangDatabase->loadObject() JROOT/administrator/components/com_hotelguide/classes/util.php:149 7 HGUtil::config() JROOT/components/com_hotelguide/hotelguide.php:62 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.60 ms After last query: 0.11 ms Query memory: 0.250 MB Memory before query: 11.441 MB Rows returned: 1
SELECT *
FROM jos_hg_siteinfo
WHERE id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_hg_siteinfo NULL system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 8 JFalangDatabase->loadObject() JROOT/administrator/components/com_hotelguide/classes/util.php:178 7 HGUtil::siteinfo() JROOT/components/com_hotelguide/hotelguide.php:63 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 0.34 ms Query memory: 0.027 MB Memory before query: 11.672 MB Rows returned: 1
SELECT *
FROM jos_hg_layout
WHERE id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_hg_layout NULL const id id 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 8 JFalangDatabase->loadObject() JROOT/administrator/components/com_hotelguide/classes/util.php:189 7 HGUtil::layout() JROOT/components/com_hotelguide/hotelguide.php:64 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 11.684 MB Rows returned: 1
SELECT *
FROM jos_hg_currency
WHERE id = 157
AND published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_hg_currency NULL const PRIMARY,id PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 8 JFalangDatabase->loadObject() JROOT/components/com_hotelguide/helpers/helper.php:198 7 hotelguide::getCurrency() JROOT/components/com_hotelguide/hotelguide.php:65 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.85 ms After last query: 70.11 ms Query memory: 0.025 MB Memory before query: 18.061 MB Rows returned: 3
SELECT DISTINCT h.id
FROM jos_hg_hotelier AS h
WHERE user = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE h NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 307 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 15 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 13 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 12 JFalangDatabase->loadObject() JROOT/components/com_hotelguide/models/hotelier.php:486 11 hotelguideModelHotelier->checkHotelier() JROOT/components/com_hotelguide/views/register/view.html.php:123 10 hotelguideViewRegister->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_hotelguide/controller.php:422 8 hotelguideController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_hotelguide/hotelguide.php:94 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.18 ms Query memory: 0.038 MB Memory before query: 18.069 MB Rows returned: 0
SELECT DISTINCT h.*, c.name AS countryname
FROM jos_hg_hotelier AS h
LEFT JOIN jos_hg_countries AS c
ON c.id = h.country
LEFT JOIN jos_users AS u
ON u.id = h.user
WHERE u.id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 15 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 13 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 12 JFalangDatabase->loadObject() JROOT/components/com_hotelguide/models/hotelier.php:514 11 hotelguideModelHotelier->getData() JROOT/components/com_hotelguide/views/register/view.html.php:459 10 hotelguideViewRegister->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_hotelguide/controller.php:422 8 hotelguideController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_hotelguide/hotelguide.php:94 6 require_once JROOT/components/com_hotelguide/hotelguide.php JROOT/libraries/src/Component/ComponentHelper.php:392 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:367 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 5.62 ms Query memory: 0.023 MB Memory before query: 18.263 MB Rows returned: 1
SELECT language,id
FROM `jos_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_menu NULL ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 258 0.88 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 11 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 9 JFalangDatabase->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:718 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 18.274 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(101)
AND falang_content.reference_table='menu'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE falang_content NULL ref idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table falangContent 310 const,const,const 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 14 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:277 12 JFalangDatabase->loadObjectList() JROOT/components/com_falang/helpers/falang.class.php:235 11 Falang::translateListWithIDs() JROOT/components/com_falang/helpers/falang.class.php:108 10 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 9 JFalangDatabase->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:718 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:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.34 ms After last query: 5.63 ms Query memory: 0.030 MB Memory before query: 18.588 MB Rows returned: 19
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2019-08-19 01:53:35')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-19 01:53:35')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 332 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds,idx_language published 5 NULL 28 2.44 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 eazytour_tour.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 eazytour_tour.m.id 1 40.00 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 16 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 14 JFalangDatabase->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/simplyblue/index.php:39 7 require JROOT/templates/simplyblue/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:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 15.63 ms Query memory: 0.026 MB Memory before query: 19.071 MB Rows returned: 18
SELECT DISTINCT (c.id), c.name,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE id END as slug
FROM jos_hg_cities AS c
WHERE c.published = 1
AND c.parent_id = 0
AND c.country = 230
GROUP BY c.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref PRIMARY,id_2,id,parent_id,country,center,lat,lon parent_id 4 const 18 10.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 14 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 12 JFalangDatabase->loadObjectList() JROOT/modules/mod_hotelguide_allinone/helper.php:46 11 modAllinOneModuleHelper::getDestinations() JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php:36 10 include JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 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:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.43 ms After last query: 0.22 ms Query memory: 0.027 MB Memory before query: 19.096 MB Rows returned: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos_falang_content AS falang_content
WHERE falang_content.language_id=1
AND falang_content.published=1
AND falang_content.reference_id IN(1,5,6,11,12,13,14,15,16,17,18,19,50,51,52,95,109,180)
AND falang_content.reference_table='hg_cities'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE falang_content NULL ref idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table language_id 4 const 1 5.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 17 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 16 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:277 15 JFalangDatabase->loadObjectList() JROOT/components/com_falang/helpers/falang.class.php:235 14 Falang::translateListWithIDs() JROOT/components/com_falang/helpers/falang.class.php:108 13 Falang::translateList() JROOT/plugins/system/falangdriver/falang_database.php:334 12 JFalangDatabase->loadObjectList() JROOT/modules/mod_hotelguide_allinone/helper.php:46 11 modAllinOneModuleHelper::getDestinations() JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php:36 10 include JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 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:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 19.100 MB Rows returned: 5
SELECT DISTINCT (id), title,
CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM jos_hg_events
WHERE published = 1
AND parent_id > 0
LIMIT 0, 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_hg_events NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 7.69 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 14 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 12 JFalangDatabase->loadObjectList() JROOT/modules/mod_hotelguide_allinone/helper.php:65 11 modAllinOneModuleHelper::getEvents() JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php:37 10 include JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 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:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 11.72 ms After last query: 0.67 ms Query memory: 0.028 MB Memory before query: 19.116 MB Rows returned: 50
SELECT COUNT( t.tid ) AS no
FROM jos_hg_tags_item_relations AS t
LEFT JOIN jos_hg_hotelitems AS i
ON i.id = t.itemid
LEFT JOIN jos_hg_tags as tag
ON tag.id = t.tid
WHERE i.published = 1
AND tag.published = 1
GROUP BY t.tid
ORDER BY no DESC
LIMIT 0, 50id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tag NULL ALL PRIMARY,id_2,id NO INDEX KEY COULD BE USED NULL NULL 217 10.00 Using where; Using temporary; Using filesort 1 SIMPLE t NULL ref PRIMARY,tid,itemid tid 4 eazytour_tour.tag.id 10 100.00 Using index 1 SIMPLE i NULL eq_ref PRIMARY,id_2,id PRIMARY 4 eazytour_tour.t.itemid 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 16 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 14 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:178 13 JFalangDatabase->loadColumn() JROOT/plugins/system/falangdriver/falang_database.php:158 12 JFalangDatabase->loadResultArray() JROOT/modules/mod_hotelguide_allinone/helper.php:114 11 modAllinOneModuleHelper::getTags() JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php:38 10 include JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 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:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 11.16 ms After last query: 0.24 ms Query memory: 0.030 MB Memory before query: 19.128 MB Rows returned: 50
SELECT DISTINCT (tag.id), tag.name, count( rel.tid ) AS no,
CASE WHEN CHAR_LENGTH(tag.alias) THEN CONCAT_WS(':', tag.id, tag.alias) ELSE tag.id END as slug
FROM jos_hg_tags AS tag
LEFT JOIN jos_hg_tags_item_relations AS rel
ON rel.tid = tag.id
LEFT JOIN jos_hg_hotelitems AS i
ON i.id = rel.itemid
WHERE i.published = 1
AND tag.published = 1
GROUP BY tag.id
HAVING no >= 3
ORDER BY tag.name
LIMIT 0, 50id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tag NULL index PRIMARY,id_2,id,name,type PRIMARY 4 NULL 217 10.00 Using where; Using temporary; Using filesort 1 SIMPLE rel NULL ref PRIMARY,tid,itemid tid 4 eazytour_tour.tag.id 10 100.00 Using index 1 SIMPLE i NULL eq_ref PRIMARY,id_2,id PRIMARY 4 eazytour_tour.rel.itemid 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 14 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 12 JFalangDatabase->loadObjectList() JROOT/modules/mod_hotelguide_allinone/helper.php:136 11 modAllinOneModuleHelper::getTags() JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php:38 10 include JROOT/modules/mod_hotelguide_allinone/mod_hotelguide_allinone.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 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:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 8.82 ms Query memory: 0.026 MB Memory before query: 19.353 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `jos_menu` AS `c`
INNER JOIN `jos_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jos_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `jos_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 332id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 16 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 14 JFalangDatabase->loadObjectList() JROOT/libraries/src/Language/Associations.php:102 13 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:320 12 MenusHelper::getAssociations() JROOT/modules/mod_falang/helper.php:66 11 modFaLangHelper::getList() JROOT/modules/mod_falang/mod_falang.php:25 10 include JROOT/modules/mod_falang/mod_falang.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 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:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 2.20 ms Query memory: 0.025 MB Memory before query: 19.446 MB Rows returned: 1Duplicate queries: #13
SELECT code
FROM jos_hg_currency
WHERE id = 157id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_hg_currency NULL const PRIMARY,id PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/plugins/system/falangdriver/falang_database.php:105 15 JFalangDatabase->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:282 13 JFalangDatabase->loadObjectList() JROOT/plugins/system/falangdriver/falang_database.php:416 12 JFalangDatabase->loadObject() JROOT/modules/mod_hotelguide_currency/tmpl/default.php:34 11 require JROOT/modules/mod_hotelguide_currency/tmpl/default.php JROOT/modules/mod_hotelguide_currency/mod_hotelguide_currency.php:38 10 include JROOT/modules/mod_hotelguide_currency/mod_hotelguide_currency.php JROOT/libraries/src/Helper/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:782 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:1117 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
23 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
4 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM jos_falang_content AS falang_content2 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id2 × SELECT code
FROM jos_hg_currency1 × SELECT DISTINCT h.id
FROM jos_hg_hotelier AS h1 × SELECT DISTINCT (tag.id), tag.name, count( rel.tid ) AS no,
CASE WHEN CHAR_LENGTH(tag.alias) THEN CONCAT_WS(':', tag.id, tag.alias) ELSE tag.id END as slug
FROM jos_hg_tags AS tag
LEFT JOIN jos_hg_tags_item_relations AS rel
ON rel.tid = tag.id
LEFT JOIN jos_hg_hotelitems AS i
ON i.id = rel.itemid1 × SELECT COUNT( t.tid ) AS no
FROM jos_hg_tags_item_relations AS t
LEFT JOIN jos_hg_hotelitems AS i
ON i.id = t.itemid
LEFT JOIN jos_hg_tags as tag
ON tag.id = t.tid1 × SELECT DISTINCT (id), title,
CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
FROM jos_hg_events1 × SELECT DISTINCT (c.id), c.name,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE id END as slug
FROM jos_hg_cities AS c1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT language,id
FROM `jos_menu`1 × SELECT DISTINCT h.*, c.name AS countryname
FROM jos_hg_hotelier AS h
LEFT JOIN jos_hg_countries AS c
ON c.id = h.country
LEFT JOIN jos_users AS u
ON u.id = h.user1 × SELECT *
FROM jos_hg_layout1 × SELECT *
FROM jos_hg_currency1 × SELECT joomlatablename,tablepkID
FROM `jos_falang_tableinfo1 × SELECT *
FROM jos_hg_siteinfo1 × SELECT lang_code
FROM jos_languages1 × SELECT *
FROM jos_hg_settings1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`1 × SELECT *
FROM jos_languages1 × SELECT `c2`.`language`,`c2`.`id`
FROM `jos_menu` AS `c`
INNER JOIN `jos_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jos_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `jos_menu` AS `c2`
ON a2.id = c2.`id`
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `jos_languages1 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"ca045ba1dad34c59d682f3be3f1b75b3\"}'