Redirect 301 redirect from GET @homepage (40c88a)

GET http://d.pre.re/it/

Query Metrics

54 Database Queries
10 Different statements
66.48 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 5.53 ms
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 WHERE s0_.enabled = ? AND (p4_.enabled = ? OR p5_.enabled = ?)
Parameters:
[
  1
  1
  1
]
2 2.69 ms
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 WHERE s0_.enabled = ? AND (p4_.enabled = ? OR p5_.enabled = ?) ORDER BY s0_.position DESC, s0_.rank DESC LIMIT 40
Parameters:
[
  1
  1
  1
]
3 3.83 ms
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.image AS image_2, s0_.background_image AS background_image_3, s0_.position AS position_4, s0_.rank AS rank_5, s0_.enabled AS enabled_6, s0_.disabling_reason AS disabling_reason_7, s0_.demo_available AS demo_available_8, s0_.released_at AS released_at_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.category AS category_12, s0_.country_list AS country_list_13, s0_.country_list_type AS country_list_type_14, s1_.id AS id_15, s1_.title AS title_16, s1_.description AS description_17, s1_.locale AS locale_18, t2_.id AS id_19, t2_.slug AS slug_20, s0_.desktop_provider_game_projection_id AS desktop_provider_game_projection_id_21, s0_.mobile_provider_game_projection_id AS mobile_provider_game_projection_id_22, s1_.translatable_id AS translatable_id_23 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 WHERE s0_.enabled = ? AND (p4_.enabled = ? OR p5_.enabled = ?) AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.position DESC, s0_.rank DESC
Parameters:
[
  1
  1
  1
  54
  91
  39
  50
  57
  61
  48
  103
  72
  64
  90
  62
  19
  8
  89
  81
  9
  84
  52
  76
  5
  97
  70
  46
  82
  15
  28
  98
  94
  56
  41
  92
  12
  85
  7
  99
  14
  22
  44
  45
]
4 1.19 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  56
]
5 1.02 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  93
]
6 0.93 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  41
]
7 0.97 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  52
]
8 1.01 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  59
]
9 1.20 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  63
]
10 1.05 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  50
]
11 0.99 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  103
]
12 0.90 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  74
]
13 0.93 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  66
]
14 0.98 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  92
]
15 1.19 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  64
]
16 1.21 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  21
]
17 1.12 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  10
]
18 1.01 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  91
]
19 0.88 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  83
]
20 1.01 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  11
]
21 0.79 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  86
]
22 0.73 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  54
]
23 0.87 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  78
]
24 0.85 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  7
]
25 1.01 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  99
]
26 1.05 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  72
]
27 0.97 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  48
]
28 0.98 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  84
]
29 1.00 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  17
]
30 1.03 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  30
]
31 0.95 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  100
]
32 0.94 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  96
]
33 0.76 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  58
]
34 1.04 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  43
]
35 0.99 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  94
]
36 1.09 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  14
]
37 0.93 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  87
]
38 0.90 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  9
]
39 0.89 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  101
]
40 0.91 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  16
]
41 0.77 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  24
]
42 0.96 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  46
]
43 0.97 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.title AS title_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.demo_available AS demo_available_6, t0.freespins_available AS freespins_available_7, t0.system AS system_8, t0.vendor AS vendor_9, t0.aspect_ratio AS aspect_ratio_10, t0.is_mobile AS is_mobile_11, t0.is_desktop AS is_desktop_12, t0.supports_funny AS supports_funny_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.category AS category_16 FROM provider_game_projections t0 WHERE t0.id = ?
Parameters:
[
  47
]
44 3.12 ms
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 WHERE s1_.enabled = ? AND t0_.slug IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0_.slug ASC
Parameters:
[
  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"
]
45 1.30 ms
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 = ?
Parameters:
[
  1
]
46 3.63 ms
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
Parameters:
[
  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"
  "slots"
]
47 1.66 ms
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
Parameters:
[]
48 1.49 ms
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
Parameters:
[
  "it"
]
49 1.32 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_name"
]
50 0.81 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_registered_number"
]
51 0.77 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_office_address"
]
52 0.41 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_post_card"
]
53 0.37 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_city"
]
54 0.58 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2 FROM parameters p0_ WHERE p0_.name = ?
Parameters:
[
  "main_host_company_country"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
game_transaction doctrine.dbal.game_transaction_connection
vavadapart doctrine.dbal.vavadapart_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
game_transaction doctrine.orm.game_transaction_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\SiteGame No errors.
App\Entity\SiteGameTranslation No errors.
App\Entity\SiteGameTag No errors.
App\Entity\ProviderGameProjection No errors.
App\Entity\Tournament\Tournament No errors.
App\Entity\User No errors.
App\Entity\SiteGamePosition No errors.
App\Entity\SocialProvider No errors.
App\Entity\Banner No errors.
App\Entity\SocialNetworkLink No errors.
App\Entity\Parameter No errors.

game_transaction entity manager

No loaded entities.