+ Zarejestruj się
(default) 56 queries took 434 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `nodes`10101
2DESCRIBE `users`880
3DESCRIBE `comments`881
4DESCRIBE `node_pages`330
5DESCRIBE `stats`330
6DESCRIBE `node_ad_females`33331
7DESCRIBE `ad_localizations`550
8DESCRIBE `node_ad_males`31311
9DESCRIBE `ratings`770
10DESCRIBE `node_ad_couples`37371
11DESCRIBE `node_ad_clubs`25251
12DESCRIBE `node_ad_works`11111
13DESCRIBE `videos`880
14DESCRIBE `node_images`991
15DESCRIBE `node_image_caches`14141
16DESCRIBE `tags`660
17DESCRIBE `vocabularies`220
18DESCRIBE `nodes_tags`220
19DESCRIBE `menu_items`770
20DESCRIBE `visitors`330
21SELECT COUNT(*) AS `count` FROM `visitors` AS `Visitor` WHERE `ip` = '54.205.236.46' AND `visited` >= 1397789029 11291
22INSERT INTO `visitors` (`ip`, `visited`) VALUES ('54.205.236.46', 1397789929)10
23SELECT LAST_INSERT_ID() AS insertID110
24SELECT COUNT(*) AS `count` FROM `visitors` AS `Visitor` WHERE `visited` >= 1397789029 11128
25SELECT `MenuItem`.`id`, `MenuItem`.`parent_id`, `MenuItem`.`menu_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`name`, `MenuItem`.`url` FROM `menu_items` AS `MenuItem` WHERE `MenuItem`.`menu_id` = 1 ORDER BY `MenuItem`.`lft` ASC 110
26SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = 0 ORDER BY `AdLocalization`.`lft` ASC 660
27SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = 1 16160
28SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` IN (14, 15, 16, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 367) ORDER BY `AdLocalization`.`name` ASC 80800
29SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = 2 770
30SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` IN (30, 31, 34, 35, 36, 37, 38) ORDER BY `AdLocalization`.`name` ASC 000
31SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = 3 15150
32SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` IN (39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 53, 54) ORDER BY `AdLocalization`.`name` ASC 770
33SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = 4 14140
34SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` IN (56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 316) ORDER BY `AdLocalization`.`name` ASC 110
35SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = 5 24240
36SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` IN (69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94) ORDER BY `AdLocalization`.`name` ASC 000
37SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = 277 110
38SELECT `AdLocalization`.`id`, `AdLocalization`.`name`, `AdLocalization`.`parent_id` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`parent_id` = (278) ORDER BY `AdLocalization`.`name` ASC 110
39SELECT `Node`.`id`, `Node`.`title`, `Node`.`type`, `AdLocalization`.`name`, `AdLocalization`.`id`, `Stat`.`value`, `NodeAdFemale`.`id` FROM `node_ad_females` AS `NodeAdFemale` LEFT JOIN stats AS `Stat` ON (`NodeAdFemale`.`node_id` = `Stat`.`node_id`) LEFT JOIN `nodes` AS `Node` ON (`NodeAdFemale`.`node_id` = `Node`.`id`) LEFT JOIN `ad_localizations` AS `AdLocalization` ON (`NodeAdFemale`.`city_id` = `AdLocalization`.`id`) WHERE `Node`.`status` = 1 AND `NodeAdFemale`.`status` = 1 ORDER BY `Stat`.`value` DESC LIMIT 1110
40SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `model` = 'NodeAdFemale' AND `Rating`.`model_id` = (694) 110
41SELECT `NodeImage`.`node_id`, `NodeImage`.`filename`, `NodeImage`.`alt`, `NodeImage`.`weight` FROM `node_images` AS `NodeImage` LEFT JOIN `nodes` AS `Node` ON (`NodeImage`.`node_id` = `Node`.`id`) LEFT JOIN `node_image_caches` AS `NodeImageCache` ON (`NodeImageCache`.`node_image_id` = `NodeImage`.`id`) WHERE `NodeImage`.`node_id` = 1759 ORDER BY `NodeImage`.`weight` ASC LIMIT 1110
42SELECT `Node`.`id`, `NodeAdFemale`.`id`, `Node`.`title`, `Node`.`type`, `AdLocalization`.`name`, `AdLocalization`.`id`, AVG(`Rating`.`rating`) AS Average FROM `node_ad_females` AS `NodeAdFemale` LEFT JOIN ratings AS `Rating` ON (`NodeAdFemale`.`id` = `Rating`.`model_id`) LEFT JOIN `nodes` AS `Node` ON (`NodeAdFemale`.`node_id` = `Node`.`id`) LEFT JOIN `ad_localizations` AS `AdLocalization` ON (`NodeAdFemale`.`city_id` = `AdLocalization`.`id`) WHERE `Node`.`status` = 1 AND `NodeAdFemale`.`status` = 1 GROUP BY `Rating`.`model_id` ORDER BY `Average` DESC, COUNT(`Rating`.`model_id`) DESC LIMIT 1110
43SELECT `NodeImage`.`node_id`, `NodeImage`.`filename`, `NodeImage`.`alt`, `NodeImage`.`weight` FROM `node_images` AS `NodeImage` LEFT JOIN `nodes` AS `Node` ON (`NodeImage`.`node_id` = `Node`.`id`) LEFT JOIN `node_image_caches` AS `NodeImageCache` ON (`NodeImageCache`.`node_image_id` = `NodeImage`.`id`) WHERE `NodeImage`.`node_id` = 1796 ORDER BY `NodeImage`.`weight` ASC LIMIT 1110
44SELECT `Node`.`id`, `NodeAdFemale`.`id`, `Node`.`title`, `Node`.`type`, `AdLocalization`.`name`, `AdLocalization`.`id` FROM `node_ad_females` AS `NodeAdFemale` LEFT JOIN `nodes` AS `Node` ON (`NodeAdFemale`.`node_id` = `Node`.`id`) LEFT JOIN `ad_localizations` AS `AdLocalization` ON (`NodeAdFemale`.`city_id` = `AdLocalization`.`id`) WHERE `Node`.`status` = 1 AND `NodeAdFemale`.`status` = 1 ORDER BY `Node`.`created` DESC LIMIT 1110
45SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `model` = 'NodeAdFemale' AND `Rating`.`model_id` = (1169) 000
46SELECT `NodeImage`.`node_id`, `NodeImage`.`filename`, `NodeImage`.`alt`, `NodeImage`.`weight` FROM `node_images` AS `NodeImage` LEFT JOIN `nodes` AS `Node` ON (`NodeImage`.`node_id` = `Node`.`id`) LEFT JOIN `node_image_caches` AS `NodeImageCache` ON (`NodeImageCache`.`node_image_id` = `NodeImage`.`id`) WHERE `NodeImage`.`node_id` = 2772 ORDER BY `NodeImage`.`weight` ASC LIMIT 1110
47SELECT `AdLocalization`.`lft`, `AdLocalization`.`rght` FROM `ad_localizations` AS `AdLocalization` WHERE `AdLocalization`.`id` = 127 LIMIT 1110
48SELECT `AdLocalization`.`id`, `AdLocalization`.`parent_id`, `AdLocalization`.`lft`, `AdLocalization`.`rght`, `AdLocalization`.`name` FROM `ad_localizations` AS `AdLocalization` WHERE 1 = 1 AND `AdLocalization`.`lft` <= 109 AND `AdLocalization`.`rght` >= 110 ORDER BY `AdLocalization`.`lft` asc 330
49SELECT `Node`.`id`, `Node`.`title`, `Node`.`created`, `Node`.`type`, `NodeAdFemale`.`promoted`, `NodeAdFemale`.`node_id`, `AdLocalization`.`id`, `AdLocalization`.`name`, `NodeAdFemale`.`age`, `NodeAdFemale`.`weight`, `NodeAdFemale`.`height`, `NodeAdFemale`.`id` FROM `node_ad_females` AS `NodeAdFemale` LEFT JOIN `nodes` AS `Node` ON (`NodeAdFemale`.`node_id` = `Node`.`id`) LEFT JOIN `ad_localizations` AS `AdLocalization` ON (`NodeAdFemale`.`city_id` = `AdLocalization`.`id`) WHERE `AdLocalization`.`id` = 127 AND `NodeAdFemale`.`promoted` = 0 AND `Node`.`type` = 'NodeAdFemale' AND `NodeAdFemale`.`status` = 1 AND `Node`.`status` = 1 ORDER BY `Node`.`created` DESC 991
50SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `model` = 'NodeAdFemale' AND `Rating`.`model_id` IN (794, 743, 742, 741, 738, 379, 518, 410, 370) 16160
51SELECT `NodeImage`.`node_id`, `NodeImage`.`filename`, `NodeImage`.`alt`, `NodeImage`.`weight` FROM `node_images` AS `NodeImage` LEFT JOIN `nodes` AS `Node` ON (`NodeImage`.`node_id` = `Node`.`id`) LEFT JOIN `node_image_caches` AS `NodeImageCache` ON (`NodeImageCache`.`node_image_id` = `NodeImage`.`id`) WHERE `NodeImage`.`node_id` IN (1904, 1820, 1819, 1818, 1813, 1044, 1454, 1127, 1021) AND `NodeImage`.`weight` = 0 ORDER BY `NodeImage`.`weight` ASC 994
52SELECT `Node`.`id`, `Node`.`title`, `Node`.`created`, `Node`.`type`, `NodeAdFemale`.`promoted`, `NodeAdFemale`.`node_id`, `AdLocalization`.`id`, `AdLocalization`.`name`, `NodeAdFemale`.`age`, `NodeAdFemale`.`weight`, `NodeAdFemale`.`height`, `NodeAdFemale`.`id` FROM `node_ad_females` AS `NodeAdFemale` LEFT JOIN `nodes` AS `Node` ON (`NodeAdFemale`.`node_id` = `Node`.`id`) LEFT JOIN `ad_localizations` AS `AdLocalization` ON (`NodeAdFemale`.`city_id` = `AdLocalization`.`id`) WHERE `AdLocalization`.`id` = 127 AND `NodeAdFemale`.`promoted` = 1 AND `Node`.`type` = 'NodeAdFemale' AND `NodeAdFemale`.`status` = 1 AND `Node`.`status` = 1 ORDER BY `Node`.`created` DESC LIMIT 10001
53SELECT `NodeImage`.`node_id`, `NodeImage`.`filename`, `NodeImage`.`alt`, `NodeImage`.`weight` FROM `node_images` AS `NodeImage` LEFT JOIN `nodes` AS `Node` ON (`NodeImage`.`node_id` = `Node`.`id`) LEFT JOIN `node_image_caches` AS `NodeImageCache` ON (`NodeImageCache`.`node_image_id` = `NodeImage`.`id`) WHERE `NodeImage`.`node_id` IS NULL AND `NodeImage`.`weight` = 0 ORDER BY `NodeImage`.`weight` ASC 000
54SELECT `Node`.`id`, `Node`.`title`, `Node`.`created`, `Node`.`type`, `NodeAdFemale`.`promoted`, `NodeAdFemale`.`node_id`, `AdLocalization`.`id`, `AdLocalization`.`name`, `NodeAdFemale`.`age`, `NodeAdFemale`.`weight`, `NodeAdFemale`.`height`, `NodeAdFemale`.`id` FROM `node_ad_females` AS `NodeAdFemale` LEFT JOIN `nodes` AS `Node` ON (`NodeAdFemale`.`node_id` = `Node`.`id`) LEFT JOIN `ad_localizations` AS `AdLocalization` ON (`NodeAdFemale`.`city_id` = `AdLocalization`.`id`) WHERE `AdLocalization`.`parent_id` = 25 AND `NodeAdFemale`.`promoted` = 1 AND `Node`.`type` = 'NodeAdFemale' AND `NodeAdFemale`.`status` = 1 AND `Node`.`status` = 1 ORDER BY `Node`.`created` DESC LIMIT 1010100
55SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`model_id`, `Rating`.`model`, `Rating`.`rating`, `Rating`.`created`, `Rating`.`modified` FROM `ratings` AS `Rating` WHERE `model` = 'NodeAdFemale' AND `Rating`.`model_id` IN (1169, 1166, 1165, 1163, 1161, 1159, 1124, 1041, 1027, 1022) 330
56SELECT `NodeImage`.`node_id`, `NodeImage`.`filename`, `NodeImage`.`alt`, `NodeImage`.`weight` FROM `node_images` AS `NodeImage` LEFT JOIN `nodes` AS `Node` ON (`NodeImage`.`node_id` = `Node`.`id`) LEFT JOIN `node_image_caches` AS `NodeImageCache` ON (`NodeImageCache`.`node_image_id` = `NodeImage`.`id`) WHERE `NodeImage`.`node_id` IN (2772, 2769, 2768, 2766, 2764, 2762, 2670, 2479, 2459, 2445) AND `NodeImage`.`weight` = 0 ORDER BY `NodeImage`.`weight` ASC 32320