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 = 'vanessa-m-lando' LIMIT 1;

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 = 6545 AND t0.statut = 1 ORDER BY t0.datetime DESC LIMIT 12;

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  bt_evaluations b0_
  LEFT JOIN bt_users b1_ ON b0_.from_user_id = b1_.id
  LEFT JOIN bt_evaluations b2_ ON b0_.id = b2_.reply_to_id
WHERE
  b0_.to_user_id = ?
  AND b0_.reply_to_id IS NULL

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bt_evaluations b0_ LEFT JOIN bt_users b1_ ON b0_.from_user_id = b1_.id LEFT JOIN bt_evaluations b2_ ON b0_.id = b2_.reply_to_id WHERE b0_.to_user_id = 6545 AND b0_.reply_to_id IS NULL;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.datetime AS datetime_1
FROM
  bt_evaluations b0_
  LEFT JOIN bt_users b1_ ON b0_.from_user_id = b1_.id
  LEFT JOIN bt_evaluations b2_ ON b0_.id = b2_.reply_to_id
WHERE
  b0_.to_user_id = ?
  AND b0_.reply_to_id IS NULL
ORDER BY
  b0_.datetime DESC
LIMIT
  5

SELECT DISTINCT b0_.id AS id_0, b0_.datetime AS datetime_1 FROM bt_evaluations b0_ LEFT JOIN bt_users b1_ ON b0_.from_user_id = b1_.id LEFT JOIN bt_evaluations b2_ ON b0_.id = b2_.reply_to_id WHERE b0_.to_user_id = 6545 AND b0_.reply_to_id IS NULL ORDER BY b0_.datetime DESC LIMIT 5;

SELECT
  b0_.id AS id_0,
  b0_.note AS note_1,
  b0_.advice AS advice_2,
  b0_.datetime AS datetime_3,
  b1_.id AS id_4,
  b1_.username AS username_5,
  b1_.username_canonical AS username_canonical_6,
  b1_.old_username_canonical AS old_username_canonical_7,
  b1_.email AS email_8,
  b1_.email_canonical AS email_canonical_9,
  b1_.enabled AS enabled_10,
  b1_.salt AS salt_11,
  b1_.password AS password_12,
  b1_.last_login AS last_login_13,
  b1_.confirmation_token AS confirmation_token_14,
  b1_.password_requested_at AS password_requested_at_15,
  b1_.star AS star_16,
  b1_.roles AS roles_17,
  b1_.user_avatar AS user_avatar_18,
  b1_.user_regdate AS user_regdate_19,
  b1_.user_phone AS user_phone_20,
  b1_.user_trocs AS user_trocs_21,
  b1_.user_products AS user_products_22,
  b1_.user_moyenne AS user_moyenne_23,
  b1_.user_name AS user_name_24,
  b1_.user_first_name AS user_first_name_25,
  b1_.user_address AS user_address_26,
  b1_.user_complementary_address AS user_complementary_address_27,
  b1_.user_cp AS user_cp_28,
  b1_.user_city AS user_city_29,
  b1_.biography AS biography_30,
  b1_.facebook_id AS facebook_id_31,
  b1_.facebook_access_token AS facebook_access_token_32,
  b1_.twitter_id AS twitter_id_33,
  b1_.twitter_access_token AS twitter_access_token_34,
  b1_.wallet AS wallet_35,
  b1_.latitude AS latitude_36,
  b1_.longitude AS longitude_37,
  b2_.id AS id_38,
  b2_.note AS note_39,
  b2_.advice AS advice_40,
  b2_.datetime AS datetime_41,
  b0_.troc_id AS troc_id_42,
  b0_.from_user_id AS from_user_id_43,
  b0_.to_user_id AS to_user_id_44,
  b0_.reply_to_id AS reply_to_id_45,
  b2_.troc_id AS troc_id_46,
  b2_.from_user_id AS from_user_id_47,
  b2_.to_user_id AS to_user_id_48,
  b2_.reply_to_id AS reply_to_id_49
FROM
  bt_evaluations b0_
  LEFT JOIN bt_users b1_ ON b0_.from_user_id = b1_.id
  LEFT JOIN bt_evaluations b2_ ON b0_.id = b2_.reply_to_id
WHERE
  b0_.to_user_id = ?
  AND b0_.reply_to_id IS NULL
  AND b0_.id IN (?, ?)
ORDER BY
  b0_.datetime DESC

SELECT b0_.id AS id_0, b0_.note AS note_1, b0_.advice AS advice_2, b0_.datetime AS datetime_3, b1_.id AS id_4, b1_.username AS username_5, b1_.username_canonical AS username_canonical_6, b1_.old_username_canonical AS old_username_canonical_7, b1_.email AS email_8, b1_.email_canonical AS email_canonical_9, b1_.enabled AS enabled_10, b1_.salt AS salt_11, b1_.password AS password_12, b1_.last_login AS last_login_13, b1_.confirmation_token AS confirmation_token_14, b1_.password_requested_at AS password_requested_at_15, b1_.star AS star_16, b1_.roles AS roles_17, b1_.user_avatar AS user_avatar_18, b1_.user_regdate AS user_regdate_19, b1_.user_phone AS user_phone_20, b1_.user_trocs AS user_trocs_21, b1_.user_products AS user_products_22, b1_.user_moyenne AS user_moyenne_23, b1_.user_name AS user_name_24, b1_.user_first_name AS user_first_name_25, b1_.user_address AS user_address_26, b1_.user_complementary_address AS user_complementary_address_27, b1_.user_cp AS user_cp_28, b1_.user_city AS user_city_29, b1_.biography AS biography_30, b1_.facebook_id AS facebook_id_31, b1_.facebook_access_token AS facebook_access_token_32, b1_.twitter_id AS twitter_id_33, b1_.twitter_access_token AS twitter_access_token_34, b1_.wallet AS wallet_35, b1_.latitude AS latitude_36, b1_.longitude AS longitude_37, b2_.id AS id_38, b2_.note AS note_39, b2_.advice AS advice_40, b2_.datetime AS datetime_41, b0_.troc_id AS troc_id_42, b0_.from_user_id AS from_user_id_43, b0_.to_user_id AS to_user_id_44, b0_.reply_to_id AS reply_to_id_45, b2_.troc_id AS troc_id_46, b2_.from_user_id AS from_user_id_47, b2_.to_user_id AS to_user_id_48, b2_.reply_to_id AS reply_to_id_49 FROM bt_evaluations b0_ LEFT JOIN bt_users b1_ ON b0_.from_user_id = b1_.id LEFT JOIN bt_evaluations b2_ ON b0_.id = b2_.reply_to_id WHERE b0_.to_user_id = 6545 AND b0_.reply_to_id IS NULL AND b0_.id IN (22015, 21909) ORDER BY b0_.datetime DESC;

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.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.user_id = 6545;

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 = 6545;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 55;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lft AS lft_3,
  t0.lvl AS lvl_4,
  t0.rgt AS rgt_5,
  t0.slug AS slug_6,
  t0.nb_products AS nb_products_7,
  t0.root_id AS root_id_8,
  t0.parent_id AS parent_id_9
FROM
  bt_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.slug AS slug_6, t0.nb_products AS nb_products_7, t0.root_id AS root_id_8, t0.parent_id AS parent_id_9 FROM bt_categories t0 WHERE t0.id = 4;