# Time: 220309 15:31:06
# User@Host: hGjw9hSs[hGjw9hSs] @ localhost []
# Thread_id: 14  Schema: xxxmadrid_com  QC_hit: No
# Query_time: 75.992033  Lock_time: 0.000453  Rows_sent: 0  Rows_examined: 2236296
# Rows_affected: 4  Bytes_sent: 50
# Tmp_tables: 3  Tmp_disk_tables: 0  Tmp_table_sizes: 507952
# Full_scan: Yes  Full_join: Yes  Tmp_table: Yes  Tmp_table_on_disk: No
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0  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	post	ref	PRIMARY,type_status_date	type_status_date	82	const	1752	1752.00	100.00	100.00	Using where; Using index; Using temporary
# explain: 1	PRIMARY	meta__sku	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.30	1.09	Using where
# explain: 1	PRIMARY	meta__regular_price	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.42	0.10	Using where
# explain: 1	PRIMARY	meta__sale_price	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.06	0.03	Using where
# explain: 1	PRIMARY	meta__stock	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.30	1.10	Using where
# explain: 1	PRIMARY	meta__stock_status	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.56	1.10	Using where
# explain: 1	PRIMARY	meta__tax_class	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.55	1.10	Using where
# explain: 1	PRIMARY	meta__tax_status	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.58	1.10	Using where
# explain: 1	PRIMARY	meta__manage_stock	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.56	1.10	Using where
# explain: 1	PRIMARY	meta__thumbnail_id	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.55	1.03	Using where
# explain: 1	PRIMARY	variation_description	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.41	0.00	Using where
# explain: 1	PRIMARY	meta__length	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.03	0.10	Using where
# explain: 1	PRIMARY	meta__width	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.03	0.10	Using where
# explain: 1	PRIMARY	meta__height	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.03	0.10	Using where
# explain: 1	PRIMARY	meta__weight	ref	post_id,meta_key	post_id	8	xxxmadrid_com.post.ID	25	91.10	0.03	0.10	Using where
# explain: 1	PRIMARY	parent	ALL	PRIMARY	NULL	NULL	NULL	76077	74839.00	100.00	0.00	Using where; Using join buffer (flat, BNL join)
# explain: 2	MATERIALIZED	pwbe_variations	ALL	NULL	NULL	NULL	NULL	1	0.00	100.00	100.00
#
SET timestamp=1646836266;
INSERT INTO pwbe_products
                SELECT
                    DISTINCT
                    post.ID AS post_id
                FROM
                    wp_posts AS post
                JOIN
                    wp_posts AS parent ON (parent.ID = post.ID)

            LEFT JOIN
                wp_postmeta AS meta__sku ON (meta__sku.post_id = post.ID AND meta__sku.meta_key = '_sku')
            LEFT JOIN
                wp_postmeta AS meta__regular_price ON (meta__regular_price.post_id = post.ID AND meta__regular_price.meta_key = '_regular_price')
            LEFT JOIN
                wp_postmeta AS meta__sale_price ON (meta__sale_price.post_id = post.ID AND meta__sale_price.meta_key = '_sale_price')
            LEFT JOIN
                wp_postmeta AS meta__stock ON (meta__stock.post_id = post.ID AND meta__stock.meta_key = '_stock')
            LEFT JOIN
                wp_postmeta AS meta__stock_status ON (meta__stock_status.post_id = post.ID AND meta__stock_status.meta_key = '_stock_status')
            LEFT JOIN
                wp_postmeta AS meta__tax_class ON (meta__tax_class.post_id = post.ID AND meta__tax_class.meta_key = '_tax_class')
            LEFT JOIN
                wp_postmeta AS meta__tax_status ON (meta__tax_status.post_id = post.ID AND meta__tax_status.meta_key = '_tax_status')
            LEFT JOIN
                wp_postmeta AS meta__manage_stock ON (meta__manage_stock.post_id = post.ID AND meta__manage_stock.meta_key = '_manage_stock')
            LEFT JOIN
                wp_postmeta AS meta__thumbnail_id ON (meta__thumbnail_id.post_id = post.ID AND meta__thumbnail_id.meta_key = '_thumbnail_id')
            LEFT JOIN
                wp_postmeta AS variation_description ON (variation_description.post_id = post.ID AND variation_description.meta_key = '_variation_description')
            LEFT JOIN
                wp_postmeta AS meta__length ON (meta__length.post_id = post.ID AND meta__length.meta_key = '_length')
            LEFT JOIN
                wp_postmeta AS meta__width ON (meta__width.post_id = post.ID AND meta__width.meta_key = '_width')
            LEFT JOIN
                wp_postmeta AS meta__height ON (meta__height.post_id = post.ID AND meta__height.meta_key = '_height')
            LEFT JOIN
                wp_postmeta AS meta__weight ON (meta__weight.post_id = post.ID AND meta__weight.meta_key = '_weight')
            -- featured_placeholder

                WHERE
                    post.post_type = 'product'
                    AND (
                        ((parent.post_title LIKE '%mascarillas%') )
                        OR post.ID IN (SELECT parent_post_id FROM pwbe_variations)
                    );