Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.image AS image_1,
  a0_.price AS price_2,
  a0_.is_available AS is_available_3,
  a0_.type AS type_4,
  a0_.name AS name_5,
  a0_.description AS description_6,
  a0_.slug AS slug_7,
  a0_.year AS year_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10,
  a0_.deleted_at AS deleted_at_11,
  a1_.id AS id_12,
  a1_.name AS name_13,
  a1_.description AS description_14,
  a1_.metadescription AS metadescription_15,
  a1_.keyword AS keyword_16,
  a1_.year AS year_17,
  a1_.type AS type_18,
  a1_.is_active AS is_active_19,
  a1_.deleted_at AS deleted_at_20,
  c2_.id AS id_21,
  c2_.name AS name_22,
  c2_.description AS description_23,
  c2_.type AS type_24,
  c2_.deleted_at AS deleted_at_25,
  a0_.artist_id AS artist_id_26,
  c2_.parent_id AS parent_id_27
FROM
  artwork a0_
  LEFT JOIN artist a1_ ON a0_.artist_id = a1_.id
  AND (a1_.deleted_at IS NULL)
  LEFT JOIN artwork_category a3_ ON a0_.id = a3_.artwork_id
  LEFT JOIN category c2_ ON c2_.id = a3_.category_id
  AND (c2_.deleted_at IS NULL)
WHERE
  (a0_.slug = ?)
  AND (a0_.deleted_at IS NULL)

SELECT a0_.id AS id_0, a0_.image AS image_1, a0_.price AS price_2, a0_.is_available AS is_available_3, a0_.type AS type_4, a0_.name AS name_5, a0_.description AS description_6, a0_.slug AS slug_7, a0_.year AS year_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.deleted_at AS deleted_at_11, a1_.id AS id_12, a1_.name AS name_13, a1_.description AS description_14, a1_.metadescription AS metadescription_15, a1_.keyword AS keyword_16, a1_.year AS year_17, a1_.type AS type_18, a1_.is_active AS is_active_19, a1_.deleted_at AS deleted_at_20, c2_.id AS id_21, c2_.name AS name_22, c2_.description AS description_23, c2_.type AS type_24, c2_.deleted_at AS deleted_at_25, a0_.artist_id AS artist_id_26, c2_.parent_id AS parent_id_27 FROM artwork a0_ LEFT JOIN artist a1_ ON a0_.artist_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN artwork_category a3_ ON a0_.id = a3_.artwork_id LEFT JOIN category c2_ ON c2_.id = a3_.category_id AND (c2_.deleted_at IS NULL) WHERE (a0_.slug = 'nude-with-calla-lilies') AND (a0_.deleted_at IS NULL);

SELECT
  a0_.id AS id_0,
  a0_.width AS width_1,
  a0_.height AS height_2,
  a0_.price AS price_3,
  a0_.artwork_type AS artwork_type_4,
  a0_.deleted_at AS deleted_at_5
FROM
  available_size a0_
WHERE
  (a0_.artwork_type = ?)
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.price ASC

SELECT a0_.id AS id_0, a0_.width AS width_1, a0_.height AS height_2, a0_.price AS price_3, a0_.artwork_type AS artwork_type_4, a0_.deleted_at AS deleted_at_5 FROM available_size a0_ WHERE (a0_.artwork_type = 'copy') AND (a0_.deleted_at IS NULL) ORDER BY a0_.price ASC;

SELECT
  a0_.id AS id_0,
  a0_.width AS width_1,
  a0_.height AS height_2,
  a0_.price AS price_3,
  a0_.artwork_type AS artwork_type_4,
  a0_.deleted_at AS deleted_at_5
FROM
  available_size a0_
WHERE
  (a0_.artwork_type = ?)
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.price ASC

SELECT a0_.id AS id_0, a0_.width AS width_1, a0_.height AS height_2, a0_.price AS price_3, a0_.artwork_type AS artwork_type_4, a0_.deleted_at AS deleted_at_5 FROM available_size a0_ WHERE (a0_.artwork_type = 'copy') AND (a0_.deleted_at IS NULL) ORDER BY a0_.price ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.description AS description_2,
  f0_.price AS price_3,
  f0_.artwork_type AS artwork_type_4,
  f0_.deleted_at AS deleted_at_5
FROM
  finish f0_
WHERE
  (f0_.artwork_type = ?)
  AND (f0_.deleted_at IS NULL)
ORDER BY
  f0_.price ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.price AS price_3, f0_.artwork_type AS artwork_type_4, f0_.deleted_at AS deleted_at_5 FROM finish f0_ WHERE (f0_.artwork_type = 'copy') AND (f0_.deleted_at IS NULL) ORDER BY f0_.price ASC;

SELECT
  t0.id AS id_1,
  t0.user_temp AS user_temp_2,
  t0.reference AS reference_3,
  t0.pricing_subtotal AS pricing_subtotal_4,
  t0.pricing_discount AS pricing_discount_5,
  t0.pricing_shipping_fees AS pricing_shipping_fees_6,
  t0.pricing_total AS pricing_total_7,
  t0.user_id AS user_id_8,
  t0.code_promo_id AS code_promo_id_9,
  t0.shipping_address_id AS shipping_address_id_10
