Query Metrics

6 Database Queries
6 Different statements
5.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.82 ms
SELECT t0.id AS id_1, t0.machine_number AS machine_number_2, t0.manufacturer AS manufacturer_3, t0.manufacture_type AS manufacture_type_4, t0.manufacture_year AS manufacture_year_5, t0.control_name AS control_name_6, t0.control_type AS control_type_7, t0.country_of_origin AS country_of_origin_8, t0.delivery_time AS delivery_time_9, t0.freight_base AS freight_base_10, t0.new_machine AS new_machine_11, t0.machine_condition AS machine_condition_12, t0.description AS description_13, t0.youtube_codes AS youtube_codes_14, t0.thumbnail_url AS thumbnail_url_15, t0.thumbnail_description AS thumbnail_description_16, t0.post_id AS post_id_17, t0.is_special_price AS is_special_price_18, t0.price AS price_19, t0.currency AS currency_20, t0.sort AS sort_21, t0.lang_code AS lang_code_22, t0.is_archived AS is_archived_23, t0.new_images AS new_images_24, t0.overview_video_link AS overview_video_link_25, t0.highlighted_at AS highlighted_at_26, t0.warehouse_id AS warehouse_id_27, t0.contact_id AS contact_id_28, t0.sub_category_id AS sub_category_id_29 FROM product t0 WHERE t0.machine_number = ? AND t0.lang_code = ? LIMIT 1
Parameters:
[
  "1058-24280"
  "de"
]
2 0.69 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.description AS description_3, t0.type AS type_4, t0.product_id AS product_id_5 FROM media t0 WHERE t0.product_id = ?
Parameters:
[
  697
]
3 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.code AS code_4, t0.lang_code AS lang_code_5, t0.post_id AS post_id_6, t0.is_accessory AS is_accessory_7, t0.slug AS slug_8, t0.category_id AS category_id_9 FROM sub_category t0 WHERE t0.id = ?
Parameters:
[
  43
]
4 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.code AS code_4, t0.post_id AS post_id_5, t0.lang_code AS lang_code_6, t0.is_top_category AS is_top_category_7, t0.is_accessory AS is_accessory_8, t0.slug AS slug_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
  10
]
5 0.32 ms
SELECT t0.id AS id_1, t0.location AS location_2, t0.zip_code AS zip_code_3, t0.street AS street_4, t0.country AS country_5 FROM warehouse t0 WHERE t0.id = ?
Parameters:
[
  697
]
6 0.41 ms
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.unit AS unit_4, t0.sort AS sort_5, t0.search_id AS search_id_6, t0.product_id AS product_id_7 FROM product_details t0 WHERE t0.product_id = ?
Parameters:
[
  697
]

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\Product No errors.
App\Entity\Warehouse No errors.
App\Entity\Contact No errors.
App\Entity\SubCategory No errors.
App\Entity\ProductDetails No errors.
App\Entity\Media No errors.
App\Entity\Category No errors.