Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 12
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Emails
• Notifications
• EasyAdmin
• Configuration

Query Metrics

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id

[]

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  lv_lagerort l0_
  LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id
  LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id
  LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id;

SELECT DISTINCT l0_.id AS id_0, l1_.id AS id_1, l2_.name AS name_2, l3_.name AS name_3, l0_.regalboden AS regalboden_4, l0_.segment AS segment_5 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id ORDER BY l1_.id ASC, l2_.name ASC, l3_.name ASC, l0_.regalboden ASC, l0_.segment ASC LIMIT 50 OFFSET 3550

[]

SELECT
  DISTINCT l0_.id AS id_0,
  l1_.id AS id_1,
  l2_.name AS name_2,
  l3_.name AS name_3,
  l0_.regalboden AS regalboden_4,
  l0_.segment AS segment_5
FROM
  lv_lagerort l0_
  LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id
  LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id
  LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id
ORDER BY
  l1_.id ASC,
  l2_.name ASC,
  l3_.name ASC,
  l0_.regalboden ASC,
  l0_.segment ASC
LIMIT
  50
OFFSET
  3550

SELECT DISTINCT l0_.id AS id_0, l1_.id AS id_1, l2_.name AS name_2, l3_.name AS name_3, l0_.regalboden AS regalboden_4, l0_.segment AS segment_5 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id ORDER BY l1_.id ASC, l2_.name ASC, l3_.name ASC, l0_.regalboden ASC, l0_.segment ASC LIMIT 50 OFFSET 3550;

SELECT l0_.id AS id_0, l0_.regal_id AS regal_id_1, l0_.segment AS segment_2, l0_.regalboden AS regalboden_3, l0_.zusatz AS zusatz_4, l0_.lager_id AS lager_id_5, l0_.lagerbereich_id AS lagerbereich_id_6, l0_.Bemerkungen AS Bemerkungen_7, l0_.delete_if_empty AS delete_if_empty_8, l0_.regal_id AS regal_id_9, l0_.lager_id AS lager_id_10, l0_.lagerbereich_id AS lagerbereich_id_11 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id WHERE l0_.id IN (?) ORDER BY l1_.id ASC, l2_.name ASC, l3_.name ASC, l0_.regalboden ASC, l0_.segment ASC

[
  4789
]

SELECT
  l0_.id AS id_0,
  l0_.regal_id AS regal_id_1,
  l0_.segment AS segment_2,
  l0_.regalboden AS regalboden_3,
  l0_.zusatz AS zusatz_4,
  l0_.lager_id AS lager_id_5,
  l0_.lagerbereich_id AS lagerbereich_id_6,
  l0_.Bemerkungen AS Bemerkungen_7,
  l0_.delete_if_empty AS delete_if_empty_8,
  l0_.regal_id AS regal_id_9,
  l0_.lager_id AS lager_id_10,
  l0_.lagerbereich_id AS lagerbereich_id_11
FROM
  lv_lagerort l0_
  LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id
  LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id
  LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id
WHERE
  l0_.id IN (?)
ORDER BY
  l1_.id ASC,
  l2_.name ASC,
  l3_.name ASC,
  l0_.regalboden ASC,
  l0_.segment ASC

SELECT l0_.id AS id_0, l0_.regal_id AS regal_id_1, l0_.segment AS segment_2, l0_.regalboden AS regalboden_3, l0_.zusatz AS zusatz_4, l0_.lager_id AS lager_id_5, l0_.lagerbereich_id AS lagerbereich_id_6, l0_.Bemerkungen AS Bemerkungen_7, l0_.delete_if_empty AS delete_if_empty_8, l0_.regal_id AS regal_id_9, l0_.lager_id AS lager_id_10, l0_.lagerbereich_id AS lagerbereich_id_11 FROM lv_lagerort l0_ LEFT JOIN lv_lager l1_ ON l0_.lager_id = l1_.id LEFT JOIN lv_lagerbereich l2_ ON l0_.lagerbereich_id = l2_.id LEFT JOIN lv_regal l3_ ON l0_.regal_id = l3_.id WHERE l0_.id IN (4789) ORDER BY l1_.id ASC, l2_.name ASC, l3_.name ASC, l0_.regalboden ASC, l0_.segment ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.attribut_id AS attribut_id_3 FROM lv_lagerbereich t0 ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.attribut_id AS attribut_id_3
FROM
  lv_lagerbereich t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.attribut_id AS attribut_id_3 FROM lv_lagerbereich t0 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2 FROM lv_regal t0 ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  lv_regal t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2 FROM lv_regal t0 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.to_billbee AS to_billbee_3, t0.is_store AS is_store_4, t0.multi AS multi_5 FROM lv_lager t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.to_billbee AS to_billbee_3,
  t0.is_store AS is_store_4,
  t0.multi AS multi_5
FROM
  lv_lager t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.to_billbee AS to_billbee_3, t0.is_store AS is_store_4, t0.multi AS multi_5 FROM lv_lager t0 WHERE t0.id = 4;