GET https://uatbackend-peekaboo.tauceti-digital.com/api/v1/_health/test-krakchemia-polish-v1

Query Metrics

8 Database Queries
6 Different statements
3.16 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.name AS name_1, t0.is_active AS is_active_2, t0.is_initialized_at AS is_initialized_at_3, t0.last_sync_at AS last_sync_at_4, t0.next_sync_at AS next_sync_at_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.environment_id AS environment_id_9, t0.locale_dict_id AS locale_dict_id_10, t0.elastic_app_search_id AS elastic_app_search_id_11, t0.dictionary_elastic_search_index_id AS dictionary_elastic_search_index_id_12 FROM search_engine t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "test-krakchemia-polish-v1"
]
2 0.64 ms
SELECT t0.data_id AS data_id_1, t0.data AS data_2, t0.prev_data AS prev_data_3, t0.action AS action_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.elastic_app_search_id AS elastic_app_search_id_8 FROM elastic_app_search_sync_data t0 WHERE t0.elastic_app_search_id = ? AND t0.action IS NULL LIMIT 1
Parameters:
[
  6
]
3 0.41 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.scope AS scope_3, t0.id AS id_4, t0.elastic_search_index_id AS elastic_search_index_id_5, t0.default_setting_id AS default_setting_id_6 FROM elastic_search_index_setting t0 WHERE t0.name = ? AND t0.scope = ? AND t0.elastic_search_index_id = ? LIMIT 1
Parameters:
[
  "elasticsearch_api_key"
  "authorization"
  6
]
4 0.37 ms
SELECT t0.name AS name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM elastic_search_index t0 WHERE t0.id = ?
Parameters:
[
  6
]
5 0.57 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.scope AS scope_3, t0.id AS id_4, t0.elastic_app_search_id AS elastic_app_search_id_5, t0.default_setting_id AS default_setting_id_6 FROM elastic_app_search_setting t0 WHERE t0.name = ? AND t0.scope = ? AND t0.elastic_app_search_id = ? LIMIT 1
Parameters:
[
  "engine_public_key"
  "authorization"
  6
]
6 0.43 ms
SELECT t0.name AS name_1, t0.force_reset AS force_reset_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.synonyms_id AS synonyms_id_6 FROM elastic_app_search t0 WHERE t0.id = ?
Parameters:
[
  6
]
7 0.21 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.scope AS scope_3, t0.id AS id_4, t0.elastic_app_search_id AS elastic_app_search_id_5, t0.default_setting_id AS default_setting_id_6 FROM elastic_app_search_setting t0 WHERE t0.name = ? AND t0.scope = ? AND t0.elastic_app_search_id = ? LIMIT 1
Parameters:
[
  "min_score"
  "schema"
  6
]
8 0.20 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.scope AS scope_3, t0.id AS id_4, t0.elastic_app_search_id AS elastic_app_search_id_5, t0.default_setting_id AS default_setting_id_6 FROM elastic_app_search_setting t0 WHERE t0.name = ? AND t0.scope = ? AND t0.elastic_app_search_id = ? LIMIT 1
Parameters:
[
  "engine_suggestion_field"
  "schema"
  6
]

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
Module\Tcai\Entity\SearchEngine No errors.
Module\Core\Entity\Environment No errors.
Module\Core\Entity\LocaleDict No errors.
Module\Tcai\Entity\ElasticAppSearch
  • The mappings Module\Tcai\Entity\ElasticAppSearch#syncData and Module\Tcai\Entity\ElasticAppSearchSyncData#elasticAppSearch are inconsistent with each other.
Module\Tcai\Entity\ElasticSearchIndex No errors.
Module\Tcai\Entity\SearchEngineFeed No errors.
Module\Settings\Entity\SearchEngineSetting No errors.
Module\Tcai\Entity\ElasticAppSearchSyncData
  • The association Module\Tcai\Entity\ElasticAppSearchSyncData#elasticAppSearch refers to the inverse side field Module\Tcai\Entity\ElasticAppSearch#elasticAppSearchSyncData which does not exist.
Module\Settings\Entity\ElasticSearchIndexSetting No errors.
Module\Settings\Entity\DefaultSetting No errors.
Module\Settings\Entity\ElasticAppSearchSetting No errors.
Module\Tcai\Entity\ElasticAppSearchSynonyms No errors.
Module\Tcai\Entity\ElasticAppSearchNegativeKeywords No errors.
Module\Tcai\Entity\ElasticAppSearchKeywordsExclusion No errors.