Joomla! Debug Console

Time

Memory

28 Queries Logged 13.2 ms

1. Query Time: 1.12 ms

   SELECT `data`
   
     FROM `ovl_session`
   
     WHERE `session_id` = 're79dl1q3gp3ec59jcoq3rdfo5'

   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]

   ---

2. Query Time: 0.24 ms After last query: 1.57 ms

   SELECT `session_id`
   
     FROM `ovl_session`
   
     WHERE `session_id` = 're79dl1q3gp3ec59jcoq3rdfo5' 
     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]

   ---

3. Query Time: 0.27 ms After last query: 0.12 ms

   INSERT INTO `ovl_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('re79dl1q3gp3ec59jcoq3rdfo5', 0, '1607190652')

   Explain

   EXPLAIN not possible on query: INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) VALUES ('re79dl1q3gp3ec59jcoq3rdfo5', 0, '1607190652')

   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]

   ---

4. Query Time: 0.47 ms After last query: 3.65 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]

   ---

5. Query Time: 0.26 ms After last query: 0.54 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]

   ---

6. Query Time: 1.07 ms After last query: 22.95 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]

   ---

7. Query Time: 0.58 ms After last query: 12.16 ms

   UPDATE `ovl_extensions`
   
     SET `params` = '{\"mediaversion\":\"676f6a202544eceade51dd13ec8f4167\"}'
   
     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]

   ---

8. Query Time: 1.34 ms After last query: 128.79 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_viewforum.php:999

   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]

   ---

9. Query Time: 0.33 ms After last query: 20.98 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_viewforum.php:999

   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]

   ---

10. Query Time: 0.22 ms After last query: 0.41 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_viewforum.php:999

    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]

    ---

11. Query Time: 0.13 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_viewforum.php:999

    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]

    ---

12. Query Time: 0.36 ms After last query: 18.82 ms

    SELECT *
    
      FROM ovl_banners
    
      WHERE '2020-12-05 17:50:52' >= '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_viewforum.php:999

    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]

    ---

13. Query Time: 0.60 ms After last query: 2.34 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_viewforum.php:999

    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]

    ---

14. Query Time: 0.58 ms After last query: 0.24 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_viewforum.php:999

    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]

    ---

15. Query Time: 0.45 ms After last query: 0.42 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
    Waiting for query cache lock	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: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_viewforum.php:999

    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]

    ---

16. Query Time: 0.36 ms After last query: 0.23 ms
    Duplicate queries: #17

    SELECT `count`
    
      FROM ovl_banner_tracks
    
      WHERE track_type=1 
      AND banner_id=2 
      AND track_date='2020-12-05 17'

    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.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/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_viewforum.php:999

    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]

    ---

17. Query Time: 0.25 ms After last query: 0.14 ms
    Duplicate queries: #16

    SELECT `count`
    
      FROM ovl_banner_tracks
    
      WHERE track_type=1 
      AND banner_id=2 
      AND track_date='2020-12-05 17'

    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_viewforum.php:999

    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]

    ---

18. Query Time: 0.32 ms After last query: 0.14 ms

    UPDATE ovl_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=2 
      AND track_date='2020-12-05 17'

    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
    Waiting for query cache lock	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: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_viewforum.php:999

    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]

    ---

19. Query Time: 1.09 ms After last query: 90.62 ms

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    starting	0.0 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.6 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_viewforum.php:999

    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]

    ---

20. Query Time: 0.57 ms After last query: 0.50 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.2 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_viewforum.php:999

    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]

    ---

21. Query Time: 0.42 ms After last query: 1.67 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.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_viewforum.php:999

    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]

    ---

22. Query Time: 0.43 ms After last query: 0.88 ms
    Duplicate queries: #21  #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.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_viewforum.php:999

    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]

    ---

23. Query Time: 0.29 ms After last query: 0.59 ms
    Duplicate queries: #21  #22

    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.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_viewforum.php:999

    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]

    ---

24. Query Time: 0.17 ms After last query: 0.50 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.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: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_viewforum.php:999

    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]

    ---

25. Query Time: 0.15 ms After last query: 0.20 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_viewforum.php:999

    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]

    ---

26. Query Time: 0.19 ms After last query: 0.11 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.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/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_viewforum.php:999

    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]

    ---

27. Query Time: 0.32 ms After last query: 0.09 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.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.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_viewforum.php:999

    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]

    ---

28. Query Time: 0.60 ms After last query: 4.54 ms

    UPDATE `ovl_session`
    
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1607190652;s:18:\"session.timer.last\";i:1607190652;s:17:\"session.timer.now\";i:1607190652;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:\"2796UFSZE8\";s:16:\"user_last_search\";s:10:\"1607190417\";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:\"1606890254\";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:1607190652;s:13:\"is_registered\";b:0;s:6:\"is_bot\";b:0;s:15:\"session_created\";b:1;s:10:\"session_id\";s:32:\"4ac0cb40cd0f9f0589a6ee2a6da1ec89\";s:15:\"session_user_id\";i:1;s:13:\"session_start\";i:1607190652;s:12:\"session_time\";i:1607190652;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:\"3.219.31.204\";s:17:\"session_autologin\";i:0;s:13:\"session_admin\";i:0;s:18:\"session_viewonline\";i:1;s:12:\"session_page\";s:18:\"viewforum.php?f=12\";s:16:\"session_forum_id\";i:12;s:32:\"hash_mark_all_notifications_read\";s:8:\"0a668d15\";}}s:13:\"session.token\";s:32:\"2ab62605b889d590c95176cf2893bef0\";}'
    	, `time` = '1607190653'
    
      WHERE `session_id` = 're79dl1q3gp3ec59jcoq3rdfo5'

    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
    Waiting for query cache lock	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/libraries/joomla/session/storage/database.php:85

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

    ---

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 3 × SELECT * 
     FROM `ovl_extensions`

2. 2 × SELECT t.parent_id 
     FROM ovl_menu as t

3. 2 × SELECT `count` 
     FROM ovl_banner_tracks

4. 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

5. 1 × SELECT last_update 
     FROM `ovl_xtdir_trees`

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

7. 1 × SELECT count(*) 
     FROM `ovl_sobipro_object`

8. 1 × SELECT id, last_update 
     FROM `ovl_xtdir_trees`

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

10. 1 × SELECT * 
      FROM ovl_banners

11. 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

12. 1 × SELECT `session_id` 
      FROM `ovl_session`

13. 1 × SELECT id, rules 
      FROM `ovl_viewlevels

