Symfony Profiler

SELECT
  f0_.id AS id_0,
  f0_.company_name AS company_name_1,
  f0_.phone AS phone_2,
  f0_.phone_mobile AS phone_mobile_3,
  f0_.postal_code AS postal_code_4,
  f0_.city AS city_5,
  f0_.street AS street_6,
  f0_.geocode AS geocode_7,
  f0_.www AS www_8,
  f0_.comment AS comment_9,
  f0_.pdo AS pdo_10,
  f0_.invoice_nip AS invoice_nip_11,
  f0_.invoice_company_name AS invoice_company_name_12,
  f0_.invoice_name AS invoice_name_13,
  f0_.invoice_postal_code AS invoice_postal_code_14,
  f0_.invoice_city AS invoice_city_15,
  f0_.invoice_street AS invoice_street_16,
  f0_.invoice_phone AS invoice_phone_17,
  f0_.invoice_delivery AS invoice_delivery_18,
  f0_.invoice_delivery_name AS invoice_delivery_name_19,
  f0_.invoice_delivery_postal_code AS invoice_delivery_postal_code_20,
  f0_.invoice_delivery_city AS invoice_delivery_city_21,
  f0_.invoice_delivery_street AS invoice_delivery_street_22,
  f0_.profile_title_top AS profile_title_top_23,
  f0_.profile_title_bottom AS profile_title_bottom_24,
  f0_.deleted_at AS deleted_at_25,
  f0_.userpage_home AS userpage_home_26,
  f0_.lang AS lang_27,
  f0_.last_activity AS last_activity_28,
  f0_.profile_url AS profile_url_29,
  f0_.expire_notify_at AS expire_notify_at_30,
  f0_.expired_at AS expired_at_31,
  f0_.test AS test_32,
  f0_.powiat AS powiat_33,
  f0_.about AS about_34,
  f0_.views AS views_35,
  f0_.name AS name_36,
  f0_.username AS username_37,
  f0_.username_canonical AS username_canonical_38,
  f0_.email AS email_39,
  f0_.email_canonical AS email_canonical_40,
  f0_.enabled AS enabled_41,
  f0_.salt AS salt_42,
  f0_.password AS password_43,
  f0_.last_login AS last_login_44,
  f0_.confirmation_token AS confirmation_token_45,
  f0_.password_requested_at AS password_requested_at_46,
  f0_.roles AS roles_47,
  f0_.country_id AS country_id_48,
  f0_.region_id AS region_id_49,
  f0_.invoice_region_id AS invoice_region_id_50,
  f0_.invoice_region_id AS invoice_region_id_51,
  f0_.image_id AS image_id_52,
  f0_.profile_image_id AS profile_image_id_53,
  f0_.profile_advert AS profile_advert_54
FROM
  fos_user f0_
WHERE
  (f0_.profile_url IS NOT NULL)
  AND (f0_.deleted_at IS NULL)
LIMIT
  50

SELECT f0_.id AS id_0, f0_.company_name AS company_name_1, f0_.phone AS phone_2, f0_.phone_mobile AS phone_mobile_3, f0_.postal_code AS postal_code_4, f0_.city AS city_5, f0_.street AS street_6, f0_.geocode AS geocode_7, f0_.www AS www_8, f0_.comment AS comment_9, f0_.pdo AS pdo_10, f0_.invoice_nip AS invoice_nip_11, f0_.invoice_company_name AS invoice_company_name_12, f0_.invoice_name AS invoice_name_13, f0_.invoice_postal_code AS invoice_postal_code_14, f0_.invoice_city AS invoice_city_15, f0_.invoice_street AS invoice_street_16, f0_.invoice_phone AS invoice_phone_17, f0_.invoice_delivery AS invoice_delivery_18, f0_.invoice_delivery_name AS invoice_delivery_name_19, f0_.invoice_delivery_postal_code AS invoice_delivery_postal_code_20, f0_.invoice_delivery_city AS invoice_delivery_city_21, f0_.invoice_delivery_street AS invoice_delivery_street_22, f0_.profile_title_top AS profile_title_top_23, f0_.profile_title_bottom AS profile_title_bottom_24, f0_.deleted_at AS deleted_at_25, f0_.userpage_home AS userpage_home_26, f0_.lang AS lang_27, f0_.last_activity AS last_activity_28, f0_.profile_url AS profile_url_29, f0_.expire_notify_at AS expire_notify_at_30, f0_.expired_at AS expired_at_31, f0_.test AS test_32, f0_.powiat AS powiat_33, f0_.about AS about_34, f0_.views AS views_35, f0_.name AS name_36, f0_.username AS username_37, f0_.username_canonical AS username_canonical_38, f0_.email AS email_39, f0_.email_canonical AS email_canonical_40, f0_.enabled AS enabled_41, f0_.salt AS salt_42, f0_.password AS password_43, f0_.last_login AS last_login_44, f0_.confirmation_token AS confirmation_token_45, f0_.password_requested_at AS password_requested_at_46, f0_.roles AS roles_47, f0_.country_id AS country_id_48, f0_.region_id AS region_id_49, f0_.invoice_region_id AS invoice_region_id_50, f0_.invoice_region_id AS invoice_region_id_51, f0_.image_id AS image_id_52, f0_.profile_image_id AS profile_image_id_53, f0_.profile_advert AS profile_advert_54 FROM fos_user f0_ WHERE (f0_.profile_url IS NOT NULL) AND (f0_.deleted_at IS NULL) LIMIT 50;

