Home and Kitchen

	Product 17 1 $129.00
	Product 19 1 $256.99

Sub-total:					$299.99
VAT (9%):					$27.00
VAT (19%):					$57.00
Green tax (1.00):					$2.00
Total:					$385.99

View cart

Checkout

Errorlog

Sql

1. SELECT *, _.name as name FROM taxonomy_item_content AS _ LEFT JOIN taxonomy_item as ti ON (_.taxonomy_item_id = ti.taxonomy_item_id) LEFT JOIN taxonomy t ON (ti.taxonomy_id = t.taxonomy_id) LEFT JOIN taxonomy_to_site tt ON (tt.taxonomy_item_id = ti.taxonomy_item_id) WHERE 1 = 1 AND slug = :slug AND language_id = :language_id AND t.post_type = :post_type AND tt.site_id = :site_id LIMIT 1
2. 1. site_id
    1
  2. user_id
  3. user_group_id
    1
  4. 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
      *.*.*
  5. path
  6. user
  7. admin
  8. current_year
    2026
  9. language
    en
  10. locale
    en-us
  11. code
    en_US
  12. language_id
    1
  13. rtl
  14. default_language
    en
  15. default_locale
    en-us
  16. default_language_id
    1
  17. currency
    USD
  18. currency_id
    1
  19. slug
    home-kitchen
  20. post_type
    post
  21. sql
    SELECT *, _.name as name FROM taxonomy_item_content AS _ LEFT JOIN taxonomy_item as ti ON (_.taxonomy_item_id = ti.taxonomy_item_id) LEFT JOIN taxonomy t ON (ti.taxonomy_id = t.taxonomy_id) LEFT JOIN taxonomy_to_site tt ON (tt.taxonomy_item_id = ti.taxonomy_item_id) WHERE 1 = 1 AND slug = 'home-kitchen' AND language_id = 1 AND t.post_type = 'post' AND tt.site_id = 1 LIMIT 1
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    17
  2. cart
    1. data
      {"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_ty
  3. sql
    UPDATE cart SET `data` = '{"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    17
  2. cart
    1. data
      {"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_ty
  3. sql
    UPDATE cart SET `data` = '{"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    17
  2. cart
    1. data
      {"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_ty
  3. sql
    UPDATE cart SET `data` = '{"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    17
  2. cart
    1. data
      {"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_ty
  3. sql
    UPDATE cart SET `data` = '{"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    17
  2. cart
    1. data
      {"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_ty
  3. sql
    UPDATE cart SET `data` = '{"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000
1. UPDATE cart SET `data` = :['cart']['data'] WHERE cart_id = :cart_id
2. 1. cart_id
    17
  2. cart
    1. data
      {"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_ty
  3. sql
    UPDATE cart SET `data` = '{"products":{"17":{"product_id":17,"language_id":1,"name":"Product 17","slug":"product-seventeen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 17","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 17","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":0,"stock_status_id":5,"image":"\/image-cache\/demo\/products\/7-1-150x190_cs.webp","manufacturer_id":5,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":100,"points":400,"tax_type_id":1,"material":"","weight":"1.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000000","height":"0.00000000","length_type_id":1,"date_available":"2023-05-01","type":"product","template":"","views":0,"subtract_stock":0,"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":17,"quantity":1,"option":[],"options":"","subscription_plan_id":false,"product_variant_id":false,"key":17,"url":"\/product\/product-seventeen","remove-url":"\/cart\/remove\/17","total":100,"total_formatted":"$100.00","price_tax":129,"tax":129,"total_tax":129,"price_currency":"USD","price_tax_formatted":"$129.00","price_formatted":"$100.00","total_tax_formatted":"$129.00"},"19":{"product_id":19,"language_id":1,"name":"Product 19","slug":"product-nineteen","excerpt":"Lorem ipsum dolor sit amet","meta_title":"Product 19","meta_description":"","meta_keywords":"","admin_id":1,"model":"Product 19","sku":"","upc":"","ean":"","jan":"","isbn":"","mpn":"","barcode":"","hs_code":"","origin_country":"","mid_code":"","location":"","stock_quantity":1000,"stock_status_id":1,"image":"\/image-cache\/demo\/products\/9-1-150x190_cs.webp","manufacturer_id":0,"vendor_id":1,"requires_shipping":1,"old_price":"0.0000","price":199.99,"points":0,"tax_type_id":1,"material":"","weight":"0.00000000","weight_type_id":1,"length":"0.00000000","width":"0.00000
1. SELECT taxonomy_item_field_value.*, field.settings, field.field_id as array_key FROM taxonomy_item_field_value LEFT JOIN field ON (field.field_id = taxonomy_item_field_value.field_id) WHERE 1 = 1 AND taxonomy_item_field_value.language_id = :language_id ORDER BY field.sort_order LIMIT :start, :limit
2. 1. type
    taxonomy_item
  2. subtype
    categories
  3. start
  4. limit
    100
  5. site_id
    1
  6. language_id
    1
  7. taxonomy_item_id
    6
  8. user_group_id
    1
  9. languages
  10. default_language
    en
  11. default_language_id
    1
  12. language
    en
  13. currency_id
    1
  14. currency
    USD
  15. currencies
  16. sql
    SELECT taxonomy_item_field_value.*, field.settings, field.field_id as array_key FROM taxonomy_item_field_value LEFT JOIN field ON (field.field_id = taxonomy_item_field_value.field_id) WHERE 1 = 1 AND taxonomy_item_field_value.language_id = 1 ORDER BY field.sort_order LIMIT 0, 100
1. SELECT count(*) FROM ( SELECT taxonomy_item_field_value.*, field.settings, field.field_id as array_key FROM taxonomy_item_field_value LEFT JOIN field ON (field.field_id = taxonomy_item_field_value.field_id) WHERE 1 = 1 AND taxonomy_item_field_value.language_id = :language_id ) as count
2. 1. type
    taxonomy_item
  2. subtype
    categories
  3. start
  4. limit
    100
  5. site_id
    1
  6. language_id
    1
  7. taxonomy_item_id
    6
  8. user_group_id
    1
  9. languages
  10. default_language
    en
  11. default_language_id
    1
  12. language
    en
  13. currency_id
    1
  14. currency
    USD
  15. currencies
  16. sql
    SELECT count(*) FROM ( SELECT taxonomy_item_field_value.*, field.settings, field.field_id as array_key FROM taxonomy_item_field_value LEFT JOIN field ON (field.field_id = taxonomy_item_field_value.field_id) WHERE 1 = 1 AND taxonomy_item_field_value.language_id = 1 ) as count
1. SELECT value FROM setting AS _ WHERE _.`key` = :key AND _.namespace = :namespace AND _.site_id = :site_id
2. 1. namespace
    posts
  2. key
    sticky
  3. site_id
    1
  4. sql
    SELECT value FROM setting AS _ WHERE _.`key` = 'sticky' AND _.namespace = 'posts' AND _.site_id = 1
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 ,(SELECT COUNT(c.comment_id) FROM comment c WHERE post.post_id = c.post_id AND c.status = :comment_status ) AS comment_count 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.type = :type AND post.status = :status AND ps.site_id = :site_id ORDER BY post.post_id desc LIMIT :start, :limit
2. 1. page
    1
  2. limit
    4
  3. language_id
    1
  4. source
    autocomplete
  5. type
    post
  6. site_id
    1
  7. order_by
    post_id
  8. direction
    desc
  9. status
    publish
  10. excerpt_limit
    200
  11. comment_count
    1
  12. comment_status
    1
  13. image_size
    medium
  14. user_group_id
    1
  15. languages
  16. default_language
    en
  17. default_language_id
    1
  18. language
    en
  19. currency_id
    1
  20. currency
    USD
  21. currencies
  22. start
  23. post_id
  24. sticky
  25. 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 ,(SELECT COUNT(c.comment_id) FROM comment c WHERE post.post_id = c.post_id AND c.status = 1 ) AS comment_count 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.type = 'post' AND post.status = 'publish' AND ps.site_id = 1 ORDER BY post.post_id desc LIMIT 0, 4
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.type = :type AND post.status = :status AND ps.site_id = :site_id ) as count
2. 1. page
    1
  2. limit
    4
  3. language_id
    1
  4. source
    autocomplete
  5. type
    post
  6. site_id
    1
  7. order_by
    post_id
  8. direction
    desc
  9. status
    publish
  10. excerpt_limit
    200
  11. comment_count
    1
  12. comment_status
    1
  13. image_size
    medium
  14. user_group_id
    1
  15. languages
  16. default_language
    en
  17. default_language_id
    1
  18. language
    en
  19. currency_id
    1
  20. currency
    USD
  21. currencies
  22. start
  23. post_id
  24. sticky
  25. 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.type = 'post' AND post.status = 'publish' AND ps.site_id = 1 ) as count
1. SELECT user.username, user.email, user.first_name, user.last_name, user.display_name, user.avatar, user.bio, user.subscribe, comment.*, comment_id as array_key ,post_content.name, post_content.slug FROM comment LEFT JOIN user ON (user.user_id = comment.user_id) LEFT JOIN post_content ON (post_content.post_id = comment.post_id) WHERE 1 = 1 AND comment.post_id = (SELECT post_id FROM post_content WHERE slug = :slug LIMIT 1) AND post_content.language_id = :language_id AND comment.status = :status ORDER BY parent_id, comment_id DESC LIMIT :start, :limit
2. 1. limit
    4
  2. post_title
    true
  3. order
    desc
  4. slug
    home-kitchen
  5. status
    1
  6. language_id
    1
  7. start
  8. site_id
    1
  9. user_group_id
    1
  10. languages
  11. default_language
    en
  12. default_language_id
    1
  13. language
    en
  14. currency_id
    1
  15. currency
    USD
  16. currencies
  17. sql
    SELECT user.username, user.email, user.first_name, user.last_name, user.display_name, user.avatar, user.bio, user.subscribe, comment.*, comment_id as array_key ,post_content.name, post_content.slug FROM comment LEFT JOIN user ON (user.user_id = comment.user_id) LEFT JOIN post_content ON (post_content.post_id = comment.post_id) WHERE 1 = 1 AND comment.post_id = (SELECT post_id FROM post_content WHERE slug = 'home-kitchen' LIMIT 1) AND post_content.language_id = 1 AND comment.status = 1 ORDER BY parent_id, comment_id DESC LIMIT 0, 4
1. SELECT count(*) FROM ( SELECT comment_id FROM comment LEFT JOIN user ON (user.user_id = comment.user_id) LEFT JOIN post_content ON (post_content.post_id = comment.post_id) WHERE 1 = 1 AND comment.post_id = (SELECT post_id FROM post_content WHERE slug = :slug LIMIT 1) AND post_content.language_id = :language_id AND comment.status = :status ) as count
2. 1. limit
    4
  2. post_title
    true
  3. order
    desc
  4. slug
    home-kitchen
  5. status
    1
  6. language_id
    1
  7. start
  8. site_id
    1
  9. user_group_id
    1
  10. languages
  11. default_language
    en
  12. default_language_id
    1
  13. language
    en
  14. currency_id
    1
  15. currency
    USD
  16. currencies
  17. sql
    SELECT count(*) FROM ( SELECT comment_id FROM comment LEFT JOIN user ON (user.user_id = comment.user_id) LEFT JOIN post_content ON (post_content.post_id = comment.post_id) WHERE 1 = 1 AND comment.post_id = (SELECT post_id FROM post_content WHERE slug = 'home-kitchen' LIMIT 1) AND post_content.language_id = 1 AND comment.status = 1 ) 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-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
1. SELECT value FROM setting AS _ WHERE _.`key` = :key AND _.namespace = :namespace AND _.site_id = :site_id
2. 1. namespace
    posts
  2. key
    sticky
  3. site_id
    1
  4. sql
    SELECT value FROM setting AS _ WHERE _.`key` = 'sticky' AND _.namespace = 'posts' AND _.site_id = 1
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 ,(SELECT COUNT(c.comment_id) FROM comment c WHERE post.post_id = c.post_id AND c.status = :comment_status ) AS comment_count 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) LEFT JOIN post_to_taxonomy_item pt ON (post.post_id = pt.post_id) WHERE 1 = 1 AND post.type = :type AND post.status = :status AND ps.site_id = :site_id AND pt.taxonomy_item_id IN ( SELECT ti.taxonomy_item_id FROM taxonomy_item_content AS tic LEFT JOIN taxonomy_item AS ti ON ti.parent_id = tic.taxonomy_item_id OR ti.taxonomy_item_id = tic.taxonomy_item_id WHERE slug = :taxonomy_item_slug ) ORDER BY post.post_id desc LIMIT :start, :limit
2. 1. limit
    4
  2. taxonomy_item_slug
    home-kitchen
  3. image_size
    large
  4. true
  5. language_id
    1
  6. source
    autocomplete
  7. type
    post
  8. site_id
    1
  9. order_by
    post_id
  10. direction
    desc
  11. status
    publish
  12. excerpt_limit
    200
  13. comment_count
    1
  14. comment_status
    1
  15. user_group_id
    1
  16. languages
  17. default_language
    en
  18. default_language_id
    1
  19. language
    en
  20. currency_id
    1
  21. currency
    USD
  22. currencies
  23. start
  24. post_id
  25. sticky
  26. 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 ,(SELECT COUNT(c.comment_id) FROM comment c WHERE post.post_id = c.post_id AND c.status = 1 ) AS comment_count 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) LEFT JOIN post_to_taxonomy_item pt ON (post.post_id = pt.post_id) WHERE 1 = 1 AND post.type = 'post' AND post.status = 'publish' AND ps.site_id = 1 AND pt.taxonomy_item_id IN ( SELECT ti.taxonomy_item_id FROM taxonomy_item_content AS tic LEFT JOIN taxonomy_item AS ti ON ti.parent_id = tic.taxonomy_item_id OR ti.taxonomy_item_id = tic.taxonomy_item_id WHERE slug = 'home-kitchen' ) ORDER BY post.post_id desc LIMIT 0, 4
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) LEFT JOIN post_to_taxonomy_item pt ON (post.post_id = pt.post_id) WHERE 1 = 1 AND post.type = :type AND post.status = :status AND ps.site_id = :site_id AND pt.taxonomy_item_id IN ( SELECT ti.taxonomy_item_id FROM taxonomy_item_content AS tic LEFT JOIN taxonomy_item AS ti ON ti.parent_id = tic.taxonomy_item_id OR ti.taxonomy_item_id = tic.taxonomy_item_id WHERE slug = :taxonomy_item_slug ) ) as count
2. 1. limit
    4
  2. taxonomy_item_slug
    home-kitchen
  3. image_size
    large
  4. true
  5. language_id
    1
  6. source
    autocomplete
  7. type
    post
  8. site_id
    1
  9. order_by
    post_id
  10. direction
    desc
  11. status
    publish
  12. excerpt_limit
    200
  13. comment_count
    1
  14. comment_status
    1
  15. user_group_id
    1
  16. languages
  17. default_language
    en
  18. default_language_id
    1
  19. language
    en
  20. currency_id
    1
  21. currency
    USD
  22. currencies
  23. start
  24. post_id
  25. sticky
  26. 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) LEFT JOIN post_to_taxonomy_item pt ON (post.post_id = pt.post_id) WHERE 1 = 1 AND post.type = 'post' AND post.status = 'publish' AND ps.site_id = 1 AND pt.taxonomy_item_id IN ( SELECT ti.taxonomy_item_id FROM taxonomy_item_content AS tic LEFT JOIN taxonomy_item AS ti ON ti.parent_id = tic.taxonomy_item_id OR ti.taxonomy_item_id = tic.taxonomy_item_id WHERE slug = 'home-kitchen' ) ) as count
