Symfony Profiler

Query Metrics

30 Database Queries

4 Different statements

8.21 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
6.59 ms (80.26%)	26	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 Parameters: [`"api_token"`] View formatted query View runnable query Explain query 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;
0.54 ms (6.61%)	1	SELECT p.name, p.level, COALESCE(g.name, 'Brak gildii') AS guild_name FROM playerdata.players p LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId WHERE p.level >= 1 AND p.name != 'Admin' ORDER BY p.level DESC, p.exp DESC, p.name ASC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT p.name, p.level, COALESCE(g.name, 'Brak gildii') AS guild_name FROM playerdata.players p LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId WHERE p.level >= 1 AND p.name != 'Admin' ORDER BY p.level DESC, p.exp DESC, p.name ASC LIMIT 10 SELECT p.name, p.level, COALESCE(g.name, 'Brak gildii') AS guild_name FROM playerdata.players p LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId WHERE p.level >= 1 AND p.name != 'Admin' ORDER BY p.level DESC, p.exp DESC, p.name ASC LIMIT 10 ;
0.39 ms (4.78%)	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 FROM cms_shop s JOIN gamedata.items i ON s.id_item = i.id WHERE s.visible = 1 ORDER BY s.id DESC LIMIT 6 Parameters: [] View formatted query View runnable query Explain query 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 FROM cms_shop s JOIN gamedata.items i ON s.id_item = i.id WHERE s.visible = 1 ORDER BY s.id DESC LIMIT 6 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 FROM cms_shop s JOIN gamedata.items i ON s.id_item = i.id WHERE s.visible = 1 ORDER BY s.id DESC LIMIT 6;

Time▼

Count

Info

6.59 ms
(80.26%)

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

Parameters:

[
  "api_token"
]

View formatted query View runnable query Explain query

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;

0.54 ms
(6.61%)

SELECT
                p.name,
                p.level,
                COALESCE(g.name, 'Brak gildii') AS guild_name
            FROM playerdata.players p
            LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId
            WHERE p.level >= 1
              AND p.name != 'Admin'
            ORDER BY p.level DESC, p.exp DESC, p.name ASC
            LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  p.name,
  p.level,
  COALESCE(g.name, 'Brak gildii') AS guild_name
FROM
  playerdata.players p
  LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId
WHERE
  p.level >= 1
  AND p.name != 'Admin'
ORDER BY
  p.level DESC,
  p.exp DESC,
  p.name ASC
LIMIT
  10

SELECT
                p.name,
                p.level,
                COALESCE(g.name, 'Brak gildii') AS guild_name
            FROM playerdata.players p
            LEFT JOIN playerdata.guilds g ON g.id = p.DbGuildId
            WHERE p.level >= 1
              AND p.name != 'Admin'
            ORDER BY p.level DESC, p.exp DESC, p.name ASC
            LIMIT 10
        ;

0.39 ms
(4.78%)

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
        FROM 
            cms_shop s
        JOIN 
            gamedata.items i ON s.id_item = i.id
        WHERE 
            s.visible = 1
        ORDER BY 
            s.id DESC
        LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query

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
FROM
  cms_shop s
  JOIN gamedata.items i ON s.id_item = i.id
WHERE
  s.visible = 1
ORDER BY
  s.id DESC
LIMIT
  6

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
        FROM 
            cms_shop s
        JOIN 
            gamedata.items i ON s.id_item = i.id
        WHERE 
            s.visible = 1
        ORDER BY 
            s.id DESC
        LIMIT 6;

flarum connection

Time▼	Count	Info
0.69 ms (8.35%)	2	SELECT d.id, d.title, d.slug, d.created_at AS createdAt, p.content AS firstPostContent, COALESCE(u.username, 'Inconnu') AS authorName FROM forum_discussions d INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id INNER JOIN forum_tags t ON t.id = dt.tag_id LEFT JOIN forum_posts p ON p.id = d.first_post_id LEFT JOIN forum_users u ON u.id = d.user_id WHERE t.slug = :tagSlug AND d.hidden_at IS NULL ORDER BY d.created_at DESC LIMIT :limit Parameters: [`"tagSlug" => "news" "limit" => 5`] View formatted query View runnable query Explain query SELECT d.id, d.title, d.slug, d.created_at AS createdAt, p.content AS firstPostContent, COALESCE(u.username, 'Inconnu') AS authorName FROM forum_discussions d INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id INNER JOIN forum_tags t ON t.id = dt.tag_id LEFT JOIN forum_posts p ON p.id = d.first_post_id LEFT JOIN forum_users u ON u.id = d.user_id WHERE t.slug = :tagSlug AND d.hidden_at IS NULL ORDER BY d.created_at DESC LIMIT :limit SELECT d.id, d.title, d.slug, d.created_at AS createdAt, p.content AS firstPostContent, COALESCE(u.username, 'Inconnu') AS authorName FROM forum_discussions d INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id INNER JOIN forum_tags t ON t.id = dt.tag_id LEFT JOIN forum_posts p ON p.id = d.first_post_id LEFT JOIN forum_users u ON u.id = d.user_id WHERE t.slug = 'news' AND d.hidden_at IS NULL ORDER BY d.created_at DESC LIMIT 5;

Time▼

Count

Info

0.69 ms
(8.35%)

SELECT
    d.id,
    d.title,
    d.slug,
    d.created_at AS createdAt,
    p.content    AS firstPostContent,
    COALESCE(u.username, 'Inconnu') AS authorName
FROM forum_discussions d
INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id
INNER JOIN forum_tags t            ON t.id = dt.tag_id
LEFT JOIN forum_posts p            ON p.id = d.first_post_id
LEFT JOIN forum_users u            ON u.id = d.user_id
WHERE t.slug = :tagSlug
  AND d.hidden_at IS NULL
ORDER BY d.created_at DESC
LIMIT :limit

Parameters:

[
  "tagSlug" => "news"
  "limit" => 5
]

View formatted query View runnable query Explain query

SELECT
  d.id,
  d.title,
  d.slug,
  d.created_at AS createdAt,
  p.content AS firstPostContent,
  COALESCE(u.username, 'Inconnu') AS authorName
FROM
  forum_discussions d
  INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id
  INNER JOIN forum_tags t ON t.id = dt.tag_id
  LEFT JOIN forum_posts p ON p.id = d.first_post_id
  LEFT JOIN forum_users u ON u.id = d.user_id
WHERE
  t.slug = :tagSlug
  AND d.hidden_at IS NULL
ORDER BY
  d.created_at DESC
LIMIT
  :limit

SELECT
    d.id,
    d.title,
    d.slug,
    d.created_at AS createdAt,
    p.content    AS firstPostContent,
    COALESCE(u.username, 'Inconnu') AS authorName
FROM forum_discussions d
INNER JOIN forum_discussion_tag dt ON dt.discussion_id = d.id
INNER JOIN forum_tags t            ON t.id = dt.tag_id
LEFT JOIN forum_posts p            ON p.id = d.first_post_id
LEFT JOIN forum_users u            ON u.id = d.user_id
WHERE t.slug = 'news'
  AND d.hidden_at IS NULL
ORDER BY d.created_at DESC
LIMIT 5;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
flarum	doctrine.dbal.flarum_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\CmsSettings	No errors.
App\Entity\CmsShop	No errors.

Symfony Profiler

GET https://altaria-online.pl/en/checkServer?variant=line

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

flarum connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping