SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104474 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104474 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113821,792742,704904,377262,849714,124146,165561,1014037,938910,431627,934500,135808,1015041,432270,820637,61637,741999,522183,703473,6807,984304,94161,379320,1041564,877190,780447,811086,324899,868154,124653,350919,660468,925687,94352,358504,754771,477878,522188,329326,770775,445106,204895,840821,502169,474775,507201,268818,167227,326559,265969,565128,725084,756839,853012,86681,161795,270924,587048,539526,950342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]