Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.user AS user_2,
  t0.prod AS prod_3,
  t0.var AS var_4,
  t0.num AS num_5,
  t0.tstamp AS tstamp_6
FROM
  wishlist t0
WHERE
  t0.user = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = 0 ORDER BY t0.id DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.user AS user_1,
          o0_.referal AS referal_2,
          o0_.manager AS manager_3,
          o0_.tstamp AS tstamp_4,
          o0_.esystem AS esystem_5,
          o0_.delivery AS delivery_6,
          o0_.subdelivery AS subdelivery_7,
          o0_.status AS status_8,
          o0_.name AS name_9,
          o0_.addr AS addr_10,
          o0_.city AS city_11,
          o0_.postcode AS postcode_12,
          o0_.state AS state_13,
          o0_.state_code AS state_code_14,
          o0_.country AS country_15,
          o0_.phone AS phone_16,
          o0_.email AS email_17,
          o0_.ip AS ip_18,
          o0_.payment_method AS payment_method_19,
          o0_.created AS created_20,
          o0_.sklad AS sklad_21,
          o0_.comment AS comment_22,
          o0_.opt AS opt_23,
          o0_.needcall AS needcall_24,
          o0_.deliverycost AS deliverycost_25,
          o0_.paylink AS paylink_26,
          o0_.discount AS discount_27,
          o0_.session AS session_28,
          o0_.cookie AS cookie_29,
          o0_.amount AS amount_30,
          o0_.amount_without_discount AS amount_without_discount_31,
          o0_.weight AS weight_32,
          o0_.company_nip AS company_nip_33,
          o0_.company_name AS company_name_34,
          o0_.company_index AS company_index_35,
          o0_.company_city AS company_city_36,
          o0_.company_street AS company_street_37,
          o0_.company_house AS company_house_38,
          o0_.company_flat AS company_flat_39
        FROM
          `order` o0_
        WHERE
          o0_.user = 0
        ORDER BY
          o0_.tstamp DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.user AS user_1, o0_.referal AS referal_2, o0_.manager AS manager_3, o0_.tstamp AS tstamp_4, o0_.esystem AS esystem_5, o0_.delivery AS delivery_6, o0_.subdelivery AS subdelivery_7, o0_.status AS status_8, o0_.name AS name_9, o0_.addr AS addr_10, o0_.city AS city_11, o0_.postcode AS postcode_12, o0_.state AS state_13, o0_.state_code AS state_code_14, o0_.country AS country_15, o0_.phone AS phone_16, o0_.email AS email_17, o0_.ip AS ip_18, o0_.payment_method AS payment_method_19, o0_.created AS created_20, o0_.sklad AS sklad_21, o0_.comment AS comment_22, o0_.opt AS opt_23, o0_.needcall AS needcall_24, o0_.deliverycost AS deliverycost_25, o0_.paylink AS paylink_26, o0_.discount AS discount_27, o0_.session AS session_28, o0_.cookie AS cookie_29, o0_.amount AS amount_30, o0_.amount_without_discount AS amount_without_discount_31, o0_.weight AS weight_32, o0_.company_nip AS company_nip_33, o0_.company_name AS company_name_34, o0_.company_index AS company_index_35, o0_.company_city AS company_city_36, o0_.company_street AS company_street_37, o0_.company_house AS company_house_38, o0_.company_flat AS company_flat_39 FROM `order` o0_ WHERE o0_.user = 0 ORDER BY o0_.tstamp DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.user AS user_2,
  t0.referal AS referal_3,
  t0.manager AS manager_4,
  t0.tstamp AS tstamp_5,
  t0.esystem AS esystem_6,
  t0.delivery AS delivery_7,
  t0.subdelivery AS subdelivery_8,
  t0.status AS status_9,
  t0.name AS name_10,
  t0.addr AS addr_11,
  t0.city AS city_12,
  t0.postcode AS postcode_13,
  t0.state AS state_14,
  t0.state_code AS state_code_15,
  t0.country AS country_16,
  t0.phone AS phone_17,
  t0.email AS email_18,
  t0.ip AS ip_19,
  t0.payment_method AS payment_method_20,
  t0.created AS created_21,
  t0.sklad AS sklad_22,
  t0.comment AS comment_23,
  t0.opt AS opt_24,
  t0.needcall AS needcall_25,
  t0.deliverycost AS deliverycost_26,
  t0.paylink AS paylink_27,
  t0.discount AS discount_28,
  t0.session AS session_29,
  t0.cookie AS cookie_30,
  t0.amount AS amount_31,
  t0.amount_without_discount AS amount_without_discount_32,
  t0.weight AS weight_33,
  t0.company_nip AS company_nip_34,
  t0.company_name AS company_name_35,
  t0.company_index AS company_index_36,
  t0.company_city AS company_city_37,
  t0.company_street AS company_street_38,
  t0.company_house AS company_house_39,
  t0.company_flat AS company_flat_40
