SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019780 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019780 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566356,270089,472150,664919,185372,906967,207412,593263,701266,37815,803869,81175,429014,203649,286477,330074,349739,658587,996120,752480,22624,394494,751541,633334,611907,538736,107781,220952,351123,502903,500512,39596,824733,857566,318202,233125,760125,618094,1009863,858694,749442,422843,556875,463591,845102,261871,831968,321632,356640,734848,742032,186352,764359,931068,392695,827768,1044446,656727,162053,240293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]