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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.sku AS sku_2,
  p0_.pricce AS pricce_3,
  p0_.weight AS weight_4,
  p0_.description AS description_5,
  p0_.created AS created_6,
  p0_.cost AS cost_7,
  p0_.pvp AS pvp_8,
  p0_.is_virtual AS is_virtual_9,
  p0_.min_sale_inventory_qty AS min_sale_inventory_qty_10,
  p0_.media AS media_11,
  p0_.inventory_quantity AS inventory_quantity_12,
  p0_.ean AS ean_13,
  p0_.image_name AS image_name_14,
  p0_.is_active AS is_active_15,
  p0_.product_url AS product_url_16,
  p0_.image_url AS image_url_17,
  p0_.category_description AS category_description_18,
  p0_.parent_id AS parent_id_19,
  p0_.store_id AS store_id_20,
  p0_.tax_id AS tax_id_21
FROM
  product p0_
WHERE
  p0_.name LIKE ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sku AS sku_2, p0_.pricce AS pricce_3, p0_.weight AS weight_4, p0_.description AS description_5, p0_.created AS created_6, p0_.cost AS cost_7, p0_.pvp AS pvp_8, p0_.is_virtual AS is_virtual_9, p0_.min_sale_inventory_qty AS min_sale_inventory_qty_10, p0_.media AS media_11, p0_.inventory_quantity AS inventory_quantity_12, p0_.ean AS ean_13, p0_.image_name AS image_name_14, p0_.is_active AS is_active_15, p0_.product_url AS product_url_16, p0_.image_url AS image_url_17, p0_.category_description AS category_description_18, p0_.parent_id AS parent_id_19, p0_.store_id AS store_id_20, p0_.tax_id AS tax_id_21 FROM product p0_ WHERE p0_.name LIKE '%GBBSJ1CCPY%';

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;

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.created_at AS created_at_2,
  c0_.qty AS qty_3,
  c0_.price AS price_4,
  c0_.description AS description_5,
  c0_.is_ready AS is_ready_6,
  c0_.preparation_at AS preparation_at_7,
  c0_.separate_at AS separate_at_8,
  c0_.product_id AS product_id_9,
  c0_.store_order_id AS store_order_id_10,
  c0_.order_line_id AS order_line_id_11,
  c0_.partial_line_track_id AS partial_line_track_id_12
FROM
  crossdocking c0_
WHERE
  c0_.order_line_id IS NOT NULL
  AND c0_.is_ready = 0

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.order_line_id IS NOT NULL AND c0_.is_ready = 0;