Explain Query (mysql)
EXPLAIN SELECT `orderdetails`.`order_details_id` AS `t1_c0`, `orderdetails`.`order_id` AS `t1_c1`, `orderdetails`.`status` AS `t1_c2`, `orderdetails`.`product_id` AS `t1_c3`, `orderdetails`.`qa_qty` AS `t1_c4`, `orderdetails`.`refunded_qty` AS `t1_c5`, `orderdetails`.`refunded_reason` AS `t1_c6`, `orderdetails`.`substituted_product_id` AS `t1_c7`, `orderdetails`.`product_details` AS `t1_c8`, `orderdetails`.`default_retail_price_per_unit` AS `t1_c9`, `orderdetails`.`default_weight_per_unit` AS `t1_c10`, `orderdetails`.`defined_retail_price_per_unit_for_default_weight` AS `t1_c11`, `orderdetails`.`paid_price_per_unit_for_default_weight` AS `t1_c12`, `orderdetails`.`national_tax_amount_per_unit_for_default_weight` AS `t1_c13`, `orderdetails`.`provincial_tax_amount_per_unit_for_default_weight` AS `t1_c14`, `orderdetails`.`purchase_price_per_unit` AS `t1_c15`, `orderdetails`.`real_weight` AS `t1_c16`, `orderdetails`.`refund_comment` AS `t1_c17`, `orderdetails`.`paid_price_for_real_weight` AS `t1_c18`, `orderdetails`.`national_tax_amount_for_real_weight` AS `t1_c19`, `orderdetails`.`provincial_tax_amount_for_real_weight` AS `t1_c20`, `orderdetails`.`picked_from_lot_id` AS `t1_c21`, `orderdetails`.`recipe_id` AS `t1_c22`, `orderdetails`.`consigne_amount` AS `t1_c23`, `orderdetails`.`temp_bundle_id` AS `t1_c24`, `orderdetails`.`refund_attachment` AS `t1_c25`, `orderdetails`.`mp_ai_kitchen_id` AS `t1_c26` FROM `order_details` `orderdetails` WHERE (`orderdetails`.`order_id`='22098898')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | orderdetails | ref | idx_order_id | idx_order_id | 4 | const | 6 | 100.00 |