Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Section`.`id`, `Section`.`name`, `Section`.`template` FROM `db_cni`.`sections` AS `Section` WHERE `Section`.`type` = 1 ORDER BY `Section`.`id` ASC | 3 | 3 | 0 | |
SELECT `Section`.`id`, `Section`.`name`, `Section`.`template` FROM `db_cni`.`sections` AS `Section` WHERE `Section`.`type` = 2 ORDER BY `Section`.`id` ASC | 3 | 3 | 0 | |
SELECT `Section`.`id`, `Section`.`name`, `Section`.`template` FROM `db_cni`.`sections` AS `Section` WHERE `Section`.`type` = 3 ORDER BY `Section`.`id` ASC | 4 | 4 | 0 | |
SELECT `Section`.`id`, `Section`.`name`, `Section`.`template` FROM `db_cni`.`sections` AS `Section` WHERE `Section`.`type` = 2 ORDER BY `Section`.`id` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`comments` AS `Comment` WHERE `Comment`.`occult` = 0 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`id` = 7305 AND `Post`.`approved` = 1 | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`section_id`, `Post`.`title`, `Post`.`description`, `Post`.`tags`, `Post`.`exists`, `Post`.`init_date`, `Post`.`end_date`, `Post`.`year`, `Post`.`address`, `Post`.`img_destaque`, `Post`.`hour`, `Post`.`place`, `Post`.`place_url`, `Post`.`all_states`, `Post`.`is_featured`, `Post`.`approved`, `Post`.`user_create`, `Post`.`user_approve`, `Post`.`user_update`, `Post`.`enabled_comment`, `Post`.`visualizations`, `Post`.`comments`, `Post`.`city_id`, `Post`.`postscol`, `Post`.`table_name`, `Post`.`created`, `Post`.`modified`, `Post`.`type_redirect`, `Post`.`expiration_date`, `Post`.`priority`, `Post`.`ementa`, `Post`.`img_64`, `Post`.`resume`, `Post`.`sphere`, `Post`.`LEXML_subcategory_id`, `Post`.`LEXML_category_id`, `Post`.`signature_date`, `Post`.`law_number`, `Post`.`publication_date`, `Post`.`is_featured_date`, `Post`.`id_site_old` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`id` = 7305 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`id` = 7305 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`id` = 7305 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`id` = 7305 | 1 | 1 | 0 | |
UPDATE `db_cni`.`posts` SET `id` = 7305, `visualizations` = 9432, `modified` = '2019-02-10 09:01:26' WHERE `db_cni`.`posts`.`id` = '7305' | 1 | 1 | 4 | maybe slow |
COMMIT | 1 | 1 | 4 | maybe slow |
SELECT `Post`.`id`, `Post`.`section_id`, `Post`.`title`, `Post`.`description`, `Post`.`tags`, `Post`.`exists`, `Post`.`init_date`, `Post`.`end_date`, `Post`.`year`, `Post`.`address`, `Post`.`img_destaque`, `Post`.`hour`, `Post`.`place`, `Post`.`place_url`, `Post`.`all_states`, `Post`.`is_featured`, `Post`.`approved`, `Post`.`user_create`, `Post`.`user_approve`, `Post`.`user_update`, `Post`.`enabled_comment`, `Post`.`visualizations`, `Post`.`comments`, `Post`.`city_id`, `Post`.`postscol`, `Post`.`table_name`, `Post`.`created`, `Post`.`modified`, `Post`.`type_redirect`, `Post`.`expiration_date`, `Post`.`priority`, `Post`.`ementa`, `Post`.`img_64`, `Post`.`resume`, `Post`.`sphere`, `Post`.`LEXML_subcategory_id`, `Post`.`LEXML_category_id`, `Post`.`signature_date`, `Post`.`law_number`, `Post`.`publication_date`, `Post`.`is_featured_date`, `Post`.`id_site_old` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`id` = 7305 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`name`, `Section`.`type`, `Section`.`template` FROM `db_cni`.`sections` AS `Section` WHERE `Section`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Section`.`id`, `Section`.`name`, `Section`.`type`, `Section`.`template`, `Section`.`url_image`, `Section`.`description`, `Section`.`created`, `Section`.`modified`, `Section`.`metatags`, `Section`.`metatitle` FROM `db_cni`.`sections` AS `Section` WHERE `Section`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Post`.`id`, `Post`.`section_id`, `Post`.`title`, `Post`.`description`, `Post`.`tags`, `Post`.`exists`, `Post`.`init_date`, `Post`.`end_date`, `Post`.`year`, `Post`.`address`, `Post`.`img_destaque`, `Post`.`hour`, `Post`.`place`, `Post`.`place_url`, `Post`.`all_states`, `Post`.`is_featured`, `Post`.`approved`, `Post`.`user_create`, `Post`.`user_approve`, `Post`.`user_update`, `Post`.`enabled_comment`, `Post`.`visualizations`, `Post`.`comments`, `Post`.`city_id`, `Post`.`postscol`, `Post`.`table_name`, `Post`.`created`, `Post`.`modified`, `Post`.`type_redirect`, `Post`.`expiration_date`, `Post`.`priority`, `Post`.`ementa`, `Post`.`img_64`, `Post`.`resume`, `Post`.`sphere`, `Post`.`LEXML_subcategory_id`, `Post`.`LEXML_category_id`, `Post`.`signature_date`, `Post`.`law_number`, `Post`.`publication_date`, `Post`.`is_featured_date`, `Post`.`id_site_old` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`id` = 7305 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Gallery`.`id`, `Gallery`.`post_id`, `Gallery`.`title`, `Gallery`.`description`, `Gallery`.`url_thumb`, `Gallery`.`url_media`, `Gallery`.`img_64`, `Gallery`.`type`, `Gallery`.`created`, `Gallery`.`modified` FROM `db_cni`.`galleries` AS `Gallery` WHERE `Gallery`.`post_id` = (7305) | 0 | 0 | 0 | |
SELECT `State`.`id`, `State`.`name`, `State`.`acronym`, `State`.`created`, `State`.`modified`, `PostsState`.`id`, `PostsState`.`post_id`, `PostsState`.`state_id` FROM `db_cni`.`states` AS `State` JOIN `db_cni`.`posts_states` AS `PostsState` ON (`PostsState`.`post_id` = 7305 AND `PostsState`.`state_id` = `State`.`id`) | 0 | 0 | 0 | |
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `Topic`.`table_name`, `PostsTopic`.`id`, `PostsTopic`.`post_id`, `PostsTopic`.`topic_id` FROM `db_cni`.`topics` AS `Topic` JOIN `db_cni`.`posts_topics` AS `PostsTopic` ON (`PostsTopic`.`post_id` = 7305 AND `PostsTopic`.`topic_id` = `Topic`.`id`) | 1 | 1 | 0 | |
SELECT `File`.`id`, `File`.`folder_id`, `File`.`name`, `File`.`description`, `File`.`url_file`, `File`.`extension`, `File`.`created`, `File`.`size`, `File`.`table_name`, `File`.`type_redirect`, `File`.`modified`, `PostsFile`.`id`, `PostsFile`.`post_id`, `PostsFile`.`file_id` FROM `db_cni`.`files` AS `File` JOIN `db_cni`.`posts_files` AS `PostsFile` ON (`PostsFile`.`post_id` = 7305 AND `PostsFile`.`file_id` = `File`.`id`) | 1 | 1 | 0 | |
SELECT `Comment`.`id`, `Comment`.`father_id`, `Comment`.`post_id`, `Comment`.`name`, `Comment`.`email`, `Comment`.`description`, `Comment`.`status`, `Comment`.`occult`, `Comment`.`has_updated`, `Comment`.`table_name`, `Comment`.`type_redirect`, `Comment`.`created`, `Comment`.`modified` FROM `db_cni`.`comments` AS `Comment` WHERE `Comment`.`occult` = 2 AND `Comment`.`status` = 2 AND `Comment`.`post_id` = 7305 AND `Comment`.`father_id` IS NULL | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`section_id`, `Post`.`title`, `Post`.`description`, `Post`.`tags`, `Post`.`exists`, `Post`.`init_date`, `Post`.`end_date`, `Post`.`year`, `Post`.`address`, `Post`.`img_destaque`, `Post`.`hour`, `Post`.`place`, `Post`.`place_url`, `Post`.`all_states`, `Post`.`is_featured`, `Post`.`approved`, `Post`.`user_create`, `Post`.`user_approve`, `Post`.`user_update`, `Post`.`enabled_comment`, `Post`.`visualizations`, `Post`.`comments`, `Post`.`city_id`, `Post`.`postscol`, `Post`.`table_name`, `Post`.`created`, `Post`.`modified`, `Post`.`type_redirect`, `Post`.`expiration_date`, `Post`.`priority`, `Post`.`ementa`, `Post`.`img_64`, `Post`.`resume`, `Post`.`sphere`, `Post`.`LEXML_subcategory_id`, `Post`.`LEXML_category_id`, `Post`.`signature_date`, `Post`.`law_number`, `Post`.`publication_date`, `Post`.`is_featured_date`, `Post`.`id_site_old` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`approved` = 1 AND `Post`.`section_id` = 1 AND ((`Post`.`init_date` >= '2019-02-10') OR (`Post`.`end_date` >= '2019-02-10')) ORDER BY `Post`.`init_date` ASC LIMIT 3 | 0 | 0 | 1 | maybe slow |
SELECT `Module`.`id`, `Module`.`name`, `Module`.`section_id`, `Module`.`post_id`, `Module`.`created`, `Module`.`modified` FROM `db_cni`.`modules` AS `Module` LEFT JOIN `db_cni`.`posts_modules` AS `PostsModule` ON (`PostsModule`.`module_id` = `Module`.`id`) WHERE `PostsModule`.`post_id` = 7305 GROUP BY `PostsModule`.`id` ORDER BY `Module`.`created` DESC LIMIT 3 | 0 | 0 | 0 | |