SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547323 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547323 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911395,185494,631739,182067,484310,476812,684330,983456,567097,741241,662981,995734,483887,854846,276924,682947,992139,154773,731622,834843,789635,545335,319348,721961,703439,77657,17890,119038,395451,190409,353405,472551,449133,863028,586829,265668,818671,484145,951968,818527,764868,947944,678564,568727,270251,335139,609194,183853,1012248,864551,437307,765019,247932,620412,602409,93552,753932,12845,712488,98719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]