Query Metrics
3
Database Queries
3
Different statements
2.98 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
customer connection
| Time▼ | Count | Info |
|---|---|---|
|
0.50 ms (16.86%) |
1 |
SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1
Parameters:
[
"ma.gymplusoptimal.com"
]
|
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.33 ms (78.17%) |
1 |
SELECT t0.id AS id_1, t0.name_system AS name_system_2, t0.slug AS slug_3, t0.user_contact AS user_contact_4, t0.phone_contact AS phone_contact_5, t0.email_error AS email_error_6, t0.number_client AS number_client_7, t0.number_user AS number_user_8, t0.number_agreements AS number_agreements_9, t0.is_active AS is_active_10, t0.skin AS skin_11, t0.fixed AS fixed_12, t0.sidebar_collapse AS sidebar_collapse_13, t0.terms_conditions AS terms_conditions_14, t0.text_politica AS text_politica_15, t0.questionnaire AS questionnaire_16, t0.questionnaire_software AS questionnaire_software_17, t0.image_login AS image_login_18, t0.image_internal AS image_internal_19, t0.image_horary AS image_horary_20, t0.software_updates AS software_updates_21, t0.horary AS horary_22, t0.number_machine AS number_machine_23, t0.number_class AS number_class_24, t0.is_auto_identifier AS is_auto_identifier_25, t0.is_send_email AS is_send_email_26, t0.send_whatsapp AS send_whatsapp_27, t0.api_whatsapp AS api_whatsapp_28, t0.api_instance_whatsapp AS api_instance_whatsapp_29, t0.template_email_slot AS template_email_slot_30, t0.is_development AS is_development_31, t0.is_request_evaluation AS is_request_evaluation_32, t0.request_evaluation_slot AS request_evaluation_slot_33, t0.nutritional_list_slot AS nutritional_list_slot_34, t0.is_health AS is_health_35, t0.is_evaluation_tools AS is_evaluation_tools_36, t0.is_trainer_prototypes AS is_trainer_prototypes_37, t0.trainer_prototypes_slot AS trainer_prototypes_slot_38, t0.is_virtual_trainer AS is_virtual_trainer_39, t0.is_token AS is_token_40, t0.is_reserve AS is_reserve_41, t0.reserve_slot AS reserve_slot_42, t0.covid_reserve_slot AS covid_reserve_slot_43, t0.is_report_client AS is_report_client_44, t0.is_report_payment AS is_report_payment_45, t0.is_payment AS is_payment_46, t0.is_payment_product AS is_payment_product_47, t0.payment_product_slot AS payment_product_slot_48, t0.is_message_ago AS is_message_ago_49, t0.is_blocking AS is_blocking_50, t0.is_report_training AS is_report_training_51, t0.spotify AS spotify_52, t0.is_discount AS is_discount_53, t0.discount_slot AS discount_slot_54, t0.plan_slot AS plan_slot_55, t0.mercado_pago AS mercado_pago_56, t0.mercado_pago_link AS mercado_pago_link_57, t0.payment_day AS payment_day_58, t0.price AS price_59, t0.price_iva AS price_iva_60, t0.parammeters AS parammeters_61, t0.token AS token_62, t0.is_instance AS is_instance_63, t0.latitude AS latitude_64, t0.longitude AS longitude_65, t0.distance AS distance_66, t0.dni_facto AS dni_facto_67, t0.email_facto AS email_facto_68, t0.day_facto AS day_facto_69, t0.day AS day_70, t0.message_debt AS message_debt_71, t0.registration_client AS registration_client_72, t0.covid_reserved_client AS covid_reserved_client_73, t0.is_massive AS is_massive_74, t0.is_app AS is_app_75, t0.onesignal AS onesignal_76, t0.facebook AS facebook_77, t0.instagram AS instagram_78, t0.twitter AS twitter_79, t0.whatsapp AS whatsapp_80, t0.website AS website_81, t0.api_key_flow AS api_key_flow_82, t0.secret_key_flow AS secret_key_flow_83, t0.api_url_flow AS api_url_flow_84, t0.api_key_flow_facto AS api_key_flow_facto_85, t0.secret_key_flow_facto AS secret_key_flow_facto_86, t0.api_url_flow_facto AS api_url_flow_facto_87, t0.is_admin_setting AS is_admin_setting_88, t0.code_register AS code_register_89, t0.due_date_day AS due_date_day_90, t0.slug_evolution AS slug_evolution_91, t0.suscription AS suscription_92, t0.plan AS plan_93 FROM settings t0 WHERE t0.is_active = ? LIMIT 1
Parameters:
[
1
]
|
|
0.15 ms (4.97%) |
1 |
USE `gym_prod_ma`
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| customer | doctrine.dbal.customer_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| customer | doctrine.orm.customer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Settings | 1 |
customer entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Settings | No errors. |
customer entity manager
No loaded entities.