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 3400

[]

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
  3400

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 3400;

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

[
  2042
  2043
  2044
  2045
  2046
  2047
  2048
  2049
  5157
  5158
  5165
  5159
  5160
  5161
  5162
  5163
  5164
  5368
  4196
  2483
  2710
  2485
  2486
  2711
  2712
  2487
  2488
  2714
  2715
  2716
  2713
  2489
  2490
  5232
  2491
  2719
  2720
  2721
  2492
  2722
  2723
  2724
  2493
  2725
  2727
  2726
  2728
  2494
  2495
  2497
]

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 (2042, 2043, 2044, 2045, 2046, 2047, 2048, 2049, 5157, 5158, 5165, 5159, 5160, 5161, 5162, 5163, 5164, 5368, 4196, 2483, 2710, 2485, 2486, 2711, 2712, 2487, 2488, 2714, 2715, 2716, 2713, 2489, 2490, 5232, 2491, 2719, 2720, 2721, 2492, 2722, 2723, 2724, 2493, 2725, 2727, 2726, 2728, 2494, 2495, 2497) 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 = ?

[
  3
]

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 = 3;