# Thread_id: 326  Schema: tecnomari_es  QC_hit: No
# Query_time: 26.465460  Lock_time: 0.000623  Rows_sent: 20  Rows_examined: 12134062
# Rows_affected: 0  Bytes_sent: 319
# Tmp_tables: 3  Tmp_disk_tables: 1  Tmp_table_sizes: 435168
# Full_scan: No  Full_join: No  Tmp_table: Yes  Tmp_table_on_disk: Yes
# Filesort: Yes  Filesort_on_disk: No  Merge_passes: 1  Priority_queue: No
#
# explain: id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
# explain: 1	PRIMARY	wp_posts	range	PRIMARY,type_status_date	type_status_date	164	NULL	8501	4724.00	6.73	99.51	Using where; Using index; Using temporary; Using filesort
# explain: 1	PRIMARY	tt1	ref	PRIMARY,term_taxonomy_id	PRIMARY	8	tecnomari_es.wp_posts.ID	5	12.74	4.18	14.72	Using where; Using index
# explain: 1	PRIMARY	tt2	ref	PRIMARY,term_taxonomy_id	PRIMARY	8	tecnomari_es.wp_posts.ID	5	9.90	4.18	29.96	Using where; Using index
# explain: 1	PRIMARY	wp_term_relationships	ref	PRIMARY,term_taxonomy_id	PRIMARY	8	tecnomari_es.wp_posts.ID	5	9.96	4.18	30.73	Using where; Using index
# explain: 1	PRIMARY	istockstatus	ref	post_id,meta_key	post_id	8	tecnomari_es.wp_posts.ID	15	73.25	0.22	1.37	Using where
# explain: 1	PRIMARY	wp_postmeta	ref	post_id,meta_key	post_id	8	tecnomari_es.wp_posts.ID	15	73.25	0.22	1.37	Using where
# explain: 2	MATERIALIZED	wp_term_relationships	ref	PRIMARY,term_taxonomy_id	term_taxonomy_id	8	const	23	23.00	100.00	100.00Using index
#
SET timestamp=1666786796;
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 )
	LEFT JOIN wp_term_relationships AS tt1 ON ( wp_posts.ID = tt1.object_id )
	LEFT JOIN wp_term_relationships AS tt2 ON ( wp_posts.ID = tt2.object_id )
	INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
	INNER JOIN wp_postmeta istockstatus ON ( wp_posts.ID = istockstatus.post_id )
