| 1 | SELECT `Brand`.`id`, `Brand`.`country_id`, `Brand`.`name`, `Brand`.`slug`, `Brand`.`logo`, `Brand`.`intro`, `Brand`.`count`, `Brand`.`device_first`, `Brand`.`device_last`, `Brand`.`website`, `Brand`.`device_types`, `Brand`.`publish`, `Brand`.`hits`, `Brand`.`weight`, `Brand`.`s_link`, `Brand`.`start_date`, `Brand`.`end_date`, `Brand`.`created`, `Brand`.`modified`, `Country`.`id`, `Country`.`code_3`, `Country`.`code_m49`, `Country`.`name`, `Country`.`slug`, `Country`.`adjective`, `Country`.`continent_name`, `Country`.`continent_code` FROM `gsmfind`.`gsm_brands` AS `Brand` LEFT JOIN `gsmfind`.`gsm_countries` AS `Country` ON (`Brand`.`country_id` = `Country`.`id`) WHERE ((`Brand`.`slug` = 'sony-ericsson') AND (`Brand`.`publish` = '1')) LIMIT 1 | | 1 | 1 | 1 |
| 2 | BEGIN | | 0 | 0 | 0 |
| 3 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 19 | | 1 | 1 | 0 |
| 4 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 19 | | 1 | 1 | 0 |
| 5 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 19 | | 1 | 1 | 0 |
| 6 | UPDATE `gsmfind`.`gsm_brands` SET `id` = 19, `country_id` = 'JP', `name` = 'Sony Ericsson', `slug` = 'sony-ericsson', `logo` = 'sony-ericsson.png', `intro` = '<p>Sony Ericsson Mobile Communications AB is a mobile phone manufacturer. The company is a joint venture that was established in 2001 by Japanese consumer electronics company Sony and the Swedish telecommunications company Ericsson. The two companies no longer make mobile phones independently.<br></p>', `count` = 188, `device_first` = '2002', `device_last` = '2011', `website` = '', `device_types` = 'phone', `publish` = '1', `hits` = 231267, `weight` = 100.0, `s_link` = 'sony_ericsson-phones-19.php', `start_date` = '2001', `end_date` = '2012', `created` = '2020-05-27 14:03:02', `modified` = '2024-08-29 03:21:49' WHERE `gsmfind`.`gsm_brands`.`id` = '19' | | 1 | 1 | 1 |
| 7 | COMMIT | | 0 | 0 | 0 |
| 8 | 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` = 19) AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` | | 188 | 188 | 2 |
| 9 | 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` = 19) AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` ORDER BY `Phone`.`f_date_order` DESC, `Phone`.`id` DESC LIMIT 50 | | 50 | 50 | 2 |
