Photo Gallery

Diamond_9

60 60 59 59 58 58 57 57 56 56 55 55 54 54 53 53 52 52 51 51 50 50 49 49 48 48 47 47 46 46 45 45 44 44 43 43

[Please activate JavaScript in order to see the slideshow]

41 41 40 40 39 39 38 38 37 37 36 36 35 35 34 34

Total images in all categories: 83

Home » Housing Schemes » Diamond » Diamond_9

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 : 3760

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

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

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

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

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: 73.5 ms / 73.5 ms Memory: 4.422 MB / 5.03 MB Application: afterInitialise

Time: 39.8 ms / 113.3 ms Memory: 1.119 MB / 6.15 MB Application: afterRoute

Time: 57.9 ms / 171.2 ms Memory: 3.834 MB / 9.99 MB Application: afterDispatch

Time: 1.9 ms / 173.2 ms Memory: 0.060 MB / 10.05 MB Application: beforeRenderModule mod_custom (Mission Statement)

Time: 7.6 ms / 180.8 ms Memory: 0.479 MB / 10.53 MB Application: afterRenderModule mod_custom (Mission Statement)

Time: 0.1 ms / 180.9 ms Memory: 0.000 MB / 10.53 MB Application: beforeRenderModule mod_custom (Support Center)

Time: 1.2 ms / 182.0 ms Memory: 0.020 MB / 10.55 MB Application: afterRenderModule mod_custom (Support Center)

Time: 0.2 ms / 182.3 ms Memory: 0.016 MB / 10.56 MB Application: beforeRenderModule mod_joomimg (Mini Gallery)

Time: 12.9 ms / 195.2 ms Memory: 0.837 MB / 11.40 MB Application: afterRenderModule mod_joomimg (Mini Gallery)

Time: 0.1 ms / 195.3 ms Memory: 0.000 MB / 11.33 MB Application: beforeRenderModule mod_search (Search)

Time: 1.7 ms / 197.1 ms Memory: 0.036 MB / 11.36 MB Application: afterRenderModule mod_search (Search)

Time: 0.1 ms / 197.1 ms Memory: 0.000 MB / 11.36 MB Application: beforeRenderModule mod_custom (Resources)

Time: 0.3 ms / 197.5 ms Memory: 0.007 MB / 11.37 MB Application: afterRenderModule mod_custom (Resources)

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

Time: 0.3 ms / 197.9 ms Memory: 0.007 MB / 11.37 MB Application: afterRenderModule mod_custom (Apply for a loan)

Time: 0.1 ms / 198.0 ms Memory: 0.000 MB / 11.37 MB Application: beforeRenderModule mod_allvideosharegallery (Featured Videos)

Time: 3.1 ms / 201.1 ms Memory: 0.122 MB / 11.49 MB Application: afterRenderModule mod_allvideosharegallery (Featured Videos)

Time: 0.1 ms / 201.2 ms Memory: 0.000 MB / 11.47 MB Application: beforeRenderModule mod_custom (Housing Schemes)

Time: 0.3 ms / 201.5 ms Memory: 0.007 MB / 11.48 MB Application: afterRenderModule mod_custom (Housing Schemes)

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

Time: 103.8 ms / 305.3 ms Memory: 1.985 MB / 13.46 MB Application: afterRenderModule mod_whosonline (Who's Online)

Time: 0.2 ms / 305.5 ms Memory: 0.000 MB / 13.46 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 3.2 ms / 308.7 ms Memory: 0.120 MB / 13.58 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.1 ms / 308.8 ms Memory: 0.000 MB / 13.57 MB Application: beforeRenderModule mod_login (Login Form)

Time: 6.9 ms / 315.7 ms Memory: 0.496 MB / 14.06 MB Application: afterRenderModule mod_login (Login Form)

Time: 0.1 ms / 315.8 ms Memory: 0.000 MB / 14.06 MB Application: beforeRenderModule mod_custom (Slide)

Time: 0.4 ms / 316.2 ms Memory: 0.007 MB / 14.07 MB Application: afterRenderModule mod_custom (Slide)

Time: 0.1 ms / 316.3 ms Memory: 0.004 MB / 14.07 MB Application: beforeRenderModule mod_exmenu (Extended Menu)

Time: 12.7 ms / 329.0 ms Memory: 0.895 MB / 14.97 MB Application: afterRenderModule mod_exmenu (Extended Menu)

Time: 8.5 ms / 337.6 ms Memory: 0.632 MB / 15.60 MB Application: afterRender

Database queries total: 111.5 ms

Memory Usage

Database Queries

42 Queries Logged 111.5 ms

Query Time: 0.29 ms
```
SELECT `data`

  FROM `dv1tb_session`

  WHERE `session_id` = '1haj63bdt7mv6aji1tu52p63h2'
```
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: 0.25 ms After last query: 1.76 ms
```
DELETE 

  FROM `dv1tb_session`

  WHERE `time` < '1575567837'
```
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.18 ms After last query: 0.14 ms
```
SELECT `session_id`

  FROM `dv1tb_session`

  WHERE `session_id` = '1haj63bdt7mv6aji1tu52p63h2' 
  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: 20.41 ms After last query: 0.14 ms
```
INSERT INTO `dv1tb_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('1haj63bdt7mv6aji1tu52p63h2', 0, '1575657837')
```
Explain
EXPLAIN not possible on query: INSERT INTO `dv1tb_session` (`session_id`, `client_id`, `time`) VALUES ('1haj63bdt7mv6aji1tu52p63h2', 0, '1575657837')
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.30 ms After last query: 4.20 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.27 ms After last query: 1.50 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.29 ms After last query: 0.74 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.59 ms After last query: 0.22 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.29 ms After last query: 0.48 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.25 ms After last query: 12.55 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.77 ms After last query: 11.43 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.26 ms After last query: 2.35 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.26 ms After last query: 0.27 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.00 ms After last query: 0.71 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.26 ms After last query: 1.65 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: 25.73 ms After last query: 0.32 ms
```
UPDATE `dv1tb_extensions`

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

  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.40 ms After last query: 4.12 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: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.68 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.34 ms After last query: 0.37 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: 4.27 ms After last query: 9.66 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/controller.php:71
JROOT/libraries/legacy/controller/legacy.php:308
JROOT/components/com_joomgallery/joomgallery.php:38
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.73 ms After last query: 3.71 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/controller.php:71
JROOT/libraries/legacy/controller/legacy.php:308
JROOT/components/com_joomgallery/joomgallery.php:38
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.20 ms After last query: 10.20 ms
```
SELECT catid

  FROM dv1tb_joomgallery

  WHERE id  = 42
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_joomgallery const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_joomgallery/models/detail.php:499
JROOT/components/com_joomgallery/models/detail.php:276
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_joomgallery/views/detail/view.html.php:45
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_joomgallery/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_joomgallery/joomgallery.php:41
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.64 ms After last query: 0.19 ms
```
SELECT a.*, a.owner AS imgowner, c.metadesc AS catmetadesc, c.metakey AS catmetakey,ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 5), 2) AS rating

  FROM dv1tb_joomgallery AS a

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

  WHERE a.catid = 5 
  AND a.published = 1 
  AND a.approved  = 1 
  AND (a.hidden = 0 OR a.id = 42) 
  AND a.access   IN (1,1,5) 
  AND c.access   IN (1,1,5)

  ORDER BY a.ordering ASC,a.imgdate DESC,a.imgtitle DESC
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c const PRIMARY PRIMARY 4 const 1 100.00 Using filesort
1 SIMPLE a ref PRIMARY,idx_catid idx_catid 4 const 27 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_joomgallery/models/detail.php:528
JROOT/components/com_joomgallery/models/detail.php:276
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_joomgallery/views/detail/view.html.php:45
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_joomgallery/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_joomgallery/joomgallery.php:41
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.29 ms After last query: 0.65 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/components/com_joomgallery/models/detail.php:162
JROOT/components/com_joomgallery/models/detail.php:278
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_joomgallery/views/detail/view.html.php:45
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_joomgallery/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_joomgallery/joomgallery.php:41
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.41 ms After last query: 0.16 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/components/com_joomgallery/models/detail.php:162
JROOT/components/com_joomgallery/models/detail.php:278
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_joomgallery/views/detail/view.html.php:45
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_joomgallery/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_joomgallery/joomgallery.php:41
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.20 ms After last query: 0.34 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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_joomgallery/helpers/helper.php:141
JROOT/components/com_joomgallery/helpers/ambit.php:338
JROOT/components/com_joomgallery/models/detail.php:172
JROOT/components/com_joomgallery/models/detail.php:278
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_joomgallery/views/detail/view.html.php:45
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_joomgallery/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_joomgallery/joomgallery.php:41
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_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	dv1tb_joomgallery	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	const	PRIMARY	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	ref	PRIMARY,idx_catid	idx_catid	4	const	27	100.00	Using where

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: 0.76 ms After last query: 7.95 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-06 18:43:57') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-06 18:43:57') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 82 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/components/com_joomgallery/helpers/helper.php:499

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

JROOT/components/com_joomgallery/views/detail/view.html.php:171

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

JROOT/components/com_joomgallery/controller.php:100

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

JROOT/components/com_joomgallery/joomgallery.php:41

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.24 ms After last query: 0.76 ms
```
SELECT *, 500 AS maxzindex

  FROM dv1tb_joomgallery_nameshields

  WHERE npicid = 42
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dv1tb_joomgallery_nameshields ref idx_picid idx_picid 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_joomgallery/models/detail.php:563
JROOT/components/com_joomgallery/models/detail.php:305
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_joomgallery/views/detail/view.html.php:328
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_joomgallery/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_joomgallery/joomgallery.php:41
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_joomgallery_nameshields	ref	idx_picid	idx_picid	4	const	1	100.00	NULL

Query Time: 0.99 ms After last query: 31.32 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

Status	Duration
starting	0.1 ms
checking permissions	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
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.4 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	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_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.53 ms After last query: 0.33 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.47 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.21 ms After last query: 0.67 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.19 ms After last query: 0.55 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: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.19 ms After last query: 0.56 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.20 ms After last query: 5.92 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.31 ms After last query: 0.11 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.19 ms After last query: 0.13 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: 16.95 ms After last query: 2.64 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	22361	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	16.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_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.33 ms After last query: 90.41 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.23 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.25 ms After last query: 10.37 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: 29.93 ms After last query: 4.04 ms

UPDATE `dv1tb_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1575657837;s:18:\"session.timer.last\";i:1575657837;s:17:\"session.timer.now\";i:1575657837;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:\"9cab4bb225dec3242c7dc13f64e16e4a\";}'
	, `time` = '1575657838'

  WHERE `session_id` = '1haj63bdt7mv6aji1tu52p63h2'

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.1 ms
System lock	0.0 ms
updating	0.2 ms
end	0.0 ms
query end	29.5 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]

34 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

4 × SELECT catpath 
  FROM dv1tb_joomgallery_catg

```
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 *, 500 AS maxzindex 
  FROM dv1tb_joomgallery_nameshields

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 name 
  FROM dv1tb_allvideoshare_categories

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 responsive 
  FROM dv1tb_allvideoshare_confi

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 a.*, a.owner AS imgowner, c.metadesc AS catmetadesc, c.metakey AS catmetakey,ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 5), 2) AS rating 
  FROM dv1tb_joomgallery AS a 
  LEFT JOIN dv1tb_joomgallery_catg AS c 
  ON c.cid = a.catid

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 * 
  FROM dv1tb_joomgallery_config

1 × SELECT catid 
  FROM dv1tb_joomgallery

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 b.rules 
  FROM dv1tb_assets AS a 
  LEFT JOIN dv1tb_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `data` 
  FROM `dv1tb_session`

OTHER Tables:

1 × UPDATE `dv1tb_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1575657837;s:18:\"session.timer.last\";i:1575657837;s:17:\"session.timer.now\";i:1575657837;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:\"9cab4bb225dec3242c7dc13f64e16e4a\";}'  , `time` = '1575657838'

1 × SHOW FULL COLUMNS 
  FROM `dv1tb_joomgallery_config

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

1 × INSERT INTO `dv1tb_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('1haj63bdt7mv6aji1tu52p63h2', 0, '1575657837'

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