http://vhost07.bugfixservice.de/de/upload

Query Metrics

10 Database Queries
9 Different statements
10.29 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.00 ms
SELECT o0_.id AS id_0, o0_.code AS code_1, o0_.name AS name_2, o0_.locale AS locale_3, o0_.erp_id AS erp_id_4 FROM oc_languages o0_ WHERE o0_.locale LIKE ?
Parameters:
[
  "de"
]
2 0.51 ms
SELECT o0_.id AS id_0, o0_.code AS code_1, o0_.name AS name_2, o0_.locale AS locale_3, o0_.erp_id AS erp_id_4 FROM oc_languages o0_ WHERE o0_.locale LIKE ?
Parameters:
[
  "de"
]
3 0.89 ms
SELECT o0_.id AS id_0, o0_.path AS path_1, o0_.level AS level_2, o0_.number AS number_3, o0_.display_as_catalogue AS display_as_catalogue_4, o0_.display_as_list AS display_as_list_5, o0_.display_as_table AS display_as_table_6, o0_.article_count AS article_count_7, o0_.recursive_article_count AS recursive_article_count_8, o0_.children_have_articles AS children_have_articles_9, o0_.erp_id AS erp_id_10, o1_.id AS id_11, o1_.type AS type_12, o1_.value AS value_13, o2_.id AS id_14, o2_.file AS file_15, o2_.hash AS hash_16, o2_.size AS size_17, o2_.width AS width_18, o2_.height AS height_19, o2_.type AS type_20, o2_.mime_type AS mime_type_21, o2_.erp_id AS erp_id_22, o0_.parent_id AS parent_id_23, o1_.web_group_id AS web_group_id_24, o1_.language_id AS language_id_25 FROM oc_web_groups o0_ LEFT JOIN oc_web_group_translations o1_ ON o0_.id = o1_.web_group_id LEFT JOIN oc_web_group_media o3_ ON o0_.id = o3_.web_group_id LEFT JOIN oc_media o2_ ON o2_.id = o3_.media_id WHERE o0_.parent_id IS NULL AND (o0_.article_count > 0 OR o0_.children_have_articles = 1) ORDER BY o0_.number ASC
Parameters:
[]
4 0.58 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.scrap_factor AS scrap_factor_3, t0.active AS active_4 FROM oc_thickness t0 WHERE t0.active = ? ORDER BY t0.value ASC
Parameters:
[
  1
]
5 0.46 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.active AS active_3 FROM oc_material_grades t0 WHERE t0.active = ?
Parameters:
[
  1
]
6 0.47 ms
SELECT t0.id AS id_1, t0.days AS days_2, t0.price_minute AS price_minute_3, t0.color AS color_4, t0.lock_weight AS lock_weight_5, t0.lock_cutting_minutes AS lock_cutting_minutes_6, t0.lock_by AS lock_by_7, t0.name AS name_8, t0.active AS active_9, t0.text_color AS text_color_10 FROM oc_price_surcharge t0
Parameters:
[]
7 0.52 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.type_addition AS type_addition_3, t0.price_form AS price_form_4, t0.addition_days AS addition_days_5, t0.active AS active_6, t0.offer_text AS offer_text_7, t0.allow_to_apply_all AS allow_to_apply_all_8 FROM oc_surcharges t0 WHERE t0.active = ? AND t0.allow_to_apply_all = ?
Parameters:
[
  1
  1
]
8 1.25 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.image AS image_3, t0.has_edit AS has_edit_4, t0.circles AS circles_5, t0.active AS active_6, t0.orden AS orden_7, t0.small_image AS small_image_8 FROM oc_calculation_shape t0 WHERE t0.active = ? ORDER BY t0.orden ASC
Parameters:
[
  1
]
9 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.configuration AS configuration_3, t0.value AS value_4, t0.is_editable AS is_editable_5, t0.modification_date AS modification_date_6 FROM oc_settings t0 WHERE t0.id = ?
Parameters:
[
  38
]
10 4.12 ms
SELECT DISTINCT o0_.id AS id_0, o0_.description AS description_1, o0_.image AS image_2, o0_.has_edit AS has_edit_3, o0_.circles AS circles_4, o0_.active AS active_5, o0_.orden AS orden_6, o0_.small_image AS small_image_7 FROM oc_calculation_shape o0_, oc_wicam_files o1_, oc_wicam_header o2_ WHERE o0_.id = o1_.calculation_shape_id AND o1_.wicam_header_id = o2_.id AND o1_.deleted = 0 AND o0_.active IN (1, 15) ORDER BY o0_.orden ASC
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
App\Entity\Language No errors.
App\Entity\WebGroup No errors.
App\Entity\WebGroupTranslation No errors.
App\Entity\Media No errors.
App\Entity\Article No errors.
App\Entity\Thickness No errors.
App\Entity\MaterialGrades No errors.
App\Entity\PriceSurcharge No errors.
App\Entity\Surcharges
  • The field App\Entity\Surcharges#surchargesCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SurchargesCategory#surcharges does not contain the required 'inversedBy="surchargesCategories"' attribute.
App\Entity\SurchargesThickness No errors.
App\Entity\SurchargesCategory No errors.
App\Entity\CalculationShape No errors.
App\Entity\CalculationShapeVariable No errors.
App\Entity\Setting No errors.
App\Entity\WiCamFiles No errors.
App\Entity\WiCamHeader
  • The association App\Entity\WiCamHeader#customer refers to the inverse side field App\Entity\Customer#wiCamHeaders which does not exist.