SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476218 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476218 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451268,610887,901915,154534,846998,370070,252907,79702,291943,951248,56960,892308,766675,783609,374765,246959,448182,28830,127707,974375,67428,782217,404618,389620,645346,725296,381,610831,442036,292581,991067,535838,883558,1040630,756739,886188,74277,357009,407823,963847,925946,578577,823874,695068,59900,606582,609566,525048,799729,914608,121843,803565,483349,187299,587426,776592,517550,613837,439262,385618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001418s ]