Strict Standards: Only variables should be assigned by reference in /home/customer/www/theoverlander.org/public_html/modules/mod_date2/mod_date2.php on line 49

Monday, 25 January 2021, 05:22:35

POI Campsites

Moderators: stan, Chris S, Zoltan

Post Reply

3 posts • Page 1 of 1

steffUK: Gold; Posts: 353; Joined: Mon Jan 12, 2015 7:58 pm; Contact:
Contact steffUK

Website

POI Campsites

Quote

Postby steffUK » Mon Jun 01, 2015 3:37 pm

Hi All,
During my travels in the interweb I found this site which offers free download of over 31 thousand camp sites in Europe. Tried it and it worked, have them now on my Garmin.

http://www.archiescampings.eu/eng1/

In addition bought the very nicely done brit stops http://britstops.com/ book which gives you the co-ordinates of many free places to stay for 24 hours, some of them farms, pubs, community centres.

Maybe interesting for others here
Steff

Top

Brian-reynolds: Gold; Posts: 1640; Joined: Thu May 03, 2012 8:05 pm; Location: Sheffield; Contact:
Contact Brian-reynolds

Website

Re: POI Campsites

Quote

Postby Brian-reynolds » Tue Jun 02, 2015 7:23 am

That sounds interesting Steff, I will have a look at them when no one is looking.....

B.

Top

jamest: Gold; Posts: 193; Joined: Fri Jan 02, 2015 11:44 am; Location: Bristol/London

Re: POI Campsites

Quote

Postby jamest » Fri Jun 05, 2015 2:28 pm

The campingcar-infos.com website is very good if you can manage the French. Great for the continent and pics so you can see if you will fit :)

Top

Post Reply

3 posts • Page 1 of 1

Return to “Navigation / Communication”

Who is online

Users browsing this forum: No registered users and 1 guest

29 Queries Logged 13.4 ms

5 duplicate found!

2 duplicates: #17 #18

3 duplicates: #22 #23 #24

Query Time: 0.40 ms
```
SELECT `data`

  FROM `ovl_session`

  WHERE `session_id` = '5k7ucleel008ipdrscsrvj38l4'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_session NULL 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:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.58 ms After last query: 1.15 ms
```
DELETE 

  FROM `ovl_session`

  WHERE `time` < '1611544955'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 DELETE ovl_session NULL 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:49
[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.14 ms
```
SELECT `session_id`

  FROM `ovl_session`

  WHERE `session_id` = '5k7ucleel008ipdrscsrvj38l4' 
  LIMIT 0, 1
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_session NULL 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:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.25 ms After last query: 0.10 ms
```
INSERT INTO `ovl_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('5k7ucleel008ipdrscsrvj38l4', 0, '1611548555')
```
Explain
EXPLAIN not possible on query: INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) VALUES ('5k7ucleel008ipdrscsrvj38l4', 0, '1611548555')
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:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	ovl_session	NULL	range	time	time	45	const	1	100.00	Using where

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

Query Time: 0.53 ms After last query: 3.38 ms

SELECT b.id

  FROM ovl_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	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:52

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

Query Time: 0.28 ms After last query: 0.44 ms
```
SELECT id, rules

  FROM `ovl_viewlevels`
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_viewlevels NULL 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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

Query Time: 1.32 ms After last query: 21.60 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 ovl_menu AS m

  LEFT JOIN ovl_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	202	5.99	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	db59gacpy8p5zb.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:218

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

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

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

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

Query Time: 0.52 ms After last query: 11.17 ms
```
UPDATE `ovl_extensions`

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

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 UPDATE ovl_extensions NULL 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/k2/k2.php:52
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ovl_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Query Time: 1.49 ms After last query: 113.77 ms

SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM ovl_modules AS m

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

  LEFT JOIN ovl_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.client_id = 0 
  AND m.access IN (1,1,5)

  ORDER BY m.ordering, m.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	145	5.17	Using where; Using filesort
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	db59gacpy8p5zb.m.id	1	100.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	db59gacpy8p5zb.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/plugins/system/advancedmodules/modulehelper.php:443

JROOT/plugins/system/advancedmodules/modulehelper.php:102

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

JROOT/templates/overlander/includes/params.php:63

