Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

8.16 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.64 ms
(93.61%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.type AS type_4, t0.type_location AS type_location_5, t0.adress AS adress_6, t0.city AS city_7, t0.province AS province_8, t0.country AS country_9, t0.status AS status_10, t0.image AS image_11, t0.bedroom AS bedroom_12, t0.bathroom AS bathroom_13, t0.price AS price_14, t0.currency AS currency_15, t0.publish AS publish_16, t0.uuid AS uuid_17, t0.registration_step AS registration_step_18, t0.guests AS guests_19, t0.livingroom AS livingroom_20, t0.periodicity AS periodicity_21, t0.postal_code AS postal_code_22, t0.appartement_number AS appartement_number_23, t0.uuid_property AS uuid_property_24, t0.publish_at AS publish_at_25, t0.address_view AS address_view_26, t0.furniture AS furniture_27, t0.air_condition AS air_condition_28, t0.pool AS pool_29, t0.openspaceroof AS openspaceroof_30, t0.exteriortoilet AS exteriortoilet_31, t0.securityguard AS securityguard_32, t0.garden AS garden_33, t0.wifi AS wifi_34, t0.parking AS parking_35, t0.unpublish_at AS unpublish_at_36, t0.header AS header_37, t0.pourcerntage_of_booking AS pourcerntage_of_booking_38, t0.price_of_visit AS price_of_visit_39, t0.surface_area AS surface_area_40, t0.relationship_to_property AS relationship_to_property_41, t0.views AS views_42, t0.for_agency AS for_agency_43, t0.cloudpano_tour_url AS cloudpano_tour_url_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.user_id AS user_id_47, t0.property_province_id AS property_province_id_48, t0.property_country_id AS property_country_id_49, t0.commune_id AS commune_id_50, t0.property_status_id AS property_status_id_51, t0.category_id AS category_id_52, t0.agency_id AS agency_id_53 FROM property t0 WHERE t0.uuid_property = ? LIMIT 1

Parameters:

[
  "019c0a8a-e134-753e-8833-0b1708aaa194"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.title AS title_3,
  t0.type AS type_4,
  t0.type_location AS type_location_5,
  t0.adress AS adress_6,
  t0.city AS city_7,
  t0.province AS province_8,
  t0.country AS country_9,
  t0.status AS status_10,
  t0.image AS image_11,
  t0.bedroom AS bedroom_12,
  t0.bathroom AS bathroom_13,
  t0.price AS price_14,
  t0.currency AS currency_15,
  t0.publish AS publish_16,
  t0.uuid AS uuid_17,
  t0.registration_step AS registration_step_18,
  t0.guests AS guests_19,
  t0.livingroom AS livingroom_20,
  t0.periodicity AS periodicity_21,
  t0.postal_code AS postal_code_22,
  t0.appartement_number AS appartement_number_23,
  t0.uuid_property AS uuid_property_24,
  t0.publish_at AS publish_at_25,
  t0.address_view AS address_view_26,
  t0.furniture AS furniture_27,
  t0.air_condition AS air_condition_28,
  t0.pool AS pool_29,
  t0.openspaceroof AS openspaceroof_30,
  t0.exteriortoilet AS exteriortoilet_31,
  t0.securityguard AS securityguard_32,
  t0.garden AS garden_33,
  t0.wifi AS wifi_34,
  t0.parking AS parking_35,
  t0.unpublish_at AS unpublish_at_36,
  t0.header AS header_37,
  t0.pourcerntage_of_booking AS pourcerntage_of_booking_38,
  t0.price_of_visit AS price_of_visit_39,
  t0.surface_area AS surface_area_40,
  t0.relationship_to_property AS relationship_to_property_41,
  t0.views AS views_42,
  t0.for_agency AS for_agency_43,
  t0.cloudpano_tour_url AS cloudpano_tour_url_44,
  t0.created_at AS created_at_45,
  t0.updated_at AS updated_at_46,
  t0.user_id AS user_id_47,
  t0.property_province_id AS property_province_id_48,
  t0.property_country_id AS property_country_id_49,
  t0.commune_id AS commune_id_50,
  t0.property_status_id AS property_status_id_51,
  t0.category_id AS category_id_52,
  t0.agency_id AS agency_id_53
FROM
  property t0
WHERE
  t0.uuid_property = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.type AS type_4, t0.type_location AS type_location_5, t0.adress AS adress_6, t0.city AS city_7, t0.province AS province_8, t0.country AS country_9, t0.status AS status_10, t0.image AS image_11, t0.bedroom AS bedroom_12, t0.bathroom AS bathroom_13, t0.price AS price_14, t0.currency AS currency_15, t0.publish AS publish_16, t0.uuid AS uuid_17, t0.registration_step AS registration_step_18, t0.guests AS guests_19, t0.livingroom AS livingroom_20, t0.periodicity AS periodicity_21, t0.postal_code AS postal_code_22, t0.appartement_number AS appartement_number_23, t0.uuid_property AS uuid_property_24, t0.publish_at AS publish_at_25, t0.address_view AS address_view_26, t0.furniture AS furniture_27, t0.air_condition AS air_condition_28, t0.pool AS pool_29, t0.openspaceroof AS openspaceroof_30, t0.exteriortoilet AS exteriortoilet_31, t0.securityguard AS securityguard_32, t0.garden AS garden_33, t0.wifi AS wifi_34, t0.parking AS parking_35, t0.unpublish_at AS unpublish_at_36, t0.header AS header_37, t0.pourcerntage_of_booking AS pourcerntage_of_booking_38, t0.price_of_visit AS price_of_visit_39, t0.surface_area AS surface_area_40, t0.relationship_to_property AS relationship_to_property_41, t0.views AS views_42, t0.for_agency AS for_agency_43, t0.cloudpano_tour_url AS cloudpano_tour_url_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.user_id AS user_id_47, t0.property_province_id AS property_province_id_48, t0.property_country_id AS property_country_id_49, t0.commune_id AS commune_id_50, t0.property_status_id AS property_status_id_51, t0.category_id AS category_id_52, t0.agency_id AS agency_id_53 FROM property t0 WHERE t0.uuid_property = '019c0a8a-e134-753e-8833-0b1708aaa194' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 37)
5	App\Controller\PropertyDetailsController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.37 ms
(4.48%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.check_in AS check_in_3, t0.check_out AS check_out_4, t0.total_amount AS total_amount_5, t0.status AS status_6, t0.duration AS duration_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.phone AS phone_10, t0.comments AS comments_11, t0.email AS email_12, t0.amount_to_pay AS amount_to_pay_13, t0.payement_type AS payement_type_14, t0.confirmed AS confirmed_15, t0.date_in AS date_in_16, t0.date_out AS date_out_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.property_id AS property_id_20, t0.user_id AS user_id_21 FROM reservation t0 WHERE t0.property_id IS NULL AND t0.confirmed = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.check_in AS check_in_3,
  t0.check_out AS check_out_4,
  t0.total_amount AS total_amount_5,
  t0.status AS status_6,
  t0.duration AS duration_7,
  t0.firstname AS firstname_8,
  t0.lastname AS lastname_9,
  t0.phone AS phone_10,
  t0.comments AS comments_11,
  t0.email AS email_12,
  t0.amount_to_pay AS amount_to_pay_13,
  t0.payement_type AS payement_type_14,
  t0.confirmed AS confirmed_15,
  t0.date_in AS date_in_16,
  t0.date_out AS date_out_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.property_id AS property_id_20,
  t0.user_id AS user_id_21
FROM
  reservation t0
WHERE
  t0.property_id IS NULL
  AND t0.confirmed = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.check_in AS check_in_3, t0.check_out AS check_out_4, t0.total_amount AS total_amount_5, t0.status AS status_6, t0.duration AS duration_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.phone AS phone_10, t0.comments AS comments_11, t0.email AS email_12, t0.amount_to_pay AS amount_to_pay_13, t0.payement_type AS payement_type_14, t0.confirmed AS confirmed_15, t0.date_in AS date_in_16, t0.date_out AS date_out_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.property_id AS property_id_20, t0.user_id AS user_id_21 FROM reservation t0 WHERE t0.property_id IS NULL AND t0.confirmed = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 39)
5	App\Controller\PropertyDetailsController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.16 ms
(1.91%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_url AS image_url_3, t0.status AS status_4, t0.property_id AS property_id_5 FROM images t0 WHERE t0.property_id IS NULL ORDER BY t0.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_url AS image_url_3,
  t0.status AS status_4,
  t0.property_id AS property_id_5
FROM
  images t0
WHERE
  t0.property_id IS NULL
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_url AS image_url_3, t0.status AS status_4, t0.property_id AS property_id_5 FROM images t0 WHERE t0.property_id IS NULL ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 57)
5	App\Controller\PropertyDetailsController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Property	No errors.
App\Entity\User	The association App\Entity\User#messengers refers to the owning side field App\Entity\Messenger#receiver which does not exist. The association App\Entity\User#messengersSender refers to the owning side field App\Entity\Messenger#sender which does not exist.
App\Entity\Province	No errors.
App\Entity\Country	No errors.
App\Entity\Commune	No errors.
App\Entity\PropertyStatus	No errors.
App\Entity\CategoryForProperty	No errors.
App\Entity\Agency	No errors.
App\Entity\Reservation	The association App\Entity\Reservation#services refers to the inverse side field App\Entity\ServiceSup#reservations which does not exist.
App\Entity\Images	No errors.
App\Entity\Favoris	No errors.
App\Entity\Messenger	No errors.
App\Entity\PropertyReport	No errors.
App\Entity\ServiceSup	The association App\Entity\ServiceSup#user refers to the inverse side field App\Entity\User#serviceSups which does not exist.
App\Entity\Rating	No errors.
App\Entity\Preference	The association App\Entity\Preference#leadClaims refers to the owning side field App\Entity\LeadClaims#leadId which does not exist.
App\Entity\PropertyView	No errors.
App\Entity\Videos	No errors.
App\Entity\Role	No errors.
App\Entity\Message	No errors.
App\Entity\AccountResetPassword	No errors.
App\Entity\AgencyAgent	No errors.
App\Entity\Invoice	No errors.
App\Entity\PaymentForPreference	No errors.
App\Entity\Subscriptions	No errors.
App\Entity\CreditWallet	No errors.
App\Entity\LeadClaims	The mappings App\Entity\LeadClaims#lead and App\Entity\Preference#leadClaims are inconsistent with each other.
App\Entity\AgentCoverages	No errors.
App\Entity\PaymentForMembership	No errors.
App\Entity\CreditTransaction	No errors.
App\Entity\DeviceToken	No errors.

Symfony Profiler

GET https://beta.smartimmo-app.com/property?propertyUuid=019c0a8a-e134-753e-8833-0b1708aaa194

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping