Query Metrics

9 Database Queries
8 Different statements
4.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LIMIT 20 OFFSET 60
Parameters:
[]
2 0.75 ms
SELECT p0_.name AS name_0, p0_.options AS options_1, p0_.description AS description_2, p0_.required AS required_3, p0_.reference_afimes AS reference_afimes_4, p0_.provider_selling_price AS provider_selling_price_5, p0_.provider_discount AS provider_discount_6, p0_.recommended_margin_rate AS recommended_margin_rate_7, p0_.comment AS comment_8, p0_.unit AS unit_9, p0_.additional_options AS additional_options_10, p0_.pricing_last_update AS pricing_last_update_11, p0_.document_id AS document_id_12, p0_.id AS id_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.category_id AS category_id_16, p0_.range_id AS range_id_17, p0_.serie_id AS serie_id_18, p0_.provider_id AS provider_id_19 FROM product p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"\x1EßK<v{`â–\f{ÌþÝÆ©"
  b"\x1EßK<x\x10a–³D{ÌþÝÆ©"
  b"\x1EßK<y²f¬˜s{ÌþÝÆ©"
  b"\x1EßK<{bk(¹l{ÌþÝÆ©"
  b"\x1EßK<}\rbp—c{ÌþÝÆ©"
  b"\x1EßK<~Ãdz¸*{ÌþÝÆ©"
  b"\x1E▀K<Çüc\x16ü¨{╠■¦ã®"
  b"\x1EßK<‚Lf2²?{ÌþÝÆ©"
  b"\x1EßK<„\x15a&µ\t{ÌþÝÆ©"
  b"\x1EßK<…Þn0Ši{ÌþÝÆ©"
  b"\x1EßK<‡¹cJ®À{ÌþÝÆ©"
  b"\x1EßK<‰§oƾ\x08{ÌþÝÆ©"
  b"\x1EßK<‹}g°­•{ÌþÝÆ©"
  b"\x1EßK<ŒÉgJ¥:{ÌþÝÆ©"
  b"\x1EßK<޾j\x1E»…{ÌþÝÆ©"
  b"\x1E▀K<É\x0Fl─úë{╠■¦ã®"
  b"\x1EßK<‘ôaʽâ{ÌþÝÆ©"
  b"\x1EßK<“Cc ´\v{ÌþÝÆ©"
  b"\x1EßK<”¢h^ª|{ÌþÝÆ©"
  b"\x1EßK<–›j\x02±\x03{ÌþÝÆ©"
]
3 0.59 ms
SELECT count(p0_.id) AS sclr_0 FROM product p0_
Parameters:
[]
4 0.45 ms
SELECT t0.name AS name_1, t0.id AS id_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  b"\x1EßK<J¸m$ª«{ÌþÝÆ©"
]
5 0.36 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.family_id AS family_id_3 FROM `range` t0 WHERE t0.id = ?
Parameters:
[
  b"\x1E▀K<[ÉcTür{╠■¦ã®"
]
6 0.34 ms
SELECT t0.name AS name_1, t0.id AS id_2 FROM family t0 WHERE t0.id = ?
Parameters:
[
  b"\x1EßK<JÇc⎸{ÌþÝÆ©"
]
7 0.34 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.family_id AS family_id_3 FROM serie t0 WHERE t0.id = ?
Parameters:
[
  b"\x1EßK<t¹k2žÓ{ÌþÝÆ©"
]
8 0.30 ms
SELECT t0.name AS name_1, t0.id AS id_2 FROM provider t0 WHERE t0.id = ?
Parameters:
[
  b"\x1EßK<[Àkb¨Ë{ÌþÝÆ©"
]
9 0.42 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.family_id AS family_id_3 FROM serie t0 WHERE t0.id = ?
Parameters:
[
  b"\x1EßK<‰ji<¥\{ÌþÝÆ©"
]

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\Range No errors.
App\Entity\Serie No errors.
App\Entity\Provider No errors.
App\Entity\ProductOption No errors.
App\Entity\Family No errors.