JROOT/templates/overlander/index.php:13

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/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.30 ms After last query: 18.96 ms
```
SELECT m.menutype

  FROM ovl_menu AS m

  WHERE m.id = 106
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE m NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/nnframework/helpers/assignments/menu.php:80
JROOT/plugins/system/nnframework/helpers/assignments/menu.php:28
JROOT/plugins/system/nnframework/helpers/assignments.php:345
JROOT/plugins/system/nnframework/helpers/assignments.php:290
JROOT/plugins/system/advancedmodules/advancedmodules.php:483
JROOT/libraries/joomla/event/dispatcher.php:167
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/advancedmodules/modulehelper.php:496
JROOT/plugins/system/advancedmodules/modulehelper.php:102
JROOT/libraries/joomla/document/html/html.php:497
JROOT/templates/overlander/includes/params.php:63
JROOT/templates/overlander/index.php:13
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/components/com_p8pbb/p8pbb.php:730
JROOT/forum/includes/hooks/index.php:143
JROOT/forum/includes/functions.php:5568
JROOT/forum/includes/functions.php:5521
JROOT/forum/cache/data_php_viewtopic.php:2265
JROOT/components/com_p8pbb/controller.php:113
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_p8pbb/p8pbb.php:1638
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:52
[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.30 ms
```
SELECT t.parent_id

  FROM ovl_menu as t

  WHERE t.id = 106
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/nnframework/helpers/assignment.php:161
JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65
JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47
JROOT/plugins/system/nnframework/helpers/assignments.php:345
JROOT/plugins/system/nnframework/helpers/assignments.php:290
JROOT/plugins/system/advancedmodules/advancedmodules.php:483
JROOT/libraries/joomla/event/dispatcher.php:167
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/advancedmodules/modulehelper.php:496
JROOT/plugins/system/advancedmodules/modulehelper.php:102
JROOT/libraries/joomla/document/html/html.php:497
JROOT/templates/overlander/includes/params.php:63
JROOT/templates/overlander/index.php:13
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/components/com_p8pbb/p8pbb.php:730
JROOT/forum/includes/hooks/index.php:143
JROOT/forum/includes/functions.php:5568
JROOT/forum/includes/functions.php:5521
JROOT/forum/cache/data_php_viewtopic.php:2265
JROOT/components/com_p8pbb/controller.php:113
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_p8pbb/p8pbb.php:1638
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.15 ms After last query: 0.10 ms
```
SELECT t.parent_id

  FROM ovl_menu as t

  WHERE t.id = 1
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/nnframework/helpers/assignment.php:161
JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65
JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47
JROOT/plugins/system/nnframework/helpers/assignments.php:345
JROOT/plugins/system/nnframework/helpers/assignments.php:290
JROOT/plugins/system/advancedmodules/advancedmodules.php:483
JROOT/libraries/joomla/event/dispatcher.php:167
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/advancedmodules/modulehelper.php:496
JROOT/plugins/system/advancedmodules/modulehelper.php:102
JROOT/libraries/joomla/document/html/html.php:497
JROOT/templates/overlander/includes/params.php:63
JROOT/templates/overlander/index.php:13
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/components/com_p8pbb/p8pbb.php:730
JROOT/forum/includes/hooks/index.php:143
JROOT/forum/includes/functions.php:5568
JROOT/forum/includes/functions.php:5521
JROOT/forum/cache/data_php_viewtopic.php:2265
JROOT/components/com_p8pbb/controller.php:113
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_p8pbb/p8pbb.php:1638
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.44 ms After last query: 16.83 ms
```
SELECT *

  FROM ovl_banners

  WHERE '2021-01-25 04:22:35' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!=NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_banners/helpers/banners.php:80
JROOT/modules/mod_banners/mod_banners.php:19
JROOT/plugins/system/advancedmodules/modulehelper.php:196
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/components/com_p8pbb/p8pbb.php:730
JROOT/forum/includes/hooks/index.php:143
JROOT/forum/includes/functions.php:5568
JROOT/forum/includes/functions.php:5521
JROOT/forum/cache/data_php_viewtopic.php:2265
JROOT/components/com_p8pbb/controller.php:113
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_p8pbb/p8pbb.php:1638
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE

