Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.lastname AS lastname_5,
  t0.firstname AS firstname_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6 FROM user t0 WHERE t0.id = 50;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.reference_internal AS reference_internal_3,
  t0.quantity_min AS quantity_min_4,
  t0.price_unity_initial AS price_unity_initial_5,
  t0.paper_quality AS paper_quality_6,
  t0.paper_quality_percent AS paper_quality_percent_7,
  t0.out_of_stock AS out_of_stock_8,
  t0.out_of_stock_at AS out_of_stock_at_9,
  t0.out_of_stock_quantity AS out_of_stock_quantity_10,
  t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11,
  t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12,
  t0.created_at AS created_at_13,
  t0.archived AS archived_14,
  t0.name AS name_15,
  t0.type AS type_16,
  t0.width AS width_17,
  t0.grammage AS grammage_18,
  t0.mandrel AS mandrel_19,
  t0.diameter AS diameter_20,
  t0.price_unity AS price_unity_21,
  t0.price AS price_22,
  t0.quantity AS quantity_23,
  t0.provider_id AS provider_id_24,
  t0.paper_category_id AS paper_category_id_25
FROM
  paper t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id IN ('1502', '1186', '984', '1253', '1229', '1051', '1038', '1481', '1309', '1304', '1046', '1416', '1331', '1280', '1133', '1405', '1092', '1281', '1402', '1403', '1404', '1285', '1132', '1191', '1442', '1432', '1131', '1141', '1334', '1050');

SELECT
  p0_.id AS id_0,
  p0_.price_unity_updated AS price_unity_updated_1,
  p0_.completed AS completed_2,
  p0_.comment AS comment_3,
  p0_.delivery_edited AS delivery_edited_4,
  p0_.created_at AS created_at_5,
  p0_.archived AS archived_6,
  p0_.product_price AS product_price_7,
  p0_.price_difference AS price_difference_8,
  p0_.product_quantity AS product_quantity_9,
  p0_.quantity_difference AS quantity_difference_10,
  p0_.delivered AS delivered_11,
  p0_.delivered_at AS delivered_at_12,
  p0_.delivery_progress AS delivery_progress_13,
  p0_.product_count AS product_count_14,
  p0_.product_delivered_count AS product_delivered_count_15,
  p0_.price AS price_16,
  p0_.quantity AS quantity_17,
  p0_.price_unity AS price_unity_18,
  p0_.type AS type_19,
  p0_.price_movement AS price_movement_20,
  p0_.quantity_movement AS quantity_movement_21,
  p0_.provider_order_id AS provider_order_id_22,
  p0_.paper_id AS paper_id_23
FROM
  provider_order_item p0_
  LEFT JOIN provider_order p1_ ON p0_.provider_order_id = p1_.id
  LEFT JOIN paper p2_ ON p0_.paper_id = p2_.id
WHERE
  p2_.id = ?
  AND (
    p1_.completed = 0
    OR p1_.delivered = 0
  )
  AND p0_.quantity_movement > 0
  AND p1_.archived = 0
  AND p0_.archived = 0
ORDER BY
  p0_.delivered_at ASC

SELECT p0_.id AS id_0, p0_.price_unity_updated AS price_unity_updated_1, p0_.completed AS completed_2, p0_.comment AS comment_3, p0_.delivery_edited AS delivery_edited_4, p0_.created_at AS created_at_5, p0_.archived AS archived_6, p0_.product_price AS product_price_7, p0_.price_difference AS price_difference_8, p0_.product_quantity AS product_quantity_9, p0_.quantity_difference AS quantity_difference_10, p0_.delivered AS delivered_11, p0_.delivered_at AS delivered_at_12, p0_.delivery_progress AS delivery_progress_13, p0_.product_count AS product_count_14, p0_.product_delivered_count AS product_delivered_count_15, p0_.price AS price_16, p0_.quantity AS quantity_17, p0_.price_unity AS price_unity_18, p0_.type AS type_19, p0_.price_movement AS price_movement_20, p0_.quantity_movement AS quantity_movement_21, p0_.provider_order_id AS provider_order_id_22, p0_.paper_id AS paper_id_23 FROM provider_order_item p0_ LEFT JOIN provider_order p1_ ON p0_.provider_order_id = p1_.id LEFT JOIN paper p2_ ON p0_.paper_id = p2_.id WHERE p2_.id = 984 AND (p1_.completed = 0 OR p1_.delivered = 0) AND p0_.quantity_movement > 0 AND p1_.archived = 0 AND p0_.archived = 0 ORDER BY p0_.delivered_at ASC;