14. 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

15. 1 × SELECT m.menutype 
      FROM ovl_menu AS m

16. 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

17. 1 × SELECT `data` 
      FROM `ovl_session`

OTHER Tables:

1. 1 × SHOW FULL COLUMNS 
     FROM `ovl_extensions

2. 1 × UPDATE `ovl_session` 
     SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1607190652;s:18:\"session.timer.last\";i:1607190652;s:17:\"session.timer.now\";i:1607190652;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:\"2796UFSZE8\";s:16:\"user_last_search\";s:10:\"1607190417\";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:\"1606890254\";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:1607190652;s:13:\"is_registered\";b:0;s:6:\"is_bot\";b:0;s:15:\"session_created\";b:1;s:10:\"session_id\";s:32:\"4ac0cb40cd0f9f0589a6ee2a6da1ec89\";s:15:\"session_user_id\";i:1;s:13:\"session_start\";i:1607190652;s:12:\"session_time\";i:1607190652;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:\"3.219.31.204\";s:17:\"session_autologin\";i:0;s:13:\"session_admin\";i:0;s:18:\"session_viewonline\";i:1;s:12:\"session_page\";s:18:\"viewforum.php?f=12\";s:16:\"session_forum_id\";i:12;s:32:\"hash_mark_all_notifications_read\";s:8:\"0a668d15\";}}s:13:\"session.token\";s:32:\"2ab62605b889d590c95176cf2893bef0\";}'  , `time` = '1607190653'

3. 1 × SHOW TABLE

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

5. 1 × UPDATE `ovl_extensions` 
     SET `params` = '{\"mediaversion\":\"676f6a202544eceade51dd13ec8f4167\"}'

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

7. 1 × INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('re79dl1q3gp3ec59jcoq3rdfo5', 0, '1607190652'