Tenemos 2WP_Query Object
(
[query] => Array
(
[product_cat] => estuches-para-regalo
)
[query_vars] => Array
(
[product_cat] => estuches-para-regalo
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[paged] => 0
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
[0] => 149600
[1] => 149582
[2] => 142941
[3] => 132653
[4] => 132344
[5] => 132312
[6] => 132220
[7] => 132214
[8] => 132205
[9] => 132198
[10] => 132195
[11] => 132182
[12] => 132179
[13] => 132170
[14] => 132167
[15] => 132163
[16] => 132159
[17] => 132152
[18] => 132149
[19] => 132146
[20] => 132143
[21] => 132133
[22] => 132127
[23] => 132121
[24] => 132118
[25] => 132115
[26] => 132112
[27] => 132097
[28] => 132093
[29] => 132089
[30] => 132083
[31] => 132079
[32] => 132074
[33] => 132071
[34] => 132067
[35] => 132065
[36] => 132062
[37] => 132059
[38] => 132056
[39] => 132053
[40] => 132050
[41] => 132047
[42] => 132043
[43] => 132040
[44] => 132037
[45] => 131988
[46] => 131925
[47] => 131736
[48] => 131714
[49] => 131693
[50] => 131654
[51] => 131629
[52] => 131608
[53] => 131587
[54] => 131566
[55] => 131545
[56] => 131524
[57] => 131502
[58] => 131480
[59] => 131459
[60] => 131438
[61] => 131417
[62] => 131391
[63] => 129972
[64] => 129954
[65] => 129917
[66] => 129894
[67] => 129876
[68] => 129783
[69] => 129704
[70] => 129663
[71] => 129641
[72] => 129619
[73] => 129404
[74] => 129386
[75] => 129368
[76] => 129340
[77] => 129304
[78] => 127977
[79] => 127878
[80] => 127839
[81] => 127796
[82] => 127763
[83] => 127760
[84] => 127661
[85] => 127603
[86] => 127552
[87] => 127429
[88] => 127189
[89] => 126999
[90] => 126996
[91] => 126854
[92] => 126763
[93] => 124301
[94] => 124222
[95] => 124142
[96] => 120327
[97] => 120302
[98] => 120300
[99] => 120297
[100] => 120294
[101] => 120291
[102] => 120288
[103] => 120285
[104] => 120226
[105] => 120223
[106] => 120220
[107] => 120217
[108] => 120214
[109] => 120211
[110] => 120208
[111] => 120205
[112] => 120202
[113] => 120199
[114] => 120196
[115] => 120150
[116] => 120084
[117] => 119887
[118] => 119842
[119] => 119671
[120] => 119666
[121] => 119544
[122] => 119484
[123] => 119481
[124] => 116468
[125] => 116189
[126] => 116132
[127] => 116090
[128] => 115642
[129] => 114931
[130] => 114928
[131] => 114925
[132] => 114656
[133] => 114325
[134] => 114256
[135] => 114019
[136] => 113884
[137] => 105755
[138] => 105576
[139] => 105573
[140] => 105570
[141] => 105567
[142] => 105068
[143] => 105065
[144] => 105062
[145] => 105059
[146] => 104218
[147] => 98534
[148] => 82386
[149] => 82350
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[orderby] => menu_order title
[order] => ASC
[meta_query] => Array
(
)
[tax_query] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => product_visibility
[field] => term_taxonomy_id
[terms] => Array
(
[0] => 7
)
[operator] => NOT IN
)
)
[wc_query] => product_query
[posts_per_page] => 16
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[post_type] =>
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => product_cat
[term] => estuches-para-regalo
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => product_visibility
[terms] => Array
(
[0] => 7
)
[field] => term_taxonomy_id
[operator] => NOT IN
[include_children] => 1
)
[1] => Array
(
[taxonomy] => product_cat
[terms] => Array
(
[0] => estuches-para-regalo
)
[field] => slug
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => ess_term_relationships
)
[queried_terms] => Array
(
[product_cat] => Array
(
[terms] => Array
(
[0] => estuches-para-regalo
)
[field] => slug
)
)
[primary_table] => ess_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)
[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)
[clauses:protected] => Array
(
)
[has_or_relation:protected] =>
)
[date_query] =>
[queried_object] => WP_Term Object
(
[term_id] => 201
[name] => Estuches para regalo
[slug] => estuches-para-regalo
[term_group] => 0
[term_taxonomy_id] => 201
[taxonomy] => product_cat
[description] =>
[parent] => 0
[count] => 2
[filter] => raw
)
[queried_object_id] => 201
[request] =>
SELECT SQL_CALC_FOUND_ROWS ess_posts.ID
FROM ess_posts LEFT JOIN ess_term_relationships ON (ess_posts.ID = ess_term_relationships.object_id) LEFT JOIN ess_icl_translations wpml_translations
ON ess_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', ess_posts.post_type)
WHERE 1=1 AND ess_posts.ID NOT IN (149600,149582,142941,132653,132344,132312,132220,132214,132205,132198,132195,132182,132179,132170,132167,132163,132159,132152,132149,132146,132143,132133,132127,132121,132118,132115,132112,132097,132093,132089,132083,132079,132074,132071,132067,132065,132062,132059,132056,132053,132050,132047,132043,132040,132037,131988,131925,131736,131714,131693,131654,131629,131608,131587,131566,131545,131524,131502,131480,131459,131438,131417,131391,129972,129954,129917,129894,129876,129783,129704,129663,129641,129619,129404,129386,129368,129340,129304,127977,127878,127839,127796,127763,127760,127661,127603,127552,127429,127189,126999,126996,126854,126763,124301,124222,124142,120327,120302,120300,120297,120294,120291,120288,120285,120226,120223,120220,120217,120214,120211,120208,120205,120202,120199,120196,120150,120084,119887,119842,119671,119666,119544,119484,119481,116468,116189,116132,116090,115642,114931,114928,114925,114656,114325,114256,114019,113884,105755,105576,105573,105570,105567,105068,105065,105062,105059,104218,98534,82386,82350) AND (
ess_posts.ID NOT IN (
SELECT object_id
FROM ess_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
ess_term_relationships.term_taxonomy_id IN (201)
) AND ((ess_posts.post_type = 'product' AND (ess_posts.post_status = 'publish' OR ess_posts.post_status = 'acf-disabled'))) AND ( ( ( wpml_translations.language_code = 'es' OR (
wpml_translations.language_code = 'es'
AND ess_posts.post_type IN ( 'product','product_variation' )
AND ( (
( SELECT COUNT(element_id)
FROM ess_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'es'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM ess_icl_translations t2
JOIN ess_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'es'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND ess_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','wpcf7_contact_form','woo_mb_template','mc4wp-form' ) ) OR ess_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','product','product_variation','wpcf7_contact_form','woo_mb_template','mc4wp-form' ) )
GROUP BY ess_posts.ID
ORDER BY ess_posts.menu_order ASC, ess_posts.post_title ASC
LIMIT 0, 16
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 104410
[post_author] => 14
[post_date] => 2023-11-02 17:03:17
[post_date_gmt] => 2023-11-02 17:03:17
[post_content] =>
[post_title] => Estuche para regalo
[post_excerpt] => Estuches para regalo.
Medidas :26,5 x 15 x 3 cms.
Materiales: Cartón y acetato
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => estuche-para-regalo
[to_ping] =>
[pinged] =>
[post_modified] => 2026-10-07 18:13:19
[post_modified_gmt] => 2026-10-07 18:13:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://coloresdeotono.com/?post_type=product&p=104410
[menu_order] => 2383
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 51392
[post_author] => 14
[post_date] => 2021-05-28 08:49:26
[post_date_gmt] => 2021-05-28 08:49:26
[post_content] =>
[post_title] => Estuches para regalo - Pack de 2 unidades
[post_excerpt] => Pack de 2 estuches para regalo.
Medidas : 27,5 x 16 x 4 cms. y 26,5 x 15 x 3 cms.
Materiales: Cartón y acetato
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => estuches-para-regalo-pack-de-2-unidades
[to_ping] =>
[pinged] =>
[post_modified] => 2026-10-07 18:14:47
[post_modified_gmt] => 2026-10-07 18:14:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://coloresdeotono.com/?post_type=product&p=51392
[menu_order] => 2386
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 2
[current_post] => -1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 104410
[post_author] => 14
[post_date] => 2023-11-02 17:03:17
[post_date_gmt] => 2023-11-02 17:03:17
[post_content] =>
[post_title] => Estuche para regalo
[post_excerpt] => Estuches para regalo.
Medidas :26,5 x 15 x 3 cms.
Materiales: Cartón y acetato
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => estuche-para-regalo
[to_ping] =>
[pinged] =>
[post_modified] => 2026-10-07 18:13:19
[post_modified_gmt] => 2026-10-07 18:13:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://coloresdeotono.com/?post_type=product&p=104410
[menu_order] => 2383
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 2
[max_num_pages] => 1
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] => 1
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => 3a0719eb57a06d14f3e59c8d0073ae9c
[query_vars_changed:WP_Query:private] => 1
[thumbnails_cached] =>
[allow_query_attachment_by_filename:protected] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
)
productos para ti
Tenemos 2 productos para ti