SELECT
  c0_.id AS id_0,
  c0_.price_ordered AS price_ordered_1,
  c0_.quantity_ordered AS quantity_ordered_2,
  c0_.production_at AS production_at_3,
  c0_.comment AS comment_4,
  c0_.detail AS detail_5,
  c0_.production_edited AS production_edited_6,
  c0_.created_at AS created_at_7,
  c0_.archived AS archived_8,
  c0_.type AS type_9,
  c0_.price_movement AS price_movement_10,
  c0_.quantity_movement AS quantity_movement_11,
  c0_.price AS price_12,
  c0_.quantity AS quantity_13,
  c0_.price_unity AS price_unity_14,
  c0_.paper_id AS paper_id_15,
  c0_.customer_order_id AS customer_order_id_16
FROM
  customer_order_item c0_
  LEFT JOIN customer_order c1_ ON c0_.customer_order_id = c1_.id
WHERE
  c0_.paper_id = ?
  AND c0_.quantity_movement < 0
  AND c1_.archived = 0
  AND c0_.archived = 0
ORDER BY
  c0_.production_at ASC

SELECT c0_.id AS id_0, c0_.price_ordered AS price_ordered_1, c0_.quantity_ordered AS quantity_ordered_2, c0_.production_at AS production_at_3, c0_.comment AS comment_4, c0_.detail AS detail_5, c0_.production_edited AS production_edited_6, c0_.created_at AS created_at_7, c0_.archived AS archived_8, c0_.type AS type_9, c0_.price_movement AS price_movement_10, c0_.quantity_movement AS quantity_movement_11, c0_.price AS price_12, c0_.quantity AS quantity_13, c0_.price_unity AS price_unity_14, c0_.paper_id AS paper_id_15, c0_.customer_order_id AS customer_order_id_16 FROM customer_order_item c0_ LEFT JOIN customer_order c1_ ON c0_.customer_order_id = c1_.id WHERE c0_.paper_id = 984 AND c0_.quantity_movement < 0 AND c1_.archived = 0 AND c0_.archived = 0 ORDER BY c0_.production_at ASC;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.delivered_at AS delivered_at_3,
  t0.ordered_at AS ordered_at_4,
  t0.in_preperation AS in_preperation_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.price AS price_8,
  t0.quantity AS quantity_9,
  t0.customer_id AS customer_id_10
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivered_at AS delivered_at_3, t0.ordered_at AS ordered_at_4, t0.in_preperation AS in_preperation_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.customer_id AS customer_id_10 FROM customer_order t0 WHERE t0.id = 7464;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.archived AS archived_4
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.archived AS archived_4 FROM customer t0 WHERE t0.id = 88;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.delivered_at AS delivered_at_3,
  t0.ordered_at AS ordered_at_4,
  t0.in_preperation AS in_preperation_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.price AS price_8,
  t0.quantity AS quantity_9,
  t0.customer_id AS customer_id_10
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivered_at AS delivered_at_3, t0.ordered_at AS ordered_at_4, t0.in_preperation AS in_preperation_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.customer_id AS customer_id_10 FROM customer_order t0 WHERE t0.id = 7756;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.archived AS archived_4
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.archived AS archived_4 FROM customer t0 WHERE t0.id = 556;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.delivered_at AS delivered_at_3,
  t0.ordered_at AS ordered_at_4,
  t0.in_preperation AS in_preperation_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.price AS price_8,
  t0.quantity AS quantity_9,
  t0.customer_id AS customer_id_10
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivered_at AS delivered_at_3, t0.ordered_at AS ordered_at_4, t0.in_preperation AS in_preperation_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.customer_id AS customer_id_10 FROM customer_order t0 WHERE t0.id = 7648;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.ordered_at AS ordered_at_3,
  t0.delivered_estimation_at AS delivered_estimation_at_4,
  t0.completed AS completed_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.product_price AS product_price_8,
  t0.price_difference AS price_difference_9,
  t0.product_quantity AS product_quantity_10,
  t0.quantity_difference AS quantity_difference_11,
  t0.delivered AS delivered_12,
  t0.delivered_at AS delivered_at_13,
  t0.delivery_progress AS delivery_progress_14,
  t0.product_count AS product_count_15,
  t0.product_delivered_count AS product_delivered_count_16,
  t0.price AS price_17,
  t0.quantity AS quantity_18,
  t0.provider_id AS provider_id_19
