Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `tb_fichas_oxxo`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id id_alumno order_id
Digital Femsa order ID
referencia
Referencia OXXO para el alumno
barcode_url
URL imagen codigo barras
monto_centavos
Monto en centavos
monto_pesos
Monto en pesos para display
concepto status expires_at
Unix timestamp expiracion
paid_at
Unix timestamp pago confirmado
fee_centavos
Comision Digital Femsa
metadatos fecha_creacion fecha_actualizacion enabled
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 1
1 168 ord_2zXDA6qpm9XaEFTK4 93007062917185 https://barcodes.digitalfemsa.io/f34c11040d81fdb79... 288100 2881.00 Pago colegiatura OXXO expired 1771195560 NULL NULL {"id": "ord_2zXDA6qpm9XaEFTK4", "amount": 288100, ... 2026-02-10 16:46:01 2026-02-15 16:59:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 2
2 2480 ord_2zXnXE4t9dQHzp4K3 98002020090097 https://barcodes.digitalfemsa.io/sandbox_reference... 2000 20.00 Pago colegiatura OXXO expired 1771347587 NULL NULL {"id": "ord_2zXnXE4t9dQHzp4K3", "amount": 2000, "o... 2026-02-12 10:59:48 2026-02-17 22:38:51 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 3
3 2480 ord_2zZRH7j6jUiLh4pRu 98002020115456 https://barcodes.digitalfemsa.io/sandbox_reference... 2000 20.00 Pago colegiatura OXXO paid 1771779360 1771347395 NULL {"livemode":false,"amount":2000,"currency":"MXN","... 2026-02-17 10:56:01 2026-02-17 22:38:51 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 4
4 1 ord_2zZVjh2FahRBZq36a 93007077714486 https://barcodes.digitalfemsa.io/d09d116d029c59000... 2500 25.00 Prueba de pago OXXO expired 1771799675 NULL NULL {"livemode":true,"amount":2500,"currency":"MXN","p... 2026-02-17 16:34:35 2026-02-22 16:36:08 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 5
5 2480 ord_2zZkm2DGudYks4Tgs 93007079105444 https://barcodes.digitalfemsa.io/13c73d4ce51fe699e... 2000 20.00 Pago colegiatura OXXO paid 1771868129 1771436919 NULL {"livemode":true,"amount":2000,"currency":"MXN","p... 2026-02-18 11:35:30 2026-02-18 11:59:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 6
6 5265 ord_2zhHdDmxFH2c21ifu 93007126930992 https://barcodes.digitalfemsa.io/122d3ca0733bfcade... 267325 2673.25 Pago colegiatura OXXO expired 1773858765 NULL NULL {"livemode":true,"amount":267325,"currency":"MXN",... 2026-03-13 12:32:45 2026-03-18 12:33:22 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 7
7 2648 ord_2zooDN3Xd8qd3sD9h 93007169816413 https://barcodes.digitalfemsa.io/09c458e921f0a360c... 252800 2528.00 Pago colegiatura OXXO paid 1775579299 1775149952 NULL {"livemode":true,"amount":252800,"currency":"MXN",... 2026-04-02 10:28:19 2026-04-02 11:29:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 8
8 5795 ord_2zpDB4FUGv6o8VGxx 93007172395066 https://barcodes.digitalfemsa.io/2b154dcc4f0e32522... 314500 3145.00 Pago colegiatura OXXO expired 1775688476 NULL NULL {"livemode":true,"amount":314500,"currency":"MXN",... 2026-04-03 16:47:57 2026-04-08 16:48:32 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 9
9 2085 ord_2zqQH3vaB2KXheWx5 93007179730679 https://barcodes.digitalfemsa.io/1564d9ea02e7ed104... 267650 2676.50 Pago colegiatura OXXO paid 1776003355 1775572233 NULL {"livemode":true,"amount":267650,"currency":"MXN",... 2026-04-07 08:15:55 2026-04-07 09:29:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 10
10 3755 ord_2zsB7SgLcUaESyWc8 93007191287617 https://barcodes.digitalfemsa.io/c00bb9ee1702b53f6... 307900 3079.00 Pago colegiatura OXXO expired 1776471934 NULL NULL {"livemode":true,"amount":307900,"currency":"MXN",... 2026-04-12 18:25:35 2026-04-17 18:25:53 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 11
11 3755 ord_2zwH5Nf6syLQfatnD 93007217065393 https://barcodes.digitalfemsa.io/32193e80397287484... 307900 3079.00 Pago colegiatura OXXO paid 1777556250 1777127528 NULL {"livemode":true,"amount":307900,"currency":"MXN",... 2026-04-25 07:37:30 2026-04-25 10:29:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 12
12 5827 ord_2zycxJ4a645sp8hAL 93007232502255 https://barcodes.digitalfemsa.io/62c252c13e0782f9c... 251600 2516.00 Pago colegiatura OXXO paid 1778175396 1777827488 NULL {"livemode":true,"amount":251600,"currency":"MXN",... 2026-05-02 11:36:37 2026-05-03 11:29:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 13
13 5918 ord_2zzFEsD9rvko2wyxU 93007236488493 https://barcodes.digitalfemsa.io/23064217adb23217f... 449500 4495.00 Pago colegiatura OXXO paid 1778340737 1777931434 NULL {"livemode":true,"amount":449500,"currency":"MXN",... 2026-05-04 09:32:18 2026-05-04 15:59:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 14
14 1394 ord_2zzcj17cWhLMRJFPn 93007239275301 https://barcodes.digitalfemsa.io/260c5b459111f4ec5... 278200 2782.00 Pago colegiatura OXXO paid 1778438637 1778008197 NULL {"livemode":true,"amount":278200,"currency":"MXN",... 2026-05-05 12:43:57 2026-05-05 13:59:09 1
Edit Edit Copy Copy Delete Delete
DELETE FROM tb_fichas_oxxo WHERE `tb_fichas_oxxo`.`id` = 15
15 5837 ord_311cQDLft3689gQvv 93007245284248 https://barcodes.digitalfemsa.io/3c60ef78e39eb824f... 314500 3145.00 Pago colegiatura OXXO expired 1778701446 NULL NULL {"livemode":true,"amount":314500,"currency":"MXN",... 2026-05-08 13:44:06 2026-05-09 15:39:48 1
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query