https://int.my.brunex.ch/robots.txt

Query Metrics

9 Database Queries
4 Different statements
3.43 ms Query time
8 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TRACKING"
]
2 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "OPTIONAL_ARTICLES"
]
3 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "MODULE_DECLARATION"
]
4 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "MODULE_TRANSLATION"
]
5 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "MONTAGE_OBERFLAECHE_AUFSCHLAG"
]
6 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3 FROM feature_flag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "677_MITTELLAGE"
]
7 0.50 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.settings AS settings_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.default_contact AS default_contact_12, t13.id AS id_14, t13.created AS created_15, t13.updated AS updated_16, t13.email AS email_17, t13.first_name AS first_name_18, t13.last_name AS last_name_19, t13.area AS area_20, t13.phone AS phone_21, t13.image AS image_22 FROM site t0 LEFT JOIN company_person t13 ON t0.default_contact = t13.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
8 0.38 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "1"
  "de"
  "Roothirsch\CoreBundle\Site\Entity\Site"
]
9 0.24 ms
SELECT t0.id AS id_1, t0.language_name AS language_name_2, t0.language_key AS language_key_3, t0.is_default_language AS is_default_language_4, t0.image AS image_5 FROM translation_language t0 WHERE t0.language_key = ? LIMIT 1
Parameters:
[
  "de"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
my_brunex doctrine.dbal.my_brunex_connection

Entity Managers

Name Service
my_brunex doctrine.orm.my_brunex_entity_manager
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

my_brunex entity manager

No loaded entities.

default entity manager

Class Mapping errors
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
Roothirsch\CoreBundle\Site\Entity\Site
  • The mappings Roothirsch\CoreBundle\Site\Entity\Site#defaultContact and Roothirsch\CoreBundle\Entity\ContactPerson#users are inconsistent with each other.
Roothirsch\CoreBundle\FeatureFlag\Entity\FeatureFlag No errors.
Roothirsch\CoreBundle\Entity\ContactPerson No errors.
Roothirsch\CoreBundle\Entity\User No errors.
Roothirsch\CoreBundle\Translation\Entity\Language No errors.
Roothirsch\CoreBundle\Entity\Company No errors.
Roothirsch\CoreBundle\Entity\ContactValidation No errors.
Roothirsch\CoreBundle\Entity\Group No errors.
App\Entity\Company No errors.
App\Entity\Declaration\EvidenceDocument No errors.
App\Entity\Declaration\RegulationDocument No errors.
App\Entity\Declaration\DetailDocument No errors.
App\Entity\Declaration\Usage No errors.
App\Entity\Declaration\Field No errors.
App\Entity\Declaration\Declaration No errors.
App\Entity\Declaration\Definition No errors.
App\Entity\Declaration\Attachment No errors.
App\Entity\Declaration\Product No errors.
App\Entity\Legacy\Estimate
  • The field 'App\Entity\Legacy\Estimate#items' uses a non-existent type 'json_array'.
  • The field 'App\Entity\Legacy\Estimate#files' uses a non-existent type 'json_array'.
App\Entity\Legacy\EstimateAddress No errors.
App\Entity\Tuer24\Category
  • The mappings App\Entity\Tuer24\Category#parent and App\Entity\Tuer24\Category#children are inconsistent with each other.
  • The association App\Entity\Tuer24\Category#children refers to the owning side field App\Entity\Tuer24\Category#parent_id which does not exist.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
Gedmo\Translator\Entity\Translation No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure No errors.
Roothirsch\CoreBundle\Entity\Address No errors.
Roothirsch\CoreBundle\Entity\Company\CompanyAttributeValue No errors.
Roothirsch\CoreBundle\Entity\ReportSubscription No errors.
Roothirsch\CoreBundle\Entity\ResetPasswordRequest No errors.
Roothirsch\CoreBundle\Entity\Company\CompanyAttributeOption No errors.
Roothirsch\CoreBundle\Entity\Company\CompanyAttribute No errors.
Roothirsch\CoreBundle\Menu\Entity\MenuItem
  • The mappings Roothirsch\CoreBundle\Menu\Entity\MenuItem#parent and Roothirsch\CoreBundle\Menu\Entity\MenuItem#children are inconsistent with each other.
  • The association Roothirsch\CoreBundle\Menu\Entity\MenuItem#children refers to the owning side field Roothirsch\CoreBundle\Menu\Entity\MenuItem#parent_id which does not exist.
Roothirsch\CoreBundle\Translation\Entity\TranslationUnit No errors.
Roothirsch\CoreBundle\Translation\Entity\TranslationScope
  • The mappings Roothirsch\CoreBundle\Translation\Entity\TranslationScope#units and Roothirsch\CoreBundle\Translation\Entity\TranslationUnit#scope are inconsistent with each other.
Roothirsch\PimBundle\Entity\DataSource No errors.
Roothirsch\PimBundle\Entity\Product No errors.
Roothirsch\PimBundle\Entity\Article No errors.
Roothirsch\PimBundle\Entity\AttributeOption No errors.
Roothirsch\PimBundle\Entity\AttributeValue No errors.
Roothirsch\PimBundle\Entity\AttributeGroup
  • The association Roothirsch\PimBundle\Entity\AttributeGroup#categories refers to the owning side field Roothirsch\PimBundle\Entity\Category#attributeGroups which does not exist.
Roothirsch\PimBundle\Entity\Channel No errors.
Roothirsch\PimBundle\Entity\Category
  • The mappings Roothirsch\PimBundle\Entity\Category#parent and Roothirsch\PimBundle\Entity\Category#children are inconsistent with each other.
  • The association Roothirsch\PimBundle\Entity\Category#children refers to the owning side field Roothirsch\PimBundle\Entity\Category#parent_id which does not exist.
  • The mappings Roothirsch\PimBundle\Entity\Category#productAttributeGroups and Roothirsch\PimBundle\Entity\AttributeGroup#categories are inconsistent with each other.
  • The mappings Roothirsch\PimBundle\Entity\Category#articleAttributeGroups and Roothirsch\PimBundle\Entity\AttributeGroup#categories are inconsistent with each other.
Roothirsch\PimBundle\Entity\DataSource\ExcelSource No errors.
Roothirsch\PimBundle\Entity\Attribute No errors.
Roothirsch\DamBundle\Entity\Category
  • The mappings Roothirsch\DamBundle\Entity\Category#parent and Roothirsch\DamBundle\Entity\Category#children are inconsistent with each other.
  • The association Roothirsch\DamBundle\Entity\Category#children refers to the owning side field Roothirsch\DamBundle\Entity\Category#parent_id which does not exist.
Roothirsch\DamBundle\Entity\Asset No errors.
Roothirsch\DamBundle\Entity\File No errors.
Roothirsch\ShopBundle\Entity\Address No errors.
Roothirsch\ShopBundle\Entity\EstimatePositionAttribute No errors.
Roothirsch\ShopBundle\Entity\Estimate\EstimateAttributeValue No errors.
Roothirsch\ShopBundle\Entity\Estimate\EstimateAttribute No errors.
Roothirsch\ShopBundle\Entity\Estimate\EstimateAttributeOption No errors.
Roothirsch\ShopBundle\Entity\EstimatePosition No errors.
Roothirsch\ShopBundle\Entity\PositionTemplate No errors.
Roothirsch\ShopBundle\Entity\Estimate No errors.
Roothirsch\ShopBundle\Entity\Order No errors.
Roothirsch\ShopBundle\Entity\Order\OrderAttributeValue No errors.
Roothirsch\ShopBundle\Entity\Order\OrderAttributeOption No errors.
Roothirsch\ShopBundle\Entity\Order\OrderAttribute No errors.
Roothirsch\ShopBundle\Entity\OrderPositionAttribute No errors.
Roothirsch\ShopBundle\Entity\OrderPosition No errors.
Roothirsch\ShopBundle\Entity\PositionTemplateAttribute No errors.
Roothirsch\NotificationBundle\Entity\Notification No errors.
Roothirsch\NotificationBundle\Entity\NotificationReadOn No errors.
Roothirsch\DeliveryTimeEstimatorBundle\Entity\ProductGroup No errors.
Roothirsch\DeliveryTimeEstimatorBundle\Entity\Downtime No errors.
Roothirsch\DeliveryTimeEstimatorBundle\Entity\Product No errors.
Vich\UploaderBundle\Entity\File No errors.