Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 157
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Workflow
• Blocks 0
• VichUploader
• Redis
• Message Queue
• GraphQL 0
• Configuration

Query Metrics

SELECT DISTINCT s0_.id AS id_0, s0_.position AS position_1, s0_.rank AS rank_2 FROM site_games s0_ LEFT JOIN site_game_translations s1_ ON s0_.id = s1_.translatable_id LEFT JOIN site_games_tags s3_ ON s0_.id = s3_.site_game_id LEFT JOIN tags t2_ ON t2_.id = s3_.tag_id LEFT JOIN provider_game_projections p4_ ON s0_.desktop_provider_game_projection_id = p4_.id LEFT JOIN provider_game_projections p5_ ON s0_.mobile_provider_game_projection_id = p5_.id INNER JOIN site_games_tags s7_ ON s0_.id = s7_.site_game_id INNER JOIN tags t6_ ON t6_.id = s7_.tag_id AND (t6_.slug = ?) WHERE s0_.enabled = ? AND (p4_.enabled = ? OR p5_.enabled = ?) ORDER BY s0_.position DESC, s0_.rank DESC LIMIT 40

[
  "casino"
  1
  1
  1
]

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.position AS position_1,
  s0_.rank AS rank_2
FROM
  site_games s0_
  LEFT JOIN site_game_translations s1_ ON s0_.id = s1_.translatable_id
  LEFT JOIN site_games_tags s3_ ON s0_.id = s3_.site_game_id
  LEFT JOIN tags t2_ ON t2_.id = s3_.tag_id
  LEFT JOIN provider_game_projections p4_ ON s0_.desktop_provider_game_projection_id = p4_.id
  LEFT JOIN provider_game_projections p5_ ON s0_.mobile_provider_game_projection_id = p5_.id
  INNER JOIN site_games_tags s7_ ON s0_.id = s7_.site_game_id
  INNER JOIN tags t6_ ON t6_.id = s7_.tag_id
  AND (t6_.slug = ?)
WHERE
  s0_.enabled = ?
  AND (
    p4_.enabled = ?
    OR p5_.enabled = ?
  )
ORDER BY
  s0_.position DESC,
  s0_.rank DESC
LIMIT
  40

SELECT DISTINCT s0_.id AS id_0, s0_.position AS position_1, s0_.rank AS rank_2 FROM site_games s0_ LEFT JOIN site_game_translations s1_ ON s0_.id = s1_.translatable_id LEFT JOIN site_games_tags s3_ ON s0_.id = s3_.site_game_id LEFT JOIN tags t2_ ON t2_.id = s3_.tag_id LEFT JOIN provider_game_projections p4_ ON s0_.desktop_provider_game_projection_id = p4_.id LEFT JOIN provider_game_projections p5_ ON s0_.mobile_provider_game_projection_id = p5_.id INNER JOIN site_games_tags s7_ ON s0_.id = s7_.site_game_id INNER JOIN tags t6_ ON t6_.id = s7_.tag_id AND (t6_.slug = 'casino') WHERE s0_.enabled = 1 AND (p4_.enabled = 1 OR p5_.enabled = 1) ORDER BY s0_.position DESC, s0_.rank DESC LIMIT 40;

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM site_games s0_ LEFT JOIN site_game_translations s1_ ON s0_.id = s1_.translatable_id LEFT JOIN site_games_tags s3_ ON s0_.id = s3_.site_game_id LEFT JOIN tags t2_ ON t2_.id = s3_.tag_id LEFT JOIN provider_game_projections p4_ ON s0_.desktop_provider_game_projection_id = p4_.id LEFT JOIN provider_game_projections p5_ ON s0_.mobile_provider_game_projection_id = p5_.id INNER JOIN site_games_tags s7_ ON s0_.id = s7_.site_game_id INNER JOIN tags t6_ ON t6_.id = s7_.tag_id AND (t6_.slug = ?) WHERE s0_.enabled = ? AND (p4_.enabled = ? OR p5_.enabled = ?)

[
  "casino"
  1
  1
  1
]

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  site_games s0_
  LEFT JOIN site_game_translations s1_ ON s0_.id = s1_.translatable_id
  LEFT JOIN site_games_tags s3_ ON s0_.id = s3_.site_game_id
  LEFT JOIN tags t2_ ON t2_.id = s3_.tag_id
  LEFT JOIN provider_game_projections p4_ ON s0_.desktop_provider_game_projection_id = p4_.id
  LEFT JOIN provider_game_projections p5_ ON s0_.mobile_provider_game_projection_id = p5_.id
  INNER JOIN site_games_tags s7_ ON s0_.id = s7_.site_game_id
  INNER JOIN tags t6_ ON t6_.id = s7_.tag_id
  AND (t6_.slug = ?)
WHERE
  s0_.enabled = ?
  AND (
    p4_.enabled = ?
    OR p5_.enabled = ?
  )

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM site_games s0_ LEFT JOIN site_game_translations s1_ ON s0_.id = s1_.translatable_id LEFT JOIN site_games_tags s3_ ON s0_.id = s3_.site_game_id LEFT JOIN tags t2_ ON t2_.id = s3_.tag_id LEFT JOIN provider_game_projections p4_ ON s0_.desktop_provider_game_projection_id = p4_.id LEFT JOIN provider_game_projections p5_ ON s0_.mobile_provider_game_projection_id = p5_.id INNER JOIN site_games_tags s7_ ON s0_.id = s7_.site_game_id INNER JOIN tags t6_ ON t6_.id = s7_.tag_id AND (t6_.slug = 'casino') WHERE s0_.enabled = 1 AND (p4_.enabled = 1 OR p5_.enabled = 1);

SELECT DISTINCT t0_.slug AS slug_0 FROM tags t0_ INNER JOIN site_games_tags s2_ ON t0_.id = s2_.tag_id INNER JOIN site_games s1_ ON s1_.id = s2_.site_game_id INNER JOIN site_games_tags s4_ ON s1_.id = s4_.site_game_id INNER JOIN tags t3_ ON t3_.id = s4_.tag_id WHERE s1_.enabled = ? AND t0_.slug IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t3_.slug = ? ORDER BY t0_.slug ASC

[
  1
  "1x2gaming"
  "amatic"
  "amusnet"
  "avatar_ux"
  "belatra"
  "betgames"
  "betsoft"
  "bgaming"
  "blue_guru"
  "blueprint"
  "booongo"
  "big_time"
  "egt"
  "elk"
  "endorphina"
  "eurasian_gaming"
  "evolution"
  "ezugi"
  "fantasma"
  "four_leaf"
  "gamomat"
  "habanero"
  "hacksaw"
  "backseat_gaming"
  "bullshark_games"
  "nownow_gaming"
  "trusty_games"
  "sky_gaming"
  "kitsune_studios"
  "igrosoft"
  "in_out"
  "iron_dog"
  "isoftbet"
  "jili"
  "kalamba"
  "lucksome"
  "merkur"
  "microgaming"
  "netent"
  "nolimit_city"
  "novomatic"
  "octoplay"
  "peter_and_sons"
  "pgsoft"
  "play_n_go"
  "playson"
  "playtech"
  "popiplay"
  "pragmatic_play"
  "print_studios"
  "push"
  "quickspin"
  "red_tiger"
  "reel_play"
  "relax"
  "slotmill"
  "smartsoft"
  "spribe"
  "stakelogic"
  "tadagaming"
  "three_oaks"
  "thunderkick"
  "top_spin"
  "true_lab"
  "turbo"
  "twain_sport"
  "vivo"
  "yggdrasil"
  "casino"
]

SELECT
  DISTINCT t0_.slug AS slug_0
FROM
  tags t0_
  INNER JOIN site_games_tags s2_ ON t0_.id = s2_.tag_id
  INNER JOIN site_games s1_ ON s1_.id = s2_.site_game_id
  INNER JOIN site_games_tags s4_ ON s1_.id = s4_.site_game_id
  INNER JOIN tags t3_ ON t3_.id = s4_.tag_id