1. SELECT DISTINCT categories.taxonomy_item_id, categories.*, tc.language_id, tc.name, tc.content, tc.slug, tc.content, categories.taxonomy_item_id as array_key FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = :site_id) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = :language_id) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = :language_id AND t2s.site_id = :site_id AND t.type = :type AND t.post_type = :post_type ORDER BY categories.parent_id, categories.sort_order, categories.taxonomy_item_id LIMIT :start, :limit
2. 1. type
    categories
  2. post_type
    post
  3. start
  4. limit
    7
  5. site_id
    1
  6. language_id
    1
  7. order
    price asc
  8. count
  9. parents_only
  10. parents_children_only
  11. parents_without_children
  12. user_group_id
    1
  13. languages
  14. default_language
    en
  15. default_language_id
    1
  16. language
    en
  17. currency_id
    1
  18. currency
    USD
  19. currencies
  20. sql
    SELECT DISTINCT categories.taxonomy_item_id, categories.*, tc.language_id, tc.name, tc.content, tc.slug, tc.content, categories.taxonomy_item_id as array_key FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = 1) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = 1) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = 1 AND t2s.site_id = 1 AND t.type = 'categories' AND t.post_type = 'post' ORDER BY categories.parent_id, categories.sort_order, categories.taxonomy_item_id LIMIT 0, 7
