SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283992 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283992 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145993,1002825,536434,785086,13012,396490,824166,726389,346409,296726,720938,507523,213988,415787,1045401,641982,998169,180179,108071,790188,765376,259650,351694,913756,333508,294669,301376,940930,23,721377,665555,311604,574082,682464,685309,579923,779063,126022,296106,757324,164807,593524,765889,904138,782448,520815,521092,301008,706262,523692,285361,229170,156259,544819,560485,269105,575697,276510,247154,163242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]