Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_login AS last_login_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.active AS active_8
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.last_login AS last_login_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.active AS active_8 FROM `user` t0 WHERE t0.id = 13;

SELECT
  c0_.id AS id_0,
  c0_.id_warehouse AS id_warehouse_1,
  c0_.firstname AS firstname_2,
  c0_.lastname AS lastname_3,
  c0_.phone AS phone_4,
  c0_.date_order AS date_order_5,
  c0_.payment AS payment_6,
  c0_.date_add AS date_add_7,
  c0_.sms1_send AS sms1_send_8,
  c0_.sms2_send AS sms2_send_9,
  c0_.paid AS paid_10,
  c0_.id_order AS id_order_11,
  c0_.email AS email_12,
  c0_.date_delivered AS date_delivered_13,
  c0_.total AS total_14,
  c0_.date_send AS date_send_15,
  c0_.date_recep AS date_recep_16,
  c0_.qty_product AS qty_product_17,
  c0_.cancel AS cancel_18,
  c0_.date_cancel AS date_cancel_19,
  c0_.id_package_shipping_bo AS id_package_shipping_bo_20,
  c0_.comment AS comment_21
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL
  AND c0_.date_recep IS NOT NULL
  AND c0_.date_cancel IS NULL

SELECT c0_.id AS id_0, c0_.id_warehouse AS id_warehouse_1, c0_.firstname AS firstname_2, c0_.lastname AS lastname_3, c0_.phone AS phone_4, c0_.date_order AS date_order_5, c0_.payment AS payment_6, c0_.date_add AS date_add_7, c0_.sms1_send AS sms1_send_8, c0_.sms2_send AS sms2_send_9, c0_.paid AS paid_10, c0_.id_order AS id_order_11, c0_.email AS email_12, c0_.date_delivered AS date_delivered_13, c0_.total AS total_14, c0_.date_send AS date_send_15, c0_.date_recep AS date_recep_16, c0_.qty_product AS qty_product_17, c0_.cancel AS cancel_18, c0_.date_cancel AS date_cancel_19, c0_.id_package_shipping_bo AS id_package_shipping_bo_20, c0_.comment AS comment_21 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 1 AND c0_.date_delivered IS NULL AND c0_.date_recep IS NOT NULL AND c0_.date_cancel IS NULL;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.phone AS phone_5,
  t0.date_order AS date_order_6,
  t0.payment AS payment_7,
  t0.date_add AS date_add_8,
  t0.sms1_send AS sms1_send_9,
  t0.sms2_send AS sms2_send_10,
  t0.paid AS paid_11,
  t0.id_order AS id_order_12,
  t0.email AS email_13,
  t0.date_delivered AS date_delivered_14,
  t0.total AS total_15,
  t0.date_send AS date_send_16,
  t0.date_recep AS date_recep_17,
  t0.qty_product AS qty_product_18,
  t0.cancel AS cancel_19,
  t0.date_cancel AS date_cancel_20,
  t0.id_package_shipping_bo AS id_package_shipping_bo_21,
  t0.comment AS comment_22
FROM
  c_and_c_order_history t0
WHERE
  t0.id_warehouse = ?
  AND t0.date_recep IS NULL

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.date_order AS date_order_6, t0.payment AS payment_7, t0.date_add AS date_add_8, t0.sms1_send AS sms1_send_9, t0.sms2_send AS sms2_send_10, t0.paid AS paid_11, t0.id_order AS id_order_12, t0.email AS email_13, t0.date_delivered AS date_delivered_14, t0.total AS total_15, t0.date_send AS date_send_16, t0.date_recep AS date_recep_17, t0.qty_product AS qty_product_18, t0.cancel AS cancel_19, t0.date_cancel AS date_cancel_20, t0.id_package_shipping_bo AS id_package_shipping_bo_21, t0.comment AS comment_22 FROM c_and_c_order_history t0 WHERE t0.id_warehouse = 1 AND t0.date_recep IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 1 AND c0_.date_delivered IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.paid = ?

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 1 AND c0_.paid = 0;

