Query Metrics

9 Database Queries
6 Different statements
16.24 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.64 ms
(53.18%)
1
SELECT t0.entity_class AS entity_class_1, t0.request_id AS request_id_2, t0.property AS property_3, t0.media_order AS media_order_4, t0.created AS created_5, t0.entity_id AS entity_id_6, t0.id AS id_7 FROM media_order_record t0 WHERE t0.request_id = ?
Parameters:
[
  "a7a584f5e4_680a434a2fb372.37360825"
]
4.73 ms
(29.14%)
1
SELECT e0_.documents_order AS documents_order_0, e0_.active AS active_1, e0_.api_id AS api_id_2, e0_.affiliate_id AS affiliate_id_3, e0_.stamp AS stamp_4, e0_.lat AS lat_5, e0_.lng AS lng_6, e0_.price AS price_7, e0_.currency AS currency_8, e0_.area_floor AS area_floor_9, e0_.area_use AS area_use_10, e0_.area_of_lot AS area_of_lot_11, e0_.area_of_balcony AS area_of_balcony_12, e0_.balcony AS balcony_13, e0_.area_of_loggia AS area_of_loggia_14, e0_.loggia AS loggia_15, e0_.area_of_terrace AS area_of_terrace_16, e0_.terrace AS terrace_17, e0_.elevator AS elevator_18, e0_.cellar AS cellar_19, e0_.area_of_cellar AS area_of_cellar_20, e0_.area_of_garden AS area_of_garden_21, e0_.garden AS garden_22, e0_.dont_advertise_price AS dont_advertise_price_23, e0_.image AS image_24, e0_.images AS images_25, e0_.region AS region_26, e0_.district AS district_27, e0_.village AS village_28, e0_.part_of_village AS part_of_village_29, e0_.psc AS psc_30, e0_.catastral_area AS catastral_area_31, e0_.type_of_estate AS type_of_estate_32, e0_.subtype_of_estate AS subtype_of_estate_33, e0_.floor AS floor_34, e0_.type_of_ownership AS type_of_ownership_35, e0_.parking AS parking_36, e0_.disposition AS disposition_37, e0_.youtube AS youtube_38, e0_.energy_performance_rating AS energy_performance_rating_39, e0_.electricity AS electricity_40, e0_.electricity_on_lot AS electricity_on_lot_41, e0_.internet_connection AS internet_connection_42, e0_.structure_of_building AS structure_of_building_43, e0_.canalization AS canalization_44, e0_.water AS water_45, e0_.show_external_url_button AS show_external_url_button_46, e0_.show_banner AS show_banner_47, e0_.price_type AS price_type_48, e0_.id AS id_49, e0_.sort AS sort_50, e0_.files_order AS files_order_51, e0_.media_updated AS media_updated_52, e0_.seo_id AS seo_id_53, e0_.estate_file_id AS estate_file_id_54, e0_.category_id AS category_id_55, e0_.file_id AS file_id_56 FROM estate e0_ WHERE e0_.category_id = ? AND (e0_.price >= ? AND e0_.price <= ?) AND (e0_.area_use >= ? AND e0_.area_use <= ?) ORDER BY e0_.sort ASC
Parameters:
[
  "2"
  0
  0
  0
  0
]
1.39 ms
(8.55%)
2
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.active = ?
Parameters:
[
  1
]
0.62 ms
(3.81%)
2
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.default_lang = ? LIMIT 1
Parameters:
[
  1
]
0.59 ms
(3.62%)
2
SELECT t0.name AS name_1, t0.iso_2 AS iso_2_2, t0.iso_3 AS iso_3_3, t0.default_lang AS default_lang_4, t0.active AS active_5, t0.id AS id_6, t0.country AS country_7 FROM lang t0 WHERE t0.iso_2 = ? LIMIT 1
Parameters:
[
  "cs"
]
0.28 ms
(1.70%)
1
SELECT l0_.iso_2 AS iso_2_0 FROM lang l0_
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.

Entities Mapping

Class Mapping errors
NexCRM\BaseBundle\Entity\Lang No errors.
NexCRM\BaseBundle\Entity\Setting No errors.
NexCRM\BaseBundle\Entity\Country No errors.
App\Entity\Estate No errors.
NexCRM\WebBundle\Entity\SEO No errors.
NexCRM\BaseBundle\Entity\MediaFile No errors.
App\Entity\Category No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord No errors.