128 ausgeführte Abfragen

1. SELECT `data`
  FROM `m2kqh_session`
  WHERE `session_id` = 'i1p2a8304fbu2n02lrfbh3ahf7'
2. DELETE
  FROM `m2kqh_session`
  WHERE `time` < '1371529907'
3. SELECT `session_id`
  FROM `m2kqh_session`
  WHERE `session_id` = 'i1p2a8304fbu2n02lrfbh3ahf7'
  LIMIT 0, 1
4. INSERT INTO `m2kqh_session` (`session_id`, `client_id`, `time`)
  VALUES ('i1p2a8304fbu2n02lrfbh3ahf7', 0, '1371530807')
5. SELECT b.id
  FROM m2kqh_usergroups AS a
  LEFT JOIN m2kqh_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `m2kqh_viewlevels`
7. 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 m2kqh_menu AS m
  LEFT JOIN m2kqh_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
8. SELECT *
  FROM m2kqh_zoo_item
  WHERE id = 15
9. SELECT *
  FROM m2kqh_zoo_application
  WHERE id = 8
10. SELECT a.rules
  FROM m2kqh_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
11. SELECT b.rules
  FROM m2kqh_assets AS a
  LEFT JOIN m2kqh_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'root.1' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
12. SELECT *
  FROM m2kqh_zoo_category
  WHERE application_id = 8
  AND published = 1
  ORDER BY ordering
13. UPDATE m2kqh_zoo_item
  SET hits = (hits + 1)
  WHERE id = 15
14. SELECT id
  FROM m2kqh_users
  WHERE id = 42
15. SHOW FULL COLUMNS
  FROM `m2kqh_users`
16. SELECT *
  FROM `m2kqh_users`
  WHERE `id` = 42
17. SELECT `g`.`id`,`g`.`title`
  FROM `m2kqh_usergroups` AS g
  INNER JOIN `m2kqh_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 42
18. SELECT b.id
  FROM m2kqh_user_usergroup_map AS map
  LEFT JOIN m2kqh_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN m2kqh_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 42
19. SELECT a.rules
  FROM m2kqh_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
20. SELECT b.id
  FROM m2kqh_zoo_category_item AS a JOIN m2kqh_zoo_category AS b
  ON a.category_id = b.id
  WHERE a.item_id=15
  AND b.published = 1 UNION SELECT 0
  FROM m2kqh_zoo_category_item AS a
  WHERE a.item_id=15
  AND a.category_id = 0
21. SELECT name
  FROM m2kqh_zoo_tag
  WHERE item_id = 15
22. SHOW FULL COLUMNS
  FROM `m2kqh_content`
23. SELECT `enabled`
  FROM `m2kqh_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
24. SELECT `enabled`
  FROM `m2kqh_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
25. SELECT u.*
  FROM `m2kqh_jvotesystem_users` AS u
  LEFT JOIN `m2kqh_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
  WHERE `ip`="67.202.5.213"
  AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH) < `lastVisitDate`
26. SELECT u.*, s.`id` AS session_id, s.`jsession_id`, s.`cookie`, s.`lastVisitDate`, s.`rights`
  FROM `m2kqh_jvotesystem_users` AS u
  LEFT JOIN `m2kqh_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
  WHERE s.`jsession_id`='i1p2a8304fbu2n02lrfbh3ahf7'
  ORDER BY s.`lastVisitDate` DESC
27. SELECT params
  FROM m2kqh_extensions AS e
  WHERE e.element='com_widgetkit'
28. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM m2kqh_modules AS m
  LEFT JOIN m2kqh_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN m2kqh_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 <= '2013-06-18 04:46:47')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-06-18 04:46:47')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 101 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
29. SELECT name, alias, app_id, app_secret, auth, token, userinfo
  FROM m2kqh_offlajn_oauths
  WHERE published = 1
30. SELECT extension_id, name
  FROM m2kqh_extensions
  WHERE type = 'plugin'
  AND folder = 'search'
  AND enabled =1
  ORDER BY ordering
31. SELECT `enabled`
  FROM `m2kqh_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
