Details: Created: 10 August 2009

The Planning and Settlement Development Department operates under the guidance of the Town and Country Planning Act. This legislation in guiding the work of the department allows for this department to:

Facilitate and promote development to ensure that it is at all times carried out in the best interest of the public.
Ensure the orderly and progressive development of land within the country in order to improve and maintain living standards of all citizens.
Monitor and regulate land use activities to ensure that development is carried out in accordance with the regulations and standards of the Central Housing and Planning Authority.

The Department discharges its functions through the following lines of operation:

Settlement Development Planning
Development Facilitation and Compliance
Research and Policy Analysis

With regards to its function of settlement development planning, the Department is responsible for preparing development plans/ strategies/ standards, urban designs, zoning guidelines, etc. To date the Department has completed development plans / strategies for the following urban areas:

Georgetown City
Parika
Bartica
Charity
Lethem

In the preparation of the Development Plans an “Integrated Development Approach” was adopted, which seeks to make the planning process all-inclusive, participatory, multi-sectoral and multi-disciplinary. This approach is therefore sensitive to the needs and priorities of all segments of the community.

To ensure the implementation of these Urban Development Plans, implementable activities and initiatives are identified and considered at the project development level.

Plan implementation therefore will be done on a phased basis as the policies adumbrated in the plan are translated into implementable project activities/ initiatives, which can give rise to tangible or qualitative changes in the social, economic or physical living condition of citizens or specific target groups.

Embedded in proposed policies of these urban development plans are investment opportunities for private developers since to realize the goal and objectives of the plans, there is need for public/ private in the implementation of plan activities at the project level.

The Greater Georgetown Development Plan is considered to be one of the major projects of the Department in recent years. With uncontrolled urban growth compounded by outdated zoning regulations, the GGDP primary focus is returning the Garden City to all its splendor and glory and facilitating an encouraging environment for businesses. The GGDP is therefore advocating the following proposals among others for the revitalization of Georgetown:

A World Heritage City
Tree lined avenues
Beautiful lush gardens
Congregation areas
Congestion free city streets
Public Parking
On site parking
Broad walks along Demerara River Front
Recreation Area with landscaping, seating and lighting with security etc...along the seawall
Strategically placed and landscaped traffic round-abouts

How can we achieve this?

Only through:

Public-Private Partnerships
Effective and coordinated planning
Education and public awareness campaigns
Public partnership at all levels
Respect for the law
Inculcating good citizenship

Another critical function of the Department is its development facilitation and compliance function, where the Department has the responsibility of:

Monitoring and managing the nature and intensity of development which takes place on any area of land.
Inspecting and reporting to the Central Housing and Planning Authority Board on all building, land use and land subdivision applications or other proposals for development.
Ensuring that development complies with provisions contained in development plans, zoning plans, planning policy guidelines, etc.

Considering these responsibilities of the Planning and Settlement Development Department, it means therefore that prior to any development taking place planning permission is required. The planning permission process and requirements can be found in the Developer’s Manual. The Developer’s Manual has been prepared to assist individuals, planning professionals and developers wishing to apply for planning permission. It is intended that this manual should convey information to the public on the procedures involved in planning permit requirements for all types of development and also the process of evaluating and deciding on development applications.

Search

Resources

EoI - Spatial Development Plan for Eccles to Diamond Area, ECD RE-TENDER

EoI - Spatial Development Plan for Eccles to Diamond Area, ECD

ESMF August vf(1)

Sophia Stakeholder Engagement Plan Sept vf

Sophia ESA August_vf(3)

General Technical Specifications and Performance (IFB)

