Cheap holiday villas in South of France in 2022

Filters Applied:

Cheap holidays Clear All

Cheap holidays | Gites

63,00 € / per Night

French gites for self catering holidays in France (sleeps 4)
Ref: 591

Sleeps: 4

Bedrooms: 2

Bathrooms: 2

FranceLanguedocCarcassonne Sonnac sur l´Hers

These French gites for self catering holidays in France are located in a beautiful part of South France, close to the Pyrenees. The French gites...

Cheap holidays | Villas with pools

82,00 € / per Night

Domaine de la Flotte French holiday gites Aude Languedoc
Ref: 590

Sleeps: 4

Bedrooms: 2

Bathrooms: 2

FranceLanguedocCarcassonne Sonnac sur l´Hers

If you are looking for a relaxing and peaceful holiday in South France, then Domaine de la Flotte holiday gites are the perfect choice. These...

Cheap holidays | Gites

86,00 € / per Night

Nezignan l'Eveque South France holiday cottage near Pezenas
Ref: 278

Sleeps: 4

Bedrooms: 2

Bathrooms: 1

FranceLanguedocPezenas Nezignan L'Eveque

This South France holiday cottage is a 300 year old stone-built property located in the heart of the village of Nezignan l´Eveque. This pretty village is...

Cheap holidays | Villas with pools

118,00 € / per Night

Maison de Vaudour - holiday rental house in France private pool
Ref: 1153

Sleeps: 8

Bedrooms: 4

Bathrooms: 2

FranceLanguedocPezenas Nezignan L'Eveque

Maison Vaudour is a charming holiday rental house in South France with a private pool. The holiday rental is is located in the beautiful village...

Cheap holidays | Villas with pools

57,00 € / per Night

Great! 1 Reviews

4.0

Provence holiday cottages to rent in France with pool
Ref: 951

Sleeps: 2

Bedrooms: 1

Bathrooms: 1

FranceProvenceAvignon Isle sur la Sorgue

These Provence holiday cottages to rent in France are set in a garden full of bamboo trees and a large swimming pool (9m x 4m)....

Cheap holidays | Gites

100,00 € / per Night

Fantastic!!! 1 Reviews

5.0

Maison Monet - Pezenas French gites for rent in South France (sleeps 6-8)
Ref: 687

Sleeps: 6

Bedrooms: 3

Bathrooms: 1

FranceLanguedocPezenas Pezenas

Maison Monet, is a spacious French gite for rent in South France, situated in the heart of the historic town of Pezenas. The holiday gite...

Cheap holidays | Villas with pools

184,00 € / per Night

Fantastic!!! 5 Reviews

5.0

L'Amandier - Gite rental South France with pool near Pezenas
Ref: 461

Sleeps: 6

Bedrooms: 3

Bathrooms: 2

FranceLanguedocPezenas Neffies

L´Amandier gite rental with private pool is located in the pretty medieval village of Neffies, South France, close to the historic town of Pezenas. This...

Cheap holidays | Villas with pools

85,00 € / per Night

Apartment Olive - holiday gite to rent South France pool
Ref: 395

Sleeps: 10

Bedrooms: 3

Bathrooms: 2

FranceLanguedocNimes Canaules

Apartment Olive holiday gite to rent in South France is located in the village of Canaules-et-Argentieres, close to both Nimes and Montpellier airports. This holiday...

Cheap holidays | Villas with pools

85,00 € / per Night

Apartment Fleur South France holiday rental with pool
Ref: 393

Sleeps: 6

Bedrooms: 2

Bathrooms: 2

FranceLanguedocNimes Canaules-et-Argentières

Apartment Fleur is located in the village of Canaules-et-Argentieres, close to both Nimes and Montpellier airports. This 2 bed holiday rental apartment in South France...

Cheap holidays | Villas with pools

85,00 € / per Night

Apartment Cerise - South France vacation rental with pool
Ref: 391

Sleeps: 6

Bedrooms: 2

Bathrooms: 2

FranceLanguedocNimes Canaules

