Yii Debugger
1.1.25
PHP 8.0.30
Status 200
Action SuperMarketController::actionGetNoteboxData()
Log 64
Time 290 ms
Memory 3.4 MB
DB 37 175 ms

Explain Query (mysql)

EXPLAIN SELECT `dropinstances`.`drop_instance_id` AS `t1_c0`, `dropinstances`.`droppoint_id` AS `t1_c1`, `dropinstances`.`delivery_day` AS `t1_c2`, `dropinstances`.`delivery_order` AS `t1_c3`, `dropinstances`.`warehouse_id` AS `t1_c4`, `dropinstances`.`route_id` AS `t1_c5`, `dropinstances`.`type` AS `t1_c6`, `dropinstances`.`capacity` AS `t1_c7`, `dropinstances`.`take_rate` AS `t1_c8`, `dropinstances`.`take_rate_capacity` AS `t1_c9`, `dropinstances`.`start_date` AS `t1_c10`, `dropinstances`.`opening_time` AS `t1_c11`, `dropinstances`.`closing_time` AS `t1_c12`, `dropinstances`.`euf_notes` AS `t1_c13`, `dropinstances`.`active` AS `t1_c14`, `dropinstances`.`business_opening_time` AS `t1_c15`, `dropinstances`.`business_closing_time` AS `t1_c16`, `dropinstances`.`ignore_ww` AS `t1_c17`, `dropinstances`.`temporary_pup_transfer` AS `t1_c18` FROM `drop_instance` `dropinstances` WHERE (`dropinstances`.`drop_instance_id`='3292')
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE dropinstances const PRIMARY PRIMARY 4 const 1 100.00