Thank You, Peter , Please see below:-
-> Nested loop inner join (cost=25852.53 rows=258437) (actual time=538.528..538.546 rows=3 loops=1)
-> Filter: (MP.product_id in ('15298','15300','15296')) (cost=1.36 rows=3) (actual time=0.021..0.031 rows=3 loops=1)
-> Index range scan on MP using PRIMARY (cost=1.36 rows=3) (actual time=0.020..0.028 rows=3 loops=1)
-> Index lookup on A using <auto_key0> (colorway_no=MP.colorway_no) (actual time=0.003..0.004 rows=1 loops=3)
-> Materialize (cost=83682.24..83682.24 rows=86146) (actual time=538.510..538.511 rows=61292 loops=1)
-> Group aggregate: group_concat(cm.col_name order by cw.col_no ASC separator '/') (cost=75067.69 rows=86146) (actual time=37.580..415.948 rows=61292 loops=1)
-> Nested loop inner join (cost=66453.13 rows=86146) (actual time=37.554..366.858 rows=94058 loops=1)
-> Nested loop inner join (cost=36302.19 rows=86146) (actual time=37.545..256.703 rows=94081 loops=1)
-> Sort: ch.colorway_id, ch.colorway_no (cost=6151.25 rows=60950) (actual time=37.516..42.369 rows=61329 loops=1)
-> Index scan on ch using colorway_no_UNIQUE (actual time=0.012..12.728 rows=61329 loops=1)
-> Index lookup on cw using colorway_id (colorway_h_id=ch.colorway_id) (cost=0.35 rows=1) (actual time=0.003..0.003 rows=2 loops=61329)
-> Single-row index lookup on cm using PRIMARY (col_id=cw.col_id) (cost=0.25 rows=1) (actual time=0.001..0.001 rows=1 loops=94081)