Query Metrics

24 Database Queries
7 Different statements
79.43 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 3.78 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 1.00 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 6.83 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:
[
  "cx"
]
4 0.47 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.61 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.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:
[
  "cx"
]
7 1.56 ms
SELECT t0.homepage AS homepage_1, t0.documents_order AS documents_order_2, t0.doc_files_order AS doc_files_order_3, t0.id AS id_4, t0.sort AS sort_5, t0.files_order AS files_order_6, t0.media_updated AS media_updated_7, t0.img_files_order AS img_files_order_8, t0.parent AS parent_9, t0.seo_id AS seo_id_10, t0.template_id AS template_id_11, t0.page_file_id AS page_file_id_12, t0.file_id AS file_id_13, t0.img_file_id AS img_file_id_14, t0.doc_file_id AS doc_file_id_15 FROM web_page t0
Parameters:
[]
8 2.80 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  40
]
9 0.67 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  2
]
10 1.60 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 1.07 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  15
]
12 0.39 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  31
]
13 0.55 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  32
]
14 0.60 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  33
]
15 0.43 ms
SELECT t0.path AS path_1, t0.type AS type_2, t0.template AS template_3, t0.upload_form AS upload_form_4, t0.data_sources AS data_sources_5, t0.only_once AS only_once_6, t0.id AS id_7, t0.updated_at AS updated_at_8, t0.upload AS upload_9 FROM web_template t0 WHERE t0.id = ?
Parameters:
[
  34
]
16 10.18 ms
SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_
Parameters:
[]
17 30.61 ms
SELECT l0_.id AS id_0, l0_.token AS token_1 FROM lang_token l0_
Parameters:
[]
18 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.active = ?
Parameters:
[
  1
]
19 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.default_lang = ? LIMIT 1
Parameters:
[
  1
]
20 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.iso_2 = ? LIMIT 1
Parameters:
[
  "cx"
]
21 0.34 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
]
22 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
]
23 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.iso_2 = ? LIMIT 1
Parameters:
[
  "cx"
]
24 13.96 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:
[
  "a7f4e1391b_680b414908da48.60860094"
]

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.
NexCRM\WebBundle\Entity\Page No errors.
NexCRM\WebBundle\Entity\SEO No errors.
NexCRM\WebBundle\Entity\Template No errors.
NexCRM\BaseBundle\Entity\MediaFile No errors.
NexCRM\DMSBundle\Entity\File No errors.
NexCRM\WebBundle\Entity\Content No errors.
NexCRM\WebBundle\Entity\PageTranslation No errors.
NexCRM\WebBundle\Entity\TemplateTranslation No errors.
NexCRM\BaseBundle\Entity\LangToken No errors.
NexCRM\BaseBundle\Entity\SettingTranslation No errors.
NexCRM\WebBundle\Entity\SEOTranslation No errors.
NexCRM\BaseBundle\Entity\Folder No errors.
NexCRM\BaseBundle\Entity\MediaFileTranslation No errors.
NexCRM\DMSBundle\Entity\Folder No errors.
NexCRM\DMSBundle\Entity\FileLog No errors.
NexCRM\DMSBundle\Entity\FileParameters No errors.
NexCRM\DMSBundle\Entity\FileTranslation No errors.
NexCRM\WebBundle\Entity\ContentTranslation No errors.
App\Entity\Agent No errors.
App\Entity\AgentTranslation No errors.
App\Entity\Category No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\Estate No errors.
App\Entity\EstateInquiry No errors.
App\Entity\EstatePrice No errors.
App\Entity\EstateTranslation 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.
App\Entity\Tag No errors.
App\Entity\TagTranslation 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\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\Popup No errors.
NexCRM\WebBundle\Entity\PopupTranslation No errors.
NexCRM\WebBundle\Entity\Setting No errors.
NexCRM\WebBundle\Entity\SettingTranslation 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\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\FolderRule No errors.
NexCRM\DMSBundle\Entity\Filter No errors.
NexCRM\DMSBundle\Entity\FileType No errors.
NexCRM\DMSBundle\Entity\NumericalRoot No errors.
NexCRM\DMSBundle\Entity\FileField No errors.
NexCRM\DMSBundle\Entity\FavoriteFolder No errors.
NexCRM\DMSBundle\Entity\FileComment No errors.
NexCRM\DMSBundle\Entity\FileTemplate No errors.
NexCRM\DMSBundle\Entity\FileTemplateField No errors.
NexCRM\DMSBundle\Entity\FileTemplateFieldSetting No errors.
NexCRM\DMSBundle\Entity\FilterField No errors.
NexCRM\DMSBundle\Entity\FilterItem 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.