Romantic getaways in the South of France in 2022

Filters Applied:

Romantic getaways Clear All

Romantic getaways | Villas with pools

122,00 € / per Night

Great! 1 Reviews

4.8

La Violette - luxury gites for honeymoon in France (sleeps 2)
Ref: 572

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceLanguedocCevennes Carnas`

If you are looking for a romantic getaway or the perfect location for your honeymoon in France, then these luxury gites are the obvious choice....

Romantic getaways | Villas with pools

122,00 € / per Night

Great! 1 Reviews

4.7

La Jonquille - French gites to rent for romantic holidays, France
Ref: 573

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceLanguedocMontpellier Carnas

These French gites to rent in South France are located between Nimes and Montpellier, near the small medieval town of Sommieres. The gites are situated...

Romantic getaways | Villas with pools

139,00 € / per Night

Great! 1 Reviews

4.8

L'Iris - luxury gite rental South France with pool (sleeps 2)
Ref: 574

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceLanguedocNimes Carnas

L´Iris is a luxurygite rental property in South France, located between Nimes and Montpellier, close to the medieval town of Sommieres. The gite is situated...

Romantic getaways | Villas with pools

107,00 € / per Night

Great! 1 Reviews

4.7

L'Anémone beautiful French gites for rent, South France (sleeps 2)
Ref: 575

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceLanguedocNimes Carnas

L´Anemone French gite for rent is located within a former monastery, Le Domaine de Monteils, located in between Nimes & Montpellier in South France. There...

Romantic getaways | Villas with pools

113,00 € / per Night

Fantastic!!! 3 Reviews

5.0

Les Corbieres French holiday gites near Carcassonne with pool
Ref: 865

Sleeps: 4

Bedrooms: 2

Bathrooms: 1

FranceLanguedocCarcassonne Ferrals les Corbieres

These French holiday gites near Carcassonne are located in the heart of Ferrals les Corbieres, a rural village, in the Aude department of Languedoc Rousillion....

Romantic getaways | Villas with pools

114,00 € / per Night

Great! 1 Reviews

4.6

Maison de la Roche gites in France with pool sleeps 4
Ref: 1504

Sleeps: 4

Bedrooms: 2

Bathrooms: 1

FranceLanguedocCarcassonne Ferrals-les-Corbieres

Maison de la Roche gite in Southern France with pool is situated in the quaint wine making village of Ferrals-les-Corbieres, in between the mountains and...

Romantic getaways | Villas with pools

146,00 € / per Night

Fantastic!!! 3 Reviews

5.0

Villa Colibri - Sommieres French villas to rent with pools sleeps 4
Ref: 1577

Sleeps: 4

Bedrooms: 1

Bathrooms: 1

FranceLanguedocMontpellier Sommieres

Villa Colibri is a fabulous 1 bedroom villa to rent with large swimming pool in Sommieres, South France. his French villa can sleep 4 people...

Romantic getaways | Villas with pools

146,00 € / per Night

Fantastic!!! 1 Reviews

5.0

Villa Paon - South of France villas to rent in Sommieres with pools
Ref: 1578

Sleeps: 1

Bedrooms: 1

Bathrooms: 1

FranceLanguedocMontpellier Sommieres

These South of France villas to rent in Sommieres, come with a large swimming pool and a private hot tub/jacuzzi. There are two villas to...

Romantic getaways | Villas with pools

164,00 € / per Night

Le Bel Apartment - holiday apartment South France with jacuzzi
Ref: 1627

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceLanguedocMontpellier Carnas

Le Bel Apartment is a luxury holiday property in South France, close to Nimes and Montpellier. Inside the apartment, you have your own private Jacuzzi...

Romantic getaways | Villas with pools

91,00 € / per Night

Great! 1 Reviews

4.5

Le Jasmin - French gites with pools Sommieres (sleeps 2)
Ref: 571

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceLanguedocCevennes Sommieres

Le Jasmin is a 1 bedroom French gite with pool located at a former monastery near the small medieval town of Sommieres in South France....

Romantic getaways | Gites

80,00 € / per Night

Fantastic!!! 1 Reviews

5.0

La Cour - Provence holiday apartments to rent South France
Ref: 210

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceProvenceUzes St Maximin, Uzes

These beautiful holiday apartments to rent in Provence, South France, are situated in the charming little village of St. Maximin, close to Uzes. The medieval village...

Romantic getaways | Apartments

65,00 € / per Night

Apartment Canabasserie - Pezenas France with large roof terrace
Ref: 1964

Sleeps: 4

Bedrooms: 1

Bathrooms: 1

FranceLanguedocPezenas Rue Canabasserie

Apartment Canabasserie is a stunning 1 bedroom apartment with a large roof terrace right in the heart of the historic centre of Pezenas in South...

Search accommodation

Popular accommodation

Maison Kipling large holiday rental with private pool in South France

FranceLanguedocPezenas

Moulin de Conas - Chateau for rent Pezenas South France

FranceLanguedocPezenas

Le Petit-Versailles villa Pezenas France with private pool

FranceLanguedocPezenas

Villa Cerisier South France with private pool, air con

FranceLanguedocPezenas

La Poste Gabian - holiday home South France with pool

FranceLanguedocPezenas

South France Holidays

COTE D'AZUR RENTALS

PROVENCE RENTALS

LANGUEDOC HOLIDAY RENTALS

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1642533587,
                "last": 1642533587,
                "now": 1642533587
            },
            "client": {
                "forwarded": "3.81.172.77"
            },
            "token": "ZCAq5bD4u0KdrBDFoDKDCMNl3xfHIt9h"
        },
        "registry": {
            "com_jomholiday": {
                "items": {
                    "list": {
                        "limitstart": 0
                    },
                    "filter": {
                        "categories_id": "180",
                        "categories_type_id": "0"
                    }
                }
            }
        },
        "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
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Profile Information

Time

Memory

Time: 7.73 ms / 7.73 ms Memory: 0.408 MB / 0.74 MB Application: afterLoad

Time: 44.62 ms / 52.35 ms Memory: 2.215 MB / 2.95 MB Application: afterInitialise

Time: 25.47 ms / 77.82 ms Memory: 0.936 MB / 3.89 MB Application: Before Access::preloadComponents (all components)

Time: 1.44 ms / 79.26 ms Memory: 0.044 MB / 3.94 MB Application: After Access::preloadComponents (all components)

Time: 3.64 ms / 82.90 ms Memory: 0.104 MB / 4.04 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.26 ms / 83.16 ms Memory: 0.008 MB / 4.05 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 0.48 ms / 83.64 ms Memory: -0.001 MB / 4.05 MB Application: afterRoute

Time: 1.22 ms / 84.86 ms Memory: 0.041 MB / 4.09 MB Application: beforeRenderComponent com_jomholiday

Time: 384.12 ms / 468.98 ms Memory: 2.005 MB / 6.09 MB Application: afterRenderComponent com_jomholiday

Time: 11.80 ms / 480.78 ms Memory: 0.134 MB / 6.23 MB Application: afterDispatch

Time: 16.03 ms / 496.81 ms Memory: 0.609 MB / 6.84 MB Application: beforeRenderModule mod_custom (Front slideshow text)

Time: 0.77 ms / 497.58 ms Memory: 0.006 MB / 6.84 MB Application: afterRenderModule mod_custom (Front slideshow text)

Time: 0.18 ms / 497.76 ms Memory: 0.002 MB / 6.84 MB Application: beforeRenderModule mod_custom (Footer CD)

Time: 0.18 ms / 497.94 ms Memory: 0.003 MB / 6.85 MB Application: afterRenderModule mod_custom (Footer CD)

Time: 2.33 ms / 500.27 ms Memory: 0.052 MB / 6.90 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.21 ms / 500.48 ms Memory: 0.003 MB / 6.90 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.23 ms / 500.71 ms Memory: 0.003 MB / 6.90 MB Application: beforeRenderModule mod_menu (Main)

Time: 21.68 ms / 522.39 ms Memory: 0.348 MB / 7.25 MB Application: afterRenderModule mod_menu (Main)

Time: 4.82 ms / 527.21 ms Memory: 0.013 MB / 7.27 MB Application: beforeRenderModule mod_custom (Login bar)

Time: 0.26 ms / 527.48 ms Memory: 0.003 MB / 7.27 MB Application: afterRenderModule mod_custom (Login bar)

Time: 0.22 ms / 527.69 ms Memory: 0.001 MB / 7.27 MB Application: beforeRenderModule mod_custom (Logo Mini)

Time: 0.17 ms / 527.86 ms Memory: 0.003 MB / 7.27 MB Application: afterRenderModule mod_custom (Logo Mini)

Time: 0.48 ms / 528.34 ms Memory: -0.013 MB / 7.26 MB Application: beforeRenderModule mod_jomholiday_search (Search accommodation)

Time: 21.65 ms / 549.98 ms Memory: 0.254 MB / 7.51 MB Application: afterRenderModule mod_jomholiday_search (Search accommodation)

Time: 0.10 ms / 550.08 ms Memory: -0.013 MB / 7.50 MB Application: beforeRenderModule mod_jomholiday_items (Popular accommodation)

Time: 24620.35 ms / 25170.43 ms Memory: 0.063 MB / 7.56 MB Application: afterRenderModule mod_jomholiday_items (Popular accommodation)

Time: 0.11 ms / 25170.54 ms Memory: -0.005 MB / 7.56 MB Application: beforeRenderModule mod_custom (South France Holidays)

Time: 0.28 ms / 25170.82 ms Memory: 0.003 MB / 7.56 MB Application: afterRenderModule mod_custom (South France Holidays)

Time: 0.82 ms / 25171.64 ms Memory: 0.034 MB / 7.60 MB Application: beforeRenderModule mod_menu (Menu offcanvas)

Time: 3.03 ms / 25174.67 ms Memory: 0.008 MB / 7.60 MB Application: afterRenderModule mod_menu (Menu offcanvas)

Time: 10354.74 ms / 35529.41 ms Memory: 0.475 MB / 8.08 MB Application: beforeProcess plgSystem (JCH Optimize)

Time: 0.41 ms / 35529.82 ms Memory: 0.023 MB / 8.10 MB Application: afterSetUpExcludes plgSystem (JCH Optimize)

Time: 11.68 ms / 35541.49 ms Memory: 0.313 MB / 8.41 MB Application: afterProcessImageAttributes plgSystem (JCH Optimize)

Time: 9.30 ms / 35550.80 ms Memory: 0.003 MB / 8.42 MB Application: afterRunCronTasks plgSystem (JCH Optimize)

Time: 0.23 ms / 35551.03 ms Memory: 0.021 MB / 8.44 MB Application: beforeGetContents - css plgSystem (JCH Optimize)

Time: 33.82 ms / 35584.85 ms Memory: 0.028 MB / 8.47 MB Application: afterCombineFile - /plugins/system/jce/css/content.css plgSystem (JCH Optimize)

Time: 25.67 ms / 35610.52 ms Memory: -0.000 MB / 8.47 MB Application: afterCombineFile - /media/cms/css/debug.css plgSystem (JCH Optimize)

Time: 0.63 ms / 35611.15 ms Memory: -0.002 MB / 8.47 MB Application: afterCombineFile - .../com_jchoptimize/css/pro-ls.effects.css plgSystem (JCH Optimize)

Time: 4.46 ms / 35615.60 ms Memory: 0.009 MB / 8.47 MB Application: afterCombineFile - /media/system/css/fields/calendar.css plgSystem (JCH Optimize)

Time: 11.20 ms / 35626.80 ms Memory: -0.001 MB / 8.47 MB Application: afterCombineFile - .../mod_jomholiday_items.css plgSystem (JCH Optimize)

Time: 8.37 ms / 35635.17 ms Memory: 0.005 MB / 8.48 MB Application: afterCombineFile - Style Declaration plgSystem (JCH Optimize)

Time: 0.37 ms / 35635.54 ms Memory: 0.018 MB / 8.50 MB Application: afterProcessCssUrls plgSystem (JCH Optimize)

Time: 939.35 ms / 36574.89 ms Memory: -0.000 MB / 8.50 MB Application: afterCalculateSprite plgSystem (JCH Optimize)

Time: 0.07 ms / 36574.96 ms Memory: 0.001 MB / 8.50 MB Application: afterGenerateSprite plgSystem (JCH Optimize)

Time: 12.63 ms / 36587.58 ms Memory: -0.036 MB / 8.46 MB Application: afterGetCombinedFiles - css plgSystem (JCH Optimize)

Time: 9.33 ms / 36596.91 ms Memory: 0.019 MB / 8.48 MB Application: afterCreateStaticFiles - css plgSystem (JCH Optimize)

Time: 79.06 ms / 36675.97 ms Memory: 0.239 MB / 8.72 MB Application: afterOptimizeCssDelivery plgSystem (JCH Optimize)

Time: 2.91 ms / 36678.88 ms Memory: -0.229 MB / 8.49 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 188.18 ms / 36867.06 ms Memory: 0.300 MB / 8.79 MB Application: afterCombineFile - /media/jui/js/jquery.js plgSystem (JCH Optimize)

Time: 7.26 ms / 36874.32 ms Memory: -0.147 MB / 8.64 MB Application: afterCombineFile - /media/jui/js/jquery-noconflict.js plgSystem (JCH Optimize)

Time: 28.56 ms / 36902.88 ms Memory: 0.032 MB / 8.67 MB Application: afterCombineFile - /media/jui/js/jquery-migrate.js plgSystem (JCH Optimize)

Time: 12.05 ms / 36914.93 ms Memory: -0.033 MB / 8.64 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 2.34 ms / 36917.27 ms Memory: 0.099 MB / 8.74 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.27 ms / 36917.54 ms Memory: -0.164 MB / 8.58 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 0.47 ms / 36918.02 ms Memory: -0.079 MB / 8.50 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 6.89 ms / 36924.90 ms Memory: 0.034 MB / 8.53 MB Application: afterCombineFile - /media/system/js/core-uncompressed.js plgSystem (JCH Optimize)

Time: 0.30 ms / 36925.20 ms Memory: -0.033 MB / 8.50 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 0.38 ms / 36925.59 ms Memory: 0.099 MB / 8.60 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.21 ms / 36925.79 ms Memory: -0.015 MB / 8.58 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 10.94 ms / 36936.74 ms Memory: -0.079 MB / 8.50 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 60.01 ms / 36996.75 ms Memory: 0.222 MB / 8.73 MB Application: afterCombineFile - .../system/js/mootools-core-uncompressed.js plgSystem (JCH Optimize)

Time: 91.96 ms / 37088.71 ms Memory: 0.392 MB / 9.12 MB Application: afterCombineFile - .../system/js/mootools-more-uncompressed.js plgSystem (JCH Optimize)

Time: 3.21 ms / 37091.91 ms Memory: -0.268 MB / 8.85 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 3.20 ms / 37095.12 ms Memory: 0.099 MB / 8.95 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.23 ms / 37095.35 ms Memory: -0.359 MB / 8.59 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 2.74 ms / 37098.10 ms Memory: -0.068 MB / 8.52 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 16.72 ms / 37114.81 ms Memory: 0.073 MB / 8.59 MB Application: afterCombineFile - /media/jui/js/bootstrap.js plgSystem (JCH Optimize)

Time: 1.60 ms / 37116.41 ms Memory: -0.034 MB / 8.56 MB Application: afterCombineFile - /media/com_jchoptimize/js/ls.loader.js plgSystem (JCH Optimize)

Time: 1.44 ms / 37117.86 ms Memory: 0.001 MB / 8.56 MB Application: afterCombineFile - .../js/pro-ls.loader.effects.js plgSystem (JCH Optimize)

Time: 2.70 ms / 37120.55 ms Memory: 0.032 MB / 8.59 MB Application: afterCombineFile - /media/com_jchoptimize/js/lazysizes.js plgSystem (JCH Optimize)

Time: 1.78 ms / 37122.33 ms Memory: -0.014 MB / 8.58 MB Application: afterCombineFile - .../system/js/fields/calendar-locales/en.js plgSystem (JCH Optimize)

Time: 4.85 ms / 37127.19 ms Memory: 0.016 MB / 8.60 MB Application: afterCombineFile - .../date/gregorian/date-helper.js plgSystem (JCH Optimize)

Time: 3.02 ms / 37130.20 ms Memory: 0.052 MB / 8.65 MB Application: afterCombineFile - /media/system/js/fields/calendar.js plgSystem (JCH Optimize)

Time: 4.64 ms / 37134.84 ms Memory: -0.015 MB / 8.63 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 8.00 ms / 37142.84 ms Memory: 0.169 MB / 8.80 MB Application: afterCombineFile - https://www.googletagmanager.com/gtag/js plgSystem (JCH Optimize)

Time: 2.05 ms / 37144.89 ms Memory: -0.089 MB / 8.71 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 4.79 ms / 37149.68 ms Memory: 0.001 MB / 8.71 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 16.60 ms / 37166.28 ms Memory: 0.110 MB / 8.82 MB Application: afterCombineFile - .../warp/vendor/uikit/js/uikit.js plgSystem (JCH Optimize)

Time: 1.84 ms / 37168.12 ms Memory: -0.046 MB / 8.78 MB Application: afterCombineFile - .../vendor/uikit/js/components/tooltip.js plgSystem (JCH Optimize)

Time: 5.58 ms / 37173.70 ms Memory: 0.009 MB / 8.79 MB Application: afterCombineFile - .../vendor/uikit/js/components/sticky.js plgSystem (JCH Optimize)

Time: 5.19 ms / 37178.90 ms Memory: 0.017 MB / 8.80 MB Application: afterCombineFile - .../vendor/uikit/js/components/slideshow.js plgSystem (JCH Optimize)

Time: 6.12 ms / 37185.01 ms Memory: 0.001 MB / 8.80 MB Application: afterCombineFile - .../vendor/uikit/js/components/parallax.js plgSystem (JCH Optimize)

Time: 5.04 ms / 37190.05 ms Memory: -0.002 MB / 8.80 MB Application: afterCombineFile - .../cd_travellist/warp/js/social.js plgSystem (JCH Optimize)

Time: 9.82 ms / 37199.87 ms Memory: 0.001 MB / 8.80 MB Application: afterCombineFile - /templates/cd_travellist/js/theme.js plgSystem (JCH Optimize)

Time: 9.59 ms / 37209.47 ms Memory: -0.000 MB / 8.80 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 19.40 ms / 37228.86 ms Memory: 0.001 MB / 8.80 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 14.86 ms / 37243.73 ms Memory: 0.001 MB / 8.81 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 9.98 ms / 37253.71 ms Memory: 0.006 MB / 8.81 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 14.37 ms / 37268.07 ms Memory: 0.001 MB / 8.81 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 9.82 ms / 37277.90 ms Memory: -0.019 MB / 8.79 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 2.03 ms / 37279.93 ms Memory: 0.099 MB / 8.89 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.67 ms / 37280.60 ms Memory: -0.265 MB / 8.63 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 26.46 ms / 37307.06 ms Memory: -0.017 MB / 8.61 MB Application: afterAddImgAttributes plgSystem (JCH Optimize)

Time: 7.79 ms / 37314.85 ms Memory: 0.417 MB / 9.03 MB Application: afterLazyLoadImages plgSystem (JCH Optimize)

Time: 6.37 ms / 37321.21 ms Memory: -0.268 MB / 8.76 MB Application: afterMinifyHtml plgSystem (JCH Optimize)

Time: 1.08 ms / 37322.29 ms Memory: 0.002 MB / 8.76 MB Application: afterProcess plgSystem (JCH Optimize)

Time: 0.43 ms / 37322.71 ms Memory: -0.235 MB / 8.53 MB Application: afterRender

Database queries total: 25067.03 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'32726e343739737368636a6b6f346e696767616a376b6d727464', 1, 1642533587, 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.96 ms After last query: 0.66 ms Query memory: 0.056 MB Memory before query: 1.075 MB Rows returned: 44

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

  FROM `jos_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	46	Using index condition; 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/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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.36 ms After last query: 0.76 ms Query memory: 0.021 MB Memory before query: 1.125 MB Rows returned: 4

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.56 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.137 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.02 ms After last query: 0.17 ms Query memory: 0.030 MB Memory before query: 1.158 MB Rows returned: 105

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM jos_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.22 ms After last query: 4.24 ms Query memory: 0.004 MB Memory before query: 1.597 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
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/jomcomdev/jomcomdev.php:50
7	plgSystemJomcomdev->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
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.58 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 1.623 MB Rows returned: 1

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

  FROM `jos_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomcomdev/jomcomdev.php:52
7	plgSystemJomcomdev->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
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.00 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 1.615 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"2d9950e14ec9d7eaa020270c27cbffd7\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"2d9950e14ec9d7eaa020270c27cbffd7\"}' 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomcomdev/jomcomdev.php:52
7	plgSystemJomcomdev->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
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.69 ms After last query: 13.34 ms Query memory: 0.022 MB Memory before query: 2.116 MB Rows returned: 1

SELECT `params`

  FROM `jos_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_jchoptimize'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof40/Params/Params.php:55
