SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43267 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43267 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85009,886622,72617,305814,852294,1021500,672259,425911,231975,337354,201106,19864,602556,793345,879046,62672,603940,223824,171765,418070,386242,1039296,576493,87721,496642,907430,59128,401373,265757,170633,654649,149605,146522,625960,998716,970577,416373,955533,457178,8321,135612,28375,804954,174108,328950,482750,37710,536658,922942,514425,592819,628221,870907,338070,527454,451150,115853,879656,821212,580683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001163s ]