Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sku AS sku_3,
  t0.pricce AS pricce_4,
  t0.weight AS weight_5,
  t0.description AS description_6,
  t0.created AS created_7,
  t0.cost AS cost_8,
  t0.pvp AS pvp_9,
  t0.is_virtual AS is_virtual_10,
  t0.min_sale_inventory_qty AS min_sale_inventory_qty_11,
  t0.media AS media_12,
  t0.inventory_quantity AS inventory_quantity_13,
  t0.ean AS ean_14,
  t0.image_name AS image_name_15,
  t0.is_active AS is_active_16,
  t0.product_url AS product_url_17,
  t0.image_url AS image_url_18,
  t0.category_description AS category_description_19,
  t0.parent_id AS parent_id_20,
  t0.store_id AS store_id_21,
  t0.tax_id AS tax_id_22
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.pricce AS pricce_4, t0.weight AS weight_5, t0.description AS description_6, t0.created AS created_7, t0.cost AS cost_8, t0.pvp AS pvp_9, t0.is_virtual AS is_virtual_10, t0.min_sale_inventory_qty AS min_sale_inventory_qty_11, t0.media AS media_12, t0.inventory_quantity AS inventory_quantity_13, t0.ean AS ean_14, t0.image_name AS image_name_15, t0.is_active AS is_active_16, t0.product_url AS product_url_17, t0.image_url AS image_url_18, t0.category_description AS category_description_19, t0.parent_id AS parent_id_20, t0.store_id AS store_id_21, t0.tax_id AS tax_id_22 FROM product t0 WHERE t0.id = '1729';

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.quantity AS quantity_2,
  t0_.description AS description_3,
  t0_.quantity_picked AS quantity_picked_4,
  t0_.created_at AS created_at_5,
  t0_.updated_at AS updated_at_6,
  t0_.product_id AS product_id_7,
  t0_.section_id AS section_id_8,
  t0_.inventory_id AS inventory_id_9,
  t0_.order_line_id AS order_line_id_10,
  t0_.partial_line_track_id AS partial_line_track_id_11
FROM
  tracking_inventory t0_
WHERE
  t0_.product_id = ?
ORDER BY
  t0_.created_at DESC
LIMIT
  500

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.quantity AS quantity_2, t0_.description AS description_3, t0_.quantity_picked AS quantity_picked_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.product_id AS product_id_7, t0_.section_id AS section_id_8, t0_.inventory_id AS inventory_id_9, t0_.order_line_id AS order_line_id_10, t0_.partial_line_track_id AS partial_line_track_id_11 FROM tracking_inventory t0_ WHERE t0_.product_id = 1729 ORDER BY t0_.created_at DESC LIMIT 500;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.logosmall AS logosmall_4,
  t0.icon AS icon_5,
  t0.favicon AS favicon_6,
  t0.is_cross_docking AS is_cross_docking_7
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.logosmall AS logosmall_4, t0.icon AS icon_5, t0.favicon AS favicon_6, t0.is_cross_docking AS is_cross_docking_7 FROM settings t0 WHERE t0.id = 1;

SELECT
  o0_.id AS id_0,
  o0_.external_market_id AS external_market_id_1,
  o0_.external_ship_id AS external_ship_id_2,
  o0_.imported_at AS imported_at_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.shipped_at AS shipped_at_6,
  o0_.error_on AS error_on_7,
  o0_.finished_at AS finished_at_8,
  o0_.canceled_at AS canceled_at_9,
  o0_.ship_from_name AS ship_from_name_10,
  o0_.ship_from_vat AS ship_from_vat_11,
  o0_.ship_from_phone AS ship_from_phone_12,
  o0_.ship_from_address AS ship_from_address_13,
  o0_.ship_from_zip_code AS ship_from_zip_code_14,
  o0_.ship_from_city AS ship_from_city_15,
  o0_.ship_from_country AS ship_from_country_16,
  o0_.ship_to_name AS ship_to_name_17,
  o0_.ship_to_vat AS ship_to_vat_18,
  o0_.ship_to_email AS ship_to_email_19,
  o0_.ship_to_phone AS ship_to_phone_20,
  o0_.ship_to_address AS ship_to_address_21,
  o0_.ship_to_zip_code AS ship_to_zip_code_22,
  o0_.ship_to_city AS ship_to_city_23,
  o0_.ship_to_country AS ship_to_country_24,
  o0_.volumes AS volumes_25,
  o0_.weight AS weight_26,
  o0_.refund AS refund_27,
  o0_.refund_value AS refund_value_28,
  o0_.back AS back_29,
  o0_.internal_reference AS internal_reference_30,
  o0_.obs AS obs_31,
  o0_.response_market AS response_market_32,
  o0_.total_price AS total_price_33,
  o0_.shipping_cost AS shipping_cost_34,
  o0_.deleted_at AS deleted_at_35,
  o0_.is_refund_received AS is_refund_received_36,
  o0_.shipping_description AS shipping_description_37,
  o0_.issuet_at AS issuet_at_38,
  o0_.completed_at AS completed_at_39,
  o0_.error_on_issue AS error_on_issue_40,
  o0_.is_gift AS is_gift_41,
  o0_.refund_received_at AS refund_received_at_42,
  o0_.external_ship_cost AS external_ship_cost_43,
  o0_.discount_value AS discount_value_44,
  o0_.store_id AS store_id_45,
  o0_.ship_provider_id AS ship_provider_id_46,
  o0_.market_store_id AS market_store_id_47,
  o0_.status_id AS status_id_48,
  o0_.store_ship_provider_id AS store_ship_provider_id_49,
  o0_.created_by_id AS created_by_id_50,
  o0_.ship_provider_status_id AS ship_provider_status_id_51
FROM
  `order` o0_
  INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id
WHERE
  s1_.type LIKE ?

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id WHERE s1_.type LIKE 'INC';

SELECT
  o0_.id AS id_0,
  o0_.external_market_id AS external_market_id_1,
  o0_.external_ship_id AS external_ship_id_2,
  o0_.imported_at AS imported_at_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.shipped_at AS shipped_at_6,
  o0_.error_on AS error_on_7,
  o0_.finished_at AS finished_at_8,
  o0_.canceled_at AS canceled_at_9,
  o0_.ship_from_name AS ship_from_name_10,
  o0_.ship_from_vat AS ship_from_vat_11,
  o0_.ship_from_phone AS ship_from_phone_12,
  o0_.ship_from_address AS ship_from_address_13,
  o0_.ship_from_zip_code AS ship_from_zip_code_14,
  o0_.ship_from_city AS ship_from_city_15,
  o0_.ship_from_country AS ship_from_country_16,
  o0_.ship_to_name AS ship_to_name_17,
  o0_.ship_to_vat AS ship_to_vat_18,
  o0_.ship_to_email AS ship_to_email_19,
  o0_.ship_to_phone AS ship_to_phone_20,
  o0_.ship_to_address AS ship_to_address_21,
  o0_.ship_to_zip_code AS ship_to_zip_code_22,
  o0_.ship_to_city AS ship_to_city_23,
  o0_.ship_to_country AS ship_to_country_24,
  o0_.volumes AS volumes_25,
  o0_.weight AS weight_26,
  o0_.refund AS refund_27,
  o0_.refund_value AS refund_value_28,
  o0_.back AS back_29,
  o0_.internal_reference AS internal_reference_30,
  o0_.obs AS obs_31,
  o0_.response_market AS response_market_32,
  o0_.total_price AS total_price_33,
  o0_.shipping_cost AS shipping_cost_34,
  o0_.deleted_at AS deleted_at_35,
  o0_.is_refund_received AS is_refund_received_36,
  o0_.shipping_description AS shipping_description_37,
  o0_.issuet_at AS issuet_at_38,
  o0_.completed_at AS completed_at_39,
  o0_.error_on_issue AS error_on_issue_40,
  o0_.is_gift AS is_gift_41,
  o0_.refund_received_at AS refund_received_at_42,
  o0_.external_ship_cost AS external_ship_cost_43,
  o0_.discount_value AS discount_value_44,
  o0_.store_id AS store_id_45,
  o0_.ship_provider_id AS ship_provider_id_46,
  o0_.market_store_id AS market_store_id_47,
  o0_.status_id AS status_id_48,
  o0_.store_ship_provider_id AS store_ship_provider_id_49,
  o0_.created_by_id AS created_by_id_50,
  o0_.ship_provider_status_id AS ship_provider_status_id_51
FROM
  `order` o0_
  INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id
WHERE
  s1_.type LIKE ?

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id WHERE s1_.type LIKE 'INC';

