SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501864 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501864 [ RunTime:0.001399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028786,808220,636675,380749,784458,97185,17313,118118,587155,970152,422909,887391,832169,863689,1003987,432469,767635,216698,198394,95788,840096,341044,497184,712637,221274,278976,858191,79824,509991,787576,890846,853353,241282,285441,196593,492788,575070,652597,324456,685849,217565,530242,767377,953949,419155,712227,582041,719703,772856,933607,41168,985002,753191,927581,777352,838062,379122,163168,551898,133748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]