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
  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 = '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
  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 50;

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;