Query Metrics
217
Database Queries
13
Different statements
201.38 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
35.47 ms (17.61%) |
35 |
SELECT t0.id AS id_1, t0.handle AS handle_2, t0.name AS name_3, t0.price AS price_4, t0.model AS model_5, t0.status AS status_6, t0.image AS image_7, t0.add_date AS add_date_8, t0.description AS description_9, t0.uuid AS uuid_10, t0.component_price AS component_price_11, t0.container AS container_12, t0.container_size AS container_size_13, t0.storage_unit_length AS storage_unit_length_14, t0.storage_unit_width AS storage_unit_width_15, t0.storage_unit_height AS storage_unit_height_16, t0.storage_unit_volume AS storage_unit_volume_17, t0.storage_unit_container_size AS storage_unit_container_size_18, t0.storage_unit_pallet_size AS storage_unit_pallet_size_19, t0.storage_unit_total_liters AS storage_unit_total_liters_20, t0.storage_unit_weight AS storage_unit_weight_21, t0.sales_unit_factor AS sales_unit_factor_22, t0.deposit AS deposit_23, t0.purchasing_price AS purchasing_price_24, t0.tax_id AS tax_id_25, t0.unit_id AS unit_id_26, t0.contra_account_id AS contra_account_id_27 FROM product t0 INNER JOIN FollowUp ON t0.id = FollowUp.follow_up_product_id WHERE FollowUp.product_id = ?
Parameters:
[
509
]
|
34.52 ms (17.14%) |
35 |
SELECT t0.id AS id_1, t0.handle AS handle_2, t0.name AS name_3, t0.price AS price_4, t0.model AS model_5, t0.status AS status_6, t0.image AS image_7, t0.add_date AS add_date_8, t0.description AS description_9, t0.uuid AS uuid_10, t0.component_price AS component_price_11, t0.container AS container_12, t0.container_size AS container_size_13, t0.storage_unit_length AS storage_unit_length_14, t0.storage_unit_width AS storage_unit_width_15, t0.storage_unit_height AS storage_unit_height_16, t0.storage_unit_volume AS storage_unit_volume_17, t0.storage_unit_container_size AS storage_unit_container_size_18, t0.storage_unit_pallet_size AS storage_unit_pallet_size_19, t0.storage_unit_total_liters AS storage_unit_total_liters_20, t0.storage_unit_weight AS storage_unit_weight_21, t0.sales_unit_factor AS sales_unit_factor_22, t0.deposit AS deposit_23, t0.purchasing_price AS purchasing_price_24, t0.tax_id AS tax_id_25, t0.unit_id AS unit_id_26, t0.contra_account_id AS contra_account_id_27 FROM product t0 INNER JOIN FollowUp ON t0.id = FollowUp.product_id WHERE FollowUp.follow_up_product_id = ?
Parameters:
[
509
]
|
26.91 ms (13.36%) |
35 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.component_price AS component_price_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6, t0.sales_unit_factor AS sales_unit_factor_7, t0.product_id AS product_id_8, t0.price_group_id AS price_group_id_9, t0.customer_id AS customer_id_10, t0.unit_id AS unit_id_11 FROM scale_price t0 WHERE t0.product_id = ?
Parameters:
[
509
]
|
26.71 ms (13.26%) |
35 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.component_price AS component_price_3, t0.valid_from AS valid_from_4, t0.valid_to AS valid_to_5, t0.sales_unit_factor AS sales_unit_factor_6, t0.quantity AS quantity_7, t0.product_id AS product_id_8, t0.price_group_id AS price_group_id_9, t0.customer_id AS customer_id_10, t0.unit_id AS unit_id_11 FROM price t0 WHERE t0.product_id = ?
Parameters:
[
509
]
|
22.36 ms (11.10%) |
35 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_id AS product_id_3 FROM product_tag t0 WHERE t0.product_id = ?
Parameters:
[
509
]
|
21.20 ms (10.53%) |
35 |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.product_id AS product_id_3, t0.stock_id AS stock_id_4 FROM product_to_stock t0 WHERE t0.product_id = ?
Parameters:
[
509
]
|
12.96 ms (6.44%) |
1 |
SELECT p0_.id AS id_0, p0_.handle AS handle_1, p0_.name AS name_2, p0_.price AS price_3, p0_.model AS model_4, p0_.status AS status_5, p0_.image AS image_6, p0_.add_date AS add_date_7, p0_.description AS description_8, p0_.uuid AS uuid_9, p0_.component_price AS component_price_10, p0_.container AS container_11, p0_.container_size AS container_size_12, p0_.storage_unit_length AS storage_unit_length_13, p0_.storage_unit_width AS storage_unit_width_14, p0_.storage_unit_height AS storage_unit_height_15, p0_.storage_unit_volume AS storage_unit_volume_16, p0_.storage_unit_container_size AS storage_unit_container_size_17, p0_.storage_unit_pallet_size AS storage_unit_pallet_size_18, p0_.storage_unit_total_liters AS storage_unit_total_liters_19, p0_.storage_unit_weight AS storage_unit_weight_20, p0_.sales_unit_factor AS sales_unit_factor_21, p0_.deposit AS deposit_22, p0_.purchasing_price AS purchasing_price_23, p0_.tax_id AS tax_id_24, p0_.unit_id AS unit_id_25, p0_.contra_account_id AS contra_account_id_26 FROM product p0_ WHERE p0_.name LIKE ? ORDER BY p0_.name ASC
Parameters:
[
"%schni%"
]
|
9.61 ms (4.77%) |
1 |
SELECT p0_.id AS id_0, p0_.handle AS handle_1, p0_.name AS name_2, p0_.price AS price_3, p0_.model AS model_4, p0_.status AS status_5, p0_.image AS image_6, p0_.add_date AS add_date_7, p0_.description AS description_8, p0_.uuid AS uuid_9, p0_.component_price AS component_price_10, p0_.container AS container_11, p0_.container_size AS container_size_12, p0_.storage_unit_length AS storage_unit_length_13, p0_.storage_unit_width AS storage_unit_width_14, p0_.storage_unit_height AS storage_unit_height_15, p0_.storage_unit_volume AS storage_unit_volume_16, p0_.storage_unit_container_size AS storage_unit_container_size_17, p0_.storage_unit_pallet_size AS storage_unit_pallet_size_18, p0_.storage_unit_total_liters AS storage_unit_total_liters_19, p0_.storage_unit_weight AS storage_unit_weight_20, p0_.sales_unit_factor AS sales_unit_factor_21, p0_.deposit AS deposit_22, p0_.purchasing_price AS purchasing_price_23, p0_.tax_id AS tax_id_24, p0_.unit_id AS unit_id_25, p0_.contra_account_id AS contra_account_id_26 FROM product p0_ WHERE p0_.model LIKE ? ORDER BY p0_.model ASC
Parameters:
[
"%schni%"
]
|
3.04 ms (1.51%) |
1 |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.uuid AS uuid_3, t0.given_name AS given_name_4, t0.family_name AS family_name_5, t0.email AS email_6, t0.b2b AS b2b_7, t0.vat AS vat_8, t0.customer_group_id AS customer_group_id_9, t0.discount_id AS discount_id_10, t0.price_group_id AS price_group_id_11 FROM customer t0 WHERE t0.price_group_id = ?
Parameters:
[
2
]
|
3.01 ms (1.49%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.account_id AS account_id_5, t6.id AS id_7, t6.given_name AS given_name_8, t6.family_name AS family_name_9, t6.external_identifier AS external_identifier_10, t6.telephone AS telephone_11, t6.status AS status_12, t6.lock_pin AS lock_pin_13, t6.from_api AS from_api_14, t6.user_id AS user_id_15, t6.employee_group_id AS employee_group_id_16, t6.language_id AS language_id_17 FROM user t0 LEFT JOIN employee t6 ON t6.user_id = t0.id WHERE t0.id = ?
Parameters:
[
2
]
|
2.71 ms (1.34%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gtin AS gtin_3 FROM gtin t0 WHERE t0.gtin = ?
Parameters:
[
"schni"
]
|
1.72 ms (0.86%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tax AS tax_3, t0.uuid AS uuid_4, t0.contra_account_id AS contra_account_id_5 FROM tax t0 WHERE t0.id = ?
Parameters:
[
2
]
|
1.16 ms (0.58%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.create_date AS create_date_3, t0.uuid AS uuid_4 FROM price_group t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\Employee | No errors. |
App\Entity\EmployeeGroup | No errors. |
App\Entity\Language | No errors. |
App\Entity\ApiToken | No errors. |
App\Entity\ReceiptUser | No errors. |
App\Entity\Cart | No errors. |
App\Entity\ReceiptEmployee | No errors. |
App\Entity\Cashbox | No errors. |
App\Entity\Gtin | No errors. |
App\Entity\Product | No errors. |
App\Entity\Tax | No errors. |
App\Entity\Unit | No errors. |
App\Entity\ContraAccount | No errors. |
App\Entity\ProductTag | No errors. |
App\Entity\ProductToStock | No errors. |
App\Entity\Price | No errors. |
App\Entity\ScalePrice | No errors. |
App\Entity\CartProduct | No errors. |
App\Entity\ReceiptDocumentPosition | No errors. |
App\Entity\ReceiptProduct | No errors. |
App\Entity\Category | No errors. |
App\Entity\ReceiptTax | No errors. |
App\Entity\FiskalyVatRate | No errors. |
App\Entity\PriceGroup | No errors. |
App\Entity\Customer | No errors. |
App\Entity\ReceiptPrice | No errors. |
App\Entity\CustomerGroup | No errors. |
App\Entity\ReceiptPriceGroup | No errors. |
App\Entity\Discount | No errors. |
App\Entity\CustomerAddress | No errors. |
App\Entity\Receipt | No errors. |
App\Entity\ReceiptCustomer | No errors. |
App\Entity\ReceiptDocumentCustomer | No errors. |
App\Entity\Stock | No errors. |