Query Count Discrepancy

[gregoryf]

When I click on the header logo to bring up the home page of my 3.1 beta, the query count in the footer reads "6 queries." The mysql log shows 23 queries for that request. I completely cleared the log before clicking on the logo. I checked this more than once with the same result, and other pages show similar discrepancies.

6 of these queries appear to be hitting a cache table, but they're still queries. At 23, the count seems comparatively low, but still, does anyone know what accounts for the discrepancies?

Here are the log entries for that one request:

100511  4:47:36   	2524 Connect 	root@localhost on ip31b

   		2524 Query   	set autocommit=1

   		2524 Query   	SELECT * FROM ip_cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','attachtypes','multimod','moderators','announcements','report_cache','chatting','birthdays','calendar','calendars','ranks','reputation_levels' )

   		2524 Query   	SELECT * FROM ip_sessions WHERE id='03756b1a449d9034810b8bb949defead'

   		2524 Query   	SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,im.*,ccb.cache_content FROM ip_members m  LEFT JOIN ip_pfields_content p ON ( p.member_id=m.member_id ) 

 LEFT JOIN ip_profile_portal pp ON ( pp.pp_member_id=m.member_id ) 

 LEFT JOIN ip_groups g ON ( g.g_id=m.member_group_id ) 

 LEFT JOIN ip_core_item_markers_storage im ON ( im.item_member_id=m.member_id ) 

 LEFT JOIN ip_content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id )   WHERE m.member_id=2

   		2524 Query   	SELECT f.*,p.* FROM ip_forums f  LEFT JOIN ip_permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )

   		2524 Query   	SELECT * FROM ip_skin_cache WHERE cache_set_id=1 AND cache_type IN ('css', 'replacements')

   		2524 Query   	SELECT id, member_id, member_name, seo_name, login_type, running_time, member_group, uagent_type FROM ip_sessions WHERE running_time > 1273570356

   		2524 Query   	SELECT * FROM ip_skin_cache WHERE cache_set_id=1 AND cache_value_1='skin_forums_global'

   		2524 Query   	SELECT * FROM ip_inline_notifications WHERE notify_to_id=2 AND notify_read=0 ORDER BY notify_sent DESC LIMIT 0,10

   		2524 Query   	SELECT * FROM ip_cache_store WHERE cs_key IN ( 'gallery_cats' )

   		2524 Query   	SELECT COUNT(*) as count FROM ip_gallery_images i  LEFT JOIN ip_members m ON ( m.member_id=i.member_id ) 

 LEFT JOIN ip_gallery_albums a ON ( i.album_id=a.id ) 

 LEFT JOIN ip_gallery_ratings r ON ( r.img_id=i.id AND r.member_id=2 )   WHERE  (  i.category_id IN ( 1 )  OR  ( i.album_id > 0 AND a.category_id IN ( 1 )  AND ( a.public_album=1 OR a.member_id=2 ) ) )  AND i.approved=1

   		2524 Query   	SELECT i.*,m.members_display_name, m.member_id AS mid, m.members_seo_name,r.id as rated, r.rate as my_rate FROM ip_gallery_images i  LEFT JOIN ip_members m ON ( m.member_id=i.member_id ) 

 LEFT JOIN ip_gallery_albums a ON ( a.id=i.album_id ) 

 LEFT JOIN ip_gallery_ratings r ON ( r.img_id=i.id AND r.member_id=2 )   WHERE  (  i.category_id IN ( 1 )  OR  ( i.album_id > 0 AND a.category_id IN ( 1 )  AND ( a.public_album=1 OR a.member_id=2 ) ) )  AND i.approved=1 ORDER BY i.idate DESC LIMIT 0,6

   		2524 Query   	SELECT tr.*,t.*,m.members_seo_name FROM ip_tracker tr  LEFT JOIN ip_topics t ON ( t.tid=tr.topic_id ) 

 LEFT JOIN ip_members m ON ( m.member_id=t.starter_id )   WHERE tr.member_id=2 AND tr.topic_id > 0 ORDER BY tr.last_sent DESC LIMIT 0,50

   		2524 Query   	SELECT forum_id, last_sent, member_id FROM ip_forum_tracker WHERE member_id=2 ORDER BY last_sent DESC LIMIT 0,50

   		2524 Query   	SELECT t.tid, t.title, t.title_seo, t.start_date, t.starter_id, t.starter_name,m.members_display_name, m.members_seo_name FROM ip_topics t  LEFT JOIN ip_members m ON ( m.member_id=t.starter_id )   WHERE t.tid IN (11,10,9,8,7)

   		2524 Query   	UPDATE ip_sessions SET member_name='Sally Serious',seo_name='sally-serious',member_id=2,member_group=3,login_type=0,running_time=1273571256,location='',in_error=0,current_appcomponent='forums',current_module='',current_section='',location_1_type='',location_1_id=0,location_2_type='',location_2_id=0,location_3_type='',location_3_id=0,uagent_key='safari',uagent_version=4,uagent_type='browser' WHERE id='03756b1a449d9034810b8bb949defead'

   		2524 Quit   	

   		2525 Connect 	root@localhost on ip31b

   		2525 Query   	set autocommit=1

   		2525 Query   	SELECT * FROM ip_cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','report_cache' )

   		2525 Query   	SELECT * FROM ip_skin_cache WHERE cache_set_id=1 AND cache_type IN ('css', 'replacements')

   		2525 Query   	SELECT * FROM ip_task_manager WHERE task_enabled = 1 AND task_next_run <= 1273571256 ORDER BY task_next_run ASC LIMIT 0,1

   		2525 Query   	UPDATE ip_task_manager SET task_next_run=1273574760,task_locked=1273571256 WHERE task_id=1

   		2525 Query   	SELECT task_next_run FROM ip_task_manager WHERE task_enabled = 1 ORDER BY task_next_run ASC LIMIT 0,1

   		2525 Query   	INSERT INTO ip_cache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`) VALUES(1,'systemvars','a:4:{s:10:\"mail_queue\";i:0;s:13:\"task_next_run\";s:10:\"1273549800\";s:15:\"itemMarkerClean\";i:1273571226;s:14:\"incomingEmails\";b:0;}',1273571256) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated)

   		2525 Query   	DELETE FROM ip_captcha WHERE captcha_date < 1273549656

   		2525 Query   	DELETE FROM ip_sessions WHERE running_time < 1273567656

   		2525 Query   	INSERT INTO ip_task_logs (`log_title`,`log_date`,`log_ip`,`log_desc`) VALUES('Hourly Clean Out',1273571256,'::1','Old reg_images, sessions and search results removed')

   		2525 Query   	UPDATE ip_task_manager SET task_locked=0 WHERE task_id=1

   		2525 Quit