SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510508 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510508 [ RunTime:0.002825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116076,331950,764403,456751,661714,349900,1010814,77121,217457,85829,953728,8607,306236,884277,209310,94825,117736,171294,113131,571331,175296,857252,445818,392957,1035417,707806,660804,236778,4720,887933,475006,693677,996815,681266,825189,211238,235983,760546,747962,754629,590308,957382,76760,271630,203995,693792,265212,482511,356260,1008964,223717,495130,591919,1032050,835873,834648,169377,252140,436770,885251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]