Symfony Profiler

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

Query Metrics

SELECT * FROM portal_categories WHERE slug = ? AND is_active = 1

[
  "fernwartung"
]

SELECT
  *
FROM
  portal_categories
WHERE
  slug = ?
  AND is_active = 1

SELECT * FROM portal_categories WHERE slug = 'fernwartung' AND is_active = 1;

INSERT INTO portal_statistics (category_id, view_count, last_accessed) 
                VALUES (?, 1, NOW()) 
                ON DUPLICATE KEY UPDATE 
                view_count = view_count + 1, 
                last_accessed = NOW()

[
  5
]

INSERT INTO portal_statistics (
  category_id, view_count, last_accessed
)
VALUES
  (
    ?,
    1,
    NOW()
  ) ON DUPLICATE KEY
UPDATE
  view_count = view_count + 1,
  last_accessed = NOW()

INSERT INTO portal_statistics (category_id, view_count, last_accessed) 
                VALUES (5, 1, NOW()) 
                ON DUPLICATE KEY UPDATE 
                view_count = view_count + 1, 
                last_accessed = NOW();

SELECT 
                    pct.id as assignment_id,
                    pct.sort_order,
                    pct.custom_name,
                    pct.custom_description,
                    pct.custom_image_url,
                    t.id as tag_id,
                    t.name,
                    t.description,
                    t.file_name,
                    t.file_size,
                    t.download_token,
                    t.is_public,
                    t.is_folder,
                    t.is_stream,
                    v.name as v_folder_name,
                    v.slug as v_folder_slug
                FROM portal_category_tags pct
                JOIN tags t ON pct.tag_id = t.id
                LEFT JOIN v_folders v ON t.v_folder_id = v.id
                WHERE pct.category_id = ?
                ORDER BY pct.sort_order ASC, t.name ASC

[
  5
]

SELECT
  pct.id as assignment_id,
  pct.sort_order,
  pct.custom_name,
  pct.custom_description,
  pct.custom_image_url,
  t.id as tag_id,
  t.name,
  t.description,
  t.file_name,
  t.file_size,
  t.download_token,
  t.is_public,
  t.is_folder,
  t.is_stream,
  v.name as v_folder_name,
  v.slug as v_folder_slug
FROM
  portal_category_tags pct
  JOIN tags t ON pct.tag_id = t.id
  LEFT JOIN v_folders v ON t.v_folder_id = v.id
WHERE
  pct.category_id = ?
ORDER BY
  pct.sort_order ASC,
  t.name ASC

SELECT 
                    pct.id as assignment_id,
                    pct.sort_order,
                    pct.custom_name,
                    pct.custom_description,
                    pct.custom_image_url,
                    t.id as tag_id,
                    t.name,
                    t.description,
                    t.file_name,
                    t.file_size,
                    t.download_token,
                    t.is_public,
                    t.is_folder,
                    t.is_stream,
                    v.name as v_folder_name,
                    v.slug as v_folder_slug
                FROM portal_category_tags pct
                JOIN tags t ON pct.tag_id = t.id
                LEFT JOIN v_folders v ON t.v_folder_id = v.id
                WHERE pct.category_id = 5
                ORDER BY pct.sort_order ASC, t.name ASC;