FROM
  `order` t0
WHERE
  t0.user = ?

SELECT t0.id AS id_1, t0.user AS user_2, t0.referal AS referal_3, t0.manager AS manager_4, t0.tstamp AS tstamp_5, t0.esystem AS esystem_6, t0.delivery AS delivery_7, t0.subdelivery AS subdelivery_8, t0.status AS status_9, t0.name AS name_10, t0.addr AS addr_11, t0.city AS city_12, t0.postcode AS postcode_13, t0.state AS state_14, t0.state_code AS state_code_15, t0.country AS country_16, t0.phone AS phone_17, t0.email AS email_18, t0.ip AS ip_19, t0.payment_method AS payment_method_20, t0.created AS created_21, t0.sklad AS sklad_22, t0.comment AS comment_23, t0.opt AS opt_24, t0.needcall AS needcall_25, t0.deliverycost AS deliverycost_26, t0.paylink AS paylink_27, t0.discount AS discount_28, t0.session AS session_29, t0.cookie AS cookie_30, t0.amount AS amount_31, t0.amount_without_discount AS amount_without_discount_32, t0.weight AS weight_33, t0.company_nip AS company_nip_34, t0.company_name AS company_name_35, t0.company_index AS company_index_36, t0.company_city AS company_city_37, t0.company_street AS company_street_38, t0.company_house AS company_house_39, t0.company_flat AS company_flat_40 FROM `order` t0 WHERE t0.user = 0;

SELECT
  o0_.id AS id_0,
  o0_.amount AS amount_1
FROM
  `order` o0_
WHERE
  o0_.opt = 0
  AND (
    o0_.status = 1
    OR o0_.status = 3
    OR o0_.status = 7
  )
  AND o0_.user = 0

SELECT o0_.id AS id_0, o0_.amount AS amount_1 FROM `order` o0_ WHERE o0_.opt = 0 AND (o0_.status = 1 OR o0_.status = 3 OR o0_.status = 7) AND o0_.user = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.nakop AS nakop_4
FROM
  discount t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.nakop AS nakop_4 FROM discount t0;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  discount_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM discount_translation t0 WHERE t0.object_id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  discount_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM discount_translation t0 WHERE t0.object_id = 2;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  discount_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM discount_translation t0 WHERE t0.object_id = 3;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  discount_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM discount_translation t0 WHERE t0.object_id = 4;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  discount_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM discount_translation t0 WHERE t0.object_id = 5;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.value AS value_2,
  d0_.nakop AS nakop_3
FROM
  discount d0_
WHERE
  d0_.nakop <= 0
ORDER BY
  d0_.nakop DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.value AS value_2, d0_.nakop AS nakop_3 FROM discount d0_ WHERE d0_.nakop <= 0 ORDER BY d0_.nakop DESC LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.value AS value_2,
  d0_.nakop AS nakop_3
FROM
  discount d0_
WHERE
  d0_.nakop > 0
ORDER BY
  d0_.nakop ASC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.value AS value_2, d0_.nakop AS nakop_3 FROM discount d0_ WHERE d0_.nakop > 0 ORDER BY d0_.nakop ASC LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.value AS value_2,
  d0_.nakop AS nakop_3
FROM
  discount d0_
WHERE
  d0_.nakop > 0
ORDER BY
  d0_.nakop ASC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.value AS value_2, d0_.nakop AS nakop_3 FROM discount d0_ WHERE d0_.nakop > 0 ORDER BY d0_.nakop ASC LIMIT 1;