Query Metrics
3
Database Queries
3
Different statements
0.79 ms
Query time
0
Invalid entities
3
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.23 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"Intervalometers"
]
|
| 2 | 0.23 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "435" "en" "App\Entity\Product\Category" ] |
| 3 | 0.33 ms |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.discount_percent AS discount_percent_24, t0.available_at AS available_at_25, t0.offer AS offer_26, t0.cash_back AS cash_back_27, t0.ask_for_price AS ask_for_price_28, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_29, t0.warehouse_stock_quantity AS warehouse_stock_quantity_30, t0.warehouse_stock_reserved AS warehouse_stock_reserved_31, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_32, t0.warehouse_stock_immutable AS warehouse_stock_immutable_33, t0.price_gross_amount AS price_gross_amount_34, t0.price_gross_currency AS price_gross_currency_35, t0.price_with_discount_amount AS price_with_discount_amount_36, t0.price_with_discount_currency AS price_with_discount_currency_37, t0.price_url AS price_url_38, t0.price_comments AS price_comments_39, t0.supplier_discount AS supplier_discount_40, t0.special_discount AS special_discount_41, t0.customs_charges AS customs_charges_42, t0.expected_profit AS expected_profit_43, t0.accessories AS accessories_44, t0.original_price_amount AS original_price_amount_45, t0.original_price_currency AS original_price_currency_46, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_47, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_48, t0.dimensions_measurement_unit AS dimensions_measurement_unit_49, t0.dimensions_length AS dimensions_length_50, t0.dimensions_width AS dimensions_width_51, t0.dimensions_height AS dimensions_height_52, t0.dimensions_weight_unit AS dimensions_weight_unit_53, t0.dimensions_weight AS dimensions_weight_54, t0.dimensions_volume AS dimensions_volume_55, t0.type_id AS type_id_56, t0.main_image_id AS main_image_id_57, t0.manufacturer_id AS manufacturer_id_58, t0.discr FROM products t0 WHERE t0.slug = ? AND t0.discr IN ('product') LIMIT 1
Parameters:
[
"category-off-canvas.html"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| blk | doctrine.dbal.blk_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\Product\Category | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product\Category | No errors. |
| App\Entity\Common\Files\AppFile | No errors. |
| App\Entity\Common\Files\CategoryBanner | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| App\Entity\Product\Object\CommonProduct | No errors. |
| App\Entity\Product\WarehouseStock | No errors. |
| App\Entity\Common\Price | No errors. |
| App\Entity\Product\Object\BaseProduct | No errors. |
| App\Entity\Product\Object\Dimensions | No errors. |
| App\Entity\Product\Object\Product | No errors. |
| App\Entity\Product\ProductType | No errors. |
| App\Entity\Common\Files\ProductImage | No errors. |
| App\Entity\Product\ProductManufacturer | No errors. |
| App\Entity\Product\Object\ProductCategory | No errors. |
| App\Entity\Product\ProductExtraWebsite | No errors. |
| App\Entity\Product\ProductReference | No errors. |
| App\Entity\Product\Object\ProductAttributeValue | No errors. |
| App\Entity\Common\Files\ManufacturerLogo | No errors. |
| App\Entity\Product\Object\BaseRental | No errors. |