SELECT
  a0_.user_id AS sclr_0,
  COUNT(a0_.id) AS sclr_1
FROM
  advert a0_
WHERE
  (
    a0_.user_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
    AND a0_.active = 1
  )
  AND (a0_.deleted_at IS NULL)
GROUP BY
  a0_.user_id

SELECT a0_.user_id AS sclr_0, COUNT(a0_.id) AS sclr_1 FROM advert a0_ WHERE (a0_.user_id IN (2, 39, 42, 65, 94, 132, 142, 171, 197, 214, 238, 259, 272, 284, 285, 332, 347, 352, 379, 393, 423, 440, 441, 510, 567, 589, 665, 667, 737, 743, 844, 869, 1035, 1104, 1139, 1146, 1257, 1288, 1302, 1318, 1520, 1559, 1636, 1847, 1999, 2910, 2959, 3117, 3143, 3243) AND a0_.active = 1) AND (a0_.deleted_at IS NULL) GROUP BY a0_.user_id;

SELECT
  a0_.pay AS pay_0,
  a0_.only_logged AS only_logged_1,
  a0_.id AS id_2,
  a0_.name AS name_3,
  a0_.description AS description_4,
  a0_.slug AS slug_5,
  a0_.price_from_to AS price_from_to_6,
  a0_.hide_default_fields AS hide_default_fields_7,
  a0_.fields AS fields_8,
  a0_.package_group_id AS package_group_id_9
FROM
  advert_category a0_

SELECT a0_.pay AS pay_0, a0_.only_logged AS only_logged_1, a0_.id AS id_2, a0_.name AS name_3, a0_.description AS description_4, a0_.slug AS slug_5, a0_.price_from_to AS price_from_to_6, a0_.hide_default_fields AS hide_default_fields_7, a0_.fields AS fields_8, a0_.package_group_id AS package_group_id_9 FROM advert_category a0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.advert_category AS advert_category_3
FROM
  advert_type t0
WHERE
  t0.advert_category IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_category AS advert_category_3 FROM advert_type t0 WHERE t0.advert_category IN (2, 3, 4, 6, 7, 8, 9, 10);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.advert_type AS advert_type_3
FROM
  advert_subtype t0
WHERE
  t0.advert_type IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_type AS advert_type_3 FROM advert_subtype t0 WHERE t0.advert_type IN (1, 2, 3, 4, 5, 6, 7, 8);

SELECT
  a0_.id AS id_0,
  a0_.number AS number_1,
  a0_.if_promo AS if_promo_2,
  a0_.active AS active_3,
  a0_.sold AS sold_4,
  a0_.expired_active AS expired_active_5,
  a0_.views AS views_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.email AS email_8,
  a0_.title AS title_9,
  a0_.slug AS slug_10,
  a0_.currency AS currency_11,
  a0_.grossnet AS grossnet_12,
  a0_.price_negotiation AS price_negotiation_13,
  a0_.price AS price_14,
  a0_.price_pln AS price_pln_15,
  a0_.price_eur AS price_eur_16,
  a0_.price_usd AS price_usd_17,
  a0_.price_to AS price_to_18,
  a0_.price_to_pln AS price_to_pln_19,
  a0_.price_to_eur AS price_to_eur_20,
  a0_.price_to_usd AS price_to_usd_21,
  a0_.created_at AS created_at_22,
  a0_.updated_at AS updated_at_23,
  a0_.refreshed_at AS refreshed_at_24,
  a0_.expired_at AS expired_at_25,
  a0_.expire AS expire_26,
  a0_.expire_notify_at AS expire_notify_at_27,
  a0_.prices_updated_at AS prices_updated_at_28,
  a0_.category_id AS category_id_29,
  a0_.type_id AS type_id_30,
  a0_.subtype_id AS subtype_id_31,
  a0_.user_id AS user_id_32
FROM
  advert a0_
WHERE
  (a0_.deleted_at IS NULL)
ORDER BY
  a0_.views DESC
LIMIT
  2

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.if_promo AS if_promo_2, a0_.active AS active_3, a0_.sold AS sold_4, a0_.expired_active AS expired_active_5, a0_.views AS views_6, a0_.deleted_at AS deleted_at_7, a0_.email AS email_8, a0_.title AS title_9, a0_.slug AS slug_10, a0_.currency AS currency_11, a0_.grossnet AS grossnet_12, a0_.price_negotiation AS price_negotiation_13, a0_.price AS price_14, a0_.price_pln AS price_pln_15, a0_.price_eur AS price_eur_16, a0_.price_usd AS price_usd_17, a0_.price_to AS price_to_18, a0_.price_to_pln AS price_to_pln_19, a0_.price_to_eur AS price_to_eur_20, a0_.price_to_usd AS price_to_usd_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.refreshed_at AS refreshed_at_24, a0_.expired_at AS expired_at_25, a0_.expire AS expire_26, a0_.expire_notify_at AS expire_notify_at_27, a0_.prices_updated_at AS prices_updated_at_28, a0_.category_id AS category_id_29, a0_.type_id AS type_id_30, a0_.subtype_id AS subtype_id_31, a0_.user_id AS user_id_32 FROM advert a0_ WHERE (a0_.deleted_at IS NULL) ORDER BY a0_.views DESC LIMIT 2;