32. SELECT *
  FROM m2kqh_zoo_application
  WHERE id = 11
33. SELECT *
  FROM m2kqh_zoo_category
  WHERE application_id = 11
  AND published = 1
  ORDER BY ordering
34. SELECT *
  FROM m2kqh_zoo_item
  WHERE id = 264
35. SELECT a. * , COUNT( c. `id` ) AS comments
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_comments` AS c
  ON ( c. `answer_id` = a. `id`
  AND c. `published` = 1 )
  WHERE a. `id` = ''
  GROUP BY a. `id`
36. SELECT *
  FROM `m2kqh_jvotesystem_boxes`
  WHERE (`id` = '3' OR `alias`="")
  AND `published` > -1
37. SELECT b. * , COUNT( a. `id` ) AS answers, c.`title` AS cattitle
  FROM `m2kqh_jvotesystem_boxes` AS b
  LEFT JOIN `m2kqh_jvotesystem_answers` AS a
  ON (b. `id` = a. `box_id`
  AND `answer` LIKE "%%"
  AND ( (a.`autor_id` = "0"
  AND a.`published` = 0
  AND "0" != 0) OR a.`published` = 1 )), `m2kqh_jvotesystem_categories` AS c
  WHERE c.`id`=b.`catid`
  AND (b. `id` = '3')
  AND b. `published` = 1
  GROUP BY b. `id`
38. SELECT IFNULL(SUM(`votes`), 0) AS votes, (b.`allowed_votes` - IFNULL(SUM(`votes`), 0)) AS allowed_votes
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON v.`answer_id`=a.`id`
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON a.`box_id`=b.`id`
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
  WHERE u.`id`="0"
  AND b.`id`=3
  GROUP BY b.`id`
39. SELECT `allowed_votes`
  FROM `m2kqh_jvotesystem_boxes`
  WHERE `id` = '3'
  AND `published` > -1
40. SELECT b.rules
  FROM m2kqh_assets AS a
  LEFT JOIN m2kqh_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_jvotesystem' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
41. SELECT c.*, IFNULL(COUNT(b.`id`), 0) AS `polls`
  FROM `m2kqh_jvotesystem_categories` AS c
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON(b.`catid`=c.`id`
  AND b.`published` > -1)
  WHERE ( c.`published`=1
  AND (c.`accesslevel`=1 OR c.`accesslevel`=1))
  AND c.`id`= '1'
  GROUP BY c.`id`
42. SELECT result.*
  FROM ( SELECT (@counter:=(@counter+1)) AS counter, IF(`published` = 1, (@rcounter:=(@rcounter+1)), "#") AS rank, resultRank.*
  FROM (SELECT @rcounter:=0)rc, (SELECT @counter:=0)r,( SELECT a.*, IFNULL(SUM(v.`votes`),0) AS votes, MAX(v.`voted_time`) AS lastvote, MAX(v.`voted_time`) AS firstvote , IF(`answer` = "", 1, 0) AS exact_match
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON (v.`answer_id`=a.`id`)
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
  WHERE a.`box_id`='3'
  AND ( a.`published` = 1 )
  GROUP BY a.`id`
  ORDER BY votes DESC, lastvote ASC, created ASC ) AS resultRank ) AS result
  WHERE 1 = 1
  AND `answer` LIKE '%%'
  ORDER BY `exact_match` DESC , votes DESC, lastvote ASC, created ASC
  LIMIT 0, 5
43. SELECT `block_id`, IF(COUNT(*)>0, 1, 0) AS user_report
  FROM `m2kqh_jvotesystem_spam_reports`
  WHERE `user_id`="0"
  AND `block_group`="answer"
  GROUP BY `block_id`
44. SELECT *
  FROM `m2kqh_jvotesystem_bbcodes`
45. SELECT u.*, name, username, ju.email AS jemail, s.`rights`, s.`lastVisitDate`,block
  FROM `m2kqh_jvotesystem_users` AS u
  LEFT JOIN `m2kqh_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
  LEFT JOIN `m2kqh_users` AS ju
  ON (ju.`id`=u.`jid`)
  WHERE u.`id`='1'
  ORDER BY s.`lastVisitDate` DESC
