2
1.89 ms
SELECT s0_ . id AS id_0 , s0_ . extId AS extId_1 , s0_ . visibility AS visibility_2 , s0_ . score AS score_3 , s0_ . name AS name_4 , s0_ . teamId AS teamId_5 , s0_ . website AS website_6 , s0_ . domain AS domain_7 , s0_ . slug AS slug_8 , s0_ . status AS status_9 , s0_ . editStatus AS editStatus_10 , s0_ . stage AS stage_11 , s0_ . logoUrl AS logoUrl_12 , s0_ . logoBackground AS logoBackground_13 , s0_ . imageLink AS imageLink_14 , s0_ . currentPitchDeckUrl AS currentPitchDeckUrl_15 , s0_ . kiAccelerator AS kiAccelerator_16 , s0_ . todos AS todos_17 , s0_ . industry AS industry_18 , s0_ . industryCondensed AS industryCondensed_19 , s0_ . customerFocus AS customerFocus_20 , s0_ . BusinessModel AS BusinessModel_21 , s0_ . tags AS tags_22 , s0_ . oneSentencePitch AS oneSentencePitch_23 , s0_ . oneSentencePitchEn AS oneSentencePitchEn_24 , s0_ . foundationYear AS foundationYear_25 , s0_ . location AS location_26 , s0_ . city AS city_27 , s0_ . employeesCount AS employeesCount_28 , s0_ . funding AS funding_29 , s0_ . investors AS investors_30 , s0_ . revenue AS revenue_31 , s0_ . contactPerson AS contactPerson_32 , s0_ . contactEmail AS contactEmail_33 , s0_ . contactTelefon AS contactTelefon_34 , s0_ . xing AS xing_35 , s0_ . linkedin AS linkedin_36 , s0_ . facebook AS facebook_37 , s0_ . twitter AS twitter_38 , s0_ . instagram AS instagram_39 , s0_ . description AS description_40 , s0_ . publicDetailHtml AS publicDetailHtml_41 , s0_ . publicDetailHtmlEn AS publicDetailHtmlEn_42 , s0_ . internalDetailHtml AS internalDetailHtml_43 , s0_ . internalDetailHtmlEn AS internalDetailHtmlEn_44 , s0_ . gsPublicSummary AS gsPublicSummary_45 , s0_ . gsIndustries AS gsIndustries_46 , s0_ . gsKeywords AS gsKeywords_47 , s0_ . gsProfile AS gsProfile_48 , s0_ . comments AS comments_49 , s0_ . history AS history_50 , s0_ . lastChangeUser AS lastChangeUser_51 , s0_ . createdAt AS createdAt_52 , s0_ . lastModified AS lastModified_53 , s0_ . lastChangedBy AS lastChangedBy_54 FROM sp_startup_profiles s0_ WHERE s0_ . kiAccelerator IS NOT NULL ORDER BY s0_ . kiAccelerator ASC , s0_ . name ASC
SELECT
s0_ . id AS id_0 ,
s0_ . extId AS extId_1 ,
s0_ . visibility AS visibility_2 ,
s0_ . score AS score_3 ,
s0_ . name AS name_4 ,
s0_ . teamId AS teamId_5 ,
s0_ . website AS website_6 ,
s0_ . domain AS domain_7 ,
s0_ . slug AS slug_8 ,
s0_ . status AS status_9 ,
s0_ . editStatus AS editStatus_10 ,
s0_ . stage AS stage_11 ,
s0_ . logoUrl AS logoUrl_12 ,
s0_ . logoBackground AS logoBackground_13 ,
s0_ . imageLink AS imageLink_14 ,
s0_ . currentPitchDeckUrl AS currentPitchDeckUrl_15 ,
s0_ . kiAccelerator AS kiAccelerator_16 ,
s0_ . todos AS todos_17 ,
s0_ . industry AS industry_18 ,
s0_ . industryCondensed AS industryCondensed_19 ,
s0_ . customerFocus AS customerFocus_20 ,
s0_ . BusinessModel AS BusinessModel_21 ,
s0_ . tags AS tags_22 ,
s0_ . oneSentencePitch AS oneSentencePitch_23 ,
s0_ . oneSentencePitchEn AS oneSentencePitchEn_24 ,
s0_ . foundationYear AS foundationYear_25 ,
s0_ . location AS location_26 ,
s0_ . city AS city_27 ,
s0_ . employeesCount AS employeesCount_28 ,
s0_ . funding AS funding_29 ,
s0_ . investors AS investors_30 ,
s0_ . revenue AS revenue_31 ,
s0_ . contactPerson AS contactPerson_32 ,
s0_ . contactEmail AS contactEmail_33 ,
s0_ . contactTelefon AS contactTelefon_34 ,
s0_ . xing AS xing_35 ,
s0_ . linkedin AS linkedin_36 ,
s0_ . facebook AS facebook_37 ,
s0_ . twitter AS twitter_38 ,
s0_ . instagram AS instagram_39 ,
s0_ . description AS description_40 ,
s0_ . publicDetailHtml AS publicDetailHtml_41 ,
s0_ . publicDetailHtmlEn AS publicDetailHtmlEn_42 ,
s0_ . internalDetailHtml AS internalDetailHtml_43 ,
s0_ . internalDetailHtmlEn AS internalDetailHtmlEn_44 ,
s0_ . gsPublicSummary AS gsPublicSummary_45 ,
s0_ . gsIndustries AS gsIndustries_46 ,
s0_ . gsKeywords AS gsKeywords_47 ,
s0_ . gsProfile AS gsProfile_48 ,
s0_ . comments AS comments_49 ,
s0_ . history AS history_50 ,
s0_ . lastChangeUser AS lastChangeUser_51 ,
s0_ . createdAt AS createdAt_52 ,
s0_ . lastModified AS lastModified_53 ,
s0_ . lastChangedBy AS lastChangedBy_54
FROM
sp_startup_profiles s0_
WHERE
s0_ . kiAccelerator IS NOT NULL
ORDER BY
s0_ . kiAccelerator ASC ,
s0_ . name ASC
Copy
SELECT s0_ . id AS id_0 , s0_ . extId AS extId_1 , s0_ . visibility AS visibility_2 , s0_ . score AS score_3 , s0_ . name AS name_4 , s0_ . teamId AS teamId_5 , s0_ . website AS website_6 , s0_ . domain AS domain_7 , s0_ . slug AS slug_8 , s0_ . status AS status_9 , s0_ . editStatus AS editStatus_10 , s0_ . stage AS stage_11 , s0_ . logoUrl AS logoUrl_12 , s0_ . logoBackground AS logoBackground_13 , s0_ . imageLink AS imageLink_14 , s0_ . currentPitchDeckUrl AS currentPitchDeckUrl_15 , s0_ . kiAccelerator AS kiAccelerator_16 , s0_ . todos AS todos_17 , s0_ . industry AS industry_18 , s0_ . industryCondensed AS industryCondensed_19 , s0_ . customerFocus AS customerFocus_20 , s0_ . BusinessModel AS BusinessModel_21 , s0_ . tags AS tags_22 , s0_ . oneSentencePitch AS oneSentencePitch_23 , s0_ . oneSentencePitchEn AS oneSentencePitchEn_24 , s0_ . foundationYear AS foundationYear_25 , s0_ . location AS location_26 , s0_ . city AS city_27 , s0_ . employeesCount AS employeesCount_28 , s0_ . funding AS funding_29 , s0_ . investors AS investors_30 , s0_ . revenue AS revenue_31 , s0_ . contactPerson AS contactPerson_32 , s0_ . contactEmail AS contactEmail_33 , s0_ . contactTelefon AS contactTelefon_34 , s0_ . xing AS xing_35 , s0_ . linkedin AS linkedin_36 , s0_ . facebook AS facebook_37 , s0_ . twitter AS twitter_38 , s0_ . instagram AS instagram_39 , s0_ . description AS description_40 , s0_ . publicDetailHtml AS publicDetailHtml_41 , s0_ . publicDetailHtmlEn AS publicDetailHtmlEn_42 , s0_ . internalDetailHtml AS internalDetailHtml_43 , s0_ . internalDetailHtmlEn AS internalDetailHtmlEn_44 , s0_ . gsPublicSummary AS gsPublicSummary_45 , s0_ . gsIndustries AS gsIndustries_46 , s0_ . gsKeywords AS gsKeywords_47 , s0_ . gsProfile AS gsProfile_48 , s0_ . comments AS comments_49 , s0_ . history AS history_50 , s0_ . lastChangeUser AS lastChangeUser_51 , s0_ . createdAt AS createdAt_52 , s0_ . lastModified AS lastModified_53 , s0_ . lastChangedBy AS lastChangedBy_54 FROM sp_startup_profiles s0_ WHERE s0_ . kiAccelerator IS NOT NULL ORDER BY s0_ . kiAccelerator ASC , s0_ . name ASC ;
Copy
3
0.57 ms
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 (? )
Parameters :
[
[
20456
24218
22426
25278
24161
25277
25279
25282
25281
25280
]
]
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 (? )
Copy
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 (20456 , 24218 , 22426 , 25278 , 24161 , 25277 , 25279 , 25282 , 25281 , 25280 );
Copy