0 a664ea84de95e382a2519962b0568de3 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:1466:"SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.preferences AS preferences_21, u0_.signature AS signature_22, r1_.is_published AS is_published_23, r1_.date_added AS date_added_24, r1_.created_by AS created_by_25, r1_.created_by_user AS created_by_user_26, r1_.date_modified AS date_modified_27, r1_.modified_by AS modified_by_28, r1_.modified_by_user AS modified_by_user_29, r1_.checked_out AS checked_out_30, r1_.checked_out_by AS checked_out_by_31, r1_.checked_out_by_user AS checked_out_by_user_32, r1_.id AS id_33, r1_.name AS name_34, r1_.description AS description_35, r1_.is_admin AS is_admin_36, r1_.readable_permissions AS readable_permissions_37, u0_.role_id AS role_id_38 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE (u0_.username = ? OR u0_.email = ?) AND u0_.is_published = ?";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":20:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:2:{s:1:"u";s:29:"Mautic\UserBundle\Entity\User";s:1:"r";s:29:"Mautic\UserBundle\Entity\Role";}s:11:"relationMap";a:1:{s:1:"r";s:4:"role";}s:14:"parentAliasMap";a:1:{s:1:"r";s:1:"u";}s:13:"fieldMappings";a:38:{s:14:"is_published_0";s:11:"isPublished";s:12:"date_added_1";s:9:"dateAdded";s:12:"created_by_2";s:9:"createdBy";s:17:"created_by_user_3";s:13:"createdByUser";s:15:"date_modified_4";s:12:"dateModified";s:13:"modified_by_5";s:10:"modifiedBy";s:18:"modified_by_user_6";s:14:"modifiedByUser";s:13:"checked_out_7";s:10:"checkedOut";s:16:"checked_out_by_8";s:12:"checkedOutBy";s:21:"checked_out_by_user_9";s:16:"checkedOutByUser";s:5:"id_10";s:2:"id";s:11:"username_11";s:8:"username";s:11:"password_12";s:8:"password";s:13:"first_name_13";s:9:"firstName";s:12:"last_name_14";s:8:"lastName";s:8:"email_15";s:5:"email";s:11:"position_16";s:8:"position";s:11:"timezone_17";s:8:"timezone";s:9:"locale_18";s:6:"locale";s:13:"last_login_19";s:9:"lastLogin";s:14:"last_active_20";s:10:"lastActive";s:14:"preferences_21";s:11:"preferences";s:12:"signature_22";s:9:"signature";s:15:"is_published_23";s:11:"isPublished";s:13:"date_added_24";s:9:"dateAdded";s:13:"created_by_25";s:9:"createdBy";s:18:"created_by_user_26";s:13:"createdByUser";s:16:"date_modified_27";s:12:"dateModified";s:14:"modified_by_28";s:10:"modifiedBy";s:19:"modified_by_user_29";s:14:"modifiedByUser";s:14:"checked_out_30";s:10:"checkedOut";s:17:"checked_out_by_31";s:12:"checkedOutBy";s:22:"checked_out_by_user_32";s:16:"checkedOutByUser";s:5:"id_33";s:2:"id";s:7:"name_34";s:4:"name";s:14:"description_35";s:11:"description";s:11:"is_admin_36";s:7:"isAdmin";s:23:"readable_permissions_37";s:14:"rawPermissions";}s:19:"columnAliasMappings";a:2:{s:29:"Mautic\UserBundle\Entity\User";a:1:{s:1:"u";a:23:{s:11:"isPublished";s:14:"is_published_0";s:9:"dateAdded";s:12:"date_added_1";s:9:"createdBy";s:12:"created_by_2";s:13:"createdByUser";s:17:"created_by_user_3";s:12:"dateModified";s:15:"date_modified_4";s:10:"modifiedBy";s:13:"modified_by_5";s:14:"modifiedByUser";s:18:"modified_by_user_6";s:10:"checkedOut";s:13:"checked_out_7";s:12:"checkedOutBy";s:16:"checked_out_by_8";s:16:"checkedOutByUser";s:21:"checked_out_by_user_9";s:2:"id";s:5:"id_10";s:8:"username";s:11:"username_11";s:8:"password";s:11:"password_12";s:9:"firstName";s:13:"first_name_13";s:8:"lastName";s:12:"last_name_14";s:5:"email";s:8:"email_15";s:8:"position";s:11:"position_16";s:8:"timezone";s:11:"timezone_17";s:6:"locale";s:9:"locale_18";s:9:"lastLogin";s:13:"last_login_19";s:10:"lastActive";s:14:"last_active_20";s:11:"preferences";s:14:"preferences_21";s:9:"signature";s:12:"signature_22";}}s:29:"Mautic\UserBundle\Entity\Role";a:1:{s:1:"r";a:15:{s:11:"isPublished";s:15:"is_published_23";s:9:"dateAdded";s:13:"date_added_24";s:9:"createdBy";s:13:"created_by_25";s:13:"createdByUser";s:18:"created_by_user_26";s:12:"dateModified";s:16:"date_modified_27";s:10:"modifiedBy";s:14:"modified_by_28";s:14:"modifiedByUser";s:19:"modified_by_user_29";s:10:"checkedOut";s:14:"checked_out_30";s:12:"checkedOutBy";s:17:"checked_out_by_31";s:16:"checkedOutByUser";s:22:"checked_out_by_user_32";s:2:"id";s:5:"id_33";s:4:"name";s:7:"name_34";s:11:"description";s:14:"description_35";s:7:"isAdmin";s:11:"is_admin_36";s:14:"rawPermissions";s:23:"readable_permissions_37";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:1:{s:10:"role_id_38";s:7:"integer";}s:14:"entityMappings";a:1:{s:1:"u";N;}s:12:"metaMappings";a:1:{s:10:"role_id_38";s:7:"role_id";}s:14:"columnOwnerMap";a:39:{s:14:"is_published_0";s:1:"u";s:12:"date_added_1";s:1:"u";s:12:"created_by_2";s:1:"u";s:17:"created_by_user_3";s:1:"u";s:15:"date_modified_4";s:1:"u";s:13:"modified_by_5";s:1:"u";s:18:"modified_by_user_6";s:1:"u";s:13:"checked_out_7";s:1:"u";s:16:"checked_out_by_8";s:1:"u";s:21:"checked_out_by_user_9";s:1:"u";s:5:"id_10";s:1:"u";s:11:"username_11";s:1:"u";s:11:"password_12";s:1:"u";s:13:"first_name_13";s:1:"u";s:12:"last_name_14";s:1:"u";s:8:"email_15";s:1:"u";s:11:"position_16";s:1:"u";s:11:"timezone_17";s:1:"u";s:9:"locale_18";s:1:"u";s:13:"last_login_19";s:1:"u";s:14:"last_active_20";s:1:"u";s:14:"preferences_21";s:1:"u";s:12:"signature_22";s:1:"u";s:15:"is_published_23";s:1:"r";s:13:"date_added_24";s:1:"r";s:13:"created_by_25";s:1:"r";s:18:"created_by_user_26";s:1:"r";s:16:"date_modified_27";s:1:"r";s:14:"modified_by_28";s:1:"r";s:19:"modified_by_user_29";s:1:"r";s:14:"checked_out_30";s:1:"r";s:17:"checked_out_by_31";s:1:"r";s:22:"checked_out_by_user_32";s:1:"r";s:5:"id_33";s:1:"r";s:7:"name_34";s:1:"r";s:14:"description_35";s:1:"r";s:11:"is_admin_36";s:1:"r";s:23:"readable_permissions_37";s:1:"r";s:10:"role_id_38";s:1:"u";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:38:{s:14:"is_published_0";s:29:"Mautic\UserBundle\Entity\User";s:12:"date_added_1";s:29:"Mautic\UserBundle\Entity\User";s:12:"created_by_2";s:29:"Mautic\UserBundle\Entity\User";s:17:"created_by_user_3";s:29:"Mautic\UserBundle\Entity\User";s:15:"date_modified_4";s:29:"Mautic\UserBundle\Entity\User";s:13:"modified_by_5";s:29:"Mautic\UserBundle\Entity\User";s:18:"modified_by_user_6";s:29:"Mautic\UserBundle\Entity\User";s:13:"checked_out_7";s:29:"Mautic\UserBundle\Entity\User";s:16:"checked_out_by_8";s:29:"Mautic\UserBundle\Entity\User";s:21:"checked_out_by_user_9";s:29:"Mautic\UserBundle\Entity\User";s:5:"id_10";s:29:"Mautic\UserBundle\Entity\User";s:11:"username_11";s:29:"Mautic\UserBundle\Entity\User";s:11:"password_12";s:29:"Mautic\UserBundle\Entity\User";s:13:"first_name_13";s:29:"Mautic\UserBundle\Entity\User";s:12:"last_name_14";s:29:"Mautic\UserBundle\Entity\User";s:8:"email_15";s:29:"Mautic\UserBundle\Entity\User";s:11:"position_16";s:29:"Mautic\UserBundle\Entity\User";s:11:"timezone_17";s:29:"Mautic\UserBundle\Entity\User";s:9:"locale_18";s:29:"Mautic\UserBundle\Entity\User";s:13:"last_login_19";s:29:"Mautic\UserBundle\Entity\User";s:14:"last_active_20";s:29:"Mautic\UserBundle\Entity\User";s:14:"preferences_21";s:29:"Mautic\UserBundle\Entity\User";s:12:"signature_22";s:29:"Mautic\UserBundle\Entity\User";s:15:"is_published_23";s:29:"Mautic\UserBundle\Entity\Role";s:13:"date_added_24";s:29:"Mautic\UserBundle\Entity\Role";s:13:"created_by_25";s:29:"Mautic\UserBundle\Entity\Role";s:18:"created_by_user_26";s:29:"Mautic\UserBundle\Entity\Role";s:16:"date_modified_27";s:29:"Mautic\UserBundle\Entity\Role";s:14:"modified_by_28";s:29:"Mautic\UserBundle\Entity\Role";s:19:"modified_by_user_29";s:29:"Mautic\UserBundle\Entity\Role";s:14:"checked_out_30";s:29:"Mautic\UserBundle\Entity\Role";s:17:"checked_out_by_31";s:29:"Mautic\UserBundle\Entity\Role";s:22:"checked_out_by_user_32";s:29:"Mautic\UserBundle\Entity\Role";s:5:"id_33";s:29:"Mautic\UserBundle\Entity\Role";s:7:"name_34";s:29:"Mautic\UserBundle\Entity\Role";s:14:"description_35";s:29:"Mautic\UserBundle\Entity\Role";s:11:"is_admin_36";s:29:"Mautic\UserBundle\Entity\Role";s:23:"readable_permissions_37";s:29:"Mautic\UserBundle\Entity\Role";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:2:{s:8:"username";a:2:{i:0;i:0;i:1;i:1;}s:4:"true";a:1:{i:0;i:2;}}}