Symfony Profiler

SELECT 
  t0.token AS token_1, 
  t0.expires_at AS expires_at_2, 
  t0.scope AS scope_3, 
  t0.id AS id_4, 
  t0.client_id AS client_id_5, 
  t0.user_id AS user_id_6 
FROM 
  oauth_access_token t0 
WHERE 
  t0.token = ? 
LIMIT 
  1

SELECT t0.token AS token_1, t0.expires_at AS expires_at_2, t0.scope AS scope_3, t0.id AS id_4, t0.client_id AS client_id_5, t0.user_id AS user_id_6 FROM oauth_access_token t0 WHERE t0.token = 'Mjk4OTgzZWM2NGVlNTFlMWUxYTA4NTVhYmE5NWQ1NjIwMTM3YjRmNzJlY2QzODg0ZTIyYTRiYTViNmIzMmZiNw' LIMIT 1;

SELECT 
  t0.enabled AS enabled_1, 
  t0.salt AS salt_2, 
  t0.password AS password_3, 
  t0.last_login AS last_login_4, 
  t0.confirmation_token AS confirmation_token_5, 
  t0.password_requested_at AS password_requested_at_6, 
  t0.roles AS roles_7, 
  t0.id AS id_8, 
  t0.first_name AS first_name_9, 
  t0.last_name AS last_name_10, 
  t0.forklift_certified AS forklift_certified_11, 
  t0.is_customer AS is_customer_12, 
  t0.reverse_group_selection AS reverse_group_selection_13, 
  t0.last_request_at AS last_request_at_14, 
  t0.type AS type_15, 
  t0.created_at AS created_at_16, 
  t0.modified_at AS modified_at_17, 
  t0.deleted_at AS deleted_at_18, 
  t0.email AS email_19, 
  t0.email_canonical AS email_canonical_20, 
  t0.username AS username_21, 
  t0.username_canonical AS username_canonical_22, 
  t0.created_by_id AS created_by_id_23, 
  t0.modified_by_id AS modified_by_id_24, 
  t0.deleted_by_id AS deleted_by_id_25 
FROM 
  fos_user t0 
WHERE 
  t0.id = ?

SELECT t0.enabled AS enabled_1, t0.salt AS salt_2, t0.password AS password_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.forklift_certified AS forklift_certified_11, t0.is_customer AS is_customer_12, t0.reverse_group_selection AS reverse_group_selection_13, t0.last_request_at AS last_request_at_14, t0.type AS type_15, t0.created_at AS created_at_16, t0.modified_at AS modified_at_17, t0.deleted_at AS deleted_at_18, t0.email AS email_19, t0.email_canonical AS email_canonical_20, t0.username AS username_21, t0.username_canonical AS username_canonical_22, t0.created_by_id AS created_by_id_23, t0.modified_by_id AS modified_by_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM fos_user t0 WHERE t0.id = 'dcb924dd-41fb-11ec-9930-92f6e0ca955a';

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.roles AS roles_3, 
  t0.created_at AS created_at_4, 
  t0.modified_at AS modified_at_5, 
  t0.deleted_at AS deleted_at_6, 
  t0.created_by_id AS created_by_id_7, 
  t0.modified_by_id AS modified_by_id_8, 
  t0.deleted_by_id AS deleted_by_id_9 
FROM 
  fos_group t0 
  INNER JOIN fos_user_group ON t0.id = fos_user_group.group_id 
WHERE 
  fos_user_group.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.created_at AS created_at_4, t0.modified_at AS modified_at_5, t0.deleted_at AS deleted_at_6, t0.created_by_id AS created_by_id_7, t0.modified_by_id AS modified_by_id_8, t0.deleted_by_id AS deleted_by_id_9 FROM fos_group t0 INNER JOIN fos_user_group ON t0.id = fos_user_group.group_id WHERE fos_user_group.user_id = 'dcb924dd-41fb-11ec-9930-92f6e0ca955a';

SELECT 
  t0.token AS token_1, 
  t0.expires_at AS expires_at_2, 
  t0.scope AS scope_3, 
  t0.id AS id_4, 
  t0.client_id AS client_id_5, 
  t0.user_id AS user_id_6 
