POST https://api.carandbikes.fr/api/get/productDetail

Query Metrics

6 Database Queries
6 Different statements
1.81 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.description AS description_4, t0.technical_description AS technical_description_5, t0.created_at AS created_at_6, t0.title_seo AS title_seo_7, t0.description_seo AS description_seo_8, t0.keywords_seo AS keywords_seo_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
2 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.fa_icon AS fa_icon_3, t0.title AS title_4, t0.text AS text_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.title_seo AS title_seo_8, t0.description_seo AS description_seo_9, t0.keywords_seo AS keywords_seo_10, t0.url AS url_11 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
Parameters:
[
  9
]
3 0.24 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
4 0.24 ms
SELECT p0_.url AS url_0 FROM product_video p0_ WHERE p0_.product_id = ?
Parameters:
[
  9
]
5 0.27 ms
SELECT p0_.file_name AS file_name_0, p0_.name AS name_1 FROM product_file p0_ WHERE p0_.product_id = ?
Parameters:
[
  9
]
6 0.30 ms
SELECT t0.id AS id_1, t0.variant_name AS variant_name_2, t0.price AS price_3, t0.description AS description_4, t0.quantity AS quantity_5, t0.available AS available_6, t0.created_at AS created_at_7, t0.main_product_variant AS main_product_variant_8, t0.weight AS weight_9, t0.length AS length_10, t0.width AS width_11, t0.height AS height_12, t0.id_prestashop AS id_prestashop_13, t0.presta_declinaison_id AS presta_declinaison_id_14, t0.reference AS reference_15, t0.promo_status AS promo_status_16, t0.promo_percentage AS promo_percentage_17, t0.product_id AS product_id_18 FROM product_variant t0 WHERE t0.product_id = ? ORDER BY t0.main_product_variant DESC
Parameters:
[
  9
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Category 3
App\Entity\ProductImage 3
App\Entity\Product 1
App\Entity\ProductVariant 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\ProductImage No errors.
App\Entity\ProductVariant No errors.
App\Entity\Category No errors.
App\Entity\UnderCategory No errors.
App\Entity\ProductVideo No errors.
App\Entity\ProductFile No errors.