Symfony Profiler

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  lv_picking_tote l0_

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lv_picking_tote l0_;

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.id AS id_1
FROM
  lv_picking_tote l0_
ORDER BY
  l0_.id DESC
LIMIT
  20

SELECT DISTINCT l0_.id AS id_0, l0_.id AS id_1 FROM lv_picking_tote l0_ ORDER BY l0_.id DESC LIMIT 20;

SELECT
  l0_.id AS id_0,
  l0_.ean13 AS ean13_1,
  l0_.order_id AS order_id_2,
  l0_.picking_area_id AS picking_area_id_3,
  l0_.user_id AS user_id_4,
  l0_.label_printed AS label_printed_5,
  l0_.user_id AS user_id_6,
  l0_.order_id AS order_id_7,
  l0_.picking_area_id AS picking_area_id_8
FROM
  lv_picking_tote l0_
WHERE
  l0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  l0_.id DESC

SELECT l0_.id AS id_0, l0_.ean13 AS ean13_1, l0_.order_id AS order_id_2, l0_.picking_area_id AS picking_area_id_3, l0_.user_id AS user_id_4, l0_.label_printed AS label_printed_5, l0_.user_id AS user_id_6, l0_.order_id AS order_id_7, l0_.picking_area_id AS picking_area_id_8 FROM lv_picking_tote l0_ WHERE l0_.id IN (22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7) ORDER BY l0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.sort AS sort_4
FROM
  lv_picking_area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.sort AS sort_4 FROM lv_picking_area t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.email_address AS email_address_5,
  t0.roles AS roles_6,
  t0.password_new AS password_new_7,
  t0.token AS token_8,
  t0.is_active AS is_active_9,
  t0.salt AS salt_10
FROM
  sf_guard_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email_address AS email_address_5, t0.roles AS roles_6, t0.password_new AS password_new_7, t0.token AS token_8, t0.is_active AS is_active_9, t0.salt AS salt_10 FROM sf_guard_user t0 WHERE t0.id = 87;

SELECT
  t0.order_id AS order_id_1,
  t0.invoice_no AS invoice_no_2,
  t0.invoice_prefix AS invoice_prefix_3,
  t0.store_id AS store_id_4,
  t0.store_name AS store_name_5,
  t0.store_url AS store_url_6,
  t0.customer_id AS customer_id_7,
  t0.customer_group_id AS customer_group_id_8,
  t0.firstname AS firstname_9,
  t0.lastname AS lastname_10,
  t0.email AS email_11,
  t0.telephone AS telephone_12,
  t0.fax AS fax_13,
  t0.ust_id AS ust_id_14,
  t0.shipping_firstname AS shipping_firstname_15,
  t0.shipping_lastname AS shipping_lastname_16,
  t0.shipping_company AS shipping_company_17,
  t0.shipping_address_1 AS shipping_address_1_18,
  t0.shipping_address_2 AS shipping_address_2_19,
  t0.shipping_city AS shipping_city_20,
  t0.shipping_postcode AS shipping_postcode_21,
  t0.shipping_country AS shipping_country_22,
  t0.shipping_country_id AS shipping_country_id_23,
  t0.shipping_zone AS shipping_zone_24,
  t0.shipping_zone_id AS shipping_zone_id_25,
  t0.shipping_address_format AS shipping_address_format_26,
  t0.shipping_method AS shipping_method_27,
  t0.shipping_delivery AS shipping_delivery_28,
  t0.shipping_code AS shipping_code_29,
  t0.payment_firstname AS payment_firstname_30,
  t0.payment_lastname AS payment_lastname_31,
  t0.payment_company AS payment_company_32,
  t0.payment_address_1 AS payment_address_1_33,
  t0.payment_address_2 AS payment_address_2_34,
  t0.payment_city AS payment_city_35,
  t0.payment_postcode AS payment_postcode_36,
  t0.payment_country AS payment_country_37,
  t0.payment_country_id AS payment_country_id_38,
  t0.payment_zone AS payment_zone_39,
  t0.payment_zone_id AS payment_zone_id_40,
  t0.payment_address_format AS payment_address_format_41,
  t0.payment_method AS payment_method_42,
  t0.payment_code AS payment_code_43,
  t0.comment AS comment_44,
  t0.preisanpassung AS preisanpassung_45,
  t0.preisanpassung_text AS preisanpassung_text_46,
  t0.total AS total_47,
  t0.reward AS reward_48,
  t0.order_status_id AS order_status_id_49,
  t0.affiliate_id AS affiliate_id_50,
  t0.commission AS commission_51,
  t0.language_id AS language_id_52,
  t0.currency_id AS currency_id_53,
  t0.currency_code AS currency_code_54,
  t0.currency_value AS currency_value_55,
  t0.date_added AS date_added_56,
  t0.date_modified AS date_modified_57,
  t0.ip AS ip_58,
  t0.forwarded_ip AS forwarded_ip_59,
  t0.user_agent AS user_agent_60,
  t0.accept_language AS accept_language_61,
  t0.rechnungsdruck AS rechnungsdruck_62,
  t0.billbee_order_id AS billbee_order_id_63,
  t0.delayed_order_id AS delayed_order_id_64,
  t0.voided AS voided_65,
  t0.picking_area_id AS picking_area_id_66,
  t0.has_dropshipping AS has_dropshipping_67,
  t0.pick_comment AS pick_comment_68,
  t0.order_status_id AS order_status_id_69,
  t0.picking_area_id AS picking_area_id_70
