Profile Information

Memory Usage

73 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'cdv8krhouc3hcn05lsemi68a91'
2. DELETE
     FROM jos_session
     WHERE ( time < '1268767493' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'cdv8krhouc3hcn05lsemi68a91'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'cdv8krhouc3hcn05lsemi68a91','1268768393','','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 `id`,`link`
     FROM jos_menu 
     WHERE ((`name` LIKE '%online casinos%')
     AND (`published` > 0))
8. SELECT oldurl, newurl
     FROM jos_redirection
     WHERE oldurl = 'online-casinos/Vegas-Casino-Online.html'
     ORDER BY rank ASC
     LIMIT 1
9. UPDATE jos_redirection
     SET cpt=(cpt+1)
     WHERE `newurl` = 'index.php?option=com_content&Itemid=443&catid=74&id=839&lang=en&view=article'
     AND `oldurl` = 'online-casinos/Vegas-Casino-Online.html'
10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 443)
      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 = 443 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:39" )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2010-03-16 19:39" )
       
      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_usplayerslist 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 10
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 (838,816,814,839,1153,846,844,1144,826,1225)
21. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=838&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=816&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=814&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=839&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=1153&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&catid=74&id=846&lang=en&view=article'
42. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
43. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
44. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
45. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=844&lang=en&view=article'
46. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
47. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
48. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
49. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=1144&lang=en&view=article'
50. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
51. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
52. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
53. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=826&lang=en&view=article'
54. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
55. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
56. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
57. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&catid=74&id=1225&lang=en&view=article'
58. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en'
59. SELECT alias, link,id
      FROM jos_menu
      WHERE id = '353'
      AND published='1'
60. SELECT oldurl
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_jreviews&Itemid=353&lang=en&url=online-casinos'
61. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_content&Itemid=443&id=1293&lang=en&view=article'
62. 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
63. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 32
64. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_banners&bid=32&lang=en&task=click'
65. 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
66. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 23
67. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_banners&bid=23&lang=en&task=click'
68. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
69. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&view=remind'
70. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_user&lang=en&task=register'
71. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 3
      AND catid = 154
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
72. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 27
73. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_banners&bid=27&lang=en&task=click'

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