SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027613 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027613 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80415,406138,509113,518678,444784,931287,80787,183695,1030287,1048233,415911,1016525,385487,1043572,361172,381715,171447,682788,1034917,228872,774677,760289,348695,193894,16172,444254,898893,281923,306447,220136,689713,850397,772934,148338,12993,437615,616609,239565,885501,987230,934367,439476,563447,389147,377449,282879,688256,27246,214937,218993,587304,453034,882257,448734,234855,560021,258494,824325,930445,942094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]