Symfony Profiler

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
  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_username' 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 = ?
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_password' 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 = ?
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_server' 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 = ?
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 = 'credit_dedipass_public_key' 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 = ?
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 = 'credit_dedipass_private_key' 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
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;

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
        ;

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 = 'theme' 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 = ?
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 = 'game_title' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'theme' 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 = ?
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 = 'theme' 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 = ?
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 = 'theme' 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 = ?
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 = 'game_title' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'game_title' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'game_title' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'theme' 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 = ?
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 = 'game_title' 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 = ?
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 = 'seo_description' 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 = ?
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 = 'theme' 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 = ?
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 = 'theme' LIMIT 1;

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;

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 = 'small-news'
  AND d.hidden_at IS NULL
ORDER BY d.created_at DESC
LIMIT 50;