Query Metrics
9
Database Queries
6
Different statements
16.24 ms
Query time
0
Invalid entities
Grouped Statements
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. |