POST https://stage.api.virtual-marketer.de/api/ai

Query Metrics

9 Database Queries
8 Different statements
3.51 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3 FROM config t0 WHERE t0.`key` = ? LIMIT 1
Parameters:
[
  "PYTHON_INTERFACE"
]
2 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.external_api_key AS external_api_key_4, t0.words_max AS words_max_5, t0.words_used AS words_used_6, t0.maintenance AS maintenance_7, t0.day_of_reset AS day_of_reset_8, t0.created AS created_9, t0.valid_until AS valid_until_10, t0.logo AS logo_11 FROM company t0 WHERE t0.api_key = ? LIMIT 1
Parameters:
[
  "M1e5wYxM-n3y1-gj4c-AZos-APbsnvg9TWxN"
]
3 0.45 ms
SELECT t0.id AS id_1, t0.product AS product_2, t0.model AS model_3, t0.type AS type_4, t0.temperature AS temperature_5, t0.max_tokens AS max_tokens_6, t0.top_p AS top_p_7, t0.stop AS stop_8, t0.suffix AS suffix_9, t0.frequency_penalty AS frequency_penalty_10, t0.presence_penalty AS presence_penalty_11, t0.segment_before AS segment_before_12, t0.segment_after AS segment_after_13, t0.tokens_used AS tokens_used_14, t0.n AS n_15, t0.best_of AS best_of_16, t0.session_id AS session_id_17, t0.company_id AS company_id_18 FROM template t0 WHERE t0.company_id = ? ORDER BY t0.product ASC
Parameters:
[
  20
]
4 0.56 ms
SELECT COUNT(*) FROM template_extension t0 WHERE t0.template_id = ?
Parameters:
[
  445
]
5 0.28 ms
SELECT t0.id AS id_1, t0.`order` AS order_2, t0.`type` AS type_3, t0.data_url AS data_url_4, t0.data_file AS data_file_5, t0.parameter AS parameter_6, t0.initialized AS initialized_7, t0.active AS active_8, t0.reinitialize AS reinitialize_9, t0.extension_type AS extension_type_10, t0.additional_data AS additional_data_11, t0.template_id AS template_id_12 FROM template_extension t0 WHERE t0.template_id = ?
Parameters:
[
  445
]
6 0.25 ms
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3 FROM config t0 WHERE t0.`key` = ? LIMIT 1
Parameters:
[
  "PYTHON_INTERFACE"
]
7 0.50 ms
"START TRANSACTION"
Parameters:
[]
8 0.40 ms
UPDATE template_extension SET active = ? WHERE id = ?
Parameters:
[
  1
  61
]
9 0.11 ms
"COMMIT"
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\Config No errors.
App\Entity\Company No errors.
App\Entity\Template
  • The mappings App\Entity\Template#templateExtensions and App\Entity\TemplateExtension#template are inconsistent with each other.
  • The association App\Entity\Template#assistantThreads refers to the owning side field App\Entity\Assistant#template which does not exist.
App\Entity\Assistant No errors.
App\Entity\TemplateExtension
  • The field 'App\Entity\TemplateExtension#active' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The association App\Entity\TemplateExtension#template refers to the inverse side field App\Entity\Template#templateSources which does not exist.