Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  bt_brands t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM bt_brands t0 WHERE t0.slug = 'benetton' LIMIT 1;

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
  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,
  b1_.id AS id_7,
  b1_.title AS title_8,
  b1_.lft AS lft_9,
  b1_.lvl AS lvl_10,
  b1_.rgt AS rgt_11,
  b1_.slug AS slug_12,
  b1_.nb_products AS nb_products_13,
  b0_.root_id AS root_id_14,
  b0_.parent_id AS parent_id_15,
  b1_.root_id AS root_id_16,
  b1_.parent_id AS parent_id_17
FROM
  bt_categories b0_
  INNER JOIN bt_categories b1_ ON b0_.parent_id = b1_.id
WHERE
  b0_.lvl <> 0
ORDER BY
  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, b1_.id AS id_7, b1_.title AS title_8, b1_.lft AS lft_9, b1_.lvl AS lvl_10, b1_.rgt AS rgt_11, b1_.slug AS slug_12, b1_.nb_products AS nb_products_13, b0_.root_id AS root_id_14, b0_.parent_id AS parent_id_15, b1_.root_id AS root_id_16, b1_.parent_id AS parent_id_17 FROM bt_categories b0_ INNER JOIN bt_categories b1_ ON b0_.parent_id = b1_.id WHERE b0_.lvl <> 0 ORDER BY b0_.lft ASC;

SELECT
  b0_.id AS id_0,
  b0_.code AS code_1,
  b0_.name AS name_2,
  b0_.department_name_uppercase AS department_name_uppercase_3,
  b0_.slug AS slug_4,
  b0_.department_name_soundex AS department_name_soundex_5
FROM
  bt_departments b0_
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.name AS name_2, b0_.department_name_uppercase AS department_name_uppercase_3, b0_.slug AS slug_4, b0_.department_name_soundex AS department_name_soundex_5 FROM bt_departments b0_ ORDER BY b0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.old_id AS old_id_1,
  b0_.username AS username_2,
  b0_.name AS name_3,
  b0_.master_image AS master_image_4,
  b0_.bio AS bio_5,
  b0_.capacity AS capacity_6,
  b0_.etat AS etat_7,
  b0_.comment AS comment_8,
  b0_.statut AS statut_9,
  b0_.pattern AS pattern_10,
  b0_.datetime AS datetime_11,
  b0_.expiration AS expiration_12,
  b0_.slug AS slug_13,
  b0_.view AS view_14,
  b1_.id AS id_15,
  b1_.username AS username_16,
  b1_.username_canonical AS username_canonical_17,
  b1_.old_username_canonical AS old_username_canonical_18,
  b1_.email AS email_19,
  b1_.email_canonical AS email_canonical_20,
  b1_.enabled AS enabled_21,
  b1_.salt AS salt_22,
  b1_.password AS password_23,
  b1_.last_login AS last_login_24,
  b1_.confirmation_token AS confirmation_token_25,
  b1_.password_requested_at AS password_requested_at_26,
  b1_.star AS star_27,
  b1_.roles AS roles_28,
  b1_.user_avatar AS user_avatar_29,
  b1_.user_regdate AS user_regdate_30,
  b1_.user_phone AS user_phone_31,
  b1_.user_trocs AS user_trocs_32,
  b1_.user_products AS user_products_33,
  b1_.user_moyenne AS user_moyenne_34,
  b1_.user_name AS user_name_35,
  b1_.user_first_name AS user_first_name_36,
  b1_.user_address AS user_address_37,
  b1_.user_complementary_address AS user_complementary_address_38,
  b1_.user_cp AS user_cp_39,
  b1_.user_city AS user_city_40,
  b1_.biography AS biography_41,
  b1_.facebook_id AS facebook_id_42,
  b1_.facebook_access_token AS facebook_access_token_43,
  b1_.twitter_id AS twitter_id_44,
  b1_.twitter_access_token AS twitter_access_token_45,
  b1_.wallet AS wallet_46,
  b1_.latitude AS latitude_47,
  b1_.longitude AS longitude_48,
  b2_.id AS id_49,
  b2_.name AS name_50,
  b2_.slug AS slug_51,
  b3_.id AS id_52,
  b3_.title AS title_53,
  b3_.lft AS lft_54,
  b3_.lvl AS lvl_55,
  b3_.rgt AS rgt_56,
  b3_.slug AS slug_57,
  b3_.nb_products AS nb_products_58,
  b4_.id AS id_59,
  b4_.title AS title_60,
  b4_.lft AS lft_61,
  b4_.lvl AS lvl_62,
  b4_.rgt AS rgt_63,
  b4_.slug AS slug_64,
  b4_.nb_products AS nb_products_65,
  b0_.user_id AS user_id_66,
  b0_.brand_id AS brand_id_67,
  b0_.parent_category_id AS parent_category_id_68,
  b0_.category_id AS category_id_69,
  b0_.box_id AS box_id_70,
  b3_.root_id AS root_id_71,
  b3_.parent_id AS parent_id_72,
  b4_.root_id AS root_id_73,
  b4_.parent_id AS parent_id_74
