9223372036854775807, 1 => 'O:31:"Doctrine\\ORM\\Query\\ParserResult":3:{s:45:"' . "\0" . 'Doctrine\\ORM\\Query\\ParserResult' . "\0" . '_sqlExecutor";O:44:"Doctrine\\ORM\\Query\\Exec\\SingleSelectExecutor":2:{s:17:"' . "\0" . '*' . "\0" . '_sqlStatements";s:3349:"SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.name AS name_2, d0_.seoTitle AS seoTitle_3, d0_.seoDescription AS seoDescription_4, d0_.seoKeywords AS seoKeywords_5, d0_.internalID AS internalID_6, d0_.logo AS logo_7, d0_.favicon AS favicon_8, d0_.banner AS banner_9, d0_.bannerLink AS bannerLink_10, d0_.createdAt AS createdAt_11, d0_.updatedAt AS updatedAt_12, d0_.status AS status_13, d0_.facebookPixel AS facebookPixel_14, d0_.googleSiteVerifMeta AS googleSiteVerifMeta_15, d0_.googleAnalytics AS googleAnalytics_16, d0_.googleAds AS googleAds_17, d0_.conversionLabel AS conversionLabel_18, d0_.messengerFacebookPageId AS messengerFacebookPageId_19, d0_.messengerLoggedInText AS messengerLoggedInText_20, d0_.messengerLoggedOutText AS messengerLoggedOutText_21, d0_.email AS email_22, d0_.useEmail AS useEmail_23, d0_.phone AS phone_24, d0_.legalNotices AS legalNotices_25, d0_.generalTermsAndConditions AS generalTermsAndConditions_26, d0_.delivery AS delivery_27, d0_.isDeliveryFree AS isDeliveryFree_28, d0_.deliveryFreeAmount AS deliveryFreeAmount_29, d0_.invoicePrefix AS invoicePrefix_30, d0_.invoiceStartNumber AS invoiceStartNumber_31, d0_.afterSalesService AS afterSalesService_32, d0_.about AS about_33, d0_.isDomainCustom AS isDomainCustom_34, d0_.dnsEntryChecked AS dnsEntryChecked_35, d0_.masterStatus AS masterStatus_36, d0_.randomSort AS randomSort_37, d0_.type AS type_38, d0_.authAccess AS authAccess_39, d0_.password AS password_40, d0_.customizationAvailable AS customizationAvailable_41, d0_.margin AS margin_42, d0_.homeDesc AS homeDesc_43, d0_.fullCatalog AS fullCatalog_44, d0_.openDesignsLibrary AS openDesignsLibrary_45, d0_.customImagesOnly AS customImagesOnly_46, d0_.dspFees AS dspFees_47, d0_.master AS master_48, d0_.headerTopMsg AS headerTopMsg_49, d0_.reviewNote AS reviewNote_50, d0_.actionBtnText AS actionBtnText_51, d0_.actionBtnUrl AS actionBtnUrl_52, d0_.leftAdBlockTitle AS leftAdBlockTitle_53, d0_.leftAdBlockText AS leftAdBlockText_54, d0_.leftAdBlockButtonText AS leftAdBlockButtonText_55, d0_.leftAdBlockButtonUrl AS leftAdBlockButtonUrl_56, d0_.leftAdBlockButtonTitle AS leftAdBlockButtonTitle_57, d0_.rightAdBlockTitle AS rightAdBlockTitle_58, d0_.rightAdBlockText AS rightAdBlockText_59, d0_.rightAdBlockButtonText AS rightAdBlockButtonText_60, d0_.rightAdBlockButtonUrl AS rightAdBlockButtonUrl_61, d0_.rightAdBlockButtonTitle AS rightAdBlockButtonTitle_62, d0_.h1Title AS h1Title_63, d0_.subCategoriesDisplayMode AS subCategoriesDisplayMode_64, d0_.obfuscateLinks AS obfuscateLinks_65, d0_.ytgGroup AS ytgGroup_66, d0_.shopifyApiKey AS shopifyApiKey_67, d0_.shopifyApiPassword AS shopifyApiPassword_68, d0_.shopifySharedCode AS shopifySharedCode_69, d0_.shopifyFulfillmentServiceId AS shopifyFulfillmentServiceId_70, d0_.shopifyFulfillmentServiceHandle AS shopifyFulfillmentServiceHandle_71, d0_.shopifyLocationId AS shopifyLocationId_72, d0_.shopifyFulfillmentErrors AS shopifyFulfillmentErrors_73, d0_.shopifyWebhookErrors AS shopifyWebhookErrors_74, d0_.optionsAvailable AS optionsAvailable_75, d0_.showcase AS showcase_76, d0_.user_id AS user_id_77, d0_.partnerProgram_id AS partnerProgram_id_78, d0_.leftAdBlockImage_id AS leftAdBlockImage_id_79, d0_.rightAdBlockImage_id AS rightAdBlockImage_id_80 FROM dsp_shop d0_ WHERE d0_.status = 1 AND d0_.domain IS NOT NULL AND d0_.name IS NOT NULL";s:20:"' . "\0" . '*' . "\0" . 'queryCacheProfile";N;}s:50:"' . "\0" . 'Doctrine\\ORM\\Query\\ParserResult' . "\0" . '_resultSetMapping";O:35:"Doctrine\\ORM\\Query\\ResultSetMapping":18:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:3:"_s1";s:22:"ShopBundle\\Entity\\Shop";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:77:{s:4:"id_0";s:2:"id";s:8:"domain_1";s:6:"domain";s:6:"name_2";s:4:"name";s:10:"seoTitle_3";s:8:"seoTitle";s:16:"seoDescription_4";s:14:"seoDescription";s:13:"seoKeywords_5";s:11:"seoKeywords";s:12:"internalID_6";s:10:"internalID";s:6:"logo_7";s:4:"logo";s:9:"favicon_8";s:7:"favicon";s:8:"banner_9";s:6:"banner";s:13:"bannerLink_10";s:10:"bannerLink";s:12:"createdAt_11";s:9:"createdAt";s:12:"updatedAt_12";s:9:"updatedAt";s:9:"status_13";s:6:"status";s:16:"facebookPixel_14";s:13:"facebookPixel";s:22:"googleSiteVerifMeta_15";s:19:"googleSiteVerifMeta";s:18:"googleAnalytics_16";s:15:"googleAnalytics";s:12:"googleAds_17";s:9:"googleAds";s:18:"conversionLabel_18";s:15:"conversionLabel";s:26:"messengerFacebookPageId_19";s:23:"messengerFacebookPageId";s:24:"messengerLoggedInText_20";s:21:"messengerLoggedInText";s:25:"messengerLoggedOutText_21";s:22:"messengerLoggedOutText";s:8:"email_22";s:5:"email";s:11:"useEmail_23";s:8:"useEmail";s:8:"phone_24";s:5:"phone";s:15:"legalNotices_25";s:12:"legalNotices";s:28:"generalTermsAndConditions_26";s:25:"generalTermsAndConditions";s:11:"delivery_27";s:8:"delivery";s:17:"isDeliveryFree_28";s:14:"isDeliveryFree";s:21:"deliveryFreeAmount_29";s:18:"deliveryFreeAmount";s:16:"invoicePrefix_30";s:13:"invoicePrefix";s:21:"invoiceStartNumber_31";s:18:"invoiceStartNumber";s:20:"afterSalesService_32";s:17:"afterSalesService";s:8:"about_33";s:5:"about";s:17:"isDomainCustom_34";s:14:"isDomainCustom";s:18:"dnsEntryChecked_35";s:15:"dnsEntryChecked";s:15:"masterStatus_36";s:12:"masterStatus";s:13:"randomSort_37";s:10:"randomSort";s:7:"type_38";s:4:"type";s:13:"authAccess_39";s:10:"authAccess";s:11:"password_40";s:8:"password";s:25:"customizationAvailable_41";s:22:"customizationAvailable";s:9:"margin_42";s:6:"margin";s:11:"homeDesc_43";s:8:"homeDesc";s:14:"fullCatalog_44";s:11:"fullCatalog";s:21:"openDesignsLibrary_45";s:18:"openDesignsLibrary";s:19:"customImagesOnly_46";s:16:"customImagesOnly";s:10:"dspFees_47";s:7:"dspFees";s:9:"master_48";s:6:"master";s:15:"headerTopMsg_49";s:12:"headerTopMsg";s:13:"reviewNote_50";s:10:"reviewNote";s:16:"actionBtnText_51";s:13:"actionBtnText";s:15:"actionBtnUrl_52";s:12:"actionBtnUrl";s:19:"leftAdBlockTitle_53";s:16:"leftAdBlockTitle";s:18:"leftAdBlockText_54";s:15:"leftAdBlockText";s:24:"leftAdBlockButtonText_55";s:21:"leftAdBlockButtonText";s:23:"leftAdBlockButtonUrl_56";s:20:"leftAdBlockButtonUrl";s:25:"leftAdBlockButtonTitle_57";s:22:"leftAdBlockButtonTitle";s:20:"rightAdBlockTitle_58";s:17:"rightAdBlockTitle";s:19:"rightAdBlockText_59";s:16:"rightAdBlockText";s:25:"rightAdBlockButtonText_60";s:22:"rightAdBlockButtonText";s:24:"rightAdBlockButtonUrl_61";s:21:"rightAdBlockButtonUrl";s:26:"rightAdBlockButtonTitle_62";s:23:"rightAdBlockButtonTitle";s:10:"h1Title_63";s:7:"h1Title";s:27:"subCategoriesDisplayMode_64";s:24:"subCategoriesDisplayMode";s:17:"obfuscateLinks_65";s:14:"obfuscateLinks";s:11:"ytgGroup_66";s:8:"ytgGroup";s:16:"shopifyApiKey_67";s:13:"shopifyApiKey";s:21:"shopifyApiPassword_68";s:18:"shopifyApiPassword";s:20:"shopifySharedCode_69";s:17:"shopifySharedCode";s:30:"shopifyFulfillmentServiceId_70";s:27:"shopifyFulfillmentServiceId";s:34:"shopifyFulfillmentServiceHandle_71";s:31:"shopifyFulfillmentServiceHandle";s:20:"shopifyLocationId_72";s:17:"shopifyLocationId";s:27:"shopifyFulfillmentErrors_73";s:24:"shopifyFulfillmentErrors";s:23:"shopifyWebhookErrors_74";s:20:"shopifyWebhookErrors";s:19:"optionsAvailable_75";s:16:"optionsAvailable";s:11:"showcase_76";s:8:"showcase";}s:14:"scalarMappings";a:0:{}s:12:"typeMappings";a:4:{s:10:"user_id_77";s:7:"integer";s:20:"partnerProgram_id_78";s:7:"integer";s:22:"leftAdBlockImage_id_79";s:7:"integer";s:23:"rightAdBlockImage_id_80";s:7:"integer";}s:14:"entityMappings";a:1:{s:3:"_s1";N;}s:12:"metaMappings";a:4:{s:10:"user_id_77";s:7:"user_id";s:20:"partnerProgram_id_78";s:17:"partnerProgram_id";s:22:"leftAdBlockImage_id_79";s:19:"leftAdBlockImage_id";s:23:"rightAdBlockImage_id_80";s:20:"rightAdBlockImage_id";}s:14:"columnOwnerMap";a:81:{s:4:"id_0";s:3:"_s1";s:8:"domain_1";s:3:"_s1";s:6:"name_2";s:3:"_s1";s:10:"seoTitle_3";s:3:"_s1";s:16:"seoDescription_4";s:3:"_s1";s:13:"seoKeywords_5";s:3:"_s1";s:12:"internalID_6";s:3:"_s1";s:6:"logo_7";s:3:"_s1";s:9:"favicon_8";s:3:"_s1";s:8:"banner_9";s:3:"_s1";s:13:"bannerLink_10";s:3:"_s1";s:12:"createdAt_11";s:3:"_s1";s:12:"updatedAt_12";s:3:"_s1";s:9:"status_13";s:3:"_s1";s:16:"facebookPixel_14";s:3:"_s1";s:22:"googleSiteVerifMeta_15";s:3:"_s1";s:18:"googleAnalytics_16";s:3:"_s1";s:12:"googleAds_17";s:3:"_s1";s:18:"conversionLabel_18";s:3:"_s1";s:26:"messengerFacebookPageId_19";s:3:"_s1";s:24:"messengerLoggedInText_20";s:3:"_s1";s:25:"messengerLoggedOutText_21";s:3:"_s1";s:8:"email_22";s:3:"_s1";s:11:"useEmail_23";s:3:"_s1";s:8:"phone_24";s:3:"_s1";s:15:"legalNotices_25";s:3:"_s1";s:28:"generalTermsAndConditions_26";s:3:"_s1";s:11:"delivery_27";s:3:"_s1";s:17:"isDeliveryFree_28";s:3:"_s1";s:21:"deliveryFreeAmount_29";s:3:"_s1";s:16:"invoicePrefix_30";s:3:"_s1";s:21:"invoiceStartNumber_31";s:3:"_s1";s:20:"afterSalesService_32";s:3:"_s1";s:8:"about_33";s:3:"_s1";s:17:"isDomainCustom_34";s:3:"_s1";s:18:"dnsEntryChecked_35";s:3:"_s1";s:15:"masterStatus_36";s:3:"_s1";s:13:"randomSort_37";s:3:"_s1";s:7:"type_38";s:3:"_s1";s:13:"authAccess_39";s:3:"_s1";s:11:"password_40";s:3:"_s1";s:25:"customizationAvailable_41";s:3:"_s1";s:9:"margin_42";s:3:"_s1";s:11:"homeDesc_43";s:3:"_s1";s:14:"fullCatalog_44";s:3:"_s1";s:21:"openDesignsLibrary_45";s:3:"_s1";s:19:"customImagesOnly_46";s:3:"_s1";s:10:"dspFees_47";s:3:"_s1";s:9:"master_48";s:3:"_s1";s:15:"headerTopMsg_49";s:3:"_s1";s:13:"reviewNote_50";s:3:"_s1";s:16:"actionBtnText_51";s:3:"_s1";s:15:"actionBtnUrl_52";s:3:"_s1";s:19:"leftAdBlockTitle_53";s:3:"_s1";s:18:"leftAdBlockText_54";s:3:"_s1";s:24:"leftAdBlockButtonText_55";s:3:"_s1";s:23:"leftAdBlockButtonUrl_56";s:3:"_s1";s:25:"leftAdBlockButtonTitle_57";s:3:"_s1";s:20:"rightAdBlockTitle_58";s:3:"_s1";s:19:"rightAdBlockText_59";s:3:"_s1";s:25:"rightAdBlockButtonText_60";s:3:"_s1";s:24:"rightAdBlockButtonUrl_61";s:3:"_s1";s:26:"rightAdBlockButtonTitle_62";s:3:"_s1";s:10:"h1Title_63";s:3:"_s1";s:27:"subCategoriesDisplayMode_64";s:3:"_s1";s:17:"obfuscateLinks_65";s:3:"_s1";s:11:"ytgGroup_66";s:3:"_s1";s:16:"shopifyApiKey_67";s:3:"_s1";s:21:"shopifyApiPassword_68";s:3:"_s1";s:20:"shopifySharedCode_69";s:3:"_s1";s:30:"shopifyFulfillmentServiceId_70";s:3:"_s1";s:34:"shopifyFulfillmentServiceHandle_71";s:3:"_s1";s:20:"shopifyLocationId_72";s:3:"_s1";s:27:"shopifyFulfillmentErrors_73";s:3:"_s1";s:23:"shopifyWebhookErrors_74";s:3:"_s1";s:19:"optionsAvailable_75";s:3:"_s1";s:11:"showcase_76";s:3:"_s1";s:10:"user_id_77";s:3:"_s1";s:20:"partnerProgram_id_78";s:3:"_s1";s:22:"leftAdBlockImage_id_79";s:3:"_s1";s:23:"rightAdBlockImage_id_80";s:3:"_s1";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:77:{s:4:"id_0";s:22:"ShopBundle\\Entity\\Shop";s:8:"domain_1";s:22:"ShopBundle\\Entity\\Shop";s:6:"name_2";s:22:"ShopBundle\\Entity\\Shop";s:10:"seoTitle_3";s:22:"ShopBundle\\Entity\\Shop";s:16:"seoDescription_4";s:22:"ShopBundle\\Entity\\Shop";s:13:"seoKeywords_5";s:22:"ShopBundle\\Entity\\Shop";s:12:"internalID_6";s:22:"ShopBundle\\Entity\\Shop";s:6:"logo_7";s:22:"ShopBundle\\Entity\\Shop";s:9:"favicon_8";s:22:"ShopBundle\\Entity\\Shop";s:8:"banner_9";s:22:"ShopBundle\\Entity\\Shop";s:13:"bannerLink_10";s:22:"ShopBundle\\Entity\\Shop";s:12:"createdAt_11";s:22:"ShopBundle\\Entity\\Shop";s:12:"updatedAt_12";s:22:"ShopBundle\\Entity\\Shop";s:9:"status_13";s:22:"ShopBundle\\Entity\\Shop";s:16:"facebookPixel_14";s:22:"ShopBundle\\Entity\\Shop";s:22:"googleSiteVerifMeta_15";s:22:"ShopBundle\\Entity\\Shop";s:18:"googleAnalytics_16";s:22:"ShopBundle\\Entity\\Shop";s:12:"googleAds_17";s:22:"ShopBundle\\Entity\\Shop";s:18:"conversionLabel_18";s:22:"ShopBundle\\Entity\\Shop";s:26:"messengerFacebookPageId_19";s:22:"ShopBundle\\Entity\\Shop";s:24:"messengerLoggedInText_20";s:22:"ShopBundle\\Entity\\Shop";s:25:"messengerLoggedOutText_21";s:22:"ShopBundle\\Entity\\Shop";s:8:"email_22";s:22:"ShopBundle\\Entity\\Shop";s:11:"useEmail_23";s:22:"ShopBundle\\Entity\\Shop";s:8:"phone_24";s:22:"ShopBundle\\Entity\\Shop";s:15:"legalNotices_25";s:22:"ShopBundle\\Entity\\Shop";s:28:"generalTermsAndConditions_26";s:22:"ShopBundle\\Entity\\Shop";s:11:"delivery_27";s:22:"ShopBundle\\Entity\\Shop";s:17:"isDeliveryFree_28";s:22:"ShopBundle\\Entity\\Shop";s:21:"deliveryFreeAmount_29";s:22:"ShopBundle\\Entity\\Shop";s:16:"invoicePrefix_30";s:22:"ShopBundle\\Entity\\Shop";s:21:"invoiceStartNumber_31";s:22:"ShopBundle\\Entity\\Shop";s:20:"afterSalesService_32";s:22:"ShopBundle\\Entity\\Shop";s:8:"about_33";s:22:"ShopBundle\\Entity\\Shop";s:17:"isDomainCustom_34";s:22:"ShopBundle\\Entity\\Shop";s:18:"dnsEntryChecked_35";s:22:"ShopBundle\\Entity\\Shop";s:15:"masterStatus_36";s:22:"ShopBundle\\Entity\\Shop";s:13:"randomSort_37";s:22:"ShopBundle\\Entity\\Shop";s:7:"type_38";s:22:"ShopBundle\\Entity\\Shop";s:13:"authAccess_39";s:22:"ShopBundle\\Entity\\Shop";s:11:"password_40";s:22:"ShopBundle\\Entity\\Shop";s:25:"customizationAvailable_41";s:22:"ShopBundle\\Entity\\Shop";s:9:"margin_42";s:22:"ShopBundle\\Entity\\Shop";s:11:"homeDesc_43";s:22:"ShopBundle\\Entity\\Shop";s:14:"fullCatalog_44";s:22:"ShopBundle\\Entity\\Shop";s:21:"openDesignsLibrary_45";s:22:"ShopBundle\\Entity\\Shop";s:19:"customImagesOnly_46";s:22:"ShopBundle\\Entity\\Shop";s:10:"dspFees_47";s:22:"ShopBundle\\Entity\\Shop";s:9:"master_48";s:22:"ShopBundle\\Entity\\Shop";s:15:"headerTopMsg_49";s:22:"ShopBundle\\Entity\\Shop";s:13:"reviewNote_50";s:22:"ShopBundle\\Entity\\Shop";s:16:"actionBtnText_51";s:22:"ShopBundle\\Entity\\Shop";s:15:"actionBtnUrl_52";s:22:"ShopBundle\\Entity\\Shop";s:19:"leftAdBlockTitle_53";s:22:"ShopBundle\\Entity\\Shop";s:18:"leftAdBlockText_54";s:22:"ShopBundle\\Entity\\Shop";s:24:"leftAdBlockButtonText_55";s:22:"ShopBundle\\Entity\\Shop";s:23:"leftAdBlockButtonUrl_56";s:22:"ShopBundle\\Entity\\Shop";s:25:"leftAdBlockButtonTitle_57";s:22:"ShopBundle\\Entity\\Shop";s:20:"rightAdBlockTitle_58";s:22:"ShopBundle\\Entity\\Shop";s:19:"rightAdBlockText_59";s:22:"ShopBundle\\Entity\\Shop";s:25:"rightAdBlockButtonText_60";s:22:"ShopBundle\\Entity\\Shop";s:24:"rightAdBlockButtonUrl_61";s:22:"ShopBundle\\Entity\\Shop";s:26:"rightAdBlockButtonTitle_62";s:22:"ShopBundle\\Entity\\Shop";s:10:"h1Title_63";s:22:"ShopBundle\\Entity\\Shop";s:27:"subCategoriesDisplayMode_64";s:22:"ShopBundle\\Entity\\Shop";s:17:"obfuscateLinks_65";s:22:"ShopBundle\\Entity\\Shop";s:11:"ytgGroup_66";s:22:"ShopBundle\\Entity\\Shop";s:16:"shopifyApiKey_67";s:22:"ShopBundle\\Entity\\Shop";s:21:"shopifyApiPassword_68";s:22:"ShopBundle\\Entity\\Shop";s:20:"shopifySharedCode_69";s:22:"ShopBundle\\Entity\\Shop";s:30:"shopifyFulfillmentServiceId_70";s:22:"ShopBundle\\Entity\\Shop";s:34:"shopifyFulfillmentServiceHandle_71";s:22:"ShopBundle\\Entity\\Shop";s:20:"shopifyLocationId_72";s:22:"ShopBundle\\Entity\\Shop";s:27:"shopifyFulfillmentErrors_73";s:22:"ShopBundle\\Entity\\Shop";s:23:"shopifyWebhookErrors_74";s:22:"ShopBundle\\Entity\\Shop";s:19:"optionsAvailable_75";s:22:"ShopBundle\\Entity\\Shop";s:11:"showcase_76";s:22:"ShopBundle\\Entity\\Shop";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:51:"' . "\0" . 'Doctrine\\ORM\\Query\\ParserResult' . "\0" . '_parameterMappings";a:0:{}}', );