| 1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog' |
0.014180898666382 |
| 2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.00039815902709961 |
| 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.0023930072784424 |
| 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.063786029815674 |
| 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.0023260116577148 |
| 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.0022249221801758 |
| 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.026175975799561 |
| 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.043483018875122 |
| 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.0022940635681152 |
| 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.0019989013671875 |
| 11 |
SELECT distinct short FROM default_property where property_id=952 LIMIT 0,1 |
0.00031590461730957 |
| 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.023623943328857 |
| 13 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.023760080337524 |
| 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.0012798309326172 |
| 15 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00021791458129883 |
| 16 |
SELECT blog_id FROM default_blog WHERE lang_id='fr' and is_trash=0 and is_online=1 and blog_id='48' and slug='choisir-votre-jonque-dans-la-baie-dhalong' |
0.002140998840332 |
| 17 |
SELECT cat_id,title,publish_date,upd_date,author,image,list_tag_id,author,intro,content,slug,intro FROM default_blog WHERE blog_id='48' |
0.00039505958557129 |
| 18 |
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.001072883605957 |
| 19 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020003318786621 |
| 20 |
SELECT blog_id,title,slug FROM default_blog WHERE lang_id='fr' and is_trash=0 and is_approve=1 and is_online=1 and blog_id <> '48' and cat_id='22' order by order_no desc limit 0,5 |
0.0054800510406494 |
| 21 |
SELECT meta_id,image FROM default_meta WHERE lang_id='fr' and config_link='/fr/b48-choisir-votre-jonque-dans-la-baie-dhalong.html' |
0.021040916442871 |
| 22 |
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.0033950805664062 |
| 23 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00024509429931641 |
| 24 |
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.0022039413452148 |
| 25 |
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/b48-choisir-votre-jonque-dans-la-baie-dhalong.html' or config_link='/fr/b48-choisir-votre-jonque-dans-la-baie-dhalong.html') limit 1 |
0.0060231685638428 |
| 26 |
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.0018160343170166 |
| 27 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0010390281677246 |
| 28 |
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.0018010139465332 |
| 29 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0011651515960693 |
| 30 |
SELECT slug FROM default_country WHERE country_id='5' |
0.00025010108947754 |
| 31 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00085210800170898 |
| 32 |
SELECT slug FROM default_country WHERE country_id='5' |
0.0011191368103027 |
| 33 |
SELECT slug FROM default_country WHERE country_id='11' |
0.0014932155609131 |
| 34 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.011827945709229 |
| 35 |
SELECT slug FROM default_country WHERE country_id='11' |
0.0001530647277832 |
| 36 |
SELECT slug FROM default_country WHERE country_id='12' |
0.00084304809570312 |
| 37 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00013399124145508 |
| 38 |
SELECT slug FROM default_country WHERE country_id='12' |
0.00020813941955566 |
| 39 |
SELECT slug FROM default_country WHERE country_id='13' |
0.00020098686218262 |
| 40 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00018000602722168 |
| 41 |
SELECT slug FROM default_country WHERE country_id='13' |
0.00019288063049316 |
| 42 |
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.00050497055053711 |
| 43 |
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.00039291381835938 |
| 44 |
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.00038599967956543 |
| 45 |
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.00039219856262207 |
| 46 |
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.00037598609924316 |
| 47 |
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.00037598609924316 |
| 48 |
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.00037217140197754 |
| 49 |
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.00038504600524902 |
| 50 |
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.00038003921508789 |
| 51 |
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.00037384033203125 |
| 52 |
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.0003819465637207 |
| 53 |
SELECT title,slug FROM default_blogcat WHERE blogcat_id='22' |
0.00049209594726562 |
| 54 |
SELECT meta_id,image FROM default_meta WHERE lang_id='fr' and config_link='/fr/b48-choisir-votre-jonque-dans-la-baie-dhalong.html' |
0.0019760131835938 |
| 55 |
SELECT blogcat_id, title,slug FROM default_blogcat WHERE lang_id='fr' and is_trash=0 and is_online=1 order by order_no asc |
0.0024302005767822 |
| 56 |
SELECT blog_id,slug,title FROM default_blog WHERE lang_id='fr' 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.0020959377288818 |
| 57 |
SELECT tag_id FROM default_tag WHERE lang_id='fr' and tag_id IN (SELECT tag_id FROM default_tag_module WHERE 1=1 and type='BLOG') |
0.010579109191895 |
| 58 |
SELECT blog_extension_id,tour_id FROM default_blog_extension WHERE lang_id='fr' and blog_id = '48' 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.0025320053100586 |
| 59 |
SELECT hotel_id FROM default_blog_extension WHERE lang_id='fr' and blog_id = '48' 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.0020930767059326 |
| 60 |
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.0011389255523682 |
| 61 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0002131462097168 |
| 62 |
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.0012500286102295 |
| 63 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020003318786621 |
| 64 |
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.0011098384857178 |
| 65 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020503997802734 |
| 66 |
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.0023519992828369 |
| 67 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018191337585449 |
| 68 |
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.0009009838104248 |
| 69 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016880035400391 |
| 70 |
SELECT slug FROM default_blogcat WHERE blogcat_id='22' |
0.00016403198242188 |
| 71 |
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.00082802772521973 |
| 72 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017595291137695 |
