Query Metrics
5
Database Queries
5
Different statements
38.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.81 ms (54.09%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount AS amount_3, t0.moneda AS moneda_4, t0.promociones AS promociones_5, t0.fh_vigencia AS fh_vigencia_6, t0.payment_status AS payment_status_7, t0.xml_request AS xml_request_8, t0.original_xml_request AS original_xml_request_9, t0.original_xml_response AS original_xml_response_10, t0.response_received_at AS response_received_at_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.consumer_web_service_id AS consumer_web_service_id_14 FROM payment_intention t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
"TU107252"
]
|
|
8.76 ms (22.78%) |
1 |
UPDATE payment_intention SET payment_status = ?, original_xml_response = ?, response_received_at = ?, update_at = ? WHERE id = ?
Parameters:
[ 1 "<?xml version="1.0" encoding="ISO-8859-15" standalone='yes'?><CENTEROFPAYMENTS><reference>TU107252</reference><response>approved</response><foliocpagos>101531668271</foliocpagos><auth>391684</auth><cd_response>00</cd_response><cd_error/><nb_error/><time>00:12:12</time><date>05/02/2026</date><nb_company>TUREANDO</nb_company><nb_merchant>9545113 TUREANDO WEB USD</nb_merchant><cc_type>CREDITO/BANCO EXTRANJERO/MasterCard</cc_type><tp_operation>VENTA</tp_operation><cc_name/><cc_number>1494</cc_number><cc_expmonth>06</cc_expmonth><cc_expyear>30</cc_expyear><amount>15.22</amount><emv_key_date/><id_url>J6TC5EC5</id_url><email>rodrigosartor1981@gmail.com</email><st_cr>0</st_cr><cc_mask>533305XXXXXX1494</cc_mask><datos_adicionales><data id="1"><label>Tureando</label><value>rodrigo sartor pla</value></data></datos_adicionales><promocion>C</promocion></CENTEROFPAYMENTS>" "2026-02-05 01:12:15" "2026-02-05 01:12:15" 171 ] |
|
7.00 ms (18.19%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.43 ms (3.72%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.webhook AS webhook_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5 FROM consumer_web_service t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.47 ms (1.22%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\PaymentIntention | No errors. |
| App\Entity\ConsumerWebService | No errors. |