Consola de Joomla! Debug

22 Registro Consultas

1. SELECT `data`
  FROM `j25_session`
  WHERE `session_id` = '4a1c9973c10ca8d709d91065521b4f03'
2. DELETE
  FROM `j25_session`
  WHERE `time` < '1550759235'
3. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = '4a1c9973c10ca8d709d91065521b4f03'
  LIMIT 0, 1
4. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('4a1c9973c10ca8d709d91065521b4f03', 0, '1550761035')
5. SELECT b.id
  FROM j25_usergroups AS a
  LEFT JOIN j25_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `j25_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 j25_menu AS m
  LEFT JOIN j25_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 a.rules
  FROM j25_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
9. SELECT b.rules
  FROM j25_assets AS a
  LEFT JOIN j25_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
10. SELECT id
  FROM j25_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
11. SELECT *
  FROM j25_k2_items
  WHERE id=373
  LIMIT 0, 1
12. SHOW FULL COLUMNS
  FROM `j25_k2_categories`
13. SELECT *
  FROM j25_k2_categories
  WHERE id = '76'
14. SELECT *
  FROM j25_k2_categories
  WHERE id = '126'
15. SELECT *
  FROM j25_k2_attachments
  WHERE itemID=373
16. SELECT *
  FROM j25_k2_rating
  WHERE itemID = 373
17. SELECT COUNT(*)
  FROM j25_k2_comments
  WHERE itemID=373
  AND published=1
18. SHOW FULL COLUMNS
  FROM `j25_k2_items`
19. UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '373'
20. SELECT *
  FROM j25_k2_items
  WHERE id != 373
  AND catid=76
  AND ordering > 4
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-21 14:57:15' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-21 14:57:15' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering ASC
  LIMIT 0, 1
21. SELECT *
  FROM j25_k2_items
  WHERE id != 373
  AND catid=76
  AND ordering < 4
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-21 14:57:15' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-21 14:57:15' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering DESC
  LIMIT 0, 1
22. UPDATE `j25_session`
  SET `data` = 'W_gxxFKUfe6yJKo9Ki21eb9yeAzsFIr8VRK-0dw0UpNvX9hmxAiTouoX9L44TErQcDtaGbXlIkVrcwsOHUufUUpV9-uGhryseUMZd4Auf9CFjRjjrPcw6rRQB-8M74tCr0qLhOsjdMdB9i8YB8Aoq3r7fYUEZdpzBlPGpxwYx3jM36r4wa7qeox297J8pWODb9gpaLx3C4QJGIVl7fXN43CEZmzve2qowPh7LLS5ytPUhi0OhCDEQMsQDUfE_ScrZ3lyIQG9_cQG7ygsz5Xb9A6p2LXT4t67OoysByRlCtn76ZbOkYRkNpnTZ1hW9VauGVGpBZF2T-Esop_LskFXSa_xmINeIEUEN_h9nAhqxO-CKnf8Wx32N8ANrv98IMBGHbCnPechg-LB2WxTg3qjoX0EhV3eGKSlxSrm2J4LJeC4xEUI0uBdZsYUJm4bPLtId_D5fXFX7SqxI7WkjJMzMpKEmLLCNaQZCeM-KuGmBdRJTsulawB3xpTmmZCfNuoVfGTGAw421fp5506UkSmDC8_MJuEF5WemWFrbQHgHIbsPXQWXaUZ9vsvxu09qlPVjcjph_6WPiQBo8WHbNuMWcvjtUkuE2j_QgfGKjdTnEw1rCMhmCfsUnzy_xcD9eMh8bn22wCytEUAR33QmVLgni5Y3ofxUsbi-uODG0PPiDcgs_VNqnd3Ph4UtDJQ9HX8MWU6BI0qLA0WIbGQTOi2Xvenmr7RN1yniodwAGsuADgLx9FH-RQWYwBgpgApCCJi3JBSdmTXJof7uhqdreFiyIxysojIq9pev8EBZUVG6GHr7uxj4_GW_spbLS2U3WEBNQAoWYePXsK_XVNpXcir5K8Hz9z7ry2gN_E_Gex0c5139x0LkWat9a_KcjZgMLr3o3foRyFa_LiPOb-vHKbfgeA4OZBXCkKu66CszClDoEYqNqEfWbkYKXlc0CM5QbqNshfecCGcAy4WN3KBzUUUxsNFw4PVfhC0vyUZurp44neu5hNQhtwBeqwcvUATpAudtx_V_m_dWGCuEW0wbBWE7ClefqQlr65F__R5GYNxsqPBnOEghT9mugcl6qQH0_pHlxvCbX-6mJTxomPZnxULMT-WKmFXR7BFPw6c0SFN88xOaca_7gFBAIITxYsyoI88tZgOyr9ipS4lc5oEwNcehD8tSrPr_Xxqp6AYk32trrqS31LfDsa9e1pPuFki3USIty7bBZyUkA9Hnxnjoqfi-xVjiUu3j1b3CARf40XIJFOCbqPfB-XP_rTlQOpeM1pIuo4CPJC02wOdDMwbZ0RzC8B8hI5hoSaXGv9K-ky71wKhzOx93ORyq8BR5025vTXNoEZ42My_1_1sqFRfQzTJ6HkOHGKpayza-bxQHCUz64vioDVAXrpR1-AHsuWhlKp5nFTV-JqZJeJ5JMdg2fgVJkkuOy3DfArm3V-IQ8A5vBa7KlHLG-jwM_i1rfdPkKFm7Ul8-mBIl9YC5YFZEmeF_UlPGgYbEBrbMlP-xnEFof4KgOuESOOoOCH28IB3zkf3hihodq2P134cXrZ69LvxCKFm6ngqCLV18XfqxTv1NoTE.' , `time` = '1550761035'
  WHERE `session_id` = '4a1c9973c10ca8d709d91065521b4f03'

19 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

1. 3 × SELECT *
  FROM j25_k2_items
2. 2 × SELECT *
  FROM j25_k2_categories
3. 1 × SELECT *
  FROM j25_k2_attachments
4. 1 × SELECT *
  FROM j25_k2_rating
5. 1 × SELECT COUNT(*)
  FROM j25_k2_comments
6. 1 × SELECT id
  FROM j25_k2_categories
7. 1 × SELECT b.rules
  FROM j25_assets AS a
  LEFT JOIN j25_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
8. 1 × SELECT b.id
  FROM j25_usergroups AS a
  LEFT JOIN j25_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
9. 1 × SELECT `session_id`
  FROM `j25_session`
10. 1 × SELECT id, rules
  FROM `j25_viewlevels
