[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'rewe' => [ 0, ], 'year' => [ 1, ], 'month' => [ 2, ], 'types' => [ 3, 4, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT count(DISTINCT r0_.id) AS sclr_0, SUM(r0_.bonus) AS sclr_1, SUM((TIME_TO_SEC(TIMEDIFF(r0_.end, r0_.start)) - (r0_.pause) * 60) / 3600.0) AS sclr_2, r1_.id AS id_3, r1_.date AS date_4, r1_.food_container AS food_container_5, r1_.food_palette AS food_palette_6, r1_.food_palette_xxl AS food_palette_xxl_7, r1_.non_food AS non_food_8, r1_.non_food_palette AS non_food_palette_9, r1_.frozen_food_container AS frozen_food_container_10, r1_.frozen_food_palette AS frozen_food_palette_11, r1_.ordering AS ordering_12, r1_.milk_product_container AS milk_product_container_13, r1_.milk_product_palette AS milk_product_palette_14, r1_.milk_product_palette_xxl AS milk_product_palette_xxl_15, r1_.goods_receipt_control AS goods_receipt_control_16, r1_.sausage_palette AS sausage_palette_17, r1_.hours AS hours_18, r1_.newspapers AS newspapers_19, r1_.weekly_paper AS weekly_paper_20, r1_.km_district AS km_district_21, r1_.travel_cost AS travel_cost_22, r1_.longitude_end AS longitude_end_23, r1_.latitude_end AS latitude_end_24, r1_.ended_at AS ended_at_25, m2_.number AS number_26, m2_.city AS city_27, m2_.address AS address_28, m2_.ordering_rate AS ordering_rate_29 FROM record_market r1_ INNER JOIN market m2_ ON r1_.market_number = m2_.number LEFT JOIN record_worker r0_ ON (r1_.market_number = r0_.market_number AND r1_.date = r0_.date AND r0_.type = ?) WHERE YEAR(r1_.date) = ? AND MONTH(r1_.date) = ? AND m2_.number IN (\'2458\') AND DAY(r1_.date) > 15 AND (NOT (SUBSTRING(m2_.number FROM 1 FOR 2) IN (?) OR SUBSTRING(m2_.number FROM 1 FOR 1) IN (?))) GROUP BY r1_.market_number, r1_.date, r1_.user_id ORDER BY r1_.date DESC, r1_.market_number ASC', ], ], 'stdClass' => [ 'isMixed' => [ 2 => true, ], 'aliasMap' => [ 2 => [ 'r' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'm' => 'Emgmbh\\MarketBundle\\Entity\\Market', ], ], 'relationMap' => [ 2 => [ 'm' => 'market', ], ], 'parentAliasMap' => [ 2 => [ 'm' => 'r', ], ], 'fieldMappings' => [ 2 => [ 'id_3' => 'id', 'date_4' => 'date', 'food_container_5' => 'foodContainer', 'food_palette_6' => 'foodPalette', 'food_palette_xxl_7' => 'foodPaletteXxl', 'non_food_8' => 'nonFood', 'non_food_palette_9' => 'nonFoodPalette', 'frozen_food_container_10' => 'frozenFoodContainer', 'frozen_food_palette_11' => 'frozenFoodPalette', 'ordering_12' => 'ordering', 'milk_product_container_13' => 'milkProductContainer', 'milk_product_palette_14' => 'milkProductPalette', 'milk_product_palette_xxl_15' => 'milkProductPaletteXxl', 'goods_receipt_control_16' => 'goodsReceiptControl', 'sausage_palette_17' => 'sausagePalette', 'hours_18' => 'hours', 'newspapers_19' => 'newspapers', 'weekly_paper_20' => 'weeklyPaper', 'km_district_21' => 'kmDistrict', 'travel_cost_22' => 'travelCost', 'longitude_end_23' => 'longitudeEnd', 'latitude_end_24' => 'latitudeEnd', 'ended_at_25' => 'endedAt', 'number_26' => 'number', 'city_27' => 'city', 'address_28' => 'address', 'ordering_rate_29' => 'orderingRate', ], ], 'scalarMappings' => [ 2 => [ 'sclr_0' => 'workers', 'sclr_1' => 'bonus', 'sclr_2' => 'worktime', ], ], 'typeMappings' => [ 2 => [ 'sclr_0' => 'string', 'sclr_1' => 'string', 'sclr_2' => 'string', ], ], 'entityMappings' => [ 2 => [ 'r' => 'record', ], ], 'columnOwnerMap' => [ 2 => [ 'id_3' => 'r', 'date_4' => 'r', 'food_container_5' => 'r', 'food_palette_6' => 'r', 'food_palette_xxl_7' => 'r', 'non_food_8' => 'r', 'non_food_palette_9' => 'r', 'frozen_food_container_10' => 'r', 'frozen_food_palette_11' => 'r', 'ordering_12' => 'r', 'milk_product_container_13' => 'r', 'milk_product_palette_14' => 'r', 'milk_product_palette_xxl_15' => 'r', 'goods_receipt_control_16' => 'r', 'sausage_palette_17' => 'r', 'hours_18' => 'r', 'newspapers_19' => 'r', 'weekly_paper_20' => 'r', 'km_district_21' => 'r', 'travel_cost_22' => 'r', 'longitude_end_23' => 'r', 'latitude_end_24' => 'r', 'ended_at_25' => 'r', 'number_26' => 'm', 'city_27' => 'm', 'address_28' => 'm', 'ordering_rate_29' => 'm', ], ], 'declaringClasses' => [ 2 => [ 'id_3' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'date_4' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'food_container_5' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'food_palette_6' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'food_palette_xxl_7' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'non_food_8' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'non_food_palette_9' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'frozen_food_container_10' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'frozen_food_palette_11' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'ordering_12' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'milk_product_container_13' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'milk_product_palette_14' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'milk_product_palette_xxl_15' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'goods_receipt_control_16' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'sausage_palette_17' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'hours_18' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'newspapers_19' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'weekly_paper_20' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'km_district_21' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'travel_cost_22' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'longitude_end_23' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'latitude_end_24' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'ended_at_25' => 'Emgmbh\\RecordBundle\\Entity\\RecordMarket', 'number_26' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'city_27' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'address_28' => 'Emgmbh\\MarketBundle\\Entity\\Market', 'ordering_rate_29' => 'Emgmbh\\MarketBundle\\Entity\\Market', ], ], ], ], $o[0], [] ); }];