SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101212 LIMIT 1 [ RunTime:0.001400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101212 [ RunTime:0.003869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212628,906680,698269,563342,977506,566749,306070,164910,902487,35770,628951,219979,875547,946499,424804,405680,598247,378411,704378,405567,610291,554653,862890,286578,893651,235998,408126,299028,835495,157004,31213,983296,791116,973241,322111,355031,534460,142619,426695,180833,117212,499725,1048299,664091,1038812,469981,913896,155893,864619,172400,308071,676899,417629,879547,7401,481089,677166,419648,1002991,908505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]