POST https://preprod.covetonet.com/order/inventory/3/lines/add

Query Metrics

11 Database Queries
11 Different statements
5.11 ms Query time
0 Invalid entities
48 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
0.99 ms
(19.41%)
1
UPDATE inventory SET updated_at = ? WHERE id = ?
Parameters:
[
  "2026-10-05 14:07:48"
  3
]
0.57 ms
(11.17%)
1
SELECT t0.id AS id_1, t0.external_code AS external_code_2, t0.name AS name_3, t0.delivery_code AS delivery_code_4, t0.email AS email_5, t0.phone AS phone_6, t0.state AS state_7, t0.postal_code AS postal_code_8, t0.address AS address_9, t0.adrline1 AS adrline1_10, t0.adrline2 AS adrline2_11, t0.adrline3 AS adrline3_12, t0.city AS city_13, t0.is_spe_ali AS is_spe_ali_14, t0.depot_id AS depot_id_15, t0.is_packaging_prohibited AS is_packaging_prohibited_16, t0.updated_at AS updated_at_17 FROM customer_coveto t0 INNER JOIN auth_user_customer_coveto ON t0.id = auth_user_customer_coveto.customer_coveto_id WHERE auth_user_customer_coveto.auth_user_id = ?
Parameters:
[
  5
]
0.55 ms
(10.83%)
1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.promo_price AS promo_price_4, t0.promo_start_at AS promo_start_at_5, t0.promo_end_at AS promo_end_at_6, t0.product_id AS product_id_7 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  226
]
0.46 ms
(8.99%)
1
"COMMIT"
Parameters:
[]
0.43 ms
(8.40%)
1
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.code AS code_3, t0.name AS name_4, t0.price AS price_5, t0.custom AS custom_6, t0.quantity AS quantity_7, t0.counted_at AS counted_at_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.inventory_id AS inventory_id_12, t0.product_id AS product_id_13, t0.created_by_id AS created_by_id_14 FROM inventory_line t0 WHERE t0.inventory_id = ? AND t0.product_id = ? AND t0.deleted_at IS NULL AND t0.custom = ?
Parameters:
[
  3
  226
  0
]
0.42 ms
(8.28%)
1
SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7 FROM auth_user t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.41 ms
(8.09%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.gtin AS gtin_3, t0.ean AS ean_4, t0.cip AS cip_5, t0.external_code AS external_code_6, t0.weight AS weight_7, t0.amm_number AS amm_number_8, t0.legal_thermo AS legal_thermo_9, t0.legal_bio AS legal_bio_10, t0.legal_eco AS legal_eco_11, t0.legal_danger AS legal_danger_12, t0.legal_atb AS legal_atb_13, t0.is_spe_ali AS is_spe_ali_14, t0.is_colisage AS is_colisage_15, t0.vat_rate AS vat_rate_16, t0.deleted_at AS deleted_at_17, t0.replacement_external_code AS replacement_external_code_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.target_species AS target_species_21, t0.laboratory_code AS laboratory_code_22, t0.product_family_id AS product_family_id_23, t0.therapeutic_class_id AS therapeutic_class_id_24, t25.id AS id_26, t25.designation_commerciale AS designation_commerciale_27, t25.conditionnement AS conditionnement_28, t25.image_url AS image_url_29, t25.date_commercialisation AS date_commercialisation_30, t25.nature AS nature_31, t25.composition AS composition_32, t25.indications AS indications_33, t25.mode_administration AS mode_administration_34, t25.indications_utilisation AS indications_utilisation_35, t25.objectifs AS objectifs_36, t25.description_commerciale AS description_commerciale_37, t25.contre_indications AS contre_indications_38, t25.especes AS especes_39, t25.product_id AS product_id_40 FROM product t0 LEFT JOIN product_mediatheque t25 ON t25.product_id = t0.id WHERE t0.id = ?
Parameters:
[
  226
]
0.39 ms
(7.68%)
1
INSERT INTO inventory_line (uid, code, name, price, custom, quantity, counted_at, deleted_at, created_at, updated_at, inventory_id, product_id, created_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "1e79f608-9b06-4dc4-848a-0ff8453b9ced"
  "674996"
  "Agrafeuse manipler az unite"
  null
  0
  "1"
  "2026-10-05 14:07:48"
  null
  "2026-10-05 14:07:48"
  "2026-10-05 14:07:48"
  3
  226
  5
]
0.37 ms
(7.25%)
1
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.code AS code_3, t0.name AS name_4, t0.price AS price_5, t0.custom AS custom_6, t0.quantity AS quantity_7, t0.counted_at AS counted_at_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.inventory_id AS inventory_id_12, t0.product_id AS product_id_13, t0.created_by_id AS created_by_id_14 FROM inventory_line t0 WHERE t0.inventory_id = ?
Parameters:
[
  3
]
0.32 ms
(6.29%)
1
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.status AS status_2, i0_.closed_at AS closed_at_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.customer_coveto_id AS customer_coveto_id_6, i0_.created_by_id AS created_by_id_7, i0_.closed_by_id AS closed_by_id_8, i0_.merged_into_id AS merged_into_id_9 FROM inventory i0_ WHERE i0_.id = ? AND ((i0_.customer_coveto_id IS NULL AND i0_.created_by_id = ?) OR i0_.customer_coveto_id IN (?, ?, ?))
Parameters:
[
  3
  5
  2158
  2159
  2161
]
0.18 ms
(3.61%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
mediatheque doctrine.dbal.mediatheque_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\Inventory\InventoryLine 25
App\Entity\Product\Product 12
App\Entity\Customer\CustomerCoveto 3
App\Entity\Product\ProductPrice 2
App\Entity\Auth\AuthUser 1
App\Entity\Inventory\Inventory 1
App\Entity\Product\ProductLaboratory 1
App\Entity\Product\ProductFamily 1
App\Entity\Product\TherapeuticClass 1
App\Entity\Product\ProductMediatheque 1