FROM 
  oauth_access_token t0 
WHERE 
  t0.token = ? 
LIMIT 
  1

SELECT t0.token AS token_1, t0.expires_at AS expires_at_2, t0.scope AS scope_3, t0.id AS id_4, t0.client_id AS client_id_5, t0.user_id AS user_id_6 FROM oauth_access_token t0 WHERE t0.token = 'Mjk4OTgzZWM2NGVlNTFlMWUxYTA4NTVhYmE5NWQ1NjIwMTM3YjRmNzJlY2QzODg0ZTIyYTRiYTViNmIzMmZiNw' LIMIT 1;

SELECT 
  t0.random_id AS random_id_1, 
  t0.redirect_uris AS redirect_uris_2, 
  t0.secret AS secret_3, 
  t0.allowed_grant_types AS allowed_grant_types_4, 
  t0.id AS id_5, 
  t0.name AS name_6 
FROM 
  oauth_client t0 
WHERE 
  t0.id = ?

SELECT t0.random_id AS random_id_1, t0.redirect_uris AS redirect_uris_2, t0.secret AS secret_3, t0.allowed_grant_types AS allowed_grant_types_4, t0.id AS id_5, t0.name AS name_6 FROM oauth_client t0 WHERE t0.id = '6780db10-fb28-11e5-9c32-bc5ff4f7aef5';

SELECT 
  t0.token AS token_1, 
  t0.expires_at AS expires_at_2, 
  t0.scope AS scope_3, 
  t0.id AS id_4, 
  t0.client_id AS client_id_5, 
  t0.user_id AS user_id_6 
FROM 
  oauth_access_token t0 
WHERE 
  t0.token = ? 
LIMIT 
  1

SELECT t0.token AS token_1, t0.expires_at AS expires_at_2, t0.scope AS scope_3, t0.id AS id_4, t0.client_id AS client_id_5, t0.user_id AS user_id_6 FROM oauth_access_token t0 WHERE t0.token = 'Mjk4OTgzZWM2NGVlNTFlMWUxYTA4NTVhYmE5NWQ1NjIwMTM3YjRmNzJlY2QzODg0ZTIyYTRiYTViNmIzMmZiNw' LIMIT 1;

SELECT 
  a0_.id AS id_0, 
  a0_.article_code AS article_code_1, 
  a0_.ean AS ean_2, 
  a0_.sku AS sku_3, 
  a0_.name AS name_4, 
  a0_.description AS description_5, 
  a0_.unit AS unit_6, 
  a0_.width AS width_7, 
  a0_.height AS height_8, 
  a0_.depth AS depth_9, 
  a0_.weight AS weight_10, 
  a0_.is_extra AS is_extra_11, 
  a0_.color AS color_12, 
  a0_.stock_physical AS stock_physical_13, 
  a0_.stock_salable AS stock_salable_14, 
  a0_.stock_available AS stock_available_15, 
  a0_.stock_pickable AS stock_pickable_16, 
  a0_.stock_quarantaine AS stock_quarantaine_17, 
  a0_.stock_plannable AS stock_plannable_18, 
  a0_.stock_warning AS stock_warning_19, 
  a0_.stock_minimum AS stock_minimum_20, 
  a0_.packing_slip_visible AS packing_slip_visible_21, 
  a0_.expirable AS expirable_22, 
  a0_.pick_priority AS pick_priority_23, 
  a0_.using_serial_numbers AS using_serial_numbers_24, 
  a0_.serial_number_description AS serial_number_description_25, 
  a0_.created_at AS created_at_26, 
  a0_.modified_at AS modified_at_27, 
  a0_.deleted_at AS deleted_at_28, 
  a0_.article_id AS article_id_29, 
  a0_.created_by_id AS created_by_id_30, 
  a0_.modified_by_id AS modified_by_id_31, 
  a0_.deleted_by_id AS deleted_by_id_32 
FROM 
  app_variant a0_ 
  INNER JOIN app_article a1_ ON a0_.article_id = a1_.id 
  INNER JOIN app_customer a2_ ON a1_.customer_id = a2_.id 
