GET http://dev.mietomat.domr.ovh/product/3

Query Metrics

8 Database Queries
8 Different statements
18.02 ms Query time
1 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price_amount AS price_amount_4, t0.price_unit AS price_unit_5, t0.deposit_amount AS deposit_amount_6, t0.manual_included AS manual_included_7, t0.consumables_policy AS consumables_policy_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.view_count AS view_count_12, t0.owner_id AS owner_id_13, t0.city_id AS city_id_14 FROM product t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.14 ms
"START TRANSACTION"
Parameters:
[]
3 0.26 ms
UPDATE product SET view_count = ? WHERE id = ?
Parameters:
[
  14
  3
]
4 10.53 ms
"COMMIT"
Parameters:
[]
5 0.33 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  3
]
6 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.deleted_at AS deleted_at_6 FROM city t0 WHERE t0.id = ?
Parameters:
[
  50
]
7 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.deleted_at AS deleted_at_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
Parameters:
[
  3
]
8 5.87 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.product_id AS product_id_4 FROM product_booked t0 WHERE t0.product_id = ? ORDER BY t0.start_at ASC
Parameters:
[
  3
]

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\Product 1
App\Entity\User 1
App\Entity\City 1
App\Entity\Category 1

Entities Mapping

Class Mapping errors
App\Entity\Product
  • The field App\Entity\Product#booked is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductBooked#product does not contain the required 'inversedBy: "booked"' attribute.
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\Category No errors.
App\Entity\ProductImage No errors.
App\Entity\ProductRating No errors.
App\Entity\Rental No errors.
App\Entity\ProductBooked No errors.