http://dev80.nexgen.cz/pdf-estate/render/cs/2

Query Metrics

31 Database Queries
18 Different statements
29.65 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.04 ms
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
]
2 0.32 ms
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
]
3 0.44 ms
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"
]
4 0.40 ms
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
]
5 0.37 ms
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
]
6 0.32 ms
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"
]
7 0.30 ms
SELECT l0_.iso_2 AS iso_2_0 FROM lang l0_
Parameters:
[]
8 1.39 ms
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.api_id AS api_id_3, t0.affiliate_id AS affiliate_id_4, t0.stamp AS stamp_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.price AS price_8, t0.currency AS currency_9, t0.area_floor AS area_floor_10, t0.area_use AS area_use_11, t0.area_of_lot AS area_of_lot_12, t0.area_of_balcony AS area_of_balcony_13, t0.balcony AS balcony_14, t0.area_of_loggia AS area_of_loggia_15, t0.loggia AS loggia_16, t0.area_of_terrace AS area_of_terrace_17, t0.terrace AS terrace_18, t0.elevator AS elevator_19, t0.cellar AS cellar_20, t0.area_of_cellar AS area_of_cellar_21, t0.area_of_garden AS area_of_garden_22, t0.garden AS garden_23, t0.dont_advertise_price AS dont_advertise_price_24, t0.image AS image_25, t0.images AS images_26, t0.region AS region_27, t0.district AS district_28, t0.village AS village_29, t0.part_of_village AS part_of_village_30, t0.psc AS psc_31, t0.catastral_area AS catastral_area_32, t0.type_of_estate AS type_of_estate_33, t0.subtype_of_estate AS subtype_of_estate_34, t0.floor AS floor_35, t0.type_of_ownership AS type_of_ownership_36, t0.parking AS parking_37, t0.disposition AS disposition_38, t0.youtube AS youtube_39, t0.energy_performance_rating AS energy_performance_rating_40, t0.electricity AS electricity_41, t0.electricity_on_lot AS electricity_on_lot_42, t0.internet_connection AS internet_connection_43, t0.structure_of_building AS structure_of_building_44, t0.canalization AS canalization_45, t0.water AS water_46, t0.show_external_url_button AS show_external_url_button_47, t0.show_banner AS show_banner_48, t0.price_type AS price_type_49, t0.id AS id_50, t0.sort AS sort_51, t0.files_order AS files_order_52, t0.media_updated AS media_updated_53, t0.seo_id AS seo_id_54, t0.estate_file_id AS estate_file_id_55, t0.category_id AS category_id_56, t0.file_id AS file_id_57 FROM estate t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
9 1.02 ms
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0
Parameters:
[]
10 0.78 ms
SELECT t0.email AS email_1, t0.phone AS phone_2, t0.documents_order AS documents_order_3, t0.active AS active_4, t0.id AS id_5, t0.sort AS sort_6, t0.files_order AS files_order_7, t0.media_updated AS media_updated_8, t0.seo_id AS seo_id_9, t0.agent_file_id AS agent_file_id_10, t0.file_id AS file_id_11 FROM agent t0
Parameters:
[]
11 0.38 ms
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"
]
12 2.45 ms
SELECT t0.setting_key AS setting_key_1, t0.id AS id_2 FROM web_setting t0
Parameters:
[]
13 2.93 ms
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 INNER JOIN agent_lang ON t0.id = agent_lang.lang_id WHERE agent_lang.agent_id = ?
Parameters:
[
  2
]
14 1.11 ms
SELECT t0.documents_order AS documents_order_1, t0.active AS active_2, t0.id AS id_3, t0.sort AS sort_4, t0.files_order AS files_order_5, t0.media_updated AS media_updated_6, t0.seo_id AS seo_id_7, t0.category_file_id AS category_file_id_8, t0.file_id AS file_id_9 FROM category t0 INNER JOIN agent_category ON t0.id = agent_category.category_id WHERE agent_category.agent_id = ?
Parameters:
[
  2
]
15 0.68 ms
SELECT t0.name AS name_1, t0.description AS description_2, t0.longDescription AS longDescription_3, t0.price_comment AS price_comment_4, t0.agent_id AS agent_id_5, t0.external_url AS external_url_6, t0.id AS id_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM estate_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
16 2.67 ms
SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_
Parameters:
[]
17 0.84 ms
SELECT t0.name AS name_1, t0.seo AS seo_2, t0.alt AS alt_3, t0.media AS media_4, t0.updated_at AS updated_at_5, t0.file_size AS file_size_6, t0.ext AS ext_7, t0.preview AS preview_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.id AS id_11, t0.folder_id AS folder_id_12 FROM media_file t0 WHERE t0.id = ?
Parameters:
[
  180
]
18 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.root AS root_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9 FROM folder t0 WHERE t0.id = ?
Parameters:
[
  17
]
19 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.lvl AS lvl_5, t0.root AS root_6, t0.deleted AS deleted_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9 FROM folder t0 WHERE t0.id = ?
Parameters:
[
  1
]
20 0.24 ms
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3 FROM setting t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "default_thumbnail_size"
]
21 1.44 ms
SELECT t0.name AS name_1, t0.position AS position_2, t0.text AS text_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM agent_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
22 0.36 ms
SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  15
]
23 0.27 ms
SELECT t0.trans_value AS trans_value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  14
]
24 0.50 ms
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
]
25 0.27 ms
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
]
26 0.25 ms
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"
]
27 0.29 ms
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
]
28 0.25 ms
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
]
29 0.28 ms
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"
]
30 0.20 ms
SELECT l0_.iso_2 AS iso_2_0 FROM lang l0_
Parameters:
[]
31 7.12 ms
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:
[
  "d1b8d678dd_681901374c46f7.88907776"
]

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.
App\Entity\Tag No errors.
App\Entity\EstateTranslation No errors.
NexCRM\BaseBundle\Entity\SettingTranslation No errors.
App\Entity\Agent No errors.
App\Entity\AgentTranslation No errors.
NexCRM\WebBundle\Entity\Setting No errors.
App\Entity\CategoryTranslation No errors.
NexCRM\BaseBundle\Entity\LangToken No errors.
NexCRM\BaseBundle\Entity\Folder No errors.
NexCRM\BaseBundle\Entity\MediaFileTranslation No errors.
NexCRM\WebBundle\Entity\SEOTranslation No errors.
App\Entity\TagTranslation No errors.
NexCRM\WebBundle\Entity\SettingTranslation No errors.
App\Entity\EstateInquiry No errors.
App\Entity\EstatePrice No errors.
App\Entity\MicropageNewsletter No errors.
App\Entity\Newsletter No errors.
App\Entity\Project No errors.
App\Entity\ProjectTranslation No errors.
App\Entity\RealkoLog No errors.
App\Entity\Reference No errors.
App\Entity\ReferenceTranslation No errors.
App\Entity\Service No errors.
App\Entity\ServiceTranslation No errors.
NexCRM\BaseBundle\Entity\AbstractTranslatableEntity No errors.
FOS\OAuthServerBundle\Entity\AccessToken No errors.
NexCRM\BaseBundle\Entity\AccessToken No errors.
FOS\OAuthServerBundle\Entity\AuthCode No errors.
NexCRM\BaseBundle\Entity\AuthCode No errors.
NexCRM\BaseBundle\Entity\BruteForceBlock No errors.
NexCRM\BaseBundle\Entity\BruteForceLoginAttempt No errors.
FOS\OAuthServerBundle\Entity\Client No errors.
NexCRM\BaseBundle\Entity\Client No errors.
NexCRM\BaseBundle\Entity\LangTranslation No errors.
NexCRM\BaseBundle\Entity\MediaOrderRecord No errors.
NexCRM\BaseBundle\Entity\MediaSize No errors.
FOS\OAuthServerBundle\Entity\RefreshToken No errors.
NexCRM\BaseBundle\Entity\RefreshToken No errors.
NexCRM\BaseBundle\Entity\Role No errors.
NexCRM\BaseBundle\Entity\RoleTranslation No errors.
NexCRM\BaseBundle\Entity\User No errors.
NexCRM\BaseBundle\Entity\Log No errors.
NexCRM\WebBundle\Entity\Web No errors.
NexCRM\WebBundle\Entity\Block No errors.
NexCRM\WebBundle\Entity\BlockTranslation No errors.
NexCRM\WebBundle\Entity\CodeTranslation No errors.
NexCRM\WebBundle\Entity\Content No errors.
NexCRM\WebBundle\Entity\ContentTranslation No errors.
NexCRM\WebBundle\Entity\Cookie No errors.
NexCRM\WebBundle\Entity\CookieTranslation No errors.
NexCRM\WebBundle\Entity\Menu No errors.
NexCRM\WebBundle\Entity\MenuGroup No errors.
NexCRM\WebBundle\Entity\MenuGroupTranslation No errors.
NexCRM\WebBundle\Entity\MenuTranslation No errors.
NexCRM\WebBundle\Entity\Module No errors.
NexCRM\WebBundle\Entity\ModuleTranslation No errors.
NexCRM\WebBundle\Entity\NewsTranslation No errors.
NexCRM\WebBundle\Entity\Page No errors.
NexCRM\WebBundle\Entity\PageTranslation No errors.
NexCRM\WebBundle\Entity\Popup No errors.
NexCRM\WebBundle\Entity\PopupTranslation No errors.
NexCRM\WebBundle\Entity\Slider No errors.
NexCRM\WebBundle\Entity\SliderGroup No errors.
NexCRM\WebBundle\Entity\SliderTranslation No errors.
NexCRM\WebBundle\Entity\Tag No errors.
NexCRM\WebBundle\Entity\TagTranslation No errors.
NexCRM\WebBundle\Entity\Template No errors.
NexCRM\WebBundle\Entity\TemplateTranslation No errors.
NexCRM\WebBundle\Entity\Code No errors.
NexCRM\WebBundle\Entity\News No errors.
NexCRM\WebBundle\Entity\Contact No errors.
NexCRM\NotificationBundle\Entity\DatabaseNotification No errors.
NexCRM\NotificationBundle\Entity\Entity No errors.
NexCRM\NotificationBundle\Entity\EntityProperty No errors.
NexCRM\NotificationBundle\Entity\EntityTranslation No errors.
NexCRM\NotificationBundle\Entity\Notification No errors.
NexCRM\NotificationBundle\Entity\NotificationRule No errors.
NexCRM\NotificationBundle\Entity\Notificator No errors.
NexCRM\NotificationBundle\Entity\NotificatorTranslation No errors.
NexCRM\NotificationBundle\Entity\Recipient No errors.
NexCRM\NotificationBundle\Entity\SystemNotification No errors.
NexCRM\NotificationBundle\Entity\Template No errors.
NexCRM\NotificationBundle\Entity\TemplateTranslation No errors.
NexCRM\NotificationBundle\Entity\Watcher No errors.
NexCRM\NotificationBundle\Entity\WatcherContent No errors.
NexCRM\NotificationBundle\Entity\WatcherContentTranslation No errors.
NexCRM\NotificationBundle\Entity\NotificationContent No errors.
NexCRM\NotificationBundle\Entity\NotificationContentTranslation No errors.
NexCRM\MicropageBundle\Entity\Micropage No errors.
NexCRM\MicropageBundle\Entity\Domain No errors.
NexCRM\MicropageBundle\Entity\MicropageCode No errors.
NexCRM\MicropageBundle\Entity\MicropageTranslation No errors.
NexCRM\CompanyBundle\Entity\Company No errors.
NexCRM\CompanyBundle\Entity\CompanyContact No errors.
NexCRM\CompanyBundle\Entity\EvidenceType No errors.
NexCRM\CompanyBundle\Entity\Subject No errors.
NexCRM\CompanyBundle\Entity\VatPayer No errors.
NexCRM\DMSBundle\Entity\FavoriteFolder No errors.
NexCRM\DMSBundle\Entity\File No errors.
NexCRM\DMSBundle\Entity\FileComment No errors.
NexCRM\DMSBundle\Entity\FileField No errors.
NexCRM\DMSBundle\Entity\FileLog No errors.
NexCRM\DMSBundle\Entity\FileParameters No errors.
NexCRM\DMSBundle\Entity\FileTemplate No errors.
NexCRM\DMSBundle\Entity\FileTemplateField No errors.
NexCRM\DMSBundle\Entity\FileTemplateFieldSetting No errors.
NexCRM\DMSBundle\Entity\FileTranslation No errors.
NexCRM\DMSBundle\Entity\FileType No errors.
NexCRM\DMSBundle\Entity\Filter No errors.
NexCRM\DMSBundle\Entity\FilterField No errors.
NexCRM\DMSBundle\Entity\FilterItem No errors.
NexCRM\DMSBundle\Entity\Folder No errors.
NexCRM\DMSBundle\Entity\FolderRule No errors.
NexCRM\DMSBundle\Entity\NumericalRoot No errors.
NexCRM\DMSBundle\Entity\NumericalRootDefinition No errors.
NexCRM\DMSBundle\Entity\OrderRecord No errors.
NexCRM\PersonBundle\Entity\Person
  • The field NexCRM\PersonBundle\Entity\Person#addresses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity NexCRM\PersonBundle\Entity\Address#person does not contain the required 'inversedBy="addresses"' attribute.
  • The field NexCRM\PersonBundle\Entity\Person#bankDetails is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity NexCRM\PersonBundle\Entity\BankDetail#person does not contain the required 'inversedBy="bankDetails"' attribute.
NexCRM\PersonBundle\Entity\Address No errors.
NexCRM\PersonBundle\Entity\BankDetail No errors.
NexCRM\PersonBundle\Entity\PersonalData No errors.
Vich\UploaderBundle\Entity\File No errors.