FROM
  provider_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ordered_at AS ordered_at_3, t0.delivered_estimation_at AS delivered_estimation_at_4, t0.completed AS completed_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.provider_id AS provider_id_19 FROM provider_order t0 WHERE t0.id = 1773;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.postal_code AS postal_code_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.phone AS phone_8,
  t0.company AS company_9,
  t0.paper_quality AS paper_quality_10,
  t0.paper_quality_percent AS paper_quality_percent_11,
  t0.created_at AS created_at_12,
  t0.archived AS archived_13
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.address AS address_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.country AS country_7, t0.phone AS phone_8, t0.company AS company_9, t0.paper_quality AS paper_quality_10, t0.paper_quality_percent AS paper_quality_percent_11, t0.created_at AS created_at_12, t0.archived AS archived_13 FROM provider t0 WHERE t0.id = 36;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.ordered_at AS ordered_at_3,
  t0.delivered_estimation_at AS delivered_estimation_at_4,
  t0.completed AS completed_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.product_price AS product_price_8,
  t0.price_difference AS price_difference_9,
  t0.product_quantity AS product_quantity_10,
  t0.quantity_difference AS quantity_difference_11,
  t0.delivered AS delivered_12,
  t0.delivered_at AS delivered_at_13,
  t0.delivery_progress AS delivery_progress_14,
  t0.product_count AS product_count_15,
  t0.product_delivered_count AS product_delivered_count_16,
  t0.price AS price_17,
  t0.quantity AS quantity_18,
  t0.provider_id AS provider_id_19
FROM
  provider_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ordered_at AS ordered_at_3, t0.delivered_estimation_at AS delivered_estimation_at_4, t0.completed AS completed_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.provider_id AS provider_id_19 FROM provider_order t0 WHERE t0.id = 1591;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.ordered_at AS ordered_at_3,
  t0.delivered_estimation_at AS delivered_estimation_at_4,
  t0.completed AS completed_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.product_price AS product_price_8,
  t0.price_difference AS price_difference_9,
  t0.product_quantity AS product_quantity_10,
  t0.quantity_difference AS quantity_difference_11,
  t0.delivered AS delivered_12,
  t0.delivered_at AS delivered_at_13,
  t0.delivery_progress AS delivery_progress_14,
  t0.product_count AS product_count_15,
  t0.product_delivered_count AS product_delivered_count_16,
  t0.price AS price_17,
  t0.quantity AS quantity_18,
  t0.provider_id AS provider_id_19
FROM
  provider_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ordered_at AS ordered_at_3, t0.delivered_estimation_at AS delivered_estimation_at_4, t0.completed AS completed_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.provider_id AS provider_id_19 FROM provider_order t0 WHERE t0.id = 1695;

SELECT
  p0_.id AS id_0,
  p0_.price_unity_updated AS price_unity_updated_1,
  p0_.completed AS completed_2,
  p0_.comment AS comment_3,
  p0_.delivery_edited AS delivery_edited_4,
  p0_.created_at AS created_at_5,
  p0_.archived AS archived_6,
  p0_.product_price AS product_price_7,
  p0_.price_difference AS price_difference_8,
  p0_.product_quantity AS product_quantity_9,
  p0_.quantity_difference AS quantity_difference_10,
  p0_.delivered AS delivered_11,
  p0_.delivered_at AS delivered_at_12,
  p0_.delivery_progress AS delivery_progress_13,
  p0_.product_count AS product_count_14,
  p0_.product_delivered_count AS product_delivered_count_15,
  p0_.price AS price_16,
  p0_.quantity AS quantity_17,
  p0_.price_unity AS price_unity_18,
  p0_.type AS type_19,
  p0_.price_movement AS price_movement_20,
  p0_.quantity_movement AS quantity_movement_21,
  p0_.provider_order_id AS provider_order_id_22,
  p0_.paper_id AS paper_id_23
