Desert Brainstorm 3 Volúmenes

Perfíl de la información

Memoria usada

328 queries identificadas

1. SELECT *
     FROM jos_session
     WHERE session_id = 'ssbnrkoajdau9vumjn2m9lpdi3'
2. DELETE
     FROM jos_session
     WHERE ( TIME < '1717242877' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'ssbnrkoajdau9vumjn2m9lpdi3'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'ssbnrkoajdau9vumjn2m9lpdi3','1717246477','','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 MAX(TIME)  
     FROM jos_vvcounter_logs
8. SELECT *
     FROM jos_xijc_config
     WHERE name = 'config'
9. 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
10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 32)
      ORDER BY menuid DESC
      LIMIT 0, 1
11. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
12. 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'
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`=2989
      AND `product_publish`='Y'
18. SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='2989'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
19. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='nashsets'
20. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=2980
21. 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`='2980'
22. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
23. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2980
24. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2980'
      AND (start_date<='1717246478' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
25. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2980'
26. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
27. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2980
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
28. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2980'
29. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2980
30. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2980
31. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='DVDCUTTINGEDGE'
32. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=15693
33. 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`='15693'
34. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15693
35. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15693'
      AND (start_date<='1717246478' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
36. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15693'
37. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15693
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
38. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15693'
39. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15693
40. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15693
41. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUSPALOMASPAK'
42. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=15840
43. 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`='15840'
44. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=15840
45. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='15840'
      AND (start_date<='1717246478' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
46. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='15840'
47. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=15840
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
48. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='15840'
49. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=15840
50. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=15840
51. SELECT CONCAT( 'search=', `search`, '
    replace=', `replace`, '
    area=', `area`, '
    ', `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'articles' OR params LIKE '%use_xml=1%'
      ORDER BY ordering, id
52. SELECT cx.category_id, category_flypage
      FROM jos_vm_category c, jos_vm_product_category_xref cx
      WHERE product_id = '2989'
      AND c.category_id=cx.category_id
      LIMIT 0,1
53. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='39'
      AND jos_vm_category.category_id='39'
54. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
55. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 2000
56. 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`='14066'
57. 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`='2867'
58. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='39'
59. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='2989'
60. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='2989'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
61. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2989
62. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2989'
      AND (start_date<='1717246478' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
63. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2989'
64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2989
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
65. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2989'
66. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2989
      AND `file_is_image`=1
      AND `file_published`=1
67. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2989
68. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
69. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2989
      AND `file_is_image`=0
      AND `file_published`=1
70. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2989'
71. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
72. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
73. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
74. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2989'
75. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='2989'
76. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2989'
77. SELECT COUNT(*) AS num_rows
      FROM jos_vm_product_reviews
                                                   
      WHERE product_id='2989'
      AND published='Y'
78. SELECT comment, TIME, userid, user_rating
      FROM jos_vm_product_reviews
                                           
      WHERE product_id='2989'
      AND published='Y'
      ORDER BY `time` DESC  
      LIMIT 0, 5
79. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='2989'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
80. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='2989'
81. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2989
82. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='2989'
83. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='2989'
84. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='2989'
85. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='2989'
86. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='2989'
      AND product_publish='Y'
87. SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
88. 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 = 32 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
89. SELECT p.product_sku
      FROM jos_vm_product AS p
    JOIN jos_vm_product_category_xref AS pc
      ON p.product_id=pc.product_id
    JOIN jos_vm_category AS c
      ON pc.category_id=c.category_id
     
      WHERE p.product_publish = 'Y'
      AND c.category_publish = 'Y'
      AND product_parent_id=0
     
      ORDER BY RAND()
      LIMIT 5
90. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='dvsrv'
91. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=17229
92. 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`='17229'
93. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=17229
94. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='17229'
      AND (start_date<='1717246478' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
95. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=17229
96. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1717246478' OR start_date=0)
      AND (end_date>='1717198560' OR end_date=0)
      AND product_discount_id=discount_id
97. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='17229'
98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=17229
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
99. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='17229'
100. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=17229
101. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=17229
102. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='20818'
103. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=539
104. 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`='539'
105. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=539
106. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='539'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
107. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=539
108. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
109. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='539'
110. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=539
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
111. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='539'
112. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=539
113. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=539
114. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='FEATHERDU'
115. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=4822
116. 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`='4822'
117. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=4822
118. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='4822'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
119. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=4822
120. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
121. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='4822'
122. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=4822
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
123. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='4822'
124. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=4822
125. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=4822
126. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='dvlino'
127. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=15791
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`='15791'
129. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=15791
130. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='15791'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
131. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=15791
132. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
133. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='15791'
134. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=15791
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
135. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='15791'
136. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=15791
137. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=15791
138. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='HOLLOW3DR'
139. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=17260
140. 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`='17260'
141. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=17260
142. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='17260'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
143. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=17260
144. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
145. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='17260'
146. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=17260
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
147. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='17260'
148. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=17260
149. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=17260
150. SELECT *
      
       FROM jos_banner
      
       WHERE showBanner=1
      
       AND cid IN ( 1 )
      
       AND catid = 17
      
       ORDER BY RAND()
151. SELECT DISTINCT product_sku
       FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
       WHERE product_parent_id=''
       AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
       AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
       AND jos_vm_product.product_publish='Y'
       ORDER BY jos_vm_product.product_id DESC
       LIMIT 0, 10
152. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='ZZROPE'
153. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18131
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`='18131'
155. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18131
156. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18131'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
157. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18131
158. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
159. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18131'
160. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18131
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
161. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18131'
162. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18131
163. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18131
164. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='GUILLOD'
165. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18130
166. 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`='18130'
167. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18130
168. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18130'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
169. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18130
170. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
171. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18130'
172. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18130
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
173. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18130'
174. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18130
175. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18130
176. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='MUNEVNEW2'
177. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18128
178. 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`='18128'
179. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18128
180. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18128'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
181. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18128
182. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
183. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18128'
184. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18128
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
185. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18128'
186. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18128
187. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18128
188. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='MUNEVNEW1'
189. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18127
190. 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`='18127'
191. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18127
192. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18127'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
193. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18127
194. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
195. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18127'
196. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18127
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
197. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18127'
198. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18127
199. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18127
200. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='NUEVOGUERO'
201. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18126
202. 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`='18126'
203. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18126
204. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18126'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
205. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18126
206. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
207. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18126'
208. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18126
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
209. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18126'
210. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18126
211. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18126
212. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='APPEARINGCANEMETAL_GREEN'
213. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18125
214. 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`='18125'
215. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18125
216. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18125'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
217. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18125
218. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
219. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18125'
220. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18125
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
221. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18125'
222. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18125
223. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18125
224. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='DBOMBAG'
225. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18124
226. 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`='18124'
227. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18124
228. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18124'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
229. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18124
230. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
231. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18124'
232. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18124
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
233. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18124'
234. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18124
235. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18124
236. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='MARIORENE2'
237. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18123
238. 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`='18123'
239. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18123
240. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18123'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
241. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18123
242. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
243. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18123'
244. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18123
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
245. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18123'
246. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18123
247. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18123
248. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='ARCOI3'
249. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18122
250. 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`='18122'
251. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18122
252. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18122'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
253. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18122
254. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
255. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18122'
256. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18122
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
257. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18122'
258. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18122
259. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18122
260. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='ARCOI2'
261. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18121
262. 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`='18121'
263. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=18121
264. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='18121'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
265. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=18121
266. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246478' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
267. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='18121'
268. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=18121
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
269. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18121'
270. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18121
271. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18121
272. SELECT TIME, visits, guests, members, bots  
       FROM jos_vvcounter_logs  
       WHERE '1=1'  
       AND TIME > 1717221600
273. SELECT session_id, TIME, guest, DATA  
       FROM jos_session  
       WHERE '1=1'  
       AND TIME >= 1717246360
274. SELECT TIME, visits, guests, members, bots  
       FROM jos_vvcounter_logs  
       WHERE '1=1'  
       AND TIME <= 1717221600
275. SELECT session_id, TIME, guest, DATA  
       FROM jos_session  
       WHERE TIME > 1717245582
276. 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
277. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='NUMBERGROUND'
278. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=14027
279. 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`='14027'
280. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=14027
281. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='14027'
       AND (start_date<='1717246482' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
282. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=14027
283. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246482' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
284. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='14027'
285. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=14027
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
286. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='14027'
287. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=14027
288. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=14027
289. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='dvarc'
290. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=17203
291. 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`='17203'
292. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=17203
293. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='17203'
       AND (start_date<='1717246482' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
294. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=17203
295. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246482' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
296. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='17203'
297. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=17203
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
298. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='17203'
299. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=17203
300. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=17203
301. 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
302. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='ARCOI2'
303. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=18121
304. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='18121'
305. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=18121
306. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=18121
307. SELECT product_id, product_name, product_parent_id, product_thumb_image
       FROM jos_vm_product
       WHERE product_sku='BOLSACAPA2'
308. SELECT category_id
       FROM `jos_vm_product_category_xref`
       WHERE product_id=4705
309. 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`='4705'
310. SELECT product_id, `jos_vm_product`.*
       FROM `jos_vm_product`
       WHERE `product_id`=4705
311. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='4705'
       AND (start_date<='1717246482' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
312. SELECT product_parent_id
       FROM jos_vm_product
       WHERE product_id=4705
313. SELECT amount,is_percent
       FROM jos_vm_product,jos_vm_product_discount
       WHERE product_id='0'
       AND (start_date<='1717246482' OR start_date=0)
       AND (end_date>='1717198560' OR end_date=0)
       AND product_discount_id=discount_id
314. SELECT vendor_id
       FROM jos_vm_product
       WHERE product_id='4705'
315. SELECT `product_price`, `product_price_id`, `product_currency`
       FROM `jos_vm_product_price`
       WHERE product_id=4705
       AND shopper_group_id=5  
       ORDER BY price_quantity_start
316. SELECT COUNT(product_id) AS num_rows
       FROM jos_vm_product
       WHERE product_parent_id='4705'
317. SELECT `product_id`
       FROM `jos_vm_product_attribute_sku`
       WHERE `product_id`=4705
318. SELECT `attribute`,`custom_attribute`
       FROM `jos_vm_product`
       WHERE `product_id`=4705
319. 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
320. SELECT group_id,group_name,group_level
       FROM `jos_vm_auth_group`
       ORDER BY group_level
321. SELECT published
       FROM jos_modules
       WHERE module='mod_virtuemart_cart'
322. SELECT p.product_id, p.product_sales AS sales, p.product_parent_id, p.product_name, c.category_id, c.category_flypage
       FROM jos_vm_product p, jos_vm_product_category_xref pc, jos_vm_category c
       WHERE p.product_publish='Y'
       AND pc.product_id = p.product_id
       AND pc.category_id = c.category_id
       AND p.product_sales > 0
       GROUP BY p.product_id
       ORDER BY sales DESC, p.product_name  
       LIMIT 0, 10
323. SELECT *
       FROM jos_acymailing_config
324. SELECT *
       FROM jos_acymailing_list
       WHERE TYPE = 'list'
       ORDER BY ordering ASC
325. SELECT *
       FROM `jos_acymailing_fields` AS a
       WHERE a.`published` = 1
       ORDER BY a.`ordering` ASC
326. SELECT CONCAT( 'search=', `search`, '
     replace=', `replace`, '
     area=', `area`, '
     ', `params` )
       FROM jos_rereplacer
       WHERE published = 1
       AND area = 'component' OR params LIKE '%use_xml=1%'
       ORDER BY ordering, id
327. SELECT CONCAT( 'search=', `search`, '
     replace=', `replace`, '
     area=', `area`, '
     ', `params` )
       FROM jos_rereplacer
       WHERE published = 1
       AND area = 'body' OR params LIKE '%use_xml=1%'
       ORDER BY ordering, id
328. SELECT CONCAT( 'search=', `search`, '
     replace=', `replace`, '
     area=', `area`, '
     ', `params` )
       FROM jos_rereplacer
       WHERE published = 1
       AND area = 'everywhere' OR params LIKE '%use_xml=1%'
       ORDER BY ordering, id

0 legado de las queries identificadas

Archivos de idioma cargados

• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.plg_system_vvisit_counter.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.plg_system_vvisit_counter.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.plg_system_debug.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.com_xijc.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.com_xijc.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\administrator\language\en-GB\en-GB.plg_system_rereplacer.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\administrator\language\es-ES\es-ES.plg_system_rereplacer.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.com_virtuemart.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.com_virtuemart.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.plg_content_pagebreak.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.tpl_go-vista.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.tpl_go-vista.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_productscroller.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_productscroller.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_ds_banner_slide.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_ds_banner_slide.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart_latestprod.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart_latestprod.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_vvisit_counter.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_vvisit_counter.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart_randomprod.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart_randomprod.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart_featureprod.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart_featureprod.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart_cart.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart_cart.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart_search.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart_search.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_mainmenu.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart_login.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart_login.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_virtuemart_topten.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_virtuemart_topten.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_acymailing.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_acymailing.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.com_acymailing.ini 1
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.com_acymailing_custom.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.com_acymailing_custom.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_ofblikebox.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_ofblikebox.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\es-ES\es-ES.mod_sih.ini
• D:\inetpub\wwwroot\lacasadelamagia.net\www\tienda\language\en-GB\en-GB.mod_sih.ini

Sin traducir las cadenas de diagnóstico

Ninguno

Sin traducir las cadenas de diseñador

Ninguno