SELECT
  o0_.id AS id_0,
  o0_.external_market_id AS external_market_id_1,
  o0_.external_ship_id AS external_ship_id_2,
  o0_.imported_at AS imported_at_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.shipped_at AS shipped_at_6,
  o0_.error_on AS error_on_7,
  o0_.finished_at AS finished_at_8,
  o0_.canceled_at AS canceled_at_9,
  o0_.ship_from_name AS ship_from_name_10,
  o0_.ship_from_vat AS ship_from_vat_11,
  o0_.ship_from_phone AS ship_from_phone_12,
  o0_.ship_from_address AS ship_from_address_13,
  o0_.ship_from_zip_code AS ship_from_zip_code_14,
  o0_.ship_from_city AS ship_from_city_15,
  o0_.ship_from_country AS ship_from_country_16,
  o0_.ship_to_name AS ship_to_name_17,
  o0_.ship_to_vat AS ship_to_vat_18,
  o0_.ship_to_email AS ship_to_email_19,
  o0_.ship_to_phone AS ship_to_phone_20,
  o0_.ship_to_address AS ship_to_address_21,
  o0_.ship_to_zip_code AS ship_to_zip_code_22,
  o0_.ship_to_city AS ship_to_city_23,
  o0_.ship_to_country AS ship_to_country_24,
  o0_.volumes AS volumes_25,
  o0_.weight AS weight_26,
  o0_.refund AS refund_27,
  o0_.refund_value AS refund_value_28,
  o0_.back AS back_29,
  o0_.internal_reference AS internal_reference_30,
  o0_.obs AS obs_31,
  o0_.response_market AS response_market_32,
  o0_.total_price AS total_price_33,
  o0_.shipping_cost AS shipping_cost_34,
  o0_.deleted_at AS deleted_at_35,
  o0_.is_refund_received AS is_refund_received_36,
  o0_.shipping_description AS shipping_description_37,
  o0_.issuet_at AS issuet_at_38,
  o0_.completed_at AS completed_at_39,
  o0_.error_on_issue AS error_on_issue_40,
  o0_.is_gift AS is_gift_41,
  o0_.refund_received_at AS refund_received_at_42,
  o0_.external_ship_cost AS external_ship_cost_43,
  o0_.discount_value AS discount_value_44,
  o0_.store_id AS store_id_45,
  o0_.ship_provider_id AS ship_provider_id_46,
  o0_.market_store_id AS market_store_id_47,
  o0_.status_id AS status_id_48,
  o0_.store_ship_provider_id AS store_ship_provider_id_49,
  o0_.created_by_id AS created_by_id_50,
  o0_.ship_provider_status_id AS ship_provider_status_id_51
FROM
  `order` o0_
  INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id
WHERE
  s1_.type LIKE ?

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id WHERE s1_.type LIKE 'INC';

SELECT
  t0.id AS id_1,
  t0.obs AS obs_2,
  t0.created_at AS created_at_3,
  t0.tracking_at AS tracking_at_4,
  t0.store_order_id AS store_order_id_5,
  t0.ship_provider_status_id AS ship_provider_status_id_6
FROM
  order_ship_provider_status t0
WHERE
  t0.store_order_id = ?
ORDER BY
  t0.tracking_at DESC

SELECT t0.id AS id_1, t0.obs AS obs_2, t0.created_at AS created_at_3, t0.tracking_at AS tracking_at_4, t0.store_order_id AS store_order_id_5, t0.ship_provider_status_id AS ship_provider_status_id_6 FROM order_ship_provider_status t0 WHERE t0.store_order_id = 7247 ORDER BY t0.tracking_at DESC;

SELECT
  t0.id AS id_1,
  t0.obs AS obs_2,
  t0.created_at AS created_at_3,
  t0.tracking_at AS tracking_at_4,
  t0.store_order_id AS store_order_id_5,
  t0.ship_provider_status_id AS ship_provider_status_id_6
FROM
  order_ship_provider_status t0
WHERE
  t0.store_order_id = ?
ORDER BY
  t0.tracking_at DESC

SELECT t0.id AS id_1, t0.obs AS obs_2, t0.created_at AS created_at_3, t0.tracking_at AS tracking_at_4, t0.store_order_id AS store_order_id_5, t0.ship_provider_status_id AS ship_provider_status_id_6 FROM order_ship_provider_status t0 WHERE t0.store_order_id = 10400 ORDER BY t0.tracking_at DESC;

SELECT
  t0.id AS id_1,
  t0.obs AS obs_2,
  t0.created_at AS created_at_3,
  t0.tracking_at AS tracking_at_4,
  t0.store_order_id AS store_order_id_5,
  t0.ship_provider_status_id AS ship_provider_status_id_6
FROM
  order_ship_provider_status t0
WHERE
  t0.store_order_id = ?
ORDER BY
  t0.tracking_at DESC

SELECT t0.id AS id_1, t0.obs AS obs_2, t0.created_at AS created_at_3, t0.tracking_at AS tracking_at_4, t0.store_order_id AS store_order_id_5, t0.ship_provider_status_id AS ship_provider_status_id_6 FROM order_ship_provider_status t0 WHERE t0.store_order_id = 11622 ORDER BY t0.tracking_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_final AS is_final_3,
  t0.type AS type_4,
  t0.is_notification AS is_notification_5
FROM
  STATUS t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_final AS is_final_3, t0.type AS type_4, t0.is_notification AS is_notification_5 FROM STATUS t0 WHERE t0.id = 3;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.status_id = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_final AS is_final_3,
  t0.type AS type_4,
  t0.is_notification AS is_notification_5
FROM
  STATUS t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_final AS is_final_3, t0.type AS type_4, t0.is_notification AS is_notification_5 FROM STATUS t0 WHERE t0.id = 4;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.status_id = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id = 4;