1 | SELECT `Post`.`user_id` FROM `inviasa_inv`.`posts` AS `Post` WHERE `Post`.`activo` = '1' AND `Post`.`url_slug` = 'como-ahorrar-agua-riego-parques' ORDER BY `Post`.`fecha` DESC, `Post`.`id` DESC LIMIT 1 | | 1 | 1 | 1 |
2 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`subtitle`, `Post`.`body`, `Post`.`body_data`, `Post`.`body_html_clean`, `Post`.`user_id`, `Post`.`url_slug`, `Post`.`activo`, `Post`.`destacado`, `Post`.`fecha`, `Post`.`tags`, `Post`.`created`, `Post`.`modified`, `Post`.`title_eng`, `Post`.`subtitle_eng`, `Post`.`body_eng`, `Post`.`title_fra`, `Post`.`subtitle_fra`, `Post`.`body_fra`, `Post`.`title_por`, `Post`.`subtitle_por`, `Post`.`body_por`, `Post`.`web` FROM `inviasa_inv`.`posts` AS `Post` WHERE `Post`.`activo` = '1' AND `Post`.`url_slug` = 'como-ahorrar-agua-riego-parques' ORDER BY `Post`.`id` DESC LIMIT 1 | | 1 | 1 | 1 |
3 | SELECT `Image`.`fuente`, `Image`.`clave`, `Image`.`tipo`, `Image`.`archivo`, `Image`.`data_json`, `Image`.`foreign_id` FROM `inviasa_inv`.`images` AS `Image` WHERE `Image`.`model` = 'Post' AND `Image`.`foreign_id` = (49) ORDER BY `Image`.`orden` ASC | | 1 | 1 | 1 |
4 | SELECT `Categoria`.`id`, `Categoria`.`title_esp`, `Categoria`.`title_eng`, `Categoria`.`title_fra`, `Categoria`.`title_por`, `Categoria`.`description_esp`, `Categoria`.`description_eng`, `Categoria`.`description_fra`, `Categoria`.`description_por`, `Categoria`.`slug`, `Categoria`.`icon`, `Categoria`.`model`, `Categoria`.`division`, `Categoria`.`orden`, `Categoria`.`espadre`, `Categoria`.`created`, `PostsCategoria`.`id`, `PostsCategoria`.`post_id`, `PostsCategoria`.`categoria_id` FROM `inviasa_inv`.`categorias` AS `Categoria` JOIN `inviasa_inv`.`posts_categorias` AS `PostsCategoria` ON (`PostsCategoria`.`post_id` = 49 AND `PostsCategoria`.`categoria_id` = `Categoria`.`id`) ORDER BY `Categoria`.`orden` ASC | | 0 | 0 | 1 |
5 | SELECT `Tag`.`id`, `Tag`.`title`, `Tag`.`slug`, `Tag`.`created`, `Tag`.`modified`, `PostsTag`.`id`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `inviasa_inv`.`tags` AS `Tag` JOIN `inviasa_inv`.`posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 49 AND `PostsTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 0 |
6 | SELECT `Categoria`.`id`, `Categoria`.`title_esp`, `Categoria`.`title_eng`, `Categoria`.`title_fra`, `Categoria`.`title_por`, `Categoria`.`description_esp`, `Categoria`.`description_eng`, `Categoria`.`description_fra`, `Categoria`.`description_por`, `Categoria`.`slug`, `Categoria`.`icon`, `Categoria`.`model`, `Categoria`.`division`, `Categoria`.`orden`, `Categoria`.`espadre`, `Categoria`.`created` FROM `inviasa_inv`.`categorias` AS `Categoria` WHERE `Categoria`.`model` = 'Post' ORDER BY `Categoria`.`model` asc, `Categoria`.`id` asc | | 1 | 1 | 1 |
7 | SELECT `Image`.`id`, `Image`.`tipo`, `Image`.`data_json`, `Image`.`archivo`, `Image`.`fuente`, `Image`.`clave`, `Image`.`portada`, `Image`.`orden`, `Image`.`foreign_id`, `Image`.`model`, `Image`.`created`, `Image`.`modified` FROM `inviasa_inv`.`images` AS `Image` WHERE `Image`.`model` = 'Categoria' AND `Image`.`foreign_id` = (6) ORDER BY `Image`.`orden` asc, `Image`.`id` asc | | 0 | 0 | 1 |
8 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`subtitle`, `Post`.`body`, `Post`.`body_data`, `Post`.`body_html_clean`, `Post`.`user_id`, `Post`.`url_slug`, `Post`.`activo`, `Post`.`destacado`, `Post`.`fecha`, `Post`.`tags`, `Post`.`created`, `Post`.`modified`, `Post`.`title_eng`, `Post`.`subtitle_eng`, `Post`.`body_eng`, `Post`.`title_fra`, `Post`.`subtitle_fra`, `Post`.`body_fra`, `Post`.`title_por`, `Post`.`subtitle_por`, `Post`.`body_por`, `Post`.`web`, `PostsCategoria`.`id`, `PostsCategoria`.`post_id`, `PostsCategoria`.`categoria_id` FROM `inviasa_inv`.`posts` AS `Post` JOIN `inviasa_inv`.`posts_categorias` AS `PostsCategoria` ON (`PostsCategoria`.`categoria_id` = 6 AND `PostsCategoria`.`post_id` = `Post`.`id`) | | 2 | 2 | 1 |
9 | SELECT `Post`.`title`, `Post`.`url_slug`, `Post`.`id` FROM `inviasa_inv`.`posts` AS `Post` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`activo` = 1 AND `Post`.`id` > 49 ORDER BY `Post`.`id` ASC LIMIT 1 | | 1 | 1 | 1 |
10 | SELECT `Image`.`id`, `Image`.`tipo`, `Image`.`data_json`, `Image`.`archivo`, `Image`.`fuente`, `Image`.`clave`, `Image`.`portada`, `Image`.`orden`, `Image`.`foreign_id`, `Image`.`model`, `Image`.`created`, `Image`.`modified` FROM `inviasa_inv`.`images` AS `Image` WHERE `Image`.`model` = 'Post' AND `Image`.`foreign_id` = (54) ORDER BY `Image`.`orden` asc, `Image`.`id` asc | | 1 | 1 | 2 |
11 | SELECT `Categoria`.`id`, `Categoria`.`title_esp`, `Categoria`.`title_eng`, `Categoria`.`title_fra`, `Categoria`.`title_por`, `Categoria`.`description_esp`, `Categoria`.`description_eng`, `Categoria`.`description_fra`, `Categoria`.`description_por`, `Categoria`.`slug`, `Categoria`.`icon`, `Categoria`.`model`, `Categoria`.`division`, `Categoria`.`orden`, `Categoria`.`espadre`, `Categoria`.`created`, `PostsCategoria`.`id`, `PostsCategoria`.`post_id`, `PostsCategoria`.`categoria_id` FROM `inviasa_inv`.`categorias` AS `Categoria` JOIN `inviasa_inv`.`posts_categorias` AS `PostsCategoria` ON (`PostsCategoria`.`post_id` = 54 AND `PostsCategoria`.`categoria_id` = `Categoria`.`id`) | | 0 | 0 | 1 |
12 | SELECT `Tag`.`id`, `Tag`.`title`, `Tag`.`slug`, `Tag`.`created`, `Tag`.`modified`, `PostsTag`.`id`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `inviasa_inv`.`tags` AS `Tag` JOIN `inviasa_inv`.`posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 54 AND `PostsTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 1 |
13 | SELECT `Post`.`title`, `Post`.`url_slug`, `Post`.`id` FROM `inviasa_inv`.`posts` AS `Post` LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`activo` = 1 AND `Post`.`id` < 49 ORDER BY `Post`.`id` DESC LIMIT 1 | | 1 | 1 | 2 |
14 | SELECT `Image`.`id`, `Image`.`tipo`, `Image`.`data_json`, `Image`.`archivo`, `Image`.`fuente`, `Image`.`clave`, `Image`.`portada`, `Image`.`orden`, `Image`.`foreign_id`, `Image`.`model`, `Image`.`created`, `Image`.`modified` FROM `inviasa_inv`.`images` AS `Image` WHERE `Image`.`model` = 'Post' AND `Image`.`foreign_id` = (48) ORDER BY `Image`.`orden` asc, `Image`.`id` asc | | 1 | 1 | 1 |
15 | SELECT `Categoria`.`id`, `Categoria`.`title_esp`, `Categoria`.`title_eng`, `Categoria`.`title_fra`, `Categoria`.`title_por`, `Categoria`.`description_esp`, `Categoria`.`description_eng`, `Categoria`.`description_fra`, `Categoria`.`description_por`, `Categoria`.`slug`, `Categoria`.`icon`, `Categoria`.`model`, `Categoria`.`division`, `Categoria`.`orden`, `Categoria`.`espadre`, `Categoria`.`created`, `PostsCategoria`.`id`, `PostsCategoria`.`post_id`, `PostsCategoria`.`categoria_id` FROM `inviasa_inv`.`categorias` AS `Categoria` JOIN `inviasa_inv`.`posts_categorias` AS `PostsCategoria` ON (`PostsCategoria`.`post_id` = 48 AND `PostsCategoria`.`categoria_id` = `Categoria`.`id`) | | 0 | 0 | 1 |
16 | SELECT `Tag`.`id`, `Tag`.`title`, `Tag`.`slug`, `Tag`.`created`, `Tag`.`modified`, `PostsTag`.`id`, `PostsTag`.`post_id`, `PostsTag`.`tag_id` FROM `inviasa_inv`.`tags` AS `Tag` JOIN `inviasa_inv`.`posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 48 AND `PostsTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 1 |
17 | SELECT `SeoTitle`.`title`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `inviasa_inv`.`seo_titles` AS `SeoTitle` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoTitle`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/noticias/como-ahorrar-agua-riego-parques' AND `SeoUri`.`is_approved` = '1' LIMIT 1 | | 0 | 0 | 0 |
18 | SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/noticias/como-ahorrar-agua-riego-parques' AND `SeoUri`.`is_approved` = '1' | | 0 | 0 | 0 |
19 | SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1' | | 0 | 0 | 0 |
20 | SELECT `SeoCanonical`.`canonical` FROM `inviasa_inv`.`seo_canonicals` AS `SeoCanonical` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoCanonical`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/noticias/como-ahorrar-agua-riego-parques' AND `SeoUri`.`is_approved` = '1' AND `SeoCanonical`.`is_active` = '1' LIMIT 1 | | 0 | 0 | 0 |