Symfony Profiler

SELECT 
  i0_.id AS id_0, 
  i0_.total_price AS total_price_1, 
  i0_.created_at AS created_at_2, 
  i0_.deleted_at AS deleted_at_3, 
  i0_.down_payment AS down_payment_4, 
  i0_.type AS type_5, 
  i0_.comment AS comment_6, 
  i0_.is_vat_intracom AS is_vat_intracom_7, 
  i0_.motif AS motif_8, 
  i0_.picture AS picture_9, 
  i0_.replacesInvoiceId AS replacesInvoiceId_10, 
  i1_.id AS id_11, 
  i1_.reference AS reference_12, 
  i1_.name AS name_13, 
  i1_.quantity AS quantity_14, 
  i1_.weight AS weight_15, 
  i1_.unit_price AS unit_price_16, 
  i1_.buy_price AS buy_price_17, 
  i1_.tax_price AS tax_price_18, 
  i1_.discount_price AS discount_price_19, 
  s2_.id AS id_20, 
  s2_.price AS price_21, 
  s2_.quantity AS quantity_22, 
  i0_.customer_id AS customer_id_23, 
  i0_.currency_id AS currency_id_24, 
  i0_.address_id AS address_id_25, 
  i0_.order_id AS order_id_26, 
  i1_.invoice_id AS invoice_id_27, 
  i1_.product_id AS product_id_28, 
  i1_.tax_id AS tax_id_29, 
  i1_.lot_id AS lot_id_30, 
  s2_.service_id AS service_id_31, 
  s2_.product_id AS product_id_32, 
  s2_.order_id AS order_id_33, 
  s2_.invoice_id AS invoice_id_34 
FROM 
  invoice i0_ 
  LEFT JOIN invoice_item i1_ ON i0_.id = i1_.invoice_id 
  LEFT JOIN service_to_item s2_ ON i0_.id = s2_.invoice_id 
WHERE 
  i0_.id = ?

SELECT i0_.id AS id_0, i0_.total_price AS total_price_1, i0_.created_at AS created_at_2, i0_.deleted_at AS deleted_at_3, i0_.down_payment AS down_payment_4, i0_.type AS type_5, i0_.comment AS comment_6, i0_.is_vat_intracom AS is_vat_intracom_7, i0_.motif AS motif_8, i0_.picture AS picture_9, i0_.replacesInvoiceId AS replacesInvoiceId_10, i1_.id AS id_11, i1_.reference AS reference_12, i1_.name AS name_13, i1_.quantity AS quantity_14, i1_.weight AS weight_15, i1_.unit_price AS unit_price_16, i1_.buy_price AS buy_price_17, i1_.tax_price AS tax_price_18, i1_.discount_price AS discount_price_19, s2_.id AS id_20, s2_.price AS price_21, s2_.quantity AS quantity_22, i0_.customer_id AS customer_id_23, i0_.currency_id AS currency_id_24, i0_.address_id AS address_id_25, i0_.order_id AS order_id_26, i1_.invoice_id AS invoice_id_27, i1_.product_id AS product_id_28, i1_.tax_id AS tax_id_29, i1_.lot_id AS lot_id_30, s2_.service_id AS service_id_31, s2_.product_id AS product_id_32, s2_.order_id AS order_id_33, s2_.invoice_id AS invoice_id_34 FROM invoice i0_ LEFT JOIN invoice_item i1_ ON i0_.id = i1_.invoice_id LEFT JOIN service_to_item s2_ ON i0_.id = s2_.invoice_id WHERE i0_.id = '5400';

