| 2 |
0.92 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.password AS password_5, t0.nif AS nif_6, t0.address1 AS address1_7, t0.address2 AS address2_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.state AS state_11, t0.country AS country_12, t0.phone AS phone_13, t0.points AS points_14, t0.roles AS roles_15, t0.verified_at AS verified_at_16, t0.authentication_token AS authentication_token_17, t0.time_expiration AS time_expiration_18, t0.image_path AS image_path_19, t0.is_exclusive AS is_exclusive_20, t0.username AS username_21, t0.nfc_id AS nfc_id_22, t0.refresh_token AS refresh_token_23, t0.preferred_language AS preferred_language_24, t0.marketing_consent AS marketing_consent_25, t0.birth_date AS birth_date_26, t0.favorite_wine AS favorite_wine_27, t0.wine_type_preferences AS wine_type_preferences_28, t0.suggestions AS suggestions_29, t0.preferred_form_of_address AS preferred_form_of_address_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t33.id AS id_34, t33.endpoint AS endpoint_35, t33.public_key AS public_key_36, t33.auth_token AS auth_token_37, t33.created_at AS created_at_38, t33.updated_at AS updated_at_39, t33.user_id AS user_id_40, t0.email_group_id AS email_group_id_41 FROM users t0 LEFT JOIN user_subscription t33 ON t33.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters: [
"gonzalo@dracoder.com"
]
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.password AS password_5, t0.nif AS nif_6, t0.address1 AS address1_7, t0.address2 AS address2_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.state AS state_11, t0.country AS country_12, t0.phone AS phone_13, t0.points AS points_14, t0.roles AS roles_15, t0.verified_at AS verified_at_16, t0.authentication_token AS authentication_token_17, t0.time_expiration AS time_expiration_18, t0.image_path AS image_path_19, t0.is_exclusive AS is_exclusive_20, t0.username AS username_21, t0.nfc_id AS nfc_id_22, t0.refresh_token AS refresh_token_23, t0.preferred_language AS preferred_language_24, t0.marketing_consent AS marketing_consent_25, t0.birth_date AS birth_date_26, t0.favorite_wine AS favorite_wine_27, t0.wine_type_preferences AS wine_type_preferences_28, t0.suggestions AS suggestions_29, t0.preferred_form_of_address AS preferred_form_of_address_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t33.id AS id_34, t33.endpoint AS endpoint_35, t33.public_key AS public_key_36, t33.auth_token AS auth_token_37, t33.created_at AS created_at_38, t33.updated_at AS updated_at_39, t33.user_id AS user_id_40, t0.email_group_id AS email_group_id_41 FROM users t0 LEFT JOIN user_subscription t33 ON t33.user_id = t0.id WHERE t0.email = 'gonzalo@dracoder.com' LIMIT 1;
|
| 3 |
5.24 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.category AS category_3, b0_.image_path AS image_path_4, b0_.embedding AS embedding_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, w1_.id AS id_8, w1_.name AS name_9, w1_.description AS description_10, w1_.image_path AS image_path_11, w1_.abbreviation AS abbreviation_12, w1_.banner_path AS banner_path_13, w1_.video_path AS video_path_14, w1_.calado_image_path AS calado_image_path_15, w1_.founding_year AS founding_year_16, w1_.embedding AS embedding_17, w1_.created_at AS created_at_18, w1_.updated_at AS updated_at_19, b0_.winery_id AS winery_id_20 FROM brand b0_ LEFT JOIN winery w1_ ON b0_.winery_id = w1_.id
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.category AS category_3, b0_.image_path AS image_path_4, b0_.embedding AS embedding_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, w1_.id AS id_8, w1_.name AS name_9, w1_.description AS description_10, w1_.image_path AS image_path_11, w1_.abbreviation AS abbreviation_12, w1_.banner_path AS banner_path_13, w1_.video_path AS video_path_14, w1_.calado_image_path AS calado_image_path_15, w1_.founding_year AS founding_year_16, w1_.embedding AS embedding_17, w1_.created_at AS created_at_18, w1_.updated_at AS updated_at_19, b0_.winery_id AS winery_id_20 FROM brand b0_ LEFT JOIN winery w1_ ON b0_.winery_id = w1_.id;
|