SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419008 LIMIT 1 [ RunTime:0.001910s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419008 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598175,974949,159141,859810,433580,765872,18486,998158,108879,1013797,233568,152755,744302,88667,807612,814608,444067,945842,148939,63986,256012,497303,234993,833572,619692,688794,305481,464177,733469,118562,677468,164933,101515,32624,103051,565171,164766,569942,1006464,799512,84885,840019,401534,943536,1027475,407971,326113,710931,809660,197191,218694,28658,166660,532293,917552,325643,541216,798336,356315,281753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]