Remind Username

Rental Property
Real Estate
Entertainment and excursions

Location

Check-in

19-04-2024

Check-out

20-04-2024

Advanced Search Close

Advice

Lloret de Mar | 4°C | Clear

ADDRESS

17310, Lloret de Mar

PHONE

+34 603 207 704

E-MAIL

info@alexandretour.com

STAY UP TO DATE

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713553561,
                "last": 1713553561,
                "now": 1713553561
            },
            "token": "XyCSm9jpC30lFPdgFVEIHX61fgiyoAh7"
        },
        "registry": {
            "current_currency_id": "2"
        },
        "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: 9.05 ms / 9.05 ms Memory: 0.575 MB / 0.95 MB Application: afterLoad

Time: 74.81 ms / 83.86 ms Memory: 1.693 MB / 2.64 MB Application: afterInitialise

Time: 44.71 ms / 128.57 ms Memory: 0.899 MB / 3.54 MB Application: Before Access::preloadComponents (all components)

Time: 1.80 ms / 130.37 ms Memory: 0.063 MB / 3.61 MB Application: After Access::preloadComponents (all components)

Time: 0.05 ms / 130.42 ms Memory: -0.002 MB / 3.60 MB Application: Before Access::getAssetRules (id:124 name:com_solidres)

Time: 0.39 ms / 130.81 ms Memory: 0.013 MB / 3.62 MB Application: After Access::getAssetRules (id:124 name:com_solidres)

Time: 12.24 ms / 143.05 ms Memory: 0.724 MB / 4.34 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.07 ms / 143.12 ms Memory: 0.007 MB / 4.35 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.29 ms / 143.40 ms Memory: 0.001 MB / 4.35 MB Application: afterRoute

Time: 0.82 ms / 144.22 ms Memory: 0.008 MB / 4.36 MB Application: beforeRenderComponent com_users

Time: 12.40 ms / 156.62 ms Memory: 0.290 MB / 4.65 MB Application: afterRenderComponent com_users

Time: 3.64 ms / 160.27 ms Memory: 0.039 MB / 4.69 MB Application: afterDispatch

Time: 8.26 ms / 168.53 ms Memory: 0.353 MB / 5.04 MB Application: beforeRenderModule mod_tabs_gk5 (Booking Tabs (2))

Time: 3.08 ms / 171.61 ms Memory: 0.156 MB / 5.20 MB Application: beforeRenderModule mod_sr_advancedsearch (Advanced Search)

Time: 4.92 ms / 176.53 ms Memory: 0.117 MB / 5.31 MB Application: afterRenderModule mod_sr_advancedsearch (Advanced Search)

Time: 0.11 ms / 176.64 ms Memory: -0.007 MB / 5.31 MB Application: beforeRenderModule mod_djclassifieds_search (DJClassifieds Search)

Time: 11.22 ms / 187.86 ms Memory: 0.325 MB / 5.63 MB Application: afterRenderModule mod_djclassifieds_search (DJClassifieds Search)

Time: 0.23 ms / 188.09 ms Memory: -0.008 MB / 5.62 MB Application: beforeRenderModule mod_sr_experience_search (Experience Search)

Time: 7.12 ms / 195.21 ms Memory: 0.106 MB / 5.73 MB Application: afterRenderModule mod_sr_experience_search (Experience Search)

Time: 0.14 ms / 195.34 ms Memory: -0.028 MB / 5.70 MB Application: afterRenderModule mod_tabs_gk5 (Booking Tabs (2))

Time: 0.22 ms / 195.56 ms Memory: -0.013 MB / 5.69 MB Application: beforeRenderModule mod_weather_gk4 (Weather)

Time: 254.84 ms / 450.41 ms Memory: 0.047 MB / 5.74 MB Application: afterRenderModule mod_weather_gk4 (Weather)

Time: 0.07 ms / 450.48 ms Memory: -0.024 MB / 5.71 MB Application: beforeRenderModule mod_custom (Contact Details Контактная информация)

Time: 0.86 ms / 451.33 ms Memory: 0.007 MB / 5.72 MB Application: afterRenderModule mod_custom (Contact Details Контактная информация)

