SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342629 LIMIT 1 [ RunTime:0.000619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342629 [ RunTime:0.002142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847126,1019559,184838,219740,715052,412666,1045087,99743,372239,141784,695378,552551,48190,142062,104299,131947,222069,681134,264686,198155,900273,478493,750931,436322,245975,798731,678484,143426,183567,66063,335224,678960,524420,525442,291416,827374,962289,846737,140893,675306,873528,58663,228885,877092,131084,515752,990465,403686,344168,719487,647438,423814,1007056,229028,958182,36115,133136,58010,85669,181813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]