Pencarian tidak ditemukan
SELECT
COUNT(*) c, MIN(price_min) p_min, MAX(price_min) p_max
FROM product_bukabuku_rt WHERE
MATCH('(@brand_store_id = 3) (@concat_cat_id =293) (@detail_format =(Soft Cover)) (@detail_language =(Indonesia)) (@sc_department_code = book)')
Warning (2): mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given [APP/Controller/BrowsesController.php, line 375]Code Context// echo number_format ( $time, 3 ) . ' : Find MIN & MAX<br>';
while ($tresult = mysqli_fetch_assoc($result)) {
$action = 'index' $params = array( 'cid' => '293', 'c' => 'puisi', 'sort' => 'popular', 'format' => 'Soft Cover', 'language' => 'Indonesia', 'page' => '16', 'dept' => 'book' ) $filter = false $filter_key = null $offset = (int) 0 $system = array( 'store' => array( 'id' => '3', 'name' => 'Bukabuku.com', 'name_label' => 'Bukabuku.com', 'url' => 'www.bukabuku.com', 'email_name' => 'Bukabuku.com', 'key' => '83be148a0563b4bebcb391917485dcc2', 'logo' => 'logo.gif', 'email_order' => 'cs@bukabuku.com', 'email_order_amazon' => 'cs@emails.bukabuku.com', 'address1' => 'Ruko Cempaka Mas Blok M/50', 'address2' => 'Jln. Letjen Suprapto', 'address3' => 'Jakarta Pusat', 'zip' => '10640', 'phone1' => '0896-7269-1122', 'phone2' => '', 'show_language_picker' => 'no', 'show_department_picker' => 'no', 'maintenance_mode' => 'no', 'readonly_mode' => 'no', 'show_banners' => 'yes', 'show_top_20' => 'yes', 'social_media_login' => 'yes', 'email_partnership' => 'partnership@bukabuku.com', 'allow_cod' => 'yes', 'sphinx_host' => 'sphinx2.bukabuku.net', 'sphinx_product_index_local' => 'product_bukabuku', 'sphinx_product_index' => 'product_bukabuku_rt' ) ) $items_per_page = (int) 20 $sphinxql = object(mysqli) { affected_rows => null client_info => null client_version => null connect_errno => null connect_error => null errno => null error => null error_list => null field_count => null host_info => null info => null insert_id => null server_info => null server_version => null stat => null sqlstate => null protocol_version => null thread_id => null warning_count => null } $param = 'book' $idx = 'dept' $attributes = array( (int) 0 => array( 'Attribute' => array( 'id' => '1', 'name' => 'Format', 'key' => 'format', 'type' => 'checkbox', 'size' => '10', 'department_id' => '1' ) ), (int) 1 => array( 'Attribute' => array( 'id' => '2', 'name' => 'Language', 'key' => 'language', 'type' => 'checkbox', 'size' => '10', 'department_id' => '1' ) ), (int) 2 => array( 'Attribute' => array( 'id' => '3', 'name' => 'Author', 'key' => 'author', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 3 => array( 'Attribute' => array( 'id' => '4', 'name' => 'Editor', 'key' => 'editor', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 4 => array( 'Attribute' => array( 'id' => '5', 'name' => 'Translator', 'key' => 'translator', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 5 => array( 'Attribute' => array( 'id' => '6', 'name' => 'Reading Level', 'key' => 'reading_level', 'type' => 'checkbox', 'size' => '10', 'department_id' => '1' ) ), (int) 6 => array( 'Attribute' => array( 'id' => '7', 'name' => 'Illustrator', 'key' => 'illustrator', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 7 => array( 'Attribute' => array( 'id' => '8', 'name' => 'Color', 'key' => 'color', 'type' => 'checkbox', 'size' => '10', 'department_id' => '2' ) ), (int) 8 => array( 'Attribute' => array( 'id' => '9', 'name' => 'Size ', 'key' => 'size_clothing', 'type' => 'checkbox', 'size' => '10', 'department_id' => '2' ) ), (int) 9 => array( 'Attribute' => array( 'id' => '10', 'name' => 'Scale', 'key' => 'scale', 'type' => 'radio', 'size' => '10', 'department_id' => '4' ) ), (int) 10 => array( 'Attribute' => array( 'id' => '11', 'name' => 'Serie', 'key' => 'serie', 'type' => '', 'size' => '10', 'department_id' => '0' ) ), (int) 11 => array( 'Attribute' => array( 'id' => '12', 'name' => 'Material', 'key' => 'material', 'type' => 'radio', 'size' => '10', 'department_id' => '4' ) ) ) $cat = array( 'Category' => array( 'id' => '293', 'name' => 'Puisi', 'status' => 'active', 'parent' => '295', 'child_ids' => '293', 'parent_ids' => '1,295', 'parent_ids_space' => '1 295', 'cat_names' => ':: Buku :: Puisi & Sastra :: Puisi', 'weight' => '0' ) ) $cat_root = array( (int) 0 => '1', (int) 1 => '295' ) $dept = array( 'Department' => array( 'id' => '1', 'name' => 'Books', 'code' => 'book', 'id_header' => '201', 'product_table' => 'product_books', 'product_table_cake' => 'ProductBook', 'category_root' => '1', 'parent_product_only' => 'no' ) ) $return = array( 'dept' => 'book', 'title_for_layout' => 'Buku - Puisi & Sastra - Puisi - Bukabuku.com' ) $arr_search = array() $arr_search_and = array() $conds = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =293)', (int) 2 => '(@detail_format =(Soft Cover))', (int) 3 => '(@detail_language =(Indonesia))', (int) 4 => '(@sc_department_code = book)' ) $conds2 = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =293)', (int) 2 => '(@detail_format =(Soft Cover))', (int) 3 => '(@detail_language =(Indonesia))', (int) 4 => '(@sc_department_code = book)' ) $arr_join = array() $conds_price = array() $current_category = array( 'Category' => array( 'id' => '293', 'name' => 'Puisi', 'status' => 'active', 'parent' => '295', 'child_ids' => '293', 'parent_ids' => '1,295', 'parent_ids_space' => '1 295', 'cat_names' => ':: Buku :: Puisi & Sastra :: Puisi', 'weight' => '0' ) ) $attribute = array( 'Attribute' => array( 'id' => '12', 'name' => 'Material', 'key' => 'material', 'type' => 'radio', 'size' => '10', 'department_id' => '4' ) ) $conds_w = '' $where = array() $where_id = array() $time_start_total = (float) 1716359847.9862 $query_total = 'SELECT COUNT(*) c, MIN(price_min) p_min, MAX(price_min) p_max FROM product_bukabuku_rt WHERE MATCH('(@brand_store_id = 3) (@concat_cat_id =293) (@detail_format =(Soft Cover)) (@detail_language =(Indonesia)) (@sc_department_code = book)') ' $time_start = (float) 1716359847.9862 $result = false $time_end = (float) 1716359847.987 $time = (float) 0.00073003768920898mysqli_fetch_assoc - [internal], line ?? BrowsesController::get_data() - APP/Controller/BrowsesController.php, line 375 BrowsesController::index() - APP/Controller/BrowsesController.php, line 896 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 110
Notice (8): Undefined variable: tmax_result [APP/Controller/BrowsesController.php, line 387]Code Context$min_price = 0;
$max_price = 0;
$max_result = $tmax_result['c'];
$action = 'index' $params = array( 'cid' => '293', 'c' => 'puisi', 'sort' => 'popular', 'format' => 'Soft Cover', 'language' => 'Indonesia', 'page' => '16', 'dept' => 'book' ) $filter = false $filter_key = null $offset = (int) 0 $system = array( 'store' => array( 'id' => '3', 'name' => 'Bukabuku.com', 'name_label' => 'Bukabuku.com', 'url' => 'www.bukabuku.com', 'email_name' => 'Bukabuku.com', 'key' => '83be148a0563b4bebcb391917485dcc2', 'logo' => 'logo.gif', 'email_order' => 'cs@bukabuku.com', 'email_order_amazon' => 'cs@emails.bukabuku.com', 'address1' => 'Ruko Cempaka Mas Blok M/50', 'address2' => 'Jln. Letjen Suprapto', 'address3' => 'Jakarta Pusat', 'zip' => '10640', 'phone1' => '0896-7269-1122', 'phone2' => '', 'show_language_picker' => 'no', 'show_department_picker' => 'no', 'maintenance_mode' => 'no', 'readonly_mode' => 'no', 'show_banners' => 'yes', 'show_top_20' => 'yes', 'social_media_login' => 'yes', 'email_partnership' => 'partnership@bukabuku.com', 'allow_cod' => 'yes', 'sphinx_host' => 'sphinx2.bukabuku.net', 'sphinx_product_index_local' => 'product_bukabuku', 'sphinx_product_index' => 'product_bukabuku_rt' ) ) $items_per_page = (int) 20 $sphinxql = object(mysqli) { affected_rows => null client_info => null client_version => null connect_errno => null connect_error => null errno => null error => null error_list => null field_count => null host_info => null info => null insert_id => null server_info => null server_version => null stat => null sqlstate => null protocol_version => null thread_id => null warning_count => null } $param = 'book' $idx = 'dept' $attributes = array( (int) 0 => array( 'Attribute' => array( 'id' => '1', 'name' => 'Format', 'key' => 'format', 'type' => 'checkbox', 'size' => '10', 'department_id' => '1' ) ), (int) 1 => array( 'Attribute' => array( 'id' => '2', 'name' => 'Language', 'key' => 'language', 'type' => 'checkbox', 'size' => '10', 'department_id' => '1' ) ), (int) 2 => array( 'Attribute' => array( 'id' => '3', 'name' => 'Author', 'key' => 'author', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 3 => array( 'Attribute' => array( 'id' => '4', 'name' => 'Editor', 'key' => 'editor', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 4 => array( 'Attribute' => array( 'id' => '5', 'name' => 'Translator', 'key' => 'translator', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 5 => array( 'Attribute' => array( 'id' => '6', 'name' => 'Reading Level', 'key' => 'reading_level', 'type' => 'checkbox', 'size' => '10', 'department_id' => '1' ) ), (int) 6 => array( 'Attribute' => array( 'id' => '7', 'name' => 'Illustrator', 'key' => 'illustrator', 'type' => 'people', 'size' => '10', 'department_id' => '1' ) ), (int) 7 => array( 'Attribute' => array( 'id' => '8', 'name' => 'Color', 'key' => 'color', 'type' => 'checkbox', 'size' => '10', 'department_id' => '2' ) ), (int) 8 => array( 'Attribute' => array( 'id' => '9', 'name' => 'Size ', 'key' => 'size_clothing', 'type' => 'checkbox', 'size' => '10', 'department_id' => '2' ) ), (int) 9 => array( 'Attribute' => array( 'id' => '10', 'name' => 'Scale', 'key' => 'scale', 'type' => 'radio', 'size' => '10', 'department_id' => '4' ) ), (int) 10 => array( 'Attribute' => array( 'id' => '11', 'name' => 'Serie', 'key' => 'serie', 'type' => '', 'size' => '10', 'department_id' => '0' ) ), (int) 11 => array( 'Attribute' => array( 'id' => '12', 'name' => 'Material', 'key' => 'material', 'type' => 'radio', 'size' => '10', 'department_id' => '4' ) ) ) $cat = array( 'Category' => array( 'id' => '293', 'name' => 'Puisi', 'status' => 'active', 'parent' => '295', 'child_ids' => '293', 'parent_ids' => '1,295', 'parent_ids_space' => '1 295', 'cat_names' => ':: Buku :: Puisi & Sastra :: Puisi', 'weight' => '0' ) ) $cat_root = array( (int) 0 => '1', (int) 1 => '295' ) $dept = array( 'Department' => array( 'id' => '1', 'name' => 'Books', 'code' => 'book', 'id_header' => '201', 'product_table' => 'product_books', 'product_table_cake' => 'ProductBook', 'category_root' => '1', 'parent_product_only' => 'no' ) ) $return = array( 'dept' => 'book', 'title_for_layout' => 'Buku - Puisi & Sastra - Puisi - Bukabuku.com' ) $arr_search = array() $arr_search_and = array() $conds = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =293)', (int) 2 => '(@detail_format =(Soft Cover))', (int) 3 => '(@detail_language =(Indonesia))', (int) 4 => '(@sc_department_code = book)' ) $conds2 = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =293)', (int) 2 => '(@detail_format =(Soft Cover))', (int) 3 => '(@detail_language =(Indonesia))', (int) 4 => '(@sc_department_code = book)' ) $arr_join = array() $conds_price = array() $current_category = array( 'Category' => array( 'id' => '293', 'name' => 'Puisi', 'status' => 'active', 'parent' => '295', 'child_ids' => '293', 'parent_ids' => '1,295', 'parent_ids_space' => '1 295', 'cat_names' => ':: Buku :: Puisi & Sastra :: Puisi', 'weight' => '0' ) ) $attribute = array( 'Attribute' => array( 'id' => '12', 'name' => 'Material', 'key' => 'material', 'type' => 'radio', 'size' => '10', 'department_id' => '4' ) ) $conds_w = '' $where = array() $where_id = array() $time_start_total = (float) 1716359847.9862 $query_total = 'SELECT COUNT(*) c, MIN(price_min) p_min, MAX(price_min) p_max FROM product_bukabuku_rt WHERE MATCH('(@brand_store_id = 3) (@concat_cat_id =293) (@detail_format =(Soft Cover)) (@detail_language =(Indonesia)) (@sc_department_code = book)') ' $time_start = (float) 1716359847.9862 $result = false $time_end = (float) 1716359847.987 $time = (float) 0.00073003768920898 $tresult = null $min_price_range = (int) 0 $max_price_range = (int) 0 $min_price = (int) 0 $max_price = (int) 0BrowsesController::get_data() - APP/Controller/BrowsesController.php, line 387 BrowsesController::index() - APP/Controller/BrowsesController.php, line 896 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 110
Warning (2): Cannot modify header information - headers already sent by (output started at /home/store3/public/www3.bukabuku.com/lib/Cake/Utility/Debugger.php:795) [CORE/Cake/Network/CakeResponse.php, line 458]Code Contextsetcookie(
$name, $c['value'], $c['expire'], $c['path'],
$c['domain'], $c['secure'], $c['httpOnly']
$c = array( 'name' => 'BukaBuku[web_display]', 'value' => 'Q2FrZQ==.JvWn0Ms/Ug==', 'expire' => (int) 1716964647, 'path' => '/', 'domain' => '', 'secure' => false, 'httpOnly' => true ) $name = 'BukaBuku[web_display]'setcookie - [internal], line ?? CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458 CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 174 [main] - APP/webroot/index.php, line 110
|