SELECT
  c0_.id AS id_0,
  c0_.id_warehouse AS id_warehouse_1,
  c0_.firstname AS firstname_2,
  c0_.lastname AS lastname_3,
  c0_.phone AS phone_4,
  c0_.date_order AS date_order_5,
  c0_.payment AS payment_6,
  c0_.date_add AS date_add_7,
  c0_.sms1_send AS sms1_send_8,
  c0_.sms2_send AS sms2_send_9,
  c0_.paid AS paid_10,
  c0_.id_order AS id_order_11,
  c0_.email AS email_12,
  c0_.date_delivered AS date_delivered_13,
  c0_.total AS total_14,
  c0_.date_send AS date_send_15,
  c0_.date_recep AS date_recep_16,
  c0_.qty_product AS qty_product_17,
  c0_.cancel AS cancel_18,
  c0_.date_cancel AS date_cancel_19,
  c0_.id_package_shipping_bo AS id_package_shipping_bo_20,
  c0_.comment AS comment_21
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL
  AND c0_.date_recep IS NOT NULL
  AND c0_.date_cancel IS NULL

SELECT c0_.id AS id_0, c0_.id_warehouse AS id_warehouse_1, c0_.firstname AS firstname_2, c0_.lastname AS lastname_3, c0_.phone AS phone_4, c0_.date_order AS date_order_5, c0_.payment AS payment_6, c0_.date_add AS date_add_7, c0_.sms1_send AS sms1_send_8, c0_.sms2_send AS sms2_send_9, c0_.paid AS paid_10, c0_.id_order AS id_order_11, c0_.email AS email_12, c0_.date_delivered AS date_delivered_13, c0_.total AS total_14, c0_.date_send AS date_send_15, c0_.date_recep AS date_recep_16, c0_.qty_product AS qty_product_17, c0_.cancel AS cancel_18, c0_.date_cancel AS date_cancel_19, c0_.id_package_shipping_bo AS id_package_shipping_bo_20, c0_.comment AS comment_21 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 2 AND c0_.date_delivered IS NULL AND c0_.date_recep IS NOT NULL AND c0_.date_cancel IS NULL;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.phone AS phone_5,
  t0.date_order AS date_order_6,
  t0.payment AS payment_7,
  t0.date_add AS date_add_8,
  t0.sms1_send AS sms1_send_9,
  t0.sms2_send AS sms2_send_10,
  t0.paid AS paid_11,
  t0.id_order AS id_order_12,
  t0.email AS email_13,
  t0.date_delivered AS date_delivered_14,
  t0.total AS total_15,
  t0.date_send AS date_send_16,
  t0.date_recep AS date_recep_17,
  t0.qty_product AS qty_product_18,
  t0.cancel AS cancel_19,
  t0.date_cancel AS date_cancel_20,
  t0.id_package_shipping_bo AS id_package_shipping_bo_21,
  t0.comment AS comment_22
FROM
  c_and_c_order_history t0
WHERE
  t0.id_warehouse = ?
  AND t0.date_recep IS NULL

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.date_order AS date_order_6, t0.payment AS payment_7, t0.date_add AS date_add_8, t0.sms1_send AS sms1_send_9, t0.sms2_send AS sms2_send_10, t0.paid AS paid_11, t0.id_order AS id_order_12, t0.email AS email_13, t0.date_delivered AS date_delivered_14, t0.total AS total_15, t0.date_send AS date_send_16, t0.date_recep AS date_recep_17, t0.qty_product AS qty_product_18, t0.cancel AS cancel_19, t0.date_cancel AS date_cancel_20, t0.id_package_shipping_bo AS id_package_shipping_bo_21, t0.comment AS comment_22 FROM c_and_c_order_history t0 WHERE t0.id_warehouse = 2 AND t0.date_recep IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 2 AND c0_.date_delivered IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.paid = ?

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 2 AND c0_.paid = 0;

SELECT
  c0_.id AS id_0,
  c0_.id_warehouse AS id_warehouse_1,
  c0_.firstname AS firstname_2,
  c0_.lastname AS lastname_3,
  c0_.phone AS phone_4,
  c0_.date_order AS date_order_5,
  c0_.payment AS payment_6,
  c0_.date_add AS date_add_7,
  c0_.sms1_send AS sms1_send_8,
  c0_.sms2_send AS sms2_send_9,
  c0_.paid AS paid_10,
  c0_.id_order AS id_order_11,
  c0_.email AS email_12,
  c0_.date_delivered AS date_delivered_13,
  c0_.total AS total_14,
  c0_.date_send AS date_send_15,
  c0_.date_recep AS date_recep_16,
  c0_.qty_product AS qty_product_17,
  c0_.cancel AS cancel_18,
  c0_.date_cancel AS date_cancel_19,
  c0_.id_package_shipping_bo AS id_package_shipping_bo_20,
  c0_.comment AS comment_21
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL
  AND c0_.date_recep IS NOT NULL
  AND c0_.date_cancel IS NULL

