Thuật toán của TripAdvisor

1	SELECT * FROM session WHERE session_id='9hhr34i49c2chtiimd6fd082d8'	0.00050902366638184
2	SELECT * FROM session WHERE session_id='9hhr34i49c2chtiimd6fd082d8'	0.0016140937805176
3	SELECT solution_id,_Icon,_Icon2,title,intro,image,slug FROM default_solution WHERE is_trash=0 order by order_no asc	0.0021328926086426
4	SELECT product_id,title,intro,slug,title_show FROM default_product WHERE is_trash=0 order by order_no asc	0.0024440288543701
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.0066940784454346
6	SELECT * FROM default_setting WHERE setting_id='1'	0.00041699409484863
7	SELECT * FROM default_common WHERE common_id='1'	0.00058603286743164
8	SELECT * FROM default_headerlink WHERE is_trash=0 and parent_id=0 order by order_no ASC limit 0,5	0.0012872219085693
9	SELECT meta_id,config_link FROM default_meta WHERE short_url='/tags/thuat-toan-cua-tripadvisor.html' limit 0,1	0.0035719871520996
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.016842842102051
11	SELECT * FROM _tag WHERE slug='thuat-toan-cua-tripadvisor' limit 0,1	0.0018410682678223
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.0010900497436523
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.0066699981689453
14	SELECT * FROM _tag WHERE tag_id='1760'	0.00039911270141602
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.0055680274963379
16	SELECT * FROM _tag WHERE tag_id='1760'	0.00033783912658691
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.0034799575805664
18	SELECT * FROM default_common WHERE common_id='1'	0.00040817260742188
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.00084996223449707
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.00072789192199707
21	SELECT cat_id FROM default_category WHERE is_trash=0 and parent_id='36' order by order_no ASC	0.00080490112304688
22	SELECT footerlink_id FROM default_footerlink WHERE is_trash=0 and parent_id=0 order by order_no ASC limit 0,4	0.0008690357208252
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.0016169548034668
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.0010099411010742
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.0011260509490967
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.00095295906066895
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.001147985458374
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.0010001659393311
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.0012238025665283
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.0012381076812744
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.0011289119720459
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.0014679431915283
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.0012481212615967
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.0012669563293457
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.0012800693511963
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.0012748241424561
37	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='News' limit 0,1	0.0012631416320801
38	SELECT lang_id,value_2,value_1 FROM default_lang_front WHERE lang_id='vn' and keyword='News' limit 0,1	0.0012819766998291
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.001255989074707
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.0013160705566406