| 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 = 57 AND language = 'pl_PL' AND accept = 1 AND res_status = 3
AND (ch_language = 'pl_PL' OR IFNULL(ch_language,1))
| 0.043 | 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 = 57 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.040 | 10 |
| SELECT `settings`.*
FROM (`settings`)
ORDER BY `settings`.`key` ASC | 0.008 | 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` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2304'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2304'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2305'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2305'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2306'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2306'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.012 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2307'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2307'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2282'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2282'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2283'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2283'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.014 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2284'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2284'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2285'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2285'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2286'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2286'
AND `language` = 'pl_PL'
AND comment_status != 0 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 5494
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 5494
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `ratings`.*
FROM (`ratings`)
WHERE `module` = 'content'
AND `parameter` = '2287'
ORDER BY `ratings`.`id` ASC | 0.000 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`comments`)
WHERE `module` = 'content'
AND `param` = '2287'
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 = 57
GROUP BY tag_id
ORDER BY size DESC
LIMIT 30
| 0.000 | 5 |
| Total: 48 | 0.122 | 147 |
