Redirect 301 redirect from GET @homepage (4126f1)

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

Response
200 OK
Browse referrer URL
IP
162.158.155.155
Profiled on
Token
78921e

Query Metrics

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

Queries

Group similar statements

default connection

#▲ Time Info
1 7.69 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
]
View formatted query    View runnable query    Explain query
2 4.23 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
]
View formatted query    View runnable query    Explain query
3 4.18 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
]
View formatted query    View runnable query    Explain query
4 1.26 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
]
View formatted query    View runnable query    Explain query
5 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: 
[
  93
]
View formatted query    View runnable query    Explain query
6 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: 
[
  41
]
View formatted query    View runnable query    Explain query
7 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: 
[
  52
]
View formatted query    View runnable query    Explain query
8 1.16 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
]
View formatted query    View runnable query    Explain query
9 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: 
[
  63
]
View formatted query    View runnable query    Explain query
10 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: 
[
  50
]
View formatted query    View runnable query    Explain query
11 1.10 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
]
View formatted query    View runnable query    Explain query
12 1.06 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
]
View formatted query    View runnable query    Explain query
13 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: 
[
  66
]
View formatted query    View runnable query    Explain query
14 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: 
[
  92
]
View formatted query    View runnable query    Explain query
15 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: 
[
  64
]
View formatted query    View runnable query    Explain query
16 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: 
[
  21
]
View formatted query    View runnable query    Explain query
17 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: 
[
  10
]
View formatted query    View runnable query    Explain query
18 1.10 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
]
View formatted query    View runnable query    Explain query
19 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: 
[
  83
]
View formatted query    View runnable query    Explain query
20 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: 
[
  11
]
View formatted query    View runnable query    Explain query
21 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: 
[
  86
]
View formatted query    View runnable query    Explain query
22 1.08 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
]
View formatted query    View runnable query    Explain query
23 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: 
[
  78
]
View formatted query    View runnable query    Explain query
24 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: 
[
  7
]
View formatted query    View runnable query    Explain query
25 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: 
[
  99
]
View formatted query    View runnable query    Explain query
26 0.81 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
]
View formatted query    View runnable query    Explain query
27 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: 
[
  48
]
View formatted query    View runnable query    Explain query
28 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: 
[
  84
]
View formatted query    View runnable query    Explain query
29 1.08 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
]
View formatted query    View runnable query    Explain query
30 1.13 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
]
View formatted query    View runnable query    Explain query
31 1.13 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
]
View formatted query    View runnable query    Explain query
32 1.24 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
]
View formatted query    View runnable query    Explain query
33 1.15 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
]
View formatted query    View runnable query    Explain query
34 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: 
[
  43
]
View formatted query    View runnable query    Explain query
35 1.10 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
]
View formatted query    View runnable query    Explain query
36 1.16 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
]
View formatted query    View runnable query    Explain query
37 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: 
[
  87
]
View formatted query    View runnable query    Explain query
38 0.72 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
]
View formatted query    View runnable query    Explain query
39 0.74 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
]
View formatted query    View runnable query    Explain query
40 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: 
[
  16
]
View formatted query    View runnable query    Explain query
41 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: 
[
  24
]
View formatted query    View runnable query    Explain query
42 1.24 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
]
View formatted query    View runnable query    Explain query
43 1.14 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
]
View formatted query    View runnable query    Explain query
44 3.06 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"
]
View formatted query    View runnable query    Explain query
45 1.39 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
]
View formatted query    View runnable query    Explain query
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"
]
View formatted query    View runnable query    Explain query
47 1.53 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: 
[]
View formatted query    View runnable query    Explain query
48 1.40 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: 
[
  "az"
]
View formatted query    View runnable query    Explain query
49 1.35 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"
]
View formatted query    View runnable query    Explain query
50 0.60 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"
]
View formatted query    View runnable query    Explain query
51 1.03 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"
]
View formatted query    View runnable query    Explain query
52 0.85 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"
]
View formatted query    View runnable query    Explain query
53 0.55 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"
]
View formatted query    View runnable query    Explain query
54 0.70 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"
]
View formatted query    View runnable query    Explain query

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.