Query Metrics
112
Database Queries
14
Different statements
47.42 ms
Query time
8
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.96 ms (56.84%) |
49 |
SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.dni AS dni_3, t0.healt_cover AS healt_cover_4, t0.height AS height_5, t0.weight AS weight_6, t0.imc AS imc_7, t0.last_height AS last_height_8, t0.last_weight AS last_weight_9, t0.last_imc AS last_imc_10, t0.how_meet_us AS how_meet_us_11, t0.how_meet_us_other AS how_meet_us_other_12, t0.allergies AS allergies_13, t0.hemorrhoids AS hemorrhoids_14, t0.vulvar_varicose AS vulvar_varicose_15, t0.prev_surgeries AS prev_surgeries_16, t0.prev_disease AS prev_disease_17, t0.prev_disease_other AS prev_disease_other_18, t0.fam_varicoses_mother AS fam_varicoses_mother_19, t0.fam_varicoses_father AS fam_varicoses_father_20, t0.fam_varicoses_brothers AS fam_varicoses_brothers_21, t0.fam_varicoses_grandparents AS fam_varicoses_grandparents_22, t0.fam_ulcers_mother AS fam_ulcers_mother_23, t0.fam_ulcers_father AS fam_ulcers_father_24, t0.fam_ulcers_brothers AS fam_ulcers_brothers_25, t0.fam_ulcers_grandparents AS fam_ulcers_grandparents_26, t0.fam_hemorrhoids_mother AS fam_hemorrhoids_mother_27, t0.fam_hemorrhoids_father AS fam_hemorrhoids_father_28, t0.fam_hemorrhoids_brothers AS fam_hemorrhoids_brothers_29, t0.fam_hemorrhoids_grandparents AS fam_hemorrhoids_grandparents_30, t0.fam_diabetes_mother AS fam_diabetes_mother_31, t0.fam_diabetes_father AS fam_diabetes_father_32, t0.fam_diabetes_brothers AS fam_diabetes_brothers_33, t0.fam_diabetes_grandparents AS fam_diabetes_grandparents_34, t0.fam_phlebitis_mother AS fam_phlebitis_mother_35, t0.fam_phlebitis_father AS fam_phlebitis_father_36, t0.fam_phlebitis_brothers AS fam_phlebitis_brothers_37, t0.fam_phlebitis_grandparents AS fam_phlebitis_grandparents_38, t0.fam_embolism_mother AS fam_embolism_mother_39, t0.fam_embolism_father AS fam_embolism_father_40, t0.fam_embolism_brothers AS fam_embolism_brothers_41, t0.fam_embolism_grandparents AS fam_embolism_grandparents_42, t0.cesarea AS cesarea_43, t0.normal_birth AS normal_birth_44, t0.sons AS sons_45, t0.sons_ages AS sons_ages_46, t0.menstrual_cycle AS menstrual_cycle_47, t0.pregnancies AS pregnancies_48, t0.abortions AS abortions_49, t0.gained_lot_weight_in_pregnancy AS gained_lot_weight_in_pregnancy_50, t0.genital_varicose AS genital_varicose_51, t0.aco AS aco_52, t0.name_aco AS name_aco_53, t0.menstrual_last_date AS menstrual_last_date_54, t0.flebo_prev_treat AS flebo_prev_treat_55, t0.flebo_what_treat AS flebo_what_treat_56, t0.eco_doppler_MMII AS eco_doppler_MMII_57, t0.flabo_oral_medications AS flabo_oral_medications_58, t0.compression_stockings_or_bandages AS compression_stockings_or_bandages_59, t0.varicorrhagia AS varicorrhagia_60, t0.ulcer AS ulcer_61, t0.dermatoses AS dermatoses_62, t0.spontaneous_hematomas AS spontaneous_hematomas_63, t0.pigmentations AS pigmentations_64, t0.bruises_easily AS bruises_easily_65, t0.chilblains AS chilblains_66, t0.anatomical_injuries AS anatomical_injuries_67, t0.anato_edema AS anato_edema_68, t0.anato_hypodermitis AS anato_hypodermitis_69, t0.anato_dermatoses AS anato_dermatoses_70, t0.anato_cyanosis AS anato_cyanosis_71, t0.anato_ulcer AS anato_ulcer_72, t0.ocupation AS ocupation_73, t0.medicines AS medicines_74, t0.smoke_quantity AS smoke_quantity_75, t0.alcohol_quantity AS alcohol_quantity_76, t0.description AS description_77, t0.enabled AS enabled_78, t0.first_name AS first_name_79, t0.last_name AS last_name_80, t0.birthday AS birthday_81, t0.gender AS gender_82, t0.last_visit AS last_visit_83, t0.address AS address_84, t0.created_at AS created_at_85, t0.updated_at AS updated_at_86, t0.phone_number AS phone_number_87, t0.subscribed_to_newsletter AS subscribed_to_newsletter_88, t0.id AS id_89, t0.admin_user_id AS admin_user_id_90, t0.professional_id AS professional_id_91, t0.customer_group_id AS customer_group_id_92 FROM sylius_customer t0 WHERE t0.id = ?
Parameters:
[
902
]
|
|
12.62 ms (26.62%) |
50 |
SELECT t0.position AS position_1, t0.id AS id_2, t0.turn_id AS turn_id_3, t0.product_id AS product_id_4, t0.taxon_id AS taxon_id_5 FROM sylius_product_taxon t0 WHERE t0.product_id = ?
Parameters:
[
445
]
|
|
1.94 ms (4.10%) |
1 |
SELECT DISTINCT id_15 FROM (SELECT DISTINCT id_15 FROM (SELECT s0_.code AS code_0, s0_.start AS start_1, s0_.finish AS finish_2, s0_.pre_description AS pre_description_3, s0_.post_description AS post_description_4, s0_.plan AS plan_5, s0_.budget AS budget_6, s0_.height AS height_7, s0_.weight AS weight_8, s0_.imc AS imc_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.enabled AS enabled_12, s0_.cancel AS cancel_13, s0_.is_finish AS is_finish_14, s0_.id AS id_15, s0_.variant_selection_method AS variant_selection_method_16, s0_.average_rating AS average_rating_17, s1_.name AS name_18, s1_.slug AS slug_19, s1_.description AS description_20, s1_.meta_keywords AS meta_keywords_21, s1_.meta_description AS meta_description_22, s1_.id AS id_23, s1_.short_description AS short_description_24, s1_.locale AS locale_25 FROM sylius_product s0_ LEFT JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.enabled = ?) dctrn_result_inner ORDER BY id_15 DESC) dctrn_result LIMIT 50
Parameters:
[ "es_ES" 1 ] |
|
1.03 ms (2.17%) |
1 |
SELECT s0_.code AS code_0, s0_.start AS start_1, s0_.finish AS finish_2, s0_.pre_description AS pre_description_3, s0_.post_description AS post_description_4, s0_.plan AS plan_5, s0_.budget AS budget_6, s0_.height AS height_7, s0_.weight AS weight_8, s0_.imc AS imc_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.enabled AS enabled_12, s0_.cancel AS cancel_13, s0_.is_finish AS is_finish_14, s0_.id AS id_15, s0_.variant_selection_method AS variant_selection_method_16, s0_.average_rating AS average_rating_17, s1_.name AS name_18, s1_.slug AS slug_19, s1_.description AS description_20, s1_.meta_keywords AS meta_keywords_21, s1_.meta_description AS meta_description_22, s1_.id AS id_23, s1_.short_description AS short_description_24, s1_.locale AS locale_25, s0_.customer_id AS customer_id_26, s0_.main_professional_id AS main_professional_id_27, s0_.room_id AS room_id_28, s0_.turn_id AS turn_id_29, s0_.main_taxon_id AS main_taxon_id_30, s1_.translatable_id AS translatable_id_31 FROM sylius_product s0_ LEFT JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.enabled = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id DESC
Parameters:
[ "es_ES" 1 445 444 443 442 441 440 439 438 437 436 435 434 433 432 431 430 429 428 427 426 425 424 423 422 421 420 419 418 417 416 415 414 413 412 411 410 409 408 407 406 405 404 403 402 401 400 399 398 397 396 ] |
|
0.84 ms (1.77%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_15 FROM (SELECT s0_.code AS code_0, s0_.start AS start_1, s0_.finish AS finish_2, s0_.pre_description AS pre_description_3, s0_.post_description AS post_description_4, s0_.plan AS plan_5, s0_.budget AS budget_6, s0_.height AS height_7, s0_.weight AS weight_8, s0_.imc AS imc_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.enabled AS enabled_12, s0_.cancel AS cancel_13, s0_.is_finish AS is_finish_14, s0_.id AS id_15, s0_.variant_selection_method AS variant_selection_method_16, s0_.average_rating AS average_rating_17, s1_.name AS name_18, s1_.slug AS slug_19, s1_.description AS description_20, s1_.meta_keywords AS meta_keywords_21, s1_.meta_description AS meta_description_22, s1_.id AS id_23, s1_.short_description AS short_description_24, s1_.locale AS locale_25 FROM sylius_product s0_ LEFT JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.enabled = ? ORDER BY s0_.id DESC) dctrn_result) dctrn_table
Parameters:
[ "es_ES" 1 ] |
|
0.72 ms (1.53%) |
2 |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.shop_billing_data_id AS shop_billing_data_id_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.enabled AS enabled_28, t26.by_default AS by_default_29, t26.created_at AS created_at_30, t26.updated_at AS updated_at_31, t26.id AS id_32, t0.default_tax_zone_id AS default_tax_zone_id_33, t0.menu_taxon_id AS menu_taxon_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id
Parameters:
[] |
|
0.61 ms (1.29%) |
1 |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.shop_billing_data_id AS shop_billing_data_id_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.enabled AS enabled_28, t26.by_default AS by_default_29, t26.created_at AS created_at_30, t26.updated_at AS updated_at_31, t26.id AS id_32, t0.default_tax_zone_id AS default_tax_zone_id_33, t0.menu_taxon_id AS menu_taxon_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id WHERE t0.hostname = ? AND t0.enabled = ? LIMIT 1
Parameters:
[ "cmp-system.com" 1 ] |
|
0.60 ms (1.27%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 2 "es_ES" ] |
|
0.57 ms (1.21%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.locale_code AS locale_code_23, t0.type AS type_24, t0.phone AS phone_25, t0.birthday AS birthday_26, t0.adminUserGroup_id AS adminUserGroup_id_27, t0.professional_id AS professional_id_28, t29.type AS type_30, t29.legend AS legend_31, t29.path AS path_32, t29.id AS id_33, t29.owner_id AS owner_id_34 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t29 ON t29.owner_id = t0.id WHERE t0.id = ?
Parameters:
[
22
]
|
|
0.33 ms (0.69%) |
1 |
SELECT t0.name AS name_1, t0.lastname AS lastname_2, t0.email AS email_3, t0.dni AS dni_4, t0.generic AS generic_5, t0.enabled AS enabled_6, t0.address AS address_7, t0.birthday AS birthday_8, t0.gender AS gender_9, t0.color AS color_10, t0.cbu AS cbu_11, t0.alias AS alias_12, t0.bank AS bank_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.phone_number AS phone_number_16, t0.description AS description_17, t0.id AS id_18, t0.adminUserGroup_id AS adminUserGroup_id_19, t0.customer_group_id AS customer_group_id_20 FROM sylius_professional t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.32 ms (0.69%) |
1 |
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.path AS path_6, t0.price AS price_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.currency_id AS currency_id_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.31 ms (0.66%) |
1 |
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
1
]
|
|
0.29 ms (0.62%) |
1 |
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.by_default AS by_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ?
Parameters:
[
1
]
|
|
0.26 ms (0.55%) |
1 |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
1
]
|
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 |
|---|---|
| Sylius\Component\Order\Model\Order | No errors. |
| Sylius\Component\Core\Model\Order | No errors. |
| Sylius\Component\Shipping\Model\Shipment | No errors. |
| Sylius\Component\Core\Model\Shipment | No errors. |
| Sylius\Component\User\Model\User | No errors. |
| Sylius\Component\Core\Model\AdminUser |
|
| Sylius\Component\Core\Model\AdminUserGroup | No errors. |
| Sylius\Component\Customer\Model\Professional | No errors. |
| Sylius\Component\Core\Model\Image | No errors. |
| Sylius\Component\Core\Model\AvatarImage | No errors. |
| Sylius\Component\Customer\Model\Customer |
|
| Sylius\Component\User\Model\UserOAuth | No errors. |
| Sylius\Component\Channel\Model\Channel | No errors. |
| Sylius\Component\Core\Model\Channel | No errors. |
| Sylius\Component\Core\Model\ShopBillingData | No errors. |
| Sylius\Component\Locale\Model\Locale | No errors. |
| Sylius\Component\Currency\Model\Currency |
|
| Sylius\Component\Addressing\Model\Zone | No errors. |
| Sylius\Component\Taxonomy\Model\Taxon | No errors. |
| Sylius\Component\Core\Model\Taxon | No errors. |
| Sylius\Component\Payment\Model\PayAcount | No errors. |
| Sylius\Component\Addressing\Model\Country | No errors. |
| Sylius\Component\Product\Model\Product |
|
| Sylius\Component\Core\Model\Product |
|
| Sylius\Component\Product\Model\ProductTranslation | No errors. |
| Sylius\Component\Core\Model\ProductTranslation | No errors. |
| Sylius\Component\Product\Model\ProductRoom | No errors. |
| Sylius\Component\Customer\Model\Turn |
|
| Sylius\Component\Product\Model\ArticleMov |
|
| Sylius\Component\Product\Model\ProductMammary | No errors. |
| Sylius\Component\Product\Model\ProductAbdomen | No errors. |
| Sylius\Component\Core\Model\ProductTaxon | No errors. |
| Sylius\Component\Core\Model\ProductImage | No errors. |
| Sylius\Component\Payment\Model\Pay | No errors. |
| Sylius\Component\Review\Model\Review | No errors. |
| Sylius\Component\Core\Model\ProductReview | No errors. |
| Sylius\Component\Core\Model\Customer |
|
| Sylius\Component\Customer\Model\CustomerGroup | No errors. |
| Sylius\Component\Taxonomy\Model\TaxonTranslation | No errors. |
| Sylius\Component\Core\Model\TaxonImage | No errors. |