GET http://mom.home.domroese.eu/category/photo-video

Query Metrics

5 Database Queries
5 Different statements
4.11 ms Query time
1 Invalid entities
57 Managed entities

Queries

Group similar statements

# Time Info
1 0.82 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 WHERE t0.slug = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  "photo-video"
]
2 1.18 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.deleted_at AS deleted_at_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.deleted_at IS NULL ORDER BY c0_.name ASC
Parameters:
[]
3 0.97 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 INNER JOIN product_category ON t0.id = product_category.product_id WHERE product_category.category_id = ?
Parameters:
[
  29
]
4 0.68 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:
[
  9
]
5 0.45 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
]

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

Entities Mapping

Class Mapping errors
App\Entity\Category No 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\ProductImage No errors.
App\Entity\ProductRating No errors.
App\Entity\Rental No errors.
App\Entity\ProductBooked No errors.