| Queries | Time | Rows |
| SELECT * FROM redirects | 0.000 | 32 |
| SELECT `notification_event`.*
FROM (`notification_event`)
ORDER BY `notification_event`.`id` ASC | 0.000 | 20 |
|
SELECT COUNT(res_id) AS ile FROM resources
INNER JOIN metainfo ON res_id = resource
INNER JOIN users_logins ON users_logins.id = resources.res_user
LEFT JOIN users_users
ON users_users.user_id = users_logins.id
LEFT JOIN users_channels
ON users_channels.user_id = users_logins.id
WHERE (res_type = 1 OR res_type = 2 OR res_type = 3 ) AND res_category = 6 AND language = 'pl_PL' AND accept = 1 AND res_status = 3
AND (ch_language = 'pl_PL' OR IFNULL(ch_language,1))
| 0.032 | 1 |
| SELECT * FROM redirects | 0.000 | 32 |
| SELECT *,users_channels.title as channel, 'content' AS media_type, metainfo.title as title, metainfo.description FROM resources
INNER JOIN metainfo ON res_id = resource
INNER JOIN users_logins ON users_logins.id = resources.res_user
LEFT JOIN users_users
ON users_users.user_id = users_logins.id
LEFT JOIN users_channels
ON users_channels.user_id = users_logins.id
WHERE (res_type = 1 OR res_type = 2 OR res_type = 3 ) AND res_category = 6 AND language = 'pl_PL' AND accept = 1 AND res_status = 3 AND language = 'pl_PL'
AND (ch_language = 'pl_PL' OR IFNULL(ch_language,1))
ORDER BY res_added DESC LIMIT 0, 10 | 0.049 | 10 |
| SELECT `settings`.*
FROM (`settings`)
ORDER BY `settings`.`key` ASC | 0.000 | 16 |
| SELECT COUNT(*) AS `records_found`
FROM (`resources`)
WHERE `res_status` = 3
AND `accept` = 1 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 9970
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 9970
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '4413'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '4413'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11710
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11710
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '4058'
ORDER BY `ratings`.`id` ASC | 0.000 | 1 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '4058'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11710
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11710
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '4056'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '4056'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11710
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11710
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '4054'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '4054'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11710
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11710
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '4041'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '4041'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11071
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11071
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2995'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2995'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11071
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11071
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2975'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2975'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11117
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11117
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2937'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2937'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11117
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11117
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2936'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2936'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11018
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11018
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2702'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2702'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
|
SELECT t.name, t.language, e.tag_id, e.id, COUNT(e.tag_id) as size
FROM `tags_extra` e
JOIN `tags_tags` t
ON e.tag_id = t.id
WHERE e.status = 1
AND t.language = 'pl_PL'
AND e.category = 6
GROUP BY tag_id
ORDER BY size DESC
LIMIT 30
| 0.010 | 23 |
| Total: 48 | 0.096 | 166 |
