Query Metrics
6
Database Queries
6
Different statements
3.84 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.50 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-23167" "de" ] |
| 2 | 0.72 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:
[
61
]
|
| 3 | 0.58 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:
[
30
]
|
| 4 | 0.35 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.29 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:
[
61
]
|
| 6 | 0.40 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:
[
61
]
|
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. |