SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473815 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473815 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603468,1007717,751637,227870,322758,55979,656003,766090,758545,372280,198084,46199,729442,174487,150695,488604,451586,101415,807318,960789,141318,51565,334218,147324,836936,477638,615246,864889,358392,689241,1001211,44850,656682,441441,426935,423989,469923,843574,1046355,677569,133747,456737,692191,424926,432314,161476,521430,410492,859924,216204,888899,632473,1045400,1027224,847679,414890,1039924,441573,627470,683425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]