Query Metrics
3
Database Queries
3
Different statements
4.47 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.94 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_basic_free AS date_basic_free_15, t0.paypal_billing_agreement AS paypal_billing_agreement_16, t0.stripe_reference AS stripe_reference_17, t0.date_pack AS date_pack_18, t0.csv_lang AS csv_lang_19, t0.dropshipping_name AS dropshipping_name_20, t0.email_paypal AS email_paypal_21, t0.moroso AS moroso_22, t0.fraudster AS fraudster_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.google_account_id AS google_account_id_34, t0.linkedin_account_id AS linkedin_account_id_35, t0.hubspot_company_id AS hubspot_company_id_36, t0.hubspot_contact_id AS hubspot_contact_id_37, t0.last_access AS last_access_38, t0.stripe_default_payment_method_reference AS stripe_default_payment_method_reference_39, t0.id_group AS id_group_40, t0.id_lang AS id_lang_41, t0.id_pack AS id_pack_42, t43.id AS id_44, t43.state_name AS state_name_45, t43.company AS company_46, t43.name AS name_47, t43.email AS email_48, t43.surnames AS surnames_49, t43.address1 AS address1_50, t43.address2 AS address2_51, t43.postcode AS postcode_52, t43.city AS city_53, t43.phone AS phone_54, t43.phone_mobile AS phone_mobile_55, t43.vat_number AS vat_number_56, t43.date_add AS date_add_57, t43.date_upd AS date_upd_58, t43.vise AS vise_59, t43.re AS re_60, t43.comercial_name AS comercial_name_61, t43.type_customer AS type_customer_62, t43.contact_name AS contact_name_63, t43.url AS url_64, t43.phone_prefix AS phone_prefix_65, t43.phone_mobile_prefix AS phone_mobile_prefix_66, t43.company_name AS company_name_67, t43.iso_vat_number AS iso_vat_number_68, t43.company_verified AS company_verified_69, t43.eori AS eori_70, t43.voec AS voec_71, t43.country_id AS country_id_72, t43.state_id AS state_id_73, t43.customer_id AS customer_id_74, t43.old_address_id AS old_address_id_75 FROM ps_customer t0 LEFT JOIN customer_invoice_address t43 ON t43.customer_id = t0.id_customer WHERE t0.id_customer = ?
Parameters:
[
800241
]
|
| 2 | 0.89 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:
[
800241
]
|
| 3 | 1.63 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, p1_.id_product_tracking AS id_product_tracking_2, w0_.customer_id AS customer_id_3, p1_.id_product AS id_product_4, p1_.id_product_attribute AS id_product_attribute_5, p1_.wishlist_id AS wishlist_id_6 FROM wishlist w0_ LEFT JOIN ps_product_tracking p1_ ON w0_.id = p1_.wishlist_id AND (p1_.id_product = ?) WHERE w0_.customer_id = ?
Parameters:
[ 44511 800241 ] |
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. |
| App\Entity\Logs\AdyenPaymentLink | No errors. |