1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour_new' |
0.0005638599395752 |
2 |
SELECT COUNT(*) AS totalitem FROM default_module WHERE site='FRONTPAGE' and name='tour' |
0.00014805793762207 |
3 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.00023007392883301 |
4 |
SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc |
0.0010840892791748 |
5 |
SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1 |
8.8930130004883E-5 |
6 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0011780261993408 |
7 |
SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1 |
8.9883804321289E-5 |
8 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0011258125305176 |
9 |
SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1 |
8.392333984375E-5 |
10 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0010960102081299 |
11 |
SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1 |
8.2015991210938E-5 |
12 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0010559558868408 |
13 |
SELECT continent_id,title,slug FROM default_continent WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc |
0.0010550022125244 |
14 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='3' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0010170936584473 |
15 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='4' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0010550022125244 |
16 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='5' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00095486640930176 |
17 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='6' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00099301338195801 |
18 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='7' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.000946044921875 |
19 |
SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=477 order by order_no asc |
0.00084614753723145 |
20 |
SELECT servicecat_id,title,slug,intro,image FROM default_servicecat WHERE lang_id='vn' and is_trash=0 and is_online=1 and servicecat_id IN (7,8,9,10) |
0.001025915145874 |
21 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00041508674621582 |
22 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.2983245849609E-5 |
23 |
SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.00094890594482422 |
24 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='vn' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3 |
0.00090217590332031 |
25 |
SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1 |
9.4890594482422E-5 |
26 |
SELECT feature_package_id 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.00029206275939941 |
27 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
7.319450378418E-5 |
28 |
SELECT feature_package_id 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.00033998489379883 |
29 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
6.8187713623047E-5 |
30 |
SELECT country_id,title FROM _country WHERE 1=1 and is_trash=0 order by order_no ASC |
0.0025360584259033 |
31 |
SELECT faq_id,title,content FROM default_faq WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc limit 0,4 |
0.0044519901275635 |
32 |
SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.0011091232299805 |
33 |
SELECT feature_package_id 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.00040698051452637 |
34 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.5129013061523E-5 |
35 |
SELECT page_id,title,slug FROM default_page WHERE lang_id='vn' and is_trash=0 and is_online=1 and page_id <>'2' order by order_no asc |
0.0010380744934082 |
36 |
SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='vn' and (config_link='/lien-he.html' or config_link='/lien-he.html') limit 1 |
0.0010719299316406 |
37 |
SELECT feature_package_id 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.00037693977355957 |
38 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.0122222900391E-5 |
39 |
SELECT feature_package_id 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.00035500526428223 |
40 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.5844268798828E-5 |
41 |
SELECT feature_package_id 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.00033688545227051 |
42 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
7.9154968261719E-5 |
43 |
SELECT feature_package_id 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.0003819465637207 |
44 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
7.7962875366211E-5 |
45 |
SELECT slug FROM default_servicecat WHERE servicecat_id='10' |
0.00012516975402832 |
46 |
SELECT title FROM default_servicecat WHERE servicecat_id='10' |
0.00010204315185547 |
47 |
SELECT title FROM default_servicecat WHERE servicecat_id='10' |
7.1048736572266E-5 |
48 |
SELECT feature_package_id 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.00056314468383789 |
49 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00010299682617188 |
50 |
SELECT feature_package_id 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.00042414665222168 |
51 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.2969665527344E-5 |
52 |
SELECT feature_package_id 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.0003058910369873 |
53 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
7.9154968261719E-5 |
54 |
SELECT feature_package_id 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.00055289268493652 |
55 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.2983245849609E-5 |
56 |
SELECT feature_package_id 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.00050902366638184 |
57 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.5115432739258E-5 |
58 |
SELECT feature_package_id 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.00038480758666992 |
59 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.0108642578125E-5 |