Invitation for Bids (Infrastructure Works at Amelia's Ward Ph 2, Perseverance Ph 3)

Town and Country Planning Act Chapter 20:01

Housing Act

Solid Waste Management Bill 2014 - (July 15, 2014) (1)

Guyana : National Integrated Solid Waste Management Strategy for the Cooperative Republic of Guyana 2017-2030

Canada-Guyana Partnership for Community Planning Project 2009-2012

Building Codes

Water & Sanitation Upgrade Programme

Developer's Manual

Guidance for the development of Gas Service Stations

Guidelines for the Development of Commercial Land at Lethem

Best Practices in the use of Cement and Concrete

1000 Homes Brochure

Remigrant Brochure

Notice to applications prior to December 2008

Apply for a loan

Hand-In-Hand Trust

New Building Society

Republic Bank Guyana Ltd.

Guyana Bank for Trade and Industry

Demerara Bank Ltd.

Citizens Bank

Scotiabank

Featured Videos

Click to View : Housing Solutions 2017 and Beyond

Housing Solutions 2017 and Beyond Views : 3767

Click to View : APNU+AFC First Year in Government with Hon. Valerie Patterson

APNU+AFC First Year in Government with Hon. Valerie Patterson Views : 4687

Click to View : GOG/IDB Second Low Income Settlements Programme Exit Workshop

GOG/IDB Second Low Income Settlements Programme Exit Workshop Views : 3917

Click to View : Guyana to transform Housing Sector under new Government

Guyana to transform Housing Sector under new Government Views : 4728

Housing Schemes

Mini Gallery

Support Center

You Can Reach our qualified and experienced staff willing to help.

Hotline: 592 223 7521
Fax: 592 225 4991
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Website: www.chpa.gov.gy

Mission Statement

To formulate policies in the Human Settlement and Water Sectors and to Monitor the implementation of plans, programmes and projects designed to satisfy the Housing and Water needs of the Population.

Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.611 MB / 0.61 MB Application: afterLoad

Time: 561.0 ms / 561.1 ms Memory: 4.422 MB / 5.03 MB Application: afterInitialise

Time: 195.8 ms / 756.9 ms Memory: 1.091 MB / 6.12 MB Application: afterRoute

Time: 164.0 ms / 920.9 ms Memory: 2.705 MB / 8.83 MB Application: afterDispatch

Time: 4.3 ms / 925.3 ms Memory: 0.207 MB / 9.04 MB Application: beforeRenderModule mod_custom (Mission Statement)

Time: 1.6 ms / 926.8 ms Memory: 0.042 MB / 9.08 MB Application: afterRenderModule mod_custom (Mission Statement)

Time: 0.1 ms / 926.9 ms Memory: 0.000 MB / 9.08 MB Application: beforeRenderModule mod_custom (Support Center)

Time: 1.3 ms / 928.2 ms Memory: 0.020 MB / 9.10 MB Application: afterRenderModule mod_custom (Support Center)

Time: 0.2 ms / 928.4 ms Memory: 0.016 MB / 9.12 MB Application: beforeRenderModule mod_joomimg (Mini Gallery)

Time: 34.6 ms / 963.1 ms Memory: 2.546 MB / 11.66 MB Application: afterRenderModule mod_joomimg (Mini Gallery)

Time: 0.2 ms / 963.2 ms Memory: 0.000 MB / 11.59 MB Application: beforeRenderModule mod_search (Search)

Time: 1.9 ms / 965.2 ms Memory: 0.034 MB / 11.62 MB Application: afterRenderModule mod_search (Search)

Time: 0.1 ms / 965.3 ms Memory: 0.000 MB / 11.62 MB Application: beforeRenderModule mod_custom (Resources)

Time: 0.4 ms / 965.6 ms Memory: 0.007 MB / 11.63 MB Application: afterRenderModule mod_custom (Resources)

Time: 0.1 ms / 965.7 ms Memory: 0.000 MB / 11.63 MB Application: beforeRenderModule mod_custom (Apply for a loan)

Time: 0.4 ms / 966.1 ms Memory: 0.007 MB / 11.63 MB Application: afterRenderModule mod_custom (Apply for a loan)

Time: 0.1 ms / 966.1 ms Memory: 0.000 MB / 11.63 MB Application: beforeRenderModule mod_allvideosharegallery (Featured Videos)

Time: 3.2 ms / 969.3 ms Memory: 0.121 MB / 11.75 MB Application: afterRenderModule mod_allvideosharegallery (Featured Videos)

Time: 0.1 ms / 969.4 ms Memory: 0.000 MB / 11.73 MB Application: beforeRenderModule mod_custom (Housing Schemes)

Time: 0.4 ms / 969.8 ms Memory: 0.007 MB / 11.74 MB Application: afterRenderModule mod_custom (Housing Schemes)

Time: 0.1 ms / 969.9 ms Memory: 0.000 MB / 11.73 MB Application: beforeRenderModule mod_whosonline (Who's Online)

Time: 66.5 ms / 1036.3 ms Memory: 0.971 MB / 12.70 MB Application: afterRenderModule mod_whosonline (Who's Online)

Time: 0.2 ms / 1036.5 ms Memory: 0.000 MB / 12.70 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.0 ms / 1038.6 ms Memory: 0.033 MB / 12.73 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.1 ms / 1038.7 ms Memory: 0.000 MB / 12.73 MB Application: beforeRenderModule mod_login (Login Form)

Time: 7.2 ms / 1045.9 ms Memory: 0.487 MB / 13.21 MB Application: afterRenderModule mod_login (Login Form)

Time: 0.1 ms / 1046.0 ms Memory: 0.000 MB / 13.21 MB Application: beforeRenderModule mod_custom (Slide)

Time: 0.4 ms / 1046.4 ms Memory: 0.007 MB / 13.22 MB Application: afterRenderModule mod_custom (Slide)

Time: 0.1 ms / 1046.6 ms Memory: 0.004 MB / 13.22 MB Application: beforeRenderModule mod_exmenu (Extended Menu)

Time: 12.9 ms / 1059.5 ms Memory: 0.891 MB / 14.11 MB Application: afterRenderModule mod_exmenu (Extended Menu)

Time: 6.8 ms / 1066.3 ms Memory: 0.525 MB / 14.64 MB Application: afterRender

Database queries total: 942.0 ms

Memory Usage

Database Queries

48 Queries Logged 942.0 ms

Query Time: 0.26 ms
```
SELECT `data`

  FROM `dv1tb_session`

  WHERE `session_id` = '59jndr0b98ja54a0uf3o5ekop6'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_session const PRIMARY PRIMARY 602 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:668
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 389.77 ms After last query: 1.90 ms
```
DELETE 

  FROM `dv1tb_session`

  WHERE `time` < '1575758855'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_session range time time 45 const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:685
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.32 ms After last query: 0.29 ms
```
SELECT `session_id`

  FROM `dv1tb_session`

  WHERE `session_id` = '59jndr0b98ja54a0uf3o5ekop6' 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_session const PRIMARY PRIMARY 602 const 1 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 115.92 ms After last query: 0.22 ms
```
INSERT INTO `dv1tb_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('59jndr0b98ja54a0uf3o5ekop6', 0, '1575848856')
```
Explain
EXPLAIN not possible on query: INSERT INTO `dv1tb_session` (`session_id`, `client_id`, `time`) VALUES ('59jndr0b98ja54a0uf3o5ekop6', 0, '1575848856')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_session	range	time	time	45	const	1	100.00	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_session	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

Query Time: 0.52 ms After last query: 4.54 ms

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

  FROM dv1tb_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:570

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.35 ms After last query: 1.66 ms

SELECT b.id

  FROM dv1tb_usergroups AS a

  LEFT JOIN dv1tb_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profile

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

Call Stack

JROOT/libraries/joomla/access/access.php:334

JROOT/libraries/joomla/access/access.php:403

JROOT/libraries/joomla/user/user.php:428

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:575

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.26 ms After last query: 0.76 ms
```
SELECT id, rules

  FROM `dv1tb_viewlevels`
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 0.23 ms
```
SELECT folder AS type, element AS name, params

  FROM dv1tb_extensions

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

  ORDER BY ordering
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_extensions ref extension extension 62 const 69 100.00 Using index condition; Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	extension	extension	62	const	69	100.00	Using index condition; Using where; Using filesort

Query Time: 0.30 ms After last query: 0.52 ms

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

  FROM dv1tb_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:628

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.29 ms After last query: 13.39 ms

SELECT `enabled`

  FROM `dv1tb_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/plugins/system/backuponupdate/backuponupdate.php:50

JROOT/libraries/cms/plugin/helper.php:232

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:582

JROOT/libraries/cms/application/site.php:649

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.84 ms After last query: 12.30 ms

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

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

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

  ORDER BY m.lft

Explain

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

Profile

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

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:353

JROOT/libraries/cms/application/site.php:279

JROOT/libraries/cms/router/site.php:158

JROOT/libraries/cms/router/router.php:379

JROOT/libraries/cms/router/router.php:186

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1018

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.30 ms After last query: 2.54 ms

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

  FROM dv1tb_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/plugins/system/jsn_system/jsn_system.php:19

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[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.28 ms
```
SELECT a.rules

  FROM dv1tb_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:248
JROOT/libraries/joomla/user/user.php:364
JROOT/plugins/system/jsn_system/jsn_system.php:99
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.14 ms After last query: 0.76 ms

SELECT b.rules

  FROM dv1tb_assets AS a

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

  WHERE (a.name = 'com_users')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	786	80.53	Using where

Profile

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

Call Stack

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/access/access.php:109

JROOT/libraries/joomla/user/user.php:373

JROOT/plugins/system/jsn_system/jsn_system.php:99

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.33 ms After last query: 1.73 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM dv1tb_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 180.74 ms After last query: 0.30 ms
```
UPDATE `dv1tb_extensions`

  SET `params` = '{\"mediaversion\":\"40f3f0e3e810d0073645cb03edbbbb96\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_extensions range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

Query Time: 0.47 ms After last query: 4.19 ms

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

  FROM dv1tb_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:328

JROOT/libraries/cms/application/site.php:135

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.29 ms After last query: 0.89 ms
```
SELECT *

  FROM dv1tb_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:166
JROOT/libraries/cms/application/site.php:336
JROOT/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

Query Time: 0.35 ms After last query: 0.48 ms

SELECT id, home, template, s.params

  FROM dv1tb_template_styles as s

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

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

Explain

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

Profile

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

Call Stack

JROOT/libraries/cms/application/site.php:486

JROOT/libraries/cms/application/site.php:165

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.79 ms After last query: 9.27 ms

SELECT b.rules

  FROM dv1tb_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	16	100.00	Using where

Profile

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

Call Stack

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/access/access.php:109

JROOT/libraries/joomla/user/user.php:373

JROOT/components/com_content/models/article.php:55

JROOT/libraries/legacy/model/legacy.php:415

JROOT/components/com_content/models/article.php:75

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.91 ms After last query: 0.67 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM dv1tb_content AS a

  LEFT JOIN dv1tb_categories AS c 
  on c.id = a.catid

  LEFT JOIN dv1tb_users AS u 
  on u.id = a.created_by

  LEFT JOIN dv1tb_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN dv1tb_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM dv1tb_categories AS cat JOIN dv1tb_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 49 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-08 23:47:36') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-08 23:47:36') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	5	100.00	Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	25	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

JROOT/components/com_content/models/article.php:158

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.42 ms After last query: 2.79 ms

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM dv1tb_categories as c

  LEFT JOIN dv1tb_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM dv1tb_categories AS cat JOIN dv1tb_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=35 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	25	48.00	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	chpagov_cpv2.c.id	5	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	25	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:41

JROOT/components/com_content/views/article/view.html.php:72

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.31 ms After last query: 2.60 ms

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

  FROM dv1tb_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/helper/tags.php:392

JROOT/components/com_content/views/article/view.html.php:155

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.36 ms After last query: 0.24 ms

SELECT `m`.`tag_id`,`t`.*

  FROM `dv1tb_contentitem_tag_map` AS m 

  INNER JOIN `dv1tb_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 49 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	chpagov_cpv2.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/views/article/view.html.php:155

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.97 ms After last query: 7.28 ms
```
SHOW FULL COLUMNS 
  FROM `dv1tb_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `dv1tb_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:301
JROOT/components/com_content/models/article.php:263
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.27 ms After last query: 2.25 ms
```
SELECT *

  FROM dv1tb_content

  WHERE `id` = '49'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_content const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:723
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 121.42 ms After last query: 0.24 ms
```
UPDATE dv1tb_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '49'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_content range PRIMARY PRIMARY 4 const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:1233
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Query Time: 0.90 ms After last query: 11.50 ms

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

  FROM dv1tb_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-08 23:47:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-08 23:47:36') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 60 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	31	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	chpagov_cpv2.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	chpagov_cpv2.m.module,const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/libraries/cms/module/helper.php:376

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:497

JROOT/templates/chpa/index.php:92

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:974

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.28 ms After last query: 6.04 ms

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

  FROM dv1tb_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:73

JROOT/modules/mod_joomimg/mod_joomimg.php:18

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 4.57 ms After last query: 6.99 ms
```
SHOW FULL COLUMNS 
  FROM `dv1tb_joomgallery_config`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `dv1tb_joomgallery_config`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:334
JROOT/libraries/joomla/table/table.php:301
JROOT/administrator/components/com_joomgallery/helpers/config.php:366
JROOT/administrator/components/com_joomgallery/helpers/config.php:429
JROOT/components/com_joomgallery/helpers/ambit.php:147
JROOT/components/com_joomgallery/helpers/ambit.php:220
JROOT/components/com_joomgallery/interface.php:102
JROOT/modules/mod_joomimg/mod_joomimg.php:43
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.69 ms After last query: 2.76 ms
```
SELECT *

  FROM dv1tb_joomgallery_config

  WHERE `id` = '1'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_joomgallery_config const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:723
JROOT/administrator/components/com_joomgallery/helpers/config.php:367
JROOT/administrator/components/com_joomgallery/helpers/config.php:429
JROOT/components/com_joomgallery/helpers/ambit.php:147
JROOT/components/com_joomgallery/helpers/ambit.php:220
JROOT/components/com_joomgallery/interface.php:102
JROOT/modules/mod_joomimg/mod_joomimg.php:43
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.34 ms After last query: 4.38 ms
```
SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner

  FROM dv1tb_joomgallery_catg AS c

  WHERE lft > 0 
  AND c.published = 1 
  AND c.access IN (1,1,5) 
  AND (c.password = '' OR c.cid IN (0))

  ORDER BY c.lft
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 16 100.00 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_joomgallery/helpers/ambit.php:492
JROOT/modules/mod_joomimg/helper.php:440
JROOT/modules/mod_joomimg/helper.php:47
JROOT/modules/mod_joomimg/mod_joomimg.php:52
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.48 ms After last query: 0.15 ms
```
SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount

  FROM dv1tb_joomgallery

  WHERE approved  = 1 
  AND published = 1 
  AND hidden    = 0 
  AND access IN (1,1,5)

  GROUP BY catid
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_joomgallery index idx_catid idx_catid 4 NULL 117 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_joomgallery/helpers/ambit.php:508
JROOT/modules/mod_joomimg/helper.php:440
JROOT/modules/mod_joomimg/helper.php:47
JROOT/modules/mod_joomimg/mod_joomimg.php:52
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_joomgallery	index	idx_catid	idx_catid	4	NULL	117	100.00	Using where

Query Time: 1.01 ms After last query: 0.19 ms

SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,c.cid AS ccid, c.catpath AS catpath

  FROM dv1tb_joomgallery AS p

  LEFT JOIN dv1tb_joomgallery_catg AS c 
  ON c.cid = p.catid

  WHERE c.published = 1 
  AND c.access IN (1,1,5) 
  AND p.published = 1 
  AND p.approved = 1 
  AND p.access IN (1,1,5) 
  AND p.catid IN (15,3,4,5,6,7) 
  AND c.hidden    = 0 
  AND c.in_hidden = 0 
  AND p.hidden    = 0

  ORDER BY rand() 
  LIMIT 0, 8

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	16	37.50	Using where; Using temporary; Using filesort
1	SIMPLE	p	ref	idx_catid	idx_catid	4	chpagov_cpv2.c.cid	5	100.00	Using where

Profile

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

Call Stack

JROOT/modules/mod_joomimg/helper.php:518

JROOT/modules/mod_joomimg/helper.php:47

JROOT/modules/mod_joomimg/mod_joomimg.php:52

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.56 ms After last query: 0.29 ms

SELECT id

  FROM dv1tb_menu

  WHERE link LIKE '%com_joomgallery%view=gallery%' 
  AND access IN (1,1,5) 
  AND published = 1 
  AND client_id = 0 
  AND (language = 'en-GB' OR language = '' OR language = '*')

  ORDER BY id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	72	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_joomgallery/helpers/ambit.php:426

JROOT/components/com_joomgallery/interface.php:304

JROOT/components/com_joomgallery/interface.php:370

JROOT/modules/mod_joomimg/helper.php:789

JROOT/modules/mod_joomimg/helper.php:100

JROOT/modules/mod_joomimg/mod_joomimg.php:52

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.48 ms After last query: 0.15 ms

SELECT id

  FROM dv1tb_menu

  WHERE link LIKE '%com_joomgallery%' 
  AND access IN (1,1,5) 
  AND published = 1 
  AND client_id = 0 
  AND (language = 'en-GB' OR language = '' OR language = '*')

  ORDER BY id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	72	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_joomgallery/helpers/ambit.php:438

JROOT/components/com_joomgallery/interface.php:304

JROOT/components/com_joomgallery/interface.php:370

JROOT/modules/mod_joomimg/helper.php:789

JROOT/modules/mod_joomimg/helper.php:100

JROOT/modules/mod_joomimg/mod_joomimg.php:52

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[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.85 ms

SELECT catpath

  FROM dv1tb_joomgallery_catg

  WHERE cid = 6

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_joomgallery/helpers/helper.php:141

JROOT/components/com_joomgallery/helpers/ambit.php:338

JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573

JROOT/libraries/cms/html/html.php:238

JROOT/libraries/cms/html/html.php:140

JROOT/components/com_joomgallery/interface.php:372

JROOT/modules/mod_joomimg/helper.php:789

JROOT/modules/mod_joomimg/helper.php:100

JROOT/modules/mod_joomimg/mod_joomimg.php:52

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.21 ms After last query: 0.58 ms

SELECT catpath

  FROM dv1tb_joomgallery_catg

  WHERE cid = 15

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_joomgallery/helpers/helper.php:141

JROOT/components/com_joomgallery/helpers/ambit.php:338

JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573

JROOT/libraries/cms/html/html.php:238

JROOT/libraries/cms/html/html.php:106

JROOT/components/com_joomgallery/interface.php:372

JROOT/modules/mod_joomimg/helper.php:789

JROOT/modules/mod_joomimg/helper.php:100

JROOT/modules/mod_joomimg/mod_joomimg.php:52

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.21 ms After last query: 1.57 ms

SELECT catpath

  FROM dv1tb_joomgallery_catg

  WHERE cid = 5

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_joomgallery/helpers/helper.php:141

JROOT/components/com_joomgallery/helpers/ambit.php:338

JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573

JROOT/libraries/cms/html/html.php:238

JROOT/libraries/cms/html/html.php:106

JROOT/components/com_joomgallery/interface.php:372

JROOT/modules/mod_joomimg/helper.php:789

JROOT/modules/mod_joomimg/helper.php:100

JROOT/modules/mod_joomimg/mod_joomimg.php:52

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.25 ms After last query: 1.13 ms

SELECT catpath

  FROM dv1tb_joomgallery_catg

  WHERE cid = 7

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_joomgallery/helpers/helper.php:141

JROOT/components/com_joomgallery/helpers/ambit.php:338

JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:573

JROOT/libraries/cms/html/html.php:238

JROOT/libraries/cms/html/html.php:106

JROOT/components/com_joomgallery/interface.php:372

JROOT/modules/mod_joomimg/helper.php:789

JROOT/modules/mod_joomimg/helper.php:100

JROOT/modules/mod_joomimg/mod_joomimg.php:52

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.21 ms After last query: 5.08 ms

SELECT name 
  FROM dv1tb_allvideoshare_categories 
  WHERE slug='chpa-videos'

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_allvideosharegallery/helper.php:78

JROOT/modules/mod_allvideosharegallery/helper.php:30

JROOT/modules/mod_allvideosharegallery/mod_allvideosharegallery.php:22

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.33 ms After last query: 0.12 ms

SELECT * 
  FROM dv1tb_allvideoshare_videos 
  WHERE published=1 
  AND category='CHPA Videos' 
  ORDER BY id DESC

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_allvideosharegallery/helper.php:66

JROOT/modules/mod_allvideosharegallery/mod_allvideosharegallery.php:22

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[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.12 ms

SELECT responsive 
  FROM dv1tb_allvideoshare_config

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_allvideosharegallery/helper.php:85

JROOT/modules/mod_allvideosharegallery/mod_allvideosharegallery.php:23

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 12.28 ms After last query: 2.72 ms

SELECT guest, client_id

  FROM dv1tb_session

  WHERE client_id = 0

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	10.8 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_whosonline/helper.php:41

JROOT/modules/mod_whosonline/mod_whosonline.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.42 ms After last query: 56.78 ms

SELECT `link`

  FROM `dv1tb_menu`

  WHERE `published`=1 
  AND `id`='63'

Explain

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

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_login/helper.php:47

JROOT/modules/mod_login/mod_login.php:18

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.63 ms After last query: 12.50 ms

SELECT m.* 
  FROM dv1tb_menu AS m 
  WHERE menutype='mainmenu' 
  AND published = 1 
  AND access IN (1,1,5) 
  ORDER BY lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_menutype	idx_menutype	74	const	37	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_exmenu/exmenu/loader/menu.menuloader.class.php:138

JROOT/modules/mod_exmenu/exmenu/loader/menu.menuloader.class.php:21

JROOT/modules/mod_exmenu/exmenu/exmenu.class.php:326

JROOT/modules/mod_exmenu/exmenu/exmenu.class.php:59

JROOT/modules/mod_exmenu/mod_exmenu.php:54

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.26 ms After last query: 9.69 ms

SELECT `profile`, `name`, `value` 
  FROM `dv1tb_magiczoom_config` 
  WHERE `disabled`='0'

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/magiczoom/magiczoom.php:125

JROOT/plugins/system/magiczoom/magiczoom.php:68

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:994

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 97.62 ms After last query: 2.93 ms

UPDATE `dv1tb_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1575848855;s:18:\"session.timer.last\";i:1575848855;s:17:\"session.timer.now\";i:1575848855;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:9:\"com_users\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"profile\";O:8:\"stdClass\":1:{s:2:\"id\";i:0;}}}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:11:\"cookieLogin\";s:0:\"\";}s:15:\"jsn_original_id\";i:0;s:13:\"session.token\";s:32:\"15f5d2ae4d8be4207babc51eea7b756b\";}'
	, `time` = '1575848856'

  WHERE `session_id` = '59jndr0b98ja54a0uf3o5ekop6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dv1tb_session	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.1 ms
end	0.0 ms
query end	97.3 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:85

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

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM dv1tb_extensions

4 × SELECT catpath 
  FROM dv1tb_joomgallery_catg

2 × SELECT b.rules 
  FROM dv1tb_assets AS a 
  LEFT JOIN dv1tb_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

```
2 × SELECT id 
  FROM dv1tb_menu
```

1 × SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,c.cid AS ccid, c.catpath AS catpath 
  FROM dv1tb_joomgallery AS p 
  LEFT JOIN dv1tb_joomgallery_catg AS c 
  ON c.cid = p.catid

1 × SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner 
  FROM dv1tb_joomgallery_catg AS c

1 × SELECT * 
  FROM dv1tb_joomgallery_config

1 × SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount 
  FROM dv1tb_joomgallery

1 × SELECT * 
  FROM dv1tb_allvideoshare_videos

1 × SELECT m.* 
  FROM dv1tb_menu AS m

1 × SELECT `profile`, `name`, `value` 
  FROM `dv1tb_magiczoom_config`

1 × SELECT `link` 
  FROM `dv1tb_menu`

1 × SELECT guest, client_id 
  FROM dv1tb_session

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

1 × SELECT responsive 
  FROM dv1tb_allvideoshare_confi

1 × SELECT name 
  FROM dv1tb_allvideoshare_categories

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `dv1tb_contentitem_tag_map` AS m  
  INNER JOIN `dv1tb_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT folder AS type, element AS name, params 
  FROM dv1tb_extensions

1 × SELECT `enabled` 
  FROM `dv1tb_extensions`

1 × SELECT id, rules 
  FROM `dv1tb_viewlevels

1 × SELECT b.id 
  FROM dv1tb_usergroups AS a 
  LEFT JOIN dv1tb_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `session_id` 
  FROM `dv1tb_session`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM dv1tb_menu AS m 
  LEFT JOIN dv1tb_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT a.rules 
  FROM dv1tb_assets AS a

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM dv1tb_categories as c 
  LEFT JOIN dv1tb_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM dv1tb_categories AS cat JOIN dv1tb_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `data` 
  FROM `dv1tb_session`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM dv1tb_content AS a 
  LEFT JOIN dv1tb_categories AS c 
  on c.id = a.catid 
  LEFT JOIN dv1tb_users AS u 
  on u.id = a.created_by 
  LEFT JOIN dv1tb_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN dv1tb_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM dv1tb_categories AS cat JOIN dv1tb_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

```
1 × SELECT * 
  FROM dv1tb_languages
```
```
1 × SELECT * 
  FROM dv1tb_content
```

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `dv1tb_joomgallery_config

1 × UPDATE `dv1tb_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1575848855;s:18:\"session.timer.last\";i:1575848855;s:17:\"session.timer.now\";i:1575848855;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:9:\"com_users\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"profile\";O:8:\"stdClass\":1:{s:2:\"id\";i:0;}}}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:11:\"cookieLogin\";s:0:\"\";}s:15:\"jsn_original_id\";i:0;s:13:\"session.token\";s:32:\"15f5d2ae4d8be4207babc51eea7b756b\";}'  , `time` = '1575848856'

1 × UPDATE dv1tb_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `dv1tb_content

1 × INSERT INTO `dv1tb_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('59jndr0b98ja54a0uf3o5ekop6', 0, '1575848856'

1 × UPDATE `dv1tb_extensions` 
  SET `params` = '{\"mediaversion\":\"40f3f0e3e810d0073645cb03edbbbb96\"}'

```
1 × DELETE  
  FROM `dv1tb_session`
```

Planning & Settlement Development

How can we achieve this?

Search

Resources

Apply for a loan

Featured Videos

Housing Schemes

Who's Online

Mini Gallery

Support Center

Mission Statement

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

48 Queries Logged 942.0 ms

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: