Symfony Profiler

SELECT
  COUNT(*): :INTEGER AS total_count
FROM
  (
    SELECT
      o0_.id AS id_0,
      o0_.eshop_order_id AS eshop_order_id_1,
      o0_.number AS number_2,
      o0_.status AS status_3,
      o0_.paid AS paid_4,
      o0_.payment_method AS payment_method_5,
      o0_.created_at AS created_at_6,
      o0_.updated_at AS updated_at_7,
      o1_.first_name || ' ' || o1_.last_name AS sclr_8,
      o2_.first_name || ' ' || o2_.last_name AS sclr_9,
      o1_.country AS country_10,
      o2_.country AS country_11,
      o2_.email AS email_12
    FROM
      orders o0_
      LEFT JOIN order_shipping_address o1_ ON (o0_.id = o1_.order_id)
      LEFT JOIN order_billing_address o2_ ON (o0_.id = o2_.order_id)
    WHERE
      (o2_.email LIKE ?)
    GROUP BY
      o0_.id,
      o1_.id,
      o2_.id
  ) ORIGINAL_QUERY

SELECT COUNT(*)::INTEGER AS total_count FROM (SELECT o0_.id AS id_0, o0_.eshop_order_id AS eshop_order_id_1, o0_.number AS number_2, o0_.status AS status_3, o0_.paid AS paid_4, o0_.payment_method AS payment_method_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7, o1_.first_name || ' ' || o1_.last_name AS sclr_8, o2_.first_name || ' ' || o2_.last_name AS sclr_9, o1_.country AS country_10, o2_.country AS country_11, o2_.email AS email_12 FROM orders o0_ LEFT JOIN order_shipping_address o1_ ON (o0_.id = o1_.order_id) LEFT JOIN order_billing_address o2_ ON (o0_.id = o2_.order_id) WHERE (o2_.email LIKE '%kantorimi93@icloud.com%') GROUP BY o0_.id, o1_.id, o2_.id) ORIGINAL_QUERY;

SELECT
  o0_.id AS id_0,
  o0_.eshop_order_id AS eshop_order_id_1,
  o0_.number AS number_2,
  o0_.status AS status_3,
  o0_.paid AS paid_4,
  o0_.payment_method AS payment_method_5,
  o0_.created_at AS created_at_6,
  o0_.updated_at AS updated_at_7,
  o1_.first_name || ' ' || o1_.last_name AS sclr_8,
  o2_.first_name || ' ' || o2_.last_name AS sclr_9,
  o1_.country AS country_10,
  o2_.country AS country_11,
  o2_.email AS email_12
FROM
  orders o0_
  LEFT JOIN order_shipping_address o1_ ON (o0_.id = o1_.order_id)
  LEFT JOIN order_billing_address o2_ ON (o0_.id = o2_.order_id)
WHERE
  (o2_.email LIKE ?)
GROUP BY
  o0_.id,
  o1_.id,
  o2_.id
ORDER BY
  o0_.created_at DESC NULLS LAST
LIMIT
  100

