Symfony Profiler

select
  *
from
  shopproductmoq
where
  shopid = '5998269'
  and productid = '654073660'
order by
  id desc
limit
  0, 1

select * from shopproductmoq where shopid = '5998269' and productid = '654073660' order by id desc limit 0,1;

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

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 = '5998269' AND c0_.productid = '654073660' ORDER BY c0_.id ASC;

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

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 = '5998269' AND p0_.productid = '654073660' ORDER BY p0_.id DESC LIMIT 1;

select
  *
from
  shopproducts
where
  shopid = '5998269'
  and shopproductid = '654073660'

select * from shopproducts where shopid = '5998269' and shopproductid = '654073660';

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

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 = '5998269' ORDER BY c0_.id ASC;

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 = ?

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 = '5998269' AND c0_.productid = '654073660';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cart (
  userid, cartid, establishmentid, productid,
  productvariantid, productname, productcartprice,
  quantity, engravetext, addedtime
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO cart (userid, cartid, establishmentid, productid, productvariantid, productname, productcartprice, quantity, engravetext, addedtime) VALUES ('22270733', 'CLq3RewiL8CmOS6pzcxWKE8d', '5998269', '654073660', '0', 'Carrot', 13, 2, '', '2026-08-12 22:22:30');

"COMMIT"

"COMMIT";

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 = ?

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 = '5998269' AND c0_.productid = '654073660';

select
  *
from
  shopproductvariants
where
  shopid = '5998269'
  and productid = '654073660'
  and productvariantid = 'ej8fVwsm6QFA'

select * from shopproductvariants where shopid = '5998269' and productid = '654073660' and productvariantid = 'ej8fVwsm6QFA';

select
  *
from
  cartproductvariant
where
  cartid = 'CLq3RewiL8CmOS6pzcxWKE8d'
  and shopid = '5998269'
  and productid = '654073660'
  and productvariantid = 'ej8fVwsm6QFA'

select * from cartproductvariant where cartid = 'CLq3RewiL8CmOS6pzcxWKE8d' and shopid = '5998269' and productid = '654073660' and productvariantid = 'ej8fVwsm6QFA';

insert into cartproductvariant (
  cartid, shopid, productid, productvariantid,
  packweight, packweightunit, packvariantname,
  packagevariantimage, packagevariantprice,
  variantquantity, packagedefault
)
values
  (
    'CLq3RewiL8CmOS6pzcxWKE8d', '5998269',
    '654073660', 'ej8fVwsm6QFA', '',
    '', '1/2 kg', '', '18', '2', ''
  )

insert into cartproductvariant (cartid, shopid, productid, productvariantid, packweight, packweightunit, packvariantname, packagevariantimage, packagevariantprice, variantquantity, packagedefault) values 
        ('CLq3RewiL8CmOS6pzcxWKE8d','5998269','654073660','ej8fVwsm6QFA','','','1/2 kg','','18','2','');