https://ec-cube.trial.jp/products/list?category_id=6&pageno=

id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE d0_ const PRIMARY, IDX_C49DE22F557B630 PRIMARY 4 const 1 100.00
1 SIMPLE d2_ const PRIMARY, IDX_B05778914584665A, IDX_B057789112469DE2 PRIMARY 8 const, const 1 100.00
1 SIMPLE d3_ const PRIMARY PRIMARY 4 const 1 100.00
1 SIMPLE d1_ ref IDX_1A11D1BA4584665A IDX_1A11D1BA4584665A 5 const 1 9.09 Using index condition; Using where