Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1

[
  "api_token"
]

SELECT
  t0.id AS id_1,
  t0.setting AS setting_2,
  t0.default_value AS default_value_3,
  t0.description AS description_4
FROM
  cms_settings t0
WHERE
  t0.setting = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = 'api_token' LIMIT 1;

SELECT 
            s.id, s.id_item, s.name AS shop_name, s.quantity, s.price, s.promotion, s.image, s.visible, s.forceddescription,
            i.name AS item_name, i.description AS item_description, i.icon AS item_icon, i.folder
        FROM 
            cms_shop s
        JOIN 
            gamedata.items i ON s.id_item = i.id
        WHERE 
            s.visible = 1
     ORDER BY s.id DESC

[]

SELECT
  s.id,
  s.id_item,
  s.name AS shop_name,
  s.quantity,
  s.price,
  s.promotion,
  s.image,
  s.visible,
  s.forceddescription,
  i.name AS item_name,
  i.description AS item_description,
  i.icon AS item_icon,
  i.folder
FROM
  cms_shop s
  JOIN gamedata.items i ON s.id_item = i.id
WHERE
  s.visible = 1
ORDER BY
  s.id DESC

SELECT 
            s.id, s.id_item, s.name AS shop_name, s.quantity, s.price, s.promotion, s.image, s.visible, s.forceddescription,
            i.name AS item_name, i.description AS item_description, i.icon AS item_icon, i.folder
        FROM 
            cms_shop s
        JOIN 
            gamedata.items i ON s.id_item = i.id
        WHERE 
            s.visible = 1
     ORDER BY s.id DESC;

SELECT DISTINCT i.folder
        FROM cms_shop s
        JOIN gamedata.items i ON s.id_item = i.id
        WHERE s.visible = 1
          AND i.folder IS NOT NULL
        ORDER BY i.folder ASC

[]

SELECT
  DISTINCT i.folder
FROM
  cms_shop s
  JOIN gamedata.items i ON s.id_item = i.id
WHERE
  s.visible = 1
  AND i.folder IS NOT NULL
ORDER BY
  i.folder ASC

SELECT DISTINCT i.folder
        FROM cms_shop s
        JOIN gamedata.items i ON s.id_item = i.id
        WHERE s.visible = 1
          AND i.folder IS NOT NULL
        ORDER BY i.folder ASC
    ;

SELECT t0.id AS id_1, t0.category AS category_2, t0.unique_slug AS unique_slug_3, t0.name AS name_4, t0.content AS content_5, t0.is_visible AS is_visible_6 FROM cms_pages t0 WHERE t0.category = ? AND t0.is_visible = ?

[
  "game"
  1
]

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.unique_slug AS unique_slug_3,
  t0.name AS name_4,
  t0.content AS content_5,
  t0.is_visible AS is_visible_6
FROM
  cms_pages t0
WHERE
  t0.category = ?
  AND t0.is_visible = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.unique_slug AS unique_slug_3, t0.name AS name_4, t0.content AS content_5, t0.is_visible AS is_visible_6 FROM cms_pages t0 WHERE t0.category = 'game' AND t0.is_visible = 1;