Tingyi (Master Kong) Achieves 36% Cost Reduction with CDP's HR SSC Digital Transformation
By implementing standardized processes and automation tools, this retail leader optimized supply chain management, setting an industry benchmark for operational efficiency.
SHOW FULL COLUMNS FROM `cdp_website` [ RunTime:0.000498s ]
SELECT `id`,`domain`,`seller_id`,`parent_id`,`status` FROM `cdp_website` WHERE `domain` = 'www.cdpgroupltd.com' LIMIT 1 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `cdp_plugin` [ RunTime:0.000446s ]
SELECT * FROM `cdp_plugin` WHERE `name` = 'api' LIMIT 1 [ RunTime:0.000279s ]
SELECT * FROM `cdp_plugin` WHERE `name` = 'assets' LIMIT 1 [ RunTime:0.000243s ]
SELECT * FROM `cdp_plugin` WHERE `name` = 'user' LIMIT 1 [ RunTime:0.000238s ]
SELECT `id`,`domain`,`seller_id`,`parent_id`,`status` FROM `cdp_website` WHERE `domain` = 'www.cdpgroupltd.com' LIMIT 1 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `cdp_theme` [ RunTime:0.000485s ]
SELECT * FROM `cdp_theme` WHERE `seller_id` = 1 AND `website_id` = 1 AND `lang` = 'en' AND `is_active` = 1 LIMIT 1 [ RunTime:0.000290s ]
SELECT * FROM `cdp_theme` WHERE `seller_id` = 1 AND `website_id` = 1 AND `lang` = 'en' AND `is_active` = 1 LIMIT 1 [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `cdp_visit_log` [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `cdp_category` [ RunTime:0.000617s ]
SELECT * FROM `cdp_category` WHERE `id` = 88 AND `seller_id` = 1 AND `website_id` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `cdp_attachment` [ RunTime:0.000524s ]
SELECT `id`,`name`,`url`,`type` FROM `cdp_attachment` WHERE `id` IS NULL [ RunTime:0.000228s ]
SELECT `id`,`name`,`url`,`type` FROM `cdp_attachment` WHERE `id` IS NULL [ RunTime:0.000213s ]
SELECT `id`,`url`,`name` FROM `cdp_attachment` WHERE `id` = 0 [ RunTime:0.000214s ]
SELECT `id`,`url`,`name` FROM `cdp_attachment` WHERE `id` = 0 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `cdp_sys_setting` [ RunTime:0.000443s ]
SELECT `value` FROM `cdp_sys_setting` WHERE `group` = 'company' AND `title` = 'huocms_powerby' LIMIT 1 [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `cdp_module` [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `cdp_article` [ RunTime:0.000483s ]
SHOW FULL COLUMNS FROM `cdp_category_sub_content` [ RunTime:0.000376s ]
SELECT * FROM `cdp_category_sub_content` WHERE `category_id` = 245 AND `seller_id` = 1 [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `cdp_sub_content` [ RunTime:0.000502s ]
SELECT `id`,`title`,`sub_title`,`description`,`thumbnail`,`cover`,`seller_id`,`category_id` FROM `cdp_sub_content` WHERE `seller_id` = 1 AND `status` = 1 AND `check_status` = 3 AND `is_del` = 1 AND `is_top` = 2 AND `id` IN (527,528) AND `publish_time` <= '2025-06-16 17:27:11' ORDER BY `sort` ASC,`is_top` ASC,`top_time` DESC,`id` DESC LIMIT 3 [ RunTime:0.000375s ]
SELECT `id`,`title`,`module_id` FROM `cdp_category` WHERE `id` = 245 [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `cdp_tag_sub_content` [ RunTime:0.000367s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '527' AND `b`.`is_del` = '1' [ RunTime:0.000344s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '528' AND `b`.`is_del` = '1' [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `cdp_nav` [ RunTime:0.000533s ]
SELECT * FROM `cdp_category` WHERE `id` = 271 AND `seller_id` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000449s ]
SELECT * FROM `cdp_module` WHERE `id` = 9 [ RunTime:0.000242s ]
SHOW FULL COLUMNS FROM `cdp_module_field` [ RunTime:0.000454s ]
SELECT * FROM `cdp_module_field` WHERE `module_id` = 9 [ RunTime:0.000270s ]
SELECT * FROM `cdp_category` WHERE `website_id` = 1 AND `lang` = 'en' AND `path` LIKE '0-69-271-%' ORDER BY `id` DESC [ RunTime:0.000751s ]
SHOW FULL COLUMNS FROM `cdp_top_article` [ RunTime:0.000494s ]
SELECT * FROM `cdp_category_sub_content` WHERE `category_id` = 271 AND `seller_id` = 1 [ RunTime:0.000399s ]
SELECT COUNT(*) AS think_count FROM `cdp_sub_content` WHERE `seller_id` = 1 AND `status` = 1 AND `check_status` = 3 AND `is_del` = 1 AND `is_top` = 2 AND `id` = 562 AND `publish_time` <= '2025-06-16 17:27:11' LIMIT 1 [ RunTime:0.000269s ]
SELECT * FROM `cdp_sub_content` WHERE `seller_id` = 1 AND `status` = 1 AND `check_status` = 3 AND `is_del` = 1 AND `is_top` = 2 AND `id` = 562 AND `publish_time` <= '2025-06-16 17:27:11' ORDER BY `sort` DESC,`publish_time` DESC,`is_top` ASC,`top_time` DESC,`id` DESC LIMIT 0,1 [ RunTime:0.000368s ]
SELECT `id`,`title`,`module_id` FROM `cdp_category` WHERE `id` = 271 [ RunTime:0.000197s ]
SELECT * FROM `cdp_top_article` WHERE `sub_id` = 562 AND `seller_id` = 1 LIMIT 1 [ RunTime:0.000222s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '562' AND `b`.`is_del` = '1' [ RunTime:0.000351s ]
SELECT * FROM `cdp_category` WHERE `parent_id` = 91 AND `seller_id` = 1 AND `website_id` = 1 AND `lang` = 'en' AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000536s ]
SELECT * FROM `cdp_category` WHERE `id` = 87 AND `seller_id` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000337s ]
SELECT * FROM `cdp_module` WHERE `id` = 1 [ RunTime:0.000213s ]
SELECT * FROM `cdp_module_field` WHERE `module_id` = 1 [ RunTime:0.000264s ]
SELECT * FROM `cdp_category` WHERE `website_id` = 1 AND `lang` = 'en' AND `path` LIKE '0-69-91-87-%' ORDER BY `id` DESC [ RunTime:0.000767s ]
SELECT * FROM `cdp_category_sub_content` WHERE `category_id` = 87 AND `seller_id` = 1 [ RunTime:0.000365s ]
SELECT COUNT(*) AS think_count FROM `cdp_sub_content` WHERE `seller_id` = 1 AND `status` = 1 AND `check_status` = 3 AND `is_del` = 1 AND `is_top` = 2 AND `id` IN (554,556,558,560,561,555,217,559) AND `publish_time` <= '2025-06-16 17:27:11' LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`title`,`sub_title`,`description`,`thumbnail`,`cover`,`publish_time`,`seller_id`,`category_id` FROM `cdp_sub_content` WHERE `seller_id` = 1 AND `status` = 1 AND `check_status` = 3 AND `is_del` = 1 AND `is_top` = 2 AND `id` IN (554,556,558,560,561,555,217,559) AND `publish_time` <= '2025-06-16 17:27:11' ORDER BY `sort` ASC,`is_top` ASC,`top_time` DESC,`id` DESC LIMIT 0,15 [ RunTime:0.000347s ]
SELECT `id`,`title`,`module_id` FROM `cdp_category` WHERE `id` = 87 [ RunTime:0.000198s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '217' AND `b`.`is_del` = '1' [ RunTime:0.000289s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '554' AND `b`.`is_del` = '1' [ RunTime:0.000280s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '555' AND `b`.`is_del` = '1' [ RunTime:0.000294s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '556' AND `b`.`is_del` = '1' [ RunTime:0.000265s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '558' AND `b`.`is_del` = '1' [ RunTime:0.000272s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '559' AND `b`.`is_del` = '1' [ RunTime:0.000266s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '560' AND `b`.`is_del` = '1' [ RunTime:0.000266s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '561' AND `b`.`is_del` = '1' [ RunTime:0.000296s ]
SELECT * FROM `cdp_sys_setting` WHERE `seller_id` = 1 AND `title` = 'company_email' LIMIT 1 [ RunTime:0.000320s ]
SELECT * FROM `cdp_sys_setting` WHERE `seller_id` = 1 AND `title` = 'company_phone' LIMIT 1 [ RunTime:0.000296s ]
SELECT * FROM `cdp_category_sub_content` WHERE `category_id` = 282 AND `seller_id` = 1 [ RunTime:0.000401s ]
SELECT * FROM `cdp_sub_content` WHERE `seller_id` = 1 AND `status` = 1 AND `check_status` = 3 AND `is_del` = 1 AND `is_top` = 2 AND `id` IN (606,607,605) AND `publish_time` <= '2025-06-16 17:27:11' ORDER BY `is_top` ASC,`top_time` DESC,`publish_time` DESC,`id` DESC LIMIT 15 [ RunTime:0.000449s ]
SELECT `id`,`title`,`module_id` FROM `cdp_category` WHERE `id` = 282 [ RunTime:0.000226s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '607' AND `b`.`is_del` = '1' [ RunTime:0.000288s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '606' AND `b`.`is_del` = '1' [ RunTime:0.000285s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '605' AND `b`.`is_del` = '1' [ RunTime:0.000274s ]
SELECT * FROM `cdp_sys_setting` WHERE `seller_id` = 1 AND `title` = 'huocms_powerby' LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `cdp_sys_setting` WHERE `seller_id` = 1 AND `title` = 'company_email' LIMIT 1 [ RunTime:0.000292s ]
SELECT * FROM `cdp_sys_setting` WHERE `seller_id` = 1 AND `title` = 'company_phone' LIMIT 1 [ RunTime:0.000307s ]
SELECT * FROM `cdp_category_sub_content` WHERE `category_id` = 282 AND `seller_id` = 1 [ RunTime:0.000448s ]
SELECT * FROM `cdp_sub_content` WHERE `seller_id` = 1 AND `status` = 1 AND `check_status` = 3 AND `is_del` = 1 AND `is_top` = 2 AND `id` IN (606,607,605) AND `publish_time` <= '2025-06-16 17:27:11' ORDER BY `is_top` ASC,`top_time` DESC,`publish_time` DESC,`id` DESC LIMIT 15 [ RunTime:0.000500s ]
SELECT `id`,`title`,`module_id` FROM `cdp_category` WHERE `id` = 282 [ RunTime:0.000215s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '607' AND `b`.`is_del` = '1' [ RunTime:0.000298s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '606' AND `b`.`is_del` = '1' [ RunTime:0.000280s ]
SELECT `b`.* FROM `cdp_tag_sub_content` `a` INNER JOIN `cdp_tag` `b` ON `b`.`id`=`a`.`tag_id` WHERE `a`.`sub_content_id` = '605' AND `b`.`is_del` = '1' [ RunTime:0.000279s ]
SELECT * FROM `cdp_sys_setting` WHERE `seller_id` = 1 AND `title` = 'huocms_powerby' LIMIT 1 [ RunTime:0.000320s ]
SELECT * FROM `cdp_sub_content` WHERE `id` = 553 AND `seller_id` = 1 AND `publish_time` < '2025-06-16 17:27:11' AND `status` = 1 AND `is_del` = 1 LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`name`,`url`,`type`,`description` FROM `cdp_attachment` WHERE `id` IS NULL [ RunTime:0.000168s ]
SELECT `id`,`name`,`url`,`type`,`description` FROM `cdp_attachment` WHERE `id` IS NULL [ RunTime:0.000145s ]
SELECT * FROM `cdp_category` `a` INNER JOIN `cdp_category_sub_content` `b` ON `a`.`id`=`b`.`category_id` WHERE `b`.`sub_content_id` = '553' AND `a`.`seller_id` = '1' AND `a`.`website_id` = '1' AND `a`.`lang` = 'en' [ RunTime:0.000980s ]
SELECT * FROM `cdp_module` WHERE `id` = 8 [ RunTime:0.000211s ]
SELECT * FROM `cdp_module_field` WHERE `module_id` = 8 [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `cdp_customer_info` [ RunTime:0.000431s ]
SELECT * FROM `cdp_customer_info` WHERE `sub_id` = 553 AND `seller_id` = 1 LIMIT 1 [ RunTime:0.000256s ]