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
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 = 'category-8'
AND language_id = 1
AND t.post_type = 'product'
AND tt.site_id = 1
LIMIT 1
UPDATE cart
SET `data` = :['cart']['data']
WHERE cart_id = :cart_id
17
{"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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}
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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}'
WHERE cart_id = 17
UPDATE cart
SET `data` = :['cart']['data']
WHERE cart_id = :cart_id
17
{"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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}
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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}'
WHERE cart_id = 17
UPDATE cart
SET `data` = :['cart']['data']
WHERE cart_id = :cart_id
17
{"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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""},"tax.3":{"namespace":"tax","key":"tax.3","title":"Green tax (1.00)","value":1,"value_formatted":"$1.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}
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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""},"tax.3":{"namespace":"tax","key":"tax.3","title":"Green tax (1.00)","value":1,"value_formatted":"$1.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}'
WHERE cart_id = 17
UPDATE cart
SET `data` = :['cart']['data']
WHERE cart_id = :cart_id
17
{"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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}
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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}'
WHERE cart_id = 17
UPDATE cart
SET `data` = :['cart']['data']
WHERE cart_id = :cart_id
17
{"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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}
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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}'
WHERE cart_id = 17
UPDATE cart
SET `data` = :['cart']['data']
WHERE cart_id = :cart_id
17
{"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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""},"tax.3":{"namespace":"tax","key":"tax.3","title":"Green tax (1.00)","value":1,"value_formatted":"$1.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}
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"}},"taxes":[],"totals":{"sub_total":{"namespace":"total","key":"sub_total","title":"Sub-total","value":100,"value_formatted":"$100.00","text":""},"tax.1":{"namespace":"tax","key":"tax.1","title":"VAT (9%)","value":9,"value_formatted":"$9.00","text":""},"tax.2":{"namespace":"tax","key":"tax.2","title":"VAT (19%)","value":19,"value_formatted":"$19.00","text":""},"tax.3":{"namespace":"tax","key":"tax.3","title":"Green tax (1.00)","value":1,"value_formatted":"$1.00","text":""}},"total_items":1,"coupons":[],"product_options":[]}'
WHERE cart_id = 17
SELECT * FROM manufacturer
LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id)
WHERE p2s.site_id = :site_id
LIMIT :start, :limit
4
price asc
7
1
tags
1
1
en
1
en
1
1
USD
SELECT * FROM manufacturer
LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id)
WHERE p2s.site_id = 1
LIMIT 0, 7
SELECT count(*) FROM (
SELECT manufacturer.manufacturer_id FROM manufacturer
LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id)
WHERE p2s.site_id = :site_id
) as count
4
price asc
7
1
tags
1
1
en
1
en
1
1
USD
SELECT count(*) FROM (
SELECT manufacturer.manufacturer_id FROM manufacturer
LEFT JOIN manufacturer_to_site p2s ON (manufacturer.manufacturer_id = p2s.manufacturer_id)
WHERE p2s.site_id = 1
) as count
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
taxonomy_item
categories
100
1
1
68
1
en
1
en
1
USD
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
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
taxonomy_item
categories
100
1
1
68
1
en
1
en
1
USD
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
SELECT pd.*,product.*, product.product_id as array_key
,(SELECT JSON_ARRAYAGG( JSON_OBJECT('id', pi.product_image_id, 'image', pi.image) )
FROM product_image as pi WHERE pi.product_id = product.product_id GROUP BY pi.product_id) as images
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
)
INNER JOIN product_to_taxonomy_item pt ON (product.product_id = pt.product_id AND pt.taxonomy_item_id IN (:taxonomy_item_id))
WHERE 1 = 1
AND p2s.site_id = :site_id
AND product.type = :type
AND product.status = :status
AND pt.taxonomy_item_id = :taxonomy_item_id
ORDER BY product.product_id DESC
LIMIT :start, :limit
6
68
medium
1
autocomplete
1
1
product
1
1
en
1
en
1
USD
SELECT pd.*,product.*, product.product_id as array_key
,(SELECT JSON_ARRAYAGG( JSON_OBJECT('id', pi.product_image_id, 'image', pi.image) )
FROM product_image as pi WHERE pi.product_id = product.product_id GROUP BY pi.product_id) as images
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
)
INNER JOIN product_to_taxonomy_item pt ON (product.product_id = pt.product_id AND pt.taxonomy_item_id IN (68))
WHERE 1 = 1
AND p2s.site_id = 1
AND product.type = 'product'
AND product.status = 1
AND pt.taxonomy_item_id = 68
ORDER BY product.product_id DESC
LIMIT 0, 6
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
)
INNER JOIN product_to_taxonomy_item pt ON (product.product_id = pt.product_id AND pt.taxonomy_item_id IN (:taxonomy_item_id))
WHERE 1 = 1
AND p2s.site_id = :site_id
AND product.type = :type
AND product.status = :status
AND pt.taxonomy_item_id = :taxonomy_item_id
) as count
6
68
medium
1
autocomplete
1
1
product
1
1
en
1
en
1
USD
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
)
INNER JOIN product_to_taxonomy_item pt ON (product.product_id = pt.product_id AND pt.taxonomy_item_id IN (68))
WHERE 1 = 1
AND p2s.site_id = 1
AND product.type = 'product'
AND product.status = 1
AND pt.taxonomy_item_id = 68
) as count
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
main-menu
10000
1
1
1
en
1
en
1
USD
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
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
12
7
13
14
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 = 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
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
12
7
13
14
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 = 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
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
main-footer
10000
1
1
1
en
1
en
1
USD
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
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
7
8
9
12
11
14
15
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 = 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
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
7
8
9
12
11
14
15
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 = 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
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
categories
1000
product
1
1
price asc
1
en
1
en
1
USD
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 = 'product'
ORDER BY categories.parent_id, categories.sort_order, categories.taxonomy_item_id
LIMIT 0, 1000
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
categories
1000
product
1
1
price asc
1
en
1
en
1
USD
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 = 'product'
) as count
SELECT * FROM vendor
LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id)
WHERE p2s.site_id = :site_id
LIMIT :start, :limit
4
price asc
7
1
tags
1
1
en
1
en
1
1
USD
SELECT * FROM vendor
LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id)
WHERE p2s.site_id = 1
LIMIT 0, 7
SELECT count(*) FROM (
SELECT vendor.vendor_id FROM vendor
LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id)
WHERE p2s.site_id = :site_id
) as count
4
price asc
7
1
tags
1
1
en
1
en
1
1
USD
SELECT count(*) FROM (
SELECT vendor.vendor_id FROM vendor
LEFT JOIN vendor_to_site p2s ON (vendor.vendor_id = p2s.vendor_id)
WHERE p2s.site_id = 1
) as count
