Profile Information

Memory Usage

37 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'ba8771ff64536320b25c14109ee38747'
2. DELETE
     FROM jos_session
     WHERE ( TIME < '1539676824' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'ba8771ff64536320b25c14109ee38747'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'ba8771ff64536320b25c14109ee38747','1539684024','','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 setting,VALUE
     FROM jos_jfbconnect_config
8. 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
9. SELECT VALUE
     FROM jos_jreviews_config
     WHERE id = 'debug_overrides_disable'
10. SELECT *
      FROM jos_menu
      WHERE id = 69
11. SELECT
                            id,
                            name,
                                                    alias AS alias,
                            link AS menu_type,
                            link,
                            componentid,
                            params,
                            access,
                            published,
                            '*' AS LANGUAGE
                   
               
      FROM jos_menu
               
      WHERE published = 1
               
      ORDER BY link DESC
12. 
      SET SQL_BIG_SELECTS=1
13. INSERT INTO
                                                    jos_jreviews_config (id, VALUE)
                                           
      VALUES
                                                    ('last_cache_clean', '1539684024')
                                           
      ON DUPLICATE KEY UPDATE
                                                    VALUE = '1539684024'
14. SELECT id, VALUE
      FROM jos_jreviews_config
15. DELETE
                                   
      FROM jos_jreviews_registration
                           
      WHERE
                                    session_time < 1539680428
16. SELECT Review.id AS `Review.review_id`,
    Review.pid AS `Review.listing_id`,
    Review.mode AS `Review.extension`,
    Review.created AS `Review.created`,
    Review.modified AS `Review.modified`,
    Review.userid AS `Review.user_id`,
    Review.userid AS `User.user_id`,
    CASE WHEN CHAR_LENGTH(USER.name) THEN USER.name ELSE Review.name END AS `User.name`,
    CASE WHEN CHAR_LENGTH(USER.username) THEN USER.username ELSE Review.username END AS `User.username`,
    Review.email AS `User.email`,
    Review.ipaddress AS `User.ipaddress`,
    Rank.rank AS `User.review_rank`,
    Rank.reviews AS `User.review_count`,
    Review.title AS `Review.title`,
    Review.comments AS `Review.comments`,
    Review.posts AS `Review.posts`,
    Review.author AS `Review.editor`,
    Review.published AS `Review.published`,
    Rating.ratings AS `Rating.ratings`,
    (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`,
    Review.vote_helpful AS `Vote.yes`,
    (Review.vote_total - Review.vote_helpful) AS `Vote.no`,
    (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`,
    Review.owner_reply_text AS `Review.owner_reply_text`,
    Review.owner_reply_approved AS `Review.owner_reply_approved`,
    Review.owner_reply_created AS `Review.owner_reply_created`,
    Review.media_count AS `Review.media_count`,
    Review.video_count AS `Review.video_count`,
    Review.photo_count AS `Review.photo_count`,
    Review.audio_count AS `Review.audio_count`,
    Review.attachment_count AS `Review.attachment_count`
     
      FROM jos_jreviews_comments AS Review
    
      LEFT JOIN jos_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
    
      LEFT JOIN jos_users AS USER
      ON Review.userid = USER.id
    
      LEFT JOIN jos_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
     
      WHERE 1 = 1
      AND (
       Review.userid= 4234
       
      AND Review.published = 1
     )
     
      ORDER BY Review.created DESC
     
      LIMIT 15
17. SELECT Listing.id AS `Listing.listing_id`,
    Listing.alias AS `Listing.slug`,
    Category.alias AS `Category.slug`,
    Listing.title AS `Listing.title`,
    Listing.introtext AS `Listing.summary`,
    Listing.fulltext AS `Listing.description`,
    Listing.images AS `Listing.images`,
    Listing.hits AS `Listing.hits`,
    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.modified AS `Listing.modified`,
    Listing.access AS `Listing.access`,
    Listing.state AS `Listing.state`,
    Listing.publish_up AS `Listing.publish_up`,
    Listing.publish_down AS `Listing.publish_down`,
    Listing.metakey AS `Listing.metakey`,
    Listing.metadesc AS `Listing.metadesc`,
    'com_content' AS `Listing.extension`,
    Category.id AS `Category.cat_id`,
    Category.title AS `Category.title`,
    Directory.id AS `Directory.dir_id`,
    Directory.DESC AS `Directory.title`,
    Directory.title AS `Directory.slug`,
    Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.required AS `Criteria.required`,
    Criteria.state AS `Criteria.state`,
    Criteria.config AS `ListingType.config`,
    `Field`.featured AS `Listing.featured`,
    USER.id AS `User.user_id`,
    USER.name AS `User.name`,
    USER.username AS `User.username`,
    USER.email AS `User.email`,
    Claim.approved AS `Claim.approved`,
    Totals.user_rating AS `Review.user_rating`,
    Totals.user_rating_count AS `Review.user_rating_count`,
    Totals.user_criteria_rating AS `Review.user_criteria_rating`,
    Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
    Totals.user_comment_count AS `Review.review_count`,
    Totals.editor_rating AS `Review.editor_rating`,
    Totals.editor_rating_count AS `Review.editor_rating_count`,
    Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
    Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
    Totals.editor_comment_count AS `Review.editor_review_count`,
    Totals.media_count AS `Listing.media_count`,
    Totals.video_count AS `Listing.video_count`,
    Totals.photo_count AS `Listing.photo_count`,
    Totals.audio_count AS `Listing.audio_count`,
    Totals.attachment_count AS `Listing.attachment_count`,
    (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
    (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
    (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
    (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
    (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
    Totals.media_count_user AS `Listing.media_count_user`,
    Totals.video_count_user AS `Listing.video_count_user`,
    Totals.photo_count_user AS `Listing.photo_count_user`,
    Totals.audio_count_user AS `Listing.audio_count_user`,
    Totals.attachment_count_user AS `Listing.attachment_count_user`,
    Listing.sectionid AS `Listing.section_id`,
    SECTION.id AS `Section.section_id`,
    SECTION.title AS `Section.title`,
    SECTION.alias AS `Section.slug`,
    Category.image AS `Listing.category_image`
     
      FROM jos_content AS Listing
    
      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'
    
      LEFT JOIN jos_categories AS Category
      ON JreviewsCategory.id = Category.id
    
      LEFT JOIN jos_sections AS SECTION
      ON Category.SECTION = SECTION.id
    
      LEFT JOIN jos_jreviews_listing_totals AS Totals
      ON Totals.listing_id = Listing.id
      AND Totals.extension = 'com_content'
    
      LEFT JOIN jos_jreviews_content AS FIELD
      ON FIELD.contentid = Listing.id
    
      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
    
      LEFT JOIN jos_jreviews_claims AS Claim
      ON Claim.listing_id = Listing.id
      AND Claim.user_id = Listing.created_by
      AND Claim.approved = 1
     
      WHERE 1 = 1
      AND (
       Listing.id IN (1863,1878,1756)
     )
18. SELECT
                            id,
                            name,
                                                    alias AS alias,
                            link AS menu_type,
                            link,
                            componentid,
                            params,
                            access,
                            published,
                            '*' AS LANGUAGE
                   
               
      FROM jos_menu
               
      WHERE published = 1
               
      ORDER BY link DESC
19. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    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.SEARCH AS `Criteria.search`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (13,25,3)
     )
20. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19,20,26,25,27,19,20,26,25,27,19)
     
      AND TYPE = 'review'
21. 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.compareview AS `Field.compareView`, 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`.groupid AS `Group.group_id`, `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 (19)
      AND `Group`.TYPE =  'review' )
     
      WHERE FIELD.location = 'review'
      AND FIELD.published = 1
     
      ORDER BY
      GROUP.ordering, FIELD.ordering
22. SELECT Review.reviewid AS element_id,jr_accomplishments
     
      FROM jos_jreviews_review_fields AS Review
     
      WHERE Review.reviewid IN (14376,14373,14371)
23. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    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.SEARCH AS `Criteria.search`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (3)
     )
24. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
25. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    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.SEARCH AS `Criteria.search`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (25)
     )
26. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
27. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    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.SEARCH AS `Criteria.search`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (13)
     )
28. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (20,26,25,27,19)
     
      AND TYPE = 'review'
29. SELECT COUNT(*)
     
      FROM jos_jreviews_comments AS Review
    
      LEFT JOIN jos_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid
    
      LEFT JOIN jos_users AS USER
      ON Review.userid = USER.id
    
      LEFT JOIN jos_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id
     
      WHERE 1 = 1
      AND (
       Review.userid= 4234
       
      AND Review.published = 1
     )
30. SELECT USER.name AS `User.name`
     
      FROM jos_users AS `User`
     
      WHERE 1 = 1
      AND (
       USER.id = 4234
     )
31. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
32. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 69)
      ORDER BY menuid DESC
      LIMIT 0, 1
33. 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 = 69 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
34. SELECT  name  
      FROM  jos_rquotes_categories
      WHERE id='1'
35. SELECT *
      FROM jos_rquotes
      WHERE  published = '1'
      AND  category='Academy Member Quotes'
36. SELECT *
                           
      FROM jos_menu
                           
      WHERE menutype='topmenu'
      AND published=1
                           
      ORDER BY sublevel DESC,ordering
                            ;
37. SELECT *
                           
      FROM jos_modules
                           
      WHERE published=1
                           
      ORDER BY id
                            ;

Language Files Loaded

• /home/bammy54/public_html/nominations/language/en-GB/en-GB.ini 1
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.plg_system_jqueryeasy.ini
• /home/bammy54/public_html/nominations/administrator/language/en-GB/en-GB.plg_system_easycalccheckplus.ini 1
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.com_jreviews.ini
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.tpl_theme513.ini
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_jcomments_most_commented.ini 1
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_search.ini 1
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_rquotes.ini 1
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_socialauth.ini
• /home/bammy54/public_html/nominations/language/en-GB/en-GB.mod_maximenu_CK.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None