FROM
  provider_order_item p0_
  LEFT JOIN provider_order p1_ ON p0_.provider_order_id = p1_.id
  LEFT JOIN paper p2_ ON p0_.paper_id = p2_.id
WHERE
  p2_.id = ?
  AND (
    p1_.completed = 0
    OR p1_.delivered = 0
  )
  AND p0_.quantity_movement > 0
  AND p1_.archived = 0
  AND p0_.archived = 0
ORDER BY
  p0_.delivered_at ASC

SELECT p0_.id AS id_0, p0_.price_unity_updated AS price_unity_updated_1, p0_.completed AS completed_2, p0_.comment AS comment_3, p0_.delivery_edited AS delivery_edited_4, p0_.created_at AS created_at_5, p0_.archived AS archived_6, p0_.product_price AS product_price_7, p0_.price_difference AS price_difference_8, p0_.product_quantity AS product_quantity_9, p0_.quantity_difference AS quantity_difference_10, p0_.delivered AS delivered_11, p0_.delivered_at AS delivered_at_12, p0_.delivery_progress AS delivery_progress_13, p0_.product_count AS product_count_14, p0_.product_delivered_count AS product_delivered_count_15, p0_.price AS price_16, p0_.quantity AS quantity_17, p0_.price_unity AS price_unity_18, p0_.type AS type_19, p0_.price_movement AS price_movement_20, p0_.quantity_movement AS quantity_movement_21, p0_.provider_order_id AS provider_order_id_22, p0_.paper_id AS paper_id_23 FROM provider_order_item p0_ LEFT JOIN provider_order p1_ ON p0_.provider_order_id = p1_.id LEFT JOIN paper p2_ ON p0_.paper_id = p2_.id WHERE p2_.id = 1038 AND (p1_.completed = 0 OR p1_.delivered = 0) AND p0_.quantity_movement > 0 AND p1_.archived = 0 AND p0_.archived = 0 ORDER BY p0_.delivered_at ASC;

SELECT
  c0_.id AS id_0,
  c0_.price_ordered AS price_ordered_1,
  c0_.quantity_ordered AS quantity_ordered_2,
  c0_.production_at AS production_at_3,
  c0_.comment AS comment_4,
  c0_.detail AS detail_5,
  c0_.production_edited AS production_edited_6,
  c0_.created_at AS created_at_7,
  c0_.archived AS archived_8,
  c0_.type AS type_9,
  c0_.price_movement AS price_movement_10,
  c0_.quantity_movement AS quantity_movement_11,
  c0_.price AS price_12,
  c0_.quantity AS quantity_13,
  c0_.price_unity AS price_unity_14,
  c0_.paper_id AS paper_id_15,
  c0_.customer_order_id AS customer_order_id_16
FROM
  customer_order_item c0_
  LEFT JOIN customer_order c1_ ON c0_.customer_order_id = c1_.id
WHERE
  c0_.paper_id = ?
  AND c0_.quantity_movement < 0
  AND c1_.archived = 0
  AND c0_.archived = 0
ORDER BY
  c0_.production_at ASC