12	FOF40\Params\Params->reload()	JROOT/libraries/fof40/Params/Params.php:40
11	FOF40\Params\Params->__construct()	JROOT/libraries/fof40/Container/Container.php:281
10	FOF40\Container\Container->FOF40\Container\{closure}()	JROOT/libraries/fof40/Pimple/Container.php:113
9	FOF40\Pimple\Container->offsetGet()	JROOT/libraries/fof40/Container/ContainerBase.php:27
8	FOF40\Container\ContainerBase->__get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:124
7	plgSystemJchoptimize->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
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: 4.17 ms Query memory: 0.022 MB Memory before query: 2.286 MB Rows returned: 0

SELECT *

  FROM jos_languages

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:219
12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:171
11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:85
10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:101
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.20 ms After last query: 0.75 ms Query memory: 0.120 MB Memory before query: 2.325 MB Rows returned: 53

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

  FROM jos_menu AS m

  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	102	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	lavers69_joomla3.m.component_id	1	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/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
19	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
16	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
15	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
14	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
13	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
12	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
11	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:131
10	Sh404sefClassPageinfo->loadHomepages()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:103
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.47 ms After last query: 1.39 ms Query memory: 0.038 MB Memory before query: 2.638 MB Rows returned: 1

SELECT `params` 
  FROM jos_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; 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/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:671
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:126
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.77 ms After last query: 7.17 ms Query memory: 0.024 MB Memory before query: 3.140 MB Rows returned: 1