Apartment Cerise is located in the village of Canaules-et-Argentières, deep in the Languedoc wine producing region in Southern France. This vacation rental property is located...

Cheap holidays | Gites

100,00 € / per Night

Fantastic!!! 1 Reviews

5.0

St Maximin rooftop apartment rentals Provence South France
Ref: 208

Sleeps: 4

Bedrooms: 2

Bathrooms: 1

FranceProvenceUzes St Maximin, Uzes

These beautiful rooftop apartment rentals in Provence, South France are located in a lovingly restored 14th Century stone building converted into three self-contained apartments. The...

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": 1642532306,
                "last": 1642532306,
                "now": 1642532306
            },
            "client": {
                "forwarded": "3.81.172.77"
            },
            "token": "Pwf6m1H82tIVoChwnWAk96DrKNNLrbn4"
        },
        "registry": {
            "com_jomholiday": {
                "items": {
                    "list": {
                        "limitstart": 0
                    },
                    "filter": {
                        "categories_id": "166",
                        "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.53 ms / 7.53 ms Memory: 0.408 MB / 0.74 MB Application: afterLoad

Time: 52.64 ms / 60.17 ms Memory: 2.215 MB / 2.95 MB Application: afterInitialise

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

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

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

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

Time: 0.36 ms / 91.70 ms Memory: -0.001 MB / 4.05 MB Application: afterRoute

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

Time: 313.89 ms / 406.81 ms Memory: 1.874 MB / 5.96 MB Application: afterRenderComponent com_jomholiday

Time: 9.66 ms / 416.47 ms Memory: 0.134 MB / 6.10 MB Application: afterDispatch

Time: 12.42 ms / 428.89 ms Memory: 0.609 MB / 6.71 MB Application: beforeRenderModule mod_custom (Front slideshow text)

Time: 0.43 ms / 429.32 ms Memory: 0.006 MB / 6.71 MB Application: afterRenderModule mod_custom (Front slideshow text)

Time: 0.12 ms / 429.45 ms Memory: 0.002 MB / 6.71 MB Application: beforeRenderModule mod_custom (Footer CD)

Time: 0.13 ms / 429.57 ms Memory: 0.003 MB / 6.72 MB Application: afterRenderModule mod_custom (Footer CD)

Time: 1.60 ms / 431.17 ms Memory: 0.052 MB / 6.77 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.14 ms / 431.31 ms Memory: 0.003 MB / 6.77 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.17 ms / 431.48 ms Memory: 0.003 MB / 6.77 MB Application: beforeRenderModule mod_menu (Main)

Time: 14.23 ms / 445.71 ms Memory: 0.348 MB / 7.12 MB Application: afterRenderModule mod_menu (Main)

Time: 3.00 ms / 448.71 ms Memory: 0.013 MB / 7.14 MB Application: beforeRenderModule mod_custom (Login bar)

Time: 0.16 ms / 448.87 ms Memory: 0.003 MB / 7.14 MB Application: afterRenderModule mod_custom (Login bar)

Time: 0.14 ms / 449.01 ms Memory: 0.001 MB / 7.14 MB Application: beforeRenderModule mod_custom (Logo Mini)

Time: 0.11 ms / 449.12 ms Memory: 0.003 MB / 7.14 MB Application: afterRenderModule mod_custom (Logo Mini)

Time: 0.30 ms / 449.42 ms Memory: -0.013 MB / 7.13 MB Application: beforeRenderModule mod_jomholiday_search (Search accommodation)

Time: 15.65 ms / 465.07 ms Memory: 0.255 MB / 7.38 MB Application: afterRenderModule mod_jomholiday_search (Search accommodation)

Time: 0.05 ms / 465.12 ms Memory: -0.013 MB / 7.37 MB Application: beforeRenderModule mod_jomholiday_items (Popular accommodation)

Time: 23513.65 ms / 23978.77 ms Memory: 0.063 MB / 7.43 MB Application: afterRenderModule mod_jomholiday_items (Popular accommodation)

Time: 0.10 ms / 23978.86 ms Memory: -0.005 MB / 7.43 MB Application: beforeRenderModule mod_custom (South France Holidays)

Time: 6.32 ms / 23985.18 ms Memory: 0.003 MB / 7.43 MB Application: afterRenderModule mod_custom (South France Holidays)

Time: 1.19 ms / 23986.37 ms Memory: 0.034 MB / 7.47 MB Application: beforeRenderModule mod_menu (Menu offcanvas)

Time: 3.31 ms / 23989.68 ms Memory: 0.008 MB / 7.47 MB Application: afterRenderModule mod_menu (Menu offcanvas)

Time: 1229.87 ms / 25219.56 ms Memory: 0.452 MB / 7.93 MB Application: beforeProcess plgSystem (JCH Optimize)

Time: 0.40 ms / 25219.96 ms Memory: 0.023 MB / 7.95 MB Application: afterSetUpExcludes plgSystem (JCH Optimize)

Time: 12.10 ms / 25232.06 ms Memory: 0.291 MB / 8.24 MB Application: afterProcessImageAttributes plgSystem (JCH Optimize)

Time: 0.35 ms / 25232.41 ms Memory: 0.003 MB / 8.24 MB Application: afterRunCronTasks plgSystem (JCH Optimize)

Time: 0.27 ms / 25232.68 ms Memory: 0.021 MB / 8.27 MB Application: beforeGetContents - css plgSystem (JCH Optimize)

Time: 7.60 ms / 25240.27 ms Memory: 0.028 MB / 8.29 MB Application: afterCombineFile - /plugins/system/jce/css/content.css plgSystem (JCH Optimize)

Time: 2.90 ms / 25243.17 ms Memory: -0.000 MB / 8.29 MB Application: afterCombineFile - /media/cms/css/debug.css plgSystem (JCH Optimize)

Time: 0.54 ms / 25243.71 ms Memory: -0.002 MB / 8.29 MB Application: afterCombineFile - .../com_jchoptimize/css/pro-ls.effects.css plgSystem (JCH Optimize)

Time: 0.49 ms / 25244.19 ms Memory: 0.009 MB / 8.30 MB Application: afterCombineFile - /media/system/css/fields/calendar.css plgSystem (JCH Optimize)

Time: 1.43 ms / 25245.62 ms Memory: -0.001 MB / 8.30 MB Application: afterCombineFile - .../mod_jomholiday_items.css plgSystem (JCH Optimize)

Time: 0.44 ms / 25246.06 ms Memory: 0.005 MB / 8.30 MB Application: afterCombineFile - Style Declaration plgSystem (JCH Optimize)

Time: 0.32 ms / 25246.39 ms Memory: 0.018 MB / 8.32 MB Application: afterProcessCssUrls plgSystem (JCH Optimize)

Time: 135.66 ms / 25382.04 ms Memory: -0.000 MB / 8.32 MB Application: afterCalculateSprite plgSystem (JCH Optimize)

Time: 0.05 ms / 25382.09 ms Memory: 0.001 MB / 8.32 MB Application: afterGenerateSprite plgSystem (JCH Optimize)

Time: 0.45 ms / 25382.55 ms Memory: -0.036 MB / 8.29 MB Application: afterGetCombinedFiles - css plgSystem (JCH Optimize)

Time: 0.53 ms / 25383.07 ms Memory: 0.019 MB / 8.31 MB Application: afterCreateStaticFiles - css plgSystem (JCH Optimize)

Time: 29.60 ms / 25412.67 ms Memory: 0.228 MB / 8.53 MB Application: afterOptimizeCssDelivery plgSystem (JCH Optimize)

Time: 2.01 ms / 25414.68 ms Memory: -0.221 MB / 8.31 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 83.74 ms / 25498.42 ms Memory: 0.300 MB / 8.61 MB Application: afterCombineFile - /media/jui/js/jquery.js plgSystem (JCH Optimize)

Time: 1.74 ms / 25500.16 ms Memory: -0.147 MB / 8.46 MB Application: afterCombineFile - /media/jui/js/jquery-noconflict.js plgSystem (JCH Optimize)

Time: 6.00 ms / 25506.16 ms Memory: 0.032 MB / 8.50 MB Application: afterCombineFile - /media/jui/js/jquery-migrate.js plgSystem (JCH Optimize)

Time: 1.53 ms / 25507.69 ms Memory: -0.033 MB / 8.46 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 0.79 ms / 25508.48 ms Memory: 0.091 MB / 8.55 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.24 ms / 25508.71 ms Memory: -0.163 MB / 8.39 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 0.13 ms / 25508.84 ms Memory: -0.071 MB / 8.32 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 5.68 ms / 25514.52 ms Memory: 0.034 MB / 8.35 MB Application: afterCombineFile - /media/system/js/core-uncompressed.js plgSystem (JCH Optimize)

Time: 34.97 ms / 25549.49 ms Memory: 0.200 MB / 8.55 MB Application: afterCombineFile - .../system/js/mootools-core-uncompressed.js plgSystem (JCH Optimize)

Time: 94.53 ms / 25644.03 ms Memory: 0.392 MB / 8.95 MB Application: afterCombineFile - .../system/js/mootools-more-uncompressed.js plgSystem (JCH Optimize)

Time: 3.23 ms / 25647.25 ms Memory: -0.268 MB / 8.68 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 1.38 ms / 25648.63 ms Memory: 0.091 MB / 8.77 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.20 ms / 25648.83 ms Memory: -0.371 MB / 8.40 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 0.13 ms / 25648.96 ms Memory: -0.071 MB / 8.33 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 11.59 ms / 25660.55 ms Memory: 0.073 MB / 8.40 MB Application: afterCombineFile - /media/jui/js/bootstrap.js plgSystem (JCH Optimize)

Time: 1.85 ms / 25662.41 ms Memory: -0.034 MB / 8.37 MB Application: afterCombineFile - /media/com_jchoptimize/js/ls.loader.js plgSystem (JCH Optimize)

Time: 1.07 ms / 25663.47 ms Memory: 0.001 MB / 8.37 MB Application: afterCombineFile - .../js/pro-ls.loader.effects.js plgSystem (JCH Optimize)

Time: 1.83 ms / 25665.30 ms Memory: 0.043 MB / 8.41 MB Application: afterCombineFile - /media/com_jchoptimize/js/lazysizes.js plgSystem (JCH Optimize)

Time: 0.64 ms / 25665.94 ms Memory: -0.033 MB / 8.38 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 0.65 ms / 25666.60 ms Memory: 0.091 MB / 8.47 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.21 ms / 25666.80 ms Memory: -0.050 MB / 8.42 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 0.21 ms / 25667.01 ms Memory: -0.071 MB / 8.35 MB Application: beforeGetContents - js plgSystem (JCH Optimize)

Time: 0.87 ms / 25667.88 ms Memory: 0.004 MB / 8.35 MB Application: afterCombineFile - .../system/js/fields/calendar-locales/en.js plgSystem (JCH Optimize)

Time: 1.22 ms / 25669.10 ms Memory: 0.015 MB / 8.37 MB Application: afterCombineFile - .../date/gregorian/date-helper.js plgSystem (JCH Optimize)

Time: 2.77 ms / 25671.87 ms Memory: 0.056 MB / 8.42 MB Application: afterCombineFile - /media/system/js/fields/calendar.js plgSystem (JCH Optimize)

Time: 1.35 ms / 25673.22 ms Memory: -0.030 MB / 8.39 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 2.33 ms / 25675.55 ms Memory: 0.180 MB / 8.57 MB Application: afterCombineFile - https://www.googletagmanager.com/gtag/js plgSystem (JCH Optimize)

Time: 1.07 ms / 25676.61 ms Memory: -0.089 MB / 8.48 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 1.00 ms / 25677.62 ms Memory: 0.001 MB / 8.49 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 2.50 ms / 25680.11 ms Memory: 0.110 MB / 8.60 MB Application: afterCombineFile - .../warp/vendor/uikit/js/uikit.js plgSystem (JCH Optimize)

Time: 0.85 ms / 25680.97 ms Memory: -0.046 MB / 8.55 MB Application: afterCombineFile - .../vendor/uikit/js/components/tooltip.js plgSystem (JCH Optimize)

Time: 1.03 ms / 25681.99 ms Memory: 0.009 MB / 8.56 MB Application: afterCombineFile - .../vendor/uikit/js/components/sticky.js plgSystem (JCH Optimize)

Time: 1.15 ms / 25683.15 ms Memory: 0.013 MB / 8.57 MB Application: afterCombineFile - .../vendor/uikit/js/components/slideshow.js plgSystem (JCH Optimize)

Time: 0.98 ms / 25684.13 ms Memory: 0.005 MB / 8.58 MB Application: afterCombineFile - .../vendor/uikit/js/components/parallax.js plgSystem (JCH Optimize)

Time: 1.02 ms / 25685.15 ms Memory: -0.005 MB / 8.57 MB Application: afterCombineFile - .../cd_travellist/warp/js/social.js plgSystem (JCH Optimize)

Time: 0.85 ms / 25686.00 ms Memory: 0.005 MB / 8.57 MB Application: afterCombineFile - /templates/cd_travellist/js/theme.js plgSystem (JCH Optimize)

Time: 1.03 ms / 25687.04 ms Memory: -0.000 MB / 8.57 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 1.03 ms / 25688.06 ms Memory: 0.001 MB / 8.58 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 0.91 ms / 25688.97 ms Memory: 0.001 MB / 8.58 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 1.12 ms / 25690.09 ms Memory: 0.002 MB / 8.58 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 1.28 ms / 25691.38 ms Memory: 0.005 MB / 8.58 MB Application: afterCombineFile - Script Declaration plgSystem (JCH Optimize)

Time: 2.03 ms / 25693.41 ms Memory: -0.019 MB / 8.56 MB Application: afterGetCombinedFiles - js plgSystem (JCH Optimize)

Time: 0.89 ms / 25694.30 ms Memory: 0.091 MB / 8.66 MB Application: afterCreateStaticFiles - js plgSystem (JCH Optimize)

Time: 0.43 ms / 25694.73 ms Memory: -0.214 MB / 8.44 MB Application: afterReplaceLinks - js plgSystem (JCH Optimize)

Time: 6.04 ms / 25700.77 ms Memory: -0.014 MB / 8.43 MB Application: afterAddImgAttributes plgSystem (JCH Optimize)

Time: 5.89 ms / 25706.66 ms Memory: 0.449 MB / 8.88 MB Application: afterLazyLoadImages plgSystem (JCH Optimize)

Time: 5.71 ms / 25712.36 ms Memory: -0.303 MB / 8.57 MB Application: afterMinifyHtml plgSystem (JCH Optimize)

Time: 0.09 ms / 25712.45 ms Memory: 0.002 MB / 8.58 MB Application: afterProcess plgSystem (JCH Optimize)

Time: 0.29 ms / 25712.74 ms Memory: -0.215 MB / 8.36 MB Application: afterRender

Database queries total: 23813.97 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'37726975376e6a6775376465657035706b6336676d7063716b73', 1, 1642532306, 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.74 ms After last query: 0.71 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.30 ms After last query: 0.80 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.43 ms After last query: 0.09 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: 0.82 ms After last query: 0.18 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.25 ms After last query: 4.97 ms Query memory: 0.004 MB Memory before query: 1.596 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.55 ms After last query: 0.25 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.83 ms After last query: 0.23 ms Query memory: 0.006 MB Memory before query: 1.615 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"d0fc5380ce4729453448069ef0fbff7a\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"d0fc5380ce4729453448069ef0fbff7a\"}' 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.75 ms After last query: 17.08 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.63 ms After last query: 5.04 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.44 ms After last query: 0.86 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.53 ms After last query: 1.83 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.83 ms After last query: 8.79 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/cheap-holidays.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.82 ms After last query: 0.76 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.60 ms After last query: 12.55 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.66 ms After last query: 0.79 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/cheap-holidays.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	1	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: 2.80 ms After last query: 0.34 ms Query memory: 0.008 MB Memory before query: 3.876 MB

UPDATE `jos_sh404sef_urls` 
  SET `cpt`=263, `last_hit`='2022-01-18 18:58:26' 
  WHERE `id`='3319' 
  AND `rank`=0;

Explain

EXPLAIN not possible on query: UPDATE `jos_sh404sef_urls` SET `cpt`=263, `last_hit`='2022-01-18 18:58:26' WHERE `id`='3319' 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: 0.88 ms After last query: 1.30 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: 1.10 ms After last query: 0.34 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.30 ms After last query: 0.31 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.58 ms After last query: 1.12 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: 0.94 ms After last query: 3.92 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.49 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 4.263 MB Rows returned: 1

SELECT *

  FROM jos_cddir_statistic

  WHERE `item_id` = '166' 
  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.89 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 4.271 MB

UPDATE `jos_cddir_statistic` 
  SET `item_id`='166',`view_in_list`='0',`view_item`='121',`add_favorite`='0',`date_year`='2022',`date_month`='1',`extension`='com_jomholiday.category' 
  WHERE `id` = '2077'

Explain

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

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.04 ms After last query: 0.58 ms Query memory: 0.030 MB Memory before query: 4.298 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.46 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 4.339 MB Rows returned: 1

Duplicate queries: #30 #107

SELECT *

  FROM jos_cddir_categories

  WHERE `id` = '166'

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.97 ms After last query: 0.35 ms Query memory: 0.062 MB Memory before query: 4.339 MB Rows returned: 11

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 18:58:26' OR a.date_publish IS NULL OR a.date_publish='0000-00-00 00:00:00 ') 
  AND (a.date_publish_down >= '2022-01-18 18:58:26' OR a.date_publish_down IS NULL OR a.date_publish_down='0000-00-00 00:00:00 ') 
  AND c.lft >= 175 
  AND c.rgt <= 176 
  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.52 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 4.416 MB Rows returned: 1

Duplicate queries: #28 #107

SELECT *

  FROM jos_cddir_categories

  WHERE `id` = '166'

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: 61.06 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 4.414 MB Rows returned: 11

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 18:58:26' OR a.date_publish IS NULL OR a.date_publish='0000-00-00 00:00:00 ') 
  AND (a.date_publish_down >= '2022-01-18 18:58:26' OR a.date_publish_down IS NULL OR a.date_publish_down='0000-00-00 00:00:00 ') 
  AND c.lft >= 175 
  AND c.rgt <= 176 
  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: 58.76 ms After last query: 0.56 ms Query memory: 0.062 MB Memory before query: 4.439 MB Rows returned: 11

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 18:58:26' OR a.date_publish IS NULL OR a.date_publish='0000-00-00 00:00:00 ') 
  AND (a.date_publish_down >= '2022-01-18 18:58:26' OR a.date_publish_down IS NULL OR a.date_publish_down='0000-00-00 00:00:00 ') 
  AND c.lft >= 175 
  AND c.rgt <= 176 
  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.81 ms After last query: 0.43 ms Query memory: 0.026 MB Memory before query: 4.442 MB Rows returned: 6

Duplicate queries: #37 #40 #44 #47 #51 #54 #57 #61 #64 #67

SELECT a.*,b.title AS type_title,c.title AS type_value,d.title AS type_group, d.id AS type_id

  FROM jos_cddir_fields AS a

  INNER JOIN jos_cddir_categories AS b 
  ON b.id = a.categories_type_id

  INNER JOIN jos_cddir_categories AS c 
  ON c.id = a.categories_value_id

  INNER JOIN jos_cddir_categories AS d 
  ON d.id = a.categories_group_id

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

  WHERE a.categories_group_id IN (24,81) 
  AND a.published = 1 
  AND a.extension = 'com_jomholiday' 
  AND a.language in ('en-GB','*')

  ORDER BY d.id,a.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	range	PRIMARY	PRIMARY	4	NULL	2	Using where; Using temporary; Using filesort
1	SIMPLE	a	ref	fk_jos_cddir_fields_jos_cddir_categories1,fk_jos_cddir_fields_jos_cddir_categories2,fk_jos_cddir_fields_jos_cddir_categories3,extension,published	fk_jos_cddir_fields_jos_cddir_categories2	4	lavers69_joomla3.d.id	1	Using where
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	lavers69_joomla3.a.categories_type_id	1
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	lavers69_joomla3.a.categories_value_id	1

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jomcomdev/libraries/Main/FieldsSite.php:156
11	Main_FieldsSite->getFields()	JROOT/components/com_jomholiday/views/items/view.html.php:76
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.22 ms After last query: 0.49 ms Query memory: 0.006 MB Memory before query: 4.467 MB

Duplicate queries: #38 #41 #45 #48 #52 #55 #58 #62 #65 #68


  SET SESSION group_concat_max_len = 10000000

Explain

EXPLAIN not possible on query: SET SESSION group_concat_max_len = 10000000

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_jomcomdev/libraries/Main/FieldsSite.php:785
12	Main_FieldsSite->getValues()	JROOT/components/com_jomcomdev/libraries/Main/FieldsSite.php:166
11	Main_FieldsSite->getFields()	JROOT/components/com_jomholiday/views/items/view.html.php:76
10	JomholidayViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->d

Filters Applied:

French gites for self catering holidays in France (sleeps 4)
Ref: 591

Domaine de la Flotte French holiday gites Aude Languedoc
Ref: 590

Nezignan l'Eveque South France holiday cottage near Pezenas
Ref: 278

Maison de Vaudour - holiday rental house in France private pool
Ref: 1153

Provence holiday cottages to rent in France with pool
Ref: 951

Maison Monet - Pezenas French gites for rent in South France (sleeps 6-8)
Ref: 687

L'Amandier - Gite rental South France with pool near Pezenas
Ref: 461

Apartment Olive - holiday gite to rent South France pool
Ref: 395

Apartment Fleur South France holiday rental with pool
Ref: 393

Apartment Cerise - South France vacation rental with pool
Ref: 391

St Maximin rooftop apartment rentals Provence South France
Ref: 208

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

163 Queries Logged 23813.97 ms

29 duplicate found!

Filters Applied:

French gites for self catering holidays in France (sleeps 4) Ref: 591

Domaine de la Flotte French holiday gites Aude Languedoc Ref: 590

Nezignan l'Eveque South France holiday cottage near Pezenas Ref: 278

Maison de Vaudour - holiday rental house in France private pool Ref: 1153

Provence holiday cottages to rent in France with pool Ref: 951

Maison Monet - Pezenas French gites for rent in South France (sleeps 6-8) Ref: 687

L'Amandier - Gite rental South France with pool near Pezenas Ref: 461

Apartment Olive - holiday gite to rent South France pool Ref: 395

Apartment Fleur South France holiday rental with pool Ref: 393

Apartment Cerise - South France vacation rental with pool Ref: 391

St Maximin rooftop apartment rentals Provence South France Ref: 208

Resources

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

163 Queries Logged 23813.97 ms

29 duplicate found!

French gites for self catering holidays in France (sleeps 4)
Ref: 591

Domaine de la Flotte French holiday gites Aude Languedoc
Ref: 590

Nezignan l'Eveque South France holiday cottage near Pezenas
Ref: 278

Maison de Vaudour - holiday rental house in France private pool
Ref: 1153

Provence holiday cottages to rent in France with pool
Ref: 951

Maison Monet - Pezenas French gites for rent in South France (sleeps 6-8)
Ref: 687

L'Amandier - Gite rental South France with pool near Pezenas
Ref: 461

Apartment Olive - holiday gite to rent South France pool
Ref: 395

Apartment Fleur South France holiday rental with pool
Ref: 393

Apartment Cerise - South France vacation rental with pool
Ref: 391

St Maximin rooftop apartment rentals Provence South France
Ref: 208