https://provider.iziclick.ru/product/view/155221

Query Metrics

9 Database Queries
3 Different statements
2.73 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.41 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.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t3.id AS id_4, t3.provider_name AS provider_name_5, t3.provider_article AS provider_article_6, t3.provider_part_number AS provider_part_number_7, t3.brand AS brand_8, t3.stock AS stock_9, t3.price_usd AS price_usd_10, t3.price_eur AS price_eur_11, t3.price_rub AS price_rub_12, t3.price_sale AS price_sale_13, t3.product_id AS product_id_14, t3.provider_id AS provider_id_15, t3.category_id AS category_id_16, t17.id AS id_18, t17.date_connected AS date_connected_19, t17.insales_product_id AS insales_product_id_20, t17.insales_variant_id AS insales_variant_id_21, t17.insales_sku AS insales_sku_22, t17.product_id AS product_id_23 FROM product t0 LEFT JOIN product_availability t3 ON t3.product_id = t0.id LEFT JOIN product_connection t17 ON t17.product_id = t0.id WHERE t0.id = ?
Parameters:
[
  "155221"
]
3 0.51 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 = ?
Parameters:
[
  2
]
4 0.26 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 = ?
Parameters:
[
  3
]
5 0.15 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 = ?
Parameters:
[
  6
]
6 0.15 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 = ?
Parameters:
[
  8
]
7 0.28 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 = ?
Parameters:
[
  18
]
8 0.14 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 = ?
Parameters:
[
  19
]
9 0.11 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 = ?
Parameters:
[
  9
]

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\Product No errors.
App\Entity\ProductAvailability No errors.
App\Entity\Provider No errors.
App\Entity\Category No errors.
App\Entity\ProductConnection No errors.