SELECT `cj_bike_id`, `bike_name`, `cj_bike`.`bike_maker_id`, `bike_maker_name`, `bike_description`, `bike_release_year`, `bike_displacement`, `cj_bike`.`bike_displacement_type_id`, `bike_displacement_type_name` FROM `cj_bike` JOIN `bike_maker` ON (`cj_bike`.`bike_maker_id` = `bike_maker`.`bike_maker_id`) JOIN `bike_displacement_type` ON (`cj_bike`.`bike_displacement_type_id` = `bike_displacement_type`.`bike_displacement_type_id`) WHERE `cj_bike_id` = '40056'Connection name: kaitori_reader
Speed: 0.469 ms
Query analysis:
· Query: SIMPLE on cj_bike · Possible keys: PRIMARY,bike_maker_id,bike_displacement_type_id · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on bike_maker · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on bike_displacement_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/model/master.php, line 209File: APPPATH/classes/controller/catalog.php, line 76File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT COUNT(*) AS `count` FROM `request_bike` WHERE `cj_bike_id` = '40056' AND `bid_end_flg` = 1Connection name: kaitori_reader
Speed: 0.738 ms
Query analysis:
· Query: SIMPLE on request_bike · Possible keys: cj_bike_id · Key Used: cj_bike_id · Type: ref · Rows: 21 (Using where)
Call trace for this query:File: APPPATH/classes/controller/catalog.php, line 86File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT avg(max_offer_price) AS `avg_price`, min(normal_offer_price) AS `min_price`, max(max_offer_price) AS `max_price` FROM `request_bike` JOIN `offered` ON (`offered`.`request_bike_id` = `request_bike`.`request_bike_id`) WHERE `cj_bike_id` = '40056' AND `bid_end_flg` = 1Connection name: kaitori_reader
Speed: 0.806 ms
Query analysis:
· Query: SIMPLE on request_bike · Possible keys: PRIMARY,cj_bike_id · Key Used: cj_bike_id · Type: ref · Rows: 21 (Using where)
· Query: SIMPLE on offered · Possible keys: request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/classes/controller/catalog.php, line 94File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
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 `request_bike`.`cj_bike_id` = '40056' AND `cancel_flg` = 0 AND `successful_bid_flg` = 1 ORDER BY `request_bike`.`request_bike_id` DESC LIMIT 5 OFFSET 0Connection name: kaitori_reader
Speed: 3.731 ms
Query analysis:
· Query: PRIMARY on cj_bike · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort)
· Query: PRIMARY on offered · Possible keys: request_bike_id · Type: ALL · Rows: 32 (Using where)
· 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 <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: 15 (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/catalog.php, line 98File: 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.427 ms
Query analysis:
· Query: SIMPLE (No tables used)
Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 245File: APPPATH/classes/controller/catalog.php, line 98File: 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.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/catalog.php, line 102File: 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.368 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/catalog.php, line 106File: 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.433 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/catalog.php, line 102File: 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.358 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/catalog.php, line 106File: 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.377 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/catalog.php, line 102File: 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.477 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/catalog.php, line 106File: 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.398 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/catalog.php, line 102File: 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/catalog.php, line 106File: 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.450 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/catalog.php, line 102File: 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/catalog.php, line 106File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT SQL_CALC_FOUND_ROWS buyer_review.buyer_id, `prefectures_name`, `nickname`, date_format(request_bike.created_at, '%Y年%c月%e日') AS `request_date`, `bike_maker_name`, `bike_name`, `model_year`, `odometer_type_name`, `shop_name`, `normal_offer_price`, `max_offer_price`, `sell_price`, `comment`, `price_rank`, `contact_rank`, `recommend_rank` FROM `buyer_review` JOIN `buyer` ON (`buyer`.`buyer_id` = `buyer_review`.`buyer_id`) JOIN `requester` ON (`requester`.`requester_id` = `buyer_review`.`requester_id`) JOIN `prefectures` ON (`prefectures`.`prefectures_id` = `requester`.`prefectures_id`) JOIN `request_bike` ON (`request_bike`.`requester_id` = `buyer_review`.`requester_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 `offered` ON (`offered`.`request_bike_id` = `request_bike`.`request_bike_id` AND `offered`.`buyer_id` = `buyer_review`.`buyer_id`) WHERE `request_bike`.`cj_bike_id` = '40056' AND `buyer_review`.`approval` = 1 ORDER BY `buyer_review_id` DESC LIMIT 5 OFFSET 0Connection name: kaitori_reader
Speed: 1.018 ms
Query analysis:
· Query: SIMPLE on cj_bike · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on buyer_review · Possible keys: buyer_id,requester_id · Key Used: PRIMARY · Type: index · Rows: 2 (Using where)
· Query: SIMPLE on buyer · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on request_bike · Possible keys: PRIMARY,bike_maker_id,odometer_type_id,requester_id,cj_bike_id · Key Used: requester_id · Type: ref · Rows: 1 (Using where)
· Query: SIMPLE on offered · Possible keys: buyer_id,request_bike_id · Key Used: request_bike_id · Type: ref · Rows: 1 (Using where)
· Query: SIMPLE on bike_maker · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on odometer_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on requester · Possible keys: PRIMARY,prefectures_id · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on prefectures · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 287File: APPPATH/classes/controller/catalog.php, line 110File: 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.470 ms · DUPLICATE
Query analysis:
· Query: SIMPLE (No tables used)
Call trace for this query:File: APPPATH/classes/model/kaitori.php, line 290File: APPPATH/classes/controller/catalog.php, line 110File: 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` = '6' AND `approval` = 1 GROUP BY `buyer_id`Connection name: kaitori_reader
Speed: 0.416 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/catalog.php, line 113File: 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.325 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/catalog.php, line 113File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
SELECT `bike_maker_id`, `bike_maker_name` FROM `bike_maker` ORDER BY `bike_maker_id`Connection name: kaitori_reader
Speed: 0.392 ms
Query analysis:
· Query: SIMPLE on bike_maker · Key Used: PRIMARY · Type: index · Rows: 10
Call trace for this query:File: APPPATH/classes/model/master.php, line 95File: APPPATH/classes/controller/catalog.php, line 117File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 133File: DOCROOT/index.php, line 172 |
