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

Method
GET
HTTP Status
200
IP
52.15.150.138
Profiled on
Token
9d5696
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY d2_ const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort
1 PRIMARY d1_ ref PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 IDX_B057789112469DE2 4 const 74 Using where
1 PRIMARY d0_ eq_ref PRIMARY, IDX_C49DE22F557B630 PRIMARY 4 xb235735_stageb.d1_.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 d4_ ref IDX_1A11D1BA4584665A IDX_1A11D1BA4584665A 5 xb235735_stageb.d1_.product_id 1 Using where; Distinct
3 DEPENDENT SUBQUERY d8_ eq_ref PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630, IDX_C49DE22FD380F18A PRIMARY 4 func 1 Using where
3 DEPENDENT SUBQUERY d9_ ref PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 PRIMARY 4 xb235735_stageb.d8_.id 2 Using where
3 DEPENDENT SUBQUERY d10_ eq_ref PRIMARY, IDX_5ED2C2B796A8F92, IDX_5ED2C2B61220EA6, IDX_5ED2C2BD380F18A PRIMARY 4 xb235735_stageb.d9_.category_id 1 Using where
3 DEPENDENT SUBQUERY p11_ eq_ref PRIMARY, IDX_1B30AA8F27BFAF1B PRIMARY 4 xb235735_stageb.d10_.schedule_time_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