SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104767 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104767 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355505,818000,1034083,378622,45355,233050,116658,619417,295999,203281,257687,130926,844173,278630,787573,738820,967680,915716,768129,630194,23655,347488,603022,453432,261290,185294,149235,173073,418973,6257,905638,783792,416441,40509,659112,371342,137669,979347,695122,180725,659434,995009,339978,455170,574687,37180,1046442,710727,530610,565274,249045,759688,777728,848839,1561,916748,656476,537361,987271,612474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]