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 | 2 | maybe slow |
SELECT `Maintain`.`id`, `Maintain`.`name`, `Maintain`.`description`, `Maintain`.`url_image`, `Maintain`.`img_64`, `Maintain`.`saved`, `Maintain`.`relation_title`, `Maintain`.`visualizations`, `Maintain`.`table_name`, `Maintain`.`type_redirect`, `Maintain`.`created`, `Maintain`.`modified`, `Maintain`.`metatags`, `Maintain`.`metatitle` FROM `db_cni`.`maintains` AS `Maintain` WHERE `Maintain`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
BEGIN | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`maintains` AS `Maintain` WHERE `Maintain`.`id` = 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`maintains` AS `Maintain` WHERE `Maintain`.`id` = 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`maintains` AS `Maintain` WHERE `Maintain`.`id` = 1 | 1 | 1 | 0 | |
UPDATE `db_cni`.`maintains` SET `id` = 1, `visualizations` = 29930, `modified` = '2019-08-26 23:40:35' WHERE `db_cni`.`maintains`.`id` = '1' | 1 | 1 | 4 | maybe slow |
COMMIT | 1 | 1 | 4 | maybe slow |
SELECT `Maintain`.`id`, `Maintain`.`name`, `Maintain`.`description`, `Maintain`.`url_image`, `Maintain`.`img_64`, `Maintain`.`saved`, `Maintain`.`relation_title`, `Maintain`.`visualizations`, `Maintain`.`table_name`, `Maintain`.`type_redirect`, `Maintain`.`created`, `Maintain`.`modified`, `Maintain`.`metatags`, `Maintain`.`metatitle` FROM `db_cni`.`maintains` AS `Maintain` WHERE `Maintain`.`id` = 1 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`.`section_id` = 3 AND `Post`.`approved` = 1 ORDER BY `Post`.`id` DESC LIMIT 3 | 3 | 3 | 1 | maybe slow |
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` IN (7705, 7704, 7703) | 3 | 3 | 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` IN (7705, 7704, 7703) AND `PostsState`.`state_id` = `State`.`id`) | 3 | 3 | 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` IN (7705, 7704, 7703) AND `PostsTopic`.`topic_id` = `Topic`.`id`) | 3 | 3 | 0 | |