SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543399 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543399 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373400,489704,1256,592964,79992,226071,1821,898184,416103,510215,941024,138721,66350,1029873,770364,622212,151995,348380,144131,274012,121006,437572,823071,218543,421629,935583,1022135,969919,842461,311170,206352,774875,858876,1040617,285740,45567,801461,190852,36474,815723,804536,1002186,704794,427367,471012,870770,920468,751975,253669,394251,385806,500315,663502,860508,247830,97302,625973,266570,135323,364738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001023s ]