GET https://devsite.gewrgakopoulos.gr/shop/product/diakosmetiko-empros-phanou-ano-khromio-1

Query Metrics

8 Database Queries
7 Different statements
4.08 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.97 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.image_original_name AS image_original_name_5, t0.sku AS sku_6, t0.is_in_stock AS is_in_stock_7, t0.car_position AS car_position_8, t0.is_genuine AS is_genuine_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t13.id AS id_14, t13.cost AS cost_15, t13.regular AS regular_16, t13.wholesale AS wholesale_17, t13.created_at AS created_at_18, t13.updated_at AS updated_at_19, t13.product_id AS product_id_20, t21.id AS id_22, t21.local AS local_23, t21.g_ath AS g_ath_24, t21.g_thes AS g_thes_25, t21.g_kar AS g_kar_26, t21.g_lio AS g_lio_27, t21.other AS other_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30, t21.product_id AS product_id_31 FROM product t0 LEFT JOIN price t13 ON t13.product_id = t0.id LEFT JOIN stock t21 ON t21.product_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "diakosmetiko-empros-phanou-ano-khromio-1"
]
2 0.53 ms
SELECT t0.id AS id_1, t0.oem AS oem_2, t0.net_oem AS net_oem_3, t0.barcode AS barcode_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_code t0 WHERE t0.product_id = ?
Parameters:
[
  90898
]
3 0.42 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.model_year_id AS model_year_id_6 FROM product_model_year t0 WHERE t0.product_id = ?
Parameters:
[
  90898
]
4 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.model_code AS model_code_5, t0.image_name AS image_name_6, t0.image_original_name AS image_original_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.model_id AS model_id_10 FROM model_year t0 WHERE t0.id = ?
Parameters:
[
  1478
]
5 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.is_visible AS is_visible_5, t0.group_name AS group_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.maker_id AS maker_id_9 FROM model t0 WHERE t0.id = ?
Parameters:
[
  122
]
6 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.image_name AS image_name_5, t0.image_original_name AS image_original_name_6, t0.is_car_maker AS is_car_maker_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM maker t0 WHERE t0.id = ?
Parameters:
[
  17
]
7 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.model_code AS model_code_5, t0.image_name AS image_name_6, t0.image_original_name AS image_original_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.model_id AS model_id_10 FROM model_year t0 WHERE t0.id = ?
Parameters:
[
  1479
]
8 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.image_original_name AS image_original_name_5, t0.display_name AS display_name_6, t0.parent_id AS parent_id_7, t0.is_car_part AS is_car_part_8, t0.is_visible AS is_visible_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM category t0 WHERE t0.id = ?
Parameters:
[
  41
]

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\Category No errors.
App\Entity\Price No errors.
App\Entity\Stock No errors.
App\Entity\ProductCode No errors.
App\Entity\ProductModelYear No errors.
App\Entity\ModelYear No errors.
App\Entity\Model No errors.
App\Entity\Maker No errors.