SELECT o0_.id AS id_0, o0_.eshop_order_id AS eshop_order_id_1, o0_.number AS number_2, o0_.status AS status_3, o0_.paid AS paid_4, o0_.payment_method AS payment_method_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7, o1_.first_name || ' ' || o1_.last_name AS sclr_8, o2_.first_name || ' ' || o2_.last_name AS sclr_9, o1_.country AS country_10, o2_.country AS country_11, o2_.email AS email_12 FROM orders o0_ LEFT JOIN order_shipping_address o1_ ON (o0_.id = o1_.order_id) LEFT JOIN order_billing_address o2_ ON (o0_.id = o2_.order_id) WHERE (o2_.email LIKE '%kantorimi93@icloud.com%') GROUP BY o0_.id, o1_.id, o2_.id ORDER BY o0_.created_at DESC NULLS LAST LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.eshop_order_parent_id AS eshop_order_parent_id_2,
  t0.eshop_order_id AS eshop_order_id_3,
  t0.number AS number_4,
  t0.currency_rate AS currency_rate_5,
  t0.invoice_number AS invoice_number_6,
  t0.status AS status_7,
  t0.currency AS currency_8,
  t0.discount_total AS discount_total_9,
  t0.discount_tax AS discount_tax_10,
  t0.total AS total_11,
  t0.total_tax AS total_tax_12,
  t0.shipping_total AS shipping_total_13,
  t0.shipping_tax AS shipping_tax_14,
  t0.cart_tax AS cart_tax_15,
  t0.prices_included_tax AS prices_included_tax_16,
  t0.customer_id AS customer_id_17,
  t0.customer_note AS customer_note_18,
  t0.note AS note_19,
  t0.payment_method AS payment_method_20,
  t0.payment_method_title AS payment_method_title_21,
  t0.transaction_id AS transaction_id_22,
  t0.paid AS paid_23,
  t0.eshop_id AS eshop_id_24,
  t0.synced AS synced_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.invoiced_at AS invoiced_at_28,
  t0.packeta_address_id AS packeta_address_id_29,
  t0.packeta_address_name AS packeta_address_name_30,
  t0.packeta_place AS packeta_place_31,
  t0.packeta_transport_id AS packeta_transport_id_32,
  t0.packeta_carrier_id AS packeta_carrier_id_33,
  t0.packeta_carrier_pickup_point_id AS packeta_carrier_pickup_point_id_34,
  t0.packeta_city AS packeta_city_35,
  t0.packeta_street AS packeta_street_36,
  t0.packeta_zip AS packeta_zip_37,
  t0.packeta_url AS packeta_url_38,
  t0.packeta_custom_dimension AS packeta_custom_dimension_39,
  t0.to_sync AS to_sync_40,
  t0.locked_date_time AS locked_date_time_41,
  t42.id AS id_43,
  t42.first_name AS first_name_44,
  t42.last_name AS last_name_45,
  t42.company AS company_46,
  t42.address AS address_47,
  t42.address2 AS address2_48,
  t42.city AS city_49,
  t42.state AS state_50,
  t42.postcode AS postcode_51,
  t42.country AS country_52,
  t42.email AS email_53,
  t42.phone AS phone_54,
  t42.order_id AS order_id_55,
  t56.id AS id_57,
  t56.first_name AS first_name_58,
  t56.last_name AS last_name_59,
  t56.company AS company_60,
  t56.address AS address_61,
  t56.address2 AS address2_62,
  t56.city AS city_63,
  t56.state AS state_64,
  t56.postcode AS postcode_65,
  t56.country AS country_66,
  t56.order_id AS order_id_67,
  t68.id AS id_69,
  t68.sent AS sent_70,
  t68.sent_status AS sent_status_71,
  t68.shipment_id AS shipment_id_72,
  t68.barcode AS barcode_73,
  t68.barcode_text AS barcode_text_74,
  t68.courier_number AS courier_number_75,
  t68.fail_text AS fail_text_76,
  t68.created_at AS created_at_77,
  t68.updated_at AS updated_at_78,
  t68.order_id AS order_id_79
FROM
  orders t0
  LEFT JOIN order_billing_address t42 ON t42.order_id = t0.id
  LEFT JOIN order_shipping_address t56 ON t56.order_id = t0.id
  LEFT JOIN order_packeta t68 ON t68.order_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.eshop_order_parent_id AS eshop_order_parent_id_2, t0.eshop_order_id AS eshop_order_id_3, t0.number AS number_4, t0.currency_rate AS currency_rate_5, t0.invoice_number AS invoice_number_6, t0.status AS status_7, t0.currency AS currency_8, t0.discount_total AS discount_total_9, t0.discount_tax AS discount_tax_10, t0.total AS total_11, t0.total_tax AS total_tax_12, t0.shipping_total AS shipping_total_13, t0.shipping_tax AS shipping_tax_14, t0.cart_tax AS cart_tax_15, t0.prices_included_tax AS prices_included_tax_16, t0.customer_id AS customer_id_17, t0.customer_note AS customer_note_18, t0.note AS note_19, t0.payment_method AS payment_method_20, t0.payment_method_title AS payment_method_title_21, t0.transaction_id AS transaction_id_22, t0.paid AS paid_23, t0.eshop_id AS eshop_id_24, t0.synced AS synced_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.invoiced_at AS invoiced_at_28, t0.packeta_address_id AS packeta_address_id_29, t0.packeta_address_name AS packeta_address_name_30, t0.packeta_place AS packeta_place_31, t0.packeta_transport_id AS packeta_transport_id_32, t0.packeta_carrier_id AS packeta_carrier_id_33, t0.packeta_carrier_pickup_point_id AS packeta_carrier_pickup_point_id_34, t0.packeta_city AS packeta_city_35, t0.packeta_street AS packeta_street_36, t0.packeta_zip AS packeta_zip_37, t0.packeta_url AS packeta_url_38, t0.packeta_custom_dimension AS packeta_custom_dimension_39, t0.to_sync AS to_sync_40, t0.locked_date_time AS locked_date_time_41, t42.id AS id_43, t42.first_name AS first_name_44, t42.last_name AS last_name_45, t42.company AS company_46, t42.address AS address_47, t42.address2 AS address2_48, t42.city AS city_49, t42.state AS state_50, t42.postcode AS postcode_51, t42.country AS country_52, t42.email AS email_53, t42.phone AS phone_54, t42.order_id AS order_id_55, t56.id AS id_57, t56.first_name AS first_name_58, t56.last_name AS last_name_59, t56.company AS company_60, t56.address AS address_61, t56.address2 AS address2_62, t56.city AS city_63, t56.state AS state_64, t56.postcode AS postcode_65, t56.country AS country_66, t56.order_id AS order_id_67, t68.id AS id_69, t68.sent AS sent_70, t68.sent_status AS sent_status_71, t68.shipment_id AS shipment_id_72, t68.barcode AS barcode_73, t68.barcode_text AS barcode_text_74, t68.courier_number AS courier_number_75, t68.fail_text AS fail_text_76, t68.created_at AS created_at_77, t68.updated_at AS updated_at_78, t68.order_id AS order_id_79 FROM orders t0 LEFT JOIN order_billing_address t42 ON t42.order_id = t0.id LEFT JOIN order_shipping_address t56 ON t56.order_id = t0.id LEFT JOIN order_packeta t68 ON t68.order_id = t0.id WHERE t0.id = 409977;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.real_name AS real_name_3,
  t0.password AS password_4,
  t0.login_token AS login_token_5,
  t0.email AS email_6,
  t0.multidomain_login_token AS multidomain_login_token_7,
  t0.multidomain_login_token_expiration AS multidomain_login_token_expiration_8,
  t0.roles_changed_at AS roles_changed_at_9
