Consola de Joomla! Debug

23 Registro Consultas

1. SELECT `data`
  FROM `j25_session`
  WHERE `session_id` = 'c5bfcc943ff0430fa985060ba85d7984'
2. DELETE
  FROM `j25_session`
  WHERE `time` < '1550440529'
3. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = 'c5bfcc943ff0430fa985060ba85d7984'
  LIMIT 0, 1
4. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('c5bfcc943ff0430fa985060ba85d7984', 0, '1550442329')
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=203
  LIMIT 0, 1
12. SHOW FULL COLUMNS
  FROM `j25_k2_categories`
13. SELECT *
  FROM j25_k2_categories
  WHERE id = '69'
14. SELECT *
  FROM j25_k2_categories
  WHERE id = '126'
15. SELECT *
  FROM j25_k2_attachments
  WHERE itemID=203
16. SELECT *
  FROM j25_k2_rating
  WHERE itemID = 203
17. SELECT COUNT(*)
  FROM j25_k2_comments
  WHERE itemID=203
  AND published=1
18. SHOW FULL COLUMNS
  FROM `j25_k2_items`
19. UPDATE j25_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '203'
20. SELECT *
  FROM j25_k2_items
  WHERE id != 203
  AND catid=69
  AND ordering > 7
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-17 22:25:29' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-17 22:25:29' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering ASC
  LIMIT 0, 1
21. SELECT *
  FROM j25_k2_items
  WHERE id != 203
  AND catid=69
  AND ordering < 7
  AND published=1
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-17 22:25:29' )
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-17 22:25:29' )
  AND access IN(1,1)
  AND trash=0
  ORDER BY ordering DESC
  LIMIT 0, 1
22. SELECT guest, usertype, client_id
  FROM j25_session
  WHERE client_id = 0
23. UPDATE `j25_session`
  SET `data` = '_1amJoxhctadX9tsEZh178imG9pfQ60Vr8qv2YneTLtZzQzr6wJgnhdjrNDBFoDrjJaVQ6KJSH6HL32JsrrzPRDrG25DV5p9xpTcMELRwIP-C8HYG6LjeYOSmksi9KOIm2TsSzP6KEREV-lhpCeEimzJ14JkdSpEWbicoaLDVh8iy-sxCZvDUwHtX7pGf6qEKGNv3zfZmYeQfMaLIcKSFDNSncFMr14XNnUN7d0yjAHmvVZWo2Q-7GD9_cJ65yH32ILhYUZ_yCkUmbjlCIBKG5YzpMlQw8x8U4TI01eWRTSWnAFOc1X-m6ARzDIZOfU0A-yut3BJMM1gNvVVEfXR9OLoFgnpxFnamqVZzJDtg2m8zfLKYbRy7N8SAWDY2XMaoOedpDhei5p1H5rP6pRQaFIGGpMN9ScDJHohocgoOCcEJuXrGGs-p2Eb5OUOh6utrdmcueKAe9mIwiPUGLf2qOMBqPg5gwqy9fcF1KweQ5IZQ4BjaF_f2jCGlwzmb9CWcgZD6HXMORZuA8T5yzi3jtOA-BrEdw39VVWF-7_HXElC0i3LH6vWvZiwmjrOBpPLBHlAohMLFEn6TPmUB2BM3BLsGXLZoQmoS44YpLtUb-j1K1NnZbGsMpUIvKA41NQ7bKsp3pPLPthPndIWZdGv420ITCpfY8T-a_nt_Rt7QCNl8zJMgTP4yDJfeKuSqZOTlVT4_-Zm6cFpdFdZYO2v2yCD5ziT3xoLgLSF94xgSpr246XzouCSiZea6xrujPcyRoJJyI7lF4hOQwqJibwtid165eIWINbTqJ8XnNS2j-0yAOZFfDnls4jSe5IHbTQ_fEW6tEXZQkDt0eLt9ioxYpsy3nKmJGlt-MnIZBdsANs45naUXaytMksfRs1DKRxRbKrS2B8PO9xrhCox3mGaCp7hoNc2DzoASqjBcbZnl5KZ5b2NPwB_9YmtcTEKnysxPQfNdddmJx2Ob3jKn5aubdAR2H2AjM3W1sZxZFGVUUVweu-TacA9N4ZwurZhvrakaesqz6p3ttxc2OV4w-sJDDXACz6dzoj3-ehf6f6mJI_cjhpEo2Qk_qhl9ATRWez_OlJ0arQESAJNFXvCaHxYZg2-RX9KPMTAlfU0wCaH5k04_2TDSW9nT7NhLcG1R5gyqwm_gUtfcMX8lRnbyBTuIIUwQhh0iEMmxvFSEvcz4olrtkE_EP-YPma85mH6V_PlTFdHTzfgHb_OyNi6bj6oRdcfJw3Hhw12gx9DDnTyQQig5W7qH_znY6HhgP24yXqgyUOr-IsOs0GizxeWUe3lEr-buDOiltx_mbJVZIKQGCJxXPez3KDLL26msL04jc5z4W2YH0-3OuoFu3TJKw-Xnfp5ECpwNPt30_lp9ON5XbV6id-DoiqlTv4-IHqktRu-sZJbTlkaiVx-SpKCrD-GDgRkmzNgQs5cTRrgv7qDMbGqkqeTDFCJVu-9atCArBQKFgvAafTFSsAnmCjbzPBToI2-Ten6n9-94pBz5K1YTZPg1dxhCHHHSVdTye29XZ4LsWyzyS78KIeN6kNSDrsWBhfFOR65DqtJMBNSvMEBXMq_R84EmhAF14KHruWoePrk0vnf2zLamsJCAHuR0mUwC4LblcAHfRECyoICSil-xAU.' , `time` = '1550442331'
  WHERE `session_id` = 'c5bfcc943ff0430fa985060ba85d7984'