SELECT c0_.id AS id_0, c0_.id_warehouse AS id_warehouse_1, c0_.firstname AS firstname_2, c0_.lastname AS lastname_3, c0_.phone AS phone_4, c0_.date_order AS date_order_5, c0_.payment AS payment_6, c0_.date_add AS date_add_7, c0_.sms1_send AS sms1_send_8, c0_.sms2_send AS sms2_send_9, c0_.paid AS paid_10, c0_.id_order AS id_order_11, c0_.email AS email_12, c0_.date_delivered AS date_delivered_13, c0_.total AS total_14, c0_.date_send AS date_send_15, c0_.date_recep AS date_recep_16, c0_.qty_product AS qty_product_17, c0_.cancel AS cancel_18, c0_.date_cancel AS date_cancel_19, c0_.id_package_shipping_bo AS id_package_shipping_bo_20, c0_.comment AS comment_21 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 3 AND c0_.date_delivered IS NULL AND c0_.date_recep IS NOT NULL AND c0_.date_cancel IS NULL;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.phone AS phone_5,
  t0.date_order AS date_order_6,
  t0.payment AS payment_7,
  t0.date_add AS date_add_8,
  t0.sms1_send AS sms1_send_9,
  t0.sms2_send AS sms2_send_10,
  t0.paid AS paid_11,
  t0.id_order AS id_order_12,
  t0.email AS email_13,
  t0.date_delivered AS date_delivered_14,
  t0.total AS total_15,
  t0.date_send AS date_send_16,
  t0.date_recep AS date_recep_17,
  t0.qty_product AS qty_product_18,
  t0.cancel AS cancel_19,
  t0.date_cancel AS date_cancel_20,
  t0.id_package_shipping_bo AS id_package_shipping_bo_21,
  t0.comment AS comment_22
FROM
  c_and_c_order_history t0
WHERE
  t0.id_warehouse = ?
  AND t0.date_recep IS NULL

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.date_order AS date_order_6, t0.payment AS payment_7, t0.date_add AS date_add_8, t0.sms1_send AS sms1_send_9, t0.sms2_send AS sms2_send_10, t0.paid AS paid_11, t0.id_order AS id_order_12, t0.email AS email_13, t0.date_delivered AS date_delivered_14, t0.total AS total_15, t0.date_send AS date_send_16, t0.date_recep AS date_recep_17, t0.qty_product AS qty_product_18, t0.cancel AS cancel_19, t0.date_cancel AS date_cancel_20, t0.id_package_shipping_bo AS id_package_shipping_bo_21, t0.comment AS comment_22 FROM c_and_c_order_history t0 WHERE t0.id_warehouse = 3 AND t0.date_recep IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 3 AND c0_.date_delivered IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.paid = ?

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 3 AND c0_.paid = 0;

SELECT
  c0_.id AS id_0,
  c0_.id_warehouse AS id_warehouse_1,
  c0_.firstname AS firstname_2,
  c0_.lastname AS lastname_3,
  c0_.phone AS phone_4,
  c0_.date_order AS date_order_5,
  c0_.payment AS payment_6,
  c0_.date_add AS date_add_7,
  c0_.sms1_send AS sms1_send_8,
  c0_.sms2_send AS sms2_send_9,
  c0_.paid AS paid_10,
  c0_.id_order AS id_order_11,
  c0_.email AS email_12,
  c0_.date_delivered AS date_delivered_13,
  c0_.total AS total_14,
  c0_.date_send AS date_send_15,
  c0_.date_recep AS date_recep_16,
  c0_.qty_product AS qty_product_17,
  c0_.cancel AS cancel_18,
  c0_.date_cancel AS date_cancel_19,
  c0_.id_package_shipping_bo AS id_package_shipping_bo_20,
  c0_.comment AS comment_21
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL
  AND c0_.date_recep IS NOT NULL
  AND c0_.date_cancel IS NULL

