SATS QUESTIONS

Profile Information

Application afterLoad: 0.001 seconds, 0.39 MB

Application afterInitialise: 0.033 seconds, 2.39 MB

Application afterRoute: 0.041 seconds, 2.82 MB

Application afterDispatch: 0.052 seconds, 3.26 MB

Application afterRender: 0.138 seconds, 7.85 MB

Memory Usage

8293440

29 queries logged

SELECT *
FROM jos_session
WHERE session_id = 't4vpq60adqig8d27fo5ilisbf1'
DELETE
FROM jos_session
WHERE ( TIME < '1786449974' )
SELECT *
FROM jos_session
WHERE session_id = 't4vpq60adqig8d27fo5ilisbf1'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 't4vpq60adqig8d27fo5ilisbf1','1786450874','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
  FROM jos_plugins
  WHERE published >= 1
  AND access <= 0
  ORDER BY ordering
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
SELECT template
  FROM jos_templates_menu
  WHERE client_id = 0
  AND (menuid = 0 OR menuid = 83)
  ORDER BY menuid DESC
  LIMIT 0, 1
SELECT category_type
FROM jos_statsquestion
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 = 83 OR mm.menuid = 0 )
  ORDER BY POSITION, ordering
SELECT group_id,group_name,group_level
FROM `jos_vm_auth_group`
ORDER BY group_level
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'
SELECT `name`
FROM `jos_core_acl_aro_groups`
WHERE `id` =29
SELECT `lft`, `rgt`
FROM `jos_core_acl_aro_groups`
WHERE `name`='Public Frontend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level

  FROM jos_core_acl_aro_groups AS g1

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

  GROUP BY g1.name

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

  FROM jos_core_acl_aro_groups AS g1

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

  GROUP BY g1.name

  ORDER BY g1.lft
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1, 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

  FROM (`jos_vm_vendor`, `jos_vm_country`)

  WHERE `vendor_id`=1

  AND (vendor_country=country_2_code OR vendor_country=country_3_code);
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
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND published=1
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='11'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='12'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='42'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT category_child_id
FROM jos_vm_category_xref
WHERE category_parent_id='42'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='39'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='38'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='37'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='36'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='35'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'

29 legacy queries logged

SELECT *
FROM jos_session
WHERE session_id = 't4vpq60adqig8d27fo5ilisbf1'
DELETE
FROM jos_session
WHERE ( TIME < '1786449974' )
SELECT *
FROM jos_session
WHERE session_id = 't4vpq60adqig8d27fo5ilisbf1'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 't4vpq60adqig8d27fo5ilisbf1','1786450874','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
  FROM jos_plugins
  WHERE published >= 1
  AND access <= 0
  ORDER BY ordering
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
SELECT template
  FROM jos_templates_menu
  WHERE client_id = 0
  AND (menuid = 0 OR menuid = 83)
  ORDER BY menuid DESC
  LIMIT 0, 1
SELECT category_type
FROM jos_statsquestion
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 = 83 OR mm.menuid = 0 )
  ORDER BY POSITION, ordering
SELECT group_id,group_name,group_level
FROM `jos_vm_auth_group`
ORDER BY group_level
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'
SELECT `name`
FROM `jos_core_acl_aro_groups`
WHERE `id` =29
SELECT `lft`, `rgt`
FROM `jos_core_acl_aro_groups`
WHERE `name`='Public Frontend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level

  FROM jos_core_acl_aro_groups AS g1

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

  GROUP BY g1.name

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

  FROM jos_core_acl_aro_groups AS g1

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

  GROUP BY g1.name

  ORDER BY g1.lft
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1, 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

  FROM (`jos_vm_vendor`, `jos_vm_country`)

  WHERE `vendor_id`=1

  AND (vendor_country=country_2_code OR vendor_country=country_3_code);
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
SELECT id
  FROM jos_menu
  WHERE link='index.php?option=com_virtuemart'
  AND published=1
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='11'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='12'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='42'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT category_child_id
FROM jos_vm_category_xref
WHERE category_parent_id='42'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='39'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='38'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='37'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='36'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'
SELECT COUNT(jos_vm_product.product_id) AS num_rows
  FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
  WHERE jos_vm_product_category_xref.category_id='35'
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
  AND product_publish='Y'

Language Files Loaded

/home/davidg/public_html/language/en-GB/en-GB.ini 1
/home/davidg/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
/home/davidg/public_html/language/en-GB/en-GB.com_stats.ini
/home/davidg/public_html/language/en-GB/en-GB.tpl_ja_mesolite.ini 1
/home/davidg/public_html/language/en-GB/en-GB.mod_footer.ini 1
/home/davidg/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
/home/davidg/public_html/language/en-GB/en-GB.mod_product_categories.ini
/home/davidg/public_html/language/en-GB/en-GB.mod_breadcrumbs.ini 1
/home/davidg/public_html/language/en-GB/en-GB.mod_virtuemart_search.ini
/home/davidg/public_html/language/en-GB/en-GB.mod_S5tellafriend.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

easylessons.co.uk

SATS

Video Categories