Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgSystemMarcosinterceptor has a deprecated constructor in /home/imlogic3/domains/visiton.pl/public_html/plugins/system/marcosinterceptor/marcosinterceptor.php on line 15
Amusement parks - Tourist attractions near you - Check parki rozrywki near you

Amusement parks
Tourist attractions near you

Sort by

Title Category Price Added

Miniature Park in Rąblów

In the city

Rąblów

Professionally made collection of 50 miniatures of wooden architecture of Kazimierz Dolny, Nałęczów, Puławy and surrounding towns

Labirynth park in Rąblów

In the city

Rąblów

Located in the Kazimierski Landscape Park, 10 km from Kazimierz Dolny and 10 km from Nałęczów, between these towns, in a known triangle ...

AB Landia Rope Park in Krościenko

In the city

Krościenko

Adventure, activity, safe dose of adrenaline and family vacation. These are the terms that describe the ABlandia Amusement Park in Krościenko

Rope Park AB Landia Rytro

In the city

Rytro

Do you want to experience a real adventure? Do you want to be high among the crowns of trees? Do you like active rest?

House of Mystery Escape Room in Warsaw

In the city

Warszawa

We invite you to a unique and extraordinary place. Get ready for exciting and amazing fun. Immerse yourself in the story and become a part of it

Minieuroland Park Miniatur

In the city

Kłodzko

In the picturesquely located park there are currently over 40 miniatures, which are modeled on famous buildings from around the world, especially Europe

Rope Park Tarzan

Mountains

Karpacz

The year-round rope park has been operating since the beginning of 2009 and now there are 50 attractions for children, youth and adults.

Magic Gardens

In the city

Janowiec

Near Janowiec nad Wisłą, among the vast meadows, green forests and loess gorges, there is a family theme park - Magic Gardens.

Kolejkowo - the largest railway model in Poland

In the city

Wrocław

Kolejkowo in Wroclaw will take all visitors on a journey into a miniature world.

Galindia

In the city

Ruciane-Nida

Galindia brings us to the full of magic pagan times.

Energy Land in Zator

In the city

Zator

Fantastic fun, unforgettable adventure and adrenaline - all of this is guaranteed by Energylandia, the largest Amusement Park in Poland.

Blubry - Poznan legends in 6D

In the city

Poznań

Why did two goats jump on Poznan's town hall? Where did the bugle call from the town hall tower come from?

Maze Park Łeba

In the city

Łeba

Do you love outdoor activities and fun? Are you eager for adventures and unforgettable impressions?

Kashubian Miniature Park

In the city

Strysza Buda

Among the picturesque areas of the Kashubian Landscape Park is an unusual place.

Kepler Science Center - Venus Planetarium

In the city

Zielona Góra

The Kepler Science Center in Zielona Góra is a modern educational institution focused on the development of a society based on education, science, technology an

Active Park Bartbo

Butryny k/Olsztyna

Park of Active Activity Bartbo is a place for a weekend with loved ones. You will find here attractions dedicated not only to families with children, but also t

Gdynia Aquarium

In the city

Gdynia

The Gdynia Aquarium functions as part of the Maritime Fisheries Institute - the National Research Institute.

Hewelianum Center

In the city

Gdańsk

Centrum Hewelianum is an interactive educational and entertainment space. Here history mixes with modernity.

Power Park Łeba

In the city

Łeba

Power Park Łeba is the perfect place to relax.

European Tales Center Koziołka Matołka in Pacanów

In the city

Pacanów

European Tales Center Matołek the Billy Goat - we know how to talk with children!

Start
Prev
1
2
3
4
5
6
7
8
9
Next
End

Notice: Undefined property: DJClassifiedsViewItems::$meta_custom in /home/imlogic3/domains/visiton.pl/public_html/templates/gdzie-wypoczac/html/com_djclassifieds/items/default_smart.php on line 496

Browse accommodation / tourist attractions

Advertistment

Newest articles

Więcej udogodnień dla pupili w czterogwiazdkowym hotelu Tristan w Kątach Rybackich

Widma w Operze Wrocławskiej

Zimowa wyprzedaż biletów do Energylandii!

If you are looking only for offers from luxury hotels all over Poland, check our second travel portal - hotelepremium.pl luxury hotels in Poland. We only review there hotels based on very strict criteria guaranteeing top quality and best care for guests comfort.

Accommodation offer nearby

Pokoje Gościnne „Orka”

Dworek Łosie

Babie Lato Bed&Breakfast

Dom Rumianek

Guest Rooms Pod Cuproną

Hotel Forum***

Pensjonat ZAMECZEK

All tourist attractions in one place

Korzystamy z Cookies. Przeglądając stronę zgadzasz się na zapis Cookie na Twoim urządzeniu

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576127929,
                "last": 1576127929,
                "now": 1576127929
            },
            "client": {
                "forwarded": "3.233.224.8"
            },
            "token": "UDUbxPurI1idHNONwlhKL6wt0FP4HvO5"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Profile Information

Time

Memory

Time: 10.51 ms / 10.51 ms Memory: 1.394 MB / 1.74 MB Application: afterLoad

Time: 429.95 ms / 440.46 ms Memory: 9.496 MB / 11.24 MB Application: afterInitialise

Time: 290.75 ms / 731.21 ms Memory: 2.333 MB / 13.57 MB Application: Before Access::preloadComponents (all components)

Time: 1.49 ms / 732.70 ms Memory: 0.071 MB / 13.64 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 732.73 ms Memory: 0.000 MB / 13.64 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.45 ms / 733.18 ms Memory: 0.026 MB / 13.66 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 11.46 ms / 744.64 ms Memory: 0.866 MB / 14.53 MB Application: afterRoute

Time: 0.39 ms / 745.03 ms Memory: 0.081 MB / 14.61 MB Application: beforeRenderComponent com_djclassifieds

Time: 1323.05 ms / 2068.09 ms Memory: 7.782 MB / 22.39 MB Application: afterRenderComponent com_djclassifieds

Time: 4.01 ms / 2072.09 ms Memory: 0.113 MB / 22.50 MB Application: afterDispatch

Time: 13.80 ms / 2085.89 ms Memory: 1.037 MB / 23.54 MB Application: beforeRenderModule mod_banners (Reklama - TOP - banery - mobile)

Time: 4.19 ms / 2090.08 ms Memory: 0.249 MB / 23.79 MB Application: afterRenderModule mod_banners (Reklama - TOP - banery - mobile)

Time: 0.04 ms / 2090.12 ms Memory: 0.000 MB / 23.78 MB Application: beforeRenderModule mod_banners (Reklama - TOP - banery)

Time: 2.06 ms / 2092.18 ms Memory: 0.074 MB / 23.86 MB Application: afterRenderModule mod_banners (Reklama - TOP - banery)

Time: 0.05 ms / 2092.22 ms Memory: 0.000 MB / 23.85 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.87 ms / 2093.09 ms Memory: 0.024 MB / 23.88 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.36 ms / 2093.46 ms Memory: 0.005 MB / 23.88 MB Application: beforeRenderModule mod_djclassifieds_search (Browse accommodation / tourist attractions)

Time: 760.99 ms / 2854.45 ms Memory: 4.109 MB / 27.99 MB Application: afterRenderModule mod_djclassifieds_search (Browse accommodation / tourist attractions)

Time: 1.54 ms / 2855.99 ms Memory: 0.000 MB / 24.15 MB Application: beforeRenderModule mod_banners (Advertistment)

Time: 2.16 ms / 2858.15 ms Memory: 0.070 MB / 24.22 MB Application: afterRenderModule mod_banners (Advertistment)

Time: 0.04 ms / 2858.19 ms Memory: 0.000 MB / 24.20 MB Application: beforeRenderModule mod_djmediatools (Newest articles)

Time: 7.34 ms / 2865.54 ms Memory: 0.652 MB / 24.86 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.06 ms / 2865.60 ms Memory: 0.007 MB / 24.86 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 15.80 ms / 2881.40 ms Memory: 0.470 MB / 25.33 MB Application: afterRenderModule mod_djmediatools (Newest articles)

Time: 0.06 ms / 2881.46 ms Memory: 0.000 MB / 25.30 MB Application: beforeRenderModule mod_custom (Looking for luxury hotels in Poland?)

Time: 0.41 ms / 2881.86 ms Memory: 0.007 MB / 25.31 MB Application: afterRenderModule mod_custom (Looking for luxury hotels in Poland?)

Time: 0.31 ms / 2882.17 ms Memory: 0.000 MB / 25.29 MB Application: beforeRenderModule mod_djmediatools (Accommodation offer nearby)

Time: 196.24 ms / 3078.41 ms Memory: 0.335 MB / 25.63 MB Application: afterRenderModule mod_djmediatools (Accommodation offer nearby)

Time: 0.11 ms / 3078.52 ms Memory: 0.000 MB / 25.61 MB Application: beforeRenderModule mod_menu (All tourist attractions in one place)

