CodeIgniter\Database\Query Object
(
    [originalQueryString:protected] => SELECT IF(`pw`.`physical_quantity` > 0, 1, 0) AS `QTY`, `products`.`product_id`, MATCH(pb.keywords) AGAINST ('5205308*' IN BOOLEAN MODE) AS relevance_score, (
                    (CASE WHEN pb.keywords LIKE '%5205308%%%' THEN 1 ELSE 0 END)
                    ) AS full_word_match_count, CHAR_LENGTH(pb.keywords) - CHAR_LENGTH(REPLACE(pb.keywords, ' ', '')) + 1 AS `word_count`
FROM `products`
INNER JOIN `product_branch_1` as `pb` ON `products`.`product_id` = `pb`.`product_id`
INNER JOIN `product_warehouse_link` as `pw` ON `products`.`product_id` = `pw`.`product_id`
INNER JOIN `warehouse` as `w` ON `pw`.`warehouse_id` = `w`.`warehouse_id`
INNER JOIN `warehouse_carrier_link` as `wcl` ON `w`.`warehouse_id` = `wcl`.`warehouse_id`
INNER JOIN `carriers` as `cr` ON `wcl`.`carrier_id` = `cr`.`carrier_id`
WHERE MATCH(pb.keywords) AGAINST ('5205308*' IN BOOLEAN MODE)
AND `products`.`product_status` = :products.product_status:
AND wcl.carrier_id = :wcl.carrier_id:
AND IF((SELECT SUM(pwl2.physical_quantity) AS total
FROM `product_warehouse_link` `pwl2`
WHERE `products`.`product_id` = `pwl2`.`product_id`) > 0, pw.physical_quantity != 0, pw.physical_quantity = 0)
ORDER BY `QTY` DESC, `full_word_match_count` DESC, `relevance_score` DESC, `word_count` ASC, `cr`.`grade` ASC, `products`.`product_id` DESC
 LIMIT 300
    [finalQueryString:protected] => SELECT IF(`pw`.`physical_quantity` > 0, 1, 0) AS `QTY`, `products`.`product_id`, MATCH(pb.keywords) AGAINST ('5205308*' IN BOOLEAN MODE) AS relevance_score, (
                    (CASE WHEN pb.keywords LIKE '%5205308%%%' THEN 1 ELSE 0 END)
                    ) AS full_word_match_count, CHAR_LENGTH(pb.keywords) - CHAR_LENGTH(REPLACE(pb.keywords, ' ', '')) + 1 AS `word_count`
FROM `products`
INNER JOIN `product_branch_1` as `pb` ON `products`.`product_id` = `pb`.`product_id`
INNER JOIN `product_warehouse_link` as `pw` ON `products`.`product_id` = `pw`.`product_id`
INNER JOIN `warehouse` as `w` ON `pw`.`warehouse_id` = `w`.`warehouse_id`
INNER JOIN `warehouse_carrier_link` as `wcl` ON `w`.`warehouse_id` = `wcl`.`warehouse_id`
INNER JOIN `carriers` as `cr` ON `wcl`.`carrier_id` = `cr`.`carrier_id`
WHERE MATCH(pb.keywords) AGAINST ('5205308*' IN BOOLEAN MODE)
AND `products`.`product_status` = 1
AND wcl.carrier_id = (SELECT `cr2`.`carrier_id`
FROM `warehouse_carrier_link` AS `wcl2`
JOIN `carriers` AS `cr2` ON `wcl2`.`carrier_id` = `cr2`.`carrier_id`
WHERE `wcl2`.`warehouse_id` = `w`.`warehouse_id`
ORDER BY `cr2`.`grade` ASC
 LIMIT 1)
AND IF((SELECT SUM(pwl2.physical_quantity) AS total
FROM `product_warehouse_link` `pwl2`
WHERE `products`.`product_id` = `pwl2`.`product_id`) > 0, pw.physical_quantity != 0, pw.physical_quantity = 0)
ORDER BY `QTY` DESC, `full_word_match_count` DESC, `relevance_score` DESC, `word_count` ASC, `cr`.`grade` ASC, `products`.`product_id` DESC
 LIMIT 300
    [binds:protected] => Array
        (
            [products.product_status] => Array
                (
                    [0] => 1
                    [1] => 1
                )

            [wcl.carrier_id] => Array
                (
                    [0] => (SELECT `cr2`.`carrier_id`
FROM `warehouse_carrier_link` AS `wcl2`
JOIN `carriers` AS `cr2` ON `wcl2`.`carrier_id` = `cr2`.`carrier_id`
WHERE `wcl2`.`warehouse_id` = `w`.`warehouse_id`
ORDER BY `cr2`.`grade` ASC
 LIMIT 1)
                    [1] => 
                )

        )

    [bindMarker:protected] => ?
    [startTime:protected] => 1765555717.835
    [endTime:protected] => 1765555717.8942
    [errorCode:protected] => 
    [errorString:protected] => 
    [db] => CodeIgniter\Database\MySQLi\Connection Object
        (
            [DSN:protected] => 
            [port:protected] => 3306
            [hostname:protected] => localhost
            [username:protected] => centraldb_usr
            [password:protected] => 460excK%7
            [database:protected] => central_data
            [DBDriver] => MySQLi
            [subdriver:protected] => 
            [DBPrefix:protected] => 
            [pConnect:protected] => 
            [DBDebug:protected] => 1
            [charset:protected] => utf8mb4
            [DBCollat:protected] => utf8mb4_general_ci
            [swapPre:protected] => 
            [encrypt:protected] => 
            [compress:protected] => 
            [strictOn:protected] => 
            [failover:protected] => Array
                (
                )

            [lastQuery:protected] => CodeIgniter\Database\Query Object
 *RECURSION*
            [connID] => mysqli Object
                (
                    [affected_rows] => 0
                    [client_info] => mysqlnd 8.3.28
                    [client_version] => 80328
                    [connect_errno] => 0
                    [connect_error] => 
                    [errno] => 0
                    [error] => 
                    [error_list] => Array
                        (
                        )

                    [field_count] => 5
                    [host_info] => Localhost via UNIX socket
                    [info] => 
                    [insert_id] => 0
                    [server_info] => 10.11.13-MariaDB-0ubuntu0.24.04.1
                    [server_version] => 101113
                    [sqlstate] => 00000
                    [protocol_version] => 10
                    [thread_id] => 919747
                    [warning_count] => 0
                )

            [resultID] => mysqli_result Object
                (
                    [current_field] => 0
                    [field_count] => 5
                    [lengths] => 
                    [num_rows] => 0
                    [type] => 0
                )

            [protectIdentifiers] => 1
            [reservedIdentifiers:protected] => Array
                (
                    [0] => *
                )

            [escapeChar] => `
            [likeEscapeStr] =>  ESCAPE '%s' 
            [likeEscapeChar] => !
            [pregEscapeChar:protected] => Array
                (
                    [1] => `
                    [0] => `
                    [3] => `
                    [2] => `
                )

            [dataCache] => Array
                (
                    [field_names] => Array
                        (
                            [product_branch_1] => Array
                                (
                                    [0] => product_id
                                    [1] => product_name
                                    [2] => sell_price
                                    [3] => tax_percentage
                                    [4] => inc_tax_sell_price
                                    [5] => additional_shipping_cost
                                    [6] => show_price
                                    [7] => available_for_order
                                    [8] => show_condition
                                    [9] => on_sale
                                    [10] => show_delivery_time
                                    [11] => discount_on_qty
                                    [12] => short_description
                                    [13] => description
                                    [14] => meta_title
                                    [15] => meta_keywords
                                    [16] => meta_description
                                    [17] => link_rewrite
                                    [18] => keywords
                                )

                        )

                )

            [connectTime:protected] => 1765555713.7182
            [connectDuration:protected] => 0.00068998336791992
            [pretend:protected] => 
            [transEnabled] => 1
            [transStrict] => 1
            [transDepth:protected] => 0
            [transStatus:protected] => 1
            [transFailure:protected] => 
            [transException:protected] => 
            [aliasedTables:protected] => Array
                (
                )

            [queryClass:protected] => CodeIgniter\Database\Query
            [dateFormat:protected] => Array
                (
                    [date] => Y-m-d
                    [datetime] => Y-m-d H:i:s
                    [datetime-ms] => Y-m-d H:i:s.v
                    [datetime-us] => Y-m-d H:i:s.u
                    [time] => H:i:s
                )

            [deleteHack] => 1
            [mysqli] => mysqli Object
                (
                    [affected_rows] => 0
                    [client_info] => mysqlnd 8.3.28
                    [client_version] => 80328
                    [connect_errno] => 0
                    [connect_error] => 
                    [errno] => 0
                    [error] => 
                    [error_list] => Array
                        (
                        )

                    [field_count] => 5
                    [host_info] => Localhost via UNIX socket
                    [info] => 
                    [insert_id] => 0
                    [server_info] => 10.11.13-MariaDB-0ubuntu0.24.04.1
                    [server_version] => 101113
                    [sqlstate] => 00000
                    [protocol_version] => 10
                    [thread_id] => 919747
                    [warning_count] => 0
                )

            [resultMode] => 0
            [numberNative] => 
            [foundRows] => 
        )

)