1. SELECT count(*) FROM ( SELECT categories.taxonomy_item_id FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = :site_id) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = :language_id) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = :language_id AND t2s.site_id = :site_id AND t.type = :type AND t.post_type = :post_type ) as count
2. 1. type
    categories
  2. post_type
    post
  3. start
  4. limit
    7
  5. site_id
    1
  6. language_id
    1
  7. order
    price asc
  8. count
  9. parents_only
  10. parents_children_only
  11. parents_without_children
  12. user_group_id
    1
  13. languages
  14. default_language
    en
  15. default_language_id
    1
  16. language
    en
  17. currency_id
    1
  18. currency
    USD
  19. currencies
  20. sql
    SELECT count(*) FROM ( SELECT categories.taxonomy_item_id FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = 1) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = 1) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = 1 AND t2s.site_id = 1 AND t.type = 'categories' AND t.post_type = 'post' ) as count
1. SELECT DISTINCT categories.taxonomy_item_id, categories.*, tc.language_id, tc.name, tc.content, tc.slug, tc.content, categories.taxonomy_item_id as array_key FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = :site_id) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = :language_id) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = :language_id AND t2s.site_id = :site_id AND t.type = :type AND t.post_type = :post_type ORDER BY categories.parent_id, categories.sort_order, categories.taxonomy_item_id LIMIT :start, :limit
2. 1. type
    tags
  2. post_type
    post
  3. start
  4. limit
    7
  5. site_id
    1
  6. language_id
    1
  7. order
    price asc
  8. count
  9. parents_only
  10. parents_children_only
  11. parents_without_children
  12. user_group_id
    1
  13. languages
  14. default_language
    en
  15. default_language_id
    1
  16. language
    en
  17. currency_id
    1
  18. currency
    USD
  19. currencies
  20. sql
    SELECT DISTINCT categories.taxonomy_item_id, categories.*, tc.language_id, tc.name, tc.content, tc.slug, tc.content, categories.taxonomy_item_id as array_key FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = 1) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = 1) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = 1 AND t2s.site_id = 1 AND t.type = 'tags' AND t.post_type = 'post' ORDER BY categories.parent_id, categories.sort_order, categories.taxonomy_item_id LIMIT 0, 7
