"select * from `wp_posts` where exists (select * from `wp_term_taxonomy` inner join `wp_term_relationships` on `wp_term_taxonomy`.`term_taxonomy_id` = `wp_term_relationships`.`term_taxonomy_id` where `wp_posts`.`ID` = `wp_term_relationships`.`object_id` and `taxonomy` = 'category' and exists (select * from `wp_terms` where `wp_term_taxonomy`.`term_id` = `wp_terms`.`term_id` and `slug` in ('cronaca'))) and (`post_status` = 'publish' or (`post_status` = 'future' and `post_date` <= '2025-04-16 09:14:43')) and `post_type` = 'post' and `ID` not in (1316249, 1316230, 1316202, 1316146) order by `post_date` desc" // vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:4074
Illuminate\Database\Query\Builder {#566 // app/Livewire/Home/Category.php:73 +connection: Illuminate\Database\MySqlConnection {#592 …26} +grammar: Illuminate\Database\Query\Grammars\MySqlGrammar {#591 …5} +processor: Illuminate\Database\Query\Processors\MySqlProcessor {#590} +bindings: array:9 [ "select" => [] "from" => [] "join" => [] "where" => array:10 [ 0 => "category" 1 => "cronaca" 2 => "publish" 3 => "future" 4 => "2025-04-16 09:14:43" 5 => "post" 6 => 1316249 7 => 1316230 8 => 1316202 9 => 1316146 ] "groupBy" => [] "having" => [] "order" => [] "union" => [] "unionOrder" => [] ] +aggregate: null +columns: null +distinct: false +from: "posts" +indexHint: null +joins: null +wheres: array:4 [ 0 => array:3 [ "type" => "Exists" "query" => Illuminate\Database\Query\Builder {#627 +connection: Illuminate\Database\MySqlConnection {#592 …26} +grammar: Illuminate\Database\Query\Grammars\MySqlGrammar {#591 …5} +processor: Illuminate\Database\Query\Processors\MySqlProcessor {#590} +bindings: array:9 [ "select" => [] "from" => [] "join" => [] "where" => array:2 [ 0 => "category" 1 => "cronaca" ] "groupBy" => [] "having" => [] "order" => [] "union" => [] "unionOrder" => [] ] +aggregate: null +columns: array:1 [ 0 => "*" ] +distinct: false +from: "term_taxonomy" +indexHint: null +joins: array:1 [ 0 => Illuminate\Database\Query\JoinClause {#538 +connection: Illuminate\Database\MySqlConnection {#592 …26} +grammar: Illuminate\Database\Query\Grammars\MySqlGrammar {#591 …5} +processor: Illuminate\Database\Query\Processors\MySqlProcessor {#590} +bindings: array:9 [ "select" => [] "from" => [] "join" => [] "where" => [] "groupBy" => [] "having" => [] "order" => [] "union" => [] "unionOrder" => [] ] +aggregate: null +columns: null +distinct: false +from: null +indexHint: null +joins: null +wheres: array:1 [ 0 => array:5 [ "type" => "Column" "first" => "term_taxonomy.term_taxonomy_id" "operator" => "=" "second" => "term_relationships.term_taxonomy_id" "boolean" => "and" ] ] +groups: null +havings: null +orders: null +limit: null +offset: null +unions: null +unionLimit: null +unionOffset: null +unionOrders: null +lock: null +beforeQueryCallbacks: [] +operators: array:33 [ 0 => "=" 1 => "<" 2 => ">" 3 => "<=" 4 => ">=" 5 => "<>" 6 => "!=" 7 => "<=>" 8 => "like" 9 => "like binary" 10 => "not like" 11 => "ilike" 12 => "&" 13 => "|" 14 => "^" 15 => "<<" 16 => ">>" 17 => "&~" 18 => "is" 19 => "is not" 20 => "rlike" 21 => "not rlike" 22 => "regexp" 23 => "not regexp" 24 => "~" 25 => "~*" 26 => "!~" 27 => "!~*" 28 => "similar to" 29 => "not similar to" 30 => "not ilike" 31 => "~~*" 32 => "!~~*" ] +bitwiseOperators: array:6 [ 0 => "&" 1 => "|" 2 => "^" 3 => "<<" 4 => ">>" 5 => "&~" ] +useWritePdo: false +type: "inner" +table: "term_relationships" #parentConnection: Illuminate\Database\MySqlConnection {#592 …26} #parentGrammar: Illuminate\Database\Query\Grammars\MySqlGrammar {#591 …5} #parentProcessor: Illuminate\Database\Query\Processors\MySqlProcessor {#590} #parentClass: "Illuminate\Database\Query\Builder" } ] +wheres: array:3 [ 0 => array:5 [ "type" => "Column" "first" => "posts.ID" "operator" => "=" "second" => "term_relationships.object_id" "boolean" => "and" ] 1 => array:5 [ "type" => "Basic" "column" => "taxonomy" "operator" => "=" "value" => "category" "boolean" => "and" ] 2 => array:3 [ "type" => "Exists" "query" => Illuminate\Database\Query\Builder {#536 +connection: Illuminate\Database\MySqlConnection {#592 …26} +grammar: Illuminate\Database\Query\Grammars\MySqlGrammar {#591 …5} +processor: Illuminate\Database\Query\Processors\MySqlProcessor {#590} +bindings: array:9 [ "select" => [] "from" => [] "join" => [] "where" => array:1 [ 0 => "cronaca" ] "groupBy" => [] "having" => [] "order" => [] "union" => [] "unionOrder" => [] ] +aggregate: null +columns: array:1 [ 0 => "*" ] +distinct: false +from: "terms" +indexHint: null +joins: null +wheres: array:2 [ 0 => array:5 [ "type" => "Column" "first" => "term_taxonomy.term_id" "operator" => "=" "second" => "terms.term_id" "boolean" => "and" ] 1 => array:4 [ "type" => "In" "column" => "slug" "values" => array:1 [ 0 => "cronaca" ] "boolean" => "and" ] ] +groups: null +havings: null +orders: null +limit: null +offset: null +unions: null +unionLimit: null +unionOffset: null +unionOrders: null +lock: null +beforeQueryCallbacks: [] +operators: array:33 [ 0 => "=" 1 => "<" 2 => ">" 3 => "<=" 4 => ">=" 5 => "<>" 6 => "!=" 7 => "<=>" 8 => "like" 9 => "like binary" 10 => "not like" 11 => "ilike" 12 => "&" 13 => "|" 14 => "^" 15 => "<<" 16 => ">>" 17 => "&~" 18 => "is" 19 => "is not" 20 => "rlike" 21 => "not rlike" 22 => "regexp" 23 => "not regexp" 24 => "~" 25 => "~*" 26 => "!~" 27 => "!~*" 28 => "similar to" 29 => "not similar to" 30 => "not ilike" 31 => "~~*" 32 => "!~~*" ] +bitwiseOperators: array:6 [ 0 => "&" 1 => "|" 2 => "^" 3 => "<<" 4 => ">>" 5 => "&~" ] +useWritePdo: false } "boolean" => "and" ] ] +groups: null +havings: null +orders: null +limit: null +offset: null +unions: null +unionLimit: null +unionOffset: null +unionOrders: null +lock: null +beforeQueryCallbacks: [] +operators: array:33 [ 0 => "=" 1 => "<" 2 => ">" 3 => "<=" 4 => ">=" 5 => "<>" 6 => "!=" 7 => "<=>" 8 => "like" 9 => "like binary" 10 => "not like" 11 => "ilike" 12 => "&" 13 => "|" 14 => "^" 15 => "<<" 16 => ">>" 17 => "&~" 18 => "is" 19 => "is not" 20 => "rlike" 21 => "not rlike" 22 => "regexp" 23 => "not regexp" 24 => "~" 25 => "~*" 26 => "!~" 27 => "!~*" 28 => "similar to" 29 => "not similar to" 30 => "not ilike" 31 => "~~*" 32 => "!~~*" ] +bitwiseOperators: array:6 [ 0 => "&" 1 => "|" 2 => "^" 3 => "<<" 4 => ">>" 5 => "&~" ] +useWritePdo: false } "boolean" => "and" ] 1 => array:3 [ "type" => "Nested" "query" => Illuminate\Database\Query\Builder {#618 +connection: Illuminate\Database\MySqlConnection {#592 …26} +grammar: Illuminate\Database\Query\Grammars\MySqlGrammar {#591 …5} +processor: Illuminate\Database\Query\Processors\MySqlProcessor {#590} +bindings: array:9 [ "select" => [] "from" => [] "join" => [] "where" => array:3 [ 0 => "publish" 1 => "future" 2 => "2025-04-16 09:14:43" ] "groupBy" => [] "having" => [] "order" => [] "union" => [] "unionOrder" => [] ] +aggregate: null +columns: null +distinct: false +from: "posts" +indexHint: null +joins: null +wheres: array:2 [ 0 => array:5 [ "type" => "Basic" "column" => "post_status" "operator" => "=" "value" => "publish" "boolean" => "and" ] 1 => array:3 [ "type" => "Nested" "query" => Illuminate\Database\Query\Builder {#537 +connection: Illuminate\Database\MySqlConnection {#592 …26} +grammar: Illuminate\Database\Query\Grammars\MySqlGrammar {#591 …5} +processor: Illuminate\Database\Query\Processors\MySqlProcessor {#590} +bindings: array:9 [ "select" => [] "from" => [] "join" => [] "where" => array:2 [ 0 => "future" 1 => "2025-04-16 09:14:43" ] "groupBy" => [] "having" => [] "order" => [] "union" => [] "unionOrder" => [] ] +aggregate: null +columns: null +distinct: false +from: "posts" +indexHint: null +joins: null +wheres: array:2 [ 0 => array:5 [ "type" => "Basic" "column" => "post_status" "operator" => "=" "value" => "future" "boolean" => "and" ] 1 => array:5 [ "type" => "Basic" "column" => "post_date" "operator" => "<=" "value" => "2025-04-16 09:14:43" "boolean" => "and" ] ] +groups: null +havings: null +orders: null +limit: null +offset: null +unions: null +unionLimit: null +unionOffset: null +unionOrders: null +lock: null +beforeQueryCallbacks: [] +operators: array:33 [ 0 => "=" 1 => "<" 2 => ">" 3 => "<=" 4 => ">=" 5 => "<>" 6 => "!=" 7 => "<=>" 8 => "like" 9 => "like binary" 10 => "not like" 11 => "ilike" 12 => "&" 13 => "|" 14 => "^" 15 => "<<" 16 => ">>" 17 => "&~" 18 => "is" 19 => "is not" 20 => "rlike" 21 => "not rlike" 22 => "regexp" 23 => "not regexp" 24 => "~" 25 => "~*" 26 => "!~" 27 => "!~*" 28 => "similar to" 29 => "not similar to" 30 => "not ilike" 31 => "~~*" 32 => "!~~*" ] +bitwiseOperators: array:6 [ 0 => "&" 1 => "|" 2 => "^" 3 => "<<" 4 => ">>" 5 => "&~" ] +useWritePdo: false } "boolean" => "or" ] ] +groups: null +havings: null +orders: null +limit: null +offset: null +unions: null +unionLimit: null +unionOffset: null +unionOrders: null +lock: null +beforeQueryCallbacks: [] +operators: array:33 [ 0 => "=" 1 => "<" 2 => ">" 3 => "<=" 4 => ">=" 5 => "<>" 6 => "!=" 7 => "<=>" 8 => "like" 9 => "like binary" 10 => "not like" 11 => "ilike" 12 => "&" 13 => "|" 14 => "^" 15 => "<<" 16 => ">>" 17 => "&~" 18 => "is" 19 => "is not" 20 => "rlike" 21 => "not rlike" 22 => "regexp" 23 => "not regexp" 24 => "~" 25 => "~*" 26 => "!~" 27 => "!~*" 28 => "similar to" 29 => "not similar to" 30 => "not ilike" 31 => "~~*" 32 => "!~~*" ] +bitwiseOperators: array:6 [ 0 => "&" 1 => "|" 2 => "^" 3 => "<<" 4 => ">>" 5 => "&~" ] +useWritePdo: false } "boolean" => "and" ] 2 => array:5 [ "type" => "Basic" "column" => "post_type" "operator" => "=" "value" => "post" "boolean" => "and" ] 3 => array:4 [ "type" => "NotIn" "column" => "ID" "values" => array:4 [ 0 => 1316249 1 => 1316230 2 => 1316202 3 => 1316146 ] "boolean" => "and" ] ] +groups: null +havings: null +orders: array:1 [ 0 => array:2 [ "column" => "post_date" "direction" => "desc" ] ] +limit: null +offset: null +unions: null +unionLimit: null +unionOffset: null +unionOrders: null +lock: null +beforeQueryCallbacks: [] +operators: array:33 [ 0 => "=" 1 => "<" 2 => ">" 3 => "<=" 4 => ">=" 5 => "<>" 6 => "!=" 7 => "<=>" 8 => "like" 9 => "like binary" 10 => "not like" 11 => "ilike" 12 => "&" 13 => "|" 14 => "^" 15 => "<<" 16 => ">>" 17 => "&~" 18 => "is" 19 => "is not" 20 => "rlike" 21 => "not rlike" 22 => "regexp" 23 => "not regexp" 24 => "~" 25 => "~*" 26 => "!~" 27 => "!~*" 28 => "similar to" 29 => "not similar to" 30 => "not ilike" 31 => "~~*" 32 => "!~~*" ] +bitwiseOperators: array:6 [ 0 => "&" 1 => "|" 2 => "^" 3 => "<<" 4 => ">>" 5 => "&~" ] +useWritePdo: false }