1
0.80 ms
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = '' LIMIT 1 ;
Copy
2
0.18 ms
SELECT p0_ . id AS id_0 , s1_ . quantity AS quantity_1 , p0_ . name AS name_2 , p0_ . price AS price_3 , p0_ . price * s1_ . quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_ . product_id = p0_ . id WHERE s1_ . shoppingcart_id = ?
SELECT p0_ . id AS id_0 , s1_ . quantity AS quantity_1 , p0_ . name AS name_2 , p0_ . price AS price_3 , p0_ . price * s1_ . quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_ . product_id = p0_ . id WHERE s1_ . shoppingcart_id = 2 ;
Copy
3
0.13 ms
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = '' LIMIT 1 ;
Copy
4
0.09 ms
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = '' LIMIT 1 ;
Copy
5
0.08 ms
SELECT p0_ . id AS id_0 , s1_ . quantity AS quantity_1 , p0_ . name AS name_2 , p0_ . price AS price_3 , p0_ . price * s1_ . quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_ . product_id = p0_ . id WHERE s1_ . shoppingcart_id = ?
SELECT p0_ . id AS id_0 , s1_ . quantity AS quantity_1 , p0_ . name AS name_2 , p0_ . price AS price_3 , p0_ . price * s1_ . quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_ . product_id = p0_ . id WHERE s1_ . shoppingcart_id = 2 ;
Copy
6
0.11 ms
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = '' LIMIT 1 ;
Copy
7
0.08 ms
SELECT p0_ . id AS id_0 , s1_ . quantity AS quantity_1 , p0_ . name AS name_2 , p0_ . price AS price_3 , p0_ . price * s1_ . quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_ . product_id = p0_ . id WHERE s1_ . shoppingcart_id = ?
SELECT p0_ . id AS id_0 , s1_ . quantity AS quantity_1 , p0_ . name AS name_2 , p0_ . price AS price_3 , p0_ . price * s1_ . quantity AS sclr_4 FROM shopping_cart_product s1_ INNER JOIN product p0_ ON s1_ . product_id = p0_ . id WHERE s1_ . shoppingcart_id = 2 ;
Copy
8
0.14 ms
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = '' LIMIT 1 ;
Copy
9
0.11 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
10
0.20 ms
UPDATE shopping_cart SET state = ? WHERE id = ?
Parameters :
[
"delivery_address "
2
]
UPDATE shopping_cart SET state = 'delivery_address' WHERE id = 2 ;
Copy
11
5.09 ms
"COMMIT"
12
0.25 ms
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = ? LIMIT 1
Parameters :
[
"j6fcdh11rjnfd5vbcdknupsq19 "
]
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = 'j6fcdh11rjnfd5vbcdknupsq19' LIMIT 1 ;
Copy
13
0.06 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
14
0.21 ms
INSERT INTO shopping_cart (state , session_id , user_id_id ) VALUES (? , ? , ? )
Parameters :
[
"shopping "
"j6fcdh11rjnfd5vbcdknupsq19 "
null
]
INSERT INTO shopping_cart (state , session_id , user_id_id ) VALUES ('shopping' , 'j6fcdh11rjnfd5vbcdknupsq19' , NULL );
Copy
15
3.05 ms
"COMMIT"
16
0.18 ms
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = ? LIMIT 1
Parameters :
[
"j6fcdh11rjnfd5vbcdknupsq19 "
]
SELECT t0 . id AS id_1 , t0 . state AS state_2 , t0 . session_id AS session_id_3 , t0 . user_id_id AS user_id_id_4 FROM shopping_cart t0 WHERE t0 . session_id = 'j6fcdh11rjnfd5vbcdknupsq19' LIMIT 1 ;
Copy
17
0.30 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . eu AS eu_2 , c0_ . iso AS iso_3 FROM country c0_
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . eu AS eu_2 , c0_ . iso AS iso_3 FROM country c0_ ;
Copy