| 1 |
0.88 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.old_username_canonical AS old_username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.star AS star_13, t0.roles AS roles_14, t0.user_avatar AS user_avatar_15, t0.user_regdate AS user_regdate_16, t0.user_phone AS user_phone_17, t0.user_trocs AS user_trocs_18, t0.user_products AS user_products_19, t0.user_moyenne AS user_moyenne_20, t0.user_name AS user_name_21, t0.user_first_name AS user_first_name_22, t0.user_address AS user_address_23, t0.user_complementary_address AS user_complementary_address_24, t0.user_cp AS user_cp_25, t0.user_city AS user_city_26, t0.biography AS biography_27, t0.facebook_id AS facebook_id_28, t0.facebook_access_token AS facebook_access_token_29, t0.twitter_id AS twitter_id_30, t0.twitter_access_token AS twitter_access_token_31, t0.wallet AS wallet_32, t0.latitude AS latitude_33, t0.longitude AS longitude_34 FROM bt_users t0 WHERE t0.username_canonical = ? LIMIT 1
Parameters: [
"athenais54"
]
SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.old_username_canonical AS old_username_canonical_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.password AS password_9, t0.last_login AS last_login_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.star AS star_13, t0.roles AS roles_14, t0.user_avatar AS user_avatar_15, t0.user_regdate AS user_regdate_16, t0.user_phone AS user_phone_17, t0.user_trocs AS user_trocs_18, t0.user_products AS user_products_19, t0.user_moyenne AS user_moyenne_20, t0.user_name AS user_name_21, t0.user_first_name AS user_first_name_22, t0.user_address AS user_address_23, t0.user_complementary_address AS user_complementary_address_24, t0.user_cp AS user_cp_25, t0.user_city AS user_city_26, t0.biography AS biography_27, t0.facebook_id AS facebook_id_28, t0.facebook_access_token AS facebook_access_token_29, t0.twitter_id AS twitter_id_30, t0.twitter_access_token AS twitter_access_token_31, t0.wallet AS wallet_32, t0.latitude AS latitude_33, t0.longitude AS longitude_34 FROM bt_users t0 WHERE t0.username_canonical = 'athenais54' LIMIT 1;
|
| 2 |
1.19 ms |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.username AS username_3, t0.name AS name_4, t0.master_image AS master_image_5, t0.bio AS bio_6, t0.capacity AS capacity_7, t0.etat AS etat_8, t0.comment AS comment_9, t0.statut AS statut_10, t0.pattern AS pattern_11, t0.datetime AS datetime_12, t0.expiration AS expiration_13, t0.slug AS slug_14, t0.view AS view_15, t0.user_id AS user_id_16, t0.brand_id AS brand_id_17, t0.parent_category_id AS parent_category_id_18, t0.category_id AS category_id_19, t0.box_id AS box_id_20 FROM bt_products t0 WHERE t0.user_id = ? AND t0.statut = ? ORDER BY t0.datetime DESC LIMIT 12
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.username AS username_3, t0.name AS name_4, t0.master_image AS master_image_5, t0.bio AS bio_6, t0.capacity AS capacity_7, t0.etat AS etat_8, t0.comment AS comment_9, t0.statut AS statut_10, t0.pattern AS pattern_11, t0.datetime AS datetime_12, t0.expiration AS expiration_13, t0.slug AS slug_14, t0.view AS view_15, t0.user_id AS user_id_16, t0.brand_id AS brand_id_17, t0.parent_category_id AS parent_category_id_18, t0.category_id AS category_id_19, t0.box_id AS box_id_20 FROM bt_products t0 WHERE t0.user_id = 606 AND t0.statut = 1 ORDER BY t0.datetime DESC LIMIT 12;
|
| 10 |
0.66 ms |
SELECT t0.id AS id_1, t0.note AS note_2, t0.advice AS advice_3, t0.datetime AS datetime_4, t0.troc_id AS troc_id_5, t0.from_user_id AS from_user_id_6, t0.to_user_id AS to_user_id_7, t8.id AS id_9, t8.note AS note_10, t8.advice AS advice_11, t8.datetime AS datetime_12, t8.troc_id AS troc_id_13, t8.from_user_id AS from_user_id_14, t8.to_user_id AS to_user_id_15, t8.reply_to_id AS reply_to_id_16, t0.reply_to_id AS reply_to_id_17 FROM bt_evaluations t0 LEFT JOIN bt_evaluations t8 ON t8.reply_to_id = t0.id WHERE t0.to_user_id = ?
SELECT t0.id AS id_1, t0.note AS note_2, t0.advice AS advice_3, t0.datetime AS datetime_4, t0.troc_id AS troc_id_5, t0.from_user_id AS from_user_id_6, t0.to_user_id AS to_user_id_7, t8.id AS id_9, t8.note AS note_10, t8.advice AS advice_11, t8.datetime AS datetime_12, t8.troc_id AS troc_id_13, t8.from_user_id AS from_user_id_14, t8.to_user_id AS to_user_id_15, t8.reply_to_id AS reply_to_id_16, t0.reply_to_id AS reply_to_id_17 FROM bt_evaluations t0 LEFT JOIN bt_evaluations t8 ON t8.reply_to_id = t0.id WHERE t0.to_user_id = 606;
|