Query Metrics
59
Database Queries
20
Different statements
76.56 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
17.41 ms (0.00%) |
1 |
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[] |
15.95 ms (0.00%) |
6 |
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
]
|
14.03 ms (0.00%) |
1 |
SELECT w0_.link_id AS link_id_0, w0_.url AS url_1, w0_.active AS active_2, w0_.id AS id_3, w0_.sort AS sort_4, w0_.parent AS parent_5, w0_.module_id AS module_id_6, w0_.file_id AS file_id_7, w0_.img_file_id AS img_file_id_8 FROM web_menu w0_ INNER JOIN web_menu_to_group w2_ ON w0_.id = w2_.menu_item_id INNER JOIN web_menu_group w1_ ON w1_.id = w2_.menu_group_id WHERE w1_.id = 2 AND w0_.active = 1 ORDER BY w0_.sort ASC
Parameters:
[] |
4.69 ms (0.00%) |
6 |
SELECT t0.name AS name_1, t0.disabled AS disabled_2, t0.id AS id_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.link_id AS link_id_7, t6.url AS url_8, t6.active AS active_9, t6.id AS id_10, t6.sort AS sort_11, t6.parent AS parent_12, t6.module_id AS module_id_13, t6.file_id AS file_id_14, t6.img_file_id AS img_file_id_15 FROM web_menu_translation t0 LEFT JOIN web_menu t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
4.11 ms (0.00%) |
1 |
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, t16.name AS name_17, t16.title AS title_18, t16.short_text AS short_text_19, t16.text AS text_20, t16.id AS id_21, t16.locale AS locale_22, t16.translatable_id AS translatable_id_23 FROM web_page t0 LEFT JOIN web_page_translation t16 ON t16.translatable_id = t0.id
Parameters:
[] |
2.52 ms (0.00%) |
6 |
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, t10.name AS name_11, t10.id AS id_12, t10.locale AS locale_13, t10.translatable_id AS translatable_id_14 FROM web_template t0 LEFT JOIN web_template_translation t10 ON t10.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
5
]
|
1.85 ms (0.00%) |
1 |
SELECT t0.name AS name_1, t0.id AS id_2 FROM web_slider_group t0
Parameters:
[] |
1.84 ms (0.00%) |
1 |
SELECT t0.block_key AS block_key_1, t0.id AS id_2, t0.files_order AS files_order_3, t0.media_updated AS media_updated_4, t0.img_files_order AS img_files_order_5, t0.block_file_id AS block_file_id_6, t0.file_id AS file_id_7, t0.img_file_id AS img_file_id_8, t0.doc_file_id AS doc_file_id_9, t10.name AS name_11, t10.text AS text_12, t10.id AS id_13, t10.locale AS locale_14, t10.translatable_id AS translatable_id_15 FROM web_block t0 LEFT JOIN web_block_translation t10 ON t10.translatable_id = t0.id
Parameters:
[] |
1.76 ms (0.00%) |
1 |
SELECT t0.updated_at AS updated_at_1, t0.sort AS sort_2, t0.id AS id_3, t0.seo_id AS seo_id_4, t0.file_id AS file_id_5, t6.name AS name_7, t6.short_name AS short_name_8, t6.description AS description_9, t6.id AS id_10, t6.locale AS locale_11, t6.translatable_id AS translatable_id_12 FROM shop_category t0 LEFT JOIN shop_category_translation t6 ON t6.translatable_id = t0.id ORDER BY t0.sort ASC
Parameters:
[] |
1.59 ms (0.00%) |
6 |
SELECT t0.noindex AS noindex_1, t0.module AS module_2, t0.anchor AS anchor_3, t0.suffix AS suffix_4, t0.entity AS entity_5, t0.id AS id_6, t7.title AS title_8, t7.description AS description_9, t7.keywords AS keywords_10, t7.name AS name_11, t7.url AS url_12, t7.`generated` AS generated_13, t7.id AS id_14, t7.locale AS locale_15, t7.translatable_id AS translatable_id_16 FROM web_seo t0 LEFT JOIN web_seo_translation t7 ON t7.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
4
]
|
1.57 ms (0.00%) |
1 |
SELECT w0_.active AS active_0, w0_.created AS created_1, w0_.id AS id_2, w0_.sort AS sort_3, w0_.link_id AS link_id_4, w0_.page_id AS page_id_5, w0_.author_id AS author_id_6, w0_.file_tablet_id AS file_tablet_id_7, w0_.file_phone_id AS file_phone_id_8, w0_.video_id AS video_id_9, w0_.dms_file_tablet_id AS dms_file_tablet_id_10, w0_.dms_file_phone_id AS dms_file_phone_id_11, w0_.dms_video_id AS dms_video_id_12, w0_.file_id AS file_id_13, w0_.img_file_id AS img_file_id_14 FROM web_slider w0_ INNER JOIN web_slider_to_group w2_ ON w0_.id = w2_.slider_item_id INNER JOIN web_slider_group w1_ ON w1_.id = w2_.slider_group_id WHERE w1_.id = 1 AND w0_.active = 1 ORDER BY w0_.page_id ASC, w0_.sort ASC
Parameters:
[] |
1.49 ms (0.00%) |
8 |
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
4
]
|
1.45 ms (0.00%) |
6 |
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
]
|
1.44 ms (0.00%) |
6 |
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"
]
|
1.26 ms (0.00%) |
1 |
SELECT t0.name AS name_1, t0.id AS id_2, t3.name AS name_4, t3.id AS id_5, t3.locale AS locale_6, t3.translatable_id AS translatable_id_7 FROM web_menu_group t0 LEFT JOIN web_menu_group_translation t3 ON t3.translatable_id = t0.id
Parameters:
[] |
1.09 ms (0.00%) |
1 |
SELECT t0.alias AS alias_1, t0.value AS value_2, t0.id AS id_3, t4.trans_value AS trans_value_5, t4.id AS id_6, t4.locale AS locale_7, t4.translatable_id AS translatable_id_8 FROM setting t0 LEFT JOIN setting_translation t4 ON t4.translatable_id = t0.id
Parameters:
[] |
1.08 ms (0.00%) |
1 |
SELECT t0.entity AS entity_1, t0.controller AS controller_2, t0.bundle AS bundle_3, t0.action AS action_4, t0.id AS id_5, t6.url AS url_7, t6.name AS name_8, t6.id AS id_9, t6.locale AS locale_10, t6.translatable_id AS translatable_id_11 FROM web_module t0 LEFT JOIN web_module_translation t6 ON t6.translatable_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
0.71 ms (0.00%) |
1 |
SELECT t0.name AS name_1, t0.text AS text_2, t0.url AS url_3, t0.button AS button_4, t0.id AS id_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.active AS active_9, t8.created AS created_10, t8.id AS id_11, t8.sort AS sort_12, t8.link_id AS link_id_13, t8.page_id AS page_id_14, t8.author_id AS author_id_15, t8.file_tablet_id AS file_tablet_id_16, t8.file_phone_id AS file_phone_id_17, t8.video_id AS video_id_18, t8.dms_file_tablet_id AS dms_file_tablet_id_19, t8.dms_file_phone_id AS dms_file_phone_id_20, t8.dms_video_id AS dms_video_id_21, t8.file_id AS file_id_22, t8.img_file_id AS img_file_id_23 FROM web_slider_translation t0 LEFT JOIN web_slider t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
0.55 ms (0.00%) |
3 |
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:
[
"instagram_client_id"
]
|
0.17 ms (0.00%) |
1 |
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 WHERE t0.homepage = ? LIMIT 1
Parameters:
[
1
]
|
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\Country | No errors. |
NexCRM\BaseBundle\Entity\Setting | No errors. |
NexCRM\ShopBundle\Entity\Product | No errors. |
NexCRM\BaseBundle\Entity\SettingTranslation | 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\PageTranslation | No errors. |
NexCRM\WebBundle\Entity\Content | No errors. |
NexCRM\WebBundle\Entity\Menu | No errors. |
NexCRM\WebBundle\Entity\MenuGroup | No errors. |
NexCRM\WebBundle\Entity\MenuGroupTranslation | No errors. |
NexCRM\WebBundle\Entity\Module | No errors. |
NexCRM\WebBundle\Entity\MenuTranslation | No errors. |
NexCRM\WebBundle\Entity\ModuleTranslation | No errors. |
NexCRM\WebBundle\Entity\SEOTranslation | No errors. |
NexCRM\WebBundle\Entity\Slider | No errors. |
NexCRM\WebBundle\Entity\SliderGroup | No errors. |
NexCRM\BaseBundle\Entity\User | No errors. |
NexCRM\WebBundle\Entity\SliderTranslation | No errors. |
NexCRM\WebBundle\Entity\Block | No errors. |
NexCRM\WebBundle\Entity\BlockTranslation | No errors. |
NexCRM\ShopBundle\Entity\Category |
|
NexCRM\ShopBundle\Entity\CategoryTranslation | No errors. |
NexCRM\ShopBundle\Entity\CategoryParameter | No errors. |
NexCRM\WebBundle\Entity\TemplateTranslation | No errors. |
NexCRM\ShopBundle\Entity\ParameterGroup | No errors. |
NexCRM\ShopBundle\Entity\ParameterValue | No errors. |
NexCRM\ShopBundle\Entity\ProductTranslation | 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. |
NexCRM\BaseBundle\Entity\Role | No errors. |
NexCRM\BaseBundle\Entity\AbstractTranslatableEntity | No errors. |
NexCRM\BaseBundle\Entity\BruteForceBlock | No errors. |
NexCRM\BaseBundle\Entity\BruteForceLoginAttempt | No errors. |
NexCRM\BaseBundle\Entity\LangToken | No errors. |
NexCRM\BaseBundle\Entity\LangTranslation | No errors. |
NexCRM\BaseBundle\Entity\Log | No errors. |
NexCRM\BaseBundle\Entity\MediaOrderRecord | No errors. |
NexCRM\BaseBundle\Entity\MediaSize | No errors. |
NexCRM\BaseBundle\Entity\RoleTranslation | No errors. |
NexCRM\WebBundle\Entity\Web | No errors. |
NexCRM\WebBundle\Entity\Contact | No errors. |
NexCRM\WebBundle\Entity\News | No errors. |
NexCRM\WebBundle\Entity\NewsTranslation | No errors. |
NexCRM\WebBundle\Entity\Setting | No errors. |
NexCRM\WebBundle\Entity\SettingTranslation | No errors. |
NexCRM\WebBundle\Entity\Tag | No errors. |
NexCRM\WebBundle\Entity\TagTranslation | No errors. |
NexCRM\WebBundle\Entity\Code | No errors. |
NexCRM\WebBundle\Entity\CodeTranslation | No errors. |
NexCRM\WebBundle\Entity\Cookie | No errors. |
NexCRM\WebBundle\Entity\CookieTranslation | No errors. |
NexCRM\ShopBundle\Entity\Basket | No errors. |
NexCRM\ShopBundle\Entity\BasketItem | No errors. |
NexCRM\ShopBundle\Entity\DeliveryData | No errors. |
NexCRM\ShopBundle\Entity\OrderItem | No errors. |
NexCRM\ShopBundle\Entity\Parameter | No errors. |
NexCRM\ShopBundle\Entity\ParameterGroupTranslation | No errors. |
NexCRM\ShopBundle\Entity\ParameterTranslation | No errors. |
NexCRM\ShopBundle\Entity\PaymentMethod | No errors. |
NexCRM\ShopBundle\Entity\PaymentMethodTranslation | No errors. |
NexCRM\ShopBundle\Entity\ShippingMethod | No errors. |
NexCRM\ShopBundle\Entity\ShippingMethodTranslation | No errors. |
NexCRM\ShopBundle\Entity\Status | No errors. |
NexCRM\ShopBundle\Entity\StatusTranslation | No errors. |
NexCRM\ShopBundle\Entity\Order | 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\NotificationContent | No errors. |
NexCRM\NotificationBundle\Entity\NotificationContentTranslation | 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\PersonBundle\Entity\Person |
|
NexCRM\PersonBundle\Entity\Address | No errors. |
NexCRM\PersonBundle\Entity\BankDetail | No errors. |
NexCRM\PersonBundle\Entity\PersonalData | 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\FileComment | No errors. |
NexCRM\DMSBundle\Entity\FileField | No errors. |
NexCRM\DMSBundle\Entity\FileTemplate | No errors. |
NexCRM\DMSBundle\Entity\FileTemplateField | No errors. |
NexCRM\DMSBundle\Entity\FileTemplateFieldSetting | 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\FolderRule | No errors. |
NexCRM\DMSBundle\Entity\NumericalRoot | No errors. |
NexCRM\DMSBundle\Entity\NumericalRootDefinition | No errors. |
NexCRM\DMSBundle\Entity\OrderRecord | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |