Query Metrics
11
Database Queries
8
Different statements
4.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 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.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:
[
"1073"
]
|
| 3 | 0.63 ms |
SELECT p0_.id AS id_0, p0_.price_unity_updated AS price_unity_updated_1, p0_.completed AS completed_2, p0_.comment AS comment_3, p0_.delivery_edited AS delivery_edited_4, p0_.created_at AS created_at_5, p0_.archived AS archived_6, p0_.product_price AS product_price_7, p0_.price_difference AS price_difference_8, p0_.product_quantity AS product_quantity_9, p0_.quantity_difference AS quantity_difference_10, p0_.delivered AS delivered_11, p0_.delivered_at AS delivered_at_12, p0_.delivery_progress AS delivery_progress_13, p0_.product_count AS product_count_14, p0_.product_delivered_count AS product_delivered_count_15, p0_.price AS price_16, p0_.quantity AS quantity_17, p0_.price_unity AS price_unity_18, p0_.type AS type_19, p0_.price_movement AS price_movement_20, p0_.quantity_movement AS quantity_movement_21, p0_.provider_order_id AS provider_order_id_22, p0_.paper_id AS paper_id_23 FROM provider_order_item p0_ LEFT JOIN provider_order p1_ ON p0_.provider_order_id = p1_.id LEFT JOIN paper p2_ ON p0_.paper_id = p2_.id WHERE p2_.id = ? AND (p1_.completed = 0 OR p1_.delivered = 0) AND p0_.quantity_movement > 0 AND p1_.archived = 0 AND p0_.archived = 0 ORDER BY p0_.delivered_at ASC
Parameters:
[
1073
]
|
| 4 | 0.69 ms |
SELECT c0_.id AS id_0, c0_.price_ordered AS price_ordered_1, c0_.quantity_ordered AS quantity_ordered_2, c0_.production_at AS production_at_3, c0_.comment AS comment_4, c0_.detail AS detail_5, c0_.production_edited AS production_edited_6, c0_.created_at AS created_at_7, c0_.archived AS archived_8, c0_.type AS type_9, c0_.price_movement AS price_movement_10, c0_.quantity_movement AS quantity_movement_11, c0_.price AS price_12, c0_.quantity AS quantity_13, c0_.price_unity AS price_unity_14, c0_.paper_id AS paper_id_15, c0_.customer_order_id AS customer_order_id_16 FROM customer_order_item c0_ LEFT JOIN customer_order c1_ ON c0_.customer_order_id = c1_.id WHERE c0_.paper_id = ? AND c0_.quantity_movement < 0 AND c1_.archived = 0 AND c0_.archived = 0 ORDER BY c0_.production_at ASC
Parameters:
[
1073
]
|
| 5 | 0.31 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivered_at AS delivered_at_3, t0.ordered_at AS ordered_at_4, t0.in_preperation AS in_preperation_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.customer_id AS customer_id_10 FROM customer_order t0 WHERE t0.id = ?
Parameters:
[
7941
]
|
| 6 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.archived AS archived_4 FROM customer t0 WHERE t0.id = ?
Parameters:
[
138
]
|
| 7 | 0.27 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.delivered_at AS delivered_at_3, t0.ordered_at AS ordered_at_4, t0.in_preperation AS in_preperation_5, t0.created_at AS created_at_6, t0.archived AS archived_7, t0.price AS price_8, t0.quantity AS quantity_9, t0.customer_id AS customer_id_10 FROM customer_order t0 WHERE t0.id = ?
Parameters:
[
8020
]
|
| 8 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.archived AS archived_4 FROM customer t0 WHERE t0.id = ?
Parameters:
[
108
]
|
| 9 | 0.53 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:
[
1639
]
|
| 10 | 0.33 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
]
|
| 11 | 0.31 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:
[
1740
]
|
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\PaperStockGroup | No errors. |
| App\Entity\CustomerOrderItem | No errors. |
| App\Entity\ProviderOrderItem | No errors. |
| App\Entity\Paper | No errors. |
| App\Entity\Provider | No errors. |
| App\Entity\PaperCategory | No errors. |
| App\Entity\PaperProduct | No errors. |
| App\Entity\PaperStock | No errors. |
| App\Entity\ProviderOrder | No errors. |
| App\Entity\CustomerOrder | No errors. |
| App\Entity\Customer | No errors. |