| 1 |
1.93 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 877;
|
| 2 |
1.78 ms
|
SELECT t0.id AS id_1, t0.clubee_id AS clubee_id_2, t0.name AS name_3 FROM "season" t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"2026/2027"
]
SELECT t0.id AS id_1, t0.clubee_id AS clubee_id_2, t0.name AS name_3 FROM "season" t0 WHERE t0.name = '2026/2027' LIMIT 1;
|
| 3 |
3.46 ms
|
SELECT c0_.id AS id_0, c0_.search_name AS search_name_1, c0_.gender AS gender_2, c0_.region AS region_3, c0_.category AS category_4, c0_.type AS type_5, c0_.active AS active_6, c0_.scanned_at AS scanned_at_7, c0_.name AS name_8, c0_.clubee_id AS clubee_id_9, COUNT(g1_.id) AS sclr_10, CASE WHEN c0_.season_id = ? THEN 0 ELSE 1 END AS sclr_11, c0_.season_id AS season_id_12 FROM "competition" c0_ INNER JOIN "game" g1_ ON c0_.id = g1_.competition_id WHERE g1_.home_team_id = ? OR g1_.away_team_id = ? GROUP BY c0_.id ORDER BY sclr_11 ASC, sclr_10 DESC LIMIT 1
Parameters: [
1
877
877
]
SELECT c0_.id AS id_0, c0_.search_name AS search_name_1, c0_.gender AS gender_2, c0_.region AS region_3, c0_.category AS category_4, c0_.type AS type_5, c0_.active AS active_6, c0_.scanned_at AS scanned_at_7, c0_.name AS name_8, c0_.clubee_id AS clubee_id_9, COUNT(g1_.id) AS sclr_10, CASE WHEN c0_.season_id = 1 THEN 0 ELSE 1 END AS sclr_11, c0_.season_id AS season_id_12 FROM "competition" c0_ INNER JOIN "game" g1_ ON c0_.id = g1_.competition_id WHERE g1_.home_team_id = 877 OR g1_.away_team_id = 877 GROUP BY c0_.id ORDER BY sclr_11 ASC, sclr_10 DESC LIMIT 1;
|
| 4 |
7.46 ms
|
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE (g0_.home_team_id = ? OR g0_.away_team_id = ?) AND g0_.starts_at >= ? AND g0_.cancelled = false ORDER BY g0_.starts_at ASC LIMIT 1
Parameters: [
877
877
"2026-08-29 00:00:00"
]
SELECT
g0_.id AS id_0,
g0_.home_score AS home_score_1,
g0_.away_score AS away_score_2,
g0_.cancelled AS cancelled_3,
g0_.forfeit AS forfeit_4,
g0_.completed AS completed_5,
g0_.phase_clubee_id AS phase_clubee_id_6,
g0_.phase_name AS phase_name_7,
g0_.updated_at AS updated_at_8,
g0_.result_recorded_at AS result_recorded_at_9,
g0_.detail_fetched_at AS detail_fetched_at_10,
g0_.clubee_id AS clubee_id_11,
g0_.starts_at AS starts_at_12,
g0_.venue_name AS venue_name_13,
g0_.venue_street AS venue_street_14,
g0_.venue_city AS venue_city_15,
g0_.venue_zip AS venue_zip_16,
g0_.venue_country AS venue_country_17,
g0_.venue_latitude AS venue_latitude_18,
g0_.venue_longitude AS venue_longitude_19,
t1_.id AS id_20,
t1_.search_name AS search_name_21,
t1_.subname AS subname_22,
t1_.category AS category_23,
t1_.gender AS gender_24,
t1_.crest_url AS crest_url_25,
t1_.name AS name_26,
t1_.normalized_name AS normalized_name_27,
t1_.clubee_id AS clubee_id_28,
t2_.id AS id_29,
t2_.search_name AS search_name_30,
t2_.subname AS subname_31,
t2_.category AS category_32,
t2_.gender AS gender_33,
t2_.crest_url AS crest_url_34,
t2_.name AS name_35,
t2_.normalized_name AS normalized_name_36,
t2_.clubee_id AS clubee_id_37,
c3_.id AS id_38,
c3_.search_name AS search_name_39,
c3_.gender AS gender_40,
c3_.region AS region_41,
c3_.category AS category_42,
c3_.type AS type_43,
c3_.active AS active_44,
c3_.scanned_at AS scanned_at_45,
c3_.name AS name_46,
c3_.clubee_id AS clubee_id_47,
g0_.home_team_id AS home_team_id_48,
g0_.away_team_id AS away_team_id_49,
g0_.competition_id AS competition_id_50,
g0_.season_id AS season_id_51,
t1_.club_id AS club_id_52,
t2_.club_id AS club_id_53,
c3_.season_id AS season_id_54
FROM
"game" g0_
INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id
INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id
INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id
WHERE
(
g0_.home_team_id = ?
OR g0_.away_team_id = ?
)
AND g0_.starts_at >= ?
AND g0_.cancelled = false
ORDER BY
g0_.starts_at ASC
LIMIT
1
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE (g0_.home_team_id = 877 OR g0_.away_team_id = 877) AND g0_.starts_at >= '2026-08-29 00:00:00' AND g0_.cancelled = false ORDER BY g0_.starts_at ASC LIMIT 1;
|
| 5 |
1.75 ms
|
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE (g0_.home_team_id = ? OR g0_.away_team_id = ?) AND g0_.home_score IS NOT NULL AND g0_.away_score IS NOT NULL ORDER BY g0_.starts_at DESC LIMIT 1
SELECT
g0_.id AS id_0,
g0_.home_score AS home_score_1,
g0_.away_score AS away_score_2,
g0_.cancelled AS cancelled_3,
g0_.forfeit AS forfeit_4,
g0_.completed AS completed_5,
g0_.phase_clubee_id AS phase_clubee_id_6,
g0_.phase_name AS phase_name_7,
g0_.updated_at AS updated_at_8,
g0_.result_recorded_at AS result_recorded_at_9,
g0_.detail_fetched_at AS detail_fetched_at_10,
g0_.clubee_id AS clubee_id_11,
g0_.starts_at AS starts_at_12,
g0_.venue_name AS venue_name_13,
g0_.venue_street AS venue_street_14,
g0_.venue_city AS venue_city_15,
g0_.venue_zip AS venue_zip_16,
g0_.venue_country AS venue_country_17,
g0_.venue_latitude AS venue_latitude_18,
g0_.venue_longitude AS venue_longitude_19,
t1_.id AS id_20,
t1_.search_name AS search_name_21,
t1_.subname AS subname_22,
t1_.category AS category_23,
t1_.gender AS gender_24,
t1_.crest_url AS crest_url_25,
t1_.name AS name_26,
t1_.normalized_name AS normalized_name_27,
t1_.clubee_id AS clubee_id_28,
t2_.id AS id_29,
t2_.search_name AS search_name_30,
t2_.subname AS subname_31,
t2_.category AS category_32,
t2_.gender AS gender_33,
t2_.crest_url AS crest_url_34,
t2_.name AS name_35,
t2_.normalized_name AS normalized_name_36,
t2_.clubee_id AS clubee_id_37,
c3_.id AS id_38,
c3_.search_name AS search_name_39,
c3_.gender AS gender_40,
c3_.region AS region_41,
c3_.category AS category_42,
c3_.type AS type_43,
c3_.active AS active_44,
c3_.scanned_at AS scanned_at_45,
c3_.name AS name_46,
c3_.clubee_id AS clubee_id_47,
g0_.home_team_id AS home_team_id_48,
g0_.away_team_id AS away_team_id_49,
g0_.competition_id AS competition_id_50,
g0_.season_id AS season_id_51,
t1_.club_id AS club_id_52,
t2_.club_id AS club_id_53,
c3_.season_id AS season_id_54
FROM
"game" g0_
INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id
INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id
INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id
WHERE
(
g0_.home_team_id = ?
OR g0_.away_team_id = ?
)
AND g0_.home_score IS NOT NULL
AND g0_.away_score IS NOT NULL
ORDER BY
g0_.starts_at DESC
LIMIT
1
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE (g0_.home_team_id = 877 OR g0_.away_team_id = 877) AND g0_.home_score IS NOT NULL AND g0_.away_score IS NOT NULL ORDER BY g0_.starts_at DESC LIMIT 1;
|
| 6 |
1.81 ms
|
SELECT r0_.id AS id_0, r0_.captured_at AS captured_at_1, r0_.hash AS hash_2, r0_.competition_id AS competition_id_3 FROM "ranking_snapshot" r0_ INNER JOIN "ranking_entry" r1_ ON r0_.id = r1_.snapshot_id INNER JOIN "competition" c2_ ON r0_.competition_id = c2_.id WHERE r1_.team_id = ? AND c2_.clubee_id = ? ORDER BY r0_.captured_at DESC LIMIT 1
Parameters: [
877
11021
]
SELECT r0_.id AS id_0, r0_.captured_at AS captured_at_1, r0_.hash AS hash_2, r0_.competition_id AS competition_id_3 FROM "ranking_snapshot" r0_ INNER JOIN "ranking_entry" r1_ ON r0_.id = r1_.snapshot_id INNER JOIN "competition" c2_ ON r0_.competition_id = c2_.id WHERE r1_.team_id = 877 AND c2_.clubee_id = 11021 ORDER BY r0_.captured_at DESC LIMIT 1;
|
| 7 |
2.30 ms
|
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE g0_.home_team_id = ? OR g0_.away_team_id = ? ORDER BY g0_.starts_at ASC
SELECT
g0_.id AS id_0,
g0_.home_score AS home_score_1,
g0_.away_score AS away_score_2,
g0_.cancelled AS cancelled_3,
g0_.forfeit AS forfeit_4,
g0_.completed AS completed_5,
g0_.phase_clubee_id AS phase_clubee_id_6,
g0_.phase_name AS phase_name_7,
g0_.updated_at AS updated_at_8,
g0_.result_recorded_at AS result_recorded_at_9,
g0_.detail_fetched_at AS detail_fetched_at_10,
g0_.clubee_id AS clubee_id_11,
g0_.starts_at AS starts_at_12,
g0_.venue_name AS venue_name_13,
g0_.venue_street AS venue_street_14,
g0_.venue_city AS venue_city_15,
g0_.venue_zip AS venue_zip_16,
g0_.venue_country AS venue_country_17,
g0_.venue_latitude AS venue_latitude_18,
g0_.venue_longitude AS venue_longitude_19,
t1_.id AS id_20,
t1_.search_name AS search_name_21,
t1_.subname AS subname_22,
t1_.category AS category_23,
t1_.gender AS gender_24,
t1_.crest_url AS crest_url_25,
t1_.name AS name_26,
t1_.normalized_name AS normalized_name_27,
t1_.clubee_id AS clubee_id_28,
t2_.id AS id_29,
t2_.search_name AS search_name_30,
t2_.subname AS subname_31,
t2_.category AS category_32,
t2_.gender AS gender_33,
t2_.crest_url AS crest_url_34,
t2_.name AS name_35,
t2_.normalized_name AS normalized_name_36,
t2_.clubee_id AS clubee_id_37,
c3_.id AS id_38,
c3_.search_name AS search_name_39,
c3_.gender AS gender_40,
c3_.region AS region_41,
c3_.category AS category_42,
c3_.type AS type_43,
c3_.active AS active_44,
c3_.scanned_at AS scanned_at_45,
c3_.name AS name_46,
c3_.clubee_id AS clubee_id_47,
g0_.home_team_id AS home_team_id_48,
g0_.away_team_id AS away_team_id_49,
g0_.competition_id AS competition_id_50,
g0_.season_id AS season_id_51,
t1_.club_id AS club_id_52,
t2_.club_id AS club_id_53,
c3_.season_id AS season_id_54
FROM
"game" g0_
INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id
INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id
INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id
WHERE
g0_.home_team_id = ?
OR g0_.away_team_id = ?
ORDER BY
g0_.starts_at ASC
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE g0_.home_team_id = 877 OR g0_.away_team_id = 877 ORDER BY g0_.starts_at ASC;
|
| 8 |
1.07 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.clubee_id AS clubee_id_3, t0.name AS name_4, t0.normalized_name AS normalized_name_5, t0.region AS region_6, t0.website AS website_7, t0.placeholder AS placeholder_8, t0.address_name AS address_name_9, t0.address_street AS address_street_10, t0.address_city AS address_city_11, t0.address_zip AS address_zip_12, t0.address_country AS address_country_13, t0.address_latitude AS address_latitude_14, t0.address_longitude AS address_longitude_15 FROM "club" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.clubee_id AS clubee_id_3, t0.name AS name_4, t0.normalized_name AS normalized_name_5, t0.region AS region_6, t0.website AS website_7, t0.placeholder AS placeholder_8, t0.address_name AS address_name_9, t0.address_street AS address_street_10, t0.address_city AS address_city_11, t0.address_zip AS address_zip_12, t0.address_country AS address_country_13, t0.address_latitude AS address_latitude_14, t0.address_longitude AS address_longitude_15 FROM "club" t0 WHERE t0.id = 40;
|
| 9 |
0.57 ms
|
SELECT t0.id AS id_1, t0.won AS won_2, t0.lost AS lost_3, t0.sets_won AS sets_won_4, t0.sets_lost AS sets_lost_5, t0.points_for AS points_for_6, t0.points_against AS points_against_7, t0.position AS position_8, t0.played AS played_9, t0.points AS points_10, t0.snapshot_id AS snapshot_id_11, t0.team_id AS team_id_12 FROM "ranking_entry" t0 WHERE t0.snapshot_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.won AS won_2, t0.lost AS lost_3, t0.sets_won AS sets_won_4, t0.sets_lost AS sets_lost_5, t0.points_for AS points_for_6, t0.points_against AS points_against_7, t0.position AS position_8, t0.played AS played_9, t0.points AS points_10, t0.snapshot_id AS snapshot_id_11, t0.team_id AS team_id_12 FROM "ranking_entry" t0 WHERE t0.snapshot_id = 23 ORDER BY t0.position ASC;
|
| 10 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 298;
|
| 11 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 300;
|
| 12 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 296;
|
| 13 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 299;
|
| 14 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 292;
|
| 15 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 396;
|
| 16 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 791;
|
| 17 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 399;
|
| 18 |
0.30 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 301;
|
| 19 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 474;
|
| 20 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 785;
|
| 21 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 297;
|
| 22 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 838;
|
| 23 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 398;
|
| 24 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 874;
|
| 25 |
0.28 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 831;
|
| 26 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 397;
|
| 27 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 834;
|
| 28 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 876;
|
| 29 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 391;
|
| 30 |
0.30 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 786;
|
| 31 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 467;
|
| 32 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 400;
|
| 33 |
0.28 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 875;
|
| 34 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 236;
|
| 35 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 235;
|
| 36 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 233;
|
| 37 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 243;
|
| 38 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 234;
|
| 39 |
0.30 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 291;
|
| 40 |
0.30 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 837;
|
| 41 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 468;
|
| 42 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 294;
|
| 43 |
0.28 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 95;
|
| 44 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 293;
|
| 45 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 393;
|
| 46 |
0.32 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 290;
|
| 47 |
0.33 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 239;
|
| 48 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 835;
|
| 49 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 242;
|
| 50 |
0.29 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 830;
|
| 51 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 832;
|
| 52 |
0.31 ms
|
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 394;
|