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