Contenido exclusivo de una agencia de viajes en Cancún

Highway improvement projects are underway in Cancun

Four major highway improvement projects are underway in Cancun. A traffic interchange is being built in the vicinity of the airport; Lu...

Jorge Pat en julio 29, 2022

3 minutos de lectura

Dinner & Show Cancun

Take advantage of our February´s Couple special promotions Pirate Show. Dinner. Are you ready for the most ...

Jorge Pat en enero 28, 2021

1 minuto de lectura

How much is the entrance To Chichen Itza?

According the situation by Covid-19 in Yucatan state the archeological site of Chichen Itza is open Monday to Sunday from 08:00 to 17:00 ...

Jorge Pat en enero 24, 2021

2 minutos de lectura

Safe,Trusted and worry free vacations

Make your vacations unforgettable, void trusting street vendors For Thomas More Travel your safety is number one, with ove...

Jorge Pat en enero 21, 2021

1 minuto de lectura

Buscar

3 minutos de lectura

Transportación

Jorge Pat en julio 29, 2022

Highway improvement projects are underway in Cancun

Four major highway improvement projects are underway in Cancun. A traffic interchange is being built in the vicinity of the airport; Lu...

Seguir leyendo

1 minuto de lectura

Transportación Royal Resorts

Johan Medina en junio 05, 2020

Our new promotion

