| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Location`.`id`, `Location`.`name` FROM `nyc_business`.`locations` AS `Location` WHERE `Location`.`name` like 'P%' ORDER BY `Location`.`name` ASC LIMIT 100, 100 | 34 | 34 | 2 | |
| 2 | SELECT COUNT(*) AS `count` FROM `nyc_business`.`locations` AS `Location` WHERE `Location`.`name` like 'P%' | 1 | 1 | 0 |