Query Metrics
12
Database Queries
8
Different statements
1.92 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.38 ms (19.57%) |
1 |
SELECT data FROM acc_setting WHERE name = 'api_auth_enforced' ORDER BY id DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (16.13%) |
3 |
"COMMIT"
Parameters:
[] |
|
0.25 ms (13.22%) |
1 |
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 ] |
|
0.25 ms (13.18%) |
1 |
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:
[ "" ] |
|
0.21 ms (10.88%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
0.19 ms (9.84%) |
1 |
UPDATE inv_item_group SET global_id = ? WHERE id = ?
Parameters:
[ "329" "329" ] |
|
0.18 ms (9.21%) |
1 |
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" ] |
|
0.15 ms (7.97%) |
1 |
UPDATE spec_type SET global_id = ?, updated_at = ? WHERE id = ?
Parameters:
[ "52" "2026-07-07 11:07:45" "52" ] |
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.