Our new private service, with all our new guidelines and safety measures. From $ 32.00 USD (Cancun) $ 59.70 USD (Royal Hacien...

Seguir leyendo

2 minutos de lectura

Aventura Arqueología Transportación

Johan Medina en abril 17, 2020

A word from you, our loyal friend

In this times of stress and worry, we share the experience of two of our long clients and friends, we hope that you and your family stay ...

Seguir leyendo

1 minuto de lectura

Transportación

Johan Medina en febrero 23, 2020

Last week of our Winter Promotion!

Winter Sale's Last Week! Book your Private Service and get 10% off + 20% off snorkeling tour! Use Promo Code for Cancun: CUN001 Fo...

Seguir leyendo

1 minuto de lectura

Transportación

Johan Medina en noviembre 20, 2019

Holiday Offers

We have to offers for this Holiday season: 10% OFF PRIVATE SERVICE + 20% OFF SNORKELING TOUR + FREE CITY TOUR! From December 17 to Ma...

Seguir leyendo

1 minuto de lectura

Transportación Royal Resorts

Johan Medina en agosto 15, 2019

Transfer Autumn Promotion

We have extended our promotion, we have our Private Services Arrivals from September 01 to December 16, 2019 , you can get a 10% discount...

Seguir leyendo

2 minutos de lectura

Transportación Royal Resorts

Johan Medina en julio 12, 2019

Beware of Pirate Services

When you arrive at the airport, make sure that the services you take are 100% from Thomas More Travel, our staff is ready to help you. ...

Seguir leyendo

1 minuto de lectura

Transportación Royal Resorts

Johan Medina en junio 26, 2019

Summer Special!

For this summer season, we have our Private Services from July 01 to August 31, 2019 with 10% discounts and a free City Tour. This are...

Seguir leyendo

(default) 31 queries took 10 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Configuration`.`key`, `Configuration`.`value` FROM `tmdb`.`configurations` AS `Configuration` WHERE 1 = 1	44	44	1
2	SELECT `WebPageSeo`.`id`, `WebPageSeo`.`key`, `WebPageSeo`.`es_name`, `WebPageSeo`.`en_name`, `WebPageSeo`.`es_title`, `WebPageSeo`.`en_title`, `WebPageSeo`.`es_description`, `WebPageSeo`.`en_description`, `WebPageSeo`.`es_meta`, `WebPageSeo`.`en_meta`, `WebPageSeo`.`es_header_code`, `WebPageSeo`.`en_header_code`, `WebPageSeo`.`es_footer_code`, `WebPageSeo`.`en_footer_code`, `WebPageSeo`.`created`, `WebPageSeo`.`modified`, `MediaImage`.`id`, `MediaImage`.`name`, `MediaImage`.`title`, `MediaImage`.`subtitle`, `MediaImage`.`alt`, `MediaImage`.`share_key`, `MediaImage`.`extra`, `MediaImage`.`type`, `MediaImage`.`model`, `MediaImage`.`foreign_key`, `MediaImage`.`collection`, `MediaImage`.`order`, `MediaImage`.`key`, `MediaImage`.`source`, `MediaImage`.`source_format`, `MediaImage`.`format`, `MediaImage`.`width`, `MediaImage`.`height`, `MediaImage`.`size`, `MediaImage`.`length`, `MediaImage`.`public`, `MediaImage`.`main`, `MediaImage`.`shared`, `MediaImage`.`is_file`, `MediaImage`.`created`, `MediaImage`.`modified` FROM `tmdb`.`web_page_seos` AS `WebPageSeo` LEFT JOIN `tmdb`.`media` AS `MediaImage` ON (`MediaImage`.`foreign_key` = `WebPageSeo`.`id` AND `MediaImage`.`model` = 'WebPageSeo' AND `MediaImage`.`collection` = 'image') WHERE 1 = 1 ORDER BY `WebPageSeo`.`es_name` ASC	7	7	1
3	SELECT `TourCategory`.`slug`, `TourCategory`.`name`, `TourCategory`.`special_offer` FROM `tmdb`.`tour_categories` AS `TourCategory` WHERE `TourCategory`.`active` = '1' AND ((`TourCategory`.`active_tours` > 0) OR (`TourCategory`.`rel_active_tours` > 0)) ORDER BY `TourCategory`.`order` ASC	9	9	0
4	SELECT `BlogPost`.`id` FROM `tmdb`.`blog_posts_blog_categories` AS `BlogPostsBlogCategory` LEFT JOIN `tmdb`.`blog_posts` AS `BlogPost` ON (`BlogPostsBlogCategory`.`blog_post_id` = `BlogPost`.`id`) WHERE `BlogPostsBlogCategory`.`blog_category_id` = 5	8	8	1
5	SELECT COUNT(*) AS `count` FROM `tmdb`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) AND `BlogPost`.`id` IN (57, 43, 40, 37, 30, 27, 28, 45)	1	1	1
6	SELECT `BlogPost`.`id`, `BlogPost`.`name`, `BlogPost`.`en_name`, `BlogPost`.`subtitle`, `BlogPost`.`en_subtitle`, `BlogPost`.`synthesis`, `BlogPost`.`en_synthesis`, `BlogPost`.`description`, `BlogPost`.`en_description`, `BlogPost`.`author`, `BlogPost`.`instagram`, `BlogPost`.`publication_date`, `BlogPost`.`publication_time`, `BlogPost`.`active`, `BlogPost`.`main`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`slug`, `BlogPost`.`slug_en`, (DATE_FORMAT(`BlogPost`.`created`, "%d/%m/%y %H:%i")) AS `BlogPost__display_created`, (DATE_FORMAT(CONCAT(`BlogPost`.`publication_date`, " ", `BlogPost`.`publication_time`), "%d/%m/%y %H:%i")) AS `BlogPost__display_publication`, (DATE_FORMAT(`BlogPost`.`publication_date`, "%d/%m/%y")) AS `BlogPost__display_publication_date`, (`BlogPost`.`publication_date`) AS `BlogPost__publication_date_raw`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified` FROM `tmdb`.`blog_posts` AS `BlogPost` LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `BlogPost`.`id` AND `MediaCover`.`model` = 'BlogPost' AND `MediaCover`.`collection` = 'cover') WHERE `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) AND `BlogPost`.`id` IN (57, 43, 40, 37, 30, 27, 28, 45) ORDER BY `BlogPost`.`publication_date` DESC, `BlogPost`.`publication_time` DESC LIMIT 12	8	8	1
7	SELECT `BlogPostsBlogCategory`.`id`, `BlogPostsBlogCategory`.`blog_post_id`, `BlogPostsBlogCategory`.`blog_category_id`, `BlogPostsBlogCategory`.`created`, `BlogPostsBlogCategory`.`modified` FROM `tmdb`.`blog_posts_blog_categories` AS `BlogPostsBlogCategory` WHERE `BlogPostsBlogCategory`.`blog_post_id` IN (57, 45, 43, 40, 37, 30, 28, 27)	14	14	0
8	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
9	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 1	1	1	0
10	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 2	1	1	0
11	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
12	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
13	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
14	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
15	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 6	1	1	0
16	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
17	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 6	1	1	0
18	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
19	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 6	1	1	0
20	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
21	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 6	1	1	0
22	SELECT `BlogPost`.`id`, `BlogPost`.`name`, `BlogPost`.`en_name`, `BlogPost`.`subtitle`, `BlogPost`.`en_subtitle`, `BlogPost`.`synthesis`, `BlogPost`.`en_synthesis`, `BlogPost`.`description`, `BlogPost`.`en_description`, `BlogPost`.`author`, `BlogPost`.`instagram`, `BlogPost`.`publication_date`, `BlogPost`.`publication_time`, `BlogPost`.`active`, `BlogPost`.`main`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`slug`, `BlogPost`.`slug_en`, (DATE_FORMAT(`BlogPost`.`created`, "%d/%m/%y %H:%i")) AS `BlogPost__display_created`, (DATE_FORMAT(CONCAT(`BlogPost`.`publication_date`, " ", `BlogPost`.`publication_time`), "%d/%m/%y %H:%i")) AS `BlogPost__display_publication`, (DATE_FORMAT(`BlogPost`.`publication_date`, "%d/%m/%y")) AS `BlogPost__display_publication_date`, (`BlogPost`.`publication_date`) AS `BlogPost__publication_date_raw`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified` FROM `tmdb`.`blog_posts` AS `BlogPost` LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `BlogPost`.`id` AND `MediaCover`.`model` = 'BlogPost' AND `MediaCover`.`collection` = 'cover') WHERE `BlogPost`.`id` NOT IN (57, 45, 43, 40, 37, 30, 28, 27) AND `BlogPost`.`active` = '1' ORDER BY RAND() ASC	48	48	4
23	SELECT `BlogPost`.`id`, `BlogPost`.`name`, `BlogPost`.`en_name`, `BlogPost`.`subtitle`, `BlogPost`.`en_subtitle`, `BlogPost`.`synthesis`, `BlogPost`.`en_synthesis`, `BlogPost`.`description`, `BlogPost`.`en_description`, `BlogPost`.`author`, `BlogPost`.`instagram`, `BlogPost`.`publication_date`, `BlogPost`.`publication_time`, `BlogPost`.`active`, `BlogPost`.`main`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`slug`, `BlogPost`.`slug_en`, (DATE_FORMAT(`BlogPost`.`created`, "%d/%m/%y %H:%i")) AS `BlogPost__display_created`, (DATE_FORMAT(CONCAT(`BlogPost`.`publication_date`, " ", `BlogPost`.`publication_time`), "%d/%m/%y %H:%i")) AS `BlogPost__display_publication`, (DATE_FORMAT(`BlogPost`.`publication_date`, "%d/%m/%y")) AS `BlogPost__display_publication_date`, (`BlogPost`.`publication_date`) AS `BlogPost__publication_date_raw`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified` FROM `tmdb`.`blog_posts` AS `BlogPost` LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `BlogPost`.`id` AND `MediaCover`.`model` = 'BlogPost' AND `MediaCover`.`collection` = 'cover') WHERE `BlogPost`.`main` = '1' AND `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) ORDER BY `BlogPost`.`publication_date` DESC, `BlogPost`.`publication_time` DESC LIMIT 4	4	4	1
24	SELECT `BlogPostsBlogCategory`.`id`, `BlogPostsBlogCategory`.`blog_post_id`, `BlogPostsBlogCategory`.`blog_category_id`, `BlogPostsBlogCategory`.`created`, `BlogPostsBlogCategory`.`modified` FROM `tmdb`.`blog_posts_blog_categories` AS `BlogPostsBlogCategory` WHERE `BlogPostsBlogCategory`.`blog_post_id` IN (57, 56, 55, 54)	6	6	0
25	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 6	1	1	0
26	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 8	1	1	0
27	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 2	1	1	0
28	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 8	1	1	0
29	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 9	1	1	0
30	SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5	1	1	0
31	SELECT `BlogCategory`.`id`, `BlogCategory`.`name` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`active_posts` > 0	7	7	0

