SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466562 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466562 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460746,673718,1021546,795082,726453,542339,222275,804180,987069,268263,729035,121356,758132,839382,138805,216602,990718,319361,506270,555497,1020800,817033,24049,298899,1039586,449039,939465,442063,508217,959715,666085,362704,445091,209804,460889,232244,654527,906678,640164,1013313,701596,715263,926477,89434,408305,450059,536414,227553,530838,839835,1021151,592510,1008828,430024,448670,590007,763025,563521,769347,14616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]