Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `nu0qz_assets`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id
Primary Key
parent_id
Nested set parent.
lft
Nested set lft.
rgt
Nested set rgt.
level
The cached level in the nested tree.
name
The unique name for the asset.
title
The descriptive title for the asset.
rules
JSON encoded access control.
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 1
1 0 0 327 0 root.1 Root Asset {"core.login.site":{"6":1,"2":1},"core.login.admin...
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 2
2 1 1 2 1 com_admin com_admin {}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 3
3 1 3 6 1 com_banners com_banners {"core.admin":{"7":1},"core.manage":{"6":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 4
4 1 7 8 1 com_cache com_cache {"core.admin":{"7":1},"core.manage":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 5
5 1 9 10 1 com_checkin com_checkin {"core.admin":{"7":1},"core.manage":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 6
6 1 11 12 1 com_config com_config {}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 7
7 1 13 16 1 com_contact com_contact {"core.admin":{"7":1},"core.manage":{"6":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 8
8 1 17 166 1 com_content com_content {"core.admin":{"7":1},"core.manage":{"6":1},"core....
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 9
9 1 167 168 1 com_cpanel com_cpanel {}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 10
10 1 169 170 1 com_installer com_installer {"core.manage":{"7":0},"core.delete":{"7":0},"core...
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 11
11 1 171 174 1 com_languages com_languages {"core.admin":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 12
12 1 175 176 1 com_login com_login {}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 13
13 1 177 178 1 com_mailto com_mailto {}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 14
14 1 179 180 1 com_massmail com_massmail {}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 15
15 1 181 182 1 com_media com_media {"core.admin":{"7":1},"core.manage":{"6":1},"core....
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 16
16 1 183 190 1 com_menus com_menus {"core.admin":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 17
17 1 191 192 1 com_messages com_messages {"core.admin":{"7":1},"core.manage":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 18
18 1 193 264 1 com_modules com_modules {"core.admin":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 19
19 1 265 268 1 com_newsfeeds com_newsfeeds {"core.admin":{"7":1},"core.manage":{"6":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 20
20 1 269 270 1 com_plugins com_plugins {"core.admin":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 21
21 1 271 272 1 com_redirect com_redirect {"core.admin":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 22
22 1 273 274 1 com_search com_search {"core.admin":{"7":1},"core.manage":{"6":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 23
23 1 275 276 1 com_templates com_templates {"core.admin":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 24
24 1 277 280 1 com_users com_users {"core.admin":{"7":1}}
Edit Edit Copy Copy Delete Delete
DELETE FROM nu0qz_assets WHERE `nu0qz_assets`.`id` = 26
26 1 281 282 1 com_wrapper com_wrapper {}
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view