Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.18 ms Query time

1 Invalid entities

32 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	2.34 ms	SELECT DISTINCT a0_.id AS id_0, a0_.sort AS sort_1, a0_.name AS name_2 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ?) ORDER BY a0_.sort ASC, a0_.name ASC LIMIT 30 Parameters: [`"29132"`] View formatted query View runnable query Explain query SELECT DISTINCT a0_.id AS id_0, a0_.sort AS sort_1, a0_.name AS name_2 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN ( SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ? ) ORDER BY a0_.sort ASC, a0_.name ASC LIMIT 30 SELECT DISTINCT a0_.id AS id_0, a0_.sort AS sort_1, a0_.name AS name_2 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = '29132') ORDER BY a0_.sort ASC, a0_.name ASC LIMIT 30;
2	1.14 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.sort AS sort_3, a0_.main AS main_4, a1_.id AS id_5, a1_.name AS name_6, a1_.date_entered AS date_entered_7, a1_.slug AS slug_8, a1_.sort AS sort_9, a1_.show AS show_10, a1_.filter AS filter_11, a0_.attribute_id AS attribute_id_12, a1_.language_id AS language_id_13, a1_.translation_id AS translation_id_14 FROM attribute_items a0_ INNER JOIN attribute_items_products a3_ ON a0_.id = a3_.attribute_items_id INNER JOIN products p2_ ON p2_.id = a3_.products_id LEFT JOIN attributes a1_ ON a0_.attribute_id = a1_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ?) AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.sort ASC, a0_.name ASC Parameters: [`"29132" 438 308 307 298 289 280 304 292 244 279 275 228 285 300 302 284`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.sort AS sort_3, a0_.main AS main_4, a1_.id AS id_5, a1_.name AS name_6, a1_.date_entered AS date_entered_7, a1_.slug AS slug_8, a1_.sort AS sort_9, a1_.show AS show_10, a1_.filter AS filter_11, a0_.attribute_id AS attribute_id_12, a1_.language_id AS language_id_13, a1_.translation_id AS translation_id_14 FROM attribute_items a0_ INNER JOIN attribute_items_products a3_ ON a0_.id = a3_.attribute_items_id INNER JOIN products p2_ ON p2_.id = a3_.products_id LEFT JOIN attributes a1_ ON a0_.attribute_id = a1_.id WHERE a0_.id IN ( SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ? ) AND a0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY a0_.sort ASC, a0_.name ASC SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.sort AS sort_3, a0_.main AS main_4, a1_.id AS id_5, a1_.name AS name_6, a1_.date_entered AS date_entered_7, a1_.slug AS slug_8, a1_.sort AS sort_9, a1_.show AS show_10, a1_.filter AS filter_11, a0_.attribute_id AS attribute_id_12, a1_.language_id AS language_id_13, a1_.translation_id AS translation_id_14 FROM attribute_items a0_ INNER JOIN attribute_items_products a3_ ON a0_.id = a3_.attribute_items_id INNER JOIN products p2_ ON p2_.id = a3_.products_id LEFT JOIN attributes a1_ ON a0_.attribute_id = a1_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = '29132') AND a0_.id IN (438, 308, 307, 298, 289, 280, 304, 292, 244, 279, 275, 228, 285, 300, 302, 284) ORDER BY a0_.sort ASC, a0_.name ASC;
3	0.69 ms	SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ?) Parameters: [`"29132"`] View formatted query View runnable query Explain query SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN ( SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ? ) SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = '29132');

#▲

Time

Info

2.34 ms

SELECT DISTINCT a0_.id AS id_0, a0_.sort AS sort_1, a0_.name AS name_2 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ?) ORDER BY a0_.sort ASC, a0_.name ASC LIMIT 30

Parameters:

[
  "29132"
]

View formatted query View runnable query Explain query

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.sort AS sort_1,
  a0_.name AS name_2
FROM
  attribute_items a0_
  INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id
  INNER JOIN products p1_ ON p1_.id = a2_.products_id
  LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id
WHERE
  a0_.id IN (
    SELECT
      a4_.id
    FROM
      attribute_items a4_
      INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id
      INNER JOIN products p5_ ON p5_.id = a6_.products_id
    WHERE
      p5_.id = ?
  )
ORDER BY
  a0_.sort ASC,
  a0_.name ASC
LIMIT
  30

SELECT DISTINCT a0_.id AS id_0, a0_.sort AS sort_1, a0_.name AS name_2 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = '29132') ORDER BY a0_.sort ASC, a0_.name ASC LIMIT 30;

1.14 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.sort AS sort_3, a0_.main AS main_4, a1_.id AS id_5, a1_.name AS name_6, a1_.date_entered AS date_entered_7, a1_.slug AS slug_8, a1_.sort AS sort_9, a1_.show AS show_10, a1_.filter AS filter_11, a0_.attribute_id AS attribute_id_12, a1_.language_id AS language_id_13, a1_.translation_id AS translation_id_14 FROM attribute_items a0_ INNER JOIN attribute_items_products a3_ ON a0_.id = a3_.attribute_items_id INNER JOIN products p2_ ON p2_.id = a3_.products_id LEFT JOIN attributes a1_ ON a0_.attribute_id = a1_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ?) AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.sort ASC, a0_.name ASC

Parameters:

View formatted query View runnable query Explain query

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.sort AS sort_3,
  a0_.main AS main_4,
  a1_.id AS id_5,
  a1_.name AS name_6,
  a1_.date_entered AS date_entered_7,
  a1_.slug AS slug_8,
  a1_.sort AS sort_9,
  a1_.show AS show_10,
  a1_.filter AS filter_11,
  a0_.attribute_id AS attribute_id_12,
  a1_.language_id AS language_id_13,
  a1_.translation_id AS translation_id_14
FROM
  attribute_items a0_
  INNER JOIN attribute_items_products a3_ ON a0_.id = a3_.attribute_items_id
  INNER JOIN products p2_ ON p2_.id = a3_.products_id
  LEFT JOIN attributes a1_ ON a0_.attribute_id = a1_.id
WHERE
  a0_.id IN (
    SELECT
      a4_.id
    FROM
      attribute_items a4_
      INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id
      INNER JOIN products p5_ ON p5_.id = a6_.products_id
    WHERE
      p5_.id = ?
  )
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.sort ASC,
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.sort AS sort_3, a0_.main AS main_4, a1_.id AS id_5, a1_.name AS name_6, a1_.date_entered AS date_entered_7, a1_.slug AS slug_8, a1_.sort AS sort_9, a1_.show AS show_10, a1_.filter AS filter_11, a0_.attribute_id AS attribute_id_12, a1_.language_id AS language_id_13, a1_.translation_id AS translation_id_14 FROM attribute_items a0_ INNER JOIN attribute_items_products a3_ ON a0_.id = a3_.attribute_items_id INNER JOIN products p2_ ON p2_.id = a3_.products_id LEFT JOIN attributes a1_ ON a0_.attribute_id = a1_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = '29132') AND a0_.id IN (438, 308, 307, 298, 289, 280, 304, 292, 244, 279, 275, 228, 285, 300, 302, 284) ORDER BY a0_.sort ASC, a0_.name ASC;

0.69 ms

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = ?)

Parameters:

[
  "29132"
]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  attribute_items a0_
  INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id
  INNER JOIN products p1_ ON p1_.id = a2_.products_id
  LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id
WHERE
  a0_.id IN (
    SELECT
      a4_.id
    FROM
      attribute_items a4_
      INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id
      INNER JOIN products p5_ ON p5_.id = a6_.products_id
    WHERE
      p5_.id = ?
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM attribute_items a0_ INNER JOIN attribute_items_products a2_ ON a0_.id = a2_.attribute_items_id INNER JOIN products p1_ ON p1_.id = a2_.products_id LEFT JOIN attributes a3_ ON a0_.attribute_id = a3_.id WHERE a0_.id IN (SELECT a4_.id FROM attribute_items a4_ INNER JOIN attribute_items_products a6_ ON a4_.id = a6_.attribute_items_id INNER JOIN products p5_ ON p5_.id = a6_.products_id WHERE p5_.id = '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\AttributeItems	16
App\Entity\Attributes	16

Entities Mapping

Class	Mapping errors
App\Entity\AttributeItems	No errors.
App\Entity\Category	No errors.
App\Entity\Products	No errors.
App\Entity\Attributes	No errors.
App\Entity\Objects	No errors.
App\Entity\Languages	The association App\Entity\Languages#vacancies refers to the owning side field App\Entity\Vacancies#language which does not exist.
App\Entity\Projects	No errors.
App\Entity\Scannings	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping