0.0015 |
SELECT
c.comment_id, COUNT(DISTINCT c.`id`) AS num
FROM comments AS c
WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0
AND c.comment_id!=0
AND c.lang = '1'
AND c.`new_content_id` = '32195'
AND c.comment_id IN (1656064,930287,925352,925348,925345,837531,835621,834166,833999,833733,833724,833416,833379,833331,833255)
GROUP BY c.comment_id
|
0.0154 | SELECT n.*,rn.*,u.user_name,u.user_name as media_username,p.title as ptitle,p.width,p.height,v.code,v.title as vtitle,p.id as pid,v.id as vid,p.author_id as pauthor_id,v.author_id as vauthor_id, v.url as video_url, v.type AS vtype FROM `news` n INNER JOIN fa_user u ON u.id = n.author_id INNER JOIN `rel_news` as rn ON n.id = rn.id_new LEFT JOIN `pictures` as p ON n.picture_content_id = p.id AND p.banned=0 LEFT JOIN `videos` as v ON n.video_content_id = v.id WHERE n.alias = 'portugal-vende-cristiano-ronaldo-espana' AND n.content_type != 2 |
0.0145 | SELECT * FROM rel_news WHERE id_new = 32195 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC |
0.0144 | SELECT title as name,alias FROM topics WHERE id =6 |
0.0144 | SELECT user_name FROM fa_user WHERE id =17284 |
0.0145 | SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 32195 AND v.contentType = 4 ORDER BY v.datetime ASC |
0.0148 | SELECT alias
FROM `news` as p WHERE author_id = 17284 AND id < 32195 ORDER by p.id DESC LIMIT 1 |
0.0149 | SELECT alias
FROM `news` as p WHERE author_id = 17284 AND id > 32195 ORDER BY p.id ASC LIMIT 1 |
0.0155 |
SELECT
c.comment,c.id,c.author_id,c.author_name,c.last_update,c.creation_date,c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, c.template,
NOW() AS difference_time, fau.changeA AS changeA
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0
AND c.comment_id=0
AND c.lang = '1'
AND c.language = 'es'
AND c.`new_content_id` = '32195'
ORDER BY c.last_update DESC, c.creation_date DESC
LIMIT 0,15
|
0.0146 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '1656064'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0147 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '930287'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0146 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '925352'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0145 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '925348'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0146 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '925345'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0146 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '837531'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0147 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '835621'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0148 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '834166'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0152 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '833999'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0154 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '833733'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0152 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '833724'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0153 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '833416'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0152 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '833379'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0154 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '833331'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0159 |
SELECT
c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device,
fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template,
NOW() AS difference_time
FROM comments AS c LEFT JOIN fa_user_mini AS fau
ON fau.id = c.author_id
WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web'
AND c.comment_id = '833255'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
0.0151 | SELECT id_content FROM rel_news WHERE id_new = '32195' AND type = '5' |
0.0162 | SELECT l.id,c.`name` as name,l.group_code,l.total_group,c.CountryCode,c.`alias` as alias FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.status = 1 AND l.links = 2 AND l.year = 2024 AND c.listed = 1 AND l.tables = 1 AND l.group_code > 0 AND c.troncal = 1 AND l.game = 1 AND c.class < 5 ORDER BY c.coefficient DESC, c.name ASC ,l.group_code ASC |
0.0150 | SELECT * FROM topics ORDER BY priority ASC |