Category 2

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) WHERE 1 = 1 AND slug = :slug AND language_id = :language_id AND t.post_type = :post_type LIMIT 1
1. site_id
  1
2. user_id
3. user_group_id
  1
4. site
  1. title
    admin
  2. description
    1. title
      Vvveb
    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
  3. address
    West 21st Street Brooklyn NY
  4. admin-email
    admin@vvveb.com
  5. contact-email
    admin@vvveb.com
  6. logo
    /media/logo.png
  7. logo-sticky
    /media/logo.png
  8. logo-dark
    /media/logo-white.png
  9. logo-dark-sticky
    /media/logo-white.png
  10. favicon
    /media/favicon.ico
  11. webbanner
    /media/biglogo.png
  12. post_xlarge_width
    1200
  13. post_xlarge_height
    675
  14. post_large_width
    800
  15. post_large_height
    450
  16. post_medium_width
    400
  17. post_medium_height
    225
  18. post_thumb_width
    150
  19. post_thumb_height
    84
  20. product_xlarge_width
    1200
  21. product_xlarge_height
    1536
  22. product_large_width
    800
  23. product_large_height
    1021
  24. product_medium_width
    400
  25. product_medium_height
    510
  26. product_thumb_width
    150
  27. product_thumb_height
    190
  28. date_format
    F j, Y
  29. time_format
    g:i A
  30. country_id
    223
  31. region_id
    3655
  32. language_id
    1
  33. currency_id
    1
  34. language
    en_US
  35. currency
    USD
  36. invoice_format
    I-{year2}-{month}-{order_id}-{user_id}-{customer_order_id}
  37. order_id_format
    {rand-str-12}-{year2}
  38. length_type_id
    1
  39. weight_type_id
    1
  40. order_status_id
    1
  41. image_format
    webp
  42. favicon-src
    favicon.ico
  43. logo-src
    logo.png
  44. logo-sticky-src
    logo.png
  45. logo-dark-src
    logo-white.png
  46. logo-dark-sticky-src
    logo-white.png
  47. webbanner-src
    biglogo.png
  48. weight_type
    kg
  49. length_type
    cm
  50. url
    maziyarid.com
5. user
6. admin
7. current_year
  2025
8. language
  fa_IR
9. locale
  fa-ir
10. language_id
  1
11. rtl
12. default_language
  fa_IR
13. default_locale
  fa-ir
14. default_language_id
  1
15. currency
  USD
16. currency_id
  1
17. slug
  category-2
18. post_type
  product
19. 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) WHERE 1 = 1 AND slug = 'category-2' AND language_id = 1 AND t.post_type = 'product' LIMIT 1

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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. count
  4
10. order
  price asc
11. limit
  7
12. page
  1
13. type
  tags
14. parents_only
15. parents_children_only
16. parents_without_children
17. sql
  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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. count
  4
10. order
  price asc
11. limit
  7
12. page
  1
13. type
  tags
14. parents_only
15. parents_children_only
16. parents_without_children
17. sql
  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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. limit
  100
10. type
  taxonomy_item
11. subtype
  categories
12. taxonomy_item_id
  63
13. 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

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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. limit
  100
10. type
  taxonomy_item
11. subtype
  categories
12. taxonomy_item_id
  63
13. 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

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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. limit
  1000
10. order
  price asc
11. type
  categories
12. post_type
  product
13. parents_only
14. parents_children_only
15. parents_without_children
16. 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 = '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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. limit
  1000
10. order
  price asc
11. type
  categories
12. post_type
  product
13. parents_only
14. parents_children_only
15. parents_without_children
16. 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 = '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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. count
  4
10. order
  price asc
11. limit
  7
12. page
  1
13. type
  tags
14. parents_only
15. parents_children_only
16. parents_without_children
17. sql
  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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. count
  4
10. order
  price asc
11. limit
  7
12. page
  1
13. type
  tags
14. parents_only
15. parents_children_only
16. parents_without_children
17. sql
  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

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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. limit
  6
10. status
  1
11. source
  autocomplete
12. type
  product
13. taxonomy_item_id
  1. 63
14. product_image
  1
15. product_id
16. search_boolean
  1
17. image_size
  medium
18. sql
  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 (63)) WHERE 1 = 1 AND p2s.site_id = 1 AND product.type = 'product' AND product.status = 1 AND pt.taxonomy_item_id = 63 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
1. start
2. site_id
  1
3. user_group_id
  1
4. language_id
  1
5. language
  en_US
6. default_language
  fa_IR
7. default_language_id
  1
8. currency_id
  1
9. limit
  6
10. status
  1
11. source
  autocomplete
12. type
  product
13. taxonomy_item_id
  1. 63
14. product_image
  1
15. product_id
16. search_boolean
  1
17. image_size
  medium
18. sql
  SELECT count(*) FROM ( SELECT product.product_id FROM product LEFT JOIN product_to_site p2s ON (product.product_id = p2s.product_id) LEFT JOIN product_content pd ON ( product.product_id = pd.product_id AND pd.language_id = 1 ) INNER JOIN product_to_taxonomy_item pt ON (product.product_id = pt.product_id AND pt.taxonomy_item_id IN (63)) WHERE 1 = 1 AND p2s.site_id = 1 AND product.type = 'product' AND product.status = 1 AND pt.taxonomy_item_id = 63 ) as count

دسته بندی ها

برندها

فروشندگان

category 2

Features

دسته بندی ها

برندها

فروشندگان

category 2