| 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` = 'oscal') 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` = 134 | | 1 | 1 | 0 |
| 4 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 134 | | 1 | 1 | 0 |
| 5 | SELECT COUNT(*) AS `count` FROM `gsmfind`.`gsm_brands` AS `Brand` WHERE `Brand`.`id` = 134 | | 1 | 1 | 0 |
| 6 | UPDATE `gsmfind`.`gsm_brands` SET `id` = 134, `country_id` = 'CN', `name` = 'Oscal', `slug` = 'oscal', `logo` = 'oscal.png', `intro` = '<p>Oscal is a technology brand established in 2021 in China. The company focuses on producing a variety of electronic devices, including smartphones, tablets, smartwatches, and other consumer electronics. Oscal aims to provide high-quality, affordable products that cater to budget-conscious consumers while delivering a reliable user experience. The brand\'s strength lies in its commitment to innovation, quality control, and customer satisfaction, ensuring that even entry-level products offer great value for money. Oscal\'s motto is \"Be Cool, Be Yourself,\" emphasizing its dedication to providing trendy and dependable devices that resonate with a youthful and dynamic audience.</p>', `count` = 5, `device_first` = '2025', `device_last` = '2025', `website` = 'https://www.oscal.hk/', `device_types` = 'phone and tablet', `publish` = '1', `hits` = 19618, `weight` = 80.0, `s_link` = 'oscal-phones-134.php', `start_date` = '2021', `end_date` = '', `created` = '2024-08-28 21:25:12', `modified` = '2024-08-29 03:21:49' WHERE `gsmfind`.`gsm_brands`.`id` = '134' | | 1 | 1 | 0 |
| 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` = 134) AND (`Phone`.`type` = 'phone') AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` | | 4 | 4 | 1 |
| 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` = 134) AND (`Phone`.`type` = 'phone') AND (`Phone`.`last_get` IS NOT NULL)) GROUP BY `Phone`.`id` ORDER BY ISNULL(`Phone`.`f_volume`) ASC, `Phone`.`f_volume` ASC LIMIT 50 | | 4 | 4 | 1 |
