https://dev.bigbuy.eu/wishlists/wishlists-with-products/44511

Query Metrics

3 Database Queries
3 Different statements
4.47 ms Query time
0 Invalid entities

Queries

Group similar statements

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

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\Warehouse No errors.
App\Entity\System\Product No errors.
App\Entity\System\ProductStock No errors.
App\Entity\System\Language 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\CategoryLang No errors.
App\Entity\System\Catalog No errors.
App\Entity\System\PackLanguage No errors.
App\Entity\System\SubscriptionLine No errors.
App\Entity\System\Group No errors.
App\Entity\System\Pack No errors.
App\Entity\System\CustomerInvoiceAddress No errors.
App\Entity\System\Country No errors.
App\Entity\System\State No errors.
App\Entity\System\Address No errors.
App\Entity\System\Order No errors.
App\Entity\System\CustomerApi 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\AdminAcl 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\CountryLanguage No errors.
App\Entity\System\TaxRuleGroup No errors.
App\Entity\System\TaxRule No errors.
App\Entity\System\CustomerAnswer No errors.
App\Entity\System\SubscriptionLineHistory No errors.
App\Entity\System\EncryptionKey No errors.
App\Entity\System\Answer No errors.
App\Entity\System\Question No errors.
App\Entity\System\ProductTracking No errors.
App\Entity\System\ProductAttribute 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.
App\Entity\Logs\AdyenPaymentLink No errors.