Symfony Profiler

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

Query Metrics

SELECT setting_value FROM site_settings WHERE setting_key = 'maintenance_pages'

[]

SELECT
  setting_value
FROM
  site_settings
WHERE
  setting_key = 'maintenance_pages'

SELECT setting_value FROM site_settings WHERE setting_key = 'maintenance_pages';

SELECT * FROM weapons WHERE id = ?

[
  493
]

SELECT
  *
FROM
  weapons
WHERE
  id = ?

SELECT * FROM weapons WHERE id = 493;

SELECT wsc.name, ws.value
            FROM weapon_stats ws
            JOIN weapon_stat_categories wsc ON ws.stat_category_id = wsc.id
            WHERE ws.weapon_id = ? AND ws.value IS NOT NULL AND ws.value != ''
            ORDER BY wsc.name ASC

[
  493
]

SELECT
  wsc.name,
  ws.value
FROM
  weapon_stats ws
  JOIN weapon_stat_categories wsc ON ws.stat_category_id = wsc.id
WHERE
  ws.weapon_id = ?
  AND ws.value IS NOT NULL
  AND ws.value != ''
ORDER BY
  wsc.name ASC

SELECT wsc.name, ws.value
            FROM weapon_stats ws
            JOIN weapon_stat_categories wsc ON ws.stat_category_id = wsc.id
            WHERE ws.weapon_id = 493 AND ws.value IS NOT NULL AND ws.value != ''
            ORDER BY wsc.name ASC
        ;

SELECT s.id, s.name, s.level, s.price_permanent, s.price_buy_once, s.is_mod 
                FROM scopes s JOIN compatibility c ON s.id = c.scope_id 
                WHERE c.weapon_id = ? AND s.is_hidden = 0 ORDER BY s.name

[
  493
]

SELECT
  s.id,
  s.name,
  s.level,
  s.price_permanent,
  s.price_buy_once,
  s.is_mod
FROM
  scopes s
  JOIN compatibility c ON s.id = c.scope_id
WHERE
  c.weapon_id = ?
  AND s.is_hidden = 0
ORDER BY
  s.name

SELECT s.id, s.name, s.level, s.price_permanent, s.price_buy_once, s.is_mod 
                FROM scopes s JOIN compatibility c ON s.id = c.scope_id 
                WHERE c.weapon_id = 493 AND s.is_hidden = 0 ORDER BY s.name
            ;

SELECT sp.id, sp.name, sp.level, sp.price_permanent, sp.price_buy_once, sp.is_mod 
                FROM suppressors sp JOIN compatibility c ON sp.id = c.suppressor_id 
                WHERE c.weapon_id = ? AND sp.is_hidden = 0 ORDER BY sp.name

[
  493
]

SELECT
  sp.id,
  sp.name,
  sp.level,
  sp.price_permanent,
  sp.price_buy_once,
  sp.is_mod
FROM
  suppressors sp
  JOIN compatibility c ON sp.id = c.suppressor_id
WHERE
  c.weapon_id = ?
  AND sp.is_hidden = 0
ORDER BY
  sp.name

SELECT sp.id, sp.name, sp.level, sp.price_permanent, sp.price_buy_once, sp.is_mod 
                FROM suppressors sp JOIN compatibility c ON sp.id = c.suppressor_id 
                WHERE c.weapon_id = 493 AND sp.is_hidden = 0 ORDER BY sp.name
            ;