GET https://tudoestaqui.pt/crossdocking/

Response
200 OK
Browse referrer URL
IP
188.251.243.234
Profiled on
Token
00abd1

Query Metrics

454 Database Queries
17 Different statements
230.15 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
48.52 ms
(21.08%) 		155 
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 = ?
Parameters: 
[
  307
]
View formatted query    View runnable query    Explain query    View query backtrace
38.22 ms
(16.60%) 		91 
SELECT t0.id AS id_1, t0.external_market_id AS external_market_id_2, t0.external_ship_id AS external_ship_id_3, t0.imported_at AS imported_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.shipped_at AS shipped_at_7, t0.error_on AS error_on_8, t0.finished_at AS finished_at_9, t0.canceled_at AS canceled_at_10, t0.ship_from_name AS ship_from_name_11, t0.ship_from_vat AS ship_from_vat_12, t0.ship_from_phone AS ship_from_phone_13, t0.ship_from_address AS ship_from_address_14, t0.ship_from_zip_code AS ship_from_zip_code_15, t0.ship_from_city AS ship_from_city_16, t0.ship_from_country AS ship_from_country_17, t0.ship_to_name AS ship_to_name_18, t0.ship_to_vat AS ship_to_vat_19, t0.ship_to_email AS ship_to_email_20, t0.ship_to_phone AS ship_to_phone_21, t0.ship_to_address AS ship_to_address_22, t0.ship_to_zip_code AS ship_to_zip_code_23, t0.ship_to_city AS ship_to_city_24, t0.ship_to_country AS ship_to_country_25, t0.volumes AS volumes_26, t0.weight AS weight_27, t0.refund AS refund_28, t0.refund_value AS refund_value_29, t0.back AS back_30, t0.internal_reference AS internal_reference_31, t0.obs AS obs_32, t0.response_market AS response_market_33, t0.total_price AS total_price_34, t0.shipping_cost AS shipping_cost_35, t0.deleted_at AS deleted_at_36, t0.is_refund_received AS is_refund_received_37, t0.shipping_description AS shipping_description_38, t0.issuet_at AS issuet_at_39, t0.completed_at AS completed_at_40, t0.error_on_issue AS error_on_issue_41, t0.is_gift AS is_gift_42, t0.refund_received_at AS refund_received_at_43, t0.external_ship_cost AS external_ship_cost_44, t0.discount_value AS discount_value_45, t0.store_id AS store_id_46, t0.ship_provider_id AS ship_provider_id_47, t0.market_store_id AS market_store_id_48, t0.status_id AS status_id_49, t0.store_ship_provider_id AS store_ship_provider_id_50, t0.created_by_id AS created_by_id_51, t0.ship_provider_status_id AS ship_provider_status_id_52 FROM `order` t0 WHERE t0.id = ?
Parameters: 
[
  19492
]
View formatted query    View runnable query    Explain query    View query backtrace
31.73 ms
(13.79%) 		106 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.tax AS tax_4, t0.discount AS discount_5, t0.created_at AS created_at_6, t0.description AS description_7, t0.product_cost_unit AS product_cost_unit_8, t0.store_order_id AS store_order_id_9, t0.product_id AS product_id_10 FROM order_line t0 WHERE t0.store_order_id = ?
Parameters: 
[
  19492
]
View formatted query    View runnable query    Explain query    View query backtrace
28.68 ms
(12.46%) 		2 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20.82 ms
(9.04%) 		78 
SELECT t0.id AS id_1, t0.qty AS qty_2, t0.external_ship_id AS external_ship_id_3, t0.created_at AS created_at_4, t0.issue_at AS issue_at_5, t0.weight AS weight_6, t0.reference AS reference_7, t0.code_invoice AS code_invoice_8, t0.order_line_id AS order_line_id_9, t0.store_ship_provider_id AS store_ship_provider_id_10 FROM partial_line_track t0 WHERE t0.id = ?
Parameters: 
[
  21392
]
View formatted query    View runnable query    Explain query    View query backtrace
15.06 ms
(6.55%) 		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 order_line o1_ ON o0_.id = o1_.store_order_id INNER JOIN partial_line_track p2_ ON o1_.id = p2_.order_line_id WHERE o0_.status_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
14.04 ms
(6.10%) 		1 
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_.is_ready = 0 AND c0_.preparation_at IS NOT NULL AND c0_.separate_at IS NULL AND c0_.order_line_id IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13.59 ms
(5.91%) 		1 
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_.is_ready = 0 AND c0_.order_line_id IS NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12.17 ms
(5.29%) 		1 
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.issuet_at IS NOT NULL AND o0_.completed_at IS NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.98 ms
(0.86%) 		3 
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 ?
Parameters: 
[
  "INC"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(0.48%) 		5 
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.initials AS initials_4, t0.public_tracking AS public_tracking_5, t0.is_issue AS is_issue_6, t0.is_events AS is_events_7, t0.is_internal AS is_internal_8 FROM ship_provider t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(0.46%) 		1 
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 = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(0.41%) 		2 
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(0.40%) 		3 
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
Parameters: 
[
  7247
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.21%) 		2 
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 = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.20%) 		1 
SELECT t0.id AS id_1, t0.info_access AS info_access_2, t0.designation AS designation_3, t0.is_active AS is_active_4, t0.store_id AS store_id_5, t0.ship_provider_id AS ship_provider_id_6 FROM store_ship_provider t0 WHERE t0.is_active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.16%) 		1 
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 = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\OrderStatus No errors.
App\Entity\Order No errors.
App\Entity\UserPreparationOrder No errors.
App\Entity\LogScanning No errors.
App\Entity\OrderInvoiceDoc No errors.
App\Entity\LogDelete No errors.
App\Entity\Crossdocking No errors.
App\Entity\Product No errors.
App\Entity\OrderLine
  • The field 'App\Entity\OrderLine#discount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PartialLineTrack No errors.
App\Entity\StoreShipProvider No errors.
App\Entity\Store No errors.
App\Entity\ShipProvider No errors.
App\Entity\StoreRateLine No errors.
App\Entity\ShipInvoiceStore No errors.
App\Entity\Settings No errors.
App\Entity\Status No errors.
App\Entity\MarketStore No errors.
App\Entity\ShipProviderStatus No errors.
App\Entity\OrderShipProviderStatus No errors.
App\Entity\OrderRma No errors.
App\Entity\LogProduct No errors.
App\Entity\SupplierInvoice No errors.
App\Entity\Tax No errors.
App\Entity\Inventory No errors.
App\Entity\TrackingInventory No errors.
App\Entity\SupplierInvoiceLine No errors.
App\Entity\ProductMarketStore No errors.
App\Entity\ProductSync No errors.
App\Entity\OrderRmaLine No errors.
App\Entity\ProductInvoiceStore No errors.