Query Time: 0.56 ms After last query: 1.23 ms

SELECT COUNT(*)

  FROM ovl_banners as a

  LEFT JOIN ovl_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state	idx_state	1	const	1	20.00	Using where
1	SIMPLE	cl	NULL	eq_ref	PRIMARY	PRIMARY	4	db59gacpy8p5zb.a.cid	1	100.00	Using index

Profile

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

Call Stack

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

JROOT/libraries/legacy/model/list.php:276

JROOT/libraries/legacy/model/list.php:310

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_banners/models/banners.php:192

JROOT/modules/mod_banners/helper.php:45

JROOT/modules/mod_banners/mod_banners.php:20

JROOT/plugins/system/advancedmodules/modulehelper.php:196

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/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.43 ms After last query: 0.10 ms

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM ovl_banners as a

  LEFT JOIN ovl_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state	idx_state	1	const	1	20.00	Using index condition; Using where; Using filesort
1	SIMPLE	cl	NULL	eq_ref	PRIMARY	PRIMARY	4	db59gacpy8p5zb.a.cid	1	100.00	NULL

Profile

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

Call Stack

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

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_banners/models/banners.php:192

JROOT/modules/mod_banners/helper.php:45

JROOT/modules/mod_banners/mod_banners.php:20

JROOT/plugins/system/advancedmodules/modulehelper.php:196

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/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

UPDATE ovl_banners

  SET impmade = (impmade + 1)

  WHERE id = 2

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ovl_banners	NULL	range	PRIMARY	PRIMARY	4	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	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_banners/models/banners.php:231

JROOT/modules/mod_banners/helper.php:46

JROOT/modules/mod_banners/mod_banners.php:20

JROOT/plugins/system/advancedmodules/modulehelper.php:196

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/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Duplicate queries: #18

SELECT `count`

  FROM ovl_banner_tracks

  WHERE track_type=1 
  AND banner_id=2 
  AND track_date='2021-01-25 04'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_banner_tracks	NULL	const	PRIMARY,idx_track_date,idx_track_type,idx_banner_id	PRIMARY	13	const,const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.1 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_banners/models/banners.php:266

JROOT/modules/mod_banners/helper.php:46

JROOT/modules/mod_banners/mod_banners.php:20

JROOT/plugins/system/advancedmodules/modulehelper.php:196

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/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.16 ms After last query: 0.07 ms

Duplicate queries: #17

SELECT `count`

  FROM ovl_banner_tracks

  WHERE track_type=1 
  AND banner_id=2 
  AND track_date='2021-01-25 04'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_banner_tracks	NULL	const	PRIMARY,idx_track_date,idx_track_type,idx_banner_id	PRIMARY	13	const,const,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_banners/models/banners.php:273

JROOT/modules/mod_banners/helper.php:46

JROOT/modules/mod_banners/mod_banners.php:20

JROOT/plugins/system/advancedmodules/modulehelper.php:196

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/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.28 ms After last query: 0.09 ms

UPDATE ovl_banner_tracks

  SET `count` = (`count` + 1)

  WHERE track_type=1 
  AND banner_id=2 
  AND track_date='2021-01-25 04'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ovl_banner_tracks	NULL	range	PRIMARY,idx_track_date,idx_track_type,idx_banner_id	PRIMARY	13	const,const,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.1 ms
updating	0.0 ms
end	0.0 ms
query end	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_banners/models/banners.php:303

JROOT/modules/mod_banners/helper.php:46

JROOT/modules/mod_banners/mod_banners.php:20

JROOT/plugins/system/advancedmodules/modulehelper.php:196

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/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 1.19 ms After last query: 51.36 ms

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 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
checking permissions	0.7 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/f0f/table/table.php:2061

JROOT/libraries/f0f/table/table.php:536

JROOT/libraries/extly/tables/extension.php:33

JROOT/libraries/f0f/table/table.php:433

JROOT/libraries/f0f/model/model.php:2037

JROOT/libraries/f0f/model/model.php:1994

JROOT/libraries/extly/models/extensions.php:75

JROOT/libraries/f0f/model/model.php:1219

JROOT/libraries/extly/helpers/extension.php:78

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:40

JROOT/plugins/system/xtdir/xtdir.php:38

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.76 ms After last query: 0.34 ms

SHOW FULL COLUMNS 
  FROM `ovl_extensions`

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.3 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
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/f0f/table/table.php:2146

JROOT/libraries/f0f/table/table.php:536

JROOT/libraries/extly/tables/extension.php:33

JROOT/libraries/f0f/table/table.php:433

JROOT/libraries/f0f/model/model.php:2037

JROOT/libraries/f0f/model/model.php:1994

JROOT/libraries/extly/models/extensions.php:75

JROOT/libraries/f0f/model/model.php:1219

JROOT/libraries/extly/helpers/extension.php:78

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:40

JROOT/plugins/system/xtdir/xtdir.php:38

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.46 ms After last query: 1.38 ms

Duplicate queries: #23 #24

SELECT *

  FROM `ovl_extensions`

  WHERE `folder` = 'system' 
  AND `element` = 'xtdir'

  ORDER BY extension_id ASC 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	10.00	Using index condition; Using where; Using filesort

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
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/libraries/f0f/model/model.php:1953

JROOT/libraries/f0f/model/model.php:1225

JROOT/libraries/extly/helpers/extension.php:78

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:40

JROOT/plugins/system/xtdir/xtdir.php:38

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Duplicate queries: #22 #24

SELECT *

  FROM `ovl_extensions`

  WHERE `folder` = 'system' 
  AND `element` = 'xtdir'

  ORDER BY extension_id ASC 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	10.00	Using index condition; Using where; Using filesort

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
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	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/libraries/f0f/model/model.php:1953

JROOT/libraries/f0f/model/model.php:1225

JROOT/libraries/extly/helpers/extension.php:78

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:42

JROOT/plugins/system/xtdir/xtdir.php:38

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Duplicate queries: #22 #23

SELECT *

  FROM `ovl_extensions`

  WHERE `folder` = 'system' 
  AND `element` = 'xtdir'

  ORDER BY extension_id ASC 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	10.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.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/libraries/f0f/model/model.php:1953

JROOT/libraries/f0f/model/model.php:1225

JROOT/libraries/extly/helpers/extension.php:78

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:43

JROOT/plugins/system/xtdir/xtdir.php:38

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

SELECT last_update

  FROM `ovl_xtdir_trees`

  ORDER BY id desc 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_xtdir_trees	NULL	index	NULL	id	4	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 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
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/administrator/components/com_xtdir/helpers/treeindexer.php:648

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:58

JROOT/plugins/system/xtdir/xtdir.php:39

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.13 ms After last query: 0.15 ms

SELECT id, last_update

  FROM `ovl_xtdir_trees`

  ORDER BY id desc 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_xtdir_trees	NULL	index	NULL	id	4	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
Sorting result	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/administrator/components/com_xtdir/helpers/treeindexer.php:195

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:115

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:80

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:66

JROOT/plugins/system/xtdir/xtdir.php:39

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.27 ms After last query: 0.10 ms

SELECT count(*)

  FROM `ovl_sobipro_object`

  WHERE updatedTime > '2020-09-11 07:39:03'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_object	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	79	33.33	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 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/administrator/components/com_xtdir/helpers/treeindexer.php:214

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:115

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:80

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:66

JROOT/plugins/system/xtdir/xtdir.php:39

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.46 ms After last query: 0.08 ms

SELECT count(*)

  FROM `ovl_sobipro_field_data` AS `d`

  WHERE updatedTime > '2020-09-11 07:39:03'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	d	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	582	33.33	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 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.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/administrator/components/com_xtdir/helpers/treeindexer.php:230

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:115

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:80

JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:66

JROOT/plugins/system/xtdir/xtdir.php:39

JROOT/plugins/system/xtdir/xtdir.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:994

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

JROOT/components/com_p8pbb/p8pbb.php:730

JROOT/forum/includes/hooks/index.php:143

JROOT/forum/includes/functions.php:5568

JROOT/forum/includes/functions.php:5521

JROOT/forum/cache/data_php_viewtopic.php:2265

JROOT/components/com_p8pbb/controller.php:113

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

JROOT/components/com_p8pbb/p8pbb.php:1638

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

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

