SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484412 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484412 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18333,903139,841724,782190,572893,456947,528466,422182,264396,350091,428984,495160,843163,158249,49055,871059,848486,197368,698807,284918,367792,424414,37167,793880,43476,317329,431331,146426,56850,721743,439858,349541,561669,20256,382715,646516,601549,666946,25992,40528,852988,672632,441779,530297,439767,776603,621213,41261,427066,515390,512200,529810,590458,153320,78223,545381,818426,873787,20220,216130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002303s ]