Time: 0.06 ms / 451.40 ms Memory: 0.006 MB / 5.73 MB Application: beforeRenderModule mod_acymailing (STAY UP TO DATE)

Time: 9.63 ms / 461.03 ms Memory: 0.902 MB / 6.63 MB Application: afterRenderModule mod_acymailing (STAY UP TO DATE)

Time: 0.13 ms / 461.16 ms Memory: -0.036 MB / 6.59 MB Application: beforeRenderModule mod_convertforms (Advice)

Time: 16.55 ms / 477.71 ms Memory: 0.090 MB / 6.68 MB Application: afterRenderModule mod_convertforms (Advice)

Time: 1.79 ms / 479.51 ms Memory: 0.096 MB / 6.78 MB Application: beforeRenderModule mod_custom (Real estate and holiday in Spain)

Time: 0.29 ms / 479.80 ms Memory: 0.003 MB / 6.78 MB Application: afterRenderModule mod_custom (Real estate and holiday in Spain)

Time: 0.19 ms / 479.99 ms Memory: 0.003 MB / 6.79 MB Application: beforeRenderModule mod_falang (FaLang Language Switcher)

Time: 15.38 ms / 495.37 ms Memory: 0.379 MB / 7.16 MB Application: afterRenderModule mod_falang (FaLang Language Switcher)

Time: 0.11 ms / 495.48 ms Memory: -0.006 MB / 7.16 MB Application: beforeRenderModule mod_sr_currency (Currency)

Time: 3.00 ms / 498.47 ms Memory: 0.032 MB / 7.19 MB Application: afterRenderModule mod_sr_currency (Currency)

Time: 0.51 ms / 498.99 ms Memory: -0.006 MB / 7.18 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.29 ms / 499.28 ms Memory: 0.003 MB / 7.19 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.39 ms / 499.67 ms Memory: 0.003 MB / 7.19 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 4.19 ms / 503.85 ms Memory: 0.053 MB / 7.24 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 2.99 ms / 506.84 ms Memory: 0.015 MB / 7.26 MB Application: beforeRenderModule mod_custom (Logo Small)

Time: 0.25 ms / 507.10 ms Memory: 0.003 MB / 7.26 MB Application: afterRenderModule mod_custom (Logo Small)

Time: 0.70 ms / 507.79 ms Memory: 0.017 MB / 7.28 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.59 ms / 509.38 ms Memory: 0.077 MB / 7.36 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.53 ms / 509.91 ms Memory: 0.013 MB / 7.37 MB Application: beforeRenderModule mod_menu (Menu)

Time: 0.86 ms / 510.77 ms Memory: 0.006 MB / 7.37 MB Application: afterRenderModule mod_menu (Menu)

Time: 1.37 ms / 512.14 ms Memory: -0.001 MB / 7.37 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 0.23 ms / 512.37 ms Memory: 0.003 MB / 7.38 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.13 ms / 512.50 ms Memory: 0.001 MB / 7.38 MB Application: beforeRenderModule mod_custom (debug)

Time: 26.58 ms / 539.08 ms Memory: 0.016 MB / 7.39 MB Application: afterRenderModule mod_custom (debug)

Time: 0.10 ms / 539.18 ms Memory: 0.000 MB / 7.39 MB Application: beforeRenderModule mod_custom (fontawesome)

Time: 0.56 ms / 539.75 ms Memory: 0.003 MB / 7.40 MB Application: afterRenderModule mod_custom (fontawesome)

Time: 0.44 ms / 540.19 ms Memory: 0.003 MB / 7.40 MB Application: beforeRenderModule mod_menu (Offcanvas Menu)

Time: 1.45 ms / 541.64 ms Memory: 0.006 MB / 7.40 MB Application: afterRenderModule mod_menu (Offcanvas Menu)

Time: 5.73 ms / 547.37 ms Memory: 0.107 MB / 7.51 MB Application: afterRender

Database queries total: 76.06 ms

Memory Usage

Database Queries

60 Queries Logged 76.06 ms

12 duplicate found!

2 duplicates: #1 #6

2 duplicates: #4 #20

2 duplicates: #24 #26

3 duplicates: #47 #51 #55

3 duplicates: #48 #52 #56

