Simply Silks 4 Collection

Profile Information

Memory Usage

122 queries logged

1. DELETE
     FROM jos_session
     WHERE ( time < '1739779938' )
2. SELECT *
     FROM jos_session
     WHERE session_id = '6g1kd7879fek5nm4putnoqnlu6'
3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '6g1kd7879fek5nm4putnoqnlu6','1739787138','','0','1','0' )
4. SELECT *
     FROM jos_components
     WHERE parent = 0
5. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
6. 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
7. SELECT *
     FROM jos_redshop_configuration
8. SELECT *
     FROM jos_redshop_catalog_request
     WHERE block = 0
9. SELECT *
     FROM jos_redshop_sample_request
     WHERE block = 0
10. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-02-17'
11. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '6g1kd7879fek5nm4putnoqnlu6'
12. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('6g1kd7879fek5nm4putnoqnlu6', '0','1739787140')
13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '6g1kd7879fek5nm4putnoqnlu6'
      AND section='product'
      AND section_id='13383'
14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('6g1kd7879fek5nm4putnoqnlu6','0','product','13383','1739787141')
15. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 275)
      ORDER BY menuid DESC
      LIMIT 0, 1
17. SELECT id
      FROM `jos_components`
      WHERE `link` LIKE '%com_reddesign%'
18. SELECT p.*, c.category_id, c.category_name, m.manufacturer_name ,s.supplier_name 
      FROM (jos_redshop_category AS c ,jos_redshop_product AS p , jos_redshop_product_category_xref AS pcr ) 
      LEFT JOIN jos_redshop_manufacturer AS m
      ON m.manufacturer_id = p.manufacturer_id 
      LEFT JOIN jos_redshop_supplier AS s
      ON s.supplier_id = p.supplier_id   
      WHERE p.product_id=13383
      AND pcr.product_id=13383
      AND pcr.category_id=c.category_id 
      AND p.published = 1
19. SELECT  min_del_time AS deltime, s.max_del_time, s.delivery_time 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 13383
      AND ps.stockroom_id = s.stockroom_id
      AND ps.quantity >0
      ORDER BY min_del_time ASC
      LIMIT 0,1
20. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=13383
      AND t.published = 1
      LIMIT 0,1
21. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
22. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 13383
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
23. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
24. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787141'
      AND end_date >= '1739787141' 
      ORDER BY amount DESC
      LIMIT 0,1
25. SELECT *
      FROM jos_menu
      WHERE id = '275'
26. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '13383'
27. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '13383'
      AND pc.category_id = c.category_id 
      AND c.category_id = '214'
28. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='214'
      AND c.category_id = cx.category_parent_id
29. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '214'
30. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1 
      AND field_name IN ('product_desc','product_thumb_image','more_images','product_s_desc','manufacturer_link','related_product:Related Products')
31. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 15
32. SELECT *
      FROM jos_menu
      WHERE id = '275'
33. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '15'
34. SELECT product_id AS value,product_name AS text
                                           
      FROM `jos_redshop_product`
                                           
      WHERE `product_parent_id` =13383
35. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 13383
      AND ps.stockroom_id = s.stockroom_id
36. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 13383
37. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 13383
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
38. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
39. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787141'
      AND end_date >= '1739787141' 
      ORDER BY amount DESC
      LIMIT 0,1
40. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
41. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
43. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
44. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
45. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
46. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
48. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
49. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 13383
      AND ps.stockroom_id = s.stockroom_id
50. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 13383
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
      AND discount_enddate>='1739787141'
      AND discount_stratdate<='1739787141'
52. SELECT *
      FROM jos_redshop_media AS m
      LEFT JOIN jos_redshop_product AS p
      ON p.product_id = m.section_id
      WHERE m.media_section = 'product'
      AND media_type='images'
      AND m.section_id=13383
      AND m.published = 1
53. SELECT *
      FROM jos_redshop_wrapper
      WHERE published = 1
      AND (FIND_IN_SET(13383,product_id)  OR wrapper_use_to_all = 1  )
54. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'wrapper_template'
      AND published=1
55. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'attribute_template'
      AND published=1