Time: 4.30 ms / 3082.82 ms Memory: 0.119 MB / 25.73 MB Application: afterRenderModule mod_menu (All tourist attractions in one place)

Time: 0.64 ms / 3083.47 ms Memory: 0.000 MB / 25.70 MB Application: beforeRenderModule mod_custom (Info kontakt)

Time: 0.20 ms / 3083.66 ms Memory: 0.004 MB / 25.71 MB Application: afterRenderModule mod_custom (Info kontakt)

Time: 0.08 ms / 3083.75 ms Memory: 0.001 MB / 25.71 MB Application: beforeRenderModule mod_menu (For owners:)

Time: 1.90 ms / 3085.65 ms Memory: 0.046 MB / 25.76 MB Application: afterRenderModule mod_menu (For owners:)

Time: 0.09 ms / 3085.75 ms Memory: 0.000 MB / 25.75 MB Application: beforeRenderModule mod_menu (General information)

Time: 2.41 ms / 3088.15 ms Memory: 0.070 MB / 25.82 MB Application: afterRenderModule mod_menu (General information)

Time: 0.10 ms / 3088.26 ms Memory: 0.000 MB / 25.82 MB Application: beforeRenderModule mod_menu (Pakiety i oferty specjalne)

Time: 2.63 ms / 3090.89 ms Memory: 0.080 MB / 25.90 MB Application: afterRenderModule mod_menu (Pakiety i oferty specjalne)

Time: 0.04 ms / 3090.93 ms Memory: 0.001 MB / 25.90 MB Application: beforeRenderModule mod_menu (Popular places to stay in Poland)

Time: 0.93 ms / 3091.85 ms Memory: 0.019 MB / 25.92 MB Application: afterRenderModule mod_menu (Popular places to stay in Poland)

Time: 10.54 ms / 3102.39 ms Memory: 1.339 MB / 27.26 MB Application: beforeRenderModule mod_custom (WYSZUKIWARKA MOBILE - przybornik)

Time: 0.22 ms / 3102.60 ms Memory: 0.003 MB / 27.26 MB Application: afterRenderModule mod_custom (WYSZUKIWARKA MOBILE - przybornik)

Time: 0.03 ms / 3102.63 ms Memory: 0.000 MB / 27.26 MB Application: beforeRenderModule mod_custom (Copyrights)

Time: 10.37 ms / 3113.00 ms Memory: 0.901 MB / 28.16 MB Application: afterRenderModule mod_custom (Copyrights)

Time: 0.10 ms / 3113.10 ms Memory: 0.000 MB / 28.16 MB Application: beforeRenderModule mod_custom (Offcanvas Button Top-bar)

Time: 0.20 ms / 3113.30 ms Memory: 0.003 MB / 28.17 MB Application: afterRenderModule mod_custom (Offcanvas Button Top-bar)

Time: 0.03 ms / 3113.33 ms Memory: 0.000 MB / 28.17 MB Application: beforeRenderModule mod_falang (FaLang Language Switcher)

Time: 5.25 ms / 3118.58 ms Memory: 0.175 MB / 28.34 MB Application: afterRenderModule mod_falang (FaLang Language Switcher)

Time: 0.04 ms / 3118.62 ms Memory: 0.000 MB / 28.34 MB Application: beforeRenderModule mod_menu (Top-bar Menu)

Time: 0.31 ms / 3118.94 ms Memory: 0.004 MB / 28.34 MB Application: afterRenderModule mod_menu (Top-bar Menu)

Time: 0.12 ms / 3119.05 ms Memory: 0.000 MB / 28.34 MB Application: beforeRenderModule mod_custom (Menu po prawej stronie)

Time: 0.23 ms / 3119.28 ms Memory: 0.003 MB / 28.34 MB Application: afterRenderModule mod_custom (Menu po prawej stronie)

Time: 117.92 ms / 3237.20 ms Memory: 1.309 MB / 29.65 MB Application: afterRender

Database queries total: 890.43 ms

Memory Usage

Database Queries

94 Queries Logged 890.43 ms

19 duplicate found!

2 duplicates: #3 #9

4 duplicates: #19 #33 #41 #60

3 duplicates: #21 #34 #42

2 duplicates: #24 #36

2 duplicates: #37 #86

3 duplicates: #38 #64 #87

3 duplicates: #52 #55 #65

