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 =1) (@detail_author =(Devar Entertainment)) (@detail_reading_level =(Remaja)) (@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' => '1', 'dept' => 'book', 'c' => '-buku-bisnis-manajemen-keuangan-buku', 'reading_level' => 'Remaja', 'author' => 'Devar Entertainment', 'page' => '1' ) $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 = '1' $idx = 'page' $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' => '1', 'name' => 'Buku', 'status' => 'active', 'parent' => '0', 'child_ids' => '1,44,176,46,48,47,424,200,129,272,185,98,49,50,51,52,172,206,251,333,205,54,256,92,253,58,203,255,244,142,376,209,59,296,60,282,61,130,295,252,143,149,190,147,144,148,155,194,412,343,64,178,179,62,259,181,63,413,66,405,262,266,267,406,65,265,420,264,263,409,67,76,74,73,71,158,269,77,78,188,213,381,81,75,82,425,426,427,439,472,463,469,471,428,468,429,462,430,460,431,432,461,433,434,435,436,466,467,437,448,459,478,438,458,473,475,476,440,441,457,442,443,444,454,477,445,446,447,464,449,450,451,452,453,456,470,465,455,474,273,173,85,86,87,88,89,90,580,174,91,196,93,95,94,96,97,584,175,493,560,102,100,276,278,99,212,101,261,187,105,104,103,55,184,279,106,108,280,162,161,169,218,223,291,226,219,292,322,415,221,414,240,225,379,220,416,241,243,242,222,224,228,227,270,275,287,286,285,284,231,274,289,288,290,111,230,229,235,237,238,233,239,234,236,342,117,159,115,177,338,180,182,119,340,339,157,419,193,145,146,170,121,123,120,124,133,207,160,208,350,418,354,277,281,126,128,195,127,131,132,293,150,204,134,422,135,138,136,348,421,382,137,387,403,401,397,393,395,398,404,385,392,384,389,400,390,383,391,386,394,399,388,396,345,140,344,346,377,139,250,107,249,352,353,198,324,189,201,349,199,141,581,151,153,152,245,154,316,299,297,305,300,302,298,301,304,347,355,307,306,358,308,310,320,309,311,317,323,360,314,313,359,315,321,312,318,319,380,368,362,367,417,369,374,191,373,366,356,371,370,327,365,351,364,423,326,479,325,361,328,363,375', 'parent_ids' => '0', 'parent_ids_space' => '0', 'cat_names' => ':: Buku', 'weight' => '0' ) ) $cat_root = array( (int) 0 => '1' ) $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 - Bukabuku.com' ) $arr_search = array() $arr_search_and = array() $conds = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =1)', (int) 2 => '(@detail_author =(Devar Entertainment))', (int) 3 => '(@detail_reading_level =(Remaja))', (int) 4 => '(@sc_department_code = book)' ) $conds2 = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =1)', (int) 2 => '(@detail_author =(Devar Entertainment))', (int) 3 => '(@detail_reading_level =(Remaja))', (int) 4 => '(@sc_department_code = book)' ) $arr_join = array() $conds_price = array() $current_category = array( 'Category' => array( 'id' => '1', 'name' => 'Buku', 'status' => 'active', 'parent' => '0', 'child_ids' => '1,44,176,46,48,47,424,200,129,272,185,98,49,50,51,52,172,206,251,333,205,54,256,92,253,58,203,255,244,142,376,209,59,296,60,282,61,130,295,252,143,149,190,147,144,148,155,194,412,343,64,178,179,62,259,181,63,413,66,405,262,266,267,406,65,265,420,264,263,409,67,76,74,73,71,158,269,77,78,188,213,381,81,75,82,425,426,427,439,472,463,469,471,428,468,429,462,430,460,431,432,461,433,434,435,436,466,467,437,448,459,478,438,458,473,475,476,440,441,457,442,443,444,454,477,445,446,447,464,449,450,451,452,453,456,470,465,455,474,273,173,85,86,87,88,89,90,580,174,91,196,93,95,94,96,97,584,175,493,560,102,100,276,278,99,212,101,261,187,105,104,103,55,184,279,106,108,280,162,161,169,218,223,291,226,219,292,322,415,221,414,240,225,379,220,416,241,243,242,222,224,228,227,270,275,287,286,285,284,231,274,289,288,290,111,230,229,235,237,238,233,239,234,236,342,117,159,115,177,338,180,182,119,340,339,157,419,193,145,146,170,121,123,120,124,133,207,160,208,350,418,354,277,281,126,128,195,127,131,132,293,150,204,134,422,135,138,136,348,421,382,137,387,403,401,397,393,395,398,404,385,392,384,389,400,390,383,391,386,394,399,388,396,345,140,344,346,377,139,250,107,249,352,353,198,324,189,201,349,199,141,581,151,153,152,245,154,316,299,297,305,300,302,298,301,304,347,355,307,306,358,308,310,320,309,311,317,323,360,314,313,359,315,321,312,318,319,380,368,362,367,417,369,374,191,373,366,356,371,370,327,365,351,364,423,326,479,325,361,328,363,375', 'parent_ids' => '0', 'parent_ids_space' => '0', 'cat_names' => ':: Buku', '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) 1716360753.7514 $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 =1) (@detail_author =(Devar Entertainment)) (@detail_reading_level =(Remaja)) (@sc_department_code = book)') ' $time_start = (float) 1716360753.7514 $result = false $time_end = (float) 1716360753.7518 $time = (float) 0.00044703483581543mysqli_fetch_assoc - [internal], line ?? BrowsesController::get_data() - APP/Controller/BrowsesController.php, line 375 BrowsesController::index() - APP/Controller/BrowsesController.php, line 897 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' => '1', 'dept' => 'book', 'c' => '-buku-bisnis-manajemen-keuangan-buku', 'reading_level' => 'Remaja', 'author' => 'Devar Entertainment', 'page' => '1' ) $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 = '1' $idx = 'page' $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' => '1', 'name' => 'Buku', 'status' => 'active', 'parent' => '0', 'child_ids' => '1,44,176,46,48,47,424,200,129,272,185,98,49,50,51,52,172,206,251,333,205,54,256,92,253,58,203,255,244,142,376,209,59,296,60,282,61,130,295,252,143,149,190,147,144,148,155,194,412,343,64,178,179,62,259,181,63,413,66,405,262,266,267,406,65,265,420,264,263,409,67,76,74,73,71,158,269,77,78,188,213,381,81,75,82,425,426,427,439,472,463,469,471,428,468,429,462,430,460,431,432,461,433,434,435,436,466,467,437,448,459,478,438,458,473,475,476,440,441,457,442,443,444,454,477,445,446,447,464,449,450,451,452,453,456,470,465,455,474,273,173,85,86,87,88,89,90,580,174,91,196,93,95,94,96,97,584,175,493,560,102,100,276,278,99,212,101,261,187,105,104,103,55,184,279,106,108,280,162,161,169,218,223,291,226,219,292,322,415,221,414,240,225,379,220,416,241,243,242,222,224,228,227,270,275,287,286,285,284,231,274,289,288,290,111,230,229,235,237,238,233,239,234,236,342,117,159,115,177,338,180,182,119,340,339,157,419,193,145,146,170,121,123,120,124,133,207,160,208,350,418,354,277,281,126,128,195,127,131,132,293,150,204,134,422,135,138,136,348,421,382,137,387,403,401,397,393,395,398,404,385,392,384,389,400,390,383,391,386,394,399,388,396,345,140,344,346,377,139,250,107,249,352,353,198,324,189,201,349,199,141,581,151,153,152,245,154,316,299,297,305,300,302,298,301,304,347,355,307,306,358,308,310,320,309,311,317,323,360,314,313,359,315,321,312,318,319,380,368,362,367,417,369,374,191,373,366,356,371,370,327,365,351,364,423,326,479,325,361,328,363,375', 'parent_ids' => '0', 'parent_ids_space' => '0', 'cat_names' => ':: Buku', 'weight' => '0' ) ) $cat_root = array( (int) 0 => '1' ) $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 - Bukabuku.com' ) $arr_search = array() $arr_search_and = array() $conds = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =1)', (int) 2 => '(@detail_author =(Devar Entertainment))', (int) 3 => '(@detail_reading_level =(Remaja))', (int) 4 => '(@sc_department_code = book)' ) $conds2 = array( (int) 0 => '(@brand_store_id = 3)', (int) 1 => '(@concat_cat_id =1)', (int) 2 => '(@detail_author =(Devar Entertainment))', (int) 3 => '(@detail_reading_level =(Remaja))', (int) 4 => '(@sc_department_code = book)' ) $arr_join = array() $conds_price = array() $current_category = array( 'Category' => array( 'id' => '1', 'name' => 'Buku', 'status' => 'active', 'parent' => '0', 'child_ids' => '1,44,176,46,48,47,424,200,129,272,185,98,49,50,51,52,172,206,251,333,205,54,256,92,253,58,203,255,244,142,376,209,59,296,60,282,61,130,295,252,143,149,190,147,144,148,155,194,412,343,64,178,179,62,259,181,63,413,66,405,262,266,267,406,65,265,420,264,263,409,67,76,74,73,71,158,269,77,78,188,213,381,81,75,82,425,426,427,439,472,463,469,471,428,468,429,462,430,460,431,432,461,433,434,435,436,466,467,437,448,459,478,438,458,473,475,476,440,441,457,442,443,444,454,477,445,446,447,464,449,450,451,452,453,456,470,465,455,474,273,173,85,86,87,88,89,90,580,174,91,196,93,95,94,96,97,584,175,493,560,102,100,276,278,99,212,101,261,187,105,104,103,55,184,279,106,108,280,162,161,169,218,223,291,226,219,292,322,415,221,414,240,225,379,220,416,241,243,242,222,224,228,227,270,275,287,286,285,284,231,274,289,288,290,111,230,229,235,237,238,233,239,234,236,342,117,159,115,177,338,180,182,119,340,339,157,419,193,145,146,170,121,123,120,124,133,207,160,208,350,418,354,277,281,126,128,195,127,131,132,293,150,204,134,422,135,138,136,348,421,382,137,387,403,401,397,393,395,398,404,385,392,384,389,400,390,383,391,386,394,399,388,396,345,140,344,346,377,139,250,107,249,352,353,198,324,189,201,349,199,141,581,151,153,152,245,154,316,299,297,305,300,302,298,301,304,347,355,307,306,358,308,310,320,309,311,317,323,360,314,313,359,315,321,312,318,319,380,368,362,367,417,369,374,191,373,366,356,371,370,327,365,351,364,423,326,479,325,361,328,363,375', 'parent_ids' => '0', 'parent_ids_space' => '0', 'cat_names' => ':: Buku', '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) 1716360753.7514 $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 =1) (@detail_author =(Devar Entertainment)) (@detail_reading_level =(Remaja)) (@sc_department_code = book)') ' $time_start = (float) 1716360753.7514 $result = false $time_end = (float) 1716360753.7518 $time = (float) 0.00044703483581543 $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 897 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) 1716965553, '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
|