SELECT * 
  FROM `jos_sh404sef_aliases` 
  WHERE `state` = 1 
  and (`alias` = 'accommodation/romantic-getaways.html') 
  order by `ordering` asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_sh404sef_aliases	ref	state,alias	alias	573	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:222
15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:706
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
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: 2.33 ms After last query: 0.58 ms Query memory: 0.314 MB Memory before query: 3.156 MB Rows returned: 945

SELECT * 
  FROM jos_sh404sef_aliases 
  WHERE state = 1 
  and (type = 1 or type = 2);

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_sh404sef_aliases	ALL	type,state	NO INDEX KEY COULD BE USED	NULL	NULL	4307	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/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:287
15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:117
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:706
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
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.56 ms After last query: 12.72 ms Query memory: 0.025 MB Memory before query: 3.848 MB Rows returned: 0

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
17	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/classes/router.php:2067
16	Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:2035
15	Sh404sefClassRouterInternal->_isSimpleEncodingSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1978
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1439
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
11	Sh404sefClassRouterInternal->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.58 ms After last query: 0.75 ms Query memory: 0.025 MB Memory before query: 3.865 MB Rows returned: 3

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM jos_sh404sef_urls 
  WHERE `oldurl`='accommodation/romantic-getaways.html' 
  ORDER BY `rank`;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_sh404sef_urls	ref	oldurl	oldurl	573	const	2	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1992
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1439
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
11	Sh404sefClassRouterInternal->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: 1.92 ms After last query: 0.29 ms Query memory: 0.008 MB Memory before query: 3.876 MB