SELECT 
  t0.id AS id_1, 
  t0.reference AS reference_2, 
  t0.status AS status_3, 
  t0.total_price AS total_price_4, 
  t0.rate_change AS rate_change_5, 
  t0.delivered_at AS delivered_at_6, 
  t0.delivery_number AS delivery_number_7, 
  t0.active AS active_8, 
  t0.created_at AS created_at_9, 
  t0.updated_at AS updated_at_10, 
  t0.deleted_at AS deleted_at_11, 
  t0.down_payment AS down_payment_12, 
  t0.marked_as_sent AS marked_as_sent_13, 
  t0.comment AS comment_14, 
  t0.warned AS warned_15, 
  t0.customer_id AS customer_id_16, 
  t0.currency_id AS currency_id_17, 
  t0.address_delivery_id AS address_delivery_id_18, 
  t0.address_invoice_id AS address_invoice_id_19, 
  t0.market_id AS market_id_20, 
  t0.promocode_id AS promocode_id_21, 
  t0.user_id AS user_id_22 
FROM 
  orders t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.status AS status_3, t0.total_price AS total_price_4, t0.rate_change AS rate_change_5, t0.delivered_at AS delivered_at_6, t0.delivery_number AS delivery_number_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.down_payment AS down_payment_12, t0.marked_as_sent AS marked_as_sent_13, t0.comment AS comment_14, t0.warned AS warned_15, t0.customer_id AS customer_id_16, t0.currency_id AS currency_id_17, t0.address_delivery_id AS address_delivery_id_18, t0.address_invoice_id AS address_invoice_id_19, t0.market_id AS market_id_20, t0.promocode_id AS promocode_id_21, t0.user_id AS user_id_22 FROM orders t0 WHERE t0.id = 5268;

SELECT 
  t0.id AS id_1, 
  t0.company AS company_2, 
  t0.lastname AS lastname_3, 
  t0.firstname AS firstname_4, 
  t0.address1 AS address1_5, 
  t0.address2 AS address2_6, 
  t0.postcode AS postcode_7, 
  t0.city AS city_8, 
  t0.other AS other_9, 
  t0.phone AS phone_10, 
  t0.mobile_phone AS mobile_phone_11, 
  t0.active AS active_12, 
  t0.is_default AS is_default_13, 
  t0.created_at AS created_at_14, 
  t0.updated_at AS updated_at_15, 
  t0.deleted_at AS deleted_at_16, 
  t0.country_id AS country_id_17, 
  t0.state_id AS state_id_18 
FROM 
  address t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.company AS company_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.address1 AS address1_5, t0.address2 AS address2_6, t0.postcode AS postcode_7, t0.city AS city_8, t0.other AS other_9, t0.phone AS phone_10, t0.mobile_phone AS mobile_phone_11, t0.active AS active_12, t0.is_default AS is_default_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.country_id AS country_id_17, t0.state_id AS state_id_18 FROM address t0 WHERE t0.id = 2429;

SELECT 
  t0.id AS id_1, 
  t0.iso_code AS iso_code_2, 
  t0.call_prefix AS call_prefix_3, 
  t0.active AS active_4, 
  t0.contains_states AS contains_states_5, 
  t0.need_zip_code AS need_zip_code_6, 
  t0.zip_code_format AS zip_code_format_7, 
  t0.currency_id AS currency_id_8, 
  t0.zone_id AS zone_id_9, 
  t0.langage_id AS langage_id_10 
FROM 
  country t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.iso_code AS iso_code_2, t0.call_prefix AS call_prefix_3, t0.active AS active_4, t0.contains_states AS contains_states_5, t0.need_zip_code AS need_zip_code_6, t0.zip_code_format AS zip_code_format_7, t0.currency_id AS currency_id_8, t0.zone_id AS zone_id_9, t0.langage_id AS langage_id_10 FROM country t0 WHERE t0.id = 8;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.active AS active_3, 
  t0.display_tax AS display_tax_4 
FROM 
  zone t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.display_tax AS display_tax_4 FROM zone t0 WHERE t0.id = 10;

SELECT 
  t0.id AS id_1, 
  t0.designation AS designation_2, 
  t0.quantity AS quantity_3, 
  t0.weight AS weight_4, 
  t0.buy_price AS buy_price_5, 
  t0.value AS value_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.deleted_at AS deleted_at_9, 
  t0.invoice_id AS invoice_id_10, 
  t0.deposit_id AS deposit_id_11, 
  t0.user_id AS user_id_12, 
  t0.status_lot_id AS status_lot_id_13 
