Joomla! Foutopsporingsconsole

31 queries gelogd

1. SELECT `data`
  FROM `jo73_session`
  WHERE `session_id` = 'l0oirdcsm08nnkuerrh5mm7h54'
2. SELECT folder AS type, element AS name, params
  FROM jo73_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
3. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_kunena'
5. SELECT `value`
  FROM `jo73_admintools_storage`
  WHERE `key` = 'cparams'
6. 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 jo73_menu AS m
  LEFT JOIN jo73_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
7. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_phocagallery'
8. SELECT *
  FROM jo73_languages
  WHERE published=1
  ORDER BY ordering ASC
9. SELECT id, home, template, s.params
  FROM jo73_template_styles as s
  LEFT JOIN jo73_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
10. SELECT a.*
  FROM jo73_phocagallery_fb_users AS a
  WHERE a.id =0
11. SELECT a.*
  FROM jo73_phocagallery_fb_users AS a
  WHERE a.id =0
12. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jo73_phocagallery_categories AS c
  WHERE c.id = 42
  LIMIT 0, 1
13. SELECT *
  FROM jo73_phocagallery_categories AS c
  WHERE c.id = 1
  AND c.published = 1
14. SELECT *
  FROM jo73_phocagallery_categories AS c
  WHERE c.id = 0
  AND c.published = 1
15. SELECT cc.*
  FROM jo73_phocagallery_categories AS cc
  WHERE cc.id = 1
  AND cc.published = 1
  AND cc.approved = 1
  AND cc.id <> 42
  ORDER BY cc.ordering ASC
  LIMIT 0, 1
16. SELECT cc.*, a.filename, a.extm, a.exts, a.extw, a.exth
  FROM jo73_phocagallery_categories AS cc
  LEFT JOIN jo73_phocagallery AS a
  ON cc.id = a.catid
  WHERE cc.parent_id = 42
  AND cc.published = 1
  AND cc.approved = 1
  AND cc.id <> 42
  GROUP BY cc.id
  ORDER BY cc.ordering ASC
17. SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
  FROM jo73_phocagallery AS a
  LEFT JOIN jo73_phocagallery_img_votes_statistics AS r
  ON r.imgid = a.id
  LEFT JOIN jo73_phocagallery_categories AS cc
  ON cc.id = a.catid
  WHERE a.catid= 42
  AND a.published = 1
  AND a.approved = 1
  ORDER BY a.ordering ASC
  LIMIT 0, 20
18. SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
  FROM jo73_phocagallery AS a
  LEFT JOIN jo73_phocagallery_img_votes_statistics AS r
  ON r.imgid = a.id
  LEFT JOIN jo73_phocagallery_categories AS cc
  ON cc.id = a.catid
  WHERE a.catid= 42
  AND a.published = 1
  AND a.approved = 1
  ORDER BY a.ordering ASC
19. SHOW FULL COLUMNS
  FROM `jo73_phocagallery_categories`
20. UPDATE jo73_phocagallery_categories
  SET `hits` = (`hits` + 1)
  WHERE id = '42'
21. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jo73_modules AS m
  LEFT JOIN jo73_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jo73_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-05-21 01:58:21')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-21 01:58:21')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 132 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
22. SELECT COUNT(id) AS count_users
  FROM jo73_users
23. SELECT COUNT(id) AS count_items
  FROM jo73_content
  WHERE state = 1
24. SELECT COUNT(id) AS count_links
  FROM jo73_weblinks
  WHERE state = 1
25. SELECT SUM(hits) AS count_hits
  FROM jo73_content
  WHERE state = 1
26. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
27. SELECT *
  FROM jo73_kunena_config
28. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_weblinks'
29. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_phocaguestbook'
30. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
31. UPDATE `jo73_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:19;s:19:\"session.timer.start\";i:1337564723;s:18:\"session.timer.last\";i:1337565467;s:17:\"session.timer.now\";i:1337565500;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";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:16:\"com_mailto.links\";a:14:{s:40:\"35af5f337f331929a8645a52a87ece2d79e9b636\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://www.watn-boudel.nl/index.php/9-gespot/95-politie-geeft-les-in-hard-rijden.html\";s:6:\"expiry\";i:1337564786;}s:40:\"f2b9f55ef56c732c1b48b41c2439bc8e06bd372a\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"http://www.watn-boudel.nl/index.php/7-algemeen/94-carnaval-2012-de-bultruters.html\";s:6:\"expiry\";i:1337565438;}s:40:\"17da15ffe56fb6decc1e29e8ad68612b583bd0a2\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.watn-boudel.nl/index.php/7-algemeen/92-carnaval-fotos-optocht-bultruters-door-bultrutersland-ter-apel.html\";s:6:\"expiry\";i:1337565406;}s:40:\"11d69995a5b72812d29e6be15d18d529cb42053a\";O:8:\"stdClass\":2:{s:4:\"link\";s:107:\"http://www.watn-boudel.nl/index.php/10-zomaar-wat-nieuws/89-sint-en-piet-nu-ook-in-ter-apel-aangekomen.html\";s:6:\"expiry\";i:1337564818;}s:40:\"c8aac6432a75509f4efcefa977d1f70a8cab1498\";O:8:\"stdClass\":2:{s:4:\"link\";s:83:\"http://www.watn-boudel.nl/index.php/7-algemeen/91-brand-woning-ter-apel-kanaal.html\";s:6:\"expiry\";i:1337565379;}s:40:\"5d02335416dbd3932e7bdf3827c93647a9808b36\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.watn-boudel.nl/index.php/7-algemeen/77-schildersfestival-montmatre-sellingen.html\";s:6:\"expiry\";i:1337564978;}s:40:\"9951b388eb9af757fdf8a8c25253efff434ae833\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.watn-boudel.nl/index.php/7-algemeen/78-jongetje-van-3-dat-in-plas-sellingerbeetse-raakte-is-overleden.html\";s:6:\"expiry\";i:1337565023;}s:40:\"92e071e1f53a84e20328234bb31efcb2be3c6a37\";O:8:\"stdClass\":2:{s:4:\"link\";s:81:\"http://www.watn-boudel.nl/index.php/7-algemeen/81-zomeravond-markt-sellingen.html\";s:6:\"expiry\";i:1337565060;}s:40:\"f2ef7ce6a765166ee8e19966cf164f9b6c4ef3e4\";O:8:\"stdClass\":2:{s:4:\"link\";s:99:\"http://www.watn-boudel.nl/index.php/7-algemeen/82-twee-gewonden-bij-eenzijdig-ongeval-ter-apel.html\";s:6:\"expiry\";i:1337565086;}s:40:\"5413e5d86dc43f36f5df2fedbe837e86571c7286\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"http://www.watn-boudel.nl/index.php/7-algemeen/83-stille-kniptuun-sellingen-open-voor-publiek.html\";s:6:\"expiry\";i:1337565120;}s:40:\"ecbb48d326112237a6607280ec71bed44659c1c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:109:\"http://www.watn-boudel.nl/index.php/7-algemeen/85-artsadier-organiseert-hondendag-klijndijk--foto-update.html\";s:6:\"expiry\";i:1337565147;}s:40:\"67e3f45915139a87d85a46bfa7c33171768cb6ce\";O:8:\"stdClass\":2:{s:4:\"link\";s:104:\"http://www.watn-boudel.nl/index.php/7-algemeen/87-kloostershow-pkv-sport-en-vriendschap-foto-update.html\";s:6:\"expiry\";i:1337565179;}s:40:\"c45d937c31260c1c3adf21b145ad35ccb6d18b9c\";O:8:\"stdClass\":2:{s:4:\"link\";s:109:\"http://www.watn-boudel.nl/index.php/7-algemeen/88-jumbo-stuulen-en-theo-bruning-fietsen-spelen-voor-sint.html\";s:6:\"expiry\";i:1337565308;}s:40:\"ff7c93e1dd4d24525daef038dca0b4c2f58162da\";O:8:\"stdClass\":2:{s:4:\"link\";s:108:\"http://www.watn-boudel.nl/index.php/7-algemeen/90-tentoonstelling-de-vogelvriend-in-t-streekje-ter-apel.html\";s:6:\"expiry\";i:1337565348;}}s:13:\"session.token\";s:32:\"ceeb1f1177eccbec02d1dec2fb4a85a3\";}' , `time` = '1337565501'
  WHERE `session_id` = 'l0oirdcsm08nnkuerrh5mm7h54'

22 query types gelogd, gesorteerd op weergave

SELECTEER Tabellen:

1. 7 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM jo73_extensions
2. 2 × SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
  FROM jo73_phocagallery AS a
  LEFT JOIN jo73_phocagallery_img_votes_statistics AS r
  ON r.imgid = a.id
  LEFT JOIN jo73_phocagallery_categories AS cc
  ON cc.id = a.catid
3. 2 × SELECT a.*
  FROM jo73_phocagallery_fb_users AS a
4. 2 × SELECT *
  FROM jo73_phocagallery_categories AS c
5. 1 × SELECT COUNT(id) AS count_users
  FROM jo73_user
6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jo73_modules AS m
  LEFT JOIN jo73_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jo73_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
7. 1 × SELECT COUNT(id) AS count_items
  FROM jo73_content
8. 1 × SELECT COUNT(id) AS count_links
  FROM jo73_weblinks
9. 1 × SELECT *
  FROM jo73_kunena_confi
10. 1 × SELECT SUM(hits) AS count_hits
  FROM jo73_content
11. 1 × SELECT folder AS type, element AS name, params
  FROM jo73_extensions
12. 1 × SELECT cc.*, a.filename, a.extm, a.exts, a.extw, a.exth
  FROM jo73_phocagallery_categories AS cc
  LEFT JOIN jo73_phocagallery AS a
  ON cc.id = a.catid
13. 1 × SELECT id, home, template, s.params
  FROM jo73_template_styles as s
  LEFT JOIN jo73_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
14. 1 × SELECT *
  FROM jo73_languages
15. 1 × SELECT `value`
  FROM `jo73_admintools_storage`
16. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jo73_phocagallery_categories AS c
17. 1 × SELECT cc.*
  FROM jo73_phocagallery_categories AS cc
18. 1 × SELECT `data`
  FROM `jo73_session`
19. 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 jo73_menu AS m
  LEFT JOIN jo73_extensions AS e
  ON m.component_id = e.extension_id

ANDERE Tabellen:

1. 1 × UPDATE `jo73_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:19;s:19:\"session.timer.start\";i:1337564723;s:18:\"session.timer.last\";i:1337565467;s:17:\"session.timer.now\";i:1337565500;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";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:16:\"com_mailto.links\";a:14:{s:40:\"35af5f337f331929a8645a52a87ece2d79e9b636\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://www.watn-boudel.nl/index.php/9-gespot/95-politie-geeft-les-in-hard-rijden.html\";s:6:\"expiry\";i:1337564786;}s:40:\"f2b9f55ef56c732c1b48b41c2439bc8e06bd372a\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"http://www.watn-boudel.nl/index.php/7-algemeen/94-carnaval-2012-de-bultruters.html\";s:6:\"expiry\";i:1337565438;}s:40:\"17da15ffe56fb6decc1e29e8ad68612b583bd0a2\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.watn-boudel.nl/index.php/7-algemeen/92-carnaval-fotos-optocht-bultruters-door-bultrutersland-ter-apel.html\";s:6:\"expiry\";i:1337565406;}s:40:\"11d69995a5b72812d29e6be15d18d529cb42053a\";O:8:\"stdClass\":2:{s:4:\"link\";s:107:\"http://www.watn-boudel.nl/index.php/10-zomaar-wat-nieuws/89-sint-en-piet-nu-ook-in-ter-apel-aangekomen.html\";s:6:\"expiry\";i:1337564818;}s:40:\"c8aac6432a75509f4efcefa977d1f70a8cab1498\";O:8:\"stdClass\":2:{s:4:\"link\";s:83:\"http://www.watn-boudel.nl/index.php/7-algemeen/91-brand-woning-ter-apel-kanaal.html\";s:6:\"expiry\";i:1337565379;}s:40:\"5d02335416dbd3932e7bdf3827c93647a9808b36\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.watn-boudel.nl/index.php/7-algemeen/77-schildersfestival-montmatre-sellingen.html\";s:6:\"expiry\";i:1337564978;}s:40:\"9951b388eb9af757fdf8a8c25253efff434ae833\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.watn-boudel.nl/index.php/7-algemeen/78-jongetje-van-3-dat-in-plas-sellingerbeetse-raakte-is-overleden.html\";s:6:\"expiry\";i:1337565023;}s:40:\"92e071e1f53a84e20328234bb31efcb2be3c6a37\";O:8:\"stdClass\":2:{s:4:\"link\";s:81:\"http://www.watn-boudel.nl/index.php/7-algemeen/81-zomeravond-markt-sellingen.html\";s:6:\"expiry\";i:1337565060;}s:40:\"f2ef7ce6a765166ee8e19966cf164f9b6c4ef3e4\";O:8:\"stdClass\":2:{s:4:\"link\";s:99:\"http://www.watn-boudel.nl/index.php/7-algemeen/82-twee-gewonden-bij-eenzijdig-ongeval-ter-apel.html\";s:6:\"expiry\";i:1337565086;}s:40:\"5413e5d86dc43f36f5df2fedbe837e86571c7286\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"http://www.watn-boudel.nl/index.php/7-algemeen/83-stille-kniptuun-sellingen-open-voor-publiek.html\";s:6:\"expiry\";i:1337565120;}s:40:\"ecbb48d326112237a6607280ec71bed44659c1c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:109:\"http://www.watn-boudel.nl/index.php/7-algemeen/85-artsadier-organiseert-hondendag-klijndijk--foto-update.html\";s:6:\"expiry\";i:1337565147;}s:40:\"67e3f45915139a87d85a46bfa7c33171768cb6ce\";O:8:\"stdClass\":2:{s:4:\"link\";s:104:\"http://www.watn-boudel.nl/index.php/7-algemeen/87-kloostershow-pkv-sport-en-vriendschap-foto-update.html\";s:6:\"expiry\";i:1337565179;}s:40:\"c45d937c31260c1c3adf21b145ad35ccb6d18b9c\";O:8:\"stdClass\":2:{s:4:\"link\";s:109:\"http://www.watn-boudel.nl/index.php/7-algemeen/88-jumbo-stuulen-en-theo-bruning-fietsen-spelen-voor-sint.html\";s:6:\"expiry\";i:1337565308;}s:40:\"ff7c93e1dd4d24525daef038dca0b4c2f58162da\";O:8:\"stdClass\":2:{s:4:\"link\";s:108:\"http://www.watn-boudel.nl/index.php/7-algemeen/90-tentoonstelling-de-vogelvriend-in-t-streekje-ter-apel.html\";s:6:\"expiry\";i:1337565348;}}s:13:\"session.token\";s:32:\"ceeb1f1177eccbec02d1dec2fb4a85a3\";}' , `time` = '1337565501'
2. 1 × UPDATE jo73_phocagallery_categories
  SET `hits` = (`hits` + 1)
3. 1 × SHOW FULL COLUMNS
  FROM `jo73_phocagallery_categories