SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904013 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904013 [ RunTime:0.001394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144073,965046,135985,949077,270487,897659,501768,1039760,35701,239091,399685,78530,427612,724970,122886,755523,172271,871801,105883,704130,770486,163298,475106,860645,320317,157498,26458,723343,941792,109143,265882,900135,1002701,901872,826417,370112,505533,27756,18685,962659,991732,449191,485423,86261,19700,21423,39743,317998,907970,1014603,227645,281108,378152,888981,839481,259732,510346,347941,1013338,634263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]