http://stage.neue-zeile.com/block/search_product

Method
GET
HTTP Status
200
IP
139.162.96.14
Profiled on
Token
e932e1
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY d0_ const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort
1 PRIMARY d1_ ALL IDX_35DCD7318C22AA1A 44 Using where
1 PRIMARY d2_ eq_ref PRIMARY, IDX_6B54DCBDD380F18A PRIMARY 4 xb235735_stageb.d1_.block_id 1 Using where
5 DEPENDENT SUBQUERY plg_schedule_time unique_subquery PRIMARY, IDX_1B30AA8F27BFAF1B PRIMARY 4 func 1 Using where
6 DEPENDENT SUBQUERY plg_schedule_time unique_subquery PRIMARY PRIMARY 4 func 1 Using where; Full scan on NULL key
2 MATERIALIZED dtb_block index PRIMARY, IDX_6B54DCBDD380F18A IDX_6B54DCBDD380F18A 5 30 Using where; Using index
3 MATERIALIZED plg_schedule_time ALL PRIMARY, IDX_1B30AA8F27BFAF1B 83 Using where
4 MATERIALIZED plg_schedule_time ALL PRIMARY 83 Using where