Query Metrics
14
Database Queries
3
Different statements
5.16 ms
Query time
4
Invalid entities
14
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.47 ms (67.29%) |
12 |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"EMAIL"
]
|
1.35 ms (26.20%) |
1 |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.id = ?
Parameters:
[
3487
]
|
0.34 ms (6.51%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_code AS product_code_3, t0.description AS description_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.url AS url_7, t0.weight AS weight_8, t0.min_amount AS min_amount_9, t0.price_netto AS price_netto_10, t0.vat AS vat_11, t0.promotional_price AS promotional_price_12, t0.homepage AS homepage_13, t0.recommended AS recommended_14, t0.new AS new_15, t0.active AS active_16, t0.calculator AS calculator_17, t0.supplier_product_id AS supplier_product_id_18, t0.bestseller AS bestseller_19, t0.final_price AS final_price_20, t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21, t0.supplier_id AS supplier_id_22, t0.main_category_id AS main_category_id_23, t0.price_factor_id AS price_factor_id_24, t0.handling_cost_id AS handling_cost_id_25, t0.main_product_variant_file_id AS main_product_variant_file_id_26, t0.canonical_variant_id AS canonical_variant_id_27 FROM product t0 WHERE t0.id = ?
Parameters:
[
1701
]
|
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Settings | 9 |
App\Entity\ProductVariant | 1 |
App\Entity\Product | 1 |
App\Entity\Supplier | 1 |
App\Entity\Category | 1 |
App\Entity\ProductVariantFile | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\ProductVariant | No errors. |
App\Entity\Product |
|
App\Entity\ProductColor | No errors. |
App\Entity\ProductVariantFile | No errors. |
App\Entity\Settings | No errors. |
App\Entity\Supplier | No errors. |
App\Entity\Category | No errors. |
App\Entity\PriceFactor | No errors. |
App\Entity\MarkingPriceListHandlingCost |
|
App\Entity\ProductLocations | No errors. |
App\Entity\PriceLog | No errors. |
App\Entity\Reviews | No errors. |
App\Entity\File | No errors. |
App\Entity\MarkingPriceList |
|
App\Entity\PriceFactorItem | No errors. |
App\Entity\ProductLocationsTechnique |
|
App\Entity\ProductLocationFile | No errors. |