| 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 = 30 AND language = 'pl_PL' AND accept = 1 AND res_status = 3
AND (ch_language = 'pl_PL' OR IFNULL(ch_language,1))
| 0.022 | 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 = 30 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.059 | 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` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8865'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8865'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8864'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8864'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8863'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8863'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8862'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8862'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8861'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8861'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8860'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8860'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8859'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8859'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8858'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8858'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8857'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8857'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 12114
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 12114
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '8855'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '8855'
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 = 30
GROUP BY tag_id
ORDER BY size DESC
LIMIT 30
| 0.000 | 30 |
| Total: 48 | 0.085 | 172 |
