Query Metrics
1
Database Queries
1
Different statements
0.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.89 ms (100.00%) |
1 |
SELECT o0_.id AS id_0, o0_.platform_id AS platform_id_1, o0_.source_id AS source_id_2, o0_.type_id AS type_id_3, o0_.client_id AS client_id_4, o0_.client_work_point_id AS client_work_point_id_5, o0_.status_id AS status_id_6, o0_.payment_method_id AS payment_method_id_7, o0_.payment_term AS payment_term_8, o0_.car_id AS car_id_9, o0_.driver_id AS driver_id_10, o0_.delivery_date AS delivery_date_11, o0_.production_day_id AS production_day_id_12, o0_.has_invoice AS has_invoice_13, o0_.invoice_series AS invoice_series_14, o0_.invoice_number AS invoice_number_15, o0_.user_invoice AS user_invoice_16, o0_.date_invoice AS date_invoice_17, o0_.paid AS paid_18, o0_.paid_amount AS paid_amount_19, o0_.unpaid_amount AS unpaid_amount_20, o0_.has_cargo_notice AS has_cargo_notice_21, o0_.cargo_notice_file AS cargo_notice_file_22, o0_.folder AS folder_23, o0_.user_created AS user_created_24, o0_.date_created AS date_created_25, o0_.is_active AS is_active_26, o0_.is_deleted AS is_deleted_27, c1_.name AS name_28, c1_.alias AS alias_29, c1_.payment_term AS payment_term_30, c2_.name AS name_31, u3_.firstname AS firstname_32, u3_.lastname AS lastname_33, c4_.name AS name_34, c4_.color AS color_35, c5_.name AS name_36, c5_.color AS color_37, c6_.label AS label_38, c6_.auto_check_payment_status AS auto_check_payment_status_39, c6_.check_payment_status AS check_payment_status_40, c7_.label AS label_41, c7_.logo AS logo_42, c7_.color AS color_43, p8_.date AS date_44, p8_.is_active AS is_active_45, d9_.firstname AS firstname_46, d9_.lastname AS lastname_47 FROM `order` o0_ LEFT JOIN user u3_ ON (o0_.user_created = u3_.id) LEFT JOIN client c1_ ON (o0_.client_id = c1_.id) LEFT JOIN client_work_point c2_ ON (o0_.client_work_point_id = c2_.id) LEFT JOIN config_order_source c4_ ON (o0_.source_id = c4_.id) LEFT JOIN config_order_status c5_ ON (o0_.status_id = c5_.id) LEFT JOIN config_payment_method c6_ ON (o0_.payment_method_id = c6_.id) LEFT JOIN config_platform c7_ ON (o0_.platform_id = c7_.platform_id) LEFT JOIN production_day p8_ ON (o0_.production_day_id = p8_.id) LEFT JOIN driver d9_ ON (o0_.driver_id = d9_.id) WHERE o0_.id = ? AND o0_.company_id = ? LIMIT 1
Parameters:
[ 9555 1 ]
|
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\Order | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\ClientWorkPoint | No errors. |
| App\Entity\ConfigOrderSource | No errors. |
| App\Entity\ConfigOrderStatus | No errors. |
| App\Entity\ConfigPaymentMethod | No errors. |
| App\Entity\ConfigPlatform | No errors. |
| App\Entity\ProductionDay | No errors. |
| App\Entity\Driver | No errors. |