GET https://bushandel-sf8.pelp.pl/profil/dodaj_ogloszenie?url=profil%2Fdodaj_ogloszenie

Query Metrics

7 Database Queries
6 Different statements
155.92 ms Query time
0 Invalid entities
35 Managed entities

Queries

Group similar statements

#▲ Time Info
1 8.83 ms
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))
Parameters:
[
  2
]
2 14.92 ms
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_
Parameters:
[]
3 7.61 ms
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 (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  3
  4
  6
  7
  8
  9
  10
]
4 7.28 ms
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 (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  4
  5
  6
  7
  8
]
5 8.00 ms
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
Parameters:
[]
6 1.89 ms
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_
Parameters:
[]
7 107.38 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\AdvertCategory 8
App\Entity\AdvertType 8
App\Entity\Advert 5
App\Entity\PackageGroup 4
App\Entity\User 3
App\Entity\Parking 3
App\Entity\AdvertSubtype 2
App\Entity\Country 1
App\Entity\Region 1

Entities Mapping