46. SELECT IFNULL(SUM(`votes`), 0) AS votes, (b.`allowed_votes` - IFNULL(SUM(`votes`), 0)) AS allowed_votes
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON v.`answer_id`=a.`id`
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON a.`box_id`=b.`id`
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
  WHERE u.`id`="0"
  AND b.`id`=3
  AND a. `id` = '8'
  GROUP BY b.`id`
47. SELECT `allowed_votes`
  FROM `m2kqh_jvotesystem_boxes`
  WHERE `id` = '3'
  AND `published` > -1
48. SELECT `catid`, `alias`
  FROM `m2kqh_jvotesystem_boxes`
  WHERE `id` = 3
49. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
50. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
51. SELECT a. `id` , COUNT( c. `id` ) AS comments
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_comments` AS c
  ON ( a. `id` = c. `answer_id`
  AND ( (c.`autor_id` = "0"
  AND c.`published` = 0
  AND "0" != 0) OR c.`published` = 1 ) )
  WHERE a.`box_id`=3
  GROUP BY a. `id`
52. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
53. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
54. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
55. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
56. SELECT IFNULL(SUM(`votes`), 0) AS votes, (b.`allowed_votes` - IFNULL(SUM(`votes`), 0)) AS allowed_votes
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON v.`answer_id`=a.`id`
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON a.`box_id`=b.`id`
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
  WHERE u.`id`="0"
  AND b.`id`=3
  AND a. `id` = '7'
  GROUP BY b.`id`
57. SELECT `allowed_votes`
  FROM `m2kqh_jvotesystem_boxes`
  WHERE `id` = '3'
  AND `published` > -1
58. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
59. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
60. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
61. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
62. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
63. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
64. SELECT IFNULL(SUM(`votes`), 0) AS votes, (b.`allowed_votes` - IFNULL(SUM(`votes`), 0)) AS allowed_votes
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON v.`answer_id`=a.`id`
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON a.`box_id`=b.`id`
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
  WHERE u.`id`="0"
  AND b.`id`=3
  AND a. `id` = '9'
  GROUP BY b.`id`
65. SELECT `allowed_votes`
  FROM `m2kqh_jvotesystem_boxes`
  WHERE `id` = '3'
  AND `published` > -1
66. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
67. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
68. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
69. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
70. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
71. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
72. SELECT IFNULL(SUM(`votes`), 0) AS votes, (b.`allowed_votes` - IFNULL(SUM(`votes`), 0)) AS allowed_votes
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON v.`answer_id`=a.`id`
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON a.`box_id`=b.`id`
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
  WHERE u.`id`="0"
  AND b.`id`=3
  AND a. `id` = '12'
  GROUP BY b.`id`
73. SELECT `allowed_votes`
  FROM `m2kqh_jvotesystem_boxes`
  WHERE `id` = '3'
  AND `published` > -1
74. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
75. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
76. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
77. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
78. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
79. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
80. SELECT IFNULL(SUM(`votes`), 0) AS votes, (b.`allowed_votes` - IFNULL(SUM(`votes`), 0)) AS allowed_votes
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON v.`answer_id`=a.`id`
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON a.`box_id`=b.`id`
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
  WHERE u.`id`="0"
  AND b.`id`=3
  AND a. `id` = '11'
  GROUP BY b.`id`
81. SELECT `allowed_votes`
  FROM `m2kqh_jvotesystem_boxes`
  WHERE `id` = '3'
  AND `published` > -1
82. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
83. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
84. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
85. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
86. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
87. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
88. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
89. SELECT link,id
  FROM `m2kqh_menu`
  WHERE
  LEFT(link,length("index.php?option=com_jvotesystem")) = "index.php?option=com_jvotesystem"
  AND published = 1
  AND (language = "*" OR language = "de-DE");
90. SELECT a.*,uc.name AS editor,c.title AS category
  FROM `m2kqh_icagenda_events` AS a
  LEFT JOIN m2kqh_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN m2kqh_icagenda_category AS c
  ON c.id=a.catid
  WHERE a.state = 1
  ORDER BY a.next ASC
91. SELECT a.*,uc.name AS editor,c.title AS category
  FROM `m2kqh_icagenda_events` AS a
  LEFT JOIN m2kqh_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN m2kqh_icagenda_category AS c
  ON c.id=a.catid
  WHERE a.state = 1
  ORDER BY a.next ASC
92. SELECT id AS idm
  FROM m2kqh_menu
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
  AND (language = 'de-DE')
93. SELECT id AS noidm
  FROM m2kqh_menu
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
  AND (language = '*')
94. SELECT id AS noidm
  FROM m2kqh_menu
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
  AND (language = '*')
95. SELECT alias
  FROM m2kqh_icagenda_events
  WHERE id=3
96. SELECT alias
  FROM m2kqh_icagenda_events
  WHERE id=4
97. SELECT alias
  FROM m2kqh_icagenda_events
  WHERE id=1
98. SELECT alias
  FROM m2kqh_icagenda_events
  WHERE id=10
99. SELECT alias
  FROM m2kqh_icagenda_events
  WHERE id=5
100. SELECT alias
  FROM m2kqh_icagenda_events
  WHERE id=9
101. SELECT `enabled`
  FROM `m2kqh_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
