Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.startupId AS startupId_2,
  t0.location AS location_3,
  t0.locationSecond AS locationSecond_4,
  t0.name AS name_5,
  t0.shortName AS shortName_6,
  t0.previousName AS previousName_7,
  t0.person AS person_8,
  t0.phone AS phone_9,
  t0.addressFieldOne AS addressFieldOne_10,
  t0.addressFieldTwo AS addressFieldTwo_11,
  t0.addressCountryCode AS addressCountryCode_12,
  t0.addressPostalCode AS addressPostalCode_13,
  t0.addressCity AS addressCity_14,
  t0.spTeamId AS spTeamId_15,
  t0.accountEmail AS accountEmail_16,
  t0.connectEmail AS connectEmail_17,
  t0.status AS status_18,
  t0.active AS active_19,
  t0.hasCommunityMembership AS hasCommunityMembership_20,
  t0.isTransponderAllowed AS isTransponderAllowed_21,
  t0.hasStartupMembership AS hasStartupMembership_22,
  t0.isIncludeInUpdateType AS isIncludeInUpdateType_23,
  t0.isCompany AS isCompany_24,
  t0.isAddressComplete AS isAddressComplete_25,
  t0.isDebitor AS isDebitor_26,
  t0.type AS type_27,
  t0.internalDescription AS internalDescription_28,
  t0.monsumCustomerType AS monsumCustomerType_29,
  t0.homepage AS homepage_30,
  t0.logoURL AS logoURL_31,
  t0.industries AS industries_32,
  t0.description AS description_33,
  t0.note AS note_34,
  t0.tags AS tags_35,
  t0.categories AS categories_36,
  t0.alertNote AS alertNote_37,
  t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_38,
  t0.monthlyExtraBudget AS monthlyExtraBudget_39,
  t0.sameDayBudget AS sameDayBudget_40,
  t0.sameDayBudgetUsed AS sameDayBudgetUsed_41,
  t0.sameDayExtraBudget AS sameDayExtraBudget_42,
  t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_43,
  t0.communityBudget AS communityBudget_44,
  t0.communityBudgetUsed AS communityBudgetUsed_45,
  t0.meetingRoomsBudget AS meetingRoomsBudget_46,
  t0.conferenceRoomsBudget AS conferenceRoomsBudget_47,
  t0.coffeeCoinsBudget AS coffeeCoinsBudget_48,
  t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_49,
  t0.meetingRoomsBooked AS meetingRoomsBooked_50,
  t0.conferenceRoomsBooked AS conferenceRoomsBooked_51,
  t0.todayRoomsBooked AS todayRoomsBooked_52,
  t0.nDedicatedDesks AS nDedicatedDesks_53,
  t0.nFlexibleDesks AS nFlexibleDesks_54,
  t0.nBasicMemberships AS nBasicMemberships_55,
  t0.nEmployees AS nEmployees_56,
  t0.nTransponders AS nTransponders_57,
  t0.nTiefgarage AS nTiefgarage_58,
  t0.editStatus AS editStatus_59,
  t0.xing AS xing_60,
  t0.linkedin AS linkedin_61,
  t0.facebook AS facebook_62,
  t0.twitter AS twitter_63,
  t0.instagram AS instagram_64,
  t0.enterDate AS enterDate_65,
  t0.lastChangeDate AS lastChangeDate_66,
  t0.lastModified AS lastModified_67,
  t0.lastInvoiceDate AS lastInvoiceDate_68,
  t0.exitDate AS exitDate_69,
  t0.isRedundant AS isRedundant_70,
  t0.gsStatus AS gsStatus_71,
  t0.gsBatchNo AS gsBatchNo_72,
  t0.gsNote AS gsNote_73,
  t0.gsIdeenblattDate AS gsIdeenblattDate_74,
  t0.gsJuryDate AS gsJuryDate_75,
  t0.gsCoachMemberId AS gsCoachMemberId_76,
  t0.gsCoachMemberName AS gsCoachMemberName_77,
  t0.spContactPerson AS spContactPerson_78,
  t0.memberTag AS memberTag_79,
  t0.zapierWebhook AS zapierWebhook_80,
  t0.actionTag AS actionTag_81,
  t0.createdAt AS createdAt_82,
  t0.lastChangeUser AS lastChangeUser_83,
  t0.history AS history_84,
  t0.treatAsSubscribed AS treatAsSubscribed_85,
  t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_86,
  t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_87,
  t0.treatAsSubscribedReason AS treatAsSubscribedReason_88,
  t0.searchAliases AS searchAliases_89
