Joomla!-Debug-Konsole

16 ausgeführte Abfragen

1. SELECT `data`
  FROM `c3pea_session`
  WHERE `session_id` = 'fa4b1a8653892e10dd411108da1cd3f0'
2. DELETE
  FROM `c3pea_session`
  WHERE `time` < '1524371247'
3. SELECT `session_id`
  FROM `c3pea_session`
  WHERE `session_id` = 'fa4b1a8653892e10dd411108da1cd3f0'
  LIMIT 0, 1
4. INSERT INTO `c3pea_session` (`session_id`, `client_id`, `time`)
  VALUES ('fa4b1a8653892e10dd411108da1cd3f0', 0, '1524372147')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM c3pea_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM c3pea_usergroups AS a
  LEFT JOIN c3pea_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `c3pea_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM c3pea_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT *
  FROM c3pea_languages
  WHERE published=1
  ORDER BY ordering ASC
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM c3pea_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
11. SELECT language,id
  FROM `c3pea_menu`
  WHERE home = 1
  AND published = 1
  AND client_id = 0
12. 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 c3pea_menu AS m
  LEFT JOIN c3pea_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
13. SELECT extension_id AS id, element AS "option", params, enabled
  FROM c3pea_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_mailto'
14. SELECT extension_id AS id, element AS "option", params, enabled
  FROM c3pea_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
15. SELECT id, home, template, s.params
  FROM c3pea_template_styles as s
  LEFT JOIN c3pea_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
16. UPDATE `c3pea_session`
  SET `data` = '4solQZiWAxxPjl85tOi1VDuP44bYUSSeMEnGNOSmns0K8p1W4sEskO_eWFWzdKtwftEStiiLr8tHUm5uN0eHaZE0ZpUmK94HHXownjEvkn9TXkvZs9HpX0PBdiOKy9m5PYba08KkfWGlZsaDRMVG1dUWZzy7yfDNKj9ish48uBU_pSjmFQIvkwZFDYuyXYnmnsJXa8hbCuBteuh-7zfOCD_x_iMItCS6umSdCFN2eLAdkWw3g-sPQMWVldKoFyFaTytvZajqlepG5QIaHa_nvvDlA9buG-qL3Ua91kAp7YgUW2-9noFkLypKXnHoUEpweROWGcdl74y7AlNkdbJ18YyEV8RTLaEKyfPJmhLHbF3_aB_Dm3J5QuKqlEQDB28Mv1NHEwinrFC-9LPucR2tHPMxmXGAzytjrHqD5WILGqUtWmNC4qkcgGxfpAZU6lWF7q3h3zEirV9maU8Kn5B_KmjagCDNE_XTo6Q6O94sFi9uc96j0E3jKTTGoSe9AurPT3iV0teG750WioiiqmaFq_JXKHfaYZEyl0QWgZVD7tqJZv566VgxR639__LlbGJxIx7aMobTfEofIlj3BUiMKnSPi1qL9ABEsW0y2Bttz4FlTypVNiwqAoT2ajyZEw2Zamcr0Y1cQ48YdNshq7dnt1a8hN5O3Vnnxv6mJARp4wqYlQABSjsH6YQUF9nRyJydtq12FnBqVT0N8Om_TdJzO6qGRfsWT2vqZMB0xV3lQdfC_rnkaC7P5HmBijLdIgAIT0ddJRK4GwfkpO2UrQ0hvJLgUO4Pt2LrU3h1YTj_Rc_YpqxZWSja9YxtDG7bvgAnwii5ZXFSJgSqHC-hyF3dtFwtnl79SGF9mYBGMmY6ir-pATF98HbuVbRPSxHqnFR5AhivTuGUvDFl6wwts2D_UsI8RvrjjtkXc5a0GXUGXuK8criQHLt1AcBCXS0AmdLuh8vYWFGF-guUd1Ji8da4MLniJ4Nt0x2GmhJsa_4McjDku0F97OCQfxKHbT3EMtl59TdknVtt9i9hlny_nEDvoRwiUzHeN9q2TH91ZSL2DMrVRPdBjvlPHWV7ICelAFmwhekxLsvU1o_DQyTLUEudkTWMOvRiUJMTbGC8dt7KvcXAET4Vj42K0mGNPoBONk1-qSoDyfSz9bfoWDrQRvk31XjTpC0FoVcDis5hne-V1kK7hfj5ZU6UaNSI3qPf3lzsccP8DGHnM9tLsbn-NFwxCzrVGzFuVNte_J06nhsCxMGNxESxSOgTW0zLKVTf5nHAi3rNU06MN79jsDDS-W8di9Tw0JaTaVOOQKerhPUfu9TJ7PZ9dUMs8xC4q6MYd2pL' , `time` = '1524372147'
  WHERE `session_id` = 'fa4b1a8653892e10dd411108da1cd3f0'

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

SELECT-Tabellen:

1. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM c3pea_extensions
2. 1 × SELECT language,id
  FROM `c3pea_menu`
3. 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 c3pea_menu AS m
  LEFT JOIN c3pea_extensions AS e
  ON m.component_id = e.extension_id
4. 1 × SELECT *
  FROM c3pea_languages
5. 1 × SELECT id, home, template, s.params
  FROM c3pea_template_styles as s
  LEFT JOIN c3pea_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
6. 1 × SELECT id, rules
  FROM `c3pea_viewlevels
