Query Metrics
2
Database Queries
2
Different statements
3.74 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.16 ms |
SELECT t0.id AS id_1, t0.currency AS currency_2, t0.delivery_date AS delivery_date_3, t0.notes AS notes_4, t0.order_number AS order_number_5, t0.shipping_marks AS shipping_marks_6, t0.soc_number AS soc_number_7, t0.terms_of_delivery AS terms_of_delivery_8, t0.text AS text_9, t0.transportation AS transportation_10, t0.contact_person AS contact_person_11, t0.customer_contact_person AS customer_contact_person_12, t0.customer_date AS customer_date_13, t0.customer_reference_number AS customer_reference_number_14, t0.customer_updated AS customer_updated_15, t0.date AS date_16, t0.status AS status_17, t0.updated AS updated_18, t0.currency_exchange_rate AS currency_exchange_rate_19, t0.currency_exchange_rate_date AS currency_exchange_rate_date_20, t0.discount_description AS discount_description_21, t0.discount_percentage AS discount_percentage_22, t0.discount_value AS discount_value_23, t0.vat AS vat_24, t0.delivery_address_id AS delivery_address_id_25, t0.end_customer_id AS end_customer_id_26, t0.invoicing_address_id AS invoicing_address_id_27, t0.sales_case_id AS sales_case_id_28, t0.supplier_id AS supplier_id_29, t0.supplier_address_id AS supplier_address_id_30 FROM purchase_order t0 WHERE t0.id = ?
Parameters:
[
"3530"
]
|
| 2 | 2.58 ms |
SELECT t0.id AS id_1, t0.additional_info AS additional_info_2, t0.commodity_code AS commodity_code_3, t0.created AS created_4, t0.deliveries AS deliveries_5, t0.delivery_comments AS delivery_comments_6, t0.delivery_date_estimate AS delivery_date_estimate_7, t0.discount_percentage AS discount_percentage_8, t0.discount_value AS discount_value_9, t0.exclude_price AS exclude_price_10, t0.export_license_expiry_date AS export_license_expiry_date_11, t0.export_license_issue_date AS export_license_issue_date_12, t0.export_license_number_eu AS export_license_number_eu_13, t0.export_license_number_us AS export_license_number_us_14, t0.export_license_quantity_eu AS export_license_quantity_eu_15, t0.export_license_quantity_us AS export_license_quantity_us_16, t0.features_expiry_date AS features_expiry_date_17, t0.inventory AS inventory_18, t0.license_serial_numbers AS license_serial_numbers_19, t0.license_visible AS license_visible_20, t0.position AS position_21, t0.purchase_price AS purchase_price_22, t0.quantity AS quantity_23, t0.quantity_per_pci AS quantity_per_pci_24, t0.service_end AS service_end_25, t0.service_id AS service_id_26, t0.service_period_visible AS service_period_visible_27, t0.service_start AS service_start_28, t0.unit AS unit_29, t0.unit_price AS unit_price_30, t0.version_code AS version_code_31, t0.code AS code_32, t0.country_of_origin AS country_of_origin_33, t0.customs_tariff AS customs_tariff_34, t0.description AS description_35, t0.description_details AS description_details_36, t0.eccn_eu AS eccn_eu_37, t0.export_license AS export_license_38, t0.eccn_us AS eccn_us_39, t0.features AS features_40, t0.header AS header_41, t0.info AS info_42, t0.license_file AS license_file_43, t0.limited_availability AS limited_availability_44, t0.platform AS platform_45, t0.type AS type_46, t0.weight AS weight_47, t0.supplier_id AS supplier_id_48 FROM sales_item t0 INNER JOIN purchase_order_sales_item ON t0.id = purchase_order_sales_item.sales_item_id WHERE purchase_order_sales_item.purchase_order_id = ? ORDER BY t0.position ASC
Parameters:
[
3530
]
|
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\PurchaseOrder | No errors. |
| App\Entity\CompanyAddress | No errors. |
| App\Entity\CompanyDocumentAddress | No errors. |
| App\Entity\EndCustomer | No errors. |
| App\Entity\DocumentEndCustomer | No errors. |
| App\Entity\SalesCase | No errors. |
| App\Entity\Supplier | No errors. |
| App\Entity\DocumentVersion | No errors. |
| App\Entity\DocumentVersionPurchaseOrder | No errors. |
| App\Entity\LogEntry | No errors. |
| App\Entity\SalesItem | No errors. |
| App\Entity\TermsOfPaymentRow | No errors. |
| App\Entity\SalesCaseAttachment | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\AbstractInvoice | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\OrderConfirmation | No errors. |
| App\Entity\PackingList | No errors. |
| App\Entity\Product | No errors. |
| Nucleos\UserBundle\Model\User | No errors. |
| App\Entity\User | No errors. |