Query Metrics
3
Database Queries
3
Different statements
2.61 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.37 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.id_customer = ?
Parameters:
[
800432
]
|
| 2 | 0.59 ms |
SELECT t0.id_role AS id_role_1, t0.name AS name_2, t0.employee AS employee_3 FROM ps_role t0 INNER JOIN customer_role ON t0.id_role = customer_role.id_role WHERE customer_role.id_customer = ?
Parameters:
[
800432
]
|
| 3 | 0.65 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:
[
"es"
]
|
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
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. |