http://10.10.5.85/health_check

Method
GET
HTTP Status
200
IP
10.10.200.246
Profiled on
Token
4778df

Query Metrics

8 Database Queries
3 Different statements
2.79 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.43 ms 
SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.published AS published_3, t0.maintenance AS maintenance_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.google_analytics_key AS google_analytics_key_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_secret_key AS recaptcha_secret_key_9, t0.port AS port_10, t0.preview_token AS preview_token_11, t0.template_id AS template_id_12, t0.color_theme_id AS color_theme_id_13, t0.clinic_id AS clinic_id_14 FROM website t0 WHERE t0.domain_name = ? AND t0.published = ? LIMIT 1
Parameters: 
[
  "10.10.5.85"
  1
]
View formatted query    View runnable query    Explain query
2 0.37 ms 
SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.published AS published_3, t0.maintenance AS maintenance_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.google_analytics_key AS google_analytics_key_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_secret_key AS recaptcha_secret_key_9, t0.port AS port_10, t0.preview_token AS preview_token_11, t0.template_id AS template_id_12, t0.color_theme_id AS color_theme_id_13, t0.clinic_id AS clinic_id_14 FROM website t0 WHERE t0.domain_name = ? AND t0.published = ? LIMIT 1
Parameters: 
[
  "10.10.5.85"
  1
]
View formatted query    View runnable query    Explain query
3 0.38 ms 
SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.published AS published_3, t0.maintenance AS maintenance_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.google_analytics_key AS google_analytics_key_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_secret_key AS recaptcha_secret_key_9, t0.port AS port_10, t0.preview_token AS preview_token_11, t0.template_id AS template_id_12, t0.color_theme_id AS color_theme_id_13, t0.clinic_id AS clinic_id_14 FROM website t0 WHERE t0.domain_name = ? AND t0.published = ? LIMIT 1
Parameters: 
[
  "www.10.10.5.85"
  1
]
View formatted query    View runnable query    Explain query
4 0.35 ms 
SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.published AS published_3, t0.maintenance AS maintenance_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.google_analytics_key AS google_analytics_key_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_secret_key AS recaptcha_secret_key_9, t0.port AS port_10, t0.preview_token AS preview_token_11, t0.template_id AS template_id_12, t0.color_theme_id AS color_theme_id_13, t0.clinic_id AS clinic_id_14 FROM website t0 WHERE t0.domain_name = ? AND t0.published = ? LIMIT 1
Parameters: 
[
  "10.10.5.85"
  1
]
View formatted query    View runnable query    Explain query
5 0.21 ms 
SELECT t0.id AS id_1, t0.ip_allowed AS ip_allowed_2, t0.cookies AS cookies_3, t0.is_coming_soon AS is_coming_soon_4, t0.message AS message_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM coming_soon_configuration t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.34 ms 
SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.published AS published_3, t0.maintenance AS maintenance_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.google_analytics_key AS google_analytics_key_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_secret_key AS recaptcha_secret_key_9, t0.port AS port_10, t0.preview_token AS preview_token_11, t0.template_id AS template_id_12, t0.color_theme_id AS color_theme_id_13, t0.clinic_id AS clinic_id_14 FROM website t0 WHERE t0.domain_name = ? AND t0.published = ? LIMIT 1
Parameters: 
[
  "10.10.5.85"
  1
]
View formatted query    View runnable query    Explain query
7 0.36 ms 
SELECT t0.id AS id_1, t0.domain_name AS domain_name_2, t0.published AS published_3, t0.maintenance AS maintenance_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.google_analytics_key AS google_analytics_key_7, t0.recaptcha_site_key AS recaptcha_site_key_8, t0.recaptcha_secret_key AS recaptcha_secret_key_9, t0.port AS port_10, t0.preview_token AS preview_token_11, t0.template_id AS template_id_12, t0.color_theme_id AS color_theme_id_13, t0.clinic_id AS clinic_id_14 FROM website t0 WHERE t0.domain_name = ? AND t0.published = ? LIMIT 1
Parameters: 
[
  "10.10.5.85"
  1
]
View formatted query    View runnable query    Explain query
8 0.35 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.other AS other_7, t0.token AS token_8, t0.expire AS expire_9, t0.active AS active_10, t0.temp_token_for_sso AS temp_token_for_sso_11, t0.adv_phone_number AS adv_phone_number_12, t0.onboarding_step AS onboarding_step_13, t0.screen_resolutions AS screen_resolutions_14, t0.avatar_id AS avatar_id_15, t0.language_id AS language_id_16, t0.franchise_id AS franchise_id_17, t18.firstname AS firstname_19, t18.lastname AS lastname_20, t18.id AS id_21, t18.job AS job_22, t18.description AS description_23, t18.ordinal_id AS ordinal_id_24, t18.wanted_ordinal_id AS wanted_ordinal_id_25, t18.token_mrvveto AS token_mrvveto_26, t18.sex AS sex_27, t18.dedicated_page AS dedicated_page_28, t18.diplomas AS diplomas_29, t18.passions AS passions_30, t18.certified_veterinary AS certified_veterinary_31, t18.avatar_id AS avatar_id_32, t18.user_id AS user_id_33, t0.manufacturer_id AS manufacturer_id_34 FROM user t0 LEFT JOIN clinic_employee t18 ON t18.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
prestashop doctrine.dbal.prestashop_connection
externalData doctrine.dbal.externalData_connection
axonaut doctrine.dbal.axonaut_connection
pricePolicy doctrine.dbal.pricePolicy_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\Apollon\Website No errors.
App\Entity\Apollon\WebsiteTemplate No errors.
App\Entity\Apollon\ColorTheme No errors.
App\Entity\Asclepios\Clinic
  • The field App\Entity\Asclepios\Clinic#website is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Apollon\Website#clinic does not contain the required 'inversedBy="website"' attribute.
  • The mappings App\Entity\Asclepios\Clinic#teamProfileOrders and App\Entity\Asclepios\TeamProfileOrder#clinic are inconsistent with each other.
App\Entity\Athena\ComingSoonConfiguration No errors.
App\Entity\Athena\User
  • The association App\Entity\Athena\User#priceCategories refers to the owning side field App\Entity\Asclepios\PriceCategory#creator which does not exist.
App\Entity\Athena\File No errors.
App\Entity\Athena\Language No errors.
App\Entity\Asclepios\Franchise No errors.
App\Entity\Athena\Employee No errors.
App\Entity\Asclepios\ClinicEmployee No errors.
App\Entity\Asclepios\PrestashopFeatureValue No errors.
App\Entity\Asclepios\PriceCategory No errors.
App\Entity\Athena\County
  • The mappings App\Entity\Athena\County#country and App\Entity\Athena\Country#counties are inconsistent with each other.
App\Entity\Athena\LogConnection No errors.
App\Entity\Athena\LogBiConnectConnection No errors.
App\Entity\Athena\SurveyResponse No errors.