Query Metrics
1
Database Queries
1
Different statements
1.98 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.98 ms (100.00%) |
1 |
SELECT f0_.id AS id_0, f0_.session_id AS session_id_1, f0_.status AS status_2, f0_.customer_type AS customer_type_3, f0_.amount AS amount_4, f0_.bonus_amount AS bonus_amount_5, f0_.quantity AS quantity_6, f0_.card_type AS card_type_7, f0_.greeting_title AS greeting_title_8, f0_.greeting_message AS greeting_message_9, f0_.first_name AS first_name_10, f0_.last_name AS last_name_11, f0_.email AS email_12, f0_.phone AS phone_13, f0_.company_name AS company_name_14, f0_.vat_number AS vat_number_15, f0_.shipping_same_as_billing AS shipping_same_as_billing_16, f0_.stripe_session_id AS stripe_session_id_17, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_18, f0_.stripe_paid_at AS stripe_paid_at_19, f0_.stripe_payment_method AS stripe_payment_method_20, f0_.stripe_refunded_at AS stripe_refunded_at_21, f0_.stripe_refund_id AS stripe_refund_id_22, f0_.stripe_refund_amount AS stripe_refund_amount_23, f0_.accepted_terms AS accepted_terms_24, f0_.accepted_privacy AS accepted_privacy_25, f0_.resume_token AS resume_token_26, f0_.resume_token_sent_at AS resume_token_sent_at_27, f0_.created_at AS created_at_28, f0_.updated_at AS updated_at_29, f0_.completed_at AS completed_at_30, f0_.locked_at AS locked_at_31, f0_.product_digital_id AS product_digital_id_32, f0_.product_analog_id AS product_analog_id_33, f0_.product_template_id AS product_template_id_34, f0_.billing_address_id AS billing_address_id_35, f0_.shipping_address_id AS shipping_address_id_36, f0_.shipping_option_id AS shipping_option_id_37 FROM frontend_card_order f0_ WHERE f0_.session_id = ? AND f0_.status NOT IN (?, ?) ORDER BY f0_.created_at DESC LIMIT 1
Parameters:
[ "" "completed" "abandoned" ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\FrontendCardOrder | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\FrontendCardOrder | No errors. |
| App\Entity\ProductDigital | No errors. |
| App\Entity\ProductAnalog | No errors. |
| App\Entity\ProductTemplate | No errors. |
| App\Entity\FrontendAddress | No errors. |
| App\Entity\ShippingOption | No errors. |
| App\Entity\GiftCard | No errors. |