Query Time: 1.77 ms Query memory: 0.043 MB Memory before query: 2.333 MB Rows returned: 24

Duplicate queries: #6

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM cqbns_menu AS m

  LEFT JOIN cqbns_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	84	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.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
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 1.03 ms Query memory: 0.033 MB Memory before query: 2.400 MB Rows returned: 36

SELECT joomlatablename,tablepkID 
  FROM `cqbns_falang_tableinfo`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
28	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
27	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.26 ms Query memory: 0.035 MB Memory before query: 2.419 MB Rows returned: 8

SELECT * 
  FROM cqbns_languages 
  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
28	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
27	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.73 ms Query memory: 0.037 MB Memory before query: 2.516 MB Rows returned: 14

Duplicate queries: #20

SHOW FULL COLUMNS 
  FROM `cqbns_languages`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
35	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
34	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
32	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
30	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
29	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
28	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
27	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.05 ms After last query: 0.80 ms Query memory: 0.031 MB Memory before query: 2.581 MB Rows returned: 8

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

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=7
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(954,306,886,290,925,127,891,129,193,130,243,240,888,890,889,932,102,101,885,128,918,926,933,934)
   
  AND falang_content.reference_table='menu'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
28	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
26	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
25	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.05 ms After last query: 21.38 ms Query memory: 0.039 MB Memory before query: 3.058 MB Rows returned: 24

Duplicate queries: #1

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM cqbns_menu AS m

  LEFT JOIN cqbns_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	84	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.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:1701
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:78
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:597
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:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.46 ms After last query: 1.19 ms Query memory: 0.040 MB Memory before query: 3.114 MB Rows returned: 97

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

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(954,306,886,290,925,127,891,129,193,130,243,240,888,890,889,932,102,101,885,128,918,926,933,934)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	76	10.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:1701
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:78
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:597
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:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 2.80 ms Query memory: 0.029 MB Memory before query: 3.092 MB Rows returned: 1

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

  FROM `cqbns_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

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:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
21	JFalangDatabase->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
20	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
17	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
16	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
15	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:147
11	NRFramework\Functions::isFeed()	JROOT/plugins/system/convertforms/convertforms.php:455
10	PlgSystemConvertForms->getHelper()	JROOT/plugins/system/convertforms/convertforms.php:98
9	PlgSystemConvertForms->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.39 ms Query memory: 0.008 MB Memory before query: 3.076 MB

UPDATE `cqbns_extensions`

  SET `params` = '{\"mediaversion\":\"8fbef877eaae29d5ba5d4b59ef7165ec\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	cqbns_extensions	NULL	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
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
16	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
15	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:147
11	NRFramework\Functions::isFeed()	JROOT/plugins/system/convertforms/convertforms.php:455
10	PlgSystemConvertForms->getHelper()	JROOT/plugins/system/convertforms/convertforms.php:98
9	PlgSystemConvertForms->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 2.39 ms Query memory: 0.028 MB Memory before query: 3.218 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM cqbns_template_styles as s

  LEFT JOIN cqbns_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	60.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	lloret_alexand.s.template,const	1	4.51	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/solidres/solidres.php:40
9	plgSystemSolidres->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.27 ms After last query: 7.82 ms Query memory: 0.032 MB Memory before query: 3.548 MB Rows returned: 46

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

  FROM `cqbns_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_djclassifieds','com_falang','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_newsfeeds','com_nextend2','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_solidres','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	198	23.74	Using where

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:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/plugins/solidres/acl/acl.php:35
13	PlgSolidresACL->authorise()	JROOT/plugins/solidres/acl/acl.php:27
12	PlgSolidresACL->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/solidres/solidres.php:66
9	plgSystemSolidres->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 6.44 ms Query memory: 0.033 MB Memory before query: 3.916 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `cqbns_extensions`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
17	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
16	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:320
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/user/solidres/solidres.php:533
14	plgUserSolidres->onSolidresPluginRegister()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/solidres/solidres.php:67
9	plgSystemSolidres->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 0.38 ms Query memory: 0.032 MB Memory before query: 3.959 MB Rows returned: 1