FROM
  administrators t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.real_name AS real_name_3, t0.password AS password_4, t0.login_token AS login_token_5, t0.email AS email_6, t0.multidomain_login_token AS multidomain_login_token_7, t0.multidomain_login_token_expiration AS multidomain_login_token_expiration_8, t0.roles_changed_at AS roles_changed_at_9 FROM administrators t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.order_shipping_id AS order_shipping_id_2,
  t0.method_title AS method_title_3,
  t0.method_id AS method_id_4,
  t0.total AS total_5,
  t0.total_tax AS total_tax_6,
  t0.delete AS delete_7,
  t0.order_id AS order_id_8
FROM
  order_shippings t0
WHERE
  t0.order_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.order_shipping_id AS order_shipping_id_2, t0.method_title AS method_title_3, t0.method_id AS method_id_4, t0.total AS total_5, t0.total_tax AS total_tax_6, t0.delete AS delete_7, t0.order_id AS order_id_8 FROM order_shippings t0 WHERE t0.order_id = 409977 ORDER BY t0.id ASC;

SELECT
  a0_.id AS id_0,
  a0_.ip_address AS ip_address_1,
  a0_.login_time AS login_time_2,
  a0_.last_action_time AS last_action_time_3,
  a0_.administrator_id AS administrator_id_4
FROM
  administrator_activities a0_
WHERE
  a0_.administrator_id = ?
ORDER BY
  a0_.login_time DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.ip_address AS ip_address_1, a0_.login_time AS login_time_2, a0_.last_action_time AS last_action_time_3, a0_.administrator_id AS administrator_id_4 FROM administrator_activities a0_ WHERE a0_.administrator_id = 5 ORDER BY a0_.login_time DESC LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.packeta_name AS packeta_name_2,
  e0_.url AS url_3,
  e0_.currency AS currency_4,
  e0_.locale AS locale_5,
  e0_.api_key AS api_key_6,
  e0_.api_secret AS api_secret_7,
  e0_.is_default AS is_default_8,
  e0_.enabled AS enabled_9,
  e0_.created_at AS created_at_10,
  e0_.updated_at AS updated_at_11
FROM
  eshops e0_
ORDER BY
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.packeta_name AS packeta_name_2, e0_.url AS url_3, e0_.currency AS currency_4, e0_.locale AS locale_5, e0_.api_key AS api_key_6, e0_.api_secret AS api_secret_7, e0_.is_default AS is_default_8, e0_.enabled AS enabled_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11 FROM eshops e0_ ORDER BY e0_.id ASC;

"COMMIT"

"COMMIT";

SELECT
  t0.grid_id AS grid_id_1,
  t0."limit" AS limit_2,
  t0.administrator_id AS administrator_id_3
FROM
  administrator_grid_limits t0
WHERE
  t0.administrator_id = ?

SELECT t0.grid_id AS grid_id_1, t0."limit" AS limit_2, t0.administrator_id AS administrator_id_3 FROM administrator_grid_limits t0 WHERE t0.administrator_id = 5;

UPDATE
  administrator_activities
SET
  last_action_time = ?
WHERE
  id = ?

UPDATE administrator_activities SET last_action_time = '2025-07-02 06:45:22' WHERE id = 2911;

SELECT
  t0.role AS role_1,
  t0.administrator_id AS administrator_id_2
FROM
  administrator_roles t0
WHERE
  t0.administrator_id = ?

SELECT t0.role AS role_1, t0.administrator_id AS administrator_id_2 FROM administrator_roles t0 WHERE t0.administrator_id = 5;

"START TRANSACTION"

"START TRANSACTION";