UPDATE `jos_sh404sef_urls` 
  SET `cpt`=170, `last_hit`='2022-01-18 19:19:47' 
  WHERE `id`='3349' 
  AND `rank`=0;

Explain

EXPLAIN not possible on query: UPDATE `jos_sh404sef_urls` SET `cpt`=170, `last_hit`='2022-01-18 19:19:47' WHERE `id`='3349' AND `rank`=0;

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/shlib/shl_packages/system/abstractdecorator.php:41
17	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1458
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
11	Sh404sefClassRouterInternal->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: 1.21 ms After last query: 1.38 ms Query memory: 0.026 MB Memory before query: 3.898 MB Rows returned: 28

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jchoptimize','com_jomcomdev','com_jomholiday','com_joomlaupdate','com_jvrelatives','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_sh404sef','com_tags','com_templates','com_universal_ajax_live_search','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	range	idx_asset_name	idx_asset_name	202	NULL	43	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:99
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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: 2.58 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 4.014 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `jos_assets`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
15	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
14	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:99
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.36 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 4.036 MB Rows returned: 0

SELECT *

  FROM jos_assets

  WHERE `name` = 'com_menus'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
15	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
14	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:99
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.70 ms After last query: 1.21 ms Query memory: 0.019 MB Memory before query: 4.083 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	lavers69_joomla3.s.template,const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.84 ms After last query: 3.61 ms Query memory: 0.027 MB Memory before query: 4.228 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `jos_cddir_statistic`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->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/administrator/components/com_jomcomdev/tables/statistic.php:29
16	JomcomdevTableStatistic->__construct()	JROOT/libraries/src/Table/Table.php:320
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jomholiday/models/items.php:81
14	JomholidayModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:42
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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.48 ms After last query: 0.35 ms Query memory: 0.024 MB Memory before query: 4.262 MB Rows returned: 1

