SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58323 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58323 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326592,214118,425245,976044,167442,499939,810921,281605,657989,383366,495930,256288,1030231,596240,958056,531929,555396,877087,468543,787619,700550,765635,892111,345879,442821,850526,765850,387805,407783,1037263,77368,667379,292251,449028,204583,654985,366977,447643,52444,84036,682058,237905,282432,380858,132156,809830,928723,298251,724017,644417,765111,102446,790942,540890,231687,413769,550367,647873,724711,516844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]