FROM
  sp_teams t0
WHERE
  (
    t0.id IN (?)
    OR t0.id IS NULL
  )

SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.active AS active_19, t0.hasCommunityMembership AS hasCommunityMembership_20, t0.isTransponderAllowed AS isTransponderAllowed_21, t0.hasStartupMembership AS hasStartupMembership_22, t0.isIncludeInUpdateType AS isIncludeInUpdateType_23, t0.isCompany AS isCompany_24, t0.isAddressComplete AS isAddressComplete_25, t0.isDebitor AS isDebitor_26, t0.type AS type_27, t0.internalDescription AS internalDescription_28, t0.monsumCustomerType AS monsumCustomerType_29, t0.homepage AS homepage_30, t0.logoURL AS logoURL_31, t0.industries AS industries_32, t0.description AS description_33, t0.note AS note_34, t0.tags AS tags_35, t0.categories AS categories_36, t0.alertNote AS alertNote_37, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_38, t0.monthlyExtraBudget AS monthlyExtraBudget_39, t0.sameDayBudget AS sameDayBudget_40, t0.sameDayBudgetUsed AS sameDayBudgetUsed_41, t0.sameDayExtraBudget AS sameDayExtraBudget_42, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_43, t0.communityBudget AS communityBudget_44, t0.communityBudgetUsed AS communityBudgetUsed_45, t0.meetingRoomsBudget AS meetingRoomsBudget_46, t0.conferenceRoomsBudget AS conferenceRoomsBudget_47, t0.coffeeCoinsBudget AS coffeeCoinsBudget_48, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_49, t0.meetingRoomsBooked AS meetingRoomsBooked_50, t0.conferenceRoomsBooked AS conferenceRoomsBooked_51, t0.todayRoomsBooked AS todayRoomsBooked_52, t0.nDedicatedDesks AS nDedicatedDesks_53, t0.nFlexibleDesks AS nFlexibleDesks_54, t0.nBasicMemberships AS nBasicMemberships_55, t0.nEmployees AS nEmployees_56, t0.nTransponders AS nTransponders_57, t0.nTiefgarage AS nTiefgarage_58, t0.editStatus AS editStatus_59, t0.xing AS xing_60, t0.linkedin AS linkedin_61, t0.facebook AS facebook_62, t0.twitter AS twitter_63, t0.instagram AS instagram_64, t0.enterDate AS enterDate_65, t0.lastChangeDate AS lastChangeDate_66, t0.lastModified AS lastModified_67, t0.lastInvoiceDate AS lastInvoiceDate_68, t0.exitDate AS exitDate_69, t0.isRedundant AS isRedundant_70, t0.gsStatus AS gsStatus_71, t0.gsBatchNo AS gsBatchNo_72, t0.gsNote AS gsNote_73, t0.gsIdeenblattDate AS gsIdeenblattDate_74, t0.gsJuryDate AS gsJuryDate_75, t0.gsCoachMemberId AS gsCoachMemberId_76, t0.gsCoachMemberName AS gsCoachMemberName_77, t0.spContactPerson AS spContactPerson_78, t0.memberTag AS memberTag_79, t0.zapierWebhook AS zapierWebhook_80, t0.actionTag AS actionTag_81, t0.createdAt AS createdAt_82, t0.lastChangeUser AS lastChangeUser_83, t0.history AS history_84, t0.treatAsSubscribed AS treatAsSubscribed_85, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_86, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_87, t0.treatAsSubscribedReason AS treatAsSubscribedReason_88, t0.searchAliases AS searchAliases_89 FROM sp_teams t0 WHERE (t0.id IN (NULL, 25280, 25282, 25279, 20456, 24161, 10590, 23807, 22905, 17320, 18111, 14813, 12442, 11654, 24218, 22426, 25281, 25278, 25277, 23156, 23342, 21764, 23612, 23873, 17291, 22465, 20949, 18380, 23803, 23356, 24167, 22428, 24319, 24136, 21556, 23732, 20040, 14284, 13810, 14298, 14797, 10897, 10576, 11689, 15245, 10827, 14622, 15414, 15474, 16277, 10128, 10029, 15249, 15040, 14286, 15572, 10490, 13427, 15479, 14333, 15618, 11481, 15083, 13429, 15264, 11653, 10427, 15323, 10426, 10514, 15427, 15009, 15235, 10273, 14787, 23989, 23638, 15151, 16439, 10921, 10259, 10335, 10184, 10493, 11025, 10507, 17266, 14848, 18399, 17128, 16100, 17414, 16967, 11977, 10421, 23912, 18703, 10030, 14473, 18515, 23808, 14292, 13575, 20628, 22196, 23579, 23946, 23192, 23315, 16021, 16713, 10059, 21708, 18437, 22279, 18133, 22304, 23492, 10062, 14676, 14711, 23474, 11652, 20867, 23089, 22860, 23806, 22880, 20930, 10346, 17176, 23001, 21915, 23063, 22460, 11715, 23526, 23751, 10170, 23486, 18936, 18798, 23083, 19649, 23311, 23738, 23729, 23663, 23653, 16209, 20155, 22551, 20654, 19777, 21846, 21102, 20860, 21110, 17764, 21250, 11171, 16531, 13264, 22515, 20726, 22528, 21204, 16061, 18554, 11106, 19083, 16697, 20619, 13677, 24376, 21849, 21848, 21863, 21675, 21821, 21806, 21736, 21827, 21033, 21003, 20593, 21727, 21712, 21706, 21692, 21070, 21716, 14658, 19915, 16641, 19763, 16340, 16803, 20009, 21064, 16802, 21308, 16801, 19614, 19840, 16799, 19839, 19743, 16797, 19495, 19651, 19510, 19846, 10158, 19577, 19498, 19860, 10178, 19696, 10159, 19745, 10252, 19770, 10387, 15808, 19802, 19645, 19863, 19484, 19901, 19782, 19610, 19711, 10542, 19784, 19656, 10405, 19817, 17811, 15402, 19838, 19847, 16991, 19914, 19849, 11447, 16796, 19606, 19829, 19785, 19546, 19636, 17075, 16635, 16341, 19588, 19923, 10371, 17009, 19823, 19781, 19795, 13500, 19578, 19599, 19831, 19773, 19729, 19507, 13385, 19642, 10628, 14585, 19918, 19707, 10975, 19528, 19775, 19675, 19519, 19868, 17311, 19822, 19752, 19830, 19872, 19732, 17312, 19756, 15094, 20651, 17313, 19894, 19605, 19668, 19522, 19909, 19618, 19535, 19673, 15359, 19666, 19882, 19718, 19612, 19644, 19616, 17575, 19828, 15752, 19820, 13766, 19893, 19567, 19818, 19685, 19643, 19702, 19701, 19698, 19721, 14782, 19913, 19857, 15278, 19758, 19553, 19734, 19493, 19911, 19737, 16103, 17314, 16202, 16211, 16745, 16184, 16380, 16494, 15847, 16430, 15375, 16576, 17070, 16653, 16912, 16901, 16790, 19928, 19924, 16642, 17146, 17142, 17078, 17217, 17225, 15820, 17353, 17390, 17368, 17554, 16601, 17833, 17864, 18068, 18093, 17940, 18775, 18766, 16726, 19858, 11978, 17455, 16724, 17753, 17498, 18041, 19081, 21332, 20264, 17413, 16087, 20635, 19068, 19160, 19156, 19118, 20051, 20274, 20385, 16424, 20474, 20495, 20755, 20674, 17853, 20811, 20820, 20983, 18395, 17803, 21098, 21076, 21045, 21434, 21297, 21270, 21266, 21185, 21268, 17507, 17371, 17578, 20968, 17754, 17190, 16428, 18155, 18153, 18128, 17653, 17634, 17573, 16942, 17380, 16717, 18549, 18548, 18547, 18546, 17860, 21458, 17733, 17073, 17344, 18919, 18915, 18916, 18918, 18920, 20873, 20028, 18921, 18917, 20470, 20468, 19276, 19274, 19275, 14472, 14754, 13334, 15150, 15145, 14534, 15165, 14294, 14287, 14790, 16427, 14795, 14789, 15504, 15486, 14792, 16431, 16429, 20469, 19273, 19015, 20026, 20029, 20027, 19293, 20030, 20197, 20031, 20140, 20295, 20294, 20296, 17428, 18808, 20465, 20466, 20467, 20590, 18301, 20297, 14297, 16638, 16530, 20571, 20866, 20908, 21130, 20885, 14279, 13291, 19370, 19360, 19374, 19416, 21115, 14651, 17442, 13452, 13625, 15758, 16426, 18411, 19710, 10113, 10002, 10539, 10317, 10008, 14509, 12035, 15684, 18122, 16711, 20248, 10394, 10432, 16994, 10466, 15771, 19303, 18675, 17457, 18438, 10512, 18082, 17643, 10219, 16622, 19195, 15740, 15332, 17486, 16302, 11233, 13488, 16962, 16432, 14891, 14350, 20245, 19695, 19581, 18409, 19805, 25866, 19789, 15783, 16585, 25873, 10483, 11824, 19564, 19597, 16490, 19525, 14069, 19548, 25884, 19791, 16197, 25877, 15259, 17202, 11842, 25910, 19855, 19919, 19920, 19917, 19910, 19908, 19906, 19903, 19902, 19899, 19900, 19898, 19896, 19895, 19892, 19891, 19888, 19886, 19887, 19884, 19885, 19883, 19880, 19881, 19877, 19874, 19873, 19871, 19869, 19870, 19867, 19865, 19861, 19862, 19859, 19856, 19852, 19853, 19851, 19848, 19844, 19841, 19834, 19835, 19833, 19827, 19825, 19821, 19815, 19816, 19814, 19813, 19812, 19810, 19811, 19808, 19809, 19807, 19804, 19803, 19801, 19798, 19799, 19796, 19797, 19793, 19794, 19790, 19788, 19787, 19786, 19783, 19780, 19778, 19779, 19776, 19771, 19772, 19768, 19769, 19766, 19767, 19764, 19765, 19762, 19759, 19757, 19753, 19751, 19750, 19748, 19746, 19747, 19740, 19738, 19739, 19735, 19733, 19731, 19730, 19727, 19726, 19724, 19725, 19722, 19719, 19716, 19712, 19709, 19705, 19706, 19704, 19700, 19699, 19694, 19692, 19693, 19691, 19689, 19687, 19688, 19686, 19684, 19680, 19681, 19679, 19677, 19674, 19672, 19670, 19667, 19664, 19665, 19663, 19661, 19659, 19654, 19655, 19652, 19650, 19646, 19647, 19640, 19637, 19638, 19634, 19635, 19633, 19631, 19629, 19630, 19627, 19628, 19626, 19624, 19625, 19622, 19623, 19621, 19619, 19620, 19615, 19613, 19609, 19608, 19607, 19603, 19604, 19601, 19602, 19600, 19598, 19595, 19594, 19592, 19591, 19589, 19590, 19586, 19585, 19579, 19575, 19576, 19572, 19571, 19570, 19568, 19566, 19565, 19563, 19561, 19562, 19559, 19557, 19555, 19554, 19552, 19550, 19551, 19549, 19547, 19544, 19545, 19542, 19543, 19541, 19539, 19538, 19536, 19534, 19530, 19531, 19529, 19527, 19526, 19524, 19523, 19521, 19520, 19518, 19517, 19515, 19514, 19512, 19513, 19509, 19508, 19506, 19505, 19503, 19501, 19500, 19499, 19497, 19494, 19492, 19490, 19488, 19486, 19485, 19483, 19481, 19480, 17882, 17878, 17881, 17880, 17879, 17895, 17693, 17739, 17707, 18372, 18275, 18327, 18300, 18351, 18325, 18326, 17832, 18056, 10050, 17386, 16612, 17319, 17318, 17023, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16371, NULL, NULL, NULL, NULL, 16279, 16425, 25912, NULL, 25905, 15352, 15540, 10229, 25852, NULL, 16725, NULL, NULL, NULL, NULL, NULL, NULL, 13312, 15825, 15435, 15531, 11858, NULL, 16206, 14796, 11463, 11196, NULL, 10516, 11583, 13321, NULL, 10502, 16298, 16205, 14288, 15326, 16189, 25913, 25916, 25899, 25903, 25904, 13656, 25891, 25892, 25893, 25894, 25895, 13312, 25886, NULL, 14364, 25881, 25876, 25878, 25872, 25870, 25867, 25868, 25850, 25846, 25843, 16722, 16723, 12264, 16561, 16515, 16714, 16715, 16719, 16273, 16183, 16304, 16343, 16347, 16590, 16571, 16190, 16194, 16198, 16199, 16200, 16210, 16218, NULL, 13884, NULL, NULL, NULL, NULL, NULL, 25919, NULL, NULL, NULL, 16116, NULL, 25901, 13771, 15223, 14289, 15357, 15358, 10092, NULL, 25898, 15353, 25900, 14296, NULL, NULL, 10824, 14793, 14206, 16061, 10898, 11446, 14285, 14295, NULL, 25885, NULL, 15526, 25887, 11216, 25888, 25889, 13292, 11226, 25890, 13563, 15140, 13770, NULL, 15621, 15856, 14282, 15476, 10237, 10096, 25880, 15093, 13767, 15398, NULL, NULL, 25874, 25861, 25862, 14786, 15777, 15713, NULL, 11412, 15707, 15575, 14788, NULL, 15530, 15533, 14967, 15816, 14820, 25848, 14890, 25851, 25855, 14005, 15541, 13430, 15426, 13302, 11448, 15319, 10541, 16012, 25839, 14783, 14784, 14785, 10518, 11194, 11232, 13768, 13760, 25875, 11126, 15530, 25906, 25908, 25909, 10068, 10685, 13778, 13831, 15178, 25914, 25917, 25897, 16345, 15304, 25915, 16204, 16589, 25911, 11716, 16112, 16284, 16459, 16580, 16557, 25902, 16061, 25907, 16398, 16186, 16208, 16251, NULL, 25882, 14208, 25883, 16173, 17275, 10040, 10615, 11050, 11557, 13173, 15713, 25865, 16230, 16591, 16587, 16544, 16539, 16419, 16124, 16151, 13840, 16207, 25871, 16264, 16166, 16379, 16578, 16579, 16548, NULL, 25869, 16215, 16492, 16575, 16553, 25859, 14786, 25863, 25864, 25918, 16348, 16196, 16201, 16203, 16213, 16397, 16550, NULL, 16292, 16102, 10037, 25857, 25858, 15532, 25845, 25849, 25853, 25854, 25856, 25844, 17279, 11349, 25840, 25841, 25842, 25838, 13151, 25847, 25860, 25879, 25896) OR t0.id IS NULL);

