Query Metrics
10
Database Queries
10
Different statements
959.24 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.46 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.global_charge_type AS global_charge_type_3, t0.global_charge_value AS global_charge_value_4, t0.pricelist_parameters AS pricelist_parameters_5, t0.stock_string_replacements AS stock_string_replacements_6, t0.category_separator AS category_separator_7 FROM provider t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
3 | 33.91 ms |
SELECT DISTINCT(brand) AS brand FROM product_availability WHERE brand != '' ORDER BY brand ASC
Parameters:
[] |
4 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.global_charge_type AS global_charge_type_3, t0.global_charge_value AS global_charge_value_4, t0.pricelist_parameters AS pricelist_parameters_5, t0.stock_string_replacements AS stock_string_replacements_6, t0.category_separator AS category_separator_7 FROM provider t0
Parameters:
[] |
5 | 0.23 ms |
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.name AS name_3, t0.provider_id AS provider_id_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
6 | 446.00 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id) LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id) WHERE p1_.provider_name LIKE ? OR p1_.provider_part_number LIKE ?
Parameters:
[ "%BM235CLI%" "%BM235CLI%" ] |
7 | 476.77 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id) LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id) WHERE p1_.provider_name LIKE ? OR p1_.provider_part_number LIKE ? ORDER BY p0_.id DESC LIMIT 100
Parameters:
[ "%BM235CLI%" "%BM235CLI%" ] |
8 | 0.59 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1 FROM product p0_ INNER JOIN product_availability p1_ ON (p1_.product_id = p0_.id) LEFT JOIN product_connection p2_ ON (p2_.product_id = p0_.id) WHERE (p1_.provider_name LIKE ? OR p1_.provider_part_number LIKE ?) AND p0_.id IN (?) ORDER BY p0_.id DESC
Parameters:
[ "%BM235CLI%" "%BM235CLI%" [ 78396 ] ] |
9 | 0.32 ms |
SELECT t0.id AS id_1, t0.provider_name AS provider_name_2, t0.provider_article AS provider_article_3, t0.provider_part_number AS provider_part_number_4, t0.brand AS brand_5, t0.stock AS stock_6, t0.price_usd AS price_usd_7, t0.price_eur AS price_eur_8, t0.price_rub AS price_rub_9, t0.price_sale AS price_sale_10, t0.product_id AS product_id_11, t0.provider_id AS provider_id_12, t0.category_id AS category_id_13 FROM product_availability t0 WHERE t0.product_id = ?
Parameters:
[
78396
]
|
10 | 0.31 ms |
SELECT t0.id AS id_1, t0.date_connected AS date_connected_2, t0.insales_product_id AS insales_product_id_3, t0.insales_variant_id AS insales_variant_id_4, t0.insales_sku AS insales_sku_5, t0.product_id AS product_id_6 FROM product_connection t0 WHERE t0.product_id = ?
Parameters:
[
78396
]
|
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\Provider | No errors. |
App\Entity\Product | No errors. |
App\Entity\Category | No errors. |
App\Entity\ProductAvailability | No errors. |
App\Entity\ProductConnection | No errors. |