Query Metrics
10
Database Queries
9
Different statements
15.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.27 ms (80.04%) |
1 |
SELECT COUNT(*) FROM configuration t0
Parameters:
[] |
|
0.80 ms (5.25%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_activ AS is_activ_3, t0.content AS content_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published_at AS published_at_8, t0.price AS price_9, t0.preview AS preview_10, t0.reference AS reference_11, t0.collection AS collection_12, t0.meta_description AS meta_description_13, t0.pdf_name AS pdf_name_14, t0.draft AS draft_15, t0.skeleton AS skeleton_16, t0.stock_quantity AS stock_quantity_17, t0.global_note AS global_note_18, t0.promotion AS promotion_19, t0.brand_id AS brand_id_20, t0.hard_component_id AS hard_component_id_21, t22.id AS id_23, t22.reference_id AS reference_id_24, t22.type AS type_25, t22.title AS title_26, t22.stock_status AS stock_status_27, t22.description AS description_28, t22.sku AS sku_29, t22.stock AS stock_30, t22.price_ht AS price_ht_31, t22.price_ttc AS price_ttc_32, t22.tax_rate AS tax_rate_33, t22.currency AS currency_34, t22.discount_amount AS discount_amount_35, t22.discount_percent AS discount_percent_36, t22.is_active AS is_active_37, t22.created_at AS created_at_38, t22.updated_at AS updated_at_39, t22.discountbegin_at AS discountbegin_at_40, t22.discountend_at AS discountend_at_41, t22.product_id AS product_id_42, t22.product_variant_id AS product_variant_id_43 FROM product t0 LEFT JOIN sale_item t22 ON t22.product_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
"TA-HDplus"
]
|
|
0.47 ms (3.05%) |
2 |
SELECT t0.id AS id_1, t0.is_online AS is_online_2, t0.email_reception AS email_reception_3, t0.email_sender AS email_sender_4, t0.meta_img_default AS meta_img_default_5, t0.website_url AS website_url_6, t0.icon AS icon_7, t0.javascript_add AS javascript_add_8, t0.css_add AS css_add_9, t0.default_image AS default_image_10, t0.plat_form AS plat_form_11, t0.analytics AS analytics_12, t0.cookiesconsent AS cookiesconsent_13, t0.header AS header_14, t0.contact_information AS contact_information_15, t0.cookies_information AS cookies_information_16, t0.is_header_login AS is_header_login_17, t0.skeleton_contact AS skeleton_contact_18, t0.application_key AS application_key_19, t0.is_initialized AS is_initialized_20, t0.header_component_id AS header_component_id_21, t0.footer_component_id AS footer_component_id_22, t0.contact_component_id AS contact_component_id_23 FROM configuration t0 LIMIT 1
Parameters:
[] |
|
0.34 ms (2.20%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3 FROM array_json t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"dynamic_link"
]
|
|
0.31 ms (2.04%) |
1 |
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:
[] |
|
0.31 ms (2.04%) |
1 |
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
]
|
|
0.30 ms (1.96%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.parent_id AS parent_id_3 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?
Parameters:
[
1
]
|
|
0.27 ms (1.74%) |
1 |
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
]
|
|
0.26 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.similar_id AS similar_id_3 FROM similar_product t0 WHERE t0.similar_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\Product | No errors. |
| App\Entity\Product\Brand | No errors. |
| App\Entity\Components\HardComponent | No errors. |
| App\Entity\Order\SaleItem | 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\CartItem | No errors. |
| App\Entity\Order\OrderItem | No errors. |
| App\Entity\User\Wish | No errors. |
| App\Entity\ArrayJson | No errors. |
| App\Entity\Product\ProductConfig | No errors. |
| App\Entity\Gallery\Gallery | No errors. |
| App\Entity\Gallery\CollectionGallery | No errors. |
| App\Entity\Gallery\GalleryCategory | No errors. |