0.47 ms
(52.26%)
|
1 |
SELECT t0.id AS id_1, t0.displayName AS displayName_2, t0.displayNameEn AS displayNameEn_3, t0.slug AS slug_4, t0.descriptionShort AS descriptionShort_5, t0.descriptionShortEn AS descriptionShortEn_6, t0.descriptionLong AS descriptionLong_7, t0.descriptionLongEn AS descriptionLongEn_8, t0.descriptionLongHtml AS descriptionLongHtml_9, t0.descriptionLongHtmlEn AS descriptionLongHtmlEn_10, t0.internalContentHtml AS internalContentHtml_11, t0.internalContentHtmlEn AS internalContentHtmlEn_12, t0.offeringsLong AS offeringsLong_13, t0.resources AS resources_14, t0.logoOverride AS logoOverride_15, t0.tags AS tags_16, t0.categoryTags AS categoryTags_17, t0.contentTags AS contentTags_18, t0.publicCategory AS publicCategory_19, t0.adminRating AS adminRating_20, t0.status AS status_21, t0.isActive AS isActive_22, t0.metadata AS metadata_23, t0.legacyPageId AS legacyPageId_24, t0.practiceDescription AS practiceDescription_25, t0.practiceDescriptionEn AS practiceDescriptionEn_26, t0.signals_de AS signals_de_27, t0.signals_en AS signals_en_28, t0.availabilityStatus AS availabilityStatus_29, t0.availabilityNote AS availabilityNote_30, t0.internalNotes AS internalNotes_31, t0.website AS website_32, t0.imageUrl AS imageUrl_33, t0.redeemPerk AS redeemPerk_34, t0.redeemPerkEn AS redeemPerkEn_35, t0.contactMemberId AS contactMemberId_36, t0.targetGroup AS targetGroup_37, t0.partnerType AS partnerType_38, t0.isPaying AS isPaying_39, t0.createdAt AS createdAt_40, t0.updatedAt AS updatedAt_41, t0.teamId AS teamId_42 FROM sp_team_partners t0 WHERE t0.slug = ? LIMIT 1
SELECT
t0.id AS id_1,
t0.displayName AS displayName_2,
t0.displayNameEn AS displayNameEn_3,
t0.slug AS slug_4,
t0.descriptionShort AS descriptionShort_5,
t0.descriptionShortEn AS descriptionShortEn_6,
t0.descriptionLong AS descriptionLong_7,
t0.descriptionLongEn AS descriptionLongEn_8,
t0.descriptionLongHtml AS descriptionLongHtml_9,
t0.descriptionLongHtmlEn AS descriptionLongHtmlEn_10,
t0.internalContentHtml AS internalContentHtml_11,
t0.internalContentHtmlEn AS internalContentHtmlEn_12,
t0.offeringsLong AS offeringsLong_13,
t0.resources AS resources_14,
t0.logoOverride AS logoOverride_15,
t0.tags AS tags_16,
t0.categoryTags AS categoryTags_17,
t0.contentTags AS contentTags_18,
t0.publicCategory AS publicCategory_19,
t0.adminRating AS adminRating_20,
t0.status AS status_21,
t0.isActive AS isActive_22,
t0.metadata AS metadata_23,
t0.legacyPageId AS legacyPageId_24,
t0.practiceDescription AS practiceDescription_25,
t0.practiceDescriptionEn AS practiceDescriptionEn_26,
t0.signals_de AS signals_de_27,
t0.signals_en AS signals_en_28,
t0.availabilityStatus AS availabilityStatus_29,
t0.availabilityNote AS availabilityNote_30,
t0.internalNotes AS internalNotes_31,
t0.website AS website_32,
t0.imageUrl AS imageUrl_33,
t0.redeemPerk AS redeemPerk_34,
t0.redeemPerkEn AS redeemPerkEn_35,
t0.contactMemberId AS contactMemberId_36,
t0.targetGroup AS targetGroup_37,
t0.partnerType AS partnerType_38,
t0.isPaying AS isPaying_39,
t0.createdAt AS createdAt_40,
t0.updatedAt AS updatedAt_41,
t0.teamId AS teamId_42
FROM
sp_team_partners t0
WHERE
t0.slug = ?
LIMIT
1
SELECT t0.id AS id_1, t0.displayName AS displayName_2, t0.displayNameEn AS displayNameEn_3, t0.slug AS slug_4, t0.descriptionShort AS descriptionShort_5, t0.descriptionShortEn AS descriptionShortEn_6, t0.descriptionLong AS descriptionLong_7, t0.descriptionLongEn AS descriptionLongEn_8, t0.descriptionLongHtml AS descriptionLongHtml_9, t0.descriptionLongHtmlEn AS descriptionLongHtmlEn_10, t0.internalContentHtml AS internalContentHtml_11, t0.internalContentHtmlEn AS internalContentHtmlEn_12, t0.offeringsLong AS offeringsLong_13, t0.resources AS resources_14, t0.logoOverride AS logoOverride_15, t0.tags AS tags_16, t0.categoryTags AS categoryTags_17, t0.contentTags AS contentTags_18, t0.publicCategory AS publicCategory_19, t0.adminRating AS adminRating_20, t0.status AS status_21, t0.isActive AS isActive_22, t0.metadata AS metadata_23, t0.legacyPageId AS legacyPageId_24, t0.practiceDescription AS practiceDescription_25, t0.practiceDescriptionEn AS practiceDescriptionEn_26, t0.signals_de AS signals_de_27, t0.signals_en AS signals_en_28, t0.availabilityStatus AS availabilityStatus_29, t0.availabilityNote AS availabilityNote_30, t0.internalNotes AS internalNotes_31, t0.website AS website_32, t0.imageUrl AS imageUrl_33, t0.redeemPerk AS redeemPerk_34, t0.redeemPerkEn AS redeemPerkEn_35, t0.contactMemberId AS contactMemberId_36, t0.targetGroup AS targetGroup_37, t0.partnerType AS partnerType_38, t0.isPaying AS isPaying_39, t0.createdAt AS createdAt_40, t0.updatedAt AS updatedAt_41, t0.teamId AS teamId_42 FROM sp_team_partners t0 WHERE t0.slug = 'miele' LIMIT 1;
|
0.43 ms
(47.74%)
|
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.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.hasStartupMembership AS hasStartupMembership_21, t0.isIncludeInUpdateType AS isIncludeInUpdateType_22, t0.isCompany AS isCompany_23, t0.isAddressComplete AS isAddressComplete_24, t0.isDebitor AS isDebitor_25, t0.type AS type_26, t0.internalDescription AS internalDescription_27, t0.monsumCustomerType AS monsumCustomerType_28, t0.homepage AS homepage_29, t0.logoURL AS logoURL_30, t0.industries AS industries_31, t0.description AS description_32, t0.note AS note_33, t0.tags AS tags_34, t0.categories AS categories_35, t0.alertNote AS alertNote_36, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37, t0.monthlyExtraBudget AS monthlyExtraBudget_38, t0.sameDayBudget AS sameDayBudget_39, t0.sameDayBudgetUsed AS sameDayBudgetUsed_40, t0.sameDayExtraBudget AS sameDayExtraBudget_41, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42, t0.communityBudget AS communityBudget_43, t0.communityBudgetUsed AS communityBudgetUsed_44, t0.meetingRoomsBudget AS meetingRoomsBudget_45, t0.conferenceRoomsBudget AS conferenceRoomsBudget_46, t0.coffeeCoinsBudget AS coffeeCoinsBudget_47, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48, t0.meetingRoomsBooked AS meetingRoomsBooked_49, t0.conferenceRoomsBooked AS conferenceRoomsBooked_50, t0.todayRoomsBooked AS todayRoomsBooked_51, t0.nDedicatedDesks AS nDedicatedDesks_52, t0.nFlexibleDesks AS nFlexibleDesks_53, t0.nBasicMemberships AS nBasicMemberships_54, t0.nEmployees AS nEmployees_55, t0.nTransponders AS nTransponders_56, t0.nTiefgarage AS nTiefgarage_57, t0.editStatus AS editStatus_58, t0.xing AS xing_59, t0.linkedin AS linkedin_60, t0.facebook AS facebook_61, t0.twitter AS twitter_62, t0.instagram AS instagram_63, t0.enterDate AS enterDate_64, t0.lastChangeDate AS lastChangeDate_65, t0.lastModified AS lastModified_66, t0.lastInvoiceDate AS lastInvoiceDate_67, t0.exitDate AS exitDate_68, t0.isRedundant AS isRedundant_69, t0.gsStatus AS gsStatus_70, t0.gsBatchNo AS gsBatchNo_71, t0.gsNote AS gsNote_72, t0.gsIdeenblattDate AS gsIdeenblattDate_73, t0.gsJuryDate AS gsJuryDate_74, t0.gsCoachMemberId AS gsCoachMemberId_75, t0.gsCoachMemberName AS gsCoachMemberName_76, t0.spContactPerson AS spContactPerson_77, t0.memberTag AS memberTag_78, t0.actionTag AS actionTag_79, t0.createdAt AS createdAt_80, t0.lastChangeUser AS lastChangeUser_81, t0.history AS history_82, t0.treatAsSubscribed AS treatAsSubscribed_83, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85, t0.treatAsSubscribedReason AS treatAsSubscribedReason_86, t0.searchAliases AS searchAliases_87 FROM sp_teams t0 WHERE t0.id = ?
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.hasCommunityMembership AS hasCommunityMembership_19,
t0.isTransponderAllowed AS isTransponderAllowed_20,
t0.hasStartupMembership AS hasStartupMembership_21,
t0.isIncludeInUpdateType AS isIncludeInUpdateType_22,
t0.isCompany AS isCompany_23,
t0.isAddressComplete AS isAddressComplete_24,
t0.isDebitor AS isDebitor_25,
t0.type AS type_26,
t0.internalDescription AS internalDescription_27,
t0.monsumCustomerType AS monsumCustomerType_28,
t0.homepage AS homepage_29,
t0.logoURL AS logoURL_30,
t0.industries AS industries_31,
t0.description AS description_32,
t0.note AS note_33,
t0.tags AS tags_34,
t0.categories AS categories_35,
t0.alertNote AS alertNote_36,
t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37,
t0.monthlyExtraBudget AS monthlyExtraBudget_38,
t0.sameDayBudget AS sameDayBudget_39,
t0.sameDayBudgetUsed AS sameDayBudgetUsed_40,
t0.sameDayExtraBudget AS sameDayExtraBudget_41,
t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42,
t0.communityBudget AS communityBudget_43,
t0.communityBudgetUsed AS communityBudgetUsed_44,
t0.meetingRoomsBudget AS meetingRoomsBudget_45,
t0.conferenceRoomsBudget AS conferenceRoomsBudget_46,
t0.coffeeCoinsBudget AS coffeeCoinsBudget_47,
t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48,
t0.meetingRoomsBooked AS meetingRoomsBooked_49,
t0.conferenceRoomsBooked AS conferenceRoomsBooked_50,
t0.todayRoomsBooked AS todayRoomsBooked_51,
t0.nDedicatedDesks AS nDedicatedDesks_52,
t0.nFlexibleDesks AS nFlexibleDesks_53,
t0.nBasicMemberships AS nBasicMemberships_54,
t0.nEmployees AS nEmployees_55,
t0.nTransponders AS nTransponders_56,
t0.nTiefgarage AS nTiefgarage_57,
t0.editStatus AS editStatus_58,
t0.xing AS xing_59,
t0.linkedin AS linkedin_60,
t0.facebook AS facebook_61,
t0.twitter AS twitter_62,
t0.instagram AS instagram_63,
t0.enterDate AS enterDate_64,
t0.lastChangeDate AS lastChangeDate_65,
t0.lastModified AS lastModified_66,
t0.lastInvoiceDate AS lastInvoiceDate_67,
t0.exitDate AS exitDate_68,
t0.isRedundant AS isRedundant_69,
t0.gsStatus AS gsStatus_70,
t0.gsBatchNo AS gsBatchNo_71,
t0.gsNote AS gsNote_72,
t0.gsIdeenblattDate AS gsIdeenblattDate_73,
t0.gsJuryDate AS gsJuryDate_74,
t0.gsCoachMemberId AS gsCoachMemberId_75,
t0.gsCoachMemberName AS gsCoachMemberName_76,
t0.spContactPerson AS spContactPerson_77,
t0.memberTag AS memberTag_78,
t0.actionTag AS actionTag_79,
t0.createdAt AS createdAt_80,
t0.lastChangeUser AS lastChangeUser_81,
t0.history AS history_82,
t0.treatAsSubscribed AS treatAsSubscribed_83,
t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84,
t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85,
t0.treatAsSubscribedReason AS treatAsSubscribedReason_86,
t0.searchAliases AS searchAliases_87
FROM
sp_teams t0
WHERE
t0.id = ?
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.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.hasStartupMembership AS hasStartupMembership_21, t0.isIncludeInUpdateType AS isIncludeInUpdateType_22, t0.isCompany AS isCompany_23, t0.isAddressComplete AS isAddressComplete_24, t0.isDebitor AS isDebitor_25, t0.type AS type_26, t0.internalDescription AS internalDescription_27, t0.monsumCustomerType AS monsumCustomerType_28, t0.homepage AS homepage_29, t0.logoURL AS logoURL_30, t0.industries AS industries_31, t0.description AS description_32, t0.note AS note_33, t0.tags AS tags_34, t0.categories AS categories_35, t0.alertNote AS alertNote_36, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37, t0.monthlyExtraBudget AS monthlyExtraBudget_38, t0.sameDayBudget AS sameDayBudget_39, t0.sameDayBudgetUsed AS sameDayBudgetUsed_40, t0.sameDayExtraBudget AS sameDayExtraBudget_41, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42, t0.communityBudget AS communityBudget_43, t0.communityBudgetUsed AS communityBudgetUsed_44, t0.meetingRoomsBudget AS meetingRoomsBudget_45, t0.conferenceRoomsBudget AS conferenceRoomsBudget_46, t0.coffeeCoinsBudget AS coffeeCoinsBudget_47, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48, t0.meetingRoomsBooked AS meetingRoomsBooked_49, t0.conferenceRoomsBooked AS conferenceRoomsBooked_50, t0.todayRoomsBooked AS todayRoomsBooked_51, t0.nDedicatedDesks AS nDedicatedDesks_52, t0.nFlexibleDesks AS nFlexibleDesks_53, t0.nBasicMemberships AS nBasicMemberships_54, t0.nEmployees AS nEmployees_55, t0.nTransponders AS nTransponders_56, t0.nTiefgarage AS nTiefgarage_57, t0.editStatus AS editStatus_58, t0.xing AS xing_59, t0.linkedin AS linkedin_60, t0.facebook AS facebook_61, t0.twitter AS twitter_62, t0.instagram AS instagram_63, t0.enterDate AS enterDate_64, t0.lastChangeDate AS lastChangeDate_65, t0.lastModified AS lastModified_66, t0.lastInvoiceDate AS lastInvoiceDate_67, t0.exitDate AS exitDate_68, t0.isRedundant AS isRedundant_69, t0.gsStatus AS gsStatus_70, t0.gsBatchNo AS gsBatchNo_71, t0.gsNote AS gsNote_72, t0.gsIdeenblattDate AS gsIdeenblattDate_73, t0.gsJuryDate AS gsJuryDate_74, t0.gsCoachMemberId AS gsCoachMemberId_75, t0.gsCoachMemberName AS gsCoachMemberName_76, t0.spContactPerson AS spContactPerson_77, t0.memberTag AS memberTag_78, t0.actionTag AS actionTag_79, t0.createdAt AS createdAt_80, t0.lastChangeUser AS lastChangeUser_81, t0.history AS history_82, t0.treatAsSubscribed AS treatAsSubscribed_83, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85, t0.treatAsSubscribedReason AS treatAsSubscribedReason_86, t0.searchAliases AS searchAliases_87 FROM sp_teams t0 WHERE t0.id = 18751;
|