SELECT DISTINCT SQL_CALC_FOUND_ROWS request_bike.request_bike_id, `prefectures_name`, date_format(request_bike.created_at, '%Y年%c月%e日') AS `request_date`, `bike_maker_name`, `bike_name`, `model_year`, `odometer_type_name`, `inspection`, `inspection_year`, `inspection_month`, `inspection_day`, `condition_type_name`, `engine_condition_name`, `one_owner_flg`, `option_flg`, `normal_flg`, `etc_flg`, `drive_recorder_flg`, `grip_heater_flg`, `genuine_muffler_flg` FROM `request_bike` JOIN `requester` ON (`requester`.`requester_id` = `request_bike`.`requester_id`) JOIN `prefectures` ON (`prefectures`.`prefectures_id` = `requester`.`prefectures_id`) JOIN `bike_maker` ON (`bike_maker`.`bike_maker_id` = `request_bike`.`bike_maker_id`) JOIN `cj_bike` ON (`cj_bike`.`cj_bike_id` = `request_bike`.`cj_bike_id`) JOIN `odometer_type` ON (`odometer_type`.`odometer_type_id` = `request_bike`.`odometer_type_id`) JOIN `condition_type` ON (`condition_type`.`condition_type_id` = `request_bike`.`condition_type_id`) JOIN `offered` ON (`offered`.`request_bike_id` = `request_bike`.`request_bike_id`) LEFT JOIN (select request_bike_id, group_concat(engine_condition_name order by engine_condition_id) as engine_condition_name from request_bike_engine_condition join engine_condition using(engine_condition_id) group by request_bike_id) AS `engine_conditions` ON (`engine_conditions`.`request_bike_id` = `request_bike`.`request_bike_id`) WHERE `cancel_flg` = 0 AND `successful_bid_flg` = 1 ORDER BY `request_bike`.`request_bike_id` DESC LIMIT 50 OFFSET 0Connection name: kaitori_reader Speed: 0.546 ms Query analysis: · Query: PRIMARY on offered · Possible keys: request_bike_id · Type: ALL · Rows: 28 (Using where; Using temporary; Using filesort) · Query: PRIMARY on request_bike · Possible keys: PRIMARY,bike_maker_id,condition_type_id,odometer_type_id,requester_id,cj_bike_id · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: PRIMARY on condition_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: PRIMARY on bike_maker · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: PRIMARY on odometer_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: PRIMARY on requester · Possible keys: PRIMARY,prefectures_id · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: PRIMARY on prefectures · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: PRIMARY on cj_bike · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: PRIMARY on <derived2> · Possible keys: · Key Used: · Type: ref · Rows: 2 · Query: DERIVED on request_bike_engine_condition · Possible keys: engine_condition_id,request_bike_id · Type: ALL · Rows: 8 (Using filesort) · Query: DERIVED on engine_condition · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 242File: APPPATH/classes/controller/offered.php, line 26File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT FOUND_ROWS() AS `count`Connection name: kaitori_reader Speed: 0.446 ms Query analysis: · Query: SIMPLE (No tables used) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 245File: APPPATH/classes/controller/offered.php, line 26File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '57' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.413 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '1' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.335 ms Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '55' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.372 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '1' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.347 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '54' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.529 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '1' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.388 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '26' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.334 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '1' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.370 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '25' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.375 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 3 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '8' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.361 ms Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '24' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.477 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '5' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.333 ms Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '12' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.474 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '1' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.408 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '11' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.404 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '1' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.316 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '10' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.417 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '2' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.348 ms Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '3' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.325 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '1' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.430 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '2' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.355 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 2 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '2' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.363 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `offered`.`buyer_id`, `shop_name`, `normal_offer_price`, `max_offer_price` FROM `offered` JOIN `buyer` ON (`buyer`.`buyer_id` = `offered`.`buyer_id`) WHERE `request_bike_id` = '1' AND `successful_bid_flg` = 1 ORDER BY `normal_offer_price` DESC, `offered_id` LIMIT 1Connection name: kaitori_reader Speed: 0.366 ms Query analysis: · Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 2 (Using index condition; Using where; Using filesort) · Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 387File: APPPATH/classes/controller/offered.php, line 41File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `buyer_id`, round(avg((price_rank + contact_rank + recommend_rank) / 3)) AS `score` FROM `buyer_review` WHERE `buyer_id` = '2' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader Speed: 0.356 ms · DUPLICATE Query analysis: · Query: SIMPLE on buyer_review · Possible keys: buyer_id · Key Used: buyer_id · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 406File: APPPATH/classes/controller/offered.php, line 45File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |