Thuật toán của TripAdvisor

1	SELECT * FROM session WHERE session_id='ba15gmbtbq1ijli3fuvvjmu4gv'	0.00032901763916016
2	SELECT * FROM session WHERE session_id='ba15gmbtbq1ijli3fuvvjmu4gv'	0.00060892105102539
3	SELECT solution_id,_Icon,_Icon2,title,intro,image,slug FROM default_solution WHERE is_trash=0 order by order_no asc	0.00090408325195312
4	SELECT product_id,title,intro,slug,title_show FROM default_product WHERE is_trash=0 order by order_no asc	0.0018119812011719
5	SELECT news_id,reg_date,end_date,cat_id,slug_vn FROM default_news WHERE is_trash=0 and is_online=1 and (cat_id = '' or list_cat_id like '%\|\|%')	0.0050389766693115
6	SELECT * FROM default_setting WHERE setting_id='1'	0.00028085708618164
7	SELECT * FROM default_common WHERE common_id='1'	0.00031399726867676
8	SELECT * FROM default_headerlink WHERE is_trash=0 and parent_id=0 order by order_no ASC limit 0,5	0.00082302093505859
9	SELECT meta_id,config_link FROM default_meta WHERE short_url='/tags/thuat-toan-cua-tripadvisor.html' limit 0,1	0.0026412010192871
10	SELECT blog_id,title_show,title,html_file_url,slug,intro FROM default_blog WHERE is_trash=0 and is_online=1 order by reg_date DESC limit 0,10	0.012588024139404
11	SELECT * FROM _tag WHERE slug='thuat-toan-cua-tripadvisor' limit 0,1	0.0012750625610352
12	SELECT cat_id FROM default_category WHERE is_trash=0 and parent_id='6' and cat_id NOT IN(8,15,42) order by order_no ASC	0.00073695182800293
13	SELECT COUNT(*) AS totalitem FROM default_news WHERE is_trash=0 and (news_id IN (SELECT news_id FROM _tag_news WHERE tag_id='1760') or news_id_old IN (SELECT news_id FROM _tag_news WHERE tag_id='1760'))	0.0050320625305176
14	SELECT * FROM _tag WHERE tag_id='1760'	0.00031590461730957
15	SELECT news_id FROM default_news WHERE is_trash=0 and (news_id IN (SELECT news_id FROM _tag_news WHERE tag_id='1760') or news_id_old IN (SELECT news_id FROM _tag_news WHERE tag_id='1760'))	0.004694938659668
16	SELECT * FROM _tag WHERE tag_id='1760'	0.00027990341186523
17	SELECT meta_id,config_value_title,config_value_intro,image,config_link FROM default_meta WHERE (config_link='/tags/thuat-toan-cua-tripadvisor.html' or config_link='/tags/thuat-toan-cua-tripadvisor.html') limit 1	0.0032050609588623
18	SELECT * FROM default_common WHERE common_id='1'	0.00027799606323242
19	SELECT cat_id FROM default_category WHERE is_trash=0 and parent_id='6' and cat_id NOT IN(8,15) order by order_no ASC	0.00072598457336426
20	SELECT cat_id FROM default_category WHERE is_trash=0 and parent_id='6' and cat_id IN (7,19,13,26) order by order_no ASC	0.0007021427154541
21	SELECT cat_id FROM default_category WHERE is_trash=0 and parent_id='36' order by order_no ASC	0.00066018104553223
22	SELECT footerlink_id FROM default_footerlink WHERE is_trash=0 and parent_id=0 order by order_no ASC limit 0,4	0.0008242130279541
23	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Sản phẩm' limit 0,1	0.0010340213775635
24	SELECT product_id,title,intro,title_menu,logo,intro_menu,slug FROM default_product WHERE is_trash=0 and is_menu=1 and solution_menu_id='10' order by order_no ASC	0.00080013275146484
25	SELECT product_id,title,intro,title_menu,logo,intro_menu,slug FROM default_product WHERE is_trash=0 and is_menu=1 and solution_menu_id='11' order by order_no ASC	0.00094199180603027
26	SELECT product_id,title,intro,title_menu,logo,intro_menu,slug FROM default_product WHERE is_trash=0 and is_menu=1 and solution_menu_id='7' order by order_no ASC	0.0007481575012207
27	SELECT product_id,title,intro,title_menu,logo,intro_menu,slug FROM default_product WHERE is_trash=0 and is_menu=1 and solution_menu_id='8' order by order_no ASC	0.00076603889465332
28	SELECT product_id,title,intro,title_menu,logo,intro_menu,slug FROM default_product WHERE is_trash=0 and is_menu=1 and solution_menu_id='9' order by order_no ASC	0.00085616111755371
29	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Khách hàng' limit 0,1	0.0010290145874023
30	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Tài nguyên' limit 0,1	0.0011880397796631
31	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Giới thiệu' limit 0,1	0.0011630058288574
32	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Đăng nhập' limit 0,1	0.00095891952514648
33	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Liên hệ' limit 0,1	0.00094103813171387
34	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Khách hàng' limit 0,1	0.00098609924316406
35	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Tài nguyên' limit 0,1	0.0009760856628418
36	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Tài nguyên' limit 0,1	0.00095200538635254
37	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='News' limit 0,1	0.00093603134155273
38	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='News' limit 0,1	0.0010230541229248
39	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Giới thiệu' limit 0,1	0.0010430812835693
40	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='Giới thiệu' limit 0,1	0.00092387199401855