POST https://dev.veka-ws.ovh/admin?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5CMaterialEntryCrudController&entityId=102

Query Metrics

17 Database Queries
15 Different statements
9.91 ms Query time
2 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.54 ms
(45.79%)
1
"COMMIT"
Parameters:
[]
1.58 ms
(15.97%)
1
UPDATE material_entry SET truck_plate = ?, arrival_time = ?, estimated_weight = ?, loaded_weight = ?, transport_cost = ?, status = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "GD500JA"
  "2026-04-01 08:11:00"
  "500"
  "33420"
  "800"
  "arrived"
  "2026-04-01 08:11:28"
  102
]
0.68 ms
(6.82%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = ?
Parameters:
[
  4949
]
0.56 ms
(5.60%)
2
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  16
]
0.34 ms
(3.40%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.position AS position_4, t0.is_vrac AS is_vrac_5, t0.always_bad AS always_bad_6, t0.created_at AS created_at_7, t0.parent_id AS parent_id_8 FROM material_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.32 ms
(3.28%)
1
SELECT t0.id AS id_1, t0.truck_plate AS truck_plate_2, t0.status AS status_3, t0.comment AS comment_4, t0.scheduled_date AS scheduled_date_5, t0.arrival_time AS arrival_time_6, t0.departure_time AS departure_time_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.validated_at AS validated_at_10, t0.estimated_box_count AS estimated_box_count_11, t0.estimated_weight AS estimated_weight_12, t0.loaded_weight AS loaded_weight_13, t0.empty_weight AS empty_weight_14, t0.stock_movement AS stock_movement_15, t0.is_delivered AS is_delivered_16, t0.transport_cost AS transport_cost_17, t0.supplier_id AS supplier_id_18, t0.carrier_id AS carrier_id_19, t0.forklift_operator_id AS forklift_operator_id_20 FROM material_entry t0 WHERE t0.id = ?
Parameters:
[
  "102"
]
0.31 ms
(3.13%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.status = ? AND r0_.id IN (?) ORDER BY r0_.name ASC
Parameters:
[
  1
  "4949"
]
0.28 ms
(2.80%)
1
SELECT t0.id AS id_1, t0.weight AS weight_2, t0.position AS position_3, t0.weighed_at AS weighed_at_4, t0.comment AS comment_5, t0.created_at AS created_at_6, t0.material_entry_id AS material_entry_id_7 FROM material_entry_weighing t0 WHERE t0.material_entry_id = ? ORDER BY t0.position ASC
Parameters:
[
  102
]
0.26 ms
(2.63%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.activity_id = ? AND r0_.id IN (?) ORDER BY r0_.name ASC
Parameters:
[
  14
  "5284"
]
0.24 ms
(2.41%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.material_category AS material_category_4, t0.legacy_material_type AS legacy_material_type_5, t0.packaging_type AS packaging_type_6, t0.material_entry_id AS material_entry_id_7, t0.material_type_id AS material_type_id_8, t0.box_id AS box_id_9, t0.box_category_id AS box_category_id_10 FROM material_entry_line t0 WHERE t0.material_entry_id = ?
Parameters:
[
  102
]
0.20 ms
(2.00%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.active AS active_2, m0_.position AS position_3, m0_.is_vrac AS is_vrac_4, m0_.always_bad AS always_bad_5, m0_.created_at AS created_at_6, m0_.parent_id AS parent_id_7 FROM material_type m0_ WHERE m0_.active = ? AND m0_.id IN (?) ORDER BY m0_.parent_id ASC, m0_.position ASC, m0_.name ASC
Parameters:
[
  1
  "1"
]
0.18 ms
(1.83%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.locale AS locale_6, u0_.favorite_apps AS favorite_apps_7 FROM user u0_ WHERE u0_.id IN (?)
Parameters:
[
  "22"
]
0.18 ms
(1.83%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM box_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.14 ms
(1.45%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1 FROM box_category b0_ WHERE b0_.id IN (?)
Parameters:
[
  "1"
]
0.10 ms
(1.06%)
1
"START TRANSACTION"
Parameters:
[]

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\User 2
App\Entity\Retailer 2
App\Entity\Activity 2
App\Entity\MaterialEntry 1
App\Entity\MaterialEntryLine 1
App\Entity\MaterialType 1
App\Entity\BoxCategory 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Log No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
App\Entity\MaterialEntry No errors.
App\Entity\Retailer No errors.
App\Entity\MaterialEntryLine No errors.
App\Entity\MaterialEntryPhoto No errors.
App\Entity\MaterialEntryWeighing No errors.
App\Entity\Activity No errors.
App\Entity\Network No errors.
App\Entity\Group No errors.
App\Entity\BoxQty No errors.
App\Entity\Contact
  • The mappings App\Entity\Contact#serviceList and App\Entity\Service#contacts are inconsistent with each other.
  • If association App\Entity\Contact#serviceList is many-to-one, then the inversed side App\Entity\Service#contacts has to be one-to-many.
App\Entity\Delivery
  • The mappings App\Entity\Delivery#carrier and App\Entity\Retailer#deliveries are inconsistent with each other.
App\Entity\Address No errors.
App\Entity\RetailerBoxSpec No errors.
App\Entity\Profiling No errors.
App\Entity\Iban No errors.
App\Entity\Preparation No errors.
App\Entity\SiretResult No errors.
App\Entity\MaterialType No errors.
App\Entity\Box No errors.
App\Entity\BoxCategory No errors.
App\Entity\BoxQualityItem No errors.