102. SELECT *
  FROM m2kqh_zoo_application
  WHERE id = 1
103. SELECT *
  FROM m2kqh_zoo_category
  WHERE application_id = 1
  AND published = 1
  ORDER BY ordering
104. SELECT c.*, i.application_id
  FROM m2kqh_zoo_comment AS c JOIN m2kqh_zoo_item AS i
  ON c.item_id = i.id
  LEFT JOIN m2kqh_zoo_category_item AS ci
  ON i.id = ci.item_id
  WHERE i.application_id = 1
  AND c.state = 1
  AND i.state = 1
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-06-18 04:46:47')
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-06-18 04:46:47')
  AND ci.category_id IN (0,1,2,4,5,3)
  GROUP BY c.id
  ORDER BY c.created DESC
  LIMIT 0, 2
105. SELECT *
  FROM m2kqh_zoo_item
  WHERE id = 284
106. SELECT id
  FROM m2kqh_users
  WHERE id = 723
107. SELECT *
  FROM `m2kqh_users`
  WHERE `id` = 723
108. SELECT `g`.`id`,`g`.`title`
  FROM `m2kqh_usergroups` AS g
  INNER JOIN `m2kqh_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 723
109. SELECT b.id
  FROM m2kqh_user_usergroup_map AS map
  LEFT JOIN m2kqh_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN m2kqh_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 723
110. SELECT a.rules
  FROM m2kqh_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
111. SELECT id
  FROM m2kqh_users
  WHERE id = 81
112. SELECT *
  FROM `m2kqh_users`
  WHERE `id` = 81
113. SELECT `g`.`id`,`g`.`title`
  FROM `m2kqh_usergroups` AS g
  INNER JOIN `m2kqh_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 81
114. SELECT b.id
  FROM m2kqh_user_usergroup_map AS map
  LEFT JOIN m2kqh_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN m2kqh_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 81
115. SELECT a.rules
  FROM m2kqh_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
116. SELECT *
  FROM m2kqh_zoo_application
  WHERE id = 7
117. SELECT *
  FROM m2kqh_zoo_category
  WHERE application_id = 7
  AND published = 1
  ORDER BY ordering
118. SELECT c.*, i.application_id
  FROM m2kqh_zoo_comment AS c JOIN m2kqh_zoo_item AS i
  ON c.item_id = i.id
  LEFT JOIN m2kqh_zoo_category_item AS ci
  ON i.id = ci.item_id
  WHERE i.application_id = 7
  AND c.state = 1
  AND i.state = 1
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-06-18 04:46:47')
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-06-18 04:46:47')
  AND ci.category_id IN (0,28,29,73,57,64,26,27,53,52)
  GROUP BY c.id
  ORDER BY c.created DESC
  LIMIT 0, 2
