487 Queries Logged

1. SELECT `data`
  FROM `zjfyl_session`
  WHERE `session_id` = 'c320114215f2e9f195adfe42ae747d70'
2. DELETE
  FROM `zjfyl_session`
  WHERE `time` < '1561593437'
3. SELECT `session_id`
  FROM `zjfyl_session`
  WHERE `session_id` = 'c320114215f2e9f195adfe42ae747d70'
  LIMIT 0, 1
4. INSERT INTO `zjfyl_session` (`session_id`, `client_id`, `time`)
  VALUES ('c320114215f2e9f195adfe42ae747d70', 0, '1561594337')
5. SELECT b.id
  FROM zjfyl_usergroups AS a
  LEFT JOIN zjfyl_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `zjfyl_viewlevels`
7. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM zjfyl_menu AS m
  LEFT JOIN zjfyl_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
8. SHOW TABLES LIKE "zjfyl_virtuemart_configs"
9. SELECT `config`
  FROM `zjfyl_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
10. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `zjfyl_virtuemart_permgroups`
  ORDER BY `group_level`
11. SELECT *
  FROM `zjfyl_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language = "en-GB" )
12. SELECT `virtuemart_category_id`
  FROM `zjfyl_virtuemart_categories_en_gb`
  WHERE `slug` LIKE 'orderDesc'
13. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
14. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "18"
  ORDER BY `ordering`
15. SELECT `category_child_id`
  FROM `zjfyl_virtuemart_category_categories`
  WHERE `category_parent_id` = 18
16. SELECT count(zjfyl_virtuemart_products.virtuemart_product_id) AS total
  FROM `zjfyl_virtuemart_products`, `zjfyl_virtuemart_product_categories`
  WHERE `zjfyl_virtuemart_products`.`virtuemart_vendor_id` = "1"
  AND `zjfyl_virtuemart_product_categories`.`virtuemart_category_id` = 18
  AND `zjfyl_virtuemart_products`.`virtuemart_product_id` = `zjfyl_virtuemart_product_categories`.`virtuemart_product_id`
  AND `zjfyl_virtuemart_products`.`published` = "1"
17. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
18. SELECT *
  FROM `zjfyl_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
19. SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
  FROM `zjfyl_virtuemart_products_en_gb` as l JOIN `zjfyl_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_categories_en_gb` as c
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
  LEFT JOIN `zjfyl_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `zjfyl_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `zjfyl_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `zjfyl_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND `pc`.`virtuemart_category_id` = 18
  AND `pc`.`virtuemart_category_id` > 0
  AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
  group by p.`virtuemart_product_id`
  ORDER BY `p`.virtuemart_product_id DESC
  LIMIT 0, 48
20. SELECT FOUND_ROWS()
21. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7077"
22. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7077"
  ORDER BY `ordering`
23. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7077"
24. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7077"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
25. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
26. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7077
27. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7077
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
28. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7077"
  and `virtuemart_category_id`= "18"
29. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
30. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
  FROM `zjfyl_virtuemart_vendors` AS v
  LEFT JOIN `zjfyl_virtuemart_currencies` AS c
  ON virtuemart_currency_id = vendor_currency
  WHERE v.`virtuemart_vendor_id`="1"
31. SELECT *
  FROM `zjfyl_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="47"
32. SELECT `price_display`,`custom_price_display`
  FROM `zjfyl_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
33. SELECT *
  FROM `zjfyl_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
34. SELECT *
  FROM zjfyl_virtuemart_calcs
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-06-27 00:12:17" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-06-27 00:12:17" ) OR `for_override` = "1" )
35. SELECT `virtuemart_category_id`
  FROM zjfyl_virtuemart_calc_categories
  WHERE `virtuemart_calc_id`="3"
36. SELECT `virtuemart_shoppergroup_id`
  FROM zjfyl_virtuemart_calc_shoppergroups
  WHERE `virtuemart_calc_id`="3"
37. SELECT `virtuemart_country_id`
  FROM zjfyl_virtuemart_calc_countries
  WHERE `virtuemart_calc_id`="3"
38. SELECT `virtuemart_state_id`
  FROM zjfyl_virtuemart_calc_states
  WHERE `virtuemart_calc_id`="3"
39. SELECT `virtuemart_manufacturer_id`
  FROM zjfyl_virtuemart_calc_manufacturers
  WHERE `virtuemart_calc_id`="3"
40. SELECT `virtuemart_category_id`
  FROM zjfyl_virtuemart_calc_categories
  WHERE `virtuemart_calc_id`="1"
41. SELECT `virtuemart_shoppergroup_id`
  FROM zjfyl_virtuemart_calc_shoppergroups
  WHERE `virtuemart_calc_id`="1"
42. SELECT `virtuemart_country_id`
  FROM zjfyl_virtuemart_calc_countries
  WHERE `virtuemart_calc_id`="1"
43. SELECT `virtuemart_state_id`
  FROM zjfyl_virtuemart_calc_states
  WHERE `virtuemart_calc_id`="1"
44. SELECT `virtuemart_manufacturer_id`
  FROM zjfyl_virtuemart_calc_manufacturers
  WHERE `virtuemart_calc_id`="1"
45. SELECT `virtuemart_category_id`
  FROM zjfyl_virtuemart_calc_categories
  WHERE `virtuemart_calc_id`="2"
46. SELECT `virtuemart_shoppergroup_id`
  FROM zjfyl_virtuemart_calc_shoppergroups
  WHERE `virtuemart_calc_id`="2"
47. SELECT `virtuemart_country_id`
  FROM zjfyl_virtuemart_calc_countries
  WHERE `virtuemart_calc_id`="2"
48. SELECT `virtuemart_state_id`
  FROM zjfyl_virtuemart_calc_states
  WHERE `virtuemart_calc_id`="2"
49. SELECT `virtuemart_manufacturer_id`
  FROM zjfyl_virtuemart_calc_manufacturers
  WHERE `virtuemart_calc_id`="2"
50. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7077
51. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7076"
52. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7076"
  ORDER BY `ordering`
53. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7076"
54. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7076"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
55. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
56. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7076
57. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7076
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
58. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7076"
  and `virtuemart_category_id`= "18"
59. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
60. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7076
61. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7075"
62. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7075"
  ORDER BY `ordering`
63. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7075"
64. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7075"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
65. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
66. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7075
67. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7075
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
68. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7075"
  and `virtuemart_category_id`= "18"
69. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
70. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7075
71. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7074"
72. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7074"
  ORDER BY `ordering`
73. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7074"
74. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7074"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
75. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
76. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7074
77. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7074
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
78. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7074"
  and `virtuemart_category_id`= "18"
79. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
80. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7074
81. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7073"
82. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7073"
  ORDER BY `ordering`
83. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7073"
84. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7073"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
85. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
86. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7073
87. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7073
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
88. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7073"
  and `virtuemart_category_id`= "18"
89. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
90. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7073
91. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7072"
92. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7072"
  ORDER BY `ordering`
93. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7072"
94. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7072"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
95. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
96. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7072
97. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7072
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
98. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7072"
  and `virtuemart_category_id`= "18"
99. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
100. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7072
101. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7071"
102. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7071"
  ORDER BY `ordering`
103. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7071"
104. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7071"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
105. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
106. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7071
107. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7071
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
108. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7071"
  and `virtuemart_category_id`= "18"
109. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
110. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7071
111. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7070"
112. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7070"
  ORDER BY `ordering`
113. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7070"
114. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7070"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
115. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
116. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7070
117. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7070
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
118. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7070"
  and `virtuemart_category_id`= "18"
119. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
120. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7070
121. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7069"
122. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7069"
  ORDER BY `ordering`
123. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7069"
124. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7069"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
125. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
126. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7069
127. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7069
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
128. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7069"
  and `virtuemart_category_id`= "18"
129. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
130. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7069
131. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7068"
132. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7068"
  ORDER BY `ordering`
133. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7068"
134. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7068"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
135. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
136. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7068
137. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7068
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
138. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7068"
  and `virtuemart_category_id`= "18"
139. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
140. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7068
141. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7067"
142. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7067"
  ORDER BY `ordering`
143. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7067"
144. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7067"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
145. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
146. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7067
147. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7067
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
148. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7067"
  and `virtuemart_category_id`= "18"
149. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
150. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7067
151. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7066"
152. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7066"
  ORDER BY `ordering`
153. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7066"
154. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7066"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
155. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
156. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7066
157. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7066
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
158. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7066"
  and `virtuemart_category_id`= "18"
159. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
160. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7066
161. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7065"
162. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7065"
  ORDER BY `ordering`
163. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7065"
164. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7065"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
165. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
166. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7065
167. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7065
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
168. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7065"
  and `virtuemart_category_id`= "18"
169. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
170. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7065
171. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7064"
172. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7064"
  ORDER BY `ordering`
173. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7064"
174. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7064"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
175. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
176. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7064
177. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7064
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
178. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7064"
  and `virtuemart_category_id`= "18"
179. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
180. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7064
181. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7063"
182. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7063"
  ORDER BY `ordering`
183. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7063"
184. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7063"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
185. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
186. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7063
187. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7063
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
188. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7063"
  and `virtuemart_category_id`= "18"
189. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
190. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7063
191. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7062"
192. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7062"
  ORDER BY `ordering`
193. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7062"
194. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7062"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
195. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
196. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7062
197. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7062
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
198. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7062"
  and `virtuemart_category_id`= "18"
199. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
200. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7062
201. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7061"
202. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7061"
  ORDER BY `ordering`
203. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7061"
204. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7061"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
205. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
206. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7061
207. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7061
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
208. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7061"
  and `virtuemart_category_id`= "18"
209. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
210. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7061
211. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7060"
212. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7060"
  ORDER BY `ordering`
213. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7060"
214. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7060"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
215. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
216. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7060
217. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7060
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
218. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7060"
  and `virtuemart_category_id`= "18"
219. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
220. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7060
221. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7059"
222. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7059"
  ORDER BY `ordering`
223. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7059"
224. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7059"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
225. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
226. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7059
227. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7059
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
228. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7059"
  and `virtuemart_category_id`= "18"
229. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
230. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7059
231. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7058"
232. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7058"
  ORDER BY `ordering`
233. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7058"
234. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7058"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
235. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
236. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7058
237. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7058
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
238. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7058"
  and `virtuemart_category_id`= "18"
239. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
240. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7058
241. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7057"
242. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7057"
  ORDER BY `ordering`
243. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7057"
244. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7057"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
245. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
246. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7057
247. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7057
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
248. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7057"
  and `virtuemart_category_id`= "18"
249. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
250. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7057
251. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7056"
252. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7056"
  ORDER BY `ordering`
253. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7056"
254. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7056"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
255. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
256. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7056
257. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7056
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
258. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7056"
  and `virtuemart_category_id`= "18"
259. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
260. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7056
261. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7055"
262. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7055"
  ORDER BY `ordering`
263. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7055"
264. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7055"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
265. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
266. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7055
267. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7055
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
268. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7055"
  and `virtuemart_category_id`= "18"
269. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
270. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7055
271. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7054"
272. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7054"
  ORDER BY `ordering`
273. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7054"
274. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7054"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
275. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
276. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7054
277. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7054
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
278. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7054"
  and `virtuemart_category_id`= "18"
279. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
280. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7054
281. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7053"
282. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7053"
  ORDER BY `ordering`
283. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7053"
284. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7053"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
285. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
286. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7053
287. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7053
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
288. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7053"
  and `virtuemart_category_id`= "18"
289. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
290. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7053
291. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7052"
292. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7052"
  ORDER BY `ordering`
293. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7052"
294. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7052"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
295. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
296. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7052
297. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7052
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
298. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7052"
  and `virtuemart_category_id`= "18"
299. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
300. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7052
301. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7051"
302. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7051"
  ORDER BY `ordering`
303. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7051"
304. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7051"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
305. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
306. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7051
307. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7051
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
308. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7051"
  and `virtuemart_category_id`= "18"
309. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
310. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7051
311. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7050"
312. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7050"
  ORDER BY `ordering`
313. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7050"
314. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7050"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
315. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
316. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7050
317. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7050
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
318. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7050"
  and `virtuemart_category_id`= "18"
319. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
320. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7050
321. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7049"
322. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7049"
  ORDER BY `ordering`
323. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7049"
324. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7049"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
325. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
326. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7049
327. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7049
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
328. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7049"
  and `virtuemart_category_id`= "18"
329. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
330. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7049
331. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7048"
332. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7048"
  ORDER BY `ordering`
333. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7048"
334. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7048"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
335. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
336. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7048
337. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7048
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
338. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7048"
  and `virtuemart_category_id`= "18"
339. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
340. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7048
341. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7047"
342. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7047"
  ORDER BY `ordering`
343. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7047"
344. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7047"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
345. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
346. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7047
347. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7047
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
348. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7047"
  and `virtuemart_category_id`= "18"
349. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
350. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7047
351. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7046"
352. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7046"
  ORDER BY `ordering`
353. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7046"
354. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7046"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
355. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
356. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7046
357. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7046
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
358. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7046"
  and `virtuemart_category_id`= "18"
359. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
360. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7046
361. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7045"
362. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7045"
  ORDER BY `ordering`
363. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7045"
364. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7045"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
365. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
366. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7045
367. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7045
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
368. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7045"
  and `virtuemart_category_id`= "18"
369. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
370. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7045
371. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7044"
372. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7044"
  ORDER BY `ordering`
373. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7044"
374. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7044"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
375. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
376. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7044
377. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7044
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
378. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7044"
  and `virtuemart_category_id`= "18"
379. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
380. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7044
381. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7043"
382. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7043"
  ORDER BY `ordering`
383. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7043"
384. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7043"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
385. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
386. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7043
387. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7043
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
388. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7043"
  and `virtuemart_category_id`= "18"
389. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
390. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7043
391. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7042"
392. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7042"
  ORDER BY `ordering`
393. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7042"
394. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7042"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
395. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
396. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7042
397. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7042
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
398. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7042"
  and `virtuemart_category_id`= "18"
399. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
400. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7042
401. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7041"
402. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7041"
  ORDER BY `ordering`
403. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7041"
404. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7041"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
405. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
406. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7041
407. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7041
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
408. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7041"
  and `virtuemart_category_id`= "18"
409. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
410. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7041
411. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7040"
412. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7040"
  ORDER BY `ordering`
413. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7040"
414. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7040"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
415. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
416. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7040
417. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7040
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
418. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7040"
  and `virtuemart_category_id`= "18"
419. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
420. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7040
421. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7039"
422. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7039"
  ORDER BY `ordering`
423. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7039"
424. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7039"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
425. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
426. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7039
427. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7039
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
428. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7039"
  and `virtuemart_category_id`= "18"
429. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
430. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7039
431. SELECT `zjfyl_virtuemart_products_en_gb`.* ,`zjfyl_virtuemart_products`.* ,`zjfyl_virtuemart_ratings`.`rating` ,`zjfyl_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`zjfyl_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `zjfyl_virtuemart_products_en_gb` JOIN zjfyl_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `zjfyl_virtuemart_ratings`
  on `zjfyl_virtuemart_ratings`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_manufacturers`
  on `zjfyl_virtuemart_product_manufacturers`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `zjfyl_virtuemart_product_customfields`
  on `zjfyl_virtuemart_product_customfields`.`virtuemart_product_id`=`zjfyl_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE zjfyl_virtuemart_products_en_gb.`virtuemart_product_id` = "7038"
432. SELECT `virtuemart_media_id`
  FROM `zjfyl_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "7038"
  ORDER BY `ordering`
433. SELECT `virtuemart_shoppergroup_id`
  FROM `zjfyl_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "7038"