WHERE 
  a0_.deleted_at IS NULL 
  AND a0_.article_code IN (?) 
  AND a2_.id = ? 
GROUP BY 
  a0_.id

SELECT a0_.id AS id_0, a0_.article_code AS article_code_1, a0_.ean AS ean_2, a0_.sku AS sku_3, a0_.name AS name_4, a0_.description AS description_5, a0_.unit AS unit_6, a0_.width AS width_7, a0_.height AS height_8, a0_.depth AS depth_9, a0_.weight AS weight_10, a0_.is_extra AS is_extra_11, a0_.color AS color_12, a0_.stock_physical AS stock_physical_13, a0_.stock_salable AS stock_salable_14, a0_.stock_available AS stock_available_15, a0_.stock_pickable AS stock_pickable_16, a0_.stock_quarantaine AS stock_quarantaine_17, a0_.stock_plannable AS stock_plannable_18, a0_.stock_warning AS stock_warning_19, a0_.stock_minimum AS stock_minimum_20, a0_.packing_slip_visible AS packing_slip_visible_21, a0_.expirable AS expirable_22, a0_.pick_priority AS pick_priority_23, a0_.using_serial_numbers AS using_serial_numbers_24, a0_.serial_number_description AS serial_number_description_25, a0_.created_at AS created_at_26, a0_.modified_at AS modified_at_27, a0_.deleted_at AS deleted_at_28, a0_.article_id AS article_id_29, a0_.created_by_id AS created_by_id_30, a0_.modified_by_id AS modified_by_id_31, a0_.deleted_by_id AS deleted_by_id_32 FROM app_variant a0_ INNER JOIN app_article a1_ ON a0_.article_id = a1_.id INNER JOIN app_customer a2_ ON a1_.customer_id = a2_.id WHERE a0_.deleted_at IS NULL AND a0_.article_code IN ('BBSK78D1760PSBK') AND a2_.id = '72028280-41fa-11ec-9930-92f6e0ca955a' GROUP BY a0_.id;

SELECT 
  a0_.id AS id_0, 
  a0_.code AS code_1, 
  a0_.name AS name_2, 
  a0_.plan_orders AS plan_orders_3, 
  a0_.plan_transfers AS plan_transfers_4, 
  a0_.shipping_template AS shipping_template_5, 
  a0_.middleware_id AS middleware_id_6, 
  a0_.business_to_business AS business_to_business_7, 
  a0_.cmr_number AS cmr_number_8, 
  a0_.publish_to_middleware AS publish_to_middleware_9, 
  a0_.last_stock_sync_at AS last_stock_sync_at_10, 
  a0_.created_at AS created_at_11, 
  a0_.modified_at AS modified_at_12, 
  a0_.deleted_at AS deleted_at_13, 
  a0_.address_id AS address_id_14, 
  a0_.created_by_id AS created_by_id_15, 
  a0_.modified_by_id AS modified_by_id_16, 
  a0_.deleted_by_id AS deleted_by_id_17 
FROM 
  app_customer a0_ 
WHERE 
  a0_.id IN (?)

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.plan_orders AS plan_orders_3, a0_.plan_transfers AS plan_transfers_4, a0_.shipping_template AS shipping_template_5, a0_.middleware_id AS middleware_id_6, a0_.business_to_business AS business_to_business_7, a0_.cmr_number AS cmr_number_8, a0_.publish_to_middleware AS publish_to_middleware_9, a0_.last_stock_sync_at AS last_stock_sync_at_10, a0_.created_at AS created_at_11, a0_.modified_at AS modified_at_12, a0_.deleted_at AS deleted_at_13, a0_.address_id AS address_id_14, a0_.created_by_id AS created_by_id_15, a0_.modified_by_id AS modified_by_id_16, a0_.deleted_by_id AS deleted_by_id_17 FROM app_customer a0_ WHERE a0_.id IN ('72028280-41fa-11ec-9930-92f6e0ca955a');