(default) 31 queries took 10 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Configuration`.`key`, `Configuration`.`value` FROM `tmdb`.`configurations` AS `Configuration` WHERE 1 = 1

SELECT `WebPageSeo`.`id`, `WebPageSeo`.`key`, `WebPageSeo`.`es_name`, `WebPageSeo`.`en_name`, `WebPageSeo`.`es_title`, `WebPageSeo`.`en_title`, `WebPageSeo`.`es_description`, `WebPageSeo`.`en_description`, `WebPageSeo`.`es_meta`, `WebPageSeo`.`en_meta`, `WebPageSeo`.`es_header_code`, `WebPageSeo`.`en_header_code`, `WebPageSeo`.`es_footer_code`, `WebPageSeo`.`en_footer_code`, `WebPageSeo`.`created`, `WebPageSeo`.`modified`, `MediaImage`.`id`, `MediaImage`.`name`, `MediaImage`.`title`, `MediaImage`.`subtitle`, `MediaImage`.`alt`, `MediaImage`.`share_key`, `MediaImage`.`extra`, `MediaImage`.`type`, `MediaImage`.`model`, `MediaImage`.`foreign_key`, `MediaImage`.`collection`, `MediaImage`.`order`, `MediaImage`.`key`, `MediaImage`.`source`, `MediaImage`.`source_format`, `MediaImage`.`format`, `MediaImage`.`width`, `MediaImage`.`height`, `MediaImage`.`size`, `MediaImage`.`length`, `MediaImage`.`public`, `MediaImage`.`main`, `MediaImage`.`shared`, `MediaImage`.`is_file`, `MediaImage`.`created`, `MediaImage`.`modified` FROM `tmdb`.`web_page_seos` AS `WebPageSeo` LEFT JOIN `tmdb`.`media` AS `MediaImage` ON (`MediaImage`.`foreign_key` = `WebPageSeo`.`id` AND `MediaImage`.`model` = 'WebPageSeo' AND `MediaImage`.`collection` = 'image') WHERE 1 = 1 ORDER BY `WebPageSeo`.`es_name` ASC

SELECT `TourCategory`.`slug`, `TourCategory`.`name`, `TourCategory`.`special_offer` FROM `tmdb`.`tour_categories` AS `TourCategory` WHERE `TourCategory`.`active` = '1' AND ((`TourCategory`.`active_tours` > 0) OR (`TourCategory`.`rel_active_tours` > 0)) ORDER BY `TourCategory`.`order` ASC

SELECT `BlogPost`.`id` FROM `tmdb`.`blog_posts_blog_categories` AS `BlogPostsBlogCategory` LEFT JOIN `tmdb`.`blog_posts` AS `BlogPost` ON (`BlogPostsBlogCategory`.`blog_post_id` = `BlogPost`.`id`) WHERE `BlogPostsBlogCategory`.`blog_category_id` = 5

SELECT COUNT(*) AS `count` FROM `tmdb`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) AND `BlogPost`.`id` IN (57, 43, 40, 37, 30, 27, 28, 45)

SELECT `BlogPost`.`id`, `BlogPost`.`name`, `BlogPost`.`en_name`, `BlogPost`.`subtitle`, `BlogPost`.`en_subtitle`, `BlogPost`.`synthesis`, `BlogPost`.`en_synthesis`, `BlogPost`.`description`, `BlogPost`.`en_description`, `BlogPost`.`author`, `BlogPost`.`instagram`, `BlogPost`.`publication_date`, `BlogPost`.`publication_time`, `BlogPost`.`active`, `BlogPost`.`main`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`slug`, `BlogPost`.`slug_en`, (DATE_FORMAT(`BlogPost`.`created`, "%d/%m/%y %H:%i")) AS `BlogPost__display_created`, (DATE_FORMAT(CONCAT(`BlogPost`.`publication_date`, " ", `BlogPost`.`publication_time`), "%d/%m/%y %H:%i")) AS `BlogPost__display_publication`, (DATE_FORMAT(`BlogPost`.`publication_date`, "%d/%m/%y")) AS `BlogPost__display_publication_date`, (`BlogPost`.`publication_date`) AS `BlogPost__publication_date_raw`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified` FROM `tmdb`.`blog_posts` AS `BlogPost` LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `BlogPost`.`id` AND `MediaCover`.`model` = 'BlogPost' AND `MediaCover`.`collection` = 'cover') WHERE `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) AND `BlogPost`.`id` IN (57, 43, 40, 37, 30, 27, 28, 45) ORDER BY `BlogPost`.`publication_date` DESC, `BlogPost`.`publication_time` DESC LIMIT 12

SELECT `BlogPostsBlogCategory`.`id`, `BlogPostsBlogCategory`.`blog_post_id`, `BlogPostsBlogCategory`.`blog_category_id`, `BlogPostsBlogCategory`.`created`, `BlogPostsBlogCategory`.`modified` FROM `tmdb`.`blog_posts_blog_categories` AS `BlogPostsBlogCategory` WHERE `BlogPostsBlogCategory`.`blog_post_id` IN (57, 45, 43, 40, 37, 30, 28, 27)

SELECT `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`name_en`, `BlogCategory`.`slug`, `BlogCategory`.`slug_en`, `BlogCategory`.`posts`, `BlogCategory`.`active_posts`, `BlogCategory`.`created`, `BlogCategory`.`modified`, (CONCAT(`BlogCategory`.`name`, " / ", `BlogCategory`.`name_en`)) AS `BlogCategory__set_name`, (CONCAT(`BlogCategory`.`active_posts`, " de ", `BlogCategory`.`posts`, " artículos activos")) AS `BlogCategory__set_posts`, (IF(`BlogCategory`.`posts` > 0, 0 , 1)) AS `BlogCategory__deletable` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`id` = 5

SELECT `BlogPost`.`id`, `BlogPost`.`name`, `BlogPost`.`en_name`, `BlogPost`.`subtitle`, `BlogPost`.`en_subtitle`, `BlogPost`.`synthesis`, `BlogPost`.`en_synthesis`, `BlogPost`.`description`, `BlogPost`.`en_description`, `BlogPost`.`author`, `BlogPost`.`instagram`, `BlogPost`.`publication_date`, `BlogPost`.`publication_time`, `BlogPost`.`active`, `BlogPost`.`main`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`slug`, `BlogPost`.`slug_en`, (DATE_FORMAT(`BlogPost`.`created`, "%d/%m/%y %H:%i")) AS `BlogPost__display_created`, (DATE_FORMAT(CONCAT(`BlogPost`.`publication_date`, " ", `BlogPost`.`publication_time`), "%d/%m/%y %H:%i")) AS `BlogPost__display_publication`, (DATE_FORMAT(`BlogPost`.`publication_date`, "%d/%m/%y")) AS `BlogPost__display_publication_date`, (`BlogPost`.`publication_date`) AS `BlogPost__publication_date_raw`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified` FROM `tmdb`.`blog_posts` AS `BlogPost` LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `BlogPost`.`id` AND `MediaCover`.`model` = 'BlogPost' AND `MediaCover`.`collection` = 'cover') WHERE `BlogPost`.`id` NOT IN (57, 45, 43, 40, 37, 30, 28, 27) AND `BlogPost`.`active` = '1' ORDER BY RAND() ASC

SELECT `BlogPost`.`id`, `BlogPost`.`name`, `BlogPost`.`en_name`, `BlogPost`.`subtitle`, `BlogPost`.`en_subtitle`, `BlogPost`.`synthesis`, `BlogPost`.`en_synthesis`, `BlogPost`.`description`, `BlogPost`.`en_description`, `BlogPost`.`author`, `BlogPost`.`instagram`, `BlogPost`.`publication_date`, `BlogPost`.`publication_time`, `BlogPost`.`active`, `BlogPost`.`main`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`slug`, `BlogPost`.`slug_en`, (DATE_FORMAT(`BlogPost`.`created`, "%d/%m/%y %H:%i")) AS `BlogPost__display_created`, (DATE_FORMAT(CONCAT(`BlogPost`.`publication_date`, " ", `BlogPost`.`publication_time`), "%d/%m/%y %H:%i")) AS `BlogPost__display_publication`, (DATE_FORMAT(`BlogPost`.`publication_date`, "%d/%m/%y")) AS `BlogPost__display_publication_date`, (`BlogPost`.`publication_date`) AS `BlogPost__publication_date_raw`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified` FROM `tmdb`.`blog_posts` AS `BlogPost` LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `BlogPost`.`id` AND `MediaCover`.`model` = 'BlogPost' AND `MediaCover`.`collection` = 'cover') WHERE `BlogPost`.`main` = '1' AND `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) ORDER BY `BlogPost`.`publication_date` DESC, `BlogPost`.`publication_time` DESC LIMIT 4

SELECT `BlogCategory`.`id`, `BlogCategory`.`name` FROM `tmdb`.`blog_categories` AS `BlogCategory` WHERE `BlogCategory`.`active_posts` > 0