Symfony Profiler

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

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 = 'zabouda' LIMIT 1;

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  bt_users b0_
  INNER JOIN bt_favorites b1_ ON b0_.id = b1_.user_id
WHERE
  b0_.enabled = 1
  AND b1_.watched_user_id = ?

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bt_users b0_ INNER JOIN bt_favorites b1_ ON b0_.id = b1_.user_id WHERE b0_.enabled = 1 AND b1_.watched_user_id = 3201;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.username_canonical AS username_canonical_1
FROM
  bt_users b0_
  INNER JOIN bt_favorites b1_ ON b0_.id = b1_.user_id
WHERE
  b0_.enabled = 1
  AND b1_.watched_user_id = ?
ORDER BY
  b0_.username_canonical ASC
LIMIT
  10

SELECT DISTINCT b0_.id AS id_0, b0_.username_canonical AS username_canonical_1 FROM bt_users b0_ INNER JOIN bt_favorites b1_ ON b0_.id = b1_.user_id WHERE b0_.enabled = 1 AND b1_.watched_user_id = 3201 ORDER BY b0_.username_canonical ASC LIMIT 10;

SELECT
  b0_.id AS id_0,
  b0_.username AS username_1,
  b0_.username_canonical AS username_canonical_2,
  b0_.old_username_canonical AS old_username_canonical_3,
  b0_.email AS email_4,
  b0_.email_canonical AS email_canonical_5,
  b0_.enabled AS enabled_6,
  b0_.salt AS salt_7,
  b0_.password AS password_8,
  b0_.last_login AS last_login_9,
  b0_.confirmation_token AS confirmation_token_10,
  b0_.password_requested_at AS password_requested_at_11,
  b0_.star AS star_12,
  b0_.roles AS roles_13,
  b0_.user_avatar AS user_avatar_14,
  b0_.user_regdate AS user_regdate_15,
  b0_.user_phone AS user_phone_16,
  b0_.user_trocs AS user_trocs_17,
  b0_.user_products AS user_products_18,
  b0_.user_moyenne AS user_moyenne_19,
  b0_.user_name AS user_name_20,
  b0_.user_first_name AS user_first_name_21,
  b0_.user_address AS user_address_22,
  b0_.user_complementary_address AS user_complementary_address_23,
  b0_.user_cp AS user_cp_24,
  b0_.user_city AS user_city_25,
  b0_.biography AS biography_26,
  b0_.facebook_id AS facebook_id_27,
  b0_.facebook_access_token AS facebook_access_token_28,
  b0_.twitter_id AS twitter_id_29,
  b0_.twitter_access_token AS twitter_access_token_30,
  b0_.wallet AS wallet_31,
  b0_.latitude AS latitude_32,
  b0_.longitude AS longitude_33,
  b1_.id AS id_34,
  b1_.watched_user_id AS watched_user_id_35,
  b1_.watched_product_id AS watched_product_id_36,
  b1_.user_id AS user_id_37
FROM
  bt_users b0_
  INNER JOIN bt_favorites b1_ ON b0_.id = b1_.user_id
WHERE
  b0_.enabled = 1
  AND b1_.watched_user_id = ?
  AND b0_.id IN (?)
ORDER BY
  b0_.username_canonical ASC

SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.username_canonical AS username_canonical_2, b0_.old_username_canonical AS old_username_canonical_3, b0_.email AS email_4, b0_.email_canonical AS email_canonical_5, b0_.enabled AS enabled_6, b0_.salt AS salt_7, b0_.password AS password_8, b0_.last_login AS last_login_9, b0_.confirmation_token AS confirmation_token_10, b0_.password_requested_at AS password_requested_at_11, b0_.star AS star_12, b0_.roles AS roles_13, b0_.user_avatar AS user_avatar_14, b0_.user_regdate AS user_regdate_15, b0_.user_phone AS user_phone_16, b0_.user_trocs AS user_trocs_17, b0_.user_products AS user_products_18, b0_.user_moyenne AS user_moyenne_19, b0_.user_name AS user_name_20, b0_.user_first_name AS user_first_name_21, b0_.user_address AS user_address_22, b0_.user_complementary_address AS user_complementary_address_23, b0_.user_cp AS user_cp_24, b0_.user_city AS user_city_25, b0_.biography AS biography_26, b0_.facebook_id AS facebook_id_27, b0_.facebook_access_token AS facebook_access_token_28, b0_.twitter_id AS twitter_id_29, b0_.twitter_access_token AS twitter_access_token_30, b0_.wallet AS wallet_31, b0_.latitude AS latitude_32, b0_.longitude AS longitude_33, b1_.id AS id_34, b1_.watched_user_id AS watched_user_id_35, b1_.watched_product_id AS watched_product_id_36, b1_.user_id AS user_id_37 FROM bt_users b0_ INNER JOIN bt_favorites b1_ ON b0_.id = b1_.user_id WHERE b0_.enabled = 1 AND b1_.watched_user_id = 3201 AND b0_.id IN (6157) ORDER BY b0_.username_canonical ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.lft AS lft_2,
  b0_.lvl AS lvl_3,
  b0_.rgt AS rgt_4,
  b0_.slug AS slug_5,
  b0_.nb_products AS nb_products_6
FROM
  bt_categories b0_
ORDER BY
  b0_.root_id ASC,
  b0_.lft ASC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.lft AS lft_2, b0_.lvl AS lvl_3, b0_.rgt AS rgt_4, b0_.slug AS slug_5, b0_.nb_products AS nb_products_6 FROM bt_categories b0_ ORDER BY b0_.root_id ASC, b0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.watched_user_id AS watched_user_id_2,
  t0.watched_product_id AS watched_product_id_3,
  t0.user_id AS user_id_4
FROM
  bt_favorites t0
WHERE
  t0.watched_user_id = ?

SELECT t0.id AS id_1, t0.watched_user_id AS watched_user_id_2, t0.watched_product_id AS watched_product_id_3, t0.user_id AS user_id_4 FROM bt_favorites t0 WHERE t0.watched_user_id = 3201;

SELECT
  t0.id AS id_1,
  t0.watched_user_id AS watched_user_id_2,
  t0.watched_product_id AS watched_product_id_3,
  t0.user_id AS user_id_4
FROM
  bt_favorites t0
WHERE
  t0.user_id = ?
  AND t0.watched_product_id IS NULL

SELECT t0.id AS id_1, t0.watched_user_id AS watched_user_id_2, t0.watched_product_id AS watched_product_id_3, t0.user_id AS user_id_4 FROM bt_favorites t0 WHERE t0.user_id = 3201 AND t0.watched_product_id IS NULL;