SELECT *

  FROM jos_cddir_statistic

  WHERE `item_id` = '180' 
  AND `extension` = 'com_jomholiday.category' 
  AND `date_year` = '2022' 
  AND `date_month` = '01'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_cddir_statistic	ref	item_id	item_id	4	const	8	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/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jomcomdev/tables/statistic.php:54
15	JomcomdevTableStatistic->addViewItemStats()	JROOT/components/com_jomholiday/models/items.php:161
14	JomholidayModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:42
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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.82 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 4.270 MB

UPDATE `jos_cddir_statistic` 
  SET `item_id`='180',`view_in_list`='0',`view_item`='87',`add_favorite`='0',`date_year`='2022',`date_month`='1',`extension`='com_jomholiday.category' 
  WHERE `id` = '2099'

Explain

EXPLAIN not possible on query: UPDATE `jos_cddir_statistic` SET `item_id`='180',`view_in_list`='0',`view_item`='87',`add_favorite`='0',`date_year`='2022',`date_month`='1',`extension`='com_jomholiday.category' WHERE `id` = '2099'

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
18	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:809
17	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Table/Table.php:925
16	Joomla\CMS\Table\Table->save()	JROOT/administrator/components/com_jomcomdev/tables/statistic.php:64
15	JomcomdevTableStatistic->addViewItemStats()	JROOT/components/com_jomholiday/models/items.php:161
14	JomholidayModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:42
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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: 1.01 ms After last query: 0.42 ms Query memory: 0.030 MB Memory before query: 4.297 MB Rows returned: 28

SHOW FULL COLUMNS 
  FROM `jos_cddir_categories`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->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/administrator/components/com_jomcomdev/tables/category.php:32
16	JomcomdevTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:320
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jomholiday/models/items.php:162
14	JomholidayModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:42
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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.40 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 4.339 MB Rows returned: 1

Duplicate queries: #30 #114

SELECT *

  FROM jos_cddir_categories

  WHERE `id` = '180'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_cddir_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
15	Joomla\CMS\Table\Table->load()	JROOT/components/com_jomholiday/models/items.php:163
14	JomholidayModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:42
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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: 67.27 ms After last query: 0.31 ms Query memory: 0.062 MB Memory before query: 4.338 MB Rows returned: 12

SELECT a.id AS id, a.title AS title, a.alias AS alias, a.users_id, a.fulladdress, a.star_rating, a.booking_type as booking_type,a.published AS published, a.categories_address_id, a.categories_id AS categories_id, a.introtext, a.ref_number as ref_number, a.featured, a.date_publish AS date_publish, a.date_publish_down AS date_publish_down, l.view_item,c.title AS category_title, c.color AS category_color,ct.title AS type_title,COUNT(Distinct d.id) AS reviewsHow, COUNT(d.id) AS rateHow, SUM(d.rate) AS rateSum, SUM(d.rate)/COUNT(d.id) as rateSort,u.name AS username,COALESCE(MIN(book.price),MIN(tour.price)) AS priceMin

  FROM `jos_cddir_jomholiday` AS a

  LEFT JOIN jos_cddir_categories AS c 
  ON c.id = a.categories_id

  LEFT JOIN jos_cddir_categories AS ct 
  ON ct.id = a.categories_type_id

  LEFT JOIN jos_cddir_categories AS e 
  ON e.id = a.categories_address_id

  LEFT JOIN jos_cddir_reviews AS d 
  ON (a.id = d.content_id 
  AND d.published=1 
  AND d.approved=1 
  AND d.extension = "com_jomholiday")

  LEFT JOIN jos_users AS u 
  ON u.id = a.users_id

  LEFT JOIN (
SELECT item_id, SUM(view_item) as view_item

  FROM `jos_cddir_statistic`

  WHERE extension='com_jomholiday'

  GROUP BY item_id) AS l 
  ON (l.item_id = a.id)

  LEFT JOIN jos_cddir_jomholiday_object AS ob 
  ON a.id = ob.items_id

  LEFT JOIN jos_cddir_jomholiday_tours AS tour 
  ON a.id = tour.items_id

  LEFT JOIN (
SELECT object_id, MIN(price) as price

  FROM `jos_cddir_jomholiday_booking`

  WHERE date>=NOW()

  GROUP BY object_id) AS book 
  ON (ob.id = book.object_id)

  WHERE a.published = 1 
  AND a.approved = 1 
  AND (a.date_publish <= '2022-01-18 19:19:47' OR a.date_publish IS NULL OR a.date_publish='0000-00-00 00:00:00 ') 
  AND (a.date_publish_down >= '2022-01-18 19:19:47' OR a.date_publish_down IS NULL OR a.date_publish_down='0000-00-00 00:00:00 ') 
  AND c.lft >= 203 
  AND c.rgt <= 204 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND a.language in ('en-GB','*')

  GROUP BY a.id

  ORDER BY a.featured DESC, a.date_publish DESC 
  LIMIT 30

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ALL	fk_jos_cddir_content_jos_categories	NO INDEX KEY COULD BE USED	NULL	NULL	170	Using where; Using temporary; Using filesort
1	PRIMARY	c	eq_ref	PRIMARY,idx_access,idx_left_right	PRIMARY	4	lavers69_joomla3.a.categories_id	1	Using where
1	PRIMARY	ct	eq_ref	PRIMARY	PRIMARY	4	lavers69_joomla3.a.categories_type_id	1	Using where
1	PRIMARY	d	ref	content_id	content_id	4	lavers69_joomla3.a.id	1	Using where
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	lavers69_joomla3.a.users_id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	lavers69_joomla3.a.id	2
1	PRIMARY	ob	ref	items_id	items_id	4	lavers69_joomla3.a.id	1	Using index
1	PRIMARY	tour	ALL	items_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	PRIMARY	<derived3>	ref	key0	key0	5	lavers69_joomla3.ob.id	352	Using where
3	DERIVED	jos_cddir_jomholiday_booking	ALL	object_id,date	NO INDEX KEY COULD BE USED	NULL	NULL	112880	Using where; Using temporary; Using filesort
2	LATERAL DERIVED	jos_cddir_statistic	ref	item_id	item_id	4	lavers69_joomla3.a.id	3	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/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:42
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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.54 ms After last query: 0.35 ms Query memory: 0.023 MB Memory before query: 4.423 MB Rows returned: 1

Duplicate queries: #28 #114

SELECT *

  FROM jos_cddir_categories

  WHERE `id` = '180'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_cddir_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
14	Joomla\CMS\Table\Table->load()	JROOT/components/com_jomholiday/models/items.php:163
13	JomholidayModelItems->getListQuery()	JROOT/components/com_jomholiday/models/items.php:42
12	JomholidayModelItems->getItemsForMap()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:43
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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: 62.48 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 4.421 MB Rows returned: 12

SELECT a.id AS id, a.title AS title, a.alias AS alias, a.users_id, a.categories_id AS categories_id, a.maps_lat, a.maps_lng,COUNT(Distinct d.id) AS reviewsHow, COUNT(d.id) AS rateHow, SUM(d.rate) AS rateSum, SUM(d.rate)/COUNT(d.id) as rateSort,COALESCE(MIN(book.price),MIN(tour.price)) AS priceMin

  FROM `jos_cddir_jomholiday` AS a

  LEFT JOIN jos_cddir_categories AS c 
  ON c.id = a.categories_id

  LEFT JOIN jos_cddir_categories AS ct 
  ON ct.id = a.categories_type_id

  LEFT JOIN jos_cddir_categories AS e 
  ON e.id = a.categories_address_id

  LEFT JOIN jos_cddir_reviews AS d 
  ON (a.id = d.content_id 
  AND d.published=1 
  AND d.approved=1 
  AND d.extension = "com_jomholiday")

  LEFT JOIN jos_users AS u 
  ON u.id = a.users_id

  LEFT JOIN (
SELECT item_id, SUM(view_item) as view_item

  FROM `jos_cddir_statistic`

  WHERE extension='com_jomholiday'

  GROUP BY item_id) AS l 
  ON (l.item_id = a.id)

  LEFT JOIN jos_cddir_jomholiday_object AS ob 
  ON a.id = ob.items_id

  LEFT JOIN jos_cddir_jomholiday_tours AS tour 
  ON a.id = tour.items_id

  LEFT JOIN (
SELECT object_id, MIN(price) as price

  FROM `jos_cddir_jomholiday_booking`

  WHERE date>=NOW()

  GROUP BY object_id) AS book 
  ON (ob.id = book.object_id)

  WHERE a.published = 1 
  AND a.approved = 1 
  AND (a.date_publish <= '2022-01-18 19:19:47' OR a.date_publish IS NULL OR a.date_publish='0000-00-00 00:00:00 ') 
  AND (a.date_publish_down >= '2022-01-18 19:19:47' OR a.date_publish_down IS NULL OR a.date_publish_down='0000-00-00 00:00:00 ') 
  AND c.lft >= 203 
  AND c.rgt <= 204 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND a.language in ('en-GB','*')

  GROUP BY a.id

  ORDER BY a.featured DESC, a.date_publish DESC 
  LIMIT 30

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ALL	fk_jos_cddir_content_jos_categories	NO INDEX KEY COULD BE USED	NULL	NULL	170	Using where; Using temporary; Using filesort
1	PRIMARY	c	eq_ref	PRIMARY,idx_access,idx_left_right	PRIMARY	4	lavers69_joomla3.a.categories_id	1	Using where
1	PRIMARY	d	ref	content_id	content_id	4	lavers69_joomla3.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	lavers69_joomla3.a.id	2
1	PRIMARY	ob	ref	items_id	items_id	4	lavers69_joomla3.a.id	1	Using index
1	PRIMARY	tour	ALL	items_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	PRIMARY	<derived3>	ref	key0	key0	5	lavers69_joomla3.ob.id	352	Using where
3	DERIVED	jos_cddir_jomholiday_booking	ALL	object_id,date	NO INDEX KEY COULD BE USED	NULL	NULL	112880	Using where; Using temporary; Using filesort
2	LATERAL DERIVED	jos_cddir_statistic	ref	item_id	item_id	4	lavers69_joomla3.a.id	3	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/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jomholiday/models/items.php:44
12	JomholidayModelItems->getItemsForMap()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:43
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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: 76.98 ms After last query: 0.74 ms Query memory: 0.062 MB Memory before query: 4.450 MB Rows returned: 12

SELECT a.id AS id, a.title AS title, a.alias AS alias, a.users_id, a.fulladdress, a.star_rating, a.booking_type as booking_type,a.published AS published, a.categories_address_id, a.categories_id AS categories_id, a.introtext, a.ref_number as ref_number, a.featured, a.date_publish AS date_publish, a.date_publish_down AS date_publish_down, l.view_item,c.title AS category_title, c.color AS category_color,ct.title AS type_title,COUNT(Distinct d.id) AS reviewsHow, COUNT(d.id) AS rateHow, SUM(d.rate) AS rateSum, SUM(d.rate)/COUNT(d.id) as rateSort,u.name AS username,COALESCE(MIN(book.price),MIN(tour.price)) AS priceMin

  FROM `jos_cddir_jomholiday` AS a

  LEFT JOIN jos_cddir_categories AS c 
  ON c.id = a.categories_id

  LEFT JOIN jos_cddir_categories AS ct 
  ON ct.id = a.categories_type_id

  LEFT JOIN jos_cddir_categories AS e 
  ON e.id = a.categories_address_id

  LEFT JOIN jos_cddir_reviews AS d 
  ON (a.id = d.content_id 
  AND d.published=1 
  AND d.approved=1 
  AND d.extension = "com_jomholiday")

  LEFT JOIN jos_users AS u 
  ON u.id = a.users_id

  LEFT JOIN (
SELECT item_id, SUM(view_item) as view_item

  FROM `jos_cddir_statistic`

  WHERE extension='com_jomholiday'

  GROUP BY item_id) AS l 
  ON (l.item_id = a.id)

  LEFT JOIN jos_cddir_jomholiday_object AS ob 
  ON a.id = ob.items_id

  LEFT JOIN jos_cddir_jomholiday_tours AS tour 
  ON a.id = tour.items_id

  LEFT JOIN (
SELECT object_id, MIN(price) as price

  FROM `jos_cddir_jomholiday_booking`

  WHERE date>=NOW()

  GROUP BY object_id) AS book 
  ON (ob.id = book.object_id)

  WHERE a.published = 1 
  AND a.approved = 1 
  AND (a.date_publish <= '2022-01-18 19:19:47' OR a.date_publish IS NULL OR a.date_publish='0000-00-00 00:00:00 ') 
  AND (a.date_publish_down >= '2022-01-18 19:19:47' OR a.date_publish_down IS NULL OR a.date_publish_down='0000-00-00 00:00:00 ') 
  AND c.lft >= 203 
  AND c.rgt <= 204 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND a.language in ('en-GB','*')

  GROUP BY a.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ALL	fk_jos_cddir_content_jos_categories	NO INDEX KEY COULD BE USED	NULL	NULL	170	Using where; Using temporary; Using filesort
