https://www.kapilko.com/product/TA-HDplus

Query Metrics

10 Database Queries
9 Different statements
15.33 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 12.27 ms
SELECT COUNT(*) FROM configuration t0
Parameters:
[]
2 0.80 ms
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"
]
3 0.34 ms
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"
]
4 0.31 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:
[]
5 0.23 ms
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:
[]
6 0.31 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
]
7 0.27 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
]
8 0.26 ms
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
]
9 0.30 ms
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
]
10 0.24 ms
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:
[]

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.