Query Time: 0.52 ms Query memory: 0.028 MB Memory before query: 8.651 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/libraries/joomla/database/driver/mysqli.php:327
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
8	plgSystemAdmintools->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.23 ms After last query: 2.17 ms Query memory: 0.029 MB Memory before query: 8.724 MB Rows returned: 0

SELECT `source`,`keepurlparams`

  FROM `h8vtf_admintools_redirects`

  WHERE ((`dest` = 'en/miejsca-atrakcje-zabytki/parki-rozrywki.html') OR (`dest` = 'en/miejsca-atrakcje-zabytki/parki-rozrywki.html') OR ('en/miejsca-atrakcje-zabytki/parki-rozrywki.html' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_admintools_redirects	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:416
13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:215
11	JFalangDatabase->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
8	plgSystemAdmintools->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 31.57 ms After last query: 3.78 ms Query memory: 0.743 MB Memory before query: 9.023 MB Rows returned: 357

Duplicate queries: #9

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 h8vtf_menu AS m

  LEFT JOIN h8vtf_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.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	4	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	imlogic3_visiton.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 4.06 ms Query memory: 0.037 MB Memory before query: 10.151 MB Rows returned: 19

SELECT joomlatablename,tablepkID 
  FROM `h8vtf_falang_tableinfo`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_falang_tableinfo	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	19	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.14 ms After last query: 0.16 ms Query memory: 0.040 MB Memory before query: 10.173 MB Rows returned: 2

SELECT * 
  FROM h8vtf_languages 
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.30 ms After last query: 0.55 ms Query memory: 0.044 MB Memory before query: 10.216 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `h8vtf_languages`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `h8vtf_languages`

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 30.45 ms After last query: 3.96 ms Query memory: 0.035 MB Memory before query: 10.324 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1282,1283,470,860,944,530,816,985,1276,876,814,791,792,772,879,1280,948,984,1260,1261,1259,840,858,789,761,838,839,947,946,943,941,940,938,937,936,932,942,929,997,1035,925,918,922,914,915,923,916,917,919,920,921,924,926,927,928,837,861,873,874,875,933,934,935,939,945,972,931,989,988,987,990,991,992,993,994,995,1262,1266,1277,999,998,1015,1016,1017,1019,1018,1020,1021,958,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1000,1040,1042,1043,1041,1044,1045,1046,1047,1048,1049,1050,1052,1053,1054,1055,1056,1057,1058,1051,1059,1060,1061,1062,1063,1064,1065,1066,1067,1001,1081,1082,1083,1084,1246,1002,1085,1086,1087,1088,1089,1090,1091,1092,1093,1003,1094,1095,1096,1097,1248,1004,1098,1099,1100,1101,1102,1103,1104,1105,1005,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1250,1265,1275,1006,1068,1069,1070,1072,1073,1074,1075,1071,1245,1007,1137,1138,1139,1140,1249,1008,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1308,1009,1038,1036,1037,1039,1010,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1297,1011,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1223,1251,1299,1012,1076,1077,1078,1079,1080,1013,1199,1200,1201,1202,1247,1284,1287,1014,1204,1205,1203,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1224,1225,1226,1227,1228,1229,1230,1285,1286,1254,1263,1264,1278,1279,1281,1300,1302,1303,1304,1301,1295,1296,1305,1306,1307)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 49.28 ms Query memory: 0.026 MB Memory before query: 11.078 MB Rows returned: 0

SELECT `state`,`rule_type`

  FROM `h8vtf_jhackguard_ip_filters`

  WHERE `ip` = '3.233.224.8' 
  AND `state` = 1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
10	JFalangDatabase->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
9	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
8	PlgSystemJhackguard->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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.85 ms After last query: 70.56 ms Query memory: 0.730 MB Memory before query: 12.664 MB Rows returned: 357

Duplicate queries: #3

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 h8vtf_menu AS m

  LEFT JOIN h8vtf_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.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	4	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	imlogic3_visiton.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:366
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 43.82 ms After last query: 49.98 ms Query memory: 0.868 MB Memory before query: 13.692 MB Rows returned: 1786

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1282,1283,470,860,944,530,816,985,1276,876,814,791,792,772,879,1280,948,984,1260,1261,1259,840,858,789,761,838,839,947,946,943,941,940,938,937,936,932,942,929,997,1035,925,918,922,914,915,923,916,917,919,920,921,924,926,927,928,837,861,873,874,875,933,934,935,939,945,972,931,989,988,987,990,991,992,993,994,995,1262,1266,1277,999,998,1015,1016,1017,1019,1018,1020,1021,958,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1000,1040,1042,1043,1041,1044,1045,1046,1047,1048,1049,1050,1052,1053,1054,1055,1056,1057,1058,1051,1059,1060,1061,1062,1063,1064,1065,1066,1067,1001,1081,1082,1083,1084,1246,1002,1085,1086,1087,1088,1089,1090,1091,1092,1093,1003,1094,1095,1096,1097,1248,1004,1098,1099,1100,1101,1102,1103,1104,1105,1005,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1250,1265,1275,1006,1068,1069,1070,1072,1073,1074,1075,1071,1245,1007,1137,1138,1139,1140,1249,1008,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1308,1009,1038,1036,1037,1039,1010,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1297,1011,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1223,1251,1299,1012,1076,1077,1078,1079,1080,1013,1199,1200,1201,1202,1247,1284,1287,1014,1204,1205,1203,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1224,1225,1226,1227,1228,1229,1230,1285,1286,1254,1263,1264,1278,1279,1281,1300,1302,1303,1304,1301,1295,1296,1305,1306,1307)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	880	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:366
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.43 ms After last query: 169.21 ms Query memory: 0.027 MB Memory before query: 13.176 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM h8vtf_template_styles as s

  LEFT JOIN h8vtf_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 = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	imlogic3_visiton.s.template,const	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.37 ms After last query: 1.32 ms Query memory: 0.032 MB Memory before query: 13.223 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `h8vtf_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->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:1156
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.30 ms After last query: 0.27 ms Query memory: 0.009 MB Memory before query: 13.221 MB

UPDATE `h8vtf_extensions`

  SET `params` = '{\"mediaversion\":\"9e52d8f9f3c4df97978b30d72bb8c85e\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->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/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->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:1156
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.16 ms After last query: 3.96 ms Query memory: 0.036 MB Memory before query: 13.575 MB Rows returned: 49

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `h8vtf_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djclassifieds','com_djmediatools','com_djtabs','com_dpcalendar','com_falang','com_fields','com_finder','com_gsd','com_installer','com_jce','com_jcomments','com_jhackguard','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_redirect','com_rsform','com_rstbox','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_assets	range	idx_asset_name	idx_asset_name	202	NULL	50	100.00	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:277
9	RstboxHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:79
8	PlgSystemRstBox->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:1156
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 0.72 ms Query memory: 0.028 MB Memory before query: 13.659 MB Rows returned: 1

