Profile Information

Memory Usage

50 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'cdv8krhouc3hcn05lsemi68a91'
2. DELETE
     FROM jos_session
     WHERE ( time < '1268767980' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'cdv8krhouc3hcn05lsemi68a91'
4. UPDATE `jos_session`
     SET `time`='1268768880',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:10;s:19:\"session.timer.start\";i:1268768393;s:18:\"session.timer.last\";i:1268768728;s:17:\"session.timer.now\";i:1268768851;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:53:\"C:\\www\\pro360\\libraries\\joomla\\html\\parameter\\element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"72d0bf288ee9f1ef4c61432d97b041d7\";}__com_jreviews|a:2:{s:14:\"module_rand222\";i:26516;s:16:\"module_params222\";a:14:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:6:{s:6:\"option\";s:11:\"com_content\";s:6:\"Itemid\";s:3:\"443\";s:5:\"catid\";s:2:\"74\";s:2:\"id\";s:3:\"839\";s:4:\"lang\";s:2:\"en\";s:4:\"view\";s:7:\"article\";}s:6:\"option\";s:11:\"com_content\";s:6:\"Itemid\";s:3:\"443\";s:5:\"catid\";s:2:\"74\";s:2:\"id\";s:3:\"839\";s:4:\"lang\";s:2:\"en\";s:4:\"view\";s:7:\"article\";s:6:\"module\";a:19:{s:13:\"listing_order\";s:14:\"topratededitor\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:27:\"jr_usplayerslist like \'%1%\'\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:8:\"ajax_nav\";s:1:\"0\";s:12:\"module_limit\";s:2:\"10\";s:7:\"columns\";s:1:\"2\";s:8:\"cat_auto\";s:1:\"0\";s:3:\"dir\";s:1:\"2\";s:7:\"section\";s:1:\"5\";s:8:\"category\";s:2:\"74\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:2:\"60\";s:15:\"moduleclass_sfx\";s:0:\"\";s:5:\"cache\";s:1:\"1\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"222\";s:4:\"page\";i:1;s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:26516;}}'
     WHERE session_id='cdv8krhouc3hcn05lsemi68a91'
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 `id`,`link`
     FROM jos_menu 
     WHERE ((`name` LIKE '%online casinos%')
     AND (`published` > 0))
8. SELECT oldurl, newurl
     FROM jos_redirection
     WHERE oldurl = 'online-casinos/Golden-Tiger-Casino.html'
     ORDER BY rank ASC
     LIMIT 1
9. UPDATE jos_redirection
     SET cpt=(cpt+1)
     WHERE `newurl` = 'index.php?option=com_content&Itemid=456&catid=74&id=819&lang=en&view=article'
     AND `oldurl` = 'online-casinos/Golden-Tiger-Casino.html'
10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 456)
      ORDER BY menuid DESC
      LIMIT 0, 1
11. 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 = 456 OR mm.menuid = 0 )
      ORDER BY position, ordering
12. SELECT Listing.id AS `Listing.listing_id`,
    Listing.title AS `Listing.title`,
    Listing.introtext AS `Listing.summary`,
    Listing.images AS `Listing.images`,
    Listing.hits AS `Listing.hits`,
    Listing.sectionid AS `Listing.section_id`,
    Listing.catid AS `Listing.cat_id`,
    Listing.created_by AS `Listing.user_id`,
    Listing.created_by_alias AS `Listing.author_alias`,
    Listing.created AS `Listing.created`,
    Listing.access AS `Listing.access`,
    Listing.state AS `Listing.state`,
    Listing.publish_up AS `Listing.publish_up`,
    Listing.state AS `Listing.publish_down`,
    Listing.metakey AS `Listing.metakey`,
    Listing.metadesc AS `Listing.metadesc`,
    'com_content' AS `Listing.extension`,
    Section.id AS `Section.section_id`,
    Section.title AS `Section.title`,
    Category.id AS `Category.cat_id`,
    Category.title AS `Category.title`,
    Category.image AS `Listing.category_image`,
    Directory.id AS `Directory.dir_id`,
    Directory.DESC AS `Directory.title`,
    Directory.title AS `Directory.slug`,
    Criteria.id AS `Criteria.criteria_id`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.state AS `Criteria.state`,
    `Field`.featured AS `Listing.featured`,
    User.id AS `User.user_id`,
    User.name AS `User.name`,
    User.username AS `User.username`,
    IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
    CASE WHEN CHAR_LENGTH(Listing.alias) THEN Listing.alias ELSE "" END AS `Listing.slug`,
    CASE WHEN CHAR_LENGTH(Category.alias) THEN Category.alias ELSE Category.title END AS `Category.slug`,
    CASE WHEN CHAR_LENGTH(Section.alias) THEN Section.alias ELSE Section.title END AS `Section.slug`,
    sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty)) AS `Review.editor_rating`,
    IF(sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty))>0,1,0) AS `Review.editor_rating_exists`,
    (sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty)) AS `Review.user_rating`,
    IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
    (count(Review.id)-sum(Review.author)) AS `Review.review_count`,
    IF ((count(Review.id)-sum(Review.author))>0,1,0) AS `Review.review_count_exists`
     
      FROM jos_content AS Listing
    
      LEFT JOIN jos_jreviews_content AS FIELD
      ON FIELD.contentid = Listing.id
    
      LEFT JOIN jos_sections AS Section
      ON Listing.sectionid = Section.id
    
      LEFT JOIN jos_categories AS Category
      ON Listing.catid = Category.id
    
      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
    
      LEFT JOIN jos_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id
    
      LEFT JOIN jos_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
    
      LEFT JOIN jos_users AS User
      ON User.id = Listing.created_by
    
      INNER JOIN jos_jreviews_comments AS Review
      ON Listing.id = Review.pid
      AND Review.published = 1
      AND Review.mode = 'com_content'
    
      INNER JOIN jos_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
    
      LEFT JOIN jos_jreviews_review_fields AS ReviewField
      ON ReviewField.reviewid = Review.id
     
      WHERE 1 = 1
      AND (
       Listing.state = 1
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2010-03-16 19:48" )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2010-03-16 19:48" )
       
      AND Listing.access <= 0
       
      AND Listing.catid > 0
       
      AND JreviewsCategory.dirid IN (2)
       
      AND Listing.sectionid IN (5)
       
      AND Listing.catid IN (74)
       
      AND jr_securitycertificate LIKE '%1%'
       
      AND LOCATE('*default*', FIELD.jr_country) > 0
     )
     
      GROUP BY Listing.id
     
      ORDER BY `Review.editor_rating_exists` DESC, `Review.editor_rating` DESC, `Review.user_rating` DESC, Listing.created DESC
     
      LIMIT 5
13. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.qty AS `Criteria.quantity`,
    Criteria.groupid AS `Criteria.group_id`,
    Criteria.state AS `Criteria.state`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (9)
     )
14. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (8,9)
     
      AND type = 'content'
15. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`,
     FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`,
     FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`,
     FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.listsort AS `Field.listSort`,
     FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`,
     FIELD.published AS `Field.published`,
     `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`
     
      FROM jos_jreviews_fields AS FIELD
     
      INNER JOIN jos_jreviews_groups AS `Group`
      ON (`Group`.groupid = FIELD.groupid
      AND
     `Group`.groupid IN (8)
      AND `Group`.type =  'content' )
     
      WHERE FIELD.location = 'content'
      AND FIELD.published = 1
     
      ORDER BY
      GROUP.ordering, FIELD.ordering
16. SELECT *
      FROM jos_jreviews_fieldoptions
     
      WHERE fieldid = 33
     
      ORDER BY ordering ASC ,optionid ASC
17. SELECT *
      FROM jos_jreviews_fieldoptions
     
      WHERE fieldid = 52
     
      ORDER BY ordering ASC ,optionid ASC
18. SELECT *
      FROM jos_jreviews_fieldoptions
     
      WHERE fieldid = 58
     
      ORDER BY ordering ASC ,optionid ASC
19. SELECT *
      FROM jos_jreviews_fieldoptions
     
      WHERE fieldid = 59
     
      ORDER BY ordering ASC ,optionid ASC
20. SELECT Listing.contentid AS element_id,jr_usplayerslist,jr_affiliatelink,jr_downloadlink,jr_bonus,jr_payout,jr_country,jr_bonuscode,jr_bonusmatch,jr_softwarelisting,jr_gameslisting
     
      FROM jos_jreviews_content AS Listing
     
      WHERE Listing.contentid IN (831,214,819,820,837)
21. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=831&lang=en&view=article'
22. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
23. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
24. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
25. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=214&lang=en&view=article'
26. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
27. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
28. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
29. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=819&lang=en&view=article'
30. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
31. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
32. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
33. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=820&lang=en&view=article'
34. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
35. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
36. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
37. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=837&lang=en&view=article'
38. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
39. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
40. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
41. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=456&id=1299&lang=en&view=article'
42. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 4
      AND catid = 13
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
43. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 32
44. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_banners&bid=32&lang=en&task=click'
45. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 1
      AND catid = 13
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
46. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 24
47. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_banners&bid=24&lang=en&task=click'
48. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
49. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=remind'
50. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&task=register'

Language Files Loaded

• C:\www\pro360\language\en-GB\en-GB.ini 1
• C:\www\pro360\language\en-GB\en-GB.plg_system_debug.ini 1
• C:\www\pro360\language\en-GB\en-GB.com_content.ini 1
• C:\www\pro360\language\en-GB\en-GB.tpl_yoo_beyond_SEO.ini
• C:\www\pro360\language\en-GB\en-GB.mod_jreviews_listings.ini
• C:\www\pro360\language\en-GB\en-GB.mod_breadcrumbs.ini 1
• C:\www\pro360\language\en-GB\en-GB.mod_banners.ini 1
• C:\www\pro360\language\en-GB\en-GB.mod_login.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None