www.cabello.ws / localhost / sys / x$statements_with_full_table_scans

There are no favorite tables.

New
aaa
- aaa
- aaa_fabricas_pruebas
abanq
- abanq_23
- abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
- azulejoscabello.com
- azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabello-enterprises
- cabello-enterprises
- cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
- php_producto
- php_producto_prueba
sys
tutorial
wordpress
- wordpress
- wordpress_desarrollo

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - ...

(Query took 0.0492 seconds.)

SELECT * FROM `x$statements_with_full_table_scans`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

query	db	exec_count	total_latency	no_index_used_count	no_good_index_used_count	no_index_used_pct	rows_sent	rows_examined	rows_sent_avg	rows_examined_avg	first_seen	last_seen	digest
SELECT `option_name` , `option_value` FROM `wp_opt...	wordpress	57332	109802627200000	57335	0	100	20781767	31685341	362	553	2026-07-16 12:45:23.829170	2026-08-06 18:30:51.286342	9d6bc3eeb0fcc3056d334a21622aee821aba1ca4e515e9fc7e...
SELECT `option_name` , `option_value` FROM `wp_opt...	wordpress_desarrollo	42275	80244751300000	42276	0	100	15274255	23354097	361	552	2026-07-16 13:02:35.273166	2026-08-06 18:32:09.751860	9d6bc3eeb0fcc3056d334a21622aee821aba1ca4e515e9fc7e...
SELECT * FROM `wp_woof_sd` ORDER BY `title` ASC	wordpress	51416	9581074700000	51416	0	100	0	0	0	0	2026-07-16 13:32:50.670365	2026-08-06 18:30:52.342496	b68a124dc0314a160cc2d907a95f55cd2969e648ba588cea4a...
UPDATE `wp_actionscheduler_actions` `t1` JOIN ( SE...	wordpress_desarrollo	8337	6665541800000	8337	0	100	0	1419	0	0	2026-07-16 13:06:00.593070	2026-08-06 18:32:09.743971	4dc47199554a59d8ba457c1dcf1e47f18610b9970a435d8cb0...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	eneboo	2769	6560241400000	2769	0	100	116298	551031	42	199	2026-08-06 06:26:35.159596	2026-08-06 18:33:14.705458	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT * FROM `wp_woof_sd` ORDER BY `title` ASC	wordpress_desarrollo	33236	6231163900000	33236	0	100	0	0	0	0	2026-07-16 13:32:53.918754	2026-08-06 18:32:09.234773	b68a124dc0314a160cc2d907a95f55cd2969e648ba588cea4a...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	cabello-enterprises	2542	6046238300000	2542	0	100	106764	505858	42	199	2026-08-06 06:26:49.965851	2026-08-06 18:33:25.496827	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	cabello-enterprises_exp	2458	5833025400000	2458	0	100	103236	489142	42	199	2026-08-06 06:26:21.627973	2026-08-06 18:33:22.367859	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	NULL	1863	4523931800000	1863	0	100	78240	370713	42	199	2026-07-16 12:46:00.686574	2026-08-06 18:33:23.786379	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
UPDATE `wp_actionscheduler_actions` `t1` JOIN ( SE...	wordpress	5351	4266648300000	5351	0	100	0	1227	0	0	2026-07-16 13:05:50.716179	2026-08-06 11:31:57.195106	4dc47199554a59d8ba457c1dcf1e47f18610b9970a435d8cb0...
SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS...	eneboo	5538	4245222400000	5538	0	100	5538	166140	1	30	2026-08-06 06:26:35.164194	2026-08-06 18:33:14.713169	5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33...
SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS...	cabello-enterprises	5084	3890167500000	5084	0	100	5084	152520	1	30	2026-08-06 06:26:49.972598	2026-08-06 18:33:25.504753	5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33...
SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS...	cabello-enterprises_exp	4916	3763468500000	4916	0	100	4916	147480	1	30	2026-08-06 06:26:21.633990	2026-08-06 18:33:22.376695	5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	abanq_23 experimental	1491	3549007200000	1491	0	100	62622	296709	42	199	2026-08-06 06:26:40.908927	2026-08-06 18:33:16.720451	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	cabecab4_abanq230	1497	3540168900000	1497	0	100	62874	297903	42	199	2026-08-06 06:26:38.171004	2026-08-06 18:33:11.722409	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	abanq_23	1464	3497073600000	1464	0	100	61488	291336	42	199	2026-08-06 06:26:44.078335	2026-08-06 18:33:17.083573	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	cabecab4_abanq	1449	3442531800000	1449	0	100	60858	288351	42	199	2026-08-06 06:26:43.763623	2026-08-06 18:33:18.950313	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	cabecab4_abanq240	1377	3272297900000	1377	0	100	57834	274023	42	199	2026-08-06 06:26:29.899180	2026-08-06 17:39:11.748156	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS...	NULL	3704	2841269100000	3704	0	100	3704	111118	1	30	2026-07-16 12:46:00.694797	2026-08-06 18:33:23.793949	5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33...
SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR...	eneboo	2769	2742976700000	2769	0	100	2769	33228	1	12	2026-08-06 06:26:35.134303	2026-08-06 18:33:14.671331	e8b67e76bb58f62c704e6904b349719537675fef0a968c067b...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	azulejoscabello.com_tienda	1073	2551633700000	1073	0	100	45066	213527	42	199	2026-08-06 06:26:48.325423	2026-08-06 18:33:06.057692	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...
SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR...	cabello-enterprises	2542	2445948300000	2542	0	100	2542	20336	1	8	2026-08-06 06:26:49.923550	2026-08-06 18:33:25.475809	e8b67e76bb58f62c704e6904b349719537675fef0a968c067b...
SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR...	cabello-enterprises_exp	2458	2378547400000	2458	0	100	2458	22122	1	9	2026-08-06 06:26:21.602939	2026-08-06 18:33:22.345277	e8b67e76bb58f62c704e6904b349719537675fef0a968c067b...
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	eneboo	2427	2373931900000	2427	0	100	2427	4854	1	2	2026-08-06 06:26:35.232648	2026-08-06 18:33:14.769056	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS...	abanq_23 experimental	2982	2291703200000	2982	0	100	2982	89460	1	30	2026-08-06 06:26:40.913581	2026-08-06 18:33:16.728024	5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view