Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

9.94 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.78 ms
(37.97%)

SELECT 'Weapons' AS category, 'weapon' AS type, w.id, w.name, w.image, w.level,
                   w.price_permanent, w.price_buy_once, NULL AS rearm_cost, wt.name AS sub_category,
                   w.is_mod, w.mod_name
              FROM weapons w JOIN weapon_types wt ON w.weapon_type_id = wt.id WHERE w.is_hidden = 0
            UNION ALL
            SELECT 'Scopes' AS category, 'scope' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM scopes WHERE is_hidden = 0
            UNION ALL
            SELECT 'Suppressors' AS category, 'suppressor' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM suppressors WHERE is_hidden = 0
            UNION ALL
            SELECT 'Explosives' AS category, 'explosive' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM explosives WHERE is_hidden = 0
            UNION ALL
            SELECT 'Accessories' AS category, 'accessory' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM accessories WHERE is_hidden = 0
            UNION ALL
            SELECT 'Vehicles' AS category, 'vehicle' AS type, v.id, v.name, v.image, v.level,
                   v.price_permanent, v.price_buy_once, v.rearm_cost, vt.name, v.is_mod, v.mod_name
              FROM vehicles v JOIN vehicle_types vt ON v.vehicle_type_id = vt.id WHERE v.is_hidden = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  'Weapons' AS category,
  'weapon' AS type,
  w.id,
  w.name,
  w.image,
  w.level,
  w.price_permanent,
  w.price_buy_once,
  NULL AS rearm_cost,
  wt.name AS sub_category,
  w.is_mod,
  w.mod_name
FROM
  weapons w
  JOIN weapon_types wt ON w.weapon_type_id = wt.id
WHERE
  w.is_hidden = 0
UNION ALL
SELECT
  'Scopes' AS category,
  'scope' AS type,
  id,
  name,
  image,
  level,
  price_permanent,
  price_buy_once,
  NULL,
  NULL,
  is_mod,
  mod_name
FROM
  scopes
WHERE
  is_hidden = 0
UNION ALL
SELECT
  'Suppressors' AS category,
  'suppressor' AS type,
  id,
  name,
  image,
  level,
  price_permanent,
  price_buy_once,
  NULL,
  NULL,
  is_mod,
  mod_name
FROM
  suppressors
WHERE
  is_hidden = 0
UNION ALL
SELECT
  'Explosives' AS category,
  'explosive' AS type,
  id,
  name,
  image,
  level,
  price_permanent,
  price_buy_once,
  NULL,
  NULL,
  is_mod,
  mod_name
FROM
  explosives
WHERE
  is_hidden = 0
UNION ALL
SELECT
  'Accessories' AS category,
  'accessory' AS type,
  id,
  name,
  image,
  level,
  price_permanent,
  price_buy_once,
  NULL,
  NULL,
  is_mod,
  mod_name
FROM
  accessories
WHERE
  is_hidden = 0
UNION ALL
SELECT
  'Vehicles' AS category,
  'vehicle' AS type,
  v.id,
  v.name,
  v.image,
  v.level,
  v.price_permanent,
  v.price_buy_once,
  v.rearm_cost,
  vt.name,
  v.is_mod,
  v.mod_name
FROM
  vehicles v
  JOIN vehicle_types vt ON v.vehicle_type_id = vt.id
WHERE
  v.is_hidden = 0

SELECT 'Weapons' AS category, 'weapon' AS type, w.id, w.name, w.image, w.level,
                   w.price_permanent, w.price_buy_once, NULL AS rearm_cost, wt.name AS sub_category,
                   w.is_mod, w.mod_name
              FROM weapons w JOIN weapon_types wt ON w.weapon_type_id = wt.id WHERE w.is_hidden = 0
            UNION ALL
            SELECT 'Scopes' AS category, 'scope' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM scopes WHERE is_hidden = 0
            UNION ALL
            SELECT 'Suppressors' AS category, 'suppressor' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM suppressors WHERE is_hidden = 0
            UNION ALL
            SELECT 'Explosives' AS category, 'explosive' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM explosives WHERE is_hidden = 0
            UNION ALL
            SELECT 'Accessories' AS category, 'accessory' AS type, id, name, image, level,
                   price_permanent, price_buy_once, NULL, NULL, is_mod, mod_name
              FROM accessories WHERE is_hidden = 0
            UNION ALL
            SELECT 'Vehicles' AS category, 'vehicle' AS type, v.id, v.name, v.image, v.level,
                   v.price_permanent, v.price_buy_once, v.rearm_cost, vt.name, v.is_mod, v.mod_name
              FROM vehicles v JOIN vehicle_types vt ON v.vehicle_type_id = vt.id WHERE v.is_hidden = 0
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 180)
2	App\Controller\HomeController->armory (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

3.21 ms
(32.30%)

SELECT GREATEST(
                COALESCE((SELECT MAX(updated_at) FROM weapons), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM scopes), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM suppressors), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM explosives), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM accessories), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM vehicles), '1970-01-01')
            )

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  GREATEST(
    COALESCE(
      (
        SELECT
          MAX(updated_at)
        FROM
          weapons
      ),
      '1970-01-01'
    ),
    COALESCE(
      (
        SELECT
          MAX(updated_at)
        FROM
          scopes
      ),
      '1970-01-01'
    ),
    COALESCE(
      (
        SELECT
          MAX(updated_at)
        FROM
          suppressors
      ),
      '1970-01-01'
    ),
    COALESCE(
      (
        SELECT
          MAX(updated_at)
        FROM
          explosives
      ),
      '1970-01-01'
    ),
    COALESCE(
      (
        SELECT
          MAX(updated_at)
        FROM
          accessories
      ),
      '1970-01-01'
    ),
    COALESCE(
      (
        SELECT
          MAX(updated_at)
        FROM
          vehicles
      ),
      '1970-01-01'
    )
  )

SELECT GREATEST(
                COALESCE((SELECT MAX(updated_at) FROM weapons), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM scopes), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM suppressors), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM explosives), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM accessories), '1970-01-01'),
                COALESCE((SELECT MAX(updated_at) FROM vehicles), '1970-01-01')
            )
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 137)
3	App\Controller\HomeController->armory (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

2.96 ms
(29.73%)

SELECT setting_value FROM site_settings WHERE setting_key = 'maintenance_pages'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  setting_value
FROM
  site_settings
WHERE
  setting_key = 'maintenance_pages'

SELECT setting_value FROM site_settings WHERE setting_key = 'maintenance_pages';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 131)
3	App\Controller\HomeController->armory (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://dev.cueslab.com/armory

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping