| 1 |
2.89 ms |
select * from shopproductmoq where shopid = '8597665' and productid = '400098936' order by id desc limit 0,1
select * from shopproductmoq where shopid = '8597665' and productid = '400098936' order by id desc limit 0,1;
|
| 2 |
0.77 ms |
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = ? AND c0_.establishmentid = ? AND c0_.productid = ? ORDER BY c0_.id ASC
Parameters: [
"22270733"
"8597665"
"400098936"
]
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = '22270733' AND c0_.establishmentid = '8597665' AND c0_.productid = '400098936' ORDER BY c0_.id ASC;
|
| 3 |
0.86 ms |
SELECT p0_.id AS id_0, p0_.shopid AS shopid_1, p0_.productid AS productid_2, p0_.productprice AS productprice_3, p0_.markasoffer AS markasoffer_4, p0_.addedtime AS addedtime_5 FROM prodproductprice p0_ WHERE p0_.shopid = ? AND p0_.productid = ? ORDER BY p0_.id DESC LIMIT 1
Parameters: [
"8597665"
"400098936"
]
SELECT p0_.id AS id_0, p0_.shopid AS shopid_1, p0_.productid AS productid_2, p0_.productprice AS productprice_3, p0_.markasoffer AS markasoffer_4, p0_.addedtime AS addedtime_5 FROM prodproductprice p0_ WHERE p0_.shopid = '8597665' AND p0_.productid = '400098936' ORDER BY p0_.id DESC LIMIT 1;
|
| 4 |
0.51 ms |
select * from shopproducts where shopid = '8597665' and shopproductid = '400098936'
select * from shopproducts where shopid = '8597665' and shopproductid = '400098936';
|
| 5 |
0.49 ms |
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = ? AND c0_.establishmentid = ? ORDER BY c0_.id ASC
Parameters: [
"22270733"
"8597665"
]
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = '22270733' AND c0_.establishmentid = '8597665' ORDER BY c0_.id ASC;
|
| 6 |
0.45 ms |
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = ? AND c0_.establishmentid = ? AND c0_.productid = ?
Parameters: [
"22270733"
"8597665"
"400098936"
]
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = '22270733' AND c0_.establishmentid = '8597665' AND c0_.productid = '400098936';
|
| 7 |
0.32 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 8 |
0.69 ms |
INSERT INTO cart (userid, cartid, establishmentid, productid, productvariantid, productname, productcartprice, quantity, engravetext, addedtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"22270733"
"z3HxcsIEQzzHIG9lb6xAKrxE"
"8597665"
"400098936"
"0"
"Potato"
31.0
2
""
"2026-07-26 13:49:43"
]
INSERT INTO cart (userid, cartid, establishmentid, productid, productvariantid, productname, productcartprice, quantity, engravetext, addedtime) VALUES ('22270733', 'z3HxcsIEQzzHIG9lb6xAKrxE', '8597665', '400098936', '0', 'Potato', 31, 2, '', '2026-07-26 13:49:43');
|
| 9 |
0.36 ms |
"COMMIT"
|
| 10 |
0.62 ms |
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = ? AND c0_.establishmentid = ? AND c0_.productid = ?
Parameters: [
"22270733"
"8597665"
"400098936"
]
SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = '22270733' AND c0_.establishmentid = '8597665' AND c0_.productid = '400098936';
|
| 11 |
1.14 ms |
select * from shopproductvariants where shopid = '8597665' and productid = '400098936' and productvariantid = ''
select * from shopproductvariants where shopid = '8597665' and productid = '400098936' and productvariantid = '';
|
| 12 |
1.06 ms |
select * from cartproductvariant where shopid = '8597665' and productid = '400098936' and productvariantid = ''
select * from cartproductvariant where shopid = '8597665' and productid = '400098936' and productvariantid = '';
|