Informacije profila
Application 0.000 seconds (+0.000); 0.40 MB (+0.40) - afterLoad
Application 0.035 seconds (+0.035); 2.88 MB (+2.48) - afterInitialise
Application 0.046 seconds (+0.011); 3.89 MB (+1.01) - afterRoute
Application 0.079 seconds (+0.033); 5.47 MB (+1.58) - afterDispatch
Application 0.158 seconds (+0.079); 7.75 MB (+2.28) - afterRender
Korištenje Memorije
7.78 MB (8,157,672 Bytes)
34 Upita zapisano
- SELECT `data`
FROM `kra_session`
WHERE `session_id` = 'c9796ir70c9e5ef9qv2pv0idk6' - SELECT `session_id`
FROM `kra_session`
WHERE `session_id` = 'c9796ir70c9e5ef9qv2pv0idk6'
LIMIT 0, 1 - INSERT INTO `kra_session` (`session_id`, `client_id`, `time`)
VALUES ('c9796ir70c9e5ef9qv2pv0idk6', 0, 1603173274) - SELECT extension_id AS "id", element AS "option", params, enabled
FROM kra_extensions
WHERE `type` = 'component'
AND `element` = 'com_users' - SELECT id, rules
FROM `kra_viewlevels` - SELECT folder AS type, element AS name, params
FROM kra_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering - SELECT extension_id AS "id", element AS "option", params, enabled
FROM kra_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages' - SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
FROM kra_menu AS m
LEFT JOIN kra_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
AND m.access IN (1,1)
ORDER BY m.lft - SELECT *
FROM kra_languages
WHERE published=1 - SELECT id, home, template, params
FROM kra_template_styles
WHERE client_id = 0 - SELECT id, title, module, position, content, showtitle, params, mm.menuid
FROM kra_modules AS m
LEFT JOIN kra_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-20 05:54:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 05:54:34')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY position, ordering - CREATE TABLE IF NOT EXISTS kra_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
- SELECT count( * ) AS records, MAX( id ) AS max
FROM kra_vvisitcounter - CREATE TABLE IF NOT EXISTS kra_mod_vvisit_counter_memo (counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL , valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL , PRIMARY KEY (counter) ) ENGINE=MEMORY
- DELETE
FROM kra_vvisitcounter
WHERE id<='466561' - SELECT COUNT(*)
FROM kra_vvisitcounter
WHERE ip=UNHEX(SHA1('3.210.201.170'))
AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' ) - INSERT INTO kra_mod_vvisit_counter_memo ( counter )
values ( 'vvisitcounter' )
ON DUPLICATE KEY UPDATE counter='vvisitcounter' - select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff
FROM kra_mod_vvisit_counter_memo
where counter = 'vvisitcounter' - select valMaxVisits val, valMaxVisitsDay day
FROM kra_mod_vvisit_counter_memo
where counter = 'vvisitcounter' - SELECT COUNT(*)
FROM kra_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY) - SELECT COUNT(*)
FROM kra_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
AND UNIX_TIMESTAMP(DATE(NOW())) - SELECT COUNT(*)
FROM kra_vvisitcounter
WHERE tm BETWEEN 1603065600
AND 1603670400 - SELECT COUNT(*)
FROM kra_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01"))
AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH) - SELECT extension_id AS "id", element AS "option", params, enabled
FROM kra_extensions
WHERE `type` = 'component'
AND `element` = 'com_content' - SELECT *
FROM kra_banners
WHERE NOW() >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0) - SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM kra_banners as a
LEFT JOIN kra_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade = a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (8)
ORDER BY a.sticky DESC,RAND() - SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM kra_banners as a
LEFT JOIN kra_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade = a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (8)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 1 - UPDATE kra_banners
SET impmade = (impmade + 1)
WHERE id = 1 - SELECT `count`
FROM kra_banner_tracks
WHERE track_type=1
AND banner_id=1
AND track_date='2020-10-20 05' - SELECT `count`
FROM kra_banner_tracks
WHERE track_type=1
AND banner_id=1
AND track_date='2020-10-20 05' - UPDATE kra_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=1
AND track_date='2020-10-20 05' - SELECT `enabled`
FROM `kra_extensions`
WHERE `element` = "com_akeeba"
AND `type` = "component" - SELECT extension_id AS "id", element AS "option", params, enabled
FROM kra_extensions
WHERE `type` = 'component'
AND `element` = 'com_akeeba' - UPDATE `kra_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1603173274;s:18:\"session.timer.last\";i:1603173274;s:17:\"session.timer.now\";i:1603173274;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"b448afb07a52886604f8fd28b03cee54\";}', `time` = 1603173274
WHERE `session_id` = 'c9796ir70c9e5ef9qv2pv0idk6'
25 Tipova upita zapisano, razvrstani su prema broju pojavljivanja.
ODABERI tablice:
- 5 × SELECT COUNT(*) FROM kra_vvisitcounter
- 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM kra_extensions
- 2 × SELECT `count` FROM kra_banner_tracks
- 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM kra_banners as a LEFT JOIN kra_banner_clients AS cl ON cl.id = a.cid
- 1 × SELECT `enabled` FROM `kra_extensions`
- 1 × select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff FROM kra_mod_vvisit_counter_memo
- 1 × select valMaxVisits val, valMaxVisitsDay day FROM kra_mod_vvisit_counter_memo
- 1 × SELECT * FROM kra_banners
- 1 × SELECT count( * ) AS records, MAX( id ) AS max FROM kra_vvisitcounte
- 1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM kra_modules AS m LEFT JOIN kra_modules_menu AS mm ON mm.moduleid = m.id
- 1 × SELECT id, rules FROM `kra_viewlevels
- 1 × SELECT `session_id` FROM `kra_session`
- 1 × SELECT folder AS type, element AS name, params FROM kra_extensions
- 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM kra_menu AS m LEFT JOIN kra_extensions AS e ON m.component_id = e.extension_id
- 1 × SELECT id, home, template, params FROM kra_template_styles
- 1 × SELECT * FROM kra_languages
- 1 × SELECT `data` FROM `kra_session`
OSTALE tablice:
- 1 × UPDATE kra_banners SET impmade = (impmade + 1)
- 1 × UPDATE kra_banner_tracks SET `count` = (`count` + 1)
- 1 × UPDATE `kra_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1603173274;s:18:\"session.timer.last\";i:1603173274;s:17:\"session.timer.now\";i:1603173274;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"b448afb07a52886604f8fd28b03cee54\";}', `time` = 1603173274
- 1 × INSERT INTO kra_mod_vvisit_counter_memo ( counter ) values ( 'vvisitcounter' ) ON DUPLICATE KEY UPDATE counter='vvisitcounter
- 1 × DELETE FROM kra_vvisitcounter
- 1 × CREATE TABLE IF NOT EXISTS kra_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=
- 1 × CREATE TABLE IF NOT EXISTS kra_mod_vvisit_counter_memo (counter varchar(240) NOT NULL, lastMaxPerDay DATE NULL DEFAULT NULL , valMaxVisits INT NULL DEFAULT NULL, valMaxVisitsDay int NULL DEFAULT NULL, lastMaxVisits DATETIME NULL , PRIMARY KEY (counter) ) ENGINE=MEMOR
- 1 × INSERT INTO `kra_session` (`session_id`, `client_id`, `time`) VALUES ('c9796ir70c9e5ef9qv2pv0idk6', 0, 1603173274
