GET https://dev.tcgcards.fr/league/tournaments

Response
200 OK
IP
216.73.216.191
Profiled on
Token
d5d88a

Query Metrics

51 Database Queries
11 Different statements
127.95 ms Query time
0 Invalid entities
69 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

#▲ Time Info
1 3.25 ms 
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.extended_name AS extended_name_4, t0.domain AS domain_5, t0.item_image_prefix AS item_image_prefix_6, t0.image_prefix AS image_prefix_7, t0.image_enprefix AS image_enprefix_8, t0.facebook AS facebook_9, t0.discord AS discord_10, t0.instagram AS instagram_11, t0.decks AS decks_12, t0.wishlists AS wishlists_13, t0.achievements AS achievements_14, t0.blog AS blog_15, t0.shops AS shops_16, t0.ranking AS ranking_17, t0.rules AS rules_18, t0.videos AS videos_19, t0.eras AS eras_20, t0.characters AS characters_21, t0.grading AS grading_22, t0.year AS year_23, t0.game AS game_24, t0.game_condensed AS game_condensed_25, t0.static_folder AS static_folder_26, t0.untap_ccg_type AS untap_ccg_type_27, t0.rarity_iconable AS rarity_iconable_28, t0.description AS description_29, t0.cardmarket_game_id AS cardmarket_game_id_30, t0.cardnexus_game_key AS cardnexus_game_key_31, t0.displayed AS displayed_32, t0.sort_order AS sort_order_33, t0.default_language_id AS default_language_id_34, t0.form_filters_id AS form_filters_id_35 FROM web_site t0 WHERE t0.reference = ? LIMIT 1
Parameters: 
[
  "dbscards"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.76 ms 
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.name AS name_2, t0_.description AS description_3, t0_.topcut AS topcut_4, t0_.draw_accepted AS draw_accepted_5 FROM tournament_category t0_ ORDER BY t0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 2.79 ms 
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM tournament t0_ WHERE t0_.slug IS NOT NULL AND t0_.website_id = ? AND t0_.private = 0 AND t0_.started = 0 AND t0_.finished = 0
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.82 ms 
SELECT DISTINCT t0_.id AS id_0, t0_.start_date AS start_date_1, t0_.name AS name_2, t0_.started AS started_3, t0_.finished AS finished_4 FROM tournament t0_ WHERE t0_.slug IS NOT NULL AND t0_.website_id = ? AND t0_.private = 0 AND t0_.started = 0 AND t0_.finished = 0 ORDER BY t0_.start_date DESC, t0_.name ASC, t0_.started ASC, t0_.finished ASC LIMIT 30
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.23 ms 
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.private AS private_2, t0_.started AS started_3, t0_.start_date AS start_date_4, t0_.nb_players_max AS nb_players_max_5, t0_.description AS description_6, t0_.history AS history_7, t0_.nb_rounds_max AS nb_rounds_max_8, t0_.draw_accepted AS draw_accepted_9, t0_.topcut_phase AS topcut_phase_10, t0_.slug AS slug_11, t0_.slug_en AS slug_en_12, t0_.creation_date AS creation_date_13, t0_.update_date AS update_date_14, t0_.finished AS finished_15, t0_.winner_id AS winner_id_16, t0_.creator_id AS creator_id_17, t0_.current_round_id AS current_round_id_18, t0_.previous_round_id AS previous_round_id_19, t0_.category_id AS category_id_20, t0_.rule_id AS rule_id_21, t0_.topcut_rule_id AS topcut_rule_id_22, t0_.website_id AS website_id_23 FROM tournament t0_ WHERE t0_.slug IS NOT NULL AND t0_.website_id = ? AND t0_.private = 0 AND t0_.started = 0 AND t0_.finished = 0 AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0_.start_date DESC, t0_.name ASC, t0_.started ASC, t0_.finished ASC
Parameters: 
[
  1
  190
  199
  197
  194
  195
  191
  192
  193
  189
  196
  186
  175
  162
  163
  130
  129
  119
  103
  104
  70
  59
  58
  57
  56
  53
  49
  47
  41
  28
]
View formatted query    View runnable query    Explain query    View query backtrace
6 2.30 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  19307
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.00 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  18787
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.72 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  9057
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.76 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  14178
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.41 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  10816
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.68 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  9277
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.66 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  7327
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.68 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  4354
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.60 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  3952
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.57 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  5050
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.63 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  112
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.66 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  2408
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.67 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  3076
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.66 ms 
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.name AS name_2, t0_.nb_max_games AS nb_max_games_3 FROM tournament_game_rule t0_ ORDER BY t0_.reference ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.43 ms 
SELECT t0.id AS id_1, t0.max_same_cards AS max_same_cards_2, t0.leader AS leader_3, t0.start_hand_length AS start_hand_length_4, t0.leader_first AS leader_first_5, t0.mulligan AS mulligan_6, t0.nb_max_cards AS nb_max_cards_7, t0.default_deck_area_id AS default_deck_area_id_8, t0.website_id AS website_id_9 FROM deckbuilder t0 WHERE t0.website_id = ? LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
21 73.43 ms 
SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id WHERE c0_.displayed = 1 AND c0_.slug IS NOT NULL AND c0_.current_price IS NOT NULL AND c0_.cardnexus_current_price IS NOT NULL AND c0_.website_id = ? AND c0_.cardnexus_current_price < c0_.current_price
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.57 ms 
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.sort_order AS sort_order_4 FROM language t0 INNER JOIN web_site_language ON t0.id = web_site_language.language_id WHERE web_site_language.web_site_id = ? ORDER BY t0.sort_order ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
23 6.47 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  190
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.86 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  199
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.81 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  197
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.83 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  194
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.77 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  195
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.80 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  191
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.76 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  192
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.95 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  193
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.76 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  189
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.79 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  196
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.78 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  186
]
View formatted query    View runnable query    Explain query    View query backtrace
34 1.07 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  175
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.63 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  162
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.79 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  163
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.62 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  130
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.63 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  129
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.67 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  119
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.90 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  103
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.67 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  104
]
View formatted query    View runnable query    Explain query    View query backtrace
42 6.83 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  70
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.85 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.57 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  58
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.66 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.72 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  56
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.79 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  53
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.56 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  49
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.52 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  47
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.91 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  41
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.72 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN tournament_user ON t0.id = tournament_user.user_id WHERE tournament_user.tournament_id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Tournament\Tournament 29
App\Entity\User 17
App\Entity\Map\Department 6
App\Entity\Avatar\Avatar 3
App\Entity\WebSite 2
App\Entity\Language 2
App\Entity\Tournament\TournamentCategory 2
App\Entity\Tournament\TournamentGameRule 2
App\Entity\Shop\ShopTournamentPlayer 2
App\Entity\Settings\FormFilter 1
App\Entity\Map\Country 1
App\Entity\Deckbuilder\Deckbuilder 1
App\Entity\Deckbuilder\DeckArea 1

Entities Mapping

Class Mapping errors
App\Entity\WebSite No errors.
App\Entity\Language No errors.
App\Entity\Settings\FormFilter No errors.
App\Entity\User No errors.
App\Entity\Support\Ticket No errors.
App\Entity\Tournament\TournamentCategory No errors.
App\Entity\Tournament\TournamentGameRule No errors.
App\Entity\Tournament\Tournament No errors.
App\Entity\Tournament\TournamentRound No errors.
App\Entity\Tournament\TournamentRanking No errors.
App\Entity\Avatar\Avatar No errors.
App\Entity\Shop\ShopTournamentPlayer No errors.
App\Entity\Map\Country No errors.
App\Entity\Map\Department No errors.
App\Entity\Video\Videographer No errors.
App\Entity\Wishlist No errors.
App\Entity\Deck No errors.
App\Entity\CardOwned No errors.
App\Entity\Product\ProductOwned No errors.
App\Entity\Partnership\CardmarketClick No errors.
App\Entity\Achievement\AchievementUser No errors.
App\Entity\Avatar\AvatarUser No errors.
App\Entity\User\UserLogin No errors.
App\Entity\User\CapsuleMovement No errors.
App\Entity\Partnership\GoupiyaClick No errors.
App\Entity\Search\UserSearch No errors.
App\Entity\User\CardSale No errors.
App\Entity\User\UserSettings No errors.
App\Entity\Shop\Shop No errors.
App\Entity\User\UserTutorial No errors.
App\Entity\Video\VideoReview No errors.
App\Entity\User\Friend\Request No errors.
App\Entity\User\LeagueStats No errors.
App\Entity\Card No errors.
App\Entity\Deckbuilder\Deckbuilder No errors.
App\Entity\Deckbuilder\DeckArea No errors.
App\Entity\Deckbuilder\DeckBuilderSkill No errors.
App\Entity\Serie No errors.