Too many SQL queries
Created by: morsik
Going into /dashboard/projects makes about 120 SQL queries (for me). This is not good.
It looks like most of them could be merged and no more than 10 could handle this page.
140627 8:39:01 58 Query SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 ORDER BY `users`.`id` ASC LIMIT 1
58 Query SELECT `projects`.`id` FROM `projects` INNER JOIN `namespaces` ON `projects`.`namespace_id` = `namespaces`.`id` WHERE `namespaces`.`owner_id` = 2 AND `namespaces`.`type` IS NULL
58 Query SELECT `projects`.`id` FROM `projects` INNER JOIN `namespaces` ON `projects`.`namespace_id` = `namespaces`.`id` INNER JOIN `users_groups` ON `namespaces`.`id` = `users_groups`.`group_id` WHERE `namespaces`.`type` IN ('Group') AND `users_groups`.`user_id` = 2
58 Query SELECT `projects`.`id` FROM `projects` INNER JOIN `users_projects` ON `projects`.`id` = `users_projects`.`project_id` WHERE `users_projects`.`user_id` = 2
58 Query SELECT projects.id FROM `projects` INNER JOIN `namespaces` ON `namespaces`.`id` = `projects`.`namespace_id` WHERE `projects`.`id` IN (98, 135, 2, 10, 36, 7, 8, 100, 101, 115, 171, 172, 174, 175, 3, 6, 11, 14, 17, 24, 29, 32, 55, 56, 62, 83, 138, 103, 132, 133, 157, 158, 6, 8, 11, 7, 17, 24, 3, 25, 29, 32, 56, 55, 14, 62, 10, 2, 36, 61, 83, 98, 100, 101, 22, 132, 135) ORDER BY namespaces.name ASC
58 Query SELECT `namespaces`.`id` FROM `namespaces` INNER JOIN `users_groups` ON `namespaces`.`id` = `users_groups`.`group_id` WHERE `namespaces`.`type` IN ('Group') AND `users_groups`.`user_id` = 2
58 Query SELECT `projects`.`namespace_id` FROM `projects` INNER JOIN `namespaces` ON `namespaces`.`id` = `projects`.`namespace_id` WHERE `projects`.`id` IN (98, 135, 2, 10, 36, 7, 8, 100, 101, 115, 171, 172, 174, 175, 3, 6, 11, 14, 17, 24, 29, 32, 55, 56, 62, 83, 138, 103, 132, 133, 157, 158, 6, 8, 11, 7, 17, 24, 3, 25, 29, 32, 56, 55, 14, 62, 10, 2, 36, 61, 83, 98, 100, 101, 22, 132, 135) ORDER BY namespaces.name ASC
58 Query SELECT COUNT(*) FROM `projects` INNER JOIN `namespaces` ON `namespaces`.`id` = `projects`.`namespace_id` WHERE `projects`.`id` IN (98, 135, 2, 10, 36, 7, 8, 100, 101, 115, 171, 172, 174, 175, 3, 6, 11, 14, 17, 24, 29, 32, 55, 56, 62, 83, 138, 103, 132, 133, 157, 158, 6, 8, 11, 7, 17, 24, 3, 25, 29, 32, 56, 55, 14, 62, 10, 2, 36, 61, 83, 98, 100, 101, 22, 132, 135)
58 Query SELECT COUNT(*) FROM `projects` INNER JOIN `namespaces` ON `projects`.`namespace_id` = `namespaces`.`id` WHERE `namespaces`.`owner_id` = 2 AND `namespaces`.`type` IS NULL
58 Query SELECT `namespaces`.* FROM `namespaces` WHERE `namespaces`.`owner_id` = 2 AND `namespaces`.`type` IS NULL LIMIT 1
58 Query SELECT COUNT(*) FROM `projects` INNER JOIN `namespaces` ON `namespaces`.`id` = `projects`.`namespace_id` WHERE `projects`.`id` IN (98, 135, 2, 10, 36, 7, 8, 100, 101, 115, 171, 172, 174, 175, 3, 6, 11, 14, 17, 24, 29, 32, 55, 56, 62, 83, 138, 103, 132, 133, 157, 158, 6, 8, 11, 7, 17, 24, 3, 25, 29, 32, 56, 55, 14, 62, 10, 2, 36, 61, 83, 98, 100, 101, 22, 132, 135) AND (namespace_id != 3)
58 Query SELECT `namespaces`.`id` FROM `namespaces` INNER JOIN `users_groups` ON `namespaces`.`id` = `users_groups`.`group_id` WHERE `namespaces`.`type` IN ('Group') AND `users_groups`.`group_access` = 50 AND `users_groups`.`user_id` = 2
58 Query SELECT COUNT(*) FROM `projects` INNER JOIN `namespaces` ON `namespaces`.`id` = `projects`.`namespace_id` WHERE `projects`.`namespace_id` IN (1, 2, 43, 45, 46, 3)
58 Query SELECT `namespaces`.* FROM `namespaces` WHERE `namespaces`.`type` IN ('Group') AND `namespaces`.`id` IN (1, 2, 43, 45, 46, 58, 45, 45, 45, 45, 45, 45, 45, 45, 45, 45, 45, 45, 45, 48, 19, 38, 2, 2, 3, 3, 43, 43, 43, 43, 43, 43, 43, 46, 58, 58, 58, 58, 1, 1, 1) ORDER BY namespaces.name ASC
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 45
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 48
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 38
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 2
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 43
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 46
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 58
58 Query SELECT COUNT(*) FROM `projects` WHERE `projects`.`namespace_id` = 1
58 Query SELECT tags.* FROM `tags` JOIN (SELECT taggings.tag_id FROM `taggings` WHERE (taggings.taggable_type = 'Project' AND taggings.context = 'labels') AND (taggings.taggable_id IN(3,6,11,14,17,24,29,32,55,56,62,83,138,22,25,61,8,7,98,135,100,101,115,171,172,174,175,103,132,133,157,158,2,10,36)) GROUP BY taggings.tag_id) AS taggings ON taggings.tag_id = tags.id
58 Query SELECT `projects`.`id` AS t0_r0, `projects`.`name` AS t0_r1, `projects`.`path` AS t0_r2, `projects`.`description` AS t0_r3, `projects`.`created_at` AS t0_r4, `projects`.`updated_at` AS t0_r5, `projects`.`creator_id` AS t0_r6, `projects`.`issues_enabled` AS t0_r7, `projects`.`wall_enabled` AS t0_r8, `projects`.`merge_requests_enabled` AS t0_r9, `projects`.`wiki_enabled` AS t0_r10, `projects`.`namespace_id` AS t0_r11, `projects`.`issues_tracker` AS t0_r12, `projects`.`issues_tracker_id` AS t0_r13, `projects`.`snippets_enabled` AS t0_r14, `projects`.`last_activity_at` AS t0_r15, `projects`.`import_url` AS t0_r16, `projects`.`visibility_level` AS t0_r17, `projects`.`archived` AS t0_r18, `projects`.`import_status` AS t0_r19, `projects`.`repository_size` AS t0_r20, `namespaces`.`id` AS t1_r0, `namespaces`.`name` AS t1_r1, `namespaces`.`path` AS t1_r2, `namespaces`.`owner_id` AS t1_r3, `namespaces`.`created_at` AS t1_r4, `namespaces`.`updated_at` AS t1_r5, `namespaces`.`type` AS t1_r6, `namespaces`.`description` AS t1_r7, `namespaces`.`avatar` AS t1_r8 FROM `projects` INNER JOIN `namespaces` ON `namespaces`.`id` = `projects`.`namespace_id` WHERE `projects`.`id` IN (98, 135, 2, 10, 36, 7, 8, 100, 101, 115, 171, 172, 174, 175, 3, 6, 11, 14, 17, 24, 29, 32, 55, 56, 62, 83, 138, 103, 132, 133, 157, 158, 6, 8, 11, 7, 17, 24, 3, 25, 29, 32, 56, 55, 14, 62, 10, 2, 36, 61, 83, 98, 100, 101, 22, 132, 135) ORDER BY namespaces.path, projects.name ASC LIMIT 30 OFFSET 0
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 11 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 11 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 11 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 56 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 56 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 56 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 6 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 6 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 6 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 55 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 55 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 55 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 62 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 62 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 62 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 138 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 138 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 138 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 17 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 17 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 17 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 83 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 83 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 83 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 24 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 24 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 24 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 14 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 14 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 14 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 29 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 29 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 29 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 32 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 32 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 32 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 3 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 3 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 3 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 22 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 22 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 22 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users`.* FROM `users` WHERE `users`.`id` = 22 LIMIT 1
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 25 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 25 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 25 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 61 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 61 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 61 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 7 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 7 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 7 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 8 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 8 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 8 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 98 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 98 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 135 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 135 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 100 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 100 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 100 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 115 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 115 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 115 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 172 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 172 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 172 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 174 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 174 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 174 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 175 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 175 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 175 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 101 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 101 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 101 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 171 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 171 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 171 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 103 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 103 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 103 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 158 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 158 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 158 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
62 Query SELECT `namespaces`.* FROM `namespaces` WHERE `namespaces`.`path` = 'salt' LIMIT 1
58 Query SELECT `users_projects`.* FROM `users_projects` WHERE `users_projects`.`project_id` = 157 AND `users_projects`.`user_id` = 2 ORDER BY `users_projects`.`id` ASC LIMIT 1
58 Query SELECT `projects`.* FROM `projects` INNER JOIN `forked_project_links` ON `projects`.`id` = `forked_project_links`.`forked_from_project_id` WHERE `forked_project_links`.`forked_to_project_id` = 157 LIMIT 1
58 Query SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 157 AND `taggings`.`taggable_type` = 'Project' AND (taggings.context = ('labels'))
58 Query SELECT `broadcast_messages`.* FROM `broadcast_messages` WHERE (ends_at > '2014-06-27 06:39:01' AND starts_at < '2014-06-27 06:39:01') ORDER BY `broadcast_messages`.`id` DESC LIMIT 1
62 Query SELECT `projects`.* FROM `projects` WHERE `projects`.`namespace_id` = 58 AND `projects`.`path` = 'xxx' LIMIT 1
62 Query SELECT `keys`.* FROM `keys` WHERE `keys`.`id` = 66 LIMIT 1
62 Query SELECT 1 AS one FROM `projects` INNER JOIN `deploy_keys_projects` ON `projects`.`id` = `deploy_keys_projects`.`project_id` WHERE `deploy_keys_projects`.`deploy_key_id` = 66 AND `projects`.`id` = 157 LIMIT 1
58 Query SELECT `users`.* FROM `users` WHERE `users`.`email` = '[email protected]' LIMIT 1
58 Query SELECT COUNT(*) FROM `issues` WHERE `issues`.`assignee_id` = 2 AND (`issues`.`state` IN ('opened','reopened'))
58 Query SELECT COUNT(*) FROM `merge_requests` WHERE `merge_requests`.`assignee_id` = 2 AND (`merge_requests`.`state` IN ('opened','reopened'))