D43M0NS

Image	Product Name	Total
	Product 14 $1,281.00	$1,281.00
	Product 12 $129.00	$129.00
	Product 18 $129.00	$129.00
2 items 2 kg

Sub-total:					$1,200.00
VAT (9%):					$108.00
VAT (19%):					$228.00
Green tax (1.00):					$3.00
Total:					$1,539.00

Checkout

	Product 14 1 $1,281.00
	Product 12 1 $129.00
	Product 18 1 $129.00

Sub-total:					$1,200.00
VAT (9%):					$108.00
VAT (19%):					$228.00
Green tax (1.00):					$3.00
Total:					$1,539.00

View cart

Checkout

Errorlog

Sql

1. SELECT pd.*,product.*, product.product_id as array_key FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = :language_id ) WHERE 1 = 1 AND p2s.site_id = :site_id AND product.product_id IN (:product_id) ORDER BY product.product_id DESC
2. 1. product_id
    1. 14
    2. 12
    3. 18
  2. site_id
    1
  3. user_id
  4. user_group_id
    1
  5. site
    1. description
      1. title
        D43M0NS
      2. description
        The next generation website builder
      3. meta-keywords
        cms, page builder, drag and drop, ecommerce, ecommerce platform, designer, developer, php, bootstrap 5
      4. meta-description
        Powerful and easy to use drag and drop website builder for blogs, presentation or ecommerce stores
      5. phone-number
        +55 (111) 123 777
    2. address
      West 21st Street Brooklyn NY
    3. admin-email
      [email protected]
    4. contact-email
      [email protected]
    5. logo
      /media/logo.png
    6. logo-sticky
      /media/logo.png
    7. logo-dark
      /media/logo-white.png
    8. logo-dark-sticky
      /media/logo-white.png
    9. favicon
      /media/favicon.ico
    10. webbanner
      /media/biglogo.png
    11. post_xlarge_width
      1200
    12. post_xlarge_height
      675
    13. post_large_width
      800
    14. post_large_height
      450
    15. post_medium_width
      400
    16. post_medium_height
      225
    17. post_thumb_width
      150
    18. post_thumb_height
      84
    19. product_xlarge_width
      1200
    20. product_xlarge_height
      1536
    21. product_large_width
      800
    22. product_large_height
      1021
    23. product_medium_width
      400
    24. product_medium_height
      510
    25. product_thumb_width
      150
    26. product_thumb_height
      190
    27. date_format
      j F Y
    28. time_format
      g:i A
    29. country_id
      223
    30. region_id
      3655
    31. language_id
      1
    32. currency_id
      1
    33. language
      en
    34. languages
    35. currency
      USD
    36. currencies
    37. invoice_format
      I-{year2}-{month}-{order_id}-{user_id}-{customer_order_id}
    38. order_id_format
      {rand-str-12}-{year2}
    39. length_type_id
      1
    40. weight_type_id
      1
    41. order_status_id
      1
    42. default_comment_status
      1
    43. anonymous_comments
      1
    44. image_format
      webp
    45. favicon-src
      favicon.ico
    46. logo-src
      logo.png
    47. logo-sticky-src
      logo.png
    48. logo-dark-src
      logo-white.png
    49. logo-dark-sticky-src
      logo-white.png
    50. webbanner-src
      biglogo.png
    51. weight_type
      kg
    52. length_type
      cm
    53. url
      *.*.*
  6. path
  7. user
  8. admin
  9. current_year
    2026
  10. language
    en
  11. locale
    en-us
  12. code
    en_US
  13. language_id
    1
  14. rtl
  15. default_language
    en
  16. default_locale
    en-us
  17. default_language_id
    1
  18. currency
    USD
  19. currency_id
    1
  20. country_id
    223
  21. length_type_id
    1
  22. weight_type_id
    1
  23. sql
    SELECT pd.*,product.*, product.product_id as array_key FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = 1 ) WHERE 1 = 1 AND p2s.site_id = 1 AND product.product_id IN (14,12,18) ORDER BY product.product_id DESC
