| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | s1_ | ref | product_taxon_idx, IDX_169C6CD94584665A, IDX_169C6CD9DE13F470 | IDX_169C6CD9DE13F470 | 4 | const | 1 | 100.00 | Using index condition; Using filesort | |
| 1 | PRIMARY | s0_ | eq_ref | PRIMARY | PRIMARY | 4 | tca_dev.s1_.product_id | 1 | 9.00 | Using where | |
| 2 | DEPENDENT SUBQUERY | s3_ | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index | |
| 2 | DEPENDENT SUBQUERY | s2_ | eq_ref | PRIMARY, IDX_F9EF269B4584665A, IDX_F9EF269B72F5A1AA | PRIMARY | 8 | tca_dev.s0_.id, const | 1 | 100.00 | Using index |