wheat Archives - Bend Pet Express

#	SQL	Time
1	SELECT * FROM wp_say_what_strings	0.4048347ms
2	SHOW FULL COLUMNS FROM `wp_options`	1.7938613ms
3	UPDATE `wp_options` SET `option_value` = '23' WHERE `option_name` = 'auth0_db_version'	0.7660388ms
4	show tables like 'wp_fbv'	1.7161369ms
5	show tables like 'wp_fbv_attachment_folder'	1.2738704ms
6	SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 200	0.4239082ms
7	SELECT wp_redirection_items.*,wp_redirection_groups.position AS group_pos FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' AND wp_redirection_groups.module_id=1 WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/product-tag/wheat/')	0.5640983ms
8	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 ('product_tag') AND t.slug = 'wheat' LIMIT 1	0.7419586ms
9	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 ('product_tag') AND t.slug IN ('wheat')	0.3910064ms
10	SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (10082) ) AND wp_term_relationships.term_taxonomy_id IN (10571) ) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 30	0.6349086ms
11	SELECT FOUND_ROWS()	0.0891685ms
12	SELECT tr.object_id FROM wp_term_relationships AS tr LEFT JOIN wp_term_taxonomy AS tt USING( term_taxonomy_id ) WHERE tt.taxonomy = 'product_visibility' AND tr.term_taxonomy_id = 10082	0.5569458ms
13	SELECT ID FROM wp_posts AS p WHERE post_type = 'product' AND post_status = 'publish' AND p.ID NOT IN ( 116319, 116391, 116504, 116508, 116514, 117095, 117324, 118239, 118617, 118632, 119799, 119864, 120976, 120977, 120978, 120979, 120980, 120981, 130714, 130886 )	1.7938613ms
14	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2780,22018,68487,125074,127012) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC	0.6070137ms
15	SELECT * FROM wp_options WHERE option_value = "enable_role"	383.95810ms
16	SELECT * FROM wp_options WHERE option_value = "enable_role"	302.77204ms
17	SELECT * FROM wp_yith_wcwl_lists WHERE `wishlist_token` = ''	0.2930164ms
18	SELECT * FROM wp_options WHERE option_value = "enable_role"	221.01593ms
19	SELECT * FROM wp_options WHERE option_value = "enable_role"	219.61212ms
20	SELECT * FROM wp_yith_wcwl_lists WHERE `wishlist_token` = ''	0.3390312ms
21	SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_sidebar_to_replace' AND wp_postmeta.meta_value != '' ) AND ( mt1.meta_key = '_condition' AND mt1.meta_value IN ('term-10571','archive-product_tag','taxonomies','archive') ) ) AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 200	0.5700588ms
22	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 ('product_cat') ORDER BY t.name ASC	1.1301040ms
23	SELECT object_id, term_taxonomy_id FROM wp_term_relationships INNER JOIN wp_posts ON object_id = ID WHERE term_taxonomy_id IN (10559,10230,11540,11330,11748,11413,11290,12626,11477,11412,11000,11307,11165,10271,10270,10326,11188,10209,11354,11326,11386,11300,11376,11389,11513,11361,11323,10388,10210,11039,10231,10804,10676,10811,10683,11589,12749,11634,11633,12748,10233,10212,10344,10249,12750,10334,10332,10808,11043,10268,10279,10265,10331,10316,10314,11156,10211,10232,10272,10315,12773,10389,10336,12756,11237,12713,11198,11197,10290,10273,11440,11464,11366,11261,10327,10337,11264,11196,10343,10248,10090,10445,10221) AND post_type IN ('product') AND post_status = 'publish'	8.5198879ms
24	SELECT min( FLOOR( price_meta.meta_value ) ) as min_price, max( CEILING( price_meta.meta_value ) ) as max_price FROM wp_posts LEFT JOIN wp_postmeta as price_meta ON wp_posts.ID = price_meta.post_id LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE wp_posts.post_type IN ('product') AND wp_posts.post_status = 'publish' AND price_meta.meta_key IN ('_price') AND price_meta.meta_value > '' AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (10082) ) AND wp_term_relationships.term_taxonomy_id IN (10571) )	4.0109157ms
25	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2714,2715,2716,5705,125089,125090,126494,126913) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC	0.4749298ms
26	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2780,22018,68487,125074,127012) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC	0.4200935ms
27	SELECT post_name, ID, comment_count FROM wp_posts WHERE post_type = 'deprecated_log'	3.4830570ms

SQL

Time

Call Stack