FROM
  cart t0
WHERE
  t0.user_temp = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_temp AS user_temp_2, t0.reference AS reference_3, t0.pricing_subtotal AS pricing_subtotal_4, t0.pricing_discount AS pricing_discount_5, t0.pricing_shipping_fees AS pricing_shipping_fees_6, t0.pricing_total AS pricing_total_7, t0.user_id AS user_id_8, t0.code_promo_id AS code_promo_id_9, t0.shipping_address_id AS shipping_address_id_10 FROM cart t0 WHERE t0.user_temp = '82d888cb-b244-4efc-9a3f-92e9fb0f341c' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.user_temp AS user_temp_2,
  t0.reference AS reference_3,
  t0.pricing_subtotal AS pricing_subtotal_4,
  t0.pricing_discount AS pricing_discount_5,
  t0.pricing_shipping_fees AS pricing_shipping_fees_6,
  t0.pricing_total AS pricing_total_7,
  t0.user_id AS user_id_8,
  t0.code_promo_id AS code_promo_id_9,
  t0.shipping_address_id AS shipping_address_id_10
FROM
  cart t0
WHERE
  t0.reference = ?

SELECT t0.id AS id_1, t0.user_temp AS user_temp_2, t0.reference AS reference_3, t0.pricing_subtotal AS pricing_subtotal_4, t0.pricing_discount AS pricing_discount_5, t0.pricing_shipping_fees AS pricing_shipping_fees_6, t0.pricing_total AS pricing_total_7, t0.user_id AS user_id_8, t0.code_promo_id AS code_promo_id_9, t0.shipping_address_id AS shipping_address_id_10 FROM cart t0 WHERE t0.reference = 'R126RQTZTNM9A';

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.type AS type_3,
  t0.payment_type AS payment_type_4,
  t0.status AS status_5,
  t0.paid_on AS paid_on_6,
  t0.parcel_traking_number AS parcel_traking_number_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.pricing_subtotal AS pricing_subtotal_11,
  t0.pricing_discount AS pricing_discount_12,
  t0.pricing_shipping_fees AS pricing_shipping_fees_13,
  t0.pricing_total AS pricing_total_14,
  t0.user_id AS user_id_15,
  t0.code_promo_id AS code_promo_id_16,
  t0.shipping_address_id AS shipping_address_id_17,
  t0.billing_address_id AS billing_address_id_18
FROM
  orders t0
WHERE
  t0.reference = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.type AS type_3, t0.payment_type AS payment_type_4, t0.status AS status_5, t0.paid_on AS paid_on_6, t0.parcel_traking_number AS parcel_traking_number_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pricing_subtotal AS pricing_subtotal_11, t0.pricing_discount AS pricing_discount_12, t0.pricing_shipping_fees AS pricing_shipping_fees_13, t0.pricing_total AS pricing_total_14, t0.user_id AS user_id_15, t0.code_promo_id AS code_promo_id_16, t0.shipping_address_id AS shipping_address_id_17, t0.billing_address_id AS billing_address_id_18 FROM orders t0 WHERE t0.reference = 'R126RQTZTNM9A' AND ((t0.deleted_at IS NULL));

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cart (
  user_temp, reference, pricing_subtotal,
  pricing_discount, pricing_shipping_fees,
  pricing_total, user_id, code_promo_id,
  shipping_address_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO cart (user_temp, reference, pricing_subtotal, pricing_discount, pricing_shipping_fees, pricing_total, user_id, code_promo_id, shipping_address_id) VALUES ('82d888cb-b244-4efc-9a3f-92e9fb0f341c', 'R126RQTZTNM9A', 0, 0, 0, 0, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.user_temp AS user_temp_2,
  t0.reference AS reference_3,
  t0.pricing_subtotal AS pricing_subtotal_4,
  t0.pricing_discount AS pricing_discount_5,
  t0.pricing_shipping_fees AS pricing_shipping_fees_6,
  t0.pricing_total AS pricing_total_7,
  t0.user_id AS user_id_8,
  t0.code_promo_id AS code_promo_id_9,
  t0.shipping_address_id AS shipping_address_id_10
FROM
  cart t0
WHERE
  t0.user_temp = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_temp AS user_temp_2, t0.reference AS reference_3, t0.pricing_subtotal AS pricing_subtotal_4, t0.pricing_discount AS pricing_discount_5, t0.pricing_shipping_fees AS pricing_shipping_fees_6, t0.pricing_total AS pricing_total_7, t0.user_id AS user_id_8, t0.code_promo_id AS code_promo_id_9, t0.shipping_address_id AS shipping_address_id_10 FROM cart t0 WHERE t0.user_temp = '82d888cb-b244-4efc-9a3f-92e9fb0f341c' LIMIT 1;