Trabajos especiales

Novedades en ingeniería de obra civil

(default) 15 queries took 15 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `User`.`id`, `User`.`title`, `User`.`slug`, `User`.`email`, `User`.`password`, `User`.`role`, `User`.`active`, `User`.`oauth_provider`, `User`.`oauth_id`, `User`.`created`, `User`.`modified`, `User`.`visto` FROM `inviasa_inv`.`posts` AS `Post` inner JOIN `inviasa_inv`.`posts_categorias` AS `PostsCategoria` ON (`PostsCategoria`.`post_id` = `Post`.`id`) inner JOIN `inviasa_inv`.`categorias` AS `Categoria` ON (`Categoria`.`id` = `PostsCategoria`.`categoria_id` AND `Categoria`.`slug` = 'trabajos-especiales') LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`activo` = '1' AND `Post`.`fecha` <= '2023-01-29 19:27:59' ORDER BY `Post`.`fecha` DESC LIMIT 10112
2SELECT `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` = (10) ORDER BY `Image`.`orden` asc, `Image`.`id` asc111
3SELECT `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` = 10 AND `PostsCategoria`.`categoria_id` = `Categoria`.`id`) 111
4SELECT `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` = 10 AND `PostsTag`.`tag_id` = `Tag`.`id`) 000
5SELECT COUNT(*) AS `count` FROM `inviasa_inv`.`posts` AS `Post` inner JOIN `inviasa_inv`.`posts_categorias` AS `PostsCategoria` ON (`PostsCategoria`.`post_id` = `Post`.`id`) inner JOIN `inviasa_inv`.`categorias` AS `Categoria` ON (`Categoria`.`id` = `PostsCategoria`.`categoria_id` AND `Categoria`.`slug` = 'trabajos-especiales') LEFT JOIN `inviasa_inv`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`activo` = '1' AND `Post`.`fecha` <= '2023-01-29 19:27:59'111
6SELECT `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`.`slug` = 'trabajos-especiales' ORDER BY `Categoria`.`model` asc, `Categoria`.`id` asc LIMIT 1111
7SELECT `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` asc001
8SELECT `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`) 221
9SELECT `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` asc111
10SELECT `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` asc001
11SELECT `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`) 221
12SELECT `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/categoria/trabajos-especiales' AND `SeoUri`.`is_approved` = '1' LIMIT 1001
13SELECT `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/categoria/trabajos-especiales' AND `SeoUri`.`is_approved` = '1'001
14SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1'001
15SELECT `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/categoria/trabajos-especiales' AND `SeoUri`.`is_approved` = '1' AND `SeoCanonical`.`is_active` = '1' LIMIT 1001