[ 'sql' => [ 1 => 'SELECT k0_.id AS id_0, k1_.id AS id_1, k1_.name AS name_2, k1_.number AS number_3, k1_.comment AS comment_4, k1_.visible AS visible_5, k1_.billable AS billable_6, k1_.company AS company_7, k1_.vat_id AS vat_id_8, k1_.contact AS contact_9, k1_.address AS address_10, k1_.country AS country_11, k1_.currency AS currency_12, k1_.phone AS phone_13, k1_.fax AS fax_14, k1_.mobile AS mobile_15, k1_.email AS email_16, k1_.homepage AS homepage_17, k1_.timezone AS timezone_18, k1_.invoice_text AS invoice_text_19, k1_.address_line1 AS address_line1_20, k1_.address_line2 AS address_line2_21, k1_.address_line3 AS address_line3_22, k1_.postcode AS postcode_23, k1_.city AS city_24, k1_.buyer_reference AS buyer_reference_25, k1_.budget AS budget_26, k1_.time_budget AS time_budget_27, k1_.budget_type AS budget_type_28, k1_.color AS color_29, k1_.created_at AS created_at_30, k0_.customer_id AS customer_id_31, k1_.invoice_template_id AS invoice_template_id_32 FROM kimai2_projects k0_ LEFT JOIN kimai2_customers k1_ ON k0_.customer_id = k1_.id WHERE k0_.id IN (56, 3, 2, 108, 55, 79, 88, 57, 147, 38, 24, 17, 12, 6, 81, 75, 51, 123, 145, 26, 112, 90, 110)', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'p' => 'App\\Entity\\Project', 'customer' => 'App\\Entity\\Customer', ], ], 'relationMap' => [ 2 => [ 'customer' => 'customer', ], ], 'parentAliasMap' => [ 2 => [ 'customer' => 'p', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'id_1' => 'id', 'name_2' => 'name', 'number_3' => 'number', 'comment_4' => 'comment', 'visible_5' => 'visible', 'billable_6' => 'billable', 'company_7' => 'company', 'vat_id_8' => 'vatId', 'contact_9' => 'contact', 'address_10' => 'address', 'country_11' => 'country', 'currency_12' => 'currency', 'phone_13' => 'phone', 'fax_14' => 'fax', 'mobile_15' => 'mobile', 'email_16' => 'email', 'homepage_17' => 'homepage', 'timezone_18' => 'timezone', 'invoice_text_19' => 'invoiceText', 'address_line1_20' => 'addressLine1', 'address_line2_21' => 'addressLine2', 'address_line3_22' => 'addressLine3', 'postcode_23' => 'postCode', 'city_24' => 'city', 'buyer_reference_25' => 'buyerReference', 'budget_26' => 'budget', 'time_budget_27' => 'timeBudget', 'budget_type_28' => 'budgetType', 'color_29' => 'color', 'created_at_30' => 'createdAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Project' => [ 'p' => [ 'id' => 'id_0', ], ], 'App\\Entity\\Customer' => [ 'customer' => [ 'id' => 'id_1', 'name' => 'name_2', 'number' => 'number_3', 'comment' => 'comment_4', 'visible' => 'visible_5', 'billable' => 'billable_6', 'company' => 'company_7', 'vatId' => 'vat_id_8', 'contact' => 'contact_9', 'address' => 'address_10', 'country' => 'country_11', 'currency' => 'currency_12', 'phone' => 'phone_13', 'fax' => 'fax_14', 'mobile' => 'mobile_15', 'email' => 'email_16', 'homepage' => 'homepage_17', 'timezone' => 'timezone_18', 'invoiceText' => 'invoice_text_19', 'addressLine1' => 'address_line1_20', 'addressLine2' => 'address_line2_21', 'addressLine3' => 'address_line3_22', 'postCode' => 'postcode_23', 'city' => 'city_24', 'buyerReference' => 'buyer_reference_25', 'budget' => 'budget_26', 'timeBudget' => 'time_budget_27', 'budgetType' => 'budget_type_28', 'color' => 'color_29', 'createdAt' => 'created_at_30', ], ], ], ], 'typeMappings' => [ 2 => [ 'customer_id_31' => 'integer', 'invoice_template_id_32' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'p' => null, ], ], 'metaMappings' => [ 2 => [ 'customer_id_31' => 'customer_id', 'invoice_template_id_32' => 'invoice_template_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'p', 'id_1' => 'customer', 'name_2' => 'customer', 'number_3' => 'customer', 'comment_4' => 'customer', 'visible_5' => 'customer', 'billable_6' => 'customer', 'company_7' => 'customer', 'vat_id_8' => 'customer', 'contact_9' => 'customer', 'address_10' => 'customer', 'country_11' => 'customer', 'currency_12' => 'customer', 'phone_13' => 'customer', 'fax_14' => 'customer', 'mobile_15' => 'customer', 'email_16' => 'customer', 'homepage_17' => 'customer', 'timezone_18' => 'customer', 'invoice_text_19' => 'customer', 'address_line1_20' => 'customer', 'address_line2_21' => 'customer', 'address_line3_22' => 'customer', 'postcode_23' => 'customer', 'city_24' => 'customer', 'buyer_reference_25' => 'customer', 'budget_26' => 'customer', 'time_budget_27' => 'customer', 'budget_type_28' => 'customer', 'color_29' => 'customer', 'created_at_30' => 'customer', 'customer_id_31' => 'p', 'invoice_template_id_32' => 'customer', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Project', 'id_1' => 'App\\Entity\\Customer', 'name_2' => 'App\\Entity\\Customer', 'number_3' => 'App\\Entity\\Customer', 'comment_4' => 'App\\Entity\\Customer', 'visible_5' => 'App\\Entity\\Customer', 'billable_6' => 'App\\Entity\\Customer', 'company_7' => 'App\\Entity\\Customer', 'vat_id_8' => 'App\\Entity\\Customer', 'contact_9' => 'App\\Entity\\Customer', 'address_10' => 'App\\Entity\\Customer', 'country_11' => 'App\\Entity\\Customer', 'currency_12' => 'App\\Entity\\Customer', 'phone_13' => 'App\\Entity\\Customer', 'fax_14' => 'App\\Entity\\Customer', 'mobile_15' => 'App\\Entity\\Customer', 'email_16' => 'App\\Entity\\Customer', 'homepage_17' => 'App\\Entity\\Customer', 'timezone_18' => 'App\\Entity\\Customer', 'invoice_text_19' => 'App\\Entity\\Customer', 'address_line1_20' => 'App\\Entity\\Customer', 'address_line2_21' => 'App\\Entity\\Customer', 'address_line3_22' => 'App\\Entity\\Customer', 'postcode_23' => 'App\\Entity\\Customer', 'city_24' => 'App\\Entity\\Customer', 'buyer_reference_25' => 'App\\Entity\\Customer', 'budget_26' => 'App\\Entity\\Customer', 'time_budget_27' => 'App\\Entity\\Customer', 'budget_type_28' => 'App\\Entity\\Customer', 'color_29' => 'App\\Entity\\Customer', 'created_at_30' => 'App\\Entity\\Customer', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [], ], ] ); } }];