11. 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 j25_menu AS m
  LEFT JOIN j25_extensions AS e
  ON m.component_id = e.extension_id
12. 1 × SELECT a.rules
  FROM j25_assets AS a
13. 1 × SELECT `data`
  FROM `j25_session`

OTRAS Tablas:

1. 1 × UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
2. 1 × UPDATE `j25_session`
  SET `data` = 'W_gxxFKUfe6yJKo9Ki21eb9yeAzsFIr8VRK-0dw0UpNvX9hmxAiTouoX9L44TErQcDtaGbXlIkVrcwsOHUufUUpV9-uGhryseUMZd4Auf9CFjRjjrPcw6rRQB-8M74tCr0qLhOsjdMdB9i8YB8Aoq3r7fYUEZdpzBlPGpxwYx3jM36r4wa7qeox297J8pWODb9gpaLx3C4QJGIVl7fXN43CEZmzve2qowPh7LLS5ytPUhi0OhCDEQMsQDUfE_ScrZ3lyIQG9_cQG7ygsz5Xb9A6p2LXT4t67OoysByRlCtn76ZbOkYRkNpnTZ1hW9VauGVGpBZF2T-Esop_LskFXSa_xmINeIEUEN_h9nAhqxO-CKnf8Wx32N8ANrv98IMBGHbCnPechg-LB2WxTg3qjoX0EhV3eGKSlxSrm2J4LJeC4xEUI0uBdZsYUJm4bPLtId_D5fXFX7SqxI7WkjJMzMpKEmLLCNaQZCeM-KuGmBdRJTsulawB3xpTmmZCfNuoVfGTGAw421fp5506UkSmDC8_MJuEF5WemWFrbQHgHIbsPXQWXaUZ9vsvxu09qlPVjcjph_6WPiQBo8WHbNuMWcvjtUkuE2j_QgfGKjdTnEw1rCMhmCfsUnzy_xcD9eMh8bn22wCytEUAR33QmVLgni5Y3ofxUsbi-uODG0PPiDcgs_VNqnd3Ph4UtDJQ9HX8MWU6BI0qLA0WIbGQTOi2Xvenmr7RN1yniodwAGsuADgLx9FH-RQWYwBgpgApCCJi3JBSdmTXJof7uhqdreFiyIxysojIq9pev8EBZUVG6GHr7uxj4_GW_spbLS2U3WEBNQAoWYePXsK_XVNpXcir5K8Hz9z7ry2gN_E_Gex0c5139x0LkWat9a_KcjZgMLr3o3foRyFa_LiPOb-vHKbfgeA4OZBXCkKu66CszClDoEYqNqEfWbkYKXlc0CM5QbqNshfecCGcAy4WN3KBzUUUxsNFw4PVfhC0vyUZurp44neu5hNQhtwBeqwcvUATpAudtx_V_m_dWGCuEW0wbBWE7ClefqQlr65F__R5GYNxsqPBnOEghT9mugcl6qQH0_pHlxvCbX-6mJTxomPZnxULMT-WKmFXR7BFPw6c0SFN88xOaca_7gFBAIITxYsyoI88tZgOyr9ipS4lc5oEwNcehD8tSrPr_Xxqp6AYk32trrqS31LfDsa9e1pPuFki3USIty7bBZyUkA9Hnxnjoqfi-xVjiUu3j1b3CARf40XIJFOCbqPfB-XP_rTlQOpeM1pIuo4CPJC02wOdDMwbZ0RzC8B8hI5hoSaXGv9K-ky71wKhzOx93ORyq8BR5025vTXNoEZ42My_1_1sqFRfQzTJ6HkOHGKpayza-bxQHCUz64vioDVAXrpR1-AHsuWhlKp5nFTV-JqZJeJ5JMdg2fgVJkkuOy3DfArm3V-IQ8A5vBa7KlHLG-jwM_i1rfdPkKFm7Ul8-mBIl9YC5YFZEmeF_UlPGgYbEBrbMlP-xnEFof4KgOuESOOoOCH28IB3zkf3hihodq2P134cXrZ69LvxCKFm6ngqCLV18XfqxTv1NoTE.' , `time` = '1550761035'
3. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_items
4. 1 × SHOW FULL COLUMNS
  FROM `j25_k2_categories
5. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('4a1c9973c10ca8d709d91065521b4f03', 0, '1550761035'
6. 1 × DELETE
  FROM `j25_session`