SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501299 LIMIT 1 [ RunTime:0.001012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501299 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812619,802292,299351,949019,640918,273662,332293,731060,340124,817459,427325,950397,434104,275232,947665,815394,612525,472810,896951,780423,66755,260824,795877,797940,747494,1009460,608134,685759,166277,104807,219991,469122,104316,668957,707111,519802,310016,677638,28356,893934,947312,694644,758103,781381,593270,280052,348365,928232,168129,47589,526760,720685,319069,780310,835591,133126,832362,172287,285413,354235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003849s ]