1. SELECT count(*) FROM ( SELECT categories.taxonomy_item_id FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = :site_id) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = :language_id) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = :language_id AND t2s.site_id = :site_id AND t.type = :type AND t.post_type = :post_type ) as count
2. 1. type
    tags
  2. post_type
    post
  3. start
  4. limit
    7
  5. site_id
    1
  6. language_id
    1
  7. order
    price asc
  8. count
  9. parents_only
  10. parents_children_only
  11. parents_without_children
  12. user_group_id
    1
  13. languages
  14. default_language
    en
  15. default_language_id
    1
  16. language
    en
  17. currency_id
    1
  18. currency
    USD
  19. currencies
  20. sql
    SELECT count(*) FROM ( SELECT categories.taxonomy_item_id FROM taxonomy_item AS categories INNER JOIN taxonomy_to_site t2s ON (categories.taxonomy_item_id = t2s.taxonomy_item_id AND t2s.site_id = 1) INNER JOIN taxonomy_item_content tc ON (categories.taxonomy_item_id = tc.taxonomy_item_id AND tc.language_id = 1) INNER JOIN taxonomy t ON (categories.taxonomy_id = t.taxonomy_id) WHERE tc.language_id = 1 AND t2s.site_id = 1 AND t.type = 'tags' AND t.post_type = 'post' ) as count