WHERE
	1 = 1
	AND istockstatus.meta_key = '_stock_status'
	AND istockstatus.meta_value <> ''
	AND (
		wp_term_relationships.term_taxonomy_id IN (
			5753,
			5754,
			5815,
			5823,
			5829,
			6385,
			6386,
			6387,
			6388,
			6389,
			6390,
			6391,
			6392,
			6393,
			6394,
			6395,
			6396,
			6397,
			6398,
			6399,
			6400,
			6401,
			6402,
			6403,
			6404,
			6405,
			6406,
			6407,
			6408,
			6409,
			6410,
			6411,
			6412,
			6414,
			6415,
			6416,
			6418,
			6419,
			6421,
			6422,
			6423,
			6424,
			6425,
			6426,
			6428,
			6429,
			6432,
			6433,
			6435,
			6437,
			6448,
			6449,
			6451,
			6456,
			6458,
			6459,
			6461,
			6462,
			6463,
			6468,
			6482,
			6485,
			6486,
			6488,
			6489,
			6490,
			6491,
			6492,
			6493,
			6494,
			6495,
			6496,
			6497,
			6498,
			6508,
			6513,
			6516,
			6518,
			6519,
			6520,
			6522,
			6523,
			6524,
			6525,
			6526,
			6527,
			6528,
			6529,
			6530,
			6531,
			6592,
			6599,
			6600,
			6601,
			7239,
			7255,
			7256,
			7257,
			7258,
			7259,
			7260,
			7261,
			7262,
			7263,
			7264,
			8177,
			8179,
			8183,
			8185,
			8187,
			8188,
			8191,
			8192,
			8194,
			8195,
			8197,
			8198,
			8199,
			8200,
			8201,
			8202,
			8206,
			8211,
			8213,
			8215,
			8219,
			8224,
			8225,
			8226,
			8234,
			8238,
			8242,
			8244,
			8247,
			8248,
			8250,
			8258,
			8260,
			8267,
			8269,
			8270,
			8272,
			8274,
			8275,
			8277,
			8280,
			8282,
			8284,
			8286,
			8288,
			8292,
			8294,
			8296,
			8298,
			8300,
			8302,
			8304,
			8306,
			8308,
			8336,
			8338,
			8341,
			8344,
			8346,
			8349,
			8351,
			8353,
			8355,
			8357,
			8359,
			8361,
			8363,
			8365,
			8368,
			8369,
			8371,
			8372,
			8374,
			8377,
			8379,
			8380,
			8383,
			8386,
			8396,
			8398,
			8400,
			8401,
			8404,
			8406,
			8408,
			8413,
			8414,
			8415,
			8416,
			8417,
			8419,
			8420,
			8421,
			8423,
			8427,
			8430,
			8432,
			8434,
			8436,
			8438,
			8440,
			8441,
			8443,
			8445,
			8447,
			8449,
			8450,
			8452,
			8454,
			8455,
			8457,
			8458,
			8459,
			8461,
			8463,
			8466,
			8471,
			8472,
			8474,
			8476,
			8477,
			8479,
			8481
		)
		AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN ( 7 ) )
		AND tt1.term_taxonomy_id IN (
			5753,
			5754,
			5815,
			5823,
			5829,
			6385,
			6386,
			6387,
			6388,
			6389,
			6390,
			6391,
			6392,
			6393,
			6394,
			6395,
			6396,
			6397,
			6398,
			6399,
			6400,
			6401,
			6402,
			6403,
			6404,
			6405,
			6406,
			6407,
			6408,
			6409,
			6410,
			6411,
			6412,
			6414,
			6415,
			6416,
			6418,
			6419,
			6421,
			6422,
			6423,
			6424,
			6425,
			6426,
			6428,
			6429,
			6432,
			6433,
			6435,
			6437,
			6448,
			6449,
			6451,
			6456,
			6458,
			6459,
			6461,
			6462,
			6463,
			6468,
			6482,
			6485,
			6486,
			6488,
			6489,
			6490,
			6491,
			6492,
			6493,
			6494,
			6495,
			6496,
			6497,
			6498,
			6508,
			6513,
			6516,
			6518,
			6519,
			6520,
			6522,
			6523,
			6524,
			6525,
			6526,
			6527,
			6528,
			6529,
			6530,
			6531,
			6592,
			6599,
			6600,
			6601,
			7239,
			7255,
			7256,
			7257,
			7258,
			7259,
			7260,
			7261,
			7262,
			7263,
			7264,
			8177,
			8179,
			8183,
			8185,
			8187,
			8188,
			8191,
			8192,
			8194,
			8195,
			8197,
			8198,
			8199,
			8200,
			8201,
			8202,
			8206,
			8211,
			8213,
			8215,
			8219,
			8224,
			8225,
			8226,
			8234,
			8238,
			8242,
			8244,
			8247,
			8248,
			8250,
			8258,
			8260,
			8267,
			8269,
			8270,
			8272,
			8274,
			8275,
			8277,
			8280,
			8282,
			8284,
			8286,
			8288,
			8292,
			8294,
			8296,
			8298,
			8300,
			8302,
			8304,
			8306,
			8308,
			8336,
			8338,
			8341,
			8344,
			8346,
			8349,
			8351,
			8353,
			8355,
			8357,
			8359,
			8361,
			8363,
			8365,
			8368,
			8369,
			8371,
			8372,
			8374,
			8377,
			8379,
			8380,
			8383,
			8386,
			8396,
			8398,
			8400,
			8401,
			8404,
			8406,
			8408,
			8413,
			8414,
			8415,
			8416,
			8417,
			8419,
			8420,
			8421,
			8423,
			8427,
			8430,
			8432,
			8434,
			8436,
			8438,
			8440,
			8441,
			8443,
			8445,
			8447,
			8449,
			8450,
			8452,
			8454,
			8455,
			8457,
			8458,
			8459,
			8461,
			8463,
			8466,
			8471,
			8472,
			8474,
			8476,
			8477,
			8479,
			8481
		)
		AND tt2.term_taxonomy_id IN (
			5753,
			5754,
			5815,
			5823,
			5829,
			6385,
			6386,
			6387,
			6388,
			6389,
			6390,
			6391,
			6392,
			6393,
			6394,
			6395,
			6396,
			6397,
			6398,
			6399,
			6400,
			6401,
			6402,
			6403,
			6404,
			6405,
			6406,
			6407,
			6408,
			6409,
			6410,
			6411,
			6412,
			6414,
			6415,
			6416,
			6418,
			6419,
			6421,
			6422,
			6423,
			6424,
			6425,
			6426,
			6428,
			6429,
			6432,
			6433,
			6435,
			6437,
			6448,
			6449,
			6451,
			6456,
			6458,
			6459,
			6461,
			6462,
			6463,
			6468,
			6482,
			6485,
			6486,
			6488,
			6489,
			6490,
			6491,
			6492,
			6493,
			6494,
			6495,
			6496,
			6497,
			6498,
			6508,
			6513,
			6516,
			6518,
			6519,
			6520,
			6522,
			6523,
			6524,
			6525,
			6526,
			6527,
			6528,
			6529,
			6530,
			6531,
			6592,
			6599,
			6600,
			6601,
			7239,
			7255,
			7256,
			7257,
			7258,
			7259,
			7260,
			7261,
			7262,
			7263,
			7264,
			8177,
			8179,
			8183,
			8185,
			8187,
			8188,
			8191,
			8192,
			8194,
			8195,
			8197,
			8198,
			8199,
			8200,
			8201,
			8202,
			8206,
			8211,
			8213,
			8215,
			8219,
			8224,
			8225,
			8226,
			8234,
			8238,
			8242,
			8244,
			8247,
			8248,
			8250,
			8258,
			8260,
			8267,
			8269,
			8270,
			8272,
			8274,
			8275,
			8277,
			8280,
			8282,
			8284,
			8286,
			8288,
			8292,
			8294,
			8296,
			8298,
			8300,
			8302,
			8304,
			8306,
			8308,
			8336,
			8338,
			8341,
			8344,
			8346,
			8349,
			8351,
			8353,
			8355,
			8357,
			8359,
			8361,
			8363,
			8365,
			8368,
			8369,
			8371,
			8372,
			8374,
			8377,
			8379,
			8380,
			8383,
			8386,
			8396,
			8398,
			8400,
			8401,
			8404,
			8406,
			8408,
			8413,
			8414,
			8415,
			8416,
			8417,
			8419,
			8420,
			8421,
			8423,
			8427,
			8430,
			8432,
			8434,
			8436,
			8438,
			8440,
			8441,
			8443,
			8445,
			8447,
			8449,
			8450,
			8452,
			8454,
			8455,
			8457,
			8458,
			8459,
			8461,
			8463,
			8466,
			8471,
			8472,
			8474,
			8476,
			8477,
			8479,
			8481
		)
	)
	AND ( wp_postmeta.meta_key = '_stock_status' )
	AND ((
			wp_posts.post_type = 'product'
		AND ( wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' )))
GROUP BY
	wp_posts.ID
ORDER BY
	istockstatus.meta_value ASC,
	wp_postmeta.meta_value ASC
	LIMIT 0,
	20;