Query Metrics
2
Database Queries
2
Different statements
1.14 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.client AS client_3, t0.type AS type_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.details AS details_7, t0.is_single_piece_managed AS is_single_piece_managed_8, t0.is_external_code_application AS is_external_code_application_9, t0.iqp_num AS iqp_num_10, t0.pieces_for_box AS pieces_for_box_11, t0.boxes_for_pallet AS boxes_for_pallet_12, t0.pieces_for_pallet AS pieces_for_pallet_13, t0.pallet_type AS pallet_type_14, t0.pallet_weight AS pallet_weight_15, t0.pallet_width AS pallet_width_16, t0.pallet_depth AS pallet_depth_17, t0.pallet_height AS pallet_height_18, t0.box_weight AS box_weight_19, t0.box_width AS box_width_20, t0.box_depth AS box_depth_21, t0.box_height AS box_height_22, t0.status_id AS status_id_23, t0.iqc_code_id AS iqc_code_id_24, t0.product_id AS product_id_25 FROM prim_warehouse_production_order t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"19"
]
|
| 2 | 0.54 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.value AS value_3, t0.rfid AS rfid_4, t0.json_msg AS json_msg_5, t0.creation_date AS creation_date_6, t0.gs1_value AS gs1_value_7, t0.in_stock AS in_stock_8, t9.id AS id_10, t9.receipt_path AS receipt_path_11, t9.is_closed AS is_closed_12, t9.assign_date AS assign_date_13, t9.withdraw_date AS withdraw_date_14, t9.iqp_code_id AS iqp_code_id_15, t9.prize_id AS prize_id_16, t9.campaign_id AS campaign_id_17, t9.user_id AS user_id_18, t9.point_of_sale_id AS point_of_sale_id_19, t20.id AS id_21, t20.name AS name_22, t20.code AS code_23, t20.company AS company_24, t20.address AS address_25, t20.lat AS lat_26, t20.lng AS lng_27, t20.image_path AS image_path_28, t20.directory_path AS directory_path_29, t20.alert_email AS alert_email_30, t20.notes AS notes_31, t20.iqp_code_id AS iqp_code_id_32, t20.maintenance_category_id AS maintenance_category_id_33, t20.point_of_sale_id AS point_of_sale_id_34, t0.iqb_code_id AS iqb_code_id_35, t0.iqc_code_id AS iqc_code_id_36, t0.box_id AS box_id_37, t0.pallet_id AS pallet_id_38, t0.transfer_entrance_id AS transfer_entrance_id_39, t0.transfer_exit_id AS transfer_exit_id_40 FROM prim_iqp_code t0 LEFT JOIN prim_campaign_ticket t9 ON t9.iqp_code_id = t0.id LEFT JOIN prim_maintenance t20 ON t20.iqp_code_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"255633"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Warehouse\ProductionOrder | 1 |
| App\Entity\Warehouse\ProductionOrderStatus | 1 |
| App\Entity\IqcCode | 1 |
| App\Entity\Catalogue\Product | 1 |
| App\Entity\IqpCode | 1 |
| App\Entity\IqbCode | 1 |
| App\Entity\Warehouse\Box | 1 |
| App\Entity\Warehouse\Transfer | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Warehouse\ProductionOrder | No errors. |
| App\Entity\Warehouse\ProductionOrderStatus | No errors. |
| App\Entity\IqcCode | No errors. |
| App\Entity\Catalogue\Product | No errors. |
| App\Entity\Warehouse\Box | No errors. |
| App\Entity\Warehouse\Pallet | No errors. |
| App\Entity\IqpCode | No errors. |
| App\Entity\Campaign\Ticket | No errors. |
| App\Entity\Campaign\Prize | No errors. |
| App\Entity\Campaign\Campaign | No errors. |
| App\Entity\User | No errors. |
| App\Entity\PointOfSale | No errors. |
| App\Entity\Maintenance\Maintenance | No errors. |
| App\Entity\Maintenance\MaintenanceCategory | No errors. |
| App\Entity\IqbCode | No errors. |
| App\Entity\Warehouse\Transfer | No errors. |
| App\Entity\Read | No errors. |
| App\Entity\Shopping\Stock | No errors. |
| App\Entity\Warranty\Warranty | No errors. |