https://dev.kmj-tv.jp/products/list?name=%E4%B8%AD%E7%B4%9A%E7%B7%A8

Method
GET
HTTP Status
200
IP
18.117.137.136
Profiled on
Token
2bd116
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY d0_ ref PRIMARY, IDX_C49DE22F557B630 IDX_C49DE22F557B630 3 const 5 Using index condition; Using where
1 PRIMARY d1_ ref PRIMARY, IDX_B05778914584665A PRIMARY 4 mahjontv1326_dev.d0_.id 1 Using where
3 MATERIALIZED p6_ index PRIMARY, IDX_607C752D4584665A, IDX_607C752DFE54D947 PRIMARY 8 1 Using index
3 MATERIALIZED p5_ eq_ref PRIMARY PRIMARY 4 mahjontv1326_dev.p6_.group_id 1 Using where
3 MATERIALIZED d4_ eq_ref PRIMARY, IDX_C49DE22F61220EA6, IDX_C49DE22F557B630 PRIMARY 4 mahjontv1326_dev.p6_.product_id 1 Using where
2 DEPENDENT SUBQUERY d3_ index_subquery IDX_1A11D1BA4584665A IDX_1A11D1BA4584665A 5 func 1 Using where