Filtra i prodotti
wpdb Object
(
[show_errors] =>
[suppress_errors] =>
[last_error] =>
[num_queries] => 322
[num_rows] => 6
[rows_affected] => 0
[insert_id] => 3411153
[last_query] => SELECT DISTINCT
psth_term_relationships.term_taxonomy_id
FROM
psth_term_relationships LEFT JOIN psth_termmeta ON psth_term_relationships.term_taxonomy_id = psth_termmeta.term_id
WHERE
term_taxonomy_id IN(
SELECT
term_id
FROM
psth_term_taxonomy
WHERE
taxonomy ='pa_colore'
) AND object_id IN(
SELECT DISTINCT
object_id
FROM
psth_term_relationships
WHERE
term_taxonomy_id = 16 AND object_id IN (SELECT object_id FROM psth_term_relationships WHERE term_taxonomy_id = 263 )
)
AND psth_termmeta.meta_key='order'
ORDER BY CAST( psth_termmeta.meta_value as unsigned) ASC
[last_result] => Array
(
[0] => stdClass Object
(
[term_taxonomy_id] => 163
)
[1] => stdClass Object
(
[term_taxonomy_id] => 89
)
[2] => stdClass Object
(
[term_taxonomy_id] => 81
)
[3] => stdClass Object
(
[term_taxonomy_id] => 85
)
[4] => stdClass Object
(
[term_taxonomy_id] => 80
)
[5] => stdClass Object
(
[term_taxonomy_id] => 28
)
)
[result:protected] => mysqli_result Object
(
[current_field] => 0
[field_count] => 1
[lengths] =>
[num_rows] => 6
[type] => 0
)
[col_meta:protected] => Array
(
[psth_options] => Array
(
[option_id] => stdClass Object
(
[Field] => option_id
[Type] => bigint(20) unsigned
[Collation] =>
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
[Privileges] => select,insert,update,references
[Comment] =>
)
[option_name] => stdClass Object
(
[Field] => option_name
[Type] => varchar(191)
[Collation] => utf8mb4_unicode_520_ci
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
[Privileges] => select,insert,update,references
[Comment] =>
)
[option_value] => stdClass Object
(
[Field] => option_value
[Type] => longtext
[Collation] => utf8mb4_unicode_520_ci
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
[Privileges] => select,insert,update,references
[Comment] =>
)
[autoload] => stdClass Object
(
[Field] => autoload
[Type] => varchar(20)
[Collation] => utf8mb4_unicode_520_ci
[Null] => NO
[Key] => MUL
[Default] => yes
[Extra] =>
[Privileges] => select,insert,update,references
[Comment] =>
)
)
)
[table_charset:protected] => Array
(
[psth_options] => utf8mb4
)
[check_current_query:protected] => 1
[checking_collation:wpdb:private] =>
[col_info:protected] =>
[queries] =>
[reconnect_retries:protected] => 5
[prefix] => psth_
[base_prefix] => psth_
[ready] => 1
[blogid] => 0
[siteid] => 0
[tables] => Array
(
[0] => posts
[1] => comments
[2] => links
[3] => options
[4] => postmeta
[5] => terms
[6] => term_taxonomy
[7] => term_relationships
[8] => termmeta
[9] => commentmeta
[10] => woocommerce_payment_tokenmeta
[11] => woocommerce_order_itemmeta
[12] => wc_product_meta_lookup
[13] => wc_tax_rate_classes
[14] => wc_reserved_stock
[15] => actionscheduler_actions
[16] => actionscheduler_claims
[17] => actionscheduler_groups
[18] => actionscheduler_logs
[19] => wc_category_lookup
)
[old_tables] => Array
(
[0] => categories
[1] => post2cat
[2] => link2cat
)
[global_tables] => Array
(
[0] => users
[1] => usermeta
)
[ms_global_tables] => Array
(
[0] => blogs
[1] => blogmeta
[2] => signups
[3] => site
[4] => sitemeta
[5] => sitecategories
[6] => registration_log
)
[comments] => psth_comments
[commentmeta] => psth_commentmeta
[links] => psth_links
[options] => psth_options
[postmeta] => psth_postmeta
[posts] => psth_posts
[terms] => psth_terms
[term_relationships] => psth_term_relationships
[term_taxonomy] => psth_term_taxonomy
[termmeta] => psth_termmeta
[usermeta] => psth_usermeta
[users] => psth_users
[blogs] =>
[blogmeta] =>
[registration_log] =>
[signups] =>
[site] =>
[sitecategories] =>
[sitemeta] =>
[field_types] => Array
(
[post_author] => %d
[post_parent] => %d
[menu_order] => %d
[term_id] => %d
[term_group] => %d
[term_taxonomy_id] => %d
[parent] => %d
[count] => %d
[object_id] => %d
[term_order] => %d
[ID] => %d
[comment_ID] => %d
[comment_post_ID] => %d
[comment_parent] => %d
[user_id] => %d
[link_id] => %d
[link_owner] => %d
[link_rating] => %d
[option_id] => %d
[blog_id] => %d
[meta_id] => %d
[post_id] => %d
[user_status] => %d
[umeta_id] => %d
[comment_karma] => %d
[comment_count] => %d
[active] => %d
[cat_id] => %d
[deleted] => %d
[lang_id] => %d
[mature] => %d
[public] => %d
[site_id] => %d
[spam] => %d
)
[charset] => utf8mb4
[collate] => utf8mb4_unicode_ci
[dbuser:protected] => u293459443_ws_db
[dbpassword:protected] => +c0HYAtR
[dbname:protected] => u293459443_ws_db
[dbhost:protected] => localhost
[dbh:protected] => mysqli Object
(
[affected_rows] => 6
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 1
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.5.19-MariaDB-cll-lve
[server_version] => 100519
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 492547081
[warning_count] => 0
)
[func_call] => $db->query("SELECT DISTINCT
psth_term_relationships.term_taxonomy_id
FROM
psth_term_relationships LEFT JOIN psth_termmeta ON psth_term_relationships.term_taxonomy_id = psth_termmeta.term_id
WHERE
term_taxonomy_id IN(
SELECT
term_id
FROM
psth_term_taxonomy
WHERE
taxonomy ='pa_colore'
) AND object_id IN(
SELECT DISTINCT
object_id
FROM
psth_term_relationships
WHERE
term_taxonomy_id = 16 AND object_id IN (SELECT object_id FROM psth_term_relationships WHERE term_taxonomy_id = 263 )
)
AND psth_termmeta.meta_key='order'
ORDER BY CAST( psth_termmeta.meta_value as unsigned) ASC
")
[is_mysql] => 1
[incompatible_modes:protected] => Array
(
[0] => NO_ZERO_DATE
[1] => ONLY_FULL_GROUP_BY
[2] => STRICT_TRANS_TABLES
[3] => STRICT_ALL_TABLES
[4] => TRADITIONAL
[5] => ANSI
)
[use_mysqli:wpdb:private] => 1
[has_connected:wpdb:private] => 1
[time_start] =>
[error] =>
[categories] => psth_categories
[post2cat] => psth_post2cat
[link2cat] => psth_link2cat
[payment_tokenmeta] => psth_woocommerce_payment_tokenmeta
[order_itemmeta] => psth_woocommerce_order_itemmeta
[wc_product_meta_lookup] => psth_wc_product_meta_lookup
[wc_tax_rate_classes] => psth_wc_tax_rate_classes
[wc_reserved_stock] => psth_wc_reserved_stock
[actionscheduler_actions] => psth_actionscheduler_actions
[actionscheduler_claims] => psth_actionscheduler_claims
[actionscheduler_groups] => psth_actionscheduler_groups
[actionscheduler_logs] => psth_actionscheduler_logs
[wc_category_lookup] => psth_wc_category_lookup
)
