Symfony Profiler

http://www.staging.startplatz.de/startups

302 Redirect from: @homepage_startup_single (721f6b)

Method: GET
HTTP Status: 200
IP: 172.22.0.12
Profiled on: Mon, 29 Dec 2025 02:51:09 +0100
Token: 7ee7ba

Last 10 Latest Search

Settings

Query Metrics

17 Database Queries

11 Different statements

52.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
15.18 ms (29.12%)	1	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 FROM aaa_sp_teams t0 WHERE (t0.id IN (?) OR t0.id IS NULL) Parameters: [[ null 16209 20155 14473 10421 22551 20654 19777 21846 21102 18703 13575 20860 21110 10590 21556 14711 17320 17764 14292 21250 11171 16531 17266 13264 18380 22515 22465 20726 20949 22528 21204 16061 18554 10030 11106 19083 16697 20619 13677 14894 21849 21848 21863 21675 21821 21806 21736 21827 21033 21003 20593 21764 21727 21712 21706 21692 21070 21716 14658 11025 14848 19915 16641 19763 16340 16803 20009 21064 16802 21308 16801 19614 19840 16799 19839 19743 16797 19495 19651 19510 19846 10158 10493 19577 19498 19860 10178 19696 10159 19745 10252 19770 10387 15808 10184 19802 10335 19645 19863 19484 19901 19782 19610 19711 10542 19784 10346 19656 10405 10259 19817 17811 15402 19838 19847 16991 19914 19849 11447 16796 19606 19829 19785 19546 19636 17075 16635 16341 19588 19923 10921 10371 17009 19823 19781 19649 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 14284 19668 19522 19909 19618 19535 11654 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 16439 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 18399 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 17291 18915 18916 18918 18920 20873 20028 10059 18921 18917 20470 20468 19276 19274 19275 14472 14754 13334 15151 15150 13810 14298 14797 10897 15145 14534 15165 14294 14287 10576 14790 16427 14676 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 16135 16638 16530 18111 20571 20866 20908 21130 20885 14279 11689 13291 20930 19370 19360 19374 19416 21115 14651 17414 17442 13452 13625 15758 16713 16426 18411 19710 10113 10002 10539 10317 10008 14509 12035 15684 18122 16711 20248 10394 10432 16100 16994 10466 15771 19303 18675 17457 18438 10512 18082 17643 10219 16622 19195 17458 15740 16967 15332 17486 16302 11233 17128 13488 16962 16432 10062 17176 14891 14350 18437 20245 16021 19695 19581 18409 19805 15245 null 19789 15783 16585 null 10483 10827 11824 19564 19597 16490 19525 14069 19548 null 19791 16197 null 15259 17202 11842 null 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 11977 17882 17878 17881 17880 17879 17895 17693 17739 17707 18372 18275 18327 18300 18351 18325 18326 17832 18056 14622 10050 17386 16612 17319 17318 15414 15474 16277 17023 null null null null null null null null 16371 null null null null 16279 16425 10128 null null null 10029 15352 null 10170 10229 null 15249 null 16725 null null null null null null null 15825 15040 15435 15531 11858 14286 null 16206 14796 11463 11196 null 10516 15572 11583 13321 null 10502 16298 16205 null 15326 16189 10490 null null 12442 null null null null null null null null null 13312 null null 14364 null null null null null null null 13427 null null null 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 null null null null 16116 null null null 15223 15479 14289 15357 15358 10092 null null 15353 null 14296 null null 10824 null 14206 null 10898 null null 14333 15618 14295 null null null 15526 null 11216 null null 13292 11226 11481 null 13563 null null 15083 null 15621 13429 15264 15856 null 15476 10237 10096 null 11653 15093 null 10427 15398 null null null null null null 15777 null null 11412 15707 15575 14788 15323 null null 15533 14967 15816 14820 10426 null 14890 null null 14005 null 13430 15426 13302 10514 11448 15319 10541 10507 16012 15427 null 14783 14784 14785 10518 11194 11232 13768 13760 null 11126 15009 15530 null null null 10068 10685 13778 13831 15178 15235 null null null 16345 15304 null 16204 16589 null 11716 16112 16284 16459 16580 16557 null null null 16398 16186 16208 16251 null null null null 16173 17275 10040 10273 10615 11050 11557 13173 15713 null 16230 16591 16587 16544 16539 16419 16124 16151 13840 16207 null 16264 14787 16166 16379 16578 16579 16548 null null 16215 16492 16575 16553 null 14786 null null null 16348 16196 16201 16203 16213 16397 16550 null 16292 16102 10037 null null 15532 null null null null null null 17279 11349 null null null null 13151 null null null null ]] View formatted query View runnable query Explain query 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 FROM aaa_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 FROM aaa_sp_teams t0 WHERE (t0.id IN (NULL, 16209, 20155, 14473, 10421, 22551, 20654, 19777, 21846, 21102, 18703, 13575, 20860, 21110, 10590, 21556, 14711, 17320, 17764, 14292, 21250, 11171, 16531, 17266, 13264, 18380, 22515, 22465, 20726, 20949, 22528, 21204, 16061, 18554, 10030, 11106, 19083, 16697, 20619, 13677, 14894, 21849, 21848, 21863, 21675, 21821, 21806, 21736, 21827, 21033, 21003, 20593, 21764, 21727, 21712, 21706, 21692, 21070, 21716, 14658, 11025, 14848, 19915, 16641, 19763, 16340, 16803, 20009, 21064, 16802, 21308, 16801, 19614, 19840, 16799, 19839, 19743, 16797, 19495, 19651, 19510, 19846, 10158, 10493, 19577, 19498, 19860, 10178, 19696, 10159, 19745, 10252, 19770, 10387, 15808, 10184, 19802, 10335, 19645, 19863, 19484, 19901, 19782, 19610, 19711, 10542, 19784, 10346, 19656, 10405, 10259, 19817, 17811, 15402, 19838, 19847, 16991, 19914, 19849, 11447, 16796, 19606, 19829, 19785, 19546, 19636, 17075, 16635, 16341, 19588, 19923, 10921, 10371, 17009, 19823, 19781, 19649, 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, 14284, 19668, 19522, 19909, 19618, 19535, 11654, 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, 16439, 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, 18399, 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, 17291, 18915, 18916, 18918, 18920, 20873, 20028, 10059, 18921, 18917, 20470, 20468, 19276, 19274, 19275, 14472, 14754, 13334, 15151, 15150, 13810, 14298, 14797, 10897, 15145, 14534, 15165, 14294, 14287, 10576, 14790, 16427, 14676, 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, 16135, 16638, 16530, 18111, 20571, 20866, 20908, 21130, 20885, 14279, 11689, 13291, 20930, 19370, 19360, 19374, 19416, 21115, 14651, 17414, 17442, 13452, 13625, 15758, 16713, 16426, 18411, 19710, 10113, 10002, 10539, 10317, 10008, 14509, 12035, 15684, 18122, 16711, 20248, 10394, 10432, 16100, 16994, 10466, 15771, 19303, 18675, 17457, 18438, 10512, 18082, 17643, 10219, 16622, 19195, 17458, 15740, 16967, 15332, 17486, 16302, 11233, 17128, 13488, 16962, 16432, 10062, 17176, 14891, 14350, 18437, 20245, 16021, 19695, 19581, 18409, 19805, 15245, NULL, 19789, 15783, 16585, NULL, 10483, 10827, 11824, 19564, 19597, 16490, 19525, 14069, 19548, NULL, 19791, 16197, NULL, 15259, 17202, 11842, NULL, 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, 11977, 17882, 17878, 17881, 17880, 17879, 17895, 17693, 17739, 17707, 18372, 18275, 18327, 18300, 18351, 18325, 18326, 17832, 18056, 14622, 10050, 17386, 16612, 17319, 17318, 15414, 15474, 16277, 17023, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16371, NULL, NULL, NULL, NULL, 16279, 16425, 10128, NULL, NULL, NULL, 10029, 15352, NULL, 10170, 10229, NULL, 15249, NULL, 16725, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15825, 15040, 15435, 15531, 11858, 14286, NULL, 16206, 14796, 11463, 11196, NULL, 10516, 15572, 11583, 13321, NULL, 10502, 16298, 16205, NULL, 15326, 16189, 10490, NULL, NULL, 12442, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13312, NULL, NULL, 14364, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13427, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, 16116, NULL, NULL, NULL, 15223, 15479, 14289, 15357, 15358, 10092, NULL, NULL, 15353, NULL, 14296, NULL, NULL, 10824, NULL, 14206, NULL, 10898, NULL, NULL, 14333, 15618, 14295, NULL, NULL, NULL, 15526, NULL, 11216, NULL, NULL, 13292, 11226, 11481, NULL, 13563, NULL, NULL, 15083, NULL, 15621, 13429, 15264, 15856, NULL, 15476, 10237, 10096, NULL, 11653, 15093, NULL, 10427, 15398, NULL, NULL, NULL, NULL, NULL, NULL, 15777, NULL, NULL, 11412, 15707, 15575, 14788, 15323, NULL, NULL, 15533, 14967, 15816, 14820, 10426, NULL, 14890, NULL, NULL, 14005, NULL, 13430, 15426, 13302, 10514, 11448, 15319, 10541, 10507, 16012, 15427, NULL, 14783, 14784, 14785, 10518, 11194, 11232, 13768, 13760, NULL, 11126, 15009, 15530, NULL, NULL, NULL, 10068, 10685, 13778, 13831, 15178, 15235, NULL, NULL, NULL, 16345, 15304, NULL, 16204, 16589, NULL, 11716, 16112, 16284, 16459, 16580, 16557, NULL, NULL, NULL, 16398, 16186, 16208, 16251, NULL, NULL, NULL, NULL, 16173, 17275, 10040, 10273, 10615, 11050, 11557, 13173, 15713, NULL, 16230, 16591, 16587, 16544, 16539, 16419, 16124, 16151, 13840, 16207, NULL, 16264, 14787, 16166, 16379, 16578, 16579, 16548, NULL, NULL, 16215, 16492, 16575, 16553, NULL, 14786, NULL, NULL, NULL, 16348, 16196, 16201, 16203, 16213, 16397, 16550, NULL, 16292, 16102, 10037, NULL, NULL, 15532, NULL, NULL, NULL, NULL, NULL, NULL, 17279, 11349, NULL, NULL, NULL, NULL, 13151, NULL, NULL, NULL, NULL) OR t0.id IS NULL);
11.21 ms (21.51%)	1	SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? ORDER BY a0_.lastModified DESC LIMIT 1083 Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? ORDER BY a0_.lastModified DESC LIMIT 1083 SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = 'public' ORDER BY a0_.lastModified DESC LIMIT 1083;
6.57 ms (12.61%)	3	SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.startplatz = ? ORDER BY a0_.lastModified DESC LIMIT 128 Parameters: [`"public" "sp-cgn"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.startplatz = ? ORDER BY a0_.lastModified DESC LIMIT 128 SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = 'public' AND a0_.startplatz = 'sp-cgn' ORDER BY a0_.lastModified DESC LIMIT 128;
6.32 ms (12.13%)	3	SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.batch = ? ORDER BY a0_.lastModified DESC LIMIT 128 Parameters: [`"public" "26"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.batch = ? ORDER BY a0_.lastModified DESC LIMIT 128 SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = 'public' AND a0_.batch = '26' ORDER BY a0_.lastModified DESC LIMIT 128;
5.20 ms (9.98%)	1	SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.startplatz = ? ORDER BY a0_.lastModified DESC LIMIT 1083 Parameters: [`"public" "extern"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.startplatz = ? ORDER BY a0_.lastModified DESC LIMIT 1083 SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = 'public' AND a0_.startplatz = 'extern' ORDER BY a0_.lastModified DESC LIMIT 1083;
2.77 ms (5.31%)	2	SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.gsStatus IN (?) ORDER BY a0_.lastModified DESC LIMIT 1280 Parameters: [`"public" [ "funded" "recommended" ]`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.gsStatus IN (?) ORDER BY a0_.lastModified DESC LIMIT 1280 SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = 'public' AND a0_.gsStatus IN ('funded', 'recommended') ORDER BY a0_.lastModified DESC LIMIT 1280;
1.39 ms (2.67%)	1	SELECT a0_.industry AS industry_0, COUNT(a0_.id) AS sclr_1 FROM aaa_startups a0_ WHERE a0_.visibility = ? GROUP BY a0_.industry ORDER BY a0_.industry ASC Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT a0_.industry AS industry_0, COUNT(a0_.id) AS sclr_1 FROM aaa_startups a0_ WHERE a0_.visibility = ? GROUP BY a0_.industry ORDER BY a0_.industry ASC SELECT a0_.industry AS industry_0, COUNT(a0_.id) AS sclr_1 FROM aaa_startups a0_ WHERE a0_.visibility = 'public' GROUP BY a0_.industry ORDER BY a0_.industry ASC;
1.25 ms (2.40%)	2	SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasFollowUp AS hasFollowUp_24, t0.isNetworking AS isNetworking_25, t0.networkingRounds AS networkingRounds_26, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28, t0.isFutureEvent AS isFutureEvent_29, t0.visibility AS visibility_30, t0.access AS access_31, t0.tags AS tags_32, t0.typeformLink AS typeformLink_33, t0.zoomLink AS zoomLink_34, t0.bgImageUrl AS bgImageUrl_35, t0.startDate AS startDate_36, t0.endDate AS endDate_37, t0.stripePriceId AS stripePriceId_38, t0.stripeProductId AS stripeProductId_39, t0.stripeAccount AS stripeAccount_40, t0.isFreeForKiCampus AS isFreeForKiCampus_41, t0.isFreeForCommunity AS isFreeForCommunity_42, t0.mailDesignTemplate AS mailDesignTemplate_43, t0.senderMail AS senderMail_44, t0.fromName AS fromName_45, t0.recipientMonitoringMail AS recipientMonitoringMail_46, t0.confirmationMailSubject AS confirmationMailSubject_47, t0.confirmationMailContent AS confirmationMailContent_48, t0.adminNotificationMailSubject AS adminNotificationMailSubject_49, t0.adminNotificationMailContent AS adminNotificationMailContent_50, t0.reminderMailTemplateId AS reminderMailTemplateId_51, t0.reminderSenderEmail AS reminderSenderEmail_52, t0.reminderBulkMailId AS reminderBulkMailId_53, t0.reminderMailSendDate AS reminderMailSendDate_54, t0.reminderMailSubject AS reminderMailSubject_55, t0.reminderMailContent AS reminderMailContent_56, t0.$reminderMailStatus AS reminderMailStatus_57, t0.surveyId AS surveyId_58, t0.surveyMailTemplateId AS surveyMailTemplateId_59, t0.surveyBulkMailId AS surveyBulkMailId_60, t0.template AS template_61, t0.pageTemplate AS pageTemplate_62, t0.footerTemplate AS footerTemplate_63, t0.email AS email_64, t0.emailSubject AS emailSubject_65, t0.emailContent AS emailContent_66, t0.landingPageContent AS landingPageContent_67, t0.landingPageDescription AS landingPageDescription_68, t0.landingPageCss AS landingPageCss_69, t0.landingPageJs AS landingPageJs_70, t0.landingPageFooterTemplate AS landingPageFooterTemplate_71, t0.landingPageSocialImage AS landingPageSocialImage_72, t0.landingPageTitle AS landingPageTitle_73, t0.landingPageTwig AS landingPageTwig_74, t0.goToPage AS goToPage_75, t0.phrasesDe AS phrasesDe_76, t0.phrasesEn AS phrasesEn_77, t0.settings AS settings_78, t0.asssesmentDimensions AS asssesmentDimensions_79, t0.start AS start_80, t0.end AS end_81, t0.pitchTopic AS pitchTopic_82, t0.pitchImageLink AS pitchImageLink_83, t0.pitchVideoLink AS pitchVideoLink_84, t0.pitchPartner AS pitchPartner_85, t0.pitchPartnerId AS pitchPartnerId_86, t0.pitchDescription AS pitchDescription_87, t0.followUpPageContent AS followUpPageContent_88, t0.followUpPageDescription AS followUpPageDescription_89, t0.followUpPageCss AS followUpPageCss_90, t0.followUpPageJs AS followUpPageJs_91, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_92, t0.followUpPageTitle AS followUpPageTitle_93, t0.followUpPageSocialImage AS followUpPageSocialImage_94, t0.followUpDescription AS followUpDescription_95, t0.followUpVideoLink AS followUpVideoLink_96, t0.followUpPresentation AS followUpPresentation_97, t0.pitchDate AS pitchDate_98, t0.pitchTime AS pitchTime_99, t0.city AS city_100, t0.applicationsCount AS applicationsCount_101, t0.startedCount AS startedCount_102, t0.appliedCount AS appliedCount_103, t0.approvedCount AS approvedCount_104, t0.rejectedCount AS rejectedCount_105, t0.$skoolWebhook AS skoolWebhook_106, t0.zapierWebhook AS zapierWebhook_107, t0.history AS history_108, t0.createdAt AS createdAt_109, t0.lastModified AS lastModified_110, t0.lastChangeUser AS lastChangeUser_111, t0.program_id AS program_id_112, t0.assessmentTeamId AS assessmentTeamId_113 FROM aab_batches t0 WHERE t0.programId = ? AND t0.focusStatus = ? LIMIT 1 Parameters: [`3 "2_current"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasFollowUp AS hasFollowUp_24, t0.isNetworking AS isNetworking_25, t0.networkingRounds AS networkingRounds_26, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28, t0.isFutureEvent AS isFutureEvent_29, t0.visibility AS visibility_30, t0.access AS access_31, t0.tags AS tags_32, t0.typeformLink AS typeformLink_33, t0.zoomLink AS zoomLink_34, t0.bgImageUrl AS bgImageUrl_35, t0.startDate AS startDate_36, t0.endDate AS endDate_37, t0.stripePriceId AS stripePriceId_38, t0.stripeProductId AS stripeProductId_39, t0.stripeAccount AS stripeAccount_40, t0.isFreeForKiCampus AS isFreeForKiCampus_41, t0.isFreeForCommunity AS isFreeForCommunity_42, t0.mailDesignTemplate AS mailDesignTemplate_43, t0.senderMail AS senderMail_44, t0.fromName AS fromName_45, t0.recipientMonitoringMail AS recipientMonitoringMail_46, t0.confirmationMailSubject AS confirmationMailSubject_47, t0.confirmationMailContent AS confirmationMailContent_48, t0.adminNotificationMailSubject AS adminNotificationMailSubject_49, t0.adminNotificationMailContent AS adminNotificationMailContent_50, t0.reminderMailTemplateId AS reminderMailTemplateId_51, t0.reminderSenderEmail AS reminderSenderEmail_52, t0.reminderBulkMailId AS reminderBulkMailId_53, t0.reminderMailSendDate AS reminderMailSendDate_54, t0.reminderMailSubject AS reminderMailSubject_55, t0.reminderMailContent AS reminderMailContent_56, t0.$reminderMailStatus AS reminderMailStatus_57, t0.surveyId AS surveyId_58, t0.surveyMailTemplateId AS surveyMailTemplateId_59, t0.surveyBulkMailId AS surveyBulkMailId_60, t0.template AS template_61, t0.pageTemplate AS pageTemplate_62, t0.footerTemplate AS footerTemplate_63, t0.email AS email_64, t0.emailSubject AS emailSubject_65, t0.emailContent AS emailContent_66, t0.landingPageContent AS landingPageContent_67, t0.landingPageDescription AS landingPageDescription_68, t0.landingPageCss AS landingPageCss_69, t0.landingPageJs AS landingPageJs_70, t0.landingPageFooterTemplate AS landingPageFooterTemplate_71, t0.landingPageSocialImage AS landingPageSocialImage_72, t0.landingPageTitle AS landingPageTitle_73, t0.landingPageTwig AS landingPageTwig_74, t0.goToPage AS goToPage_75, t0.phrasesDe AS phrasesDe_76, t0.phrasesEn AS phrasesEn_77, t0.settings AS settings_78, t0.asssesmentDimensions AS asssesmentDimensions_79, t0.start AS start_80, t0.end AS end_81, t0.pitchTopic AS pitchTopic_82, t0.pitchImageLink AS pitchImageLink_83, t0.pitchVideoLink AS pitchVideoLink_84, t0.pitchPartner AS pitchPartner_85, t0.pitchPartnerId AS pitchPartnerId_86, t0.pitchDescription AS pitchDescription_87, t0.followUpPageContent AS followUpPageContent_88, t0.followUpPageDescription AS followUpPageDescription_89, t0.followUpPageCss AS followUpPageCss_90, t0.followUpPageJs AS followUpPageJs_91, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_92, t0.followUpPageTitle AS followUpPageTitle_93, t0.followUpPageSocialImage AS followUpPageSocialImage_94, t0.followUpDescription AS followUpDescription_95, t0.followUpVideoLink AS followUpVideoLink_96, t0.followUpPresentation AS followUpPresentation_97, t0.pitchDate AS pitchDate_98, t0.pitchTime AS pitchTime_99, t0.city AS city_100, t0.applicationsCount AS applicationsCount_101, t0.startedCount AS startedCount_102, t0.appliedCount AS appliedCount_103, t0.approvedCount AS approvedCount_104, t0.rejectedCount AS rejectedCount_105, t0.$skoolWebhook AS skoolWebhook_106, t0.zapierWebhook AS zapierWebhook_107, t0.history AS history_108, t0.createdAt AS createdAt_109, t0.lastModified AS lastModified_110, t0.lastChangeUser AS lastChangeUser_111, t0.program_id AS program_id_112, t0.assessmentTeamId AS assessmentTeamId_113 FROM aab_batches t0 WHERE t0.programId = ? AND t0.focusStatus = ? LIMIT 1 SELECT t0.id AS id_1, t0.programId AS programId_2, t0.eventId AS eventId_3, t0.productId AS productId_4, t0.batchNumber AS batchNumber_5, t0.url AS url_6, t0.name AS name_7, t0.slug AS slug_8, t0.alias AS alias_9, t0.status AS status_10, t0.focusStatus AS focusStatus_11, t0.lang AS lang_12, t0.priceInEuroCent AS priceInEuroCent_13, t0.isTaxIncluded AS isTaxIncluded_14, t0.discount100MemberTags AS discount100MemberTags_15, t0.discount50MemberTags AS discount50MemberTags_16, t0.discount20MemberTags AS discount20MemberTags_17, t0.askForTeam AS askForTeam_18, t0.hasEvent AS hasEvent_19, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_21, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_22, t0.hasIncludePhone AS hasIncludePhone_23, t0.hasFollowUp AS hasFollowUp_24, t0.isNetworking AS isNetworking_25, t0.networkingRounds AS networkingRounds_26, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28, t0.isFutureEvent AS isFutureEvent_29, t0.visibility AS visibility_30, t0.access AS access_31, t0.tags AS tags_32, t0.typeformLink AS typeformLink_33, t0.zoomLink AS zoomLink_34, t0.bgImageUrl AS bgImageUrl_35, t0.startDate AS startDate_36, t0.endDate AS endDate_37, t0.stripePriceId AS stripePriceId_38, t0.stripeProductId AS stripeProductId_39, t0.stripeAccount AS stripeAccount_40, t0.isFreeForKiCampus AS isFreeForKiCampus_41, t0.isFreeForCommunity AS isFreeForCommunity_42, t0.mailDesignTemplate AS mailDesignTemplate_43, t0.senderMail AS senderMail_44, t0.fromName AS fromName_45, t0.recipientMonitoringMail AS recipientMonitoringMail_46, t0.confirmationMailSubject AS confirmationMailSubject_47, t0.confirmationMailContent AS confirmationMailContent_48, t0.adminNotificationMailSubject AS adminNotificationMailSubject_49, t0.adminNotificationMailContent AS adminNotificationMailContent_50, t0.reminderMailTemplateId AS reminderMailTemplateId_51, t0.reminderSenderEmail AS reminderSenderEmail_52, t0.reminderBulkMailId AS reminderBulkMailId_53, t0.reminderMailSendDate AS reminderMailSendDate_54, t0.reminderMailSubject AS reminderMailSubject_55, t0.reminderMailContent AS reminderMailContent_56, t0.$reminderMailStatus AS reminderMailStatus_57, t0.surveyId AS surveyId_58, t0.surveyMailTemplateId AS surveyMailTemplateId_59, t0.surveyBulkMailId AS surveyBulkMailId_60, t0.template AS template_61, t0.pageTemplate AS pageTemplate_62, t0.footerTemplate AS footerTemplate_63, t0.email AS email_64, t0.emailSubject AS emailSubject_65, t0.emailContent AS emailContent_66, t0.landingPageContent AS landingPageContent_67, t0.landingPageDescription AS landingPageDescription_68, t0.landingPageCss AS landingPageCss_69, t0.landingPageJs AS landingPageJs_70, t0.landingPageFooterTemplate AS landingPageFooterTemplate_71, t0.landingPageSocialImage AS landingPageSocialImage_72, t0.landingPageTitle AS landingPageTitle_73, t0.landingPageTwig AS landingPageTwig_74, t0.goToPage AS goToPage_75, t0.phrasesDe AS phrasesDe_76, t0.phrasesEn AS phrasesEn_77, t0.settings AS settings_78, t0.asssesmentDimensions AS asssesmentDimensions_79, t0.start AS start_80, t0.end AS end_81, t0.pitchTopic AS pitchTopic_82, t0.pitchImageLink AS pitchImageLink_83, t0.pitchVideoLink AS pitchVideoLink_84, t0.pitchPartner AS pitchPartner_85, t0.pitchPartnerId AS pitchPartnerId_86, t0.pitchDescription AS pitchDescription_87, t0.followUpPageContent AS followUpPageContent_88, t0.followUpPageDescription AS followUpPageDescription_89, t0.followUpPageCss AS followUpPageCss_90, t0.followUpPageJs AS followUpPageJs_91, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_92, t0.followUpPageTitle AS followUpPageTitle_93, t0.followUpPageSocialImage AS followUpPageSocialImage_94, t0.followUpDescription AS followUpDescription_95, t0.followUpVideoLink AS followUpVideoLink_96, t0.followUpPresentation AS followUpPresentation_97, t0.pitchDate AS pitchDate_98, t0.pitchTime AS pitchTime_99, t0.city AS city_100, t0.applicationsCount AS applicationsCount_101, t0.startedCount AS startedCount_102, t0.appliedCount AS appliedCount_103, t0.approvedCount AS approvedCount_104, t0.rejectedCount AS rejectedCount_105, t0.$skoolWebhook AS skoolWebhook_106, t0.zapierWebhook AS zapierWebhook_107, t0.history AS history_108, t0.createdAt AS createdAt_109, t0.lastModified AS lastModified_110, t0.lastChangeUser AS lastChangeUser_111, t0.program_id AS program_id_112, t0.assessmentTeamId AS assessmentTeamId_113 FROM aab_batches t0 WHERE t0.programId = 3 AND t0.focusStatus = '2_current' LIMIT 1;
1.12 ms (2.15%)	1	SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.pitchNumber LIKE ? ORDER BY a0_.rheinlandPitch ASC, a0_.rheinlandPitchBestResult DESC LIMIT 1280 Parameters: [`"public" "%winterfinale-2023%"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = ? AND a0_.pitchNumber LIKE ? ORDER BY a0_.rheinlandPitch ASC, a0_.rheinlandPitchBestResult DESC LIMIT 1280 SELECT a0_.id AS id_0, a0_.extId AS extId_1, a0_.visibility AS visibility_2, a0_.teamId AS teamId_3, a0_.name AS name_4, a0_.status AS status_5, a0_.location AS location_6, a0_.city AS city_7, a0_.website AS website_8, a0_.domain AS domain_9, a0_.slug AS slug_10, a0_.linkedin AS linkedin_11, a0_.twitter AS twitter_12, a0_.logoUrl AS logoUrl_13, a0_.stage AS stage_14, a0_.hasBadgeStartplatz AS hasBadgeStartplatz_15, a0_.startplatz AS startplatz_16, a0_.accelerator AS accelerator_17, a0_.batch AS batch_18, a0_.batchLast AS batchLast_19, a0_.batchFirst AS batchFirst_20, a0_.batchYear AS batchYear_21, a0_.rheinlandPitch AS rheinlandPitch_22, a0_.pitchNumber AS pitchNumber_23, a0_.pitchDate AS pitchDate_24, a0_.pitchTopic AS pitchTopic_25, a0_.gruenderstipendium AS gruenderstipendium_26, a0_.gsJury AS gsJury_27, a0_.gsStatus AS gsStatus_28, a0_.industry AS industry_29, a0_.industryCondensed AS industryCondensed_30, a0_.customerFocus AS customerFocus_31, a0_.BusinessModel AS BusinessModel_32, a0_.tags AS tags_33, a0_.todos AS todos_34, a0_.foundationYear AS foundationYear_35, a0_.funding AS funding_36, a0_.oneSentencePitch AS oneSentencePitch_37, a0_.employeesCount AS employeesCount_38, a0_.revenue AS revenue_39, a0_.investors AS investors_40, a0_.contactPerson AS contactPerson_41, a0_.contactEmail AS contactEmail_42, a0_.contactTelefon AS contactTelefon_43, a0_.lastModified AS lastModified_44, a0_.history AS history_45, a0_.lastChangeUser AS lastChangeUser_46, a0_.createdAt AS createdAt_47, a1_.score AS score_48 FROM aaa_startups a0_ INNER JOIN aaa_startups_relevance a1_ ON (a0_.id = a1_.startupId) WHERE a0_.visibility = 'public' AND a0_.pitchNumber LIKE '%winterfinale-2023%' ORDER BY a0_.rheinlandPitch ASC, a0_.rheinlandPitchBestResult DESC LIMIT 1280;
0.69 ms (1.32%)	1	SELECT COUNT(a0_.id) AS sclr_0 FROM aaa_startups a0_ WHERE a0_.visibility = ? Parameters: [`"public"`] View formatted query View runnable query Explain query SELECT COUNT(a0_.id) AS sclr_0 FROM aaa_startups a0_ WHERE a0_.visibility = ? SELECT COUNT(a0_.id) AS sclr_0 FROM aaa_startups a0_ WHERE a0_.visibility = 'public';
0.42 ms (0.80%)	1	SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37 FROM aaa_sp_pages t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"startups"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37 FROM aaa_sp_pages t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.slug AS slug_4, t0.title AS title_5, t0.teaser AS teaser_6, t0.partnerAdminRating AS partnerAdminRating_7, t0.imagelink AS imagelink_8, t0.website AS website_9, t0.tags AS tags_10, t0.feedTags AS feedTags_11, t0.logoUrl AS logoUrl_12, t0.publicId AS publicId_13, t0.description AS description_14, t0.relatedInformation AS relatedInformation_15, t0.redeemPerk AS redeemPerk_16, t0.targetGroup AS targetGroup_17, t0.contactPartner AS contactPartner_18, t0.contactPartnerMemberId AS contactPartnerMemberId_19, t0.isActive AS isActive_20, t0.status AS status_21, t0.visibility AS visibility_22, t0.teamId AS teamId_23, t0.teamName AS teamName_24, t0.titleEN AS titleEN_25, t0.teaserEN AS teaserEN_26, t0.descriptionEN AS descriptionEN_27, t0.relatedInformationEN AS relatedInformationEN_28, t0.redeemPerkEN AS redeemPerkEN_29, t0.seoTitle AS seoTitle_30, t0.seoKeyword AS seoKeyword_31, t0.seoDescription AS seoDescription_32, t0.history AS history_33, t0.lastModified AS lastModified_34, t0.lastChangeUser AS lastChangeUser_35, t0.createdAt AS createdAt_36, t0.additionalHead AS additionalHead_37 FROM aaa_sp_pages t0 WHERE t0.slug = 'startups' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\StartPlatz\Bundle\UserBundle\Entity\User	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Startup	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\StartupRelevance	No errors.
App\StartPlatz\Bundle\AlphaBundle\Entity\Page	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Option	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Program	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam	No errors.