56. SELECT a.attribute_id AS value,a.attribute_name AS text,a.*
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=13383
      AND p.published = 1
      ORDER BY a.ordering ASC
57. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'accessory_template'
      AND published=1
58. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'review'
      AND published=1
      LIMIT 0,1
59. SELECT ui.firstname,ui.lastname,pr.*
      FROM jos_redshop_product_rating AS pr, jos_users AS u, jos_redshop_users_info AS ui
      WHERE pr.product_id=13383
      AND pr.published = 1
      AND pr.userid=u.id
      AND ui.user_id=u.id
      AND ui.address_type LIKE 'BT'
      ORDER BY pr.favoured DESC
60. SELECT pr.*
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=13383
      AND pr.published = 1
61. SELECT sum(user_rating) AS rating
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=13383
      AND pr.published = 1
62. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
63. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 13383
64. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 13383
      AND ps.stockroom_id = s.stockroom_id
65. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
66. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="13383"
      AND media_type="images" 
      AND media_name = "simplysilks4/SK34724.jpg"
67. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
68. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 13383
      AND ps.stockroom_id = s.stockroom_id
69. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 13383
70. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 13383
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
71. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
72. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787141'
      AND end_date >= '1739787141' 
      ORDER BY amount DESC
      LIMIT 0,1
73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
74. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
75. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
76. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
77. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
      AND discount_enddate>='1739787141'
      AND discount_stratdate<='1739787141'
78. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
79. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
80. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 13383
      AND ps.stockroom_id = s.stockroom_id
81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 13383
82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 13383
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
83. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
84. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739787141'
      AND end_date >= '1739787141' 
      ORDER BY amount DESC
      LIMIT 0,1
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
86. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
88. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
89. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 13383
      AND discount_enddate>='1739787141'
      AND discount_stratdate<='1739787141'
90. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
91. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
92. UPDATE jos_redshop_product
      SET `visited` = visited + 1
      WHERE `product_id` = '13383'
93. SELECT p.product_name,pcx.category_id
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE p.product_id = 13383
      AND p.product_id = pcx.product_id
94. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id=''
      AND c.category_id = cx.category_parent_id
95. SELECT pcx.product_id,p.product_name
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE pcx.category_id=214
      AND pcx.product_id=p.product_id
      ORDER BY pcx.product_id
96. SELECT *
      FROM jos_menu
      WHERE id = '275'
97. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '13384'
98. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '13384'
      AND pc.category_id = c.category_id 
      AND c.category_id = '214'
99. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='214'
      AND c.category_id = cx.category_parent_id
100. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '214'
101. SELECT *
       FROM jos_menu
       WHERE id = '275'
102. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '13382'
103. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '13382'
       AND pc.category_id = c.category_id 
       AND c.category_id = '214'
104. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='214'
       AND c.category_id = cx.category_parent_id
105. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '214'
106. SELECT *
       FROM jos_redshop_textlibrary
       WHERE published=1
107. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '275'
108. SELECT category_id
       FROM jos_redshop_product_category_xref
       WHERE product_id=13383
109. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
110. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=214
     %'
111. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=214
112. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=product%' 
       AND params  LIKE '%productid=13383
     %'
113. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 13383
114. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'related_product'
       AND published=1
115. SELECT *
       FROM jos_redshop_product AS p ,jos_redshop_product_related  AS r
       WHERE r.related_id = p.product_id
       AND r.product_id=13383
       AND p.published = 1
116. 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 = 275 OR mm.menuid = 0 )
       ORDER BY position, ordering
117. SELECT *
       FROM jos_menu
       WHERE id = '71'
118. SELECT *
       FROM jos_menu
       WHERE id = '222'
119. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
120. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`link` LIKE '%id=216%'  OR `params` LIKE '%categoryid=216%')
       ORDER BY 'ordering'
121. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
122. SELECT *
       FROM jos_menu
       WHERE id = '275'

Language Files Loaded

• /home/ontwall/public_html/language/en-GB/en-GB.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.com_redshop.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.tpl_granit.ini
• /home/ontwall/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.mod_btslideshow.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.mod_redshop_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None