FROM 
  lot t0 
WHERE 
  t0.invoice_id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2, t0.quantity AS quantity_3, t0.weight AS weight_4, t0.buy_price AS buy_price_5, t0.value AS value_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.invoice_id AS invoice_id_10, t0.deposit_id AS deposit_id_11, t0.user_id AS user_id_12, t0.status_lot_id AS status_lot_id_13 FROM lot t0 WHERE t0.invoice_id = 5400;

SELECT 
  t0.id AS id_1, 
  t0.username AS username_2, 
  t0.username_canonical AS username_canonical_3, 
  t0.firstname AS firstname_4, 
  t0.lastname AS lastname_5, 
  t0.email AS email_6, 
  t0.email_canonical AS email_canonical_7, 
  t0.salt AS salt_8, 
  t0.password AS password_9, 
  t0.enabled AS enabled_10, 
  t0.role AS role_11, 
  t0.type AS type_12, 
  t0.active AS active_13, 
  t0.created_at AS created_at_14, 
  t0.updated_at AS updated_at_15, 
  t0.deleted_at AS deleted_at_16, 
  t0.confirmationToken AS confirmationToken_17, 
  t0.passwordRequestedAt AS passwordRequestedAt_18, 
  t0.optinEmail AS optinEmail_19, 
  t0.anonymized AS anonymized_20, 
  t0.langage_id AS langage_id_21 
FROM 
  customer t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.email_canonical AS email_canonical_7, t0.salt AS salt_8, t0.password AS password_9, t0.enabled AS enabled_10, t0.role AS role_11, t0.type AS type_12, t0.active AS active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.confirmationToken AS confirmationToken_17, t0.passwordRequestedAt AS passwordRequestedAt_18, t0.optinEmail AS optinEmail_19, t0.anonymized AS anonymized_20, t0.langage_id AS langage_id_21 FROM customer t0 WHERE t0.id = 2388;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.created_at AS created_at_3, 
  t0.updated_at AS updated_at_4, 
  t0.deleted_at AS deleted_at_5, 
  t0.culture AS culture_6, 
  t0.country_id AS country_id_7, 
  t0.langage_id AS langage_id_8 
FROM 
  country_translation t0 
WHERE 
  t0.country_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.culture AS culture_6, t0.country_id AS country_id_7, t0.langage_id AS langage_id_8 FROM country_translation t0 WHERE t0.country_id = 8;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.code AS code_3, 
  t0.rate AS rate_4, 
  t0.created_at AS created_at_5, 
  t0.updated_at AS updated_at_6, 
  t0.deleted_at AS deleted_at_7 
FROM 
  currency t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.rate AS rate_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM currency t0 WHERE t0.id = 1;

SELECT 
  t0.id AS id_1, 
  t0.rate AS rate_2, 
  t0.sort_order AS sort_order_3, 
  t0.code AS code_4 
FROM 
  tax t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.rate AS rate_2, t0.sort_order AS sort_order_3, t0.code AS code_4 FROM tax t0 WHERE t0.id = 9;

SELECT 
  t0.id AS id_1, 
  t0.amount AS amount_2, 
  t0.created_at AS created_at_3, 
  t0.reference AS reference_4, 
  t0.operation AS operation_5, 
  t0.rate_change AS rate_change_6, 
  t0.order_id AS order_id_7, 
  t0.currency_id AS currency_id_8, 
  t0.type, 
  t0.bank_name AS bank_name_9 
FROM 
  payment t0 
WHERE 
  t0.order_id = ? 
  AND t0.type IN (
    'paypal', 'check', 'transfer', 'card', 
    'other', 'stripe'
  )

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.reference AS reference_4, t0.operation AS operation_5, t0.rate_change AS rate_change_6, t0.order_id AS order_id_7, t0.currency_id AS currency_id_8, t0.type, t0.bank_name AS bank_name_9 FROM payment t0 WHERE t0.order_id = 5268 AND t0.type IN ('paypal', 'check', 'transfer', 'card', 'other', 'stripe');