SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451954 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451954 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956580,802409,465225,157451,1047032,970832,286367,198324,315092,673189,813051,48163,269382,59316,515082,660870,257719,38092,450934,720309,316103,927097,384134,330136,973898,28291,1018430,339276,612967,484726,854181,146803,582507,337774,238969,293872,309153,474076,319016,420913,725872,825475,503924,369163,631527,475351,242870,256140,164556,274978,436579,195343,747660,17739,574597,949970,811040,711929,333174,470973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]