SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028927 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028927 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888232,7572,433485,804406,134749,248258,153308,540090,68888,183442,217308,441039,768122,877463,427948,900329,932460,76333,122713,171659,761723,806117,603937,82200,184074,531217,1022577,809875,350859,967800,1014421,982661,998538,275915,787338,859564,110472,1020465,199344,287731,682422,723173,457206,129102,938632,902816,80823,798863,352267,380591,1021322,507966,95377,883698,12443,719703,520294,528327,400687,742977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]