1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour' |
0.0012681484222412 |
2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.00031089782714844 |
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.006882905960083 |
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.0026528835296631 |
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.0020990371704102 |
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.0021460056304932 |
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.0020489692687988 |
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.0024549961090088 |
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.0018398761749268 |
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.0019190311431885 |
11 |
SELECT distinct short FROM default_property where property_id=952 LIMIT 0,1 |
0.00024819374084473 |
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.0010030269622803 |
13 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00028300285339355 |
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.00092411041259766 |
15 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0001990795135498 |
16 |
SELECT tourcat_id,slug,title,intro FROM default_tour_category WHERE tourcat_id='29' |
0.00049901008605957 |
17 |
SELECT tourcat_id FROM default_tour_category WHERE lang_id='fr' and is_trash=0 and is_online=1 and parent_id='29' |
0.0021250247955322 |
18 |
SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='fr' and is_trash=0 and is_online=1 and (cat_id='29' or list_cat_id like '%|29|%') |
0.0020091533660889 |
19 |
SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='fr' and is_trash=0 and is_online=1 and (cat_id='29' or list_cat_id like '%|29|%') |
0.0021810531616211 |
20 |
SELECT tour_id FROM default_tour WHERE lang_id='fr' and is_trash=0 and is_online=1 and (cat_id='29' or list_cat_id like '%|29|%') |
0.0020501613616943 |
21 |
SELECT slug FROM default_tour_category WHERE tourcat_id='29' |
0.00017285346984863 |
22 |
SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE lang_id='fr' and is_trash=0 and is_online=1 and (cat_id='29' or list_cat_id like '%|29|%') order by order_no ASC LIMIT 0,15 |
0.0020320415496826 |
23 |
SELECT category_country_id,content FROM default_category_country WHERE lang_id='fr' and is_trash=0 and is_online=1 and cat_id='29' and country_id = '' limit 0,1 |
0.011239051818848 |
24 |
SELECT meta_id,image FROM default_meta WHERE lang_id='fr' and config_link='/fr/tours/exploratrice-c29' |
0.002363920211792 |
25 |
SELECT distinct image FROM default_tour_category where tourcat_id=29 LIMIT 0,1 |
0.00021100044250488 |
26 |
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.0021770000457764 |
27 |
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/tours/exploratrice-c29' or config_link='/fr/tours/exploratrice-c29') limit 1 |
0.0019659996032715 |
28 |
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.0011551380157471 |
29 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00022506713867188 |
30 |
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.00082683563232422 |
31 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00021195411682129 |
32 |
SELECT slug FROM default_country WHERE country_id='5' |
0.00030398368835449 |
33 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00024795532226562 |
34 |
SELECT slug FROM default_country WHERE country_id='5' |
0.00016498565673828 |
35 |
SELECT slug FROM default_country WHERE country_id='11' |
0.00022006034851074 |
36 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00026798248291016 |
37 |
SELECT slug FROM default_country WHERE country_id='11' |
0.00017189979553223 |
38 |
SELECT slug FROM default_country WHERE country_id='12' |
0.00019693374633789 |
39 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00020480155944824 |
40 |
SELECT slug FROM default_country WHERE country_id='12' |
0.0001988410949707 |
41 |
SELECT slug FROM default_country WHERE country_id='13' |
0.00014185905456543 |
42 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00014686584472656 |
43 |
SELECT slug FROM default_country WHERE country_id='13' |
0.00014185905456543 |
44 |
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.00053691864013672 |
45 |
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.00040698051452637 |
46 |
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.00040197372436523 |
47 |
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.00040984153747559 |
48 |
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.00040292739868164 |
49 |
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.00042891502380371 |
50 |
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.00041294097900391 |
51 |
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.00042009353637695 |
52 |
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.00040698051452637 |
53 |
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.00041007995605469 |
54 |
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.00040102005004883 |
55 |
SELECT title,slug FROM default_country WHERE country_id='' |
0.00049400329589844 |
56 |
SELECT title FROM default_country WHERE country_id='' |
0.00019216537475586 |
57 |
SELECT image_banner FROM default_tour_category WHERE tourcat_id='29' |
0.00022101402282715 |
58 |
SELECT image_banner FROM default_tour_category WHERE tourcat_id='29' |
0.00022792816162109 |
59 |
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.0013539791107178 |
60 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00022196769714355 |
61 |
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.0024929046630859 |
62 |
SELECT intro FROM default_blog WHERE blog_id='97' |
0.0002439022064209 |
63 |
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.0014028549194336 |
64 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020694732666016 |
65 |
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.0011491775512695 |
66 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00021100044250488 |
67 |
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.00092911720275879 |
68 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018596649169922 |
69 |
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.0008549690246582 |
70 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017786026000977 |
71 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00017786026000977 |
72 |
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.00085592269897461 |
73 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017905235290527 |