Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Config`.`name`, `Config`.`value` FROM `bikerental_db`.`configs` AS `Config` WHERE 1 = 1 | 10 | 10 | 0 | |
SELECT `Area`.`id`, `Area`.`name` FROM `bikerental_db`.`areas` AS `Area` WHERE 1 = 1 | 2 | 2 | 0 | |
SELECT `Maker`.`id`, `Maker`.`name` FROM `bikerental_db`.`makers` AS `Maker` WHERE 1 = 1 | 2 | 2 | 0 | |
SELECT `Fee`.`id`, `Fee`.`name` FROM `bikerental_db`.`fees` AS `Fee` WHERE 1 = 1 | 2 | 2 | 0 | |
SELECT `Message`.`id`, `Message`.`area_id`, `Message`.`user_id`, `Message`.`administrator_id`, `Message`.`title`, `Message`.`content`, `Message`.`url`, `Message`.`deleted`, `Message`.`created`, `Message`.`modified` FROM `bikerental_db`.`messages` AS `Message` WHERE `Message`.`area_id` = 1 ORDER BY `Message`.`modified` DESC LIMIT 3 | 2 | 2 | 0 | |
SELECT `Message`.`id`, `Message`.`area_id`, `Message`.`user_id`, `Message`.`administrator_id`, `Message`.`title`, `Message`.`content`, `Message`.`url`, `Message`.`deleted`, `Message`.`created`, `Message`.`modified` FROM `bikerental_db`.`messages` AS `Message` WHERE `Message`.`area_id` = 2 ORDER BY `Message`.`modified` DESC LIMIT 3 | 1 | 1 | 0 | |
SELECT `Item`.`id`, `Item`.`name`, `Item`.`area_id`, `Item`.`maker_id`, `Item`.`cc`, `Item`.`category_id`, `Item`.`fee_id`, `Item`.`year`, `Item`.`memo`, `Item`.`complete_price`, `Item`.`capacity`, `Item`.`complete_no`, `Item`.`is_complete`, `Item`.`sold`, `Item`.`pickup`, `Item`.`rental_pickup_no`, `Item`.`rental_pickup_price`, `Item`.`complete_pickup_no`, `Item`.`complete_pickup_price`, `Item`.`not_show`, `Item`.`rental_no`, `Item`.`owner_memo`, `Item`.`deleted`, `Item`.`created`, `Item`.`modified`, `Fee`.`id`, `Fee`.`name`, `Fee`.`code`, `Fee`.`hour_8`, `Fee`.`hour_24`, `Fee`.`day`, `Fee`.`hour`, `Fee`.`created`, `Fee`.`modified` FROM `bikerental_db`.`items` AS `Item` LEFT JOIN `bikerental_db`.`fees` AS `Fee` ON (`Item`.`fee_id` = `Fee`.`id`) WHERE `Item`.`deleted` IS NULL AND `Item`.`not_show` = 0 AND `Item`.`complete_pickup_no` > 0 ORDER BY `Item`.`complete_pickup_no` DESC LIMIT 3 | 1 | 1 | 0 | |
SELECT `Itempic`.`id`, `Itempic`.`item_id`, `Itempic`.`pic_index`, `Itempic`.`filename`, `Itempic`.`original_filename`, `Itempic`.`original_filename_webp`, `Itempic`.`modified`, `Itempic`.`created` FROM `bikerental_db`.`itempics` AS `Itempic` WHERE `Itempic`.`item_id` = 18 | 0 | 0 | 0 | |
SELECT `Item`.`id`, `Item`.`name`, `Item`.`area_id`, `Item`.`maker_id`, `Item`.`cc`, `Item`.`category_id`, `Item`.`fee_id`, `Item`.`year`, `Item`.`memo`, `Item`.`complete_price`, `Item`.`capacity`, `Item`.`complete_no`, `Item`.`is_complete`, `Item`.`sold`, `Item`.`pickup`, `Item`.`rental_pickup_no`, `Item`.`rental_pickup_price`, `Item`.`complete_pickup_no`, `Item`.`complete_pickup_price`, `Item`.`not_show`, `Item`.`rental_no`, `Item`.`owner_memo`, `Item`.`deleted`, `Item`.`created`, `Item`.`modified` FROM `bikerental_db`.`items` AS `Item` WHERE `Item`.`deleted` IS NULL AND `Item`.`not_show` = 0 AND `Item`.`complete_pickup_no` > 0 ORDER BY `Item`.`rental_pickup_no` DESC LIMIT 3 | 1 | 1 | 0 | |
SELECT `Itempic`.`id`, `Itempic`.`item_id`, `Itempic`.`pic_index`, `Itempic`.`filename`, `Itempic`.`original_filename`, `Itempic`.`original_filename_webp`, `Itempic`.`modified`, `Itempic`.`created` FROM `bikerental_db`.`itempics` AS `Itempic` WHERE `Itempic`.`item_id` = 18 | 0 | 0 | 0 | |
SELECT `BikeNew`.`id`, `BikeNew`.`shop_id`, `BikeNew`.`user_id`, `BikeNew`.`administrator_id`, `BikeNew`.`title`, `BikeNew`.`content`, `BikeNew`.`deleted`, `BikeNew`.`created`, `BikeNew`.`modified` FROM `bikerental_db`.`bike_news` AS `BikeNew` WHERE 1 = 1 ORDER BY `BikeNew`.`modified` DESC LIMIT 3 | 1 | 1 | 0 | |
1 duplicate queries run.