SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 360180 LIMIT 1 [ RunTime:0.001076s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 360180 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385014,1039964,413447,369617,814938,795711,222285,215599,396599,250200,563316,807169,230167,192210,768860,594287,746630,603293,154518,561515,625551,860641,933851,657817,805623,2805,723044,718978,565907,955383,736193,770928,552867,703640,697374,158592,645,765069,255945,933967,595270,262035,632282,895139,427853,367726,808696,353132,246145,755695,467165,541178,323237,929025,228894,695849,559150,787381,674503,585608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 360180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 360180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003123s ]