1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='testimonial' |
0.0062520503997803 |
2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.0059077739715576 |
3 |
SELECT country_id,title,slug,intro,image FROM default_country WHERE lang_id='fr' and is_trash=0 and is_online=1 order by order_no ASC |
0.011964082717896 |
4 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='fr' 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.0094399452209473 |
5 |
SELECT tourcat_id,title,slug,image FROM default_tour_category WHERE lang_id='fr' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.014480113983154 |
6 |
SELECT tour_id,list_cat_id FROM default_tour WHERE lang_id='fr' and is_trash=0 and is_online=1 and is_multi_country=1 |
0.011966943740845 |
7 |
SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='fr' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.011270046234131 |
8 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='fr' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3 |
0.0080139636993408 |
9 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='fr' and is_trash=0 and is_online=1 and type='VISITORAGETYPE' order by order_no ASC limit 0,1 |
0.012663125991821 |
10 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='fr' and is_trash=0 and is_online=1 and type='VISITORHEIGHTTYPE' order by order_no ASC limit 0,1 |
0.012583017349243 |
11 |
SELECT distinct short FROM default_property where property_id=952 LIMIT 0,1 |
0.004227876663208 |
12 |
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.00748610496521 |
13 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0010168552398682 |
14 |
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.0062849521636963 |
15 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00038599967956543 |
16 |
SELECT * FROM default_testimonial WHERE lang_id='fr' and is_trash=0 and is_online=1 and testimonial_id='8' and slug='vietnam-holiday-15-days' |
0.011279821395874 |
17 |
SELECT testimonial_id FROM default_testimonial WHERE lang_id='fr' and is_trash=0 and is_online=1 and testimonial_id<>'8' order by rand() limit 0,3 |
0.011965036392212 |
18 |
SELECT title FROM default_testimonial WHERE testimonial_id='8' |
0.0018420219421387 |
19 |
SELECT intro FROM default_testimonial WHERE testimonial_id='8' |
0.0060548782348633 |
20 |
SELECT slug FROM default_testimonial WHERE testimonial_id='8' |
0.00036406517028809 |
21 |
SELECT meta_id,image FROM default_meta WHERE lang_id='fr' and config_link='/fr/te8-vietnam-holiday-15-days.html' |
0.012513875961304 |
22 |
SELECT image FROM default_meta WHERE meta_id='40' |
0.0059361457824707 |
23 |
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.0079879760742188 |
24 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0003809928894043 |
25 |
SELECT page_id,title,slug FROM default_page WHERE lang_id='fr' and is_trash=0 and is_online=1 and page_id <>'3' order by order_no asc |
0.0022220611572266 |
26 |
SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='fr' and (config_link='/fr/te8-vietnam-holiday-15-days.html' or config_link='/fr/te8-vietnam-holiday-15-days.html') limit 1 |
0.0016398429870605 |
27 |
SELECT * FROM default_featurepackage WHERE mod_page='setting' and act_page='cart' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0011332035064697 |
28 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0002129077911377 |
29 |
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.00080513954162598 |
30 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016903877258301 |
31 |
SELECT slug FROM default_country WHERE country_id='5' |
0.00017404556274414 |
32 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00029397010803223 |
33 |
SELECT slug FROM default_country WHERE country_id='5' |
0.00016903877258301 |
34 |
SELECT slug FROM default_country WHERE country_id='11' |
0.00017595291137695 |
35 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.0001530647277832 |
36 |
SELECT slug FROM default_country WHERE country_id='11' |
0.00014209747314453 |
37 |
SELECT slug FROM default_country WHERE country_id='12' |
0.00014090538024902 |
38 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00011897087097168 |
39 |
SELECT slug FROM default_country WHERE country_id='12' |
0.00019097328186035 |
40 |
SELECT slug FROM default_country WHERE country_id='13' |
0.00019598007202148 |
41 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00017285346984863 |
42 |
SELECT slug FROM default_country WHERE country_id='13' |
0.00014591217041016 |
43 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='35' or list_cat_id like '%|35|%') |
0.00050091743469238 |
44 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='34' or list_cat_id like '%|34|%') |
0.00038385391235352 |
45 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='33' or list_cat_id like '%|33|%') |
0.00037717819213867 |
46 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='32' or list_cat_id like '%|32|%') |
0.00037384033203125 |
47 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='31' or list_cat_id like '%|31|%') |
0.00037622451782227 |
48 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='29' or list_cat_id like '%|29|%') |
0.00037288665771484 |
49 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='28' or list_cat_id like '%|28|%') |
0.00038814544677734 |
50 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='27' or list_cat_id like '%|27|%') |
0.00038909912109375 |
51 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='26' or list_cat_id like '%|26|%') |
0.00038504600524902 |
52 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='25' or list_cat_id like '%|25|%') |
0.00037407875061035 |
53 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='24' or list_cat_id like '%|24|%') |
0.00037598609924316 |
54 |
SELECT title FROM default_testimonial WHERE testimonial_id='8' |
0.0003509521484375 |
55 |
SELECT rates FROM default_testimonial WHERE testimonial_id='8' |
0.00015592575073242 |
56 |
SELECT name FROM default_testimonial WHERE testimonial_id='8' |
0.00013303756713867 |
57 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='8' |
0.00019001960754395 |
58 |
SELECT title FROM _country WHERE country_id='175' |
0.00038886070251465 |
59 |
SELECT intro FROM default_testimonial WHERE testimonial_id='8' |
0.00017619132995605 |
60 |
SELECT title FROM default_testimonial WHERE testimonial_id='3' |
0.00018596649169922 |
61 |
SELECT slug FROM default_testimonial WHERE testimonial_id='3' |
0.00016498565673828 |
62 |
SELECT image FROM default_testimonial WHERE testimonial_id='3' |
0.00016188621520996 |
63 |
SELECT intro FROM default_testimonial WHERE testimonial_id='3' |
0.00014805793762207 |
64 |
SELECT name FROM default_testimonial WHERE testimonial_id='3' |
0.00014495849609375 |
65 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='3' |
0.00011992454528809 |
66 |
SELECT title FROM _country WHERE country_id='77' |
0.00020909309387207 |
67 |
SELECT rates FROM default_testimonial WHERE testimonial_id='3' |
0.00018787384033203 |
68 |
SELECT title FROM default_testimonial WHERE testimonial_id='11' |
0.00017094612121582 |
69 |
SELECT slug FROM default_testimonial WHERE testimonial_id='11' |
0.00014686584472656 |
70 |
SELECT image FROM default_testimonial WHERE testimonial_id='11' |
0.00012516975402832 |
71 |
SELECT intro FROM default_testimonial WHERE testimonial_id='11' |
0.00021886825561523 |
72 |
SELECT name FROM default_testimonial WHERE testimonial_id='11' |
0.0002129077911377 |
73 |
SELECT country_id FROM default_testimonial WHERE testimonial_id='11' |
0.00019097328186035 |
74 |
SELECT title FROM _country WHERE country_id='134' |
0.00017905235290527 |
75 |
SELECT rates FROM default_testimonial WHERE testimonial_id='11' |
0.00015616416931152 |
76 |
SELECT why_id,title,image,intro FROM default_why WHERE lang_id='fr' and is_trash=0 and is_online=1 and type='HOME' order by order_no ASC |
0.0027358531951904 |
77 |
SELECT * FROM default_featurepackage WHERE mod_page='subscription' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0013220310211182 |
78 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020313262939453 |
79 |
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.0083591938018799 |
80 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0010080337524414 |
81 |
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.0086472034454346 |
82 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00088906288146973 |
83 |
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.010973930358887 |
84 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00094413757324219 |
85 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.0061931610107422 |
86 |
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.0061938762664795 |
87 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0014069080352783 |