select b.* 
  from h8vtf_rstbox b 
  where b.published = 1  
  AND b.testmode=0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:289
9	RstboxHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:79
8	PlgSystemRstBox->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:1156
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 0.53 ms Query memory: 0.029 MB Memory before query: 13.712 MB Rows returned: 1

SELECT COUNT(id)

  FROM `h8vtf_rstbox_logs`

  WHERE `event` = 1 
  AND `box` = 1 
  AND `sessionid` = '6oog5gpptp1s5hhpng0l0t1ij7'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_rstbox_logs	ref	box,sessionid	sessionid	194	const	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
14	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
13	JFalangDatabase->loadResult()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:269
12	RstboxHelper::passImpressions()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:203
11	RstboxHelper::passLocalAssignments()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:137
10	RstboxHelper::checkPublishingAssignments()	JROOT/administrator/components/com_rstbox/helpers/rstbox.php:291
9	RstboxHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:79
8	PlgSystemRstBox->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:1156
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.92 ms After last query: 22.35 ms Query memory: 0.025 MB Memory before query: 15.769 MB Rows returned: 0

SELECT item_id 
  FROM h8vtf_djcf_items_promotions 
  WHERE date_exp <= '2019-12-12 06:18:50' 
  AND updated=0 
  GROUP BY item_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_djcf_items_promotions	index	item_id,date_exp	item_id	4	NULL	2019	53.59	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
8	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:891
7	DJClassifiedsPayment::updatePromotions()	JROOT/components/com_djclassifieds/djclassifieds.php:103
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.66 ms After last query: 4.04 ms Query memory: 0.070 MB Memory before query: 16.126 MB Rows returned: 39

SELECT c.* 
  FROM h8vtf_djcf_categories c 
  WHERE c.published=1  
  AND c.access_view IN (1,1,5) 
  ORDER BY c.parent_id, c.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	published	published	4	const	38	100.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djcategory.php:610
11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201
10	DJClassifiedsCategory::getSubCatIemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:87
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.95 ms After last query: 0.43 ms Query memory: 0.072 MB Memory before query: 16.320 MB Rows returned: 117

