Query Metrics

5 Database Queries
5 Different statements
3.15 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.98 ms
(31.06%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.slug AS slug_5, t0.extract_home AS extract_home_6, t0.extract_menu AS extract_menu_7, t0.cat_order AS cat_order_8, t0.icon AS icon_9, t0.shop AS shop_10, t0.machine AS machine_11, t0.show_caliber AS show_caliber_12, t0.parent_id AS parent_id_13 FROM category t0 WHERE t0.is_active = ? AND t0.parent_id IS NULL AND t0.machine = ? ORDER BY t0.cat_order ASC
Parameters:
[
  1
  1
]
0.67 ms
(21.22%)
1
SELECT i0_.id AS id_0, i0_.path AS path_1, i0_.external AS external_2, i0_.type AS type_3, i0_.name AS name_4, i0_.size AS size_5, i0_.short_description AS short_description_6, i0_.image_order AS image_order_7, i0_.is_active AS is_active_8, i0_.active_image AS active_image_9, i0_.gallery_id AS gallery_id_10, i0_.product_id AS product_id_11, i0_.page_id AS page_id_12 FROM image i0_ WHERE i0_.product_id = ? AND i0_.type IN (?, ?, ?) AND i0_.is_active = ? ORDER BY i0_.image_order ASC
Parameters:
[
  23
  "jpg"
  "jpeg"
  "png"
  1
]
0.64 ms
(20.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.title_tag AS title_tag_3, t0.meta_description AS meta_description_4, t0.slug AS slug_5, t0.description AS description_6, t0.price AS price_7, t0.created AS created_8, t0.is_active AS is_active_9, t0.extracted_home AS extracted_home_10, t0.image AS image_11, t0.price_eur AS price_eur_12, t0.description_link AS description_link_13, t0.pdf AS pdf_14, t0.most_sold AS most_sold_15, t0.new AS new_16, t0.sku AS sku_17, t0.short_name AS short_name_18, t0.model_name AS model_name_19, t0.width AS width_20, t0.height AS height_21, t0.lenght AS lenght_22, t0.diameter AS diameter_23, t0.weight AS weight_24, t0.literage AS literage_25, t0.slider AS slider_26, t0.order_slider AS order_slider_27, t0.slider_bg AS slider_bg_28, t0.order_extracted AS order_extracted_29, t0.short_text AS short_text_30, t0.partner_sku AS partner_sku_31, t0.partner_id AS partner_id_32, t0.partner_product_number AS partner_product_number_33, t0.image_external AS image_external_34, t0.kamado_extracted AS kamado_extracted_35, t0.remark AS remark_36, t0.posalji_upit AS posalji_upit_37, t0.price_eur_discount AS price_eur_discount_38, t0.not_available AS not_available_39, t0.video AS video_40, t0.shop AS shop_41, t0.machine AS machine_42, t0.image_tech_specs AS image_tech_specs_43, t0.order_cat AS order_cat_44, t0.order_shop AS order_shop_45, t0.gallery_id AS gallery_id_46, t0.category_id AS category_id_47, t0.color_id AS color_id_48, t0.material_id AS material_id_49, t0.measure_id AS measure_id_50, t0.partner_id AS partner_id_51 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "23"
]
0.47 ms
(15.04%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.image AS image_4, t0.slug AS slug_5, t0.extract_home AS extract_home_6, t0.extract_menu AS extract_menu_7, t0.cat_order AS cat_order_8, t0.icon AS icon_9, t0.shop AS shop_10, t0.machine AS machine_11, t0.show_caliber AS show_caliber_12, t0.parent_id AS parent_id_13 FROM category t0 WHERE t0.is_active = ? AND t0.machine = ? AND t0.extract_menu = ? ORDER BY t0.cat_order ASC
Parameters:
[
  1
  1
  1
]
0.39 ms
(12.22%)
1
SELECT i0_.id AS id_0, i0_.path AS path_1, i0_.external AS external_2, i0_.type AS type_3, i0_.name AS name_4, i0_.size AS size_5, i0_.short_description AS short_description_6, i0_.image_order AS image_order_7, i0_.is_active AS is_active_8, i0_.active_image AS active_image_9, i0_.gallery_id AS gallery_id_10, i0_.product_id AS product_id_11, i0_.page_id AS page_id_12 FROM image i0_ WHERE i0_.product_id = ? AND i0_.type IN (?, ?, ?, ?, ?) ORDER BY i0_.id ASC
Parameters:
[
  23
  "xls"
  "xlsx"
  "doc"
  "docx"
  "pdf"
]

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