Resource id #4 em db-02 -> SELECT GET_LOCK("lock_dblst_46_1_30_T1___",0) AS locked em 0.001

Resource id #4 em db-02 -> /*LISTA: LST_MATERIAS_MAIS_VISTAS_SEMANA*/ SELECT SQL_CALC_FOUND_ROWS cnt.pk_id_conteudo, cnt.url_fixa, cnt.titulo, cnt.descricao, cnt.texto, cnt.data_publicacao, cnt.fk_id_tipo_conteudo, cnt.fk_id_conteudo_status, cnt.pro_carreiras, cnt.pro_industria, cnt.pro_tendencias, cnt.uolmais_id, cnt.dailymotion_id, img1.caminho_arquivo AS img1, img1.caminho_arquivo_4x3 AS img4x3_1, img1.caminho_arquivo_9x16 AS img9x16_1, img1.caminho_arquivo_16x9 AS img16x9_1, img1.titulo AS img1_tit, img1.descricao AS img1_des, img1.autor_copyright AS img1_aut, cnt.uolmais_id AS vid_uolmais_id, cnt.dailymotion_id AS vid_dmotion_id, cnt.uolmais_ativo AS vid_uolmais_ativo, vid.caminho_video_baixa AS vid_cam_normal, vid.caminho_video_720p AS vid_cam_720p, vid.caminho_youtube AS vid_cam_youtube, img2.caminho_arquivo AS img2, img2.caminho_arquivo_4x3 AS img4x3_2, img2.caminho_arquivo_9x16 AS img9x16_2, img2.caminho_arquivo_16x9 AS img16x9_2, img2.titulo AS img2_tit, img2.descricao AS img2_des, img2.autor_copyright AS img2_aut FROM cms_tbl_conteudo AS cnt IGNORE INDEX (fk_id_conteudo_status,fk_id_tipo_conteudo,data_expiracao,pro_carreiras,pro_industria,pro_tendencias,uolmais_id,dailymotion_id) INNER JOIN alog_cnt_top80_vis_semana AS ltop ON ltop.fk_id_conteudo=cnt.pk_id_conteudo LEFT JOIN cms_tbl_noticias AS ntc ON ntc.fk_id_conteudo=cnt.pk_id_conteudo LEFT JOIN cms_tbl_imagens AS img1 ON img1.pk_id_imagem=ntc.fk_id_imagem LEFT JOIN cms_tbl_videos AS vid ON vid.fk_id_conteudo=cnt.pk_id_conteudo LEFT JOIN cms_tbl_imagens AS img2 ON img2.pk_id_imagem=vid.fk_id_imagem WHERE cnt.data_publicacao<=UNIX_TIMESTAMP(NOW()) AND cnt.fk_id_conteudo_status=2 AND cnt.fk_id_tipo_conteudo IN (1,2,7,9) ORDER BY ltop.visualizacoes DESC, cnt.data_publicacao DESC, cnt.pk_id_conteudo DESC LIMIT 0,30 em 0.187

Resource id #4 em db-02 -> SELECT FOUND_ROWS() AS total em 0

Resource id #4 em db-02 -> SELECT rt.fk_id_conteudo AS cid, rt.fk_id_tag AS tid, t.tag AS tag FROM cms_tbl_conteudo_r_tags AS rt INNER JOIN cms_tbl_tags AS t ON t.pk_id_tag=rt.fk_id_tag WHERE rt.fk_id_conteudo IN (108779,108721,108857,108874,108854,108741,108938,108886,108960,108680,109018,108824,108808,108620,108973,108849,108720,108885,108990,108907,108706,108714,98089,108150,108870,108789,108588,108508,108951,108982) em 0.003

Resource id #4 em db-02 -> SELECT id, assunto, url FROM alog_cnt_assuntos ORDER BY id em 0.001

Resource id #4 em db-02 -> SELECT r.id_assunto AS aid, r.id_tag AS tid, t.tag AS tag FROM alog_cnt_assuntos_tags AS r INNER JOIN cms_tbl_tags AS t ON t.pk_id_tag=r.id_tag em 0.01

Resource id #4 em db-02 -> SELECT c.pk_id_conteudo AS id_conteudo, ua.pk_id_usuario AS id_autor, ue.pk_id_usuario AS id_editor, TRIM(CONCAT(ua.nome, " ", ua.sobrenome)) AS autor_nome, ua.email AS autor_email, TRIM(CONCAT(ue.nome, " ", ue.sobrenome)) AS editor_nome, ue.email AS editor_email FROM cms_tbl_historico_relatorio AS h INNER JOIN ( SELECT MAX(pk_id_historico_relatorio) AS hid, fk_id_conteudo AS id_conteudo FROM cms_tbl_historico_relatorio WHERE fk_id_conteudo IN (108779,108721,108857,108874,108854,108741,108938,108886,108960,108680,109018,108824,108808,108620,108973,108849,108720,108885,108990,108907,108706,108714,98089,108150,108870,108789,108588,108508,108951,108982) AND fk_id_usuario<>0 GROUP BY fk_id_conteudo ) AS t ON t.hid=h.pk_id_historico_relatorio INNER JOIN cms_tbl_conteudo AS c ON c.pk_id_conteudo=t.id_conteudo LEFT JOIN cms_tbl_usuarios AS ue ON ue.pk_id_usuario=h.fk_id_usuario LEFT JOIN cms_tbl_usuarios AS ua ON ua.pk_id_usuario=c.fk_id_usuario em 0.008

Resource id #4 em db-02 -> SELECT RELEASE_LOCK("lock_dblst_46_1_30_T1___") AS released em 0