Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.field_type AS field_type_5,
  t0.title AS title_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = 'MODULE_SETTING' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.total AS total_2,
  t0.shipping_method AS shipping_method_3,
  t0.status AS status_4,
  t0.waiting_status AS waiting_status_5,
  t0.cancel_motif AS cancel_motif_6,
  t0.shipping_price AS shipping_price_7,
  t0.internal_reference AS internal_reference_8,
  t0.comment AS comment_9,
  t0.is_managed_by_customer AS is_managed_by_customer_10,
  t0.fees_order AS fees_order_11,
  t0.extra_cb_payment AS extra_cb_payment_12,
  t0.total_bonus_used AS total_bonus_used_13,
  t0.not_billable AS not_billable_14,
  t0.otherinformations AS otherinformations_15,
  t0.old_id AS old_id_16,
  t0.category_values AS category_values_17,
  t0.fees_category_values AS fees_category_values_18,
  t0.custom_question AS custom_question_19,
  t0.order_rate AS order_rate_20,
  t0.is_trip AS is_trip_21,
  t0.order_extra_data AS order_extra_data_22,
  t0.is_express_delivery AS is_express_delivery_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.bank_return_id AS bank_return_id_26,
  t0.user_id AS user_id_27,
  t0.saleorder_grouped_id AS saleorder_grouped_id_28,
  t0.shipping_address_id AS shipping_address_id_29,
  t0.billing_address_id AS billing_address_id_30,
  t0.cart_id AS cart_id_31,
  t0.invoice_id AS invoice_id_32
FROM
  sale_order t0
WHERE
  t0.status IN (?, ?, ?, ?)
  AND t0.is_managed_by_customer = ?

SELECT t0.id AS id_1, t0.total AS total_2, t0.shipping_method AS shipping_method_3, t0.status AS status_4, t0.waiting_status AS waiting_status_5, t0.cancel_motif AS cancel_motif_6, t0.shipping_price AS shipping_price_7, t0.internal_reference AS internal_reference_8, t0.comment AS comment_9, t0.is_managed_by_customer AS is_managed_by_customer_10, t0.fees_order AS fees_order_11, t0.extra_cb_payment AS extra_cb_payment_12, t0.total_bonus_used AS total_bonus_used_13, t0.not_billable AS not_billable_14, t0.otherinformations AS otherinformations_15, t0.old_id AS old_id_16, t0.category_values AS category_values_17, t0.fees_category_values AS fees_category_values_18, t0.custom_question AS custom_question_19, t0.order_rate AS order_rate_20, t0.is_trip AS is_trip_21, t0.order_extra_data AS order_extra_data_22, t0.is_express_delivery AS is_express_delivery_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.bank_return_id AS bank_return_id_26, t0.user_id AS user_id_27, t0.saleorder_grouped_id AS saleorder_grouped_id_28, t0.shipping_address_id AS shipping_address_id_29, t0.billing_address_id AS billing_address_id_30, t0.cart_id AS cart_id_31, t0.invoice_id AS invoice_id_32 FROM sale_order t0 WHERE t0.status IN ('pending_not_confirmed', 'pending_canceled', 'pending_processing', 'pending_group') AND t0.is_managed_by_customer = 0;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.quantity AS quantity_3,
  t0.quantity_no_batch AS quantity_no_batch_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.gamme AS gamme_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.unit_point AS unit_point_12,
  t0.image_url AS image_url_13,
  t0.image_thumbnail_url AS image_thumbnail_url_14,
  t0.taxable_amount AS taxable_amount_15,
  t0.category_values AS category_values_16,
  t0.total_chosen_category_values AS total_chosen_category_values_17,
  t0.wish_date_evasion AS wish_date_evasion_18,
  t0.weight AS weight_19,
  t0.is_refundable AS is_refundable_20,
  t0.is_replaced AS is_replaced_21,
  t0.bo_id AS bo_id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.order_id AS order_id_25,
  t26.id AS id_27,
  t26.bo_id AS bo_id_28,
  t26.sale_order_shipment_id AS sale_order_shipment_id_29,
  t26.sale_order_item_id AS sale_order_item_id_30,
  t0.replace_item_id AS replace_item_id_31
FROM
  sale_order_item t0
  LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = 3;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.quantity AS quantity_3,
  t0.quantity_no_batch AS quantity_no_batch_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.gamme AS gamme_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.unit_point AS unit_point_12,
  t0.image_url AS image_url_13,
  t0.image_thumbnail_url AS image_thumbnail_url_14,
  t0.taxable_amount AS taxable_amount_15,
  t0.category_values AS category_values_16,
  t0.total_chosen_category_values AS total_chosen_category_values_17,
  t0.wish_date_evasion AS wish_date_evasion_18,
  t0.weight AS weight_19,
  t0.is_refundable AS is_refundable_20,
  t0.is_replaced AS is_replaced_21,
  t0.bo_id AS bo_id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.order_id AS order_id_25,
  t26.id AS id_27,
  t26.bo_id AS bo_id_28,
  t26.sale_order_shipment_id AS sale_order_shipment_id_29,
  t26.sale_order_item_id AS sale_order_item_id_30,
  t0.replace_item_id AS replace_item_id_31