SELECT c0_.id AS id_0, c0_.id_warehouse AS id_warehouse_1, c0_.firstname AS firstname_2, c0_.lastname AS lastname_3, c0_.phone AS phone_4, c0_.date_order AS date_order_5, c0_.payment AS payment_6, c0_.date_add AS date_add_7, c0_.sms1_send AS sms1_send_8, c0_.sms2_send AS sms2_send_9, c0_.paid AS paid_10, c0_.id_order AS id_order_11, c0_.email AS email_12, c0_.date_delivered AS date_delivered_13, c0_.total AS total_14, c0_.date_send AS date_send_15, c0_.date_recep AS date_recep_16, c0_.qty_product AS qty_product_17, c0_.cancel AS cancel_18, c0_.date_cancel AS date_cancel_19, c0_.id_package_shipping_bo AS id_package_shipping_bo_20, c0_.comment AS comment_21 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 4 AND c0_.date_delivered IS NULL AND c0_.date_recep IS NOT NULL AND c0_.date_cancel IS NULL;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.phone AS phone_5,
  t0.date_order AS date_order_6,
  t0.payment AS payment_7,
  t0.date_add AS date_add_8,
  t0.sms1_send AS sms1_send_9,
  t0.sms2_send AS sms2_send_10,
  t0.paid AS paid_11,
  t0.id_order AS id_order_12,
  t0.email AS email_13,
  t0.date_delivered AS date_delivered_14,
  t0.total AS total_15,
  t0.date_send AS date_send_16,
  t0.date_recep AS date_recep_17,
  t0.qty_product AS qty_product_18,
  t0.cancel AS cancel_19,
  t0.date_cancel AS date_cancel_20,
  t0.id_package_shipping_bo AS id_package_shipping_bo_21,
  t0.comment AS comment_22
FROM
  c_and_c_order_history t0
WHERE
  t0.id_warehouse = ?
  AND t0.date_recep IS NULL

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.date_order AS date_order_6, t0.payment AS payment_7, t0.date_add AS date_add_8, t0.sms1_send AS sms1_send_9, t0.sms2_send AS sms2_send_10, t0.paid AS paid_11, t0.id_order AS id_order_12, t0.email AS email_13, t0.date_delivered AS date_delivered_14, t0.total AS total_15, t0.date_send AS date_send_16, t0.date_recep AS date_recep_17, t0.qty_product AS qty_product_18, t0.cancel AS cancel_19, t0.date_cancel AS date_cancel_20, t0.id_package_shipping_bo AS id_package_shipping_bo_21, t0.comment AS comment_22 FROM c_and_c_order_history t0 WHERE t0.id_warehouse = 4 AND t0.date_recep IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 4 AND c0_.date_delivered IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.paid = ?

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 4 AND c0_.paid = 0;

SELECT
  c0_.id AS id_0,
  c0_.id_warehouse AS id_warehouse_1,
  c0_.firstname AS firstname_2,
  c0_.lastname AS lastname_3,
  c0_.phone AS phone_4,
  c0_.date_order AS date_order_5,
  c0_.payment AS payment_6,
  c0_.date_add AS date_add_7,
  c0_.sms1_send AS sms1_send_8,
  c0_.sms2_send AS sms2_send_9,
  c0_.paid AS paid_10,
  c0_.id_order AS id_order_11,
  c0_.email AS email_12,
  c0_.date_delivered AS date_delivered_13,
  c0_.total AS total_14,
  c0_.date_send AS date_send_15,
  c0_.date_recep AS date_recep_16,
  c0_.qty_product AS qty_product_17,
  c0_.cancel AS cancel_18,
  c0_.date_cancel AS date_cancel_19,
  c0_.id_package_shipping_bo AS id_package_shipping_bo_20,
  c0_.comment AS comment_21
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL
  AND c0_.date_recep IS NOT NULL
  AND c0_.date_cancel IS NULL

