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` = 'coolpad') 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` = 105 | | 1 | 1 | 0 |
4 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 105 | | 1 | 1 | 0 |
5 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 105 | | 1 | 1 | 0 |
6 | UPDATE `gsmfind`.`gsm_brands` SET `id` = 105, `country_id` = 'CN', `name` = 'Coolpad', `slug` = 'coolpad', `logo` = 'coolpad.png', `intro` = '<p>Coolpad Group Limited formerly known as China Wireless Technologies Limited is a Caymans-incorporated holding company. Its major subsidiary Yulong Computer Telecommunication Scientific (Shenzhen) Co., Ltd., is a Chinese telecommunications equipment company headquartered in Shenzhen, Guangdong. It was a large smartphone company in China (as of 2012) and the largest Chinese domestic brand by sales outside of China (as of 2014). From January to June 2012, the company had a market share of shipments of 10.4% phones of China.</p><p>Yulong at first was a maker of pagers and paging systems. In 2002 the company started to make mobile phones.<br></p>', `count` = 48, `device_first` = '2015', `device_last` = '2025', `website` = 'http://www.coolpad.com/', `device_types` = 'phone', `publish` = '1', `hits` = 65677, `weight` = 31.0, `s_link` = 'coolpad-phones-105.php', `start_date` = '1993', `end_date` = '', `created` = '2020-05-27 14:03:02', `modified` = '2024-08-29 03:21:49' WHERE `gsmfind`.`gsm_brands`.`id` = '105' | | 1 | 1 | 1 |
7 | COMMIT | | 0 | 0 | 0 |
8 | SELECT DISTINCT `Phone`.`type` FROM `gsmfind`.`gsm_phones` AS `Phone` LEFT JOIN `gsmfind`.`gsm_brands` AS `Brand` ON (`Phone`.`brand_id` = `Brand`.`id`) WHERE ((`Phone`.`brand_id` = 105) AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` ORDER BY `Phone`.`type` ASC | | 1 | 1 | 13 |
9 | 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` = 105) AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` | | 48 | 48 | 1 |
10 | 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` = 105) AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` ORDER BY `Phone`.`f_date_order` DESC, `Phone`.`id` DESC LIMIT 50 | | 48 | 48 | 3 |