Galerija

imageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimageimage

Natječaj za pročelnika Jedinstvenog upravnog odjela

Natječaj za prijam u službu u Općinu Kravarsko
Kravarsko,16.srpnja 2015. 

Više o natječaju

Načelnik općine Kravarsko raspisao je javni natječaj za prijam u službu  na neodređeno vrijeme. Natječaj je objavljen dana 15.srpnja  2015. godine u Narodnim novinama broj 77. Prijave na natječaj podnose se u roku 8 dana od dana objave natječaja.

 


Podaci vezani uz natječaj za prijam u službu na neodređeno vrijeme u Općinu Kravarsko na radno mjesto pročelnika Jedinstvenog upravnog odjela, 1 izvršitelj/ica, magistra struke, objavljeni su u Narodnim novinama dana 15. srpnja 2015. godine, broj 77. Rok za podnošenje prijava na natječaj je do 23. srpnja  2015. godine.
više
Osnovnu brutto plaću sačinjava umnožak koeficijenta radnog mjesta ( 1,70) i osnovice koja iznosi 5.000,00 kuna.

 


Opis poslova:
•    planira, vodi, koordinira obavljanje poslova i upravlja radom Odjela, ima najviši stupanj materijalne i financijske odgovornosti za rad Odjela, ima nadzornu i upravljačku odgovornost na temelju općih smjernica i utvrđene politike Odjela samostalno odlučuje o najsloženijim stručnim pitanjima donosi rješenja u upravnim stvarima iz nadležnosti Odjela sudjeluje u stalnim stručnim komunikacijama unutar i izvan upravnog Odjela u skladu sa zakonom obavlja i druge poslove po nalogu načelnika 

Stručni uvjeti:
•    magistar struke ili stručni specijalist društvene ili tehničke struke
•    najmanje jedna godina radnog iskustva na odgovarajućim poslovima
•    organizacijske sposobnosti i komunikacijske vještine
•    položen državni stručni ispit i poznavanje rada na računalu
•    znanje engleskog jezika

Pored posebnih uvjeta za prijam u službu, kandidati moraju ispunjavati opće uvjete za prijam u službu (punoljetnost, hrvatsko državljanstvo, zdravstvenu sposobnost).
Kandidat koji bude izabran dužan je priložiti i uvjerenje o zdravstvenoj sposobnosti kojim se dokazuje ispunjavanje općeg uvjeta zdravstvene sposobnosti za obavljanje poslova radnog mjesta na koje se prima.
Ukoliko izabrani kandidat u određenom roku ne dostavi uvjerenje o zdravstvenoj sposobnosti smatrati će se da ne ispunjava uvjete propisane u natječaju.
U službu ne mogu biti primljene osobe za koje postoje zapreke iz članka 15. i 16. Zakona o službenicima i namještenicima u lokalnoj i područnoj (regionalnoj) samoupravi („NN“ broj 86/08 i 61/11). Na natječaj se mogu javiti kandidati koji nemaju položen državni stručni ispit, s time da su ga dužni položiti u zakonskom roku.
Na natječaj se mogu javiti osobe oba spola.
Kandidati koji ostvaruju pravo prednosti pri zapošljavanju, dužni su u prijavi na natječaj pozvati se na to pravo i imaju prednost u odnosu na ostale kandidate pod jednakim uvjetima. Uz prijavu na natječaj dužni su priložiti rješenje odnosno potvrdu iz koje je vidljivo navedeno pravo te potvrdu o nezaposlenosti Zavoda za zapošljavanje izdanu u vrijeme trajanja ovog natječaja.

Uz prijavu na natječaj potrebno je priložiti:
1.    životopis
2.    dokaz o hrvatskom državljanstvu ( preslik osobne iskaznice, vojne iskaznice, putovnice ili domovnice)
3.    potvrdu o radnom stažu koju izdaje Hrvatski zavod za mirovinsko osiguranje ns šalterima Zavoda ili elektronskim putem
4.    presliku ugovora o radu ili rješenje o rasporedu ili potvrda poslodavca (koja mora sadržavati vrstu poslova koju je obavljao i vremenska razdoblja u kojem je kandidat obavljao navedene poslove)
5.    presliku diplome
6.    presliku svjedodžbe o položenom državnom stručnom ispitu
7.    presliku uvjerenja nadležnog suda da se protiv podnositelja prijave ne vodi kazneni postupak izdanog u vrijeme objave natječaja
8.    izvornik rješenja ili potvrde o priznatom statusu i potvrdu o    
nezaposlenosti- dokaz prava prednosti pri zapošljavanju
9. vlastoručno potpisanu izjavu da ne postoje zapreke za prijam u službu  
navedene u članku 15. i 16. ZSNLP(R)S-a.  

