SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466257 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466257 [ RunTime:0.001444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542822,1046055,467331,228811,573224,923551,441210,414797,746553,580598,755403,736084,939496,131900,80014,260125,815892,91853,618467,915526,232333,1033348,155286,590107,518981,441146,839044,100682,683908,172125,561071,91430,278631,864125,517044,430279,154706,274416,109521,1023582,798332,732586,113831,974433,213334,83036,396992,155748,403339,573725,372383,503145,328796,837925,237263,168421,466951,142777,212254,783578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]