Query Metrics
23
Database Queries
5
Different statements
22.95 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.13 ms (4.90%) |
1 |
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:
[
500006
]
|
|
1.01 ms (4.40%) |
1 |
SELECT c0_.id AS id_0, c0_.`read` AS read_1, c0_.entity_id AS entity_id_2, n1_.id AS id_3, n1_.expiration_date AS expiration_date_4, n1_.creation_date AS creation_date_5, n1_.notification_date AS notification_date_6, n1_.deactivation_date AS deactivation_date_7, n1_.active AS active_8, n2_.title AS title_9, n2_.description AS description_10, n2_.link AS link_11, n2_.link_text AS link_text_12, c0_.customer_id AS customer_id_13, c0_.notification_id AS notification_id_14, n1_.creation_employee_id AS creation_employee_id_15, n1_.notification_employee_id AS notification_employee_id_16, n1_.deactivation_employee_id AS deactivation_employee_id_17, n1_.type_id AS type_id_18, n1_.notification_product_id AS notification_product_id_19, n1_.section_id AS section_id_20, n2_.notification_id AS notification_id_21, n2_.language_id AS language_id_22 FROM customer_notification c0_ INNER JOIN notification n1_ ON c0_.notification_id = n1_.id INNER JOIN notification_lang n2_ ON n1_.id = n2_.notification_id WHERE (c0_.customer_id = ? AND n1_.active = ?) AND n2_.language_id IN (?, ?) ORDER BY c0_.id DESC
Parameters:
[ 500006 1 4 1 ] |
|
0.90 ms (3.91%) |
1 |
SELECT p0_.id_order AS id_order_0, p0_.id_order_state AS sclr_1, p1_.id_text AS id_text_2 FROM ps_orders p0_ INNER JOIN ps_payment_method p1_ ON p0_.payment_method = p1_.id_payment_method WHERE p0_.id_customer = ? AND p0_.id_order_state IN (?, ?) AND p1_.id_text IN (?, ?) ORDER BY p0_.id_order DESC
Parameters:
[ 500006 1 20 "stripe" "adyen" ] |
|
0.73 ms (3.16%) |
1 |
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:
[
500006
]
|
logs connection
| Time▼ | Count | Info |
|---|---|---|
|
19.19 ms (83.63%) |
19 |
SELECT s0_.checkout_session_reference AS checkout_session_reference_0 FROM stripe_notification s0_ WHERE s0_.order_id = ? AND s0_.event_code = ?
Parameters:
[ 11933164 "checkout.session.created" ] |
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. |
| App\Entity\Report\CustomerSeoData | No errors. |
logs entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Logs\CustomerExternalReferer | No errors. |
| App\Entity\Logs\AdyenPaymentLink | No errors. |
| App\Entity\Logs\StripeNotification | No errors. |