SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103091 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103091 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282281,941053,883300,616505,534984,839411,644043,989424,823782,1023672,914557,191859,503143,709277,524706,21353,341926,759183,535246,650817,126354,945767,213800,413954,642030,733713,901495,560173,475709,201057,1032057,625221,967378,149814,135176,505736,705715,963791,571804,133311,660054,334964,237334,681503,982506,114554,773649,552058,323337,1017331,759141,967546,757796,252414,403512,985313,966218,363500,497285,105270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]