1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog' |
0.00094199180603027 |
2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.0002589225769043 |
3 |
SELECT country_id,title,slug,intro,image,image_menu FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC |
0.0019981861114502 |
4 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 AND country_id IN (SELECT country_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no asc |
0.0022590160369873 |
5 |
SELECT tourcat_id,title,slug,image FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.0016989707946777 |
6 |
SELECT tour_id,list_cat_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and is_multi_country=1 |
0.0018179416656494 |
7 |
SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.0017328262329102 |
8 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3 |
0.0016589164733887 |
9 |
SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1 |
0.00020194053649902 |
10 |
SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00076889991760254 |
11 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00019097328186035 |
12 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_departure_point' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00074100494384766 |
13 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016403198242188 |
14 |
SELECT tag_id FROM default_tag WHERE lang_id='' and slug='phu-quoc-island-top-3star-hotels' limit 0,1 |
0.0018270015716553 |
15 |
SELECT * FROM default_tag WHERE tag_id='596' |
0.00024914741516113 |
16 |
SELECT title FROM default_tag WHERE tag_id='596' |
0.00014185905456543 |
17 |
SELECT * FROM default_tag WHERE tag_id='596' |
0.00018215179443359 |
18 |
SELECT * FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%|596|%') |
0.0047781467437744 |
19 |
SELECT blog_id,cat_id,reg_date,publish_date FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%|596|%') order by order_no ASC LIMIT 0,6 |
0.0022859573364258 |
20 |
SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00082516670227051 |
21 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020313262939453 |
22 |
SELECT * FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00082993507385254 |
23 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00019598007202148 |
24 |
SELECT page_id,title,slug FROM default_page WHERE lang_id='' and is_trash=0 and is_online=1 and page_id <>'1' order by order_no asc |
0.0017330646514893 |
25 |
SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/blog/tag/phu-quoc-island-top-3star-hotels' or config_link='/blog/tag/phu-quoc-island-top-3star-hotels') limit 1 |
0.0027170181274414 |
26 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00018501281738281 |
27 |
SELECT slug FROM default_country WHERE country_id='64' |
0.00019311904907227 |
28 |
SELECT slug FROM default_country WHERE country_id='3' |
0.00020408630371094 |
29 |
SELECT slug FROM default_country WHERE country_id='7' |
0.00021004676818848 |
30 |
SELECT * FROM default_featurepackage WHERE mod_page='tour_exhautive' and act_page='category_country' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0011119842529297 |
31 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020480155944824 |
32 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC |
0.0018689632415771 |
33 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC |
0.0019009113311768 |
34 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC |
0.0018560886383057 |
35 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC |
0.001655101776123 |
36 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC |
0.0016388893127441 |
37 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='6' |
0.00020098686218262 |
38 |
SELECT slug FROM default_country WHERE country_id='1' |
0.0002129077911377 |
39 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='5' |
0.00021886825561523 |
40 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00020694732666016 |
41 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='4' |
0.00019121170043945 |
42 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00017905235290527 |
43 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='3' |
0.00016307830810547 |
44 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00015091896057129 |
45 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='2' |
0.00016498565673828 |
46 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00015592575073242 |
47 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='1' |
0.00016689300537109 |
48 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00015616416931152 |
49 |
SELECT image_menu FROM default_country WHERE country_id='1' |
0.00014495849609375 |
50 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC |
0.0016360282897949 |
51 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='12' |
0.0001370906829834 |
52 |
SELECT slug FROM default_country WHERE country_id='64' |
0.00013017654418945 |
53 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='11' |
0.00021696090698242 |
54 |
SELECT slug FROM default_country WHERE country_id='64' |
0.00020599365234375 |
55 |
SELECT image_menu FROM default_country WHERE country_id='64' |
0.00019121170043945 |
56 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC |
0.0019431114196777 |
57 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='8' |
0.00014591217041016 |
58 |
SELECT slug FROM default_country WHERE country_id='3' |
0.0001380443572998 |
59 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='7' |
0.00012397766113281 |
60 |
SELECT slug FROM default_country WHERE country_id='3' |
0.0002131462097168 |
61 |
SELECT image_menu FROM default_country WHERE country_id='3' |
0.00021100044250488 |
62 |
SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC |
0.0017340183258057 |
63 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='10' |
0.00013589859008789 |
64 |
SELECT slug FROM default_country WHERE country_id='7' |
0.00012803077697754 |
65 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='9' |
0.00021600723266602 |
66 |
SELECT slug FROM default_country WHERE country_id='7' |
0.00020599365234375 |
67 |
SELECT image_menu FROM default_country WHERE country_id='7' |
0.00019478797912598 |
68 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20' |
0.00020003318786621 |
69 |
SELECT slug FROM default_tour_category WHERE tourcat_id='20' |
0.00018215179443359 |
70 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16' |
0.00016903877258301 |
71 |
SELECT slug FROM default_tour_category WHERE tourcat_id='16' |
0.00014996528625488 |
72 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19' |
0.00013589859008789 |
73 |
SELECT slug FROM default_tour_category WHERE tourcat_id='19' |
0.00021600723266602 |
74 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15' |
0.00020194053649902 |
75 |
SELECT slug FROM default_tour_category WHERE tourcat_id='15' |
0.00018310546875 |
76 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17' |
0.00016903877258301 |
77 |
SELECT slug FROM default_tour_category WHERE tourcat_id='17' |
0.00014901161193848 |
78 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18' |
0.00013494491577148 |
79 |
SELECT slug FROM default_tour_category WHERE tourcat_id='18' |
0.00021600723266602 |
80 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13' |
0.00020194053649902 |
81 |
SELECT slug FROM default_tour_category WHERE tourcat_id='13' |
0.00018095970153809 |
82 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14' |
0.00016593933105469 |
83 |
SELECT slug FROM default_tour_category WHERE tourcat_id='14' |
0.00097298622131348 |
84 |
SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22' |
0.00020289421081543 |
85 |
SELECT slug FROM default_tour_category WHERE tourcat_id='22' |
0.00017690658569336 |
86 |
SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00082302093505859 |
87 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018310546875 |
88 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='51' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016140937805176 |
89 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49' |
0.00018811225891113 |
90 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015769004821777 |
91 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015649795532227 |
92 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6' |
0.0001378059387207 |
93 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016670227050781 |
94 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015871524810791 |
95 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50' |
0.00015711784362793 |
96 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015599727630615 |
97 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015339851379395 |
98 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7' |
0.00020384788513184 |
99 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016160011291504 |
100 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016260147094727 |
101 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4' |
0.0001981258392334 |
102 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016169548034668 |
103 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016138553619385 |
104 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2' |
0.00018692016601562 |
105 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015709400177002 |
106 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016307830810547 |
107 |
SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.000762939453125 |
108 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017189979553223 |
109 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='57' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015521049499512 |
110 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58' |
0.00013899803161621 |
111 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016500949859619 |
112 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015380382537842 |
113 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59' |
0.00021004676818848 |
114 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016219615936279 |
115 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016241073608398 |
116 |
SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00082492828369141 |
117 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017094612121582 |
118 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='60' and is_trash=0 and is_online=1 order by order_no ASC |
0.0016570091247559 |
119 |
SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00076413154602051 |
120 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017023086547852 |
121 |
SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='54' and is_trash=0 and is_online=1 order by order_no ASC |
0.0015280246734619 |
122 |
SELECT title FROM default_tag WHERE tag_id='596' |
0.00020098686218262 |
123 |
SELECT title FROM default_blog WHERE blog_id='246' |
0.00020503997802734 |
124 |
SELECT slug FROM default_blog WHERE blog_id='246' |
0.00017404556274414 |
125 |
SELECT author FROM default_blog WHERE blog_id='246' |
0.00016593933105469 |
126 |
SELECT author FROM default_blog WHERE blog_id='246' |
0.00013399124145508 |
127 |
SELECT image FROM default_blog WHERE blog_id='246' |
0.00020194053649902 |
128 |
SELECT image FROM default_blog WHERE blog_id='246' |
0.0001978874206543 |
129 |
SELECT intro FROM default_blog WHERE blog_id='246' |
0.00018191337585449 |
130 |
SELECT blogcat_id, title,slug FROM default_blogcat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc |
0.0016841888427734 |
131 |
SELECT blog_id,slug,title FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and num_view > 0 order by num_view desc limit 0,5 |
0.0019550323486328 |
132 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 AND country_id IN (SELECT country_id FROM default_blog WHERE is_trash=0 and is_online=1) order by order_no asc |
0.0020270347595215 |
133 |
SELECT blog_extension_id,tour_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='tour' and tour_id IN (SELECT tour_id FROM default_tour WHERE is_trash=0 and is_online=1) order by order_no ASC |
0.0018799304962158 |
134 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00020217895507812 |
135 |
SELECT slug FROM default_country WHERE country_id='64' |
0.00018405914306641 |
136 |
SELECT slug FROM default_country WHERE country_id='3' |
0.00016212463378906 |
137 |
SELECT slug FROM default_country WHERE country_id='7' |
0.0001370906829834 |
138 |
SELECT * FROM default_featurepackage WHERE mod_page='testimonial' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00079202651977539 |
139 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017690658569336 |
140 |
SELECT testimonial_id,title,slug,image,reg_date,rates,name,intro FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online = 1 and image<>'' order by order_no ASC limit 0,9 |
0.0017580986022949 |
141 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='7' |
0.0001521110534668 |
142 |
SELECT title FROM _country WHERE country_id='193' |
0.00015091896057129 |
143 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='12' |
0.00015091896057129 |
144 |
SELECT title FROM _country WHERE country_id='103' |
0.00012302398681641 |
145 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='10' |
0.00011897087097168 |
146 |
SELECT title FROM _country WHERE country_id='229' |
0.00018906593322754 |
147 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='5' |
0.00018596649169922 |
148 |
SELECT title FROM _country WHERE country_id='14' |
0.00015783309936523 |
149 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='8' |
0.0001528263092041 |
150 |
SELECT title FROM _country WHERE country_id='175' |
0.00012493133544922 |
151 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='6' |
0.00011801719665527 |
152 |
SELECT title FROM _country WHERE country_id='228' |
0.00018787384033203 |
153 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='9' |
0.00018095970153809 |
154 |
SELECT title FROM _country WHERE country_id='42' |
0.00015091896057129 |
155 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='11' |
0.00014519691467285 |
156 |
SELECT title FROM _country WHERE country_id='134' |
0.00012898445129395 |
157 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='3' |
0.00012302398681641 |
158 |
SELECT title FROM _country WHERE country_id='77' |
0.00019097328186035 |
159 |
SELECT * FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00079083442687988 |
160 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017094612121582 |
161 |
SELECT * FROM default_featurepackage WHERE mod_page='testimonial' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00078201293945312 |
162 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017309188842773 |
163 |
SELECT * FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00078606605529785 |
164 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016999244689941 |
165 |
SELECT * FROM default_featurepackage WHERE mod_page='download' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00075888633728027 |
166 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016903877258301 |
167 |
SELECT * FROM default_featurepackage WHERE mod_page='news' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00077486038208008 |
168 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020098686218262 |
169 |
SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00081896781921387 |
170 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017094612121582 |