Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `Phone`.`f_cpucore`, `Phone`.`id`, `Phone`.`fullname`, `Phone`.`slug`, `Phone`.`desc`, `Phone`.`status`, `Phone`.`image` FROM `gsmfind`.`gsm_phones` AS `Phone` LEFT JOIN `gsmfind`.`gsm_brands` AS `Brand` ON (`Phone`.`brand_id` = `Brand`.`id`) LEFT JOIN `gsmfind`.`gsm_phones_terms` AS `PhonesTerm6` ON (`Phone`.`id` = `PhonesTerm6`.`phone_id`) LEFT JOIN `gsmfind`.`gsm_terms` AS `Term` ON (`Term`.`id` = `PhonesTerm6`.`term_id`) WHERE ((`Phone`.`type` = 'phone') AND (`PhonesTerm6`.`term_id` <> 108) AND (`Term`.`type` = 'OS') AND (`Phone`.`last_get` IS NOT NULL) AND (`Phone`.`f_cpucore` IS NOT NULL AND `Phone`.`f_cpucore` > 0)) GROUP BY `Phone`.`id` ORDER BY `Phone`.`f_cpucore` DESC, `Phone`.`f_date_order` DESC, `Phone`.`hl_hits` DESC LIMIT 10 | 10 | 10 | 512 |