SELECT 
  t0.id AS id_1, 
  t0.created_at AS created_at_2, 
  t0.modified_at AS modified_at_3, 
  t0.deleted_at AS deleted_at_4, 
  t0.customer_id AS customer_id_5, 
  t0.paazl_shipment_option_id AS paazl_shipment_option_id_6, 
  t0.created_by_id AS created_by_id_7, 
  t0.modified_by_id AS modified_by_id_8, 
  t0.deleted_by_id AS deleted_by_id_9 
FROM 
  app_shipping_matrix t0 
WHERE 
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.modified_at AS modified_at_3, t0.deleted_at AS deleted_at_4, t0.customer_id AS customer_id_5, t0.paazl_shipment_option_id AS paazl_shipment_option_id_6, t0.created_by_id AS created_by_id_7, t0.modified_by_id AS modified_by_id_8, t0.deleted_by_id AS deleted_by_id_9 FROM app_shipping_matrix t0 WHERE t0.customer_id = '72028280-41fa-11ec-9930-92f6e0ca955a';

SELECT 
  t0.enabled AS enabled_1, 
  t0.salt AS salt_2, 
  t0.password AS password_3, 
  t0.last_login AS last_login_4, 
  t0.confirmation_token AS confirmation_token_5, 
  t0.password_requested_at AS password_requested_at_6, 
  t0.roles AS roles_7, 
  t0.id AS id_8, 
  t0.first_name AS first_name_9, 
  t0.last_name AS last_name_10, 
  t0.forklift_certified AS forklift_certified_11, 
  t0.is_customer AS is_customer_12, 
  t0.reverse_group_selection AS reverse_group_selection_13, 
  t0.last_request_at AS last_request_at_14, 
  t0.type AS type_15, 
  t0.created_at AS created_at_16, 
  t0.modified_at AS modified_at_17, 
  t0.deleted_at AS deleted_at_18, 
  t0.email AS email_19, 
  t0.email_canonical AS email_canonical_20, 
  t0.username AS username_21, 
  t0.username_canonical AS username_canonical_22, 
  t0.created_by_id AS created_by_id_23, 
  t0.modified_by_id AS modified_by_id_24, 
  t0.deleted_by_id AS deleted_by_id_25 
FROM 
  fos_user t0 
WHERE 
  t0.id IN (?)

SELECT t0.enabled AS enabled_1, t0.salt AS salt_2, t0.password AS password_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.roles AS roles_7, t0.id AS id_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.forklift_certified AS forklift_certified_11, t0.is_customer AS is_customer_12, t0.reverse_group_selection AS reverse_group_selection_13, t0.last_request_at AS last_request_at_14, t0.type AS type_15, t0.created_at AS created_at_16, t0.modified_at AS modified_at_17, t0.deleted_at AS deleted_at_18, t0.email AS email_19, t0.email_canonical AS email_canonical_20, t0.username AS username_21, t0.username_canonical AS username_canonical_22, t0.created_by_id AS created_by_id_23, t0.modified_by_id AS modified_by_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM fos_user t0 WHERE t0.id IN ('9fd3eff0-fb28-11e5-9c32-bc5ff4f7aef4');

SELECT 
  a0_.id AS id_0, 
  a0_.article_code AS article_code_1, 
  a0_.ean AS ean_2, 
  a0_.sku AS sku_3, 
  a0_.name AS name_4, 
  a0_.description AS description_5, 
  a0_.unit AS unit_6, 
  a0_.width AS width_7, 
  a0_.height AS height_8, 
  a0_.depth AS depth_9, 
  a0_.weight AS weight_10, 
  a0_.is_extra AS is_extra_11, 
  a0_.color AS color_12, 
  a0_.stock_physical AS stock_physical_13, 
  a0_.stock_salable AS stock_salable_14, 
  a0_.stock_available AS stock_available_15, 
  a0_.stock_pickable AS stock_pickable_16, 
  a0_.stock_quarantaine AS stock_quarantaine_17, 
  a0_.stock_plannable AS stock_plannable_18, 
  a0_.stock_warning AS stock_warning_19, 
  a0_.stock_minimum AS stock_minimum_20, 
  a0_.packing_slip_visible AS packing_slip_visible_21, 
  a0_.expirable AS expirable_22, 
  a0_.pick_priority AS pick_priority_23, 
  a0_.using_serial_numbers AS using_serial_numbers_24, 
  a0_.serial_number_description AS serial_number_description_25, 
  a0_.created_at AS created_at_26, 
  a0_.modified_at AS modified_at_27, 
  a0_.deleted_at AS deleted_at_28, 
  a0_.article_id AS article_id_29, 
  a0_.created_by_id AS created_by_id_30, 
  a0_.modified_by_id AS modified_by_id_31, 
  a0_.deleted_by_id AS deleted_by_id_32 
