Car Rental "Sfakia tours"

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1780748282,
                "last": 1780748283,
                "now": 1780748283
            },
            "token": "yHzgU4u1qIPRRnpj1wVHFZc4Zy72tZfz"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        },
        "vrcfaw": "1",
        "vrcTFP": "56358971faf67bb9545380a11e377fce",
        "vrcTidentifier": 1780748282,
        "vrcTreferrer": "",
        "setDropDatePlus": "",
        "loadJquery": "1",
        "getTimeFormat": "H:i",
        "showPlacesFront": "1",
        "vrcMultiLang": "1",
        "vrcfirstWeekDay": "0",
        "vrcminDaysAdvance": "1",
        "vrcmaxDateFuture": "+1y",
        "showCategoriesFront": "1",
        "getSubmitName": "Search",
        "getSubmitClass": "button"
    }
}

Profile Information

Memory Usage

Database Queries

20 Queries Logged 1.92 ms

10 duplicate found!

2 duplicates: #3 #4

2 duplicates: #5 #6

2 duplicates: #7 #8

2 duplicates: #9 #10

2 duplicates: #11 #12

Query Time: 0.33 ms Query memory: 0.005 MB Memory before query: 8.211 MB

UPDATE `jos4c_extensions`

  SET `params` = '{\"mediaversion\":\"33337edeb3a918b93243c1d016b9d177\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `jos4c_extensions` SET `params` = '{\"mediaversion\":\"33337edeb3a918b93243c1d016b9d177\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.08 ms After last query: 12.82 ms Query memory: 0.005 MB Memory before query: 10.286 MB


  SET SQL_BIG_SELECTS=1

Explain

EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
9	JFalangDatabase->execute()	JROOT/administrator/components/com_vikrentcar/helpers/jv_helper.php:361
8	VrcApplication->normalizeDbDriver()	JROOT/administrator/components/com_vikrentcar/helpers/jv_helper.php:73
7	VrcApplication->normalizeExecution()	JROOT/components/com_vikrentcar/vikrentcar.php:36
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.09 ms After last query: 0.63 ms Query memory: 0.007 MB Memory before query: 10.383 MB Rows returned: 1

Duplicate queries: #4

SELECT `param`, `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param` IN ('trkcampaigns');

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/components/com_vikrentcar/helpers/tracker.php:840
12	VikRentCarTracker::loadSettings()	JROOT/components/com_vikrentcar/helpers/tracker.php:864
11	VikRentCarTracker::loadCampaigns()	JROOT/components/com_vikrentcar/helpers/tracker.php:226
10	VikRentCarTracker->getReferrer()	JROOT/components/com_vikrentcar/helpers/tracker.php:74
9	VikRentCarTracker->__construct()	JROOT/components/com_vikrentcar/helpers/tracker.php:87
8	VikRentCarTracker::getInstance()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:265
7	VikRentCar::getTracker()	JROOT/components/com_vikrentcar/vikrentcar.php:45
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.05 ms After last query: 0.14 ms Query memory: 0.008 MB Memory before query: 10.392 MB Rows returned: 1

Duplicate queries: #3

SELECT `param`, `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param` IN ('trkcampaigns');

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
13	JFalangDatabase->loadAssocList()	JROOT/components/com_vikrentcar/helpers/tracker.php:844
12	VikRentCarTracker::loadSettings()	JROOT/components/com_vikrentcar/helpers/tracker.php:864
11	VikRentCarTracker::loadCampaigns()	JROOT/components/com_vikrentcar/helpers/tracker.php:226
10	VikRentCarTracker->getReferrer()	JROOT/components/com_vikrentcar/helpers/tracker.php:74
9	VikRentCarTracker->__construct()	JROOT/components/com_vikrentcar/helpers/tracker.php:87
8	VikRentCarTracker::getInstance()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:265
7	VikRentCar::getTracker()	JROOT/components/com_vikrentcar/vikrentcar.php:45
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.05 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 10.401 MB Rows returned: 1

Duplicate queries: #6

SELECT `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param`='pref_colors';

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
9	JFalangDatabase->execute()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:8324
8	VikRentCar::getPreferredColors()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:8348
7	VikRentCar::loadPreferredColorStyles()	JROOT/components/com_vikrentcar/vikrentcar.php:46
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.05 ms After last query: 0.04 ms Query memory: 0.007 MB Memory before query: 10.406 MB Rows returned: 1

Duplicate queries: #5

SELECT `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param`='pref_colors';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	117	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:416
11	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
10	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
9	JFalangDatabase->loadResult()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:8326
8	VikRentCar::getPreferredColors()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:8348
7	VikRentCar::loadPreferredColorStyles()	JROOT/components/com_vikrentcar/vikrentcar.php:46
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.07 ms After last query: 2.91 ms Query memory: 0.006 MB Memory before query: 10.825 MB Rows returned: 9

Duplicate queries: #8

SELECT * 
  FROM `jos4c_vikrentcar_places` 
  ORDER BY `jos4c_vikrentcar_places`.`ordering` ASC, `jos4c_vikrentcar_places`.`name` ASC;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_places	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
11	JFalangDatabase->execute()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:22
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.05 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 10.831 MB Rows returned: 9

Duplicate queries: #7

SELECT * 
  FROM `jos4c_vikrentcar_places` 
  ORDER BY `jos4c_vikrentcar_places`.`ordering` ASC, `jos4c_vikrentcar_places`.`name` ASC;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_places	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
11	JFalangDatabase->loadAssocList()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:24
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.05 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 10.853 MB Rows returned: 1

Duplicate queries: #10

SELECT `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param`='theme';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	117	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/components/com_vikrentcar/helpers/lib.vikrentcar.php:319
11	VikRentCar::getTheme()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:35
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.06 ms After last query: 0.03 ms Query memory: 0.007 MB Memory before query: 10.860 MB Rows returned: 1

Duplicate queries: #9

SELECT `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param`='theme';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	117	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:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
12	JFalangDatabase->loadAssocList()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:320
11	VikRentCar::getTheme()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:35
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.16 ms Query memory: 0.008 MB Memory before query: 10.895 MB Rows returned: 1

Duplicate queries: #12

SELECT `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param`='gmapskey' 
  LIMIT 1;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	117	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/components/com_vikrentcar/helpers/lib.vikrentcar.php:329
14	VikRentCar::getGoogleMapsKey()	JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php:24
13	include JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:43
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.05 ms After last query: 0.05 ms Query memory: 0.010 MB Memory before query: 10.903 MB Rows returned: 1

Duplicate queries: #11

SELECT `setting` 
  FROM `jos4c_vikrentcar_config` 
  WHERE `param`='gmapskey' 
  LIMIT 1;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	117	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/plugins/system/falangdriver/falang_database.php:416
17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
15	JFalangDatabase->loadResult()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:331
14	VikRentCar::getGoogleMapsKey()	JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php:24
13	include JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:43
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.06 ms After last query: 0.64 ms Query memory: 0.009 MB Memory before query: 10.962 MB Rows returned: 0

SELECT `setting`

  FROM `jos4c_vikrentcar_config`

  WHERE `param` = 'measurment_driver' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	117	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/administrator/components/com_vikrentcar/helpers/src/config/registry/database.php:75
16	VRCConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikrentcar/helpers/src/config/registry.php:75
15	VRCConfigRegistry->get()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:2699
14	VikRentCar::printTrackingCode()	JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php:91
13	include JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:43
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.04 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 10.971 MB Rows returned: 0

SELECT `setting`

  FROM `jos4c_vikrentcar_config`

  WHERE `param` = 'measurment_params' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_vikrentcar_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	117	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/administrator/components/com_vikrentcar/helpers/src/config/registry/database.php:75
16	VRCConfigRegistryDatabase->retrieve()	JROOT/administrator/components/com_vikrentcar/helpers/src/config/registry.php:75
15	VRCConfigRegistry->get()	JROOT/components/com_vikrentcar/helpers/lib.vikrentcar.php:2700
14	VikRentCar::printTrackingCode()	JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php:91
13	include JROOT/components/com_vikrentcar/views/locationsmap/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_vikrentcar/views/locationsmap/view.html.php:43
10	VikrentcarViewLocationsmap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_vikrentcar/controller.php:37
8	VikRentCarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_vikrentcar/vikrentcar.php:51
6	require_once JROOT/components/com_vikrentcar/vikrentcar.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:203
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.05 ms After last query: 0.24 ms Query memory: 0.006 MB Memory before query: 10.943 MB Rows returned: 1

SELECT language,id

  FROM `jos4c_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	14	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
11	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.06 ms After last query: 0.54 ms Query memory: 0.008 MB Memory before query: 11.089 MB Rows returned: 10

SELECT joomlatablename,tablepkID 
  FROM `jos4c_falang_tableinfo`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:138
13	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
12	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
11	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.05 ms After last query: 0.06 ms Query memory: 0.009 MB Memory before query: 11.100 MB Rows returned: 6

SELECT * 
  FROM jos4c_languages 
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos4c_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:313
13	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
12	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
11	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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: 1.10 ms Query memory: 0.009 MB Memory before query: 11.285 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `jos4c_languages`

Explain

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

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/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
14	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
13	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
12	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
11	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.06 ms After last query: 0.36 ms Query memory: 0.007 MB Memory before query: 11.343 MB Rows returned: 0

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

  FROM jos4c_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	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:277
12	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
11	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.]

10 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

8 × SELECT `setting` 
  FROM `jos4c_vikrentcar_config`

2 × SELECT `param`, `setting` 
  FROM `jos4c_vikrentcar_config`

2 × SELECT * 
  FROM `jos4c_vikrentcar_places`

1 × SELECT language,id 
  FROM `jos4c_menu`

1 × SELECT joomlatablename,tablepkID 
  FROM `jos4c_falang_tableinfo

```
1 × SELECT * 
  FROM jos4c_languages
```

1 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
  FROM jos4c_falang_content AS falang_content

OTHER Tables:

1 × UPDATE `jos4c_extensions` 
  SET `params` = '{\"mediaversion\":\"33337edeb3a918b93243c1d016b9d177\"}'

```
1 × 
  SET SQL_BIG_SELECTS=
```

1 × SHOW FULL COLUMNS 
  FROM `jos4c_languages