SELECT
  s0_.id AS id_0,
  s0_.extId AS extId_1,
  s0_.visibility AS visibility_2,
  s0_.teamId AS teamId_3,
  s0_.name AS name_4,
  s0_.status AS status_5,
  s0_.location AS location_6,
  s0_.city AS city_7,
  s0_.website AS website_8,
  s0_.domain AS domain_9,
  s0_.slug AS slug_10,
  s0_.linkedin AS linkedin_11,
  s0_.twitter AS twitter_12,
  s0_.logoUrl AS logoUrl_13,
  s0_.stage AS stage_14,
  s0_.kiAccelerator AS kiAccelerator_15,
  s0_.industry AS industry_16,
  s0_.industryCondensed AS industryCondensed_17,
  s0_.customerFocus AS customerFocus_18,
  s0_.BusinessModel AS BusinessModel_19,
  s0_.tags AS tags_20,
  s0_.todos AS todos_21,
  s0_.foundationYear AS foundationYear_22,
  s0_.funding AS funding_23,
  s0_.oneSentencePitch AS oneSentencePitch_24,
  s0_.employeesCount AS employeesCount_25,
  s0_.revenue AS revenue_26,
  s0_.investors AS investors_27,
  s0_.contactPerson AS contactPerson_28,
  s0_.contactEmail AS contactEmail_29,
  s0_.contactTelefon AS contactTelefon_30,
  s0_.lastModified AS lastModified_31,
  s0_.history AS history_32,
  s0_.lastChangeUser AS lastChangeUser_33,
  s0_.createdAt AS createdAt_34,
  s1_.score AS score_35