SELECT *

  FROM cqbns_extensions

  WHERE `name` = 'plg_user_solidres'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_extensions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	400	10.00	Using where

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:1701
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/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
16	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
15	Joomla\CMS\Table\Table->load()	JROOT/plugins/user/solidres/solidres.php:534
14	plgUserSolidres->onSolidresPluginRegister()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/solidres/solidres.php:67
9	plgSystemSolidres->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.79 ms After last query: 10.47 ms Query memory: 0.039 MB Memory before query: 4.551 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM cqbns_fields AS a

  LEFT JOIN `cqbns_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN cqbns_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN cqbns_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN cqbns_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN cqbns_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_users.remind' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	lloret_alexand.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.group_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
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
19	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
18	PlgSystemFields->onContentPrepareForm()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/remind.php:59
13	UsersModelRemind->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/remind.php:34
11	UsersModelRemind->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/remind/view.html.php:37
9	UsersViewRemind->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 6.10 ms Query memory: 0.023 MB Memory before query: 4.653 MB Rows returned: 1

SELECT language,id

  FROM `cqbns_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	85	1.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:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
10	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 4.664 MB Rows returned: 4

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

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(101)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	3	10.00	Using where

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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
13	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
12	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
11	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
10	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.71 ms Query memory: 0.024 MB Memory before query: 4.678 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `cqbns_menu` AS `c`

  INNER JOIN `cqbns_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `cqbns_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `cqbns_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 193

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

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:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.55 ms After last query: 3.53 ms Query memory: 0.032 MB Memory before query: 4.991 MB Rows returned: 20

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM cqbns_modules AS m

  LEFT JOIN cqbns_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN cqbns_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-19 19:06:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 19:06:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 193 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	34	1.04	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	lloret_alexand.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	lloret_alexand.m.id	1	40.00	Using where; Using index

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:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/infinity/layouts/theme.config.php:26
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.35 ms Query memory: 0.031 MB Memory before query: 5.037 MB Rows returned: 16

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

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(169,93,109,103,17,183,202,108,88,113,208,1,111,117,150,142,191,165,96,124)
   
  AND falang_content.reference_table='modules'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	23	10.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:1701
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()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/infinity/layouts/theme.config.php:26
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 5.17 ms Query memory: 0.037 MB Memory before query: 5.239 MB Rows returned: 14

Duplicate queries: #4

SHOW FULL COLUMNS 
  FROM `cqbns_languages`

Explain

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

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:1701
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
27	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Language.php:29
23	Joomla\CMS\Table\Language->__construct()	JROOT/libraries/src/Table/Table.php:320
22	Joomla\CMS\Table\Table::getInstance()	JROOT/modules/mod_sr_advancedsearch/helper.php:42
21	modSRAdvancedsearchHelper::getCities()	JROOT/modules/mod_sr_advancedsearch/mod_sr_advancedsearch.php:33
20	include JROOT/modules/mod_sr_advancedsearch/mod_sr_advancedsearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.39 ms Query memory: 0.036 MB Memory before query: 5.281 MB Rows returned: 1

SELECT *

  FROM cqbns_languages

  WHERE `lang_code` = 'en-GB'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_languages	NULL	const	idx_langcode	idx_langcode	28	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
28	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
26	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
25	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
24	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
23	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
22	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_sr_advancedsearch/helper.php:43
21	modSRAdvancedsearchHelper::getCities()	JROOT/modules/mod_sr_advancedsearch/mod_sr_advancedsearch.php:33
20	include JROOT/modules/mod_sr_advancedsearch/mod_sr_advancedsearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 5.289 MB Rows returned: 0

SELECT DISTINCT value

  FROM `cqbns_falang_content`

  WHERE reference_table = 'sr_reservation_assets' 
  AND reference_field = 'city' 
  AND language_id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_falang_content	NULL	ref	falangContent,language_id,reference_table,reference_field	reference_field	302	const	1	5.00	Using index condition; Using where; Using temporary

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
22	JFalangDatabase->loadColumn()	JROOT/modules/mod_sr_advancedsearch/helper.php:55
21	modSRAdvancedsearchHelper::getCities()	JROOT/modules/mod_sr_advancedsearch/mod_sr_advancedsearch.php:33
20	include JROOT/modules/mod_sr_advancedsearch/mod_sr_advancedsearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 4.27 ms Query memory: 0.038 MB Memory before query: 5.467 MB Rows returned: 4

SELECT * 
  FROM cqbns_djcf_categories 
  WHERE published=1 
  ORDER BY parent_id, ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_djcf_categories	NULL	ref	published	published	4	const	3	100.00	Using index condition; Using filesort

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:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:35
21	modDjClassifiedsSearch::getCats()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:76
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 0.41 ms Query memory: 0.034 MB Memory before query: 5.506 MB Rows returned: 16

Duplicate queries: #26

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

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,2,4,5)
   
  AND falang_content.reference_table='djcf_categories'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	19	10.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
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
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/modules/mod_djclassifieds_search/helper.php:35
21	modDjClassifiedsSearch::getCats()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:76
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.28 ms Query memory: 0.038 MB Memory before query: 5.523 MB Rows returned: 4

SELECT c.* 
  FROM cqbns_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	published	published	4	const	3	50.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
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:623
21	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:92
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.17 ms After last query: 0.24 ms Query memory: 0.034 MB Memory before query: 5.549 MB Rows returned: 16

Duplicate queries: #24

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

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,2,4,5)
   
  AND falang_content.reference_table='djcf_categories'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	19	10.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
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
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/administrator/components/com_djclassifieds/lib/djcategory.php:623
21	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:92
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.31 ms Query memory: 0.031 MB Memory before query: 5.565 MB Rows returned: 0

SELECT i.cat_id, count(i.id) as items_count 
  FROM cqbns_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2024-04-19 22:00:00'  
  GROUP BY i.cat_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	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
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:535
22	DJClassifiedsCategory::getItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:635
21	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:92
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 5.567 MB Rows returned: 0

SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM cqbns_djcf_items_categories ic, cqbns_djcf_items i 
  WHERE ic.item_id=i.id 
  AND i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2024-04-19 22:00:00' 
  GROUP BY ic.cat_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	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
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:644
21	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:92
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.19 ms Query memory: 0.032 MB Memory before query: 5.579 MB Rows returned: 0

SELECT r.* 
  FROM cqbns_djcf_regions r 
  WHERE r.published=1 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

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:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:46
21	modDjClassifiedsSearch::getRegions()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:105
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.18 ms Query memory: 0.031 MB Memory before query: 5.592 MB Rows returned: 1

SELECT t.id as value, t.name as text, '0' as disabled 
  FROM cqbns_djcf_types t 
  WHERE t.published=1 
  ORDER BY t.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

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:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:58
21	modDjClassifiedsSearch::getTypes()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:108
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.24 ms Query memory: 0.032 MB Memory before query: 5.610 MB Rows returned: 1

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

  FROM cqbns_falang_content AS falang_content

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

Explain

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

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:1701
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/modules/mod_djclassifieds_search/helper.php:58
21	modDjClassifiedsSearch::getTypes()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:108
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.15 ms Query memory: 0.031 MB Memory before query: 5.623 MB Rows returned: 0

SELECT g.* 
  FROM cqbns_djcf_fields_groups g 
  WHERE g.source=2 
  ORDER BY g.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

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:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:72
21	modDjClassifiedsSearch::getProfileGroups()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:109
20	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 2.18 ms Query memory: 0.033 MB Memory before query: 5.660 MB Rows returned: 1

SELECT filter_range

  FROM cqbns_sr_currencies

  WHERE id = 2

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_sr_currencies	NULL	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
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
24	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
23	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
22	JFalangDatabase->loadResult()	JROOT/modules/mod_sr_experience_search/helper.php:35
21	ModSRExperienceSearchHelper::getFilterRangeByPrice()	JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php:16
20	include JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.34 ms Query memory: 0.031 MB Memory before query: 5.678 MB Rows returned: 10

SELECT a.id, a.name

  FROM `cqbns_sr_experience_categories` AS `a`

Explain

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

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:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/modules/mod_sr_experience_search/helper.php:99
21	ModSRExperienceSearchHelper::getCategories()	JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php:28
20	include JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.93 ms After last query: 0.30 ms Query memory: 0.033 MB Memory before query: 5.701 MB Rows returned: 10

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

  FROM cqbns_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(1,2,3,4,5,6,7,8,9,10)
   
  AND falang_content.reference_table='sr_experience_categories'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	range	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	NULL	13	10.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
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
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/modules/mod_sr_experience_search/helper.php:99
21	ModSRExperienceSearchHelper::getCategories()	JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php:28
20	include JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 0.36 ms Query memory: 0.031 MB Memory before query: 5.714 MB Rows returned: 12

SELECT DISTINCT a.base_location

  FROM `cqbns_sr_experiences` AS `a`

  WHERE a.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	10.00	Using where; Using temporary

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
22	JFalangDatabase->loadColumn()	JROOT/modules/mod_sr_experience_search/helper.php:78
21	ModSRExperienceSearchHelper::getLocations()	JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php:47
20	include JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.33 ms Query memory: 0.031 MB Memory before query: 5.727 MB Rows returned: 9

SELECT DISTINCT a.end_location

  FROM `cqbns_sr_experiences` AS `a`

  WHERE a.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	10.00	Using where; Using temporary

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
22	JFalangDatabase->loadColumn()	JROOT/modules/mod_sr_experience_search/helper.php:78
21	ModSRExperienceSearchHelper::getLocations()	JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php:70
20	include JROOT/modules/mod_sr_experience_search/mod_sr_experience_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_tabs_gk5/tmpl/module.php:22
18	require JROOT/modules/mod_tabs_gk5/tmpl/module.php	JROOT/modules/mod_tabs_gk5/helper.php:213
17	TabsGK5Helper->moduleRender()	JROOT/modules/mod_tabs_gk5/tmpl/default.php:39
16	require JROOT/modules/mod_tabs_gk5/tmpl/default.php	JROOT/modules/mod_tabs_gk5/helper.php:202
15	TabsGK5Helper->render()	JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php:24
14	include JROOT/modules/mod_tabs_gk5/mod_tabs_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 258.02 ms Query memory: 0.042 MB Memory before query: 5.840 MB Rows returned: 142

SELECT * 
  FROM cqbns_acymailing_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
19	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
18	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
17	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
16	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
15	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
14	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 2.49 ms Query memory: 0.032 MB Memory before query: 6.388 MB Rows returned: 1

SELECT * 
  FROM cqbns_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_acymailing_list	NULL	system	typeorderingindex,typeuseridindex	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
16	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
15	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:148
14	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.26 ms After last query: 1.10 ms Query memory: 0.048 MB Memory before query: 6.510 MB Rows returned: 308

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
23	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
22	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:555
21	acymailing_getTableList()	JROOT/plugins/acymailing/tagcontent/tagcontent.php:22
20	plgAcymailingTagcontent->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_acymailing/compat/joomla.php:666
17	acymailing_importPlugin()	JROOT/administrator/components/com_acymailing/classes/fields.php:32
16	fieldsClass->__construct()	JROOT/administrator/components/com_acymailing/helpers/helper.php:567
15	acymailing_get()	JROOT/modules/mod_acymailing/mod_acymailing.php:239
14	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 1.40 ms Query memory: 0.035 MB Memory before query: 6.610 MB Rows returned: 3

SELECT * 
  FROM `cqbns_acymailing_fields` as a 
  WHERE a.`published` = 1 
  AND (a.access = 'all' OR a.access LIKE ('%,9,%')) 
  ORDER BY a.`ordering` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	orderingindex	orderingindex	1	const	2	55.56	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
16	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:85
15	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:244
14	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.26 ms Query memory: 0.035 MB Memory before query: 6.630 MB Rows returned: 3

SELECT * 
  FROM `cqbns_acymailing_fields`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
16	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:100
15	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:244
14	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 2.21 ms Query memory: 0.035 MB Memory before query: 6.618 MB Rows returned: 1

SELECT *

  FROM `cqbns_convertforms`

  WHERE `id` = 4 
  AND `state` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_convertforms	NULL	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
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
19	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
18	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
17	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:316
16	ConvertForms\Helper::getForm()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:472
15	ConvertForms\Helper::renderFormById()	JROOT/modules/mod_convertforms/mod_convertforms.php:22
14	include JROOT/modules/mod_convertforms/mod_convertforms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 10.77 ms Query memory: 0.030 MB Memory before query: 6.671 MB Rows returned: 1

SELECT count(*)

  FROM cqbns_convertforms_conversions

  WHERE form_id = 4 
  AND state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_convertforms_conversions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	20	5.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
23	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
22	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
21	JFalangDatabase->loadResult()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:53
20	ConvertForms\Helper::getFormLeadsCount()	JROOT/administrator/components/com_convertforms/ConvertForms/SmartTags.php:81
19	ConvertForms\SmartTags::prepare()	JROOT/administrator/components/com_convertforms/ConvertForms/SmartTags.php:89
18	ConvertForms\SmartTags::replace()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:337
17	ConvertForms\Helper::prepareForm()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:491
16	ConvertForms\Helper::renderForm()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:479
15	ConvertForms\Helper::renderFormById()	JROOT/modules/mod_convertforms/mod_convertforms.php:22
14	include JROOT/modules/mod_convertforms/mod_convertforms.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/layouts/theme.config.php:72
10	include JROOT/templates/infinity/layouts/theme.config.php	JROOT/templates/infinity/layouts/theme.php:10
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 6.92 ms Query memory: 0.029 MB Memory before query: 6.816 MB Rows returned: 2

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 8 
  AND fc.reference_field = 'params' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContentLanguage	612	const,const,const,const	1	10.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:183
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.34 ms Query memory: 0.029 MB Memory before query: 6.831 MB Rows returned: 2

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 8 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContentLanguage	612	const,const,const,const	2	10.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:342
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 6.843 MB Rows returned: 1

Duplicate queries: #51 #55

SELECT m.path

  FROM cqbns_menu m

  WHERE m.id = 193

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	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
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:351
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 6.857 MB Rows returned: 1

Duplicate queries: #52 #56

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 1 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContentLanguage	612	const,const,const,const	1	10.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:367
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.35 ms Query memory: 0.029 MB Memory before query: 6.868 MB Rows returned: 1

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 4 
  AND fc.reference_field = 'params' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContentLanguage	612	const,const,const,const	1	10.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:183
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.33 ms Query memory: 0.029 MB Memory before query: 6.881 MB Rows returned: 1

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 4 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContentLanguage	612	const,const,const,const	1	10.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:342
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.13 ms Query memory: 0.029 MB Memory before query: 6.893 MB Rows returned: 1

Duplicate queries: #47 #55

SELECT m.path

  FROM cqbns_menu m

  WHERE m.id = 193

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	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
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:351
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 6.907 MB Rows returned: 1

Duplicate queries: #48 #56

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 1 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContentLanguage	612	const,const,const,const	1	10.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:367
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 6.916 MB Rows returned: 0

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 7 
  AND fc.reference_field = 'params' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	5.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:183
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.40 ms Query memory: 0.029 MB Memory before query: 6.928 MB Rows returned: 0

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 7 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContent	310	const,const,const	1	5.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:342
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 6.939 MB Rows returned: 1

Duplicate queries: #47 #51

SELECT m.path

  FROM cqbns_menu m

  WHERE m.id = 193

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	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
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:351
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.43 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 6.954 MB Rows returned: 1

Duplicate queries: #48 #52

SELECT fc.value

  FROM cqbns_falang_content fc

  WHERE fc.reference_id = 193 
  AND fc.language_id = 1 
  AND fc.reference_field = 'path' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	falangContentLanguage	612	const,const,const,const	1	10.00	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:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
18	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:367
17	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:30
16	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 8.44 ms Query memory: 0.030 MB Memory before query: 7.191 MB Rows returned: 3

SELECT u.*

  FROM `cqbns_sr_currencies` AS u

  WHERE u.state = 1

  ORDER BY u.currency_name ASC

Explain

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

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:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/modules/mod_sr_currency/mod_sr_currency.php:25
16	include JROOT/modules/mod_sr_currency/mod_sr_currency.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:32
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 25.17 ms After last query: 14.88 ms Query memory: 0.042 MB Memory before query: 7.398 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM cqbns_fields AS a

  LEFT JOIN `cqbns_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN cqbns_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN cqbns_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN cqbns_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN cqbns_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	lloret_alexand.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	lloret_alexand.a.group_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