1. SELECT count(*) FROM ( SELECT product.product_id FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = :language_id ) WHERE 1 = 1 AND p2s.site_id = :site_id AND product.product_id IN (:product_id) ) as count
2. 1. product_id
    1. 14
    2. 12
    3. 18
  2. site_id
    1
  3. user_id
  4. user_group_id
    1
  5. site
    1. description
      1. title
        D43M0NS
      2. description
        The next generation website builder
      3. meta-keywords
        cms, page builder, drag and drop, ecommerce, ecommerce platform, designer, developer, php, bootstrap 5
      4. meta-description
        Powerful and easy to use drag and drop website builder for blogs, presentation or ecommerce stores
      5. phone-number
        +55 (111) 123 777
    2. address
      West 21st Street Brooklyn NY
    3. admin-email
      [email protected]
    4. contact-email
      [email protected]
    5. logo
      /media/logo.png
    6. logo-sticky
      /media/logo.png
    7. logo-dark
      /media/logo-white.png
    8. logo-dark-sticky
      /media/logo-white.png
    9. favicon
      /media/favicon.ico
    10. webbanner
      /media/biglogo.png
    11. post_xlarge_width
      1200
    12. post_xlarge_height
      675
    13. post_large_width
      800
    14. post_large_height
      450
    15. post_medium_width
      400
    16. post_medium_height
      225
    17. post_thumb_width
      150
    18. post_thumb_height
      84
    19. product_xlarge_width
      1200
    20. product_xlarge_height
      1536
    21. product_large_width
      800
    22. product_large_height
      1021
    23. product_medium_width
      400
    24. product_medium_height
      510
    25. product_thumb_width
      150
    26. product_thumb_height
      190
    27. date_format
      j F Y
    28. time_format
      g:i A
    29. country_id
      223
    30. region_id
      3655
    31. language_id
      1
    32. currency_id
      1
    33. language
      en
    34. languages
    35. currency
      USD
    36. currencies
    37. invoice_format
      I-{year2}-{month}-{order_id}-{user_id}-{customer_order_id}
    38. order_id_format
      {rand-str-12}-{year2}
    39. length_type_id
      1
    40. weight_type_id
      1
    41. order_status_id
      1
    42. default_comment_status
      1
    43. anonymous_comments
      1
    44. image_format
      webp
    45. favicon-src
      favicon.ico
    46. logo-src
      logo.png
    47. logo-sticky-src
      logo.png
    48. logo-dark-src
      logo-white.png
    49. logo-dark-sticky-src
      logo-white.png
    50. webbanner-src
      biglogo.png
    51. weight_type
      kg
    52. length_type
      cm
    53. url
      *.*.*
  6. path
  7. user
  8. admin
  9. current_year
    2026
  10. language
    en
  11. locale
    en-us
  12. code
    en_US
  13. language_id
    1
  14. rtl
  15. default_language
    en
  16. default_locale
    en-us
  17. default_language_id
    1
  18. currency
    USD
  19. currency_id
    1
  20. country_id
    223
  21. length_type_id
    1
  22. weight_type_id
    1
  23. sql
    SELECT count(*) FROM ( SELECT product.product_id FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = 1 ) WHERE 1 = 1 AND p2s.site_id = 1 AND product.product_id IN (14,12,18) ) as count
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    12
  2. cart
    1. data
      {"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width":"2.00000000","height":"3.00000000","
  3. sql
    UPDATE cart SET `data` = '{"products":{"14":{"product_id":14,"language_id":1,"name":"Product 14","slug":"product-fourteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 14","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 14","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/4-1-150x190_cs.webp","manufacturer_id":3,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":1000,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":2,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":1,"minimum_quantity":1,"subscription_onetime":1,"status":1,"sort_order":0,"created_at":"2022-05-01 00:00:00","updated_at":"2022-05-01 00:00:00","array_key":14,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":14,"url":"\/product\/product-fourteen","remove-url":"\/cart\/remove\/14","total":1000,"total_formatted":"$1,000.00","price_tax":1281,"tax":1281,"total_tax":1281,"price_currency":"USD","price_tax_formatted":"$1,281.00","price_formatted":"$1,000.00","total_tax_formatted":"$1,281.00"},"12":{"product_id":12,"language_id":1,"name":"Product 12","slug":"product-twelve","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 12","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 12","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":990,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/2-1-150x190_cs.webp","manufacturer_id":1,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"12.50000000","weight_type_id":1,"length":"1.00000000","width"
1. SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = :language_id) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = :site_id) WHERE slug = :slug LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT :start, :limit
2. 1. slug
    main-menu
  2. start
  3. limit
    10000
  4. site_id
    1
  5. language_id
    1
  6. user_group_id
    1
  7. languages
  8. default_language
    en
  9. default_language_id
    1
  10. language
    en
  11. currency_id
    1
  12. currency
    USD
  13. currencies
  14. sql
    SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = 1) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = 1) WHERE slug = 'main-menu' LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT 0, 10000
1. SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ORDER BY post.post_id DESC
2. 1. post_id
    1. 12
    2. 7
    3. 13
    4. 14
  2. language_id
    1
  3. sql
    SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (12,7,13,14) ORDER BY post.post_id DESC
1. SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ) as count
2. 1. post_id
    1. 12
    2. 7
    3. 13
    4. 14
  2. language_id
    1
  3. sql
    SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (12,7,13,14) ) as count
1. SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = :language_id) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = :site_id) WHERE slug = :slug LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT :start, :limit
2. 1. slug
    main-footer
  2. start
  3. limit
    10000
  4. site_id
    1
  5. language_id
    1
  6. user_group_id
    1
  7. languages
  8. default_language
    en
  9. default_language_id
    1
  10. language
    en
  11. currency_id
    1
  12. currency
    USD
  13. currencies
  14. sql
    SELECT menu_item.url, menu_item.sort_order, menu_item.parent_id, menu_item.type, menu_item.options, menu_item.item_id, td.*, menu_item.menu_item_id as menu_item_id, menu_item.menu_item_id as array_key FROM menu_item LEFT JOIN menu_item_content td ON (menu_item.menu_item_id = td.menu_item_id AND td.language_id = 1) WHERE 1 = 1 AND menu_item.menu_id = ( SELECT menu.menu_id FROM menu INNER JOIN menu_to_site ON (menu.menu_id = menu_to_site.menu_id AND menu_to_site.site_id = 1) WHERE slug = 'main-footer' LIMIT 1 ) ORDER BY menu_item.parent_id, menu_item.sort_order, menu_item.menu_id LIMIT 0, 10000
1. SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ORDER BY post.post_id DESC
2. 1. post_id
    1. 7
    2. 8
    3. 9
    4. 12
    5. 11
    6. 14
    7. 15
  2. language_id
    1
  3. sql
    SELECT pd.*,post.*,ad.username,ad.display_name,ad.admin_id,ad.email, ad.avatar, ad.bio, ad.first_name, ad.last_name, post.post_id as array_key FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (7,8,9,12,11,14,15) ORDER BY post.post_id DESC
1. SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = :language_id ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (:post_id) ) as count
2. 1. post_id
    1. 7
    2. 8
    3. 9
    4. 12
    5. 11
    6. 14
    7. 15
  2. language_id
    1
  3. sql
    SELECT count(*) FROM ( SELECT post.post_id FROM post LEFT JOIN post_content pd ON ( post.post_id = pd.post_id AND pd.language_id = 1 ) LEFT JOIN post_to_site ps ON (post.post_id = ps.post_id) LEFT JOIN admin ad ON (post.admin_id = ad.admin_id) WHERE 1 = 1 AND post.post_id IN (7,8,9,12,11,14,15) ) as count

Request

product_id
18
route
/cart/add/#product_id#
module
cart/cart/add
pattern
\/cart\/add\/(?\d+)

View

template
cart/cart.html
tplFile
cart/cart.tpl

Filters

Vvveb\System\Db\Mysqli

execute

DebugPlugin

/* /var/www/html/plugins/debug/plugin.php [line: 124 - 129] */
function ($sql, $params){
			$debugSql = $db->debugSql($sql, $params);
			$this->view->debug['data']['sql'][] = [$sql, $params + ['sql' => $debugSql]];

			return [$sql, $params];
		});

Vvveb\System\Core\View

render

DebugPlugin

/* /var/www/html/plugins/debug/plugin.php [line: 167 - 184] */
function ($template, $tplFile, $templateEngine, $view){
			$events = Event::getEvents();

			array_walk_recursive($events, function (&$value, $key) {
				if (is_object($value)) {
					if ($value instanceof \Closure) {
						$value = $this->closureDump($value);
					}
				}
			});

			$view = ['template' => $template, 'tplFile' => $tplFile];
			$this->view->debug['data']['request'] = Routes::getUrlData();
			$this->view->debug['data']['view'] = $view;
			$this->view->debug['data']['filters'] = $events;

			return [$template, $tplFile, $templateEngine, $view];
		});

compile:after

MinifyPlugin

/* /var/www/html/plugins/minify/plugin.php [line: 369 - 381] */
function ($template, $htmlFile, $tplFile, $vTpl, $view){
			$theme = $view->getTheme();

			$this->initMinifier();

			$this->processCss($vTpl, $template, $theme);
			$this->processCss($vTpl, $template, $theme, 'body > ');

			$this->processJs($vTpl, $template, $theme);
			$this->processJs($vTpl, $template, $theme, 'body > ');

			return [$template, $htmlFile, $tplFile, $vTpl, $view];
		});

Features