| 1 |
0.88 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.username AS username_5, u0_.salt AS salt_6, u0_.google_id AS google_id_7, u0_.facebook_id AS facebook_id_8, u0_.old_id AS old_id_9, u0_.creation_date AS creation_date_10, u0_.last_login AS last_login_11, u0_.newsletter AS newsletter_12, u0_.state AS state_13, u0_.period_grace AS period_grace_14, u0_.deleted_at AS deleted_at_15, u0_.apple_id AS apple_id_16, u0_.longitude AS longitude_17, u0_.latitude AS latitude_18 FROM `user` u0_ WHERE u0_.username = ? OR u0_.email = ?
Parameters: [
"Webmaster"
"Webmaster"
]
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.username AS username_5, u0_.salt AS salt_6, u0_.google_id AS google_id_7, u0_.facebook_id AS facebook_id_8, u0_.old_id AS old_id_9, u0_.creation_date AS creation_date_10, u0_.last_login AS last_login_11, u0_.newsletter AS newsletter_12, u0_.state AS state_13, u0_.period_grace AS period_grace_14, u0_.deleted_at AS deleted_at_15, u0_.apple_id AS apple_id_16, u0_.longitude AS longitude_17, u0_.latitude AS latitude_18 FROM `user` u0_ WHERE u0_.username = 'Webmaster' OR u0_.email = 'Webmaster';
|
| 2 |
0.27 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.sex AS sex_6, t0.index_r AS index_r_7, t0.index_v AS index_v_8, t0.year_of_birth AS year_of_birth_9, t0.newsletter AS newsletter_10, t0.colors AS colors_11, t0.border AS border_12, t0.text_colors AS text_colors_13, t0.nb_shoot AS nb_shoot_14, t0.distance AS distance_15, t0.nb_card AS nb_card_16, t0.nb_competition AS nb_competition_17, t0.used_in_mean_r AS used_in_mean_r_18, t0.avatar AS avatar_19, t0.stableford_setting AS stableford_setting_20, t0.last_for_mean_r AS last_for_mean_r_21, t0.share_public_enabled AS share_public_enabled_22, t0.share_public_slug AS share_public_slug_23, t0.test_sg AS test_sg_24, t0.user_id AS user_id_25 FROM player t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.sex AS sex_6, t0.index_r AS index_r_7, t0.index_v AS index_v_8, t0.year_of_birth AS year_of_birth_9, t0.newsletter AS newsletter_10, t0.colors AS colors_11, t0.border AS border_12, t0.text_colors AS text_colors_13, t0.nb_shoot AS nb_shoot_14, t0.distance AS distance_15, t0.nb_card AS nb_card_16, t0.nb_competition AS nb_competition_17, t0.used_in_mean_r AS used_in_mean_r_18, t0.avatar AS avatar_19, t0.stableford_setting AS stableford_setting_20, t0.last_for_mean_r AS last_for_mean_r_21, t0.share_public_enabled AS share_public_enabled_22, t0.share_public_slug AS share_public_slug_23, t0.test_sg AS test_sg_24, t0.user_id AS user_id_25 FROM player t0 WHERE t0.user_id = 3;
|
| 3 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.line1 AS line1_3, t0.line2 AS line2_4, t0.line3 AS line3_5, t0.city AS city_6, t0.country AS country_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.state AS state_10, t0.last_name AS last_name_11, t0.first_name AS first_name_12, t0.postal_code AS postal_code_13, t0.public_name AS public_name_14, t0.user_id AS user_id_15, t0.golf_id AS golf_id_16, t17.id AS id_18, t17.amount AS amount_19, t17.token AS token_20, t17.state AS state_21, t17.pro_id AS pro_id_22 FROM pro t0 LEFT JOIN budget t17 ON t17.pro_id = t0.id WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.line1 AS line1_3, t0.line2 AS line2_4, t0.line3 AS line3_5, t0.city AS city_6, t0.country AS country_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.state AS state_10, t0.last_name AS last_name_11, t0.first_name AS first_name_12, t0.postal_code AS postal_code_13, t0.public_name AS public_name_14, t0.user_id AS user_id_15, t0.golf_id AS golf_id_16, t17.id AS id_18, t17.amount AS amount_19, t17.token AS token_20, t17.state AS state_21, t17.pro_id AS pro_id_22 FROM pro t0 LEFT JOIN budget t17 ON t17.pro_id = t0.id WHERE t0.user_id = 3;
|
| 4 |
0.20 ms |
SELECT c0_.id AS id_0, c0_.note AS note_1, c0_.hole_number AS hole_number_2, c0_.created_at AS created_at_3, c0_.update_at AS update_at_4, c1_.id AS id_5, c1_.name AS name_6, c1_.slug_web AS slug_web_7, c1_.old_slug_web AS old_slug_web_8, c1_.enabled AS enabled_9, c1_.holes_number AS holes_number_10, c1_.type AS type_11, c1_.code AS code_12, c1_.token AS token_13, c1_.creation_date AS creation_date_14, c1_.update_date AS update_date_15, c1_.ffg_slug AS ffg_slug_16, c1_.slug AS slug_17, c1_.golf_name AS golf_name_18, c1_.update_needed AS update_needed_19, p2_.id AS id_20, p2_.image_name AS image_name_21, p2_.updated_at AS updated_at_22, p2_.first_name AS first_name_23, p2_.last_name AS last_name_24, p2_.sex AS sex_25, p2_.index_r AS index_r_26, p2_.index_v AS index_v_27, p2_.year_of_birth AS year_of_birth_28, p2_.newsletter AS newsletter_29, p2_.colors AS colors_30, p2_.border AS border_31, p2_.text_colors AS text_colors_32, p2_.nb_shoot AS nb_shoot_33, p2_.distance AS distance_34, p2_.nb_card AS nb_card_35, p2_.nb_competition AS nb_competition_36, p2_.used_in_mean_r AS used_in_mean_r_37, p2_.avatar AS avatar_38, p2_.stableford_setting AS stableford_setting_39, p2_.last_for_mean_r AS last_for_mean_r_40, p2_.share_public_enabled AS share_public_enabled_41, p2_.share_public_slug AS share_public_slug_42, p2_.test_sg AS test_sg_43, c0_.course_id AS course_id_44, c0_.player_id AS player_id_45, c1_.golf_id AS golf_id_46, c1_.owner_id AS owner_id_47, p2_.user_id AS user_id_48 FROM comment_item c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id INNER JOIN player p2_ ON c0_.player_id = p2_.id WHERE c0_.player_id = ? AND c0_.course_id = ? ORDER BY c0_.id ASC LIMIT 30
SELECT
c0_.id AS id_0,
c0_.note AS note_1,
c0_.hole_number AS hole_number_2,
c0_.created_at AS created_at_3,
c0_.update_at AS update_at_4,
c1_.id AS id_5,
c1_.name AS name_6,
c1_.slug_web AS slug_web_7,
c1_.old_slug_web AS old_slug_web_8,
c1_.enabled AS enabled_9,
c1_.holes_number AS holes_number_10,
c1_.type AS type_11,
c1_.code AS code_12,
c1_.token AS token_13,
c1_.creation_date AS creation_date_14,
c1_.update_date AS update_date_15,
c1_.ffg_slug AS ffg_slug_16,
c1_.slug AS slug_17,
c1_.golf_name AS golf_name_18,
c1_.update_needed AS update_needed_19,
p2_.id AS id_20,
p2_.image_name AS image_name_21,
p2_.updated_at AS updated_at_22,
p2_.first_name AS first_name_23,
p2_.last_name AS last_name_24,
p2_.sex AS sex_25,
p2_.index_r AS index_r_26,
p2_.index_v AS index_v_27,
p2_.year_of_birth AS year_of_birth_28,
p2_.newsletter AS newsletter_29,
p2_.colors AS colors_30,
p2_.border AS border_31,
p2_.text_colors AS text_colors_32,
p2_.nb_shoot AS nb_shoot_33,
p2_.distance AS distance_34,
p2_.nb_card AS nb_card_35,
p2_.nb_competition AS nb_competition_36,
p2_.used_in_mean_r AS used_in_mean_r_37,
p2_.avatar AS avatar_38,
p2_.stableford_setting AS stableford_setting_39,
p2_.last_for_mean_r AS last_for_mean_r_40,
p2_.share_public_enabled AS share_public_enabled_41,
p2_.share_public_slug AS share_public_slug_42,
p2_.test_sg AS test_sg_43,
c0_.course_id AS course_id_44,
c0_.player_id AS player_id_45,
c1_.golf_id AS golf_id_46,
c1_.owner_id AS owner_id_47,
p2_.user_id AS user_id_48
FROM
comment_item c0_
LEFT JOIN course c1_ ON c0_.course_id = c1_.id
INNER JOIN player p2_ ON c0_.player_id = p2_.id
WHERE
c0_.player_id = ?
AND c0_.course_id = ?
ORDER BY
c0_.id ASC
LIMIT
30
SELECT c0_.id AS id_0, c0_.note AS note_1, c0_.hole_number AS hole_number_2, c0_.created_at AS created_at_3, c0_.update_at AS update_at_4, c1_.id AS id_5, c1_.name AS name_6, c1_.slug_web AS slug_web_7, c1_.old_slug_web AS old_slug_web_8, c1_.enabled AS enabled_9, c1_.holes_number AS holes_number_10, c1_.type AS type_11, c1_.code AS code_12, c1_.token AS token_13, c1_.creation_date AS creation_date_14, c1_.update_date AS update_date_15, c1_.ffg_slug AS ffg_slug_16, c1_.slug AS slug_17, c1_.golf_name AS golf_name_18, c1_.update_needed AS update_needed_19, p2_.id AS id_20, p2_.image_name AS image_name_21, p2_.updated_at AS updated_at_22, p2_.first_name AS first_name_23, p2_.last_name AS last_name_24, p2_.sex AS sex_25, p2_.index_r AS index_r_26, p2_.index_v AS index_v_27, p2_.year_of_birth AS year_of_birth_28, p2_.newsletter AS newsletter_29, p2_.colors AS colors_30, p2_.border AS border_31, p2_.text_colors AS text_colors_32, p2_.nb_shoot AS nb_shoot_33, p2_.distance AS distance_34, p2_.nb_card AS nb_card_35, p2_.nb_competition AS nb_competition_36, p2_.used_in_mean_r AS used_in_mean_r_37, p2_.avatar AS avatar_38, p2_.stableford_setting AS stableford_setting_39, p2_.last_for_mean_r AS last_for_mean_r_40, p2_.share_public_enabled AS share_public_enabled_41, p2_.share_public_slug AS share_public_slug_42, p2_.test_sg AS test_sg_43, c0_.course_id AS course_id_44, c0_.player_id AS player_id_45, c1_.golf_id AS golf_id_46, c1_.owner_id AS owner_id_47, p2_.user_id AS user_id_48 FROM comment_item c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id INNER JOIN player p2_ ON c0_.player_id = p2_.id WHERE c0_.player_id = 3 AND c0_.course_id = '93' ORDER BY c0_.id ASC LIMIT 30;
|