1	PRIMARY	c	eq_ref	PRIMARY,idx_access,idx_left_right	PRIMARY	4	lavers69_joomla3.a.categories_id	1	Using where
1	PRIMARY	ct	eq_ref	PRIMARY	PRIMARY	4	lavers69_joomla3.a.categories_type_id	1	Using where
1	PRIMARY	d	ref	content_id	content_id	4	lavers69_joomla3.a.id	1	Using where
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	lavers69_joomla3.a.users_id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	lavers69_joomla3.a.id	2
1	PRIMARY	ob	ref	items_id	items_id	4	lavers69_joomla3.a.id	1	Using index
1	PRIMARY	tour	ALL	items_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	PRIMARY	<derived3>	ref	key0	key0	5	lavers69_joomla3.ob.id	352	Using where
3	DERIVED	jos_cddir_jomholiday_booking	ALL	object_id,date	NO INDEX KEY COULD BE USED	NULL	NULL	112880	Using where; Using temporary; Using filesort
2	LATERAL DERIVED	jos_cddir_statistic	ref	item_id	item_id	4	lavers69_joomla3.a.id	3	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/libraries/src/MVC/Model/BaseDatabaseModel.php:367
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:284
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:234
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomholiday/views/items/view.html.php:45
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomholiday/controller.php:34
8	JomHolidayController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomholiday/jomholiday.php:73
6	require_once JROOT/components/com_jomholiday/jomholiday.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: 1.89 ms After last query: 0.78 ms Query memory: 0.026 MB Memory before query: 4.453 MB Rows returned: 6

Filters Applied:

La Violette - luxury gites for honeymoon in France (sleeps 2)
Ref: 572

La Jonquille - French gites to rent for romantic holidays, France
Ref: 573

L'Iris - luxury gite rental South France with pool (sleeps 2)
Ref: 574

L'Anémone beautiful French gites for rent, South France (sleeps 2)
Ref: 575

Les Corbieres French holiday gites near Carcassonne with pool
Ref: 865

Maison de la Roche gites in France with pool sleeps 4
Ref: 1504

Villa Colibri - Sommieres French villas to rent with pools sleeps 4
Ref: 1577

Villa Paon - South of France villas to rent in Sommieres with pools
Ref: 1578

Le Bel Apartment - holiday apartment South France with jacuzzi
Ref: 1627

Le Jasmin - French gites with pools Sommieres (sleeps 2)
Ref: 571

La Cour - Provence holiday apartments to rent South France
Ref: 210

Apartment Canabasserie - Pezenas France with large roof terrace
Ref: 1964

Maison Kipling large holiday rental with private pool in South France

Moulin de Conas - Chateau for rent Pezenas South France

Le Petit-Versailles villa Pezenas France with private pool

Villa Cerisier South France with private pool, air con

La Poste Gabian - holiday home South France with pool

Resources

Contact Go Languedoc

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

173 Queries Logged 25067.03 ms

31 duplicate found!

Filters Applied:

La Violette - luxury gites for honeymoon in France (sleeps 2) Ref: 572

La Jonquille - French gites to rent for romantic holidays, France Ref: 573

L'Iris - luxury gite rental South France with pool (sleeps 2) Ref: 574

L'Anémone beautiful French gites for rent, South France (sleeps 2) Ref: 575

Les Corbieres French holiday gites near Carcassonne with pool Ref: 865

Maison de la Roche gites in France with pool sleeps 4 Ref: 1504

Villa Colibri - Sommieres French villas to rent with pools sleeps 4 Ref: 1577

Villa Paon - South of France villas to rent in Sommieres with pools Ref: 1578

Le Bel Apartment - holiday apartment South France with jacuzzi Ref: 1627

Le Jasmin - French gites with pools Sommieres (sleeps 2) Ref: 571

La Cour - Provence holiday apartments to rent South France Ref: 210

Apartment Canabasserie - Pezenas France with large roof terrace Ref: 1964

Resources

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

173 Queries Logged 25067.03 ms

31 duplicate found!

La Violette - luxury gites for honeymoon in France (sleeps 2)
Ref: 572

La Jonquille - French gites to rent for romantic holidays, France
Ref: 573

L'Iris - luxury gite rental South France with pool (sleeps 2)
Ref: 574

L'Anémone beautiful French gites for rent, South France (sleeps 2)
Ref: 575

Les Corbieres French holiday gites near Carcassonne with pool
Ref: 865

Maison de la Roche gites in France with pool sleeps 4
Ref: 1504

Villa Colibri - Sommieres French villas to rent with pools sleeps 4
Ref: 1577

Villa Paon - South of France villas to rent in Sommieres with pools
Ref: 1578

Le Bel Apartment - holiday apartment South France with jacuzzi
Ref: 1627

Le Jasmin - French gites with pools Sommieres (sleeps 2)
Ref: 571

La Cour - Provence holiday apartments to rent South France
Ref: 210

Apartment Canabasserie - Pezenas France with large roof terrace
Ref: 1964