Coolpad

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.

Yulong at first was a maker of pagers and paging systems. In 2002 the company started to make mobile phones.

Coolpad is a Chinese phone brand. The company was founded in 1993.

48 phones
The first device was released in 2015
The latest device was released in 2025

All Coolpad phones

(default) 10 queries took 19 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 1111
2BEGIN000
3SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 105110
4SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 105110
5SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 105110
6UPDATE `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'111
7COMMIT000
8SELECT 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` ASC1113
9SELECT 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`48481
10SELECT `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 5048483