Brands query log

//////////////////////////////////////////

August 23, 2011, 5:15:24 pm

					SELECT wp_term_taxonomy.term_id
					FROM wp_term_taxonomy
					INNER JOIN wp_terms USING (term_id)
					WHERE taxonomy = 'portfolio-cats'
					AND wp_terms.slug IN ('brands')
				 - (0.00059390068054199 s)


					SELECT term_taxonomy_id
					FROM wp_term_taxonomy
					WHERE taxonomy = 'portfolio-cats'
					AND term_id IN (11)
				 - (0.00046014785766602 s)

 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( wp_term_relationships.term_taxonomy_id IN (11) ) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'portfolio') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 2 AND wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10 - (0.011028051376343 s)

SELECT FOUND_ROWS() - (0.00042009353637695 s)

SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('portfolio-cats', 'kia_featured') AND tr.object_id IN (341, 336) ORDER BY t.name ASC - (0.0021967887878418 s)

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (341,336) - (0.0025320053100586 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.0005040168762207 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.term_id = '4' LIMIT 1 - (0.00053310394287109 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.0003659725189209 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.00039911270141602 s)


					SELECT wp_term_taxonomy.term_id
					FROM wp_term_taxonomy
					INNER JOIN wp_terms USING (term_id)
					WHERE taxonomy = 'portfolio-cats'
					AND wp_terms.slug IN ('brands')
				 - (0.0004429817199707 s)


					SELECT term_taxonomy_id
					FROM wp_term_taxonomy
					WHERE taxonomy = 'portfolio-cats'
					AND term_id IN (11)
				 - (0.00039005279541016 s)

 SELECT   wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND wp_posts.post_parent = 0  AND ( wp_term_relationships.term_taxonomy_id IN (11) ) AND wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date ASC  - (0.0025839805603027 s)

SELECT * FROM wp_users WHERE ID = 1 LIMIT 1 - (0.00048995018005371 s)

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) - (0.00043201446533203 s)


					SELECT wp_term_taxonomy.term_id
					FROM wp_term_taxonomy
					INNER JOIN wp_terms USING (term_id)
					WHERE taxonomy = 'portfolio-cats'
					AND wp_terms.slug IN ('brands')
				 - (0.00036191940307617 s)


					SELECT term_taxonomy_id
					FROM wp_term_taxonomy
					WHERE taxonomy = 'portfolio-cats'
					AND term_id IN (11)
				 - (0.00039482116699219 s)

 SELECT   wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND wp_posts.ID NOT IN (336,341) AND ( wp_term_relationships.term_taxonomy_id IN (11) ) AND wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date ASC LIMIT 0, 1 - (0.0024511814117432 s)


					SELECT wp_term_taxonomy.term_id
					FROM wp_term_taxonomy
					INNER JOIN wp_terms USING (term_id)
					WHERE taxonomy = 'portfolio-cats'
					AND wp_terms.slug IN ('brands')
				 - (0.00050187110900879 s)


					SELECT term_taxonomy_id
					FROM wp_term_taxonomy
					WHERE taxonomy = 'portfolio-cats'
					AND term_id IN (11)
				 - (0.00050687789916992 s)

 SELECT   wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND wp_posts.ID NOT IN (336,341) AND ( wp_term_relationships.term_taxonomy_id IN (11) ) AND wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 - (0.0024840831756592 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.0010790824890137 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.00045514106750488 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.0009009838104248 s)

SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('20') ORDER BY tr.object_id ASC - (0.00072908401489258 s)

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (186,187,188,189,190) AND wp_posts.post_type = 'nav_menu_item' AND (wp_posts.post_status = 'publish')  ORDER BY menu_order ASC  - (0.00092101097106934 s)

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (186,187,188,189,190) - (0.00040912628173828 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('portfolio-cats') AND ( t.term_id = 5  OR t.term_id = 8  OR t.term_id = 10  OR t.term_id = 11  OR t.term_id = 9 ) ORDER BY t.name ASC  - (0.0030980110168457 s)

SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_firstprint' LIMIT 1 - (0.00072193145751953 s)

SELECT option_value FROM wp_options WHERE option_name = '_transient_firstprint' LIMIT 1 - (0.00073003768920898 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.00058794021606445 s)

SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('7') ORDER BY tr.object_id ASC - (0.00064992904663086 s)

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (19,20,36,87) AND wp_posts.post_type = 'nav_menu_item' AND (wp_posts.post_status = 'publish')  ORDER BY menu_order ASC  - (0.00051212310791016 s)

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (20,19,87,36) - (0.00046396255493164 s)

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (85,34) AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC  - (0.00076103210449219 s)

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (85,34) - (0.00054502487182617 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('portfolio-cats') AND ( t.term_id = 4  OR t.term_id = 3 ) ORDER BY t.name ASC  - (0.00083017349243164 s)


					SELECT wp_term_taxonomy.term_taxonomy_id
					FROM wp_term_taxonomy
					INNER JOIN wp_terms USING (term_id)
					WHERE taxonomy = 'kia_featured'
					AND wp_terms.slug IN ('excluded')
				 - (0.00089502334594727 s)


					SELECT wp_term_taxonomy.term_id
					FROM wp_term_taxonomy
					INNER JOIN wp_terms USING (term_id)
					WHERE taxonomy = 'portfolio-cats'
					AND wp_terms.slug IN ('brands')
				 - (0.00062298774719238 s)


					SELECT term_taxonomy_id
					FROM wp_term_taxonomy
					WHERE taxonomy = 'portfolio-cats'
					AND term_id IN (11)
				 - (0.00043392181396484 s)

 SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) WHERE 1=1  AND wp_posts.post_parent = 0  AND ( wp_posts.ID NOT IN (
					SELECT object_id
					FROM wp_term_relationships
					WHERE term_taxonomy_id IN (17)
				) AND tt1.term_taxonomy_id IN (11) ) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'portfolio') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 2 AND wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20 - (0.0031418800354004 s)

SELECT FOUND_ROWS() - (0.0012588500976562 s)

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_parent = 341  AND wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 1 - (0.00079107284545898 s)

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (345,337) AND wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'inherit')  ORDER BY wp_posts.post_date DESC  - (0.00065088272094727 s)

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (345,337) - (0.0005950927734375 s)

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_parent = 336  AND wp_posts.post_type = 'portfolio' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 1 - (0.00051307678222656 s)

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'portfolio-cats' AND t.slug = 'brands' LIMIT 1 - (0.00056695938110352 s)

SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments  GROUP BY comment_approved - (0.00045609474182129 s)