GET http://api-felso.inneti.net/api/product_infos?product.id=29132

Query Metrics

2 Database Queries
2 Different statements
2.09 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.63 ms
SELECT p0_.id AS id_0, p0_.key_name AS key_name_1, p0_.name AS name_2, p0_.value AS value_3, p0_.sort AS sort_4, p0_.data AS data_5, p0_.product_id AS product_id_6 FROM product_info p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.id IN (SELECT p2_.id FROM product_info p2_ INNER JOIN products p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ?) ORDER BY p0_.id DESC LIMIT 30
Parameters:
[
  "29132"
]
2 0.46 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product_info p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.id IN (SELECT p2_.id FROM product_info p2_ INNER JOIN products p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ?)
Parameters:
[
  "29132"
]

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\ProductInfo 7
App\Entity\Products 1

Entities Mapping

Class Mapping errors
App\Entity\ProductInfo No errors.
App\Entity\Products No errors.