Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT id, name as name, dbs_id as dbs_id FROM libraries WHERE dbs_id = ? AND active = 1

[
  "MV3015"
]

SELECT
  id,
  name as name,
  dbs_id as dbs_id
FROM
  libraries
WHERE
  dbs_id = ?
  AND active = 1

SELECT id, name as name, dbs_id as dbs_id FROM libraries WHERE dbs_id = 'MV3015' AND active = 1;

SELECT id, name, slug, active, auth_method FROM offers WHERE id = ? AND active = 1

[
  22
]

SELECT
  id,
  name,
  slug,
  active,
  auth_method
FROM
  offers
WHERE
  id = ?
  AND active = 1

SELECT id, name, slug, active, auth_method FROM offers WHERE id = 22 AND active = 1;

SELECT COUNT(*) 
            FROM license_pools lp
            JOIN license_pool_allocations lpa ON lp.id = lpa.pool_id
            WHERE lp.offer_id = ? AND lpa.library_id = ? AND lpa.allocation_value > 0

[
  22
  382
]

SELECT
  COUNT(*)
FROM
  license_pools lp
  JOIN license_pool_allocations lpa ON lp.id = lpa.pool_id
WHERE
  lp.offer_id = ?
  AND lpa.library_id = ?
  AND lpa.allocation_value > 0

SELECT COUNT(*) 
            FROM license_pools lp
            JOIN license_pool_allocations lpa ON lp.id = lpa.pool_id
            WHERE lp.offer_id = 22 AND lpa.library_id = 382 AND lpa.allocation_value > 0
        ;

SELECT setting_value FROM system_settings WHERE setting_key = ?

[
  "genios.offer_id"
]

SELECT
  setting_value
FROM
  system_settings
WHERE
  setting_key = ?

SELECT setting_value FROM system_settings WHERE setting_key = 'genios.offer_id';

SELECT DISTINCT lp.id
                FROM license_pools lp
                LEFT JOIN library_pool_assignments lpa ON lp.id = lpa.pool_id
                WHERE lp.offer_id = ? AND lp.active = 1
                  AND (
                    lpa.pool_id IS NULL  -- Pool hat keine Bibliothek-Beschränkungen
                    OR lpa.library_id = ?  -- Bibliothek ist explizit zugeordnet
                  )

[
  22
  382
]

SELECT
  DISTINCT lp.id
FROM
  license_pools lp
  LEFT JOIN library_pool_assignments lpa ON lp.id = lpa.pool_id
WHERE
  lp.offer_id = ?
  AND lp.active = 1
  AND (
    lpa.pool_id IS NULL -- Pool hat keine Bibliothek-Beschränkungen
    OR lpa.library_id = ? -- Bibliothek ist explizit zugeordnet
  )

SELECT DISTINCT lp.id
                FROM license_pools lp
                LEFT JOIN library_pool_assignments lpa ON lp.id = lpa.pool_id
                WHERE lp.offer_id = 22 AND lp.active = 1
                  AND (
                    lpa.pool_id IS NULL  -- Pool hat keine Bibliothek-Beschränkungen
                    OR lpa.library_id = 382  -- Bibliothek ist explizit zugeordnet
                  )
            ;

SELECT DISTINCT l.id, l.title, l.description, l.image_url, l.external_id, l.url,
                       l.fach, l.area, l.topic, l.klassenstufen, l.dauer, l.medium, l.created_at, l.valid_from
                FROM lessons l
                LEFT JOIN lesson_pool_assignments lpas ON l.id = lpas.lesson_id
                WHERE l.offer_id = ? AND l.active = 1
                  AND (
                    lpas.lesson_id IS NULL  -- Lesson hat keine Pool-Beschränkungen (gilt für alle Pools)
             OR lpas.pool_id IN (?)) ORDER BY l.created_at DESC, l.title LIMIT 20 OFFSET 0

[
  22
  14
]

SELECT
  DISTINCT l.id,
  l.title,
  l.description,
  l.image_url,
  l.external_id,
  l.url,
  l.fach,
  l.area,
  l.topic,
  l.klassenstufen,
  l.dauer,
  l.medium,
  l.created_at,
  l.valid_from
FROM
  lessons l
  LEFT JOIN lesson_pool_assignments lpas ON l.id = lpas.lesson_id
WHERE
  l.offer_id = ?
  AND l.active = 1
  AND (
    lpas.lesson_id IS NULL -- Lesson hat keine Pool-Beschränkungen (gilt für alle Pools)
    OR lpas.pool_id IN (?)
  )
ORDER BY
  l.created_at DESC,
  l.title
LIMIT
  20
OFFSET
  0

SELECT DISTINCT l.id, l.title, l.description, l.image_url, l.external_id, l.url,
                       l.fach, l.area, l.topic, l.klassenstufen, l.dauer, l.medium, l.created_at, l.valid_from
                FROM lessons l
                LEFT JOIN lesson_pool_assignments lpas ON l.id = lpas.lesson_id
                WHERE l.offer_id = 22 AND l.active = 1
                  AND (
                    lpas.lesson_id IS NULL  -- Lesson hat keine Pool-Beschränkungen (gilt für alle Pools)
             OR lpas.pool_id IN (14)) ORDER BY l.created_at DESC, l.title LIMIT 20 OFFSET 0;

SELECT COUNT(DISTINCT l.id) FROM lessons l
                LEFT JOIN lesson_pool_assignments lpas ON l.id = lpas.lesson_id
                WHERE l.offer_id = ? AND l.active = 1
                  AND (
                    lpas.lesson_id IS NULL
             OR lpas.pool_id IN (?))

[
  22
  14
]

SELECT
  COUNT(DISTINCT l.id)
FROM
  lessons l
  LEFT JOIN lesson_pool_assignments lpas ON l.id = lpas.lesson_id
WHERE
  l.offer_id = ?
  AND l.active = 1
  AND (
    lpas.lesson_id IS NULL
    OR lpas.pool_id IN (?)
  )

SELECT COUNT(DISTINCT l.id) FROM lessons l
                LEFT JOIN lesson_pool_assignments lpas ON l.id = lpas.lesson_id
                WHERE l.offer_id = 22 AND l.active = 1
                  AND (
                    lpas.lesson_id IS NULL
             OR lpas.pool_id IN (14));