TT TREE is an intelligent teaching matching platform dedicated to connecting students with professional tutors. ROLLLL DESIGN was responsible for its overall product strategy, user experience design, and technical development. The core objective was to solve the dual-sided challenges of students finding suitable tutors and tutors acquiring clients. This project leverages data-driven demand matching and a rigorous tutor verification system to create an efficient, transparent, and trustworthy professional teaching services marketplace.
Main Highlights
Intelligent Teaching Demand Matching Engine: The platform's core is its intelligent matching system. Students can input detailed training goals, budget, available times, and location preferences. Based on this data, the system uses algorithms to recommend and filter a list of professional tutors that best match the criteria, transforming the traditionally time-consuming and laborious search process into efficient, precise recommendations.
Dual-Side User Experience & Real-Time Status Synchronization Architecture: For the two distinct user roles—students and tutors—we built two separate, optimized user flow and interface systems. More crucially, we implemented a real-time synchronization mechanism for data across both sides (such as demand postings, tutor applications, and booking status). This ensures the immediacy and smoothness of two-way interactions, creating a seamless connection experience.
Platform-Based Verification & Ecosystem Management System: ROLLLL DESIGN developed powerful platform management tools for the client's backend. This includes not only a standardized tutor onboarding and qualification verification process but also a centralized control system for course orders, transaction logic, user reviews, and activity information. This system empowers the client to effortlessly maintain platform quality, manage complex bilateral relationships, and operate the ecosystem autonomously.
Extended Community & Resource Integration: In addition to its core matching functionality, the platform also integrates local event information with online registration features and pushes relevant promotions. This helps enhance user engagement and extends the platform from a mere transactional space into a community and information hub.
Result
The establishment of the TT TREE platform has successfully standardized and digitized the offline matching process in the teaching market. Through the intelligent matching system and two-sided platform mechanism designed by ROLLLL DESIGN, it has not only significantly enhanced the connection efficiency and success rate between students and tutors but also created a professional service platform with quality control and sustainable operational capabilities for the client. This has set a new service standard within Hong Kong's sports and teaching sector.
Free Consultation
Get Free Consultation Now
Our professional team has rich technical experience and advanced development capabilities, and can tailor IT technical solutions for you according to your needs.
We will reply to you within one day
基本文件流程错误SQL调试
请求信息 : 2026-06-15 11:49:39 HTTP/2.0 GET : https://rolllldesign.com/en/portfolio/tt-tree.html
SHOW FULL COLUMNS FROM `dlm_user` [ RunTime:0.001214s ]
SELECT * FROM `dlm_user` WHERE `status` = 1 AND `token` = 'cxiozWIhQajxDasmjilCfhHVP' LIMIT 1 [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `dlm_site` [ RunTime:0.000668s ]
SELECT * FROM `dlm_site` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `dlm_nav` [ RunTime:0.000702s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `tpl` = 'tt-tree' AND `catid` = -1 ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000300s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%tt-tree.html%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000291s ]
SELECT `id`,COALESCE(name_en, name) as name,COALESCE(sub_en, sub) as sub,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,parent_id as parentid,`linkurl`,COALESCE(title_en, title) as title,COALESCE(keywords_en, keywords) as keywords,COALESCE(description_en, description) as description FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%tt-tree%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000255s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000303s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 14 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000271s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000282s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000288s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000313s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000260s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 27 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `dlm_article` [ RunTime:0.000770s ]
SELECT `id`,title_en as name,url_en as linkurl,`thumb_url`,thumb_alt_en as thumb_alt FROM `dlm_article` WHERE `status` = 1 ORDER BY `is_rec` DESC,`sort` ASC LIMIT 3 [ RunTime:0.000385s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 30 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000265s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000243s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 14 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000213s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000206s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 15 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000227s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000210s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 22 AND `thumb_url` LIKE '%images%' ORDER BY `sort` ASC LIMIT 3 [ RunTime:0.000201s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 27 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000189s ]
SELECT `id`,title_en as name,url_en as linkurl,`thumb_url`,thumb_alt_en as thumb_alt FROM `dlm_article` WHERE `status` = 1 ORDER BY `is_rec` DESC,`sort` ASC LIMIT 3 [ RunTime:0.000282s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,COALESCE(thumb_alt_en, thumb_alt) as thumb_alt,COALESCE(name_en, name) as name,`status`,catid as cat FROM `dlm_nav` WHERE `parent_id` = 30 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `dlm_weblink` [ RunTime:0.001268s ]
SELECT * FROM `dlm_weblink` ORDER BY `sort` ASC [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `dlm_ai_stats` [ RunTime:0.000820s ]
SHOW FULL COLUMNS FROM `dlm_goods` [ RunTime:0.000991s ]
SELECT g_result_en as result,g_cdate as create_time,b.thumb as cat_thumb,g_link as link,seo_title_en as seo_title,seo_keywords_en as seo_keywords,seo_description_en as seo_description,b.catname_en as catname_en,b.catname as catname_cn,`b`.`catid`,g_imgs as imgs,g_tag_en as tag,g_thumb as thumb,g_thumb_alt_en as thumb_alt,g_description_en as description,g_content_en as content,g_param as param,g_ad_en as ad,g_sub_en as sub,g_ids as ids,g_extra as extra,g_name_en as name FROM `dlm_goods` `a` LEFT JOIN `dlm_goods_cat` `b` ON `b`.`catid`=`a`.`g_cat2` WHERE `a`.`g_state` = '2' AND `a`.`g_seo_en` = 'tt-tree' LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,name_en as name,`catid`,sub_en as sub,`thumb_url`,thumb_alt_en as thumb_alt,parent_id as parentid,`linkurl`,title_en as title,keywords_en as keywords,description_en as description FROM `dlm_nav` WHERE `tpl` = 'portfolio' AND `catid` = 3 ORDER BY `parent_id` ASC,`id` ASC LIMIT 1 [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `dlm_web` [ RunTime:0.001393s ]
SELECT id as w_id,`page_code`,`mp4`,name_en as name,link_name_en as link_name,`link_url`,sub_en as sub,description_en as description,`k`,`image_url`,image_url_alt_en as image_url_alt,`tpl`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data1_image_url`,data1_image_alt_en as data1_image_alt,`data1_out_mp4`,`data1_type`,`data1_show`,`data2_image_url`,data2_image_alt_en as data2_image_alt,`data2_out_mp4`,`data2_type`,`data2_show`,`data3_image_url`,data3_image_alt_en as data3_image_alt,`data3_out_mp4`,`data3_type`,`data3_show`,`data4_image_url`,data4_image_alt_en as data4_image_alt,`data4_out_mp4`,`data4_type`,`data4_show`,`data5_image_url`,data5_image_alt_en as data5_image_alt,`data5_out_mp4`,`data5_type`,`data5_show`,`data6_image_url`,data6_image_alt_en as data6_image_alt,`data6_out_mp4`,`data6_type`,`data6_show`,`data7_image_url`,data7_image_alt_en as data7_image_alt,`data7_out_mp4`,`data7_type`,`data7_show`,`data8_image_url`,data8_image_alt_en as data8_image_alt,`data8_out_mp4`,`data8_type`,`data8_show`,`data9_image_url`,data9_image_alt_en as data9_image_alt,`data9_out_mp4`,`data9_type`,`data9_show`,`data10_image_url`,data10_image_alt_en as data10_image_alt,`data10_out_mp4`,`data10_type`,`data10_show`,`data11_image_url`,data11_image_alt_en as data11_image_alt,`data11_out_mp4`,`data11_type`,`data11_show`,`data12_image_url`,data12_image_alt_en as data12_image_alt,`data12_out_mp4`,`data12_type`,`data12_show`,`data13_image_url`,data13_image_alt_en as data13_image_alt,`data13_out_mp4`,`data13_type`,`data13_show`,`data14_image_url`,data14_image_alt_en as data14_image_alt,`data14_out_mp4`,`data14_type`,`data14_show` FROM `dlm_web` WHERE `catdir` = 'home' LIMIT 1 [ RunTime:0.000509s ]
