http://stage.neue-zeile.com/products/list?category_id=9

Method
GET
HTTP Status
200
IP
3.15.182.88
Profiled on
Token
4cd8db
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY d4_ ALL IDX_1A11D1BA4584665A 6045 Using where; Using temporary; Using filesort
1 PRIMARY d1_ ref PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 PRIMARY 4 xb235735_stageb.d4_.product_id 2 Using where
1 PRIMARY d0_ eq_ref PRIMARY, IDX_C49DE22F557B630 PRIMARY 4 xb235735_stageb.d4_.product_id 1 Using where
1 PRIMARY p3_ eq_ref PRIMARY PRIMARY 4 xb235735_stageb.d0_.schedule_time_id 1 Using where; Distinct
1 PRIMARY d2_ eq_ref PRIMARY PRIMARY 4 xb235735_stageb.d1_.category_id 1 Using where; Distinct
3 MATERIALIZED p11_ ALL PRIMARY, IDX_1B30AA8F27BFAF1B 83 Using where
3 MATERIALIZED d10_ ref PRIMARY, IDX_5ED2C2B796A8F92, IDX_5ED2C2B61220EA6, IDX_5ED2C2BD380F18A IDX_5ED2C2BD380F18A 5 xb235735_stageb.p11_.schedule_time_id 1 Using where
3 MATERIALIZED d9_ ref PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 IDX_B057789112469DE2 4 xb235735_stageb.d10_.id 106 Using where
3 MATERIALIZED d8_ eq_ref PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22FD380F18A PRIMARY 4 xb235735_stageb.d9_.product_id 1 Using where
2 MATERIALIZED p6_ ALL PRIMARY 9 Using where
2 MATERIALIZED p7_ ref PRIMARY, IDX_607C752D4584665A, IDX_607C752DFE54D947 IDX_607C752DFE54D947 4 xb235735_stageb.p6_.id 1 Using index
2 MATERIALIZED d5_ eq_ref PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22FD380F18A PRIMARY 4 xb235735_stageb.p7_.product_id 1 Using where