Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.qty AS qty_3,
  t0.price AS price_4,
  t0.sku AS sku_5,
  t0.option_price AS option_price_6,
  t0.attribute_price AS attribute_price_7,
  t0.order_id AS order_id_8,
  t0.stock_id AS stock_id_9
FROM
  cart t0
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = 406;

SELECT
  t0.id AS id_1,
  t0.imei AS imei_2,
  t0.tracking AS tracking_3,
  t0.sync AS sync_4,
  t0.date AS date_5,
  t0.order_id AS order_id_6,
  t0.product_id AS product_id_7,
  t0.shop_id AS shop_id_8,
  t0.cart_id AS cart_id_9
FROM
  imei t0
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = 406;

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.status_id <> ?
  AND o0_.active = ?
  AND o0_.shop_id = ?

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id <> 10 AND o0_.active = 1 AND o0_.shop_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country AS country_3,
  t0.wtt_id AS wtt_id_4,
  t0.wtt_name AS wtt_name_5,
  t0.logo AS logo_6,
  t0.config AS config_7,
  t0.apikey AS apikey_8,
  t0.login_hash AS login_hash_9,
  t0.channel AS channel_10,
  t0.mail_copy AS mail_copy_11,
  t0.active AS active_12
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.wtt_id AS wtt_id_4, t0.wtt_name AS wtt_name_5, t0.logo AS logo_6, t0.config AS config_7, t0.apikey AS apikey_8, t0.login_hash AS login_hash_9, t0.channel AS channel_10, t0.mail_copy AS mail_copy_11, t0.active AS active_12 FROM shop t0 WHERE t0.id = '7';

SELECT
  o0_.id AS id_0,
  o0_.reference AS reference_1,
  o0_.coupon AS coupon_2,
  o0_.custom_reference AS custom_reference_3,
  o0_.confirm AS confirm_4,
  o0_.accept_terms AS accept_terms_5,
  o0_.total_product AS total_product_6,
  o0_.delivery_ht AS delivery_ht_7,
  o0_.delivery_total AS delivery_total_8,
  o0_.amount_ht AS amount_ht_9,
  o0_.amount_total AS amount_total_10,
  o0_.discount AS discount_11,
  o0_.vat AS vat_12,
  o0_.date AS date_13,
  o0_.b2l_id AS b2l_id_14,
  o0_.bak2_reference AS bak2_reference_15,
  o0_.shipping_number AS shipping_number_16,
  o0_.payment AS payment_17,
  o0_.payment_reference AS payment_reference_18,
  o0_.comment AS comment_19,
  o0_.option_price AS option_price_20,
  o0_.invoice_filename AS invoice_filename_21,
  o0_.active AS active_22,
  o0_.user_id AS user_id_23,
  o0_.shop_id AS shop_id_24,
  o0_.delivery_address_id AS delivery_address_id_25,
  o0_.invoice_address_id AS invoice_address_id_26,
  o0_.status_id AS status_id_27,
  o0_.temp_address_id AS temp_address_id_28
FROM
  `order` o0_
WHERE
  o0_.status_id <> ?
  AND o0_.active = ?
  AND o0_.shop_id = ?
  AND o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  o0_.date DESC

SELECT o0_.id AS id_0, o0_.reference AS reference_1, o0_.coupon AS coupon_2, o0_.custom_reference AS custom_reference_3, o0_.confirm AS confirm_4, o0_.accept_terms AS accept_terms_5, o0_.total_product AS total_product_6, o0_.delivery_ht AS delivery_ht_7, o0_.delivery_total AS delivery_total_8, o0_.amount_ht AS amount_ht_9, o0_.amount_total AS amount_total_10, o0_.discount AS discount_11, o0_.vat AS vat_12, o0_.date AS date_13, o0_.b2l_id AS b2l_id_14, o0_.bak2_reference AS bak2_reference_15, o0_.shipping_number AS shipping_number_16, o0_.payment AS payment_17, o0_.payment_reference AS payment_reference_18, o0_.comment AS comment_19, o0_.option_price AS option_price_20, o0_.invoice_filename AS invoice_filename_21, o0_.active AS active_22, o0_.user_id AS user_id_23, o0_.shop_id AS shop_id_24, o0_.delivery_address_id AS delivery_address_id_25, o0_.invoice_address_id AS invoice_address_id_26, o0_.status_id AS status_id_27, o0_.temp_address_id AS temp_address_id_28 FROM `order` o0_ WHERE o0_.status_id <> 10 AND o0_.active = 1 AND o0_.shop_id = 7 AND o0_.id IN (406, 396, 395, 393, 387, 385, 381, 367, 366, 356, 352, 344, 325, 306, 305, 275, 266, 265, 264, 263, 257, 254, 253, 252, 248, 246, 245, 244, 243, 242) ORDER BY o0_.date DESC;

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date AS date_1
FROM
  `order` o0_
WHERE
  o0_.status_id <> ?
  AND o0_.active = ?
  AND o0_.shop_id = ?
ORDER BY
  o0_.date DESC
LIMIT
  30

SELECT DISTINCT o0_.id AS id_0, o0_.date AS date_1 FROM `order` o0_ WHERE o0_.status_id <> 10 AND o0_.active = 1 AND o0_.shop_id = 7 ORDER BY o0_.date DESC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.b2l_id AS b2l_id_3,
  t0.color AS color_4,
  t0.type AS type_5
FROM
  status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.b2l_id AS b2l_id_3, t0.color AS color_4, t0.type AS type_5 FROM status t0 WHERE t0.id = 11;