7. 1 × SELECT `session_id`
  FROM `c3pea_session`
8. 1 × SELECT b.id
  FROM c3pea_usergroups AS a
  LEFT JOIN c3pea_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
9. 1 × SELECT `data`
  FROM `c3pea_session`
10. 1 × SELECT folder AS type, element AS name, params
  FROM c3pea_extensions

Andere Tabellen:

1. 1 × UPDATE `c3pea_session`
  SET `data` = '4solQZiWAxxPjl85tOi1VDuP44bYUSSeMEnGNOSmns0K8p1W4sEskO_eWFWzdKtwftEStiiLr8tHUm5uN0eHaZE0ZpUmK94HHXownjEvkn9TXkvZs9HpX0PBdiOKy9m5PYba08KkfWGlZsaDRMVG1dUWZzy7yfDNKj9ish48uBU_pSjmFQIvkwZFDYuyXYnmnsJXa8hbCuBteuh-7zfOCD_x_iMItCS6umSdCFN2eLAdkWw3g-sPQMWVldKoFyFaTytvZajqlepG5QIaHa_nvvDlA9buG-qL3Ua91kAp7YgUW2-9noFkLypKXnHoUEpweROWGcdl74y7AlNkdbJ18YyEV8RTLaEKyfPJmhLHbF3_aB_Dm3J5QuKqlEQDB28Mv1NHEwinrFC-9LPucR2tHPMxmXGAzytjrHqD5WILGqUtWmNC4qkcgGxfpAZU6lWF7q3h3zEirV9maU8Kn5B_KmjagCDNE_XTo6Q6O94sFi9uc96j0E3jKTTGoSe9AurPT3iV0teG750WioiiqmaFq_JXKHfaYZEyl0QWgZVD7tqJZv566VgxR639__LlbGJxIx7aMobTfEofIlj3BUiMKnSPi1qL9ABEsW0y2Bttz4FlTypVNiwqAoT2ajyZEw2Zamcr0Y1cQ48YdNshq7dnt1a8hN5O3Vnnxv6mJARp4wqYlQABSjsH6YQUF9nRyJydtq12FnBqVT0N8Om_TdJzO6qGRfsWT2vqZMB0xV3lQdfC_rnkaC7P5HmBijLdIgAIT0ddJRK4GwfkpO2UrQ0hvJLgUO4Pt2LrU3h1YTj_Rc_YpqxZWSja9YxtDG7bvgAnwii5ZXFSJgSqHC-hyF3dtFwtnl79SGF9mYBGMmY6ir-pATF98HbuVbRPSxHqnFR5AhivTuGUvDFl6wwts2D_UsI8RvrjjtkXc5a0GXUGXuK8criQHLt1AcBCXS0AmdLuh8vYWFGF-guUd1Ji8da4MLniJ4Nt0x2GmhJsa_4McjDku0F97OCQfxKHbT3EMtl59TdknVtt9i9hlny_nEDvoRwiUzHeN9q2TH91ZSL2DMrVRPdBjvlPHWV7ICelAFmwhekxLsvU1o_DQyTLUEudkTWMOvRiUJMTbGC8dt7KvcXAET4Vj42K0mGNPoBONk1-qSoDyfSz9bfoWDrQRvk31XjTpC0FoVcDis5hne-V1kK7hfj5ZU6UaNSI3qPf3lzsccP8DGHnM9tLsbn-NFwxCzrVGzFuVNte_J06nhsCxMGNxESxSOgTW0zLKVTf5nHAi3rNU06MN79jsDDS-W8di9Tw0JaTaVOOQKerhPUfu9TJ7PZ9dUMs8xC4q6MYd2pL' , `time` = '1524372147'
2. 1 × INSERT INTO `c3pea_session` (`session_id`, `client_id`, `time`)
  VALUES ('fa4b1a8653892e10dd411108da1cd3f0', 0, '1524372147'
3. 1 × DELETE
  FROM `c3pea_session`