Duplicate queries: #33 #41 #60

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(66,68,77,67,69,70,71,72,73,74,75,76,79,80,27,48,49,50,51,52,54,55,56,57,58,59,60,61,62,63,78,81,82,83,85,86,87,88,84)
   
  AND falang_content.reference_table='djcf_categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_table	302	const	84	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djcategory.php:610
11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201
10	DJClassifiedsCategory::getSubCatIemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:87
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 18.01 ms After last query: 0.96 ms Query memory: 0.030 MB Memory before query: 16.332 MB Rows returned: 30

SELECT i.cat_id, count(i.id) as items_count 
  FROM h8vtf_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2019-12-12 06:00:00'  
  GROUP BY i.cat_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	ref	cat_id,published,blocked	published	4	const	7147	100.00	Using where; Using temporary; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djcategory.php:522
12	DJClassifiedsCategory::getItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:622
11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201
10	DJClassifiedsCategory::getSubCatIemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:87
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.20 ms After last query: 0.29 ms Query memory: 0.027 MB Memory before query: 16.346 MB Rows returned: 0

Duplicate queries: #34 #42

SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM h8vtf_djcf_items_categories ic, h8vtf_djcf_items i 
  WHERE ic.item_id=i.id 
  AND i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2019-12-12 06:00:00' 
  GROUP BY ic.cat_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djcategory.php:631
11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201
10	DJClassifiedsCategory::getSubCatIemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:87
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 62.69 ms After last query: 0.55 ms Query memory: 0.142 MB Memory before query: 16.357 MB Rows returned: 20

SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, c.rev_group_id, r.name as r_name, r.id as r_id , u.name as username 
  FROM  h8vtf_djcf_items i 
  LEFT JOIN h8vtf_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN h8vtf_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN h8vtf_users u 
  ON i.user_id = u.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM h8vtf_djcf_items_categories 
  WHERE cat_id IN (70,70) 
  GROUP BY item_id ) mc 
  ON i.id=mc.item_id 
  WHERE i.date_exp > '2019-12-12 06:18:50' 
  AND i.published=1 
  AND i.blocked=0 
  AND c.published=1  
  AND (i.cat_id IN (70,70) OR mc.mcat_c>0)  
  AND c.restriction_18=0  
  AND c.access_view IN (0,1,1,5)  
  ORDER BY i.special DESC, i.date_start ASC 
  LIMIT 0, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	ref	cat_id,published,blocked	published	4	const	7147	100.00	Using where; Using temporary; Using filesort
1	PRIMARY	c	eq_ref	PRIMARY,published	PRIMARY	4	imlogic3_visiton.i.cat_id	1	100.00	Using where
1	PRIMARY	r	eq_ref	PRIMARY	PRIMARY	4	imlogic3_visiton.i.region_id	1	100.00	NULL
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	imlogic3_visiton.i.user_id	1	100.00	NULL
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/libraries/src/MVC/Model/BaseDatabaseModel.php:308
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_djclassifieds/models/items.php:359
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.47 ms After last query: 0.75 ms Query memory: 0.103 MB Memory before query: 16.689 MB Rows returned: 140

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(5819,5820,5822,5823,5824,5826,5828,5830,5831,5865,5905,5924,5936,5937,5960,5975,5980,5982,5988,5994)
   
  AND falang_content.reference_table='djcf_items'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	53	75.47	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/libraries/src/MVC/Model/BaseDatabaseModel.php:308
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_djclassifieds/models/items.php:359
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.35 ms After last query: 1.12 ms Query memory: 0.030 MB Memory before query: 16.685 MB Rows returned: 2

Duplicate queries: #36

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(70)
   
  AND falang_content.reference_table='djcf_categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/libraries/src/MVC/Model/BaseDatabaseModel.php:308
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_djclassifieds/models/items.php:359
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.06 ms After last query: 0.49 ms Query memory: 0.032 MB Memory before query: 16.698 MB Rows returned: 18

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(2068,1144,1003,95,678,59,2072,63,281,1469,138,114,2094,263,2106,121,115,2100)
   
  AND falang_content.reference_table='djcf_regions'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	20	75.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/libraries/src/MVC/Model/BaseDatabaseModel.php:308
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_djclassifieds/models/items.php:359
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.47 ms After last query: 0.36 ms Query memory: 0.028 MB Memory before query: 16.707 MB Rows returned: 0