SELECT c0_.id AS id_0, c0_.id_warehouse AS id_warehouse_1, c0_.firstname AS firstname_2, c0_.lastname AS lastname_3, c0_.phone AS phone_4, c0_.date_order AS date_order_5, c0_.payment AS payment_6, c0_.date_add AS date_add_7, c0_.sms1_send AS sms1_send_8, c0_.sms2_send AS sms2_send_9, c0_.paid AS paid_10, c0_.id_order AS id_order_11, c0_.email AS email_12, c0_.date_delivered AS date_delivered_13, c0_.total AS total_14, c0_.date_send AS date_send_15, c0_.date_recep AS date_recep_16, c0_.qty_product AS qty_product_17, c0_.cancel AS cancel_18, c0_.date_cancel AS date_cancel_19, c0_.id_package_shipping_bo AS id_package_shipping_bo_20, c0_.comment AS comment_21 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 5 AND c0_.date_delivered IS NULL AND c0_.date_recep IS NOT NULL AND c0_.date_cancel IS NULL;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.phone AS phone_5,
  t0.date_order AS date_order_6,
  t0.payment AS payment_7,
  t0.date_add AS date_add_8,
  t0.sms1_send AS sms1_send_9,
  t0.sms2_send AS sms2_send_10,
  t0.paid AS paid_11,
  t0.id_order AS id_order_12,
  t0.email AS email_13,
  t0.date_delivered AS date_delivered_14,
  t0.total AS total_15,
  t0.date_send AS date_send_16,
  t0.date_recep AS date_recep_17,
  t0.qty_product AS qty_product_18,
  t0.cancel AS cancel_19,
  t0.date_cancel AS date_cancel_20,
  t0.id_package_shipping_bo AS id_package_shipping_bo_21,
  t0.comment AS comment_22
FROM
  c_and_c_order_history t0
WHERE
  t0.id_warehouse = ?
  AND t0.date_recep IS NULL

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.date_order AS date_order_6, t0.payment AS payment_7, t0.date_add AS date_add_8, t0.sms1_send AS sms1_send_9, t0.sms2_send AS sms2_send_10, t0.paid AS paid_11, t0.id_order AS id_order_12, t0.email AS email_13, t0.date_delivered AS date_delivered_14, t0.total AS total_15, t0.date_send AS date_send_16, t0.date_recep AS date_recep_17, t0.qty_product AS qty_product_18, t0.cancel AS cancel_19, t0.date_cancel AS date_cancel_20, t0.id_package_shipping_bo AS id_package_shipping_bo_21, t0.comment AS comment_22 FROM c_and_c_order_history t0 WHERE t0.id_warehouse = 5 AND t0.date_recep IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 5 AND c0_.date_delivered IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.paid = ?

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 5 AND c0_.paid = 0;

SELECT
  c0_.id AS id_0,
  c0_.id_warehouse AS id_warehouse_1,
  c0_.firstname AS firstname_2,
  c0_.lastname AS lastname_3,
  c0_.phone AS phone_4,
  c0_.date_order AS date_order_5,
  c0_.payment AS payment_6,
  c0_.date_add AS date_add_7,
  c0_.sms1_send AS sms1_send_8,
  c0_.sms2_send AS sms2_send_9,
  c0_.paid AS paid_10,
  c0_.id_order AS id_order_11,
  c0_.email AS email_12,
  c0_.date_delivered AS date_delivered_13,
  c0_.total AS total_14,
  c0_.date_send AS date_send_15,
  c0_.date_recep AS date_recep_16,
  c0_.qty_product AS qty_product_17,
  c0_.cancel AS cancel_18,
  c0_.date_cancel AS date_cancel_19,
  c0_.id_package_shipping_bo AS id_package_shipping_bo_20,
  c0_.comment AS comment_21
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL
  AND c0_.date_recep IS NOT NULL
  AND c0_.date_cancel IS NULL

SELECT c0_.id AS id_0, c0_.id_warehouse AS id_warehouse_1, c0_.firstname AS firstname_2, c0_.lastname AS lastname_3, c0_.phone AS phone_4, c0_.date_order AS date_order_5, c0_.payment AS payment_6, c0_.date_add AS date_add_7, c0_.sms1_send AS sms1_send_8, c0_.sms2_send AS sms2_send_9, c0_.paid AS paid_10, c0_.id_order AS id_order_11, c0_.email AS email_12, c0_.date_delivered AS date_delivered_13, c0_.total AS total_14, c0_.date_send AS date_send_15, c0_.date_recep AS date_recep_16, c0_.qty_product AS qty_product_17, c0_.cancel AS cancel_18, c0_.date_cancel AS date_cancel_19, c0_.id_package_shipping_bo AS id_package_shipping_bo_20, c0_.comment AS comment_21 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 6 AND c0_.date_delivered IS NULL AND c0_.date_recep IS NOT NULL AND c0_.date_cancel IS NULL;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.phone AS phone_5,
  t0.date_order AS date_order_6,
  t0.payment AS payment_7,
  t0.date_add AS date_add_8,
  t0.sms1_send AS sms1_send_9,
  t0.sms2_send AS sms2_send_10,
  t0.paid AS paid_11,
  t0.id_order AS id_order_12,
  t0.email AS email_13,
  t0.date_delivered AS date_delivered_14,
  t0.total AS total_15,
  t0.date_send AS date_send_16,
  t0.date_recep AS date_recep_17,
  t0.qty_product AS qty_product_18,
  t0.cancel AS cancel_19,
  t0.date_cancel AS date_cancel_20,
  t0.id_package_shipping_bo AS id_package_shipping_bo_21,
  t0.comment AS comment_22
