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 `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` = 7 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Post`.`id` FROM `db_cni`.`posts` AS `Post` WHERE `Post`.`approved` = 1 AND `Post`.`section_id` = 7 | 19 | 19 | 0 | |
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `Topic`.`table_name` FROM `db_cni`.`topics` AS `Topic` LEFT JOIN `db_cni`.`posts_topics` AS `PostsTopic` ON (`PostsTopic`.`topic_id` = `Topic`.`id`) WHERE `PostsTopic`.`post_id` IN (6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208, 6209, 6210, 6211) GROUP BY `Topic`.`id` | 6 | 6 | 1 | 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`, `Section`.`id`, `Section`.`name`, `Section`.`type`, `Section`.`template`, `Section`.`url_image`, `Section`.`description`, `Section`.`created`, `Section`.`modified`, `Section`.`metatags`, `Section`.`metatitle` FROM `db_cni`.`posts` AS `Post` LEFT JOIN `db_cni`.`sections` AS `Section` ON (`Post`.`section_id` = `Section`.`id`) WHERE `Post`.`section_id` = 7 AND `Post`.`approved` = 1 ORDER BY `Post`.`created` DESC LIMIT 9 | 9 | 9 | 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 (6211, 6210, 6209, 6208, 6207, 6206, 6205, 6204, 6203) | 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` IN (6211, 6210, 6209, 6208, 6207, 6206, 6205, 6204, 6203) 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` IN (6211, 6210, 6209, 6208, 6207, 6206, 6205, 6204, 6203) AND `PostsTopic`.`topic_id` = `Topic`.`id`) | 10 | 10 | 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` IN (6211, 6210, 6209, 6208, 6207, 6206, 6205, 6204, 6203) AND `PostsFile`.`file_id` = `File`.`id`) | 9 | 9 | 0 | |
SELECT COUNT(*) AS `count` FROM `db_cni`.`posts` AS `Post` LEFT JOIN `db_cni`.`sections` AS `Section` ON (`Post`.`section_id` = `Section`.`id`) WHERE `Post`.`section_id` = 7 AND `Post`.`approved` = 1 | 1 | 1 | 0 | |
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` IN (6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208, 6209, 6210, 6211) GROUP BY `PostsModule`.`id` ORDER BY `Module`.`created` DESC LIMIT 3 | 0 | 0 | 0 | |