SELECT fv.item_id, fv.field_id, fv.value, fv.value_date, fv.value_date_to, f.label, f.type 
  FROM h8vtf_djcf_fields_values fv,h8vtf_djcf_fields f 
  WHERE fv.item_id IN (5819,5820,5822,5823,5824,5826,5828,5830,5831,5865,5905,5924,5936,5937,5960,5975,5980,5982,5988,5994) 
  AND f.id=fv.field_id 
  AND (f.in_table>0 OR f.in_blog=1) 
  AND f.access=0 
  AND f.published=1 
  ORDER BY fv.item_id,f.ordering, f.label

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fv	range	field_id,item_id	item_id	4	NULL	1200	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	f	eq_ref	PRIMARY,published	PRIMARY	4	imlogic3_visiton.fv.field_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:383
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.01 ms After last query: 0.21 ms Query memory: 0.082 MB Memory before query: 16.689 MB Rows returned: 234

SELECT img.* 
  FROM h8vtf_djcf_images img 
  WHERE img.item_id IN (5819,5820,5822,5823,5824,5826,5828,5830,5831,5865,5905,5924,5936,5937,5960,5975,5980,5982,5988,5994) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	img	range	item_id,type	item_id	4	NULL	40	75.00	Using index condition; Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djimage.php:427
11	DJClassifiedsImage::getAdsImages()	JROOT/components/com_djclassifieds/models/items.php:386
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.18 ms After last query: 0.50 ms Query memory: 0.027 MB Memory before query: 17.160 MB Rows returned: 0

SELECT ic.item_id, ic.cat_id, c.name, c.alias 
  FROM h8vtf_djcf_items_categories ic, h8vtf_djcf_categories c 
  WHERE c.id=ic.cat_id 
  AND ic.item_id IN (5819,5820,5822,5823,5824,5826,5828,5830,5831,5865,5905,5924,5936,5937,5960,5975,5980,5982,5988,5994)  
  ORDER BY ic.item_id,ic.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:394
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 17.171 MB Rows returned: 0

SELECT * 
  FROM h8vtf_djcf_images 
  WHERE item_id IN (839,839,839,839,839,839,839,839,839,1318,1318,1280,1318,1318,1318,839,1318,1318,1318,1318) 
  AND type='profile'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_djcf_images	ref	item_id,type	type	167	const	2	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:401
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.11 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 17.178 MB Rows returned: 0

SELECT * 
  FROM h8vtf_djcf_profiles 
  WHERE user_id IN (839,839,839,839,839,839,839,839,839,1318,1318,1280,1318,1318,1318,839,1318,1318,1318,1318)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_djcf_profiles	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:405
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:109
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 36.82 ms After last query: 0.54 ms Query memory: 0.029 MB Memory before query: 17.199 MB Rows returned: 1

SELECT count(i.id) 
  FROM (SELECT i.id  
  FROM  h8vtf_djcf_items i 
  LEFT JOIN h8vtf_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN h8vtf_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN h8vtf_users u 
  ON i.user_id = u.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM h8vtf_djcf_items_categories 
  WHERE cat_id IN (70,70) 
  GROUP BY item_id ) mc 
  ON i.id=mc.item_id 
  WHERE i.date_exp > '2019-12-12 06:18:50' 
  AND i.published=1 
  AND i.blocked=0 
  AND c.published=1  
  AND (i.cat_id IN (70,70) OR mc.mcat_c>0)  
  AND c.restriction_18=0  
  AND c.access_view IN (0,1,1,5)  ) as i

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7147	100.00	NULL
2	DERIVED	i	ref	cat_id,published,blocked	published	4	const	7147	100.00	Using where
2	DERIVED	c	eq_ref	PRIMARY,published	PRIMARY	4	imlogic3_visiton.i.cat_id	1	100.00	Using where
2	DERIVED	r	eq_ref	PRIMARY	PRIMARY	4	imlogic3_visiton.i.region_id	1	100.00	Using index
2	DERIVED	u	eq_ref	PRIMARY	PRIMARY	4	imlogic3_visiton.i.user_id	1	100.00	Using index
2	DERIVED	<derived3>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
3	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:416
13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
11	JFalangDatabase->loadResult()	JROOT/components/com_djclassifieds/models/items.php:768
10	DjclassifiedsModelItems->getCountItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:110
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.63 ms After last query: 0.41 ms Query memory: 0.070 MB Memory before query: 17.209 MB Rows returned: 39

SELECT c.* 
  FROM h8vtf_djcf_categories c 
  WHERE c.published=1  
  AND c.access_view IN (1,1,5) 
  ORDER BY c.parent_id, c.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	published	published	4	const	38	100.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djcategory.php:469
