Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.phone AS phone_3,
  t0.phone_mobile AS phone_mobile_4,
  t0.postal_code AS postal_code_5,
  t0.city AS city_6,
  t0.street AS street_7,
  t0.geocode AS geocode_8,
  t0.www AS www_9,
  t0.comment AS comment_10,
  t0.pdo AS pdo_11,
  t0.invoice_nip AS invoice_nip_12,
  t0.invoice_company_name AS invoice_company_name_13,
  t0.invoice_name AS invoice_name_14,
  t0.invoice_postal_code AS invoice_postal_code_15,
  t0.invoice_city AS invoice_city_16,
  t0.invoice_street AS invoice_street_17,
  t0.invoice_phone AS invoice_phone_18,
  t0.invoice_delivery AS invoice_delivery_19,
  t0.invoice_delivery_name AS invoice_delivery_name_20,
  t0.invoice_delivery_postal_code AS invoice_delivery_postal_code_21,
  t0.invoice_delivery_city AS invoice_delivery_city_22,
  t0.invoice_delivery_street AS invoice_delivery_street_23,
  t0.profile_title_top AS profile_title_top_24,
  t0.profile_title_bottom AS profile_title_bottom_25,
  t0.deleted_at AS deleted_at_26,
  t0.userpage_home AS userpage_home_27,
  t0.lang AS lang_28,
  t0.last_activity AS last_activity_29,
  t0.profile_url AS profile_url_30,
  t0.expire_notify_at AS expire_notify_at_31,
  t0.expired_at AS expired_at_32,
  t0.test AS test_33,
  t0.powiat AS powiat_34,
  t0.about AS about_35,
  t0.views AS views_36,
  t0.name AS name_37,
  t0.username AS username_38,
  t0.username_canonical AS username_canonical_39,
  t0.email AS email_40,
  t0.email_canonical AS email_canonical_41,
  t0.enabled AS enabled_42,
  t0.salt AS salt_43,
  t0.password AS password_44,
  t0.last_login AS last_login_45,
  t0.confirmation_token AS confirmation_token_46,
  t0.password_requested_at AS password_requested_at_47,
  t0.roles AS roles_48,
  t0.country_id AS country_id_49,
  t0.region_id AS region_id_50,
  t0.invoice_region_id AS invoice_region_id_51,
  t0.invoice_region_id AS invoice_region_id_52,
  t0.image_id AS image_id_53,
  t0.profile_image_id AS profile_image_id_54,
  t0.profile_advert AS profile_advert_55
FROM
  fos_user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone AS phone_3, t0.phone_mobile AS phone_mobile_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.street AS street_7, t0.geocode AS geocode_8, t0.www AS www_9, t0.comment AS comment_10, t0.pdo AS pdo_11, t0.invoice_nip AS invoice_nip_12, t0.invoice_company_name AS invoice_company_name_13, t0.invoice_name AS invoice_name_14, t0.invoice_postal_code AS invoice_postal_code_15, t0.invoice_city AS invoice_city_16, t0.invoice_street AS invoice_street_17, t0.invoice_phone AS invoice_phone_18, t0.invoice_delivery AS invoice_delivery_19, t0.invoice_delivery_name AS invoice_delivery_name_20, t0.invoice_delivery_postal_code AS invoice_delivery_postal_code_21, t0.invoice_delivery_city AS invoice_delivery_city_22, t0.invoice_delivery_street AS invoice_delivery_street_23, t0.profile_title_top AS profile_title_top_24, t0.profile_title_bottom AS profile_title_bottom_25, t0.deleted_at AS deleted_at_26, t0.userpage_home AS userpage_home_27, t0.lang AS lang_28, t0.last_activity AS last_activity_29, t0.profile_url AS profile_url_30, t0.expire_notify_at AS expire_notify_at_31, t0.expired_at AS expired_at_32, t0.test AS test_33, t0.powiat AS powiat_34, t0.about AS about_35, t0.views AS views_36, t0.name AS name_37, t0.username AS username_38, t0.username_canonical AS username_canonical_39, t0.email AS email_40, t0.email_canonical AS email_canonical_41, t0.enabled AS enabled_42, t0.salt AS salt_43, t0.password AS password_44, t0.last_login AS last_login_45, t0.confirmation_token AS confirmation_token_46, t0.password_requested_at AS password_requested_at_47, t0.roles AS roles_48, t0.country_id AS country_id_49, t0.region_id AS region_id_50, t0.invoice_region_id AS invoice_region_id_51, t0.invoice_region_id AS invoice_region_id_52, t0.image_id AS image_id_53, t0.profile_image_id AS profile_image_id_54, t0.profile_advert AS profile_advert_55 FROM fos_user t0 WHERE t0.id = 2 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country_id AS country_id_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country_id AS country_id_3 FROM region t0 WHERE t0.id = 28;

SELECT
  t0.pay AS pay_1,
  t0.only_logged AS only_logged_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.price_from_to AS price_from_to_7,
  t0.hide_default_fields AS hide_default_fields_8,
  t0.fields AS fields_9,
  t0.package_group_id AS package_group_id_10
FROM
  advert_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.pay AS pay_1, t0.only_logged AS only_logged_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.price_from_to AS price_from_to_7, t0.hide_default_fields AS hide_default_fields_8, t0.fields AS fields_9, t0.package_group_id AS package_group_id_10 FROM advert_category t0 WHERE t0.slug = 'czesci-sprzedam' LIMIT 1;

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 (9);

SELECT
  t0.id AS id_1,
  t0.start AS start_2,
  t0.expire AS expire_3,
  t0.notified_at AS notified_at_4,
  t0.user_id AS user_id_5,
  t0.package_id AS package_id_6,
  t7.id AS id_8,
  t7.name AS name_9,
  t7.price_pln AS price_pln_10,
  t7.price_pln_6 AS price_pln_6_11,
  t7.price_pln_12 AS price_pln_12_12,
  t7.price_eur AS price_eur_13,
  t7.adverts_limit AS adverts_limit_14,
  t7.test AS test_15,
  t7.duration AS duration_16,
  t0.group_id AS group_id_17
FROM
  user_package t0
  LEFT JOIN package t7 ON t0.package_id = t7.id
WHERE
  t0.group_id = ?
  AND t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start AS start_2, t0.expire AS expire_3, t0.notified_at AS notified_at_4, t0.user_id AS user_id_5, t0.package_id AS package_id_6, t7.id AS id_8, t7.name AS name_9, t7.price_pln AS price_pln_10, t7.price_pln_6 AS price_pln_6_11, t7.price_pln_12 AS price_pln_12_12, t7.price_eur AS price_eur_13, t7.adverts_limit AS adverts_limit_14, t7.test AS test_15, t7.duration AS duration_16, t0.group_id AS group_id_17 FROM user_package t0 LEFT JOIN package t7 ON t0.package_id = t7.id WHERE t0.group_id = 1 AND t0.user_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.default_package_id AS default_package_id_3
FROM
  package_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_package_id AS default_package_id_3 FROM package_group t0 WHERE t0.id = 1;

SELECT
  t0.pay AS pay_1,
  t0.only_logged AS only_logged_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.price_from_to AS price_from_to_7,
  t0.hide_default_fields AS hide_default_fields_8,
  t0.fields AS fields_9,
  t0.package_group_id AS package_group_id_10
FROM
  advert_category t0
WHERE
  t0.package_group_id = ?

SELECT t0.pay AS pay_1, t0.only_logged AS only_logged_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.price_from_to AS price_from_to_7, t0.hide_default_fields AS hide_default_fields_8, t0.fields AS fields_9, t0.package_group_id AS package_group_id_10 FROM advert_category t0 WHERE t0.package_group_id = 1;

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, 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
  count(a0_.id) AS sclr_0
FROM
  advert a0_
WHERE
  (
    a0_.category_id IN (?, ?, ?, ?, ?)
    AND a0_.user_id = ?
    AND a0_.active = 1
  )
  AND (a0_.deleted_at IS NULL)

SELECT count(a0_.id) AS sclr_0 FROM advert a0_ WHERE (a0_.category_id IN (2, 3, 4, 9, 10) AND a0_.user_id = 2 AND a0_.active = 1) AND (a0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  make t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM make t0;

SELECT
  a0_.id AS id_0,
  a0_.added_at AS added_at_1,
  a0_.advert_id AS advert_id_2,
  a0_.user_id AS user_id_3
FROM
  advert_parking a0_
  INNER JOIN advert a1_ ON a0_.advert_id = a1_.id
  AND (a1_.deleted_at IS NULL)
WHERE
  a1_.active = 1
  AND a0_.user_id = 2

SELECT a0_.id AS id_0, a0_.added_at AS added_at_1, a0_.advert_id AS advert_id_2, a0_.user_id AS user_id_3 FROM advert_parking a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE a1_.active = 1 AND a0_.user_id = 2;

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 (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;