FROM
  c_and_c_order_history t0
WHERE
  t0.id_warehouse = ?
  AND t0.date_recep IS NULL

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.date_order AS date_order_6, t0.payment AS payment_7, t0.date_add AS date_add_8, t0.sms1_send AS sms1_send_9, t0.sms2_send AS sms2_send_10, t0.paid AS paid_11, t0.id_order AS id_order_12, t0.email AS email_13, t0.date_delivered AS date_delivered_14, t0.total AS total_15, t0.date_send AS date_send_16, t0.date_recep AS date_recep_17, t0.qty_product AS qty_product_18, t0.cancel AS cancel_19, t0.date_cancel AS date_cancel_20, t0.id_package_shipping_bo AS id_package_shipping_bo_21, t0.comment AS comment_22 FROM c_and_c_order_history t0 WHERE t0.id_warehouse = 6 AND t0.date_recep IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 6 AND c0_.date_delivered IS NULL;

SELECT
  SUM(c0_.total) AS sclr_0
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.paid = ?

SELECT SUM(c0_.total) AS sclr_0 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 6 AND c0_.paid = 0;

SELECT
  c0_.id AS id_0,
  c0_.id_warehouse AS id_warehouse_1,
  c0_.firstname AS firstname_2,
  c0_.lastname AS lastname_3,
  c0_.phone AS phone_4,
  c0_.date_order AS date_order_5,
  c0_.payment AS payment_6,
  c0_.date_add AS date_add_7,
  c0_.sms1_send AS sms1_send_8,
  c0_.sms2_send AS sms2_send_9,
  c0_.paid AS paid_10,
  c0_.id_order AS id_order_11,
  c0_.email AS email_12,
  c0_.date_delivered AS date_delivered_13,
  c0_.total AS total_14,
  c0_.date_send AS date_send_15,
  c0_.date_recep AS date_recep_16,
  c0_.qty_product AS qty_product_17,
  c0_.cancel AS cancel_18,
  c0_.date_cancel AS date_cancel_19,
  c0_.id_package_shipping_bo AS id_package_shipping_bo_20,
  c0_.comment AS comment_21
FROM
  c_and_c_order_history c0_
WHERE
  c0_.id_warehouse = ?
  AND c0_.date_delivered IS NULL
  AND c0_.date_recep IS NOT NULL
  AND c0_.date_cancel IS NULL

SELECT c0_.id AS id_0, c0_.id_warehouse AS id_warehouse_1, c0_.firstname AS firstname_2, c0_.lastname AS lastname_3, c0_.phone AS phone_4, c0_.date_order AS date_order_5, c0_.payment AS payment_6, c0_.date_add AS date_add_7, c0_.sms1_send AS sms1_send_8, c0_.sms2_send AS sms2_send_9, c0_.paid AS paid_10, c0_.id_order AS id_order_11, c0_.email AS email_12, c0_.date_delivered AS date_delivered_13, c0_.total AS total_14, c0_.date_send AS date_send_15, c0_.date_recep AS date_recep_16, c0_.qty_product AS qty_product_17, c0_.cancel AS cancel_18, c0_.date_cancel AS date_cancel_19, c0_.id_package_shipping_bo AS id_package_shipping_bo_20, c0_.comment AS comment_21 FROM c_and_c_order_history c0_ WHERE c0_.id_warehouse = 9 AND c0_.date_delivered IS NULL AND c0_.date_recep IS NOT NULL AND c0_.date_cancel IS NULL;