Back

SQL Explained

Executed SQL
EXPLAIN SELECT ••• `evaluation_evaluationresults`.`id`, `evaluation_evaluationresults`.`date_created`, `evaluation_evaluationresults`.`evaluation_id`, `evaluation_evaluationresults`.`gt_unit`, `evaluation_evaluationresults`.`found_unit`, `evaluation_evaluationresults`.`KS`, `evaluation_evaluationresults`.`KSO`, `evaluation_evaluationresults`.`FS`, `evaluation_evaluationresults`.`TP`, `evaluation_evaluationresults`.`TPO`, `evaluation_evaluationresults`.`FPA`, `evaluation_evaluationresults`.`FPAE`, `evaluation_evaluationresults`.`FPAO`, `evaluation_evaluationresults`.`FPAOE`, `evaluation_evaluationresults`.`FN`, `evaluation_evaluationresults`.`FNO`, `evaluation_evaluationresults`.`FP` FROM `evaluation_evaluationresults` WHERE `evaluation_evaluationresults`.`evaluation_id` = 78 ORDER BY `evaluation_evaluationresults`.`gt_unit` ASC
Time
0.29 ms
Database
default
ID SELECT_TYPE TABLE TYPE POSSIBLE_KEYS KEY KEY_LEN REF ROWS EXTRA
1 SIMPLE evaluation_evaluationresults ref evaluation_evaluationresults_78c7dc5c evaluation_evaluationresults_78c7dc5c 4 const 2 Using where; Using filesort