Twoje konto Jakies bajery

(jestem spiacy)

229.00z
49.39z
HomeSzopRoyal Canin Breed Boxer JuniorZapytanie - Royal Canin Breed Boxer Junior

Powróć do produktu









Informacje o wydajności

Application afterLoad: 0.001 seconds, 0.30 MB
Application afterInitialise: 0.026 seconds, 1.39 MB
Application afterRoute: 0.058 seconds, 2.01 MB
Application afterDispatch: 0.089 seconds, 2.99 MB
Application afterRender: 0,328 seconds, 3,91 MB

Zużycie pamięci

4138912

Zapytań do bazy danych: 277

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'r145fg33mae4982tqrd9gq1rv6'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1555991132' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'r145fg33mae4982tqrd9gq1rv6'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'r145fg33mae4982tqrd9gq1rv6','1555992332','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  9. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 84)
      ORDER BY menuid DESC
      LIMIT 0, 1
  10. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  11. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  12. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  13. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  14. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  15. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  16. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  17. SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=18
      AND `product_publish`='Y'
  18. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  19. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 84 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  20. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE product_parent_id=''
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      ORDER BY product_name DESC
  21. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='SZE0002'
  22. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=11
  23. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='11'
  24. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=11
  25. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='11'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  26. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=11
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='11'
  29. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  30. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=11
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  31. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=11
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=11
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=11
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='11'
  35. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='SZE0001'
  36. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=10
  37. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='10'
  38. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=10
  39. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='10'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  40. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=10
  41. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  42. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='10'
  43. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=10
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  44. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=10
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  45. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=10
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=10
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  47. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='10'
  48. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='SPODNIE Bojwki 5.11 W38/L34 (czarne)'
  49. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=35
  50. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='35'
  51. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=35
  52. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='35'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  53. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=35
  54. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  55. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='35'
  56. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=35
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  57. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=35
  58. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='35'
  59. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=35
  60. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=35
  61. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='SPODNIE Bojwki 5.11 W34/L36 (czarne)'
  62. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=34
  63. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='34'
  64. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=34
  65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='34'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  66. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=34
  67. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  68. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='34'
  69. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=34
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  70. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=34
  71. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='34'
  72. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=34
  73. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=34
  74. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='SPODNIE Bojwki 5.11 W30/L34 (czarne)'
  75. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=33
  76. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='33'
  77. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=33
  78. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='33'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  79. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=33
  80. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  81. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='33'
  82. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=33
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  83. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=33
  84. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='33'
  85. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=33
  86. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=33
  87. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='SPODNIE Bojwki 5.11 W28/L32 (czarne)'
  88. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=32
  89. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='32'
  90. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=32
  91. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='32'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=32
  93. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  94. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='32'
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=32
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=32
  97. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='32'
  98. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=32
  99. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=32
  100. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBYT29'
  101. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=21
  102. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='21'
  103. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=21
  104. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='21'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  105. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=21
  106. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  107. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='21'
  108. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  109. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  110. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  111. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  112. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='21'
  113. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBYT28'
  114. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=20
  115. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='20'
  116. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=20
  117. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='20'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=20
  119. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  120. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='20'
  121. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  122. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  123. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  124. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  125. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='20'
  126. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBP30'
  127. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=23
  128. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='23'
  129. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
  130. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  131. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  132. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  133. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='23'
  134. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  135. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  136. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  137. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  138. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='23'
  139. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBJ28'
  140. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=22
  141. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='22'
  142. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=22
  143. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='22'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  144. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  145. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  146. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='22'
  147. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  148. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  149. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  150. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  151. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='22'
  152. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBGS24'
  153. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=24
  154. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='24'
  155. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=24
  156. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='24'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  157. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=24
  158. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  159. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='24'
  160. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  161. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  162. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=24
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='24'
  165. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBB30'
  166. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=18
  167. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='18'
  168. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=18
  169. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='18'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  170. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=18
  171. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  172. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='18'
  173. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  174. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  175. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  176. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=18
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  177. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='18'
  178. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBB26'
  179. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=19
  180. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='19'
  181. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=19
  182. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='19'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=19
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='19'
  186. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=19
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  187. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=19
  188. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='19'
  189. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=19
  190. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0001'
  191. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=4
  192. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='4'
  193. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=4
  194. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='4'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  195. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=4
  196. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  197. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='4'
  198. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  199. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  200. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  201. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=4
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  202. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='4'
  203. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0004'
  204. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=7
  205. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='7'
  206. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=7
  207. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='7'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  208. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=7
  209. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  210. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='7'
  211. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  212. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  213. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  214. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=7
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  215. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='7'
  216. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='OBR0001'
  217. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=12
  218. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='12'
  219. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=12
  220. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='12'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  221. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=12
  222. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='12'
  224. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=12
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  225. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=12
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  226. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=12
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  227. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=12
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  228. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='12'
  229. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='OBR0004'
  230. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=15
  231. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='15'
  232. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15
  233. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=15
  235. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  236. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15'
  237. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  238. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  239. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  240. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  241. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15'
  242. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0006'
  243. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=8
  244. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='8'
  245. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=8
  246. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='8'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  247. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=8
  248. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  249. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='8'
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=8
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='8'
  255. SELECT *
      FROM jos_swmenufree_config
      WHERE id = 1
  256. SELECT jos_menu.*
                                   
      FROM jos_menu
                   
      WHERE jos_menu.menutype = 'sklep'
      AND published = '1'
                   
      ORDER BY parent, ordering
  257. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  258. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  259. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  260. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY RAND()
      LIMIT 0, 2
  261. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='RCBB26'
  262. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=19
  263. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=19
  264. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='19'
  265. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0002'
  266. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=5
  267. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='5'
  268. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=5
  269. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='5'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  270. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=5
  271. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1555992332' OR start_date=0)
      AND (end_date>='1555976160' OR end_date=0)
      AND product_discount_id=discount_id
  272. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='5'
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=5
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=5
  275. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='5'
  276. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=5
  277. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=5

Zapytań w trybie zgodności: 4

  1. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  3. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  4. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

Wczytane pliki języka

Untranslated Strings Diagnostic

Brak

Untranslated Strings Designer

Brak