For Thomas More Travel your safety is number one, with over years experience taking care about your transportation and tours when visiting Cancun and Riviera Maya.
Always following the highest quality standarts.
| Nr | Query | Error | 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 | 1 | |
| 4 | 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`.`slug` = 'safe-trusted-and-worry-free-vacations' AND `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) LIMIT 1 | 1 | 1 | 1 | |
| 5 | 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` = (54) | 2 | 2 | 0 | |
| 6 | 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 | |
| 7 | 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 | |
| 8 | 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` <> 54 AND `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) AND ((`BlogPost`.`publication_date` < '2021-01-21') OR (((`BlogPost`.`publication_date` = '2021-01-21') AND (`BlogPost`.`publication_time` <= '14:00:00')))) ORDER BY `BlogPost`.`publication_date` DESC, `BlogPost`.`publication_time` DESC LIMIT 1 | 1 | 1 | 1 | |
| 9 | 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` <> 54 AND `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) AND ((`BlogPost`.`publication_date` > '2021-01-21') OR (((`BlogPost`.`publication_date` = '2021-01-21') AND (`BlogPost`.`publication_time` >= '14:00:00')))) ORDER BY `BlogPost`.`publication_date` ASC, `BlogPost`.`publication_time` ASC LIMIT 1 | 1 | 1 | 1 | |
| 10 | 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` <> 54 AND `BlogPost`.`active` = '1' AND ((`BlogPost`.`publication_date` < DATE(NOW())) OR (((`BlogPost`.`publication_date` = DATE(NOW())) AND (`BlogPost`.`publication_time` <= TIME(NOW()))))) ORDER BY RAND() ASC LIMIT 3 | 3 | 3 | 2 | |
| 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`.`active_posts` > 0 ORDER BY `BlogCategory`.`active_posts` DESC | 7 | 7 | 0 | |
| 12 | SELECT `Banner`.`id`, `Banner`.`name`, `Banner`.`name_en`, `Banner`.`subtitle`, `Banner`.`subtitle_en`, `Banner`.`is_cta`, `Banner`.`cta`, `Banner`.`cta_en`, `Banner`.`controller`, `Banner`.`controller_action`, `Banner`.`controller_key`, `Banner`.`position`, `Banner`.`order`, `Banner`.`active`, `Banner`.`created`, `Banner`.`modified`, (CONCAT(`Banner`.`name`, " / ", `Banner`.`name_en`)) AS `Banner__set_name`, (CONCAT(`Banner`.`controller`, "/", `Banner`.`controller_action`, "/", IFNULL(`Banner`.`controller_key`, ""))) AS `Banner__action`, `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`, `MediaVideo`.`id`, `MediaVideo`.`name`, `MediaVideo`.`title`, `MediaVideo`.`subtitle`, `MediaVideo`.`alt`, `MediaVideo`.`share_key`, `MediaVideo`.`extra`, `MediaVideo`.`type`, `MediaVideo`.`model`, `MediaVideo`.`foreign_key`, `MediaVideo`.`collection`, `MediaVideo`.`order`, `MediaVideo`.`key`, `MediaVideo`.`source`, `MediaVideo`.`source_format`, `MediaVideo`.`format`, `MediaVideo`.`width`, `MediaVideo`.`height`, `MediaVideo`.`size`, `MediaVideo`.`length`, `MediaVideo`.`public`, `MediaVideo`.`main`, `MediaVideo`.`shared`, `MediaVideo`.`is_file`, `MediaVideo`.`created`, `MediaVideo`.`modified` FROM `tmdb`.`banners` AS `Banner` LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `Banner`.`id` AND `MediaCover`.`model` = 'Banner' AND `MediaCover`.`collection` = 'cover') LEFT JOIN `tmdb`.`media` AS `MediaVideo` ON (`MediaVideo`.`foreign_key` = `Banner`.`id` AND `MediaVideo`.`model` = 'Banner' AND `MediaVideo`.`collection` = 'video') WHERE `Banner`.`active` = '1' AND `Banner`.`position` = ('blog') ORDER BY `Banner`.`order` ASC | 1 | 1 | 1 | |
| 13 | SELECT `TourCategory`.`slug` FROM `tmdb`.`tour_categories` AS `TourCategory` WHERE `id` = 13 LIMIT 1 | 1 | 1 | 0 |