434. SELECT *
  FROM `zjfyl_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "7038"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-06-27 00:12:17" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-27 00:12:17" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
435. SELECT `zjfyl_virtuemart_manufacturers_en_gb`.* ,`zjfyl_virtuemart_manufacturers`.*
  FROM `zjfyl_virtuemart_manufacturers_en_gb` JOIN zjfyl_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE zjfyl_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
436. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 7038
437. SELECT pc.`virtuemart_category_id`
  FROM `zjfyl_virtuemart_product_categories` as pc
  LEFT JOIN `zjfyl_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 7038
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
438. SELECT `ordering`,`id`
  FROM `zjfyl_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "7038"
  and `virtuemart_category_id`= "18"
439. SELECT `zjfyl_virtuemart_categories_en_gb`.* ,`zjfyl_virtuemart_categories`.*
  FROM `zjfyl_virtuemart_categories_en_gb` JOIN zjfyl_virtuemart_categories using (`virtuemart_category_id`)
  WHERE zjfyl_virtuemart_categories_en_gb.`virtuemart_category_id` = "18"
440. SELECT `slug`
  FROM `zjfyl_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 7038
441. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11037"
442. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11035"
443. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11033"
444. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11031"
445. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11029"
446. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11027"
447. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11025"
448. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11023"
449. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11021"
450. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11019"
451. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11017"
452. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11015"
453. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11013"
454. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11011"
455. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11009"
456. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11007"
457. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11005"
458. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11003"
459. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10999"
460. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "11001"
461. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10996"
462. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10994"
463. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10992"
464. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10991"
465. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10990"
466. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10989"
467. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10988"
468. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10987"
469. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10986"
470. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10985"
471. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10984"
472. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10983"
473. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10982"
474. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10981"
475. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10980"
476. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10979"
477. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10978"
478. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10977"
479. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10976"
480. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10975"
481. SELECT `zjfyl_virtuemart_medias`.*
  FROM `zjfyl_virtuemart_medias`
  WHERE zjfyl_virtuemart_medias.`virtuemart_media_id` = "10352"
482. SELECT L.*
  FROM `zjfyl_virtuemart_categories_en_gb` as L JOIN `zjfyl_virtuemart_categories` as c using (`virtuemart_category_id`)
  LEFT JOIN `zjfyl_virtuemart_category_categories` as cx
  on c.`virtuemart_category_id` = cx.`category_child_id`
  WHERE cx.`category_parent_id` = 18
  AND c.`virtuemart_vendor_id` = 1
  AND c.`published` = 1
  ORDER BY c.ordering DESC
483. SELECT `template`,`params`
  FROM `zjfyl_template_styles`
  WHERE `id`="9"
484. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM zjfyl_modules AS m
  LEFT JOIN zjfyl_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN zjfyl_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-06-27 00:12:17')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-06-27 00:12:17')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 779 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
485. SELECT `virtuemart_category_id`
  FROM `zjfyl_virtuemart_categories_en_gb`
  WHERE `slug` LIKE 'orderDesc'
486. SELECT extension_id AS id, element AS "option", params, enabled
  FROM zjfyl_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
487. UPDATE `zjfyl_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1561594337;s:18:\"session.timer.last\";i:1561594337;s:17:\"session.timer.now\";i:1561594337;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":3:{s:8:\"category\";O:8:\"stdClass\":1:{s:12:\"filter_order\";s:25:\"`p`.virtuemart_product_id\";}s:11:\"categoryc18\";O:8:\"stdClass\":1:{s:5:\"
  limit\";s:3:\"int\";}s:13:\"categoryc18m0\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"c6d8de90843ec7117abcd1ccb5994c9a\";}__vm|a:3:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";s:23:\"vmlastvisitedcategoryid\";i:18;s:19:\"vmlastvisitedmanuid\";i:-1;}' , `time` = '1561594338'
  WHERE `session_id` = 'c320114215f2e9f195adfe42ae747d70'