Explain Query (mysql)
EXPLAIN SELECT `dropinstance`.`drop_instance_id` AS `t1_c0`, `dropinstance`.`droppoint_id` AS `t1_c1`, `dropinstance`.`delivery_day` AS `t1_c2`, `dropinstance`.`delivery_order` AS `t1_c3`, `dropinstance`.`warehouse_id` AS `t1_c4`, `dropinstance`.`route_id` AS `t1_c5`, `dropinstance`.`type` AS `t1_c6`, `dropinstance`.`capacity` AS `t1_c7`, `dropinstance`.`take_rate` AS `t1_c8`, `dropinstance`.`take_rate_capacity` AS `t1_c9`, `dropinstance`.`start_date` AS `t1_c10`, `dropinstance`.`opening_time` AS `t1_c11`, `dropinstance`.`closing_time` AS `t1_c12`, `dropinstance`.`euf_notes` AS `t1_c13`, `dropinstance`.`active` AS `t1_c14`, `dropinstance`.`business_opening_time` AS `t1_c15`, `dropinstance`.`business_closing_time` AS `t1_c16`, `dropinstance`.`ignore_ww` AS `t1_c17`, `dropinstance`.`temporary_pup_transfer` AS `t1_c18` FROM `drop_instance` `dropinstance` WHERE (dropinstance.type IN (1,3) AND dropinstance.active = 1 AND dropinstance.capacity > 0) AND (`dropinstance`.`droppoint_id`='1810')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | dropinstance | ref | unique_drop_instance, droppoint_id | unique_drop_instance | 4 | const | 7 | 0.71 | Using index condition; Using where |