32	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
31	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
29	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
20	JHtmlContent::prepare()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
16	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/infinity/warp/systems/joomla/layouts/widgets.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/infinity/layouts/theme.php:222
9	include JROOT/templates/infinity/layouts/theme.php	JROOT/templates/infinity/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/infinity/index.php:16
7	require JROOT/templates/infinity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.26 ms After last query: 6.38 ms Query memory: 0.024 MB Memory before query: 7.443 MB Rows returned: 1

SELECT data_key, data_value

  FROM `cqbns_sr_config_data`

  WHERE scope_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cqbns_sr_config_data	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1039	10.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/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:246
11	JFalangDatabase->loadRowList()	JROOT/libraries/solidres/config/config.php:153
10	SRConfig->loadFromDb()	JROOT/libraries/solidres/config/config.php:60
9	SRConfig->__construct()	JROOT/plugins/system/solidres/solidres.php:266
8	plgSystemSolidres->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

38 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

9 × SELECT fc.value 
  FROM cqbns_falang_content fc

8 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
  FROM cqbns_falang_content AS falang_content

3 × SELECT m.path 
  FROM cqbns_menu m

2 × 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 cqbns_menu AS m 
  LEFT JOIN cqbns_extensions AS e 
  ON m.component_id = e.extension_id

```
2 × SELECT * 
  FROM cqbns_languages
```

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM cqbns_fields AS a 
  LEFT JOIN `cqbns_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cqbns_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cqbns_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cqbns_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cqbns_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT * 
  FROM cqbns_acymailing_list

1 × SELECT a.id, a.name 
  FROM `cqbns_sr_experience_categories` AS `a

