Order By :
1 2 3 

«Prev Next »

Profile Information

Application afterLoad: 0.000 seconds, 0.30 MB
Application afterInitialise: 0.005 seconds, 0.96 MB
Application afterRoute: 0.010 seconds, 2.53 MB
Application afterDispatch: 3.836 seconds, 3.16 MB
Application afterRender: 3.850 seconds, 3.35 MB

Memory Usage

3546864

240 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'dum2q4cak34dl4pghui87lgrb1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1756461974' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'dum2q4cak34dl4pghui87lgrb1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'dum2q4cak34dl4pghui87lgrb1','1756469174','','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 *
      FROM jos_redshop_configuration
  9. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-08-29'
  12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'dum2q4cak34dl4pghui87lgrb1'
  13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('dum2q4cak34dl4pghui87lgrb1', '0','1756469176')
  14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'dum2q4cak34dl4pghui87lgrb1'
      AND section='category'
      AND section_id='31'
  15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('dum2q4cak34dl4pghui87lgrb1','0','category','31','1756469178')
  16. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  17. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
  18. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=31
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
  19. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=31
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  20. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=31
      AND published = 1
      ORDER BY c.category_name ASC
  21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '31'
  22. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=31%')
      ORDER BY 'ordering'
  23. SELECT *
      FROM jos_menu
      WHERE id = '222'
  24. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  25. 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='31'
      AND c.category_id = cx.category_parent_id
  26. 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='29'
      AND c.category_id = cx.category_parent_id
  27. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=31
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 20, 15
  28. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=31
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  29. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=31
      AND published = 1
      ORDER BY c.category_name ASC
  30. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '31'
  31. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=31%')
      ORDER BY 'ordering'
  32. SELECT *
      FROM jos_menu
      WHERE id = '222'
  33. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  34. 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='31'
      AND c.category_id = cx.category_parent_id
  35. 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='29'
      AND c.category_id = cx.category_parent_id
  36. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=56
      AND p.published = 1
      ORDER BY a.ordering ASC
  37. 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=56
      AND t.published = 1
      LIMIT 0,1
  38. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  39. SELECT *
      FROM jos_menu
      WHERE id = '222'
  40. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '56'
  41. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '56'
      AND pc.category_id = c.category_id 
      AND c.category_id = '31'
  42. 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='31'
      AND c.category_id = cx.category_parent_id
  43. 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='29'
      AND c.category_id = cx.category_parent_id
  44. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  45. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  46. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='56'
      AND section='1'
  47. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 56
  48. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 56
      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
  49. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  50. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
  52. 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
  53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
  54. 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
  55. 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'
  56. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
  57. 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
  58. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
  59. 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
  60. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 56
      AND ps.stockroom_id = s.stockroom_id
  61. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 56
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  63. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 56
  64. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 56
      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 ="56"
      AND media_type="images" 
      AND media_name = "1301545388_CT7141-7.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
      WHERE  ps.product_id = 56
      AND ps.stockroom_id = s.stockroom_id
  69. 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'
  70. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 56
  71. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 56
      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
  72. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  73. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
  75. 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
  76. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
  77. 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
  78. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  79. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 56
      AND ps.stockroom_id = s.stockroom_id
  80. 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'
  81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 56
  82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 56
      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 <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 56
  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 = 56
  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 = 56
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  90. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=57
      AND p.published = 1
      ORDER BY a.ordering ASC
  91. 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=57
      AND t.published = 1
      LIMIT 0,1
  92. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  93. SELECT *
      FROM jos_menu
      WHERE id = '222'
  94. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '57'
  95. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '57'
      AND pc.category_id = c.category_id 
      AND c.category_id = '31'
  96. 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='31'
      AND c.category_id = cx.category_parent_id
  97. 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='29'
      AND c.category_id = cx.category_parent_id
  98. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  99. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  100. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='57'
      AND section='1'
  101. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 57
  102. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 57
      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
  103. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  104. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  105. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  106. 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
  107. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  108. 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
  109. 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'
  110. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  111. 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
  112. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  113. 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
  114. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 57
      AND ps.stockroom_id = s.stockroom_id
  115. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 57
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  116. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  117. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 57
  118. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 57
      AND ps.stockroom_id = s.stockroom_id
  119. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  120. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="57"
      AND media_type="images" 
      AND media_name = "1301545595_CT7143-11.jpg"
  121. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  122. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 57
      AND ps.stockroom_id = s.stockroom_id
  123. 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'
  124. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 57
  125. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 57
      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
  126. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  127. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  128. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  129. 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
  130. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  131. 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
  132. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  133. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 57
      AND ps.stockroom_id = s.stockroom_id
  134. 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'
  135. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 57
  136. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 57
      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
  137. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  138. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  139. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  140. 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
  141. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
  142. 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
  143. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 57
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  144. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=58
      AND p.published = 1
      ORDER BY a.ordering ASC
  145. 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=58
      AND t.published = 1
      LIMIT 0,1
  146. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  147. SELECT *
      FROM jos_menu
      WHERE id = '222'
  148. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '58'
  149. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '58'
      AND pc.category_id = c.category_id 
      AND c.category_id = '31'
  150. 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='31'
      AND c.category_id = cx.category_parent_id
  151. 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='29'
      AND c.category_id = cx.category_parent_id
  152. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  153. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
  154. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='58'
      AND section='1'
  155. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 58
  156. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 58
      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
  157. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  158. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  159. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  160. 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
  161. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  162. 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
  163. 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'
  164. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  165. 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
  166. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  167. 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
  168. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 58
      AND ps.stockroom_id = s.stockroom_id
  169. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 58
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  170. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  171. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 58
  172. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 58
      AND ps.stockroom_id = s.stockroom_id
  173. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  174. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="58"
      AND media_type="images" 
      AND media_name = "1301545732_CT7616-7.jpg"
  175. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  176. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 58
      AND ps.stockroom_id = s.stockroom_id
  177. 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'
  178. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 58
  179. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 58
      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
  180. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  181. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  182. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  183. 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
  184. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  185. 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
  186. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  187. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 58
      AND ps.stockroom_id = s.stockroom_id
  188. 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'
  189. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 58
  190. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 58
      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
  191. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  192. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1756469178'
      AND end_date >= '1756469178' 
      ORDER BY amount DESC
      LIMIT 0,1
  193. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  194. 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
  195. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
  196. 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
  197. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 58
      AND discount_enddate>='1756469178'
      AND discount_stratdate<='1756469178'
  198. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 31
  199. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '222'
  200. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params NOT LIKE '%categoryid%'
  201. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params  LIKE '%categoryid=31
    %'
  202. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 31
  203. SELECT *
      FROM jos_menu
      WHERE id = '222'
  204. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  205. 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='31'
      AND c.category_id = cx.category_parent_id
  206. 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='29'
      AND c.category_id = cx.category_parent_id
  207. SELECT category_parent_id
      FROM jos_redshop_category_xref
      WHERE category_child_id=31
  208. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params  LIKE '%categoryid=29
    %'
  209. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 29
  210. SELECT *
      FROM jos_menu
      WHERE id = '222'
  211. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '29'
  212. 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='29'
      AND c.category_id = cx.category_parent_id
  213. SELECT category_parent_id
      FROM jos_redshop_category_xref
      WHERE category_child_id=29
  214. SELECT *
      FROM jos_menu
      WHERE id = '222'
  215. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  216. 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='31'
      AND c.category_id = cx.category_parent_id
  217. 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='29'
      AND c.category_id = cx.category_parent_id
  218. SELECT *
      FROM jos_menu
      WHERE id = '222'
  219. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  220. 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='31'
      AND c.category_id = cx.category_parent_id
  221. 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='29'
      AND c.category_id = cx.category_parent_id
  222. SELECT *
      FROM jos_menu
      WHERE id = '222'
  223. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  224. 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='31'
      AND c.category_id = cx.category_parent_id
  225. 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='29'
      AND c.category_id = cx.category_parent_id
  226. SELECT *
      FROM jos_menu
      WHERE id = '222'
  227. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  228. 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='31'
      AND c.category_id = cx.category_parent_id
  229. 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='29'
      AND c.category_id = cx.category_parent_id
  230. SELECT *
      FROM jos_menu
      WHERE id = '222'
  231. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
  232. 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='31'
      AND c.category_id = cx.category_parent_id
  233. 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='29'
      AND c.category_id = cx.category_parent_id
  234. 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 = 222 OR mm.menuid = 0 )
      ORDER BY position, ordering
  235. SELECT *
      FROM jos_menu
      WHERE id = '71'
  236. SELECT *
      FROM jos_menu
      WHERE id = '222'
  237. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  238. 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'
  239. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  240. SELECT *
      FROM jos_menu
      WHERE id = '222'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None