SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267670 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267670 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208106,436190,124447,924389,872328,1037995,275314,970931,749292,505812,621169,794516,872383,697620,513038,536007,351152,830474,168425,934945,576104,324578,948083,723458,1029534,721275,933460,233576,961138,553767,337597,35292,796304,925152,211717,763527,496069,56205,360448,647890,627740,849445,299159,981469,171847,988246,862056,956302,63670,600235,975585,370257,483375,378792,146773,1046802,845134,121036,581796,536693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]