Query Metrics
14
Database Queries
8
Different statements
6.98 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |