SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460893 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460893 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533677,835047,473353,859006,653321,602874,979644,915390,100902,175679,862212,610615,720720,511152,840613,667620,959487,481331,188359,971146,279363,237438,534128,925092,328180,714492,989583,156437,309794,876639,970851,574102,946843,562456,506504,258549,22858,870157,514526,856883,991255,502596,214982,982567,883396,940213,525516,93676,698867,191454,137611,488384,11032,848163,668761,870502,246811,1048593,813858,492274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]