1. SELECT YEAR(archives.created_at) AS year ,MONTH(archives.created_at) AS month ,count(archives.post_id) as count FROM post AS archives LEFT JOIN post_to_site ps ON (archives.post_id = ps.post_id) WHERE 1 = 1 AND type = :type AND ps.site_id = :site_id GROUP BY YEAR(archives.created_at) ,MONTH(archives.created_at) ORDER BY YEAR(archives.created_at) ,MONTH(archives.created_at)
2. 1. start
    1
  2. language_id
    1
  3. site_id
    1
  4. count
    4
  5. order
    price asc
  6. limit
  7. type
    post
  8. interval
    month
  9. user_group_id
    1
  10. languages
  11. default_language
    en
  12. default_language_id
    1
  13. language
    en
  14. currency_id
    1
  15. currency
    USD
  16. currencies
  17. sql
    SELECT YEAR(archives.created_at) AS year ,MONTH(archives.created_at) AS month ,count(archives.post_id) as count FROM post AS archives LEFT JOIN post_to_site ps ON (archives.post_id = ps.post_id) WHERE 1 = 1 AND type = 'post' AND ps.site_id = 1 GROUP BY YEAR(archives.created_at) ,MONTH(archives.created_at) ORDER BY YEAR(archives.created_at) ,MONTH(archives.created_at)

Request

slug
home-kitchen
route
/cat/{slug}
module
content/category/index
pattern
\/cat\/(?[^$\/]+)

View

template
content/category.html
tplFile
content/category.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

Home and Kitchen