https://dev.bigbuy.eu/front/api/cart-services/details

Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 0.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:
[
  500006
]
2 0.66 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:
[
  500006
]
3 1.26 ms
SELECT t0.id_cart AS id_cart_1, t0.delivery_option AS delivery_option_2, t0.id_currency AS id_currency_3, t0.secure_key AS secure_key_4, t0.recyclable AS recyclable_5, t0.date_upd AS date_upd_6, t0.date_add AS date_add_7, t0.is_virtual AS is_virtual_8, t0.is_sync AS is_sync_9, t0.is_mobile AS is_mobile_10, t0.dropshipping AS dropshipping_11, t0.total_products AS total_products_12, t0.total_envio AS total_envio_13, t0.logistic_weight AS logistic_weight_14, t0.ref_order_supplier AS ref_order_supplier_15, t0.is_system AS is_system_16, t0.selling_channel AS selling_channel_17, t0.additional_parameters AS additional_parameters_18, t0.date_amazon AS date_amazon_19, t0.fba AS fba_20, t0.max_delivery_datetime AS max_delivery_datetime_21, t0.max_expedition_datetime AS max_expedition_datetime_22, t0.shipment_choices AS shipment_choices_23, t0.ship_from_address_company_name AS ship_from_address_company_name_24, t25.id_order AS id_order_26, t25.reference AS reference_27, t25.id_carrier AS id_carrier_28, t25.id_currency AS id_currency_29, t25.conversion_rate AS conversion_rate_30, t25.module AS module_31, t25.dropshipping AS dropshipping_32, t25.total_discounts AS total_discounts_33, t25.total_discounts_tax_incl AS total_discounts_tax_incl_34, t25.total_discounts_tax_excl AS total_discounts_tax_excl_35, t25.total_paid AS total_paid_36, t25.total_paid_tax_incl AS total_paid_tax_incl_37, t25.total_paid_tax_excl AS total_paid_tax_excl_38, t25.total_paid_real AS total_paid_real_39, t25.total_products AS total_products_40, t25.total_products_wt AS total_products_wt_41, t25.total_shipping AS total_shipping_42, t25.total_shipping_tax_incl AS total_shipping_tax_incl_43, t25.total_shipping_tax_excl AS total_shipping_tax_excl_44, t25.carrier_tax_rate AS carrier_tax_rate_45, t25.total_wrapping AS total_wrapping_46, t25.total_wrapping_tax_incl AS total_wrapping_tax_incl_47, t25.total_wrapping_tax_excl AS total_wrapping_tax_excl_48, t25.invoice_date AS invoice_date_49, t25.delivery_date AS delivery_date_50, t25.valid AS valid_51, t25.validate_transfer AS validate_transfer_52, t25.ref_order_supplier AS ref_order_supplier_53, t25.date_add AS date_add_54, t25.date_upd AS date_upd_55, t25.purse AS purse_56, t25.dropshipping_qty AS dropshipping_qty_57, t25.payment_method_cost AS payment_method_cost_58, t25.dropshipping_cost AS dropshipping_cost_59, t25.re AS re_60, t25.transaction_id AS transaction_id_61, t25.refund AS refund_62, t25.full_refund AS full_refund_63, t25.intracomunitario AS intracomunitario_64, t25.is_tracking AS is_tracking_65, t25.state_dropshipping AS state_dropshipping_66, t25.vol_weight AS vol_weight_67, t25.id_carrier_master AS id_carrier_master_68, t25.quantity_stock_supplier AS quantity_stock_supplier_69, t25.quantity_stock_supplier_3_5 AS quantity_stock_supplier_3_5_70, t25.quantity_future_stock AS quantity_future_stock_71, t25.id_pack AS id_pack_72, t25.delivered_date AS delivered_date_73, t25.api AS api_74, t25.is_system AS is_system_75, t25.selling_channel AS selling_channel_76, t25.date_amazon AS date_amazon_77, t25.additional_parameters AS additional_parameters_78, t25.estimated_shipping_date AS estimated_shipping_date_79, t25.scheduled_confirmation_date AS scheduled_confirmation_date_80, t25.a4b_uuid AS a4b_uuid_81, t25.dispute AS dispute_82, t25.paypal_payer_id AS paypal_payer_id_83, t25.paypal_payer_email AS paypal_payer_email_84, t25.fba AS fba_85, t25.max_expedition_datetime AS max_expedition_datetime_86, t25.max_delivery_datetime AS max_delivery_datetime_87, t25.logistic_weight AS logistic_weight_88, t25.extra_discount_percentage AS extra_discount_percentage_89, t25.ship_from_address_company_name AS ship_from_address_company_name_90, t25.id_cart AS id_cart_91, t25.id_customer AS id_customer_92, t25.id_voucher AS id_voucher_93, t25.id_customer_order_fraud_rule AS id_customer_order_fraud_rule_94, t25.id_address_delivery AS id_address_delivery_95, t25.id_order_state AS id_order_state_96, t25.id_lang AS id_lang_97, t25.warehouse_id AS warehouse_id_98, t25.payment_method AS payment_method_99, t0.id_carrier AS id_carrier_100, t0.id_address_delivery AS id_address_delivery_101, t0.id_customer AS id_customer_102, t0.code_discount_id AS code_discount_id_103, t0.cart_parent_id AS cart_parent_id_104, t0.payment_method AS payment_method_105 FROM ps_cart t0 LEFT JOIN ps_orders t25 ON t25.id_cart = t0.id_cart WHERE t0.id_cart = ?
Parameters:
[
  3876883
]

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\CartProduct No errors.
App\Entity\System\OrderDetailStock No errors.
App\Entity\System\Lock No errors.
App\Entity\System\ProductAttribute No errors.
App\Entity\System\MinimumOrderQuantity No errors.
App\Entity\System\SubscriptionCustomer No errors.
App\Entity\System\CustomerFormAnswers No errors.
App\Entity\System\Subscription No errors.
App\Entity\System\SubscriptionData No errors.
App\Entity\System\SubscriptionCustomerHistory No errors.
App\Entity\System\ProductPrice No errors.
App\Entity\System\ProductCatalog No errors.
App\Entity\System\Discount No errors.
App\Entity\System\ProductPack No errors.
App\Entity\System\Currency No errors.
App\Entity\System\TaxLanguage No errors.
App\Entity\System\Tax No errors.
App\Entity\System\CodeDiscount No errors.
App\Entity\System\PaymentMethod No errors.
App\Entity\System\CustomerOrderFraudRule No errors.
App\Entity\System\OrderStatus 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.
App\Entity\Logs\CartShippingOptions No errors.
App\Entity\Logs\Vies No errors.