Nathan Adler Studio - strony internetowe Poznań
Nathan Adler Studio - strony internetowe Poznań
(default) 30 queries took 136 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`777
2DESCRIBE `acos`776
3DESCRIBE `aros_acos`776
4DESCRIBE `sites`16166
5DESCRIBE `page_contents`7713
6DESCRIBE `uploads`10106
7DESCRIBE `news`14146
8DESCRIBE `tags`226
9DESCRIBE `users`886
10DESCRIBE `groups`556
11DESCRIBE `profiles`30307
12DESCRIBE `messages`996
13DESCRIBE `users_users`556
14DESCRIBE `most_wanted`666
15DESCRIBE `youtubes`556
16DESCRIBE `i18n`666
17SELECT `Site`.*, `Parent`.*, `I18n__title`.`content`, `I18n__description`.`content`, `Site`.`id` FROM `sites` AS `Site` LEFT JOIN `i18n` AS `I18n__title` ON (`Site`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Site' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__description` ON (`Site`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Site' AND `I18n__description`.`field` = 'description') LEFT JOIN `sites` AS `Parent` ON (`Site`.`parent_id` = `Parent`.`id`) WHERE `Site`.`site` = 'sponsoring' AND `I18n__title`.`locale` = 'pol' AND `I18n__description`.`locale` = 'pol' ORDER BY `Site`.`created` DESC LIMIT 1113
18SELECT `PageContent`.*, `Site`.*, `I18n__header`.`content`, `I18n__content`.`content`, `PageContent`.`id` FROM `page_contents` AS `PageContent` LEFT JOIN `i18n` AS `I18n__header` ON (`PageContent`.`id` = `I18n__header`.`foreign_key` AND `I18n__header`.`model` = 'PageContent' AND `I18n__header`.`field` = 'header') LEFT JOIN `i18n` AS `I18n__content` ON (`PageContent`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'PageContent' AND `I18n__content`.`field` = 'content') LEFT JOIN `sites` AS `Site` ON (`PageContent`.`site_id` = `Site`.`id`) WHERE `Site`.`site` = 'sponsoring' AND `I18n__header`.`locale` = 'pol' AND `I18n__content`.`locale` = 'pol' 3316
19SELECT `Site`.`lft`, `Site`.`rght` FROM `sites` AS `Site` WHERE `Site`.`id` = 70 LIMIT 1110
20SELECT `Site`.*, `I18n__title`.`content`, `I18n__description`.`content` FROM `sites` AS `Site` LEFT JOIN `i18n` AS `I18n__title` ON (`Site`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Site' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__description` ON (`Site`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Site' AND `I18n__description`.`field` = 'description') WHERE 1 = 1 AND `Site`.`lft` <= 143 AND `Site`.`rght` >= 154 AND `I18n__title`.`locale` = 'pol' AND `I18n__description`.`locale` = 'pol' ORDER BY `Site`.`lft` asc 110
21DESCRIBE `posts`776
22SELECT `News`.*, `Tag`.*, `User`.*, `I18n__title`.`content`, `I18n__content`.`content`, `I18n__short`.`content`, `News`.`id` FROM `news` AS `News` LEFT JOIN `i18n` AS `I18n__title` ON (`News`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'News' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__content` ON (`News`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'News' AND `I18n__content`.`field` = 'content') LEFT JOIN `i18n` AS `I18n__short` ON (`News`.`id` = `I18n__short`.`foreign_key` AND `I18n__short`.`model` = 'News' AND `I18n__short`.`field` = 'short') LEFT JOIN `tags` AS `Tag` ON (`News`.`tag` = `Tag`.`id`) LEFT JOIN `users` AS `User` ON (`News`.`user_id` = `User`.`id`) WHERE `News`.`complete` = 1 AND `I18n__title`.`locale` = 'pol' AND `I18n__content`.`locale` = 'pol' AND `I18n__short`.`locale` = 'pol' ORDER BY `News`.`created` DESC 14140
23SELECT `Upload`.`id`, `Upload`.`model`, `Upload`.`foreign_key`, `Upload`.`position`, `Upload`.`name`, `Upload`.`type`, `Upload`.`size`, `Upload`.`description`, `Upload`.`created`, `Upload`.`modified` FROM `uploads` AS `Upload` WHERE `Upload`.`foreign_key` IN (27, 23, 17, 15, 13, 12, 11, 10, 9, 8, 6, 5, 4, 3) ORDER BY `Upload`.`position` ASC 60600
24SELECT `MostWanted`.`id`, `MostWanted`.`model`, `MostWanted`.`foreign_key`, `MostWanted`.`counter`, `MostWanted`.`created`, `MostWanted`.`modified` FROM `most_wanted` AS `MostWanted` WHERE `MostWanted`.`foreign_key` IN (27, 23, 17, 15, 13, 12, 11, 10, 9, 8, 6, 5, 4, 3) ORDER BY `MostWanted`.`counter` DESC, `MostWanted`.`id` ASC 14140
25SELECT `Youtube`.`id`, `Youtube`.`news_id`, `Youtube`.`link`, `Youtube`.`created`, `Youtube`.`modified` FROM `youtubes` AS `Youtube` WHERE `Youtube`.`news_id` IN (27, 23, 17, 15, 13, 12, 11, 10, 9, 8, 6, 5, 4, 3) 000
26SELECT `titleT`.`id`, `titleT`.`locale`, `titleT`.`model`, `titleT`.`foreign_key`, `titleT`.`field`, `titleT`.`content` FROM `i18n` AS `titleT` WHERE `model` = 'News' AND `field` = 'title' AND `titleT`.`foreign_key` IN (27, 23, 17, 15, 13, 12, 11, 10, 9, 8, 6, 5, 4, 3) 42420
27SELECT `contentT`.`id`, `contentT`.`locale`, `contentT`.`model`, `contentT`.`foreign_key`, `contentT`.`field`, `contentT`.`content` FROM `i18n` AS `contentT` WHERE `model` = 'News' AND `field` = 'content' AND `contentT`.`foreign_key` IN (27, 23, 17, 15, 13, 12, 11, 10, 9, 8, 6, 5, 4, 3) 42420
28SELECT `shortT`.`id`, `shortT`.`locale`, `shortT`.`model`, `shortT`.`foreign_key`, `shortT`.`field`, `shortT`.`content` FROM `i18n` AS `shortT` WHERE `model` = 'News' AND `field` = 'short' AND `shortT`.`foreign_key` IN (27, 23, 17, 15, 13, 12, 11, 10, 9, 8, 6, 5, 4, 3) 42420
29DESCRIBE `options`446
30SELECT `Option`.`value` FROM `options` AS `Option` WHERE `option` = 'news' LIMIT 1110