FROM 
  app_variant a0_ 
  INNER JOIN app_article a1_ ON a0_.article_id = a1_.id 
  INNER JOIN app_customer a2_ ON a1_.customer_id = a2_.id 
WHERE 
  a0_.deleted_at IS NULL 
  AND a0_.article_code IN (?) 
  AND a2_.id = ? 
GROUP BY 
  a0_.id

SELECT a0_.id AS id_0, a0_.article_code AS article_code_1, a0_.ean AS ean_2, a0_.sku AS sku_3, a0_.name AS name_4, a0_.description AS description_5, a0_.unit AS unit_6, a0_.width AS width_7, a0_.height AS height_8, a0_.depth AS depth_9, a0_.weight AS weight_10, a0_.is_extra AS is_extra_11, a0_.color AS color_12, a0_.stock_physical AS stock_physical_13, a0_.stock_salable AS stock_salable_14, a0_.stock_available AS stock_available_15, a0_.stock_pickable AS stock_pickable_16, a0_.stock_quarantaine AS stock_quarantaine_17, a0_.stock_plannable AS stock_plannable_18, a0_.stock_warning AS stock_warning_19, a0_.stock_minimum AS stock_minimum_20, a0_.packing_slip_visible AS packing_slip_visible_21, a0_.expirable AS expirable_22, a0_.pick_priority AS pick_priority_23, a0_.using_serial_numbers AS using_serial_numbers_24, a0_.serial_number_description AS serial_number_description_25, a0_.created_at AS created_at_26, a0_.modified_at AS modified_at_27, a0_.deleted_at AS deleted_at_28, a0_.article_id AS article_id_29, a0_.created_by_id AS created_by_id_30, a0_.modified_by_id AS modified_by_id_31, a0_.deleted_by_id AS deleted_by_id_32 FROM app_variant a0_ INNER JOIN app_article a1_ ON a0_.article_id = a1_.id INNER JOIN app_customer a2_ ON a1_.customer_id = a2_.id WHERE a0_.deleted_at IS NULL AND a0_.article_code IN ('SK78D1760A') AND a2_.id = '72028280-41fa-11ec-9930-92f6e0ca955a' GROUP BY a0_.id;

SELECT 
  a0_.id AS id_0, 
  a0_.article_code AS article_code_1, 
  a0_.ean AS ean_2, 
  a0_.sku AS sku_3, 
  a0_.name AS name_4, 
  a0_.description AS description_5, 
  a0_.unit AS unit_6, 
  a0_.width AS width_7, 
  a0_.height AS height_8, 
  a0_.depth AS depth_9, 
  a0_.weight AS weight_10, 
  a0_.is_extra AS is_extra_11, 
  a0_.color AS color_12, 
  a0_.stock_physical AS stock_physical_13, 
  a0_.stock_salable AS stock_salable_14, 
  a0_.stock_available AS stock_available_15, 
  a0_.stock_pickable AS stock_pickable_16, 
  a0_.stock_quarantaine AS stock_quarantaine_17, 
  a0_.stock_plannable AS stock_plannable_18, 
  a0_.stock_warning AS stock_warning_19, 
  a0_.stock_minimum AS stock_minimum_20, 
  a0_.packing_slip_visible AS packing_slip_visible_21, 
  a0_.expirable AS expirable_22, 
  a0_.pick_priority AS pick_priority_23, 
  a0_.using_serial_numbers AS using_serial_numbers_24, 
  a0_.serial_number_description AS serial_number_description_25, 
  a0_.created_at AS created_at_26, 
  a0_.modified_at AS modified_at_27, 
  a0_.deleted_at AS deleted_at_28, 
  a0_.article_id AS article_id_29, 
  a0_.created_by_id AS created_by_id_30, 
  a0_.modified_by_id AS modified_by_id_31, 
  a0_.deleted_by_id AS deleted_by_id_32 