Urednom prijavom smatra se prijava koja sadržava sve podatke i priloge navedene u natječaju.
Nepravodobne i neuredne prijave na natječaj ne će se razmatrati niti će podnositelji neurednih prijava biti pozivani na dopunu prijave.
Osobe koje podnesu nepravodobne ili neuredne prijave na natječaj ili ne ispunjavaju uvjete objavljene u natječaju, ne smatraju se kandidatima prijavljenima na natječaj.
Postupak prijma u službu obuhvaća obvezatnu provjeru znanja kandidata koji ispunjavaju uvjete propisane u natječaju.
Prijave na natječaj  podnose se u roku od 8 dana od dana objave natječaja u Narodnim novinama na adresu: Općina Kravarsko, Trg Stjepana Radića 1, 10413 Kravarsko. Prijave se mogu dostaviti i osobno u sjedište Općine Kravarsko.
O rezultatima natječaja kandidati će biti obaviješteni u zakonskom roku.
Prethodna provjera znanja i sposobnosti kandidata obuhvaća pisano testiranje, provjeru poznavanja rada na računalu, provjeru znanja engleskog jezika i intervju.
Kandidati su obvezni pristupiti prethodnoj provjeri znanja i sposobnosti. Ako kandidat ne pristupi testiranju smatra se da je povukao prijavu na natječaj.
Na intervju mogu pristupiti oni kandidati koji ostvare najmanje 50% ukupnog broja bodova na pisanom testu, provjeri rada na računalu i provjeri znanja engleskog jezika. 
Vrijeme održavanja prethodne provjere znanja i sposobnosti kandidata biti će objavljeno na web stranici Općine Kravarsko (www. kravarsko.hr) i na oglasnoj ploči u sjedištu Općine Kravarsko, najkasnije pet dana prije održavanja provjere.  

Pravni i drugi izvori za pripremanje kandidata za testiranje: 
1.    Zakon o komunalnom gospodarstvu („Narodne novine“ broj 36/1995, 109/1995, 21/1996, 70/1997, 128/1999, 57/2000, 129/2000, 59/2001, 82/2004, 110/2004, 178/2004, 38/2009, 79/2009, 153/2009, 153/2009, 49/2011, 84/2011, 90/2011, 144/2012, 56/2013, 94/2013, 153/2013, 147/2014).
2.    Zakon o lokalnoj i područnoj (regionalno) samoupravi („Narodne novine“broj  
33/01, 60/01, 129/05, 109/07, 36/09, 125/08, 36/09, 150/11, 144/12 i 19/13).    
3. Zakon o Proračunu ( „Narodne novine“ broj 87/08, 136/12 i 15/15).
4. Zakon o upravnom postupku („Narodne novine“broj 47/2009).
5. Zakon o službenicima i namještenicima u lokalnoj i područnoj  
(regionalnoj) samoupravi („Narodne novine“ broj 86/08 i 61/ 11).

© Općina Kravarsko, Trg Stjepana Radića 1, Telefon: 01 62 37 022, 01 62 37 044.......................Design by - StudioAgram

Informacije profila

Application 0.000 seconds (+0.000); 0.40 MB (+0.40) - afterLoad
Application 0.051 seconds (+0.050); 2.88 MB (+2.48) - afterInitialise
Application 0.069 seconds (+0.018); 3.95 MB (+1.07) - afterRoute
Application 0.114 seconds (+0.045); 5.96 MB (+2.01) - afterDispatch
Application 0.186 seconds (+0.072); 7.74 MB (+1.79) - afterRender

Korištenje Memorije

7.78 MB (8,156,360 Bytes)