1 × SELECT DISTINCT a.base_location 
  FROM `cqbns_sr_experiences` AS `a`

1 × SELECT DISTINCT a.end_location 
  FROM `cqbns_sr_experiences` AS `a`

1 × SELECT * 
  FROM cqbns_acymailing_confi

1 × SELECT * 
  FROM `cqbns_convertforms`

1 × SELECT * 
  FROM `cqbns_acymailing_fields` as a

1 × SELECT * 
  FROM `cqbns_acymailing_fields

1 × SELECT g.* 
  FROM cqbns_djcf_fields_groups g

1 × SELECT count(*) 
  FROM cqbns_convertforms_conversions

1 × SELECT u.* 
  FROM `cqbns_sr_currencies` AS u

1 × SELECT filter_range 
  FROM cqbns_sr_currencies

1 × SELECT r.* 
  FROM cqbns_djcf_regions r

1 × SELECT t.id as value, t.name as text, '0' as disabled 
  FROM cqbns_djcf_types t

1 × SELECT joomlatablename,tablepkID 
  FROM `cqbns_falang_tableinfo

1 × SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM cqbns_djcf_items_categories ic, cqbns_djcf_items i

1 × SELECT i.cat_id, count(i.id) as items_count 
  FROM cqbns_djcf_items i

1 × SELECT c.* 
  FROM cqbns_djcf_categories c

1 × SELECT * 
  FROM cqbns_djcf_categories

1 × SELECT DISTINCT value 
  FROM `cqbns_falang_content`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM cqbns_modules AS m 
  LEFT JOIN cqbns_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN cqbns_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `cqbns_menu` AS `c` 
  INNER JOIN `cqbns_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `cqbns_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `cqbns_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `cqbns_menu`

```
1 × SELECT * 
  FROM cqbns_extensions
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `cqbns_assets`

1 × SELECT id, home, template, s.params 
  FROM cqbns_template_styles as s 
  LEFT JOIN cqbns_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `cqbns_extensions`

1 × SELECT data_key, data_value 
  FROM `cqbns_sr_config_data`

OTHER Tables:

2 × SHOW FULL COLUMNS 
  FROM `cqbns_languages

1 × UPDATE `cqbns_extensions` 
  SET `params` = '{\"mediaversion\":\"8fbef877eaae29d5ba5d4b59ef7165ec\"}'

1 × SHOW FULL COLUMNS 
  FROM `cqbns_extensions

```
1 × SHOW TABLE
```