query_block
Query cost: 116.04
ORDER
sto
PRIMARY
Full Index Scan
0.45
2 rows
adr
PRIMARY
Unique Key Lookup
1.6
1 row
cit
PRIMARY
Unique Key Lookup
0.7
1 row
cou
PRIMARY
Unique Key Lookup
0.7
1 row
GROUP
cus
idx_fk_store_id
Full Index Scan
61.15
599 rows
pay
idx_fk_customer_id
Non-Unique Key Lookup
5630.1
26 rows
nested
loop
5691.25
16.09K rows
B (materialised)
<auto_key0>
Non-Unique Key Lookup
112.59
160 rows
nested
loop
2.05
2 rows
nested
loop
2.75
2 rows
nested
loop
3.45
2 rows
nested
loop
116.05
321 rows
Tooltip