+ Register
(default) 58 queries took 450 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `nodes`10100
2DESCRIBE `users`880
3DESCRIBE `comments`880
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`11110
13DESCRIBE `videos`880
14DESCRIBE `node_images`990
15DESCRIBE `node_image_caches`14140
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` = '107.21.163.227' AND `visited` >= 1398010096 11313
22INSERT INTO `visitors` (`ip`, `visited`) VALUES ('107.21.163.227', 1398010997)11
23SELECT LAST_INSERT_ID() AS insertID110
24SELECT COUNT(*) AS `count` FROM `visitors` AS `Visitor` WHERE `visited` >= 1398010097 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` = 275 LIMIT 1111
48SELECT `AdLocalization`.`id`, `AdLocalization`.`parent_id`, `AdLocalization`.`lft`, `AdLocalization`.`rght`, `AdLocalization`.`name` FROM `ad_localizations` AS `AdLocalization` WHERE 1 = 1 AND `AdLocalization`.`lft` <= 179 AND `AdLocalization`.`rght` >= 180 ORDER BY `AdLocalization`.`lft` asc 331
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` = 275 AND `NodeAdFemale`.`promoted` = 0 AND `Node`.`type` = 'NodeAdFemale' AND `NodeAdFemale`.`status` = 1 AND `Node`.`status` = 1 ORDER BY `Node`.`created` DESC 001
50SELECT `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
51SELECT `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` = 275 AND `NodeAdFemale`.`promoted` = 1 AND `Node`.`type` = 'NodeAdFemale' AND `NodeAdFemale`.`status` = 1 AND `Node`.`status` = 1 ORDER BY `Node`.`created` DESC LIMIT 10001
52SELECT `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
53SELECT `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` = 28 AND `NodeAdFemale`.`promoted` = 0 AND `Node`.`type` = 'NodeAdFemale' AND `NodeAdFemale`.`status` = 1 AND `Node`.`status` = 1 ORDER BY `Node`.`created` DESC 33330
54SELECT `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 (1068, 1055, 1054, 940, 914, 897, 615, 108, 464, 646, 651, 650, 649, 648, 647, 644, 643, 642, 605, 586, 563, 537, 535, 504, 467, 440, 413, 327, 319, 253, 252, 246, 245) 14140
55SELECT `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 (2559, 2509, 2508, 2275, 2233, 2162, 1652, 346, 1264, 1695, 1701, 1700, 1699, 1698, 1697, 1692, 1691, 1690, 1632, 1598, 1570, 1501, 1498, 1390, 1276, 1193, 1132, 920, 908, 803, 802, 794, 793) AND `NodeImage`.`weight` = 0 ORDER BY `NodeImage`.`weight` ASC 36360
56SELECT `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` = 28 AND `NodeAdFemale`.`promoted` = 1 AND `Node`.`type` = 'NodeAdFemale' AND `NodeAdFemale`.`status` = 1 AND `Node`.`status` = 1 ORDER BY `Node`.`created` DESC LIMIT 10550
57SELECT `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 (1014, 1008, 919, 810, 585) 220
58SELECT `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 (2424, 2418, 2240, 1925, 1597) AND `NodeImage`.`weight` = 0 ORDER BY `NodeImage`.`weight` ASC 10100