Query Time: 0.54 ms After last query: 2.37 ms

UPDATE `ovl_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611548555;s:18:\"session.timer.last\";i:1611548555;s:17:\"session.timer.now\";i:1611548555;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\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;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\";N;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:5:\"phpbb\";a:82:{s:7:\"user_id\";i:1;s:9:\"user_type\";s:1:\"2\";s:8:\"group_id\";s:1:\"1\";s:14:\"user_perm_from\";s:1:\"0\";s:7:\"user_ip\";s:0:\"\";s:12:\"user_regdate\";s:10:\"1265626827\";s:8:\"username\";s:9:\"Anonymous\";s:14:\"username_clean\";s:9:\"anonymous\";s:13:\"user_password\";s:0:\"\";s:12:\"user_passchg\";s:1:\"0\";s:10:\"user_email\";s:0:\"\";s:15:\"user_email_hash\";s:1:\"0\";s:13:\"user_birthday\";s:0:\"\";s:14:\"user_lastvisit\";s:1:\"0\";s:13:\"user_lastmark\";s:1:\"0\";s:18:\"user_lastpost_time\";s:10:\"1434992131\";s:13:\"user_lastpage\";s:0:\"\";s:21:\"user_last_confirm_key\";s:10:\"2TAQNE1DHG\";s:16:\"user_last_search\";s:10:\"1611548216\";s:13:\"user_warnings\";s:1:\"0\";s:17:\"user_last_warning\";s:1:\"0\";s:19:\"user_login_attempts\";s:1:\"2\";s:20:\"user_inactive_reason\";s:1:\"0\";s:18:\"user_inactive_time\";s:1:\"0\";s:10:\"user_posts\";s:1:\"0\";s:9:\"user_lang\";s:2:\"en\";s:13:\"user_timezone\";s:3:\"UTC\";s:15:\"user_dateformat\";s:9:\"d M Y H:i\";s:10:\"user_style\";s:1:\"3\";s:9:\"user_rank\";s:1:\"0\";s:11:\"user_colour\";s:0:\"\";s:16:\"user_new_privmsg\";s:1:\"0\";s:19:\"user_unread_privmsg\";s:1:\"0\";s:17:\"user_last_privmsg\";s:1:\"0\";s:18:\"user_message_rules\";s:1:\"0\";s:16:\"user_full_folder\";s:2:\"-3\";s:14:\"user_emailtime\";s:10:\"1609965796\";s:20:\"user_topic_show_days\";s:1:\"0\";s:22:\"user_topic_sortby_type\";s:1:\"t\";s:21:\"user_topic_sortby_dir\";s:1:\"d\";s:19:\"user_post_show_days\";s:1:\"0\";s:21:\"user_post_sortby_type\";s:1:\"t\";s:20:\"user_post_sortby_dir\";s:1:\"a\";s:11:\"user_notify\";s:1:\"0\";s:14:\"user_notify_pm\";s:1:\"0\";s:16:\"user_notify_type\";s:1:\"0\";s:13:\"user_allow_pm\";s:1:\"0\";s:21:\"user_allow_viewonline\";s:1:\"1\";s:20:\"user_allow_viewemail\";s:1:\"0\";s:20:\"user_allow_massemail\";s:1:\"0\";s:12:\"user_options\";s:6:\"229425\";s:11:\"user_avatar\";s:0:\"\";s:16:\"user_avatar_type\";s:0:\"\";s:17:\"user_avatar_width\";s:1:\"0\";s:18:\"user_avatar_height\";s:1:\"0\";s:8:\"user_sig\";s:0:\"\";s:19:\"user_sig_bbcode_uid\";s:0:\"\";s:24:\"user_sig_bbcode_bitfield\";s:0:\"\";s:11:\"user_jabber\";s:0:\"\";s:11:\"user_actkey\";s:0:\"\";s:14:\"user_newpasswd\";s:0:\"\";s:14:\"user_form_salt\";s:16:\"e9b72229b66760bd\";s:8:\"user_new\";s:1:\"0\";s:13:\"user_reminded\";s:1:\"0\";s:18:\"user_reminded_time\";s:1:\"0\";s:18:\"session_last_visit\";i:1611548555;s:13:\"is_registered\";b:0;s:6:\"is_bot\";b:0;s:15:\"session_created\";b:1;s:10:\"session_id\";s:32:\"4da9b5575f45eb6e155a16991f43dfe6\";s:15:\"session_user_id\";i:1;s:13:\"session_start\";i:1611548555;s:12:\"session_time\";i:1611548555;s:15:\"session_browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:21:\"session_forwarded_for\";s:0:\"\";s:10:\"session_ip\";s:12:\"18.204.42.98\";s:17:\"session_autologin\";i:0;s:13:\"session_admin\";i:0;s:18:\"session_viewonline\";i:1;s:12:\"session_page\";s:33:\"viewtopic.php?f=32&p=13273&t=7789\";s:16:\"session_forum_id\";i:32;s:32:\"hash_mark_all_notifications_read\";s:8:\"0a668d15\";}}s:13:\"session.token\";s:32:\"fbed6074e2ec83bab6abf734f5d52694\";}'
	, `time` = '1611548555'

  WHERE `session_id` = '5k7ucleel008ipdrscsrvj38l4'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ovl_session	NULL	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

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
updating	0.2 ms
end	0.0 ms
query end	0.1 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]

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
3 × SELECT * 
  FROM `ovl_extensions`
```