FROM
  sp_startup_profiles s0_
  INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId)
WHERE
  s0_.visibility = ?
ORDER BY
  s0_.lastModified DESC
LIMIT
  1280

SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 1280;

SELECT
  s0_.id AS id_0,
  s0_.extId AS extId_1,
  s0_.visibility AS visibility_2,
  s0_.teamId AS teamId_3,
  s0_.name AS name_4,
  s0_.status AS status_5,
  s0_.location AS location_6,
  s0_.city AS city_7,
  s0_.website AS website_8,
  s0_.domain AS domain_9,
  s0_.slug AS slug_10,
  s0_.linkedin AS linkedin_11,
  s0_.twitter AS twitter_12,
  s0_.logoUrl AS logoUrl_13,
  s0_.stage AS stage_14,
  s0_.kiAccelerator AS kiAccelerator_15,
  s0_.industry AS industry_16,
  s0_.industryCondensed AS industryCondensed_17,
  s0_.customerFocus AS customerFocus_18,
  s0_.BusinessModel AS BusinessModel_19,
  s0_.tags AS tags_20,
  s0_.todos AS todos_21,
  s0_.foundationYear AS foundationYear_22,
  s0_.funding AS funding_23,
  s0_.oneSentencePitch AS oneSentencePitch_24,
  s0_.employeesCount AS employeesCount_25,
  s0_.revenue AS revenue_26,
  s0_.investors AS investors_27,
  s0_.contactPerson AS contactPerson_28,
  s0_.contactEmail AS contactEmail_29,
  s0_.contactTelefon AS contactTelefon_30,
  s0_.lastModified AS lastModified_31,
  s0_.history AS history_32,
  s0_.lastChangeUser AS lastChangeUser_33,
  s0_.createdAt AS createdAt_34,
  s1_.score AS score_35
FROM
  sp_startup_profiles s0_
  INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId)
WHERE
  s0_.visibility = ?
ORDER BY
  s0_.lastModified DESC
LIMIT
  128

SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 128;

SELECT
  s0_.id AS id_0,
  s0_.extId AS extId_1,
  s0_.visibility AS visibility_2,
  s0_.teamId AS teamId_3,
  s0_.name AS name_4,
  s0_.status AS status_5,
  s0_.location AS location_6,
  s0_.city AS city_7,
  s0_.website AS website_8,
  s0_.domain AS domain_9,
  s0_.slug AS slug_10,
  s0_.linkedin AS linkedin_11,
  s0_.twitter AS twitter_12,
  s0_.logoUrl AS logoUrl_13,
  s0_.stage AS stage_14,
  s0_.kiAccelerator AS kiAccelerator_15,
  s0_.industry AS industry_16,
  s0_.industryCondensed AS industryCondensed_17,
  s0_.customerFocus AS customerFocus_18,
  s0_.BusinessModel AS BusinessModel_19,
  s0_.tags AS tags_20,
  s0_.todos AS todos_21,
  s0_.foundationYear AS foundationYear_22,
  s0_.funding AS funding_23,
  s0_.oneSentencePitch AS oneSentencePitch_24,
  s0_.employeesCount AS employeesCount_25,
  s0_.revenue AS revenue_26,
  s0_.investors AS investors_27,
  s0_.contactPerson AS contactPerson_28,
  s0_.contactEmail AS contactEmail_29,
  s0_.contactTelefon AS contactTelefon_30,
  s0_.lastModified AS lastModified_31,
  s0_.history AS history_32,
  s0_.lastChangeUser AS lastChangeUser_33,
  s0_.createdAt AS createdAt_34,
  s1_.score AS score_35
FROM
  sp_startup_profiles s0_
  INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId)
WHERE
  s0_.visibility = ?
ORDER BY
  s0_.lastModified DESC
LIMIT
  1145

SELECT s0_.id AS id_0, s0_.extId AS extId_1, s0_.visibility AS visibility_2, s0_.teamId AS teamId_3, s0_.name AS name_4, s0_.status AS status_5, s0_.location AS location_6, s0_.city AS city_7, s0_.website AS website_8, s0_.domain AS domain_9, s0_.slug AS slug_10, s0_.linkedin AS linkedin_11, s0_.twitter AS twitter_12, s0_.logoUrl AS logoUrl_13, s0_.stage AS stage_14, s0_.kiAccelerator AS kiAccelerator_15, s0_.industry AS industry_16, s0_.industryCondensed AS industryCondensed_17, s0_.customerFocus AS customerFocus_18, s0_.BusinessModel AS BusinessModel_19, s0_.tags AS tags_20, s0_.todos AS todos_21, s0_.foundationYear AS foundationYear_22, s0_.funding AS funding_23, s0_.oneSentencePitch AS oneSentencePitch_24, s0_.employeesCount AS employeesCount_25, s0_.revenue AS revenue_26, s0_.investors AS investors_27, s0_.contactPerson AS contactPerson_28, s0_.contactEmail AS contactEmail_29, s0_.contactTelefon AS contactTelefon_30, s0_.lastModified AS lastModified_31, s0_.history AS history_32, s0_.lastChangeUser AS lastChangeUser_33, s0_.createdAt AS createdAt_34, s1_.score AS score_35 FROM sp_startup_profiles s0_ INNER JOIN sp_startup_relevance s1_ ON (s0_.id = s1_.startupId) WHERE s0_.visibility = 'public' ORDER BY s0_.lastModified DESC LIMIT 1145;

SELECT
  s0_.industry AS industry_0,
  COUNT(s0_.id) AS sclr_1
FROM
  sp_startup_profiles s0_
WHERE
  s0_.visibility = ?
GROUP BY
  s0_.industry
ORDER BY
  s0_.industry ASC

SELECT s0_.industry AS industry_0, COUNT(s0_.id) AS sclr_1 FROM sp_startup_profiles s0_ WHERE s0_.visibility = 'public' GROUP BY s0_.industry ORDER BY s0_.industry ASC;