SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 862718 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 862718 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041007,510615,42225,119413,984372,51825,618258,665891,193060,248448,251615,1039466,526818,266279,525038,934670,602843,991088,1013618,221084,865421,892677,654741,951476,940342,323532,60135,410392,709634,112029,467359,348364,497970,75964,431842,796614,590872,577640,276302,478299,826606,819254,1006251,668488,580328,328140,1016251,429650,816129,593237,1508,77198,438883,602799,462648,695635,287319,1031167,1030221,176062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 862718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 862718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]