2 × SELECT t.parent_id 
  FROM ovl_menu as t

2 × SELECT `count` 
  FROM ovl_banner_tracks

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM ovl_banners as a 
  LEFT JOIN ovl_banner_clients AS cl 
  ON cl.id = a.cid

1 × SELECT last_update 
  FROM `ovl_xtdir_trees`

1 × SELECT count(*) 
  FROM `ovl_sobipro_field_data` AS `d`

1 × SELECT count(*) 
  FROM `ovl_sobipro_object`

1 × SELECT id, last_update 
  FROM `ovl_xtdir_trees`

1 × SELECT COUNT(*) 
  FROM ovl_banners as a 
  LEFT JOIN ovl_banner_clients AS cl 
  ON cl.id = a.cid

```
1 × SELECT * 
  FROM ovl_banners
```

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

1 × SELECT `session_id` 
  FROM `ovl_session`

1 × SELECT id, rules 
  FROM `ovl_viewlevels

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 ovl_menu AS m 
  LEFT JOIN ovl_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT m.menutype 
  FROM ovl_menu AS m

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
  FROM ovl_modules AS m 
  LEFT JOIN ovl_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN ovl_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT `data` 
  FROM `ovl_session`

OTHER Tables:

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `ovl_extensions

1 × UPDATE `ovl_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611548555;s:18:\"session.timer.last\";i:1611548555;s:17:\"session.timer.now\";i:1611548555;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\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;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\";N;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:5:\"phpbb\";a:82:{s:7:\"user_id\";i:1;s:9:\"user_type\";s:1:\"2\";s:8:\"group_id\";s:1:\"1\";s:14:\"user_perm_from\";s:1:\"0\";s:7:\"user_ip\";s:0:\"\";s:12:\"user_regdate\";s:10:\"1265626827\";s:8:\"username\";s:9:\"Anonymous\";s:14:\"username_clean\";s:9:\"anonymous\";s:13:\"user_password\";s:0:\"\";s:12:\"user_passchg\";s:1:\"0\";s:10:\"user_email\";s:0:\"\";s:15:\"user_email_hash\";s:1:\"0\";s:13:\"user_birthday\";s:0:\"\";s:14:\"user_lastvisit\";s:1:\"0\";s:13:\"user_lastmark\";s:1:\"0\";s:18:\"user_lastpost_time\";s:10:\"1434992131\";s:13:\"user_lastpage\";s:0:\"\";s:21:\"user_last_confirm_key\";s:10:\"2TAQNE1DHG\";s:16:\"user_last_search\";s:10:\"1611548216\";s:13:\"user_warnings\";s:1:\"0\";s:17:\"user_last_warning\";s:1:\"0\";s:19:\"user_login_attempts\";s:1:\"2\";s:20:\"user_inactive_reason\";s:1:\"0\";s:18:\"user_inactive_time\";s:1:\"0\";s:10:\"user_posts\";s:1:\"0\";s:9:\"user_lang\";s:2:\"en\";s:13:\"user_timezone\";s:3:\"UTC\";s:15:\"user_dateformat\";s:9:\"d M Y H:i\";s:10:\"user_style\";s:1:\"3\";s:9:\"user_rank\";s:1:\"0\";s:11:\"user_colour\";s:0:\"\";s:16:\"user_new_privmsg\";s:1:\"0\";s:19:\"user_unread_privmsg\";s:1:\"0\";s:17:\"user_last_privmsg\";s:1:\"0\";s:18:\"user_message_rules\";s:1:\"0\";s:16:\"user_full_folder\";s:2:\"-3\";s:14:\"user_emailtime\";s:10:\"1609965796\";s:20:\"user_topic_show_days\";s:1:\"0\";s:22:\"user_topic_sortby_type\";s:1:\"t\";s:21:\"user_topic_sortby_dir\";s:1:\"d\";s:19:\"user_post_show_days\";s:1:\"0\";s:21:\"user_post_sortby_type\";s:1:\"t\";s:20:\"user_post_sortby_dir\";s:1:\"a\";s:11:\"user_notify\";s:1:\"0\";s:14:\"user_notify_pm\";s:1:\"0\";s:16:\"user_notify_type\";s:1:\"0\";s:13:\"user_allow_pm\";s:1:\"0\";s:21:\"user_allow_viewonline\";s:1:\"1\";s:20:\"user_allow_viewemail\";s:1:\"0\";s:20:\"user_allow_massemail\";s:1:\"0\";s:12:\"user_options\";s:6:\"229425\";s:11:\"user_avatar\";s:0:\"\";s:16:\"user_avatar_type\";s:0:\"\";s:17:\"user_avatar_width\";s:1:\"0\";s:18:\"user_avatar_height\";s:1:\"0\";s:8:\"user_sig\";s:0:\"\";s:19:\"user_sig_bbcode_uid\";s:0:\"\";s:24:\"user_sig_bbcode_bitfield\";s:0:\"\";s:11:\"user_jabber\";s:0:\"\";s:11:\"user_actkey\";s:0:\"\";s:14:\"user_newpasswd\";s:0:\"\";s:14:\"user_form_salt\";s:16:\"e9b72229b66760bd\";s:8:\"user_new\";s:1:\"0\";s:13:\"user_reminded\";s:1:\"0\";s:18:\"user_reminded_time\";s:1:\"0\";s:18:\"session_last_visit\";i:1611548555;s:13:\"is_registered\";b:0;s:6:\"is_bot\";b:0;s:15:\"session_created\";b:1;s:10:\"session_id\";s:32:\"4da9b5575f45eb6e155a16991f43dfe6\";s:15:\"session_user_id\";i:1;s:13:\"session_start\";i:1611548555;s:12:\"session_time\";i:1611548555;s:15:\"session_browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:21:\"session_forwarded_for\";s:0:\"\";s:10:\"session_ip\";s:12:\"18.204.42.98\";s:17:\"session_autologin\";i:0;s:13:\"session_admin\";i:0;s:18:\"session_viewonline\";i:1;s:12:\"session_page\";s:33:\"viewtopic.php?f=32&p=13273&t=7789\";s:16:\"session_forum_id\";i:32;s:32:\"hash_mark_all_notifications_read\";s:8:\"0a668d15\";}}s:13:\"session.token\";s:32:\"fbed6074e2ec83bab6abf734f5d52694\";}'  , `time` = '1611548555'

1 × UPDATE ovl_banner_tracks 
  SET `count` = (`count` + 1)

1 × UPDATE ovl_banners 
  SET impmade = (impmade + 1)

1 × INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('5k7ucleel008ipdrscsrvj38l4', 0, '1611548555'

1 × UPDATE `ovl_extensions` 
  SET `params` = '{\"mediaversion\":\"ff1357aed0896cc9685a627b7f49bf4d\"}'

```
1 × DELETE  
  FROM `ovl_session`
```

POI Campsites

POI Campsites

Re: POI Campsites

Re: POI Campsites

Who is online

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

29 Queries Logged 13.4 ms

5 duplicate found!

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: