Query Metrics
6
Database Queries
6
Different statements
2.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.85 ms |
SELECT COUNT(*) FROM configuration t0
Parameters:
[] |
| 2 | 0.43 ms |
SELECT t0.id AS id_1, t0.list_class AS list_class_2, t0.list_class_mobile AS list_class_mobile_3, t0.list_class_tablet AS list_class_tablet_4, t0.template AS template_5, t0.design AS design_6, t0.is_header_component AS is_header_component_7, t0.skeleton_nav AS skeleton_nav_8, t0.skeleton AS skeleton_9, t0.is_ecommerce AS is_ecommerce_10, t0.hard_component_nav_id AS hard_component_nav_id_11, t0.hard_component_id AS hard_component_id_12 FROM product_config t0 LIMIT 1
Parameters:
[] |
| 3 | 0.50 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_activ AS is_activ_2, p0_.content AS content_3, p0_.slug AS slug_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.published_at AS published_at_7, p0_.price AS price_8, p0_.preview AS preview_9, p0_.reference AS reference_10, p0_.collection AS collection_11, p0_.meta_description AS meta_description_12, p0_.pdf_name AS pdf_name_13, p0_.draft AS draft_14, p0_.skeleton AS skeleton_15, p0_.stock_quantity AS stock_quantity_16, p0_.global_note AS global_note_17, p0_.promotion AS promotion_18, p0_.brand_id AS brand_id_19, p0_.hard_component_id AS hard_component_id_20 FROM product p0_ WHERE p0_.is_activ = ?
Parameters:
[
1
]
|
| 4 | 0.49 ms |
SELECT t0.id AS id_1, t0.reference_id AS reference_id_2, t0.type AS type_3, t0.title AS title_4, t0.stock_status AS stock_status_5, t0.description AS description_6, t0.sku AS sku_7, t0.stock AS stock_8, t0.price_ht AS price_ht_9, t0.price_ttc AS price_ttc_10, t0.tax_rate AS tax_rate_11, t0.currency AS currency_12, t0.discount_amount AS discount_amount_13, t0.discount_percent AS discount_percent_14, t0.is_active AS is_active_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.discountbegin_at AS discountbegin_at_18, t0.discountend_at AS discountend_at_19, t0.product_id AS product_id_20, t0.product_variant_id AS product_variant_id_21 FROM sale_item t0 WHERE t0.product_id = ?
Parameters:
[
1
]
|
| 5 | 0.36 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.image_id AS image_id_4, t0.product_variant_id AS product_variant_id_5 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
1
]
|
| 6 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.content AS content_4, t0.mentions AS mentions_5, t0.keywords AS keywords_6 FROM gallery t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Configuration | No errors. |
| App\Entity\Product\ProductConfig | No errors. |
| App\Entity\Components\HardComponent | No errors. |
| App\Entity\Product\Product | No errors. |
| App\Entity\Product\Brand | No errors. |
| App\Entity\Product\ProductVariant | No errors. |
| App\Entity\Product\ProductAttributeValue | No errors. |
| App\Entity\Product\ProductCategory | No errors. |
| App\Entity\Product\ProductImage | No errors. |
| App\Entity\Product\ProductTag | No errors. |
| App\Entity\Product\CustomerComment | No errors. |
| App\Entity\Product\CustomerNoteProduct | No errors. |
| App\Entity\Product\SimilarProduct | No errors. |
| App\Entity\Product\ProductBoughtTogether | No errors. |
| App\Entity\Order\SaleItem | No errors. |
| App\Entity\Order\CartItem | No errors. |
| App\Entity\Order\OrderItem | No errors. |
| App\Entity\User\Wish | No errors. |
| App\Entity\Gallery\Gallery | No errors. |
| App\Entity\Gallery\CollectionGallery | No errors. |
| App\Entity\Gallery\GalleryCategory | No errors. |