Query Metrics
10
Database Queries
9
Different statements
10.29 ms
Query time
2
Invalid entities
Queries
#▲ | 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 |
|
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 |
|