FROM
  oc_order t0
WHERE
  t0.order_id = ?

SELECT t0.order_id AS order_id_1, t0.invoice_no AS invoice_no_2, t0.invoice_prefix AS invoice_prefix_3, t0.store_id AS store_id_4, t0.store_name AS store_name_5, t0.store_url AS store_url_6, t0.customer_id AS customer_id_7, t0.customer_group_id AS customer_group_id_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.email AS email_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.ust_id AS ust_id_14, t0.shipping_firstname AS shipping_firstname_15, t0.shipping_lastname AS shipping_lastname_16, t0.shipping_company AS shipping_company_17, t0.shipping_address_1 AS shipping_address_1_18, t0.shipping_address_2 AS shipping_address_2_19, t0.shipping_city AS shipping_city_20, t0.shipping_postcode AS shipping_postcode_21, t0.shipping_country AS shipping_country_22, t0.shipping_country_id AS shipping_country_id_23, t0.shipping_zone AS shipping_zone_24, t0.shipping_zone_id AS shipping_zone_id_25, t0.shipping_address_format AS shipping_address_format_26, t0.shipping_method AS shipping_method_27, t0.shipping_delivery AS shipping_delivery_28, t0.shipping_code AS shipping_code_29, t0.payment_firstname AS payment_firstname_30, t0.payment_lastname AS payment_lastname_31, t0.payment_company AS payment_company_32, t0.payment_address_1 AS payment_address_1_33, t0.payment_address_2 AS payment_address_2_34, t0.payment_city AS payment_city_35, t0.payment_postcode AS payment_postcode_36, t0.payment_country AS payment_country_37, t0.payment_country_id AS payment_country_id_38, t0.payment_zone AS payment_zone_39, t0.payment_zone_id AS payment_zone_id_40, t0.payment_address_format AS payment_address_format_41, t0.payment_method AS payment_method_42, t0.payment_code AS payment_code_43, t0.comment AS comment_44, t0.preisanpassung AS preisanpassung_45, t0.preisanpassung_text AS preisanpassung_text_46, t0.total AS total_47, t0.reward AS reward_48, t0.order_status_id AS order_status_id_49, t0.affiliate_id AS affiliate_id_50, t0.commission AS commission_51, t0.language_id AS language_id_52, t0.currency_id AS currency_id_53, t0.currency_code AS currency_code_54, t0.currency_value AS currency_value_55, t0.date_added AS date_added_56, t0.date_modified AS date_modified_57, t0.ip AS ip_58, t0.forwarded_ip AS forwarded_ip_59, t0.user_agent AS user_agent_60, t0.accept_language AS accept_language_61, t0.rechnungsdruck AS rechnungsdruck_62, t0.billbee_order_id AS billbee_order_id_63, t0.delayed_order_id AS delayed_order_id_64, t0.voided AS voided_65, t0.picking_area_id AS picking_area_id_66, t0.has_dropshipping AS has_dropshipping_67, t0.pick_comment AS pick_comment_68, t0.order_status_id AS order_status_id_69, t0.picking_area_id AS picking_area_id_70 FROM oc_order t0 WHERE t0.order_id = 1318164;