1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='cruise' |
0.0016441345214844 |
2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.00031590461730957 |
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.032170057296753 |
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.0026009082794189 |
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.023324012756348 |
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.38319897651672 |
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.012650966644287 |
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.013130903244019 |
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.0070559978485107 |
11 |
SELECT distinct short FROM default_property where property_id=952 LIMIT 0,1 |
0.005403995513916 |
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.0074868202209473 |
13 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00045084953308105 |
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.010854959487915 |
15 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0019481182098389 |
16 |
SELECT country_id FROM default_country WHERE lang_id='fr' and is_trash=0 and slug = 'cambodge' |
0.011411905288696 |
17 |
SELECT cruise_id FROM default_cruise WHERE lang_id='fr' and is_trash=0 and is_online=1 |
0.044081926345825 |
18 |
SELECT cruise_id,title,slug,star_number,about,image FROM default_cruise WHERE lang_id='fr' and is_trash=0 and is_online=1 and cruise_id IN (SELECT cruise_id FROM default_cruise_destination WHERE is_trash=0 and country_id='11' ) order by order_no asc limit 0,6 |
0.027302980422974 |
19 |
SELECT cruise_id FROM default_cruise WHERE lang_id='fr' and is_trash=0 and is_online=1 and cruise_id IN (SELECT cruise_id FROM default_cruise_destination WHERE is_trash=0 and country_id='11' ) |
0.031962156295776 |
20 |
SELECT country_id,title,image,banner,slug,intro FROM default_country WHERE country_id='11' |
0.0029420852661133 |
21 |
SELECT slug FROM default_country WHERE country_id='11' |
0.0045220851898193 |
22 |
SELECT intro FROM default_country WHERE country_id='11' |
0.0040078163146973 |
23 |
SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='' |
0.0035409927368164 |
24 |
SELECT meta_id,image FROM default_meta WHERE lang_id='fr' and config_link='/fr/cruise//' |
0.011945962905884 |
25 |
SELECT distinct image FROM default_cruise_cat where cruise_cat_id= LIMIT 0,1 |
0.0026299953460693 |
26 |
SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0080089569091797 |
27 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0039198398590088 |
28 |
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.07537317276001 |
29 |
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/cruises/cambodge' or config_link='/fr/cruises/cambodge') limit 1 |
0.0089669227600098 |
30 |
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.0064568519592285 |
31 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0062689781188965 |
32 |
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.0064380168914795 |
33 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0054981708526611 |
34 |
SELECT slug FROM default_country WHERE country_id='5' |
0.00084304809570312 |
35 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.01095986366272 |
36 |
SELECT slug FROM default_country WHERE country_id='5' |
0.0014429092407227 |
37 |
SELECT slug FROM default_country WHERE country_id='11' |
0.0061161518096924 |
38 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.0042910575866699 |
39 |
SELECT slug FROM default_country WHERE country_id='11' |
0.0079770088195801 |
40 |
SELECT slug FROM default_country WHERE country_id='12' |
0.011869192123413 |
41 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.0009758472442627 |
42 |
SELECT slug FROM default_country WHERE country_id='12' |
0.0061850547790527 |
43 |
SELECT slug FROM default_country WHERE country_id='13' |
0.012668132781982 |
44 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.0071558952331543 |
45 |
SELECT slug FROM default_country WHERE country_id='13' |
0.0047638416290283 |
46 |
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.0017809867858887 |
47 |
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.0060868263244629 |
48 |
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.0039491653442383 |
49 |
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.0079548358917236 |
50 |
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.00085020065307617 |
51 |
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.0062069892883301 |
52 |
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.0049281120300293 |
53 |
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.011857986450195 |
54 |
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.0019221305847168 |
55 |
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.006011962890625 |
56 |
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.0039429664611816 |
57 |
SELECT * FROM default_cruise_destination WHERE lang_id='fr' and is_trash=0 and country_id='11' and cruise_id IN (SELECT cruise_id FROM default_cruise WHERE is_trash=0 and is_online=1) order by order_no asc |
0.0086288452148438 |
58 |
SELECT title FROM default_city WHERE city_id='773' |
0.067929983139038 |
59 |
SELECT title FROM default_city WHERE city_id='768' |
0.00029397010803223 |
60 |
SELECT title FROM default_city WHERE city_id='766' |
0.00018000602722168 |
61 |
SELECT cruise_price_range_id FROM default_cruise_price_range WHERE lang_id='fr' and is_trash=0 order by order_no asc |
0.0086948871612549 |
62 |
SELECT cruise_destination_id,country_id,city_id FROM default_cruise_destination WHERE lang_id='fr' and is_trash=0 and cruise_id='145' order by order_no asc Limit 0,1 |
0.013244867324829 |
63 |
SELECT title,slug FROM default_city WHERE city_id='774' |
0.003122091293335 |
64 |
SELECT * FROM default_cruise_destination WHERE lang_id='fr' and is_trash=0 and cruise_id='145' order by order_no asc |
0.0096950531005859 |
65 |
SELECT title,slug FROM default_city WHERE city_id='774' |
0.0062389373779297 |
66 |
SELECT title,slug FROM default_city WHERE city_id='773' |
0.0039699077606201 |
67 |
SELECT title,slug FROM default_city WHERE city_id='780' |
0.0028510093688965 |
68 |
SELECT MIN(min_price) as price FROM default_cruise_itinerary WHERE lang_id='fr' and is_trash=0 and is_online=1 and cruise_id='145' limit 0,1 |
0.013066053390503 |
69 |
SELECT cruise_destination_id,country_id,city_id FROM default_cruise_destination WHERE lang_id='fr' and is_trash=0 and cruise_id='144' order by order_no asc Limit 0,1 |
0.012293100357056 |
70 |
SELECT title,slug FROM default_city WHERE city_id='751' |
0.0026271343231201 |
71 |
SELECT * FROM default_cruise_destination WHERE lang_id='fr' and is_trash=0 and cruise_id='144' order by order_no asc |
0.0079329013824463 |
72 |
SELECT title,slug FROM default_city WHERE city_id='751' |
0.0038352012634277 |
73 |
SELECT title,slug FROM default_city WHERE city_id='768' |
0.0013070106506348 |
74 |
SELECT title,slug FROM default_city WHERE city_id='771' |
0.0049128532409668 |
75 |
SELECT title,slug FROM default_city WHERE city_id='783' |
0.0027170181274414 |
76 |
SELECT MIN(min_price) as price FROM default_cruise_itinerary WHERE lang_id='fr' and is_trash=0 and is_online=1 and cruise_id='144' limit 0,1 |
0.0093529224395752 |
77 |
SELECT cruise_destination_id,country_id,city_id FROM default_cruise_destination WHERE lang_id='fr' and is_trash=0 and cruise_id='130' order by order_no asc Limit 0,1 |
0.012444972991943 |
78 |
SELECT title,slug FROM default_city WHERE city_id='757' |
0.0023109912872314 |
79 |
SELECT * FROM default_cruise_destination WHERE lang_id='fr' and is_trash=0 and cruise_id='130' order by order_no asc |
0.013689041137695 |
80 |
SELECT title,slug FROM default_city WHERE city_id='757' |
0.0013449192047119 |
81 |
SELECT title,slug FROM default_city WHERE city_id='766' |
0.0065269470214844 |
82 |
SELECT title,slug FROM default_city WHERE city_id='769' |
0.0039670467376709 |
83 |
SELECT title,slug FROM default_city WHERE city_id='782' |
0.0027642250061035 |
84 |
SELECT MIN(min_price) as price FROM default_cruise_itinerary WHERE lang_id='fr' and is_trash=0 and is_online=1 and cruise_id='130' limit 0,1 |
0.013232946395874 |
85 |
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.0058650970458984 |
86 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0038180351257324 |
87 |
SELECT blog_id,title,slug,publish_date,intro,image FROM default_blog WHERE lang_id='fr' and is_trash=0 and is_approve=1 and is_online=1 order by order_no ASC LIMIT 0,4 |
0.1502799987793 |
88 |
SELECT intro FROM default_blog WHERE blog_id='97' |
0.0044510364532471 |
89 |
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.010967969894409 |
90 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0028319358825684 |
91 |
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.011546850204468 |
92 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0043878555297852 |
93 |
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.007990837097168 |
94 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0039360523223877 |
95 |
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.0078990459442139 |
96 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0039157867431641 |
97 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.0038411617279053 |
98 |
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.0079760551452637 |
99 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0025620460510254 |