Query Metrics
138
Database Queries
10
Different statements
1037.94 ms
Query time
9
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 59.84 ms |
SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0
Parameters:
[ "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MjY5Mjk4ODYsImV4cCI6MTcyNjkzMzQ4Niwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6IndpZ3Nld21hckBjaG9jby5sYSJ9.L8JUhofQVvfPyGNRsI0CU0_oCJovCx_rUPvCeufLAj2dbiYrFz5s_zqYk0RfvNFe3hKg-cqlGxNXQ8_NyRm-heCHoPnOVIT_MDoYH6hGXSStRPW9RTBqWQE8RuSoqolt5Ssjpy0Mvh6qDsHpxYbEoMm2A1GWqFbuvVfl0X61OzlTXWQ__Ko-41VCsGYR-xQv2DmBlWKhoAeggeAiDp7uM-hFu_9qIkq0ZF_cXBJTxB7Sou3MPUMjosLn6PpEGBGdrIIEvwsWKuI6tuNSMgQ4ZrTKsggqjfk_o_ud9jwK0fl_PaUhBnATtV9QhI4x3zuCNq1DLl53-MkQiZJ6UyIBiRfg9VNnMS3voyJ4O8yjrXpKw0iDpJ6P3lHvIMz3kkNmrHr6nMXrOhq-dCWhQKYD_G6ZggMpuZiwHeqB77tOTIIMzcJTYox8xmUhsljtZ68GZI46VFTJyQ2mfejor-hpV_VyT2OE0G1r7fW6Wf6Ut2fh3nRZslNZtLUJZ1uJbMCD9XLpmOlf2MJSFUu6HquU9Pfmsk450_PErGMO5rUQMioMtLfJMnz19q1_NRLxttaIoHiBDD0CUsHtR2Vgiukdckv1j6IpgGMLMrAr6jFUgKxqaX3ew8qbMoynf86EtNr5mpTWVd-Oyg90IoBssFKC5ksZV2fMCECod71WUDgsry8" ] |
2 | 15.72 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:
[
"wigsewmar@choco.la"
]
|
3 | 15.98 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:
[
26272
]
|
4 | 11.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 = ?
Parameters:
[
27437
]
|
5 | 76.34 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:
[
118579
]
|
6 | 34.07 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121608 ] |
7 | 29.97 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
8 | 30.09 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118579 "season_id" => 27437 ] |
9 | 19.44 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
10 | 23.56 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118579 "season_id" => 27437 ] |
11 | 31.25 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:
[
1
]
|
12 | 14.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:
[
118670
]
|
13 | 8.10 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121700 ] |
14 | 12.21 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
15 | 11.01 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118670 "season_id" => 27437 ] |
16 | 9.62 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
17 | 2.94 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118670 "season_id" => 27437 ] |
18 | 6.34 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:
[
118671
]
|
19 | 2.92 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121701 ] |
20 | 4.61 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
21 | 4.03 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118671 "season_id" => 27437 ] |
22 | 4.60 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
23 | 7.91 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118671 "season_id" => 27437 ] |
24 | 4.65 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:
[
118672
]
|
25 | 6.70 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121702 ] |
26 | 5.50 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
27 | 6.66 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118672 "season_id" => 27437 ] |
28 | 3.23 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
29 | 4.60 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118672 "season_id" => 27437 ] |
30 | 9.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:
[
118673
]
|
31 | 4.43 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121703 ] |
32 | 6.39 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
33 | 5.18 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118673 "season_id" => 27437 ] |
34 | 5.45 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
35 | 6.33 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118673 "season_id" => 27437 ] |
36 | 7.55 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:
[
118674
]
|
37 | 4.83 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121704 ] |
38 | 3.47 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
39 | 9.74 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118674 "season_id" => 27437 ] |
40 | 6.52 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
41 | 4.68 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118674 "season_id" => 27437 ] |
42 | 6.05 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:
[
118675
]
|
43 | 7.43 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121705 ] |
44 | 6.22 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
45 | 3.83 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118675 "season_id" => 27437 ] |
46 | 8.69 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
47 | 1.18 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118675 "season_id" => 27437 ] |
48 | 4.87 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:
[
118676
]
|
49 | 7.08 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121706 ] |
50 | 1.45 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
51 | 7.40 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118676 "season_id" => 27437 ] |
52 | 6.88 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
53 | 5.60 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118676 "season_id" => 27437 ] |
54 | 3.14 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:
[
118677
]
|
55 | 7.26 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121707 ] |
56 | 2.17 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
57 | 2.96 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118677 "season_id" => 27437 ] |
58 | 9.14 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
59 | 3.75 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118677 "season_id" => 27437 ] |
60 | 5.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:
[
118678
]
|
61 | 4.72 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121708 ] |
62 | 2.07 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
63 | 2.51 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118678 "season_id" => 27437 ] |
64 | 3.69 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
65 | 1.44 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118678 "season_id" => 27437 ] |
66 | 3.53 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:
[
118679
]
|
67 | 6.31 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121709 ] |
68 | 2.48 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
69 | 6.79 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118679 "season_id" => 27437 ] |
70 | 3.11 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
71 | 8.52 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118679 "season_id" => 27437 ] |
72 | 9.10 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:
[
118680
]
|
73 | 2.24 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121710 ] |
74 | 2.82 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
75 | 5.55 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118680 "season_id" => 27437 ] |
76 | 4.59 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
77 | 5.61 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118680 "season_id" => 27437 ] |
78 | 2.88 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:
[
118681
]
|
79 | 11.61 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121711 ] |
80 | 5.09 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
81 | 7.61 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118681 "season_id" => 27437 ] |
82 | 8.76 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
83 | 9.43 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118681 "season_id" => 27437 ] |
84 | 3.92 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:
[
2
]
|
85 | 11.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:
[
118682
]
|
86 | 5.37 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121712 ] |
87 | 2.42 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
88 | 5.28 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118682 "season_id" => 27437 ] |
89 | 2.46 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
90 | 3.46 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118682 "season_id" => 27437 ] |
91 | 5.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:
[
118683
]
|
92 | 5.65 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121713 ] |
93 | 2.30 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
94 | 3.89 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118683 "season_id" => 27437 ] |
95 | 3.35 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
96 | 4.36 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118683 "season_id" => 27437 ] |
97 | 8.89 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:
[
118684
]
|
98 | 1.50 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121714 ] |
99 | 2.42 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
100 | 3.02 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118684 "season_id" => 27437 ] |
101 | 9.21 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
102 | 3.55 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118684 "season_id" => 27437 ] |
103 | 11.02 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:
[
118685
]
|
104 | 1.99 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121715 ] |
105 | 2.15 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
106 | 11.64 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118685 "season_id" => 27437 ] |
107 | 6.91 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
108 | 11.95 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118685 "season_id" => 27437 ] |
109 | 3.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:
[
118686
]
|
110 | 5.88 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121716 ] |
111 | 1.71 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
112 | 4.44 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118686 "season_id" => 27437 ] |
113 | 2.43 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
114 | 7.58 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118686 "season_id" => 27437 ] |
115 | 15.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:
[
118687
]
|
116 | 17.92 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121717 ] |
117 | 2.71 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
118 | 9.12 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118687 "season_id" => 27437 ] |
119 | 5.62 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
120 | 6.22 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118687 "season_id" => 27437 ] |
121 | 2.88 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:
[
118688
]
|
122 | 1.56 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121718 ] |
123 | 5.99 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
124 | 1.63 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118688 "season_id" => 27437 ] |
125 | 4.42 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
126 | 4.84 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118688 "season_id" => 27437 ] |
127 | 2.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:
[
118831
]
|
128 | 2.41 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 121873 ] |
129 | 2.28 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
130 | 2.45 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 118831 "season_id" => 27437 ] |
131 | 2.75 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
132 | 3.88 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 118831 "season_id" => 27437 ] |
133 | 4.01 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:
[
119481
]
|
134 | 1.92 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.note AS note_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.finish AS finish_6, t0.season_player_id AS season_player_id_7, t0.season_id AS season_id_8 FROM player_sports_injuries t0 WHERE t0.season_id = ? AND t0.season_player_id = ?
Parameters:
[ 27437 122553 ] |
135 | 7.59 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
136 | 1.62 ms |
SELECT SUM(IF(pj.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(pj.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(pj.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(pj.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(pj.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(pj.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(pj.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(pj.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(pj.justification_type_id = 9,1,0)) AS justification_9, COUNT(pj.id) AS justificationTotal FROM player_justification AS pj WHERE pj.season_id = :season_id AND pj.player_id = :player_id AND pj.is_active = 1 GROUP BY pj.season_id;
Parameters:
[ "player_id" => 119481 "season_id" => 27437 ] |
137 | 2.26 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.created_at AS created_at_3, t0.nro_order AS nro_order_4, t0.show_training AS show_training_5, t0.show_announcement AS show_announcement_6 FROM justification_type t0
Parameters:
[] |
138 | 2.73 ms |
SELECT SUM(IF(cp.justification_type_id IS NULL,1,0)) AS justificationOld, SUM(IF(cp.justification_type_id = 1,1,0)) AS justification_1,SUM(IF(cp.justification_type_id = 2,1,0)) AS justification_2,SUM(IF(cp.justification_type_id = 3,1,0)) AS justification_3,SUM(IF(cp.justification_type_id = 4,1,0)) AS justification_4,SUM(IF(cp.justification_type_id = 5,1,0)) AS justification_5,SUM(IF(cp.justification_type_id = 6,1,0)) AS justification_6,SUM(IF(cp.justification_type_id = 7,1,0)) AS justification_7,SUM(IF(cp.justification_type_id = 8,1,0)) AS justification_8,SUM(IF(cp.justification_type_id = 9,1,0)) AS justification_9, SUM(IF(cp.justification_type_id > 0,1,0)) AS justificationTotal 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 = 0 WHERE g.season_id = :season_id AND cp.player_id = :player_id AND cp.is_active = 0 AND g.deleted_at IS NULL GROUP BY g.season_id;
Parameters:
[ "player_id" => 119481 "season_id" => 27437 ] |
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 |
|
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 |
|
App\Entity\Strategy | No errors. |
App\Entity\Player |
|
App\Entity\Team |
|
App\Entity\SeasonPlayer |
|
App\Entity\Game |
|
App\Entity\TrainingAsist | No errors. |
App\Entity\ExerciseCalendar |
|
App\Entity\PlayerJustification | No errors. |
App\Entity\Minutes | No errors. |
App\Entity\KilometersTraveled | No errors. |
App\Entity\ShotsOnGoal | No errors. |
App\Entity\PlayerWeight |
|
App\Entity\GamePlayerStatistics | No errors. |
App\Entity\PlayerSportsInjuries | No errors. |
App\Entity\Position | No errors. |
App\Entity\Convocatoria |
|
App\Entity\JustificationType | No errors. |
App\Entity\JustificationTypeTranslation | No errors. |
App\Entity\PositionTranslation | No errors. |