WHERE
  s1_.enabled = ?
  AND t0_.slug IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
  AND t3_.slug = ?
ORDER BY
  t0_.slug ASC

SELECT DISTINCT t0_.slug AS slug_0 FROM tags t0_ INNER JOIN site_games_tags s2_ ON t0_.id = s2_.tag_id INNER JOIN site_games s1_ ON s1_.id = s2_.site_game_id INNER JOIN site_games_tags s4_ ON s1_.id = s4_.site_game_id INNER JOIN tags t3_ ON t3_.id = s4_.tag_id WHERE s1_.enabled = 1 AND t0_.slug IN ('1x2gaming', 'amatic', 'amusnet', 'avatar_ux', 'belatra', 'betgames', 'betsoft', 'bgaming', 'blue_guru', 'blueprint', 'booongo', 'big_time', 'egt', 'elk', 'endorphina', 'eurasian_gaming', 'evolution', 'ezugi', 'fantasma', 'four_leaf', 'gamomat', 'habanero', 'hacksaw', 'backseat_gaming', 'bullshark_games', 'nownow_gaming', 'trusty_games', 'sky_gaming', 'kitsune_studios', 'igrosoft', 'in_out', 'iron_dog', 'isoftbet', 'jili', 'kalamba', 'lucksome', 'merkur', 'microgaming', 'netent', 'nolimit_city', 'novomatic', 'octoplay', 'peter_and_sons', 'pgsoft', 'play_n_go', 'playson', 'playtech', 'popiplay', 'pragmatic_play', 'print_studios', 'push', 'quickspin', 'red_tiger', 'reel_play', 'relax', 'slotmill', 'smartsoft', 'spribe', 'stakelogic', 'tadagaming', 'three_oaks', 'thunderkick', 'top_spin', 'true_lab', 'turbo', 'twain_sport', 'vivo', 'yggdrasil') AND t3_.slug = 'casino' ORDER BY t0_.slug ASC;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?

[
  "main_host_company_name"
]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2
FROM
  parameters p0_
WHERE
  p0_.name = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = 'main_host_company_name';

SELECT b0_.id AS id_0, b0_.enabled AS enabled_1, b0_.name AS name_2, b0_.visibility AS visibility_3, b0_.country_list AS country_list_4, b0_.position AS position_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7 FROM banners b0_ WHERE b0_.enabled = true ORDER BY b0_.position ASC

[]

SELECT
  b0_.id AS id_0,
  b0_.enabled AS enabled_1,
  b0_.name AS name_2,
  b0_.visibility AS visibility_3,
  b0_.country_list AS country_list_4,
  b0_.position AS position_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7
FROM
  banners b0_
WHERE
  b0_.enabled = true
ORDER BY
  b0_.position ASC

SELECT b0_.id AS id_0, b0_.enabled AS enabled_1, b0_.name AS name_2, b0_.visibility AS visibility_3, b0_.country_list AS country_list_4, b0_.position AS position_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7 FROM banners b0_ WHERE b0_.enabled = true ORDER BY b0_.position ASC;

SELECT s0_.id AS id_0, s0_.provider AS provider_1, s0_.active AS active_2, s0_.created_at AS created_at_3 FROM social_providers s0_ WHERE s0_.active = ?

[
  1
]

SELECT
  s0_.id AS id_0,
  s0_.provider AS provider_1,
  s0_.active AS active_2,
  s0_.created_at AS created_at_3
FROM
  social_providers s0_
WHERE
  s0_.active = ?

SELECT s0_.id AS id_0, s0_.provider AS provider_1, s0_.active AS active_2, s0_.created_at AS created_at_3 FROM social_providers s0_ WHERE s0_.active = 1;

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3 FROM social_network_links s0_ WHERE s0_.locale = ? ORDER BY s0_.type ASC

[
  "en"
]

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.locale AS locale_2,
  s0_.url AS url_3
FROM
  social_network_links s0_
WHERE
  s0_.locale = ?
ORDER BY
  s0_.type ASC

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3 FROM social_network_links s0_ WHERE s0_.locale = 'en' ORDER BY s0_.type ASC;