SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549257 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549257 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505012,9059,280845,520633,600769,10438,334097,544382,320421,887448,484325,700330,1029300,544343,323980,904558,236121,412045,830424,500361,270923,347779,593094,813210,322940,27462,976109,21692,1027308,167731,370592,544171,1048016,934698,796435,1004066,636183,571762,442051,682745,366740,549207,632748,655504,198188,54325,518593,143356,10741,375817,845256,496334,209271,692798,603380,221255,1017308,64539,347427,608563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]