SELECT c0_.id AS id_0, c0_.price_ordered AS price_ordered_1, c0_.quantity_ordered AS quantity_ordered_2, c0_.production_at AS production_at_3, c0_.comment AS comment_4, c0_.detail AS detail_5, c0_.production_edited AS production_edited_6, c0_.created_at AS created_at_7, c0_.archived AS archived_8, c0_.type AS type_9, c0_.price_movement AS price_movement_10, c0_.quantity_movement AS quantity_movement_11, c0_.price AS price_12, c0_.quantity AS quantity_13, c0_.price_unity AS price_unity_14, c0_.paper_id AS paper_id_15, c0_.customer_order_id AS customer_order_id_16 FROM customer_order_item c0_ LEFT JOIN customer_order c1_ ON c0_.customer_order_id = c1_.id WHERE c0_.paper_id = 1038 AND c0_.quantity_movement < 0 AND c1_.archived = 0 AND c0_.archived = 0 ORDER BY c0_.production_at ASC;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.delivered_at AS delivered_at_3,
  t0.ordered_at AS ordered_at_4,
  t0.in_preperation AS in_preperation_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.price AS price_8,
  t0.quantity AS quantity_9,
  t0.customer_id AS customer_id_10
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivered_at AS delivered_at_3, t0.ordered_at AS ordered_at_4, t0.in_preperation AS in_preperation_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.customer_id AS customer_id_10 FROM customer_order t0 WHERE t0.id = 7193;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.archived AS archived_4
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.archived AS archived_4 FROM customer t0 WHERE t0.id = 91;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.ordered_at AS ordered_at_3,
  t0.delivered_estimation_at AS delivered_estimation_at_4,
  t0.completed AS completed_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.product_price AS product_price_8,
  t0.price_difference AS price_difference_9,
  t0.product_quantity AS product_quantity_10,
  t0.quantity_difference AS quantity_difference_11,
  t0.delivered AS delivered_12,
  t0.delivered_at AS delivered_at_13,
  t0.delivery_progress AS delivery_progress_14,
  t0.product_count AS product_count_15,
  t0.product_delivered_count AS product_delivered_count_16,
  t0.price AS price_17,
  t0.quantity AS quantity_18,
  t0.provider_id AS provider_id_19
FROM
  provider_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ordered_at AS ordered_at_3, t0.delivered_estimation_at AS delivered_estimation_at_4, t0.completed AS completed_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.provider_id AS provider_id_19 FROM provider_order t0 WHERE t0.id = 1620;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.ordered_at AS ordered_at_3,
  t0.delivered_estimation_at AS delivered_estimation_at_4,
  t0.completed AS completed_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.product_price AS product_price_8,
  t0.price_difference AS price_difference_9,
  t0.product_quantity AS product_quantity_10,
  t0.quantity_difference AS quantity_difference_11,
  t0.delivered AS delivered_12,
  t0.delivered_at AS delivered_at_13,
  t0.delivery_progress AS delivery_progress_14,
  t0.product_count AS product_count_15,
  t0.product_delivered_count AS product_delivered_count_16,
  t0.price AS price_17,
  t0.quantity AS quantity_18,
  t0.provider_id AS provider_id_19
FROM
  provider_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ordered_at AS ordered_at_3, t0.delivered_estimation_at AS delivered_estimation_at_4, t0.completed AS completed_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.provider_id AS provider_id_19 FROM provider_order t0 WHERE t0.id = 1645;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.ordered_at AS ordered_at_3,
  t0.delivered_estimation_at AS delivered_estimation_at_4,
  t0.completed AS completed_5,
  t0.created_at AS created_at_6,
  t0.archived AS archived_7,
  t0.product_price AS product_price_8,
  t0.price_difference AS price_difference_9,
  t0.product_quantity AS product_quantity_10,
  t0.quantity_difference AS quantity_difference_11,
  t0.delivered AS delivered_12,
  t0.delivered_at AS delivered_at_13,
  t0.delivery_progress AS delivery_progress_14,
  t0.product_count AS product_count_15,
  t0.product_delivered_count AS product_delivered_count_16,
  t0.price AS price_17,
  t0.quantity AS quantity_18,
  t0.provider_id AS provider_id_19
FROM
  provider_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ordered_at AS ordered_at_3, t0.delivered_estimation_at AS delivered_estimation_at_4, t0.completed AS completed_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.provider_id AS provider_id_19 FROM provider_order t0 WHERE t0.id = 1675;