119. SELECT *
  FROM m2kqh_zoo_item
  WHERE id = 173
120. SELECT id
  FROM m2kqh_users
  WHERE id = 428
121. SELECT *
  FROM `m2kqh_users`
  WHERE `id` = 428
122. SELECT `g`.`id`,`g`.`title`
  FROM `m2kqh_usergroups` AS g
  INNER JOIN `m2kqh_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 428
123. SELECT b.id
  FROM m2kqh_user_usergroup_map AS map
  LEFT JOIN m2kqh_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN m2kqh_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 428
124. SELECT a.rules
  FROM m2kqh_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
125. SELECT *
  FROM m2kqh_zoo_item
  WHERE id = 155
126. SELECT a.*
  FROM m2kqh_zoo_item AS a
  LEFT JOIN m2kqh_zoo_category_item AS b
  ON a.id = b.item_id
  WHERE a.application_id = 7
  AND b.category_id IN (57,64,26,27,53,52)
  AND access IN (1)
  AND a.state = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-06-18 04:46:47')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-06-18 04:46:47')
  GROUP BY a.id
  ORDER BY a.priority DESC, a.modified DESC
  LIMIT 0,4
127. SELECT `enabled`
  FROM `m2kqh_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
128. UPDATE `m2kqh_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1371530807;s:18:\"session.timer.last\";i:1371530807;s:17:\"session.timer.now\";i:1371530807;s:22:\"session.client.browser\";s:9:\"CCBot/2.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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;i: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:10:\"superadmin\";N;}s:13:\"session.token\";s:32:\"852f808e0f52e5ce39f4d8af86a790bd\";s:17:\"jVoteBoxPageArray\";a:1:{i:3;a:1:{s:6:\"module\";i:1;}}}ologin|a:3:{s:5:\"https\";s:1:\"0\";s:4:\"curl\";s:1:\"0\";s:7:\"regpage\";s:4:\"auto\";}oauth|a:4:{s:8:\"facebook\";O:8:\"stdClass\":7:{s:4:\"name\";s:8:\"Facebook\";s:5:\"alias\";s:8:\"facebook\";s:6:\"app_id\";s:15:\"437390999630348\";s:10:\"app_secret\";s:32:\"a13caae11b7a1823966ab14774e04ae1\";s:4:\"auth\";s:82:\"https://www.facebook.com/dialog/oauth?scope=email&response_type=code&display=popup\";s:5:\"token\";s:45:\"https://graph.facebook.com/oauth/access_token\";s:8:\"userinfo\";s:29:\"https://graph.facebook.com/me\";}s:6:\"google\";O:8:\"stdClass\":7:{s:4:\"name\";s:6:\"Google\";s:5:\"alias\";s:6:\"google\";s:6:\"app_id\";s:39:\"731269355448.apps.googleusercontent.com\";s:10:\"app_secret\";s:24:\"43WlyQZbIG0MyWBEHZ-bIBNH\";s:4:\"auth\";s:196:\"https://accounts.google.com/o/oauth2/auth?scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile&response_type=code&display=popup\";s:5:\"token\";s:42:\"https://accounts.google.com/o/oauth2/token\";s:8:\"userinfo\";s:45:\"https://www.googleapis.com/oauth2/v2/userinfo\";}s:7:\"twitter\";O:8:\"stdClass\":7:{s:4:\"name\";s:7:\"Twitter\";s:5:\"alias\";s:7:\"twitter\";s:6:\"app_id\";s:22:\"mV8HTsoxRpS94qWNWv1sxg\";s:10:\"app_secret\";s:41:\"1COu6ekXkaTfpmk1Gg5Yc9TwD67K5aCbtPyAKdqds\";s:4:\"auth\";s:0:\"\";s:5:\"token\";s:0:\"\";s:8:\"userinfo\";s:0:\"\";}s:7:\"windows\";O:8:\"stdClass\":7:{s:4:\"name\";s:12:\"Windows Live\";s:5:\"alias\";s:7:\"windows\";s:6:\"app_id\";s:16:\"00000000440D624F\";s:10:\"app_secret\";s:32:\"ntpaLsQ1ex3xaqoMV8QnaYDrzsXRbynK\";s:4:\"auth\";s:93:\"https://login.live.com/oauth20_authorize.srf?scope=wl.emails&response_type=code&display=popup\";s:5:\"token\";s:40:\"https://login.live.com/oauth20_token.srf\";s:8:\"userinfo\";s:29:\"https://apis.live.net/v5.0/me\";}}reCaptcha|a:2:{s:6:\"public\";s:40:\"6Lc8m9USAAAAAPmbY8EiK9eVXKClTwNqSsqK6TGZ\";s:7:\"private\";s:40:\"6Lc8m9USAAAAAOEiVujNJbLFv-41oBMO2oN8klBO\";}fakeItemid|s:3:\"101\";__joomessLibrary|a:1:{s:5:\"files\";a:0:{}}' , `time` = '1371530809'
  WHERE `session_id` = 'i1p2a8304fbu2n02lrfbh3ahf7'

48 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 32 × SELECT link,id
  FROM `m2kqh_menu`
2. 6 × SELECT alias
  FROM m2kqh_icagenda_events
3. 6 × SELECT `allowed_votes`
  FROM `m2kqh_jvotesystem_boxes`
4. 6 × SELECT IFNULL(SUM(`votes`), 0) AS votes, (b.`allowed_votes` - IFNULL(SUM(`votes`), 0)) AS allowed_votes
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON v.`answer_id`=a.`id`
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON a.`box_id`=b.`id`
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
5. 5 × SELECT a.rules
  FROM m2kqh_assets AS a
6. 5 × SELECT `enabled`
  FROM `m2kqh_extensions`
7. 5 × SELECT *
  FROM m2kqh_zoo_item
8. 4 × SELECT *
  FROM `m2kqh_users`
9. 4 × SELECT id
  FROM m2kqh_users
10. 4 × SELECT b.id
  FROM m2kqh_user_usergroup_map AS map
  LEFT JOIN m2kqh_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN m2kqh_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
11. 4 × SELECT `g`.`id`,`g`.`title`
  FROM `m2kqh_usergroups` AS g
  INNER JOIN `m2kqh_user_usergroup_map` AS m
  ON m.group_id = g.id
12. 4 × SELECT *
  FROM m2kqh_zoo_application
13. 4 × SELECT *
  FROM m2kqh_zoo_category
14. 2 × SELECT id AS noidm
  FROM m2kqh_menu
15. 2 × SELECT a.*,uc.name AS editor,c.title AS category
  FROM `m2kqh_icagenda_events` AS a
  LEFT JOIN m2kqh_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN m2kqh_icagenda_category AS c
  ON c.id=a.catid
16. 2 × SELECT c.*, i.application_id
  FROM m2kqh_zoo_comment AS c JOIN m2kqh_zoo_item AS i
  ON c.item_id = i.id
  LEFT JOIN m2kqh_zoo_category_item AS ci
  ON i.id = ci.item_id
17. 2 × SELECT b.rules
  FROM m2kqh_assets AS a
  LEFT JOIN m2kqh_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
18. 1 × SELECT result.*
  FROM ( SELECT (@counter:=(@counter+1)) AS counter, IF(`published` = 1, (@rcounter:=(@rcounter+1)), "#") AS rank, resultRank.*
  FROM (SELECT @rcounter:=0)rc, (SELECT @counter:=0)r,( SELECT a.*, IFNULL(SUM(v.`votes`),0) AS votes, MAX(v.`voted_time`) AS lastvote, MAX(v.`voted_time`) AS firstvote , IF(`answer` = "", 1, 0) AS exact_match
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_votes` AS v
  ON (v.`answer_id`=a.`id`)
  LEFT JOIN `m2kqh_jvotesystem_users` AS u
  ON (u.`id`=v.`user_id`
  AND u.`blocked`=0)
19. 1 × SELECT c.*, IFNULL(COUNT(b.`id`), 0) AS `polls`
  FROM `m2kqh_jvotesystem_categories` AS c
  LEFT JOIN `m2kqh_jvotesystem_boxes` AS b
  ON(b.`catid`=c.`id`
  AND b.`published` > -1)
20. 1 × SELECT `block_id`, IF(COUNT(*)>0, 1, 0) AS user_report
  FROM `m2kqh_jvotesystem_spam_reports`
21. 1 × SELECT a.*
  FROM m2kqh_zoo_item AS a
  LEFT JOIN m2kqh_zoo_category_item AS b
  ON a.id = b.item_id
22. 1 × SELECT u.*, name, username, ju.email AS jemail, s.`rights`, s.`lastVisitDate`,block
  FROM `m2kqh_jvotesystem_users` AS u
  LEFT JOIN `m2kqh_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
  LEFT JOIN `m2kqh_users` AS ju
  ON (ju.`id`=u.`jid`)
23. 1 × SELECT a. `id` , COUNT( c. `id` ) AS comments
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_comments` AS c
  ON ( a. `id` = c. `answer_id`
  AND ( (c.`autor_id` = "0"
  AND c.`published` = 0
  AND "0" != 0) OR c.`published` = 1 ) )
24. 1 × SELECT `catid`, `alias`
  FROM `m2kqh_jvotesystem_boxes`
25. 1 × SELECT id AS idm
  FROM m2kqh_menu
26. 1 × SELECT *
  FROM `m2kqh_jvotesystem_bbcodes
27. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM m2kqh_modules AS m
  LEFT JOIN m2kqh_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN m2kqh_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
28. 1 × SELECT b.id
  FROM m2kqh_zoo_category_item AS a JOIN m2kqh_zoo_category AS b
  ON a.category_id = b.id
29. 1 × SELECT name
  FROM m2kqh_zoo_tag
30. 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 m2kqh_menu AS m
  LEFT JOIN m2kqh_extensions AS e
  ON m.component_id = e.extension_id
31. 1 × SELECT id, rules
  FROM `m2kqh_viewlevels
32. 1 × SELECT `session_id`
  FROM `m2kqh_session`
33. 1 × SELECT b.id
  FROM m2kqh_usergroups AS a
  LEFT JOIN m2kqh_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
34. 1 × SELECT u.*
  FROM `m2kqh_jvotesystem_users` AS u
  LEFT JOIN `m2kqh_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
35. 1 × SELECT u.*, s.`id` AS session_id, s.`jsession_id`, s.`cookie`, s.`lastVisitDate`, s.`rights`
  FROM `m2kqh_jvotesystem_users` AS u
  LEFT JOIN `m2kqh_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
36. 1 × SELECT a. * , COUNT( c. `id` ) AS comments
  FROM `m2kqh_jvotesystem_answers` AS a
  LEFT JOIN `m2kqh_jvotesystem_comments` AS c
  ON ( c. `answer_id` = a. `id`
  AND c. `published` = 1 )
37. 1 × SELECT *
  FROM `m2kqh_jvotesystem_boxes`
38. 1 × SELECT extension_id, name
  FROM m2kqh_extensions
39. 1 × SELECT name, alias, app_id, app_secret, auth, token, userinfo
  FROM m2kqh_offlajn_oauths
40. 1 × SELECT params
  FROM m2kqh_extensions AS e
41. 1 × SELECT `data`
  FROM `m2kqh_session`
42. 1 × SELECT b. * , COUNT( a. `id` ) AS answers, c.`title` AS cattitle
  FROM `m2kqh_jvotesystem_boxes` AS b
  LEFT JOIN `m2kqh_jvotesystem_answers` AS a
  ON (b. `id` = a. `box_id`
  AND `answer` LIKE "%%"
  AND ( (a.`autor_id` = "0"
  AND a.`published` = 0
  AND "0" != 0) OR a.`published` = 1 )), `m2kqh_jvotesystem_categories` AS c

Andere Tabellen:

1. 1 × SHOW FULL COLUMNS
  FROM `m2kqh_content
2. 1 × UPDATE `m2kqh_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1371530807;s:18:\"session.timer.last\";i:1371530807;s:17:\"session.timer.now\";i:1371530807;s:22:\"session.client.browser\";s:9:\"CCBot/2.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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:13:\"lastResetTime\";N;s:10:\"resetCount\";N;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;i: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:10:\"superadmin\";N;}s:13:\"session.token\";s:32:\"852f808e0f52e5ce39f4d8af86a790bd\";s:17:\"jVoteBoxPageArray\";a:1:{i:3;a:1:{s:6:\"module\";i:1;}}}ologin|a:3:{s:5:\"https\";s:1:\"0\";s:4:\"curl\";s:1:\"0\";s:7:\"regpage\";s:4:\"auto\";}oauth|a:4:{s:8:\"facebook\";O:8:\"stdClass\":7:{s:4:\"name\";s:8:\"Facebook\";s:5:\"alias\";s:8:\"facebook\";s:6:\"app_id\";s:15:\"437390999630348\";s:10:\"app_secret\";s:32:\"a13caae11b7a1823966ab14774e04ae1\";s:4:\"auth\";s:82:\"https://www.facebook.com/dialog/oauth?scope=email&response_type=code&display=popup\";s:5:\"token\";s:45:\"https://graph.facebook.com/oauth/access_token\";s:8:\"userinfo\";s:29:\"https://graph.facebook.com/me\";}s:6:\"google\";O:8:\"stdClass\":7:{s:4:\"name\";s:6:\"Google\";s:5:\"alias\";s:6:\"google\";s:6:\"app_id\";s:39:\"731269355448.apps.googleusercontent.com\";s:10:\"app_secret\";s:24:\"43WlyQZbIG0MyWBEHZ-bIBNH\";s:4:\"auth\";s:196:\"https://accounts.google.com/o/oauth2/auth?scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile&response_type=code&display=popup\";s:5:\"token\";s:42:\"https://accounts.google.com/o/oauth2/token\";s:8:\"userinfo\";s:45:\"https://www.googleapis.com/oauth2/v2/userinfo\";}s:7:\"twitter\";O:8:\"stdClass\":7:{s:4:\"name\";s:7:\"Twitter\";s:5:\"alias\";s:7:\"twitter\";s:6:\"app_id\";s:22:\"mV8HTsoxRpS94qWNWv1sxg\";s:10:\"app_secret\";s:41:\"1COu6ekXkaTfpmk1Gg5Yc9TwD67K5aCbtPyAKdqds\";s:4:\"auth\";s:0:\"\";s:5:\"token\";s:0:\"\";s:8:\"userinfo\";s:0:\"\";}s:7:\"windows\";O:8:\"stdClass\":7:{s:4:\"name\";s:12:\"Windows Live\";s:5:\"alias\";s:7:\"windows\";s:6:\"app_id\";s:16:\"00000000440D624F\";s:10:\"app_secret\";s:32:\"ntpaLsQ1ex3xaqoMV8QnaYDrzsXRbynK\";s:4:\"auth\";s:93:\"https://login.live.com/oauth20_authorize.srf?scope=wl.emails&response_type=code&display=popup\";s:5:\"token\";s:40:\"https://login.live.com/oauth20_token.srf\";s:8:\"userinfo\";s:29:\"https://apis.live.net/v5.0/me\";}}reCaptcha|a:2:{s:6:\"public\";s:40:\"6Lc8m9USAAAAAPmbY8EiK9eVXKClTwNqSsqK6TGZ\";s:7:\"private\";s:40:\"6Lc8m9USAAAAAOEiVujNJbLFv-41oBMO2oN8klBO\";}fakeItemid|s:3:\"101\";__joomessLibrary|a:1:{s:5:\"files\";a:0:{}}' , `time` = '1371530809'
3. 1 × SHOW FULL COLUMNS
  FROM `m2kqh_users
4. 1 × UPDATE m2kqh_zoo_item
  SET hits = (hits + 1)
5. 1 × INSERT INTO `m2kqh_session` (`session_id`, `client_id`, `time`)
  VALUES ('i1p2a8304fbu2n02lrfbh3ahf7', 0, '1371530807'
6. 1 × DELETE
  FROM `m2kqh_session`