11	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:246
10	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/items/view.html.php:132
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.18 ms After last query: 0.59 ms Query memory: 0.074 MB Memory before query: 17.410 MB Rows returned: 117

Duplicate queries: #19 #41 #60

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(66,68,77,67,69,70,71,72,73,74,75,76,79,80,27,48,49,50,51,52,54,55,56,57,58,59,60,61,62,63,78,81,82,83,85,86,87,88,84)
   
  AND falang_content.reference_table='djcf_categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_table	302	const	84	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djcategory.php:469
11	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:246
10	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/items/view.html.php:132
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.19 ms After last query: 0.79 ms Query memory: 0.027 MB Memory before query: 17.423 MB Rows returned: 0

Duplicate queries: #21 #42

SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM h8vtf_djcf_items_categories ic, h8vtf_djcf_items i 
  WHERE ic.item_id=i.id 
  AND i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2019-12-12 06:00:00' 
  GROUP BY ic.cat_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/administrator/components/com_djclassifieds/lib/djcategory.php:488
11	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:246
10	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/items/view.html.php:132
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.16 ms After last query: 0.19 ms Query memory: 0.034 MB Memory before query: 17.421 MB Rows returned: 1

SELECT * 
  FROM h8vtf_djcf_categories 
  WHERE id=70 
  AND access_view IN (1,1,5)  
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_djcf_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/items.php:800
10	DjclassifiedsModelItems->getMainCat()	JROOT/components/com_djclassifieds/views/items/view.html.php:150
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.31 ms After last query: 0.21 ms Query memory: 0.030 MB Memory before query: 17.451 MB Rows returned: 2

Duplicate queries: #24

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(70)
   
  AND falang_content.reference_table='djcf_categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/components/com_djclassifieds/models/items.php:800
10	DjclassifiedsModelItems->getMainCat()	JROOT/components/com_djclassifieds/views/items/view.html.php:150
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.17 ms After last query: 21.74 ms Query memory: 0.030 MB Memory before query: 17.576 MB Rows returned: 6

Duplicate queries: #86

SELECT * 
  FROM h8vtf_djcf_types 
  WHERE published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_djcf_types	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:1122
10	DjclassifiedsModelItems->getTypes()	JROOT/components/com_djclassifieds/views/items/view.html.php:311
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.83 ms After last query: 0.22 ms Query memory: 0.030 MB Memory before query: 17.586 MB Rows returned: 6

Duplicate queries: #64 #87

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(7,8,9,10,11,12)
   
  AND falang_content.reference_table='djcf_types'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_table	302	const	3	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:277
14	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
13	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
12	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
11	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:1122
10	DjclassifiedsModelItems->getTypes()	JROOT/components/com_djclassifieds/views/items/view.html.php:311
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.31 ms After last query: 1.09 ms Query memory: 0.039 MB Memory before query: 17.686 MB Rows returned: 0

SELECT * 
  FROM h8vtf_djcf_fields 
  WHERE published=1 
  AND (in_table>0 OR in_blog=1) 
  ORDER BY name

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h8vtf_djcf_fields	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	64	98.44	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:1136
10	DjclassifiedsModelItems->getCustomFields()	JROOT/components/com_djclassifieds/views/items/view.html.php:359
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.53 ms After last query: 0.32 ms Query memory: 0.069 MB Memory before query: 17.713 MB Rows returned: 39

SELECT c.* 
  FROM h8vtf_djcf_categories c 
  ORDER BY c.parent_id, c.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	39	100.00	Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:469
10	DJClassifiedsCategory::getCategories()	JROOT/components/com_djclassifieds/views/items/view.html.php:375
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:132
6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.03 ms After last query: 0.37 ms Query memory: 0.072 MB Memory before query: 17.885 MB Rows returned: 117

Duplicate queries: #19 #33 #60

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM h8vtf_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(66,68,77,67,69,70,71,72,73,74,75,76,79,80,27,48,49,50,51,52,54,55,56,57,58,59,60,61,62,63,78,81,82,83,85,86,87,88,84)
   
  AND falang_content.reference_table='djcf_categories'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_table	302	const	84	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	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:277
14	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
13	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falan

Amusement parksTourist attractions near you

Accommodation offer nearby

All tourist attractions in one place

For owners:

General information

Pakiety i oferty specjalne

Popular places to stay in Poland

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

94 Queries Logged 890.43 ms

19 duplicate found!

Amusement parks
Tourist attractions near you