Phone Finder
Sharing is happiness:
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_phones` AS `Phone` LEFT JOIN `gsmfind`.`gsm_brands` AS `Brand` ON (`Phone`.`brand_id` = `Brand`.`id`) WHERE ((`Phone`.`brand_id` IN (93)) AND (`Phone`.`type` = 'phone') AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` | 15 | 15 | 9 | |
| 2 | SELECT `Phone`.`id`, `Phone`.`shortname`, `Phone`.`fullname`, `Phone`.`slug`, `Phone`.`desc`, `Phone`.`type`, `Phone`.`status`, `Phone`.`image`, `Phone`.`modified` FROM `gsmfind`.`gsm_phones` AS `Phone` LEFT JOIN `gsmfind`.`gsm_brands` AS `Brand` ON (`Phone`.`brand_id` = `Brand`.`id`) WHERE ((`Phone`.`brand_id` IN (93)) AND (`Phone`.`type` = 'phone') AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` ORDER BY `Phone`.`f_date_order` DESC, `Phone`.`id` DESC LIMIT 50 | 15 | 15 | 1 |