SELECT
  p0_.id AS id_0,
  p0_.price_unity_updated AS price_unity_updated_1,
  p0_.completed AS completed_2,
  p0_.comment AS comment_3,
  p0_.delivery_edited AS delivery_edited_4,
  p0_.created_at AS created_at_5,
  p0_.archived AS archived_6,
  p0_.product_price AS product_price_7,
  p0_.price_difference AS price_difference_8,
  p0_.product_quantity AS product_quantity_9,
  p0_.quantity_difference AS quantity_difference_10,
  p0_.delivered AS delivered_11,
  p0_.delivered_at AS delivered_at_12,
  p0_.delivery_progress AS delivery_progress_13,
  p0_.product_count AS product_count_14,
  p0_.product_delivered_count AS product_delivered_count_15,
  p0_.price AS price_16,
  p0_.quantity AS quantity_17,
  p0_.price_unity AS price_unity_18,
  p0_.type AS type_19,
  p0_.price_movement AS price_movement_20,
  p0_.quantity_movement AS quantity_movement_21,
  p0_.provider_order_id AS provider_order_id_22,
  p0_.paper_id AS paper_id_23
FROM
  provider_order_item p0_
  LEFT JOIN provider_order p1_ ON p0_.provider_order_id = p1_.id
  LEFT JOIN paper p2_ ON p0_.paper_id = p2_.id
WHERE
  p2_.id = ?
  AND (
    p1_.completed = 0
    OR p1_.delivered = 0
  )
  AND p0_.quantity_movement > 0
  AND p1_.archived = 0
  AND p0_.archived = 0
ORDER BY
  p0_.delivered_at ASC

SELECT p0_.id AS id_0, p0_.price_unity_updated AS price_unity_updated_1, p0_.completed AS completed_2, p0_.comment AS comment_3, p0_.delivery_edited AS delivery_edited_4, p0_.created_at AS created_at_5, p0_.archived AS archived_6, p0_.product_price AS product_price_7, p0_.price_difference AS price_difference_8, p0_.product_quantity AS product_quantity_9, p0_.quantity_difference AS quantity_difference_10, p0_.delivered AS delivered_11, p0_.delivered_at AS delivered_at_12, p0_.delivery_progress AS delivery_progress_13, p0_.product_count AS product_count_14, p0_.product_delivered_count AS product_delivered_count_15, p0_.price AS price_16, p0_.quantity AS quantity_17, p0_.price_unity AS price_unity_18, p0_.type AS type_19, p0_.price_movement AS price_movement_20, p0_.quantity_movement AS quantity_movement_21, p0_.provider_order_id AS provider_order_id_22, p0_.paper_id AS paper_id_23 FROM provider_order_item p0_ LEFT JOIN provider_order p1_ ON p0_.provider_order_id = p1_.id LEFT JOIN paper p2_ ON p0_.paper_id = p2_.id WHERE p2_.id = 1046 AND (p1_.completed = 0 OR p1_.delivered = 0) AND p0_.quantity_movement > 0 AND p1_.archived = 0 AND p0_.archived = 0 ORDER BY p0_.delivered_at ASC;

SELECT
  c0_.id AS id_0,
  c0_.price_ordered AS price_ordered_1,
  c0_.quantity_ordered AS quantity_ordered_2,
  c0_.production_at AS production_at_3,
  c0_.comment AS comment_4,
  c0_.detail AS detail_5,
  c0_.production_edited AS production_edited_6,
  c0_.created_at AS created_at_7,
  c0_.archived AS archived_8,
  c0_.type AS type_9,
  c0_.price_movement AS price_movement_10,
  c0_.quantity_movement AS quantity_movement_11,
  c0_.price AS price_12,
  c0_.quantity AS quantity_13,
  c0_.price_unity AS price_unity_14,
  c0_.paper_id AS paper_id_15,
  c0_.customer_order_id AS customer_order_id_16
FROM
  customer_order_item c0_
  LEFT JOIN customer_order c1_ ON c0_.customer_order_id = c1_.id
WHERE
  c0_.paper_id = ?
  AND c0_.quantity_movement < 0
  AND c1_.archived = 0
  AND c0_.archived = 0
ORDER BY
  c0_.production_at ASC