FROM
  sale_order_item t0
  LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = 4;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.quantity AS quantity_3,
  t0.quantity_no_batch AS quantity_no_batch_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.gamme AS gamme_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.unit_point AS unit_point_12,
  t0.image_url AS image_url_13,
  t0.image_thumbnail_url AS image_thumbnail_url_14,
  t0.taxable_amount AS taxable_amount_15,
  t0.category_values AS category_values_16,
  t0.total_chosen_category_values AS total_chosen_category_values_17,
  t0.wish_date_evasion AS wish_date_evasion_18,
  t0.weight AS weight_19,
  t0.is_refundable AS is_refundable_20,
  t0.is_replaced AS is_replaced_21,
  t0.bo_id AS bo_id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.order_id AS order_id_25,
  t26.id AS id_27,
  t26.bo_id AS bo_id_28,
  t26.sale_order_shipment_id AS sale_order_shipment_id_29,
  t26.sale_order_item_id AS sale_order_item_id_30,
  t0.replace_item_id AS replace_item_id_31
FROM
  sale_order_item t0
  LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = 5;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.quantity AS quantity_3,
  t0.quantity_no_batch AS quantity_no_batch_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.gamme AS gamme_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.unit_point AS unit_point_12,
  t0.image_url AS image_url_13,
  t0.image_thumbnail_url AS image_thumbnail_url_14,
  t0.taxable_amount AS taxable_amount_15,
  t0.category_values AS category_values_16,
  t0.total_chosen_category_values AS total_chosen_category_values_17,
  t0.wish_date_evasion AS wish_date_evasion_18,
  t0.weight AS weight_19,
  t0.is_refundable AS is_refundable_20,
  t0.is_replaced AS is_replaced_21,
  t0.bo_id AS bo_id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.order_id AS order_id_25,
  t26.id AS id_27,
  t26.bo_id AS bo_id_28,
  t26.sale_order_shipment_id AS sale_order_shipment_id_29,
  t26.sale_order_item_id AS sale_order_item_id_30,
  t0.replace_item_id AS replace_item_id_31
FROM
  sale_order_item t0
  LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = 6;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.quantity AS quantity_3,
  t0.quantity_no_batch AS quantity_no_batch_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.gamme AS gamme_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.unit_point AS unit_point_12,
  t0.image_url AS image_url_13,
  t0.image_thumbnail_url AS image_thumbnail_url_14,
  t0.taxable_amount AS taxable_amount_15,
  t0.category_values AS category_values_16,
  t0.total_chosen_category_values AS total_chosen_category_values_17,
  t0.wish_date_evasion AS wish_date_evasion_18,
  t0.weight AS weight_19,
  t0.is_refundable AS is_refundable_20,
  t0.is_replaced AS is_replaced_21,
  t0.bo_id AS bo_id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.order_id AS order_id_25,
  t26.id AS id_27,
  t26.bo_id AS bo_id_28,
  t26.sale_order_shipment_id AS sale_order_shipment_id_29,
  t26.sale_order_item_id AS sale_order_item_id_30,
  t0.replace_item_id AS replace_item_id_31
FROM
  sale_order_item t0
  LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = 7;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.quantity AS quantity_3,
  t0.quantity_no_batch AS quantity_no_batch_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.gamme AS gamme_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.unit_point AS unit_point_12,
  t0.image_url AS image_url_13,
  t0.image_thumbnail_url AS image_thumbnail_url_14,
  t0.taxable_amount AS taxable_amount_15,
  t0.category_values AS category_values_16,
  t0.total_chosen_category_values AS total_chosen_category_values_17,
  t0.wish_date_evasion AS wish_date_evasion_18,
  t0.weight AS weight_19,
  t0.is_refundable AS is_refundable_20,
  t0.is_replaced AS is_replaced_21,
  t0.bo_id AS bo_id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.order_id AS order_id_25,
  t26.id AS id_27,
  t26.bo_id AS bo_id_28,
  t26.sale_order_shipment_id AS sale_order_shipment_id_29,
  t26.sale_order_item_id AS sale_order_item_id_30,
  t0.replace_item_id AS replace_item_id_31
FROM
  sale_order_item t0
  LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.field_type AS field_type_5,
  t0.title AS title_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = 'SHOP_ORDER_VALIDATION' LIMIT 1;