SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 279188 LIMIT 1 [ RunTime:0.005719s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 279188 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043272,537537,984080,291841,833100,671642,1001410,846088,7535,730688,59719,183436,1007267,703036,476846,857092,26646,809053,1028788,820710,382976,121496,77323,426777,732398,374775,830313,391831,875540,817654,902552,21399,438989,793997,864239,684056,734789,914585,979554,117861,358935,907649,922222,580314,517439,528653,194574,922156,295076,800014,287308,231046,720726,995446,557667,789836,27538,394100,1010654,535470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 279188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 279188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003471s ]