| 1 |
1.98 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 = 137;
|
| 2 |
1.65 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 |
2.90 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
137
137
]
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 = 137 OR g1_.away_team_id = 137 GROUP BY c0_.id ORDER BY sclr_11 ASC, sclr_10 DESC LIMIT 1;
|
| 4 |
2.47 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: [
137
137
"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 = 137 OR g0_.away_team_id = 137) AND g0_.starts_at >= '2026-08-29 00:00:00' AND g0_.cancelled = false ORDER BY g0_.starts_at ASC LIMIT 1;
|
| 5 |
1.34 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 = 137 OR g0_.away_team_id = 137) AND g0_.home_score IS NOT NULL AND g0_.away_score IS NOT NULL ORDER BY g0_.starts_at DESC LIMIT 1;
|
| 6 |
1.33 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: [
137
10766
]
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 = 137 AND c2_.clubee_id = 10766 ORDER BY r0_.captured_at DESC LIMIT 1;
|
| 7 |
1.87 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 = 137 OR g0_.away_team_id = 137 ORDER BY g0_.starts_at ASC;
|
| 8 |
0.49 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 = 119 ORDER BY t0.position ASC;
|
| 9 |
0.27 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 = 144;
|
| 10 |
0.26 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 = 140;
|
| 11 |
0.26 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 = 126;
|
| 12 |
0.26 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 = 135;
|
| 13 |
0.26 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 = 127;
|
| 14 |
0.26 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 = 139;
|
| 15 |
0.23 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 = 130;
|
| 16 |
0.23 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 = 145;
|
| 17 |
0.22 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 = 187;
|
| 18 |
0.20 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 = 86;
|
| 19 |
0.20 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 = 125;
|
| 20 |
0.24 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 = 44;
|
| 21 |
0.25 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 = 136;
|
| 22 |
0.24 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 = 143;
|
| 23 |
0.26 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 = 123;
|
| 24 |
0.25 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 = 124;
|
| 25 |
0.22 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 = 56;
|
| 26 |
0.22 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 = 141;
|
| 27 |
0.20 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 = 51;
|
| 28 |
0.23 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 = 191;
|
| 29 |
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 = 133;
|
| 30 |
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 = 146;
|
| 31 |
0.23 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 = 52;
|
| 32 |
0.21 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 = 128;
|
| 33 |
0.20 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 = 129;
|
| 34 |
0.20 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 = 43;
|
| 35 |
0.20 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 = 202;
|
| 36 |
0.20 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 = 228;
|
| 37 |
0.20 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 = 54;
|
| 38 |
0.20 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 = 132;
|
| 39 |
0.19 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 = 142;
|
| 40 |
0.24 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 = 194;
|
| 41 |
0.23 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 = 131;
|
| 42 |
0.26 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 = 134;
|
| 43 |
0.24 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 = 192;
|
| 44 |
0.24 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 = 45;
|
| 45 |
0.23 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 = 37;
|
| 46 |
0.25 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 = 85;
|
| 47 |
0.24 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 = 38;
|
| 48 |
0.24 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 = 48;
|
| 49 |
0.25 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 = 147;
|