| 1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog' |
0.032434940338135 |
| 2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.023331880569458 |
| 3 |
SELECT country_id,title,slug,intro,image FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC |
0.016196012496948 |
| 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.036550998687744 |
| 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.06259298324585 |
| 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.16249322891235 |
| 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.024045944213867 |
| 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.04376482963562 |
| 9 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORAGETYPE' order by order_no ASC limit 0,1 |
0.0079600811004639 |
| 10 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORHEIGHTTYPE' order by order_no ASC limit 0,1 |
0.0071268081665039 |
| 11 |
SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1 |
0.068748950958252 |
| 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.029247999191284 |
| 13 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.041867017745972 |
| 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.0047509670257568 |
| 15 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0031440258026123 |
| 16 |
SELECT guidecat_id,slug,title FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC |
0.10385584831238 |
| 17 |
SELECT blog_id FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 |
0.24006080627441 |
| 18 |
SELECT blog_id,cat_id,reg_date,publish_date,upd_date,author,list_tag_id,intro,title,slug,image FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 order by order_no ASC LIMIT 16,8 |
0.011398077011108 |
| 19 |
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.001025915145874 |
| 20 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0001990795135498 |
| 21 |
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.037076950073242 |
| 22 |
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/&page=3' or config_link='/blog/&page=3') limit 1 |
0.035747051239014 |
| 23 |
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.0013191699981689 |
| 24 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020599365234375 |
| 25 |
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.00082302093505859 |
| 26 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017714500427246 |
| 27 |
SELECT slug FROM default_country WHERE country_id='67' |
0.00022006034851074 |
| 28 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.024214029312134 |
| 29 |
SELECT slug FROM default_country WHERE country_id='67' |
0.00027990341186523 |
| 30 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00022101402282715 |
| 31 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0014059543609619 |
| 32 |
SELECT slug FROM default_country WHERE country_id='1' |
0.0036220550537109 |
| 33 |
SELECT slug FROM default_country WHERE country_id='3' |
0.003058910369873 |
| 34 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0048480033874512 |
| 35 |
SELECT slug FROM default_country WHERE country_id='3' |
0.0019958019256592 |
| 36 |
SELECT slug FROM default_country WHERE country_id='7' |
0.0058469772338867 |
| 37 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.00091195106506348 |
| 38 |
SELECT slug FROM default_country WHERE country_id='7' |
0.0064339637756348 |
| 39 |
SELECT slug FROM default_country WHERE country_id='64' |
0.004533052444458 |
| 40 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0020899772644043 |
| 41 |
SELECT slug FROM default_country WHERE country_id='64' |
0.0058419704437256 |
| 42 |
SELECT slug FROM default_country WHERE country_id='65' |
0.0010991096496582 |
| 43 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0018458366394043 |
| 44 |
SELECT slug FROM default_country WHERE country_id='65' |
0.0047829151153564 |
| 45 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='30' or list_cat_id like '%|30|%') |
0.0040619373321533 |
| 46 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='20' or list_cat_id like '%|20|%') |
0.0033159255981445 |
| 47 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='19' or list_cat_id like '%|19|%') |
0.0045709609985352 |
| 48 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='18' or list_cat_id like '%|18|%') |
0.002734899520874 |
| 49 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='17' or list_cat_id like '%|17|%') |
0.0052149295806885 |
| 50 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='16' or list_cat_id like '%|16|%') |
0.0021941661834717 |
| 51 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='21' or list_cat_id like '%|21|%') |
0.0057220458984375 |
| 52 |
SELECT title FROM default_region WHERE region_id='' |
0.017838954925537 |
| 53 |
SELECT slug FROM default_blog WHERE blog_id='40' |
0.0011019706726074 |
| 54 |
SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/b40-lan-ha-bay-cat-ba-island.html' |
0.0087869167327881 |
| 55 |
SELECT distinct image FROM default_blog where blog_id=40 LIMIT 0,1 |
0.0027740001678467 |
| 56 |
SELECT slug FROM default_blog WHERE blog_id='43' |
0.0044550895690918 |
| 57 |
SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/b43-the-five-hs-to-have-in-your-vietnam-itinerary.html' |
0.011176109313965 |
| 58 |
SELECT distinct image FROM default_blog where blog_id=43 LIMIT 0,1 |
0.0047571659088135 |
| 59 |
SELECT slug FROM default_blog WHERE blog_id='47' |
0.002202033996582 |
| 60 |
SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/b47-vietnam-renews-visa-waiver-program-for-europeans.html' |
0.01828408241272 |
| 61 |
SELECT distinct image FROM default_blog where blog_id=47 LIMIT 0,1 |
0.00020313262939453 |
| 62 |
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.0034229755401611 |
| 63 |
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.0021100044250488 |
| 64 |
SELECT tag_id FROM default_tag WHERE lang_id='' and tag_id IN (SELECT tag_id FROM default_tag_module WHERE 1=1 and type='BLOG') |
0.07622218132019 |
| 65 |
SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='57' |
0.00036406517028809 |
| 66 |
SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='58' |
0.00019502639770508 |
| 67 |
SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='59' |
0.00017786026000977 |
| 68 |
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.031425952911377 |
| 69 |
SELECT hotel_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='hotel' and hotel_id IN (SELECT hotel_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no ASC |
0.0092999935150146 |
| 70 |
SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='category' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0092940330505371 |
| 71 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0061540603637695 |
| 72 |
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.0012907981872559 |
| 73 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020003318786621 |
| 74 |
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.0011210441589355 |
| 75 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00019693374633789 |
| 76 |
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.00081300735473633 |
| 77 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016903877258301 |
| 78 |
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.00079679489135742 |
| 79 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016999244689941 |
| 80 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0001680850982666 |
| 81 |
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.00080609321594238 |
| 82 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017285346984863 |