FROM
  bt_products b0_
  INNER JOIN bt_users b1_ ON b0_.user_id = b1_.id
  INNER JOIN bt_brands b2_ ON b0_.brand_id = b2_.id
  INNER JOIN bt_categories b3_ ON b0_.parent_category_id = b3_.id
  INNER JOIN bt_categories b4_ ON b0_.category_id = b4_.id
WHERE
  b0_.statut = ?
  AND b0_.brand_id = ?
ORDER BY
  b0_.datetime DESC
LIMIT
  40

SELECT b0_.id AS id_0, b0_.old_id AS old_id_1, b0_.username AS username_2, b0_.name AS name_3, b0_.master_image AS master_image_4, b0_.bio AS bio_5, b0_.capacity AS capacity_6, b0_.etat AS etat_7, b0_.comment AS comment_8, b0_.statut AS statut_9, b0_.pattern AS pattern_10, b0_.datetime AS datetime_11, b0_.expiration AS expiration_12, b0_.slug AS slug_13, b0_.view AS view_14, b1_.id AS id_15, b1_.username AS username_16, b1_.username_canonical AS username_canonical_17, b1_.old_username_canonical AS old_username_canonical_18, b1_.email AS email_19, b1_.email_canonical AS email_canonical_20, b1_.enabled AS enabled_21, b1_.salt AS salt_22, b1_.password AS password_23, b1_.last_login AS last_login_24, b1_.confirmation_token AS confirmation_token_25, b1_.password_requested_at AS password_requested_at_26, b1_.star AS star_27, b1_.roles AS roles_28, b1_.user_avatar AS user_avatar_29, b1_.user_regdate AS user_regdate_30, b1_.user_phone AS user_phone_31, b1_.user_trocs AS user_trocs_32, b1_.user_products AS user_products_33, b1_.user_moyenne AS user_moyenne_34, b1_.user_name AS user_name_35, b1_.user_first_name AS user_first_name_36, b1_.user_address AS user_address_37, b1_.user_complementary_address AS user_complementary_address_38, b1_.user_cp AS user_cp_39, b1_.user_city AS user_city_40, b1_.biography AS biography_41, b1_.facebook_id AS facebook_id_42, b1_.facebook_access_token AS facebook_access_token_43, b1_.twitter_id AS twitter_id_44, b1_.twitter_access_token AS twitter_access_token_45, b1_.wallet AS wallet_46, b1_.latitude AS latitude_47, b1_.longitude AS longitude_48, b2_.id AS id_49, b2_.name AS name_50, b2_.slug AS slug_51, b3_.id AS id_52, b3_.title AS title_53, b3_.lft AS lft_54, b3_.lvl AS lvl_55, b3_.rgt AS rgt_56, b3_.slug AS slug_57, b3_.nb_products AS nb_products_58, b4_.id AS id_59, b4_.title AS title_60, b4_.lft AS lft_61, b4_.lvl AS lvl_62, b4_.rgt AS rgt_63, b4_.slug AS slug_64, b4_.nb_products AS nb_products_65, b0_.user_id AS user_id_66, b0_.brand_id AS brand_id_67, b0_.parent_category_id AS parent_category_id_68, b0_.category_id AS category_id_69, b0_.box_id AS box_id_70, b3_.root_id AS root_id_71, b3_.parent_id AS parent_id_72, b4_.root_id AS root_id_73, b4_.parent_id AS parent_id_74 FROM bt_products b0_ INNER JOIN bt_users b1_ ON b0_.user_id = b1_.id INNER JOIN bt_brands b2_ ON b0_.brand_id = b2_.id INNER JOIN bt_categories b3_ ON b0_.parent_category_id = b3_.id INNER JOIN bt_categories b4_ ON b0_.category_id = b4_.id WHERE b0_.statut = 1 AND b0_.brand_id = 708 ORDER BY b0_.datetime DESC LIMIT 40;