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_ ref IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A IDX_5ED2C2B796A8F92 5 const 2 Using index condition; Using where; Using temporary; Using filesort
1 PRIMARY d1_ ref IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A IDX_5ED2C2B796A8F92 5 xb235735_stageb.d0_.id 6 Using where
1 PRIMARY d2_ ref IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A IDX_5ED2C2B796A8F92 5 xb235735_stageb.d1_.id 6 Using where
1 PRIMARY d3_ ref IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A IDX_5ED2C2B796A8F92 5 xb235735_stageb.d2_.id 6 Using where
1 PRIMARY d4_ ref IDX_5ED2C2B796A8F92, IDX_5ED2C2BD380F18A IDX_5ED2C2B796A8F92 5 xb235735_stageb.d3_.id 6 Using where
10 DEPENDENT SUBQUERY plg_schedule_time unique_subquery PRIMARY, IDX_1B30AA8F27BFAF1B PRIMARY 4 func 1 Using where
11 DEPENDENT SUBQUERY plg_schedule_time unique_subquery PRIMARY PRIMARY 4 func 1 Using where; Full scan on NULL key
8 MATERIALIZED plg_schedule_time ALL PRIMARY, IDX_1B30AA8F27BFAF1B 83 Using where
9 MATERIALIZED plg_schedule_time ALL PRIMARY 83 Using where
6 MATERIALIZED plg_schedule_time ALL PRIMARY, IDX_1B30AA8F27BFAF1B 83 Using where
7 MATERIALIZED plg_schedule_time ALL PRIMARY 83 Using where
4 MATERIALIZED plg_schedule_time ALL PRIMARY, IDX_1B30AA8F27BFAF1B 83 Using where
5 MATERIALIZED plg_schedule_time ALL PRIMARY 83 Using where
2 MATERIALIZED plg_schedule_time ALL PRIMARY, IDX_1B30AA8F27BFAF1B 83 Using where
3 MATERIALIZED plg_schedule_time ALL PRIMARY 83 Using where