SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3817 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3817 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653052,1044203,570538,744841,453626,431399,85502,669017,540008,526348,652642,184058,957335,37104,231239,730165,848543,489334,673101,7579,809493,104545,839041,847269,856528,51415,755952,392947,350177,134303,758283,1036225,212184,702941,517498,880816,398696,572835,341972,27210,89777,989539,150205,131573,948837,163338,908070,713752,973364,97161,302517,468912,316275,283589,452234,258685,649574,845540,773038,840754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]