https://ourhoneybee.eu/api/convertMlParsedProductInfoToLocal

Query Metrics

12 Database Queries
8 Different statements
1.92 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.38 ms
SELECT data FROM acc_setting WHERE name = 'api_auth_enforced' ORDER BY id DESC LIMIT 1
Parameters:
[]
2 0.25 ms
SELECT t0.id AS id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.class_suffix AS class_suffix_4, t0.name AS name_5, t0.unit_text AS unit_text_6, t0.unique_hash AS unique_hash_7, t0.markers AS markers_8, t0.tags AS tags_9, t0.status AS status_10, t0.create_login_id AS create_login_id_11, t0.edit_login_id AS edit_login_id_12, t0.conversion AS conversion_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.doc_booked_flag AS doc_booked_flag_16, t0.time_stamp_of_form AS time_stamp_of_form_17 FROM spec_type t0 WHERE t0.unique_hash = ? LIMIT 1
Parameters:
[
  ""
]
3 0.07 ms
"START TRANSACTION"
Parameters:
[]
4 0.18 ms
UPDATE spec_type SET global_id = ?, STATUS = ?, create_login_id = ?, edit_login_id = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "0"
  true
  0
  0
  "2026-07-07 11:07:45"
  "52"
]
5 0.12 ms
"COMMIT"
Parameters:
[]
6 0.08 ms
"START TRANSACTION"
Parameters:
[]
7 0.25 ms
INSERT INTO inv_item_group (global_id, sync_flag, class_suffix, name, TYPE, company_id, pg_id, group_code, hs_code, start_hs_code, end_hs_code, dr_accounts_head_id, cr_accounts_head_id, ledger_hit_as, default_purchase_action_tag_id, default_expense_id, vat_as_expense_flag, sellable, abstract, icon_path, banner_image, default_image, data_sheets, tax_config_ids, default_tax_config_id, purchase_tax_config_ids, default_purchase_tax_config_id, images, expiry_days, description, categorization_data, specification_types, allowed_unit_types, include_in_product_name, STATUS, unit_type_id, created_login_id, edited_login_id, created_user_id, edited_user_id, created_sig_id, edited_sig_id, doc_booked_flag, time_stamp_of_form) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  null
  null
  ""
  1
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  null
  true
  null
  null
  null
  null
  null
  null
  null
  null
  null
]
8 0.15 ms
UPDATE spec_type SET global_id = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "52"
  "2026-07-07 11:07:45"
  "52"
]
9 0.09 ms
"COMMIT"
Parameters:
[]
10 0.06 ms
"START TRANSACTION"
Parameters:
[]
11 0.19 ms
UPDATE inv_item_group SET global_id = ? WHERE id = ?
Parameters:
[
  "329"
  "329"
]
12 0.10 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
company_group doctrine.dbal.company_group_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
company_group doctrine.orm.company_group_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
ApplicationBundle\Entity\SpecType No errors.
ApplicationBundle\Entity\InvItemGroup No errors.

company_group entity manager

No loaded entities.