39 Upita zapisano

  1. SELECT `data`
      FROM `kra_session`
      WHERE `session_id` = '4o5900m8l5mgi9evlte5c4kml7'
  2. SELECT `session_id`
      FROM `kra_session`
      WHERE `session_id` = '4o5900m8l5mgi9evlte5c4kml7'
      LIMIT 0, 1
  3. INSERT INTO `kra_session` (`session_id`, `client_id`, `time`)
      VALUES ('4o5900m8l5mgi9evlte5c4kml7', 0, 1601027164)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `kra_viewlevels`
  6. 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
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. 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
  9. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  10. SELECT *
      FROM kra_languages
      WHERE published=1
  11. SELECT id, home, template, params
      FROM kra_template_styles
      WHERE client_id = 0
  12. SELECT a.rules
      FROM kra_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id
  13. SELECT b.rules
      FROM kra_assets AS a
      LEFT JOIN kra_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content' OR a.parent_id=0)
      GROUP BY b.id
      ORDER BY b.lft
  14. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM kra_content AS a
      LEFT JOIN kra_categories AS c
      on c.id = a.catid
      LEFT JOIN kra_users AS u
      on u.id = a.created_by
      LEFT JOIN kra_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN kra_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN kra_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM kra_categories AS cat JOIN kra_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 69
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-25 09:46:04')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-25 09:46:04')
      AND (a.state = 1 OR a.state =2)
  15. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM kra_categories as c
      LEFT JOIN kra_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM kra_categories AS cat JOIN kra_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=9
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  16. UPDATE kra_content
      SET hits = hits + 1
      WHERE id = 69
  17. 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-09-25 09:46:04')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-25 09:46:04')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY position, ordering
  18. 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
  19. SELECT count( * ) AS records, MAX( id ) AS max
      FROM kra_vvisitcounter
  20. 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
  21. DELETE
      FROM kra_vvisitcounter
      WHERE id<='460684'
  22. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE ip=UNHEX(SHA1('3.235.137.159'))
      AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
  23. INSERT INTO kra_mod_vvisit_counter_memo ( counter )
      values ( 'vvisitcounter' )
      ON DUPLICATE KEY UPDATE counter='vvisitcounter'
  24. select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  25. select valMaxVisits val, valMaxVisitsDay day
      FROM kra_mod_vvisit_counter_memo
      where counter = 'vvisitcounter'
  26. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
      AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
  27. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
      AND UNIX_TIMESTAMP(DATE(NOW()))
  28. SELECT COUNT(*)
      FROM kra_vvisitcounter
      WHERE tm BETWEEN 1600646400
      AND 1601251200
  29. 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)
  30. 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)
  31. 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()
  32. 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
  33. UPDATE kra_banners
      SET impmade = (impmade + 1)
      WHERE id = 1
  34. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-25 09'
  35. SELECT `count`
      FROM kra_banner_tracks
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-25 09'
  36. UPDATE kra_banner_tracks
      SET `count` = (`count` + 1)
      WHERE track_type=1
      AND banner_id=1
      AND track_date='2020-09-25 09'
  37. SELECT `enabled`
      FROM `kra_extensions`
      WHERE `element` = "com_akeeba"
      AND `type` = "component"
  38. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM kra_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_akeeba'
  39. UPDATE `kra_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1601027164;s:18:\"session.timer.last\";i:1601027164;s:17:\"session.timer.now\";i:1601027164;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\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s: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\";a:1:{i:0;s:1:\"1\";}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:\"d000e70c65727a00da8af5952085699d\";}', `time` = 1601027164
      WHERE `session_id` = '4o5900m8l5mgi9evlte5c4kml7'

30 Tipova upita zapisano, razvrstani su prema broju pojavljivanja.

ODABERI tablice:
  1. 5 × SELECT COUNT(*) FROM kra_vvisitcounter
  2. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM kra_extensions
  3. 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
  4. 2 × SELECT `count` FROM kra_banner_tracks
  5. 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
  6. 1 × SELECT count( * ) AS records, MAX( id ) AS max FROM kra_vvisitcounte
  7. 1 × select TIMESTAMPDIFF( SECOND, lastMaxVisits, now() ) as ddiff FROM kra_mod_vvisit_counter_memo
  8. 1 × SELECT * FROM kra_banners
  9. 1 × SELECT `enabled` FROM `kra_extensions`
  10. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM kra_categories as c LEFT JOIN kra_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM kra_categories AS cat JOIN kra_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  11. 1 × select valMaxVisits val, valMaxVisitsDay day FROM kra_mod_vvisit_counter_memo
  12. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM kra_content AS a LEFT JOIN kra_categories AS c on c.id = a.catid LEFT JOIN kra_users AS u on u.id = a.created_by LEFT JOIN kra_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN kra_categories as parent ON parent.id = c.parent_id LEFT JOIN kra_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM kra_categories AS cat JOIN kra_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  13. 1 × SELECT folder AS type, element AS name, params FROM kra_extensions
  14. 1 × SELECT id, rules FROM `kra_viewlevels
  15. 1 × SELECT `session_id` FROM `kra_session`
  16. 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
  17. 1 × SELECT * FROM kra_languages
  18. 1 × SELECT b.rules FROM kra_assets AS a LEFT JOIN kra_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  19. 1 × SELECT a.rules FROM kra_assets AS a
  20. 1 × SELECT id, home, template, params FROM kra_template_styles
  21. 1 × SELECT `data` FROM `kra_session`
OSTALE tablice:
  1. 1 × UPDATE kra_banners SET impmade = (impmade + 1)
  2. 1 × UPDATE kra_banner_tracks SET `count` = (`count` + 1)
  3. 1 × UPDATE `kra_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1601027164;s:18:\"session.timer.last\";i:1601027164;s:17:\"session.timer.now\";i:1601027164;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\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s: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\";a:1:{i:0;s:1:\"1\";}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:\"d000e70c65727a00da8af5952085699d\";}', `time` = 1601027164
  4. 1 × INSERT INTO kra_mod_vvisit_counter_memo ( counter ) values ( 'vvisitcounter' ) ON DUPLICATE KEY UPDATE counter='vvisitcounter
  5. 1 × DELETE FROM kra_vvisitcounter
  6. 1 × UPDATE kra_content SET hits = hits + 1
  7. 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=
  8. 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
  9. 1 × INSERT INTO `kra_session` (`session_id`, `client_id`, `time`) VALUES ('4o5900m8l5mgi9evlte5c4kml7', 0, 1601027164