20 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 guest, usertype, client_id
  FROM j25_session
6. 1 × SELECT COUNT(*)
  FROM j25_k2_comments
7. 1 × SELECT id
  FROM j25_k2_categories
8. 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
9. 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
10. 1 × SELECT `session_id`
  FROM `j25_session`
11. 1 × SELECT id, rules
  FROM `j25_viewlevels
12. 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
13. 1 × SELECT a.rules
  FROM j25_assets AS a
14. 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` = '_1amJoxhctadX9tsEZh178imG9pfQ60Vr8qv2YneTLtZzQzr6wJgnhdjrNDBFoDrjJaVQ6KJSH6HL32JsrrzPRDrG25DV5p9xpTcMELRwIP-C8HYG6LjeYOSmksi9KOIm2TsSzP6KEREV-lhpCeEimzJ14JkdSpEWbicoaLDVh8iy-sxCZvDUwHtX7pGf6qEKGNv3zfZmYeQfMaLIcKSFDNSncFMr14XNnUN7d0yjAHmvVZWo2Q-7GD9_cJ65yH32ILhYUZ_yCkUmbjlCIBKG5YzpMlQw8x8U4TI01eWRTSWnAFOc1X-m6ARzDIZOfU0A-yut3BJMM1gNvVVEfXR9OLoFgnpxFnamqVZzJDtg2m8zfLKYbRy7N8SAWDY2XMaoOedpDhei5p1H5rP6pRQaFIGGpMN9ScDJHohocgoOCcEJuXrGGs-p2Eb5OUOh6utrdmcueKAe9mIwiPUGLf2qOMBqPg5gwqy9fcF1KweQ5IZQ4BjaF_f2jCGlwzmb9CWcgZD6HXMORZuA8T5yzi3jtOA-BrEdw39VVWF-7_HXElC0i3LH6vWvZiwmjrOBpPLBHlAohMLFEn6TPmUB2BM3BLsGXLZoQmoS44YpLtUb-j1K1NnZbGsMpUIvKA41NQ7bKsp3pPLPthPndIWZdGv420ITCpfY8T-a_nt_Rt7QCNl8zJMgTP4yDJfeKuSqZOTlVT4_-Zm6cFpdFdZYO2v2yCD5ziT3xoLgLSF94xgSpr246XzouCSiZea6xrujPcyRoJJyI7lF4hOQwqJibwtid165eIWINbTqJ8XnNS2j-0yAOZFfDnls4jSe5IHbTQ_fEW6tEXZQkDt0eLt9ioxYpsy3nKmJGlt-MnIZBdsANs45naUXaytMksfRs1DKRxRbKrS2B8PO9xrhCox3mGaCp7hoNc2DzoASqjBcbZnl5KZ5b2NPwB_9YmtcTEKnysxPQfNdddmJx2Ob3jKn5aubdAR2H2AjM3W1sZxZFGVUUVweu-TacA9N4ZwurZhvrakaesqz6p3ttxc2OV4w-sJDDXACz6dzoj3-ehf6f6mJI_cjhpEo2Qk_qhl9ATRWez_OlJ0arQESAJNFXvCaHxYZg2-RX9KPMTAlfU0wCaH5k04_2TDSW9nT7NhLcG1R5gyqwm_gUtfcMX8lRnbyBTuIIUwQhh0iEMmxvFSEvcz4olrtkE_EP-YPma85mH6V_PlTFdHTzfgHb_OyNi6bj6oRdcfJw3Hhw12gx9DDnTyQQig5W7qH_znY6HhgP24yXqgyUOr-IsOs0GizxeWUe3lEr-buDOiltx_mbJVZIKQGCJxXPez3KDLL26msL04jc5z4W2YH0-3OuoFu3TJKw-Xnfp5ECpwNPt30_lp9ON5XbV6id-DoiqlTv4-IHqktRu-sZJbTlkaiVx-SpKCrD-GDgRkmzNgQs5cTRrgv7qDMbGqkqeTDFCJVu-9atCArBQKFgvAafTFSsAnmCjbzPBToI2-Ten6n9-94pBz5K1YTZPg1dxhCHHHSVdTye29XZ4LsWyzyS78KIeN6kNSDrsWBhfFOR65DqtJMBNSvMEBXMq_R84EmhAF14KHruWoePrk0vnf2zLamsJCAHuR0mUwC4LblcAHfRECyoICSil-xAU.' , `time` = '1550442331'
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 ('c5bfcc943ff0430fa985060ba85d7984', 0, '1550442329'
6. 1 × DELETE
  FROM `j25_session`