https://dev.bigbuy.eu/account/validate?email=test%40test.es

Query Metrics

2 Database Queries
2 Different statements
3.25 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.08 ms
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
  "en"
]
2 2.17 ms
SELECT t0.id_customer AS id_customer_1, t0.name AS name_2, t0.surnames AS surnames_3, t0.email AS email_4, t0.passwd AS passwd_5, t0.purse AS purse_6, t0.last_passwd_gen AS last_passwd_gen_7, t0.multifactor_auth_enabled AS multifactor_auth_enabled_8, t0.order_confirmation_delay AS order_confirmation_delay_9, t0.active AS active_10, t0.dropshipping AS dropshipping_11, t0.date_add AS date_add_12, t0.date_upd AS date_upd_13, t0.comment AS comment_14, t0.date_csv AS date_csv_15, t0.date_basic_free AS date_basic_free_16, t0.paypal_billing_agreement AS paypal_billing_agreement_17, t0.stripe_reference AS stripe_reference_18, t0.date_pack AS date_pack_19, t0.csv_lang AS csv_lang_20, t0.dropshipping_name AS dropshipping_name_21, t0.email_paypal AS email_paypal_22, t0.moroso AS moroso_23, t0.payer_id_paypal AS payer_id_paypal_24, t0.excluir_vies AS excluir_vies_25, t0.date_excluir_iva AS date_excluir_iva_26, t0.force_password_update AS force_password_update_27, t0.read_policy_cookies AS read_policy_cookies_28, t0.pack_by_purse AS pack_by_purse_29, t0.partial_creation AS partial_creation_30, t0.purchase_not_allowed AS purchase_not_allowed_31, t0.pack_bankwire_payment AS pack_bankwire_payment_32, t0.adyen_payment_id AS adyen_payment_id_33, t0.the_power_mba_user_id AS the_power_mba_user_id_34, t0.google_account_id AS google_account_id_35, t0.linkedin_account_id AS linkedin_account_id_36, t0.hubspot_company_id AS hubspot_company_id_37, t0.hubspot_contact_id AS hubspot_contact_id_38, t0.last_access AS last_access_39, t0.stripe_default_payment_method_reference AS stripe_default_payment_method_reference_40, t0.id_group AS id_group_41, t0.id_lang AS id_lang_42, t0.id_pack AS id_pack_43, t44.id AS id_45, t44.state_name AS state_name_46, t44.company AS company_47, t44.name AS name_48, t44.email AS email_49, t44.surnames AS surnames_50, t44.address1 AS address1_51, t44.address2 AS address2_52, t44.postcode AS postcode_53, t44.city AS city_54, t44.phone AS phone_55, t44.phone_mobile AS phone_mobile_56, t44.vat_number AS vat_number_57, t44.date_add AS date_add_58, t44.date_upd AS date_upd_59, t44.vise AS vise_60, t44.re AS re_61, t44.comercial_name AS comercial_name_62, t44.type_customer AS type_customer_63, t44.contact_name AS contact_name_64, t44.url AS url_65, t44.phone_prefix AS phone_prefix_66, t44.phone_mobile_prefix AS phone_mobile_prefix_67, t44.company_name AS company_name_68, t44.iso_vat_number AS iso_vat_number_69, t44.company_verified AS company_verified_70, t44.eori AS eori_71, t44.voec AS voec_72, t44.country_id AS country_id_73, t44.state_id AS state_id_74, t44.customer_id AS customer_id_75, t44.old_address_id AS old_address_id_76 FROM ps_customer t0 LEFT JOIN customer_invoice_address t44 ON t44.customer_id = t0.id_customer WHERE t0.email = ? LIMIT 1
Parameters:
[
  "[email protected]"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
report doctrine.dbal.report_connection
logs doctrine.dbal.logs_connection

Entity Managers

Name Service
auto_generate_proxy_classes doctrine.orm.auto_generate_proxy_classes_entity_manager
default doctrine.orm.default_entity_manager
report doctrine.orm.report_entity_manager
logs doctrine.orm.logs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

auto_generate_proxy_classes entity manager

No loaded entities.

default entity manager

Class Mapping errors
App\Entity\System\Employee No errors.
App\Entity\System\Customer No errors.
App\Entity\System\ServiceCustomerParameter No errors.
App\Entity\System\ServiceCustomer No errors.
App\Entity\System\Supplier No errors.
App\Entity\System\IncomingStock No errors.
App\Entity\System\SupplierHolidays No errors.
App\Entity\System\Product No errors.
App\Entity\System\Language No errors.
App\Entity\System\Configuration No errors.
App\Entity\System\CmsLanguage No errors.
App\Entity\System\TaxonomyLanguage No errors.
App\Entity\System\BrandLanguage No errors.
App\Entity\System\ProductImage No errors.
App\Entity\System\Catalog No errors.
App\Entity\System\Order No errors.
App\Entity\System\Country No errors.
App\Entity\System\MultifactorAuth No errors.
App\Entity\System\Carrier No errors.
App\Entity\System\Tracking No errors.
App\Entity\System\Cart No errors.
App\Entity\System\OrderNotification No errors.
App\Entity\System\PaymentMethod No errors.
App\Entity\System\CountryLanguage No errors.
App\Entity\System\TaxRuleGroup No errors.
App\Entity\System\TaxRule No errors.
App\Entity\System\PackLanguage No errors.
App\Entity\System\CustomerAnswer No errors.
App\Entity\System\SubscriptionLineHistory No errors.
App\Entity\System\EncryptionKey No errors.
App\Entity\System\AdminAcl No errors.
App\Entity\System\Answer No errors.
App\Entity\System\Question No errors.
App\Entity\System\CustomerApi No errors.
App\Entity\System\Group No errors.
App\Entity\System\Pack No errors.
App\Entity\System\CustomerInvoiceAddress No errors.
App\Entity\System\State No errors.
App\Entity\System\Address No errors.
App\Entity\System\FuturePack No errors.
App\Entity\System\SubscriptionLine No errors.
App\Entity\System\CustomerLog No errors.
App\Entity\System\Ftp No errors.
App\Entity\System\SynchronisedShopConfiguration No errors.
App\Entity\System\CustomerMigration No errors.
App\Entity\System\Role No errors.
App\Entity\System\CustomerCatalog No errors.
App\Entity\System\AdditionalInfoAnswer No errors.
App\Entity\System\Wishlist No errors.
App\Entity\System\ApiResponseTime No errors.
App\Entity\System\TapfiliateCustomer No errors.

report entity manager

Class Mapping errors
App\Entity\Report\CustomerAuthenticationAccessControl No errors.
App\Entity\Report\CustomerAuthenticationAccessControlLog No errors.

logs entity manager

Class Mapping errors
App\Entity\Logs\CustomerExternalReferer No errors.