http://ndp.geostocks.eu/manager/provider-order/1714/edit Return to referer URL

Query Metrics

14 Database Queries
8 Different statements
6.98 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.49 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  50
]
2 0.40 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ordered_at AS ordered_at_3, t0.delivered_estimation_at AS delivered_estimation_at_4, t0.completed AS completed_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.provider_id AS provider_id_19 FROM provider_order t0 WHERE t0.id = ?
Parameters:
[
  "1714"
]
3 0.48 ms
SELECT t0.id AS id_1, t0.price_unity_updated AS price_unity_updated_2, t0.completed AS completed_3, t0.comment AS comment_4, t0.delivery_edited AS delivery_edited_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.product_price AS product_price_8, t0.price_difference AS price_difference_9, t0.product_quantity AS product_quantity_10, t0.quantity_difference AS quantity_difference_11, t0.delivered AS delivered_12, t0.delivered_at AS delivered_at_13, t0.delivery_progress AS delivery_progress_14, t0.product_count AS product_count_15, t0.product_delivered_count AS product_delivered_count_16, t0.price AS price_17, t0.quantity AS quantity_18, t0.price_unity AS price_unity_19, t0.type AS type_20, t0.price_movement AS price_movement_21, t0.quantity_movement AS quantity_movement_22, t0.provider_order_id AS provider_order_id_23, t0.paper_id AS paper_id_24 FROM provider_order_item t0 WHERE t0.provider_order_id = ?
Parameters:
[
  1714
]
4 0.38 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.address AS address_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.country AS country_7, t0.phone AS phone_8, t0.company AS company_9, t0.paper_quality AS paper_quality_10, t0.paper_quality_percent AS paper_quality_percent_11, t0.created_at AS created_at_12, t0.archived AS archived_13 FROM provider t0 WHERE t0.id = ?
Parameters:
[
  36
]
5 0.40 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id = ?
Parameters:
[
  1039
]
6 0.34 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id = ?
Parameters:
[
  1040
]
7 0.33 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id = ?
Parameters:
[
  1042
]
8 0.32 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id = ?
Parameters:
[
  1366
]
9 0.35 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id = ?
Parameters:
[
  1054
]
10 0.32 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id = ?
Parameters:
[
  1308
]
11 0.35 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.id = ?
Parameters:
[
  1041
]
12 1.22 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.reference_internal AS reference_internal_3, t0.quantity_min AS quantity_min_4, t0.price_unity_initial AS price_unity_initial_5, t0.paper_quality AS paper_quality_6, t0.paper_quality_percent AS paper_quality_percent_7, t0.out_of_stock AS out_of_stock_8, t0.out_of_stock_at AS out_of_stock_at_9, t0.out_of_stock_quantity AS out_of_stock_quantity_10, t0.lowest_out_of_stock_at AS lowest_out_of_stock_at_11, t0.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_12, t0.created_at AS created_at_13, t0.archived AS archived_14, t0.name AS name_15, t0.type AS type_16, t0.width AS width_17, t0.grammage AS grammage_18, t0.mandrel AS mandrel_19, t0.diameter AS diameter_20, t0.price_unity AS price_unity_21, t0.price AS price_22, t0.quantity AS quantity_23, t0.provider_id AS provider_id_24, t0.paper_category_id AS paper_category_id_25 FROM paper t0 WHERE t0.provider_id = ?
Parameters:
[
  36
]
13 0.38 ms
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.name AS name_2, p0_.address AS address_3, p0_.postal_code AS postal_code_4, p0_.city AS city_5, p0_.country AS country_6, p0_.phone AS phone_7, p0_.company AS company_8, p0_.paper_quality AS paper_quality_9, p0_.paper_quality_percent AS paper_quality_percent_10, p0_.created_at AS created_at_11, p0_.archived AS archived_12 FROM provider p0_
Parameters:
[]
14 1.23 ms
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.reference_internal AS reference_internal_2, p0_.quantity_min AS quantity_min_3, p0_.price_unity_initial AS price_unity_initial_4, p0_.paper_quality AS paper_quality_5, p0_.paper_quality_percent AS paper_quality_percent_6, p0_.out_of_stock AS out_of_stock_7, p0_.out_of_stock_at AS out_of_stock_at_8, p0_.out_of_stock_quantity AS out_of_stock_quantity_9, p0_.lowest_out_of_stock_at AS lowest_out_of_stock_at_10, p0_.lowest_out_of_stock_quantity AS lowest_out_of_stock_quantity_11, p0_.created_at AS created_at_12, p0_.archived AS archived_13, p0_.name AS name_14, p0_.type AS type_15, p0_.width AS width_16, p0_.grammage AS grammage_17, p0_.mandrel AS mandrel_18, p0_.diameter AS diameter_19, p0_.price_unity AS price_unity_20, p0_.price AS price_21, p0_.quantity AS quantity_22, p0_.provider_id AS provider_id_23, p0_.paper_category_id AS paper_category_id_24 FROM paper p0_ WHERE p0_.provider_id = ?
Parameters:
[
  36
]

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\User No errors.
App\Entity\ProviderOrder No errors.
App\Entity\Provider No errors.
App\Entity\ProviderOrderItem No errors.
App\Entity\Paper No errors.
App\Entity\PaperProduct No errors.
App\Entity\PaperCategory No errors.
App\Entity\PaperStock No errors.
App\Entity\PaperStockGroup No errors.