FROM 
  app_variant a0_ 
WHERE 
  a0_.id IN (?)

SELECT a0_.id AS id_0, a0_.article_code AS article_code_1, a0_.ean AS ean_2, a0_.sku AS sku_3, a0_.name AS name_4, a0_.description AS description_5, a0_.unit AS unit_6, a0_.width AS width_7, a0_.height AS height_8, a0_.depth AS depth_9, a0_.weight AS weight_10, a0_.is_extra AS is_extra_11, a0_.color AS color_12, a0_.stock_physical AS stock_physical_13, a0_.stock_salable AS stock_salable_14, a0_.stock_available AS stock_available_15, a0_.stock_pickable AS stock_pickable_16, a0_.stock_quarantaine AS stock_quarantaine_17, a0_.stock_plannable AS stock_plannable_18, a0_.stock_warning AS stock_warning_19, a0_.stock_minimum AS stock_minimum_20, a0_.packing_slip_visible AS packing_slip_visible_21, a0_.expirable AS expirable_22, a0_.pick_priority AS pick_priority_23, a0_.using_serial_numbers AS using_serial_numbers_24, a0_.serial_number_description AS serial_number_description_25, a0_.created_at AS created_at_26, a0_.modified_at AS modified_at_27, a0_.deleted_at AS deleted_at_28, a0_.article_id AS article_id_29, a0_.created_by_id AS created_by_id_30, a0_.modified_by_id AS modified_by_id_31, a0_.deleted_by_id AS deleted_by_id_32 FROM app_variant a0_ WHERE a0_.id IN ('23798acf-778a-11ec-9930-92f6e0ca955a');

SELECT 
  t0.id AS id_1, 
  t0.external_reference AS external_reference_2, 
  t0.status AS status_3, 
  t0.batch_number AS batch_number_4, 
  t0.quantity AS quantity_5, 
  t0.is_external AS is_external_6, 
  t0.production_margin AS production_margin_7, 
  t0.created_at AS created_at_8, 
  t0.modified_at AS modified_at_9, 
  t0.deleted_at AS deleted_at_10, 
  t0.instructions AS instructions_11, 
  t0.prefix AS prefix_12, 
  t0.reference AS reference_13, 
  t0.customer_id AS customer_id_14, 
  t0.variant_id AS variant_id_15, 
  t0.warehouse_id AS warehouse_id_16, 
  t0.created_by_id AS created_by_id_17, 
  t0.modified_by_id AS modified_by_id_18, 
  t0.deleted_by_id AS deleted_by_id_19 
FROM 
  app_production_order t0 
WHERE 
  t0.customer_id = ? 
  AND t0.external_reference = ? 
  AND t0.deleted_at IS NULL

SELECT t0.id AS id_1, t0.external_reference AS external_reference_2, t0.status AS status_3, t0.batch_number AS batch_number_4, t0.quantity AS quantity_5, t0.is_external AS is_external_6, t0.production_margin AS production_margin_7, t0.created_at AS created_at_8, t0.modified_at AS modified_at_9, t0.deleted_at AS deleted_at_10, t0.instructions AS instructions_11, t0.prefix AS prefix_12, t0.reference AS reference_13, t0.customer_id AS customer_id_14, t0.variant_id AS variant_id_15, t0.warehouse_id AS warehouse_id_16, t0.created_by_id AS created_by_id_17, t0.modified_by_id AS modified_by_id_18, t0.deleted_by_id AS deleted_by_id_19 FROM app_production_order t0 WHERE t0.customer_id = '72028280-41fa-11ec-9930-92f6e0ca955a' AND t0.external_reference = 'PR2200000424' AND t0.deleted_at IS NULL;