SELECT * FROM wp_say_what_strings

0.4048347ms

SHOW FULL COLUMNS FROM `wp_options`

1.7938613ms

UPDATE `wp_options` SET `option_value` = '23' WHERE `option_name` = 'auth0_db_version'

0.7660388ms

show tables like 'wp_fbv'

1.7161369ms

show tables like 'wp_fbv_attachment_folder'

1.2738704ms

SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 200

0.4239082ms

SELECT wp_redirection_items.*,wp_redirection_groups.position AS group_pos FROM wp_redirection_items INNER JOIN wp_redirection_groups ON wp_redirection_groups.id=wp_redirection_items.group_id AND wp_redirection_groups.status='enabled' AND wp_redirection_groups.module_id=1 WHERE (wp_redirection_items.regex=1 OR wp_redirection_items.url='/product-tag/wheat/')

0.5640983ms

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 ('product_tag') AND t.slug = 'wheat' LIMIT 1

0.7419586ms

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 ('product_tag') AND t.slug IN ('wheat')

0.3910064ms

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (10082) ) AND wp_term_relationships.term_taxonomy_id IN (10571) ) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 30

0.6349086ms

SELECT FOUND_ROWS()

0.0891685ms

SELECT tr.object_id FROM wp_term_relationships AS tr LEFT JOIN wp_term_taxonomy AS tt USING( term_taxonomy_id ) WHERE tt.taxonomy = 'product_visibility' AND tr.term_taxonomy_id = 10082

0.5569458ms

SELECT ID FROM wp_posts AS p WHERE post_type = 'product' AND post_status = 'publish' AND p.ID NOT IN ( 116319, 116391, 116504, 116508, 116514, 117095, 117324, 118239, 118617, 118632, 119799, 119864, 120976, 120977, 120978, 120979, 120980, 120981, 130714, 130886 )

1.7938613ms

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2780,22018,68487,125074,127012) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC

0.6070137ms

SELECT * FROM wp_options WHERE option_value = "enable_role"

383.95810ms

SELECT * FROM wp_options WHERE option_value = "enable_role"

302.77204ms

SELECT * FROM wp_yith_wcwl_lists WHERE `wishlist_token` = ''

0.2930164ms

SELECT * FROM wp_options WHERE option_value = "enable_role"

221.01593ms

SELECT * FROM wp_options WHERE option_value = "enable_role"

219.61212ms

SELECT * FROM wp_yith_wcwl_lists WHERE `wishlist_token` = ''

0.3390312ms

SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_sidebar_to_replace' AND wp_postmeta.meta_value != '' ) AND ( mt1.meta_key = '_condition' AND mt1.meta_value IN ('term-10571','archive-product_tag','taxonomies','archive') ) ) AND wp_posts.post_type = 'sidebar' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 200

0.5700588ms

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 ('product_cat') ORDER BY t.name ASC

1.1301040ms

SELECT object_id, term_taxonomy_id FROM wp_term_relationships INNER JOIN wp_posts ON object_id = ID WHERE term_taxonomy_id IN (10559,10230,11540,11330,11748,11413,11290,12626,11477,11412,11000,11307,11165,10271,10270,10326,11188,10209,11354,11326,11386,11300,11376,11389,11513,11361,11323,10388,10210,11039,10231,10804,10676,10811,10683,11589,12749,11634,11633,12748,10233,10212,10344,10249,12750,10334,10332,10808,11043,10268,10279,10265,10331,10316,10314,11156,10211,10232,10272,10315,12773,10389,10336,12756,11237,12713,11198,11197,10290,10273,11440,11464,11366,11261,10327,10337,11264,11196,10343,10248,10090,10445,10221) AND post_type IN ('product') AND post_status = 'publish'

8.5198879ms

SELECT min( FLOOR( price_meta.meta_value ) ) as min_price, max( CEILING( price_meta.meta_value ) ) as max_price FROM wp_posts LEFT JOIN wp_postmeta as price_meta ON wp_posts.ID = price_meta.post_id LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE wp_posts.post_type IN ('product') AND wp_posts.post_status = 'publish' AND price_meta.meta_key IN ('_price') AND price_meta.meta_value > '' AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (10082) ) AND wp_term_relationships.term_taxonomy_id IN (10571) )

4.0109157ms

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2714,2715,2716,5705,125089,125090,126494,126913) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC

0.4749298ms

0.4200935ms

SELECT post_name, ID, comment_count FROM wp_posts WHERE post_type = 'deprecated_log'

3.4830570ms