https://prod.golmanagerpanel.com/api/es/player/listbygame/38327?isIos=false&p=api%2Fes%2Fplayer%2Flistbygame%2F38327&version_app=5.0.1

Query Metrics

155 Database Queries
12 Different statements
114.42 ms Query time
10 Invalid entities

Queries

Group similar statements

# Time Info
1 29.94 ms
SELECT
        *
        FROM
        customer_device
        WHERE
            :token LIKE CONCAT(token,'%') AND
            `status` = 0
Parameters:
0 of 0
[ "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzgyNzg3OTcsImV4cCI6MTczODI4MjM5Nywicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImxmdW5lejEwMjNAZ21haWwuY29tIn0.PLXSognEngYTw3FwSMEuWuhSyBw4WPOSuwbyDdQwPhZTICNvdclpkphqJbfYH_QOml7zdhO5zhpbPjcI_D71MVr0oKYxNE-0bCkSqkFVd2WgioS0gRu4bVYu7aYDOdAfwlM_7A4P-1ZFQ2WMZLTCHDz0UxbV2I9hU5mQJEGHfQEm5ArjT0zalV6o-mIJX45c_eEkgvy8TlpTudmL2wN4yihutFbsaObiHcdvC3GCX_XoSmQqqk_0vDX63ECULzQWg_mYQoHXj0JgfwPpaVtj92Ml2d4Jq4VCKL644GHZfabkLHAIqACuRIxLbEGWES4FYtVEpxRkzrs-mVMX3LHL4fpjngnmGB8LYRcU6je9p_btZTaDnhmAX0CKTXRAyal7_xK7dHMB8zAPDSPYVNQUNypIzTobSwVYeVvqa9OhS6t4Kc4huchigNc45RS7ZhZxKTqGY4m4MDA5DbVYKM-HHed0GMFYj4frqOnQr-nrVVqNRqpx9wxs7JGm2QyakUfQ-ZFiijgAQNI-TyUW7gd1IdJap0CR24K27o6LKZ15dt_4mmfov2gel9Vhy_c0N64B5PFEdCZciGDJj7REtDYFZo-hF2l1Aoj8JZH2IY9FPmq-LD0_EsBUYWhFp9Jx9LghqNKRfU7J8xw-jER8XmWF-c9NH45JL44gCHWR8gSK5eI" ]
2 0.82 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.plain_password AS plain_password_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.surname AS surname_9, t0.address AS address_10, t0.celular AS celular_11, t0.image AS image_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.country_id AS country_id_15, t0.season_active AS season_active_16, t0.type_account AS type_account_17, t0.is_pro AS is_pro_18, t0.purchase AS purchase_19, t0.purchase_platform AS purchase_platform_20, t0.membership_id AS membership_id_21, t0.coupon_status AS coupon_status_22, t0.phone AS phone_23, t0.google_auth_code AS google_auth_code_24, t0.google_auth_code_verified AS google_auth_code_verified_25, t0.date_of_birth AS date_of_birth_26, t0.deleted_at AS deleted_at_27, t0.is_deleted AS is_deleted_28, t0.country_id AS country_id_29 FROM customer t0 WHERE t0.email = ? LIMIT 1
Parameters:
0 of 0
[ "lfunez1023@gmail.com" ]
3 0.62 ms
SELECT t0.id AS id_1, t0.year AS year_2, t0.is_active AS is_active_3, t0.team_id AS team_id_4, t0.customer_id AS customer_id_5, t0.country_id AS country_id_6 FROM season t0 WHERE t0.customer_id = ?
Parameters:
0 of 0
[ 8880 ]
4 0.93 ms
SELECT t0.id AS id_1, t0.rival AS rival_2, t0.day AS day_3, t0.date AS date_4, t0.goals AS goals_5, t0.rival_goals AS rival_goals_6, t0.image AS image_7, t0.updated_at AS updated_at_8, t0.shots_goal AS shots_goal_9, t0.shots_opponent AS shots_opponent_10, t0.corners_favor AS corners_favor_11, t0.corners_against AS corners_against_12, t0.penalties_favor AS penalties_favor_13, t0.penalties_against AS penalties_against_14, t0.fouls_favor AS fouls_favor_15, t0.fouls_against AS fouls_against_16, t0.time_match AS time_match_17, t0.category AS category_18, t0.total_shots AS total_shots_19, t0.total_shots_against AS total_shots_against_20, t0.yellow_cards AS yellow_cards_21, t0.yellow_cards_against AS yellow_cards_against_22, t0.red_cards AS red_cards_23, t0.red_cards_against AS red_cards_against_24, t0.current_position_league AS current_position_league_25, t0.opponent_current_position_league AS opponent_current_position_league_26, t0.deleted_at AS deleted_at_27, t0.season_id AS season_id_28, t0.locality_id AS locality_id_29, t30.id AS id_31, t30.game_id AS game_id_32, t0.competition_id AS competition_id_33, t0.alignment_id AS alignment_id_34, t0.rival_alignment_id AS rival_alignment_id_35, t0.pressure_rival_id AS pressure_rival_id_36 FROM game t0 LEFT JOIN convocatoria t30 ON t30.game_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[ "38327" ]
5 0.97 ms
SELECT t0.id AS id_1, t0.tactic AS tactic_2, t0.alignment AS alignment_3, t4.id AS id_5, t4.rival AS rival_6, t4.day AS day_7, t4.date AS date_8, t4.goals AS goals_9, t4.rival_goals AS rival_goals_10, t4.image AS image_11, t4.updated_at AS updated_at_12, t4.shots_goal AS shots_goal_13, t4.shots_opponent AS shots_opponent_14, t4.corners_favor AS corners_favor_15, t4.corners_against AS corners_against_16, t4.penalties_favor AS penalties_favor_17, t4.penalties_against AS penalties_against_18, t4.fouls_favor AS fouls_favor_19, t4.fouls_against AS fouls_against_20, t4.time_match AS time_match_21, t4.category AS category_22, t4.total_shots AS total_shots_23, t4.total_shots_against AS total_shots_against_24, t4.yellow_cards AS yellow_cards_25, t4.yellow_cards_against AS yellow_cards_against_26, t4.red_cards AS red_cards_27, t4.red_cards_against AS red_cards_against_28, t4.current_position_league AS current_position_league_29, t4.opponent_current_position_league AS opponent_current_position_league_30, t4.deleted_at AS deleted_at_31, t4.season_id AS season_id_32, t4.locality_id AS locality_id_33, t4.competition_id AS competition_id_34, t4.alignment_id AS alignment_id_35, t4.rival_alignment_id AS rival_alignment_id_36, t4.pressure_rival_id AS pressure_rival_id_37, t0.seasonplayer_id AS seasonplayer_id_38 FROM game_alignment t0 LEFT JOIN game t4 ON t4.alignment_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[ 16871 ]
6 0.89 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? ORDER BY t0.dorsal ASC
Parameters:
0 of 0
[ 28031 ]
7 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 57754 ]
8 0.52 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.field_position AS field_position_5 FROM position t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 6 ]
9 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug_translation AS slug_translation_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM position_translation t0 WHERE t0.translatable_id = ?
Parameters:
0 of 0
[ 6 ]
10 0.46 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.field_position AS field_position_5 FROM position t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 5 ]
11 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug_translation AS slug_translation_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM position_translation t0 WHERE t0.translatable_id = ?
Parameters:
0 of 0
[ 5 ]
12 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 77120 ]
13 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 54709 ]
14 0.32 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.field_position AS field_position_5 FROM position t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 2 ]
15 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug_translation AS slug_translation_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM position_translation t0 WHERE t0.translatable_id = ?
Parameters:
0 of 0
[ 2 ]
16 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91109 ]
17 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 90488 ]
18 0.31 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.field_position AS field_position_5 FROM position t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 1 ]
19 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug_translation AS slug_translation_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM position_translation t0 WHERE t0.translatable_id = ?
Parameters:
0 of 0
[ 1 ]
20 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91102 ]
21 0.32 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.field_position AS field_position_5 FROM position t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 7 ]
22 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug_translation AS slug_translation_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM position_translation t0 WHERE t0.translatable_id = ?
Parameters:
0 of 0
[ 7 ]
23 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124533 ]
24 0.45 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124533 ]
25 1.02 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124533 "seasonplayer_id" => 127837 "alignment" => "%"id":124533%" "game_id" => 38327 ]
26 0.62 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124533 21431 ]
27 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124183 ]
28 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124181 ]
29 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124538 ]
30 0.69 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124538 ]
31 1.05 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124538 "seasonplayer_id" => 127842 "alignment" => "%"id":124538%" "game_id" => 38327 ]
32 0.39 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124538 21431 ]
33 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91084 ]
34 0.69 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 91084 ]
35 0.91 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 91084 "seasonplayer_id" => 127437 "alignment" => "%"id":91084%" "game_id" => 38327 ]
36 0.44 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 91084 21431 ]
37 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124180 ]
38 0.50 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124180 ]
39 0.91 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124180 "seasonplayer_id" => 127452 "alignment" => "%"id":124180%" "game_id" => 38327 ]
40 0.31 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124180 21431 ]
41 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124536 ]
42 0.51 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124536 ]
43 0.83 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124536 "seasonplayer_id" => 127840 "alignment" => "%"id":124536%" "game_id" => 38327 ]
44 0.33 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124536 21431 ]
45 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124178 ]
46 0.29 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.field_position AS field_position_5 FROM position t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 3 ]
47 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug_translation AS slug_translation_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM position_translation t0 WHERE t0.translatable_id = ?
Parameters:
0 of 0
[ 3 ]
48 0.45 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124178 ]
49 0.93 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124178 "seasonplayer_id" => 127450 "alignment" => "%"id":124178%" "game_id" => 38327 ]
50 0.34 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124178 21431 ]
51 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124179 ]
52 0.44 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124179 ]
53 1.01 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124179 "seasonplayer_id" => 127451 "alignment" => "%"id":124179%" "game_id" => 38327 ]
54 0.35 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124179 21431 ]
55 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124238 ]
56 0.43 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.field_position AS field_position_5 FROM position t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 4 ]
57 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug_translation AS slug_translation_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM position_translation t0 WHERE t0.translatable_id = ?
Parameters:
0 of 0
[ 4 ]
58 0.45 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124238 ]
59 1.24 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124238 "seasonplayer_id" => 127511 "alignment" => "%"id":124238%" "game_id" => 38327 ]
60 0.31 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124238 21431 ]
61 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91098 ]
62 0.54 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 91098 ]
63 0.89 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 91098 "seasonplayer_id" => 127438 "alignment" => "%"id":91098%" "game_id" => 38327 ]
64 0.58 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 91098 21431 ]
65 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124888 ]
66 0.48 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124888 ]
67 0.94 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124888 "seasonplayer_id" => 128253 "alignment" => "%"id":124888%" "game_id" => 38327 ]
68 0.29 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124888 21431 ]
69 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124301 ]
70 0.42 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124301 ]
71 1.13 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124301 "seasonplayer_id" => 127587 "alignment" => "%"id":124301%" "game_id" => 38327 ]
72 0.31 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124301 21431 ]
73 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124534 ]
74 0.58 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124534 ]
75 0.87 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124534 "seasonplayer_id" => 127838 "alignment" => "%"id":124534%" "game_id" => 38327 ]
76 0.28 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124534 21431 ]
77 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91082 ]
78 0.54 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 91082 ]
79 1.21 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 91082 "seasonplayer_id" => 127439 "alignment" => "%"id":91082%" "game_id" => 38327 ]
80 0.35 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 91082 21431 ]
81 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91111 ]
82 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124532 ]
83 0.39 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124532 ]
84 0.77 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124532 "seasonplayer_id" => 127836 "alignment" => "%"id":124532%" "game_id" => 38327 ]
85 0.39 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124532 21431 ]
86 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91099 ]
87 0.52 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 91099 ]
88 0.84 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 91099 "seasonplayer_id" => 127512 "alignment" => "%"id":91099%" "game_id" => 38327 ]
89 0.28 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 91099 21431 ]
90 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91097 ]
91 0.67 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 91097 ]
92 1.13 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 91097 "seasonplayer_id" => 127442 "alignment" => "%"id":91097%" "game_id" => 38327 ]
93 0.25 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 91097 21431 ]
94 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124182 ]
95 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91103 ]
96 0.45 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 91103 ]
97 0.67 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 91103 "seasonplayer_id" => 127443 "alignment" => "%"id":91103%" "game_id" => 38327 ]
98 0.29 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 91103 21431 ]
99 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124535 ]
100 0.33 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124535 ]
101 0.63 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124535 "seasonplayer_id" => 127839 "alignment" => "%"id":124535%" "game_id" => 38327 ]
102 0.25 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124535 21431 ]
103 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124299 ]
104 0.30 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124299 ]
105 0.59 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124299 "seasonplayer_id" => 127585 "alignment" => "%"id":124299%" "game_id" => 38327 ]
106 0.24 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124299 21431 ]
107 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124302 ]
108 0.32 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124302 ]
109 0.73 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124302 "seasonplayer_id" => 127588 "alignment" => "%"id":124302%" "game_id" => 38327 ]
110 0.29 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124302 21431 ]
111 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124300 ]
112 0.32 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124300 ]
113 0.62 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124300 "seasonplayer_id" => 127586 "alignment" => "%"id":124300%" "game_id" => 38327 ]
114 0.27 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124300 21431 ]
115 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 120383 ]
116 0.58 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 120383 ]
117 0.81 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 120383 "seasonplayer_id" => 127448 "alignment" => "%"id":120383%" "game_id" => 38327 ]
118 0.37 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 120383 21431 ]
119 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91079 ]
120 0.49 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 91079 ]
121 0.62 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 91079 "seasonplayer_id" => 127441 "alignment" => "%"id":91079%" "game_id" => 38327 ]
122 0.29 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 91079 21431 ]
123 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124263 ]
124 0.43 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124263 ]
125 0.84 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124263 "seasonplayer_id" => 127537 "alignment" => "%"id":124263%" "game_id" => 38327 ]
126 0.38 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124263 21431 ]
127 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 94870 ]
128 0.55 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 94870 ]
129 0.68 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 94870 "seasonplayer_id" => 127444 "alignment" => "%"id":94870%" "game_id" => 38327 ]
130 0.28 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 94870 21431 ]
131 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 57748 ]
132 0.97 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 57748 ]
133 0.72 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 57748 "seasonplayer_id" => 127431 "alignment" => "%"id":57748%" "game_id" => 38327 ]
134 0.32 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 57748 21431 ]
135 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 124537 ]
136 0.39 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 124537 ]
137 0.71 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 124537 "seasonplayer_id" => 127841 "alignment" => "%"id":124537%" "game_id" => 38327 ]
138 0.89 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 124537 21431 ]
139 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 57756 ]
140 0.51 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 57756 ]
141 0.66 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 57756 "seasonplayer_id" => 127433 "alignment" => "%"id":57756%" "game_id" => 38327 ]
142 0.29 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 57756 21431 ]
143 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 91110 ]
144 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 57741 ]
145 0.68 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 57741 ]
146 0.90 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 57741 "seasonplayer_id" => 127456 "alignment" => "%"id":57741%" "game_id" => 38327 ]
147 0.52 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 57741 21431 ]
148 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 115816 ]
149 1.04 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 115816 ]
150 0.66 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 115816 "seasonplayer_id" => 128133 "alignment" => "%"id":115816%" "game_id" => 38327 ]
151 0.35 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 115816 21431 ]
152 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.age AS age_4, t0.weight AS weight_5, t0.height AS height_6, t0.shoes AS shoes_7, t0.image AS image_8, t0.updated_at AS updated_at_9, t0.skillful_leg AS skillful_leg_10, t0.is_active AS is_active_11, t0.birth_date AS birth_date_12, t0.phone AS phone_13, t0.email AS email_14, t0.number_document AS number_document_15, t0.health_card AS health_card_16, t0.date_of_birth AS date_of_birth_17, t0.medical_review_date AS medical_review_date_18, t0.last_club AS last_club_19, t0.deleted_at AS deleted_at_20, t0.position_id AS position_id_21, t0.secondary_position_id AS secondary_position_id_22, t0.country_id AS country_id_23 FROM player t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 108295 ]
153 0.59 ms
SELECT t0.id AS id_1, t0.games AS games_2, t0.goals AS goals_3, t0.yellow_card AS yellow_card_4, t0.red_card AS red_card_5, t0.dorsal AS dorsal_6, t0.is_active AS is_active_7, t0.deleted_at AS deleted_at_8, t0.season_id AS season_id_9, t0.player_id AS player_id_10 FROM season_player t0 WHERE t0.season_id = ? AND t0.player_id = ? LIMIT 1
Parameters:
0 of 0
[ 28031 108295 ]
154 0.92 ms
SELECT
        SUM(IF(gps.id IS NOT NULL AND gps.minutes > 0,1,0)) AS countPlayed,
        SUM(IF(gps.id IS NOT NULL,gps.minutes,0)) AS `minutes`,
        SUM(IF(gps.id IS NOT NULL,gps.red_cards,0)) AS `redCards`,
        SUM(IF(gps.id IS NOT NULL,gps.yellow_cards,0)) AS `yellowCards`,
        SUM(IF(gps.id IS NOT NULL,gps.kilometers_traveled,0)) AS `kilometersTraveled`,
        SUM(IF(gps.id IS NOT NULL,gps.shots_on_goal,0)) AS `shotsOnGoal`,
        SUM(IF(gps.id IS NOT NULL,gps.stolen_balls,0)) AS `stolenBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.penalties_committed,0)) AS `penaltiesCommitted`,
        SUM(IF(gps.id IS NOT NULL,gps.forced_penalties,0)) AS `forcedPenalties`,
        SUM(IF(gps.id IS NOT NULL,gps.stops_made,0)) AS `stopsMade`,
        SUM(IF(gps.id IS NOT NULL,gps.goals_conceded,0)) AS `goalsConceded`,
        SUM(IF(gps.id IS NOT NULL,gps.lost_balls,0)) AS `lostBalls`,
        SUM(IF(gps.id IS NOT NULL,gps.note,0)) AS `note`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `isTitular`,
        SUM(IF(gps.id IS NOT NULL,gps.is_titular,0)) AS `titularity`,
        SUM(IF(gps.id IS NOT NULL,gps.goal_assistances,0)) AS `goalAssistances`,
        SUM(IF(gps.id IS NOT NULL,gps.goals,0)) AS `goals`,
        SUM(IF(ga.id IS NOT NULL,1,0)) AS `gameAlignment`,
        COUNT(*) AS convocatory
        FROM
        game g
        INNER JOIN convocatoria c ON g.id = c.game_id
        INNER JOIN convocatoria_player cp ON c.id = cp.convocatoria_id AND cp.player_id = :player_id AND cp.is_active = 1
        LEFT JOIN game_player_statistics gps ON g.id = gps.game_id AND gps.seasonplayer_id = :seasonplayer_id  
        LEFT JOIN game_alignment ga ON ga.id = g.alignment_id AND ga.alignment LIKE :alignment
        WHERE
        g.id = :game_id AND g.deleted_at IS NULL
Parameters:
0 of 0
[ "player_id" => 108295 "seasonplayer_id" => 127449 "alignment" => "%"id":108295%" "game_id" => 38327 ]
155 0.36 ms
SELECT t0.player_id AS player_id_1, t0.convocatoria_id AS convocatoria_id_2, t0.is_active AS is_active_3, t0.justification_type_id AS justification_type_id_4 FROM convocatoria_player t0 WHERE t0.player_id = ? AND t0.convocatoria_id = ? LIMIT 1
Parameters:
0 of 0
[ 108295 21431 ]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Customer
  • The association App\Entity\Customer#exerciseQualifications refers to the owning side field App\Entity\ExerciseQualification#customer_id which does not exist.
App\Entity\Country No errors.
App\Entity\Season No errors.
App\Entity\Suggestion No errors.
App\Entity\CouponCustomer No errors.
App\Entity\Notification No errors.
App\Entity\ExerciseQualification
  • The association App\Entity\ExerciseQualification#exercise refers to the inverse side field App\Entity\Exercise#qualifications which does not exist.
  • The association App\Entity\ExerciseQualification#customer refers to the inverse side field App\Entity\Customer#exerciseQualification which does not exist.
  • The association App\Entity\ExerciseQualification#exercises refers to the owning side field App\Entity\Exercise#qualifications which does not exist.
App\Entity\Strategy No errors.
App\Entity\Player
  • The field App\Entity\Player#convocatorias is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Convocatoria#players does not contain the required 'inversedBy="convocatorias"' attribute.
  • The association App\Entity\Player#country refers to the inverse side field App\Entity\Country#player which does not exist.
App\Entity\Team
  • The association App\Entity\Team#typeSoccer refers to the inverse side field App\Entity\TypeSoccer#teams which does not exist.
App\Entity\SeasonPlayer
  • The association App\Entity\SeasonPlayer#minutes refers to the owning side field App\Entity\Minutes#player_id which does not exist.
  • The association App\Entity\SeasonPlayer#playerWeights refers to the owning side field App\Entity\PlayerWeight#season_player_id which does not exist.
  • The mappings App\Entity\SeasonPlayer#captainInGames and App\Entity\GameAlignment#seasonplayer are inconsistent with each other.
App\Entity\Game
  • The association App\Entity\Game#minutes refers to the owning side field App\Entity\Minutes#game_id which does not exist.
  • The mappings App\Entity\Game#rival_alignment and App\Entity\GameAlignment#game are inconsistent with each other.
  • The mappings App\Entity\Game#seasonplayer and App\Entity\GamePlayerStatistics#game are inconsistent with each other.
App\Entity\TrainingAsist No errors.
App\Entity\ExerciseCalendar
  • The association App\Entity\ExerciseCalendar#exerciseUser refers to the inverse side field App\Entity\ExerciseUser#exerciseCalendar which does not exist.
App\Entity\PlayerJustification No errors.
App\Entity\Locality No errors.
App\Entity\Convocatoria
  • The association App\Entity\Convocatoria#players refers to the owning side field App\Entity\ConvocatoriaPlayer#convocatoria which does not exist.
App\Entity\Competition No errors.
App\Entity\GameAlignment
  • The association App\Entity\GameAlignment#seasonplayer refers to the inverse side field App\Entity\SeasonPlayer#GameAlignment which does not exist.
App\Entity\Difficulty No errors.
App\Entity\Minutes No errors.
App\Entity\KilometersTraveled No errors.
App\Entity\ShotsOnGoal No errors.
App\Entity\GamePlayerStatistics No errors.
App\Entity\ConvocatoriaPlayer No errors.
App\Entity\PlayerWeight
  • The mappings App\Entity\PlayerWeight#seasonPlayer and App\Entity\SeasonPlayer#playerWeights are inconsistent with each other.
App\Entity\PlayerSportsInjuries No errors.
App\Entity\Position No errors.
App\Entity\PositionTranslation No errors.
App\Entity\JustificationType No errors.