[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'status' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.serial_number AS serial_number_2, c0_.incoming_site_name AS incoming_site_name_3, c0_.payload AS payload_4, c0_.status AS status_5, c0_.created_at AS created_at_6, c0_.resolved_at AS resolved_at_7, c0_.fingerprint AS fingerprint_8, c0_.message AS message_9, c0_.occurrences AS occurrences_10, c0_.last_seen_at AS last_seen_at_11, c0_.resolution_action AS resolution_action_12, c0_.resolution_note AS resolution_note_13, s1_.id AS id_14, s1_.nom AS nom_15, s1_.is_hidden AS is_hidden_16, s1_.created_at AS created_at_17, s2_.id AS id_18, s2_.nom AS nom_19, s2_.is_hidden AS is_hidden_20, s2_.created_at AS created_at_21, c0_.imprimante_id AS imprimante_id_22, c0_.current_site_id AS current_site_id_23, c0_.incoming_site_id AS incoming_site_id_24, c0_.resolved_by_id AS resolved_by_id_25 FROM csv_import_anomaly c0_ LEFT JOIN site s1_ ON c0_.current_site_id = s1_.id LEFT JOIN site s2_ ON c0_.incoming_site_id = s2_.id WHERE c0_.status = ? ORDER BY c0_.last_seen_at DESC, c0_.id DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'a' => 'App\\Entity\\CsvImportAnomaly', 'currentSite' => 'App\\Entity\\Site', 'incomingSite' => 'App\\Entity\\Site', ], ], 'relationMap' => [ 2 => [ 'currentSite' => 'currentSite', 'incomingSite' => 'incomingSite', ], ], 'parentAliasMap' => [ 2 => [ 'currentSite' => 'a', 'incomingSite' => 'a', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'type_1' => 'type', 'serial_number_2' => 'serialNumber', 'incoming_site_name_3' => 'incomingSiteName', 'payload_4' => 'payload', 'status_5' => 'status', 'created_at_6' => 'createdAt', 'resolved_at_7' => 'resolvedAt', 'fingerprint_8' => 'fingerprint', 'message_9' => 'message', 'occurrences_10' => 'occurrences', 'last_seen_at_11' => 'lastSeenAt', 'resolution_action_12' => 'resolutionAction', 'resolution_note_13' => 'resolutionNote', 'id_14' => 'id', 'nom_15' => 'nom', 'is_hidden_16' => 'isHidden', 'created_at_17' => 'createdAt', 'id_18' => 'id', 'nom_19' => 'nom', 'is_hidden_20' => 'isHidden', 'created_at_21' => 'createdAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\CsvImportAnomaly' => [ 'a' => [ 'id' => 'id_0', 'type' => 'type_1', 'serialNumber' => 'serial_number_2', 'incomingSiteName' => 'incoming_site_name_3', 'payload' => 'payload_4', 'status' => 'status_5', 'createdAt' => 'created_at_6', 'resolvedAt' => 'resolved_at_7', 'fingerprint' => 'fingerprint_8', 'message' => 'message_9', 'occurrences' => 'occurrences_10', 'lastSeenAt' => 'last_seen_at_11', 'resolutionAction' => 'resolution_action_12', 'resolutionNote' => 'resolution_note_13', ], ], 'App\\Entity\\Site' => [ 'currentSite' => [ 'id' => 'id_14', 'nom' => 'nom_15', 'isHidden' => 'is_hidden_16', 'createdAt' => 'created_at_17', ], 'incomingSite' => [ 'id' => 'id_18', 'nom' => 'nom_19', 'isHidden' => 'is_hidden_20', 'createdAt' => 'created_at_21', ], ], ], ], 'enumMappings' => [ 2 => [ 'status_5' => 'App\\Entity\\Enum\\CsvImportAnomalyStatus', ], ], 'typeMappings' => [ 2 => [ 'imprimante_id_22' => 'integer', 'current_site_id_23' => 'integer', 'incoming_site_id_24' => 'integer', 'resolved_by_id_25' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'a' => null, ], ], 'metaMappings' => [ 2 => [ 'imprimante_id_22' => 'imprimante_id', 'current_site_id_23' => 'current_site_id', 'incoming_site_id_24' => 'incoming_site_id', 'resolved_by_id_25' => 'resolved_by_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'a', 'type_1' => 'a', 'serial_number_2' => 'a', 'incoming_site_name_3' => 'a', 'payload_4' => 'a', 'status_5' => 'a', 'created_at_6' => 'a', 'resolved_at_7' => 'a', 'fingerprint_8' => 'a', 'message_9' => 'a', 'occurrences_10' => 'a', 'last_seen_at_11' => 'a', 'resolution_action_12' => 'a', 'resolution_note_13' => 'a', 'id_14' => 'currentSite', 'nom_15' => 'currentSite', 'is_hidden_16' => 'currentSite', 'created_at_17' => 'currentSite', 'id_18' => 'incomingSite', 'nom_19' => 'incomingSite', 'is_hidden_20' => 'incomingSite', 'created_at_21' => 'incomingSite', 'imprimante_id_22' => 'a', 'current_site_id_23' => 'a', 'incoming_site_id_24' => 'a', 'resolved_by_id_25' => 'a', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\CsvImportAnomaly', 'type_1' => 'App\\Entity\\CsvImportAnomaly', 'serial_number_2' => 'App\\Entity\\CsvImportAnomaly', 'incoming_site_name_3' => 'App\\Entity\\CsvImportAnomaly', 'payload_4' => 'App\\Entity\\CsvImportAnomaly', 'status_5' => 'App\\Entity\\CsvImportAnomaly', 'created_at_6' => 'App\\Entity\\CsvImportAnomaly', 'resolved_at_7' => 'App\\Entity\\CsvImportAnomaly', 'fingerprint_8' => 'App\\Entity\\CsvImportAnomaly', 'message_9' => 'App\\Entity\\CsvImportAnomaly', 'occurrences_10' => 'App\\Entity\\CsvImportAnomaly', 'last_seen_at_11' => 'App\\Entity\\CsvImportAnomaly', 'resolution_action_12' => 'App\\Entity\\CsvImportAnomaly', 'resolution_note_13' => 'App\\Entity\\CsvImportAnomaly', 'id_14' => 'App\\Entity\\Site', 'nom_15' => 'App\\Entity\\Site', 'is_hidden_16' => 'App\\Entity\\Site', 'created_at_17' => 'App\\Entity\\Site', 'id_18' => 'App\\Entity\\Site', 'nom_19' => 'App\\Entity\\Site', 'is_hidden_20' => 'App\\Entity\\Site', 'created_at_21' => 'App\\Entity\\Site', ], ], ], ], $o[0], [] ); } }];