| Queries | Time | Rows |
| SELECT * FROM redirects | 0.000 | 31 |
| SELECT `featured`.*
FROM (`featured`)
WHERE `language` = 'en_US'
ORDER BY `stick` DESC, RAND()
LIMIT 0, 4 | 0.001 | 4 |
| SELECT * FROM resources INNER JOIN metainfo ON res_id = resource WHERE res_id = 10737 AND language = 'en_US' AND res_status = 3; | 0.001 | 1 |
| SELECT * FROM resources INNER JOIN metainfo ON res_id = resource WHERE res_id = 10634 AND language = 'en_US' AND res_status = 3; | 0.000 | 1 |
| SELECT * FROM resources INNER JOIN metainfo ON res_id = resource WHERE res_id = 10612 AND language = 'en_US' AND res_status = 3; | 0.001 | 1 |
| SELECT `settings`.*
FROM (`settings`)
ORDER BY `settings`.`key` ASC | 0.000 | 16 |
| SELECT * FROM redirects | 0.000 | 31 |
| 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` = 11015
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11015
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 11015
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 11015
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 15687
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.001 | 1 |
| SELECT `users_channels`.*
FROM (`users_channels`)
WHERE `ch_language` = 'en_US'
AND `users_channels`.`user_id` = 15687
ORDER BY `users_channels`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_logins`.*
FROM (`users_logins`)
WHERE `users_logins`.`id` = 15642
ORDER BY `users_logins`.`id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT `users_users`.*
FROM (`users_users`)
WHERE `users_users`.`user_id` = 15642
ORDER BY `users_users`.`user_id` ASC
LIMIT 0, 1 | 0.000 | 1 |
| SELECT DISTINCT(c.user_id) as vkey,u.*,c.* FROM users_logins u LEFT JOIN users_channels c ON c.user_id = u.id WHERE featured = 1 AND ch_language = 'en_US' ORDER BY title ASC LIMIT 4 | 0.001 | 3 |
| SELECT metainfo.title, metainfo.description, resources.res_id, resources.res_name, resources.res_category, resources.res_type
FROM metainfo
INNER JOIN resources
ON resources.res_id = metainfo.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 language = 'en_US' AND res_status = 3 AND accept = 1
AND (res_id = 1318 OR res_id = 2705 OR res_id = 9679)
ORDER BY FIELD(res_id,1318,2705,9679)
LIMIT 6; | 0.001 | 4 |
|
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 = 'en_US'
GROUP BY tag_id
ORDER BY size DESC
LIMIT 30
| 0.000 | 30 |
| Total: 19 | 0.007 | 131 |
| Session | Value |
| session_id | 10d9d0de339721ec89a9988a91a8c432 |
| total_hits | 1 |
| _kf_flash_ | Array
(
)
|
| user_agent | CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| ip_address | 38.107.179.241 |
| last_activity | 1327748196 |
| uploadParams | Array
(
[maxFiles] => 9999
[maxFilesize] => 534773760
[allowedExt] => jpg|jpeg|gif|tiff|png|avi|mpg|mpeg|wmv|mp4|flv|fl9|asf|3gp|mov|doc|rtf|txt|ppt|docx|odt|pdf
[multiFiles] => 1
[allowedExtDesc] => Files jpg, jpeg, gif, tiff, png, avi, mpg, mpeg, wmv, mp4, flv, fl9, asf, 3gp, mov, doc, rtf, txt, ppt, docx, odt, pdf
)
|
| sessFiles | Array
(
)
|
